prompt --application/set_environment
set define off verify off feedback off
whenever sqlerror exit sql.sqlcode rollback
--------------------------------------------------------------------------------
--
-- ORACLE Application Express (APEX) export file
--
-- You should run the script connected to SQL*Plus as the Oracle user
-- APEX_190200 or as the owner (parsing schema) of the application.
--
-- NOTE: Calls to apex_application_install override the defaults below.
--
--------------------------------------------------------------------------------
begin
wwv_flow_api.import_begin (
 p_version_yyyy_mm_dd=>'2019.10.04'
,p_release=>'19.2.0.00.18'
,p_default_workspace_id=>37181779490747874089
,p_default_application_id=>93690
,p_default_id_offset=>0
,p_default_owner=>'ASHISH_ME'
);
end;
/
 
prompt APPLICATION 93690 - Ashish Sahay Plugins
--
-- Application Export:
--   Application:     93690
--   Name:            Ashish Sahay Plugins
--   Date and Time:   16:10 Tuesday February 18, 2020
--   Exported By:     ASHISH
--   Flashback:       0
--   Export Type:     Component Export
--   Manifest
--     PLUGIN: 26565773067280366791
--   Manifest End
--   Version:         19.2.0.00.18
--   Instance ID:     63113759365424
--

begin
  -- replace components
  wwv_flow_api.g_mode := 'REPLACE';
end;
/
prompt --application/shared_components/plugins/region_type/social_footer
begin
wwv_flow_api.create_plugin(
 p_id=>wwv_flow_api.id(26565773067280366791)
,p_plugin_type=>'REGION TYPE'
,p_name=>'SOCIAL_FOOTER'
,p_display_name=>'Social Footer'
,p_supported_ui_types=>'DESKTOP'
,p_javascript_file_urls=>'#PLUGIN_FILES#script_test.js'
,p_plsql_code=>wwv_flow_string.join(wwv_flow_t_varchar2(
'FUNCTION SQL_TO_SYS_REFCURSOR (',
'    P_IN_SQL_STATEMENT   CLOB,',
'    P_IN_BINDS           SYS.DBMS_SQL.VARCHAR2_TABLE',
') RETURN SYS_REFCURSOR AS',
'    VR_CURS         BINARY_INTEGER;',
'    VR_REF_CURSOR   SYS_REFCURSOR;',
'    VR_EXEC         BINARY_INTEGER;',
'/* TODO make size dynamic */',
'    VR_BINDS        VARCHAR(100);',
'BEGIN',
'    VR_CURS         := DBMS_SQL.OPEN_CURSOR;',
'    DBMS_SQL.PARSE(',
'        VR_CURS,',
'        P_IN_SQL_STATEMENT,',
'        DBMS_SQL.NATIVE',
'    );',
'    IF P_IN_BINDS.COUNT > 0 THEN',
'        FOR I IN 1..P_IN_BINDS.COUNT LOOP',
'        /* TODO find out how to prevent ltrim */',
'            VR_BINDS   := LTRIM(',
'                P_IN_BINDS(I),',
'                '':''',
'            );',
'            DBMS_SQL.BIND_VARIABLE(',
'                VR_CURS,',
'                VR_BINDS,',
'                V(VR_BINDS)',
'            );',
'        END LOOP;',
'    END IF;',
'',
'    VR_EXEC         := DBMS_SQL.EXECUTE(VR_CURS);',
'    VR_REF_CURSOR   := DBMS_SQL.TO_REFCURSOR(VR_CURS);',
'    RETURN VR_REF_CURSOR;',
'EXCEPTION',
'    WHEN OTHERS THEN',
'        IF DBMS_SQL.IS_OPEN(VR_CURS) THEN',
'            DBMS_SQL.CLOSE_CURSOR(VR_CURS);',
'        END IF;',
'        RAISE;',
'END;',
'',
'FUNCTION F_AJAX (',
'    P_REGION   IN         APEX_PLUGIN.T_REGION,',
'    P_PLUGIN   IN         APEX_PLUGIN.T_PLUGIN',
') RETURN APEX_PLUGIN.T_REGION_AJAX_RESULT IS',
'    VR_RESULT       APEX_PLUGIN.T_REGION_AJAX_RESULT;',
'    VR_CUR          SYS_REFCURSOR;',
'    VR_BIND_NAMES   SYS.DBMS_SQL.VARCHAR2_TABLE;',
'BEGIN',
'/* undocumented function of APEX for get all bindings */',
'    VR_BIND_NAMES   := WWV_FLOW_UTILITIES.GET_BINDS(P_REGION.SOURCE);',
'',
'/* execute binding*/',
'    VR_CUR          := SQL_TO_SYS_REFCURSOR(',
'        RTRIM(',
'            P_REGION.SOURCE,',
'            '';''',
'        ),',
'        VR_BIND_NAMES',
'    );',
'',
'/* create json */',
'    APEX_JSON.OPEN_OBJECT;',
'    APEX_JSON.WRITE(',
'        ''row'',',
'        VR_CUR',
'    );',
'    APEX_JSON.CLOSE_OBJECT;',
'',
'    RETURN VR_RESULT;',
'END;',
'',
'FUNCTION F_RENDER (',
'    P_REGION                IN                      APEX_PLUGIN.T_REGION,',
'    P_PLUGIN                IN                      APEX_PLUGIN.T_PLUGIN,',
'    P_IS_PRINTER_FRIENDLY   IN                      BOOLEAN',
') RETURN APEX_PLUGIN.T_REGION_RENDER_RESULT IS',
'',
'    VR_RESULT         APEX_PLUGIN.T_REGION_RENDER_RESULT;',
'    VR_ITEMS2SUBMIT   APEX_APPLICATION_PAGE_REGIONS.AJAX_ITEMS_TO_SUBMIT%TYPE := APEX_PLUGIN_UTIL.PAGE_ITEM_NAMES_TO_JQUERY(P_REGION.AJAX_ITEMS_TO_SUBMIT);',
'BEGIN',
'    APEX_CSS.ADD_FILE(',
'        P_NAME        => ''css'',',
'        P_DIRECTORY   => P_PLUGIN.FILE_PREFIX,',
'        P_VERSION     => NULL,',
'        P_KEY         => ''testasffssshishsahay''',
'    );',
'    ',
'    APEX_JAVASCRIPT.ADD_LIBRARY(',
'        P_NAME        => ''js'',',
'        P_DIRECTORY   => P_PLUGIN.FILE_PREFIX,',
'        P_VERSION     => NULL,',
'        P_KEY         => ''testadashishsahayasasasas''',
'    );',
'',
'    HTP.P(''<div id="'' || APEX_ESCAPE.HTML_ATTRIBUTE( P_REGION.STATIC_ID ) || ''-p" class="social-footer"></div>'');',
'',
'    APEX_JAVASCRIPT.ADD_ONLOAD_CODE( ''footer.render(''',
'     || APEX_JAVASCRIPT.ADD_VALUE( P_REGION.STATIC_ID, TRUE )    ',
'     || APEX_JAVASCRIPT.ADD_VALUE( APEX_PLUGIN.GET_AJAX_IDENTIFIER, TRUE )',
'     || APEX_JAVASCRIPT.ADD_VALUE( P_REGION.NO_DATA_FOUND_MESSAGE, TRUE )',
'     || APEX_JAVASCRIPT.ADD_VALUE( VR_ITEMS2SUBMIT, TRUE )',
'     || APEX_JAVASCRIPT.ADD_VALUE( P_REGION.ESCAPE_OUTPUT, TRUE )',
'     || APEX_JAVASCRIPT.ADD_VALUE( P_REGION.ATTRIBUTE_01, FALSE )',
'     || '');'' );',
'',
'    RETURN VR_RESULT;',
'END;'))
,p_api_version=>2
,p_render_function=>'F_RENDER'
,p_ajax_function=>'F_AJAX'
,p_standard_attributes=>'SOURCE_SQL:AJAX_ITEMS_TO_SUBMIT:NO_DATA_FOUND_MESSAGE:ESCAPE_OUTPUT'
,p_substitute_attributes=>true
,p_reference_id=>26140779711610252367
,p_subscribe_plugin_settings=>true
,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
'#LINK_TEXT#<br>',
'#LINK_URL#<br>',
'#ICON#<br>'))
,p_version_identifier=>'1.0'
,p_about_url=>'https://apex.oracle.com/pls/apex/f?p=93690:8:14996197284059:::::'
,p_files_version=>306
);
wwv_flow_api.create_plugin_attribute(
 p_id=>wwv_flow_api.id(26566244569202865178)
,p_plugin_id=>wwv_flow_api.id(26565773067280366791)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>1
,p_display_sequence=>10
,p_prompt=>'ConfiguraionJSON'
,p_attribute_type=>'TEXT'
,p_is_required=>false
,p_default_value=>'{ "refresh": 0 ,"backgroundColor":"lightsalmon"}'
,p_is_translatable=>false
,p_examples=>wwv_flow_string.join(wwv_flow_t_varchar2(
'<ul> <li>fa-times fa-2x</li>',
'     <li>fa-long-arrow-down</li>',
'</ul>'))
,p_attribute_comment=>wwv_flow_string.join(wwv_flow_t_varchar2(
'@Auther',
'Ashish Sahay',
'Version 1.0.1',
'2020 Feb 18'))
);
wwv_flow_api.create_plugin_std_attribute(
 p_id=>wwv_flow_api.id(26566245531167865184)
,p_plugin_id=>wwv_flow_api.id(26565773067280366791)
,p_name=>'SOURCE_SQL'
,p_depending_on_has_to_exist=>true
,p_examples=>wwv_flow_string.join(wwv_flow_t_varchar2(
'<pre>',
'Select ''#'' LINK_URL, ''Facebook'' LINK_TEXT, ''fa-facebook'' ICON FROM DUAL',
'UNION ',
'Select ''#'' LINK_URL, ''Twitter'' LINK_TEXT, ''fa-twitter'' ICON FROM DUAL',
'UNION',
'Select ''https://www.github.com'' LINK_URL, ''GITHub'' LINK_TEXT, ''fa-github'' ICON FROM DUAL',
'UNION',
'Select ''https://www.google.com'' LINK_URL, ''Google'' LINK_TEXT, ''fa-google'' ICON FROM DUAL',
'</pre>'))
,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
'#LINK_TEXT#<br>',
'#LINK_URL#<br>',
'#ICON#<br>'))
);
end;
/
begin
wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table;
wwv_flow_api.g_varchar2_table(1) := '61207B0D0A2020636F6C6F723A20236666663B0D0A2020746578742D6465636F726174696F6E3A206E6F6E653B0D0A7D0D0A2E736F6369616C207B0D0A2020706F736974696F6E3A2066697865643B0D0A2020626F74746F6D3A203130253B0D0A202072';
wwv_flow_api.g_varchar2_table(2) := '696768743A3070783B0D0A7D0D0A2E736F6369616C20756C207B0D0A202070616464696E673A203070783B0D0A2020206D617267696E3A202D302E3872656D203272656D3B0D0A20202D7765626B69742D7472616E73666F726D3A207472616E736C6174';
wwv_flow_api.g_varchar2_table(3) := '652832363570782C2030293B0D0A20202D6D6F7A2D7472616E73666F726D3A207472616E736C6174652832363570782C2030293B0D0A20202D6D732D7472616E73666F726D3A207472616E736C6174652832363570782C2030293B0D0A20202D6F2D7472';
wwv_flow_api.g_varchar2_table(4) := '616E73666F726D3A207472616E736C6174652832363570782C2030293B0D0A20207472616E73666F726D3A207472616E736C6174652832363570782C307078293B0D0A7D0D0A2E736F6369616C20756C206C69207B0D0A2020646973706C61793A20626C';
wwv_flow_api.g_varchar2_table(5) := '6F636B3B0D0A2020637572736F723A706F696E7465723B0D0A20206D617267696E3A203570783B0D0A20206261636B67726F756E643A207267626128302C20302C20302C20302E3336293B0D0A202077696474683A2033303070783B0D0A202074657874';
wwv_flow_api.g_varchar2_table(6) := '2D616C69676E3A206C6566743B0D0A202070616464696E673A20313070783B0D0A20206C696E652D6865696768743A3472656D3B0D0A20202D7765626B69742D626F726465722D7261646975733A2033307078203070782030707820333070783B0D0A20';
wwv_flow_api.g_varchar2_table(7) := '202D6D6F7A2D626F726465722D7261646975733A2033307078203070782030707820333070783B0D0A2020626F726465722D7261646975733A2033307078203070782030707820333070783B0D0A20202D7765626B69742D7472616E736974696F6E3A20';
wwv_flow_api.g_varchar2_table(8) := '616C6C2031733B0D0A20202D6D6F7A2D7472616E736974696F6E3A20616C6C2031733B0D0A20202D6D732D7472616E736974696F6E3A20616C6C2031733B0D0A20202D6F2D7472616E736974696F6E3A20616C6C2031733B0D0A20207472616E73697469';
wwv_flow_api.g_varchar2_table(9) := '6F6E3A20616C6C2031733B0D0A7D0D0A2E736F6369616C20756C206C693A686F766572207B0D0A20202D7765626B69742D7472616E73666F726D3A207472616E736C617465282D31313070782C2030293B0D0A20202D6D6F7A2D7472616E73666F726D3A';
wwv_flow_api.g_varchar2_table(10) := '207472616E736C617465282D31313070782C2030293B0D0A20202D6D732D7472616E73666F726D3A207472616E736C617465282D31313070782C2030293B0D0A20202D6F2D7472616E73666F726D3A207472616E736C617465282D31313070782C203029';
wwv_flow_api.g_varchar2_table(11) := '3B0D0A20207472616E73666F726D3A207472616E736C617465282D31313070782C2030293B0D0A20206261636B67726F756E643A2072676261283235352C203235352C203235352C20302E34293B0D0A7D0D0A2E736F6369616C20756C206C693A686F76';
wwv_flow_api.g_varchar2_table(12) := '65722061207B0D0A2020636F6C6F723A20233030303B0D0A7D0D0A2E736F6369616C20756C206C693A686F7665722069207B0D0A2020636F6C6F723A20236666663B0D0A20206261636B67726F756E643A207265643B0D0A20202D7765626B69742D7472';
wwv_flow_api.g_varchar2_table(13) := '616E73666F726D3A20726F7461746528333630646567293B0D0A20202D6D6F7A2D7472616E73666F726D3A20726F7461746528333630646567293B0D0A20202D6D732D7472616E73666F726D3A20726F7461746528333630646567293B0D0A20202D6F2D';
wwv_flow_api.g_varchar2_table(14) := '7472616E73666F726D3A20726F7461746528333630646567293B0D0A20207472616E73666F726D3A20726F7461746528333630646567293B0D0A20202D7765626B69742D7472616E736974696F6E3A20616C6C2031733B0D0A20202D6D6F7A2D7472616E';
wwv_flow_api.g_varchar2_table(15) := '736974696F6E3A20616C6C2031733B0D0A20202D6D732D7472616E736974696F6E3A20616C6C2031733B0D0A20202D6F2D7472616E736974696F6E3A20616C6C2031733B0D0A20207472616E736974696F6E3A20616C6C2031733B0D0A7D0D0A2E736F63';
wwv_flow_api.g_varchar2_table(16) := '69616C20756C206C692069207B0D0A20206D617267696E2D6C6566743A20313070783B0D0A2020636F6C6F723A20233030303B0D0A20206261636B67726F756E643A20236666663B0D0A202070616464696E673A20313070783B0D0A20202D7765626B69';
wwv_flow_api.g_varchar2_table(17) := '742D626F726465722D7261646975733A203530253B0D0A20202D6D6F7A2D626F726465722D7261646975733A203530253B0D0A2020626F726465722D7261646975733A203530253B0D0A2020666F6E742D73697A653A20323070783B0D0A20206261636B';
wwv_flow_api.g_varchar2_table(18) := '67726F756E643A20236666666666663B0D0A20202D7765626B69742D7472616E73666F726D3A20726F746174652830646567293B0D0A20202D6D6F7A2D7472616E73666F726D3A20726F746174652830646567293B0D0A20202D6D732D7472616E73666F';
wwv_flow_api.g_varchar2_table(19) := '726D3A20726F746174652830646567293B0D0A20202D6F2D7472616E73666F726D3A20726F746174652830646567293B0D0A20207472616E73666F726D3A20726F746174652830646567293B0D0A7D';
null;
end;
/
begin
wwv_flow_api.create_plugin_file(
 p_id=>wwv_flow_api.id(26566246539975865188)
,p_plugin_id=>wwv_flow_api.id(26565773067280366791)
,p_file_name=>'css.css'
,p_mime_type=>'text/css'
,p_file_charset=>'utf-8'
,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table)
);
end;
/
begin
wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table;
wwv_flow_api.g_varchar2_table(1) := '76617220666F6F746572203D202866756E6374696F6E202829207B0D0A202020202275736520737472696374223B0D0A202020207661722073637269707456657273696F6E203D2022312E302E30223B0D0A20202020766172207574696C203D207B0D0A';
wwv_flow_api.g_varchar2_table(2) := '202020202020202076657273696F6E3A2022312E302E30222C0D0A20202020202020206973415045583A2066756E6374696F6E202829207B0D0A20202020202020202020202069662028747970656F6628617065782920213D3D2027756E646566696E65';
wwv_flow_api.g_varchar2_table(3) := '642729207B0D0A2020202020202020202020202020202072657475726E20747275653B0D0A2020202020202020202020207D20656C7365207B0D0A2020202020202020202020202020202072657475726E2066616C73653B0D0A20202020202020202020';
wwv_flow_api.g_varchar2_table(4) := '20207D0D0A20202020202020207D2C0D0A202020202020202064656275673A207B0D0A202020202020202020202020696E666F3A2066756E6374696F6E202873747229207B0D0A20202020202020202020202020202020696620287574696C2E69734150';
wwv_flow_api.g_varchar2_table(5) := '4558282929207B0D0A2020202020202020202020202020202020202020617065782E64656275672E696E666F28737472293B0D0A202020202020202020202020202020207D0D0A2020202020202020202020207D2C0D0A20202020202020202020202065';
wwv_flow_api.g_varchar2_table(6) := '72726F723A2066756E6374696F6E202873747229207B0D0A20202020202020202020202020202020696620287574696C2E697341504558282929207B0D0A2020202020202020202020202020202020202020617065782E64656275672E6572726F722873';
wwv_flow_api.g_varchar2_table(7) := '7472293B0D0A202020202020202020202020202020207D20656C7365207B0D0A2020202020202020202020202020202020202020636F6E736F6C652E6572726F7228737472293B0D0A202020202020202020202020202020207D0D0A2020202020202020';
wwv_flow_api.g_varchar2_table(8) := '202020207D0D0A20202020202020207D2C0D0A20202020202020206A736F6E53617665457874656E643A2066756E6374696F6E2028737263436F6E6669672C20746172676574436F6E66696729207B0D0A2020202020202020202020207661722066696E';
wwv_flow_api.g_varchar2_table(9) := '616C436F6E666967203D207B7D3B0D0A2020202020202020202020202F2A2074727920746F20706172736520636F6E666967206A736F6E207768656E20737472696E67206F72206A75737420736574202A2F0D0A20202020202020202020202069662028';
wwv_flow_api.g_varchar2_table(10) := '747970656F6620746172676574436F6E666967203D3D3D2027737472696E672729207B0D0A20202020202020202020202020202020747279207B0D0A2020202020202020202020202020202020202020746172676574436F6E666967203D204A534F4E2E';
wwv_flow_api.g_varchar2_table(11) := '706172736528746172676574436F6E666967293B0D0A202020202020202020202020202020207D20636174636820286529207B0D0A2020202020202020202020202020202020202020636F6E736F6C652E6572726F7228224572726F72207768696C6520';
wwv_flow_api.g_varchar2_table(12) := '74727920746F20706172736520746172676574436F6E6669672E20506C6561736520636865636B20796F757220436F6E666967204A534F4E2E205374616E6461726420436F6E6669672077696C6C20626520757365642E22293B0D0A2020202020202020';
wwv_flow_api.g_varchar2_table(13) := '202020202020202020202020636F6E736F6C652E6572726F722865293B0D0A2020202020202020202020202020202020202020636F6E736F6C652E6572726F7228746172676574436F6E666967293B0D0A202020202020202020202020202020207D0D0A';
wwv_flow_api.g_varchar2_table(14) := '2020202020202020202020207D20656C7365207B0D0A2020202020202020202020202020202066696E616C436F6E666967203D20746172676574436F6E6669673B0D0A2020202020202020202020207D0D0A2020202020202020202020202F2A20747279';
wwv_flow_api.g_varchar2_table(15) := '20746F206D657267652077697468207374616E6461726420696620616E7920617474726962757465206973206D697373696E67202A2F0D0A202020202020202020202020747279207B0D0A2020202020202020202020202020202066696E616C436F6E66';
wwv_flow_api.g_varchar2_table(16) := '6967203D20242E657874656E6428747275652C20737263436F6E6669672C20746172676574436F6E666967293B0D0A2020202020202020202020207D20636174636820286529207B0D0A20202020202020202020202020202020636F6E736F6C652E6572';
wwv_flow_api.g_varchar2_table(17) := '726F7228274572726F72207768696C652074727920746F206D657267652032204A534F4E7320696E746F207374616E64617264204A534F4E20696620616E7920617474726962757465206973206D697373696E672E20506C6561736520636865636B2079';
wwv_flow_api.g_varchar2_table(18) := '6F757220436F6E666967204A534F4E2E205374616E6461726420436F6E6669672077696C6C20626520757365642E27293B0D0A20202020202020202020202020202020636F6E736F6C652E6572726F722865293B0D0A2020202020202020202020202020';
wwv_flow_api.g_varchar2_table(19) := '202066696E616C436F6E666967203D20737263436F6E6669673B0D0A20202020202020202020202020202020636F6E736F6C652E6572726F722866696E616C436F6E666967293B0D0A2020202020202020202020207D0D0A202020202020202020202020';
wwv_flow_api.g_varchar2_table(20) := '72657475726E2066696E616C436F6E6669673B0D0A20202020202020207D0D0A202020207D3B0D0A0D0A202020202F2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A';
wwv_flow_api.g_varchar2_table(21) := '2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A0D0A20202020202A2A0D0A20202020202A2A205573656420746F2064726177206120636F6E7461696E65720D0A20202020202A2A0D0A20202020202A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A';
wwv_flow_api.g_varchar2_table(22) := '2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2F0D0A2020202066756E6374696F6E2064726177436F6E7461696E657228706172656E7429207B0D0A2020202020202020766172';
wwv_flow_api.g_varchar2_table(23) := '20646976203D202428223C6469763E3C2F6469763E22293B0D0A20202020202020206469762E616464436C6173732822736F6369616C22293B0D0A2020202020202020706172656E742E617070656E6428646976293B0D0A202020202020202072657475';
wwv_flow_api.g_varchar2_table(24) := '726E2028646976293B0D0A202020207D0D0A0D0A202020202F2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A0D0A2020';
wwv_flow_api.g_varchar2_table(25) := '2020202A2A0D0A20202020202A2A205573656420746F2064726177206120726F770D0A20202020202A2A0D0A20202020202A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A';
wwv_flow_api.g_varchar2_table(26) := '2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2F0D0A2020202066756E6374696F6E2064726177526F7728706172656E7429207B0D0A202020202020202076617220646976203D202428223C6469763E3C2F6469763E22293B0D0A2020202020202020';
wwv_flow_api.g_varchar2_table(27) := '6469762E616464436C6173732822617065782D726F7722293B0D0A2020202020202020706172656E742E617070656E6428646976293B0D0A202020202020202072657475726E2028646976293B0D0A202020207D0D0A0D0A202020202F2A2A2A2A2A2A2A';
wwv_flow_api.g_varchar2_table(28) := '2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A0D0A20202020202A2A0D0A20202020202A2A205573656420746F2072656E6465722074';
wwv_flow_api.g_varchar2_table(29) := '68652068746D6C20696E746F20726567696F6E0D0A20202020202A2A0D0A20202020202A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A';
wwv_flow_api.g_varchar2_table(30) := '2A2A2A2A2A2A2F0D0A2020202066756E6374696F6E2072656E64657248544D4C2870506172656E7449442C2070446174612C207045736361706548544D4C2C2070436F6E6669674A534F4E29207B0D0A0D0A202020202020202076617220706172656E74';
wwv_flow_api.g_varchar2_table(31) := '203D20242870506172656E744944293B0D0A2020202020202020706172656E742E706172656E7428292E63737328226F766572666C6F77222C2022696E686572697422293B0D0A2020202020202020766172206C5F636F6E7461696E6572203D20647261';
wwv_flow_api.g_varchar2_table(32) := '77436F6E7461696E657228706172656E74293B0D0A2020202020202020766172207A696E646578203D2031303B0D0A2020202020202020766172206261636B67726F756E64436F6C6F72203D2070436F6E6669674A534F4E2E6261636B67726F756E6443';
wwv_flow_api.g_varchar2_table(33) := '6F6C6F723B0D0A0D0A2020202020202020766172206C697374203D202428223C756C3E3C2F756C3E22293B0D0A2020202020202020242E656163682870446174612C2066756E6374696F6E20286964782C206461746129207B0D0A202020202020202020';
wwv_flow_api.g_varchar2_table(34) := '2020202F2F20636172644E756D203D20636172644E756D202B2070436F6E6669674A534F4E2E6361726457696474683B0D0A202020202020202020202020696620286261636B67726F756E64436F6C6F72203D3D20222229207B0D0A2020202020202020';
wwv_flow_api.g_varchar2_table(35) := '2020202020202020766172206C5F6C6973745F6C69203D202428273C6C693E3C2F6C693E27293B0D0A2020202020202020202020207D20656C7365207B0D0A20202020202020202020202020202020766172206C5F6C6973745F6C69203D202428273C6C';
wwv_flow_api.g_varchar2_table(36) := '69207374796C653D226261636B67726F756E643A27202B206261636B67726F756E64436F6C6F72202B20272021696D706F7274616E743B223E3C2F6C693E27293B0D0A090909090D0A2020202020202020202020207D0D0A202020202020202020202020';
wwv_flow_api.g_varchar2_table(37) := '766172206C5F6C696E6B203D202428273C61207461726765743D225F626C616E6B223E2027202B20646174612E4C494E4B5F54455854202B20273C2F613E27293B0D0A2020202020202020202020206C5F6C696E6B2E61747472282268726566222C2064';
wwv_flow_api.g_varchar2_table(38) := '6174612E4C494E4B5F55524C293B0D0A202020202020202020202020766172206C5F69636F6E203D202428273C6920636C6173733D2266612027202B20646174612E49434F4E202B2027223E3C2F693E27290D0A20202020202020202020202020202020';
wwv_flow_api.g_varchar2_table(39) := '6C5F6C696E6B2E70726570656E64286C5F69636F6E293B0D0A2020202020202020202020206C5F6C6973745F6C692E617070656E64286C5F6C696E6B293B0D0A20202020202020202020202024286C5F6C6973745F6C69292E636C69636B2866756E6374';
wwv_flow_api.g_varchar2_table(40) := '696F6E202829207B0D0A202020202020202020202020202020202F2F676574207468652075726C2066726F6D20687265662061747472696275746520616E64206C61756E6368207468652075726C0D0A2020202020202020202020202020202077696E64';
wwv_flow_api.g_varchar2_table(41) := '6F772E6F70656E28242874686973292E66696E6428226122292E6174747228226872656622292C20275F626C616E6B27293B0D0A2020202020202020202020202020202072657475726E2066616C73653B0D0A2020202020202020202020207D293B0D0A';
wwv_flow_api.g_varchar2_table(42) := '2020202020202020202020206C6973742E617070656E64286C5F6C6973745F6C69293B0D0A20202020202020207D293B0D0A20202020202020206C5F636F6E7461696E65722E617070656E64286C697374293B0D0A2020202020202020242827626F6479';
wwv_flow_api.g_varchar2_table(43) := '27292E617070656E64286C5F636F6E7461696E6572293B0D0A202020207D0D0A202020202F2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A';
wwv_flow_api.g_varchar2_table(44) := '2A2A2A2A2A2A2A2A2A0D0A20202020202A2A0D0A20202020202A2A205573656420746F20636865636B206461746120616E6420746F2063616C6C2072656E646572696E670D0A20202020202A2A0D0A20202020202A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A';
wwv_flow_api.g_varchar2_table(45) := '2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2F0D0A2020202066756E6374696F6E2070726570617265446174612870506172656E7449442C2070446174612C';
wwv_flow_api.g_varchar2_table(46) := '20704E6F44617461466F756E642C207045736361706548544D4C2C2070436F6E6669674A534F4E29207B0D0A20202020202020202F2A20656D70747920636F6E7461696E657220666F72206E6577207374756666202A2F0D0A2020202020202020242870';
wwv_flow_api.g_varchar2_table(47) := '506172656E744944292E656D70747928293B0D0A0D0A20202020202020206966202870446174612E726F772026262070446174612E726F772E6C656E677468203E203029207B0D0A0D0A20202020202020202020202072656E64657248544D4C28705061';
wwv_flow_api.g_varchar2_table(48) := '72656E7449442C2070446174612E726F772C207045736361706548544D4C2C2070436F6E6669674A534F4E293B0D0A20202020202020207D20656C7365207B0D0A0D0A202020202020202020202020242870506172656E744944292E63737328226D696E';
wwv_flow_api.g_varchar2_table(49) := '2D686569676874222C202222293B0D0A20202020202020207D0D0A202020207D0D0A0D0A2020202072657475726E207B0D0A202020202020202072656E6465723A2066756E6374696F6E2028726567696F6E49442C20616A617849442C206E6F44617461';
wwv_flow_api.g_varchar2_table(50) := '466F756E644D6573736167652C206974656D73325375626D69742C2065736361706552657175697265642C207564436F6E6669674A534F4E29207B0D0A20202020202020202020202076617220706172656E744944203D20222322202B20726567696F6E';
wwv_flow_api.g_varchar2_table(51) := '4944202B20222D70223B0D0A20202020202020202020202076617220737464436F6E6669674A534F4E203D207B0D0A2020202020202020202020202020202022636172645769647468223A20342C0D0A2020202020202020202020202020202022726566';
wwv_flow_api.g_varchar2_table(52) := '72657368223A20300D0A2020202020202020202020207D3B0D0A0D0A20202020202020202020202076617220636F6E6669674A534F4E203D207B7D3B0D0A202020202020202020202020636F6E6669674A534F4E203D207574696C2E6A736F6E53617665';
wwv_flow_api.g_varchar2_table(53) := '457874656E6428737464436F6E6669674A534F4E2C207564436F6E6669674A534F4E293B0D0A2020202020202020202020202F2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A';
wwv_flow_api.g_varchar2_table(54) := '2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A0D0A202020202020202020202020202A2A0D0A202020202020202020202020202A2A205573656420746F2067657420646174612066726F6D20415045580D0A202020202020202020202020202A';
wwv_flow_api.g_varchar2_table(55) := '2A0D0A202020202020202020202020202A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2F0D0A20202020202020202020';
wwv_flow_api.g_varchar2_table(56) := '202066756E6374696F6E20676574446174612829207B0D0A0D0A202020202020202020202020202020202428706172656E744944292E63737328226D696E2D686569676874222C2022313230707822293B0D0A0D0A202020202020202020202020202020';
wwv_flow_api.g_varchar2_table(57) := '20766172207375626D69744974656D73203D206974656D73325375626D69743B0D0A20202020202020202020202020202020747279207B0D0A2020202020202020202020202020202020202020617065782E7365727665722E706C7567696E280D0A2020';
wwv_flow_api.g_varchar2_table(58) := '20202020202020202020202020202020202020202020616A617849442C207B0D0A202020202020202020202020202020202020202020202020706167654974656D733A207375626D69744974656D730D0A20202020202020202020202020202020202020';
wwv_flow_api.g_varchar2_table(59) := '207D2C207B0D0A202020202020202020202020202020202020202020202020737563636573733A2066756E6374696F6E2028704461746129207B0D0A20202020202020202020202020202020202020202020202020202020707265706172654461746128';
wwv_flow_api.g_varchar2_table(60) := '706172656E7449442C2070446174612C206E6F44617461466F756E644D6573736167652C2065736361706552657175697265642C20636F6E6669674A534F4E290D0A2020202020202020202020202020202020202020202020207D2C0D0A202020202020';
wwv_flow_api.g_varchar2_table(61) := '2020202020202020202020202020202020206572726F723A2066756E6374696F6E20286429207B0D0A20202020202020202020202020202020202020202020202020202020636F6E736F6C652E6572726F7228642E726573706F6E736554657874293B0D';
wwv_flow_api.g_varchar2_table(62) := '0A2020202020202020202020202020202020202020202020207D2C0D0A20202020202020202020202020202020202020202020202064617461547970653A20226A736F6E220D0A20202020202020202020202020202020202020207D293B0D0A20202020';
wwv_flow_api.g_varchar2_table(63) := '2020202020202020202020207D20636174636820286529207B0D0A2020202020202020202020202020202020202020636F6E736F6C652E6572726F7228224572726F72207768696C652074727920746F2067657420446174612066726F6D204150455822';
wwv_flow_api.g_varchar2_table(64) := '293B0D0A2020202020202020202020202020202020202020636F6E736F6C652E6572726F722865293B0D0A202020202020202020202020202020207D0D0A0D0A2020202020202020202020207D0D0A0D0A2020202020202020202020202F2F206C6F6164';
wwv_flow_api.g_varchar2_table(65) := '20646174610D0A2020202020202020202020206765744461746128293B0D0A0D0A2020202020202020202020202F2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A';
wwv_flow_api.g_varchar2_table(66) := '2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A0D0A202020202020202020202020202A2A0D0A202020202020202020202020202A2A205573656420746F2062696E6420415045782052656672657368206576656E74202844412773290D0A20202020202020';
wwv_flow_api.g_varchar2_table(67) := '2020202020202A2A0D0A202020202020202020202020202A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2F0D0A202020';
wwv_flow_api.g_varchar2_table(68) := '202020202020202020747279207B0D0A20202020202020202020202020202020617065782E6A517565727928222322202B20726567696F6E4944292E62696E6428226170657872656672657368222C2066756E6374696F6E202829207B0D0A2020202020';
wwv_flow_api.g_varchar2_table(69) := '2020202020202020202020202020206765744461746128293B0D0A202020202020202020202020202020207D293B0D0A2020202020202020202020207D20636174636820286529207B0D0A20202020202020202020202020202020636F6E736F6C652E65';
wwv_flow_api.g_varchar2_table(70) := '72726F7228224572726F72207768696C652074727920746F2062696E6420415045582072656672657368206576656E7422293B0D0A20202020202020202020202020202020636F6E736F6C652E6572726F722865293B0D0A202020202020202020202020';
wwv_flow_api.g_varchar2_table(71) := '7D0D0A0D0A2020202020202020202020202F2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A0D0A2020202020202020';
wwv_flow_api.g_varchar2_table(72) := '20202020202A2A0D0A202020202020202020202020202A2A205573656420746F207265667265736820627920612074696D65720D0A202020202020202020202020202A2A0D0A202020202020202020202020202A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A';
wwv_flow_api.g_varchar2_table(73) := '2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2A2F0D0A20202020202020202020202069662028636F6E6669674A534F4E2E7265667265736820262620636F6E6669';
wwv_flow_api.g_varchar2_table(74) := '674A534F4E2E72656672657368203E203029207B0D0A20202020202020202020202020202020736574496E74657276616C2866756E6374696F6E202829207B0D0A20202020202020202020202020202020202020206765744461746128293B0D0A202020';
wwv_flow_api.g_varchar2_table(75) := '202020202020202020202020207D2C20636F6E6669674A534F4E2E72656672657368202A2031303030293B0D0A2020202020202020202020207D0D0A20202020202020207D0D0A202020207D0D0A0D0A7D2928293B0D0A';
null;
end;
/
begin
wwv_flow_api.create_plugin_file(
 p_id=>wwv_flow_api.id(26566246918883865189)
,p_plugin_id=>wwv_flow_api.id(26565773067280366791)
,p_file_name=>'js.js'
,p_mime_type=>'text/javascript'
,p_file_charset=>'utf-8'
,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table)
);
end;
/
prompt --application/end_environment
begin
wwv_flow_api.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false));
commit;
end;
/
set verify on feedback on define on
prompt  ...done
