set define off verify off feedback off whenever sqlerror exit sql.sqlcode rollback -------------------------------------------------------------------------------- -- -- ORACLE Application Express (APEX) export file -- -- You should run the script connected to SQL*Plus as the Oracle user -- APEX_050000 or as the owner (parsing schema) of the application. -- -- NOTE: Calls to apex_application_install override the defaults below. -- -------------------------------------------------------------------------------- begin wwv_flow_api.import_begin ( p_version_yyyy_mm_dd=>'2013.01.01' ,p_release=>'5.0.3.00.03' ,p_default_workspace_id=>3899267116010088828 ,p_default_application_id=>90770 ,p_default_owner=>'JMR' ); end; / prompt --application/set_environment prompt APPLICATION 90770 - Demo Practical Dynamic Actions -- -- Application Export: -- Application: 90770 -- Name: Demo Practical Dynamic Actions -- Date and Time: 21:33 Tuesday March 29, 2016 -- Exported By: JORGE@RIMBLAS.COM -- Flashback: 0 -- Export Type: Application Export -- Version: 5.0.3.00.03 -- Instance ID: 63113759365424 -- -- Application Statistics: -- Pages: 13 -- Items: 28 -- Computations: 1 -- Processes: 9 -- Regions: 26 -- Buttons: 15 -- Dynamic Actions: 11 -- Shared Components: -- Logic: -- Navigation: -- Lists: 2 -- Breadcrumbs: 1 -- Entries: 13 -- Security: -- Authentication: 1 -- User Interface: -- Themes: 1 -- Templates: -- Page: 9 -- Region: 13 -- Label: 5 -- List: 11 -- Popup LOV: 1 -- Calendar: 1 -- Breadcrumb: 1 -- Button: 3 -- Report: 8 -- LOVs: 1 -- Plug-ins: 1 -- Globalization: -- Reports: -- Supporting Objects: Included prompt --application/delete_application begin wwv_flow_api.remove_flow(wwv_flow.g_flow_id); end; / prompt --application/ui_types begin null; end; / prompt --application/create_application begin wwv_flow_api.create_flow( p_id=>wwv_flow.g_flow_id ,p_display_id=>nvl(wwv_flow_application_install.get_application_id,90770) ,p_owner=>nvl(wwv_flow_application_install.get_schema,'JMR') ,p_name=>nvl(wwv_flow_application_install.get_application_name,'Demo Practical Dynamic Actions') ,p_alias=>nvl(wwv_flow_application_install.get_application_alias,'F_90770') ,p_page_view_logging=>'YES' ,p_page_protection_enabled_y_n=>'Y' ,p_checksum_salt=>'E214740DF477735E45C1C526F696B26B3FD353F24387784ECED51AD09593734A' ,p_bookmark_checksum_function=>'SH512' ,p_compatibility_mode=>'5.0' ,p_flow_language=>'en' ,p_flow_language_derived_from=>'FLOW_PRIMARY_LANGUAGE' ,p_flow_image_prefix => nvl(wwv_flow_application_install.get_image_prefix,'') ,p_authentication=>'PLUGIN' ,p_authentication_id=>wwv_flow_api.id(7917789865142017531) ,p_application_tab_set=>0 ,p_logo_image=>'TEXT:Dynamic Actions Presentation' ,p_public_user=>'APEX_PUBLIC_USER' ,p_proxy_server=> nvl(wwv_flow_application_install.get_proxy,'') ,p_flow_version=>'release 1.0' ,p_flow_status=>'AVAILABLE_W_EDIT_LINK' ,p_flow_unavailable_text=>'This application is currently unavailable at this time.' ,p_exact_substitutions_only=>'Y' ,p_browser_cache=>'N' ,p_deep_linking=>'Y' ,p_rejoin_existing_sessions=>'N' ,p_csv_encoding=>'Y' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20160329213333' ,p_file_prefix => nvl(wwv_flow_application_install.get_static_app_file_prefix,'') ,p_ui_type_name => null ); end; / prompt --application/shared_components/navigation/lists begin wwv_flow_api.create_list( p_id=>wwv_flow_api.id(7917747218966017443) ,p_name=>'Desktop Navigation Menu' ,p_list_status=>'PUBLIC' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(7917790022873017534) ,p_list_item_display_sequence=>10 ,p_list_item_link_text=>'Home' ,p_list_item_link_target=>'f?p=&APP_ID.:1:&APP_SESSION.::&DEBUG.:' ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'1' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(7918243824435261660) ,p_list_item_display_sequence=>20 ,p_list_item_link_text=>'Component Actions' ,p_list_item_link_target=>'f?p=&APP_ID.:10:&SESSION.::&DEBUG.::::' ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'10,20,11,30,25,40' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(7919256313847427271) ,p_list_item_display_sequence=>30 ,p_list_item_link_text=>'Simple Hide/Show' ,p_list_item_link_target=>'f?p=&APP_ID.:11:&SESSION.::&DEBUG.::::' ,p_parent_list_item_id=>wwv_flow_api.id(7918243824435261660) ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'11' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(7918399695790119366) ,p_list_item_display_sequence=>40 ,p_list_item_link_text=>'Switch Items' ,p_list_item_link_target=>'f?p=&APP_ID.:20:&SESSION.::&DEBUG.::::' ,p_parent_list_item_id=>wwv_flow_api.id(7918243824435261660) ,p_list_item_current_type=>'TARGET_PAGE' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(8004284969894160290) ,p_list_item_display_sequence=>45 ,p_list_item_link_text=>'Hide/Show Conditional' ,p_list_item_link_target=>'f?p=&APP_ID.:25:&SESSION.::&DEBUG.' ,p_parent_list_item_id=>wwv_flow_api.id(7918243824435261660) ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'25' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(7985015610106021461) ,p_list_item_display_sequence=>50 ,p_list_item_link_text=>'Set Value' ,p_list_item_link_target=>'f?p=&APP_ID.:30:&SESSION.::&DEBUG.' ,p_parent_list_item_id=>wwv_flow_api.id(7918243824435261660) ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'30' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(8280976316797207122) ,p_list_item_display_sequence=>100 ,p_list_item_link_text=>'Key Release' ,p_list_item_link_target=>'f?p=&APP_ID.:40:&SESSION.::&DEBUG.' ,p_parent_list_item_id=>wwv_flow_api.id(7918243824435261660) ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'40' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(7986772816702351465) ,p_list_item_display_sequence=>60 ,p_list_item_link_text=>'Refresh' ,p_list_item_link_target=>'f?p=&APP_ID.:100:&SESSION.::&DEBUG.' ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'100,110,110' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(7986934733701310833) ,p_list_item_display_sequence=>70 ,p_list_item_link_text=>'Simple Refresh Report' ,p_list_item_link_target=>'f?p=&APP_ID.:110:&SESSION.::&DEBUG.' ,p_parent_list_item_id=>wwv_flow_api.id(7986772816702351465) ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'110' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(8248856044040898679) ,p_list_item_display_sequence=>80 ,p_list_item_link_text=>'AJAX' ,p_list_item_link_target=>'f?p=&APP_ID.:200:&SESSION.::&DEBUG.' ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'200,210,214' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(8250359808661241908) ,p_list_item_display_sequence=>85 ,p_list_item_link_text=>'Users (No DA)' ,p_list_item_link_target=>'f?p=&APP_ID.:214:&SESSION.::&DEBUG.::P214_ID:1' ,p_parent_list_item_id=>wwv_flow_api.id(8248856044040898679) ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'214' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(8249553903844034031) ,p_list_item_display_sequence=>90 ,p_list_item_link_text=>'Users' ,p_list_item_link_target=>'f?p=&APP_ID.:210:&SESSION.::&DEBUG.' ,p_parent_list_item_id=>wwv_flow_api.id(8248856044040898679) ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'210,215' ); wwv_flow_api.create_list( p_id=>wwv_flow_api.id(7917789531021017529) ,p_name=>'Desktop Navigation Bar' ,p_list_status=>'PUBLIC' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(7917789770316017530) ,p_list_item_display_sequence=>10 ,p_list_item_link_text=>'Log Out' ,p_list_item_link_target=>'&LOGOUT_URL.' ,p_list_item_current_for_pages=>'&LOGOUT_URL.' ); end; / prompt --application/shared_components/files begin null; end; / prompt --application/plugin_settings begin wwv_flow_api.create_plugin_setting( p_id=>wwv_flow_api.id(7917746959783017442) ,p_plugin_type=>'ITEM TYPE' ,p_plugin=>'NATIVE_YES_NO' ,p_attribute_01=>'Y' ,p_attribute_03=>'N' ); wwv_flow_api.create_plugin_setting( p_id=>wwv_flow_api.id(7917747009039017442) ,p_plugin_type=>'REGION TYPE' ,p_plugin=>'NATIVE_CSS_CALENDAR' ); wwv_flow_api.create_plugin_setting( p_id=>wwv_flow_api.id(7917747109905017443) ,p_plugin_type=>'REGION TYPE' ,p_plugin=>'NATIVE_DISPLAY_SELECTOR' ,p_attribute_01=>'Y' ); end; / prompt --application/shared_components/security/authorizations begin null; end; / prompt --application/shared_components/navigation/navigation_bar begin null; end; / prompt --application/shared_components/logic/application_processes begin null; end; / prompt --application/shared_components/logic/application_items begin null; end; / prompt --application/shared_components/logic/application_computations begin null; end; / prompt --application/shared_components/navigation/tabs/standard begin null; end; / prompt --application/shared_components/navigation/tabs/parent begin null; end; / prompt --application/shared_components/user_interface/lovs begin wwv_flow_api.create_list_of_values( p_id=>wwv_flow_api.id(7986776559584387738) ,p_lov_name=>'P110_Report Row Per Page' ,p_lov_query=>'.'||wwv_flow_api.id(7986776559584387738)||'.' ); wwv_flow_api.create_static_lov_data( p_id=>wwv_flow_api.id(7986776998139387739) ,p_lov_disp_sequence=>10 ,p_lov_disp_value=>'10' ,p_lov_return_value=>'10' ); wwv_flow_api.create_static_lov_data( p_id=>wwv_flow_api.id(7986777389160387740) ,p_lov_disp_sequence=>20 ,p_lov_disp_value=>'15' ,p_lov_return_value=>'15' ); wwv_flow_api.create_static_lov_data( p_id=>wwv_flow_api.id(7986777756408387740) ,p_lov_disp_sequence=>30 ,p_lov_disp_value=>'20' ,p_lov_return_value=>'20' ); wwv_flow_api.create_static_lov_data( p_id=>wwv_flow_api.id(7986798147833387741) ,p_lov_disp_sequence=>40 ,p_lov_disp_value=>'30' ,p_lov_return_value=>'30' ); wwv_flow_api.create_static_lov_data( p_id=>wwv_flow_api.id(7986798584097387741) ,p_lov_disp_sequence=>50 ,p_lov_disp_value=>'50' ,p_lov_return_value=>'50' ); wwv_flow_api.create_static_lov_data( p_id=>wwv_flow_api.id(7986798918620387741) ,p_lov_disp_sequence=>60 ,p_lov_disp_value=>'100' ,p_lov_return_value=>'100' ); wwv_flow_api.create_static_lov_data( p_id=>wwv_flow_api.id(7986799363178387741) ,p_lov_disp_sequence=>70 ,p_lov_disp_value=>'200' ,p_lov_return_value=>'200' ); wwv_flow_api.create_static_lov_data( p_id=>wwv_flow_api.id(7986799717643387742) ,p_lov_disp_sequence=>80 ,p_lov_disp_value=>'500' ,p_lov_return_value=>'500' ); wwv_flow_api.create_static_lov_data( p_id=>wwv_flow_api.id(7986800196964387742) ,p_lov_disp_sequence=>90 ,p_lov_disp_value=>'1000' ,p_lov_return_value=>'1000' ); wwv_flow_api.create_static_lov_data( p_id=>wwv_flow_api.id(7986800582888387742) ,p_lov_disp_sequence=>100 ,p_lov_disp_value=>'5000' ,p_lov_return_value=>'5000' ); end; / prompt --application/shared_components/navigation/trees begin null; end; / prompt --application/pages/page_groups begin null; end; / prompt --application/comments begin null; end; / prompt --application/shared_components/navigation/breadcrumbs/breadcrumb begin wwv_flow_api.create_menu( p_id=>wwv_flow_api.id(7917789953665017533) ,p_name=>' Breadcrumb' ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(7917790302335017536) ,p_parent_id=>0 ,p_short_name=>'Home' ,p_link=>'f?p=&APP_ID.:1:&APP_SESSION.::&DEBUG.' ,p_page_id=>1 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(7918244764998261665) ,p_parent_id=>wwv_flow_api.id(7917790302335017536) ,p_short_name=>'Component Actions' ,p_link=>'f?p=&APP_ID.:10:&SESSION.::&DEBUG.:::' ,p_page_id=>10 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(7918312452759272301) ,p_parent_id=>wwv_flow_api.id(7918244764998261665) ,p_short_name=>'Switch Items' ,p_link=>'f?p=&APP_ID.:20:&SESSION.::&DEBUG.:::' ,p_page_id=>20 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(7919257469155427273) ,p_parent_id=>wwv_flow_api.id(7918244764998261665) ,p_short_name=>'Simple Hide/Show' ,p_link=>'f?p=&APP_ID.:11:&SESSION.::&DEBUG.:::' ,p_page_id=>11 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(7985016750719021465) ,p_parent_id=>wwv_flow_api.id(7918244764998261665) ,p_short_name=>'Set Value' ,p_link=>'f?p=&APP_ID.:30:&SESSION.' ,p_page_id=>30 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(7986773765627351467) ,p_parent_id=>wwv_flow_api.id(7917790302335017536) ,p_short_name=>'Refresh' ,p_link=>'f?p=&APP_ID.:100:&SESSION.' ,p_page_id=>100 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(7986942093635310845) ,p_parent_id=>wwv_flow_api.id(7986773765627351467) ,p_short_name=>'Simple Refresh Report' ,p_link=>'f?p=&APP_ID.:110:&SESSION.' ,p_page_id=>110 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(8004302857048160558) ,p_parent_id=>wwv_flow_api.id(7918244764998261665) ,p_short_name=>'Hide/Show Conditional' ,p_link=>'f?p=&APP_ID.:25:&SESSION.' ,p_page_id=>25 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(8248856891579898685) ,p_parent_id=>wwv_flow_api.id(7917790302335017536) ,p_short_name=>'AJAX' ,p_link=>'f?p=&APP_ID.:200:&SESSION.' ,p_page_id=>200 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(8249559331859034053) ,p_parent_id=>wwv_flow_api.id(8248856891579898685) ,p_short_name=>'Users' ,p_link=>'f?p=&APP_ID.:210:&SESSION.' ,p_page_id=>210 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(8249560528705034055) ,p_parent_id=>wwv_flow_api.id(8249559331859034053) ,p_short_name=>'Maintain Users' ,p_link=>'f?p=&APP_ID.:215:&SESSION.' ,p_page_id=>215 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(8250370325138241938) ,p_parent_id=>wwv_flow_api.id(8249559331859034053) ,p_short_name=>'Maintain Users (No Dynamic Aactions)' ,p_link=>'f?p=&APP_ID.:214:&SESSION.' ,p_page_id=>214 ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(8280979425555207132) ,p_parent_id=>wwv_flow_api.id(7918244764998261665) ,p_short_name=>'Generate Uppercase Code' ,p_link=>'f?p=&APP_ID.:40:&SESSION.' ,p_page_id=>40 ); end; / prompt --application/shared_components/user_interface/templates/page begin wwv_flow_api.create_template( p_id=>wwv_flow_api.id(7917747304558017443) ,p_theme_id=>42 ,p_name=>'Left Side Column' ,p_is_popup=>false ,p_javascript_code_onload=>'apex.theme42.initializePage.leftSideCol();' ,p_header_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '', '', '', '', '', '', '', ' ', '
', ' ', '#ADDITIONAL_INFO#
', '#ADDITIONAL_INFO#
', '#ADDITIONAL_INFO#
', '#ADDITIONAL_INFO#
', '#ADDITIONAL_INFO#
', '#ADDITIONAL_INFO#
', '#ADDITIONAL_INFO#
', '#ADDITIONAL_INFO#
', '#ADDITIONAL_INFO#
', '#A01#
', '#A01#
', '#SEARCH_DESC#
', ' #LABEL_01#: #VALUE_01#', '#SEARCH_DESC#
', ' #LABEL_01#: #VALUE_01#', ' #LABEL_02#: #VALUE_02#', '#SEARCH_DESC#
', ' #LABEL_01#: #VALUE_01#', ' #LABEL_02#: #VALUE_02#', ' #LABEL_03#: #VALUE_03#', '#SEARCH_DESC#
', ' #LABEL_01#: #VALUE_01#', ' #LABEL_02#: #VALUE_02#', ' #LABEL_03#: #VALUE_03#', ' #LABEL_04#: #VALUE_04#', '#IMONTH# #DD#, #YYYY# |
' ,p_daily_open_format=>' |
', ' #DD# #IDAY#', ' ', ' | ')) ,p_weekly_month_open_format=>'
---|
', ' The Notification dynamic action plug-in provides an unobtrusive stylish notification popup where the message automatically goes away after some time.
', '', ' The plug-in is based on the jQuery plug-in Gritter http://github.com/jboesch/Gritter
', '')) ,p_version_identifier=>'1.3' ,p_about_url=>'http://apex.oracle.com/plugins/' ); wwv_flow_api.create_plugin_attribute( p_id=>wwv_flow_api.id(11803512734823058050) ,p_plugin_id=>wwv_flow_api.id(11803512436077048971) ,p_attribute_scope=>'COMPONENT' ,p_attribute_sequence=>1 ,p_display_sequence=>10 ,p_prompt=>'Title' ,p_attribute_type=>'TEXT' ,p_is_required=>true ,p_display_length=>60 ,p_is_translatable=>true ,p_help_text=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '', ' The heading of the notification.
', '', ' The following placeholder syntax is available:
', '', ' The text inside the notification.
', '', ' The following placeholder syntax''s are available:
', '', ' The image URL used to display an image on the left.
', '')) ); wwv_flow_api.create_plugin_attribute( p_id=>wwv_flow_api.id(11803514264258066522) ,p_plugin_id=>wwv_flow_api.id(11803512436077048971) ,p_attribute_scope=>'COMPONENT' ,p_attribute_sequence=>4 ,p_display_sequence=>40 ,p_prompt=>'Sticky' ,p_attribute_type=>'CHECKBOX' ,p_is_required=>false ,p_default_value=>'N' ,p_is_translatable=>false ,p_help_text=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'If you want it to fade out on its own or just sit there sticky.
', '')) ); wwv_flow_api.create_plugin_attribute( p_id=>wwv_flow_api.id(11803514750322081468) ,p_plugin_id=>wwv_flow_api.id(11803512436077048971) ,p_attribute_scope=>'COMPONENT' ,p_attribute_sequence=>5 ,p_display_sequence=>50 ,p_prompt=>'Hide After x Seconds' ,p_attribute_type=>'INTEGER' ,p_is_required=>false ,p_display_length=>4 ,p_is_translatable=>false ,p_depending_on_attribute_id=>wwv_flow_api.id(11803514264258066522) ,p_depending_on_condition_type=>'EQUALS' ,p_depending_on_expression=>'N' ,p_help_text=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'Specifies the number of seconds the message should be displayed before it should fade out.
', '')) ); end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '2F2A20696536207472617368202A2F0D0A2A2068746D6C2023677269747465722D6E6F746963652D77726170706572207B0D0A09706F736974696F6E3A6162736F6C7574653B0D0A7D0D0A2A2068746D6C202E677269747465722D746F70207B0D0A096D'; wwv_flow_api.g_varchar2_table(2) := '617267696E2D626F74746F6D3A2D313070783B0D0A7D0D0A2A2068746D6C202E677269747465722D6974656D207B0D0A0970616464696E672D626F74746F6D3A303B0D0A7D0D0A2A2068746D6C202E677269747465722D626F74746F6D207B0D0A096D61'; wwv_flow_api.g_varchar2_table(3) := '7267696E2D626F74746F6D3A303B0D0A7D0D0A2A2068746D6C202E677269747465722D636C6F7365207B0D0A096261636B67726F756E643A75726C28677269747465722D636C6F73652D6965362E676966293B0D0A0977696474683A323270783B0D0A09'; wwv_flow_api.g_varchar2_table(4) := '6865696768743A323270783B0D0A09746F703A3770783B0D0A096C6566743A3770783B0D0A7D0D0A0D0A2F2A20746865206E6F726D202A2F0D0A23677269747465722D6E6F746963652D77726170706572207B0D0A09706F736974696F6E3A6669786564'; wwv_flow_api.g_varchar2_table(5) := '3B0D0A09746F703A323070783B0D0A0972696768743A323070783B0D0A0977696474683A33303170783B0D0A097A2D696E6465783A393939393B0D0A7D0D0A2E677269747465722D6974656D2D77726170706572207B0D0A09706F736974696F6E3A7265'; wwv_flow_api.g_varchar2_table(6) := '6C61746976653B0D0A096D617267696E3A302030203130707820303B0D0A096261636B67726F756E643A75726C282769652D7370616365722E67696627293B202F2A206965372F3820666978202A2F0D0A7D0D0A2E677269747465722D746F70207B0D0A'; wwv_flow_api.g_varchar2_table(7) := '096261636B67726F756E643A75726C28677269747465722E706E6729206E6F2D726570656174206C656674202D333070783B0D0A096865696768743A313070783B0D0A7D0D0A2E686F766572202E677269747465722D746F70207B0D0A096261636B6772'; wwv_flow_api.g_varchar2_table(8) := '6F756E642D706F736974696F6E3A7269676874202D333070783B0D0A7D0D0A2E677269747465722D626F74746F6D207B0D0A096261636B67726F756E643A75726C28677269747465722E706E6729206E6F2D726570656174206C65667420626F74746F6D'; wwv_flow_api.g_varchar2_table(9) := '3B0D0A096865696768743A3870783B0D0A096D617267696E3A303B0D0A7D0D0A2E686F766572202E677269747465722D626F74746F6D207B0D0A096261636B67726F756E642D706F736974696F6E3A20626F74746F6D2072696768743B0D0A7D0D0A2E67'; wwv_flow_api.g_varchar2_table(10) := '7269747465722D6974656D207B0D0A09646973706C61793A626C6F636B3B0D0A096261636B67726F756E643A75726C28677269747465722E706E6729206E6F2D726570656174206C656674202D343070783B0D0A09636F6C6F723A236565653B0D0A0970'; wwv_flow_api.g_varchar2_table(11) := '616464696E673A32707820313170782038707820313170783B0D0A09666F6E742D73697A653A20313170783B0D0A09666F6E742D66616D696C793A76657264616E613B0D0A7D0D0A2E686F766572202E677269747465722D6974656D207B0D0A09626163'; wwv_flow_api.g_varchar2_table(12) := '6B67726F756E642D706F736974696F6E3A7269676874202D343070783B0D0A7D0D0A2E677269747465722D6974656D2070207B0D0A0970616464696E673A303B0D0A096D617267696E3A303B0D0A09636F6C6F723A236565653B202F2A206E6563657373'; wwv_flow_api.g_varchar2_table(13) := '61727920666F72207468656D65203134202A2F0D0A7D0D0A2E677269747465722D636C6F7365207B0D0A09706F736974696F6E3A6162736F6C7574653B0D0A09746F703A3570783B0D0A096C6566743A3370783B0D0A096261636B67726F756E643A7572'; wwv_flow_api.g_varchar2_table(14) := '6C28677269747465722E706E6729206E6F2D726570656174206C65667420746F703B0D0A09637572736F723A706F696E7465723B0D0A0977696474683A333070783B0D0A096865696768743A333070783B0D0A7D0D0A2E677269747465722D7469746C65'; wwv_flow_api.g_varchar2_table(15) := '207B0D0A09666F6E742D73697A653A313470783B0D0A09666F6E742D7765696768743A626F6C643B0D0A09636F6C6F723A236565653B202F2A206E656365737361727920666F72207468656D65203134202A2F0D0A0970616464696E673A302030203770'; wwv_flow_api.g_varchar2_table(16) := '7820303B0D0A09646973706C61793A626C6F636B3B0D0A09746578742D736861646F773A3170782031707820233030303B202F2A204E6F7420737570706F72746564206279204945203A28202A2F0D0A7D0D0A2E677269747465722D696D616765207B0D'; wwv_flow_api.g_varchar2_table(17) := '0A0977696474683A343870783B0D0A096865696768743A343870783B0D0A09666C6F61743A6C6566743B0D0A7D0D0A2E677269747465722D776974682D696D6167652C0D0A2E677269747465722D776974686F75742D696D616765207B0D0A0970616464'; wwv_flow_api.g_varchar2_table(18) := '696E673A3020302035707820303B0D0A7D0D0A2E677269747465722D776974682D696D616765207B0D0A0977696474683A32323070783B0D0A09666C6F61743A72696768743B0D0A7D0D0A'; null; end; / begin wwv_flow_api.create_plugin_file( p_id=>wwv_flow_api.id(8256126537267809464) ,p_plugin_id=>wwv_flow_api.id(11803512436077048971) ,p_file_name=>'apex.jquery.gritter.css' ,p_mime_type=>'text/css' ,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table) ); end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '4749463839610100010080000000000000000021F90401000000002C00000000010001000002024401003B'; null; end; / begin wwv_flow_api.create_plugin_file( p_id=>wwv_flow_api.id(8261015675058869338) ,p_plugin_id=>wwv_flow_api.id(11803512436077048971) ,p_file_name=>'ie-spacer.gif' ,p_mime_type=>'image/gif' ,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table) ); end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '2866756E6374696F6E2824297B242E677269747465723D7B7D3B242E677269747465722E6F7074696F6E733D7B666164655F696E5F73706565643A276D656469756D272C666164655F6F75745F73706565643A313030302C74696D653A363030307D0A24'; wwv_flow_api.g_varchar2_table(2) := '2E677269747465722E6164643D66756E6374696F6E28706172616D73297B7472797B72657475726E20477269747465722E61646428706172616D737C7C7B7D293B7D63617463682865297B766172206572723D2747726974746572204572726F723A2027'; wwv_flow_api.g_varchar2_table(3) := '2B653B28747970656F6628636F6E736F6C6529213D27756E646566696E6564272626636F6E736F6C652E6572726F72293F636F6E736F6C652E6572726F72286572722C706172616D73293A616C65727428657272293B7D7D0A242E677269747465722E72'; wwv_flow_api.g_varchar2_table(4) := '656D6F76653D66756E6374696F6E2869642C706172616D73297B477269747465722E72656D6F766553706563696669632869642C706172616D737C7C7B7D293B7D0A242E677269747465722E72656D6F7665416C6C3D66756E6374696F6E28706172616D'; wwv_flow_api.g_varchar2_table(5) := '73297B477269747465722E73746F7028706172616D737C7C7B7D293B7D0A76617220477269747465723D7B666164655F696E5F73706565643A27272C666164655F6F75745F73706565643A27272C74696D653A27272C5F637573746F6D5F74696D65723A'; wwv_flow_api.g_varchar2_table(6) := '302C5F6974656D5F636F756E743A302C5F69735F73657475703A302C5F74706C5F636C6F73653A273C64697620636C6173733D22677269747465722D636C6F7365223E3C2F6469763E272C5F74706C5F6974656D3A273C6469762069643D226772697474'; wwv_flow_api.g_varchar2_table(7) := '65722D6974656D2D5B5B6E756D6265725D5D2220636C6173733D22677269747465722D6974656D2D77726170706572205B5B6974656D5F636C6173735D5D22207374796C653D22646973706C61793A6E6F6E65223E3C64697620636C6173733D22677269'; wwv_flow_api.g_varchar2_table(8) := '747465722D746F70223E3C2F6469763E3C64697620636C6173733D22677269747465722D6974656D223E5B5B696D6167655D5D3C64697620636C6173733D225B5B636C6173735F6E616D655D5D223E3C7370616E20636C6173733D22677269747465722D'; wwv_flow_api.g_varchar2_table(9) := '7469746C65223E5B5B757365726E616D655D5D3C2F7370616E3E3C703E5B5B746578745D5D3C2F703E3C2F6469763E3C646976207374796C653D22636C6561723A626F7468223E3C2F6469763E3C2F6469763E3C64697620636C6173733D226772697474'; wwv_flow_api.g_varchar2_table(10) := '65722D626F74746F6D223E3C2F6469763E3C2F6469763E272C5F74706C5F777261703A273C6469762069643D22677269747465722D6E6F746963652D77726170706572223E3C2F6469763E272C6164643A66756E6374696F6E28706172616D73297B6966'; wwv_flow_api.g_varchar2_table(11) := '2821706172616D732E7469746C657C7C21706172616D732E74657874297B7468726F7727596F75206E65656420746F2066696C6C206F757420746865206669727374203220706172616D733A20227469746C652220616E6420227465787422273B7D0A69'; wwv_flow_api.g_varchar2_table(12) := '662821746869732E5F69735F7365747570297B746869732E5F72756E536574757028293B7D0A76617220757365723D706172616D732E7469746C652C746578743D706172616D732E746578742C696D6167653D706172616D732E696D6167657C7C27272C'; wwv_flow_api.g_varchar2_table(13) := '737469636B793D706172616D732E737469636B797C7C66616C73652C6974656D5F636C6173733D706172616D732E636C6173735F6E616D657C7C27272C74696D655F616C6976653D706172616D732E74696D657C7C27273B746869732E5F766572696679'; wwv_flow_api.g_varchar2_table(14) := '5772617070657228293B746869732E5F6974656D5F636F756E742B2B3B766172206E756D6265723D746869732E5F6974656D5F636F756E742C746D703D746869732E5F74706C5F6974656D3B24285B276265666F72655F6F70656E272C2761667465725F'; wwv_flow_api.g_varchar2_table(15) := '6F70656E272C276265666F72655F636C6F7365272C2761667465725F636C6F7365275D292E656163682866756E6374696F6E28692C76616C297B477269747465725B275F272B76616C2B275F272B6E756D6265725D3D28242E697346756E6374696F6E28'; wwv_flow_api.g_varchar2_table(16) := '706172616D735B76616C5D29293F706172616D735B76616C5D3A66756E6374696F6E28297B7D7D293B746869732E5F637573746F6D5F74696D65723D303B69662874696D655F616C697665297B746869732E5F637573746F6D5F74696D65723D74696D65'; wwv_flow_api.g_varchar2_table(17) := '5F616C6976653B7D0A76617220696D6167655F7374723D28696D616765213D2727293F273C696D67207372633D22272B696D6167652B272220636C6173733D22677269747465722D696D61676522202F3E273A27272C636C6173735F6E616D653D28696D'; wwv_flow_api.g_varchar2_table(18) := '616765213D2727293F27677269747465722D776974682D696D616765273A27677269747465722D776974686F75742D696D616765273B746D703D746869732E5F7374725F7265706C616365285B275B5B757365726E616D655D5D272C275B5B746578745D'; wwv_flow_api.g_varchar2_table(19) := '5D272C275B5B696D6167655D5D272C275B5B6E756D6265725D5D272C275B5B636C6173735F6E616D655D5D272C275B5B6974656D5F636C6173735D5D275D2C5B757365722C746578742C696D6167655F7374722C746869732E5F6974656D5F636F756E74'; wwv_flow_api.g_varchar2_table(20) := '2C636C6173735F6E616D652C6974656D5F636C6173735D2C746D70293B746869735B275F6265666F72655F6F70656E5F272B6E756D6265725D28293B24282723677269747465722D6E6F746963652D7772617070657227292E617070656E6428746D7029'; wwv_flow_api.g_varchar2_table(21) := '3B766172206974656D3D24282723677269747465722D6974656D2D272B746869732E5F6974656D5F636F756E74293B6974656D2E66616465496E28746869732E666164655F696E5F73706565642C66756E6374696F6E28297B477269747465725B275F61'; wwv_flow_api.g_varchar2_table(22) := '667465725F6F70656E5F272B6E756D6265725D2824287468697329293B7D293B69662821737469636B79297B746869732E5F7365744661646554696D6572286974656D2C6E756D626572293B7D0A24286974656D292E62696E6428276D6F757365656E74'; wwv_flow_api.g_varchar2_table(23) := '6572206D6F7573656C65617665272C66756E6374696F6E286576656E74297B6966286576656E742E747970653D3D276D6F757365656E74657227297B69662821737469636B79297B477269747465722E5F726573746F72654974656D4966466164696E67'; wwv_flow_api.g_varchar2_table(24) := '28242874686973292C6E756D626572293B7D7D0A656C73657B69662821737469636B79297B477269747465722E5F7365744661646554696D657228242874686973292C6E756D626572293B7D7D0A477269747465722E5F686F7665725374617465282428'; wwv_flow_api.g_varchar2_table(25) := '74686973292C6576656E742E74797065293B7D293B72657475726E206E756D6265723B7D2C5F636F756E7452656D6F7665577261707065723A66756E6374696F6E28756E697175655F69642C65297B652E72656D6F766528293B746869735B275F616674'; wwv_flow_api.g_varchar2_table(26) := '65725F636C6F73655F272B756E697175655F69645D2865293B6966282428272E677269747465722D6974656D2D7772617070657227292E6C656E6774683D3D30297B24282723677269747465722D6E6F746963652D7772617070657227292E72656D6F76'; wwv_flow_api.g_varchar2_table(27) := '6528293B7D7D2C5F666164653A66756E6374696F6E28652C756E697175655F69642C706172616D732C756E62696E645F6576656E7473297B76617220706172616D733D706172616D737C7C7B7D2C666164653D28747970656F6628706172616D732E6661'; wwv_flow_api.g_varchar2_table(28) := '646529213D27756E646566696E656427293F706172616D732E666164653A747275653B666164655F6F75745F73706565643D706172616D732E73706565647C7C746869732E666164655F6F75745F73706565643B746869735B275F6265666F72655F636C'; wwv_flow_api.g_varchar2_table(29) := '6F73655F272B756E697175655F69645D2865293B696628756E62696E645F6576656E7473297B652E756E62696E6428276D6F757365656E746572206D6F7573656C6561766527293B7D0A69662866616465297B652E616E696D617465287B6F7061636974'; wwv_flow_api.g_varchar2_table(30) := '793A307D2C666164655F6F75745F73706565642C66756E6374696F6E28297B652E616E696D617465287B6865696768743A307D2C3330302C66756E6374696F6E28297B477269747465722E5F636F756E7452656D6F76655772617070657228756E697175'; wwv_flow_api.g_varchar2_table(31) := '655F69642C65293B7D297D297D0A656C73657B746869732E5F636F756E7452656D6F76655772617070657228756E697175655F69642C65293B7D7D2C5F686F76657253746174653A66756E6374696F6E28652C74797065297B696628747970653D3D276D'; wwv_flow_api.g_varchar2_table(32) := '6F757365656E74657227297B652E616464436C6173732827686F76657227293B7661722066696E645F696D673D652E66696E642827696D6727293B2866696E645F696D672E6C656E677468293F66696E645F696D672E6265666F726528746869732E5F74'; wwv_flow_api.g_varchar2_table(33) := '706C5F636C6F7365293A652E66696E6428277370616E27292E6265666F726528746869732E5F74706C5F636C6F7365293B652E66696E6428272E677269747465722D636C6F736527292E636C69636B2866756E6374696F6E28297B76617220756E697175'; wwv_flow_api.g_varchar2_table(34) := '655F69643D652E617474722827696427292E73706C697428272D27295B325D3B477269747465722E72656D6F7665537065636966696328756E697175655F69642C7B7D2C652C74727565293B7D293B7D0A656C73657B652E72656D6F7665436C61737328'; wwv_flow_api.g_varchar2_table(35) := '27686F76657227293B652E66696E6428272E677269747465722D636C6F736527292E72656D6F766528293B7D7D2C72656D6F766553706563696669633A66756E6374696F6E28756E697175655F69642C706172616D732C652C756E62696E645F6576656E'; wwv_flow_api.g_varchar2_table(36) := '7473297B6966282165297B76617220653D24282723677269747465722D6974656D2D272B756E697175655F6964293B7D0A746869732E5F6661646528652C756E697175655F69642C706172616D737C7C7B7D2C756E62696E645F6576656E7473293B7D2C'; wwv_flow_api.g_varchar2_table(37) := '5F726573746F72654974656D4966466164696E673A66756E6374696F6E28652C756E697175655F6964297B636C65617254696D656F757428746869735B275F696E745F69645F272B756E697175655F69645D293B652E73746F7028292E637373287B6F70'; wwv_flow_api.g_varchar2_table(38) := '61636974793A27277D293B7D2C5F72756E53657475703A66756E6374696F6E28297B666F72286F707420696E20242E677269747465722E6F7074696F6E73297B746869735B6F70745D3D242E677269747465722E6F7074696F6E735B6F70745D3B7D0A74'; wwv_flow_api.g_varchar2_table(39) := '6869732E5F69735F73657475703D313B7D2C5F7365744661646554696D65723A66756E6374696F6E28652C756E697175655F6964297B7661722074696D65725F7374723D28746869732E5F637573746F6D5F74696D6572293F746869732E5F637573746F'; wwv_flow_api.g_varchar2_table(40) := '6D5F74696D65723A746869732E74696D653B746869735B275F696E745F69645F272B756E697175655F69645D3D73657454696D656F75742866756E6374696F6E28297B477269747465722E5F6661646528652C756E697175655F6964293B7D2C74696D65'; wwv_flow_api.g_varchar2_table(41) := '725F737472293B7D2C73746F703A66756E6374696F6E28706172616D73297B766172206265666F72655F636C6F73653D28242E697346756E6374696F6E28706172616D732E6265666F72655F636C6F736529293F706172616D732E6265666F72655F636C'; wwv_flow_api.g_varchar2_table(42) := '6F73653A66756E6374696F6E28297B7D3B7661722061667465725F636C6F73653D28242E697346756E6374696F6E28706172616D732E61667465725F636C6F736529293F706172616D732E61667465725F636C6F73653A66756E6374696F6E28297B7D3B'; wwv_flow_api.g_varchar2_table(43) := '76617220777261703D24282723677269747465722D6E6F746963652D7772617070657227293B6265666F72655F636C6F73652877726170293B777261702E666164654F75742866756E6374696F6E28297B242874686973292E72656D6F766528293B6166'; wwv_flow_api.g_varchar2_table(44) := '7465725F636C6F736528293B7D293B7D2C5F7374725F7265706C6163653A66756E6374696F6E287365617263682C7265706C6163652C7375626A6563742C636F756E74297B76617220693D302C6A3D302C74656D703D27272C7265706C3D27272C736C3D'; wwv_flow_api.g_varchar2_table(45) := '302C666C3D302C663D5B5D2E636F6E63617428736561726368292C723D5B5D2E636F6E636174287265706C616365292C733D7375626A6563742C72613D7220696E7374616E63656F662041727261792C73613D7320696E7374616E63656F662041727261'; wwv_flow_api.g_varchar2_table(46) := '793B733D5B5D2E636F6E6361742873293B696628636F756E74297B746869732E77696E646F775B636F756E745D3D303B7D0A666F7228693D302C736C3D732E6C656E6774683B693C736C3B692B2B297B696628735B695D3D3D3D2727297B636F6E74696E'; wwv_flow_api.g_varchar2_table(47) := '75653B7D0A666F72286A3D302C666C3D662E6C656E6774683B6A3C666C3B6A2B2B297B74656D703D735B695D2B27273B7265706C3D72613F28725B6A5D213D3D756E646566696E65643F725B6A5D3A2727293A725B305D3B735B695D3D2874656D70292E'; wwv_flow_api.g_varchar2_table(48) := '73706C697428665B6A5D292E6A6F696E287265706C293B696628636F756E742626735B695D213D3D74656D70297B746869732E77696E646F775B636F756E745D2B3D2874656D702E6C656E6774682D735B695D2E6C656E677468292F665B6A5D2E6C656E'; wwv_flow_api.g_varchar2_table(49) := '6774683B7D7D7D0A72657475726E2073613F733A735B305D3B7D2C5F766572696679577261707065723A66756E6374696F6E28297B69662824282723677269747465722D6E6F746963652D7772617070657227292E6C656E6774683D3D30297B24282762'; wwv_flow_api.g_varchar2_table(50) := '6F647927292E617070656E6428746869732E5F74706C5F77726170293B7D7D7D7D2928617065782E6A5175657279293B'; null; end; / begin wwv_flow_api.create_plugin_file( p_id=>wwv_flow_api.id(9136570963231074884) ,p_plugin_id=>wwv_flow_api.id(11803512436077048971) ,p_file_name=>'apex.jquery.gritter.min.js' ,p_mime_type=>'text/javascript' ,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table) ); end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '2F2A0A202A204E6F74696669636174696F6E20506C75672D696E2076312E30202D20687474703A2F2F7777772E6F7261636C65617065782E696E666F2F0A202A200A202A204261736564206F6E206A5175657279204772697474657220687474703A2F2F'; wwv_flow_api.g_varchar2_table(2) := '626F6564657369676E2E636F6D2F626C6F672F323030392F30372F31312F67726F776C2D666F722D6A71756572792D677269747465722F0A202A0A202A204475616C206C6963656E73656420756E64657220746865204D495420616E642047504C206C69'; wwv_flow_api.g_varchar2_table(3) := '63656E7365733A0A202A202020687474703A2F2F7777772E6F70656E736F757263652E6F72672F6C6963656E7365732F6D69742D6C6963656E73652E7068700A202A202020687474703A2F2F7777772E676E752E6F72672F6C6963656E7365732F67706C'; wwv_flow_api.g_varchar2_table(4) := '2E68746D6C0A2A2F0A66756E6374696F6E20636F6D5F6F7261636C655F617065785F677269747465725F6E6F74696669636174696F6E28297B66756E6374696F6E2066286B297B76617220693D6E6577205265674578702822235C5C772B23222C226722'; wwv_flow_api.g_varchar2_table(5) := '292C672C6A2C683D6B3B7768696C6528673D692E65786563286B29297B6A3D247828675B305D2E7265706C616365282F232F672C222229293B6966286A297B683D682E7265706C61636528675B305D2C2476286A29297D7D72657475726E20687D766172'; wwv_flow_api.g_varchar2_table(6) := '20653D746869732E616374696F6E2E61747472696275746530312C623D746869732E616374696F6E2E61747472696275746530322C633D746869732E616374696F6E2E61747472696275746530332C613D2828746869732E616374696F6E2E6174747269'; wwv_flow_api.g_varchar2_table(7) := '6275746530343D3D3D225922293F747275653A66616C7365292C643D746869732E616374696F6E2E61747472696275746530353B617065782E6A51756572792E677269747465722E616464287B7469746C653A662865292C746578743A662862292C696D'; wwv_flow_api.g_varchar2_table(8) := '6167653A632C737469636B793A612C74696D653A642A313030307D297D3B'; null; end; / begin wwv_flow_api.create_plugin_file( p_id=>wwv_flow_api.id(10819972401969024216) ,p_plugin_id=>wwv_flow_api.id(11803512436077048971) ,p_file_name=>'com_oracle_apex_gritter_notification.min.js' ,p_mime_type=>'application/x-javascript' ,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table) ); end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '47494638396116001600E66200050505DDDDDDE1E1E1B7B7B7383838353535ACACACC1C1C13B3B3B7F7F7F5E5E5ECFCFCFE7E7E70C0C0C4545453232321D1D1D4A4A4A2828289797977C7C7CA8A8A8E4E4E4D3D3D39A9A9A373737646464313131898989'; wwv_flow_api.g_varchar2_table(2) := '4C4C4C3A3A3AEBEBEB6A6A6A7171716D6D6DFCFCFC202020CDCDCDEEEEEEF9F9F9E2E2E26E6E6E3333339D9D9D1717179B9B9BF3F3F34D4D4DCBCBCB3D3D3D2C2C2C8484849999993F3F3FE5E5E52222220808089191915C5C5C252525F0F0F0ADADAD96'; wwv_flow_api.g_varchar2_table(3) := '96961010103E3E3E6B6B6B686868C7C7C74040405A5A5ACACACA797979565656AFAFAFA3A3A3F8F8F88787877A7A7A141414D8D8D8BCBCBCAEAEAEC2C2C2606060949494707070808080838383F1F1F16262628B8B8BDFDFDF727272C4C4C42E2E2EF6F6'; wwv_flow_api.g_varchar2_table(4) := 'F6FFFFFF0202022E2E2E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021F904'; wwv_flow_api.g_varchar2_table(5) := '01000062002C00000000160016000007FF8062828305453E015F5F012D5305838F831B210260950C5B956002295E9082043D6027130E61A661055A5F604A1E900430600324A7B5611246600B089151602B00B6B6005760070F825CB2C1C2C254604D6205'; wwv_flow_api.g_varchar2_table(6) := '022E10A70F08B52C590DA63828021E0A6039A7329509A637166013A71A6041346004A724AB60093BEC601CA74E230604E0612B023E2C950C30335502D1136111966452682B49A20BC2247CC864459801451F6C49605069043A5B5D02540063CDD40F9260'; wwv_flow_api.g_varchar2_table(7) := '0C74C007E214001303848011718A40C26006C15438E5004C1502026C7433A501C4C202095A86812200889823FD9A351BC744D08303601468AD85E0C4810C83882C0043616C181D5F2B1674805403EC05244B894A31F6C293181514287D298101C310139A'; wwv_flow_api.g_varchar2_table(8) := '66A0F52B0881088189020C0811C35320003B'; null; end; / begin wwv_flow_api.create_plugin_file( p_id=>wwv_flow_api.id(11803517566228154921) ,p_plugin_id=>wwv_flow_api.id(11803512436077048971) ,p_file_name=>'gritter-close-ie6.gif' ,p_mime_type=>'image/gif' ,p_file_charset=>'utf-8' ,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table) ); end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '89504E470D0A1A0A0000000D494844520000025A000002120806000000145061EB0000001974455874536F6674776172650041646F626520496D616765526561647971C9653C0000183D4944415478DAECDD7B8C5D0581C7F133AF4E67987684694BB714'; wwv_flow_api.g_varchar2_table(2) := 'DA459E5254AC145808859414226E501A5C8998106ADA7F208A42220A289810374165FFD1440DB0A624B09180A96697260A5530F268BA509A4583427994472D954E3B9D5767F69CE9BDC36D295DD7DD9F4E3B9F4F723233771E4DCE1F27DFFEEE993B4DC5'; wwv_flow_api.g_varchar2_table(3) := '8135D58EE2BCF3CE6BEEEDED6DEAEFEF6F1A1818685AB972656B676767D377BFFBDDC1EAF353A74E1D9D366DDAE8238F3C3252FBDED1DAB15FA3A3A30500C0A1ACF50081D55C3B5A4E3CF1C4B6934E3AA9A37CDB598656EBE6CD9B475B5A5A0E6F6D6D6D'; wwv_flow_api.g_varchar2_table(4) := '29636BF382050B8A79F3E68D6EDAB46960E3C68DBBB66CD9325C7EDFEEF218A91DAA0A00105AB5C86AA98E993367B69D76DA699D175F7CF1AC534F3DF598F258DCDDDD7D6E5B5BDB99F52F5EB16245313C3CFC9FBDBDBD4FAE5FBF7EF5DB6FBFFDCC134F'; wwv_flow_api.g_varchar2_table(5) := '3CD13B3030305806D7502DB8768B2D0060B269DAE7E3FA8AD5367FFEFCF6D34F3F7DFA45175D74CCA73EF5A96BBBBABA2E6DFCC237DE7863A4BFBFBF5AB29A1B1FDFBE7DFB7D8B162DBAA1B3B373E0C5175FDCB96DDBB6EAA9C52AB8EAEBD6184F1D0200'; wwv_flow_api.g_varchar2_table(6) := '87BAE67DA2ABFA78CADCB9733BCE39E79C19575C71C587AFBCF2CA5555640D0D0D8D7EFFFBDF1FBAF0C20B77353535ED983D7B765F19637DD5FB6558F57DFBDBDF1E2AC36B74FAF4E9FFB461C386076EBFFDF6C5C71E7B6C77696AF5336B3FBBC9290700'; wwv_flow_api.g_varchar2_table(7) := '268BA686B7D5D3856D6528759C75D659472C5FBEFCD4CB2EBBECDE2A92D6AC59B37BC58A15FD9B366D3AE00C75D2492735AF5AB5AA7DE1C285D5CF2ACAEFBBE2F39FFFFC63AFBDF6DADBA5FE62CFB235F634A2450B0038D43537BCADE268CAFCF9F3BB97'; wwv_flow_api.g_varchar2_table(8) := '2C5972DCA5975E7A47F5F1DD77DF3DF4B18F7D6CD7FF145995E79E7B6EE48C33CED875DB6DB78DFD26E2D2A54B5795A175DA61871DD655EC59B55A0ACB1600308942ABFE9461DB8C19330E3BE79C738EFADCE73E77754B4BCB31D59255BE3FB07BF7EE3F'; wwv_flow_api.g_varchar2_table(9) := 'FB07565FFBD5AF7E75F07BDFFB5EB55E15575C71C5F59B376F9E56BEDB51FD1B420B00986CA1D5327DFAF4291FF8C007BA172D5A74FCE1871F7E715F5FDFC8F2E5CBFB1B23EB231FF948F3D9679FDDB2EF0F99356B5653F9B56D9D9D9DE38F7DE10B5F18'; wwv_flow_api.g_varchar2_table(10) := '28036BB8ABABEBACB56BD75E3677EEDC2AB6EAAB96D00200264568555A868787A71E79E4913D8B172F3EAF7AE0CE3BEFDCFDCA2BAF8C3F5DB860C182E675EBD6753EFAE8A31DB7DC72CB94FAE3C71E7B6CF3FAF5EB3B7FF8C31FB67FE73BDF69AF3F3E38'; wwv_flow_api.g_varchar2_table(11) := '3858945F375669A79C72CA79E5CFAA16ADEAF3AD420B00982CA155454F6B5B5BDBD49D3B777695B1F5A1EA13F7DC73CF70E317F6F6F68EEEDAB56BECFD9B6FBE794A155BC71F7F7CF3AF7EF5AB8E3973E68C85D3F6EDDBF7BA8FEBFEFBEF1FAE16B19E9E'; wwv_flow_api.g_varchar2_table(12) := '9EF3DE572A1F9A5A0BAD66A71E009834A13575EAD4CE32B68EE8E8E8F850195523BFF9CD6FF6BA31ABBA19FEB2CB2EDBD5185BEBD6AD1B8FAC071E7860F8CB5FFEF260E3F76CDDBA7574E3C68D638FAD5CB9F243D3A64D6B175A00C0A40AADAEAEAE9619'; wwv_flow_api.g_varchar2_table(13) := '336674CC9C397346F5E0EBAFBFBEDFDF30FCD9CF7EB6BB8AAD818181B18FCB701A8FACF2F1FEFDDD345F06DAD8DBF9F3E7CF1D1919A942CB3D5A00C0A409ADA20CA096A6A6A6B63294AAA7F68AA1A1A1F7FC86DFFFFEF7A33B76ECD82BC49E7DF6D991F7'; wwv_flow_api.g_varchar2_table(14) := 'FACDC4FAE35564EDDCB9B3A578E7251E00000EFDD0EAEBEB6B7AF3CD378BE79F7F7EEC79C1D9B367EFF78BAB17247DE491473A7A7A7A9A1A23EAA69B6E9AD278837CA33973E68CFDD99D175F7CB1B7A3A3C38DF000C0E40AADCAB66DDBAADF32EC1B1A1A'; wwv_flow_api.g_varchar2_table(15) := 'DA72C41147B4CC9D3B77AF20EAEEEE6EAA22EBC8238F1C7FBAF0939FFCE45EF76C5D7DF5D56D8DDFD3D2D252C5D9D81FAE7EE8A187360F0F0F3BE300C0A40BADEAA9C091CECECEE1975F7EF9B9EA8165CB96B5367EE1C9279FDCDC1859D53D59AB57AFDE'; wwv_flow_api.g_varchar2_table(16) := 'DD7883FCB9E79EBBD76B6C2D59B2A47A7DAED637DE78E3D9679E79E64F65C4EDAEFD5B00009326B4AA002A3B68A8FF273FF9C9EFAA076EB8E18696C61720AD7E0B71E5CA9503D75C73CD40E38DEFD50DF28B172FEEBBF5D65B07BFF8C52F0E34FEF01B6F'; wwv_flow_api.g_varchar2_table(17) := 'BC712CAA9E7CF2C917CB37D5E7866BFFD688530F001CEAC65EDAA13CBACB63567B7BFBDFCF9C3973C1E38F3F7EF99C39733E7CFBEDB70F5E7FFDF5837FC90FBEF2CA2B5BEFBAEBAEA93B76EC786DFEFCF9FFB275EBD6A7CB87AB5F41DC521E3B464747FB'; wwv_flow_api.g_varchar2_table(18) := '9D7E00E050562D5AD5EA542D4DD54AD5DBD7D7B7F56B5FFBDA13D527AFBBEEBA295530FD6F7F68F5677A7EF0831F8CDD1CFFA31FFDE8F132B2DE2CDFDD59FD1BB57FCBA205001CF2EAAF6935F6B20B2323236D838383535F79E59596C30E3B6CFBE9A79F'; wwv_flow_api.g_varchar2_table(19) := '7EF2273EF189D6D1D1D162EDDAB57FD65F96FEEC673FDBFAE31FFFB87DCA9429CDBFFEF5AF9F5CB66CD99AF2E157CAA38AADB76BB135F4F5AF7F5D6C01009322B49A6B474B1955ADFDFDFDAD8F3DF6D848195B7F5AB468D189E79F7F7ECBE5975F3EBA65'; wwv_flow_api.g_varchar2_table(20) := 'CB96E6175E7861647FAFB3B574E9D29655AB56355F73CD351DADADAD4D6564AD3FFBECB3FFBDFCD44BE5F17A796C2D8F1DC59E7BB57697A1E5A67800E090D654BC739F56F5AAED5DE551BD3AFC512D2D2DF3BABABA8E2D03EBE41B6FBCF1E4A38E3AEAF8'; wwv_flow_api.g_varchar2_table(21) := 'EA1B060606467EFBDBDF0E3FF5D45363A1F4C10F7EB038E18413C67EBBB0FAF8ADB7DEDA7CD75D77FDEEBAEBAE7BBCFCF00FC59EFBB25E2D8F3F3686561974162D00E0900FAD4A4B2DB6AA57869F5E8BADBF2B636B6E7B7BFBD17D7D7D47DD71C71D277C'; wwv_flow_api.g_varchar2_table(22) := 'FCE31F9FF1FEF7BFFFC4FDFDA0975E7AE90FBFF8C52FB6AE58B162E3D0D050F554E1CBC59EA70C5FAB45D6F6A2E11EADD1EAF948008049105AF5FBB4DA6AB135AD3C8E288F236BC7EC8E8E8E59BB76ED3AA2BBBBFB7D1FFDE847679E79E6998757DFB87E'; wwv_flow_api.g_varchar2_table(23) := 'FDFAB79F7EFAE93FBEFAEAABD553836F157BEEC5AA9E2A7CA376548FF5D622AB7ACE71ECB5B4741600305942AB31B6AADF16AC3F8D58BDEC4315543DB5F07A5FF5786B6B6B47F9B6B57AA5F7F2FDE19191915DE5513D2DF8A75A5855D1B5ADD873F37BFD'; wwv_flow_api.g_varchar2_table(24) := 'E9C2C17A64157B4ACBD907000E698D2FDD30F6EAF0B520AABF5F2D50D5CBBEF7D6E2A98AAFCE32B0DA6B515694EFEFAE85545F2DAA7A6BC7CEDAF70ED67ECE48E155E10180491A5A45430CD5436BB816515534550B551558536ADFD7DCF03DC3B5A01A68'; wwv_flow_api.g_varchar2_table(25) := '38066B8F0F8B2C004068EDD1B86C0DD5A26947F1CE4B40D47F5371DFEFA97FDF48C3FBA30D9F070098F4A155EC1348F5976168FA337FA6A80200384068558E2E8F8BCAE38CF298531EB3FE3FFFE1A6A626671F6854DDE759BDEEDE86F278B83C9EDCEFFF'; wwv_flow_api.g_varchar2_table(26) := 'E4DEFB1769A2D72C80BFE49AB5BFDAA97ECBF0EAF2F8C7E29DFBB000FEDAAA0BD76DC59EFB430F145AAE59C084BD66ED1B5AC795C71DE531DBF9022680EA82F5CDF2F8F97B84D65ED7AC071F7CB0B8F7DE7B8B75EBD615CF3FFFBCB307C4747777170B17'; wwv_flow_api.g_varchar2_table(27) := '2E2C2EBDF4D2E2D39FFE74D1D3D3B3DF6B5663685553FBBFD6FE77083091DC521EABF709ADF16BD62F7FF9CBE24B5FFA52F1D4534F3953C05FDD31C71C53DC79E79DC592254BDE75CDAACFECD5DB7F1659C004F595F238A1E1E3F16BD69A356B8AC58B17'; wwv_flow_api.g_varchar2_table(28) := '8B2CE06FE6A5975E2A2EB8E082E21BDFF8C6BBAE59F5D0AAEE6D38D9A90226A8EACF835DDDF0F1D835EBD9679F1D9BED0126829B6FBEB9B8FFFEFBF7BA66D543EB72A70798E0FEA1E13F8463D7ACBBEFBEBBD8B973A733034C18575D7555F1EAABAF8E5F'; wwv_flow_api.g_varchar2_table(29) := 'B3AAD0AA7E25FA38A70638089C5FBF66BDFCF2CBC5B7BEF52D67049850B66FDF5EFCFCE7E3F7C29F5F85D6294E0B709038A97ECDDAB06183B3014C480F3DF4D0F835AB0AAD1EA7043848CCAA5FB3DE7CF34D67039890366DDA347ECDAA42ABCD29010E22'; wwv_flow_api.g_varchar2_table(30) := '63D7AC818101670298F0BC8A327050F267BC00A105107280BF790820B400FE2F2C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(31) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(32) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(33) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(34) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(35) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(36) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(37) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(38) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(39) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(40) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(41) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(42) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(43) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(44) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(45) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(46) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(47) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(48) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(49) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(50) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(51) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(52) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(53) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(54) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(55) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(56) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(57) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(58) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(59) := '108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80108B1620B400422C5A80D00208B16801420B20C4A205082D80'; wwv_flow_api.g_varchar2_table(60) := '108B1620B400422C5A80D00208B16801420B20C4A2051C2CA1F5B0D3001C241EAD5FB32EBCF04267039890962F5F3E7ECDAA426B53793CEFB400078187EBD7AC79F3E615D75E7BAD33024C28EDEDEDC505175C307ECDAA3F75F86F4E0D30C13D5E1E1B1B'; wwv_flow_api.g_varchar2_table(61) := 'AF59575D75553165CA1467069830EEB9E79EE2E8A38F1EBF66D543EBC1F2F82FA70798A086CAE35F1A3E1EBB662D58B0A058BD7AB5B3034C0837DD7453B16CD9B2BDAE59F5D01A298FAF94C736A7099880BE591EBF6BF878FC9AB574E9D262EDDAB5C5C2'; wwv_flow_api.g_varchar2_table(62) := '850B9D25E06F62EEDCB9C59A356B8A5B6FBDF55DD7AC7D7F6DE7B8F2B8A33C663B6DC004B0A376C1FA8FFA03FBBCACC3F8356B6868A8F8E94F7F5ADC77DF7DC5134F3C51BCF0C20BCE1E10D3D9D9599C79E699C525975C527CE6339F297A7A7AF67BCDDA'; wwv_flow_api.g_varchar2_table(63) := 'DFEF471F5E1E5797C7254E23F037F470ED82B5B5F1C1FDBC7E966B163061AF59077A219AEA4EAE8BCAE38CDAFB3DCE211034501E7F288F0DE5B1B6D87323E9BB1CE0854A5DB3800977CDFA6F01060077AEF42CD62CA82D0000000049454E44AE426082'; null; end; / begin wwv_flow_api.create_plugin_file( p_id=>wwv_flow_api.id(11803518359543157909) ,p_plugin_id=>wwv_flow_api.id(11803512436077048971) ,p_file_name=>'gritter-long.png' ,p_mime_type=>'image/png' ,p_file_charset=>'utf-8' ,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table) ); end; / begin wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table; wwv_flow_api.g_varchar2_table(1) := '89504E470D0A1A0A0000000D494844520000025A000001360806000000B9853C560000001974455874536F6674776172650041646F626520496D616765526561647971C9653C000012B24944415478DAECDD7D8C55F59DC7F13373E799815186A7C55158'; wwv_flow_api.g_varchar2_table(2) := 'EA03546C6BA98AAB111A0C986AA342D09ADAAC918DA4894DABB5896EC556D298FEA1AD4DAC7FA851D768A29B1A75699385A42AEA6A4509AB404A0D6DA13C28285299618679BC7B7EC3BDE305D1ADBBF9D68179BD9213980B3326E78F93B79F7BEEA12AFB'; wwv_flow_api.g_varchar2_table(3) := '6455A5239B3B776E757B7B7BD5810307AABABBBBAB962E5D5AD3D4D45475EFBDF7F6A43F6F6868288E1E3DBAF8FCF3CF0F94BEB7583A8EA8582C660000C7B29A4F08ACEAD25138EDB4D36AA74F9FDE98FFDA948756CDCE9D3B8B8542E1F89A9A9A421E5B'; wwv_flow_api.g_varchar2_table(4) := '3B67CE9C994D9932A5B875EBD6EE8D1B3776BDFBEEBB7DF9F7F5E7C740E9505500C08853F531AF15D2317EFCF8DA33CF3CB3E9E28B2F9E70C619679C941F735A5A5A2EA8ADAD9D5DF90D7D7D7DFFDDDEDEFEDABA75EB56FCF297BF7C73CD9A35EDDDDDDD'; wwv_flow_api.g_varchar2_table(5) := '3D7970F59682ABFFF0D8B2680100232DB4CA2B56EDD4A953EBCF3AEBAC31175D74D149575C71C50DCDCDCD0B2BFFE2AE5DBB060E1C389096ACEACAD7F7EDDBF7C4D9679F7D4B535353F7962D5BF6EFDDBB37BDB59882ABBC6E092D006044A83E2CBAD2D7'; wwv_flow_api.g_varchar2_table(6) := '756D6D6D8DE79F7FFEB8ABAFBEFA4BD75C73CDA329B27A7B7B8BF7DD775FEF82050BBAAAAAAA3A264D9AD499C75867FA7D1E569D3FFBD9CF7AF3F02A8E1933E6CAF5EBD73F75E79D77CE99366D5A4BAE21FDCCD2CFAE72CA018091A2AAE2D7F476616D1E'; wwv_flow_api.g_varchar2_table(7) := '4A8DE79E7BEED8254B969CB178F1E2C75324AD5AB5AAFFBAEBAE3BB075EBD64F9CA1A64F9F5EFDE8A38FD6CF9A352BFDAC2CFFBEABBFFBDDEFFED7DB6FBFFD41EE407670D91A7C1BD1A205001CEBAA2B7E4D71543775EAD49679F3E69DBC70E1C2BBD3D7'; wwv_flow_api.g_varchar2_table(8) := '0F3FFC70EFD7BEF6B5AEFF2DB2924D9B360D9C73CE395D77DC71C7E02711E7CF9FFF681E5A678E1A35AA393BB86A1532CB16003042941FDF903E7D583F6EDCB831575C71C5B49FFCE427371F7FFCF117A7252B45567F7FFFA7FEC1F7DE7B6FFDB7BFFDED'; wwv_flow_api.g_varchar2_table(9) := 'DA8E8E8E57468F1EFD2FF94BEFE747477E74E7477FB1581C70FA01806359795D2A8C1933A6EEF39FFF7CCBD9679F7D4A8AACCECECE81254B961CA88CAC2F7FF9CBD5E79D775EE1F01F3261C284AAFCEFD63635350DBDF6BDEF7DAF7BE7CE9D7DCDCDCDE7'; wwv_flow_api.g_varchar2_table(10) := 'AE5EBD7A715B5BDBE8ECC355CBA205008C88D04A0A7D7D7D0D13274E6C9D3367CEDCF4C2830F3ED8BF7DFBF6A1B70B67CE9C59BD76EDDAA6975E7AA9F1F6DB6FAF2BBF3E6DDAB4EA75EBD6353DF0C003F53FFFF9CFEBCBAFF7F4F464F9DF1BACB4D34F3F'; wwv_flow_api.g_varchar2_table(11) := '7D6EFEB31AF3DFA63FAF115A00C04809ADC1B70E6B6B6B1BF6EFDFDF9CC7D617D31F3CF6D8637D957FB1BDBDBDD8D5D535F8FBDB6EBBAD2EC5D629A79C52FDE28B2F364E9E3C79309CF6EDDB77C87D5C4F3EF9645F5AC45A5B5BE71E97CB5F6A288556B5'; wwv_flow_api.g_varchar2_table(12) := '530F008C98D06A686868CA636B6C6363E317F3A81AF8DDEF7E77C88D59E966F8C58B177755C6D6DAB56B8722EBA9A79EEABBF9E69B7B2ABF67CF9E3DC58D1B370EBEB674E9D22F8E1E3DBA5E680100232AB49A9B9B0BE3C68D6B1C3F7EFCB8F4E23BEFBC'; wwv_flow_api.g_varchar2_table(13) := '73C44F18FEE637BFE94FB1D5DDDD3DF8751E4E439195BF7EE04837CDE78136F8EBD4A953DB0606065268B9470B001831A195E50154A8AAAAAACD4329BDB597F5F6F67EEC37FCF18F7F2C7674741C12621B366C18F8B84F26965F4F91B57FFFFE42F6E123'; wwv_flow_api.g_varchar2_table(14) := '1E00008EFDD0EAECECACDABD7B77B679F3E6C1F705274D9A74C4BF9C1E48FAFCF3CF37B6B6B6565546D4B265CBEA2A6F90AF3479F2E4C1C7386CD9B2A5BDB1B1D18DF000C0C80AAD64EFDEBDE953869DBDBDBDEF8E1D3BB6D0D6D6764810B5B4B454A5C8'; wwv_flow_api.g_varchar2_table(15) := '9A3871E2D0DB85975F7EF921F76C5D7FFDF5B595DF532814529CA5B8CA56AE5CB9B3AFAFCF190700465C68A5B702079A9A9AFAB66DDBB629BDB068D1A29ACABF3863C68CEACAC84AF764AD58B1A2BFF206F90B2EB8E090676CCD9B372F3D9FAB66D7AE5D'; wwv_flow_api.g_varchar2_table(16) := '1BDE7CF3CDBFE611D75FFA6F01008C98D04A01947750EF81679E79E6ADF4C22DB7DC52A87C0069FA14E2D2A54BBBBFF39DEF7457DEF89E6E909F33674EE7F2E5CB7B6EBCF1C6EECA1F7EEBADB70E46D56BAFBDB6253BF844F8BED27FCB53E10180635EF9'; wwv_flow_api.g_varchar2_table(17) := '9FDF69C98F09F5F5F5FF387EFCF899AFBEFAEA5593274FFED29D77DED9F3831FFCA0E7FFF283AFB9E69A9A871E7AA8A1A3A3E3EDA953A7FE62CF9E3D6FE42FA78F20BE9B1F1DC562F180D30F001CCBD2A29556A7B434A595AABDB3B373CF8F7EF4A335E9'; wwv_flow_api.g_varchar2_table(18) := '0F6FBAE9A6BA144C9FF687A67FA6E7FEFBEF1FBC39FE91471E79358FACDDF96FF7A7FF46E9BF65D102008E79E5675A0D3E76616060A0B6A7A7A761FBF6ED8551A346ED3BEBACB3665C76D96535C562315BBD7AF5DFF42F4B7FEB5BDFAAF9D5AF7E555F57'; wwv_flow_api.g_varchar2_table(19) := '5757FDF2CB2FBFB668D1A255F9CBDBF323C5D607A5D8EAFDF18F7F2CB60080635AE53D5AE91EAA8EFEFEFE3DEFBDF7DEDB3FFCE10F7F7FCF3DF7FC47FAC3F4E8864D9B36D55E79E5953595F76D559A3F7F7EE195575E293CF2C8230DF5F5F529B2D69D77'; wwv_flow_api.g_varchar2_table(20) := 'DE792BF33F7A273FF6A69F9D7D789F961BE20180635E55F6E17D5AE9A9EDCDF9919E0E7F42A15098D2DCDC3CEDAAABAE9A71EBADB7CE38E184134E49DFD0DDDD3DF0873FFCA1EFF5D75F1F8CA52F7CE10BD9A9A79E3AF8E9C2F4F5FBEFBFBFF3A1871E7A'; wwv_flow_api.g_varchar2_table(21) := 'EBA69B6E7A35FFF24FD9C1FBB276E4C77B15B1D55F2C162D5A00C0311F5A49A1145BE9C9F0634AB1F50F796CB5D5D7D79FD8D9D979C2DD77DF7DEA25975C32EE739FFBDC6947FA417FF9CB5FFEF4ECB3CFEEB9EEBAEB36F6F6F6A6B70AB76507DF327CBB'; wwv_flow_api.g_varchar2_table(22) := '1459FBB28A7BB48AE9FD48008011105AE5FBB46A4BB1353A3FC6E6C7C4D231A9B1B171425757D7D8969696E3BEF295AF8C9F3D7BF6F1E91BD7AD5BF7C11B6FBCF1DE8E1D3BF6E45FBE9F1DBC172BBD5DB8AB74A4D7DA4B9195FE6D9FC16769E92C0060A4'; wwv_flow_api.g_varchar2_table(23) := '8456656CA54F0B96DF464C8F7D4841D55A0AAFE3D2EB3535358DF9AF35E949EFF9EFFB060606BAF223BD2DF8D75258A5E84AF765A59BDFCB6F17F694232B3B585ACE3E003062422BA92E1DB5A5E04A41352A3BB8708D2EC5575329C4CA4F812FDF48DF59'; wwv_flow_api.g_varchar2_table(24) := '8AAAF6D2911EE7D0550AACB4640D64158F75105A00C0480BADF26B29B66A4A4779E12A1F75A5D7CB9F584CF1D4570AAAEE8AA3A7F47AF9B959879495D0020046626855BE5E8EAEF2AFE5DF1FFE7DC5D2315011559571F591AA125A00C0480DADFFCFDFFD'; wwv_flow_api.g_varchar2_table(25) := '9B0A4A6801002339B44ECC8F8BF2E39CFC989C1F139C2E2050BACF333D776F7D7E3C971FAF7DCAFF4973CD0286DD35EB48A1953E65787D7E7C3DFBF03E2C80BFB774E1BA233BF809E64F0A2DD72C60D85EB30E0FAD93F3E3EEFC98E47C01C340BA60FD34'; wwv_flow_api.g_varchar2_table(26) := '3F7EFB31A175C835EBE9A79FCE1E7FFCF16CEDDAB5D9E6CD9B9D3D204C4B4B4B366BD6AC6CE1C285D937BEF18DACB5B5F588D7ACCAD04A53FBBF95FEEF106038B93D3F561C165A43D7AC175E7821FBFEF7BF9FBDFEFAEBCE14F07777D24927650F3EF860'; wwv_flow_api.g_varchar2_table(27) := '366FDEBC8F5CB3CAA1555DBA60CD70BA8061283D8BEF9FF3E3AD52680D5DB356AD5A952D58B0C019023E73CB972FCF962D5B76C835AB7C3FC3D74516308CA587285F5FF1F5E0356BC3860D83B33DC07070DB6DB7654F3EF9E421D7AC72685DE5F400C3DC'; wwv_flow_api.g_varchar2_table(28) := '3F55FC0FE1E035EBE1871FCEF6EFDFEFCC00C3C6B5D75E9BEDD8B163E89A95422B7D24FA64A706380A7CB57CCDDAB66D5B76D75D773923C0B0B26FDFBEECB7BF1DBA17FEAB29B44E775A80A3C4F4F2356BFDFAF5CE06302CAD5CB972E89A9542ABD52901'; wwv_flow_api.g_varchar2_table(29) := '8E1213CAD7ACDDBB773B1BC0B0B475EBD6A16B560AAD5AA704388A0C5EB3BABBBB9D0960D8F31465E0A8545555E52400420B20827F981E105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801'; wwv_flow_api.g_varchar2_table(30) := '420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B1'; wwv_flow_api.g_varchar2_table(31) := '6801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D406801'; wwv_flow_api.g_varchar2_table(32) := '04B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40'; wwv_flow_api.g_varchar2_table(33) := '680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D802016'; wwv_flow_api.g_varchar2_table(34) := '2D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D80'; wwv_flow_api.g_varchar2_table(35) := '20162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A20508'; wwv_flow_api.g_varchar2_table(36) := '2D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A2'; wwv_flow_api.g_varchar2_table(37) := '05082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510'; wwv_flow_api.g_varchar2_table(38) := 'C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A1'; wwv_flow_api.g_varchar2_table(39) := '0510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B4'; wwv_flow_api.g_varchar2_table(40) := '00A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B40082'; wwv_flow_api.g_varchar2_table(41) := '58B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4'; wwv_flow_api.g_varchar2_table(42) := '008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B16'; wwv_flow_api.g_varchar2_table(43) := '20B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D10284164010'; wwv_flow_api.g_varchar2_table(44) := '8B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D1028416'; wwv_flow_api.g_varchar2_table(45) := '40108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102841640108B1620B4008258B400A10510C4A205082D8020162D40680104B16801420B2088450B105A00412C5A80D0020862D102'; wwv_flow_api.g_varchar2_table(46) := '841640108B1670B484D6734E03709478A97CCD5AB06081B3010C4B4B962C19BA66A5D0DA9A1F9B9D16E028F05CF99A3565CA94EC861B6E70468061A5BEBE3EBBF0C20B87AE59E5B70EFFDDA90186B957F36363E535EBDA6BAFCDEAEAEA9C1960D878ECB1'; wwv_flow_api.g_varchar2_table(47) := 'C7B2134F3C71E89A550EADA7F3E3F74E0F304CF5E6C72F2ABE1EBC66CD9C39335BB16285B3030C0BCB962DCB162D5A74C835AB1C5A03F9F1AFF9B1D7690286A19FE6C75B155F0F5DB3E6CF9F9FAD5EBD3A9B356B96B3047C26DADADAB255AB5665CB972F'; wwv_flow_api.g_varchar2_table(48) := 'FFC835EBF08FED9C9C1F77E7C724A70D18063A4A17ACFF2CBF70D8631D86AE59BDBDBDD9AF7FFDEBEC89279EC8D6AC5993FDF9CF7F76F680304D4D4DD9ECD9B3B34B2FBD34FBE637BF99B5B6B61EF19A75A4CF471F9F1FD7E7C7A54E23F0197AAE74C1DA'; wwv_flow_api.g_varchar2_table(49) := '53F9E2119E9FE59A050CDB6BD6273D8826DDC975517E9C53FA7DAB730804EACE8F3FE5C7FAFC589D1DBC91F4233EE141A5AE59C0B0BB66FD8F000300CED29779978A694F0000000049454E44AE426082'; null; end; / begin wwv_flow_api.create_plugin_file( p_id=>wwv_flow_api.id(11803519156308159490) ,p_plugin_id=>wwv_flow_api.id(11803512436077048971) ,p_file_name=>'gritter.png' ,p_mime_type=>'image/png' ,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(7917789640752017529) ,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.:1:&SESSION.' ,p_navigation_list_id=>wwv_flow_api.id(7917747218966017443) ,p_navigation_list_position=>'TOP' ,p_navigation_list_template_id=>wwv_flow_api.id(7917782892391017488) ,p_nav_list_template_options=>'#DEFAULT#' ,p_nav_bar_type=>'LIST' ,p_nav_bar_list_id=>wwv_flow_api.id(7917789531021017529) ,p_nav_bar_list_template_id=>wwv_flow_api.id(7917781716382017487) ,p_nav_bar_template_options=>'#DEFAULT#' ); end; / prompt --application/user_interfaces/combined_files begin null; end; / prompt --application/pages/page_00001 begin wwv_flow_api.create_page( p_id=>1 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Home' ,p_page_mode=>'NORMAL' ,p_step_title=>'Home' ,p_step_sub_title=>'Home' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_dialog_chained=>'Y' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_upd_yyyymmddhh24miss=>'20150611185806' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(7917790405445017537) ,p_plug_name=>'Breadcrumbs' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); end; / prompt --application/pages/page_00010 begin wwv_flow_api.create_page( p_id=>10 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Component Actions' ,p_page_mode=>'NORMAL' ,p_step_title=>'Component Actions' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20150613205726' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(7918244375488261664) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); end; / prompt --application/pages/page_00011 begin wwv_flow_api.create_page( p_id=>11 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Simple Hide/Show' ,p_page_mode=>'NORMAL' ,p_step_title=>'Simple' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20150613205044' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(7918431778918126616) ,p_plug_name=>'Region' ,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader:t-Region--scrollBody:t-Form--xlarge' ,p_plug_template=>wwv_flow_api.id(7917763654291017471) ,p_plug_display_sequence=>10 ,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_plug( p_id=>wwv_flow_api.id(7919257044607427272) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(7918431916883126618) ,p_button_sequence=>10 ,p_button_plug_id=>wwv_flow_api.id(7918431778918126616) ,p_button_name=>'HIDE' ,p_button_action=>'DEFINED_BY_DA' ,p_button_template_options=>'#DEFAULT#:t-Button--iconRight:t-Button--pillStart' ,p_button_template_id=>wwv_flow_api.id(7917784585387017494) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Hide' ,p_button_position=>'REGION_TEMPLATE_NEXT' ,p_icon_css_classes=>'fa-minus' ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(7918432024076126619) ,p_button_sequence=>20 ,p_button_plug_id=>wwv_flow_api.id(7918431778918126616) ,p_button_name=>'SHOW' ,p_button_action=>'DEFINED_BY_DA' ,p_button_template_options=>'#DEFAULT#:t-Button--iconRight:t-Button--pillEnd' ,p_button_template_id=>wwv_flow_api.id(7917784585387017494) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Show' ,p_button_position=>'REGION_TEMPLATE_NEXT' ,p_icon_css_classes=>'fa-plus' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(7918431890307126617) ,p_name=>'P11_ITEM' ,p_item_sequence=>10 ,p_item_plug_id=>wwv_flow_api.id(7918431778918126616) ,p_prompt=>'Item' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>30 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,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_da_event( p_id=>wwv_flow_api.id(7918432113863126620) ,p_name=>'Hide Item' ,p_event_sequence=>10 ,p_triggering_element_type=>'BUTTON' ,p_triggering_button_id=>wwv_flow_api.id(7918431916883126618) ,p_bind_type=>'bind' ,p_bind_event_type=>'click' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7918432282701126621) ,p_event_id=>wwv_flow_api.id(7918432113863126620) ,p_event_result=>'TRUE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_HIDE' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P11_ITEM' ,p_attribute_01=>'N' ); wwv_flow_api.create_page_da_event( p_id=>wwv_flow_api.id(7918432374222126622) ,p_name=>'Show Item' ,p_event_sequence=>20 ,p_triggering_element_type=>'BUTTON' ,p_triggering_button_id=>wwv_flow_api.id(7918432024076126619) ,p_bind_type=>'bind' ,p_bind_event_type=>'click' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7918432436083126623) ,p_event_id=>wwv_flow_api.id(7918432374222126622) ,p_event_result=>'TRUE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_SHOW' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P11_ITEM' ,p_attribute_01=>'N' ); end; / prompt --application/pages/page_00020 begin wwv_flow_api.create_page( p_id=>20 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Hide/Show Items' ,p_page_mode=>'NORMAL' ,p_step_title=>'Hide/Show Items' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_dialog_chained=>'Y' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20150615011400' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(7918312006149272300) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(7918430264349126601) ,p_plug_name=>'Next Approver' ,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody:t-Form--xlarge' ,p_plug_template=>wwv_flow_api.id(7917763654291017471) ,p_plug_display_sequence=>10 ,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(7918430537499126604) ,p_button_sequence=>10 ,p_button_plug_id=>wwv_flow_api.id(7918430264349126601) ,p_button_name=>'USER_BTN' ,p_button_action=>'DEFINED_BY_DA' ,p_button_template_options=>'#DEFAULT#:t-Button--iconRight' ,p_button_template_id=>wwv_flow_api.id(7917784585387017494) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Switch to Enter User' ,p_button_position=>'REGION_TEMPLATE_NEXT' ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(7918430612025126605) ,p_button_sequence=>20 ,p_button_plug_id=>wwv_flow_api.id(7918430264349126601) ,p_button_name=>'USER_LIST_BTN' ,p_button_action=>'DEFINED_BY_DA' ,p_button_template_options=>'#DEFAULT#:t-Button--iconRight' ,p_button_template_id=>wwv_flow_api.id(7917784585387017494) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Switch to Select User' ,p_button_position=>'REGION_TEMPLATE_NEXT' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(7918430394852126602) ,p_name=>'P20_USER' ,p_item_sequence=>10 ,p_item_plug_id=>wwv_flow_api.id(7918430264349126601) ,p_prompt=>'Enter User' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>15 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,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(7918430495209126603) ,p_name=>'P20_USER_LIST' ,p_item_sequence=>20 ,p_item_plug_id=>wwv_flow_api.id(7918430264349126601) ,p_prompt=>'Select User' ,p_display_as=>'NATIVE_SELECT_LIST' ,p_lov=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'select ename as d, ', ' empno as r', ' from emp ', ' order by 1')) ,p_lov_display_null=>'YES' ,p_cHeight=>1 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,p_item_template_options=>'#DEFAULT#' ,p_lov_display_extra=>'YES' ,p_attribute_01=>'NONE' ,p_attribute_02=>'N' ); wwv_flow_api.create_page_da_event( p_id=>wwv_flow_api.id(7918430754350126606) ,p_name=>'Show Single User' ,p_event_sequence=>10 ,p_triggering_element_type=>'BUTTON' ,p_triggering_button_id=>wwv_flow_api.id(7918430537499126604) ,p_bind_type=>'bind' ,p_bind_event_type=>'click' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7918430843776126607) ,p_event_id=>wwv_flow_api.id(7918430754350126606) ,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=>'P20_USER' ,p_attribute_01=>'N' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7918430952882126608) ,p_event_id=>wwv_flow_api.id(7918430754350126606) ,p_event_result=>'TRUE' ,p_action_sequence=>20 ,p_execute_on_page_init=>'Y' ,p_action=>'NATIVE_HIDE' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P20_USER_LIST' ,p_attribute_01=>'N' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7918431544178126614) ,p_event_id=>wwv_flow_api.id(7918430754350126606) ,p_event_result=>'TRUE' ,p_action_sequence=>30 ,p_execute_on_page_init=>'Y' ,p_action=>'NATIVE_SHOW' ,p_affected_elements_type=>'BUTTON' ,p_affected_button_id=>wwv_flow_api.id(7918430612025126605) ,p_attribute_01=>'N' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7918431435338126613) ,p_event_id=>wwv_flow_api.id(7918430754350126606) ,p_event_result=>'TRUE' ,p_action_sequence=>40 ,p_execute_on_page_init=>'Y' ,p_action=>'NATIVE_HIDE' ,p_affected_elements_type=>'BUTTON' ,p_affected_button_id=>wwv_flow_api.id(7918430537499126604) ,p_attribute_01=>'N' ); wwv_flow_api.create_page_da_event( p_id=>wwv_flow_api.id(7918431020711126609) ,p_name=>'Show Select List' ,p_event_sequence=>20 ,p_triggering_element_type=>'BUTTON' ,p_triggering_button_id=>wwv_flow_api.id(7918430612025126605) ,p_bind_type=>'bind' ,p_bind_event_type=>'click' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7918431155822126610) ,p_event_id=>wwv_flow_api.id(7918431020711126609) ,p_event_result=>'TRUE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_SHOW' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P20_USER_LIST' ,p_attribute_01=>'N' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7918431228571126611) ,p_event_id=>wwv_flow_api.id(7918431020711126609) ,p_event_result=>'TRUE' ,p_action_sequence=>20 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_HIDE' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P20_USER' ,p_attribute_01=>'N' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7918431611894126615) ,p_event_id=>wwv_flow_api.id(7918431020711126609) ,p_event_result=>'TRUE' ,p_action_sequence=>30 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_SHOW' ,p_affected_elements_type=>'BUTTON' ,p_affected_button_id=>wwv_flow_api.id(7918430537499126604) ,p_attribute_01=>'N' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7918431375523126612) ,p_event_id=>wwv_flow_api.id(7918431020711126609) ,p_event_result=>'TRUE' ,p_action_sequence=>40 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_HIDE' ,p_affected_elements_type=>'BUTTON' ,p_affected_button_id=>wwv_flow_api.id(7918430612025126605) ,p_attribute_01=>'N' ); end; / prompt --application/pages/page_00025 begin wwv_flow_api.create_page( p_id=>25 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Hide/Show Conditional' ,p_page_mode=>'NORMAL' ,p_step_title=>'Hide/Show Conditional' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_dialog_chained=>'Y' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_protection_level=>'C' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20150614162622' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8004285560205160294) ,p_plug_name=>'Employees' ,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody' ,p_plug_template=>wwv_flow_api.id(7917763654291017471) ,p_plug_display_sequence=>0 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'BODY' ,p_plug_query_row_template=>1 ,p_attribute_01=>'N' ,p_attribute_02=>'TEXT' ,p_attribute_03=>'Y' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8004302489770160558) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(8004286088816160295) ,p_button_sequence=>30 ,p_button_plug_id=>wwv_flow_api.id(8004285560205160294) ,p_button_name=>'SAVE' ,p_button_action=>'SUBMIT' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_api.id(7917784434352017494) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Apply Changes' ,p_button_position=>'REGION_TEMPLATE_CHANGE' ,p_button_condition=>'P25_EMPNO' ,p_button_condition_type=>'ITEM_IS_NOT_NULL' ,p_grid_new_grid=>false ,p_database_action=>'UPDATE' ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(8004286113839160296) ,p_button_sequence=>10 ,p_button_plug_id=>wwv_flow_api.id(8004285560205160294) ,p_button_name=>'CANCEL' ,p_button_action=>'REDIRECT_PAGE' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_api.id(7917784434352017494) ,p_button_image_alt=>'Cancel' ,p_button_position=>'REGION_TEMPLATE_CLOSE' ,p_button_redirect_url=>'f?p=&APP_ID.:25:&SESSION.::&DEBUG.:::' ,p_grid_new_grid=>false ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(8004285913800160295) ,p_button_sequence=>40 ,p_button_plug_id=>wwv_flow_api.id(8004285560205160294) ,p_button_name=>'CREATE' ,p_button_action=>'SUBMIT' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_api.id(7917784434352017494) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Create' ,p_button_position=>'REGION_TEMPLATE_CREATE' ,p_button_condition=>'P25_EMPNO' ,p_button_condition_type=>'ITEM_IS_NULL' ,p_grid_new_grid=>false ,p_database_action=>'INSERT' ); wwv_flow_api.create_page_branch( p_id=>wwv_flow_api.id(8004287219671160299) ,p_branch_action=>'f?p=&APP_ID.:25:&SESSION.&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(8004287630060160536) ,p_name=>'P25_EMPNO' ,p_item_sequence=>10 ,p_item_plug_id=>wwv_flow_api.id(8004285560205160294) ,p_use_cache_before_default=>'NO' ,p_prompt=>'Empno' ,p_source=>'EMPNO' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_HIDDEN' ,p_label_alignment=>'RIGHT' ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,p_item_template_options=>'#DEFAULT#' ,p_protection_level=>'S' ,p_attribute_01=>'Y' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(8004287947306160550) ,p_name=>'P25_ENAME' ,p_is_required=>true ,p_item_sequence=>20 ,p_item_plug_id=>wwv_flow_api.id(8004285560205160294) ,p_use_cache_before_default=>'NO' ,p_prompt=>'Employee' ,p_source=>'ENAME' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>30 ,p_cMaxlength=>10 ,p_cHeight=>1 ,p_label_alignment=>'RIGHT' ,p_field_template=>wwv_flow_api.id(7917784100775017491) ,p_item_template_options=>'#DEFAULT#' ,p_attribute_01=>'N' ,p_attribute_02=>'N' ,p_attribute_03=>'N' ,p_attribute_04=>'TEXT' ,p_attribute_05=>'BOTH' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(8004298213110160550) ,p_name=>'P25_JOB' ,p_item_sequence=>30 ,p_item_plug_id=>wwv_flow_api.id(8004285560205160294) ,p_use_cache_before_default=>'NO' ,p_prompt=>'Job' ,p_source=>'JOB' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_SELECT_LIST' ,p_lov=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'select distinct job d, job r', 'from emp', 'order by 1')) ,p_lov_display_null=>'YES' ,p_cHeight=>1 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,p_item_template_options=>'#DEFAULT#' ,p_lov_display_extra=>'YES' ,p_attribute_01=>'NONE' ,p_attribute_02=>'N' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(8004298665412160551) ,p_name=>'P25_SAL' ,p_item_sequence=>40 ,p_item_plug_id=>wwv_flow_api.id(8004285560205160294) ,p_use_cache_before_default=>'NO' ,p_prompt=>'Sal' ,p_source=>'SAL' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_NUMBER_FIELD' ,p_cSize=>10 ,p_cMaxlength=>7 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,p_item_template_options=>'#DEFAULT#' ,p_attribute_03=>'right' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(8004299070163160552) ,p_name=>'P25_COMM' ,p_item_sequence=>50 ,p_item_plug_id=>wwv_flow_api.id(8004285560205160294) ,p_use_cache_before_default=>'NO' ,p_prompt=>'Comm' ,p_source=>'COMM' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_NUMBER_FIELD' ,p_cSize=>10 ,p_cMaxlength=>7 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,p_item_template_options=>'#DEFAULT#' ,p_attribute_03=>'right' ); wwv_flow_api.create_page_computation( p_id=>wwv_flow_api.id(7984634555016825714) ,p_computation_sequence=>10 ,p_computation_item=>'P25_EMPNO' ,p_computation_point=>'BEFORE_HEADER' ,p_computation_type=>'STATIC_ASSIGNMENT' ,p_computation=>'7876' ); wwv_flow_api.create_page_da_event( p_id=>wwv_flow_api.id(7984634633435825715) ,p_name=>'Commission for SALESMAN only' ,p_event_sequence=>10 ,p_triggering_element_type=>'ITEM' ,p_triggering_element=>'P25_JOB' ,p_triggering_condition_type=>'EQUALS' ,p_triggering_expression=>'SALESMAN' ,p_bind_type=>'bind' ,p_bind_event_type=>'change' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984634739352825716) ,p_event_id=>wwv_flow_api.id(7984634633435825715) ,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=>'P25_COMM' ,p_attribute_01=>'N' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984634802665825717) ,p_event_id=>wwv_flow_api.id(7984634633435825715) ,p_event_result=>'FALSE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'Y' ,p_action=>'NATIVE_HIDE' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P25_COMM' ,p_attribute_01=>'N' ); wwv_flow_api.create_page_process( p_id=>wwv_flow_api.id(8004301088628160554) ,p_process_sequence=>10 ,p_process_point=>'AFTER_HEADER' ,p_process_type=>'NATIVE_FORM_FETCH' ,p_process_name=>'Fetch Row from EMP' ,p_attribute_02=>'EMP' ,p_attribute_03=>'P25_EMPNO' ,p_attribute_04=>'EMPNO' ); wwv_flow_api.create_page_process( p_id=>wwv_flow_api.id(8004301684671160555) ,p_process_sequence=>30 ,p_process_point=>'AFTER_SUBMIT' ,p_process_type=>'NATIVE_FORM_PROCESS' ,p_process_name=>'Process Row of EMP' ,p_attribute_02=>'EMP' ,p_attribute_03=>'P25_EMPNO' ,p_attribute_04=>'EMPNO' ,p_attribute_11=>'I:U' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ,p_process_success_message=>'Action Processed.' ); wwv_flow_api.create_page_process( p_id=>wwv_flow_api.id(8004302088848160556) ,p_process_sequence=>40 ,p_process_point=>'AFTER_SUBMIT' ,p_process_type=>'NATIVE_SESSION_STATE' ,p_process_name=>'reset page' ,p_attribute_01=>'CLEAR_CACHE_CURRENT_PAGE' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ); end; / prompt --application/pages/page_00030 begin wwv_flow_api.create_page( p_id=>30 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Set Value' ,p_page_mode=>'NORMAL' ,p_step_title=>'Set Value' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_dialog_chained=>'Y' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20150613211822' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(7984633384538825702) ,p_plug_name=>'Log Entry' ,p_region_template_options=>'#DEFAULT#:i-h240:t-Region--scrollBody:t-Form--xlarge' ,p_plug_template=>wwv_flow_api.id(7917763654291017471) ,p_plug_display_sequence=>10 ,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_plug( p_id=>wwv_flow_api.id(7985016373204021464) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(7984633541509825704) ,p_button_sequence=>30 ,p_button_plug_id=>wwv_flow_api.id(7984633384538825702) ,p_button_name=>'TODAY' ,p_button_action=>'DEFINED_BY_DA' ,p_button_template_options=>'#DEFAULT#:t-Button--large:t-Button--noUI' ,p_button_template_id=>wwv_flow_api.id(7917784434352017494) ,p_button_image_alt=>'[Today]' ,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(7984633912473825708) ,p_button_sequence=>40 ,p_button_plug_id=>wwv_flow_api.id(7984633384538825702) ,p_button_name=>'CLEAR' ,p_button_action=>'DEFINED_BY_DA' ,p_button_template_options=>'#DEFAULT#:t-Button--large:t-Button--noUI' ,p_button_template_id=>wwv_flow_api.id(7917784434352017494) ,p_button_image_alt=>'[Clear]' ,p_button_position=>'BODY' ,p_grid_new_row=>'N' ,p_grid_new_column=>'Y' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(7984633438898825703) ,p_name=>'P30_LOG_DATE' ,p_item_sequence=>20 ,p_item_plug_id=>wwv_flow_api.id(7984633384538825702) ,p_prompt=>'Log Date' ,p_display_as=>'NATIVE_DATE_PICKER' ,p_cSize=>12 ,p_colspan=>6 ,p_grid_label_column_span=>2 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,p_item_template_options=>'#DEFAULT#' ,p_attribute_04=>'button' ,p_attribute_05=>'N' ,p_attribute_07=>'NONE' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(7984633695419825705) ,p_name=>'P30_TODAY' ,p_item_sequence=>50 ,p_item_plug_id=>wwv_flow_api.id(7984633384538825702) ,p_item_default=>'to_char(sysdate, ''DD-MON-YY'')' ,p_item_default_type=>'PLSQL_EXPRESSION' ,p_display_as=>'NATIVE_HIDDEN' ,p_attribute_01=>'Y' ); wwv_flow_api.create_page_da_event( p_id=>wwv_flow_api.id(7984633712993825706) ,p_name=>'Set Today' ,p_event_sequence=>10 ,p_triggering_element_type=>'BUTTON' ,p_triggering_button_id=>wwv_flow_api.id(7984633541509825704) ,p_bind_type=>'bind' ,p_bind_event_type=>'click' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984633811593825707) ,p_event_id=>wwv_flow_api.id(7984633712993825706) ,p_event_result=>'TRUE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_SET_VALUE' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P30_LOG_DATE' ,p_attribute_01=>'STATIC_ASSIGNMENT' ,p_attribute_02=>'&P30_TODAY.' ,p_attribute_09=>'N' ,p_stop_execution_on_error=>'Y' ,p_wait_for_result=>'Y' ); wwv_flow_api.create_page_da_event( p_id=>wwv_flow_api.id(7984634019051825709) ,p_name=>'Clear Log Date' ,p_event_sequence=>20 ,p_triggering_element_type=>'BUTTON' ,p_triggering_button_id=>wwv_flow_api.id(7984633912473825708) ,p_bind_type=>'bind' ,p_bind_event_type=>'click' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984634123807825710) ,p_event_id=>wwv_flow_api.id(7984634019051825709) ,p_event_result=>'TRUE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'Y' ,p_action=>'NATIVE_SET_VALUE' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P30_LOG_DATE' ,p_attribute_01=>'STATIC_ASSIGNMENT' ,p_attribute_09=>'N' ,p_stop_execution_on_error=>'Y' ,p_wait_for_result=>'Y' ); end; / prompt --application/pages/page_00040 begin wwv_flow_api.create_page( p_id=>40 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Key Release' ,p_page_mode=>'NORMAL' ,p_step_title=>'Generate Uppercase Code' ,p_step_sub_title=>'Generate Uppercase Code' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20150622022505' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8280976938559207124) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8280977357056207127) ,p_plug_name=>'Roles' ,p_region_template_options=>'#DEFAULT#:i-h240:t-Region--scrollBody:t-Form--xlarge' ,p_plug_template=>wwv_flow_api.id(7917763654291017471) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'Y' ,p_plug_display_point=>'BODY' ,p_plug_query_row_template=>1 ,p_plug_query_options=>'DERIVED_REPORT_COLUMNS' ,p_attribute_01=>'N' ,p_attribute_02=>'HTML' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(8251130410674330502) ,p_name=>'P40_CODE' ,p_item_sequence=>30 ,p_item_plug_id=>wwv_flow_api.id(8280977357056207127) ,p_prompt=>'Code' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>30 ,p_field_template=>wwv_flow_api.id(7917784100775017491) ,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(8280978595662207129) ,p_name=>'P40_NAME' ,p_item_sequence=>20 ,p_item_plug_id=>wwv_flow_api.id(8280977357056207127) ,p_prompt=>'Name' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>30 ,p_field_template=>wwv_flow_api.id(7917784100775017491) ,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_da_event( p_id=>wwv_flow_api.id(8251130544260330503) ,p_name=>'Generate Upper Code' ,p_event_sequence=>10 ,p_triggering_element_type=>'ITEM' ,p_triggering_element=>'P40_NAME' ,p_bind_type=>'bind' ,p_bind_event_type=>'keyup' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(8251130699379330504) ,p_event_id=>wwv_flow_api.id(8251130544260330503) ,p_event_result=>'TRUE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_SET_VALUE' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P40_CODE' ,p_attribute_01=>'JAVASCRIPT_EXPRESSION' ,p_attribute_05=>'this.triggeringElement.value.toUpperCase().replace(/\s+/g, ''_'').substring(0, 20);' ,p_attribute_09=>'N' ,p_stop_execution_on_error=>'Y' ,p_wait_for_result=>'Y' ); end; / prompt --application/pages/page_00100 begin wwv_flow_api.create_page( p_id=>100 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Refresh' ,p_page_mode=>'NORMAL' ,p_step_title=>'Refresh' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_dialog_chained=>'Y' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20150614001310' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(7986773355340351466) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); end; / prompt --application/pages/page_00110 begin wwv_flow_api.create_page( p_id=>110 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Simple Refresh Report' ,p_page_mode=>'NORMAL' ,p_step_title=>'Simple Refresh Report' ,p_step_sub_title=>'Simple Refresh Report' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_dialog_chained=>'Y' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20150614004147' ); wwv_flow_api.create_report_region( p_id=>wwv_flow_api.id(7986935394362310834) ,p_name=>'Employees' ,p_template=>wwv_flow_api.id(7917763654291017471) ,p_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody' ,p_component_template_options=>'#DEFAULT#:t-Report--altRowsDefault:t-Report--rowHighlight' ,p_display_point=>'BODY' ,p_source=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'select EMPNO,', ' ENAME,', ' JOB,', ' MGR', ' from EMP', 'where (:P110_DEPTNO is null or deptno = :P110_DEPTNO)')) ,p_source_type=>'NATIVE_SQL_REPORT' ,p_ajax_enabled=>'Y' ,p_ajax_items_to_submit=>'P110_DEPTNO' ,p_query_row_template=>wwv_flow_api.id(7917772488812017479) ,p_query_num_rows=>15 ,p_query_options=>'DERIVED_REPORT_COLUMNS' ,p_query_no_data_found=>'No data found.' ,p_query_num_rows_type=>'ROW_RANGES_IN_SELECT_LIST' ,p_query_row_count_max=>500 ,p_csv_output=>'N' ,p_prn_output=>'N' ); wwv_flow_api.create_report_columns( p_id=>wwv_flow_api.id(7986936015374310837) ,p_query_column_id=>1 ,p_column_alias=>'EMPNO' ,p_column_display_sequence=>1 ,p_column_heading=>'Empno' ,p_default_sort_column_sequence=>1 ,p_disable_sort_column=>'N' ); wwv_flow_api.create_report_columns( p_id=>wwv_flow_api.id(7986936403166310838) ,p_query_column_id=>2 ,p_column_alias=>'ENAME' ,p_column_display_sequence=>2 ,p_column_heading=>'Ename' ,p_disable_sort_column=>'N' ); wwv_flow_api.create_report_columns( p_id=>wwv_flow_api.id(7986936838950310838) ,p_query_column_id=>3 ,p_column_alias=>'JOB' ,p_column_display_sequence=>3 ,p_column_heading=>'Job' ,p_disable_sort_column=>'N' ); wwv_flow_api.create_report_columns( p_id=>wwv_flow_api.id(7986937285529310838) ,p_query_column_id=>4 ,p_column_alias=>'MGR' ,p_column_display_sequence=>4 ,p_column_heading=>'Mgr' ,p_disable_sort_column=>'N' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(7986941656284310844) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(7984634203597825711) ,p_name=>'P110_DEPTNO' ,p_item_sequence=>10 ,p_item_plug_id=>wwv_flow_api.id(7986935394362310834) ,p_prompt=>'Department' ,p_display_as=>'NATIVE_SELECT_LIST' ,p_lov=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'select dname d, deptno r', 'from dept', 'order by 1')) ,p_lov_display_null=>'YES' ,p_lov_null_text=>'- All -' ,p_cHeight=>1 ,p_grid_label_column_span=>1 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,p_item_template_options=>'#DEFAULT#' ,p_lov_display_extra=>'YES' ,p_attribute_01=>'NONE' ,p_attribute_02=>'N' ); wwv_flow_api.create_page_da_event( p_id=>wwv_flow_api.id(7984634325909825712) ,p_name=>'Refresh Report' ,p_event_sequence=>10 ,p_triggering_element_type=>'ITEM' ,p_triggering_element=>'P110_DEPTNO' ,p_bind_type=>'bind' ,p_bind_event_type=>'change' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984634485060825713) ,p_event_id=>wwv_flow_api.id(7984634325909825712) ,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(7986935394362310834) ); end; / prompt --application/pages/page_00200 begin wwv_flow_api.create_page( p_id=>200 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'AJAX' ,p_page_mode=>'NORMAL' ,p_step_title=>'AJAX' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_dialog_chained=>'Y' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20150620160550' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8248856527862898684) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); end; / prompt --application/pages/page_00210 begin wwv_flow_api.create_page( p_id=>210 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Users' ,p_page_mode=>'NORMAL' ,p_step_title=>'Users' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_dialog_chained=>'Y' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'APEX_PUBLIC_USER' ,p_last_upd_yyyymmddhh24miss=>'20150620162953' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8249554828927034046) ,p_plug_name=>'Users' ,p_region_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917763112083017470) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'BODY' ,p_plug_source=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'select "ID", ', '"USERNAME",', '"FIRST_NAME",', '"LAST_NAME",', '"EMAIL",', '"ACTIVE_IND",', '"CREATED_BY",', '"CREATED_ON",', '"UPDATED_BY",', '"UPDATED_ON"', 'from "#OWNER#"."APP_USERS" ', ' ', '')) ,p_plug_source_type=>'NATIVE_IR' ,p_plug_query_row_template=>1 ); wwv_flow_api.create_worksheet( p_id=>wwv_flow_api.id(8249555200369034047) ,p_name=>'Users' ,p_max_row_count=>'1000000' ,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=>'C' ,p_download_formats=>'CSV:HTML:EMAIL:XLS:PDF:RTF' ,p_detail_link=>'f?p=&APP_ID.:215:&APP_SESSION.::::P215_ID:#ID#' ,p_detail_link_text=>'Edit' ,p_owner=>'JORGE@RIMBLAS.COM' ,p_internal_uid=>8249555200369034047 ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8249555329644034048) ,p_db_column_name=>'ID' ,p_display_order=>1 ,p_column_identifier=>'A' ,p_column_label=>'Id' ,p_column_type=>'NUMBER' ,p_display_text_as=>'HIDDEN' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8249555749062034049) ,p_db_column_name=>'USERNAME' ,p_display_order=>2 ,p_column_identifier=>'B' ,p_column_label=>'Username' ,p_column_type=>'STRING' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8249556153106034050) ,p_db_column_name=>'FIRST_NAME' ,p_display_order=>3 ,p_column_identifier=>'C' ,p_column_label=>'First Name' ,p_column_type=>'STRING' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8249556529055034050) ,p_db_column_name=>'LAST_NAME' ,p_display_order=>4 ,p_column_identifier=>'D' ,p_column_label=>'Last Name' ,p_column_type=>'STRING' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8249556972194034051) ,p_db_column_name=>'EMAIL' ,p_display_order=>5 ,p_column_identifier=>'E' ,p_column_label=>'Email' ,p_column_type=>'STRING' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8249557300673034051) ,p_db_column_name=>'ACTIVE_IND' ,p_display_order=>6 ,p_column_identifier=>'F' ,p_column_label=>'Active?' ,p_column_type=>'STRING' ,p_column_alignment=>'CENTER' ,p_tz_dependent=>'N' ,p_help_text=>'Indicates if this row is active or inactive.' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8249557733203034051) ,p_db_column_name=>'CREATED_BY' ,p_display_order=>7 ,p_column_identifier=>'G' ,p_column_label=>'Created By' ,p_column_type=>'STRING' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8249558137237034052) ,p_db_column_name=>'CREATED_ON' ,p_display_order=>8 ,p_column_identifier=>'H' ,p_column_label=>'Created On' ,p_column_type=>'DATE' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8249558541598034052) ,p_db_column_name=>'UPDATED_BY' ,p_display_order=>9 ,p_column_identifier=>'I' ,p_column_label=>'Updated By' ,p_column_type=>'STRING' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8249558914068034053) ,p_db_column_name=>'UPDATED_ON' ,p_display_order=>10 ,p_column_identifier=>'J' ,p_column_label=>'Updated On' ,p_column_type=>'DATE' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_rpt( p_id=>wwv_flow_api.id(8249561746353036294) ,p_application_user=>'APXWS_DEFAULT' ,p_report_seq=>10 ,p_report_alias=>'82495618' ,p_status=>'PUBLIC' ,p_is_default=>'Y' ,p_display_rows=>50 ,p_report_columns=>'USERNAME:FIRST_NAME:LAST_NAME:EMAIL:ACTIVE_IND:' ,p_flashback_enabled=>'N' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8249559543216034053) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); end; / prompt --application/pages/page_00214 begin wwv_flow_api.create_page( p_id=>214 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Maintain Users (No Dynamic Aactions)' ,p_page_mode=>'NORMAL' ,p_step_title=>'Maintain Users (No Dynamic Aactions)' ,p_step_sub_title=>'Maintain Users (No Dynamic Aactions)' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'APEX_PUBLIC_USER' ,p_last_upd_yyyymmddhh24miss=>'20150620180341' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8250360464250241911) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8250360877927241916) ,p_plug_name=>'Maintain Users' ,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody' ,p_plug_template=>wwv_flow_api.id(7917763654291017471) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'BODY' ,p_plug_query_row_template=>1 ,p_attribute_01=>'N' ,p_attribute_02=>'TEXT' ,p_attribute_03=>'Y' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8250364929660241924) ,p_plug_name=>'Assigned Roles' ,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody' ,p_plug_template=>wwv_flow_api.id(7917763654291017471) ,p_plug_display_sequence=>20 ,p_include_in_reg_disp_sel_yn=>'Y' ,p_plug_display_point=>'BODY' ,p_plug_query_row_template=>1 ,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(8250366156774241926) ,p_plug_name=>'Assigned Roles IR' ,p_parent_plug_id=>wwv_flow_api.id(8250364929660241924) ,p_region_template_options=>'#DEFAULT#' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917763112083017470) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'BODY' ,p_plug_source=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'select ur.id,', ' ur.username,', ' ur.role_key,', ' r.name role,', ' ur.created_by,', ' ur.created_on,', ' ur.updated_by,', ' ur.updated_on', 'from app_user_roles ur', ' , app_roles r', 'where ur.role_key = r.role_key (+)', ' and ur.username = :P214_USERNAME')) ,p_plug_source_type=>'NATIVE_IR' ,p_ajax_items_to_submit=>'P214_USERNAME' ,p_plug_query_row_template=>1 ,p_plug_query_options=>'DERIVED_REPORT_COLUMNS' ,p_plug_display_condition_type=>'ITEM_IS_NOT_NULL' ,p_plug_display_when_condition=>'P214_ID' ,p_prn_content_disposition=>'ATTACHMENT' ,p_prn_document_header=>'APEX' ,p_prn_units=>'INCHES' ,p_prn_paper_size=>'LETTER' ,p_prn_width=>8.5 ,p_prn_height=>11 ,p_prn_orientation=>'HORIZONTAL' ,p_prn_page_header_font_color=>'#000000' ,p_prn_page_header_font_family=>'Helvetica' ,p_prn_page_header_font_weight=>'normal' ,p_prn_page_header_font_size=>'12' ,p_prn_page_footer_font_color=>'#000000' ,p_prn_page_footer_font_family=>'Helvetica' ,p_prn_page_footer_font_weight=>'normal' ,p_prn_page_footer_font_size=>'12' ,p_prn_header_bg_color=>'#9bafde' ,p_prn_header_font_color=>'#000000' ,p_prn_header_font_family=>'Helvetica' ,p_prn_header_font_weight=>'normal' ,p_prn_header_font_size=>'10' ,p_prn_body_bg_color=>'#efefef' ,p_prn_body_font_color=>'#000000' ,p_prn_body_font_family=>'Helvetica' ,p_prn_body_font_weight=>'normal' ,p_prn_body_font_size=>'10' ,p_prn_border_width=>.5 ,p_prn_page_header_alignment=>'CENTER' ,p_prn_page_footer_alignment=>'CENTER' ); wwv_flow_api.create_worksheet( p_id=>wwv_flow_api.id(8250366528624241927) ,p_max_row_count=>'1000000' ,p_no_data_found_message=>'No Roles' ,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_show_notify=>'Y' ,p_download_formats=>'CSV:HTML:EMAIL:XLS:PDF:RTF' ,p_owner=>'JORGE@RIMBLAS.COM' ,p_internal_uid=>8250366528624241927 ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8250366630387241930) ,p_db_column_name=>'ID' ,p_display_order=>10 ,p_column_identifier=>'A' ,p_column_label=>'Id' ,p_column_type=>'NUMBER' ,p_column_alignment=>'RIGHT' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8250366957311241931) ,p_db_column_name=>'USERNAME' ,p_display_order=>20 ,p_column_identifier=>'B' ,p_column_label=>'Username' ,p_column_type=>'STRING' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8250367397029241932) ,p_db_column_name=>'ROLE_KEY' ,p_display_order=>30 ,p_column_identifier=>'C' ,p_column_label=>'Role key' ,p_column_type=>'STRING' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8250367763132241932) ,p_db_column_name=>'ROLE' ,p_display_order=>40 ,p_column_identifier=>'D' ,p_column_label=>'Role' ,p_column_type=>'STRING' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8250368127309241933) ,p_db_column_name=>'CREATED_BY' ,p_display_order=>50 ,p_column_identifier=>'E' ,p_column_label=>'Created by' ,p_column_type=>'STRING' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8250368514466241933) ,p_db_column_name=>'CREATED_ON' ,p_display_order=>60 ,p_column_identifier=>'F' ,p_column_label=>'Created on' ,p_column_type=>'DATE' ,p_column_alignment=>'CENTER' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8250368946863241933) ,p_db_column_name=>'UPDATED_BY' ,p_display_order=>70 ,p_column_identifier=>'G' ,p_column_label=>'Updated by' ,p_column_type=>'STRING' ); wwv_flow_api.create_worksheet_column( p_id=>wwv_flow_api.id(8250369308465241934) ,p_db_column_name=>'UPDATED_ON' ,p_display_order=>80 ,p_column_identifier=>'H' ,p_column_label=>'Updated on' ,p_column_type=>'DATE' ,p_column_alignment=>'CENTER' ,p_tz_dependent=>'N' ); wwv_flow_api.create_worksheet_rpt( p_id=>wwv_flow_api.id(8250369780903241935) ,p_application_user=>'APXWS_DEFAULT' ,p_report_seq=>10 ,p_report_alias=>'82503698' ,p_status=>'PUBLIC' ,p_is_default=>'Y' ,p_display_rows=>50 ,p_report_columns=>'ID:USERNAME:ROLE_KEY:ROLE:' ,p_flashback_enabled=>'N' ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(8250365372379241925) ,p_button_sequence=>20 ,p_button_plug_id=>wwv_flow_api.id(8250364929660241924) ,p_button_name=>'ASSIGN_ROLE' ,p_button_action=>'DEFINED_BY_DA' ,p_button_template_options=>'#DEFAULT#:t-Button--iconRight' ,p_button_template_id=>wwv_flow_api.id(7917784585387017494) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Assign Role' ,p_button_position=>'BODY' ,p_icon_css_classes=>'fa-check' ,p_grid_new_row=>'N' ,p_grid_column=>5 ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(8250361684242241918) ,p_button_sequence=>30 ,p_button_plug_id=>wwv_flow_api.id(8250360877927241916) ,p_button_name=>'SAVE' ,p_button_action=>'SUBMIT' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_api.id(7917784434352017494) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Apply Changes' ,p_button_position=>'REGION_TEMPLATE_CHANGE' ,p_button_condition=>'P214_ID' ,p_button_condition_type=>'ITEM_IS_NOT_NULL' ,p_grid_new_grid=>false ,p_database_action=>'UPDATE' ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(8250361236749241917) ,p_button_sequence=>10 ,p_button_plug_id=>wwv_flow_api.id(8250360877927241916) ,p_button_name=>'CANCEL' ,p_button_action=>'REDIRECT_PAGE' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_api.id(7917784434352017494) ,p_button_image_alt=>'Cancel' ,p_button_position=>'REGION_TEMPLATE_CLOSE' ,p_button_redirect_url=>'f?p=&APP_ID.:210:&SESSION.::&DEBUG.:::' ,p_grid_new_grid=>false ); wwv_flow_api.create_page_branch( p_id=>wwv_flow_api.id(8250371809973241943) ,p_branch_action=>'f?p=&APP_ID.:210:&SESSION.&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(8250362015955241919) ,p_name=>'P214_ID' ,p_item_sequence=>10 ,p_item_plug_id=>wwv_flow_api.id(8250360877927241916) ,p_use_cache_before_default=>'NO' ,p_source=>'ID' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_HIDDEN' ,p_attribute_01=>'Y' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(8250362446347241920) ,p_name=>'P214_USERNAME' ,p_is_required=>true ,p_item_sequence=>20 ,p_item_plug_id=>wwv_flow_api.id(8250360877927241916) ,p_use_cache_before_default=>'NO' ,p_prompt=>'Username' ,p_source=>'USERNAME' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>10 ,p_cMaxlength=>60 ,p_field_template=>wwv_flow_api.id(7917784100775017491) ,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(8250362809709241921) ,p_name=>'P214_ACTIVE_IND' ,p_is_required=>true ,p_item_sequence=>30 ,p_item_plug_id=>wwv_flow_api.id(8250360877927241916) ,p_use_cache_before_default=>'NO' ,p_item_default=>'Y' ,p_prompt=>'Active?' ,p_source=>'ACTIVE_IND' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_YES_NO' ,p_begin_on_new_line=>'N' ,p_grid_label_column_span=>1 ,p_field_template=>wwv_flow_api.id(7917784100775017491) ,p_item_template_options=>'#DEFAULT#' ,p_help_text=>'Indicates if this row is active or inactive.' ,p_attribute_01=>'APPLICATION' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(8250363724165241923) ,p_name=>'P214_FIRST_NAME' ,p_item_sequence=>40 ,p_item_plug_id=>wwv_flow_api.id(8250360877927241916) ,p_use_cache_before_default=>'NO' ,p_prompt=>'First Name' ,p_source=>'FIRST_NAME' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>10 ,p_cMaxlength=>50 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,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(8250364188955241923) ,p_name=>'P214_LAST_NAME' ,p_item_sequence=>60 ,p_item_plug_id=>wwv_flow_api.id(8250360877927241916) ,p_use_cache_before_default=>'NO' ,p_prompt=>'Last Name' ,p_source=>'LAST_NAME' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>10 ,p_cMaxlength=>50 ,p_begin_on_new_line=>'N' ,p_grid_label_column_span=>1 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,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(8250364542653241924) ,p_name=>'P214_EMAIL' ,p_item_sequence=>70 ,p_item_plug_id=>wwv_flow_api.id(8250360877927241916) ,p_use_cache_before_default=>'NO' ,p_source=>'EMAIL' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_HIDDEN' ,p_attribute_01=>'Y' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(8250365791968241925) ,p_name=>'P214_ROLE_KEY' ,p_item_sequence=>10 ,p_item_plug_id=>wwv_flow_api.id(8250364929660241924) ,p_prompt=>'New Role' ,p_display_as=>'NATIVE_SELECT_LIST' ,p_lov=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'select r.name || '' ('' || r.role_key || '')'' d, r.role_key r', 'from app_roles r', 'where r.active_ind = ''Y''', ' and not exists (', ' select 1', ' from app_user_roles ur', ' where ur.username = :P214_USERNAME', ' and ur.role_key = r.role_key', ' )', ' ')) ,p_lov_display_null=>'YES' ,p_cHeight=>1 ,p_grid_label_column_span=>2 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,p_item_template_options=>'#DEFAULT#' ,p_lov_display_extra=>'YES' ,p_attribute_01=>'NONE' ,p_attribute_02=>'N' ); wwv_flow_api.create_page_process( p_id=>wwv_flow_api.id(8250370587561241940) ,p_process_sequence=>10 ,p_process_point=>'AFTER_HEADER' ,p_process_type=>'NATIVE_FORM_FETCH' ,p_process_name=>'Fetch Row from APP_USERS' ,p_attribute_02=>'APP_USERS' ,p_attribute_03=>'P214_ID' ,p_attribute_04=>'ID' ); wwv_flow_api.create_page_process( p_id=>wwv_flow_api.id(8250370975952241941) ,p_process_sequence=>30 ,p_process_point=>'AFTER_SUBMIT' ,p_process_type=>'NATIVE_FORM_PROCESS' ,p_process_name=>'Process Row of APP_USERS' ,p_attribute_02=>'APP_USERS' ,p_attribute_03=>'P214_ID' ,p_attribute_04=>'ID' ,p_attribute_11=>'U' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ,p_process_success_message=>'Action Processed.' ); wwv_flow_api.create_page_process( p_id=>wwv_flow_api.id(8250371391144241941) ,p_process_sequence=>40 ,p_process_point=>'AFTER_SUBMIT' ,p_process_type=>'NATIVE_SESSION_STATE' ,p_process_name=>'reset page' ,p_attribute_01=>'CLEAR_CACHE_CURRENT_PAGE' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ); end; / prompt --application/pages/page_00215 begin wwv_flow_api.create_page( p_id=>215 ,p_user_interface_id=>wwv_flow_api.id(7917789640752017529) ,p_name=>'Maintain Users' ,p_page_mode=>'NORMAL' ,p_step_title=>'Maintain Users' ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS' ,p_first_item=>'NO_FIRST_ITEM' ,p_page_template_options=>'#DEFAULT#' ,p_overwrite_navigation_list=>'N' ,p_page_is_public_y_n=>'N' ,p_cache_mode=>'NOCACHE' ,p_help_text=>'No help is available for this page.' ,p_last_updated_by=>'JORGE@RIMBLAS.COM' ,p_last_upd_yyyymmddhh24miss=>'20150620181037' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(7984636242292825731) ,p_plug_name=>'Assigned Roles' ,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody' ,p_plug_template=>wwv_flow_api.id(7917763654291017471) ,p_plug_display_sequence=>20 ,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(7984635096949825719) ,p_name=>'Assigned Roles IR' ,p_region_name=>'userRolesRegion' ,p_parent_plug_id=>wwv_flow_api.id(7984636242292825731) ,p_template=>wwv_flow_api.id(7917763112083017470) ,p_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_region_template_options=>'#DEFAULT#' ,p_component_template_options=>'#DEFAULT#:t-Report--altRowsDefault:t-Report--rowHighlight' ,p_display_point=>'BODY' ,p_source=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'select ur.id', '-- , ur.username', ' , ur.role_key', ' , r.name role', '-- , ur.created_by', '-- , ur.created_on', '-- , ur.updated_by', '-- , ur.updated_on', 'from app_user_roles ur', ' , app_roles r', 'where ur.role_key = r.role_key (+)', ' and ur.username = :P215_USERNAME')) ,p_source_type=>'NATIVE_SQL_REPORT' ,p_display_when_condition=>'P215_ID' ,p_display_condition_type=>'ITEM_IS_NOT_NULL' ,p_ajax_enabled=>'Y' ,p_ajax_items_to_submit=>'P215_USERNAME' ,p_query_row_template=>wwv_flow_api.id(7917772488812017479) ,p_query_num_rows=>15 ,p_query_options=>'DERIVED_REPORT_COLUMNS' ,p_query_show_nulls_as=>'-' ,p_query_num_rows_type=>'ROW_RANGES_IN_SELECT_LIST' ,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(7984636833727825737) ,p_query_column_id=>1 ,p_column_alias=>'ID' ,p_column_display_sequence=>1 ,p_column_heading=>'Delete' ,p_column_link=>'#0' ,p_column_linktext=>'' ,p_column_link_attr=>'class="deleteRole" data-id="#ID#" title="Un-assign Role"' ,p_column_alignment=>'CENTER' ,p_derived_column=>'N' ,p_include_in_export=>'Y' ); wwv_flow_api.create_report_columns( p_id=>wwv_flow_api.id(7984637011893825739) ,p_query_column_id=>2 ,p_column_alias=>'ROLE_KEY' ,p_column_display_sequence=>2 ,p_column_heading=>'Role key' ,p_use_as_row_header=>'N' ,p_default_sort_column_sequence=>1 ,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(7984637147922825740) ,p_query_column_id=>3 ,p_column_alias=>'ROLE' ,p_column_display_sequence=>3 ,p_column_heading=>'Role' ,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_plug( p_id=>wwv_flow_api.id(8249506867341032016) ,p_plug_name=>'Maintain Users' ,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader:t-Region--scrollBody' ,p_plug_template=>wwv_flow_api.id(7917763654291017471) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'BODY' ,p_plug_query_row_template=>1 ,p_plug_query_options=>'DERIVED_REPORT_COLUMNS' ,p_attribute_01=>'N' ,p_attribute_02=>'TEXT' ,p_attribute_03=>'Y' ); wwv_flow_api.create_page_plug( p_id=>wwv_flow_api.id(8249560146513034055) ,p_plug_name=>'Breadcrumb' ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_api.id(7917766953339017473) ,p_plug_display_sequence=>10 ,p_include_in_reg_disp_sel_yn=>'N' ,p_plug_display_point=>'REGION_POSITION_01' ,p_menu_id=>wwv_flow_api.id(7917789953665017533) ,p_plug_source_type=>'NATIVE_BREADCRUMB' ,p_menu_template_id=>wwv_flow_api.id(7917784951080017494) ,p_plug_query_row_template=>1 ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(7984636118916825730) ,p_button_sequence=>30 ,p_button_plug_id=>wwv_flow_api.id(7984636242292825731) ,p_button_name=>'ASSIGN_ROLE' ,p_button_action=>'DEFINED_BY_DA' ,p_button_template_options=>'#DEFAULT#:t-Button--iconRight' ,p_button_template_id=>wwv_flow_api.id(7917784585387017494) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Assign Role' ,p_button_position=>'BODY' ,p_icon_css_classes=>'fa-check' ,p_grid_new_row=>'N' ,p_grid_column=>5 ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(8249507215691032019) ,p_button_sequence=>30 ,p_button_plug_id=>wwv_flow_api.id(8249506867341032016) ,p_button_name=>'SAVE' ,p_button_action=>'SUBMIT' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_api.id(7917784434352017494) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Apply Changes' ,p_button_position=>'REGION_TEMPLATE_CHANGE' ,p_button_condition=>'P215_ID' ,p_button_condition_type=>'ITEM_IS_NOT_NULL' ,p_grid_new_grid=>false ,p_database_action=>'UPDATE' ); wwv_flow_api.create_page_button( p_id=>wwv_flow_api.id(8249507318168032019) ,p_button_sequence=>10 ,p_button_plug_id=>wwv_flow_api.id(8249506867341032016) ,p_button_name=>'CANCEL' ,p_button_action=>'REDIRECT_PAGE' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_api.id(7917784434352017494) ,p_button_image_alt=>'Cancel' ,p_button_position=>'REGION_TEMPLATE_CLOSE' ,p_button_redirect_url=>'f?p=&APP_ID.:210:&SESSION.::&DEBUG.:::' ,p_grid_new_grid=>false ); wwv_flow_api.create_page_branch( p_id=>wwv_flow_api.id(8249548181438032021) ,p_branch_action=>'f?p=&APP_ID.:210:&SESSION.&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(7984634945588825718) ,p_name=>'P215_EMAIL' ,p_item_sequence=>70 ,p_item_plug_id=>wwv_flow_api.id(8249506867341032016) ,p_use_cache_before_default=>'NO' ,p_source=>'EMAIL' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_HIDDEN' ,p_attribute_01=>'Y' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(7984636046045825729) ,p_name=>'P215_ROLE_KEY' ,p_item_sequence=>20 ,p_item_plug_id=>wwv_flow_api.id(7984636242292825731) ,p_prompt=>'New Role' ,p_display_as=>'NATIVE_SELECT_LIST' ,p_lov=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'select r.name || '' ('' || r.role_key || '')'' d, r.role_key r', 'from app_roles r', 'where r.active_ind = ''Y''', ' and not exists (', ' select 1', ' from app_user_roles ur', ' where ur.username = :P215_USERNAME', ' and ur.role_key = r.role_key', ' )', ' ')) ,p_lov_display_null=>'YES' ,p_lov_null_text=>'- Choose -' ,p_cHeight=>1 ,p_grid_label_column_span=>2 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,p_item_template_options=>'#DEFAULT#' ,p_lov_display_extra=>'YES' ,p_attribute_01=>'NONE' ,p_attribute_02=>'N' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(7984636317309825732) ,p_name=>'P215_UR_ID' ,p_item_sequence=>10 ,p_item_plug_id=>wwv_flow_api.id(7984636242292825731) ,p_display_as=>'NATIVE_HIDDEN' ,p_attribute_01=>'N' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(8249548598806032027) ,p_name=>'P215_ID' ,p_item_sequence=>10 ,p_item_plug_id=>wwv_flow_api.id(8249506867341032016) ,p_use_cache_before_default=>'NO' ,p_source=>'ID' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_HIDDEN' ,p_attribute_01=>'Y' ); wwv_flow_api.create_page_item( p_id=>wwv_flow_api.id(8249548913038032030) ,p_name=>'P215_USERNAME' ,p_is_required=>true ,p_item_sequence=>20 ,p_item_plug_id=>wwv_flow_api.id(8249506867341032016) ,p_use_cache_before_default=>'NO' ,p_prompt=>'Username' ,p_source=>'USERNAME' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>10 ,p_cMaxlength=>60 ,p_colspan=>4 ,p_grid_label_column_span=>2 ,p_field_template=>wwv_flow_api.id(7917784100775017491) ,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(8249549308628032030) ,p_name=>'P215_FIRST_NAME' ,p_item_sequence=>40 ,p_item_plug_id=>wwv_flow_api.id(8249506867341032016) ,p_use_cache_before_default=>'NO' ,p_prompt=>'First Name' ,p_source=>'FIRST_NAME' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>10 ,p_cMaxlength=>50 ,p_colspan=>4 ,p_grid_label_column_span=>2 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,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(8249549714290032031) ,p_name=>'P215_LAST_NAME' ,p_item_sequence=>60 ,p_item_plug_id=>wwv_flow_api.id(8249506867341032016) ,p_use_cache_before_default=>'NO' ,p_prompt=>'Last Name' ,p_source=>'LAST_NAME' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>10 ,p_cMaxlength=>50 ,p_begin_on_new_line=>'N' ,p_grid_label_column_span=>2 ,p_field_template=>wwv_flow_api.id(7917783971986017491) ,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(8249550105601032031) ,p_name=>'P215_ACTIVE_IND' ,p_is_required=>true ,p_item_sequence=>30 ,p_item_plug_id=>wwv_flow_api.id(8249506867341032016) ,p_use_cache_before_default=>'NO' ,p_item_default=>'Y' ,p_prompt=>'Active?' ,p_source=>'ACTIVE_IND' ,p_source_type=>'DB_COLUMN' ,p_display_as=>'NATIVE_YES_NO' ,p_begin_on_new_line=>'N' ,p_grid_label_column_span=>2 ,p_field_template=>wwv_flow_api.id(7917784100775017491) ,p_item_template_options=>'#DEFAULT#' ,p_help_text=>'Indicates if this row is active or inactive.' ,p_attribute_01=>'APPLICATION' ); wwv_flow_api.create_page_da_event( p_id=>wwv_flow_api.id(7984636407072825733) ,p_name=>'Assign New Role' ,p_event_sequence=>10 ,p_triggering_element_type=>'BUTTON' ,p_triggering_button_id=>wwv_flow_api.id(7984636118916825730) ,p_triggering_condition_type=>'JAVASCRIPT_EXPRESSION' ,p_triggering_expression=>'!!$v("P215_ROLE_KEY")' ,p_bind_type=>'bind' ,p_bind_event_type=>'click' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984636578573825734) ,p_event_id=>wwv_flow_api.id(7984636407072825733) ,p_event_result=>'TRUE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_EXECUTE_PLSQL_CODE' ,p_attribute_01=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'insert into app_user_roles', ' ( username', ' , role_key)', 'values', ' ( :P215_USERNAME', ' , :P215_ROLE_KEY);')) ,p_attribute_02=>'P215_USERNAME,P215_ROLE_KEY' ,p_stop_execution_on_error=>'Y' ,p_wait_for_result=>'Y' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984636609325825735) ,p_event_id=>wwv_flow_api.id(7984636407072825733) ,p_event_result=>'TRUE' ,p_action_sequence=>20 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_REFRESH' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P215_ROLE_KEY' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984636781500825736) ,p_event_id=>wwv_flow_api.id(7984636407072825733) ,p_event_result=>'TRUE' ,p_action_sequence=>30 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_REFRESH' ,p_affected_elements_type=>'REGION' ,p_affected_region_id=>wwv_flow_api.id(7984635096949825719) ); wwv_flow_api.create_page_da_event( p_id=>wwv_flow_api.id(7984637661253825745) ,p_name=>'Delete/Unassign Role' ,p_event_sequence=>20 ,p_triggering_element_type=>'JQUERY_SELECTOR' ,p_triggering_element=>'.deleteRole' ,p_bind_type=>'live' ,p_bind_delegate_to_selector=>'#userRolesRegion' ,p_bind_event_type=>'click' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984637816906825747) ,p_event_id=>wwv_flow_api.id(7984637661253825745) ,p_event_result=>'TRUE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_CONFIRM' ,p_attribute_01=>'Are you sure you want to revoke this role?' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984637708392825746) ,p_event_id=>wwv_flow_api.id(7984637661253825745) ,p_event_result=>'TRUE' ,p_action_sequence=>20 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_SET_VALUE' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P215_UR_ID' ,p_attribute_01=>'JAVASCRIPT_EXPRESSION' ,p_attribute_05=>'this.triggeringElement.dataset.id' ,p_attribute_09=>'N' ,p_stop_execution_on_error=>'Y' ,p_wait_for_result=>'Y' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984637985164825748) ,p_event_id=>wwv_flow_api.id(7984637661253825745) ,p_event_result=>'TRUE' ,p_action_sequence=>30 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_EXECUTE_PLSQL_CODE' ,p_attribute_01=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'delete', 'from app_user_roles', 'where id = :P215_UR_ID;')) ,p_attribute_02=>'P215_UR_ID' ,p_stop_execution_on_error=>'Y' ,p_wait_for_result=>'Y' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984698051951825749) ,p_event_id=>wwv_flow_api.id(7984637661253825745) ,p_event_result=>'TRUE' ,p_action_sequence=>40 ,p_execute_on_page_init=>'N' ,p_action=>'PLUGIN_COM.ORACLE.APEX.GRITTER_NOTIFICATION' ,p_attribute_01=>'Role' ,p_attribute_02=>'Role has been revoked from #P215_USERNAME#' ,p_attribute_04=>'N' ,p_attribute_05=>'3' ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(7984698192047825750) ,p_event_id=>wwv_flow_api.id(7984637661253825745) ,p_event_result=>'TRUE' ,p_action_sequence=>50 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_REFRESH' ,p_affected_elements_type=>'REGION' ,p_affected_region_id=>wwv_flow_api.id(7984635096949825719) ); wwv_flow_api.create_page_da_action( p_id=>wwv_flow_api.id(8251130351119330501) ,p_event_id=>wwv_flow_api.id(7984637661253825745) ,p_event_result=>'TRUE' ,p_action_sequence=>60 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_REFRESH' ,p_affected_elements_type=>'ITEM' ,p_affected_elements=>'P215_ROLE_KEY' ); wwv_flow_api.create_page_process( p_id=>wwv_flow_api.id(8249551744717032033) ,p_process_sequence=>10 ,p_process_point=>'AFTER_HEADER' ,p_process_type=>'NATIVE_FORM_FETCH' ,p_process_name=>'Fetch Row from APP_USERS' ,p_attribute_02=>'APP_USERS' ,p_attribute_03=>'P215_ID' ,p_attribute_04=>'ID' ); wwv_flow_api.create_page_process( p_id=>wwv_flow_api.id(8249552133432032034) ,p_process_sequence=>30 ,p_process_point=>'AFTER_SUBMIT' ,p_process_type=>'NATIVE_FORM_PROCESS' ,p_process_name=>'Process Row of APP_USERS' ,p_attribute_02=>'APP_USERS' ,p_attribute_03=>'P215_ID' ,p_attribute_04=>'ID' ,p_attribute_11=>'U' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ,p_process_success_message=>'Action Processed.' ); wwv_flow_api.create_page_process( p_id=>wwv_flow_api.id(8249552541926032035) ,p_process_sequence=>40 ,p_process_point=>'AFTER_SUBMIT' ,p_process_type=>'NATIVE_SESSION_STATE' ,p_process_name=>'reset page' ,p_attribute_01=>'CLEAR_CACHE_CURRENT_PAGE' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ); end; / prompt --application/deployment/definition begin null; end; / prompt --application/deployment/install begin null; 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