DECLARE
   l_items    my_apex_url.strings_t
      := my_apex_url.strings_t ('P659_QUIZ_ID',
                                'P659_COMP_EVENT_ID',
                                'P659_QUESTION_ID');
   l_values   my_apex_url.strings_t
                 := my_apex_url.strings_t (1392416, 871639, NULL);
   l_url      VARCHAR2 (32767);
BEGIN
   /* Single item call */
   DBMS_OUTPUT.put_line (my_apex_url.for_this (
                            app_id_in             => 10000,
                            app_pg_id_in          => 650,
                            app_session_in        => NULL,
                            request_in            => 'SHOW',
                            debug_in              => 'NO',
                            cache_in              => 650,
                            page_item_in         => NULL,
                            value_in             => NULL,
                            printer_friendly_in   => 'No',
                            add_href_in           => TRUE,
                            href_name_in          => 'Library',
                            external_url_in       => 'https://plsqlchallenge.oracle.com/pls/apex/',
                            open_new_window_in    => TRUE,
                            onclick_in            => NULL,
                            image_in              => NULL,
                            add_ssp_in            => TRUE,
                            hashtag_in            => NULL));

   /* En SQL */
   SELECT my_apex_url.for_this (
             app_id_in             => 10000,
             app_pg_id_in          => 650,
             app_session_in        => NULL,
             request_in            => 'SHOW',
             debug_in              => 'NO',
             cache_in              => 650,
             page_item_in         => NULL,
             value_in             => NULL,
             printer_friendly_in   => 'No',
             add_href_in           => 1,
             href_name_in          => 'Library',
             external_url_in       => 'https://plsqlchallenge.oracle.com/pls/apex/',
             open_new_window_in    => 1,
             onclick_in            => NULL,
             image_in              => NULL,
             add_ssp_in            => 1,
             hashtag_in            => NULL)
     INTO l_url
     FROM DUAL;

   DBMS_OUTPUT.put_line (l_url);

   /* Multiple items */
   DBMS_OUTPUT.put_line (my_apex_url.for_this (
                            app_id_in             => 10000,
                            app_pg_id_in          => 659,
                            app_session_in        => NULL,
                            request_in            => 'CLEAR_HA',
                            debug_in              => 'NO',
                            cache_in              => 659,
                            page_items_in         => l_items,
                            values_in             => l_values,
                            printer_friendly_in   => 'Yes',
                            add_href_in           => TRUE,
                            href_name_in          => 'Quick Quiz: 2 January - 8 January 2016',
                            external_url_in       => 'https://plsqlchallenge.oracle.com/pls/apex/',
                            open_new_window_in    => TRUE,
                            onclick_in            => NULL,
                            image_in              => NULL,
                            add_ssp_in            => TRUE,
                            hashtag_in            => NULL));
END;