wwv_flow_imp.g_varchar2_table(1314) := '881BAE544684D0A9F98C0000100149444154FE14B04AAC057112D92DB96D9AE780730AC780A684250D17BBEEC4B08DA5DD6B53BF9680D5F03933E588AF8D5189716BC4DE41DAC9F4BC92CB6D4FDF45B4CAC4A7B83E66053E0330AF61773D78D79130D5C4';
wwv_flow_imp.g_varchar2_table(1315) := 'F0CA396C0E15DEDEDD6336FB93845B01C278DDBA2CB7F626CED559C5BAE14CA51D8C9F9C99547CABE23FF9B3FFBD3126AC1F87AB26DEF0BC77CF466BD6541C470B3F3E04980810C99825BA1920B61F231424411CE8F9EFF3160073478D8BBB715A8DC02B';
wwv_flow_imp.g_varchar2_table(1316) := '217B95E0539ED3ECA4BD549DA7F86F04B90167229CB95F8AFF159198754A24E2CC068B31C59D8EB779A9BDD5DC36397F9CF3D767007EFDC7E3FF3F3F0FC070C0083B89BF8BD9F5A1ADC9C971F202BBF655ACAA781ACE71A2C07AD4E00505328977E2ED76';
wwv_flow_imp.g_varchar2_table(1317) := 'CF669D899DF924628AF3E435E4E4999BC381BA6154FA91F6C4F890079276B039DCF0A9C26D5BF3793D62EEF35B0037C3713B3CCD75CD398EC85AE0AAE66D88C691806A74139F139C5B50BC921792CB4DDE73D81C80B7F57925AFDB3CDEB9E72BF9DE5C9B';
wwv_flow_imp.g_varchar2_table(1318) := 'AE7948FDF9F1E7F077AD68195AAC6C31FECE9A376BA53A356BE039BF63CD9B3812EE0F776DE36DB9DBF1F73BF241C3807C83793923EBCC6FE2B1A9016A1D7603EC6AB0E909DBF3BC463F04980A3781F18E46DD988FDFB5EFBBD6DD363435FB7718950D88';
wwv_flow_imp.g_varchar2_table(1319) := '5AE16E86BA21886D6CEFEA1B23EB39C0ED3EB3FF9B5C36E79E589A6B9A9ABF538C6F0C405BDBFFEFE73D6A939E4CFCD3394E4C6DB033CF6D7199EE640FA760CD12C7261D6BE2C399B8E18277AF910C659BD7E33CFA04E0B6F9EF042D36EF7708E03BE355';
wwv_flow_imp.g_varchar2_table(1320) := '26A601778AC3B9CF570199F6BE39DE0230991E55BB77ACFFCA50368498C8E9A6AEEA9A261E66CCDC75DB1AB3F3DBB8DE598B7FC7B5586DDE898FDF5DE7CDFA8D01D8626BD3538C9519D14D3E496C37B19D19649C7D5B13966FAB399F0680BD6772025281';
wwv_flow_imp.g_varchar2_table(1321) := 'DD06BC21FDE4E0B6C5FF27CE7F479D18881D98FE893CDFBD675B37775EBB06134736F8F3B576C8DE5D97CDFCBC9BBCB67B63FD1539ABF758E7F59B5EBEBBE6AFEE7D73BDE35D1410E44986D357446F53CF669F9B7AB4313406A099F776BFED796D7DDE6D';
wwv_flow_imp.g_varchar2_table(1322) := '12E4CD147E0D7026A406F89DC1BD4252EF02D2BBD6F99DC06A81F30E616AEE4E6E6AB6B9A63D9761745B8336DF83D566FD0D819F75DB9C1BD2616B6DD7C7BA34D72BB3FA771BD6392FCDEC6CE24B7568F64B6B209734E7335CB8586ED76CF0A7CEB9E9CB';
wwv_flow_imp.g_varchar2_table(1323) := '66BF640066CEE7BFF17FE73C6E66DEE5AC3EF0C9FAF38EBE3418FCC09833000E50CC65B644F66A82CDF54D611D59A95C10C04C0C9AF8D8FA0C9CCD206DC8CBF5684B160DC8DE21D0CA586DEAE54844BD5FCF7A9DF271BD9F44A3888561B2C993112B33EA';
wwv_flow_imp.g_varchar2_table(1324) := '894C37F9259CB3E3CD3527C6F3235FC970CD351B33976A308F37B5C7F367DDB7D72BCE4D35C0EBD46C36F1341C97B8BEE156D490C7350A3388E5C779131F73B6A6D826E1C5BACD3A270D49C7192E70EED9DCA60F2B2A3E549AC2B8E6B35E8FAF0132F0B0';
wwv_flow_imp.g_varchar2_table(1325) := '42B026282273C2C51A743B94E93A0440222035FCB3B8A70E6A2DF7BA23E54D6CEDC0B77DB8118B54FB771E47F1DC1262538726DE24F0CD3C28E27064D4122E0AE0BBEAC4C82CADDD92399BB9641E5E9995A6CFCD3928A62868895719A7A47DDF9177EA8B';
wwv_flow_imp.g_varchar2_table(1326) := '320F2D06590E092B8F6BD26CA126E15B471837EB4F3204B7E29BFA320D51D200A6B32A2E667C14AE68DFE7EF004CF262C55481A7614DA06E9A8FB135809A429DC0CB626C06C53D01D8D6258148C538FB82A07775DAC6D7F47173CEC628FD0E03A0EEFC53';
wwv_flow_imp.g_varchar2_table(1327) := '0EA94F783C9DBF31276DCD1C31A4FCB6C7DF81A3DB1A6D63FDBBCE777D6A444671A2C3D61499ED4D9613CFAD91995C9DB8DD615FF11A7239AB0913D18DB0A63D9A9AA0E8CF6B142F33F3D51823558358C3F304009D9173118F63EE6B2C2C899BC13B04CD';
wwv_flow_imp.g_varchar2_table(1328) := '80BD15F4362675DEA6313764B6218C594B37B837716CC4A8ED6923102956676C6E6B8706A0218DC628A65C9A3514C1B40640CDC74D6C6D9FD3799BBDD1C03C7AF5F8FD7D1436C70D8AC35C9C0D56539E4E1C3635C0393FB9CF1AE05C6CC45799097C8AB4';
wwv_flow_imp.g_varchar2_table(1329) := 'AD57C27712ECA6A7D358A4F5CEB938DF730DA7274D3D660CEC7C3403E9AD06D57BC7FDE9D889F11BEFB1BF05E01CEA49646B001A87C21A9286B8BD8B4350A9419F20698715C92A11000EE92B84B2BDD6015D0D2E1B9C06A0DBBD6E73D9EE7383859BD836';
wwv_flow_imp.g_varchar2_table(1330) := 'C64491B19B89496C13530D813AE3A8080FAF4944EF6A964895ED955E63F5666F892019DF8ABE9AFB9637B07FE9A9E631418FEB907F536FE6F106FF0977B3B7EAE6118597EDAB44F9BCDECC10C332AEEB0418E35473755EC75F9DC5B72214EEDD5CCE3C1B';
wwv_flow_imp.g_varchar2_table(1331) := '4393624C1A7362F9FC5B00AC60EA3112025F0D26BA9C398CC901B9C633F035048D4380C04D03C880A28450811289BAD9D3E5D6928D3B2F9147535B4718CD10A73D9A3C9B7336A47B5397246C0A4348008C009550DDCC03C367834524D2C91B6DFD4FBC5B';
wwv_flow_imp.g_varchar2_table(1332) := '4C6ED7579874649B7088F3CE048C9DA3CE73A280B16CEB35EB8CBCE378E806F70D0FB25C534F1BEE987AC4748CCDC72616D43B8691D41BA57D0D9E523F50D71C867FDCDC3F9E004C30B0E16CC9C20D966B120EEA4D431900B129582865005233D3D02B91';
wwv_flow_imp.g_varchar2_table(1333) := '41D025F0273262F9A11B6DF6D890908BA91956757D8AA1C923D56B3BB84A40D2803191C4D9601862D7354699115CAAB37BCAE78487C57872D9F6289D9F8E37396ED648186C3886D58E89D2CDCDC7C4231ACD5B917077AF694DA6152A7F6738D2DC263E76';
wwv_flow_imp.g_varchar2_table(1334) := 'B5747865BAC3625137C20C0F8963522E4A5B128E93BECA59D97C0D90390D25384E7C13B162324E705961E6F5E9AEA621E629E85B30B09ACD61C0214A8D4EC382B126C02567DAC493EADDACD1888EEBE5CD1E0A87888984A1B627A9D6A906EC7A2438F6D4';
wwv_flow_imp.g_varchar2_table(1335) := '6D8B5F1747CAB5E943734EE208178712AEB46F630012AFB571DFC6D8989EA647499053AD36E2877CC73877CBF10CD30CB7F89ABBE93B31DCF46653AF193BF6C1190057A3A9239BF3BEFD1470727C787C267DC889AD8124C504700E8E2B2673BE4C945D13';
wwv_flow_imp.g_varchar2_table(1336) := '67815CCEA9A94CF850F0D99D1602AD69581AEAED71D64B16474B78F37DB1D9A39B61427249F5497D72A4D988BB7BACDF3CF24FBD513333CD7593A33B6733530C9F936054CD1856DCB9B32ECAB8A4DAB5C79BFAB1B5D2758933952835B86373D00A4433B7';
wwv_flow_imp.g_varchar2_table(1337) := 'B3CFCCFCBC237714FB9B3EDFE21AEBD7D67CD353A66DDB7DB0A72C5FAC63738DE3D14FED3A6F01B0A09348A840597089C48F0150D73AE0BF620012816CC18706C0991D752CC5D41E6F4D90AB3D0EAC226D27B24DEF534ED36C6DC0BFED5F8A4389C48C29';
wwv_flow_imp.g_varchar2_table(1338) := '09A122675C9B99C7965CDCF0B739260160E27643F06D3CB7847EF09D6AB7CDB75D37F542EDDBBEEE048B09543B8FCDBACC0037A64F1967C637EEB54DCF1217E00C37754AC23CB9B5E5ADD60024BE6834557E08F02C9EDCD0246626C4DBE1DE341407B06D';
wwv_flow_imp.g_varchar2_table(1339) := '8623D644DEB32E89505CEEA9AEDBBAB5FD5264B4317B9BD837E7A67A4DD27887D02039DEF693D54EC5C708F976DF242C5B4CCCD86E6272B3B39DEB24AE8924DBDABC725E23100CD38CA75E59CB5DABCC66632E1D1E145F9C7CD9FA4C00677DD0144C3D61';
wwv_flow_imp.g_varchar2_table(1340) := '753CE73737AF0D9E547C6E161ACD6118736640611B6B9BF88B712F5EF3F116805B2811383300ACD8295845FE8994B0010A34CE9CB81C1571B583B51172260EB7C4B0D9F7F4EBECD51054AA992202D76777E7807D7D870150A4A030B5AD299E9FFAEBB0E6';
wwv_flow_imp.g_varchar2_table(1341) := 'EAA9B038B19304D81D4FD76E7BDAAE97EAD19894C41F6D8F548ECDDD2E23EEC4532A2E2576CDEC2821DACCAA133C55EB24924C1B140731C3C09E104C2E6BF263B12B8E73F3D6F2755AC3714D831D17FB371CCC9F02C68B92F8A37020C01869DF0CA4737A';
wwv_flow_imp.g_varchar2_table(1342) := '89949B1CD81A67CF96AC9498A4F8CE71260EEF78A2C2F667356143A8FA7B6A926A938E6F6BD3107EBBE63F711E1BFA4D8FDB7ADE62BE15F2368E76BD24768C976E0CE06DDC6E36920160DCA504D1C5977AAAAEC5D7E75DB6CA6B331B4AA8D5DDBCC3442B';
wwv_flow_imp.g_varchar2_table(1343) := '9EC899EF30009B9C91EB5FAD236A22D302343E939B59DD12D6CF1EF443806CB36DE3D2D0A6A1DF342425BB59EB9F3A1707E956ECDA5A3813901E79B583DAC6F24FD59C61F0B6EEC900A65AA4E34D8DDEB1C6BB6BD2C49DF69C586539BABC51F0B677D037';
wwv_flow_imp.g_varchar2_table(1344) := 'F14F2CA010325E7CD73C3183E9D67E17E7CC1A29F17A65AEB63D50A6E4B18EFAB0F2ED1E37355406701A1BAC179A846900125FDBE3E709006B5CE3B295336501BB22AB75D0E92840B7E4A708C4C5B6250D97CB1668DBF3DF51877457A31CE779FDC4F04F';
wwv_flow_imp.g_varchar2_table(1345) := 'D4E16620DDE06D8CEACC9B0D702241470C4D5F9B731A3CBD52C366FDDB731A3CB5E734183F716E09B6E5B2F4F42771B2C266C365EFC28ADA4B1981A6A6B7F860D7611CA997738D24C2BFA3860D76128F2443F64DD7D367005283DB823641AB823666E2B6';
wwv_flow_imp.g_varchar2_table(1346) := '19AF5CE784701E4B4D6D6AE3FAA00CCA76D85AF264EB3A63D5E6E704B021058C3FF5369DDFD4A33508180B5BFBDFC50034B5DE9E937AC1D69B02796E045A337E33732946B526EB1BCE3F7B4CDDCE4553EB2D5653AECD9E9B73D8AC39B1BD591BF9589910';
wwv_flow_imp.g_varchar2_table(1347) := '65BC9C696137C3A786D8FFDBBE26CC6EF95C19A26FB9B8AF01364D48E2EC8EE3B14D2167B158239AD827A9B4039180CC40DD10471B6F6BC8B684706AC18628DD2D2151374F8E5CBE4DECAC5F6D0FCFDE4C94195133A3D7F661D3D70DFE9BE1DEECEDF269';
wwv_flow_imp.g_varchar2_table(1348) := '9E66A4DAA7E34EE055BF6E31D4C432E70167BAB9DEF5F216DF38A3285849781EE73F1E81B33FAA346B8C42A30CCE990B77DC89FCACC323F6C7BF9BDACE355BD154E2A9626F6A79629EFC90E29F5AA50CCBBB6EE8D2FC7FD4FB3C014057E41249829BC839';
wwv_flow_imp.g_varchar2_table(1349) := '0D40737C23327350D263B79688B0B8070CF37F3742C3E25203EE7A3341D90C470B7427386C88581D7070D900DD907D027A739C998146F8CF753317B65F3AAEEABB219749C82AE744B489C092E81E3C35F9A639677869EA8442E9B0ABF2619CD1E0A8C1EF';
wwv_flow_imp.g_varchar2_table(1350) := 'B6C6698E99415382F74A4D27372A0D98B1A6B89D39605866EB35186ACE519851DC768B058C85FD3B71723B83138B8A472A03C0C811095E89D50670E94E72822219809B4237396051E7A0E150B4C0DB08E31CC20D081D0936793B42BC310037B12B914E44';
wwv_flow_imp.g_varchar2_table(1351) := 'B2D96B4BCEAF0C63C28723BC39D088C14DBEAF9C9BC84B894423926D5C0A97AA76C99832D264A2C6EABF89F986E41936D56B4D7C4EDC14365D4F158FB8181BA3923857AD91F0C9B854691D33088A2B1CF610230CBFEFE2A02A7F7C0B4091AC12DC4DB0EE';
wwv_flow_imp.g_varchar2_table(1352) := '5C273058FC4D93920B6A8AA4C41385C7C595C881918C228944AC692F5513751D0E361BB80DE8DBF8523C0D892691652470139F2303D7C786A8673C4D3E8A303764DBD420C532718AEBA927659B7A285CAA3552BC4DCEEE9CEDFAEEFCC495E9E919D6603B';
wwv_flow_imp.g_varchar2_table(1353) := '9F2A36C73DD80FD40C573BBCF94B3DDCACC5D66E4C03D38619D7CDCC2B2D61B5DAF0DB898BCD84BAB17E9C2B9F0038919889ABFFC644F13CD660557006E6F404A01DE6EDD02A72658FE158031D6866135DF31D3924714FF926A298004B24BE352A4D5E6D';
wwv_flow_imp.g_varchar2_table(1354) := '5F9B4143614D35C7E14FB86431E0A3F16DCEEC7CF79A23E5477C090FE79C0D96DB1E6D7257393642A7E269F66FEBE384A199F906AFECED9B39630E9F4A18520DF038CEB4EB0B8BA7C546C3EF2A369CEBF9EF24AAAC4ECE2C344F9494AE4D617666A9ADC5';
wwv_flow_imp.g_varchar2_table(1355) := 'FC8A239BED19C7F9EFFF035DE3E834279465A80000000049454E44AE426082';
wwv_flow_imp_shared.create_app_static_file(
 p_id=>wwv_flow_imp.id(103294111903174197)
,p_file_name=>'icons/app-icon-512.png'
,p_mime_type=>'image/png'
,p_file_charset=>'utf-8'
,p_file_content => wwv_flow_imp.varchar2_to_blob(wwv_flow_imp.g_varchar2_table)
);
end;
/
prompt --application/plugin_settings
begin
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103285396433174176)
,p_plugin_type=>'REGION TYPE'
,p_plugin=>'NATIVE_IR'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'actions_menu_structure', 'IG')).to_clob
,p_version_scn=>36076232
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103285671521174177)
,p_plugin_type=>'ITEM TYPE'
,p_plugin=>'NATIVE_SELECT_MANY'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'display_values_as', 'separated')).to_clob
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103286014336174177)
,p_plugin_type=>'ITEM TYPE'
,p_plugin=>'NATIVE_COLOR_PICKER'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'display_as', 'POPUP',
  'mode', 'FULL')).to_clob
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103286319448174177)
,p_plugin_type=>'ITEM TYPE'
,p_plugin=>'NATIVE_STAR_RATING'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'default_icon', 'fa-star',
  'tooltip', '#VALUE#')).to_clob
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103286599048174177)
,p_plugin_type=>'ITEM TYPE'
,p_plugin=>'NATIVE_YES_NO'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'display_style', 'SWITCH_CB',
  'off_value', 'N',
  'on_value', 'Y')).to_clob
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103286880622174177)
,p_plugin_type=>'REGION TYPE'
,p_plugin=>'NATIVE_DISPLAY_SELECTOR'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'include_slider', 'Y')).to_clob
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103287160457174177)
,p_plugin_type=>'DYNAMIC ACTION'
,p_plugin=>'NATIVE_OPEN_AI_ASSISTANT'
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103287458115174177)
,p_plugin_type=>'ITEM TYPE'
,p_plugin=>'NATIVE_DATE_PICKER_APEX'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'appearance_behavior', 'MONTH-PICKER:YEAR-PICKER:TODAY-BUTTON',
  'days_outside_month', 'VISIBLE',
  'show_on', 'FOCUS',
  'time_increment', '15')).to_clob
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103287808039174177)
,p_plugin_type=>'ITEM TYPE'
,p_plugin=>'NATIVE_GEOCODED_ADDRESS'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'background', 'default',
  'display_as', 'LIST',
  'map_preview', 'POPUP:ITEM',
  'match_mode', 'RELAX_HOUSE_NUMBER',
  'show_coordinates', 'N')).to_clob
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103288039219174177)
,p_plugin_type=>'REGION TYPE'
,p_plugin=>'NATIVE_MAP_REGION'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'use_vector_tile_layers', 'Y')).to_clob
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103288341393174177)
,p_plugin_type=>'WEB SOURCE TYPE'
,p_plugin=>'NATIVE_BOSS'
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103288719108174177)
,p_plugin_type=>'WEB SOURCE TYPE'
,p_plugin=>'NATIVE_ADFBC'
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103288994772174177)
,p_plugin_type=>'PROCESS TYPE'
,p_plugin=>'NATIVE_GEOCODING'
,p_attribute_01=>'RELAX_HOUSE_NUMBER'
,p_version_scn=>36076233
);
wwv_flow_imp_shared.create_plugin_setting(
 p_id=>wwv_flow_imp.id(103289298533174177)
,p_plugin_type=>'ITEM TYPE'
,p_plugin=>'NATIVE_SINGLE_CHECKBOX'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'checked_value', 'Y',
  'unchecked_value', 'N')).to_clob
,p_version_scn=>36076233
);
end;
/
prompt --application/shared_components/security/authorizations/administration_rights
begin
wwv_flow_imp_shared.create_security_scheme(
 p_id=>wwv_flow_imp.id(103295408550174197)
,p_name=>'Administration Rights'
,p_scheme_type=>'NATIVE_FUNCTION_BODY'
,p_attribute_01=>'return true;'
,p_error_message=>'Insufficient privileges, user is not an Administrator'
,p_version_scn=>36076259
,p_caching=>'BY_USER_BY_PAGE_VIEW'
);
end;
/
prompt --application/shared_components/navigation/navigation_bar
begin
null;
end;
/
prompt --application/shared_components/logic/application_settings
begin
null;
end;
/
prompt --application/shared_components/navigation/tabs/standard
begin
null;
end;
/
prompt --application/shared_components/navigation/tabs/parent
begin
null;
end;
/
prompt --application/pages/page_groups
begin
wwv_flow_imp_page.create_page_group(
 p_id=>wwv_flow_imp.id(103295715767174198)
,p_group_name=>'Administration'
);
end;
/
prompt --application/comments
begin
null;
end;
/
prompt --application/shared_components/navigation/breadcrumbs/breadcrumb
begin
wwv_flow_imp_shared.create_menu(
 p_id=>wwv_flow_imp.id(103290207012174179)
,p_name=>'Breadcrumb'
);
wwv_flow_imp_shared.create_menu_option(
 p_id=>wwv_flow_imp.id(103290286617174179)
,p_short_name=>'Home'
,p_link=>'f?p=&APP_ID.:1:&APP_SESSION.::&DEBUG.:::'
,p_page_id=>1
);
wwv_flow_imp_shared.create_menu_option(
 p_id=>wwv_flow_imp.id(103368084491308064)
,p_short_name=>'Books Collections'
,p_link=>'f?p=&APP_ID.:4:&APP_SESSION.::&DEBUG.:::'
,p_page_id=>4
);
end;
/
prompt --application/shared_components/navigation/breadcrumbentry
begin
null;
end;
/
prompt --application/shared_components/user_interface/templates/popuplov
begin
null;
end;
/
prompt --application/shared_components/user_interface/themes
begin
wwv_flow_imp_shared.create_theme(
 p_id=>wwv_flow_imp.id(103291009282174181)
,p_theme_id=>42
,p_theme_name=>'Universal Theme'
,p_theme_internal_name=>'UNIVERSAL_THEME'
,p_version_identifier=>'24.2'
,p_navigation_type=>'L'
,p_nav_bar_type=>'LIST'
,p_reference_id=>4072363937200175119
,p_is_locked=>false
,p_current_theme_style_id=>wwv_flow_imp.id(103485194740531000)
,p_default_page_template=>4072355960268175073
,p_default_dialog_template=>2100407606326202693
,p_error_template=>2101157952850466385
,p_printer_friendly_template=>4072355960268175073
,p_login_template=>2101157952850466385
,p_default_button_template=>4072362960822175091
,p_default_region_template=>4072358936313175081
,p_default_chart_template=>4072358936313175081
,p_default_form_template=>4072358936313175081
,p_default_reportr_template=>4072358936313175081
,p_default_tabform_template=>4072358936313175081
,p_default_wizard_template=>4072358936313175081
,p_default_menur_template=>2531463326621247859
,p_default_listr_template=>4072358936313175081
,p_default_irr_template=>2100526641005906379
,p_default_report_template=>2538654340625403440
,p_default_label_template=>1609121967514267634
,p_default_menu_template=>4072363345357175094
,p_default_calendar_template=>4072363550766175095
,p_default_list_template=>4072361143931175087
,p_default_nav_list_template=>2526754704087354841
,p_default_top_nav_list_temp=>2526754704087354841
,p_default_side_nav_list_temp=>2467739217141810545
,p_default_nav_list_position=>'SIDE'
,p_default_dialogbtnr_template=>2126429139436695430
,p_default_dialogr_template=>4501440665235496320
,p_default_option_label=>1609121967514267634
,p_default_required_label=>1609122147107268652
,p_default_navbar_list_template=>2847543055748234966
,p_file_prefix => nvl(wwv_flow_application_install.get_static_theme_file_prefix(42),'#APEX_FILES#themes/theme_42/24.2/')
,p_files_version=>65
,p_icon_library=>'FONTAPEX'
,p_javascript_file_urls=>wwv_flow_string.join(wwv_flow_t_varchar2(
'#APEX_FILES#libraries/apex/#MIN_DIRECTORY#widget.stickyWidget#MIN#.js?v=#APEX_VERSION#',
'#THEME_FILES#js/theme42#MIN#.js?v=#APEX_VERSION#'))
,p_css_file_urls=>'#THEME_FILES#css/Core#MIN#.css?v=#APEX_VERSION#'
);
end;
/
prompt --application/shared_components/user_interface/theme_style
begin
wwv_flow_imp_shared.create_theme_style(
 p_id=>wwv_flow_imp.id(103485194740531000)
,p_theme_id=>42
,p_name=>'Redwood Dark'
,p_css_file_urls=>wwv_flow_string.join(wwv_flow_t_varchar2(
'#APEX_FILES#libraries/oracle-fonts/oraclesans-apex#MIN#.css?v=#APEX_VERSION#',
'#THEME_FILES#css/Redwood#MIN#.css?v=#APEX_VERSION#'))
,p_css_classes=>' rw-mode-header--pillar rw-pillar--sienna rw-mode-nav--dark rw-mode-body-header--dark'
,p_is_public=>true
,p_is_accessible=>false
,p_theme_roller_input_file_urls=>'#THEME_FILES#less/theme/Redwood-Theme.less'
,p_theme_roller_config=>'{"classes":["rw-mode-header--pillar","rw-pillar--sienna","rw-mode-nav--dark","rw-mode-body-header--dark"],"vars":{},"customCSS":"","useCustomLess":"N"}'
,p_theme_roller_output_file_url=>'#THEME_DB_FILES#43298462563267310.css'
,p_theme_roller_read_only=>false
);
end;
/
prompt --application/shared_components/user_interface/theme_files
begin
wwv_flow_imp.g_varchar2_table := wwv_flow_imp.empty_varchar2_table;
wwv_flow_imp.g_varchar2_table(1) := '2F2A210D0A20436F707972696768742028632920323032302C20323032342C204F7261636C6520616E642F6F722069747320616666696C69617465732E0D0A202A2F0D0A';
wwv_flow_imp_shared.create_theme_file(
 p_id=>wwv_flow_imp.id(103485574899531004)
,p_theme_id=>42
,p_file_name=>'43298462563267310.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;
/
prompt --application/shared_components/user_interface/template_opt_groups
begin
null;
end;
/
prompt --application/shared_components/user_interface/template_options
begin
null;
end;
/
prompt --application/shared_components/globalization/language
begin
null;
end;
/
prompt --application/shared_components/globalization/translations
begin
null;
end;
/
prompt --application/shared_components/logic/build_options
begin
wwv_flow_imp_shared.create_build_option(
 p_id=>wwv_flow_imp.id(103289569972174177)
,p_build_option_name=>'Commented Out'
,p_build_option_status=>'EXCLUDE'
,p_version_scn=>36076233
);
end;
/
prompt --application/shared_components/globalization/messages
begin
null;
end;
/
prompt --application/shared_components/globalization/dyntranslations
begin
null;
end;
/
prompt --application/shared_components/security/authentications/oracle_apex_accounts
begin
wwv_flow_imp_shared.create_authentication(
 p_id=>wwv_flow_imp.id(103289882736174178)
,p_name=>'Oracle APEX Accounts'
,p_scheme_type=>'NATIVE_APEX_ACCOUNTS'
,p_invalid_session_type=>'LOGIN'
,p_use_secure_cookie_yn=>'N'
,p_ras_mode=>0
,p_version_scn=>36076234
);
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=>'Books Against Duality View'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_page_component_map=>'11'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(103303259050174211)
,p_plug_name=>'Books Against Duality View'
,p_region_template_options=>'#DEFAULT#'
,p_escape_on_http_output=>'Y'
,p_plug_template=>2674017834225413037
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_plug_query_num_rows=>15
,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
);
end;
/
prompt --application/pages/page_00004
begin
wwv_flow_imp_page.create_page(
 p_id=>4
,p_name=>'Books Collections'
,p_alias=>'BOOKS-COLLECTIONS'
,p_step_title=>'Books Collections'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_page_component_map=>'13'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(103364493042308063)
,p_plug_name=>'Books Collections'
,p_region_template_options=>'#DEFAULT#:t-IRR-region--hideHeader js-addHiddenHeadingRoleDesc'
,p_plug_template=>2100526641005906379
,p_plug_display_sequence=>10
,p_location=>'DUALITY_VIEW'
,p_document_source_id=>wwv_flow_imp.id(103348574692304752)
,p_query_type=>'SQL'
,p_plug_source_type=>'NATIVE_IR'
,p_prn_page_header=>'Books Collections'
);
wwv_flow_imp_page.create_worksheet(
 p_id=>wwv_flow_imp.id(103364623839308063)
,p_name=>'Books Collections'
,p_max_row_count_message=>'The maximum row count for this report is #MAX_ROW_COUNT# rows.  Please apply a filter to reduce the number of records in your query.'
,p_no_data_found_message=>'No data found.'
,p_pagination_type=>'ROWS_X_TO_Y'
,p_pagination_display_pos=>'BOTTOM_RIGHT'
,p_report_list_mode=>'TABS'
,p_lazy_loading=>false
,p_show_detail_link=>'C'
,p_show_notify=>'Y'
,p_download_formats=>'CSV:HTML:XLSX:PDF'
,p_enable_mail_download=>'Y'
,p_detail_link=>'f?p=&APP_ID.:5:&SESSION.::&DEBUG.:RP,:P5_COLLECTION_ID:#COLLECTION_ID##ID_1#\'
,p_detail_link_text=>'<span role="img" aria-label="Edit" class="fa fa-edit" title="Edit"></span>'
,p_owner=>'SMUENCH'
,p_internal_uid=>43177891662044373
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(103374595480330420)
,p_db_column_name=>'COLLECTION_ID'
,p_display_order=>10
,p_is_primary_key=>'Y'
,p_column_identifier=>'D'
,p_column_label=>'Collection Id'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN_ESCAPE_SC'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(103366054967308063)
,p_db_column_name=>'COLLECTIONNAME'
,p_display_order=>20
,p_column_identifier=>'C'
,p_column_label=>'Collection Name'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(103365710055308063)
,p_db_column_name=>'CREATED'
,p_display_order=>30
,p_column_identifier=>'B'
,p_column_label=>'Created'
,p_column_type=>'DATE'
,p_heading_alignment=>'LEFT'
,p_format_mask=>'DD-MON-YYYY HH24:MI'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_rpt(
 p_id=>wwv_flow_imp.id(103389842266441497)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'432032'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'COLLECTIONNAME:CREATED'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(103368215733308064)
,p_plug_name=>'Breadcrumb'
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>2531463326621247859
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_imp.id(103290207012174179)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>4072363345357175094
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(103366538413308063)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(103364493042308063)
,p_button_name=>'CREATE'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>4072362960822175091
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Create'
,p_button_position=>'RIGHT_OF_IR_SEARCH_BAR'
,p_button_redirect_url=>'f?p=&APP_ID.:5:&APP_SESSION.::&DEBUG.:5::'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(103366890459308063)
,p_name=>'Edit Report - Dialog Closed'
,p_event_sequence=>10
,p_triggering_element_type=>'REGION'
,p_triggering_region_id=>wwv_flow_imp.id(103364493042308063)
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'apexafterclosedialog'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(103367352581308064)
,p_event_id=>wwv_flow_imp.id(103366890459308063)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_REFRESH'
,p_affected_elements_type=>'REGION'
,p_affected_region_id=>wwv_flow_imp.id(103364493042308063)
);
end;
/
prompt --application/pages/page_00005
begin
wwv_flow_imp_page.create_page(
 p_id=>5
,p_name=>'Book Collection'
,p_alias=>'BOOK-COLLECTION'
,p_page_mode=>'MODAL'
,p_step_title=>'Book Collection'
,p_autocomplete_on_off=>'OFF'
,p_step_template=>1661186590416509825
,p_page_template_options=>'#DEFAULT#:js-dialog-class-t-Drawer--pullOutEnd'
,p_dialog_chained=>'N'
,p_dialog_resizable=>'Y'
,p_protection_level=>'C'
,p_page_component_map=>'02'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(102687056762562835)
,p_plug_name=>'Books'
,p_region_template_options=>'#DEFAULT#:t-IRR-region--hideHeader js-addHiddenHeadingRoleDesc'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>2100526641005906379
,p_plug_display_sequence=>20
,p_location=>'DUALITY_VIEW'
,p_array_column_id=>wwv_flow_imp.id(103351050073304754)
,p_document_source_id=>wwv_flow_imp.id(103348574692304752)
,p_query_where=>'COLLECTION_ID = :P5_COLLECTION_ID and BOOK_ID is not null'
,p_source_post_processing=>'WHERE_ORDER_BY_CLAUSE'
,p_plug_source_type=>'NATIVE_IG'
,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_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(103372292927330397)
,p_name=>'ISBN'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'ISBN'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'ISBN'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>50
,p_value_alignment=>'LEFT'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'trim_spaces', 'BOTH')).to_clob
,p_is_required=>false
,p_max_length=>64
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_exact_match=>true
,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
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103372349643330398)
,p_name=>'PRICE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PRICE'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_NUMBER_FIELD'
,p_heading=>'Price'
,p_heading_alignment=>'RIGHT'
,p_display_sequence=>60
,p_value_alignment=>'RIGHT'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'number_alignment', 'left',
  'virtual_keyboard', 'decimal')).to_clob
,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
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103372492587330399)
,p_name=>'TITLE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'TITLE'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'Title'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>70
,p_value_alignment=>'LEFT'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'trim_spaces', 'BOTH')).to_clob
,p_is_required=>false
,p_max_length=>64
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_exact_match=>true
,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
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103372563205330400)
,p_name=>'PUBLISHED'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PUBLISHED'
,p_data_type=>'TIMESTAMP'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_DATE_PICKER_APEX'
,p_heading=>'Published'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>80
,p_value_alignment=>'LEFT'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'display_as', 'POPUP',
  'max_date', 'NONE',
  'min_date', 'NONE',
  'multiple_months', 'N',
  'show_time', 'N',
  'use_defaults', 'Y')).to_clob
,p_format_mask=>'DD-MON-YYYY'
,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
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103372716480330401)
,p_name=>'PUBLISHER'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PUBLISHER'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'Publisher'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>90
,p_value_alignment=>'LEFT'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'trim_spaces', 'BOTH')).to_clob
,p_is_required=>false
,p_max_length=>64
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_exact_match=>true
,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
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103372910571330403)
,p_name=>'APEX$ROW_ACTION'
,p_session_state_data_type=>'VARCHAR2'
,p_item_type=>'NATIVE_ROW_ACTION'
,p_display_sequence=>40
,p_use_as_row_header=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103372996029330404)
,p_name=>'APEX$ROW_SELECTOR'
,p_session_state_data_type=>'VARCHAR2'
,p_item_type=>'NATIVE_ROW_SELECTOR'
,p_display_sequence=>30
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'enable_multi_select', 'Y',
  'hide_control', 'N',
  'show_select_all', 'Y')).to_clob
,p_use_as_row_header=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103375554869330430)
,p_name=>'COLLECTION_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'COLLECTION_ID'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>100
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'value_protected', 'Y')).to_clob
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>true
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103375719789330431)
,p_name=>'BOOK_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'BOOK_ID'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>110
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'value_protected', 'Y')).to_clob
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>true
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_interactive_grid(
 p_id=>wwv_flow_imp.id(102687211544562836)
,p_internal_uid=>42500479367299146
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_add_row_if_empty=>false
,p_submit_checked_rows=>false
,p_lazy_loading=>false
,p_requires_filter=>false
,p_select_first_row=>true
,p_fixed_row_height=>true
,p_pagination_type=>'SCROLL'
,p_show_total_row_count=>true
,p_show_toolbar=>true
,p_toolbar_buttons=>'ACTIONS_MENU'
,p_add_button_label=>'Add Book'
,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(103377321792397370)
,p_interactive_grid_id=>wwv_flow_imp.id(102687211544562836)
,p_static_id=>'431906'
,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(103377504707397370)
,p_report_id=>wwv_flow_imp.id(103377321792397370)
,p_view_type=>'GRID'
,p_stretch_columns=>true
,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(103379795233397374)
,p_view_id=>wwv_flow_imp.id(103377504707397370)
,p_display_seq=>5
,p_column_id=>wwv_flow_imp.id(103372292927330397)
,p_is_visible=>true
,p_is_frozen=>false
,p_width=>133
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103380651132397375)
,p_view_id=>wwv_flow_imp.id(103377504707397370)
,p_display_seq=>6
,p_column_id=>wwv_flow_imp.id(103372349643330398)
,p_is_visible=>true
,p_is_frozen=>false
,p_width=>66.3281
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103381616839397376)
,p_view_id=>wwv_flow_imp.id(103377504707397370)
,p_display_seq=>4
,p_column_id=>wwv_flow_imp.id(103372492587330399)
,p_is_visible=>true
,p_is_frozen=>false
,p_width=>160
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103382509662397377)
,p_view_id=>wwv_flow_imp.id(103377504707397370)
,p_display_seq=>8
,p_column_id=>wwv_flow_imp.id(103372563205330400)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103383419365397378)
,p_view_id=>wwv_flow_imp.id(103377504707397370)
,p_display_seq=>7
,p_column_id=>wwv_flow_imp.id(103372716480330401)
,p_is_visible=>true
,p_is_frozen=>false
,p_width=>120.3281
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103385411602401246)
,p_view_id=>wwv_flow_imp.id(103377504707397370)
,p_display_seq=>1
,p_column_id=>wwv_flow_imp.id(103372910571330403)
,p_is_visible=>true
,p_is_frozen=>true
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103497478023730291)
,p_view_id=>wwv_flow_imp.id(103377504707397370)
,p_display_seq=>9
,p_column_id=>wwv_flow_imp.id(103375554869330430)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103498387733730292)
,p_view_id=>wwv_flow_imp.id(103377504707397370)
,p_display_seq=>10
,p_column_id=>wwv_flow_imp.id(103375719789330431)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(103356826837308060)
,p_plug_name=>'Book Collection'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>4501440665235496320
,p_plug_display_sequence=>10
,p_location=>'DUALITY_VIEW'
,p_document_source_id=>wwv_flow_imp.id(103348574692304752)
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_plug_source_type=>'NATIVE_FORM'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(103359683270308061)
,p_plug_name=>'Buttons'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>2126429139436695430
,p_plug_display_sequence=>20
,p_plug_display_point=>'REGION_POSITION_03'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'expand_shortcuts', 'N',
  'output_as', 'TEXT',
  'show_line_breaks', 'Y')).to_clob
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(103373270658330407)
,p_plug_name=>'Authors'
,p_region_template_options=>'#DEFAULT#:t-IRR-region--hideHeader js-addHiddenHeadingRoleDesc'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>2100526641005906379
,p_plug_display_sequence=>30
,p_location=>'DUALITY_VIEW'
,p_array_column_id=>wwv_flow_imp.id(103351416372304754)
,p_document_source_id=>wwv_flow_imp.id(103348574692304752)
,p_query_where=>'AUTHOR_ID is not null'
,p_source_post_processing=>'WHERE_ORDER_BY_CLAUSE'
,p_plug_source_type=>'NATIVE_IG'
,p_master_region_id=>wwv_flow_imp.id(102687056762562835)
,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_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(103376259659330437)
,p_name=>'COLLECTION_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'COLLECTION_ID'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>30
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'value_protected', 'Y')).to_clob
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>true
,p_parent_column_id=>wwv_flow_imp.id(103375554869330430)
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103505236201799206)
,p_name=>'AUTHOR_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'AUTHOR_ID'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>50
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'value_protected', 'Y')).to_clob
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>true
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103505413081799207)
,p_name=>'LASTNAME'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'LASTNAME'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'Lastname'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>60
,p_value_alignment=>'LEFT'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'trim_spaces', 'BOTH')).to_clob
,p_is_required=>false
,p_max_length=>64
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_exact_match=>true
,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
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103505494855799208)
,p_name=>'FIRSTNAME'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'FIRSTNAME'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'Firstname'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>70
,p_value_alignment=>'LEFT'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'trim_spaces', 'BOTH')).to_clob
,p_is_required=>false
,p_max_length=>64
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_exact_match=>true
,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
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103506958682799223)
,p_name=>'BOOK_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'BOOK_ID'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>40
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'value_protected', 'Y')).to_clob
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>true
,p_parent_column_id=>wwv_flow_imp.id(103375719789330431)
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103508135801799235)
,p_name=>'APEX$ROW_ACTION'
,p_session_state_data_type=>'VARCHAR2'
,p_item_type=>'NATIVE_ROW_ACTION'
,p_display_sequence=>20
,p_use_as_row_header=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(103508246729799236)
,p_name=>'APEX$ROW_SELECTOR'
,p_session_state_data_type=>'VARCHAR2'
,p_item_type=>'NATIVE_ROW_SELECTOR'
,p_display_sequence=>10
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'enable_multi_select', 'Y',
  'hide_control', 'N',
  'show_select_all', 'Y')).to_clob
,p_use_as_row_header=>false
);
wwv_flow_imp_page.create_interactive_grid(
 p_id=>wwv_flow_imp.id(103373412104330408)
,p_internal_uid=>43186679927066718
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_add_row_if_empty=>false
,p_submit_checked_rows=>false
,p_lazy_loading=>false
,p_requires_filter=>false
,p_select_first_row=>true
,p_fixed_row_height=>true
,p_pagination_type=>'SCROLL'
,p_show_total_row_count=>true
,p_show_toolbar=>true
,p_toolbar_buttons=>null
,p_add_button_label=>'Add Author'
,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(103486729620668232)
,p_interactive_grid_id=>wwv_flow_imp.id(103373412104330408)
,p_static_id=>'433000'
,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(103486924849668233)
,p_report_id=>wwv_flow_imp.id(103486729620668232)
,p_view_type=>'GRID'
,p_stretch_columns=>true
,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(103509741718805534)
,p_view_id=>wwv_flow_imp.id(103486924849668233)
,p_display_seq=>1
,p_column_id=>wwv_flow_imp.id(103376259659330437)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103518417602859931)
,p_view_id=>wwv_flow_imp.id(103486924849668233)
,p_display_seq=>2
,p_column_id=>wwv_flow_imp.id(103505236201799206)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103519280616859933)
,p_view_id=>wwv_flow_imp.id(103486924849668233)
,p_display_seq=>4
,p_column_id=>wwv_flow_imp.id(103505413081799207)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103520165665859934)
,p_view_id=>wwv_flow_imp.id(103486924849668233)
,p_display_seq=>3
,p_column_id=>wwv_flow_imp.id(103505494855799208)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(103683573493968253)
,p_view_id=>wwv_flow_imp.id(103486924849668233)
,p_display_seq=>5
,p_column_id=>wwv_flow_imp.id(103506958682799223)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(104083236234066125)
,p_view_id=>wwv_flow_imp.id(103486924849668233)
,p_display_seq=>0
,p_column_id=>wwv_flow_imp.id(103508135801799235)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(103360081400308061)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(103359683270308061)
,p_button_name=>'CANCEL'
,p_button_action=>'DEFINED_BY_DA'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>4072362960822175091
,p_button_image_alt=>'Cancel'
,p_button_position=>'CLOSE'
,p_button_alignment=>'RIGHT'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(103361466179308062)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(103359683270308061)
,p_button_name=>'DELETE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>4072362960822175091
,p_button_image_alt=>'Delete'
,p_button_position=>'DELETE'
,p_button_execute_validations=>'N'
,p_confirm_message=>'&APP_TEXT$DELETE_MSG!RAW.'
,p_confirm_style=>'danger'
,p_button_condition=>'P5_COLLECTION_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'DELETE'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(103361914298308062)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_imp.id(103359683270308061)
,p_button_name=>'SAVE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>4072362960822175091
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Apply Changes'
,p_button_position=>'NEXT'
,p_button_condition=>'P5_COLLECTION_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'UPDATE'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(103362322925308062)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_imp.id(103359683270308061)
,p_button_name=>'CREATE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>4072362960822175091
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Create'
,p_button_position=>'NEXT'
,p_button_condition=>'P5_COLLECTION_ID'
,p_button_condition_type=>'ITEM_IS_NULL'
,p_database_action=>'INSERT'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(102686895228562833)
,p_name=>'P5_CREATED_FORMATTED'
,p_item_sequence=>100
,p_item_plug_id=>wwv_flow_imp.id(103356826837308060)
,p_prompt=>'Created'
,p_format_mask=>'DD-MON-YYYY HH24:MI'
,p_display_as=>'NATIVE_DISPLAY_ONLY'
,p_display_when=>'P5_COLLECTION_ID'
,p_display_when_type=>'ITEM_IS_NOT_NULL'
,p_field_template=>1609121967514267634
,p_item_template_options=>'#DEFAULT#'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'based_on', 'VALUE',
  'format', 'PLAIN',
  'send_on_page_submit', 'Y',
  'show_line_breaks', 'Y')).to_clob
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(103357595512308060)
,p_name=>'P5_CREATED'
,p_source_data_type=>'TIMESTAMP'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(103356826837308060)
,p_item_source_plug_id=>wwv_flow_imp.id(103356826837308060)
,p_format_mask=>'DD-MON-YYYY HH24:MI'
,p_source=>'CREATED'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'value_protected', 'Y')).to_clob
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(103358409465308061)
,p_name=>'P5_COLLECTIONNAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_imp.id(103356826837308060)
,p_item_source_plug_id=>wwv_flow_imp.id(103356826837308060)
,p_prompt=>'Collection Name'
,p_source=>'COLLECTIONNAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>64
,p_field_template=>1609121967514267634
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'disabled', 'N',
  'submit_when_enter_pressed', 'N',
  'subtype', 'TEXT',
  'trim_spaces', 'BOTH')).to_clob
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(103375047686330425)
,p_name=>'P5_COLLECTION_ID'
,p_source_data_type=>'VARCHAR2'
,p_is_primary_key=>true
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_imp.id(103356826837308060)
,p_item_source_plug_id=>wwv_flow_imp.id(103356826837308060)
,p_source=>'COLLECTION_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'value_protected', 'Y')).to_clob
);
wwv_flow_imp_page.create_page_computation(
 p_id=>wwv_flow_imp.id(102686944238562834)
,p_computation_sequence=>10
,p_computation_item=>'P5_CREATED_FORMATTED'
,p_computation_point=>'BEFORE_BOX_BODY'
,p_computation_type=>'ITEM_VALUE'
,p_computation=>'P5_CREATED'
);
wwv_flow_imp_page.create_page_validation(
 p_id=>wwv_flow_imp.id(103358046224308061)
,p_validation_name=>'P5_CREATED must be timestamp'
,p_validation_sequence=>10
,p_validation=>'P5_CREATED'
,p_validation_type=>'ITEM_IS_TIMESTAMP'
,p_error_message=>'#LABEL# must be a valid timestamp.'
,p_associated_item=>wwv_flow_imp.id(103357595512308060)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(103360228075308061)
,p_name=>'Cancel Dialog'
,p_event_sequence=>10
,p_triggering_element_type=>'BUTTON'
,p_triggering_button_id=>wwv_flow_imp.id(103360081400308061)
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'click'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(103360973706308062)
,p_event_id=>wwv_flow_imp.id(103360228075308061)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_DIALOG_CANCEL'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(102686803590562832)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Default Created for Insert'
,p_process_sql_clob=>':P5_CREATED := to_char(sysdate, ''DD-MON-YYYY HH24:MI'');'
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when=>'P5_COLLECTION_ID'
,p_process_when_type=>'ITEM_IS_NULL'
,p_internal_uid=>42500071413299142
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(103363057611308062)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_imp.id(103356826837308060)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>'Process form Book Collection'
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>43176325434044372
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(103373176048330406)
,p_process_sequence=>30
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_imp.id(102687056762562835)
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Assign Parent Id for Book'
,p_process_sql_clob=>':COLLECTION_ID := :P5_COLLECTION_ID;'
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>43186443871066716
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(103373076455330405)
,p_process_sequence=>50
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_imp.id(102687056762562835)
,p_process_type=>'NATIVE_IG_DML'
,p_process_name=>'Books - Save Interactive Grid Data'
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>43186344278066715
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(58575148974404454)
,p_process_sequence=>60
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_imp.id(103373270658330407)
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Assign Parent Id for Authors'
,p_process_sql_clob=>':COLLECTION_ID := :P5_COLLECTION_ID;'
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>3187041797459144
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(103508388833799237)
,p_process_sequence=>70
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_imp.id(103373270658330407)
,p_process_type=>'NATIVE_IG_DML'
,p_process_name=>'Authors - Save Interactive Grid Data'
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>43321656656535547
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(103363518559308062)
,p_process_sequence=>80
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_CLOSE_WINDOW'
,p_process_name=>'Close Dialog'
,p_attribute_02=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when=>'CREATE,SAVE,DELETE'
,p_process_when_type=>'REQUEST_IN_CONDITION'
,p_internal_uid=>43176786382044372
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(103362687583308062)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_imp.id(103356826837308060)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>'Initialize form Book Collection'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>43175955406044372
);
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=>'Books Against Duality View - Log In'
,p_warn_on_unsaved_changes=>'N'
,p_first_item=>'AUTO_FIRST_ITEM'
,p_autocomplete_on_off=>'OFF'
,p_step_template=>2101157952850466385
,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(103296277651174202)
,p_plug_name=>'Books Against Duality View'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>2674157997338192145
,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(103297968438174207)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_imp.id(103296277651174202)
,p_button_name=>'LOGIN'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>4072362960822175091
,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(103296778488174205)
,p_name=>'P9999_USERNAME'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(103296277651174202)
,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=>2040785906935475274
,p_item_icon_css_classes=>'fa-user'
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'disabled', 'N',
  'submit_when_enter_pressed', 'N',
  'subtype', 'TEXT',
  'trim_spaces', 'BOTH')).to_clob
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(103297145221174206)
,p_name=>'P9999_PASSWORD'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(103296277651174202)
,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=>2040785906935475274
,p_item_icon_css_classes=>'fa-key'
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'submit_when_enter_pressed', 'Y')).to_clob
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(103297565928174206)
,p_name=>'P9999_REMEMBER'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_imp.id(103296277651174202)
,p_prompt=>'Remember username'
,p_display_as=>'NATIVE_SINGLE_CHECKBOX'
,p_label_alignment=>'RIGHT'
,p_display_when=>'apex_authentication.persistent_cookies_enabled'
,p_display_when2=>'PLSQL'
,p_display_when_type=>'EXPRESSION'
,p_field_template=>2040785906935475274
,p_item_template_options=>'#DEFAULT#'
,p_escape_on_http_output=>'N'
,p_attributes=>wwv_flow_t_plugin_attributes(wwv_flow_t_varchar2(
  'checked_value', '',
  'unchecked_value', '',
  'use_defaults', 'Y')).to_clob
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(103300224938174208)
,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=>43113492760910518
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
 p_id=>wwv_flow_imp.id(103300710725174208)
,p_page_process_id=>wwv_flow_imp.id(103300224938174208)
,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(103301230655174208)
,p_page_process_id=>wwv_flow_imp.id(103300224938174208)
,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(103298301284174207)
,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=>43111569106910517
);
wwv_flow_imp_shared.create_invokeapi_comp_param(
 p_id=>wwv_flow_imp.id(103298805981174208)
,p_page_process_id=>wwv_flow_imp.id(103298301284174207)
,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(103299277716174208)
,p_page_process_id=>wwv_flow_imp.id(103298301284174207)
,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(103299816015174208)
,p_page_process_id=>wwv_flow_imp.id(103298301284174207)
,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=>'API_DEFAULT'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(103302113976174208)
,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=>43115381798910518
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(103301636264174208)
,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=>43114904086910518
);
end;
/
prompt --application/deployment/definition
begin
wwv_flow_imp_shared.create_install(
 p_id=>wwv_flow_imp.id(103305237943174444)
,p_deinstall_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'drop view book_collections_dv;',
'drop table book_collections_dv_root cascade constraints;',
'drop table book_collections_dv_books cascade constraints;',
'drop table book_collections_dv_authors cascade constraints;'))
);
end;
/
prompt --application/deployment/install/install_create_schema
begin
wwv_flow_imp_shared.create_install_script(
 p_id=>wwv_flow_imp.id(103305696659177452)
,p_install_id=>wwv_flow_imp.id(103305237943174444)
,p_name=>'Create Schema'
,p_sequence=>10
,p_script_type=>'INSTALL'
,p_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'CREATE TABLE book_collections_dv_root(',
'   "_id"            varchar2(64)  DEFAULT ON NULL SYS_GUID(),',
'   created          timestamp,',
'   collection_name  varchar2(64),',
'   PRIMARY KEY("_id")',
')',
'/',
'    ',
'CREATE TABLE book_collections_dv_books(',
'   "_id" varchar2(64) default on null sys_guid(),    ',
'   isbn                   varchar2(64),',
'   price                  number,',
'   title                  varchar2(64),',
'   published              timestamp,',
'   publisher              varchar2(64),',
'   "_id_book_collection"  varchar2(64),',
'   PRIMARY KEY("_id")',
')',
'/',
'',
'CREATE TABLE book_collections_dv_authors(',
'   "_id" varchar2(64) default on null sys_guid(),',
'   last_name  varchar2(64),',
'   first_name  varchar2(64),',
'   "_id_book"  varchar2(64),',
'   PRIMARY KEY("_id")',
')',
'/',
'',
'ALTER TABLE book_collections_dv_books',
'ADD CONSTRAINT fk_book_collections_dv_books_to_book_collections_dv_root',
'FOREIGN KEY ("_id_book_collection")',
'REFERENCES book_collections_dv_root("_id")',
'/',
'        ',
'ALTER TABLE book_collections_dv_authors',
'ADD CONSTRAINT fk_book_collections_dv_authors_to_book_collections_dv_books',
'FOREIGN KEY ("_id_book") ',
'REFERENCES book_collections_dv_books("_id")',
'/',
'',
'CREATE INDEX IF NOT EXISTS fk_book_collections_dv_books_to_book_collections_dv_root_index ON book_collections_dv_books("_id_book_collection")',
'/',
'',
'CREATE INDEX IF NOT EXISTS fk_book_collections_dv_authors_to_book_collections_dv_books_index ON book_collections_dv_authors("_id_book")',
'/',
'',
'CREATE OR REPLACE JSON RELATIONAL DUALITY VIEW BOOK_COLLECTIONS_DV AS ',
'book_collections_dv_root @insert @update @delete',
'{ ',
'  "_id"',
'  collectionName: collection_name',
'  created',
'  books: book_collections_dv_books @insert @update @delete',
'  { ',
'    "_id"',
'    ISBN: isbn',
'    price',
'    title',
'    published',
'    publisher',
'    authors: book_collections_dv_authors @insert @update @delete',
'    {',
'      "_id"',
'      lastName: last_name',
'      firstName: first_name',
'    } ',
'  } ',
'}',
'/',
''))
);
end;
/
prompt --application/deployment/install/install_sample_json_documents
begin
wwv_flow_imp_shared.create_install_script(
 p_id=>wwv_flow_imp.id(103307235878187961)
,p_install_id=>wwv_flow_imp.id(103305237943174444)
,p_name=>'Sample JSON Documents'
,p_sequence=>20
,p_script_type=>'INSTALL'
,p_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'begin',
'    insert into book_collections_dv(data) values (q''~{',
'    	"collectionName": "Favorite Animation Books",',
'    	"created": "2025-04-05T08:09:00",',
'    	"books": [',
'    		{',
'    			"title": "The Illusion of Life",',
'    			"publisher": "Disney Editions",',
'    			"authors": [',
'    				{',
'    					"firstName": "Frank",',
'    					"lastName": "Thomas"',
'    				},',
'    				{',
'    					"firstName": "Ollie",',
'    					"lastName": "Johnston"',
'    				}',
'    			],',
'    			"published": "1995-10-19",',
'    			"ISBN": "978-0786860708",',
'    			"price": 35',
'    		},',
'    		{',
'    			"title": "The Art of Ratatouille",',
'    			"publisher": "Chronicle Books",',
'    			"authors": [',
'    				{',
'    					"firstName": "Brad",',
'    					"lastName": "Bird"',
'    				},',
'    				{',
'    					"firstName": "John",',
'    					"lastName": "Lasseter"',
'    				}',
'    			],',
'    			"published": "2007-05-03",',
'    			"ISBN": "978-0811858342",',
'    			"price": 32',
'    		}',
'    	],',
'    	"_id": "67EFC25A081831C44C5486DF"',
'    }~'');',
'    insert into book_collections_dv(data) values (q''~{',
'    	"collectionName": "Favorite Art Books",',
'    	"created": "2025-04-04T14:28:00",',
'    	"books": [',
'    		{',
'    			"title": "Malcom T. Liepke: A Retrospective",',
'    			"publisher": "Arcadia Contemporary Press",',
'    			"published": "2004-11-10",',
'    			"ISBN": "0-9754404-0-3",',
'    			"price": 125',
'    		},',
'    		{',
'    			"title": "Edward Hopper''s New York",',
'    			"publisher": "Whitney Museum of Art",',
'    			"published": "2022-11-22",',
'    			"ISBN": "978-0300266740",',
'    			"price": 32.5',
'    		}',
'    	],',
'    	"_id": "67EFC281081831C44C5486E2"',
'    }~'');',
'    insert into book_collections_dv(data) values (q''~{',
'    	"collectionName": "Best Cookbooks",',
'    	"created": "2025-04-05T07:55:00",',
'    	"books": [',
'    		{',
'    			"ISBN": "23423234",',
'    			"price": 15,',
'    			"title": "Spices of India",',
'    			"published": "2025-04-16",',
'    			"publisher": "Big Naan Press"',
'    		},',
'    		{',
'    			"ISBN": "93483434",',
'    			"price": 20,',
'    			"title": "Ricette Buone",',
'    			"published": "2025-04-29",',
'    			"publisher": "Feltrinelli"',
'    		}',
'    	],',
'    	"_id": "67EFF19E081831C44C54871C"',
'    }~'');',
'    commit;',
'end;',
'/'))
);
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
