CREATE OR REPLACE PACKAGE my_apex_url
IS
   /* Don't hand-construct your URLs inside APEX code. Instead call one of these
      functions to do the work for you!

      Explanations of non-self-evident parameters:

      add_href_in - if TRUE surround URL in <a> tags
      href_name_in - text used for href
      external_url_in - you want the URL to be outside of APEX? then provide the "base" domain string
      open_new_window_in - adds target="_blank" so you don't have to remember that silly syntax
      hashtag_in - when you want to go to a specific # location on page

   */

   /* No maneje-construya sus URLs dentro del código APEX. EN su lugar,llame una de estas
      funciones para que hagan el trabajo por usted!

      Explicaciones de parámetros no tan evidentes por si mismos:

      add_href_in - si TRUE encasille el URL dentro de etiquetas <a>
      href_name_in - texto usado para href (el texto mostrado por el enlace)
      external_url_in - quiere que el URL esté fuera de APEX? entonces provea la cadena de dominio "base"
      open_new_window_in - agrega target="_blank" de manera que no deba recordar esta tonta sintáxis
      hashtag_in - cuando quiere ir a localización # específica en la página (un marcador dentro de la página)

   */

   /* All arrays are assumed to be empty or densely-filled from index value 1 */
   /* Seasume que todos los arreglos están vacíos o densamente-llenos desde el valor de índice 1 */
   TYPE strings_t IS TABLE OF VARCHAR2 (32767);

   FUNCTION for_this (app_id_in             IN VARCHAR2,
                      app_pg_id_in          IN VARCHAR2,
                      app_session_in        IN VARCHAR2,
                      request_in            IN VARCHAR2,
                      debug_in              IN VARCHAR2 DEFAULT 'NO',
                      cache_in              IN VARCHAR2,
                      page_items_in         IN strings_t,
                      values_in             IN strings_t,
                      printer_friendly_in   IN VARCHAR2 DEFAULT NULL,
                      add_href_in           IN BOOLEAN DEFAULT FALSE,
                      href_name_in          IN VARCHAR2 DEFAULT NULL,
                      external_url_in       IN VARCHAR2 DEFAULT NULL,
                      open_new_window_in    IN BOOLEAN DEFAULT TRUE,
                      onclick_in            IN VARCHAR2 DEFAULT NULL,
                      image_in              IN VARCHAR2 DEFAULT NULL,
                      add_ssp_in            IN BOOLEAN DEFAULT TRUE,
                      hashtag_in            IN VARCHAR2 DEFAULT NULL)
      RETURN VARCHAR2;

   /* Single parameter overloading */
   /* Un simple parámetro */
   FUNCTION for_this (app_id_in             IN VARCHAR2,
                      app_pg_id_in          IN VARCHAR2,
                      app_session_in        IN VARCHAR2,
                      request_in            IN VARCHAR2,
                      debug_in              IN VARCHAR2 DEFAULT 'NO',
                      cache_in              IN VARCHAR2,
                      page_item_in          IN VARCHAR2 DEFAULT NULL,
                      value_in              IN VARCHAR2 DEFAULT NULL,
                      printer_friendly_in   IN VARCHAR2 DEFAULT NULL,
                      add_href_in           IN BOOLEAN DEFAULT FALSE,
                      href_name_in          IN VARCHAR2 DEFAULT NULL,
                      external_url_in       IN VARCHAR2 DEFAULT NULL,
                      open_new_window_in    IN BOOLEAN DEFAULT TRUE,
                      onclick_in            IN VARCHAR2 DEFAULT NULL,
                      image_in              IN VARCHAR2 DEFAULT NULL,
                      add_ssp_in            IN BOOLEAN DEFAULT TRUE,
                      hashtag_in            IN VARCHAR2 DEFAULT NULL)
      RETURN VARCHAR2;

   /* Single parameter overloading for use in SQL: 1 = TRUE, 0 (or anything else!) FALSE. */
   /* Un simple parámetro para usar en SQL: 1 = TRUE, 0 (o cualquier otra cosa!) FALSE. */
   FUNCTION for_this (app_id_in             IN VARCHAR2,
                      app_pg_id_in          IN VARCHAR2,
                      app_session_in        IN VARCHAR2,
                      request_in            IN VARCHAR2,
                      debug_in              IN VARCHAR2 DEFAULT 'NO',
                      cache_in              IN VARCHAR2,
                      page_item_in          IN VARCHAR2 DEFAULT NULL,
                      value_in              IN VARCHAR2 DEFAULT NULL,
                      printer_friendly_in   IN VARCHAR2 DEFAULT NULL,
                      add_href_in           IN INTEGER DEFAULT 0,
                      href_name_in          IN VARCHAR2 DEFAULT NULL,
                      external_url_in       IN VARCHAR2 DEFAULT NULL,
                      open_new_window_in    IN INTEGER DEFAULT 1,
                      onclick_in            IN VARCHAR2 DEFAULT NULL,
                      image_in              IN VARCHAR2 DEFAULT NULL,
                      add_ssp_in            IN INTEGER DEFAULT 1,
                      hashtag_in            IN VARCHAR2 DEFAULT NULL)
      RETURN VARCHAR2;
END;