begin
wwv_flow_imp_shared.create_plugin_file(
 p_id=>wwv_flow_imp.id(51825846878691890991)
,p_plugin_id=>wwv_flow_imp.id(51863982453698216845)
,p_file_name=>'lib/codemirror/codemirror.css'
,p_mime_type=>'text/css'
,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) := '2E436F64654D6972726F722D68696E7473207B0A2020706F736974696F6E3A206162736F6C7574653B0A20207A2D696E6465783A2031303B0A20206F766572666C6F773A2068696464656E3B0A20206C6973742D7374796C653A206E6F6E653B0A0A2020';
wwv_flow_imp.g_varchar2_table(2) := '6D617267696E3A20303B0A202070616464696E673A203270783B0A0A20202D7765626B69742D626F782D736861646F773A203270782033707820357078207267626128302C302C302C2E32293B0A20202D6D6F7A2D626F782D736861646F773A20327078';
wwv_flow_imp.g_varchar2_table(3) := '2033707820357078207267626128302C302C302C2E32293B0A2020626F782D736861646F773A203270782033707820357078207267626128302C302C302C2E32293B0A2020626F726465722D7261646975733A203370783B0A2020626F726465723A2031';
wwv_flow_imp.g_varchar2_table(4) := '707820736F6C69642073696C7665723B0A0A20206261636B67726F756E643A2077686974653B0A2020666F6E742D73697A653A203930253B0A2020666F6E742D66616D696C793A206D6F6E6F73706163653B0A0A20206D61782D6865696768743A203230';
wwv_flow_imp.g_varchar2_table(5) := '656D3B0A20206F766572666C6F772D793A206175746F3B0A7D0A0A2E436F64654D6972726F722D68696E74207B0A20206D617267696E3A20303B0A202070616464696E673A2030203470783B0A2020626F726465722D7261646975733A203270783B0A20';
wwv_flow_imp.g_varchar2_table(6) := '2077686974652D73706163653A207072653B0A2020636F6C6F723A20626C61636B3B0A2020637572736F723A20706F696E7465723B0A7D0A0A6C692E436F64654D6972726F722D68696E742D616374697665207B0A20206261636B67726F756E643A2023';
wwv_flow_imp.g_varchar2_table(7) := '3038663B0A2020636F6C6F723A2077686974653B0A7D0A';
end;
/
begin
wwv_flow_imp_shared.create_plugin_file(
 p_id=>wwv_flow_imp.id(51825847306520890997)
,p_plugin_id=>wwv_flow_imp.id(51863982453698216845)
,p_file_name=>'lib/codemirror/addon/hint/show-hint.css'
,p_mime_type=>'text/css'
,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) := '2F2F20436F64654D6972726F722C20636F7079726967687420286329206279204D6172696A6E20486176657262656B6520616E64206F74686572730A2F2F20446973747269627574656420756E64657220616E204D4954206C6963656E73653A20687474';
wwv_flow_imp.g_varchar2_table(2) := '703A2F2F636F64656D6972726F722E6E65742F4C4943454E53450A0A2866756E6374696F6E286D6F6429207B0A202069662028747970656F66206578706F727473203D3D20226F626A6563742220262620747970656F66206D6F64756C65203D3D20226F';
wwv_flow_imp.g_varchar2_table(3) := '626A6563742229202F2F20436F6D6D6F6E4A530A202020206D6F64287265717569726528222E2E2F2E2E2F6C69622F636F64656D6972726F722229293B0A2020656C73652069662028747970656F6620646566696E65203D3D202266756E6374696F6E22';
wwv_flow_imp.g_varchar2_table(4) := '20262620646566696E652E616D6429202F2F20414D440A20202020646566696E65285B222E2E2F2E2E2F6C69622F636F64656D6972726F72225D2C206D6F64293B0A2020656C7365202F2F20506C61696E2062726F7773657220656E760A202020206D6F';
wwv_flow_imp.g_varchar2_table(5) := '6428436F64654D6972726F72293B0A7D292866756E6374696F6E28436F64654D6972726F7229207B0A20202275736520737472696374223B0A0A20207661722048494E545F454C454D454E545F434C41535320202020202020203D2022436F64654D6972';
wwv_flow_imp.g_varchar2_table(6) := '726F722D68696E74223B0A2020766172204143544956455F48494E545F454C454D454E545F434C415353203D2022436F64654D6972726F722D68696E742D616374697665223B0A0A20202F2F205468697320697320746865206F6C6420696E7465726661';
wwv_flow_imp.g_varchar2_table(7) := '63652C206B6570742061726F756E6420666F72206E6F7720746F20737461790A20202F2F206261636B77617264732D636F6D70617469626C652E0A2020436F64654D6972726F722E73686F7748696E74203D2066756E6374696F6E28636D2C2067657448';
wwv_flow_imp.g_varchar2_table(8) := '696E74732C206F7074696F6E7329207B0A20202020696620282167657448696E7473292072657475726E20636D2E73686F7748696E74286F7074696F6E73293B0A20202020696620286F7074696F6E73202626206F7074696F6E732E6173796E63292067';
wwv_flow_imp.g_varchar2_table(9) := '657448696E74732E6173796E63203D20747275653B0A20202020766172206E65774F707473203D207B68696E743A2067657448696E74737D3B0A20202020696620286F7074696F6E732920666F7220287661722070726F7020696E206F7074696F6E7329';
wwv_flow_imp.g_varchar2_table(10) := '206E65774F7074735B70726F705D203D206F7074696F6E735B70726F705D3B0A2020202072657475726E20636D2E73686F7748696E74286E65774F707473293B0A20207D3B0A0A2020436F64654D6972726F722E646566696E65457874656E73696F6E28';
wwv_flow_imp.g_varchar2_table(11) := '2273686F7748696E74222C2066756E6374696F6E286F7074696F6E7329207B0A202020206F7074696F6E73203D2070617273654F7074696F6E7328746869732C20746869732E676574437572736F722822737461727422292C206F7074696F6E73293B0A';
wwv_flow_imp.g_varchar2_table(12) := '202020207661722073656C656374696F6E73203D20746869732E6C69737453656C656374696F6E7328290A202020206966202873656C656374696F6E732E6C656E677468203E2031292072657475726E3B0A202020202F2F2042792064656661756C742C';
wwv_flow_imp.g_varchar2_table(13) := '20646F6E277420616C6C6F7720636F6D706C6574696F6E207768656E20736F6D657468696E672069732073656C65637465642E0A202020202F2F20412068696E742066756E6374696F6E2063616E206861766520612060737570706F72747353656C6563';
wwv_flow_imp.g_varchar2_table(14) := '74696F6E602070726F706572747920746F0A202020202F2F20696E64696361746520746861742069742063616E2068616E646C652073656C656374696F6E732E0A2020202069662028746869732E736F6D657468696E6753656C6563746564282929207B';
wwv_flow_imp.g_varchar2_table(15) := '0A20202020202069662028216F7074696F6E732E68696E742E737570706F72747353656C656374696F6E292072657475726E3B0A2020202020202F2F20446F6E27742074727920776974682063726F73732D6C696E652073656C656374696F6E730A2020';
wwv_flow_imp.g_varchar2_table(16) := '20202020666F7220287661722069203D20303B2069203C2073656C656374696F6E732E6C656E6774683B20692B2B290A20202020202020206966202873656C656374696F6E735B695D2E686561642E6C696E6520213D2073656C656374696F6E735B695D';
wwv_flow_imp.g_varchar2_table(17) := '2E616E63686F722E6C696E65292072657475726E3B0A202020207D0A0A2020202069662028746869732E73746174652E636F6D706C6574696F6E4163746976652920746869732E73746174652E636F6D706C6574696F6E4163746976652E636C6F736528';
wwv_flow_imp.g_varchar2_table(18) := '293B0A2020202076617220636F6D706C6574696F6E203D20746869732E73746174652E636F6D706C6574696F6E416374697665203D206E657720436F6D706C6574696F6E28746869732C206F7074696F6E73293B0A202020206966202821636F6D706C65';
wwv_flow_imp.g_varchar2_table(19) := '74696F6E2E6F7074696F6E732E68696E74292072657475726E3B0A0A20202020436F64654D6972726F722E7369676E616C28746869732C20227374617274436F6D706C6574696F6E222C2074686973293B0A20202020636F6D706C6574696F6E2E757064';
wwv_flow_imp.g_varchar2_table(20) := '6174652874727565293B0A20207D293B0A0A202066756E6374696F6E20436F6D706C6574696F6E28636D2C206F7074696F6E7329207B0A20202020746869732E636D203D20636D3B0A20202020746869732E6F7074696F6E73203D206F7074696F6E733B';
wwv_flow_imp.g_varchar2_table(21) := '0A20202020746869732E776964676574203D206E756C6C3B0A20202020746869732E6465626F756E6365203D20303B0A20202020746869732E7469636B203D20303B0A20202020746869732E7374617274506F73203D20746869732E636D2E6765744375';
wwv_flow_imp.g_varchar2_table(22) := '72736F722822737461727422293B0A20202020746869732E73746172744C656E203D20746869732E636D2E6765744C696E6528746869732E7374617274506F732E6C696E65292E6C656E677468202D20746869732E636D2E67657453656C656374696F6E';
wwv_flow_imp.g_varchar2_table(23) := '28292E6C656E6774683B0A0A202020207661722073656C66203D20746869733B0A20202020636D2E6F6E2822637572736F724163746976697479222C20746869732E616374697669747946756E63203D2066756E6374696F6E2829207B2073656C662E63';
wwv_flow_imp.g_varchar2_table(24) := '7572736F72416374697669747928293B207D293B0A20207D0A0A20207661722072657175657374416E696D6174696F6E4672616D65203D2077696E646F772E72657175657374416E696D6174696F6E4672616D65207C7C2066756E6374696F6E28666E29';
wwv_flow_imp.g_varchar2_table(25) := '207B0A2020202072657475726E2073657454696D656F757428666E2C20313030302F3630293B0A20207D3B0A20207661722063616E63656C416E696D6174696F6E4672616D65203D2077696E646F772E63616E63656C416E696D6174696F6E4672616D65';
wwv_flow_imp.g_varchar2_table(26) := '207C7C20636C65617254696D656F75743B0A0A2020436F6D706C6574696F6E2E70726F746F74797065203D207B0A20202020636C6F73653A2066756E6374696F6E2829207B0A2020202020206966202821746869732E6163746976652829292072657475';
wwv_flow_imp.g_varchar2_table(27) := '726E3B0A202020202020746869732E636D2E73746174652E636F6D706C6574696F6E416374697665203D206E756C6C3B0A202020202020746869732E7469636B203D206E756C6C3B0A202020202020746869732E636D2E6F66662822637572736F724163';
wwv_flow_imp.g_varchar2_table(28) := '746976697479222C20746869732E616374697669747946756E63293B0A0A20202020202069662028746869732E77696467657420262620746869732E646174612920436F64654D6972726F722E7369676E616C28746869732E646174612C2022636C6F73';
wwv_flow_imp.g_varchar2_table(29) := '6522293B0A20202020202069662028746869732E7769646765742920746869732E7769646765742E636C6F736528293B0A202020202020436F64654D6972726F722E7369676E616C28746869732E636D2C2022656E64436F6D706C6574696F6E222C2074';
wwv_flow_imp.g_varchar2_table(30) := '6869732E636D293B0A202020207D2C0A0A202020206163746976653A2066756E6374696F6E2829207B0A20202020202072657475726E20746869732E636D2E73746174652E636F6D706C6574696F6E416374697665203D3D20746869733B0A202020207D';
wwv_flow_imp.g_varchar2_table(31) := '2C0A0A202020207069636B3A2066756E6374696F6E28646174612C206929207B0A20202020202076617220636F6D706C6574696F6E203D20646174612E6C6973745B695D3B0A20202020202069662028636F6D706C6574696F6E2E68696E742920636F6D';
wwv_flow_imp.g_varchar2_table(32) := '706C6574696F6E2E68696E7428746869732E636D2C20646174612C20636F6D706C6574696F6E293B0A202020202020656C736520746869732E636D2E7265706C61636552616E6765286765745465787428636F6D706C6574696F6E292C20636F6D706C65';
wwv_flow_imp.g_varchar2_table(33) := '74696F6E2E66726F6D207C7C20646174612E66726F6D2C0A2020202020202020202020202020202020202020202020202020202020202020636F6D706C6574696F6E2E746F207C7C20646174612E746F2C2022636F6D706C65746522293B0A2020202020';
wwv_flow_imp.g_varchar2_table(34) := '20436F64654D6972726F722E7369676E616C28646174612C20227069636B222C20636F6D706C6574696F6E293B0A202020202020746869732E636C6F736528293B0A202020207D2C0A0A20202020637572736F7241637469766974793A2066756E637469';
wwv_flow_imp.g_varchar2_table(35) := '6F6E2829207B0A20202020202069662028746869732E6465626F756E636529207B0A202020202020202063616E63656C416E696D6174696F6E4672616D6528746869732E6465626F756E6365293B0A2020202020202020746869732E6465626F756E6365';
wwv_flow_imp.g_varchar2_table(36) := '203D20303B0A2020202020207D0A0A20202020202076617220706F73203D20746869732E636D2E676574437572736F7228292C206C696E65203D20746869732E636D2E6765744C696E6528706F732E6C696E65293B0A20202020202069662028706F732E';
wwv_flow_imp.g_varchar2_table(37) := '6C696E6520213D20746869732E7374617274506F732E6C696E65207C7C206C696E652E6C656E677468202D20706F732E636820213D20746869732E73746172744C656E202D20746869732E7374617274506F732E6368207C7C0A20202020202020202020';
wwv_flow_imp.g_varchar2_table(38) := '706F732E6368203C20746869732E7374617274506F732E6368207C7C20746869732E636D2E736F6D657468696E6753656C65637465642829207C7C0A202020202020202020202821706F732E6368207C7C20746869732E6F7074696F6E732E636C6F7365';
wwv_flow_imp.g_varchar2_table(39) := '436861726163746572732E74657374286C696E652E63686172417428706F732E6368202D203129292929207B0A2020202020202020746869732E636C6F736528293B0A2020202020207D20656C7365207B0A20202020202020207661722073656C66203D';
wwv_flow_imp.g_varchar2_table(40) := '20746869733B0A2020202020202020746869732E6465626F756E6365203D2072657175657374416E696D6174696F6E4672616D652866756E6374696F6E2829207B73656C662E75706461746528293B7D293B0A202020202020202069662028746869732E';
wwv_flow_imp.g_varchar2_table(41) := '7769646765742920746869732E7769646765742E64697361626C6528293B0A2020202020207D0A202020207D2C0A0A202020207570646174653A2066756E6374696F6E28666972737429207B0A20202020202069662028746869732E7469636B203D3D20';
wwv_flow_imp.g_varchar2_table(42) := '6E756C6C292072657475726E0A2020202020207661722073656C66203D20746869732C206D795469636B203D202B2B746869732E7469636B0A202020202020666574636848696E747328746869732E6F7074696F6E732E68696E742C20746869732E636D';
wwv_flow_imp.g_varchar2_table(43) := '2C20746869732E6F7074696F6E732C2066756E6374696F6E286461746129207B0A20202020202020206966202873656C662E7469636B203D3D206D795469636B292073656C662E66696E69736855706461746528646174612C206669727374290A202020';
wwv_flow_imp.g_varchar2_table(44) := '2020207D290A202020207D2C0A0A2020202066696E6973685570646174653A2066756E6374696F6E28646174612C20666972737429207B0A20202020202069662028746869732E646174612920436F64654D6972726F722E7369676E616C28746869732E';
wwv_flow_imp.g_varchar2_table(45) := '646174612C202275706461746522293B0A0A202020202020766172207069636B6564203D2028746869732E77696467657420262620746869732E7769646765742E7069636B656429207C7C2028666972737420262620746869732E6F7074696F6E732E63';
wwv_flow_imp.g_varchar2_table(46) := '6F6D706C65746553696E676C65293B0A20202020202069662028746869732E7769646765742920746869732E7769646765742E636C6F736528293B0A0A202020202020746869732E64617461203D20646174613B0A0A2020202020206966202864617461';
wwv_flow_imp.g_varchar2_table(47) := '20262620646174612E6C6973742E6C656E67746829207B0A2020202020202020696620287069636B656420262620646174612E6C6973742E6C656E677468203D3D203129207B0A20202020202020202020746869732E7069636B28646174612C2030293B';
wwv_flow_imp.g_varchar2_table(48) := '0A20202020202020207D20656C7365207B0A20202020202020202020746869732E776964676574203D206E65772057696467657428746869732C2064617461293B0A20202020202020202020436F64654D6972726F722E7369676E616C28646174612C20';
wwv_flow_imp.g_varchar2_table(49) := '2273686F776E22293B0A20202020202020207D0A2020202020207D0A202020207D0A20207D3B0A0A202066756E6374696F6E2070617273654F7074696F6E7328636D2C20706F732C206F7074696F6E7329207B0A2020202076617220656469746F72203D';
wwv_flow_imp.g_varchar2_table(50) := '20636D2E6F7074696F6E732E68696E744F7074696F6E733B0A20202020766172206F7574203D207B7D3B0A20202020666F7220287661722070726F7020696E2064656661756C744F7074696F6E7329206F75745B70726F705D203D2064656661756C744F';
wwv_flow_imp.g_varchar2_table(51) := '7074696F6E735B70726F705D3B0A2020202069662028656469746F722920666F7220287661722070726F7020696E20656469746F72290A20202020202069662028656469746F725B70726F705D20213D3D20756E646566696E656429206F75745B70726F';
wwv_flow_imp.g_varchar2_table(52) := '705D203D20656469746F725B70726F705D3B0A20202020696620286F7074696F6E732920666F7220287661722070726F7020696E206F7074696F6E73290A202020202020696620286F7074696F6E735B70726F705D20213D3D20756E646566696E656429';
wwv_flow_imp.g_varchar2_table(53) := '206F75745B70726F705D203D206F7074696F6E735B70726F705D3B0A20202020696620286F75742E68696E742E7265736F6C766529206F75742E68696E74203D206F75742E68696E742E7265736F6C766528636D2C20706F73290A202020207265747572';
wwv_flow_imp.g_varchar2_table(54) := '6E206F75743B0A20207D0A0A202066756E6374696F6E206765745465787428636F6D706C6574696F6E29207B0A2020202069662028747970656F6620636F6D706C6574696F6E203D3D2022737472696E6722292072657475726E20636F6D706C6574696F';
wwv_flow_imp.g_varchar2_table(55) := '6E3B0A20202020656C73652072657475726E20636F6D706C6574696F6E2E746578743B0A20207D0A0A202066756E6374696F6E206275696C644B65794D617028636F6D706C6574696F6E2C2068616E646C6529207B0A2020202076617220626173654D61';
wwv_flow_imp.g_varchar2_table(56) := '70203D207B0A20202020202055703A2066756E6374696F6E2829207B68616E646C652E6D6F7665466F637573282D31293B7D2C0A202020202020446F776E3A2066756E6374696F6E2829207B68616E646C652E6D6F7665466F6375732831293B7D2C0A20';
wwv_flow_imp.g_varchar2_table(57) := '20202020205061676555703A2066756E6374696F6E2829207B68616E646C652E6D6F7665466F637573282D68616E646C652E6D656E7553697A652829202B20312C2074727565293B7D2C0A20202020202050616765446F776E3A2066756E6374696F6E28';
wwv_flow_imp.g_varchar2_table(58) := '29207B68616E646C652E6D6F7665466F6375732868616E646C652E6D656E7553697A652829202D20312C2074727565293B7D2C0A202020202020486F6D653A2066756E6374696F6E2829207B68616E646C652E736574466F6375732830293B7D2C0A2020';
wwv_flow_imp.g_varchar2_table(59) := '20202020456E643A2066756E6374696F6E2829207B68616E646C652E736574466F6375732868616E646C652E6C656E677468202D2031293B7D2C0A202020202020456E7465723A2068616E646C652E7069636B2C0A2020202020205461623A2068616E64';
wwv_flow_imp.g_varchar2_table(60) := '6C652E7069636B2C0A2020202020204573633A2068616E646C652E636C6F73650A202020207D3B0A2020202076617220637573746F6D203D20636F6D706C6574696F6E2E6F7074696F6E732E637573746F6D4B6579733B0A20202020766172206F75724D';
wwv_flow_imp.g_varchar2_table(61) := '6170203D20637573746F6D203F207B7D203A20626173654D61703B0A2020202066756E6374696F6E2061646442696E64696E67286B65792C2076616C29207B0A20202020202076617220626F756E643B0A20202020202069662028747970656F66207661';
wwv_flow_imp.g_varchar2_table(62) := '6C20213D2022737472696E6722290A2020202020202020626F756E64203D2066756E6374696F6E28636D29207B2072657475726E2076616C28636D2C2068616E646C65293B207D3B0A2020202020202F2F2054686973206D656368616E69736D20697320';
wwv_flow_imp.g_varchar2_table(63) := '646570726563617465640A202020202020656C73652069662028626173654D61702E6861734F776E50726F70657274792876616C29290A2020202020202020626F756E64203D20626173654D61705B76616C5D3B0A202020202020656C73650A20202020';
wwv_flow_imp.g_varchar2_table(64) := '20202020626F756E64203D2076616C3B0A2020202020206F75724D61705B6B65795D203D20626F756E643B0A202020207D0A2020202069662028637573746F6D290A202020202020666F722028766172206B657920696E20637573746F6D292069662028';
wwv_flow_imp.g_varchar2_table(65) := '637573746F6D2E6861734F776E50726F7065727479286B657929290A202020202020202061646442696E64696E67286B65792C20637573746F6D5B6B65795D293B0A20202020766172206578747261203D20636F6D706C6574696F6E2E6F7074696F6E73';
wwv_flow_imp.g_varchar2_table(66) := '2E65787472614B6579733B0A20202020696620286578747261290A202020202020666F722028766172206B657920696E20657874726129206966202865787472612E6861734F776E50726F7065727479286B657929290A20202020202020206164644269';
wwv_flow_imp.g_varchar2_table(67) := '6E64696E67286B65792C2065787472615B6B65795D293B0A2020202072657475726E206F75724D61703B0A20207D0A0A202066756E6374696F6E2067657448696E74456C656D656E742868696E7473456C656D656E742C20656C29207B0A202020207768';
wwv_flow_imp.g_varchar2_table(68) := '696C652028656C20262620656C20213D2068696E7473456C656D656E7429207B0A20202020202069662028656C2E6E6F64654E616D652E746F5570706572436173652829203D3D3D20224C492220262620656C2E706172656E744E6F6465203D3D206869';
wwv_flow_imp.g_varchar2_table(69) := '6E7473456C656D656E74292072657475726E20656C3B0A202020202020656C203D20656C2E706172656E744E6F64653B0A202020207D0A20207D0A0A202066756E6374696F6E2057696467657428636F6D706C6574696F6E2C206461746129207B0A2020';
wwv_flow_imp.g_varchar2_table(70) := '2020746869732E636F6D706C6574696F6E203D20636F6D706C6574696F6E3B0A20202020746869732E64617461203D20646174613B0A20202020746869732E7069636B6564203D2066616C73653B0A2020202076617220776964676574203D2074686973';
wwv_flow_imp.g_varchar2_table(71) := '2C20636D203D20636F6D706C6574696F6E2E636D3B0A0A202020207661722068696E7473203D20746869732E68696E7473203D20646F63756D656E742E637265617465456C656D656E742822756C22293B0A20202020766172207468656D65203D20636F';
wwv_flow_imp.g_varchar2_table(72) := '6D706C6574696F6E2E636D2E6F7074696F6E732E7468656D653B0A2020202068696E74732E636C6173734E616D65203D2022436F64654D6972726F722D68696E74732022202B207468656D653B0A20202020746869732E73656C656374656448696E7420';
wwv_flow_imp.g_varchar2_table(73) := '3D20646174612E73656C656374656448696E74207C7C20303B0A0A2020202076617220636F6D706C6574696F6E73203D20646174612E6C6973743B0A20202020666F7220287661722069203D20303B2069203C20636F6D706C6574696F6E732E6C656E67';
wwv_flow_imp.g_varchar2_table(74) := '74683B202B2B6929207B0A20202020202076617220656C74203D2068696E74732E617070656E644368696C6428646F63756D656E742E637265617465456C656D656E7428226C692229292C20637572203D20636F6D706C6574696F6E735B695D3B0A2020';
wwv_flow_imp.g_varchar2_table(75) := '2020202076617220636C6173734E616D65203D2048494E545F454C454D454E545F434C415353202B20286920213D20746869732E73656C656374656448696E74203F202222203A20222022202B204143544956455F48494E545F454C454D454E545F434C';
wwv_flow_imp.g_varchar2_table(76) := '415353293B0A202020202020696620286375722E636C6173734E616D6520213D206E756C6C2920636C6173734E616D65203D206375722E636C6173734E616D65202B20222022202B20636C6173734E616D653B0A202020202020656C742E636C6173734E';
wwv_flow_imp.g_varchar2_table(77) := '616D65203D20636C6173734E616D653B0A202020202020696620286375722E72656E64657229206375722E72656E64657228656C742C20646174612C20637572293B0A202020202020656C736520656C742E617070656E644368696C6428646F63756D65';
wwv_flow_imp.g_varchar2_table(78) := '6E742E637265617465546578744E6F6465286375722E646973706C617954657874207C7C2067657454657874286375722929293B0A202020202020656C742E68696E744964203D20693B0A202020207D0A0A2020202076617220706F73203D20636D2E63';
wwv_flow_imp.g_varchar2_table(79) := '7572736F72436F6F72647328636F6D706C6574696F6E2E6F7074696F6E732E616C69676E57697468576F7264203F20646174612E66726F6D203A206E756C6C293B0A20202020766172206C656674203D20706F732E6C6566742C20746F70203D20706F73';
wwv_flow_imp.g_varchar2_table(80) := '2E626F74746F6D2C2062656C6F77203D20747275653B0A2020202068696E74732E7374796C652E6C656674203D206C656674202B20227078223B0A2020202068696E74732E7374796C652E746F70203D20746F70202B20227078223B0A202020202F2F20';
wwv_flow_imp.g_varchar2_table(81) := '4966207765277265206174207468652065646765206F66207468652073637265656E2C207468656E2077652077616E7420746865206D656E7520746F20617070656172206F6E20746865206C656674206F662074686520637572736F722E0A2020202076';
wwv_flow_imp.g_varchar2_table(82) := '61722077696E57203D2077696E646F772E696E6E65725769647468207C7C204D6174682E6D617828646F63756D656E742E626F64792E6F666673657457696474682C20646F63756D656E742E646F63756D656E74456C656D656E742E6F66667365745769';
wwv_flow_imp.g_varchar2_table(83) := '647468293B0A202020207661722077696E48203D2077696E646F772E696E6E6572486569676874207C7C204D6174682E6D617828646F63756D656E742E626F64792E6F66667365744865696768742C20646F63756D656E742E646F63756D656E74456C65';
wwv_flow_imp.g_varchar2_table(84) := '6D656E742E6F6666736574486569676874293B0A2020202028636F6D706C6574696F6E2E6F7074696F6E732E636F6E7461696E6572207C7C20646F63756D656E742E626F6479292E617070656E644368696C642868696E7473293B0A2020202076617220';
wwv_flow_imp.g_varchar2_table(85) := '626F78203D2068696E74732E676574426F756E64696E67436C69656E745265637428292C206F7665726C617059203D20626F782E626F74746F6D202D2077696E483B0A20202020766172207363726F6C6C73203D2068696E74732E7363726F6C6C486569';
wwv_flow_imp.g_varchar2_table(86) := '676874203E2068696E74732E636C69656E74486569676874202B20310A202020207661722073746172745363726F6C6C203D20636D2E6765745363726F6C6C496E666F28293B0A0A20202020696620286F7665726C617059203E203029207B0A20202020';
wwv_flow_imp.g_varchar2_table(87) := '202076617220686569676874203D20626F782E626F74746F6D202D20626F782E746F702C20637572546F70203D20706F732E746F70202D2028706F732E626F74746F6D202D20626F782E746F70293B0A20202020202069662028637572546F70202D2068';
wwv_flow_imp.g_varchar2_table(88) := '6569676874203E203029207B202F2F20466974732061626F766520637572736F720A202020202020202068696E74732E7374796C652E746F70203D2028746F70203D20706F732E746F70202D2068656967687429202B20227078223B0A20202020202020';
wwv_flow_imp.g_varchar2_table(89) := '2062656C6F77203D2066616C73653B0A2020202020207D20656C73652069662028686569676874203E2077696E4829207B0A202020202020202068696E74732E7374796C652E686569676874203D202877696E48202D203529202B20227078223B0A2020';
wwv_flow_imp.g_varchar2_table(90) := '20202020202068696E74732E7374796C652E746F70203D2028746F70203D20706F732E626F74746F6D202D20626F782E746F7029202B20227078223B0A202020202020202076617220637572736F72203D20636D2E676574437572736F7228293B0A2020';
wwv_flow_imp.g_varchar2_table(91) := '20202020202069662028646174612E66726F6D2E636820213D20637572736F722E636829207B0A20202020202020202020706F73203D20636D2E637572736F72436F6F72647328637572736F72293B0A2020202020202020202068696E74732E7374796C';
wwv_flow_imp.g_varchar2_table(92) := '652E6C656674203D20286C656674203D20706F732E6C65667429202B20227078223B0A20202020202020202020626F78203D2068696E74732E676574426F756E64696E67436C69656E745265637428293B0A20202020202020207D0A2020202020207D0A';
wwv_flow_imp.g_varchar2_table(93) := '202020207D0A20202020766172206F7665726C617058203D20626F782E7269676874202D2077696E573B0A20202020696620286F7665726C617058203E203029207B0A20202020202069662028626F782E7269676874202D20626F782E6C656674203E20';
wwv_flow_imp.g_varchar2_table(94) := '77696E5729207B0A202020202020202068696E74732E7374796C652E7769647468203D202877696E57202D203529202B20227078223B0A20202020202020206F7665726C617058202D3D2028626F782E7269676874202D20626F782E6C65667429202D20';
wwv_flow_imp.g_varchar2_table(95) := '77696E573B0A2020202020207D0A20202020202068696E74732E7374796C652E6C656674203D20286C656674203D20706F732E6C656674202D206F7665726C61705829202B20227078223B0A202020207D0A20202020696620287363726F6C6C73292066';
wwv_flow_imp.g_varchar2_table(96) := '6F722028766172206E6F6465203D2068696E74732E66697273744368696C643B206E6F64653B206E6F6465203D206E6F64652E6E6578745369626C696E67290A2020202020206E6F64652E7374796C652E70616464696E675269676874203D20636D2E64';
wwv_flow_imp.g_varchar2_table(97) := '6973706C61792E6E61746976654261725769647468202B20227078220A0A20202020636D2E6164644B65794D617028746869732E6B65794D6170203D206275696C644B65794D617028636F6D706C6574696F6E2C207B0A2020202020206D6F7665466F63';
wwv_flow_imp.g_varchar2_table(98) := '75733A2066756E6374696F6E286E2C2061766F69645772617029207B207769646765742E6368616E6765416374697665287769646765742E73656C656374656448696E74202B206E2C2061766F696457726170293B207D2C0A202020202020736574466F';
wwv_flow_imp.g_varchar2_table(99) := '6375733A2066756E6374696F6E286E29207B207769646765742E6368616E6765416374697665286E293B207D2C0A2020202020206D656E7553697A653A2066756E6374696F6E2829207B2072657475726E207769646765742E73637265656E416D6F756E';
wwv_flow_imp.g_varchar2_table(100) := '7428293B207D2C0A2020202020206C656E6774683A20636F6D706C6574696F6E732E6C656E6774682C0A202020202020636C6F73653A2066756E6374696F6E2829207B20636F6D706C6574696F6E2E636C6F736528293B207D2C0A202020202020706963';
wwv_flow_imp.g_varchar2_table(101) := '6B3A2066756E6374696F6E2829207B207769646765742E7069636B28293B207D2C0A202020202020646174613A20646174610A202020207D29293B0A0A2020202069662028636F6D706C6574696F6E2E6F7074696F6E732E636C6F73654F6E556E666F63';
wwv_flow_imp.g_varchar2_table(102) := '757329207B0A20202020202076617220636C6F73696E674F6E426C75723B0A202020202020636D2E6F6E2822626C7572222C20746869732E6F6E426C7572203D2066756E6374696F6E2829207B20636C6F73696E674F6E426C7572203D2073657454696D';
wwv_flow_imp.g_varchar2_table(103) := '656F75742866756E6374696F6E2829207B20636F6D706C6574696F6E2E636C6F736528293B207D2C20313030293B207D293B0A202020202020636D2E6F6E2822666F637573222C20746869732E6F6E466F637573203D2066756E6374696F6E2829207B20';
wwv_flow_imp.g_varchar2_table(104) := '636C65617254696D656F757428636C6F73696E674F6E426C7572293B207D293B0A202020207D0A0A20202020636D2E6F6E28227363726F6C6C222C20746869732E6F6E5363726F6C6C203D2066756E6374696F6E2829207B0A2020202020207661722063';
wwv_flow_imp.g_varchar2_table(105) := '75725363726F6C6C203D20636D2E6765745363726F6C6C496E666F28292C20656469746F72203D20636D2E67657457726170706572456C656D656E7428292E676574426F756E64696E67436C69656E745265637428293B0A202020202020766172206E65';
wwv_flow_imp.g_varchar2_table(106) := '77546F70203D20746F70202B2073746172745363726F6C6C2E746F70202D206375725363726F6C6C2E746F703B0A20202020202076617220706F696E74203D206E6577546F70202D202877696E646F772E70616765594F6666736574207C7C2028646F63';
wwv_flow_imp.g_varchar2_table(107) := '756D656E742E646F63756D656E74456C656D656E74207C7C20646F63756D656E742E626F6479292E7363726F6C6C546F70293B0A202020202020696620282162656C6F772920706F696E74202B3D2068696E74732E6F66667365744865696768743B0A20';
wwv_flow_imp.g_varchar2_table(108) := '202020202069662028706F696E74203C3D20656469746F722E746F70207C7C20706F696E74203E3D20656469746F722E626F74746F6D292072657475726E20636F6D706C6574696F6E2E636C6F736528293B0A20202020202068696E74732E7374796C65';
wwv_flow_imp.g_varchar2_table(109) := '2E746F70203D206E6577546F70202B20227078223B0A20202020202068696E74732E7374796C652E6C656674203D20286C656674202B2073746172745363726F6C6C2E6C656674202D206375725363726F6C6C2E6C65667429202B20227078223B0A2020';
wwv_flow_imp.g_varchar2_table(110) := '20207D293B0A0A20202020436F64654D6972726F722E6F6E2868696E74732C202264626C636C69636B222C2066756E6374696F6E286529207B0A2020202020207661722074203D2067657448696E74456C656D656E742868696E74732C20652E74617267';
wwv_flow_imp.g_varchar2_table(111) := '6574207C7C20652E737263456C656D656E74293B0A202020202020696620287420262620742E68696E74496420213D206E756C6C29207B7769646765742E6368616E676541637469766528742E68696E744964293B207769646765742E7069636B28293B';
wwv_flow_imp.g_varchar2_table(112) := '7D0A202020207D293B0A0A20202020436F64654D6972726F722E6F6E2868696E74732C2022636C69636B222C2066756E6374696F6E286529207B0A2020202020207661722074203D2067657448696E74456C656D656E742868696E74732C20652E746172';
wwv_flow_imp.g_varchar2_table(113) := '676574207C7C20652E737263456C656D656E74293B0A202020202020696620287420262620742E68696E74496420213D206E756C6C29207B0A20202020202020207769646765742E6368616E676541637469766528742E68696E744964293B0A20202020';
wwv_flow_imp.g_varchar2_table(114) := '2020202069662028636F6D706C6574696F6E2E6F7074696F6E732E636F6D706C6574654F6E53696E676C65436C69636B29207769646765742E7069636B28293B0A2020202020207D0A202020207D293B0A0A20202020436F64654D6972726F722E6F6E28';
wwv_flow_imp.g_varchar2_table(115) := '68696E74732C20226D6F757365646F776E222C2066756E6374696F6E2829207B0A20202020202073657454696D656F75742866756E6374696F6E28297B636D2E666F63757328293B7D2C203230293B0A202020207D293B0A0A20202020436F64654D6972';
wwv_flow_imp.g_varchar2_table(116) := '726F722E7369676E616C28646174612C202273656C656374222C20636F6D706C6574696F6E735B746869732E73656C656374656448696E745D2C2068696E74732E6368696C644E6F6465735B746869732E73656C656374656448696E745D293B0A202020';
wwv_flow_imp.g_varchar2_table(117) := '2072657475726E20747275653B0A20207D0A0A20205769646765742E70726F746F74797065203D207B0A20202020636C6F73653A2066756E6374696F6E2829207B0A20202020202069662028746869732E636F6D706C6574696F6E2E7769646765742021';
wwv_flow_imp.g_varchar2_table(118) := '3D2074686973292072657475726E3B0A202020202020746869732E636F6D706C6574696F6E2E776964676574203D206E756C6C3B0A202020202020746869732E68696E74732E706172656E744E6F64652E72656D6F76654368696C6428746869732E6869';
wwv_flow_imp.g_varchar2_table(119) := '6E7473293B0A202020202020746869732E636F6D706C6574696F6E2E636D2E72656D6F76654B65794D617028746869732E6B65794D6170293B0A0A20202020202076617220636D203D20746869732E636F6D706C6574696F6E2E636D3B0A202020202020';
wwv_flow_imp.g_varchar2_table(120) := '69662028746869732E636F6D706C6574696F6E2E6F7074696F6E732E636C6F73654F6E556E666F63757329207B0A2020202020202020636D2E6F66662822626C7572222C20746869732E6F6E426C7572293B0A2020202020202020636D2E6F6666282266';
wwv_flow_imp.g_varchar2_table(121) := '6F637573222C20746869732E6F6E466F637573293B0A2020202020207D0A202020202020636D2E6F666628227363726F6C6C222C20746869732E6F6E5363726F6C6C293B0A202020207D2C0A0A2020202064697361626C653A2066756E6374696F6E2829';
wwv_flow_imp.g_varchar2_table(122) := '207B0A202020202020746869732E636F6D706C6574696F6E2E636D2E72656D6F76654B65794D617028746869732E6B65794D6170293B0A20202020202076617220776964676574203D20746869733B0A202020202020746869732E6B65794D6170203D20';
wwv_flow_imp.g_varchar2_table(123) := '7B456E7465723A2066756E6374696F6E2829207B207769646765742E7069636B6564203D20747275653B207D7D3B0A202020202020746869732E636F6D706C6574696F6E2E636D2E6164644B65794D617028746869732E6B65794D6170293B0A20202020';
wwv_flow_imp.g_varchar2_table(124) := '7D2C0A0A202020207069636B3A2066756E6374696F6E2829207B0A202020202020746869732E636F6D706C6574696F6E2E7069636B28746869732E646174612C20746869732E73656C656374656448696E74293B0A202020207D2C0A0A20202020636861';
wwv_flow_imp.g_varchar2_table(125) := '6E67654163746976653A2066756E6374696F6E28692C2061766F69645772617029207B0A2020202020206966202869203E3D20746869732E646174612E6C6973742E6C656E677468290A202020202020202069203D2061766F696457726170203F207468';
wwv_flow_imp.g_varchar2_table(126) := '69732E646174612E6C6973742E6C656E677468202D2031203A20303B0A202020202020656C7365206966202869203C2030290A202020202020202069203D2061766F696457726170203F203020203A20746869732E646174612E6C6973742E6C656E6774';
wwv_flow_imp.g_varchar2_table(127) := '68202D20313B0A20202020202069662028746869732E73656C656374656448696E74203D3D2069292072657475726E3B0A202020202020766172206E6F6465203D20746869732E68696E74732E6368696C644E6F6465735B746869732E73656C65637465';
wwv_flow_imp.g_varchar2_table(128) := '6448696E745D3B0A202020202020696620286E6F646529206E6F64652E636C6173734E616D65203D206E6F64652E636C6173734E616D652E7265706C61636528222022202B204143544956455F48494E545F454C454D454E545F434C4153532C20222229';
wwv_flow_imp.g_varchar2_table(129) := '3B0A2020202020206E6F6465203D20746869732E68696E74732E6368696C644E6F6465735B746869732E73656C656374656448696E74203D20695D3B0A2020202020206E6F64652E636C6173734E616D65202B3D20222022202B204143544956455F4849';
wwv_flow_imp.g_varchar2_table(130) := '4E545F454C454D454E545F434C4153533B0A202020202020696620286E6F64652E6F6666736574546F70203C20746869732E68696E74732E7363726F6C6C546F70290A2020202020202020746869732E68696E74732E7363726F6C6C546F70203D206E6F';
wwv_flow_imp.g_varchar2_table(131) := '64652E6F6666736574546F70202D20333B0A202020202020656C736520696620286E6F64652E6F6666736574546F70202B206E6F64652E6F6666736574486569676874203E20746869732E68696E74732E7363726F6C6C546F70202B20746869732E6869';
wwv_flow_imp.g_varchar2_table(132) := '6E74732E636C69656E74486569676874290A2020202020202020746869732E68696E74732E7363726F6C6C546F70203D206E6F64652E6F6666736574546F70202B206E6F64652E6F6666736574486569676874202D20746869732E68696E74732E636C69';
wwv_flow_imp.g_varchar2_table(133) := '656E74486569676874202B20333B0A202020202020436F64654D6972726F722E7369676E616C28746869732E646174612C202273656C656374222C20746869732E646174612E6C6973745B746869732E73656C656374656448696E745D2C206E6F646529';
wwv_flow_imp.g_varchar2_table(134) := '3B0A202020207D2C0A0A2020202073637265656E416D6F756E743A2066756E6374696F6E2829207B0A20202020202072657475726E204D6174682E666C6F6F7228746869732E68696E74732E636C69656E74486569676874202F20746869732E68696E74';
wwv_flow_imp.g_varchar2_table(135) := '732E66697273744368696C642E6F666673657448656967687429207C7C20313B0A202020207D0A20207D3B0A0A202066756E6374696F6E206170706C696361626C6548656C7065727328636D2C2068656C7065727329207B0A202020206966202821636D';
wwv_flow_imp.g_varchar2_table(136) := '2E736F6D657468696E6753656C65637465642829292072657475726E2068656C706572730A2020202076617220726573756C74203D205B5D0A20202020666F7220287661722069203D20303B2069203C2068656C706572732E6C656E6774683B20692B2B';
wwv_flow_imp.g_varchar2_table(137) := '290A2020202020206966202868656C706572735B695D2E737570706F72747353656C656374696F6E2920726573756C742E707573682868656C706572735B695D290A2020202072657475726E20726573756C740A20207D0A0A202066756E6374696F6E20';
wwv_flow_imp.g_varchar2_table(138) := '666574636848696E74732868696E742C20636D2C206F7074696F6E732C2063616C6C6261636B29207B0A202020206966202868696E742E6173796E6329207B0A20202020202068696E7428636D2C2063616C6C6261636B2C206F7074696F6E73290A2020';
wwv_flow_imp.g_varchar2_table(139) := '20207D20656C7365207B0A20202020202076617220726573756C74203D2068696E7428636D2C206F7074696F6E73290A20202020202069662028726573756C7420262620726573756C742E7468656E2920726573756C742E7468656E2863616C6C626163';
wwv_flow_imp.g_varchar2_table(140) := '6B290A202020202020656C73652063616C6C6261636B28726573756C74290A202020207D0A20207D0A0A202066756E6374696F6E207265736F6C76654175746F48696E747328636D2C20706F7329207B0A202020207661722068656C70657273203D2063';
wwv_flow_imp.g_varchar2_table(141) := '6D2E67657448656C7065727328706F732C202268696E7422292C20776F7264730A202020206966202868656C706572732E6C656E67746829207B0A202020202020766172207265736F6C766564203D2066756E6374696F6E28636D2C2063616C6C626163';
wwv_flow_imp.g_varchar2_table(142) := '6B2C206F7074696F6E7329207B0A202020202020202076617220617070203D206170706C696361626C6548656C7065727328636D2C2068656C70657273293B0A202020202020202066756E6374696F6E2072756E286929207B0A20202020202020202020';
wwv_flow_imp.g_varchar2_table(143) := '6966202869203D3D206170702E6C656E677468292072657475726E2063616C6C6261636B286E756C6C290A20202020202020202020666574636848696E7473286170705B695D2C20636D2C206F7074696F6E732C2066756E6374696F6E28726573756C74';
wwv_flow_imp.g_varchar2_table(144) := '29207B0A20202020202020202020202069662028726573756C7420262620726573756C742E6C6973742E6C656E677468203E2030292063616C6C6261636B28726573756C74290A202020202020202020202020656C73652072756E2869202B2031290A20';
wwv_flow_imp.g_varchar2_table(145) := '2020202020202020207D290A20202020202020207D0A202020202020202072756E2830290A2020202020207D0A2020202020207265736F6C7665642E6173796E63203D20747275650A2020202020207265736F6C7665642E737570706F72747353656C65';
wwv_flow_imp.g_varchar2_table(146) := '6374696F6E203D20747275650A20202020202072657475726E207265736F6C7665640A202020207D20656C73652069662028776F726473203D20636D2E67657448656C70657228636D2E676574437572736F7228292C202268696E74576F726473222929';
wwv_flow_imp.g_varchar2_table(147) := '207B0A20202020202072657475726E2066756E6374696F6E28636D29207B2072657475726E20436F64654D6972726F722E68696E742E66726F6D4C69737428636D2C207B776F7264733A20776F7264737D29207D0A202020207D20656C73652069662028';
wwv_flow_imp.g_varchar2_table(148) := '436F64654D6972726F722E68696E742E616E79776F726429207B0A20202020202072657475726E2066756E6374696F6E28636D2C206F7074696F6E7329207B2072657475726E20436F64654D6972726F722E68696E742E616E79776F726428636D2C206F';
wwv_flow_imp.g_varchar2_table(149) := '7074696F6E7329207D0A202020207D20656C7365207B0A20202020202072657475726E2066756E6374696F6E2829207B7D0A202020207D0A20207D0A0A2020436F64654D6972726F722E726567697374657248656C706572282268696E74222C20226175';
wwv_flow_imp.g_varchar2_table(150) := '746F222C207B0A202020207265736F6C76653A207265736F6C76654175746F48696E74730A20207D293B0A0A2020436F64654D6972726F722E726567697374657248656C706572282268696E74222C202266726F6D4C697374222C2066756E6374696F6E';
wwv_flow_imp.g_varchar2_table(151) := '28636D2C206F7074696F6E7329207B0A2020202076617220637572203D20636D2E676574437572736F7228292C20746F6B656E203D20636D2E676574546F6B656E417428637572290A20202020766172207465726D2C2066726F6D203D20436F64654D69';
wwv_flow_imp.g_varchar2_table(152) := '72726F722E506F73286375722E6C696E652C20746F6B656E2E7374617274292C20746F203D206375720A2020202069662028746F6B656E2E7374617274203C206375722E6368202626202F5C772F2E7465737428746F6B656E2E737472696E672E636861';
wwv_flow_imp.g_varchar2_table(153) := '724174286375722E6368202D20746F6B656E2E7374617274202D2031292929207B0A2020202020207465726D203D20746F6B656E2E737472696E672E73756273747228302C206375722E6368202D20746F6B656E2E7374617274290A202020207D20656C';
wwv_flow_imp.g_varchar2_table(154) := '7365207B0A2020202020207465726D203D2022220A20202020202066726F6D203D206375720A202020207D0A2020202076617220666F756E64203D205B5D3B0A20202020666F7220287661722069203D20303B2069203C206F7074696F6E732E776F7264';
wwv_flow_imp.g_varchar2_table(155) := '732E6C656E6774683B20692B2B29207B0A20202020202076617220776F7264203D206F7074696F6E732E776F7264735B695D3B0A20202020202069662028776F72642E736C69636528302C207465726D2E6C656E67746829203D3D207465726D290A2020';
wwv_flow_imp.g_varchar2_table(156) := '202020202020666F756E642E7075736828776F7264293B0A202020207D0A0A2020202069662028666F756E642E6C656E677468292072657475726E207B6C6973743A20666F756E642C2066726F6D3A2066726F6D2C20746F3A20746F7D3B0A20207D293B';
wwv_flow_imp.g_varchar2_table(157) := '0A0A2020436F64654D6972726F722E636F6D6D616E64732E6175746F636F6D706C657465203D20436F64654D6972726F722E73686F7748696E743B0A0A20207661722064656661756C744F7074696F6E73203D207B0A2020202068696E743A20436F6465';
wwv_flow_imp.g_varchar2_table(158) := '4D6972726F722E68696E742E6175746F2C0A20202020636F6D706C65746553696E676C653A20747275652C0A20202020616C69676E57697468576F72643A20747275652C0A20202020636C6F7365436861726163746572733A202F5B5C7328295C5B5C5D';
wwv_flow_imp.g_varchar2_table(159) := '7B7D3B3A3E2C5D2F2C0A20202020636C6F73654F6E556E666F6375733A20747275652C0A20202020636F6D706C6574654F6E53696E676C65436C69636B3A20747275652C0A20202020636F6E7461696E65723A206E756C6C2C0A20202020637573746F6D';
wwv_flow_imp.g_varchar2_table(160) := '4B6579733A206E756C6C2C0A2020202065787472614B6579733A206E756C6C0A20207D3B0A0A2020436F64654D6972726F722E646566696E654F7074696F6E282268696E744F7074696F6E73222C206E756C6C293B0A7D293B0A';
end;
/
begin
wwv_flow_imp_shared.create_plugin_file(
 p_id=>wwv_flow_imp.id(51825847723691890999)
,p_plugin_id=>wwv_flow_imp.id(51863982453698216845)
,p_file_name=>'lib/codemirror/addon/hint/show-hint.js'
,p_mime_type=>'application/x-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) := '2F2F20436F64654D6972726F722C20636F7079726967687420286329206279204D6172696A6E20486176657262656B6520616E64206F74686572730A2F2F20446973747269627574656420756E64657220616E204D4954206C6963656E73653A20687474';
wwv_flow_imp.g_varchar2_table(2) := '703A2F2F636F64656D6972726F722E6E65742F4C4943454E53450A0A2866756E6374696F6E286D6F6429207B0A202069662028747970656F66206578706F727473203D3D20226F626A6563742220262620747970656F66206D6F64756C65203D3D20226F';
wwv_flow_imp.g_varchar2_table(3) := '626A6563742229202F2F20436F6D6D6F6E4A530A202020206D6F64287265717569726528222E2E2F2E2E2F6C69622F636F64656D6972726F722229293B0A2020656C73652069662028747970656F6620646566696E65203D3D202266756E6374696F6E22';
wwv_flow_imp.g_varchar2_table(4) := '20262620646566696E652E616D6429202F2F20414D440A20202020646566696E65285B222E2E2F2E2E2F6C69622F636F64656D6972726F72225D2C206D6F64293B0A2020656C7365202F2F20506C61696E2062726F7773657220656E760A202020206D6F';
wwv_flow_imp.g_varchar2_table(5) := '6428436F64654D6972726F72293B0A7D292866756E6374696F6E28436F64654D6972726F7229207B0A20207661722064656661756C7473203D207B0A2020202070616972733A202228295B5D7B7D27275C225C22222C0A20202020747269706C65733A20';
wwv_flow_imp.g_varchar2_table(6) := '22222C0A202020206578706C6F64653A20225B5D7B7D220A20207D3B0A0A202076617220506F73203D20436F64654D6972726F722E506F733B0A0A2020436F64654D6972726F722E646566696E654F7074696F6E28226175746F436C6F7365427261636B';
wwv_flow_imp.g_varchar2_table(7) := '657473222C2066616C73652C2066756E6374696F6E28636D2C2076616C2C206F6C6429207B0A20202020696620286F6C64202626206F6C6420213D20436F64654D6972726F722E496E697429207B0A202020202020636D2E72656D6F76654B65794D6170';
wwv_flow_imp.g_varchar2_table(8) := '286B65794D6170293B0A202020202020636D2E73746174652E636C6F7365427261636B657473203D206E756C6C3B0A202020207D0A202020206966202876616C29207B0A202020202020656E73757265426F756E64286765744F7074696F6E2876616C2C';
wwv_flow_imp.g_varchar2_table(9) := '202270616972732229290A202020202020636D2E73746174652E636C6F7365427261636B657473203D2076616C3B0A202020202020636D2E6164644B65794D6170286B65794D6170293B0A202020207D0A20207D293B0A0A202066756E6374696F6E2067';
wwv_flow_imp.g_varchar2_table(10) := '65744F7074696F6E28636F6E662C206E616D6529207B0A20202020696620286E616D65203D3D202270616972732220262620747970656F6620636F6E66203D3D2022737472696E6722292072657475726E20636F6E663B0A202020206966202874797065';
wwv_flow_imp.g_varchar2_table(11) := '6F6620636F6E66203D3D20226F626A6563742220262620636F6E665B6E616D655D20213D206E756C6C292072657475726E20636F6E665B6E616D655D3B0A2020202072657475726E2064656661756C74735B6E616D655D3B0A20207D0A0A202076617220';
wwv_flow_imp.g_varchar2_table(12) := '6B65794D6170203D207B4261636B73706163653A2068616E646C654261636B73706163652C20456E7465723A2068616E646C65456E7465727D3B0A202066756E6374696F6E20656E73757265426F756E6428636861727329207B0A20202020666F722028';
wwv_flow_imp.g_varchar2_table(13) := '7661722069203D20303B2069203C2063686172732E6C656E6774683B20692B2B29207B0A202020202020766172206368203D2063686172732E6368617241742869292C206B6579203D20222722202B206368202B202227220A2020202020206966202821';
wwv_flow_imp.g_varchar2_table(14) := '6B65794D61705B6B65795D29206B65794D61705B6B65795D203D2068616E646C6572286368290A202020207D0A20207D0A2020656E73757265426F756E642864656661756C74732E7061697273202B20226022290A0A202066756E6374696F6E2068616E';
wwv_flow_imp.g_varchar2_table(15) := '646C657228636829207B0A2020202072657475726E2066756E6374696F6E28636D29207B2072657475726E2068616E646C654368617228636D2C206368293B207D3B0A20207D0A0A202066756E6374696F6E20676574436F6E66696728636D29207B0A20';
wwv_flow_imp.g_varchar2_table(16) := '202020766172206465666C74203D20636D2E73746174652E636C6F7365427261636B6574733B0A2020202069662028216465666C74207C7C206465666C742E6F76657272696465292072657475726E206465666C743B0A20202020766172206D6F646520';
wwv_flow_imp.g_varchar2_table(17) := '3D20636D2E6765744D6F6465417428636D2E676574437572736F722829293B0A2020202072657475726E206D6F64652E636C6F7365427261636B657473207C7C206465666C743B0A20207D0A0A202066756E6374696F6E2068616E646C654261636B7370';
wwv_flow_imp.g_varchar2_table(18) := '61636528636D29207B0A2020202076617220636F6E66203D20676574436F6E66696728636D293B0A202020206966202821636F6E66207C7C20636D2E6765744F7074696F6E282264697361626C65496E7075742229292072657475726E20436F64654D69';
wwv_flow_imp.g_varchar2_table(19) := '72726F722E506173733B0A0A20202020766172207061697273203D206765744F7074696F6E28636F6E662C2022706169727322293B0A202020207661722072616E676573203D20636D2E6C69737453656C656374696F6E7328293B0A20202020666F7220';
wwv_flow_imp.g_varchar2_table(20) := '287661722069203D20303B2069203C2072616E6765732E6C656E6774683B20692B2B29207B0A202020202020696620282172616E6765735B695D2E656D7074792829292072657475726E20436F64654D6972726F722E506173733B0A2020202020207661';
wwv_flow_imp.g_varchar2_table(21) := '722061726F756E64203D20636861727341726F756E6428636D2C2072616E6765735B695D2E68656164293B0A202020202020696620282161726F756E64207C7C2070616972732E696E6465784F662861726F756E64292025203220213D20302920726574';
wwv_flow_imp.g_varchar2_table(22) := '75726E20436F64654D6972726F722E506173733B0A202020207D0A20202020666F7220287661722069203D2072616E6765732E6C656E677468202D20313B2069203E3D20303B20692D2D29207B0A20202020202076617220637572203D2072616E676573';
wwv_flow_imp.g_varchar2_table(23) := '5B695D2E686561643B0A202020202020636D2E7265706C61636552616E67652822222C20506F73286375722E6C696E652C206375722E6368202D2031292C20506F73286375722E6C696E652C206375722E6368202B2031292C20222B64656C6574652229';
wwv_flow_imp.g_varchar2_table(24) := '3B0A202020207D0A20207D0A0A202066756E6374696F6E2068616E646C65456E74657228636D29207B0A2020202076617220636F6E66203D20676574436F6E66696728636D293B0A20202020766172206578706C6F6465203D20636F6E66202626206765';
wwv_flow_imp.g_varchar2_table(25) := '744F7074696F6E28636F6E662C20226578706C6F646522293B0A2020202069662028216578706C6F6465207C7C20636D2E6765744F7074696F6E282264697361626C65496E7075742229292072657475726E20436F64654D6972726F722E506173733B0A';
wwv_flow_imp.g_varchar2_table(26) := '0A202020207661722072616E676573203D20636D2E6C69737453656C656374696F6E7328293B0A20202020666F7220287661722069203D20303B2069203C2072616E6765732E6C656E6774683B20692B2B29207B0A202020202020696620282172616E67';
wwv_flow_imp.g_varchar2_table(27) := '65735B695D2E656D7074792829292072657475726E20436F64654D6972726F722E506173733B0A2020202020207661722061726F756E64203D20636861727341726F756E6428636D2C2072616E6765735B695D2E68656164293B0A202020202020696620';
wwv_flow_imp.g_varchar2_table(28) := '282161726F756E64207C7C206578706C6F64652E696E6465784F662861726F756E64292025203220213D2030292072657475726E20436F64654D6972726F722E506173733B0A202020207D0A20202020636D2E6F7065726174696F6E2866756E6374696F';
wwv_flow_imp.g_varchar2_table(29) := '6E2829207B0A202020202020766172206C696E65736570203D20636D2E6C696E65536570617261746F722829207C7C20225C6E223B0A202020202020636D2E7265706C61636553656C656374696F6E286C696E65736570202B206C696E657365702C206E';
wwv_flow_imp.g_varchar2_table(30) := '756C6C293B0A202020202020636D2E65786563436F6D6D616E642822676F436861724C65667422293B0A20202020202072616E676573203D20636D2E6C69737453656C656374696F6E7328293B0A202020202020666F7220287661722069203D20303B20';
wwv_flow_imp.g_varchar2_table(31) := '69203C2072616E6765732E6C656E6774683B20692B2B29207B0A2020202020202020766172206C696E65203D2072616E6765735B695D2E686561642E6C696E653B0A2020202020202020636D2E696E64656E744C696E65286C696E652C206E756C6C2C20';
wwv_flow_imp.g_varchar2_table(32) := '74727565293B0A2020202020202020636D2E696E64656E744C696E65286C696E65202B20312C206E756C6C2C2074727565293B0A2020202020207D0A202020207D293B0A20207D0A0A202066756E6374696F6E20636F6E747261637453656C656374696F';
wwv_flow_imp.g_varchar2_table(33) := '6E2873656C29207B0A2020202076617220696E766572746564203D20436F64654D6972726F722E636D70506F732873656C2E616E63686F722C2073656C2E6865616429203E20303B0A2020202072657475726E207B616E63686F723A206E657720506F73';
wwv_flow_imp.g_varchar2_table(34) := '2873656C2E616E63686F722E6C696E652C2073656C2E616E63686F722E6368202B2028696E766572746564203F202D31203A203129292C0A202020202020202020202020686561643A206E657720506F732873656C2E686561642E6C696E652C2073656C';
wwv_flow_imp.g_varchar2_table(35) := '2E686561642E6368202B2028696E766572746564203F2031203A202D3129297D3B0A20207D0A0A202066756E6374696F6E2068616E646C654368617228636D2C20636829207B0A2020202076617220636F6E66203D20676574436F6E66696728636D293B';
wwv_flow_imp.g_varchar2_table(36) := '0A202020206966202821636F6E66207C7C20636D2E6765744F7074696F6E282264697361626C65496E7075742229292072657475726E20436F64654D6972726F722E506173733B0A0A20202020766172207061697273203D206765744F7074696F6E2863';
wwv_flow_imp.g_varchar2_table(37) := '6F6E662C2022706169727322293B0A2020202076617220706F73203D2070616972732E696E6465784F66286368293B0A2020202069662028706F73203D3D202D31292072657475726E20436F64654D6972726F722E506173733B0A202020207661722074';
wwv_flow_imp.g_varchar2_table(38) := '7269706C6573203D206765744F7074696F6E28636F6E662C2022747269706C657322293B0A0A20202020766172206964656E746963616C203D2070616972732E63686172417428706F73202B203129203D3D2063683B0A202020207661722072616E6765';
wwv_flow_imp.g_varchar2_table(39) := '73203D20636D2E6C69737453656C656374696F6E7328293B0A20202020766172206F70656E696E67203D20706F7320252032203D3D20303B0A0A2020202076617220747970653B0A20202020666F7220287661722069203D20303B2069203C2072616E67';
wwv_flow_imp.g_varchar2_table(40) := '65732E6C656E6774683B20692B2B29207B0A2020202020207661722072616E6765203D2072616E6765735B695D2C20637572203D2072616E67652E686561642C20637572547970653B0A202020202020766172206E657874203D20636D2E67657452616E';
wwv_flow_imp.g_varchar2_table(41) := '6765286375722C20506F73286375722E6C696E652C206375722E6368202B203129293B0A202020202020696620286F70656E696E67202626202172616E67652E656D707479282929207B0A202020202020202063757254797065203D2022737572726F75';
wwv_flow_imp.g_varchar2_table(42) := '6E64223B0A2020202020207D20656C73652069662028286964656E746963616C207C7C20216F70656E696E6729202626206E657874203D3D20636829207B0A2020202020202020696620286964656E746963616C20262620737472696E67537461727473';
wwv_flow_imp.g_varchar2_table(43) := '416674657228636D2C2063757229290A2020202020202020202063757254797065203D2022626F7468223B0A2020202020202020656C73652069662028747269706C65732E696E6465784F6628636829203E3D203020262620636D2E67657452616E6765';
wwv_flow_imp.g_varchar2_table(44) := '286375722C20506F73286375722E6C696E652C206375722E6368202B20332929203D3D206368202B206368202B206368290A2020202020202020202063757254797065203D2022736B69705468726565223B0A2020202020202020656C73650A20202020';
wwv_flow_imp.g_varchar2_table(45) := '20202020202063757254797065203D2022736B6970223B0A2020202020207D20656C736520696620286964656E746963616C202626206375722E6368203E203120262620747269706C65732E696E6465784F6628636829203E3D20302026260A20202020';
wwv_flow_imp.g_varchar2_table(46) := '20202020202020202020202020636D2E67657452616E676528506F73286375722E6C696E652C206375722E6368202D2032292C2063757229203D3D206368202B20636829207B0A2020202020202020696620286375722E6368203E2032202626202F5C62';
wwv_flow_imp.g_varchar2_table(47) := '737472696E672F2E7465737428636D2E676574546F6B656E54797065417428506F73286375722E6C696E652C206375722E6368202D2032292929292072657475726E20436F64654D6972726F722E506173733B0A20202020202020206375725479706520';
wwv_flow_imp.g_varchar2_table(48) := '3D2022616464466F7572223B0A2020202020207D20656C736520696620286964656E746963616C29207B0A20202020202020207661722070726576203D206375722E6368203D3D2030203F20222022203A20636D2E67657452616E676528506F73286375';
wwv_flow_imp.g_varchar2_table(49) := '722E6C696E652C206375722E6368202D2031292C20637572290A20202020202020206966202821436F64654D6972726F722E6973576F726443686172286E65787429202626207072657620213D2063682026262021436F64654D6972726F722E6973576F';
wwv_flow_imp.g_varchar2_table(50) := '726443686172287072657629292063757254797065203D2022626F7468223B0A2020202020202020656C73652072657475726E20436F64654D6972726F722E506173733B0A2020202020207D20656C736520696620286F70656E696E672026262028636D';
wwv_flow_imp.g_varchar2_table(51) := '2E6765744C696E65286375722E6C696E65292E6C656E677468203D3D206375722E6368207C7C0A20202020202020202020202020202020202020202020202020202020206973436C6F73696E67427261636B6574286E6578742C20706169727329207C7C';
wwv_flow_imp.g_varchar2_table(52) := '0A20202020202020202020202020202020202020202020202020202020202F5C732F2E74657374286E657874292929207B0A202020202020202063757254797065203D2022626F7468223B0A2020202020207D20656C7365207B0A202020202020202072';
wwv_flow_imp.g_varchar2_table(53) := '657475726E20436F64654D6972726F722E506173733B0A2020202020207D0A202020202020696620282174797065292074797065203D20637572547970653B0A202020202020656C736520696620287479706520213D2063757254797065292072657475';
wwv_flow_imp.g_varchar2_table(54) := '726E20436F64654D6972726F722E506173733B0A202020207D0A0A20202020766172206C656674203D20706F7320252032203F2070616972732E63686172417428706F73202D203129203A2063683B0A20202020766172207269676874203D20706F7320';
wwv_flow_imp.g_varchar2_table(55) := '252032203F206368203A2070616972732E63686172417428706F73202B2031293B0A20202020636D2E6F7065726174696F6E2866756E6374696F6E2829207B0A2020202020206966202874797065203D3D2022736B69702229207B0A2020202020202020';
wwv_flow_imp.g_varchar2_table(56) := '636D2E65786563436F6D6D616E642822676F43686172526967687422293B0A2020202020207D20656C7365206966202874797065203D3D2022736B697054687265652229207B0A2020202020202020666F7220287661722069203D20303B2069203C2033';
wwv_flow_imp.g_varchar2_table(57) := '3B20692B2B290A20202020202020202020636D2E65786563436F6D6D616E642822676F43686172526967687422293B0A2020202020207D20656C7365206966202874797065203D3D2022737572726F756E642229207B0A20202020202020207661722073';
wwv_flow_imp.g_varchar2_table(58) := '656C73203D20636D2E67657453656C656374696F6E7328293B0A2020202020202020666F7220287661722069203D20303B2069203C2073656C732E6C656E6774683B20692B2B290A2020202020202020202073656C735B695D203D206C656674202B2073';
wwv_flow_imp.g_varchar2_table(59) := '656C735B695D202B2072696768743B0A2020202020202020636D2E7265706C61636553656C656374696F6E732873656C732C202261726F756E6422293B0A202020202020202073656C73203D20636D2E6C69737453656C656374696F6E7328292E736C69';
wwv_flow_imp.g_varchar2_table(60) := '636528293B0A2020202020202020666F7220287661722069203D20303B2069203C2073656C732E6C656E6774683B20692B2B290A2020202020202020202073656C735B695D203D20636F6E747261637453656C656374696F6E2873656C735B695D293B0A';
wwv_flow_imp.g_varchar2_table(61) := '2020202020202020636D2E73657453656C656374696F6E732873656C73293B0A2020202020207D20656C7365206966202874797065203D3D2022626F74682229207B0A2020202020202020636D2E7265706C61636553656C656374696F6E286C65667420';
wwv_flow_imp.g_varchar2_table(62) := '2B2072696768742C206E756C6C293B0A2020202020202020636D2E74726967676572456C656374726963286C656674202B207269676874293B0A2020202020202020636D2E65786563436F6D6D616E642822676F436861724C65667422293B0A20202020';
wwv_flow_imp.g_varchar2_table(63) := '20207D20656C7365206966202874797065203D3D2022616464466F75722229207B0A2020202020202020636D2E7265706C61636553656C656374696F6E286C656674202B206C656674202B206C656674202B206C6566742C20226265666F726522293B0A';
wwv_flow_imp.g_varchar2_table(64) := '2020202020202020636D2E65786563436F6D6D616E642822676F43686172526967687422293B0A2020202020207D0A202020207D293B0A20207D0A0A202066756E6374696F6E206973436C6F73696E67427261636B65742863682C20706169727329207B';
wwv_flow_imp.g_varchar2_table(65) := '0A2020202076617220706F73203D2070616972732E6C617374496E6465784F66286368293B0A2020202072657475726E20706F73203E202D3120262620706F7320252032203D3D20313B0A20207D0A0A202066756E6374696F6E20636861727341726F75';
wwv_flow_imp.g_varchar2_table(66) := '6E6428636D2C20706F7329207B0A2020202076617220737472203D20636D2E67657452616E676528506F7328706F732E6C696E652C20706F732E6368202D2031292C0A2020202020202020202020202020202020202020202020202020506F7328706F73';
wwv_flow_imp.g_varchar2_table(67) := '2E6C696E652C20706F732E6368202B203129293B0A2020202072657475726E207374722E6C656E677468203D3D2032203F20737472203A206E756C6C3B0A20207D0A0A202066756E6374696F6E20737472696E67537461727473416674657228636D2C20';
wwv_flow_imp.g_varchar2_table(68) := '706F7329207B0A2020202076617220746F6B656E203D20636D2E676574546F6B656E417428506F7328706F732E6C696E652C20706F732E6368202B203129290A2020202072657475726E202F5C62737472696E672F2E7465737428746F6B656E2E747970';
wwv_flow_imp.g_varchar2_table(69) := '652920262620746F6B656E2E7374617274203D3D20706F732E63682026260A20202020202028706F732E6368203D3D2030207C7C20212F5C62737472696E672F2E7465737428636D2E676574546F6B656E54797065417428706F732929290A20207D0A7D';
wwv_flow_imp.g_varchar2_table(70) := '293B0A';
end;
/
begin
wwv_flow_imp_shared.create_plugin_file(
 p_id=>wwv_flow_imp.id(51825848066258891002)
,p_plugin_id=>wwv_flow_imp.id(51863982453698216845)
,p_file_name=>'lib/codemirror/addon/edit/closebrackets.js'
,p_mime_type=>'application/x-javascript'
,p_file_charset=>'utf-8'
,p_file_content=>wwv_flow_imp.varchar2_to_blob(wwv_flow_imp.g_varchar2_table)
);
end;
/
prompt --application/user_interfaces/combined_files
begin
null;
end;
/
prompt --application/pages/page_00000
begin
wwv_flow_imp_page.create_page(
 p_id=>0
,p_name=>'Global Page'
,p_step_title=>'Global Page'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'D'
,p_page_component_map=>'14'
);
end;
/
prompt --application/pages/page_00001
begin
wwv_flow_imp_page.create_page(
 p_id=>1
,p_name=>'Home'
,p_alias=>'HOME'
,p_step_title=>'ChatDB'
,p_warn_on_unsaved_changes=>'N'
,p_autocomplete_on_off=>'OFF'
,p_javascript_file_urls=>'#APP_FILES#speechRecognition#MIN#.js'
,p_inline_css=>wwv_flow_string.join(wwv_flow_t_varchar2(
'.t-Footer {',
'    gap: 0;',
'    padding: .5rem!important;',
'}',
'',
'.t-Footer-top,.t-Footer-apex{',
'    display: none;',
'}',
'',
'.llm-recording{',
'    pointer-events: auto !important;',
'} ',
'',
'.sticky-Footer {',
'    position: sticky;',
'    left: 0;',
'    bottom: 0;',
'    width: 100%;',
'    background-color: #eeeae7;',
'    border-top: 1px solid #e6e6e6;',
'}',
'.t-Body-contentInner{',
'    padding: 0px !important;',
'}',
'',
'#PROMPTS_TemplateComponent{',
'    min-height: 100vh;',
'}',
''))
,p_step_template=>wwv_flow_imp.id(49923506692962420276)
,p_page_template_options=>'#DEFAULT#'
,p_overwrite_navigation_list=>'Y'
,p_navigation_list_position=>'SIDE'
,p_navigation_list_id=>wwv_flow_imp.id(172644861450333789)
,p_navigation_list_template_id=>wwv_flow_imp.id(49924044504368420333)
,p_nav_list_template_options=>'#DEFAULT#:t-TreeNav--classic:js-navCollapsed--hidden'
,p_protection_level=>'C'
,p_page_component_map=>'13'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(173862332515815491)
,p_plug_name=>'Prompts'
,p_region_name=>'PROMPTS'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(49923518223509420282)
,p_plug_display_sequence=>20
,p_plug_item_display_point=>'BELOW'
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select ID,',
'       CONV_ID,',
'       PROMPT,',
'       RESPONSE,',
'       ASKED_ON,',
'       SHOWSQL,',
'       (case when RESPONSE is not null then ''CHAT'' ELSE NULL END) RESPONSE_TYPE',
'  from OCW23_PROMPTS',
' where CONV_ID = :P1_CONV_ID',
' order by ASKED_ON'))
,p_template_component_type=>'REPORT'
,p_lazy_loading=>false
,p_plug_source_type=>'TMPL_LLM_CONVERSATION'
,p_ajax_items_to_submit=>'P1_CONV_ID'
,p_plug_query_num_rows=>15
,p_plug_query_num_rows_type=>'SET'
,p_plug_query_no_data_found=>'No questions have been asked!'
,p_show_total_row_count=>false
,p_landmark_type=>'region'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'ID', 'ID',
  'PROMPT', 'PROMPT',
  'RESPONSE_TYPE', 'RESPONSE_TYPE')).to_clob
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(166890269955630098)
,p_name=>'RESPONSE_TYPE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'RESPONSE_TYPE'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_display_sequence=>70
,p_use_as_row_header=>false
,p_is_primary_key=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(173862437449815492)
,p_name=>'ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'ID'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_display_sequence=>10
,p_use_as_row_header=>false
,p_is_primary_key=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(173862527445815493)
,p_name=>'CONV_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'CONV_ID'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_display_sequence=>20
,p_use_as_row_header=>false
,p_is_primary_key=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(173862647845815494)
,p_name=>'PROMPT'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PROMPT'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_display_sequence=>30
,p_use_as_row_header=>false
,p_is_primary_key=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(173862677620815495)
,p_name=>'RESPONSE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'RESPONSE'
,p_data_type=>'CLOB'
,p_session_state_data_type=>'VARCHAR2'
,p_display_sequence=>40
,p_use_as_row_header=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(173862780913815496)
,p_name=>'SHOWSQL'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'SHOWSQL'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_display_sequence=>50
,p_use_as_row_header=>false
,p_is_primary_key=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(173862939282815497)
,p_name=>'ASKED_ON'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'ASKED_ON'
,p_data_type=>'TIMESTAMP'
,p_session_state_data_type=>'VARCHAR2'
,p_display_sequence=>60
,p_use_as_row_header=>false
,p_is_primary_key=>false
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(170858042163738254)
,p_plug_name=>'New'
,p_parent_plug_id=>wwv_flow_imp.id(173862332515815491)
,p_region_css_classes=>'sticky-Footer padding-lg'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(49923518223509420282)
,p_plug_display_sequence=>60
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'expand_shortcuts', 'N',
  'output_as', 'HTML')).to_clob
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(48372047006103079319)
,p_plug_name=>'Question'
,p_parent_plug_id=>wwv_flow_imp.id(170858042163738254)
,p_region_template_options=>'#DEFAULT#:t-Form--xlarge:t-Form--stretchInputs'
,p_plug_template=>wwv_flow_imp.id(49923975737325420304)
,p_plug_display_sequence=>10
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'expand_shortcuts', 'N',
  'output_as', 'HTML')).to_clob
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(48372046824485079317)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_imp.id(48372047006103079319)
,p_button_name=>'RUN'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(49924055995830420339)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Run'
,p_button_position=>'BUTTON_END'
,p_button_alignment=>'RIGHT'
,p_icon_css_classes=>'fa-send-o'
);
wwv_flow_imp_page.create_page_branch(
 p_id=>wwv_flow_imp.id(170851246628869479)
,p_branch_action=>'f?p=&APP_ID.:1:&SESSION.::&DEBUG.::P1_CONV_ID:&P1_CONV_ID.&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'AFTER_PROCESSING'
,p_branch_type=>'REDIRECT_URL'
,p_branch_sequence=>10
);
wwv_flow_imp_page.create_page_branch(
 p_id=>wwv_flow_imp.id(168098812150992573)
,p_branch_action=>'f?p=&APP_ID.:20020:&SESSION.::&DEBUG.:::'
,p_branch_point=>'BEFORE_COMPUTATION'
,p_branch_type=>'REDIRECT_URL'
,p_branch_sequence=>10
,p_branch_condition_type=>'REQUEST_EQUALS_CONDITION'
,p_branch_condition=>'OPEN_AI_SETTINGS'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(166890361980630099)
,p_name=>'P1_ASK_ADB'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(170858042163738254)
,p_prompt=>'Ask Database'
,p_display_as=>'NATIVE_SINGLE_CHECKBOX'
,p_field_template=>wwv_flow_imp.id(49924054164191420338)
,p_item_template_options=>'#DEFAULT#'
,p_help_text=>'By checking this box, your app will utilize your business data to provide answers to your questions. Uncheck this box to search the internet for general information.'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(170850490474869472)
,p_name=>'P1_CONV_ID'
,p_item_sequence=>50
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(48372046659589079316)
,p_name=>'P1_PROMPT'
,p_is_required=>true
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(48372047006103079319)
,p_prompt=>'Prompt'
,p_placeholder=>'Ask a question'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_field_template=>wwv_flow_imp.id(49924053909586420337)
,p_item_icon_css_classes=>'fa-microphone llm-recording'
,p_item_template_options=>'#DEFAULT#:t-Form-fieldContainer--stretchInputs:t-Form-fieldContainer--xlarge'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(168098606766992571)
,p_name=>'Open AI Settings'
,p_event_sequence=>60
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'ready'
,p_display_when_type=>'FUNCTION_BODY'
,p_display_when_cond=>wwv_flow_string.join(wwv_flow_t_varchar2(
'return APEX_UTIL.GET_PREFERENCE(       ',
'         p_preference => ''CLOUD_AI_PROFILE'',',
'            p_user       => :APP_USER) is null;'))
,p_display_when_cond2=>'PLSQL'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(168098694502992572)
,p_event_id=>wwv_flow_imp.id(168098606766992571)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_SUBMIT_PAGE'
,p_attribute_01=>'OPEN_AI_SETTINGS'
,p_attribute_02=>'N'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(170850670181869473)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Create a Conversation'
,p_process_sql_clob=>'INSERT INTO OCW23_CONVERSATIONS (USERNAME, STARTED_ON) VALUES (:APP_USER, SYSTIMESTAMP) returning id into :P1_CONV_ID;'
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when=>'P1_CONV_ID'
,p_process_when_type=>'ITEM_IS_NULL'
,p_internal_uid=>7968697490642105
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(175551555473432973)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'AI Call'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'declare',
'    l_response clob;',
'    l_sql clob;',
'    l_prompt varchar2(4000);',
'    l_cursor NUMBER := dbms_sql.open_cursor;',
'    l_profile_name user_cloud_ai_profiles.profile_name%type := lower(APEX_UTIL.GET_PREFERENCE(       ',
'         p_preference => ''CLOUD_AI_PROFILE'',',
'            p_user       => :APP_USER));',
'begin',
'',
'    if :P1_ASK_ADB = ''Y'' then',
'        -- question about customer data',
'        ',
'        l_sql := dbms_cloud_ai.generate(',
'            prompt => :P1_PROMPT,',
'            action => ''showsql'',',
'            profile_name => l_profile_name',
'            );',
'        ',
'        -- check if SQL could be generated.',
'        -- if not, then return the response ',
'        BEGIN',
'            DBMS_SQL.PARSE (l_cursor, l_sql, DBMS_SQL.native);',
'        EXCEPTION',
'            WHEN OTHERS THEN',
'                l_response := l_sql;',
'        END;',
'           ',
'    else',
'        -- general chat',
'        l_response := dbms_cloud_ai.generate(',
'            prompt => :P1_PROMPT,',
'            action => ''chat'',',
'            profile_name => l_profile_name',
'            );',
'       ',
'    end if;',
'    ',
'    l_prompt := dbms_cloud_ai.generate(',
'        prompt => ''Rewrite as a short title : ''||:P1_PROMPT,',
'        action => ''chat'',',
'        profile_name => l_profile_name',
'    );',
'        ',
'    update OCW23_CONVERSATIONS set summary = l_prompt',
'    where id = :p1_conv_id and summary is null;',
'    ',
'    insert into OCW23_PROMPTS (conv_id, prompt, response, asked_on, showsql) ',
'        values (:p1_conv_id, :p1_prompt, l_response, systimestamp, l_sql);',
'',
'end;'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>12669582782205605
);
wwv_flow_imp_page.create_component_action(
 p_id=>wwv_flow_imp.id(173863584116815504)
,p_region_id=>wwv_flow_imp.id(173862332515815491)
,p_position_id=>wwv_flow_imp.id(174072419540158353)
,p_display_sequence=>10
,p_label=>'Explore'
,p_link_target_type=>'REDIRECT_PAGE'
,p_link_target=>'f?p=&APP_ID.:2:&SESSION.::&DEBUG.:RR,2:P2_CURRENT_ID:&ID.'
,p_button_display_type=>'TEXT'
,p_is_hot=>false
,p_show_as_disabled=>false
,p_condition_type=>'ITEM_IS_NOT_NULL'
,p_condition_expr1=>'SHOWSQL'
,p_exec_cond_for_each_row=>true
);
wwv_flow_imp_page.create_component_action(
 p_id=>wwv_flow_imp.id(173863772287815505)
,p_region_id=>wwv_flow_imp.id(173862332515815491)
,p_position_id=>wwv_flow_imp.id(174072419540158353)
,p_display_sequence=>20
,p_label=>'Explain'
,p_link_target_type=>'REDIRECT_PAGE'
,p_link_target=>'f?p=&APP_ID.:3:&SESSION.::&DEBUG.::P3_CURRENT_ID:&ID.'
,p_button_display_type=>'TEXT'
,p_is_hot=>false
,p_show_as_disabled=>false
,p_condition_type=>'ITEM_IS_NOT_NULL'
,p_condition_expr1=>'SHOWSQL'
,p_exec_cond_for_each_row=>true
);
end;
/
prompt --application/pages/page_00002
begin
wwv_flow_imp_page.create_page(
 p_id=>2
,p_name=>'Explore'
,p_alias=>'REPORT'
,p_step_title=>'Explore'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_overwrite_navigation_list=>'Y'
,p_navigation_list_position=>'SIDE'
,p_navigation_list_id=>wwv_flow_imp.id(172644861450333789)
,p_navigation_list_template_id=>wwv_flow_imp.id(49924044504368420333)
,p_nav_list_template_options=>'#DEFAULT#:t-TreeNav--styleA:js-navCollapsed--hidden'
,p_protection_level=>'C'
,p_page_component_map=>'21'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(189814661071164426)
,p_plug_name=>'Breadcrumb'
,p_region_sub_css_classes=>'u-textCenter'
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(49923995796476420313)
,p_plug_display_sequence=>30
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_imp.id(49923480142300420265)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_imp.id(49924058328176420340)
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(221781627007156647)
,p_plug_name=>'REPORT'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(49923973599927420304)
,p_plug_display_sequence=>10
,p_query_type=>'FUNC_BODY_RETURNING_SQL'
,p_function_body_language=>'PLSQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'IF :P2_SQL IS NULL THEN',
'RETURN Q''[select',
'       C001,',
'       C002,',
'       C003,',
'       C004,',
'       C005,',
'       N001,',
'       N002,',
'       N003,',
'       N004,',
'       N005,',
'       D001,',
'       D002,',
'       D003,',
'       D004,',
'       D005',
'  from APEX_COLLECTIONS]'';',
'  ELSE RETURN :P2_SQL;',
'  END IF;'))
,p_plug_source_type=>'NATIVE_IG'
,p_ajax_items_to_submit=>'P2_VAR_COL_LABEL_1,P2_VAR_COL_LABEL_2,P2_VAR_COL_LABEL_3,P2_VAR_COL_LABEL_4,P2_VAR_COL_LABEL_5,P2_NUM_COL_LABEL_1,P2_NUM_COL_LABEL_2,P2_NUM_COL_LABEL_3,P2_NUM_COL_LABEL_4,P2_NUM_COL_LABEL_5,P2_DATE_COL_LABEL_1,P2_DATE_COL_LABEL_2,P2_DATE_COL_LABEL_3,'
||'P2_DATE_COL_LABEL_4,P2_DATE_COL_LABEL_5,P2_SQL'
,p_prn_units=>'INCHES'
,p_prn_paper_size=>'LETTER'
,p_prn_width=>11
,p_prn_height=>8.5
,p_prn_orientation=>'HORIZONTAL'
,p_prn_page_header=>'REPORT'
,p_prn_page_header_font_color=>'#000000'
,p_prn_page_header_font_family=>'Helvetica'
,p_prn_page_header_font_weight=>'normal'
,p_prn_page_header_font_size=>'12'
,p_prn_page_footer_font_color=>'#000000'
,p_prn_page_footer_font_family=>'Helvetica'
,p_prn_page_footer_font_weight=>'normal'
,p_prn_page_footer_font_size=>'12'
,p_prn_header_bg_color=>'#EEEEEE'
,p_prn_header_font_color=>'#000000'
,p_prn_header_font_family=>'Helvetica'
,p_prn_header_font_weight=>'bold'
,p_prn_header_font_size=>'10'
,p_prn_body_bg_color=>'#FFFFFF'
,p_prn_body_font_color=>'#000000'
,p_prn_body_font_family=>'Helvetica'
,p_prn_body_font_weight=>'normal'
,p_prn_body_font_size=>'10'
,p_prn_border_width=>.5
,p_prn_page_header_alignment=>'CENTER'
,p_prn_page_footer_alignment=>'CENTER'
,p_prn_border_color=>'#666666'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170582810390924983)
,p_name=>'C001'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'C001'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'&P2_VAR_COL_LABEL_1.'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>30
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>false
,p_max_length=>32767
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_VAR_COL_LABEL_1'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170582976818924984)
,p_name=>'C002'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'C002'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'&P2_VAR_COL_LABEL_2.'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>40
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>false
,p_max_length=>32767
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_VAR_COL_LABEL_2'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170582996631924985)
,p_name=>'C003'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'C003'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'&P2_VAR_COL_LABEL_3.'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>50
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>false
,p_max_length=>32767
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_VAR_COL_LABEL_3'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170583123114924986)
,p_name=>'C004'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'C004'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'&P2_VAR_COL_LABEL_4.'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>60
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>false
,p_max_length=>32767
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_VAR_COL_LABEL_4'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170583199902924987)
,p_name=>'C005'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'C005'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'&P2_VAR_COL_LABEL_5.'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>70
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>false
,p_max_length=>32767
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_VAR_COL_LABEL_5'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170660746360036885)
,p_name=>'N001'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'N001'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_NUMBER_FIELD'
,p_heading=>'&P2_NUM_COL_LABEL_1.'
,p_heading_alignment=>'RIGHT'
,p_display_sequence=>550
,p_value_alignment=>'RIGHT'
,p_attribute_03=>'left'
,p_attribute_04=>'decimal'
,p_format_mask=>'999G999G999G999G990D00'
,p_is_required=>false
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_NUM_COL_LABEL_1'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170660826769036886)
,p_name=>'N002'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'N002'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_NUMBER_FIELD'
,p_heading=>'&P2_NUM_COL_LABEL_2.'
,p_heading_alignment=>'RIGHT'
,p_display_sequence=>560
,p_value_alignment=>'RIGHT'
,p_attribute_03=>'left'
,p_attribute_04=>'decimal'
,p_format_mask=>'999G999G999G999G990D00'
,p_is_required=>false
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_NUM_COL_LABEL_2'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170660981490036887)
,p_name=>'N003'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'N003'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_NUMBER_FIELD'
,p_heading=>'&P2_NUM_COL_LABEL_3.'
,p_heading_alignment=>'RIGHT'
,p_display_sequence=>570
,p_value_alignment=>'RIGHT'
,p_attribute_03=>'left'
,p_attribute_04=>'decimal'
,p_format_mask=>'999G999G999G999G990D00'
,p_is_required=>false
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_NUM_COL_LABEL_3'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170661076733036888)
,p_name=>'N004'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'N004'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_NUMBER_FIELD'
,p_heading=>'&P2_NUM_COL_LABEL_4.'
,p_heading_alignment=>'RIGHT'
,p_display_sequence=>580
,p_value_alignment=>'RIGHT'
,p_attribute_03=>'left'
,p_attribute_04=>'decimal'
,p_format_mask=>'999G999G999G999G990D00'
,p_is_required=>false
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_NUM_COL_LABEL_4'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170661176493036889)
,p_name=>'N005'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'N005'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_NUMBER_FIELD'
,p_heading=>'&P2_NUM_COL_LABEL_5.'
,p_heading_alignment=>'RIGHT'
,p_display_sequence=>590
,p_value_alignment=>'RIGHT'
,p_attribute_03=>'left'
,p_attribute_04=>'decimal'
,p_format_mask=>'999G999G999G999G990D00'
,p_is_required=>false
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_NUM_COL_LABEL_5'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170661279100036890)
,p_name=>'D001'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'D001'
,p_data_type=>'DATE'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_DATE_PICKER_APEX'
,p_heading=>'&P2_DATE_COL_LABEL_1.'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>600
,p_value_alignment=>'LEFT'
,p_attribute_01=>'N'
,p_attribute_02=>'POPUP'
,p_attribute_03=>'NONE'
,p_attribute_06=>'NONE'
,p_attribute_09=>'N'
,p_attribute_11=>'Y'
,p_is_required=>false
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_date_ranges=>'ALL'
,p_filter_lov_type=>'DISTINCT'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_DATE_COL_LABEL_1'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170661347054036891)
,p_name=>'D002'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'D002'
,p_data_type=>'DATE'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_DATE_PICKER_APEX'
,p_heading=>'&P2_DATE_COL_LABEL_2.'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>610
,p_value_alignment=>'LEFT'
,p_attribute_01=>'N'
,p_attribute_02=>'POPUP'
,p_attribute_03=>'NONE'
,p_attribute_06=>'NONE'
,p_attribute_09=>'N'
,p_attribute_11=>'Y'
,p_is_required=>false
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_date_ranges=>'ALL'
,p_filter_lov_type=>'DISTINCT'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_DATE_COL_LABEL_2'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170661472759036892)
,p_name=>'D003'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'D003'
,p_data_type=>'DATE'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_DATE_PICKER_APEX'
,p_heading=>'&P2_DATE_COL_LABEL_3.'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>620
,p_value_alignment=>'LEFT'
,p_attribute_01=>'N'
,p_attribute_02=>'POPUP'
,p_attribute_03=>'NONE'
,p_attribute_06=>'NONE'
,p_attribute_09=>'N'
,p_attribute_11=>'Y'
,p_is_required=>false
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_date_ranges=>'ALL'
,p_filter_lov_type=>'DISTINCT'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_DATE_COL_LABEL_3'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170661561892036893)
,p_name=>'D004'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'D004'
,p_data_type=>'DATE'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_DATE_PICKER_APEX'
,p_heading=>'&P2_DATE_COL_LABEL_4.'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>630
,p_value_alignment=>'LEFT'
,p_attribute_01=>'N'
,p_attribute_02=>'POPUP'
,p_attribute_03=>'NONE'
,p_attribute_06=>'NONE'
,p_attribute_09=>'N'
,p_attribute_11=>'Y'
,p_is_required=>false
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_date_ranges=>'ALL'
,p_filter_lov_type=>'DISTINCT'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_DATE_COL_LABEL_4'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(170661632980036894)
,p_name=>'D005'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'D005'
,p_data_type=>'DATE'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_DATE_PICKER_APEX'
,p_heading=>'&P2_DATE_COL_LABEL_5.'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>640
,p_value_alignment=>'LEFT'
,p_attribute_01=>'N'
,p_attribute_02=>'POPUP'
,p_attribute_03=>'NONE'
,p_attribute_06=>'NONE'
,p_attribute_09=>'N'
,p_attribute_11=>'Y'
,p_is_required=>false
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_date_ranges=>'ALL'
,p_filter_lov_type=>'DISTINCT'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_display_condition=>'P2_DATE_COL_LABEL_5'
);
wwv_flow_imp_page.create_interactive_grid(
 p_id=>wwv_flow_imp.id(170582504868924980)
,p_internal_uid=>16663213184896630
,p_is_editable=>false
,p_lazy_loading=>true
,p_requires_filter=>false
,p_select_first_row=>true
,p_fixed_row_height=>true
,p_pagination_type=>'SET'
,p_show_total_row_count=>true
,p_show_toolbar=>true
,p_enable_save_public_report=>false
,p_enable_subscriptions=>true
,p_enable_flashback=>true
,p_define_chart_view=>true
,p_enable_download=>true
,p_download_formats=>'CSV:HTML:XLSX:PDF'
,p_enable_mail_download=>true
,p_fixed_header=>'PAGE'
,p_show_icon_view=>false
,p_show_detail_view=>false
);
wwv_flow_imp_page.create_ig_report(
 p_id=>wwv_flow_imp.id(170663209987039629)
,p_interactive_grid_id=>wwv_flow_imp.id(170582504868924980)
,p_static_id=>'167440'
,p_type=>'PRIMARY'
,p_default_view=>'GRID'
,p_show_row_number=>false
,p_settings_area_expanded=>true
);
wwv_flow_imp_page.create_ig_report_view(
 p_id=>wwv_flow_imp.id(170663396212039629)
,p_report_id=>wwv_flow_imp.id(170663209987039629)
,p_view_type=>'GRID'
,p_srv_exclude_null_values=>false
,p_srv_only_display_columns=>true
,p_edit_mode=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170665723889039641)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>3
,p_column_id=>wwv_flow_imp.id(170582810390924983)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170666664852039644)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>4
,p_column_id=>wwv_flow_imp.id(170582976818924984)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170667421487039647)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>5
,p_column_id=>wwv_flow_imp.id(170582996631924985)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170668308019039650)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>6
,p_column_id=>wwv_flow_imp.id(170583123114924986)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170669280274039653)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>7
,p_column_id=>wwv_flow_imp.id(170583199902924987)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170670165125039656)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>8
,p_column_id=>wwv_flow_imp.id(170660746360036885)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170671009912039659)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>9
,p_column_id=>wwv_flow_imp.id(170660826769036886)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170671903162039661)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>10
,p_column_id=>wwv_flow_imp.id(170660981490036887)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170672816770039663)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>11
,p_column_id=>wwv_flow_imp.id(170661076733036888)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170673736937039666)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>12
,p_column_id=>wwv_flow_imp.id(170661176493036889)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170674604706039669)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>13
,p_column_id=>wwv_flow_imp.id(170661279100036890)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170675565744039672)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>14
,p_column_id=>wwv_flow_imp.id(170661347054036891)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170676418498039674)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>15
,p_column_id=>wwv_flow_imp.id(170661472759036892)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170677362608039677)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>16
,p_column_id=>wwv_flow_imp.id(170661561892036893)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(170678227150039688)
,p_view_id=>wwv_flow_imp.id(170663396212039629)
,p_display_seq=>17
,p_column_id=>wwv_flow_imp.id(170661632980036894)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(170414416574720829)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(189814661071164426)
,p_button_name=>'CLOSE_REPORT'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(49924055995830420339)
,p_button_image_alt=>'Close Report'
,p_button_position=>'UP'
,p_button_alignment=>'RIGHT'
,p_button_redirect_url=>'f?p=&APP_ID.:1:&SESSION.::&DEBUG.:::'
,p_icon_css_classes=>'fa-chevron-circle-left'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(170384957938698592)
,p_name=>'P2_CURRENT_ID'
,p_item_sequence=>90
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(170832002478731259)
,p_name=>'P2_SQL'
,p_item_sequence=>80
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(203231181297750304)
,p_name=>'P2_NUM_COL_LABEL_1'
,p_item_sequence=>150
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(203231267973750305)
,p_name=>'P2_NUM_COL_LABEL_2'
,p_item_sequence=>160
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(203231369304750306)
,p_name=>'P2_NUM_COL_LABEL_3'
,p_item_sequence=>170
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(203231468688750307)
,p_name=>'P2_NUM_COL_LABEL_4'
,p_item_sequence=>180
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(203231546614750308)
,p_name=>'P2_NUM_COL_LABEL_5'
,p_item_sequence=>190
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(203231656459750309)
,p_name=>'P2_DATE_COL_LABEL_1'
,p_item_sequence=>200
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(203231801459750310)
,p_name=>'P2_DATE_COL_LABEL_2'
,p_item_sequence=>210
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(203231862800750311)
,p_name=>'P2_DATE_COL_LABEL_3'
,p_item_sequence=>220
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(203231946372750312)
,p_name=>'P2_DATE_COL_LABEL_4'
,p_item_sequence=>230
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(203232117876750313)
,p_name=>'P2_DATE_COL_LABEL_5'
,p_item_sequence=>240
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(224669215485590360)
,p_name=>'P2_COL_COUNT'
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(224968093701986478)
,p_name=>'P2_VAR_COL_LABEL_1'
,p_item_sequence=>100
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_encrypt_session_state_yn=>'N'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(224968204858986479)
,p_name=>'P2_VAR_COL_LABEL_2'
,p_item_sequence=>110
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(224968303733986480)
,p_name=>'P2_VAR_COL_LABEL_3'
,p_item_sequence=>120
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(224968426138986481)
,p_name=>'P2_VAR_COL_LABEL_4'
,p_item_sequence=>130
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(224968447209986482)
,p_name=>'P2_VAR_COL_LABEL_5'
,p_item_sequence=>140
,p_item_plug_id=>wwv_flow_imp.id(221781627007156647)
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(170582405376924979)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Init Items'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
':P2_VAR_COL_LABEL_1   := NULL;',
':P2_VAR_COL_LABEL_2   := null;  ',
':P2_VAR_COL_LABEL_3  := null;',
':P2_VAR_COL_LABEL_4  := null;',
':P2_VAR_COL_LABEL_5  := null;',
':P2_NUM_COL_LABEL_1  := null;',
':P2_NUM_COL_LABEL_2  := null;',
':P2_NUM_COL_LABEL_3  := null;',
':P2_NUM_COL_LABEL_4  := null;',
':P2_NUM_COL_LABEL_5  := null;',
':P2_DATE_COL_LABEL_1  := NULL; ',
':P2_DATE_COL_LABEL_2  := NULL; ',
':P2_DATE_COL_LABEL_3  := NULL; ',
':P2_DATE_COL_LABEL_4  := NULL; ',
':P2_DATE_COL_LABEL_5  := NULL;'))
,p_process_clob_language=>'PLSQL'
,p_internal_uid=>16663113692896629
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(170431247285720843)
,p_process_sequence=>20
,p_process_point=>'BEFORE_HEADER'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Fill Collection'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'declare ',
'    l_sql VARCHAR2(4000);',
'    l_cursor_id INTEGER;',
'    l_desc_tab dbms_sql.desc_tab;',
'    l_col_cnt   INTEGER;',
'    l_char_columns varchar2(4000);',
'    l_date_columns varchar2(4000);',
'    l_num_columns varchar2(4000);',
'    l_char_counter number := 0;',
'    l_num_counter number := 0;',
'    l_date_counter number := 0;',
'begin',
'',
' ',
'',
'',
'  SELECT showsql into l_sql from OCW23_PROMPTS where id = :P2_CURRENT_ID;',
'',
'   APEX_DEBUG.INFO(''INIT l_sql - ''||l_sql || '' id - ''||:P2_CURRENT_ID);',
'   begin',
'      APEX_COLLECTION.DELETE_COLLECTION(',
'            p_collection_name => ''RESPONSE_REPORT_JARVIS'') ;',
'    exception',
'    when others then ',
'        null;',
'    end;',
'',
'  l_cursor_id := DBMS_SQL.OPEN_CURSOR;',
'  dbms_sql.parse(l_cursor_id, l_sql, dbms_sql.native);',
'  dbms_sql.describe_columns(l_cursor_id, l_col_cnt, l_desc_tab);',
'',
'  :P2_COL_COUNT := l_col_cnt;',
'',
'  FOR i IN 1..l_col_cnt LOOP',
'',
'  IF  l_desc_tab(i).col_type = 1 then -- VARCHAR2',
'    l_char_counter := l_char_counter + 1;',
'    if l_char_counter > 5 then',
'        CONTINUE;',
'    end if;',
'    APEX_UTIL.SET_SESSION_STATE(''P2_VAR_COL_LABEL_''||l_char_counter, l_desc_tab(i).col_name, true); ',
'',
'    l_char_columns := l_char_columns || '',"''||l_desc_tab(i).col_name||''" AS C00''||l_char_counter;',
'',
'  ELSif l_desc_tab(i).col_type = 2 then -- NUMBER',
'    l_num_counter := l_num_counter + 1;',
'    if l_num_counter > 5 then',
'        CONTINUE;',
'    end if;',
'    APEX_UTIL.SET_SESSION_STATE(''P2_NUM_COL_LABEL_''||l_num_counter, l_desc_tab(i).col_name, true); ',
'APEX_DEBUG.INFO(''P2_NUM_COL_LABEL_''||l_num_counter ||''- ''||APEX_UTIL.gET_SESSION_STATE(''P2_NUM_COL_LABEL_''||l_num_counter));',
'    l_num_columns := l_num_columns || '',"''||l_desc_tab(i).col_name ||''" AS N00''||l_num_counter;',
'   ELSif l_desc_tab(i).col_type = 12 then -- DATE',
'    l_date_counter := l_date_counter + 1;',
'     if l_date_counter > 5 then',
'        CONTINUE;',
'    end if;',
'    APEX_UTIL.SET_SESSION_STATE(''P2_DATE_COL_LABEL_''||l_date_counter, l_desc_tab(i).col_name, true); ',
'',
'    l_date_columns := l_date_columns || '',"''||l_desc_tab(i).col_name||''" AS D00''||l_date_counter;',
'',
'  END IF;',
'',
'  ',
'',
'  ',
'  end loop;',
'',
'  ',
'',
'  if l_num_counter < 5 then ',
'    for i in l_num_counter +1..5 loop',
'        l_num_columns := l_num_columns ||'',null AS N00''||i;',
'    end loop;',
'  end if;',
'',
' if l_date_counter < 5 then ',
'    for i in l_date_counter+1..5 loop',
'        l_date_columns := l_date_columns ||'',null AS D00''||i;',
'    end loop;',
'  end if;',
'',
'',
'',
'  IF INSTR(l_CHAR_columns, '','') = 1 THEN ',
'    l_CHAR_columns := SUBSTR(l_CHAR_columns, 2);',
'  END IF;',
'',
'  IF INSTR(l_num_columns, '','') = 1 THEN ',
'    l_num_columns := SUBSTR(l_num_columns, 2);',
'  END IF;',
'',
' IF INSTR(l_date_columns, '','') = 1 THEN ',
'    l_date_columns := SUBSTR(l_date_columns, 2);',
'  END IF;',
'',
'',
'  APEX_DEBUG.INFO(''l_date_columns - ''||l_date_columns);',
'  APEX_DEBUG.INFO(''l_num_columns - ''||l_num_columns);',
'  APEX_DEBUG.INFO(''l_CHAR_columns - ''||l_CHAR_columns);',
'',
' ',
'  l_sql := ''SELECT '' || l_num_columns||',
'  (CASE WHEN l_date_columns is not null then '' , ''||l_date_columns',
'    else null end )||(CASE WHEN l_char_columns is not null then '' , ''||l_char_columns',
'    else null end ) ||'' FROM (''||l_sql||'' )'';',
'',
'  APEX_DEBUG.INFO(''l_sql - ''||l_sql);',
'',
'--   APEX_COLLECTION.CREATE_COLLECTION_FROM_QUERY2 (',
'--         p_collection_name => ''RESPONSE_REPORT_JARVIS'', ',
'--         p_query => l_sql,',
'--         p_generate_md5 => ''NO'');',
'',
':P2_SQL := l_sql;',
'',
'',
'end;'))
,p_process_clob_language=>'PLSQL'
,p_internal_uid=>16511955601692493
);
end;
/
prompt --application/pages/page_00003
begin
wwv_flow_imp_page.create_page(
 p_id=>3
,p_name=>'Explain'
,p_alias=>'EXPLAIN'
,p_step_title=>'Explain'
,p_autocomplete_on_off=>'OFF'
,p_inline_css=>wwv_flow_string.join(wwv_flow_t_varchar2(
'pre{',
'    white-space: pre-wrap !important;       /* Since CSS 2.1 */',
'    white-space: -moz-pre-wrap !important;  /* Mozilla, since 1999 */',
'    white-space: -pre-wrap !important;      /* Opera 4-6 */',
'    white-space: -o-pre-wrap !important;    /* Opera 7 */',
'    word-wrap: break-word !important;       /* Internet Explorer 5.5+ */',
'    font-family: inherit !important;',
'    font-size: inherit !important;',
'}'))
,p_page_template_options=>'#DEFAULT#'
,p_overwrite_navigation_list=>'Y'
,p_navigation_list_position=>'SIDE'
,p_navigation_list_id=>wwv_flow_imp.id(172644861450333789)
,p_navigation_list_template_id=>wwv_flow_imp.id(49924044504368420333)
,p_nav_list_template_options=>'#DEFAULT#:t-TreeNav--styleA:js-navCollapsed--hidden'
,p_protection_level=>'C'
,p_page_component_map=>'25'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(170111250556887825)
,p_plug_name=>'Breadcrumb'
,p_region_sub_css_classes=>'u-textCenter'
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(49923995796476420313)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_imp.id(49923480142300420265)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_imp.id(49924058328176420340)
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(170661982532036897)
,p_plug_name=>'New'
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader js-removeLandmark:t-Region--noUI:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(49923983431248420308)
,p_plug_display_sequence=>10
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'expand_shortcuts', 'N',
  'output_as', 'HTML')).to_clob
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(173693777660226871)
,p_plug_name=>'Explanation'
,p_region_template_options=>'#DEFAULT#:margin-top-none'
,p_plug_template=>wwv_flow_imp.id(49923516768000420281)
,p_plug_display_sequence=>20
,p_function_body_language=>'PLSQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'declare',
'    l_explanation clob;',
'    l_showsql OCW23_PROMPTS.showsql%type;',
'    l_profile_name user_cloud_ai_profiles.profile_name%type := lower(APEX_UTIL.GET_PREFERENCE(       ',
'         p_preference => ''CLOUD_AI_PROFILE'',',
'            p_user       => :APP_USER));',
'begin',
'    SELECT SHOWSQL into l_showsql FROM OCW23_PROMPTS WHERE ID = :P3_CURRENT_ID;',
'',
'    -- ''explain this sql query to a non-technical user:'' ',
'    return ''<h3>Explanation: </h3><div><pre>''||dbms_cloud_ai.generate(',
'            prompt => ''explain this sql query to a non-technical user: ''||l_showsql  ,',
'            action => ''chat'',',
'            profile_name => l_profile_name',
'    )||''</pre></div>'';',
'',
'end;'))
,p_lazy_loading=>true
,p_plug_source_type=>'NATIVE_DYNAMIC_CONTENT'
,p_ajax_items_to_submit=>'P3_CURRENT_ID'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(170112755646892887)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(170661982532036897)
,p_button_name=>'UPDATE_SQL'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(49924056692230420339)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Update SQL'
,p_button_position=>'CHANGE'
,p_button_alignment=>'RIGHT'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(168101451738992599)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(170111250556887825)
,p_button_name=>'CLOSE_SQL'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(49924055995830420339)
,p_button_image_alt=>'Close SQL'
,p_button_position=>'UP'
,p_button_alignment=>'RIGHT'
,p_button_redirect_url=>'f?p=&APP_ID.:1:&SESSION.::&DEBUG.:::'
,p_icon_css_classes=>'fa-chevron-circle-left'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(168101283023992597)
,p_name=>'P3_CURRENT_ID'
,p_item_sequence=>40
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(170111977540890971)
,p_name=>'P3_SQL'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(170661982532036897)
,p_use_cache_before_default=>'NO'
,p_source=>'SELECT SHOWSQL FROM OCW23_PROMPTS WHERE ID = :P3_CURRENT_ID;'
,p_source_type=>'QUERY'
,p_display_as=>'PLUGIN_COM.APEXBYG.BLOGSPOT.CODEMIRROR'
,p_field_template=>wwv_flow_imp.id(49924054164191420338)
,p_item_template_options=>'#DEFAULT#'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_validation(
 p_id=>wwv_flow_imp.id(170662158014036899)
,p_validation_name=>'Check Valid SQL'
,p_validation_sequence=>10
,p_validation=>wwv_flow_string.join(wwv_flow_t_varchar2(
'declare',
'    l_cursor NUMBER := dbms_sql.open_cursor;',
'BEGIN',
'            DBMS_SQL.PARSE (l_cursor, :P3_SQL, DBMS_SQL.native);',
'            return null;',
'        EXCEPTION',
'            WHEN OTHERS THEN',
'                return sqlerrm;',
'END;'))
,p_validation2=>'PLSQL'
,p_validation_type=>'FUNC_BODY_RETURNING_ERR_TEXT'
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(170661865679036896)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'update SQL'
,p_process_sql_clob=>'update OCW23_PROMPTS set showsql = REPLACE(:P3_SQL,'';'') where id = :P3_CURRENT_ID;'
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_success_message=>'SQL Updated'
,p_internal_uid=>16742573995008546
);
end;
/
prompt --application/pages/page_09999
begin
wwv_flow_imp_page.create_page(
 p_id=>9999
,p_name=>'Login Page'
,p_alias=>'LOGIN'
,p_step_title=>'ChatDB - Log In'
,p_warn_on_unsaved_changes=>'N'
,p_first_item=>'AUTO_FIRST_ITEM'
,p_autocomplete_on_off=>'OFF'
,p_inline_css=>wwv_flow_string.join(wwv_flow_t_varchar2(
'.t-Login-logo{',
'    background-color: transparent !important;',
'}'))
,p_step_template=>wwv_flow_imp.id(49923491466470420271)
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_protection_level=>'C'
,p_page_component_map=>'12'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(49924170178613420399)
,p_plug_name=>'ChatDB'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(49923978206151420305)
,p_plug_display_sequence=>10
,p_region_image=>'#APP_FILES#icons/app-icon-512.png'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'expand_shortcuts', 'N',
  'output_as', 'HTML',
  'show_line_breaks', 'Y')).to_clob
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(49924172413965420400)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_imp.id(49924170178613420399)
,p_button_name=>'LOGIN'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(49924056692230420339)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Sign In'
,p_button_position=>'NEXT'
,p_button_alignment=>'LEFT'
,p_grid_new_row=>'Y'
,p_grid_new_column=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(170831717039731256)
,p_name=>'P9999_PERSISTENT_AUTH'
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_imp.id(49924170178613420399)
,p_prompt=>'Remember me'
,p_display_as=>'NATIVE_SINGLE_CHECKBOX'
,p_display_when=>'apex_authentication.persistent_auth_enabled'
,p_display_when2=>'PLSQL'
,p_display_when_type=>'EXPRESSION'
,p_field_template=>wwv_flow_imp.id(49924053909586420337)
,p_item_template_options=>'#DEFAULT#'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(49924170963983420399)
,p_name=>'P9999_USERNAME'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(49924170178613420399)
,p_prompt=>'Username'
,p_placeholder=>'Username'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>40
,p_cMaxlength=>100
,p_tag_attributes=>'autocomplete="username"'
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(49924053909586420337)
,p_item_icon_css_classes=>'fa-user'
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(49924171652389420400)
,p_name=>'P9999_PASSWORD'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(49924170178613420399)
,p_prompt=>'Password'
,p_placeholder=>'Password'
,p_display_as=>'NATIVE_PASSWORD'
,p_cSize=>40
,p_cMaxlength=>100
,p_tag_attributes=>'autocomplete="current-password"'
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(49924053909586420337)
,p_item_icon_css_classes=>'fa-key'
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(49924172002864420400)
,p_name=>'P9999_REMEMBER'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_imp.id(49924170178613420399)
,p_prompt=>'Remember username'
,p_display_as=>'NATIVE_SINGLE_CHECKBOX'
,p_display_when=>'apex_authentication.persistent_cookies_enabled and not apex_authentication.persistent_auth_enabled'
,p_display_when2=>'PLSQL'
,p_display_when_type=>'EXPRESSION'
,p_field_template=>wwv_flow_imp.id(49924053909586420337)
,p_item_template_options=>'#DEFAULT#'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(49924174627827420402)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_INVOKE_API'
,p_process_name=>'Set Username Cookie'
,p_attribute_01=>'PLSQL_PACKAGE'
,p_attribute_03=>'APEX_AUTHENTICATION'
,p_attribute_04=>'SEND_LOGIN_USERNAME_COOKIE'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>49752329974128994016
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
 p_id=>wwv_flow_imp.id(49924175059887420402)
,p_page_process_id=>wwv_flow_imp.id(49924174627827420402)
,p_page_id=>9999
,p_name=>'p_username'
,p_direction=>'IN'
,p_data_type=>'VARCHAR2'
,p_has_default=>false
,p_display_sequence=>1
,p_value_type=>'EXPRESSION'
,p_value_language=>'PLSQL'
,p_value=>'lower( :P9999_USERNAME )'
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
 p_id=>wwv_flow_imp.id(49924175610080420402)
,p_page_process_id=>wwv_flow_imp.id(49924174627827420402)
,p_page_id=>9999
,p_name=>'p_consent'
,p_direction=>'IN'
,p_data_type=>'BOOLEAN'
,p_has_default=>false
,p_display_sequence=>2
,p_value_type=>'ITEM'
,p_value=>'P9999_REMEMBER'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(49924172728168420401)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_INVOKE_API'
,p_process_name=>'Login'
,p_attribute_01=>'PLSQL_PACKAGE'
,p_attribute_03=>'APEX_AUTHENTICATION'
,p_attribute_04=>'LOGIN'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>49752328074469994015
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
 p_id=>wwv_flow_imp.id(49924173169028420401)
,p_page_process_id=>wwv_flow_imp.id(49924172728168420401)
,p_page_id=>9999
,p_name=>'p_username'
,p_direction=>'IN'
,p_data_type=>'VARCHAR2'
,p_has_default=>false
,p_display_sequence=>1
,p_value_type=>'ITEM'
,p_value=>'P9999_USERNAME'
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
 p_id=>wwv_flow_imp.id(49924173739867420401)
,p_page_process_id=>wwv_flow_imp.id(49924172728168420401)
,p_page_id=>9999
,p_name=>'p_password'
,p_direction=>'IN'
,p_data_type=>'VARCHAR2'
,p_has_default=>false
,p_display_sequence=>2
,p_value_type=>'ITEM'
,p_value=>'P9999_PASSWORD'
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
 p_id=>wwv_flow_imp.id(49924174209292420402)
,p_page_process_id=>wwv_flow_imp.id(49924172728168420401)
,p_page_id=>9999
,p_name=>'p_set_persistent_auth'
,p_direction=>'IN'
,p_data_type=>'BOOLEAN'
,p_has_default=>true
,p_display_sequence=>3
,p_value_type=>'FUNCTION_BODY'
,p_value_language=>'PLSQL'
,p_value=>'return nvl(:P9999_PERSISTENT_AUTH,''N'')=''Y'';'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(49924176506551420403)
,p_process_sequence=>30
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_SESSION_STATE'
,p_process_name=>'Clear Page(s) Cache'
,p_attribute_01=>'CLEAR_CACHE_CURRENT_PAGE'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>49752331852852994017
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(49924176131147420403)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Get Username Cookie'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
':P9999_USERNAME := apex_authentication.get_login_username_cookie;',
':P9999_REMEMBER := case when :P9999_USERNAME is not null then ''Y'' end;'))
,p_process_clob_language=>'PLSQL'
,p_internal_uid=>49752331477448994017
);
end;
/
prompt --application/pages/page_20000
begin
wwv_flow_imp_page.create_page(
 p_id=>20000
,p_name=>'Settings'
,p_alias=>'SETTINGS'
,p_page_mode=>'MODAL'
,p_step_title=>'Settings'
,p_autocomplete_on_off=>'OFF'
,p_group_id=>wwv_flow_imp.id(173443284116560812)
,p_step_template=>wwv_flow_imp.id(49923480901596420266)
,p_page_template_options=>'#DEFAULT#:t-Dialog--noPadding:js-dialog-class-t-Drawer--pullOutEnd:js-dialog-class-t-Drawer--md'
,p_required_patch=>wwv_flow_imp.id(173443769302560824)
,p_protection_level=>'C'
,p_help_text=>'This page contains a list of settings applicable to the current application user.'
,p_page_component_map=>'23'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(173448386601560853)
,p_plug_name=>'&APP_USER.'
,p_region_template_options=>'#DEFAULT#:t-HeroRegion--hideIcon'
,p_plug_template=>wwv_flow_imp.id(49923550068883420294)
,p_plug_display_sequence=>10
,p_plug_display_condition_type=>'NOT_EXISTS'
,p_plug_display_when_condition=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select 1',
'  from apex_application_auth ',
' where application_id            = :APP_ID ',
'   and is_current_authentication = ''Y'' ',
'   and scheme_type_code          = ''NATIVE_APEX_ACCOUNTS'''))
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'expand_shortcuts', 'N',
  'output_as', 'HTML')).to_clob
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(173448729274560853)
,p_plug_name=>'&APP_USER.'
,p_region_template_options=>'#DEFAULT#:t-CardsRegion--styleB'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(49923523945940420284)
,p_plug_display_sequence=>20
,p_query_type=>'TABLE'
,p_query_table=>'APEX_WORKSPACE_APEX_USERS'
,p_query_where=>'user_name = :APP_USER'
,p_include_rowid_column=>false
,p_lazy_loading=>false
,p_plug_source_type=>'NATIVE_CARDS'
,p_plug_query_num_rows_type=>'SCROLL'
,p_show_total_row_count=>false
,p_plug_display_condition_type=>'EXISTS'
,p_plug_display_when_condition=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select 1 ',
'  from apex_application_auth ',
' where application_id            = :APP_ID ',
'   and is_current_authentication = ''Y'' ',
'   and scheme_type_code          = ''NATIVE_APEX_ACCOUNTS'''))
);
wwv_flow_imp_page.create_card(
 p_id=>wwv_flow_imp.id(173449238516560855)
,p_region_id=>wwv_flow_imp.id(173448729274560853)
,p_layout_type=>'ROW'
,p_card_css_classes=>'a-CardView--noUI'
,p_title_adv_formatting=>false
,p_title_column_name=>'USER_NAME'
,p_sub_title_adv_formatting=>false
,p_sub_title_column_name=>'EMAIL'
,p_body_adv_formatting=>false
,p_second_body_adv_formatting=>false
,p_icon_source_type=>'INITIALS'
,p_icon_class_column_name=>'EMAIL'
,p_icon_position=>'START'
,p_media_adv_formatting=>false
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(173449759341560859)
,p_plug_name=>'Settings'
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#:t-MediaList--showBadges:u-colors'
,p_plug_template=>wwv_flow_imp.id(49923516768000420281)
,p_plug_display_sequence=>30
,p_list_id=>wwv_flow_imp.id(173447316095560844)
,p_plug_source_type=>'NATIVE_LIST'
,p_list_template_id=>wwv_flow_imp.id(49924039753404420331)
);
end;
/
prompt --application/pages/page_20010
begin
wwv_flow_imp_page.create_page(
 p_id=>20010
,p_name=>'Push Notifications'
,p_alias=>'PUSH-NOTIFICATIONS'
,p_page_mode=>'MODAL'
,p_step_title=>'Settings - Push Notifications'
,p_warn_on_unsaved_changes=>'N'
,p_autocomplete_on_off=>'OFF'
,p_group_id=>wwv_flow_imp.id(173443284116560812)
,p_javascript_code_onload=>'apex.pwa.initPushSubscriptionPage();'
,p_step_template=>wwv_flow_imp.id(49923480901596420266)
,p_page_template_options=>'#DEFAULT#:js-dialog-class-t-Drawer--pullOutEnd'
,p_required_patch=>wwv_flow_imp.id(173443469788560819)
,p_protection_level=>'C'
,p_help_text=>'This page contains the settings for controlling push notification subscription for the current user.'
,p_page_component_map=>'17'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(173444842696560831)
,p_plug_name=>'Push Notifications Not Supported'
,p_region_css_classes=>'a-pwaPush--subscriptionRegion--not-supported'
,p_icon_css_classes=>'fa-bell-slash-o'
,p_region_template_options=>'#DEFAULT#:t-Alert--colorBG:t-Alert--wizard:t-Alert--customIcons:t-Alert--warning:t-Alert--removeHeading js-removeLandmark:t-Form--xlarge'
,p_region_attributes=>'style="display:none;"'
,p_plug_template=>wwv_flow_imp.id(49923511595007420278)
,p_plug_display_sequence=>20
,p_plug_item_display_point=>'BELOW'
,p_plug_source=>'Push notifications are not currently supported in your browser.'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'expand_shortcuts', 'N',
  'output_as', 'HTML')).to_clob
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(173445113914560834)
,p_plug_name=>'Push Notifications'
,p_region_css_classes=>'a-pwaPush--subscriptionRegion'
,p_icon_css_classes=>'fa-bell-o'
,p_region_template_options=>'#DEFAULT#:t-Alert--colorBG:t-Alert--wizard:t-Alert--customIcons:t-Alert--info:t-Alert--removeHeading js-removeLandmark:t-Form--xlarge'
,p_plug_template=>wwv_flow_imp.id(49923511595007420278)
,p_plug_display_sequence=>30
,p_plug_item_display_point=>'BELOW'
,p_plug_source=>'Push notifications have to be enabled for each device you want to receive the notifications on. The first time you enable push notifications, you will have to grant permission to your browser. This setting can be changed at any time.'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'expand_shortcuts', 'N',
  'output_as', 'HTML')).to_clob
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(173444440551560828)
,p_button_sequence=>10
,p_button_name=>'BACK'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#:t-Button--link:t-Button--iconLeft'
,p_button_template_id=>wwv_flow_imp.id(49924056832481420339)
,p_button_image_alt=>'Settings'
,p_button_alignment=>'RIGHT'
,p_button_redirect_url=>'f?p=&APP_ID.:20000:&APP_SESSION.::&DEBUG.:::'
,p_button_css_classes=>'t-Button--inlineLink'
,p_icon_css_classes=>'fa-chevron-left'
,p_grid_new_row=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(173445618656560837)
,p_name=>'P20010_ENABLE_PUSH'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(173445113914560834)
,p_prompt=>'Enable push notifications on this device'
,p_display_as=>'NATIVE_SINGLE_CHECKBOX'
,p_field_template=>wwv_flow_imp.id(49924054164191420338)
,p_item_template_options=>'#DEFAULT#:margin-top-sm'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(173445927039560838)
,p_name=>'Change P20010_ENABLE_PUSH'
,p_event_sequence=>10
,p_triggering_element_type=>'ITEM'
,p_triggering_element=>'P20010_ENABLE_PUSH'
,p_condition_element=>'P20010_ENABLE_PUSH'
,p_triggering_condition_type=>'EQUALS'
,p_triggering_expression=>'Y'
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'change'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(173446454648560841)
,p_event_id=>wwv_flow_imp.id(173445927039560838)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_name=>'Subscribe to push notifications'
,p_action=>'NATIVE_JAVASCRIPT_CODE'
,p_attribute_01=>'apex.pwa.subscribePushNotifications();'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(173446903682560843)
,p_event_id=>wwv_flow_imp.id(173445927039560838)
,p_event_result=>'FALSE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_name=>'Unsubscribe from push notifications'
,p_action=>'NATIVE_JAVASCRIPT_CODE'
,p_attribute_01=>'apex.pwa.unsubscribePushNotifications();'
);
end;
/
prompt --application/pages/page_20020
begin
wwv_flow_imp_page.create_page(
 p_id=>20020
,p_name=>'AI Settings'
,p_alias=>'AI-SETTINGS'
,p_page_mode=>'MODAL'
,p_step_title=>'AI Settings'
,p_warn_on_unsaved_changes=>'N'
,p_autocomplete_on_off=>'OFF'
,p_group_id=>wwv_flow_imp.id(173443284116560812)
,p_javascript_code_onload=>'apex.pwa.initPushSubscriptionPage();'
,p_step_template=>wwv_flow_imp.id(49923480901596420266)
,p_page_template_options=>'#DEFAULT#:js-dialog-class-t-Drawer--pullOutEnd'
,p_required_patch=>wwv_flow_imp.id(173443469788560819)
,p_protection_level=>'C'
,p_help_text=>'This page contains the settings for controlling push notification subscription for the current user.'
,p_page_component_map=>'17'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(184015345438918252)
,p_plug_name=>'Push Notifications'
,p_region_css_classes=>'a-pwaPush--subscriptionRegion'
,p_icon_css_classes=>'fa-bell-o'
,p_region_template_options=>'#DEFAULT#:t-Alert--colorBG:t-Alert--wizard:t-Alert--customIcons:t-Alert--info:t-Alert--removeHeading js-removeLandmark:t-Form--xlarge'
,p_plug_template=>wwv_flow_imp.id(49923511595007420278)
,p_plug_display_sequence=>30
,p_plug_item_display_point=>'BELOW'
,p_plug_source=>'Please select a Profile to be used by the application. Profile selected here will be saved as a user preference.'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'expand_shortcuts', 'N',
  'output_as', 'HTML')).to_clob
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(173453612654584823)
,p_button_sequence=>10
,p_button_name=>'BACK'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#:t-Button--link:t-Button--iconLeft'
,p_button_template_id=>wwv_flow_imp.id(49924056832481420339)
,p_button_image_alt=>'Settings'
,p_button_alignment=>'RIGHT'
,p_button_redirect_url=>'f?p=&APP_ID.:20000:&APP_SESSION.::&DEBUG.:::'
,p_button_css_classes=>'t-Button--inlineLink'
,p_icon_css_classes=>'fa-chevron-left'
,p_grid_new_row=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(173455581373587920)
,p_name=>'P20020_SERVICE'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(184015345438918252)
,p_prompt=>'Service'
,p_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'RETURN APEX_UTIL.GET_PREFERENCE(      ',
'        p_preference => ''CLOUD_AI_PROFILE'',',
'        p_user       => :APP_USER);'))
,p_source_type=>'FUNCTION_BODY'
,p_source_language=>'PLSQL'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_lov=>'select profile_name d, profile_name r from user_cloud_ai_profiles;'
,p_lov_display_null=>'YES'
,p_lov_null_text=>'-- Select a Profile --'
,p_cHeight=>1
,p_field_template=>wwv_flow_imp.id(49924054164191420338)
,p_item_template_options=>'#DEFAULT#'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'NONE'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(172679608554999578)
,p_name=>'Set AI_SERVICE'
,p_event_sequence=>10
,p_triggering_element_type=>'ITEM'
,p_triggering_element=>'P20020_SERVICE'
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'change'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(172679675377999579)
,p_event_id=>wwv_flow_imp.id(172679608554999578)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_EXECUTE_PLSQL_CODE'
,p_attribute_01=>wwv_flow_string.join(wwv_flow_t_varchar2(
'  APEX_UTIL.SET_PREFERENCE(        ',
'        p_preference => ''CLOUD_AI_PROFILE'',',
'        p_value      => :P20020_SERVICE,      ',
'        p_user       => :APP_USER); '))
,p_attribute_02=>'P20020_SERVICE'
,p_attribute_05=>'PLSQL'
,p_wait_for_result=>'Y'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(173454162658584826)
,p_name=>'Change P20020_ENABLE_PUSH'
,p_event_sequence=>10
,p_triggering_element_type=>'ITEM'
,p_triggering_element=>'P20020_ENABLE_PUSH'
,p_condition_element=>'P20020_ENABLE_PUSH'
,p_triggering_condition_type=>'EQUALS'
,p_triggering_expression=>'Y'
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'change'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(173454605671584828)
,p_event_id=>wwv_flow_imp.id(173454162658584826)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_name=>'Subscribe to push notifications'
,p_action=>'NATIVE_JAVASCRIPT_CODE'
,p_attribute_01=>'apex.pwa.subscribePushNotifications();'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(173455130270584830)
,p_event_id=>wwv_flow_imp.id(173454162658584826)
,p_event_result=>'FALSE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_name=>'Unsubscribe from push notifications'
,p_action=>'NATIVE_JAVASCRIPT_CODE'
,p_attribute_01=>'apex.pwa.unsubscribePushNotifications();'
);
end;
/
prompt --application/deployment/definition
begin
wwv_flow_imp_shared.create_install(
 p_id=>wwv_flow_imp.id(50917928699703154117)
,p_required_free_kb=>100
,p_required_sys_privs=>'CREATE PROCEDURE:CREATE TABLE:CREATE TRIGGER:CREATE VIEW'
);
end;
/
prompt --application/deployment/install/install_db_objects
begin
wwv_flow_imp_shared.create_install_script(
 p_id=>wwv_flow_imp.id(175284143227957637)
,p_install_id=>wwv_flow_imp.id(50917928699703154117)
,p_name=>'DB Objects'
,p_sequence=>10
,p_script_type=>'INSTALL'
,p_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'  CREATE TABLE "OCW23_CONVERSATIONS" ',
'   (	"ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, ',
'	"SUMMARY" VARCHAR2(4000 CHAR) COLLATE "USING_NLS_COMP", ',
'	"USERNAME" VARCHAR2(100 CHAR) COLLATE "USING_NLS_COMP", ',
'	"STARTED_ON" TIMESTAMP (6), ',
'	 CONSTRAINT "CONVERSATIONS_ID_PK" PRIMARY KEY ("ID")',
'  USING INDEX  ENABLE',
'   )  DEFAULT COLLATION "USING_NLS_COMP" ;',
'',
'  CREATE TABLE "OCW23_PROMPTS" ',
'   (	"ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, ',
'	"CONV_ID" NUMBER NOT NULL ENABLE, ',
'	"PROMPT" VARCHAR2(4000 CHAR) COLLATE "USING_NLS_COMP", ',
'	"RESPONSE" CLOB COLLATE "USING_NLS_COMP", ',
'	"ASKED_ON" TIMESTAMP (6), ',
'	"SHOWSQL" VARCHAR2(4000) COLLATE "USING_NLS_COMP", ',
'	 CONSTRAINT "PROMPTS_ID_PK" PRIMARY KEY ("ID")',
'  USING INDEX  ENABLE',
'   )  DEFAULT COLLATION "USING_NLS_COMP" ;',
'',
'  ALTER TABLE "OCW23_PROMPTS" ADD CONSTRAINT "PROMPTS_CONV_ID_FK" FOREIGN KEY ("CONV_ID")',
'	  REFERENCES "OCW23_CONVERSATIONS" ("ID") ON DELETE CASCADE ENABLE;',
'',
'  CREATE INDEX "PROMPTS_I1" ON "OCW23_PROMPTS" ("CONV_ID") ',
'  ;',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
' '))
);
wwv_flow_imp_shared.create_install_object(
 p_id=>wwv_flow_imp.id(175284425311957646)
,p_script_id=>wwv_flow_imp.id(175284143227957637)
,p_object_owner=>'#OWNER#'
,p_object_type=>'TABLE'
,p_object_name=>'OCW23_CONVERSATIONS'
);
wwv_flow_imp_shared.create_install_object(
 p_id=>wwv_flow_imp.id(175284282822957646)
,p_script_id=>wwv_flow_imp.id(175284143227957637)
,p_object_owner=>'#OWNER#'
,p_object_type=>'TABLE'
,p_object_name=>'OCW23_PROMPTS'
);
end;
/
prompt --application/deployment/checks
begin
null;
end;
/
prompt --application/deployment/buildoptions
begin
null;
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
