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=>65172
,p_default_id_offset=>21810712866363894224
,p_default_owner=>'ASHISH_ME'
);
end;
/
 
prompt APPLICATION 65172 - Extended Grid toolbar TEST
--
-- Application Export:
--   Application:     65172
--   Name:            Extended Grid toolbar TEST
--   Date and Time:   18:22 Monday January 27, 2020
--   Exported By:     ASHISH
--   Flashback:       0
--   Export Type:     Component Export
--   Manifest
--     PLUGIN: 22071472853659786029
--   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/dynamic_action/interactive_report_row_view
begin
wwv_flow_api.create_plugin(
 p_id=>wwv_flow_api.id(22071472853659786029)
,p_plugin_type=>'DYNAMIC ACTION'
,p_name=>'INTERACTIVE_REPORT_ROW_VIEW'
,p_display_name=>'Interactive report Smooth Row View '
,p_category=>'INIT'
,p_supported_ui_types=>'DESKTOP'
,p_javascript_file_urls=>'#PLUGIN_FILES#iRsmooth_row_view.js'
,p_plsql_code=>wwv_flow_string.join(wwv_flow_t_varchar2(
'function f_render_plugin (',
'    p_dynamic_action in apex_plugin.t_dynamic_action,',
'    p_plugin         in apex_plugin.t_plugin)',
'  return apex_plugin.t_dynamic_action_render_result',
'is',
'  v_return apex_plugin.t_dynamic_action_render_result;',
'begin',
'  -- return',
'  v_return.javascript_function := ''iRsmooth_row_view.init'';',
'  v_return.attribute_01        := p_dynamic_action.attribute_01;',
'  ',
'  return v_return;',
'end;'))
,p_api_version=>2
,p_render_function=>'f_render_plugin'
,p_standard_attributes=>'REGION:EVENT_SOURCE:REQUIRED'
,p_substitute_attributes=>true
,p_subscribe_plugin_settings=>true
,p_help_text=>'It allows a smooth row view instead of loading query every time.'
,p_version_identifier=>'1.0'
,p_about_url=>'https://apex.oracle.com/pls/apex/f?p=93690'
,p_files_version=>14
);
wwv_flow_api.create_plugin_attribute(
 p_id=>wwv_flow_api.id(22075522233396895849)
,p_plugin_id=>wwv_flow_api.id(22071472853659786029)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>1
,p_display_sequence=>10
,p_prompt=>'Region ID'
,p_attribute_type=>'TEXT'
,p_is_required=>true
,p_is_translatable=>false
);
end;
/
begin
wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table;
wwv_flow_api.g_varchar2_table(1) := '2F2A210D0A202A20617065782D706C7567696E2D6952736D6F6F74685F726F775F76696577202D204F7261636C65204150455820706C7567696E0D0A202A2040617574686F72204173686973682053616861790D0A202A204076657273696F6E2076312E';
wwv_flow_api.g_varchar2_table(2) := '302E300D0A202A20406C696E6B200D0A202A20406C6963656E7365204D49540D0A202A2F0D0A2F2A0D0A202A2043686167654C6F673A0D0A202A2076312E302E30202D203230313731313031202D20496E697469616C2052656C656173650D0A202A2F0D';
wwv_flow_api.g_varchar2_table(3) := '0A200D0A202020200D0A2020202066756E6374696F6E20686964654D6528705F726567696F6E496429207B0D0A20202020202020202F2F7661722076526567696F6E496424203D202723524547494F4E5F5354415449435F494423273B0D0A2020202020';
wwv_flow_api.g_varchar2_table(4) := '20202024282723272B20705F726567696F6E49642B20275F53494E474C452D524F572D5649455727292E686964652822736C6F7722293B0D0A20202020202020202F2F20617065782E726567696F6E2827534F4E4746494C452D555345525327292E7265';
wwv_flow_api.g_varchar2_table(5) := '667265736828293B0D0A20202020202020202428272327202B20705F726567696F6E4964202B20275F66756C6C5F7669657727292E73686F772822736C6F7722293B0D0A20202020202020207D0D0A202020200D0A766172206952736D6F6F74685F726F';
wwv_flow_api.g_varchar2_table(6) := '775F76696577203D207B0D0A0D0A20202F2F20496E69742046756E6374696F6E0D0A2020696E69743A2066756E6374696F6E28297B0D0A20202020766172206461203D20746869733B0D0A202020200D0A09617065782E64656275672E6C6F6728276952';
wwv_flow_api.g_varchar2_table(7) := '736D6F6F74685F726F775F766965772E696E6974272C6461293B0D0A090D0A202020202F2F2067657420706C7567696E20617474726962757465730D0A202020207661722076526567696F6E496420202020202020203D2064612E616374696F6E2E6174';
wwv_flow_api.g_varchar2_table(8) := '7472696275746530313B0D0A090D0A096966282428222322202B76526567696F6E4964202B225F53494E474C452D524F572D5649455722292E6C656E677468203D3D203029207B0D0A090920200D0A092428273C646976206964203D22272B7652656769';
wwv_flow_api.g_varchar2_table(9) := '6F6E4964202B275F53494E474C452D524F572D56494557223E203C6469763E27292E696E73657274416674657228272327202B2076526567696F6E49642B20275F66756C6C5F7669657727293B0D0A097D0D0A090D0A24282723272B76526567696F6E49';
wwv_flow_api.g_varchar2_table(10) := '64202B275F53494E474C452D524F572D5649455727292E6869646528293B0D0A0D0A2428222322202B2076526567696F6E4964202B2022202E612D4952522D64657461696C2D726F7722292E65616368282066756E6374696F6E28297B0D0A2020202024';
wwv_flow_api.g_varchar2_table(11) := '2874686973292E617474722827636C617373272C2076526567696F6E4964202B27617065782D656469742D7669657727293B0D0A7D293B0D0A0D0A0D0A2428272E272B2076526567696F6E49642B2027617065782D656469742D7669657727292E636C69';
wwv_flow_api.g_varchar2_table(12) := '636B282066756E6374696F6E28206529207B0D0A0976617220767461726765743D206576656E742E7461726765743B0D0A2020202076617220726F775F696E64783D2028242874686973292E706172656E742827746427292E706172656E742827747227';
wwv_flow_api.g_varchar2_table(13) := '292E696E6465782829292B20313B0D0A097661722066756E6374696F6E5F43616C6C203D22686964654D652827222B76526567696F6E49642B222729223B0D0A0976617220696E64783D20303B0D0A097661722068746D6C3D20273C64697620636C6173';
wwv_flow_api.g_varchar2_table(14) := '733D22612D4952522D746F6F6C62617220612D4952522D746F6F6C6261722D2D73696E676C65526F77223E272B0D0A09090909273C64697620636C6173733D22612D4952522D746F6F6C6261724E6176223E272B0D0A09090909273C627574746F6E2074';
wwv_flow_api.g_varchar2_table(15) := '7970653D22627574746F6E222069643D2227202B2076526567696F6E4964202B275F7265706F72745F766965772220636C6173733D22612D427574746F6E20612D4952522D627574746F6E20612D4952522D627574746F6E2D2D7265706F727456696577';
wwv_flow_api.g_varchar2_table(16) := '22206F6E436C69636B3D202227202B66756E6374696F6E5F43616C6C2B2027223E272B0D0A090909090909273C7370616E20636C6173733D22612D49636F6E2069636F6E2D6C6566742D63686576726F6E223E3C2F7370616E3E272B0D0A090909090909';
wwv_flow_api.g_varchar2_table(17) := '273C7370616E3E5265706F727420566965773C2F7370616E3E272B0D0A0909090909273C2F627574746F6E3E272B0D0A09090909273C2F6469763E272B0D0A09090909273C64697620636C6173733D22612D4952522D73696E676C65526F774E6176223E';
wwv_flow_api.g_varchar2_table(18) := '272B0D0A09090909273C2F6469763E272B0D0A090909273C2F6469763E272B0D0A090909273C64697620636C6173733D22612D4952522D636F6E74656E74223E273B0D0A090D0A202020202428272327202B2076526567696F6E4964292E66696E642827';
wwv_flow_api.g_varchar2_table(19) := '23737469636B795461626C654865616465725F3120746827292E65616368282066756E6374696F6E28297B0D0A0909766172206864725F7478743D20242874686973292E7465787428293B0D0A202020202020202076617220736F72743D202428746869';
wwv_flow_api.g_varchar2_table(20) := '73292E66696E6428277370616E5B636C6173733D22612D4952522D686561646572536F7274225D27292E7465787428293B0D0A202020202020202069662820736F72742E6C656E6774683E203029207B0D0A2020202020202020202020206864725F7478';
wwv_flow_api.g_varchar2_table(21) := '743D206864725F7478742E737562737472696E6728302C206864725F7478742E696E6465784F6628736F727429293B0D0A20202020202020207D0D0A0909696E64782B3D20313B0D0A09092F2F20544F20444F3A2D2020416464696E6720506167696E61';
wwv_flow_api.g_varchar2_table(22) := '74696F6E200D0A0909696628206864725F747874213D20272720262620286864725F7478742E63686172436F64654174283029213D2031363029202626206864725F747874213D274C696E6B2729207B0D0A0909097661722064746C5F7478743D202428';
wwv_flow_api.g_varchar2_table(23) := '272E742D6668742D74626F6479207461626C652074626F64792074723A6E74682D6368696C6428272B20726F775F696E64782B2027292074643A6E74682D6368696C6428272B20696E64782B20272927292E68746D6C28293B0D0A09090968746D6C3D20';
wwv_flow_api.g_varchar2_table(24) := '68746D6C2B20273C64697620636C6173733D22612D4952522D73696E676C65526F772D726F77223E272B200D0A09090909090909273C7370616E20636C6173733D22612D4952522D73696E676C65526F772D6E616D65223E272B200D0A09090909090909';
wwv_flow_api.g_varchar2_table(25) := '096864725F7478742B200D0A09090909090909273C2F7370616E3E272B0D0A09090909090909273C7370616E20636C6173733D22612D4952522D73696E676C65526F772D76616C7565223E272B0D0A090909090909090964746C5F7478742B0D0A090909';
wwv_flow_api.g_varchar2_table(26) := '09090909273C2F7370616E3E272B0D0A090909090909273C2F6469763E273B0D0A09097D0D0A097D293B0D0A0968746D6C3D2068746D6C2B20273C2F6469763E273B0D0A202020202428272327202B2076526567696F6E4964202B20275F66756C6C5F76';
wwv_flow_api.g_varchar2_table(27) := '69657727292E686964652822736C6F7722293B0D0A2020202024282723272B2076526567696F6E4964202B20275F53494E474C452D524F572D5649455727292E68746D6C282068746D6C293B0D0A2020202024282723272B2076526567696F6E4964202B';
wwv_flow_api.g_varchar2_table(28) := '20275F53494E474C452D524F572D5649455727292E73686F772822736C6F7722293B0D0A7D293B0D0A0D0A7D7D';
null;
end;
/
begin
wwv_flow_api.create_plugin_file(
 p_id=>wwv_flow_api.id(22071220777363350743)
,p_plugin_id=>wwv_flow_api.id(22071472853659786029)
,p_file_name=>'iRsmooth_row_view.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
