-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdynamic_action_plugin.sql
208 lines (206 loc) · 19 KB
/
dynamic_action_plugin.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
prompt --application/set_environment
set define off verify off feedback off
whenever sqlerror exit sql.sqlcode rollback
--------------------------------------------------------------------------------
--
-- Oracle APEX export file
--
-- You should run this script using a SQL client connected to the database as
-- the owner (parsing schema) of the application or as a database user with the
-- APEX_ADMINISTRATOR_ROLE role.
--
-- This export file has been automatically generated. Modifying this file is not
-- supported by Oracle and can lead to unexpected application and/or instance
-- behavior now or in the future.
--
-- NOTE: Calls to apex_application_install override the defaults below.
--
--------------------------------------------------------------------------------
begin
wwv_flow_imp.import_begin (
p_version_yyyy_mm_dd=>'2023.10.31'
,p_release=>'23.2.4'
,p_default_workspace_id=>54699133849791445369
,p_default_application_id=>203140
,p_default_id_offset=>0
,p_default_owner=>'WKSP_A7A'
);
end;
/
prompt APPLICATION 203140 - BASIC UI TRAINING
--
-- Application Export:
-- Application: 203140
-- Name: BASIC UI TRAINING
-- Date and Time: 10:44 Monday March 25, 2024
-- Exported By: [email protected]
-- Flashback: 0
-- Export Type: Component Export
-- Manifest
-- PLUGIN: 82770889312155439677
-- Manifest End
-- Version: 23.2.4
-- Instance ID: 63113759365424
--
begin
-- replace components
wwv_flow_imp.g_mode := 'REPLACE';
end;
/
prompt --application/shared_components/plugins/dynamic_action/test
begin
wwv_flow_imp_shared.create_plugin(
p_id=>wwv_flow_imp.id(82770889312155439677)
,p_plugin_type=>'DYNAMIC ACTION'
,p_name=>'TEST'
,p_display_name=>'Map Region Info Picker'
,p_category=>'EXECUTE'
,p_javascript_file_urls=>wwv_flow_string.join(wwv_flow_t_varchar2(
'#PLUGIN_FILES#picker#MIN#.js',
'https://unpkg.com/[email protected]/dist/leaflet.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 := ''picker_fun.init'';',
' v_return.attribute_01 := p_dynamic_action.attribute_01; -- TRANSLATE FROM',
'',
'',
' return v_return;',
'end;'))
,p_default_escape_mode=>'HTML'
,p_api_version=>2
,p_render_function=>'f_render_plugin'
,p_standard_attributes=>'JAVASCRIPT_EXPRESSION'
,p_substitute_attributes=>true
,p_subscribe_plugin_settings=>true
,p_help_text=>'Dynamic Action Plugin that enables you to retrieve information about the picked area in a Map Region'
,p_version_identifier=>'1.0'
,p_about_url=>'https://github.com/Wadie-ess'
,p_files_version=>62
);
wwv_flow_imp_shared.create_plugin_attribute(
p_id=>wwv_flow_imp.id(82836405121155007672)
,p_plugin_id=>wwv_flow_imp.id(82770889312155439677)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>1
,p_display_sequence=>10
,p_prompt=>'Map Region Static id'
,p_attribute_type=>'TEXT'
,p_is_required=>false
,p_is_translatable=>false
,p_examples=>'map_id'
,p_help_text=>'add the static ID of the map Region'
);
end;
/
begin
wwv_flow_imp.g_varchar2_table := wwv_flow_imp.empty_varchar2_table;
wwv_flow_imp.g_varchar2_table(1) := '766172207069636B65725F66756E203D207B0D0A0D0A202020202F2A20496E69742046756E6374696F6E2A2F0D0A20202020696E69743A2066756E6374696F6E202829207B0D0A2020202020202020766172206461203D20746869733B0D0A2020202020';
wwv_flow_imp.g_varchar2_table(2) := '202020747279207B0D0A20202020202020202020202076617220765F726567696F6E4944203D2064612E616374696F6E2E61747472696275746530313B0D0A202020202020202020202020766172206D6170626F78203D20617065782E726567696F6E28';
wwv_flow_imp.g_varchar2_table(3) := '765F726567696F6E4944292E6765744D61704F626A65637428293B0D0A202020202020202020202020766172206D6170203D204C2E6D617028765F726567696F6E4944292E73657456696577285B35312E3530352C202D302E30395D2C203133293B0D0A';
wwv_flow_imp.g_varchar2_table(4) := '202020202020202020202020766172206C6174447261773B0D0A202020202020202020202020766172206C6E67447261773B0D0A0D0A202020202020202020202020766172206C6174203D20303B0D0A202020202020202020202020766172206C6E6720';
wwv_flow_imp.g_varchar2_table(5) := '3D20303B0D0A0D0A0D0A2020202020202020202020206D61702E6F6E2827636C69636B272C2066756E6374696F6E20286529207B0D0A0D0A202020202020202020202020202020206C617444726177203D20652E6C61746C6E672E6C61743B0D0A202020';
wwv_flow_imp.g_varchar2_table(6) := '202020202020202020202020206C6E6744726177203D20652E6C61746C6E672E6C6E673B0D0A0D0A2020202020202020202020207D293B0D0A0D0A2020202020202020202020206D6170626F782E6F6E2827636C69636B272C206173796E632066756E63';
wwv_flow_imp.g_varchar2_table(7) := '74696F6E20286529207B0D0A202020202020202020202020202020206C6174203D20652E6C6E674C61742E6C61743B0D0A202020202020202020202020202020206C6E67203D20652E6C6E674C61742E6C6E673B0D0A2020202020202020202020202020';
wwv_flow_imp.g_varchar2_table(8) := '20206177616974206665746368506F70756C6174696F6E286C6E672C206C6174293B0D0A2020202020202020202020202020202061776169742066657463684C616E6455736544617461286C61742C206C6E67293B0D0A0D0A2020202020202020202020';
wwv_flow_imp.g_varchar2_table(9) := '202020202075706461746557656174686572554928603C6469763E43757272656E7420436974792F526567696F6E3A203C7370616E207374796C653D22666F6E742D7765696768743A20626F6C643B223E247B73656C6563746564436974797D3C2F7370';
wwv_flow_imp.g_varchar2_table(10) := '616E3E3C62723E506F70756C6174696F6E3A203C7370616E207374796C653D22666F6E742D7765696768743A20626F6C643B223E247B706F70756C6174696F6E7D3C2F7370616E3E3C62723E4C616E6420547970653A203C7370616E207374796C653D22';
wwv_flow_imp.g_varchar2_table(11) := '666F6E742D7765696768743A20626F6C643B223E247B6C616E64747970657D3C2F7370616E3E3C2F6469763E60293B0D0A2020202020202020202020207D293B0D0A0D0A2020202020202020202020206173796E632066756E6374696F6E206665746368';
wwv_flow_imp.g_varchar2_table(12) := '506F70756C6174696F6E286C6E672C206C617429207B0D0A20202020202020202020202020202020636F6E737420656E64706F696E7455726C203D202768747470733A2F2F71756572792E77696B69646174612E6F72672F73706172716C273B0D0A2020';
wwv_flow_imp.g_varchar2_table(13) := '2020202020202020202020202020636F6E73742073706172716C5175657279203D206053454C454354203F63697479203F636974794C6162656C203F706F70756C6174696F6E205748455245207B0D0A2020534552564943452077696B69626173653A61';
wwv_flow_imp.g_varchar2_table(14) := '726F756E64207B0D0A202020203F63697479207764743A50363235203F6C6F636174696F6E2E0D0A2020202062643A73657276696365506172616D2077696B69626173653A63656E7465722022506F696E7428247B6C6E677D20247B6C61747D29225E5E';
wwv_flow_imp.g_varchar2_table(15) := '67656F3A776B744C69746572616C2E0D0A2020202062643A73657276696365506172616D2077696B69626173653A72616469757320223130222E0D0A20207D0D0A20203F63697479207764743A5033312F7764743A503237392A2077643A513531353B0D';
wwv_flow_imp.g_varchar2_table(16) := '0A20202020202020207764743A5031303832203F706F70756C6174696F6E2E0D0A2020534552564943452077696B69626173653A6C6162656C207B2062643A73657276696365506172616D2077696B69626173653A6C616E677561676520225B4155544F';
wwv_flow_imp.g_varchar2_table(17) := '5F4C414E47554147455D2C656E222E207D0D0A7D0D0A4C494D49542031603B0D0A0D0A20202020202020202020202020202020636F6E73742066756C6C55726C203D20656E64706F696E7455726C202B20273F71756572793D27202B20656E636F646555';
wwv_flow_imp.g_varchar2_table(18) := '5249436F6D706F6E656E742873706172716C5175657279293B0D0A20202020202020202020202020202020636F6E73742068656164657273203D207B2027416363657074273A20276170706C69636174696F6E2F73706172716C2D726573756C74732B6A';
wwv_flow_imp.g_varchar2_table(19) := '736F6E27207D3B0D0A0D0A2020202020202020202020202020202061776169742066657463682866756C6C55726C2C207B2068656164657273207D290D0A20202020202020202020202020202020202020202E7468656E28726573706F6E7365203D3E20';
wwv_flow_imp.g_varchar2_table(20) := '726573706F6E73652E6A736F6E2829290D0A20202020202020202020202020202020202020202E7468656E2864617461203D3E207B0D0A202020202020202020202020202020202020202020202020706F70756C6174696F6E203D20646174612E726573';
wwv_flow_imp.g_varchar2_table(21) := '756C74732E62696E64696E67732E6C656E677468203E2030203F20646174612E726573756C74732E62696E64696E67735B305D2E706F70756C6174696F6E2E76616C75652E746F537472696E672829203A2022556E646566696E65642041726561223B0D';
wwv_flow_imp.g_varchar2_table(22) := '0A20202020202020202020202020202020202020202020202073656C656374656443697479203D20646174612E726573756C74732E62696E64696E67732E6C656E677468203E2030203F20646174612E726573756C74732E62696E64696E67735B305D2E';
wwv_flow_imp.g_varchar2_table(23) := '636974794C6162656C2E76616C7565203A2022556E646566696E6564223B0D0A20202020202020202020202020202020202020207D293B0D0A2020202020202020202020207D0D0A0D0A2020202020202020202020206173796E632066756E6374696F6E';
wwv_flow_imp.g_varchar2_table(24) := '2066657463684C616E6455736544617461286C61742C206C6E6729207B0D0A20202020202020202020202020202020766172206F766572706173735175657279203D20602F2A0D0A202020205468697320686173206265656E2067656E65726174656420';
wwv_flow_imp.g_varchar2_table(25) := '627920746865206F766572706173732D747572626F2077697A6172642E0D0A20202020546865206F726967696E616C20736561726368207761733A0D0A2020202022706F70756C6174696F6E220D0A202020202A2F0D0A202020205B6F75743A6A736F6E';
wwv_flow_imp.g_varchar2_table(26) := '5D5B74696D656F75743A32355D3B0D0A20202020280D0A20202020202020207761795B226C616E64757365225D28247B6C6174202D20302E317D2C247B6C6E67202D20302E317D2C247B6C6174202B20302E317D2C247B6C6E67202B20302E317D293B0D';
wwv_flow_imp.g_varchar2_table(27) := '0A202020202020202072656C6174696F6E5B22706F70756C6174696F6E225D28247B6C6174202D20302E317D2C247B6C6E67202D20302E317D2C247B6C6174202B20302E317D2C247B6C6E67202B20302E317D293B0D0A20202020202020202877617928';
wwv_flow_imp.g_varchar2_table(28) := '247B6C6174202D20302E317D2C247B6C6E67202D20302E317D2C247B6C6174202B20302E317D2C247B6C6E67202B20302E317D295B706C6163657E22746F776E7C63697479225D3B0D0A202020202020202072656C28247B6C6174202D20302E317D2C24';
wwv_flow_imp.g_varchar2_table(29) := '7B6C6E67202D20302E317D2C247B6C6174202B20302E317D2C247B6C6E67202B20302E317D295B706C6163657E22746F776E7C63697479225D3B0D0A20202020202020206E6F646528247B6C6174202D20302E317D2C247B6C6E67202D20302E317D2C24';
wwv_flow_imp.g_varchar2_table(30) := '7B6C6174202B20302E317D2C247B6C6E67202B20302E317D295B706C6163657E22746F776E7C63697479225D3B293B0D0A20202020202020202872656C28247B6C6174202D20302E317D2C247B6C6E67202D20302E317D2C247B6C6174202B20302E317D';
wwv_flow_imp.g_varchar2_table(31) := '2C247B6C6E67202B20302E317D295B706F70756C6174696F6E5D3B293B0D0A20202020293B0D0A202020206F757420626F64793B0D0A202020203E3B0D0A202020206F757420736B656C2071743B603B0D0A202020202020202020202020202020206177';
wwv_flow_imp.g_varchar2_table(32) := '616974206665746368282768747470733A2F2F6F766572706173732D6170692E64652F6170692F696E746572707265746572272C207B0D0A20202020202020202020202020202020202020206D6574686F643A2027504F5354272C0D0A20202020202020';
wwv_flow_imp.g_varchar2_table(33) := '20202020202020202020202020626F64793A206F7665727061737351756572790D0A202020202020202020202020202020207D290D0A20202020202020202020202020202020202020202E7468656E28726573706F6E7365203D3E20726573706F6E7365';
wwv_flow_imp.g_varchar2_table(34) := '2E6A736F6E2829290D0A20202020202020202020202020202020202020202E7468656E2864617461203D3E207B0D0A2020202020202020202020202020202020202020202020206C616E6474797065203D20646174612E656C656D656E74732026262064';
wwv_flow_imp.g_varchar2_table(35) := '6174612E656C656D656E74732E6C656E677468203E2030203F20646174612E656C656D656E74732E66696C7465722828656C656D656E7429203D3E20656C656D656E742E74797065203D3D202277617922295B305D2E746167732E6C616E64757365203A';
wwv_flow_imp.g_varchar2_table(36) := '2022556E646966696E65642041726561223B0D0A0D0A20202020202020202020202020202020202020207D290D0A20202020202020202020202020202020202020202E6361746368286572726F72203D3E207B0D0A202020202020202020202020202020';
wwv_flow_imp.g_varchar2_table(37) := '2020202020202020206C616E6474797065203D2022556E646566696E65642041726561220D0A0D0A0D0A20202020202020202020202020202020202020207D290D0A2020202020202020202020207D0D0A0D0A0D0A20202020202020202020202066756E';
wwv_flow_imp.g_varchar2_table(38) := '6374696F6E207570646174655765617468657255492868746D6C29207B0D0A0D0A2020202020202020202020202020202076617220706F707570203D204C2E706F70757028290D0A20202020202020202020202020202020202020202E7365744C61744C';
wwv_flow_imp.g_varchar2_table(39) := '6E67285B6C6174447261772C206C6E67447261775D290D0A20202020202020202020202020202020202020202E736574436F6E74656E742868746D6C290D0A20202020202020202020202020202020202020202E6F70656E4F6E286D6170293B0D0A0D0A';
wwv_flow_imp.g_varchar2_table(40) := '2020202020202020202020207D0D0A20202020202020207D20636174636820286529207B0D0A2020202020202020202020202F2F20636F6E736F6C652E6C6F672865293B0D0A20202020202020207D0D0A0D0A0D0A202020207D0D0A7D0D0A0D0A0D0A0D';
wwv_flow_imp.g_varchar2_table(41) := '0A0D0A';
null;
end;
/
begin
wwv_flow_imp_shared.create_plugin_file(
p_id=>wwv_flow_imp.id(82771279433086932509)
,p_plugin_id=>wwv_flow_imp.id(82770889312155439677)
,p_file_name=>'picker.js'
,p_mime_type=>'text/javascript'
,p_file_charset=>'utf-8'
,p_file_content=>wwv_flow_imp.varchar2_to_blob(wwv_flow_imp.g_varchar2_table)
);
end;
/
begin
wwv_flow_imp.g_varchar2_table := wwv_flow_imp.empty_varchar2_table;
wwv_flow_imp.g_varchar2_table(1) := '766172207069636B65725F66756E3D7B696E69743A66756E6374696F6E28297B7472797B766172206E2C742C653D746869732E616374696F6E2E61747472696275746530312C613D617065782E726567696F6E2865292E6765744D61704F626A65637428';
wwv_flow_imp.g_varchar2_table(2) := '292C693D4C2E6D61702865292E73657456696577285B35312E3530352C2D2E30395D2C3133292C6F3D302C6C3D303B692E6F6E2822636C69636B222C2866756E6374696F6E2865297B6E3D652E6C61746C6E672E6C61742C743D652E6C61746C6E672E6C';
wwv_flow_imp.g_varchar2_table(3) := '6E677D29292C612E6F6E2822636C69636B222C286173796E632066756E6374696F6E2865297B76617220613B6F3D652E6C6E674C61742E6C61742C6C3D652E6C6E674C61742E6C6E672C6177616974206173796E632066756E6374696F6E286E2C74297B';
wwv_flow_imp.g_varchar2_table(4) := '636F6E737420653D6053454C454354203F63697479203F636974794C6162656C203F706F70756C6174696F6E205748455245207B5C6E2020534552564943452077696B69626173653A61726F756E64207B5C6E202020203F63697479207764743A503632';
wwv_flow_imp.g_varchar2_table(5) := '35203F6C6F636174696F6E2E5C6E2020202062643A73657276696365506172616D2077696B69626173653A63656E7465722022506F696E7428247B6E7D20247B747D29225E5E67656F3A776B744C69746572616C2E5C6E2020202062643A736572766963';
wwv_flow_imp.g_varchar2_table(6) := '65506172616D2077696B69626173653A72616469757320223130222E5C6E20207D5C6E20203F63697479207764743A5033312F7764743A503237392A2077643A513531353B5C6E20202020202020207764743A5031303832203F706F70756C6174696F6E';
wwv_flow_imp.g_varchar2_table(7) := '2E5C6E2020534552564943452077696B69626173653A6C6162656C207B2062643A73657276696365506172616D2077696B69626173653A6C616E677561676520225B4155544F5F4C414E47554147455D2C656E222E207D5C6E7D5C6E4C494D4954203160';
wwv_flow_imp.g_varchar2_table(8) := '2C613D2268747470733A2F2F71756572792E77696B69646174612E6F72672F73706172716C3F71756572793D222B656E636F6465555249436F6D706F6E656E742865292C693D7B4163636570743A226170706C69636174696F6E2F73706172716C2D7265';
wwv_flow_imp.g_varchar2_table(9) := '73756C74732B6A736F6E227D3B617761697420666574636828612C7B686561646572733A697D292E7468656E28286E3D3E6E2E6A736F6E282929292E7468656E28286E3D3E7B706F70756C6174696F6E3D6E2E726573756C74732E62696E64696E67732E';
wwv_flow_imp.g_varchar2_table(10) := '6C656E6774683E303F6E2E726573756C74732E62696E64696E67735B305D2E706F70756C6174696F6E2E76616C75652E746F537472696E6728293A22556E646566696E65642041726561222C73656C6563746564436974793D6E2E726573756C74732E62';
wwv_flow_imp.g_varchar2_table(11) := '696E64696E67732E6C656E6774683E303F6E2E726573756C74732E62696E64696E67735B305D2E636974794C6162656C2E76616C75653A22556E646566696E6564227D29297D286C2C6F292C6177616974206173796E632066756E6374696F6E286E2C74';
wwv_flow_imp.g_varchar2_table(12) := '297B76617220653D602F2A5C6E202020205468697320686173206265656E2067656E65726174656420627920746865206F766572706173732D747572626F2077697A6172642E5C6E20202020546865206F726967696E616C20736561726368207761733A';
wwv_flow_imp.g_varchar2_table(13) := '5C6E2020202022706F70756C6174696F6E225C6E202020202A2F5C6E202020205B6F75743A6A736F6E5D5B74696D656F75743A32355D3B5C6E20202020285C6E20202020202020207761795B226C616E64757365225D28247B6E2D2E317D2C247B742D2E';
wwv_flow_imp.g_varchar2_table(14) := '317D2C247B6E2B2E317D2C247B742B2E317D293B5C6E202020202020202072656C6174696F6E5B22706F70756C6174696F6E225D28247B6E2D2E317D2C247B742D2E317D2C247B6E2B2E317D2C247B742B2E317D293B5C6E202020202020202028776179';
wwv_flow_imp.g_varchar2_table(15) := '28247B6E2D2E317D2C247B742D2E317D2C247B6E2B2E317D2C247B742B2E317D295B706C6163657E22746F776E7C63697479225D3B5C6E202020202020202072656C28247B6E2D2E317D2C247B742D2E317D2C247B6E2B2E317D2C247B742B2E317D295B';
wwv_flow_imp.g_varchar2_table(16) := '706C6163657E22746F776E7C63697479225D3B5C6E20202020202020206E6F646528247B6E2D2E317D2C247B742D2E317D2C247B6E2B2E317D2C247B742B2E317D295B706C6163657E22746F776E7C63697479225D3B293B5C6E20202020202020202872';
wwv_flow_imp.g_varchar2_table(17) := '656C28247B6E2D2E317D2C247B742D2E317D2C247B6E2B2E317D2C247B742B2E317D295B706F70756C6174696F6E5D3B293B5C6E20202020293B5C6E202020206F757420626F64793B5C6E202020203E3B5C6E202020206F757420736B656C2071743B60';
wwv_flow_imp.g_varchar2_table(18) := '3B6177616974206665746368282268747470733A2F2F6F766572706173732D6170692E64652F6170692F696E746572707265746572222C7B6D6574686F643A22504F5354222C626F64793A657D292E7468656E28286E3D3E6E2E6A736F6E282929292E74';
wwv_flow_imp.g_varchar2_table(19) := '68656E28286E3D3E7B6C616E64747970653D6E2E656C656D656E747326266E2E656C656D656E74732E6C656E6774683E303F6E2E656C656D656E74732E66696C74657228286E3D3E22776179223D3D6E2E7479706529295B305D2E746167732E6C616E64';
wwv_flow_imp.g_varchar2_table(20) := '7573653A22556E646966696E65642041726561227D29292E636174636828286E3D3E7B6C616E64747970653D22556E646566696E65642041726561227D29297D286F2C6C292C613D603C6469763E43757272656E7420436974792F526567696F6E3A203C';
wwv_flow_imp.g_varchar2_table(21) := '7370616E207374796C653D22666F6E742D7765696768743A20626F6C643B223E247B73656C6563746564436974797D3C2F7370616E3E3C62723E506F70756C6174696F6E3A203C7370616E207374796C653D22666F6E742D7765696768743A20626F6C64';
wwv_flow_imp.g_varchar2_table(22) := '3B223E247B706F70756C6174696F6E7D3C2F7370616E3E3C62723E4C616E6420547970653A203C7370616E207374796C653D22666F6E742D7765696768743A20626F6C643B223E247B6C616E64747970657D3C2F7370616E3E3C2F6469763E602C4C2E70';
wwv_flow_imp.g_varchar2_table(23) := '6F70757028292E7365744C61744C6E67285B6E2C745D292E736574436F6E74656E742861292E6F70656E4F6E2869297D29297D6361746368286E297B7D7D7D3B';
null;
end;
/
begin
wwv_flow_imp_shared.create_plugin_file(
p_id=>wwv_flow_imp.id(84294829526041444184)
,p_plugin_id=>wwv_flow_imp.id(82770889312155439677)
,p_file_name=>'picker.min.js'
,p_mime_type=>'text/javascript'
,p_file_charset=>'utf-8'
,p_file_content=>wwv_flow_imp.varchar2_to_blob(wwv_flow_imp.g_varchar2_table)
);
end;
/
prompt --application/end_environment
begin
wwv_flow_imp.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