wwv_flow_api.g_varchar2_table(2923) := '63957C64F3C1A600578C004D3047B980EE7D284C07B42C015C10077229543160ADC8518145EE048225DB9CAF239C76A548D4330D9B8B1F5C54DEE023C419571B89C1E08AB31306558FECC73B36FA7E34B987616558E3994A60E3018E4633503B23072C09';
wwv_flow_api.g_varchar2_table(2924) := '6C90083D3DE84FB94244079AA1C6F527A0E735B10CBF2AA13B5B19E79A3A92C596449895519627192719239ACA9A3443B94E3270541CE3D680427CA30AAC43632075A95D310AC8BBBE6386F72286040718DCA71CFA7434C93CC55CFCA1738E3D6980D924';
wwv_flow_api.g_varchar2_table(2925) := 'CB160BCB1CF34E52C4156C80DE9EB4C400B0901519E300E691D41C73CE7A75A5E63008049CF040FCE90AAE725719E87D28B88B56F202BE5ED24F63DBF2A99A770B973B198F191C0C5676D4BE8382A4CCBFEAF3CE179048AB0511BF74A54A719C74FCE87A';
wwv_flow_api.g_varchar2_table(2926) := '136123849F984641C608273939EB53DC5BF9F098DB084F381DAA8933DECA45077739E8C0E7FC9AAFE50598AF28A3B6325AA931A2CC36F1C8A55711876CE5D7E61E94B369D35BB24A855C02395EC73FA51707A14255712BB38C166249C70691B0CC00EA07';
wwv_flow_api.g_varchar2_table(2927) := 'E55404B1CD29DA1739E981C93ED5046ED9C12411E9DB9ED40165D55080AA0B9DC19B3D7351C6EB1B20D83690413D33FF00EAA94FA8C3CC6C3A4841046D1BB9DA339E29562C06C67E5FD29DC761608C4E4A8F948C9C8E7A54B12B2B9C95425790C7A0A408';
wwv_flow_api.g_varchar2_table(2928) := '71519F2F700EBF30C723153FEF960DA55061C36476CD311ABB229C09701B2319C723B1FC6B2AE8451B491330527276E71818E2A237033B04166201048E3352214C952704F2BCF4F6AB6087B0568DB07E63C8C1EA6AA6E38E40F6A1098248637C74F51539';
wwv_flow_api.g_varchar2_table(2929) := '547CB633562229C6D88E38354B27764F5A045D4507927E9430C0A064327BD44AC51F23AD022591CBF26900E01A0635B20D3D36F00F5F7A621738C9145AC625BA40E7E4CE49A4F6034257444090B00B8FE25FF39AAAF8DCC7CC2DC707A56512988AEFB3A2';
wwv_flow_api.g_varchar2_table(2930) := 'E1473C73566D5262032AE173939A256B021659A57053800E4118E6A865636DC08C8391441586C960B967950CD90A3F523A56AC721921CE0018EA3B8A8A91B02771B25D2271B813D00EB4C5B8321DA0AE0633CD428681718BBDCFEF15093C8CFF004A5865';
wwv_flow_api.g_varchar2_table(2931) := '4044672A0F51D8D55BA202BDD812C848938F6150ADA82A4ED2C71C6DF5AD93B2131D1425246570558024738C71C1AB51A0118CB39DC3033C71532608B50C3BD0CCECC800E1738344D206C2A6D0CE38CF39AC8A219194314566040CE31B6A160B23F96557';
wwv_flow_api.g_varchar2_table(2932) := '79E376781EB9AB5A088A676813CB85D76360F0727F1A2D25C4BF30F71576D05D4D15643C80A809E838CD271BF68FBC7A815CB2DCB124711AE24233ED4832C5B8C0E9C54DAC02876404C795246DC81C8A8D97701F3E030DBF37515B47613284D03C5BC29D';
wwv_flow_api.g_varchar2_table(2933) := 'CA3F880E950BC6C085C1CD6E9904E8CA030032BB703DA81CB1273C00285B8CB96457780DD0E73F962AD2FCCE14E0A0EB8EF5402B0F91876F4A8638D8336718EA4E3934806FD899D4B796B19EBD7BD42620558C8C46CC96238FA28A00864851C31C6CEF8E';
wwv_flow_api.g_varchar2_table(2934) := 'B8150A46AA792483D8D4DEE16237CA9E3814E4DBB80639CF34FA0031E0639A91363265DDB391D3D293D863AE0289484391FDEA83193D323D69C5E82629182554E680A7B03F8550005C8C039CFA52FF000825B183C0A404B114653EA71D6A45442382C4F5';
wwv_flow_api.g_varchar2_table(2935) := '3C74A622E226E4382D8E8067B5675D3113BE5795E2931824981C1E4D31C93F4C52403890C0839F51F5A118C44F03E618CD3604B22F98A847E9DAA2CE1F200C0A940C4E77E7A0F4A9A10C0EE27AF20FAD5011B3641E49C9CE3D6A1639E3B67AD000C3EE90';
wwv_flow_api.g_varchar2_table(2936) := '09C8E949203BB71C834EE223CE0E40A9531DC8C1A4C06E4E318E299FC5CF5A603C9246339DA7AD3720672BCFF2A007BC83CA015707D698189C524807E5597AD30163C03400EC050771E48A5494A600E99E3DA96E04EF3E5492DCE2AB019C8CE3BE0D1156';
wwv_flow_api.g_varchar2_table(2937) := '4363D6379032819DB49228040279F4A2E200CCA38E4771522B1180AC7079033D2868058A41E67CC39CE734E131570072B9E2A5A1A269A46F2080BF231CF4A6DB461D0E7820FE751B458FA9743C6C3CB71C37048AA93AC81D93692179E2A21B8D92EF7301';
wwv_flow_api.g_varchar2_table(2938) := 'D990C3B547146064B12AE0FA706AFA00BCFEF0EDDA39E8D8CFD2A1396078E39E7DEA9088C6E54C63F1A92054721C302473B4F19AA7A210E65DCBF23127BAD441CA927191DF9A94AE30124A49555E2ADC31AEDDC646527B35292B205A8F41E5A1566DD9F5';
wwv_flow_api.g_varchar2_table(2939) := 'E69A7111391F2F502A13B8CABBC8940C91CF14B23FC873C1C715A5B5248B040017924F5353265402E719ED5A4B6121442D27DC1851CE4F4C52EFDBFBA53823B8EF59DEFA141348AD03205E3AE6A9A31236B37CA3B1A20B41360493C0E99FCA987AE3D2B4';
wwv_flow_api.g_varchar2_table(2940) := '10A5B8E79A54215B732647A500233A9E995F6A5DDD082C706800470091C1A6F9C4499071F5A2C03198C8496E49A72E4751F9D301C20DC33B853848F18F2CB6E5C600F4A5B86C43CE6A48C0240C739A6C090C6064F4C7A8A6ADC3071B9723D2A6D719B724';
wwv_flow_api.g_varchar2_table(2941) := '965F645DB3312833E58C904E6AB79601257CB89CF4504E6B995D2D4BB21B1C935C38B45450E7A03C63F1A8E70D0CA63085645EA076356A36D09B959DE467CC80F1D41E334C67655006429AD52E821E5A32003EBDFD695A0638283269EC16145BA061B894';
wwv_flow_api.g_varchar2_table(2942) := '3FDDF5A99446AAB9CED07BD4C9BE80569034D2040C73F5E00A998088EDE5D02ED1C63F1A6DF402F0587519165695223126DD8E7208C75ACA76520AAB6587426941F4EC3922D4724725A2C72961227099638551DB1447B198050492704F0A00EDCD263259';
wwv_flow_api.g_varchar2_table(2943) := '1629199C46234CE150B647D734D1124981C9500907B545D85864811B18231EE79A85F119232718EBD31551131C1879398D995BEB4C95C30C331EC7183C9F5A696A042EA3785390D8E73CF34D590AB0C8E474AD492D585ACB772384C2855DC49E95221852';
wwv_flow_api.g_varchar2_table(2944) := 'D4488678E690900F452BDEB37D8A218D9622FB86E18C2E3A7E34C9662EC542ED53DB14D2D6E0DE9621E3AE726A445CFCA7927A62A992490A0D841C876E94D9501618520F5E7A9A57D46021930189C28A744B9C678F7349B405F3290BB7007B81DAA291CA';
wwv_flow_api.g_varchar2_table(2945) := '1CE32D819183903B56090C8FCEC8C819CE339ED522B162A589CE4FCBD2ADC6C227DA586593E627B719A8E7840E8B820E3E950B40B10BC4FE5E0B0CB1F940E94FBA8D222A237DC1461DC7F19F6F6ED5AA698586C625991E48E3CC69D7DAA290EC63F3EE50';
wwv_flow_api.g_varchar2_table(2946) := '7AFAD090C469CEDC200D9193C557DB8701860E79CF6AB4AC20DBB9C81CFE953488AB27CA777039A6C10F84B718E54F0054D243B5B7C63A75CF1C540C5F3652000496E8AA1703DE99B038DEB9326486078CD25A0308D580E739F41D0E2970D06D60DB49E7';
wwv_flow_api.g_varchar2_table(2947) := 'E619A2FD02C48B725A55201603A93DFDEAE4AC0C62408CE4FF0002B75FAD6528DA48B4509A064F99ADFE5CEEC8EDED52C2D14C9864C6E38650BC568DDD5D096E46D12C6CD8601908395E94EF376805B6EF27249CE58E7D29C5DC4C865B83138589C05C10';
wwv_flow_api.g_varchar2_table(2948) := '78E41CF5FAD2F9C8D88FA83F78B1E09ECD9ABB08915239221B70AE0119539DDF8D3FCC31C0A8C9EB93D2A011578DA473EB418E675F302601E39ED540C5F2CEE657CA328C818E4D3D22FDE00BF39DA71EDEF40885415392C739C7DDEB485483D324F6539C';
wwv_flow_api.g_varchar2_table(2949) := 'D360491DBC8C3254E719E39353AC4F22EC29B5B6839E80FD2B36D74018AF140CDE60DC470463A52463CE976642E7A64E38F6A6975298A33249B46D1B7E55C0033CF5C5682C4583BB32313C9C74C8F4A993B0855902C7211B8E79F978E98E94E0F248C91A';
wwv_flow_api.g_varchar2_table(2950) := '02A1BF898E303D7DE9369022564F9446F226F2060A9C8CD42B6D1099D790C79209E07D2A93110BB3AC89B816673F2317E38ED572D24CAEE67E09CFB81E956052BF8105D2EEDA226425319233EDF8D66AC2146EF3067A6D229A6EF60248A26396DD86033B';
wwv_flow_api.g_varchar2_table(2951) := 'B38A64B134054918DDD723A50DEB619342F21DE0807193CF2291650C8C19016F7E952D5F618390EABB57E7E431F5FF0038A7D860CBB1D0313FC47F87F0EF54B601B2992298ED6C8E78DBD07D2991EE76D80E0E3AB524F410ACE015C0E40208238353AC81';
wwv_flow_api.g_varchar2_table(2952) := 'E13195C6390475DDE9401A96137EE1548231C364739CD2DFDA8B9D8C101DB9040E091DB27D2B36DA6051305B98C23109820EE5E71ED5488D8C5BEF20E323AD5A7A0C9957CB9C13F30C65483D6A9DD1F267744FBA3919F7AA5B89908259F2DF31EF5614ED';
wwv_flow_api.g_varchar2_table(2953) := '4E4D592457126F43EF557636718E6988955A4880C8CAFA54BBC32E4114860B134A770E17A64D588E35FBAB1E481F99CF5350D813359C6DC080F4E589C734C92D079636FC873D339A853D476284A8518861D0F5F5A0B2AAE3764FB56C891114B91B810A7B';
wwv_flow_api.g_varchar2_table(2954) := 'FAD5C31975246D488738CF41498C84C8B9F97DB9A58CBBB8F2F24B7A527A016869D2B000CABC0E38240A7A585C230C5C0C0FAF02B2734C7A8F6B59D62202C721CFDE53F35671B678CFCCA411D88A709206211E61DA7393D7353AC2C17059BCA5E0633CD6';
wwv_flow_api.g_varchar2_table(2955) := '8D890AAC2DD9959067D339C52B4C67CAA05518E38A8B75191BCB22285321CA1EDD05477372262BB33C0C734D475B85C58DD9D71B41FA75A9E399B6047524039C8E09F6A6D0012BE5B1C9CB0C10573822A4B12F25C2899485C70E5720544968C0D4930AAC';
wwv_flow_api.g_varchar2_table(2956) := 'B904E704E3B567CE9B0EED8C547539E86B283B68532C793691DBA48D16E958ED193807DC5543E64CE622FB50364F183F8D5C5EBA886CB1280CD0FCF8CAB0C66A9B92CDC000FB56B1D44CBD04E5ED8478C3467863C9353AB148C16F971DBBD61511498C45';
wwv_flow_api.g_varchar2_table(2957) := '12ED761BB3C8CF6A779B9040FBB9E08EF51BE8324076CA08FBDD3269A89890C818A91D3DA852B0837055CAE304702ABCB6E923E57716F561DEAE2C4D148FCB232F607A9A96323237862A7D2BA108B309D8E3F955D2DF30208FCBA50001864F27E942EDC8';
wwv_flow_api.g_varchar2_table(2958) := '6278F7EF40C6DC4A510843DC671DAB3E462FDFE6DD9C7BD0C4425E48DB39C6E1D08A63382C4FB75A4900C24B100F20503A16514C000DCD8F4EFEB42F0719E28025538001EFD0D263032052D8072A6F381C1A90CA04981F2E075CD00420E07CB513A9EE7A';
wwv_flow_api.g_varchar2_table(2959) := '552405889330EEE3E5F7AB70C4CC030E401D0D021CEB28C8278EFB6A8DD2CC1F749C923F3A0646A70465B029ECDB867AD4A00C00063A9F5A07DEC919DA29B0260C58B601C7614D750AAA41E9C7D6A5683232095C93C9AB1110A371E0A8E6988878CE7A7B';
wwv_flow_api.g_varchar2_table(2960) := '0E950B12EC07BFA53025251179E4F41508DD9CE719F5A48061E09C8A339E3073ED5421CA485EA323B531F3D3191400DC73C52EEF5A62176B37D2A441C61464D4B18AE8597760F5C605315485C9CE295C07142D1EF5F9B039151367029A00EBD4E45380C3';
wwv_flow_api.g_varchar2_table(2961) := '0C0E29889524F2CF5E4F06A465494A9CE33EA6A2D677288D571BF19DBD33FE3405181C631EB45C074214B6E2BF28E2A658D361656391C8A4D82435A4560C243F303CE69C308A0A1207AFA1A56192A2B901C738AB1F2ECCE4EE3D73D6B193B3D0A4437171';
wwv_flow_api.g_varchar2_table(2962) := 'B4FCC33DB3EDEF50F9B9C06059471D79AD22B4B898F624AE3680C3B1EF55F90483DCFE7551131304B6173BB3536D521727191D874A72121C7CC8D7E41BB9FBCBDE90B2CAA4E003DC11D6A7CC644E0E410701BB8A91CB210BBB7291C739154F51081B2B86';
wwv_flow_api.g_varchar2_table(2963) := '278E983D69C5DF61C76F5F4ACEC322999B2240321BA71D29A00CF3CD6F144B2589072C5B0474E2A4802F2C57183DFA54546348925BAFDDE14053E951C08AC4191892738CD67B4463EE14C6840036F6159C400C723A706AA9EC0C5723670A063BFAD33636';
wwv_flow_api.g_varchar2_table(2964) := 'DCF63CD6B7246B1FC2942F62C73400FD8A3863CD341556E06E1E8690C56719C8400D44C0BC849FC6A96821DE5E5721B27D29BB46EC1271EB45C43F7606D072477F5142919E78A4311B83CF3EF42360838EF4C07925F3CD34213CE0D2034275D9B8346C24';
wwv_flow_api.g_varchar2_table(2965) := '73B8F3803DB1492C7E74CAF0DB70980E81F2588FAF3592EE5B45CB9B369A07BA0BE4EDFBA08E48FF001ACE75F2CEE95816CF639FCE88EC16B113380E01391EB8A922585A27725DA503E418E3F3AAD56C205214798C838E33D39A743133480ABE4B1E0302';
wwv_flow_api.g_varchar2_table(2966) := '09AA7B090932C8650AE0965383DB8A6B4787DA55D475C1A9BA0156DF00B64FBF622A58561DEED3A3B02BF2F3819A57EA0579A2202B274C73ED4D8E265994491927862ADC6455A7A01AE960B708D32C396933E5C4B260271DCD56BBF322F2E19A3488018C';
wwv_flow_api.g_varchar2_table(2967) := '05C16FAD62A5CCEC5584B84759DB0524C01F321C81ED528797C94655561BB60556F98FE1E949AD80A92E006CA9DDD9739CD559599B1FC35AC4862C79D982793D7D40A4FE23C923DEAC06FCC19598F5E335344A85BCD4018E71B59BBFAD0C0BEDE6D9AAA4';
wwv_flow_api.g_varchar2_table(2968) := '1345F3E25665EDE82A19DDDDB0D96551F2E4E4283EDDAB2D2E511040E58F65C1E47DEA49977C85BE4193C91C2F1569884382EC0B200579246054B12AED3205CA81D4AE40FC29301D248980142EEC024F4C9A93C94C82CC4961951EB50EE807DBC8BC2385';
wwv_flow_api.g_varchar2_table(2969) := 'DA7839151BC91A7CD1AA900F4EC45424EE3207BC91BCB1BBEE1C8E287BD924572DB9D98E59AB5E442B8F48C7908CE858E4B67763031C7D69F12E1875DDB41F4E693770275DC0F03A7A9E951DD63080CBB8119C0CE57EB9A8431A1CA44EC24DA32319E49F';
wwv_flow_api.g_varchar2_table(2970) := 'A5539E4DCC76B123A649EB5705A8325B4B89238CA2FCA99DCCD9E7A629EE3CF8DA462842B64800024FE156F477115C1DA77B0F97D296631B29643C8EDFDEA3A831C80BC7C28CAF703F99A9E1CC1285970700363FFAD40C459D15BE72A4862780391DAA51';
wwv_flow_api.g_varchar2_table(2971) := '224B2B20524039C96E9E8052604534D1C93953B863B9EFEF50C9313CA809DB20F5A1218B1CD2B2F960023A62A487CC3208DC719F9893D29349022F17FDD8FDD145270B8A0A461B3BCEE1DC1E07E1DEB0D4BB0CB9989C22BA956F4151A9484101B96180B9';
wwv_flow_api.g_varchar2_table(2972) := 'E6AD2D2C223DABBB2C0819EBDCD40E08605724AFF9C56911313ECFE6CAAAABCEDCF3C63EB52140B8F371B80C8082AAE4A44AAA15F2AAD9040C0E78A75C485978C304F9718E7351D4644BB08CC641000393C107B8A69972879EFD0D520013B2C8265C6410';
wwv_flow_api.g_varchar2_table(2973) := '4679C76A8D24DACDB180CFE43D4555809DC1949643F36FC1F6E3834FB6B79432398D46339F7C5672692B1269476EE7239FA66A395767C8A8D9519CE3B56093194A563B324008406E98DC2A195A34F955413804609E3E95BA4C189034B04D1484800F24E3';
wwv_flow_api.g_varchar2_table(2974) := 'B679CD680466248651B8E49C73CF3DA89AB889022960C8721471C647AE0D58051208B684C8DC0A963DCFF9E2B27D868ABE7F9921B88D48C1C1DDFCF02A570ECE2424A03D57AE7FC2AED60648D6EAB11F90B64FDE5196151E045193876541B8FCA0673DEB';
wwv_flow_api.g_varchar2_table(2975) := '44221D4089ED612CA63903E067F873D41ACC963565CABB703903D7355B201D6BBD1B25030E06D7F4EF4F71BE3D922B671F29F4FF0038A993290C0DE51C67702BF36283B5B63F3C0FC48A6BB80DDBFBDDC376C27AF4ED4F8C912E541E98C1A7701D74F8C1';
wwv_flow_api.g_varchar2_table(2976) := '53BD4003918343BCB2CE0A29201C64F4FCEA5680C8B736EE83BF7EBEB4F880450C4BE01C9DBC1C0FAD5D8934ED8CAD01958F25C92BDC0FF1ABF0C8AEA518E491C81DEB39A1A312F1CACEE191557764704F07F1AACE546E0C1300FF0008EB55102C452EE8';
wwv_flow_api.g_varchar2_table(2977) := '915D1327BF75F4EF50DF21648E5CE597E57F51E945F51BD8AA3083269198C9C76AD4CC72C58DB9E4FF002A99557710C3240231D72690C631C005783DFD29B0DB8790B370A39C0EF4AF603456110F24A9C63EE8C814E4BA20202995E7951F8D60D730D0D6';
wwv_flow_api.g_varchar2_table(2978) := '9CB9F9A4544EA037248AAF25C123049E7DFA8AA8C6C044FE5B23EE4396FBA41E01EF50C76A5A451D549C71D6B54C45868D446CE8FC072AAA7AE3D7F954526172839E39FAD3109144CEEA8B825BF4AD8485234DA0EDED9AC2ACBA1490AEFF00742E3D1573';
wwv_flow_api.g_varchar2_table(2979) := 'C523BAA7DE7C01C927BD656B8CAF793F951A94B8DCCE3808C0E07BD528EE1D0F2D91E87BD7428248572C190CF19211571C9C0E9513BBE701895E30334241719B8B67E5E7B77A8C9278DDF415422291CF4CF02980F7E98AA10F1C739C548242786E695865';
wwv_flow_api.g_varchar2_table(2980) := 'E89A1684C92B1CAF00752C7B9AD0478CC691A64460707A7E35CF3B9688AE99942084EF627AF4A81A5958932BB33753C50920631D8C72FCCA46C200C8EB4F927463BB824E00079DB4EDADC486F9CC230377C831F2818FAF35448039CFB5690132CDAB3232';
wwv_flow_api.g_varchar2_table(2981) := '12B807201353BE37850870C39F415135A8D12800E403F291DA9327EE8C7E158228679A4C9918E3D2A60C0649C118CE0D37101148C646D000C1C7F3A86532264E4601C920E41AA86E23387CDC54ABD8161D7A7F5AE820B96EBBB6B30627D00CE71DEAD16C';
wwv_flow_api.g_varchar2_table(2982) := 'C9C74E6A98D0D072ECD8CF6CFA5233A9036B77C60F07AD2194EEA7241503033CD552E49DC4F3458426FCF5E9D68539F9703F1A004550720824F6C5388209C723D450C068186F43EB52050EA0743EB4806BA147C31040E841A557098C9CF7C50C05661B89';
wwv_flow_api.g_varchar2_table(2983) := 'E99ED4D4064C81F5C7AD09013243850D8381D6A1652E496EBDF15622DC4A0DB608E54E2ACAB2AAF9680EE0382290C5466CA3B671DC1AA97B22BCA4AB6463BF34015003B7D853B0380ADF877A94022FDE031DFA53F8F980EE714D890E8CE31CE0FF003A17';
wwv_flow_api.g_varchar2_table(2984) := '1D79E09CFBD218D5DCCE0609C54B1E187CDC01CFFF005A980C73841D3079C541FED6318A0069F99492738A706F306DC638CFD6810C3C64631E9C52AAB0F9CF14C04DDF3648C8A42D91CF4A006F7FAD040079E87A53014138C03934F898827E5C9A968079';
wwv_flow_api.g_varchar2_table(2985) := '6761D0920678ED4D3216F940A56010B63217AF7C50A01619E334F602631306E06E5EF8E951050320E41F4349300DC380C01C75ED9A4CF603A1A00963665047B73915244B1852598103D4D43F218A8115B6823079C1A199402AA696AD8C836891890718EA';
wwv_flow_api.g_varchar2_table(2986) := '2AE08D521562D86C60A9E86AA4F642436399891B39DDC6DAB0D3282BBB8CF07158CA3A94990BFCEC5C6393822A09386F94FD4FAD6B1131F6A4962AC473D01A1FEF1E06E1C52DA41D068F9B218B6E1D3DA9A7AE3D3BD5089564703A91818A9366EC36DC67';
wwv_flow_api.g_varchar2_table(2987) := 'A9150F4188D1145D8C7A9C838A886F54C2A82011549DC361EB182A4161B80CE7D29B8319600F18E68110A331272C76FA538E39FCEB65A124A1B110CE00C7E7491B2312242428E83DEB168B1C23F30862324F402A758846A3BB015949F402A5CCBB88F99B';
wwv_flow_api.g_varchar2_table(2988) := '2A79CD5419CE33C9ADE2AC84C7E0AA927834CDDCFB53003F3375C520625B9E0F6354210B1C6334AB9E49A0009CFCB8A09D871D6801586D3EBF4A4C9E99E0D20136F1D79A0860064153EFE94C00763DE979C03EBDE800CE0F7A9ED8E5FEE9CA8CFCB4981A';
wwv_flow_api.g_varchar2_table(2989) := '7387917ED11A2E76E48233B7DEA2B82F1B2AC722B804302540C9EF5CD1B688D5DCA9233B8F99988E71B9B2053237040CA6EE7A1EF5B7423A93C9A7DC2A19248C2AE7843D4539ADDD824795000E01149C900915B2CF218FCD891900C6FE371FAD48D6AF04';
wwv_flow_api.g_varchar2_table(2990) := 'FF00673282D8058AB7F3A1CBA021D11493F7663DCC3AB13D053248C09326320919DBC9C8F5ACEF6761919506550FB8A819214E7352C7019A169115523E4E59BAE3B0AABD816A54672323771D302A5547BAB84DD36D6618324AD8C8157B216E4B3888DC2A';
wwv_flow_api.g_varchar2_table(2991) := '89C065C22EC27078EB9A924DB14ACEABE76C187727203F6C56767B143A24B79577CD72C18B9695157200FF00134AB288E1736D048ABBB72CA7AAD2682C466DD63FF48915A45DC723772C7AD50B928642DB76231C851CE2B483B92C8FAE09E3DE9AAA581E';
wwv_flow_api.g_varchar2_table(2992) := 'A7E95A22455460BBF1C1CD491ED28173B5B3C9238FCE86C68B28D10DC36EF5F5152E7195081571C64E33F5AC1A772AE419213180B939C74C8A48E013EF0CE1362920019CFB55DEDA896A5723905BA114B1C9B5886276B7079AD372492128B22637703278';
wwv_flow_api.g_varchar2_table(2993) := 'FBC6ACA4CBBB72E10E7383D3FF00D5ED59C8A423C5863BD9C0209C81D4F5A6344C143163B5B853DC9A49A0B12AD8EFB23701D46D3B76F73559CEC00638C73557B89AB0EF3848A08C8000E0D2B4ACCC1901E981E94B96C02EE763B0061B8E4A9E39A64930';
wwv_flow_api.g_varchar2_table(2994) := '3D1B711C61BA5096A03A37DAAE8F1A333E06ECE48FA76A65CC22350777CC72481FE354B71896A03B80143376079A67CCBBD436067903A1A621C40628B9049F415616DA116ACC597CC0410C1B9FA6295EC049668771CE08518F5FE555EE9B126387C9EB8F';
wwv_flow_api.g_varchar2_table(2995) := '6F5A480848078072DEC29F13491B8031ED9E9ED54323694F98CFD4B139CF4A082083D770CD301D149E4C8586483D4558016E3E7526361CE4F4A89771A11DDB7005B23A7AD21CED07AE7A053D0516417258E58E14CB292DD97B52EF24E768191E9C0FA54B';
wwv_flow_api.g_varchar2_table(2996) := '43B8DF31721C31DE0FE029A5460B33100763548085E466258E0E4E7AF5F6A97CB3BCEEC927240FC781814C44AB26E8D18E43124608EBF8D46ADD0E403CF53D4D2B009090C4AFCAA40FBDE951C8A0280A39EFEF4FA886A9E369E05491478718DA31CFCDFE';
wwv_flow_api.g_varchar2_table(2997) := '1540687D9D515E7639DC798CF7ED5662D9E5E1004C8CF1CE0D6135A887B481FF008C8200CE3BD0C180556C3F38C9EC3AD2195EF6112AF32A9EE723A0F6AA20C4929DE598281B4742DFE15680927994C61514E3A6C27AE7A1A726F29B173B3EE9E7A719CE';
wwv_flow_api.g_varchar2_table(2998) := '7F3A6D00AF3489BA3600A8073B411FAD492486785C805B80400D8273DAB36BA86C4968189CED7693CBF9C01CFB53DE6DC83CB25643D79CEDF5155D4416F74A54297EBC8DC7A83E94F9650CFE58192411B4F71FE71560675DDDED69136B1C31E49CF3E954';
wwv_flow_api.g_varchar2_table(2999) := 'FCF38FDE2E46E0481C550176D6644753E5EE43939EE7D78EF4C9660D36F8F03184047D2A5A29119C1724B852AA4E71D7DA9BE5842C19B006393D4834D76062DAB3B13129E99E18D3995B928C1C75E39F7A52D0110493191C839C16C906A78CBC6CD1A91B';
wwv_flow_api.g_varchar2_table(3000) := '3BE7AD3B0869B4970658B0B9FF00391535A928CEB72BB81F948FA9EB562342D71B1234909C12C50F5F4E7D715184B9377245BF12000A10300FA5296C1D4AB2E0C84B83E675249E011D7F1A89C8750C7690470ABFCAA50C6201B5884E48EA4F435612312C';
null;
end;
/
begin
wwv_flow_api.g_varchar2_table(3001) := '2413C1014F3D3D0D27A0CC790B2B32B7041C1A7453346B82B95AD8CCB0B3C4D8C654FBD399863EF003D8D21913CC1460726A4B5242972373120FD293D807BCEC1F9C67713F2D42F965E18823A0F4A4958191172BC11CFAD267B62AAC20CE3BD489334641';
wwv_flow_api.g_varchar2_table(3002) := '1D8E7068B00D6965624AF4CF5C5489048EAB213B57B67A9A361976292181311FCC4FDE2475A9E290CC5885181DBAD72CA2F76342CD34507385671E9C115993DCBCE496200F41574E3D5831C65592DD6338063E413D4FB0A833CFF8D6E213CE3192830548';
wwv_flow_api.g_varchar2_table(3003) := 'C1A7ACAADC0E94AC038B0EDC1F5A8A572DC93CD08089559CE14669F2DBC9085671C1E869DD6C210120823B5032400AA4B66802C4519881F332326A6175326DD87000E87D2A5A5229310DCB95639C376C74A9ED6F1D3253EF052189EA01F4A8946C1708D1';
wwv_flow_api.g_varchar2_table(3004) := 'A6532B2EE0A7EFE72D8A853CA4907271F4FE5496AEC039A44390000A47001FD6A170796030093DFA55C5581823103AF7E9579E4696D1946DDA0E707D6A2A740432294ED9013B5635038A73CA7CB6118F95B0338F7ACDC75288F7AE180C61793519BCEA02';
wwv_flow_api.g_varchar2_table(3005) := 'E140EB8CD5A8DC5727B790BC2DC0CF7C0EBEF44C07D9580207CC718146CC6505C6F18E3B7D29780C8DD6B420B4920F2F72C981903AF23F0AB1E682BF29CB7E7C53190AB331DB1920FF00755738FA9AB2CB23A7DE20F4E474A00CFBA1E5C85739CD404738';
wwv_flow_api.g_varchar2_table(3006) := 'ED4C4288F6B018CF14060136ED071DE96E31A08E87B0A7A30DA3B63AFBD0C04C82C3DF8A72EF0A79C8E94806395EB919F4A3733638CE6988568CE4648AB56A81490C33EF4C09AE31F6765008E9FAD520A33CFE74C0B56DF74E7900F7AB0836E700E3039E';
wwv_flow_api.g_varchar2_table(3007) := 'A0D48D12A02840ED8E7359775B44AE47427A629811E414000C01D29E2324678E2A7A811AF2F4FE49E94D80F623A0E83814D5CE3B1F7A403A14C48CC4E060F34E7C88546DC1E41A6040E47DDE7DA900E093C81FA52023200E87AF5A6720F06A843BCC6391';
wwv_flow_api.g_varchar2_table(3008) := 'D7DA86C95E4F4FE1A2C034904138A4A003A7B8A0A838DA33ED4C05FBA406069493838EF4807E5B6640E83AD460FA0E6900BB78E695081838F6A00B08768621F1C738A81DC336E724E79A98A01AAC3903A7BD4BC300411C7E94D80A1C646EE289645DC02F';
wwv_flow_api.g_varchar2_table(3009) := 'E271536188D2718001A421DC120EDCF6A6B410F5568C80F1F51D6A6964F9D30301474232293D58C45FF8F80E47CA4E38ED4F9FF777193CAF07F1A9EA32556841F9B041CF38EA2A16689E5E4911FB75A949DC6248D1820AE6A4936B9520F5E69BBEE03441';
wwv_flow_api.g_varchar2_table(3010) := 'B4315EA3D78A848F98AB75EFED4D4AE21B9E700F4A903C8EA0019354D2112AACCF2853B940E6877C2E4631D31EF52319B8798AC0FB1CD32E4FEF7646F9535715A8861F940E38A920512B1C8E055C9D91289E48CC9B507271C542FB63F94AE48E39E05651';
wwv_flow_api.g_varchar2_table(3011) := '77D0B2CDAC4C13CC6CE48E39E82AB5D4D2FDD6E07D7352929483A15DD4F97E613D78151E3D78AD891C5B2307B74A6752303F01400A71EB48ABBB182073DE98065413C7B6697EEF3DC7623834086B74F6A606E306980B9E314A39EBCD030E4F0280E76904';
wwv_flow_api.g_varchar2_table(3012) := 'D00009C7AFD68C9E78C668100E4F279AB962A3733E49C0C6DF5A996C52DCFFD9';
null;
end;
/
begin
wwv_flow_api.create_plugin_file(
 p_id=>wwv_flow_api.id(60034838845446305074)
,p_plugin_id=>wwv_flow_api.id(87533112644228034927)
,p_file_name=>'tectonic-plates-569347_1920.jpg'
,p_mime_type=>'image/jpeg'
,p_file_charset=>'utf-8'
,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table)
);
end;
/
prompt --application/user_interfaces
begin
wwv_flow_api.create_user_interface(
 p_id=>wwv_flow_api.id(428440845006998233)
,p_ui_type_name=>'DESKTOP'
,p_display_name=>'Desktop'
,p_display_seq=>10
,p_use_auto_detect=>false
,p_is_default=>true
,p_theme_id=>42
,p_home_url=>'f?p=&APP_ID.:4:&SESSION.'
,p_login_url=>'f?p=&APP_ID.:LOGIN_DESKTOP:&SESSION.'
,p_theme_style_by_user_pref=>false
,p_global_page_id=>0
,p_navigation_list_id=>wwv_flow_api.id(428304103537997676)
,p_navigation_list_position=>'SIDE'
,p_navigation_list_template_id=>wwv_flow_api.id(428406110984998073)
,p_nav_list_template_options=>'#DEFAULT#:js-navCollapsed--hidden:t-TreeNav--styleB'
,p_css_file_urls=>'#APP_IMAGES#app-icon.css?version=#APP_VERSION#'
,p_nav_bar_type=>'LIST'
,p_nav_bar_list_id=>wwv_flow_api.id(428440529510998229)
,p_nav_bar_list_template_id=>wwv_flow_api.id(428405723100998072)
,p_nav_bar_template_options=>'#DEFAULT#'
);
end;
/
prompt --application/user_interfaces/combined_files
begin
null;
end;
/
prompt --application/pages/page_00000
begin
wwv_flow_api.create_page(
 p_id=>0
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Global Page - Desktop'
,p_step_title=>'Global Page - Desktop'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'D'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200323223436'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(432933490716209725)
,p_name=>'load_Background'
,p_event_sequence=>10
,p_bind_type=>'bind'
,p_bind_event_type=>'ready'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(432933638903209726)
,p_event_id=>wwv_flow_api.id(432933490716209725)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'PLUGIN_AT.RAMMELHOF.MODERNBACKGROUND'
,p_attribute_01=>'planet-2120004_1920.jpg'
,p_attribute_02=>'planet-2120004_1920.jpg'
,p_attribute_05=>'black'
,p_attribute_06=>'0.5'
,p_attribute_08=>'Y'
,p_attribute_09=>'Y'
,p_attribute_10=>'#fbce4a'
);
end;
/
prompt --application/pages/page_00001
begin
wwv_flow_api.create_page(
 p_id=>1
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Home'
,p_alias=>'HOME'
,p_step_title=>'Corona Hilfe Angebote'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200324174737'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428453517763998641)
,p_plug_name=>'Corona Help Portal - My Profile'
,p_icon_css_classes=>'app-icon'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428330366786997924)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_plug_query_num_rows=>15
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
,p_attribute_03=>'Y'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428517051324999013)
,p_plug_name=>'Page Navigation'
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#:u-colors:t-Cards--featured t-Cards--block force-fa-lg:t-Cards--displayIcons:t-Cards--4cols:t-Cards--hideBody:t-Cards--animColorFill'
,p_escape_on_http_output=>'Y'
,p_plug_template=>wwv_flow_api.id(428330242231997924)
,p_plug_display_sequence=>30
,p_plug_display_point=>'BODY'
,p_list_id=>wwv_flow_api.id(428516305820999013)
,p_plug_source_type=>'NATIVE_LIST'
,p_list_template_id=>wwv_flow_api.id(428397315341998061)
,p_plug_query_num_rows=>15
);
end;
/
prompt --application/pages/page_00002
begin
wwv_flow_api.create_page(
 p_id=>2
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'My Profile'
,p_step_title=>'My Profile'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_help_text=>'Hier kannst Du Dein Profil anpassen.<br /><br />'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200325100641'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428454844642998657)
,p_plug_name=>'Corona Help'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428355752240997960)
,p_plug_display_sequence=>10
,p_plug_grid_column_span=>6
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'CORONA_HELP'
,p_query_where=>'upper(email) = upper(:APP_USER)'
,p_include_rowid_column=>false
,p_plug_source_type=>'NATIVE_IR'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_worksheet(
 p_id=>wwv_flow_api.id(428454879087998657)
,p_name=>'Mein Profil'
,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_show_nulls_as=>'-'
,p_pagination_type=>'ROWS_X_TO_Y'
,p_pagination_display_pos=>'BOTTOM_RIGHT'
,p_show_search_bar=>'N'
,p_report_list_mode=>'TABS'
,p_show_detail_link=>'C'
,p_detail_link=>'f?p=&APP_ID.:17:&SESSION.::&DEBUG.::P17_ID:\#ID#\'
,p_detail_link_text=>'<span class="fa fa-edit" aria-hidden="true"></span>'
,p_owner=>'FISCHER'
,p_internal_uid=>210828615676215439
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428455346264998684)
,p_db_column_name=>'ID'
,p_display_order=>1
,p_column_identifier=>'A'
,p_column_label=>'ID'
,p_column_type=>'NUMBER'
,p_heading_alignment=>'RIGHT'
,p_column_alignment=>'RIGHT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428455697163998704)
,p_db_column_name=>'ANREDE'
,p_display_order=>2
,p_column_identifier=>'B'
,p_column_label=>'Sal.'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428456084721998706)
,p_db_column_name=>'VORNAME'
,p_display_order=>3
,p_column_identifier=>'C'
,p_column_label=>'Prename'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428456561560998706)
,p_db_column_name=>'NAME'
,p_display_order=>4
,p_column_identifier=>'D'
,p_column_label=>'Name'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428456921109998706)
,p_db_column_name=>'STRASSE'
,p_display_order=>5
,p_column_identifier=>'E'
,p_column_label=>'Street'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428457361948998707)
,p_db_column_name=>'PLZ'
,p_display_order=>6
,p_column_identifier=>'F'
,p_column_label=>'ZIP-code'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428457754994998707)
,p_db_column_name=>'ORT'
,p_display_order=>7
,p_column_identifier=>'G'
,p_column_label=>'City/Town'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428458082471998707)
,p_db_column_name=>'STADTTEIL'
,p_display_order=>8
,p_column_identifier=>'H'
,p_column_label=>'District'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428458464340998708)
,p_db_column_name=>'ANGEBOT'
,p_display_order=>9
,p_column_identifier=>'I'
,p_column_label=>'Engagement'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428458937851998709)
,p_db_column_name=>'KATEGORIE'
,p_display_order=>10
,p_column_identifier=>'J'
,p_column_label=>'Category'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428459284130998709)
,p_db_column_name=>'SONSTIGES'
,p_display_order=>11
,p_column_identifier=>'K'
,p_column_label=>'Misc.'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428459689638998712)
,p_db_column_name=>'EMAIL'
,p_display_order=>12
,p_column_identifier=>'L'
,p_column_label=>'Email'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428460079664998712)
,p_db_column_name=>'PASSWORT'
,p_display_order=>13
,p_column_identifier=>'M'
,p_column_label=>'Passwort'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428460533389998713)
,p_db_column_name=>'TELEFON'
,p_display_order=>14
,p_column_identifier=>'N'
,p_column_label=>'Telephone'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428460882469998713)
,p_db_column_name=>'PKW'
,p_display_order=>15
,p_column_identifier=>'O'
,p_column_label=>'Pkw'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428461269900998714)
,p_db_column_name=>'ERFASST_AM'
,p_display_order=>16
,p_column_identifier=>'P'
,p_column_label=>'created'
,p_column_type=>'DATE'
,p_display_text_as=>'HIDDEN'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428461716479998714)
,p_db_column_name=>'ANGEBOT_GUELTIG_BIS'
,p_display_order=>17
,p_column_identifier=>'Q'
,p_column_label=>'Valid until'
,p_column_type=>'DATE'
,p_display_text_as=>'HIDDEN'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428462144623998714)
,p_db_column_name=>'BEMERKUNGEN'
,p_display_order=>18
,p_column_identifier=>'R'
,p_column_label=>'Remarks'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(428462398280998715)
,p_db_column_name=>'ADMIN'
,p_display_order=>19
,p_column_identifier=>'S'
,p_column_label=>'Admin'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_rpt(
 p_id=>wwv_flow_api.id(428485747344998908)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'2108595'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'ANREDE:VORNAME:NAME:STRASSE:PLZ:ORT:STADTTEIL:ANGEBOT:KATEGORIE:SONSTIGES:TELEFON:PKW:ERFASST_AM:ANGEBOT_GUELTIG_BIS:BEMERKUNGEN:'
,p_sort_column_1=>'ANREDE'
,p_sort_direction_1=>'ASC'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428462819385998715)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(428454844642998657)
,p_button_name=>'Help_available'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'t-Button--iconRight'
,p_button_template_id=>wwv_flow_api.id(428418367443998122)
,p_button_image_alt=>'Help available'
,p_button_position=>'RIGHT_OF_IR_SEARCH_BAR'
,p_button_redirect_url=>'f?p=&APP_ID.:5:&SESSION.::&DEBUG.:::'
,p_icon_css_classes=>'fa-hand-o-right'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428465381100998746)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(428454844642998657)
,p_button_name=>'CREATE'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,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.:3:&SESSION.::&DEBUG.:3'
,p_button_condition_type=>'NEVER'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(428464479484998729)
,p_name=>'Edit Report - Dialog Closed'
,p_event_sequence=>10
,p_triggering_element_type=>'REGION'
,p_triggering_region_id=>wwv_flow_api.id(428454844642998657)
,p_bind_type=>'bind'
,p_bind_event_type=>'apexafterclosedialog'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(428464966210998735)
,p_event_id=>wwv_flow_api.id(428464479484998729)
,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_api.id(428454844642998657)
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(428465784727998747)
,p_name=>'Create Button - Dialog Closed'
,p_event_sequence=>20
,p_triggering_element_type=>'BUTTON'
,p_triggering_button_id=>wwv_flow_api.id(428465381100998746)
,p_bind_type=>'bind'
,p_bind_event_type=>'apexafterclosedialog'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(428466338567998749)
,p_event_id=>wwv_flow_api.id(428465784727998747)
,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_api.id(428454844642998657)
);
end;
/
prompt --application/pages/page_00003
begin
wwv_flow_api.create_page(
 p_id=>3
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Masks available'
,p_step_title=>'Masks available'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_help_text=>unistr('Durch das Ausw\00E4hlen einer Hilfe oder Kategorie kann man im n\00E4chsten Schritt seine Kontaktdaten hinterlassen - und wird dann angerufen oder angemailt, um Weiteres zu vereinbaren.')
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200327145344'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(654789950904320999)
,p_plug_name=>'<font color="lightblue">Corona Help - Help in the Region</font>'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428330366786997924)
,p_plug_display_sequence=>5
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_report_region(
 p_id=>wwv_flow_api.id(861963361876934551)
,p_name=>'Corona Help - Help in the Region'
,p_template=>wwv_flow_api.id(428357602299997961)
,p_display_sequence=>10
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader:t-Region--scrollBody'
,p_component_template_options=>'#DEFAULT#:t-Cards--displaySubtitle:t-Cards--compact:t-Cards--displayInitials:t-Cards--float:t-Cards--animColorFill'
,p_display_point=>'BODY'
,p_source_type=>'NATIVE_SQL_REPORT'
,p_query_type=>'SQL'
,p_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select ID,',
'KATEGORIE as CARD_TITLE,',
'plz||''-''||ORT||'', ''||STADTTEIL as card_subtitle, ',
'ANGEBOT as CARD_TEXT,',
'',
'case ',
'when masks_available > 0 then',
'substr(VORNAME,1,1)||'' ''|| substr(NAME,1,3)||''...- ''||''Masks available: ''|| masks_available',
'else',
'ANREDE||'' ''||substr(VORNAME,1,1)||'' ''|| substr(NAME,1,3)||''...'' end as CARD_SUBTEXT,',
'apex_string.get_initials(VORNAME) as card_initials,     -- 2 or 3 letters, use apex_string.get_initials(...)',
'APEX_PAGE.GET_URL (',
'            p_page   => 8,',
'            p_items  => ''P8_COR_HELPER_FK'',',
'            p_values => ID ) as CARD_LINK',
'--       STRASSE,',
'--       SONSTIGES,',
'--       EMAIL,',
'--       PASSWORT,',
'--       TELEFON,',
'--       PKW,',
'--       ERFASST_AM,',
'--       ANGEBOT_GUELTIG_BIS',
'--       BEMERKUNGEN',
'  from CORONA_HELP',
'  where ANGEBOT_GUELTIG_BIS > SYSDATE',
'--  and id != 525',
' and upper(ORT)||upper(stadtteil) like ''%''||upper(:P3_SUCHE)||''%''',
' and Kategorie like ''Masks''',
'  ',
'  -- vorlage:',
'  /**',
'  select',
'  -- data',
'  card_title,       -- title',
'  card_subtitle,    -- subtitle, set template option to see',
'  card_text,        -- card body text',
'  card_subtext,     -- card secondary text, positioned near bottom',
'',
'  -- ui and other attributes',
'  card_modifiers,   -- card item modifiers',
'  card_link,        -- card link, use apex_page.get_url(...)',
'  card_color,       -- color modifier, e.g. u-color-1 or u-warning',
'  card_icon,        -- icon class, e.g. fa-cloud',
'  card_initials     -- 2 or 3 letters, use apex_string.get_initials(...)',
'from dual',
'',
'**/',
'   '))
,p_header=>'Select the card with the engagement and enter your data on the next page. You will then be contacted by telephone or email.<br><br>'
,p_ajax_enabled=>'Y'
,p_query_row_template=>wwv_flow_api.id(428373497645997999)
,p_query_num_rows=>15
,p_query_options=>'DERIVED_REPORT_COLUMNS'
,p_query_show_nulls_as=>'-'
,p_query_num_rows_type=>'NEXT_PREVIOUS_LINKS'
,p_pagination_display_position=>'BOTTOM_RIGHT'
,p_csv_output=>'N'
,p_prn_output=>'N'
,p_sort_null=>'L'
,p_plug_query_strip_html=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(222574900879430331)
,p_query_column_id=>1
,p_column_alias=>'ID'
,p_column_display_sequence=>1
,p_column_heading=>'Id'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(222575380383430336)
,p_query_column_id=>2
,p_column_alias=>'CARD_TITLE'
,p_column_display_sequence=>2
,p_column_heading=>'Card Title'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(222575747364430336)
,p_query_column_id=>3
,p_column_alias=>'CARD_SUBTITLE'
,p_column_display_sequence=>3
,p_column_heading=>'Card Subtitle'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(222576143601430337)
,p_query_column_id=>4
,p_column_alias=>'CARD_TEXT'
,p_column_display_sequence=>4
,p_column_heading=>'Card Text'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(222576582938430338)
,p_query_column_id=>5
,p_column_alias=>'CARD_SUBTEXT'
,p_column_display_sequence=>5
,p_column_heading=>'Card Subtext'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(222576966228430339)
,p_query_column_id=>6
,p_column_alias=>'CARD_INITIALS'
,p_column_display_sequence=>6
,p_column_heading=>'Card Initials'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(222577397606430339)
,p_query_column_id=>7
,p_column_alias=>'CARD_LINK'
,p_column_display_sequence=>7
,p_column_heading=>'Card Link'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(221499917617739031)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(861963361876934551)
,p_button_name=>'Go'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Go'
,p_button_position=>'BODY'
,p_grid_new_row=>'N'
,p_grid_new_column=>'Y'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(221500037462739032)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(861963361876934551)
,p_button_name=>'Reset'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'Reset - show all'
,p_button_position=>'BODY'
,p_button_redirect_url=>'f?p=&APP_ID.:5:&SESSION.::&DEBUG.:RP,5::'
,p_grid_new_row=>'N'
,p_grid_new_column=>'Y'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(222577739400430340)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(861963361876934551)
,p_button_name=>'enter_offer'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'t-Button--iconRight'
,p_button_template_id=>wwv_flow_api.id(428418367443998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Enter your Engagement here'
,p_button_position=>'RIGHT_OF_IR_SEARCH_BAR'
,p_button_redirect_url=>'f?p=&APP_ID.:17:&SESSION.::&DEBUG.:17::'
,p_icon_css_classes=>'fa-hand-o-right'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(222578102143430355)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(861963361876934551)
,p_button_name=>'CREATE'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,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.:17:&SESSION.::&DEBUG.:17::'
,p_button_condition_type=>'NEVER'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(221499847495739030)
,p_name=>'P3_SUCHE'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(861963361876934551)
,p_prompt=>'Suche'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(428416997352998107)
,p_item_template_options=>'#DEFAULT#'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
end;
/
prompt --application/pages/page_00004
begin
wwv_flow_api.create_page(
 p_id=>4
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Corona engagement home page '
,p_step_title=>'Corona Hilfe Angebote Annahme'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200325120629'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(426997755160873029)
,p_plug_name=>'Welcome! Nice to see you here !!'
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_grid_column_span=>6
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'<b><table >',
' ',
'<tr>',
'  <td>This appplication will serve to coordinate help and engagement related to the COVID-19 crisis.<br><br>',
'This is a non commercial initiative.<br><br>',
'Engaged people - lets call them "Service-Providers" - may register in this portal and describe what they are willing to do for others. How they like to engage.<br>',
'    <td>',
'<img src ="#APP_IMAGES#apeks.png" width = 200><br><br><br><br></td>',
'  </tr>',
'</table>',
'',
'<br>',
'The "Help-Seekers", who require assistance and help, may select from the list of services and leave their contact data.<br><br>',
'',
'The "Service-Providers" will be informed by mail and establish contact to the "Job-Seekers".<br><br>',
'',
'This all does work without interference. The programm in the portal does that all.<br>',
'The communication is by email - but no data will be communicated - this all is done in the portal - the "profile" of the "Service Provider".<br>',
'Please see "The Process Flow" page (<--Menue - left) illustrating the communication<br><br>',
'',
'Data security is important nowadays. Your data will not be onpassed to third parties and after the project is coming to an end will be deleted completely.<br>',
'"Service-Providers" may delete their data anytime by entering the profile.<br>',
'The "Help-seeker" data are then deleted as well.<br><br>',
'',
'',
'Be proud, that you engage yourself here !!!! Respect ! <br><br>',
'',
'We are looking forward to your engagement <br><br>',
'',
'Your<br>',
'Corona-Help-Team',
''))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_report_region(
 p_id=>wwv_flow_api.id(428809967240400543)
,p_name=>'Offers for Engagement&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'
,p_template=>wwv_flow_api.id(428357602299997961)
,p_display_sequence=>20
,p_include_in_reg_disp_sel_yn=>'Y'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_component_template_options=>'#DEFAULT#:t-Report--altRowsDefault:t-Report--rowHighlight'
,p_new_grid_row=>false
,p_display_point=>'BODY'
,p_source_type=>'NATIVE_SQL_REPORT'
,p_query_type=>'TABLE'
,p_query_table=>'CORONA_HELP'
,p_query_where=>wwv_flow_string.join(wwv_flow_t_varchar2(
'ADMIN IS NULL',
'and ANGEBOT_GUELTIG_BIS > SYSDATE'))
,p_include_rowid_column=>false
,p_ajax_enabled=>'Y'
,p_query_row_template=>wwv_flow_api.id(428380348961998008)
,p_query_num_rows=>15
,p_query_options=>'DERIVED_REPORT_COLUMNS'
,p_query_show_nulls_as=>'-'
,p_query_num_rows_type=>'ROW_RANGES'
,p_pagination_display_position=>'BOTTOM_RIGHT'
,p_csv_output=>'N'
,p_prn_output=>'N'
,p_sort_null=>'L'
,p_plug_query_strip_html=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428810096270400544)
,p_query_column_id=>1
,p_column_alias=>'ID'
,p_column_display_sequence=>1
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428810165774400545)
,p_query_column_id=>2
,p_column_alias=>'ANREDE'
,p_column_display_sequence=>2
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428810295329400546)
,p_query_column_id=>3
,p_column_alias=>'VORNAME'
,p_column_display_sequence=>3
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428810445623400547)
,p_query_column_id=>4
,p_column_alias=>'NAME'
,p_column_display_sequence=>4
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428810539625400548)
,p_query_column_id=>5
,p_column_alias=>'STRASSE'
,p_column_display_sequence=>5
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428810649361400549)
,p_query_column_id=>6
,p_column_alias=>'PLZ'
,p_column_display_sequence=>6
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428810726826400550)
,p_query_column_id=>7
,p_column_alias=>'ORT'
,p_column_display_sequence=>11
,p_column_heading=>'Location'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428810786797400551)
,p_query_column_id=>8
,p_column_alias=>'STADTTEIL'
,p_column_display_sequence=>12
,p_column_heading=>'District'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428810881092400552)
,p_query_column_id=>9
,p_column_alias=>'ANGEBOT'
,p_column_display_sequence=>9
,p_column_heading=>'Engagement'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811022406400553)
,p_query_column_id=>10
,p_column_alias=>'KATEGORIE'
,p_column_display_sequence=>10
,p_column_heading=>'Category'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811114003400554)
,p_query_column_id=>11
,p_column_alias=>'SONSTIGES'
,p_column_display_sequence=>13
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811223213400555)
,p_query_column_id=>12
,p_column_alias=>'EMAIL'
,p_column_display_sequence=>14
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811345981400556)
,p_query_column_id=>13
,p_column_alias=>'PASSWORT'
,p_column_display_sequence=>15
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811452587400557)
,p_query_column_id=>14
,p_column_alias=>'TELEFON'
,p_column_display_sequence=>16
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811503135400558)
,p_query_column_id=>15
,p_column_alias=>'PKW'
,p_column_display_sequence=>17
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811618850400559)
,p_query_column_id=>16
,p_column_alias=>'ERFASST_AM'
,p_column_display_sequence=>18
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811671810400560)
,p_query_column_id=>17
,p_column_alias=>'ANGEBOT_GUELTIG_BIS'
,p_column_display_sequence=>19
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811791085400561)
,p_query_column_id=>18
,p_column_alias=>'BEMERKUNGEN'
,p_column_display_sequence=>20
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811940896400562)
,p_query_column_id=>19
,p_column_alias=>'ADMIN'
,p_column_display_sequence=>21
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(428811970123400563)
,p_query_column_id=>20
,p_column_alias=>'DATENSCHUTZ'
,p_column_display_sequence=>22
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432216337781890729)
,p_plug_name=>'<font color="lightblue">Welcome! Nice to see you here !!</font>'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428330366786997924)
,p_plug_display_sequence=>5
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(426997780587873030)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(428809967240400543)
,p_button_name=>'EnterEngagement'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#:t-Button--iconRight'
,p_button_template_id=>wwv_flow_api.id(428418367443998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Enter your Engagement here'
,p_button_position=>'RIGHT_OF_TITLE'
,p_button_redirect_url=>'f?p=&APP_ID.:17:&SESSION.::&DEBUG.:RP,17:P17_PREV_PAGE:&APP_PAGE_ID.'
,p_icon_css_classes=>'fa-signing'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432219265263890759)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(428809967240400543)
,p_button_name=>'Help_neded'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#:t-Button--iconRight'
,p_button_template_id=>wwv_flow_api.id(428418367443998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Help needed ? Click here'
,p_button_position=>'RIGHT_OF_TITLE'
,p_button_redirect_url=>'f?p=&APP_ID.:5:&SESSION.::&DEBUG.:RP::'
,p_icon_css_classes=>'fa-volume-control-phone'
);
end;
/
prompt --application/pages/page_00005
begin
wwv_flow_api.create_page(
 p_id=>5
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Hilfs Angebote'
,p_step_title=>'Hilfs Angebote'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_help_text=>unistr('Durch das Ausw\00E4hlen einer Hilfe oder Kategorie kann man im n\00E4chsten Schritt seine Kontaktdaten hinterlassen - und wird dann angerufen oder angemailt, um Weiteres zu vereinbaren.')
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200327145447'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432216217630890728)
,p_plug_name=>'<font color="lightblue">Corona Help - Help in the Region</font>'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428330366786997924)
,p_plug_display_sequence=>5
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_report_region(
 p_id=>wwv_flow_api.id(639389628603504280)
,p_name=>'Corona Help - Help in the Region'
,p_template=>wwv_flow_api.id(428357602299997961)
,p_display_sequence=>10
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader:t-Region--scrollBody'
,p_component_template_options=>'#DEFAULT#:t-Cards--displaySubtitle:t-Cards--compact:t-Cards--displayInitials:t-Cards--float:t-Cards--animColorFill'
,p_display_point=>'BODY'
,p_source_type=>'NATIVE_SQL_REPORT'
,p_query_type=>'SQL'
,p_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select ID,',
'KATEGORIE as CARD_TITLE,',
'plz||''-''||ORT||'', ''||STADTTEIL as card_subtitle, ',
'ANGEBOT as CARD_TEXT,',
'',
'case ',
'when masks_available > 0 then',
'substr(VORNAME,1,1)||'' ''|| substr(NAME,1,3)||''...- ''||''Masks available: ''|| masks_available',
'else',
'ANREDE||'' ''||substr(VORNAME,1,1)||'' ''|| substr(NAME,1,3)||''...'' end as CARD_SUBTEXT,',
'apex_string.get_initials(VORNAME) as card_initials,     -- 2 or 3 letters, use apex_string.get_initials(...)',
'APEX_PAGE.GET_URL (',
'            p_page   => 8,',
'            p_items  => ''P8_COR_HELPER_FK'',',
'            p_values => ID ) as CARD_LINK',
'--       STRASSE,',
'--       SONSTIGES,',
'--       EMAIL,',
'--       PASSWORT,',
'--       TELEFON,',
'--       PKW,',
'--       ERFASST_AM,',
'--       ANGEBOT_GUELTIG_BIS',
'--       BEMERKUNGEN',
'  from CORONA_HELP',
'  where ANGEBOT_GUELTIG_BIS > SYSDATE',
'--  and id != 525',
' and upper(ORT)||upper(stadtteil)||upper(KATEGORIE) like ''%''||upper(:P5_SUCHE)||''%''',
' and upper(ORT)||upper(stadtteil)||upper(KATEGORIE) like ''%''||upper(:P5_SUCHE2)||''%''',
'  ',
'  -- vorlage:',
'  /**',
'  select',
'  -- data',
'  card_title,       -- title',
'  card_subtitle,    -- subtitle, set template option to see',
'  card_text,        -- card body text',
'  card_subtext,     -- card secondary text, positioned near bottom',
'',
'  -- ui and other attributes',
'  card_modifiers,   -- card item modifiers',
'  card_link,        -- card link, use apex_page.get_url(...)',
'  card_color,       -- color modifier, e.g. u-color-1 or u-warning',
'  card_icon,        -- icon class, e.g. fa-cloud',
'  card_initials     -- 2 or 3 letters, use apex_string.get_initials(...)',
'from dual',
'',
'**/',
'   '))
,p_header=>'Select the card with the engagement and enter your data on the next page. You will then be contacted by telephone or email.<br><br>'
,p_ajax_enabled=>'Y'
,p_query_row_template=>wwv_flow_api.id(428373497645997999)
,p_query_num_rows=>15
,p_query_options=>'DERIVED_REPORT_COLUMNS'
,p_query_show_nulls_as=>'-'
,p_query_num_rows_type=>'NEXT_PREVIOUS_LINKS'
,p_pagination_display_position=>'BOTTOM_RIGHT'
,p_csv_output=>'N'
,p_prn_output=>'N'
,p_sort_null=>'L'
,p_plug_query_strip_html=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(221497955703739011)
,p_query_column_id=>1
,p_column_alias=>'ID'
,p_column_display_sequence=>1
,p_column_heading=>'Id'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(221499259213739024)
,p_query_column_id=>2
,p_column_alias=>'CARD_TITLE'
,p_column_display_sequence=>2
,p_column_heading=>'Card Title'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(221499328697739025)
,p_query_column_id=>3
,p_column_alias=>'CARD_SUBTITLE'
,p_column_display_sequence=>3
,p_column_heading=>'Card Subtitle'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(221499458449739026)
,p_query_column_id=>4
,p_column_alias=>'CARD_TEXT'
,p_column_display_sequence=>4
,p_column_heading=>'Card Text'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(221499501361739027)
,p_query_column_id=>5
,p_column_alias=>'CARD_SUBTEXT'
,p_column_display_sequence=>5
,p_column_heading=>'Card Subtext'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(221499695231739028)
,p_query_column_id=>6
,p_column_alias=>'CARD_INITIALS'
,p_column_display_sequence=>6
,p_column_heading=>'Card Initials'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(221499736458739029)
,p_query_column_id=>7
,p_column_alias=>'CARD_LINK'
,p_column_display_sequence=>7
,p_column_heading=>'Card Link'
,p_use_as_row_header=>'N'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(221500216692739034)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(639389628603504280)
,p_button_name=>'Go'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'Go'
,p_button_position=>'BODY'
,p_grid_new_row=>'N'
,p_grid_new_column=>'Y'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(221500415481739036)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_api.id(639389628603504280)
,p_button_name=>'Reset'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'Reset - show all'
,p_button_position=>'BODY'
,p_button_redirect_url=>'f?p=&APP_ID.:5:&SESSION.::&DEBUG.:RP,5::'
,p_grid_new_row=>'N'
,p_grid_new_column=>'Y'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428570186355289014)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(639389628603504280)
,p_button_name=>'enter_offer'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'t-Button--iconRight'
,p_button_template_id=>wwv_flow_api.id(428418367443998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Enter your Engagement here'
,p_button_position=>'RIGHT_OF_IR_SEARCH_BAR'
,p_button_redirect_url=>'f?p=&APP_ID.:17:&SESSION.::&DEBUG.:17::'
,p_icon_css_classes=>'fa-hand-o-right'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428570505864289021)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(639389628603504280)
,p_button_name=>'CREATE'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,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.:17:&SESSION.::&DEBUG.:17::'
,p_button_condition_type=>'NEVER'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(221500119133739033)
,p_name=>'P5_SUCHE'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(639389628603504280)
,p_prompt=>'search for'
,p_placeholder=>'location...'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(428416997352998107)
,p_item_template_options=>'#DEFAULT#'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(221500551525739037)
,p_name=>'P5_SUCHE2'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(639389628603504280)
,p_prompt=>'search '
,p_placeholder=>'category'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428416997352998107)
,p_item_template_options=>'#DEFAULT#'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
end;
/
prompt --application/pages/page_00006
begin
wwv_flow_api.create_page(
 p_id=>6
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Corona Helper - all Data'
,p_step_title=>'Corona Helper - all Data'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_required_role=>wwv_flow_api.id(432186096805417042)
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200327163134'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(431513302282340066)
,p_plug_name=>'Corona Helper - Contactdata (Admin only)'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select ID,',
'       ANREDE,',
'       VORNAME,',
'       NAME,',
'       STRASSE,',
'       PLZ,',
'       ORT,',
'       STADTTEIL,',
'       ANGEBOT,',
'       KATEGORIE,',
'       SONSTIGES,',
'       EMAIL,',
'--       PASSWORT,',
'       TELEFON,',
'--       PKW,',
'       ERFASST_AM,',
'       ANGEBOT_GUELTIG_BIS,',
'       BEMERKUNGEN,',
'       ADMIN,',
'       DATENSCHUTZ',
'  from CORONA_HELP',
'  where id != 525'))
,p_plug_source_type=>'NATIVE_IR'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_worksheet(
 p_id=>wwv_flow_api.id(431513390132340066)
,p_name=>'Corona Helfer - alle Daten'
,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_show_nulls_as=>'-'
,p_pagination_type=>'ROWS_X_TO_Y_OF_Z'
,p_pagination_display_pos=>'BOTTOM_RIGHT'
,p_show_actions_menu=>'N'
,p_report_list_mode=>'TABS'
,p_show_detail_link=>'C'
,p_detail_link=>'f?p=&APP_ID.:3:&SESSION.::&DEBUG.:RP:P3_ID,P3_PREV_PAGE:#ID#,&APP_PAGE_ID.'
,p_detail_link_text=>'<img src="#IMAGE_PREFIX#app_ui/img/icons/apex-edit-pencil.png" class="apex-edit-pencil" alt="">'
,p_owner=>'FISCHER'
,p_internal_uid=>213887126720556848
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431513826751340291)
,p_db_column_name=>'ID'
,p_display_order=>1
,p_column_identifier=>'A'
,p_column_label=>'Id'
,p_column_type=>'NUMBER'
,p_heading_alignment=>'RIGHT'
,p_column_alignment=>'RIGHT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431514317645340363)
,p_db_column_name=>'ANREDE'
,p_display_order=>2
,p_column_identifier=>'B'
,p_column_label=>'Sal.'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431514716658340364)
,p_db_column_name=>'VORNAME'
,p_display_order=>3
,p_column_identifier=>'C'
,p_column_label=>'Prename'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431515085328340365)
,p_db_column_name=>'NAME'
,p_display_order=>4
,p_column_identifier=>'D'
,p_column_label=>'Name'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431515509109340365)
,p_db_column_name=>'STRASSE'
,p_display_order=>5
,p_column_identifier=>'E'
,p_column_label=>'Street'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431515903453340366)
,p_db_column_name=>'PLZ'
,p_display_order=>6
,p_column_identifier=>'F'
,p_column_label=>'Zip-Code'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431516361827340367)
,p_db_column_name=>'ORT'
,p_display_order=>7
,p_column_identifier=>'G'
,p_column_label=>'City/Town'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431516750438340367)
,p_db_column_name=>'STADTTEIL'
,p_display_order=>8
,p_column_identifier=>'H'
,p_column_label=>'District'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431517157546340367)
,p_db_column_name=>'ANGEBOT'
,p_display_order=>9
,p_column_identifier=>'I'
,p_column_label=>'Engagement'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431517925075340368)
,p_db_column_name=>'SONSTIGES'
,p_display_order=>11
,p_column_identifier=>'K'
,p_column_label=>'Misc.'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431518318439340372)
,p_db_column_name=>'EMAIL'
,p_display_order=>12
,p_column_identifier=>'L'
,p_column_label=>'Email'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431519130775340373)
,p_db_column_name=>'TELEFON'
,p_display_order=>14
,p_column_identifier=>'N'
,p_column_label=>'Telephone'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431519904357340375)
,p_db_column_name=>'ERFASST_AM'
,p_display_order=>16
,p_column_identifier=>'P'
,p_column_label=>'Created'
,p_column_type=>'DATE'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431520315622340381)
,p_db_column_name=>'ANGEBOT_GUELTIG_BIS'
,p_display_order=>17
,p_column_identifier=>'Q'
,p_column_label=>'valid until'
,p_column_type=>'DATE'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431520671615340382)
,p_db_column_name=>'BEMERKUNGEN'
,p_display_order=>18
,p_column_identifier=>'R'
,p_column_label=>'Remarks'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431521126097340382)
,p_db_column_name=>'ADMIN'
,p_display_order=>19
,p_column_identifier=>'S'
,p_column_label=>'Admin'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(431521515536340383)
,p_db_column_name=>'DATENSCHUTZ'
,p_display_order=>20
,p_column_identifier=>'T'
,p_column_label=>'Datasecurity'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(222631874390831510)
,p_db_column_name=>'KATEGORIE'
,p_display_order=>30
,p_column_identifier=>'V'
,p_column_label=>'Category'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_rpt(
 p_id=>wwv_flow_api.id(431523153986345744)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'2138969'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'ID:ANREDE:VORNAME:NAME:STRASSE:PLZ:ORT:STADTTEIL:ANGEBOT:SONSTIGES:EMAIL:TELEFON:BEMERKUNGEN:ANGEBOT_GUELTIG_BIS:ERFASST_AM::KATEGORIE'
);
end;
/
prompt --application/pages/page_00007
begin
wwv_flow_api.create_page(
 p_id=>7
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Fragen/Antworten'
,p_step_title=>'Fragen/Antworten'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200324223324'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428812106130400564)
,p_plug_name=>'How does it work to establish contact ?'
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428342734110997951)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'<b>Service-Provider:</b><br><br>',
'1. The Service-provider for services enters his services with his Email-Address.<br><br>',
'2. At first he gets a confirmation mail.<br><br>',
'3. His engagement is shown on the "list of engagements".<br><br><br>',
'',
'<b>Help-Seekers:</b><br><br>',
'',
'4. Do search for a category or service or engagement or location for an adequate service.<br><br>',
'5. He/she finds an appropriate servcie and clicks on the description and<br><br>',
'6. enters his contact-data in a form.<br><br>',
'7. the application will then send an confirmation-email to him/her and a mail to the "Service Provider"<br><br>',
'',
'<b>Service-Provider:</b><br><br>',
'',
'8. The Service-Provider receives the Email with therequest to sign in to the "Corona-Help-Portal" --> uppper right "Login-Profile".<br><br>',
'9. He logs in with E-Mail-Address and Password. If he has forgotten his password, he can click the link to get it by mail.<br><br>',
'10. Once logged in in his "Profile" he will see his own data and on the right hand side the contact-data of the "Help-seeker".<br><br>',
'11. Contact to the "Help-Seeker" can be made by telephone or Email.',
''))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428812209021400565)
,p_plug_name=>'I forgot my Password - what to do?'
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428342734110997951)
,p_plug_display_sequence=>20
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'On the Login-Page you can find a link called "password forgotten"<br><br>',
'One can click on that link and a page will appear, where you may enter your Email-address<br><br>',
'You press the button "send" and the application will send you a Mail with your password.'))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428812417398400567)
,p_plug_name=>'I don''t have time anymore - what to do ?'
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428342734110997951)
,p_plug_display_sequence=>30
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'You may sign in to the Portal and adjust your data accordingly:<br><br>',
'You may change "offer valid until" to a day before today and the engagement offered will no longer appear on the list of engagements.'))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432215747168890723)
,p_plug_name=>'What shall elderly people do, who don''t have a computer or internet?'
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428342734110997951)
,p_plug_display_sequence=>40
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'This is a valid question.<br><br>',
'ONE Option: You speak to your parents or elderlys, who are in need of services.<br><br>',
'YOU can organize this for them.<br>',
'YOU enter their contact details and they will be contacted.<br>'))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432215796090890724)
,p_plug_name=>'Data Security - what will happen to my data ?'
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428342734110997951)
,p_plug_display_sequence=>50
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Data Security is very important.<br><br>',
'',
'Your saved date will only be used for this project and will not be onpassed to third parties.<br><br>',
'',
'Responsible for that is the person/organisation stipulated on the "Imprint-page".'))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432215874036890725)
,p_plug_name=>'Can I withdraw my data or delete it ?'
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428342734110997951)
,p_plug_display_sequence=>60
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source=>'yes, anytime you can access your profil (upper right "My Pr0file") and delete your data.'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432215972914890726)
,p_plug_name=>'<font color="lightblue">Questions & Answers</font>'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428330366786997924)
,p_plug_display_sequence=>5
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
end;
/
prompt --application/pages/page_00008
begin
wwv_flow_api.create_page(
 p_id=>8
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Request service'
,p_step_title=>'Request service'
,p_autocomplete_on_off=>'OFF'
,p_javascript_code=>'var htmldb_delete_message=''"DELETE_CONFIRM_MSG"'';'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_protection_level=>'C'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200325114739'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428611360801571056)
,p_plug_name=>'Engagement appreciated - pls enter you data here and send it - You will then be contacted by the people'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_plug_grid_column_span=>6
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'CORONA_LEUTE'
,p_include_rowid_column=>false
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_plug_source_type=>'NATIVE_FORM'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428620636550571164)
,p_plug_name=>'Buttons'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428340720298997944)
,p_plug_display_sequence=>20
,p_plug_display_point=>'BODY'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'TEXT'
,p_attribute_03=>'Y'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428620986166571165)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(428611360801571056)
,p_button_name=>'CANCEL'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'cancel'
,p_button_position=>'BELOW_BOX'
,p_button_alignment=>'LEFT'
,p_button_redirect_url=>'f?p=&APP_ID.:5:&SESSION.::&DEBUG.:RP::'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428622611492571200)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(428611360801571056)
,p_button_name=>'DELETE'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'Delete'
,p_button_position=>'BELOW_BOX'
,p_button_redirect_url=>'javascript:apex.confirm(htmldb_delete_message,''DELETE'');'
,p_button_execute_validations=>'N'
,p_button_condition=>'P8_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'DELETE'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428623051638571200)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(428611360801571056)
,p_button_name=>'SAVE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Apply Changes'
,p_button_position=>'BELOW_BOX'
,p_button_condition=>'P8_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'UPDATE'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428623376907571201)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_api.id(428611360801571056)
,p_button_name=>'CREATE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'send...'
,p_button_position=>'BELOW_BOX'
,p_button_condition=>'P8_ID'
,p_button_condition_type=>'ITEM_IS_NULL'
,p_database_action=>'INSERT'
);
wwv_flow_api.create_page_branch(
 p_id=>wwv_flow_api.id(426999335919873045)
,p_branch_action=>'f?p=&APP_ID.:5:&SESSION.::&DEBUG.:RP::&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'AFTER_PROCESSING'
,p_branch_type=>'REDIRECT_URL'
,p_branch_when_button_id=>wwv_flow_api.id(428623376907571201)
,p_branch_sequence=>10
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(426999738307873049)
,p_name=>'P8_EMAIL_ANBIETER'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select email from CORONA_HELP',
'where id = :P8_COR_HELPER_FK'))
,p_source_type=>'QUERY'
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428611630473571067)
,p_name=>'P8_ID'
,p_source_data_type=>'NUMBER'
,p_is_primary_key=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_source=>'ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428611984185571115)
,p_name=>'P8_COR_HELPER_FK'
,p_source_data_type=>'NUMBER'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_source=>'COR_HELPER_FK'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428612267699571137)
,p_name=>'P8_ANREDE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'Salutation'
,p_source=>'ANREDE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_RADIOGROUP'
,p_lov=>'STATIC2:Mrs.;Mrs.,Mr.;Mr.'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'2'
,p_attribute_02=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428612692220571138)
,p_name=>'P8_VORNAME'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'Prename'
,p_source=>'VORNAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>12
,p_cMaxlength=>20
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428613101768571141)
,p_name=>'P8_NAME'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>60
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'Name'
,p_source=>'NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>20
,p_cMaxlength=>20
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428613516067571142)
,p_name=>'P8_STRASSE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'Street'
,p_source=>'STRASSE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>20
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428613929645571147)
,p_name=>'P8_PLZ'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>80
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'ZIP'
,p_source=>'PLZ'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>6
,p_cMaxlength=>10
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428614309293571147)
,p_name=>'P8_ORT'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>90
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'City/Town'
,p_source=>'ORT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>20
,p_cMaxlength=>50
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428614692396571148)
,p_name=>'P8_TELEFON'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>100
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'Telephone'
,p_source=>'TELEFON'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>20
,p_cMaxlength=>20
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428615068470571149)
,p_name=>'P8_EMAIL'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>110
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'Email'
,p_source=>'EMAIL'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428615536583571149)
,p_name=>'P8_ERSTELLT_AM'
,p_source_data_type=>'DATE'
,p_item_sequence=>130
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_default=>'sysdate'
,p_item_default_type=>'PLSQL_EXPRESSION'
,p_prompt=>'created on'
,p_source=>'ERSTELLT_AM'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DATE_PICKER'
,p_cSize=>10
,p_cMaxlength=>255
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_04=>'button'
,p_attribute_05=>'N'
,p_attribute_07=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428615916584571150)
,p_name=>'P8_BEMERKUNGEN'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>140
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'Remarks'
,p_source=>'BEMERKUNGEN'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXTAREA'
,p_cSize=>60
,p_cMaxlength=>200
,p_cHeight=>4
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428616272889571150)
,p_name=>'P8_INFIZIER_JA_NEIN'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>160
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'Infected'
,p_source=>'INFIZIER_JA_NEIN'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_RADIOGROUP'
,p_lov=>'STATIC2:Yes;Yes,NO;No'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'2'
,p_attribute_02=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428809801577400541)
,p_name=>'P8_DATENSCHUTZ'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>150
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_item_source_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'Data security: I agree, that my data will be stored and only used for the project please see "About Page" for more info.'
,p_source=>'DATENSCHUTZ'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_CHECKBOX'
,p_lov=>'STATIC:Yes;Yes'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'1'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432217528763890741)
,p_name=>'P8_EMAIL_1'
,p_is_required=>true
,p_item_sequence=>120
,p_item_plug_id=>wwv_flow_api.id(428611360801571056)
,p_prompt=>'Email Check - pls key in again'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_validation(
 p_id=>wwv_flow_api.id(428809921381400542)
,p_validation_name=>'Datenschutz_ja'
,p_validation_sequence=>10
,p_validation=>'P8_DATENSCHUTZ'
,p_validation2=>'Yes'
,p_validation_type=>'ITEM_IN_VALIDATION_EQ_STRING2'
,p_error_message=>'sorry, without "Yes" it will not work... please se the "Imprint page" as well'
,p_when_button_pressed=>wwv_flow_api.id(428623376907571201)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_api.create_page_validation(
 p_id=>wwv_flow_api.id(432217650073890742)
,p_validation_name=>'Check_email_format'
,p_validation_sequence=>20
,p_validation=>'regexp_like (:P17_EMAIL, ''^[A-Za-z]+[A-Za-z0-9.]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$'')'
,p_validation_type=>'PLSQL_EXPRESSION'
,p_error_message=>'Email Format not valid'
,p_associated_item=>wwv_flow_api.id(428615068470571149)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_api.create_page_validation(
 p_id=>wwv_flow_api.id(432217737463890743)
,p_validation_name=>'Check_Email_misprint'
,p_validation_sequence=>30
,p_validation=>'P8_EMAIL'
,p_validation2=>'&P8_EMAIL_1.'
,p_validation_type=>'ITEM_IN_VALIDATION_EQ_STRING2'
,p_error_message=>'Email not correct - please check'
,p_associated_item=>wwv_flow_api.id(428615068470571149)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(428621088346571165)
,p_name=>'Cancel Dialog'
,p_event_sequence=>10
,p_triggering_element_type=>'BUTTON'
,p_triggering_button_id=>wwv_flow_api.id(428620986166571165)
,p_bind_type=>'bind'
,p_bind_event_type=>'click'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(428621925677571193)
,p_event_id=>wwv_flow_api.id(428621088346571165)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_DIALOG_CANCEL'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(428624227306571204)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(428611360801571056)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>unistr('Process form Hilfe erw\00FCnscht')
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_process_error_message=>'nix gespeichert.'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_api.id(428623376907571201)
,p_process_success_message=>'your request has been processed'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(426999605970873048)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_SEND_EMAIL'
,p_process_name=>'Mail to service provider'
,p_attribute_01=>'info@bfw-design.de'
,p_attribute_02=>'&P8_EMAIL_ANBIETER.'
,p_attribute_06=>'Request for help from the Corona-Help-Portal'
,p_attribute_07=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Hallo,',
'',
'',
'please have a look into the "Corona-Help-Portal". ',
'',
'',
'There is a contact, who requested help.',
'',
'',
'Thank you for your engagement.',
'',
'',
'We can do it !',
'',
'',
'Your Corona-Help-Portal Team',
''))
,p_attribute_08=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Hallo,',
'<br><br>',
'',
'please have a look into the "Corona-Help-Portal". ',
'<br><br>',
'',
'There is a contact, who requested help.',
'',
'<br><br>',
'Thank you for your engagement.',
'<br><br>',
'',
'We can do it !',
'',
'<br><br>',
'Your Corona-Help-Portal Team'))
,p_attribute_10=>'N'
,p_process_error_message=>'keine Mail'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_api.id(428623376907571201)
,p_process_success_message=>'Mail geht raus an den Anbieter - er wird sich melden. Bitte etwas Geduld.'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(428623792765571203)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(428611360801571056)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>unistr('Initialize form Hilfe erw\00FCnscht')
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
end;
/
prompt --application/pages/page_00009
begin
wwv_flow_api.create_page(
 p_id=>9
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Passwort forgotten'
,p_step_title=>'Passwort forgotten'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200324171004'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428808794672400531)
,p_plug_name=>'Password forgotten'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_grid_column_span=>4
,p_plug_display_point=>'BODY'
,p_plug_source=>'Please enter your Email-Address here and we''ll send you your password.<br><br>'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_plug_footer=>'<br><br>this takes a little while... - pls also look into your SPAM-folder.'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428809059339400533)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(428808794672400531)
,p_button_name=>'send'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Send...'
,p_button_position=>'BELOW_BOX'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428808887725400532)
,p_name=>'P9_EMAIL'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(428808794672400531)
,p_prompt=>'Email'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(428417352493998107)
,p_item_template_options=>'#DEFAULT#'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_validation(
 p_id=>wwv_flow_api.id(428809462996400537)
,p_validation_name=>'check_if_Mail_exists'
,p_validation_sequence=>10
,p_validation=>'select 1 from CORONA_HELP where upper(EMAIL) = upper(:P9_EMAIL)'
,p_validation_type=>'EXISTS'
,p_error_message=>'this Email does not exist in our records ... misprint ?'
,p_always_execute=>'Y'
,p_when_button_pressed=>wwv_flow_api.id(428809059339400533)
,p_associated_item=>wwv_flow_api.id(428808887725400532)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_api.create_page_validation(
 p_id=>wwv_flow_api.id(215307795513426512)
,p_validation_name=>'check_email_format'
,p_validation_sequence=>20
,p_validation=>'regexp_like (:P9_EMAIL, ''^[A-Za-z]+[A-Za-z0-9.]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$'')'
,p_validation_type=>'PLSQL_EXPRESSION'
,p_error_message=>'not a valid email format... please kindly check'
,p_when_button_pressed=>wwv_flow_api.id(428809059339400533)
,p_associated_item=>wwv_flow_api.id(428808887725400532)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(428809357366400536)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Passwort_mailen'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'for c1 in (select EMAIL,PASSWORT ',
'             from CORONA_HELP ',
'            where upper(EMAIL) = upper(:P9_EMAIL)) loop',
'  if c1.EMAIL is not null then',
'    APEX_MAIL.SEND',
'(',
'   P_TO       => c1.EMAIL,',
'',
'   P_FROM     => ''no-reply@corona-help.org'',',
'',
'   P_BODY     => ''Here is your password as requested for the Corona-Help-Portal:''||chr(10)||chr(10)||c1.PASSWORT||chr(10)||chr(10)||''',
'    rgds''||chr(10)||',
'    ''your Corona-Help-Team'' ,',
'',
'   P_SUBJ     => ''requested information for the Corona-Help-Portal''',
');',
'end if;',
'end loop;'))
,p_process_error_message=>'nothing maild'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_api.id(428809059339400533)
,p_process_success_message=>wwv_flow_string.join(wwv_flow_t_varchar2(
'your password has been mailed.... <br>',
'please also look into your Spam-folder.'))
);
end;
/
prompt --application/pages/page_00010
begin
wwv_flow_api.create_page(
 p_id=>10
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Background Infos'
,p_step_title=>'Background Infos'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200324130918'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432933072471209721)
,p_plug_name=>'Background Infos on COVID-19'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Dr. Emily Porter, Austin Texas - <a target=new href="https://www.youtube.com/watch?v=gTxuo0gH_ho"> Video auf Youtube (5:30 Min.) - Englisch</a><br>',
'"Flatten the Curve" - 49 von 50 Amerikanern werden sterben...<br><br>'))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
end;
/
prompt --application/pages/page_00011
begin
wwv_flow_api.create_page(
 p_id=>11
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Restaurant Services'
,p_step_title=>'Restaurant Services'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200325004713'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428812525748400568)
,p_plug_name=>'Restaurants - will come to your home'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Restaurants have closed... (;-(...<br><br>',
'.. or have to adjust their business model:<br><br>',
'<table >',
' <tr>',
'  <td>Yesterday I received this WhatsApp message from my tennis-partner Gaetano Orlando:<br>',
'Buongiorno!<br>',
'If you don''t come to the Buona Sera, <b>the Buona Sera will come to you!</b><br>',
'Select your meal or Pizza under https://Buona-sera.de and we will deliver it to you.<br>',
'Or order by telephone: 04131-37275<br>',
'Or by email: Info@buona-sera.de<br>',
'Take care - stay healthy!<br>',
'Gaetano<br>',
'',
'    <td>',
'<img src = "#APP_IMAGES#Buena_sera.PNG">',
'  </tr>',
'</table><br>',
'.. add other restaurants if needed...',
'',
'',
'',
'',
''))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432216116917890727)
,p_plug_name=>'<font color="lightblue">Restaurants have to rethink...</font>'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428330366786997924)
,p_plug_display_sequence=>5
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
end;
/
prompt --application/pages/page_00012
begin
wwv_flow_api.create_page(
 p_id=>12
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'The Process Flow'
,p_step_title=>'The Process Flow'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200325120821'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432933920193209729)
,p_plug_name=>'The Process Flow'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_grid_column_span=>7
,p_plug_display_point=>'BODY'
,p_plug_source=>'<img src ="#APP_IMAGES#PROZESS_ENGL.PNG" width="800"  />'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
end;
/
prompt --application/pages/page_00013
begin
wwv_flow_api.create_page(
 p_id=>13
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'More Initiatives'
,p_step_title=>'More Initiatives'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_protection_level=>'C'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200325091935'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432207839974848319)
,p_plug_name=>'More Initiatives'
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select ',
'"ID"',
',"NAME"',
',"BESCHREIBUNG"',
',"LINK"',
',sys.dbms_lob.getlength("LOGO")"LOGO"',
'--,''<img src="''||apex_util.get_blob_file_src(''P14_LOGO'',logo)||''" width="250" />'' LOGO2',
'--,''<img src="''||apex_util.get_blob_file_src(''P4_DOCUMENT'',id)||''" />'' ',
'--,''<img src="''||apex_util.get_blob_file_src(''P14_LOGO'',logo)||''" />''  logo',
'',
',"ANZEIGEN"',
', TELEFON',
', WHATSAPP ',
'from "CORONA_HILFSDIENSTE"',
'where ANZEIGEN = ''Ja''',
'--and whatsapp != ''infos'''))
,p_plug_source_type=>'NATIVE_IR'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_worksheet(
 p_id=>wwv_flow_api.id(432208210801848319)
,p_name=>'Report 1'
,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_show_nulls_as=>'-'
,p_pagination_type=>'ROWS_X_TO_Y'
,p_pagination_display_pos=>'BOTTOM_RIGHT'
,p_show_actions_menu=>'N'
,p_report_list_mode=>'TABS'
,p_show_detail_link=>'C'
,p_detail_link=>'f?p=&APP_ID.:14:&SESSION.::&DEBUG.:RP:P14_ID:\#ID#\'
,p_detail_link_text=>'<span aria-label="Edit"><span class="fa fa-edit" aria-hidden="true" title="Edit"></span></span>'
,p_detail_link_auth_scheme=>wwv_flow_api.id(432186096805417042)
,p_owner=>'FISCHER'
,p_internal_uid=>214581947390065101
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432208310916848330)
,p_db_column_name=>'ID'
,p_display_order=>1
,p_column_identifier=>'A'
,p_column_label=>'Id'
,p_column_type=>'NUMBER'
,p_heading_alignment=>'RIGHT'
,p_column_alignment=>'RIGHT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432208738694848398)
,p_db_column_name=>'NAME'
,p_display_order=>2
,p_column_identifier=>'B'
,p_column_label=>'Name'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432209145857848400)
,p_db_column_name=>'BESCHREIBUNG'
,p_display_order=>3
,p_column_identifier=>'C'
,p_column_label=>'Beschreibung'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432209532637848401)
,p_db_column_name=>'LINK'
,p_display_order=>4
,p_column_identifier=>'D'
,p_column_label=>'Link'
,p_column_html_expression=>'<a target="_blank" href =''http://#LINK#''>#LINK#</a>'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432209906041848402)
,p_db_column_name=>'LOGO'
,p_display_order=>5
,p_column_identifier=>'E'
,p_column_label=>'Logo'
,p_allow_sorting=>'N'
,p_allow_filtering=>'N'
,p_allow_highlighting=>'N'
,p_allow_ctrl_breaks=>'N'
,p_allow_aggregations=>'N'
,p_allow_computations=>'N'
,p_allow_charting=>'N'
,p_allow_group_by=>'N'
,p_allow_pivot=>'N'
,p_column_type=>'NUMBER'
,p_heading_alignment=>'LEFT'
,p_format_mask=>'IMAGE:CORONA_HILFSDIENSTE:LOGO:ID::::::::'
,p_rpt_show_filter_lov=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432210285545848402)
,p_db_column_name=>'ANZEIGEN'
,p_display_order=>6
,p_column_identifier=>'F'
,p_column_label=>'Anzeigen'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432215458726890720)
,p_db_column_name=>'TELEFON'
,p_display_order=>16
,p_column_identifier=>'G'
,p_column_label=>'Telefon'
,p_column_type=>'STRING'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432215522490890721)
,p_db_column_name=>'WHATSAPP'
,p_display_order=>26
,p_column_identifier=>'H'
,p_column_label=>'Whatsapp'
,p_column_type=>'STRING'
);
wwv_flow_api.create_worksheet_rpt(
 p_id=>wwv_flow_api.id(432212561166856944)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'2145863'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'LOGO:NAME:BESCHREIBUNG:LINK:TELEFON::WHATSAPP'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432216393870890730)
,p_plug_name=>'<font color="lightblue">More Initiatives</font>'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428330366786997924)
,p_plug_display_sequence=>5
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432211706080848425)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(432207839974848319)
,p_button_name=>'CREATE'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,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.:14:&SESSION.::&DEBUG.:14'
,p_security_scheme=>wwv_flow_api.id(432186096805417042)
);
end;
/
prompt --application/pages/page_00014
begin
wwv_flow_api.create_page(
 p_id=>14
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'More Initiatives Form'
,p_step_title=>'More Initiatives Form'
,p_autocomplete_on_off=>'OFF'
,p_javascript_code=>'var htmldb_delete_message=''"DELETE_CONFIRM_MSG"'';'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200325114408'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432200112604848173)
,p_plug_name=>'Initiativen Formular'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_plug_grid_column_span=>5
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'CORONA_HILFSDIENSTE'
,p_include_rowid_column=>false
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_plug_source_type=>'NATIVE_FORM'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432205732260848297)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(432200112604848173)
,p_button_name=>'SAVE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Apply Changes'
,p_button_position=>'REGION_TEMPLATE_CHANGE'
,p_button_condition=>'P14_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'UPDATE'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432204488688848264)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(432200112604848173)
,p_button_name=>'CANCEL'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'Cancel'
,p_button_position=>'REGION_TEMPLATE_CLOSE'
,p_button_redirect_url=>'f?p=&APP_ID.:13:&SESSION.::&DEBUG.:::'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432206099493848298)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_api.id(432200112604848173)
,p_button_name=>'CREATE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Create'
,p_button_position=>'REGION_TEMPLATE_CREATE'
,p_button_condition=>'P14_ID'
,p_button_condition_type=>'ITEM_IS_NULL'
,p_database_action=>'INSERT'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432205321580848293)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(432200112604848173)
,p_button_name=>'DELETE'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'Delete'
,p_button_position=>'REGION_TEMPLATE_DELETE'
,p_button_redirect_url=>'javascript:apex.confirm(htmldb_delete_message,''DELETE'');'
,p_button_execute_validations=>'N'
,p_button_condition=>'P14_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'DELETE'
);
wwv_flow_api.create_page_branch(
 p_id=>wwv_flow_api.id(432206364985848298)
,p_branch_action=>'f?p=&APP_ID.:13:&SESSION.::&DEBUG.&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'AFTER_PROCESSING'
,p_branch_type=>'REDIRECT_URL'
,p_branch_sequence=>1
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432200414267848184)
,p_name=>'P14_ID'
,p_source_data_type=>'NUMBER'
,p_is_primary_key=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(432200112604848173)
,p_item_source_plug_id=>wwv_flow_api.id(432200112604848173)
,p_source=>'ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432200827944848228)
,p_name=>'P14_NAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(432200112604848173)
,p_item_source_plug_id=>wwv_flow_api.id(432200112604848173)
,p_prompt=>'Name'
,p_source=>'NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432201162727848239)
,p_name=>'P14_BESCHREIBUNG'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(432200112604848173)
,p_item_source_plug_id=>wwv_flow_api.id(432200112604848173)
,p_prompt=>'Description'
,p_source=>'BESCHREIBUNG'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXTAREA'
,p_cSize=>60
,p_cMaxlength=>100
,p_cHeight=>4
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432201472919848242)
,p_name=>'P14_LINK'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>60
,p_item_plug_id=>wwv_flow_api.id(432200112604848173)
,p_item_source_plug_id=>wwv_flow_api.id(432200112604848173)
,p_prompt=>'Link (without https://)'
,p_placeholder=>'bfw-design.de'
,p_source=>'LINK'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>60
,p_cMaxlength=>500
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432201956392848254)
,p_name=>'P14_LOGO'
,p_source_data_type=>'BLOB'
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_api.id(432200112604848173)
,p_item_source_plug_id=>wwv_flow_api.id(432200112604848173)
,p_prompt=>'Logo'
,p_source=>'LOGO'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>60
,p_cMaxlength=>255
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_06=>'Y'
,p_attribute_08=>'attachment'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432202349745848254)
,p_name=>'P14_ANZEIGEN'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>80
,p_item_plug_id=>wwv_flow_api.id(432200112604848173)
,p_item_source_plug_id=>wwv_flow_api.id(432200112604848173)
,p_item_default=>'Ja'
,p_prompt=>'Show'
,p_source=>'ANZEIGEN'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_RADIOGROUP'
,p_lov=>'STATIC:Yes;Ja,No;Nein'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'2'
,p_attribute_02=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432215329928890719)
,p_name=>'P14_TELEFON'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_api.id(432200112604848173)
,p_item_source_plug_id=>wwv_flow_api.id(432200112604848173)
,p_prompt=>'Telephone'
,p_source=>'TELEFON'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>20
,p_cMaxlength=>20
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432215623265890722)
,p_name=>'P14_WHATSAPP'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_api.id(432200112604848173)
,p_item_source_plug_id=>wwv_flow_api.id(432200112604848173)
,p_prompt=>'Whatsapp'
,p_source=>'WHATSAPP'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>20
,p_cMaxlength=>20
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(432207273784848313)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(432200112604848173)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>'Process form Hilfsdienste Formular'
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(432206896942848307)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(432200112604848173)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>'Initialize form Hilfsdienste Formular'
);
end;
/
prompt --application/pages/page_00015
begin
wwv_flow_api.create_page(
 p_id=>15
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'People who need help'
,p_step_title=>'People who need help'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_required_role=>wwv_flow_api.id(432186096805417042)
,p_protection_level=>'C'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200324131544'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432738220867350789)
,p_plug_name=>'People who need help'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select cl.ID,',
'       cl.COR_HELPER_FK,',
'       cl.ANREDE,',
'       cl.VORNAME,',
'       cl.NAME,',
'       cl.STRASSE,',
'       cl.PLZ,',
'       cl.ORT,',
'       cl.TELEFON,',
'       cl.EMAIL,',
'       cl.ERSTELLT_AM,',
'       cl.BEMERKUNGEN,',
'       cl.INFIZIER_JA_NEIN as infiziert,',
'       H.Name as Helfer,',
'       H.ORT as Ort_helfer,',
'       H.TELEFON as Helfer_telefon,',
'       H.ANGEBOT',
'  from CORONA_LEUTE CL , CORONA_HELP H',
'  where COR_HELPER_FK = H.ID'))
,p_plug_source_type=>'NATIVE_IR'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_worksheet(
 p_id=>wwv_flow_api.id(432738644152350789)
,p_name=>'Report 1'
,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_show_nulls_as=>'-'
,p_pagination_type=>'ROWS_X_TO_Y'
,p_pagination_display_pos=>'BOTTOM_RIGHT'
,p_report_list_mode=>'TABS'
,p_show_detail_link=>'N'
,p_download_formats=>'CSV:HTML:EMAIL:XLS:PDF:RTF'
,p_owner=>'FISCHER'
,p_internal_uid=>215112380740567571
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432738664856350799)
,p_db_column_name=>'ID'
,p_display_order=>1
,p_column_identifier=>'A'
,p_column_label=>'Id'
,p_column_type=>'NUMBER'
,p_heading_alignment=>'RIGHT'
,p_column_alignment=>'RIGHT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432739080448350809)
,p_db_column_name=>'COR_HELPER_FK'
,p_display_order=>2
,p_column_identifier=>'B'
,p_column_label=>'Cor Helper Fk'
,p_column_type=>'NUMBER'
,p_heading_alignment=>'RIGHT'
,p_column_alignment=>'RIGHT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432739543595350810)
,p_db_column_name=>'ANREDE'
,p_display_order=>3
,p_column_identifier=>'C'
,p_column_label=>'Sal.'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432739932495350811)
,p_db_column_name=>'VORNAME'
,p_display_order=>4
,p_column_identifier=>'D'
,p_column_label=>'Prename'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432740342951350812)
,p_db_column_name=>'NAME'
,p_display_order=>5
,p_column_identifier=>'E'
,p_column_label=>'Name'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432740742618350813)
,p_db_column_name=>'STRASSE'
,p_display_order=>6
,p_column_identifier=>'F'
,p_column_label=>'Street'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432741064306350813)
,p_db_column_name=>'PLZ'
,p_display_order=>7
,p_column_identifier=>'G'
,p_column_label=>'ZIP'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432741538445350814)
,p_db_column_name=>'ORT'
,p_display_order=>8
,p_column_identifier=>'H'
,p_column_label=>'City/Town'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432741874058350814)
,p_db_column_name=>'TELEFON'
,p_display_order=>9
,p_column_identifier=>'I'
,p_column_label=>'Telephone'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432742274592350814)
,p_db_column_name=>'EMAIL'
,p_display_order=>10
,p_column_identifier=>'J'
,p_column_label=>'Email'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432742708140350815)
,p_db_column_name=>'ERSTELLT_AM'
,p_display_order=>11
,p_column_identifier=>'K'
,p_column_label=>'created'
,p_column_type=>'DATE'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432743124003350815)
,p_db_column_name=>'BEMERKUNGEN'
,p_display_order=>12
,p_column_identifier=>'L'
,p_column_label=>'Remarks'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432219400667890760)
,p_db_column_name=>'INFIZIERT'
,p_display_order=>22
,p_column_identifier=>'O'
,p_column_label=>'Infected'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432219533038890761)
,p_db_column_name=>'HELFER'
,p_display_order=>32
,p_column_identifier=>'P'
,p_column_label=>'Helper'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432219620705890762)
,p_db_column_name=>'ORT_HELFER'
,p_display_order=>42
,p_column_identifier=>'Q'
,p_column_label=>'Helper location'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432219755274890763)
,p_db_column_name=>'HELFER_TELEFON'
,p_display_order=>52
,p_column_identifier=>'R'
,p_column_label=>'Helper tel.'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(432219836736890764)
,p_db_column_name=>'ANGEBOT'
,p_display_order=>62
,p_column_identifier=>'S'
,p_column_label=>'Engagement'
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_rpt(
 p_id=>wwv_flow_api.id(432746058375354756)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'2151198'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'ANREDE:VORNAME:NAME:STRASSE:PLZ:ORT:TELEFON:EMAIL:ERSTELLT_AM:BEMERKUNGEN:INFIZIERT:HELFER:ORT_HELFER:HELFER_TELEFON:ANGEBOT:'
);
end;
/
prompt --application/pages/page_00016
begin
wwv_flow_api.create_page(
 p_id=>16
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Helpseeker - Form'
,p_step_title=>'Helpseeker - Form'
,p_autocomplete_on_off=>'OFF'
,p_javascript_code=>'var htmldb_delete_message=''"DELETE_CONFIRM_MSG"'';'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200324160417'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432724847419350687)
,p_plug_name=>'Helpseeker - Form'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_plug_grid_column_span=>5
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'CORONA_LEUTE'
,p_include_rowid_column=>false
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_plug_source_type=>'NATIVE_FORM'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432736033301350771)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(432724847419350687)
,p_button_name=>'SAVE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Apply Changes'
,p_button_position=>'REGION_TEMPLATE_CHANGE'
,p_button_condition=>'P16_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'UPDATE'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432734913558350759)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(432724847419350687)
,p_button_name=>'CANCEL'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'Cancel'
,p_button_position=>'REGION_TEMPLATE_CLOSE'
,p_button_redirect_url=>'f?p=&APP_ID.:15:&SESSION.::&DEBUG.:::'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432736413199350771)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_api.id(432724847419350687)
,p_button_name=>'CREATE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Create'
,p_button_position=>'REGION_TEMPLATE_CREATE'
,p_button_condition=>'P16_ID'
,p_button_condition_type=>'ITEM_IS_NULL'
,p_database_action=>'INSERT'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432735612077350770)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(432724847419350687)
,p_button_name=>'DELETE'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'Delete'
,p_button_position=>'REGION_TEMPLATE_DELETE'
,p_button_redirect_url=>'javascript:apex.confirm(htmldb_delete_message,''DELETE'');'
,p_button_execute_validations=>'N'
,p_button_condition=>'P16_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'DELETE'
);
wwv_flow_api.create_page_branch(
 p_id=>wwv_flow_api.id(432736713873350771)
,p_branch_action=>'f?p=&APP_ID.:15:&SESSION.::&DEBUG.&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'AFTER_PROCESSING'
,p_branch_type=>'REDIRECT_URL'
,p_branch_sequence=>1
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432216527428890731)
,p_name=>'P16_EMAIL_1'
,p_item_sequence=>110
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Email'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432725078426350692)
,p_name=>'P16_ID'
,p_source_data_type=>'NUMBER'
,p_is_primary_key=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_source=>'ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432725542105350733)
,p_name=>'P16_COR_HELPER_FK'
,p_source_data_type=>'NUMBER'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_source=>'COR_HELPER_FK'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432725902231350745)
,p_name=>'P16_ANREDE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Anrede'
,p_source=>'ANREDE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_RADIOGROUP'
,p_lov=>'STATIC2:Frau;Frau,Herr;Herr'
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'2'
,p_attribute_02=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432726270120350745)
,p_name=>'P16_VORNAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Vorname'
,p_source=>'VORNAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>15
,p_cMaxlength=>20
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432726704906350746)
,p_name=>'P16_NAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Name'
,p_source=>'NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>20
,p_cMaxlength=>20
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432727106348350748)
,p_name=>'P16_STRASSE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>60
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Strasse'
,p_source=>'STRASSE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432727531176350748)
,p_name=>'P16_PLZ'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Plz'
,p_source=>'PLZ'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>6
,p_cMaxlength=>10
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432727940565350749)
,p_name=>'P16_ORT'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>80
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Ort'
,p_source=>'ORT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>50
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432728276352350749)
,p_name=>'P16_TELEFON'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>90
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Telefon'
,p_source=>'TELEFON'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>20
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432728710952350750)
,p_name=>'P16_EMAIL'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>100
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Email'
,p_source=>'EMAIL'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432729146808350750)
,p_name=>'P16_ERSTELLT_AM'
,p_source_data_type=>'DATE'
,p_item_sequence=>120
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Erstellt Am'
,p_source=>'ERSTELLT_AM'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DATE_PICKER'
,p_cSize=>32
,p_cMaxlength=>255
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_04=>'button'
,p_attribute_05=>'N'
,p_attribute_07=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432729553831350750)
,p_name=>'P16_BEMERKUNGEN'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>130
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Bemerkungen'
,p_source=>'BEMERKUNGEN'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXTAREA'
,p_cSize=>60
,p_cMaxlength=>200
,p_cHeight=>4
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432729956713350750)
,p_name=>'P16_INFIZIER_JA_NEIN'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>140
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Infiziert'
,p_source=>'INFIZIER_JA_NEIN'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_RADIOGROUP'
,p_lov=>'STATIC:Ja;Ja,Nein;Nein'
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'2'
,p_attribute_02=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432730342268350751)
,p_name=>'P16_DATENSCHUTZ'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>150
,p_item_plug_id=>wwv_flow_api.id(432724847419350687)
,p_item_source_plug_id=>wwv_flow_api.id(432724847419350687)
,p_prompt=>'Datenschutz - ich bin einverstanden mit der Speicherung'
,p_source=>'DATENSCHUTZ'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DISPLAY_ONLY'
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
,p_attribute_02=>'VALUE'
,p_attribute_04=>'Y'
);
wwv_flow_api.create_page_validation(
 p_id=>wwv_flow_api.id(432216838322890734)
,p_validation_name=>'Check_email_format'
,p_validation_sequence=>5
,p_validation=>'regexp_like (:P16_EMAIL, ''^[A-Za-z]+[A-Za-z0-9.]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$'')'
,p_validation_type=>'PLSQL_EXPRESSION'
,p_error_message=>unistr('dies ist kein Email Format ! bitte pr\00FCfen !!!')
,p_always_execute=>'Y'
,p_associated_item=>wwv_flow_api.id(432728710952350750)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_api.create_page_validation(
 p_id=>wwv_flow_api.id(432216614963890732)
,p_validation_name=>'check_email'
,p_validation_sequence=>10
,p_validation=>'P16_EMAIL'
,p_validation2=>'&P16_EMAIL_1.'
,p_validation_type=>'ITEM_IN_VALIDATION_EQ_STRING2'
,p_error_message=>unistr('verschrieben ? bitte pr\00FCfen ! ')
,p_associated_item=>wwv_flow_api.id(432728710952350750)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(432737595868350783)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(432724847419350687)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>'Process form Hilfesuchende - Formular'
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(432216686921890733)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_SEND_EMAIL'
,p_process_name=>'Mail_bestaetigung'
,p_attribute_01=>'info@bfw-design.de'
,p_attribute_02=>'&P16_EMAIL.'
,p_attribute_06=>unistr('Corna-Hilfe - Antrag Best\00E4tigung')
,p_attribute_07=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Hallo &P16_ANREDE. &P16_NAME.,',
'wir haben Ihren Antrag erhalten und leiten ihn per Email an den anbieter weiter.',
'Etwas Geduld !',
unistr('Herzliche Gr\00FC\00DFe'),
'Ihre Corana-Hilfe'))
,p_attribute_10=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(432737260444350779)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(432724847419350687)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>'Initialize form Hilfesuchende - Formular'
);
end;
/
prompt --application/pages/page_00017
begin
wwv_flow_api.create_page(
 p_id=>17
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Engagement Form'
,p_step_title=>'Engagement Form'
,p_autocomplete_on_off=>'OFF'
,p_javascript_code=>'var htmldb_delete_message=''"DELETE_CONFIRM_MSG"'';'
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_protection_level=>'C'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200327162215'
);
wwv_flow_api.create_report_region(
 p_id=>wwv_flow_api.id(432217798877890744)
,p_name=>'Requested support/help'
,p_template=>wwv_flow_api.id(428357602299997961)
,p_display_sequence=>20
,p_include_in_reg_disp_sel_yn=>'Y'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_component_template_options=>'#DEFAULT#:t-Report--altRowsDefault:t-Report--rowHighlight'
,p_new_grid_row=>false
,p_display_point=>'BODY'
,p_source_type=>'NATIVE_SQL_REPORT'
,p_query_type=>'TABLE'
,p_query_table=>'CORONA_LEUTE'
,p_query_where=>'COR_HELPER_FK = :P17_ID'
,p_include_rowid_column=>false
,p_display_when_condition=>'P17_ID'
,p_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_ajax_enabled=>'Y'
,p_query_row_template=>wwv_flow_api.id(428380348961998008)
,p_query_num_rows=>15
,p_query_options=>'DERIVED_REPORT_COLUMNS'
,p_query_show_nulls_as=>'-'
,p_csv_output=>'N'
,p_prn_output=>'N'
,p_sort_null=>'L'
,p_plug_query_strip_html=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432217961721890745)
,p_query_column_id=>1
,p_column_alias=>'ID'
,p_column_display_sequence=>1
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432217988125890746)
,p_query_column_id=>2
,p_column_alias=>'COR_HELPER_FK'
,p_column_display_sequence=>2
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432218104324890747)
,p_query_column_id=>3
,p_column_alias=>'ANREDE'
,p_column_display_sequence=>3
,p_column_heading=>'Sal.'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432218183509890748)
,p_query_column_id=>4
,p_column_alias=>'VORNAME'
,p_column_display_sequence=>4
,p_column_heading=>'Prename'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432218360074890749)
,p_query_column_id=>5
,p_column_alias=>'NAME'
,p_column_display_sequence=>5
,p_column_heading=>'Name'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432218412873890750)
,p_query_column_id=>6
,p_column_alias=>'STRASSE'
,p_column_display_sequence=>6
,p_column_heading=>'Street'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432218557546890751)
,p_query_column_id=>7
,p_column_alias=>'PLZ'
,p_column_display_sequence=>7
,p_column_heading=>'Zip'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432218566997890752)
,p_query_column_id=>8
,p_column_alias=>'ORT'
,p_column_display_sequence=>8
,p_column_heading=>'City/Town'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432218709972890753)
,p_query_column_id=>9
,p_column_alias=>'TELEFON'
,p_column_display_sequence=>9
,p_column_heading=>'Telephone'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432218801444890754)
,p_query_column_id=>10
,p_column_alias=>'EMAIL'
,p_column_display_sequence=>10
,p_column_heading=>'Email'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432218904819890755)
,p_query_column_id=>11
,p_column_alias=>'ERSTELLT_AM'
,p_column_display_sequence=>13
,p_column_heading=>'created'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432218965152890756)
,p_query_column_id=>12
,p_column_alias=>'BEMERKUNGEN'
,p_column_display_sequence=>11
,p_column_heading=>'Remarks'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432219144716890757)
,p_query_column_id=>13
,p_column_alias=>'INFIZIER_JA_NEIN'
,p_column_display_sequence=>12
,p_column_heading=>'Infected'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(432219255268890758)
,p_query_column_id=>14
,p_column_alias=>'DATENSCHUTZ'
,p_column_display_sequence=>14
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432817910253277002)
,p_plug_name=>'Engagement Form - Profile'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_plug_grid_column_span=>6
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'CORONA_HELP'
,p_include_rowid_column=>false
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_plug_source_type=>'NATIVE_FORM'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432831955976277145)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(432817910253277002)
,p_button_name=>'SAVE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Apply changes'
,p_button_position=>'REGION_TEMPLATE_CHANGE'
,p_button_condition=>'P17_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'UPDATE'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432830687207277119)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(432817910253277002)
,p_button_name=>'CANCEL'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'cancel'
,p_button_position=>'REGION_TEMPLATE_CLOSE'
,p_button_redirect_url=>'f?p=&APP_ID.:4:&SESSION.::&DEBUG.:::'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432832310405277146)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_api.id(432817910253277002)
,p_button_name=>'CREATE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'create'
,p_button_position=>'REGION_TEMPLATE_CREATE'
,p_button_condition=>'P17_ID'
,p_button_condition_type=>'ITEM_IS_NULL'
,p_database_action=>'INSERT'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(432831470980277144)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(432817910253277002)
,p_button_name=>'DELETE'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'delete'
,p_button_position=>'REGION_TEMPLATE_DELETE'
,p_button_redirect_url=>'javascript:apex.confirm(htmldb_delete_message,''DELETE'');'
,p_button_execute_validations=>'N'
,p_button_condition=>'P17_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'DELETE'
);
wwv_flow_api.create_page_branch(
 p_id=>wwv_flow_api.id(432832595389277150)
,p_branch_action=>'f?p=&APP_ID.:5:&SESSION.::&DEBUG.&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'AFTER_PROCESSING'
,p_branch_type=>'REDIRECT_URL'
,p_branch_sequence=>1
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(221500669991739038)
,p_name=>'P17_MASKS_AVAILABLE'
,p_source_data_type=>'NUMBER'
,p_item_sequence=>120
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Masks available'
,p_post_element_text=>'&nbsp;&nbsp;(shown in List)'
,p_source=>'MASKS_AVAILABLE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_NUMBER_FIELD'
,p_cSize=>3
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_03=>'right'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432217032091890736)
,p_name=>'P17_EMAIL_1'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>160
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'repeat Email'
,p_post_element_text=>'&nbsp;&nbsp;(often misspelled)'
,p_source=>'EMAIL_CHECK'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432217394605890740)
,p_name=>'P17_PREV_PAGE'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_use_cache_before_default=>'NO'
,p_source=>'P17_PREV_PAGE'
,p_source_type=>'ITEM'
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432818252797277014)
,p_name=>'P17_ID'
,p_source_data_type=>'NUMBER'
,p_is_primary_key=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_source=>'ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432818621524277064)
,p_name=>'P17_ANREDE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_default=>'Frau'
,p_prompt=>'Salutation'
,p_source=>'ANREDE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_RADIOGROUP'
,p_lov=>'STATIC2:Mrs;Mrs,Mr.;Mr.'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'2'
,p_attribute_02=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432818949513277081)
,p_name=>'P17_VORNAME'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Prename'
,p_source=>'VORNAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>10
,p_cMaxlength=>20
,p_begin_on_new_line=>'N'
,p_grid_column=>3
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432819334400277082)
,p_name=>'P17_NAME'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Name'
,p_source=>'NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>20
,p_cMaxlength=>50
,p_begin_on_new_line=>'N'
,p_grid_column=>5
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432819695185277083)
,p_name=>'P17_STRASSE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Street'
,p_source=>'STRASSE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432820119590277083)
,p_name=>'P17_PLZ'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Zip-code'
,p_source=>'PLZ'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>6
,p_cMaxlength=>10
,p_begin_on_new_line=>'N'
,p_grid_column=>5
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432820517230277084)
,p_name=>'P17_ORT'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>80
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'City/Town'
,p_source=>'ORT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>20
,p_cMaxlength=>50
,p_begin_on_new_line=>'N'
,p_grid_column=>7
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432820867426277084)
,p_name=>'P17_STADTTEIL'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>90
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'District'
,p_source=>'STADTTEIL'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>20
,p_cMaxlength=>50
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432821283582277084)
,p_name=>'P17_ANGEBOT'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>110
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'My engagement'
,p_post_element_text=>'&nbsp;&nbsp;(shown in List)'
,p_source=>'ANGEBOT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432821682450277086)
,p_name=>'P17_KATEGORIE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>100
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'category'
,p_source=>'KATEGORIE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_CHECKBOX'
,p_named_lov=>'LOV_CATEGORIES'
,p_lov=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select name d, name r',
'from COR_CATEGORIES',
'order by 1'))
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'8'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432822095522277086)
,p_name=>'P17_SONSTIGES'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>130
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Misc.'
,p_source=>'SONSTIGES'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432822528277277086)
,p_name=>'P17_EMAIL'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>140
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Email'
,p_post_element_text=>'&nbsp;&nbsp;(= Username)'
,p_source=>'EMAIL'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_cMaxlength=>50
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_help_text=>unistr('Mit Ihrer Email und dem Passwort k\00F6nnen sie sich sp\00E4ter wieder hier einloggen und die Hilfsanfragen einsehen')
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432822891793277088)
,p_name=>'P17_PASSWORT'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>150
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Password'
,p_post_element_text=>'&nbsp;&nbsp;(for Login to profile - pls remember!)'
,p_source=>'PASSWORT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>12
,p_cMaxlength=>20
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_help_text=>unistr('Mit Ihrer Email und dem Passwort k\00F6nnen sie sich sp\00E4ter wieder hier einloggen und die Hilfsanfragen einsehen')
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432823309003277088)
,p_name=>'P17_TELEFON'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>170
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Telephone'
,p_source=>'TELEFON'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>15
,p_cMaxlength=>20
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432823685905277096)
,p_name=>'P17_ERFASST_AM'
,p_source_data_type=>'DATE'
,p_item_sequence=>180
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_default=>'SYSDATE'
,p_item_default_type=>'PLSQL_EXPRESSION'
,p_source=>'ERFASST_AM'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432824127351277097)
,p_name=>'P17_ANGEBOT_GUELTIG_BIS'
,p_source_data_type=>'DATE'
,p_is_required=>true
,p_item_sequence=>210
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_default=>'SYSDATE+30'
,p_item_default_type=>'PLSQL_EXPRESSION'
,p_prompt=>'Offer valid unitl'
,p_source=>'ANGEBOT_GUELTIG_BIS'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DATE_PICKER'
,p_cSize=>10
,p_cMaxlength=>255
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_04=>'button'
,p_attribute_05=>'N'
,p_attribute_07=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432824477719277098)
,p_name=>'P17_BEMERKUNGEN'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>190
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Remarks'
,p_source=>'BEMERKUNGEN'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>60
,p_field_template=>wwv_flow_api.id(428417069117998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(432824941109277098)
,p_name=>'P17_DATENSCHUTZ'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>200
,p_item_plug_id=>wwv_flow_api.id(432817910253277002)
,p_item_source_plug_id=>wwv_flow_api.id(432817910253277002)
,p_prompt=>'Data-Security: I agree to store my data for this project - for more info see "About Page"'
,p_source=>'DATENSCHUTZ'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_CHECKBOX'
,p_lov=>'STATIC:Yes;Yes'
,p_field_template=>wwv_flow_api.id(428417380742998108)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'1'
);
wwv_flow_api.create_page_validation(
 p_id=>wwv_flow_api.id(432217190499890738)
,p_validation_name=>'Check_email_format'
,p_validation_sequence=>5
,p_validation=>'regexp_like (:P17_EMAIL, ''^[A-Za-z]+[A-Za-z0-9.]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$'')'
,p_validation_type=>'PLSQL_EXPRESSION'
,p_error_message=>'not a valid Email Format - please check'
,p_associated_item=>wwv_flow_api.id(432822528277277086)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_api.create_page_validation(
 p_id=>wwv_flow_api.id(432217105335890737)
,p_validation_name=>'Email_check'
,p_validation_sequence=>10
,p_validation=>'P17_EMAIL'
,p_validation2=>'&P17_EMAIL_1.'
,p_validation_type=>'ITEM_IN_VALIDATION_EQ_STRING2'
,p_error_message=>'misprint ?'
,p_associated_item=>wwv_flow_api.id(432822528277277086)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_api.create_page_validation(
 p_id=>wwv_flow_api.id(221500926243739041)
,p_validation_name=>'validate_masks_available'
,p_validation_sequence=>20
,p_validation=>'P17_MASKS_AVAILABLE'
,p_validation_type=>'ITEM_NOT_NULL'
,p_error_message=>'category "masks" selected.. then please fill in here'
,p_always_execute=>'Y'
,p_validation_condition=>'P17_KATEGORIE'
,p_validation_condition2=>'Masks'
,p_validation_condition_type=>'VALUE_OF_ITEM_IN_CONDITION_IN_COLON_DELIMITED_LIST'
,p_associated_item=>wwv_flow_api.id(221500669991739038)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(221501208346739044)
,p_name=>'show_no_of_masks_available'
,p_event_sequence=>10
,p_triggering_element_type=>'ITEM'
,p_triggering_element=>'P17_KATEGORIE'
,p_condition_element=>'P17_KATEGORIE'
,p_triggering_condition_type=>'IN_LIST'
,p_triggering_expression=>'Masks'
,p_bind_type=>'bind'
,p_bind_event_type=>'change'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(221501324245739045)
,p_event_id=>wwv_flow_api.id(221501208346739044)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'Y'
,p_action=>'NATIVE_SHOW'
,p_affected_elements_type=>'ITEM'
,p_affected_elements=>'P17_MASKS_AVAILABLE'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(221501483028739046)
,p_name=>'hide_masks_available'
,p_event_sequence=>20
,p_bind_type=>'bind'
,p_bind_event_type=>'ready'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(221501590082739047)
,p_event_id=>wwv_flow_api.id(221501483028739046)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'Y'
,p_action=>'NATIVE_HIDE'
,p_affected_elements_type=>'ITEM'
,p_affected_elements=>'P17_MASKS_AVAILABLE'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(222631605055831508)
,p_name=>'show_when_value'
,p_event_sequence=>30
,p_bind_type=>'bind'
,p_bind_event_type=>'ready'
,p_display_when_type=>'EXISTS'
,p_display_when_cond=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select 1 from CORONA_HELP where MASKS_AVAILABLE > 0',
'and ID = :P17_ID',
'and KATEGORIE like ''%''||''Masks''||''%'''))
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(222631728721831509)
,p_event_id=>wwv_flow_api.id(222631605055831508)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'Y'
,p_action=>'NATIVE_SHOW'
,p_affected_elements_type=>'ITEM'
,p_affected_elements=>'P17_MASKS_AVAILABLE'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(432833392406277169)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(432817910253277002)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>'Process form Angebot Formular'
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_process_error_message=>'nothing processed'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_success_message=>'Data processed<br>'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(432217343592890739)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_SEND_EMAIL'
,p_process_name=>'Mail_confirmation'
,p_attribute_01=>'info@bfw-design.de'
,p_attribute_02=>'&P17_EMAIL.'
,p_attribute_06=>'Corona-Help - your engagement has been received'
,p_attribute_07=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Hallo &P17_VORNAME. &P17_NAME.,',
'',
'',
'',
'thank you very much for signing for our Corona-Help Portal!',
'',
'',
'Those who deserve it, will very much appreciate that !',
'',
'',
'Your data will only serve the project and will not be onpassed to third parties (*). ',
'',
'',
'After the crisis is over your datas will be deleted (*).',
'',
'',
'(*) The data handling is under responsibilty of the person stipulated in the imprint.',
'',
'',
'Take care and stay healthy !',
'',
'',
'With warm regards',
'',
'The Corona-Help-team'))
,p_attribute_08=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Hallo &P17_VORNAME. &P17_NAME., <br>',
'',
'',
'thank you very much for signing in our Corona-Help Portal!)<br><br>',
'',
'Those who deserve it, will very much appreciate that !<br><br>',
'',
'Your data will only serve the project and will not be onpassed to third parties (*). <br><br>',
'',
'After the crisis is over your data will be deleted (*).<br><br>',
'',
'(*) The data handling is under responsibilty of the person stipulated in the imprint.<br><br>',
'',
'Take care and stay healthy !<br><br>',
'',
'With warm regards<br>',
'The Corona-Help-team'))
,p_attribute_10=>'Y'
,p_process_error_message=>'no mail sent'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_api.id(432832310405277146)
,p_process_success_message=>'Mail confirmation has been sent to you'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(215308080981426515)
,p_process_sequence=>30
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Corona_help_seekers_delete'
,p_process_sql_clob=>'delete from CORONA_LEUTE where COR_HELPER_FK = :P17_ID;'
,p_process_error_message=>'nothing deleted'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_api.id(432831470980277144)
,p_process_success_message=>'connected Help-Seeker data deleted as well'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(432833094622277164)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(432817910253277002)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>'Initialize form Angebot Formular'
);
end;
/
prompt --application/pages/page_00018
begin
wwv_flow_api.create_page(
 p_id=>18
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'News'
,p_step_title=>'News'
,p_reload_on_submit=>'A'
,p_autocomplete_on_off=>'OFF'
,p_inline_css=>wwv_flow_string.join(wwv_flow_t_varchar2(
'iframe:focus {',
'  outline: none;',
'}',
'',
'iframe[seamless] {',
'  display: block;',
'}'))
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200325114940'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(215308270033426517)
,p_plug_name=>'News2'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>70
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source_type=>'NATIVE_URL'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_plug_display_condition_type=>'NEVER'
,p_attribute_01=>'https://landeszeitung.de'
,p_attribute_02=>'IFRAME'
,p_attribute_03=>'width="900" height="900"'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432933462641209724)
,p_plug_name=>'News'
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>8
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source=>'<iframe style="width:160vh;border:none;height:300vh" src=" https://www.who.int/"></iframe>'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(432933747274209727)
,p_plug_name=>'<font color="lightblue">News</font>'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428330366786997924)
,p_plug_display_sequence=>5
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
end;
/
prompt --application/pages/page_00024
begin
wwv_flow_api.create_page(
 p_id=>24
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Setup instructions'
,p_step_title=>'Setup instructions'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_required_role=>wwv_flow_api.id(432186096805417042)
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200325115558'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(215308158211426516)
,p_plug_name=>'Setup hints'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'<b>Hi,<br><br>',
'I assume you are familiar with APEX.<br><br>',
'',
'Following adjustments have to be checked or carried out:<br><br>',
'',
'A) Imprint page Page 20 - add your name/organisation<br><br>',
'',
'B) Check page 4 - which is the "Homepage" for the content - adjust accordingly with your localising needs like another language.<br><br>',
'',
'C) Check Administration --> Categories and adjust.<br><br>',
'',
'D) Access your profile and adjust the password.<br><br>',
'',
'E) (optional) News: Suggest to adjust the link in the iframe region or unable the page (condition = never). Please be aware, that the link starts with "https" otherwise it will not work.<br><br>',
'',
'F) (optional) - Mails - on P.8 there is a Mail_process "Mail_to_service_provider" ... to request the "service-provider" to access the "Corona-Help-Portal" and his profile and look for news regarding somebody, who calls for help. It would be comfortab'
||'le for the user, if you can add the link of the application.<br><br>',
'',
'If you have questions, just drop me an email: <a href = "mailto:Bernhard@Fischer-Wasels.de">Bernhard@Fischer-Wasels.de</a><br><br>',
'',
'Good luck!<br>',
'Bernhard<br>',
'',
'<br>',
'',
'</b>'))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
end;
/
prompt --application/pages/page_00030
begin
wwv_flow_api.create_page(
 p_id=>30
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Categories Report'
,p_step_title=>'Categories Report'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200324180346'
);
wwv_flow_api.create_report_region(
 p_id=>wwv_flow_api.id(217826103300661792)
,p_name=>'Categories'
,p_template=>wwv_flow_api.id(428357602299997961)
,p_display_sequence=>10
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_component_template_options=>'#DEFAULT#'
,p_grid_column_span=>3
,p_display_point=>'BODY'
,p_source_type=>'NATIVE_SQL_REPORT'
,p_query_type=>'TABLE'
,p_query_table=>'COR_CATEGORIES'
,p_include_rowid_column=>false
,p_ajax_enabled=>'Y'
,p_query_row_template=>wwv_flow_api.id(428380348961998008)
,p_query_num_rows=>15
,p_query_options=>'DERIVED_REPORT_COLUMNS'
,p_query_show_nulls_as=>'-'
,p_csv_output=>'N'
,p_prn_output=>'N'
,p_sort_null=>'L'
,p_plug_query_strip_html=>'N'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(217826539644661796)
,p_query_column_id=>1
,p_column_alias=>'CAT_ID'
,p_column_display_sequence=>1
,p_column_link=>'f?p=&APP_ID.:31:&SESSION.::&DEBUG.:RP:P31_CAT_ID:\#CAT_ID#\'
,p_column_linktext=>'<span aria-label="Edit"><span class="fa fa-edit" aria-hidden="true" title="Edit"></span></span>'
,p_column_alignment=>'RIGHT'
,p_heading_alignment=>'RIGHT'
,p_disable_sort_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_report_columns(
 p_id=>wwv_flow_api.id(217826919708661797)
,p_query_column_id=>2
,p_column_alias=>'NAME'
,p_column_display_sequence=>2
,p_column_heading=>'Name'
,p_heading_alignment=>'LEFT'
,p_disable_sort_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(217828167415661835)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(217826103300661792)
,p_button_name=>'CREATE'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Create'
,p_button_position=>'REGION_TEMPLATE_EDIT'
,p_button_redirect_url=>'f?p=&APP_ID.:31:&SESSION.::&DEBUG.:31'
);
end;
/
prompt --application/pages/page_00031
begin
wwv_flow_api.create_page(
 p_id=>31
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Categories Form'
,p_step_title=>'Categories Form'
,p_autocomplete_on_off=>'OFF'
,p_javascript_code=>'var htmldb_delete_message=''"DELETE_CONFIRM_MSG"'';'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200324180407'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(217821106815661703)
,p_plug_name=>'Categories Form'
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(428357602299997961)
,p_plug_display_sequence=>10
,p_plug_grid_column_span=>3
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'COR_CATEGORIES'
,p_include_rowid_column=>false
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_plug_source_type=>'NATIVE_FORM'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(217823997072661775)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(217821106815661703)
,p_button_name=>'SAVE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Apply Changes'
,p_button_position=>'REGION_TEMPLATE_CHANGE'
,p_button_condition=>'P31_CAT_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'UPDATE'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(217822721825661762)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(217821106815661703)
,p_button_name=>'CANCEL'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'Cancel'
,p_button_position=>'REGION_TEMPLATE_CLOSE'
,p_button_redirect_url=>'f?p=&APP_ID.:30:&SESSION.::&DEBUG.:::'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(217824367600661776)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_api.id(217821106815661703)
,p_button_name=>'CREATE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Create'
,p_button_position=>'REGION_TEMPLATE_CREATE'
,p_button_condition=>'P31_CAT_ID'
,p_button_condition_type=>'ITEM_IS_NULL'
,p_database_action=>'INSERT'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(217823590751661774)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(217821106815661703)
,p_button_name=>'DELETE'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_image_alt=>'Delete'
,p_button_position=>'REGION_TEMPLATE_DELETE'
,p_button_redirect_url=>'javascript:apex.confirm(htmldb_delete_message,''DELETE'');'
,p_button_execute_validations=>'N'
,p_button_condition=>'P31_CAT_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'DELETE'
);
wwv_flow_api.create_page_branch(
 p_id=>wwv_flow_api.id(217824694415661776)
,p_branch_action=>'f?p=&APP_ID.:30:&SESSION.::&DEBUG.&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'AFTER_PROCESSING'
,p_branch_type=>'REDIRECT_URL'
,p_branch_sequence=>1
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(217821496363661704)
,p_name=>'P31_CAT_ID'
,p_source_data_type=>'NUMBER'
,p_is_primary_key=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(217821106815661703)
,p_item_source_plug_id=>wwv_flow_api.id(217821106815661703)
,p_source=>'CAT_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(217821898469661741)
,p_name=>'P31_NAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(217821106815661703)
,p_item_source_plug_id=>wwv_flow_api.id(217821106815661703)
,p_prompt=>'Name'
,p_source=>'NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>30
,p_field_template=>wwv_flow_api.id(428417166215998107)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(217825507946661788)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(217821106815661703)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>'Process form Categories Form'
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(217825157561661784)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(217821106815661703)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>'Initialize form Categories Form'
);
end;
/
prompt --application/pages/page_09999
begin
wwv_flow_api.create_page(
 p_id=>9999
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Login Page'
,p_alias=>'LOGIN_DESKTOP'
,p_step_title=>'Corona Hilfe Angebote - Sign 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(
'span.t-Login-logo {',
'background-image: url(#APP_IMAGES#Claudia_Heimkehr_des_Prinzen.png);',
'backgroung-size: cover;',
'width: 150px;',
'height: 140px;',
'}',
''))
,p_step_template=>wwv_flow_api.id(428310274166997848)
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_help_text=>'Benuutzer = Email-Adresse'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200324165633'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428446769034998524)
,p_plug_name=>'Corona Engagement and Help Services in the Region'
,p_icon_css_classes=>'app-icon'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(428356300338997960)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_plug_footer=>'<br><a href="http://bfw-design.maxapex.ws/apex/f?p=&APP_ID.:9"/><font color="blue">Password forgotten ? click here</font></a><br><br>'
,p_attribute_01=>'N'
,p_attribute_02=>'TEXT'
,p_attribute_03=>'Y'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428451479356998599)
,p_plug_name=>'Language Selector'
,p_parent_plug_id=>wwv_flow_api.id(428446769034998524)
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#'
,p_escape_on_http_output=>'Y'
,p_plug_template=>wwv_flow_api.id(428330242231997924)
,p_plug_display_sequence=>20
,p_plug_display_point=>'BODY'
,p_plug_source=>'apex_lang.emit_language_selector_list;'
,p_plug_source_type=>'NATIVE_PLSQL'
,p_plug_query_num_rows=>15
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428449622004998578)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_api.id(428446769034998524)
,p_button_name=>'LOGIN'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Sign In'
,p_button_position=>'REGION_TEMPLATE_NEXT'
,p_button_alignment=>'LEFT'
,p_grid_new_row=>'Y'
,p_grid_new_column=>'Y'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(426998834606873040)
,p_button_sequence=>50
,p_button_plug_id=>wwv_flow_api.id(428446769034998524)
,p_button_name=>'Eintragen'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#:t-Button--primary'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Enter your engagement here'
,p_button_position=>'REGION_TEMPLATE_NEXT'
,p_button_redirect_url=>'f?p=&APP_ID.:3:&SESSION.::&DEBUG.:RP,3::'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(428812279995400566)
,p_button_sequence=>60
,p_button_plug_id=>wwv_flow_api.id(428446769034998524)
,p_button_name=>'HOME'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#:t-Button--primary'
,p_button_template_id=>wwv_flow_api.id(428418332319998122)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'To the Homepage without Login'
,p_button_position=>'REGION_TEMPLATE_NEXT'
,p_button_redirect_url=>'f?p=&APP_ID.:4:&SESSION.::&DEBUG.:RP::'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428447183833998539)
,p_name=>'P9999_USERNAME'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(428446769034998524)
,p_prompt=>'Username/Email'
,p_placeholder=>'email'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>40
,p_cMaxlength=>100
,p_field_template=>wwv_flow_api.id(428416925566998092)
,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_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428447563438998546)
,p_name=>'P9999_PASSWORD'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(428446769034998524)
,p_prompt=>'Password'
,p_placeholder=>'Passwort'
,p_display_as=>'NATIVE_PASSWORD'
,p_cSize=>40
,p_cMaxlength=>100
,p_field_template=>wwv_flow_api.id(428416925566998092)
,p_item_icon_css_classes=>'fa-key'
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428448717666998563)
,p_name=>'P9999_REMEMBER'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(428446769034998524)
,p_prompt=>'Benutzername/Email merken'
,p_display_as=>'NATIVE_CHECKBOX'
,p_named_lov=>'LOGIN_REMEMBER_USERNAME'
,p_lov=>'.'||wwv_flow_api.id(428447937683998547)||'.'
,p_field_template=>wwv_flow_api.id(428416925566998092)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
'<p>',
unistr('Wenn man diese Checkbox anklickt, wird die Anwendung Benutzername7Email und Passwort in einem cookie named "LOGIN_USERNAME_COOKIE" speichern. Wenn man das n\00E4chste mal wiederkommt, werden Benutzername und Paswort automatisch eingetragen.'),
'</p>',
'<p>',
unistr('Wenn man die Checkbox nicht angeklickt hat (und sich einloggt) werden die gespeicherten Daten wieder gel\00F6scht.'),
'</p>'))
,p_attribute_01=>'1'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(428450410606998595)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Set Username Cookie'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'apex_authentication.send_login_username_cookie (',
'    p_username => lower(:P9999_USERNAME),',
'    p_consent  => :P9999_REMEMBER = ''Y'' );'))
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(428449975968998589)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Login'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'apex_authentication.login(',
'    p_username => :P9999_USERNAME,',
'    p_password => :P9999_PASSWORD );'))
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(428451252065998598)
,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'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(428450862309998596)
,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;'))
);
end;
/
prompt --application/pages/page_10010
begin
wwv_flow_api.create_page(
 p_id=>10010
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'About'
,p_alias=>'HELP'
,p_step_title=>'About'
,p_first_item=>'AUTO_FIRST_ITEM'
,p_autocomplete_on_off=>'OFF'
,p_group_id=>wwv_flow_api.id(428443971555998436)
,p_required_patch=>wwv_flow_api.id(428442961143998411)
,p_page_is_public_y_n=>'Y'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200324224737'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428517803292999048)
,p_plug_name=>'<font color="lightblue">About Page</font>'
,p_region_template_options=>'#DEFAULT#:t-ContentBlock--padded:t-ContentBlock--h1:t-ContentBlock--lightBG'
,p_plug_template=>wwv_flow_api.id(428348115182997954)
,p_plug_display_sequence=>20
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'This appplication will serve to coordinate help and engagement related to the COVID-19 crisis.',
'<br><br>',
'',
'This is a <b>Non commercial initiative</b>.<br><br>',
'',
'Engaged people - lets call them "Service-Providers" - may register in this portal and describe what they are willing to do for others.<br><br>',
'',
'Those "Help-Seekers", who require assistance and help, may select from the list of services and leave their contact data.<br>',
'',
'The "Service-Providers" will be informed by mail and establish contact to the "Job-Seekers".<br><br>',
'',
'Data security is important nowadays. Your data will not be onpaassed to third parties and after the project is coming to an end will be deleted completely (*).<br>',
'"Service-Providers" may delete their data anytime by entering the profile.<br>',
'The "Help-seeker" data are then delete as well.<br><br>',
'',
'This application has been developed by:<br>',
'<a href = "mailto:Bernhard@Fischer-Wasels.de">Bernhard@Fischer-Wasels.de</a><br>',
'Neulander Weg 25<br>',
'21357 Wittorf<br>',
'www.BFW-DESIGN.DE<br>',
'Whereas he is not responsible for the content and data as contained in this application.<br>',
unistr('Wittorf/L\00FCneburg/Germany, 20.03.2020'),
''))
,p_plug_query_num_rows=>15
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
,p_attribute_03=>'Y'
);
end;
/
prompt --application/pages/page_10011
begin
wwv_flow_api.create_page(
 p_id=>10011
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Help'
,p_alias=>'PAGE_HELP'
,p_page_mode=>'MODAL'
,p_step_title=>'Help'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_required_patch=>wwv_flow_api.id(428442961143998411)
,p_dialog_chained=>'N'
,p_page_is_public_y_n=>'Y'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200322094733'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(428518558564999051)
,p_plug_name=>'Search Dialog'
,p_region_template_options=>'#DEFAULT#'
,p_escape_on_http_output=>'Y'
,p_plug_template=>wwv_flow_api.id(428330242231997924)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'for c1 in ',
'(',
'    select page_title, help_text ',
'      from apex_application_pages',
'     where page_id = :P10011_PAGE_ID ',
'       and application_id = :APP_ID',
')',
'loop',
'    if c1.help_text is null then',
'        sys.htp.p(''No help is available for this page.'');',
'    else',
'        if substr(c1.help_text, 1, 3) != ''<p>'' then',
'            sys.htp.p(''<p>'');',
'        end if;',
'',
'        sys.htp.p(apex_application.do_substitutions(c1.help_text));',
'',
'        if substr(trim(c1.help_text), -4) != ''</p>'' then',
'            sys.htp.p(''</p>'');',
'        end if;',
'    end if;',
'end loop;'))
,p_plug_source_type=>'NATIVE_PLSQL'
,p_plug_query_num_rows=>15
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(428518906519999051)
,p_name=>'P10011_PAGE_ID'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(428518558564999051)
,p_display_as=>'NATIVE_HIDDEN'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'Y'
);
end;
/
prompt --application/pages/page_10012
begin
wwv_flow_api.create_page(
 p_id=>10012
,p_user_interface_id=>wwv_flow_api.id(428440845006998233)
,p_name=>'Imprint'
,p_step_title=>'Imprint'
,p_first_item=>'AUTO_FIRST_ITEM'
,p_autocomplete_on_off=>'OFF'
,p_group_id=>wwv_flow_api.id(428443971555998436)
,p_required_patch=>wwv_flow_api.id(428442961143998411)
,p_page_is_public_y_n=>'Y'
,p_help_text=>'Hier gibt es Impressum- und Datenschutzhinweise'
,p_last_updated_by=>'FISCHER'
,p_last_upd_yyyymmddhh24miss=>'20200325114650'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(643072974993505529)
,p_plug_name=>'<font color="lightblue">Impressum - Datenschutz</font>'
,p_region_template_options=>'#DEFAULT#:t-ContentBlock--padded:t-ContentBlock--h1:t-ContentBlock--lightBG'
,p_plug_template=>wwv_flow_api.id(428348115182997954)
,p_plug_display_sequence=>20
,p_plug_display_point=>'BODY'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'This appplication will serve to coordinate help and engagement related to the COVID-19 crisis.',
'<br><br>',
'',
'This is a <b>Non commercial initiative</b>.<br><br>',
'',
'This application has been developed by:<br>',
'<a href = "mailto:Bernhard@Fischer-Wasels.de">Bernhard@Fischer-Wasels.de</a><br>',
'Neulander Weg 25<br>',
'21357 Wittorf<br>',
'www.BFW-DESIGN.DE<br>',
unistr('Wittorf/L\00FCneburg/Germany, 20.03.2020<br><br>'),
'',
'Whereas he is not responsible for the content and data as contained in this application.<br><br>',
'',
'Responsible for this application is:<br>',
'... pls fill in your name here ...<br>',
'... Location ...<br>',
'... contact ...<br>',
''))
,p_plug_query_num_rows=>15
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
,p_attribute_03=>'Y'
);
end;
/
prompt --application/deployment/definition
begin
wwv_flow_api.create_install(
 p_id=>wwv_flow_api.id(217714371931334900)
,p_welcome_message=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Please make a note of the ADMIN user: ADMIN@CORONAHELP.NET  - Password: nocorona (case sensitive)<br>',
'after the Login go to your profile (upper right) and change the password.<br>',
'Then pls go to "Administration" --> Setup hints.. <br>',
'Thank you and good luck !!<br>',
''))
,p_configuration_message=>'You can configure the following attributes of your application.'
,p_build_options_message=>'You can choose to include the following build options.'
,p_validation_message=>'The following validations will be performed to ensure your system is compatible with this application.'
,p_install_message=>'Please confirm that you would like to install this application''s supporting objects.'
,p_upgrade_message=>'The application installer has detected that this application''s supporting objects were previously installed.  This wizard will guide you through the process of upgrading these supporting objects.'
,p_upgrade_confirm_message=>'Please confirm that you would like to install this application''s supporting objects.'
,p_upgrade_success_message=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Your application''s supporting objects have been installed.<br><br>',
'please make a note of the <br>',
'ADMIN user: <b>admin@coronahelp.net</b> - Password: <b>nomorecorona</b> (case sensitive!);<br>',
'on the <b>Login page</b> use that ADMIN user and credentials and you are set.'))
,p_upgrade_failure_message=>'Installation of database objects and seed data has failed.'
,p_deinstall_success_message=>'Deinstallation complete.'
,p_deinstall_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'/*',
'Drop the tables, sequences and triggers for the application.',
'*/',
'',
'-- tables',
'DROP TABLE CORONA_LEUTE CASCADE CONSTRAINTS',
'/',
'DROP TABLE CORONA_HELP CASCADE CONSTRAINTS',
'/',
'DROP TABLE CORONA_HILFSDIENSTE CASCADE CONSTRAINTS',
'/',
'DROP TABLE COR_CATEGORIES CASCADE CONSTRAINTS',
'/',
'',
'--sequences',
'DROP SEQUENCE CORONA_LEUTE_SEQ',
'/',
'DROP SEQUENCE CORONA_HELP_SEQ;',
'/',
'DROP SEQUENCE CORONA_HILFSDIENSTE_SEQ',
'/',
'DROP SEQUENCE COR_CATEGORIES_SEQ',
'/',
'',
'--triggers',
'DROP TRIGGER BI_CORONA_LEUTE',
'/',
'DROP TRIGGER BI_CORONA_HELP',
'/',
'DROP TRIGGER BI_CORONA_HILFSDIENSTE',
'/',
'DROP TRIGGER BI_COR_CATEGORIES',
'/'))
,p_deinstall_message=>'The deinstallation script will purge all related objects.'
);
end;
/
prompt --application/deployment/install/install_create_tables_corona_app
begin
wwv_flow_api.create_install_script(
 p_id=>wwv_flow_api.id(217725188551375477)
,p_install_id=>wwv_flow_api.id(217714371931334900)
,p_name=>'Create_tables_corona_app'
,p_sequence=>5
,p_script_type=>'INSTALL'
,p_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'CREATE TABLE  "CORONA_HILFSDIENSTE" ',
'   (	"ID" NUMBER NOT NULL ENABLE, ',
'	"NAME" VARCHAR2(50), ',
'	"BESCHREIBUNG" VARCHAR2(100), ',
'	"LINK" VARCHAR2(500), ',
'	"LOGO" BLOB, ',
'	"ANZEIGEN" VARCHAR2(5), ',
'	"TELEFON" VARCHAR2(20), ',
'	"WHATSAPP" VARCHAR2(20), ',
'	 CONSTRAINT "CORONA_HILFSDIENSTE_PK" PRIMARY KEY ("ID")',
'  USING INDEX  ENABLE',
'   )',
'/',
'CREATE TABLE  "CORONA_LEUTE" ',
'   (	"ID" NUMBER NOT NULL ENABLE, ',
'	"COR_HELPER_FK" NUMBER, ',
'	"ANREDE" VARCHAR2(10), ',
'	"VORNAME" VARCHAR2(20), ',
'	"NAME" VARCHAR2(20), ',
'	"STRASSE" VARCHAR2(50), ',
'	"PLZ" VARCHAR2(10), ',
'	"ORT" VARCHAR2(50), ',
'	"TELEFON" VARCHAR2(20), ',
'	"EMAIL" VARCHAR2(50), ',
'	"ERSTELLT_AM" DATE, ',
'	"BEMERKUNGEN" VARCHAR2(200), ',
'	"INFIZIER_JA_NEIN" VARCHAR2(20), ',
'	"DATENSCHUTZ" VARCHAR2(5), ',
'	 CONSTRAINT "CORONA_LEUTE_PK" PRIMARY KEY ("ID")',
'  USING INDEX  ENABLE',
'   )',
'/',
'CREATE TABLE  "CORONA_HELP" ',
'   (	"ID" NUMBER NOT NULL ENABLE, ',
'	"ANREDE" VARCHAR2(20), ',
'	"VORNAME" VARCHAR2(20), ',
'	"NAME" VARCHAR2(50), ',
'	"STRASSE" VARCHAR2(50), ',
'	"PLZ" VARCHAR2(10), ',
'	"ORT" VARCHAR2(50), ',
'	"STADTTEIL" VARCHAR2(50), ',
'	"ANGEBOT" VARCHAR2(500), ',
'	"KATEGORIE" VARCHAR2(100), ',
'	"SONSTIGES" VARCHAR2(50), ',
'	"EMAIL" VARCHAR2(50), ',
'    "EMAIL_CHECK" VARCHAR2(50), ',
'	"PASSWORT" VARCHAR2(20), ',
'	"TELEFON" VARCHAR2(20), ',
'	"PKW" VARCHAR2(10), ',
'	"ERFASST_AM" DATE, ',
'	"ANGEBOT_GUELTIG_BIS" DATE, ',
'	"BEMERKUNGEN" VARCHAR2(500), ',
'	"ADMIN" VARCHAR2(10), ',
'	"DATENSCHUTZ" VARCHAR2(5), ',
'    "MASKS_AVAILABLE" NUMBER, ',
'  	 CONSTRAINT "CORONA_HELP_PK" PRIMARY KEY ("ID")',
'  USING INDEX  ENABLE',
'   )',
'/',
'',
'CREATE TABLE  "COR_CATEGORIES" ',
'   (	"CAT_ID" NUMBER NOT NULL ENABLE, ',
'	"NAME" VARCHAR2(30), ',
'    "NAME_DEUTSCH" VARCHAR2(30), ',
'	 CONSTRAINT "COR_CATEGORIES_PK" PRIMARY KEY ("CAT_ID")',
'  USING INDEX  ENABLE',
'   )',
'/',
'CREATE OR REPLACE EDITIONABLE FUNCTION  "CORONA_AUTH_FUNCTION" ',
'(p_username in varchar2, p_password in varchar2)',
'RETURN BOOLEAN',
'AS',
'BEGIN',
'for c1 in (select 1 from CORONA_HELP where upper(email) = upper(p_username) and passwort = p_password ) loop',
'return true;',
'end loop;',
'return false;',
'end;',
'/',
'',
' CREATE SEQUENCE   "CORONA_HELP_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 ',
'/',
' CREATE SEQUENCE   "CORONA_HILFSDIENSTE_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 ',
'/',
' CREATE SEQUENCE   "CORONA_LEUTE_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 ',
'/',
' CREATE SEQUENCE   "COR_CATEGORIES_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1',
'/',
'CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_CORONA_HELP" ',
'  before insert on "CORONA_HELP"               ',
'  for each row  ',
'begin   ',
'  if :NEW."ID" is null then ',
'    select "CORONA_HELP_SEQ".nextval into :NEW."ID" from sys.dual; ',
'  end if; ',
'end; ',
'',
'/',
'ALTER TRIGGER  "BI_CORONA_HELP" ENABLE',
'/',
'CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_CORONA_HILFSDIENSTE" ',
'  before insert on "CORONA_HILFSDIENSTE"               ',
'  for each row  ',
'begin   ',
'  if :NEW."ID" is null then ',
'    select "CORONA_HILFSDIENSTE_SEQ".nextval into :NEW."ID" from sys.dual; ',
'  end if; ',
'end; ',
'',
'/',
'ALTER TRIGGER  "BI_CORONA_HILFSDIENSTE" ENABLE',
'/',
'CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_CORONA_LEUTE" ',
'  before insert on "CORONA_LEUTE"               ',
'  for each row  ',
'begin   ',
'  if :NEW."ID" is null then ',
'    select "CORONA_LEUTE_SEQ".nextval into :NEW."ID" from sys.dual; ',
'  end if; ',
'end; ',
'',
'/',
'ALTER TRIGGER  "BI_CORONA_LEUTE" ENABLE',
'',
'/',
'',
'CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_COR_CATEGORIES" ',
'  before insert on "COR_CATEGORIES"               ',
'  for each row  ',
'begin   ',
'  if :NEW."CAT_ID" is null then ',
'    select "COR_CATEGORIES_SEQ".nextval into :NEW."CAT_ID" from sys.dual; ',
'  end if; ',
'end; ',
'',
'/',
'ALTER TRIGGER  "BI_COR_CATEGORIES" ENABLE',
'/',
''))
);
end;
/
prompt --application/deployment/install/install_insert_admin_user_in_corona_help_table
begin
wwv_flow_api.create_install_script(
 p_id=>wwv_flow_api.id(217715431644346872)
,p_install_id=>wwv_flow_api.id(217714371931334900)
,p_name=>'Insert_Admin_user_in_corona_help_table'
,p_sequence=>10
,p_script_type=>'INSTALL'
,p_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'-- Insert data into CORONA_HELP ... these are the "helpers"engagers"',
'-- this first record is the ADMIN admin@coronahelp.net - Password: nomorecorona',
'',
'SET DEFINE OFF',
'',
'INSERT INTO CORONA_HELP (',
'name, vorname, email, admin, passwort)',
'',
'VALUES (''Helper'', ''corona'', ''admin@coronahelp.net'', ''Yes'',''nocorona'');',
'',
'insert into COR_CATEGORIES (name)',
'values (''shopping'');',
'',
'insert into COR_CATEGORIES (name)',
'values (''transportation'');',
'',
'insert into COR_CATEGORIES (name)',
'values (''baby sitting'');',
'',
'insert into COR_CATEGORIES (name)',
'values (''walk the dog'');',
'',
'insert into COR_CATEGORIES (name)',
'values (''communication'');',
'',
'insert into COR_CATEGORIES (name)',
'values (''doctor consultation'');',
'',
'insert into COR_CATEGORIES (name)',
'values (''misc.'');',
'',
'Commit;',
'',
''))
);
end;
/
prompt --application/deployment/checks
begin
null;
end;
/
prompt --application/deployment/buildoptions
begin
null;
end;
/
prompt --application/end_environment
begin
wwv_flow_api.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false));
commit;
end;
/
set verify on feedback on define on
prompt  ...done
