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.0.00.31' ,p_default_workspace_id=>35483170619760214768 ,p_default_application_id=>24166 ,p_default_owner=>'DETORA' ); end; / prompt --application/set_environment prompt APPLICATION 24166 - SPA V4 -- -- Application Export: -- Application: 24166 -- Name: SPA V4 -- Date and Time: 20:00 Saturday June 20, 2015 -- Exported By: DICK.DRAL@DETORA.NL -- Flashback: 0 -- Export Type: Application Export -- Version: 5.0.0.00.31 -- Instance ID: 63113759365424 -- -- Application Statistics: -- Pages: 2 -- Items: 13 -- Processes: 6 -- Regions: 4 -- Buttons: 5 -- Dynamic Actions: 3 -- Shared Components: -- Logic: -- Navigation: -- Lists: 2 -- Breadcrumbs: 1 -- Entries: 1 -- Security: -- Authentication: 2 -- User Interface: -- Themes: 1 -- Templates: -- Page: 9 -- Region: 13 -- Label: 5 -- List: 11 -- Popup LOV: 1 -- Calendar: 1 -- Breadcrumb: 1 -- Button: 3 -- Report: 9 -- Shortcuts: 1 -- Globalization: -- Reports: -- Supporting Objects: Included -- Install scripts: 2 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,24166) ,p_owner=>nvl(wwv_flow_application_install.get_schema,'DETORA') ,p_name=>nvl(wwv_flow_application_install.get_application_name,'SPA V4') ,p_alias=>nvl(wwv_flow_application_install.get_application_alias,'KSCOPE_SPA') ,p_page_view_logging=>'YES' ,p_page_protection_enabled_y_n=>'Y' ,p_checksum_salt=>'D31D7C2890D35A058C42079DCF6328CD53AFDBE7C58717B48E3320E7A54A7086' ,p_bookmark_checksum_function=>'SH512' ,p_compatibility_mode=>'5.0' ,p_flow_language=>'en' ,p_flow_language_derived_from=>'FLOW_PRIMARY_LANGUAGE' ,p_date_format=>'dd-mm-yyyy' ,p_flow_image_prefix => nvl(wwv_flow_application_install.get_image_prefix,'') ,p_authentication=>'PLUGIN' ,p_authentication_id=>wwv_flow_api.id(7991809412078552627) ,p_application_tab_set=>0 ,p_logo_image=>'TEXT:SPA4' ,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_browser_frame=>'D' ,p_rejoin_existing_sessions=>'N' ,p_csv_encoding=>'Y' ,p_last_updated_by=>'DICK.DRAL@DETORA.NL' ,p_last_upd_yyyymmddhh24miss=>'20150620200011' ,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(7991763378211545743) ,p_name=>'Desktop Navigation Menu' ,p_list_status=>'PUBLIC' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(7991806980462545845) ,p_list_item_display_sequence=>10 ,p_list_item_link_text=>'Employee list' ,p_list_item_link_target=>'javascript:emp_list_show()' ,p_list_item_icon=>'fa-home' ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'1' ); wwv_flow_api.create_list( p_id=>wwv_flow_api.id(7991805467424545827) ,p_name=>'Desktop Navigation Bar' ,p_list_status=>'PUBLIC' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(7991805621722545830) ,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(7991763036850545742) ,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(7991763185894545743) ,p_plugin_type=>'REGION TYPE' ,p_plugin=>'NATIVE_CSS_CALENDAR' ); wwv_flow_api.create_plugin_setting( p_id=>wwv_flow_api.id(7991763236571545743) ,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 null; 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(7991806803643545839) ,p_name=>' Breadcrumb' ); wwv_flow_api.create_menu_option( p_id=>wwv_flow_api.id(7991807200279545845) ,p_parent_id=>0 ,p_short_name=>'Home' ,p_link=>'f?p=&APP_ID.:1:&APP_SESSION.::&DEBUG.' ,p_page_id=>1 ); end; / prompt --application/shared_components/user_interface/templates/page begin wwv_flow_api.create_template( p_id=>wwv_flow_api.id(7991763477600545744) ,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( '', '', '', '', '', '', '', ' ', '', ' ', ' #TITLE#', ' #APEX_CSS#', ' #THEME_CSS#', ' #TEMPLATE_CSS#', ' #THEME_STYLE_CSS#', ' #APPLICATION_CSS#', ' #PAGE_CSS#', ' #FAVICONS#', ' #HEAD#', ' ', '', '', '#FORM_OPEN#', '
', ' #REGION_POSITION_07#', '
', '
', ' ', '
', ' ', '
', ' #NAVIGATION_BAR#', '
', '
', '
', ' #TOP_GLOBAL_NAVIGATION_LIST#', ' #REGION_POSITION_06#', '
', '
')) ,p_box=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
', '#SIDE_GLOBAL_NAVIGATION_LIST#', '
', '
', ' #REGION_POSITION_01#', '
', '
', ' #REGION_POSITION_02#', '
', '
', ' #SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#', '
', ' #BODY#', '
', ' ', '
', '
', '
', '
', ' #REGION_POSITION_04#', '
')) ,p_footer_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '#FORM_CLOSE#', '#DEVELOPER_TOOLBAR#', '#APEX_JAVASCRIPT#', '#GENERATED_CSS#', '#THEME_JAVASCRIPT#', '#TEMPLATE_JAVASCRIPT#', '#APPLICATION_JAVASCRIPT#', '#PAGE_JAVASCRIPT# ', '#GENERATED_JAVASCRIPT#', '', '')) ,p_success_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
', ' ', '
')) ,p_notification_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
', ' ', '
')) ,p_navigation_bar=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '')) ,p_navbar_entry=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ', ' ', ' #TEXT#', ' ', '
  • ')) ,p_region_table_cattributes=>' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"' ,p_breadcrumb_def_reg_pos=>'REGION_POSITION_01' ,p_theme_class_id=>17 ,p_error_page_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ', '

    #MESSAGE#

    ', '

    #ADDITIONAL_INFO#

    ', '
    #TECHNICAL_INFO#
    ', '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ')) ,p_grid_type=>'FIXED' ,p_grid_max_columns=>12 ,p_grid_always_use_max_columns=>true ,p_grid_has_column_span=>true ,p_grid_always_emit=>true ,p_grid_emit_empty_leading_cols=>true ,p_grid_emit_empty_trail_cols=>false ,p_grid_default_label_col_span=>3 ,p_grid_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#ROWS#', '
    ')) ,p_grid_row_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#COLUMNS#', '
    ')) ,p_grid_column_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#CONTENT#', '
    ')) ,p_grid_first_column_attributes=>'alpha' ,p_grid_last_column_attributes=>'omega' ,p_dialog_js_init_code=>'apex.navigation.dialog(#PAGE_URL#,{title:#TITLE#,height:#DIALOG_HEIGHT#,width:#DIALOG_WIDTH#,maxWidth:#DIALOG_MAX_WIDTH#,modal:#IS_MODAL#,dialog:#DIALOG#,#DIALOG_ATTRIBUTES#},#DIALOG_CSS_CLASSES#,#TRIGGERING_ELEMENT#);' ,p_dialog_js_close_code=>'apex.navigation.dialog.close(#IS_MODAL#,#TARGET#);' ,p_dialog_js_cancel_code=>'apex.navigation.dialog.cancel(#IS_MODAL#);' ,p_dialog_browser_frame=>'MODAL' ,p_reference_id=>2525196570560608698 ,p_translate_this_template=>'N' ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991763527464545750) ,p_page_template_id=>wwv_flow_api.id(7991763477600545744) ,p_name=>'Content Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>false ,p_max_fixed_grid_columns=>8 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991763659039545751) ,p_page_template_id=>wwv_flow_api.id(7991763477600545744) ,p_name=>'Breadcrumb Bar' ,p_placeholder=>'REGION_POSITION_01' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991763751635545751) ,p_page_template_id=>wwv_flow_api.id(7991763477600545744) ,p_name=>'Left Column' ,p_placeholder=>'REGION_POSITION_02' ,p_has_grid_support=>false ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>4 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991763851188545751) ,p_page_template_id=>wwv_flow_api.id(7991763477600545744) ,p_name=>'Inline Dialogs' ,p_placeholder=>'REGION_POSITION_04' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991763995070545751) ,p_page_template_id=>wwv_flow_api.id(7991763477600545744) ,p_name=>'Footer' ,p_placeholder=>'REGION_POSITION_05' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>8 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991764042763545751) ,p_page_template_id=>wwv_flow_api.id(7991763477600545744) ,p_name=>'Page Navigation' ,p_placeholder=>'REGION_POSITION_06' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991764166200545751) ,p_page_template_id=>wwv_flow_api.id(7991763477600545744) ,p_name=>'Page Header' ,p_placeholder=>'REGION_POSITION_07' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991764260403545751) ,p_page_template_id=>wwv_flow_api.id(7991763477600545744) ,p_name=>'Before Navigation Bar' ,p_placeholder=>'REGION_POSITION_08' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_template( p_id=>wwv_flow_api.id(7991764353201545752) ,p_theme_id=>42 ,p_name=>'Left and Right Side Columns' ,p_is_popup=>false ,p_javascript_code_onload=>'apex.theme42.initializePage.bothSideCols();' ,p_header_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '', '', '', '', '', '', '', ' ', '', ' ', ' #TITLE#', ' #APEX_CSS#', ' #THEME_CSS#', ' #TEMPLATE_CSS#', ' #THEME_STYLE_CSS#', ' #APPLICATION_CSS#', ' #PAGE_CSS#', ' #FAVICONS#', ' #HEAD#', ' ', '', '', '#FORM_OPEN#', '
    ', ' #REGION_POSITION_07#', '
    ', '
    ', ' ', '
    ', ' ', '
    ', ' #NAVIGATION_BAR#', '
    ', '
    ', '
    ', ' #TOP_GLOBAL_NAVIGATION_LIST#', ' #REGION_POSITION_06#', '
    ', '
    ')) ,p_box=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#SIDE_GLOBAL_NAVIGATION_LIST#', '
    ', '
    ', ' #REGION_POSITION_01#', '
    ', '
    ', ' #REGION_POSITION_02#', '
    ', '
    ', ' #SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#', '
    ', ' #BODY#', '
    ', '
    ', ' #APP_VERSION#', ' #CUSTOMIZE#', ' #SCREEN_READER_TOGGLE#', ' #REGION_POSITION_05#', '
    ', '
    ', '
    ', '
    ', ' ', '
    ', ' #REGION_POSITION_03#', '
    ', '
    ', '
    ', '
    ', ' #REGION_POSITION_04#', '
    ')) ,p_footer_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '#FORM_CLOSE#', '#DEVELOPER_TOOLBAR#', '#APEX_JAVASCRIPT#', '#GENERATED_CSS#', '#THEME_JAVASCRIPT#', '#TEMPLATE_JAVASCRIPT#', '#APPLICATION_JAVASCRIPT#', '#PAGE_JAVASCRIPT# ', '#GENERATED_JAVASCRIPT#', '', '')) ,p_success_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_notification_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_navigation_bar=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '')) ,p_navbar_entry=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ', ' ', ' #TEXT#', ' ', '
  • ')) ,p_region_table_cattributes=>' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"' ,p_sidebar_def_reg_pos=>'REGION_POSITION_03' ,p_breadcrumb_def_reg_pos=>'REGION_POSITION_01' ,p_theme_class_id=>17 ,p_error_page_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ', '

    #MESSAGE#

    ', '

    #ADDITIONAL_INFO#

    ', '
    #TECHNICAL_INFO#
    ', '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ')) ,p_grid_type=>'FIXED' ,p_grid_max_columns=>12 ,p_grid_always_use_max_columns=>true ,p_grid_has_column_span=>true ,p_grid_always_emit=>false ,p_grid_emit_empty_leading_cols=>true ,p_grid_emit_empty_trail_cols=>false ,p_grid_default_label_col_span=>3 ,p_grid_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#ROWS#', '
    ')) ,p_grid_row_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#COLUMNS#', '
    ')) ,p_grid_column_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#CONTENT#', '
    ')) ,p_grid_first_column_attributes=>'alpha' ,p_grid_last_column_attributes=>'omega' ,p_dialog_js_init_code=>'apex.navigation.dialog(#PAGE_URL#,{title:#TITLE#,height:#DIALOG_HEIGHT#,width:#DIALOG_WIDTH#,maxWidth:#DIALOG_MAX_WIDTH#,modal:#IS_MODAL#,dialog:#DIALOG#,#DIALOG_ATTRIBUTES#},#DIALOG_CSS_CLASSES#,#TRIGGERING_ELEMENT#);' ,p_dialog_js_close_code=>'apex.navigation.dialog.close(#IS_MODAL#,#TARGET#);' ,p_dialog_js_cancel_code=>'apex.navigation.dialog.cancel(#IS_MODAL#);' ,p_dialog_browser_frame=>'MODAL' ,p_reference_id=>2525203692562657055 ,p_translate_this_template=>'N' ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991764409894545755) ,p_page_template_id=>wwv_flow_api.id(7991764353201545752) ,p_name=>'Content Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>false ,p_max_fixed_grid_columns=>6 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991764540126545755) ,p_page_template_id=>wwv_flow_api.id(7991764353201545752) ,p_name=>'Breadcrumb Bar' ,p_placeholder=>'REGION_POSITION_01' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991764665417545755) ,p_page_template_id=>wwv_flow_api.id(7991764353201545752) ,p_name=>'Left Column' ,p_placeholder=>'REGION_POSITION_02' ,p_has_grid_support=>false ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>3 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991764735452545755) ,p_page_template_id=>wwv_flow_api.id(7991764353201545752) ,p_name=>'Right Column' ,p_placeholder=>'REGION_POSITION_03' ,p_has_grid_support=>false ,p_glv_new_row=>false ,p_max_fixed_grid_columns=>3 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991764867686545755) ,p_page_template_id=>wwv_flow_api.id(7991764353201545752) ,p_name=>'Inline Dialogs' ,p_placeholder=>'REGION_POSITION_04' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991764946361545755) ,p_page_template_id=>wwv_flow_api.id(7991764353201545752) ,p_name=>'Footer' ,p_placeholder=>'REGION_POSITION_05' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>6 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991765007208545755) ,p_page_template_id=>wwv_flow_api.id(7991764353201545752) ,p_name=>'Page Navigation' ,p_placeholder=>'REGION_POSITION_06' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991765106414545755) ,p_page_template_id=>wwv_flow_api.id(7991764353201545752) ,p_name=>'Page Header' ,p_placeholder=>'REGION_POSITION_07' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991765233133545755) ,p_page_template_id=>wwv_flow_api.id(7991764353201545752) ,p_name=>'Before Navigation Bar' ,p_placeholder=>'REGION_POSITION_08' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_template( p_id=>wwv_flow_api.id(7991765358612545755) ,p_theme_id=>42 ,p_name=>'Login' ,p_is_popup=>false ,p_javascript_code_onload=>'apex.theme42.initializePage.appLogin();' ,p_header_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '', '', '', '', '', '', '', ' ', '', ' ', ' #TITLE#', ' #APEX_CSS#', ' #THEME_CSS#', ' #TEMPLATE_CSS#', ' #THEME_STYLE_CSS#', ' #APPLICATION_CSS#', ' #PAGE_CSS#', ' #FAVICONS#', ' #HEAD#', ' ', '', '', '#FORM_OPEN#')) ,p_box=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' #REGION_POSITION_01#', ' #SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#', '
    ', '
    ', ' ', '
    ', '
    ', '
    ')) ,p_footer_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '#FORM_CLOSE#', '#DEVELOPER_TOOLBAR#', '#APEX_JAVASCRIPT#', '#GENERATED_CSS#', '#THEME_JAVASCRIPT#', '#TEMPLATE_JAVASCRIPT#', '#APPLICATION_JAVASCRIPT#', '#PAGE_JAVASCRIPT# ', '#GENERATED_JAVASCRIPT#', '', '')) ,p_success_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_notification_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_region_table_cattributes=>' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"' ,p_breadcrumb_def_reg_pos=>'REGION_POSITION_01' ,p_theme_class_id=>6 ,p_error_page_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ', '

    #MESSAGE#

    ', '

    #ADDITIONAL_INFO#

    ', '
    #TECHNICAL_INFO#
    ', '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ')) ,p_grid_type=>'FIXED' ,p_grid_max_columns=>12 ,p_grid_always_use_max_columns=>true ,p_grid_has_column_span=>true ,p_grid_always_emit=>true ,p_grid_emit_empty_leading_cols=>true ,p_grid_emit_empty_trail_cols=>false ,p_grid_default_label_col_span=>3 ,p_grid_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#ROWS#', '
    ')) ,p_grid_row_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#COLUMNS#', '
    ')) ,p_grid_column_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#CONTENT#', '
    ')) ,p_grid_first_column_attributes=>'alpha' ,p_grid_last_column_attributes=>'omega' ,p_dialog_js_init_code=>'apex.navigation.dialog(#PAGE_URL#,{title:#TITLE#,height:#DIALOG_HEIGHT#,width:#DIALOG_WIDTH#,maxWidth:#DIALOG_MAX_WIDTH#,modal:#IS_MODAL#,dialog:#DIALOG#,#DIALOG_ATTRIBUTES#},#DIALOG_CSS_CLASSES#,#TRIGGERING_ELEMENT#);' ,p_dialog_js_close_code=>'apex.navigation.dialog.close(#IS_MODAL#,#TARGET#);' ,p_dialog_js_cancel_code=>'apex.navigation.dialog.cancel(#IS_MODAL#);' ,p_dialog_browser_frame=>'MODAL' ,p_reference_id=>2099711150063350616 ,p_translate_this_template=>'N' ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991765420068545755) ,p_page_template_id=>wwv_flow_api.id(7991765358612545755) ,p_name=>'Content Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991765557347545755) ,p_page_template_id=>wwv_flow_api.id(7991765358612545755) ,p_name=>'Body Header' ,p_placeholder=>'REGION_POSITION_01' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_template( p_id=>wwv_flow_api.id(7991765611849545755) ,p_theme_id=>42 ,p_name=>'Master Detail' ,p_is_popup=>false ,p_javascript_code_onload=>'apex.theme42.initializePage.masterDetail();' ,p_header_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '', '', '', '', '', '', '', ' ', '', ' ', ' #TITLE#', ' #APEX_CSS#', ' #THEME_CSS#', ' #TEMPLATE_CSS#', ' #THEME_STYLE_CSS#', ' #APPLICATION_CSS#', ' #PAGE_CSS#', ' #FAVICONS#', ' #HEAD#', ' ', '', '', '#FORM_OPEN#', '
    ', ' #REGION_POSITION_07#', '
    ', '
    ', ' ', '
    ', ' ', '
    ', ' #NAVIGATION_BAR#', '
    ', '
    ', '
    ', ' #TOP_GLOBAL_NAVIGATION_LIST#', ' #REGION_POSITION_06#', '
    ', '
    ')) ,p_box=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#SIDE_GLOBAL_NAVIGATION_LIST#', '
    ', '
    ', ' #REGION_POSITION_01#', '
    ', '
    ', ' #SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#', '
    ', ' #REGION_POSITION_02#', '
    ', '
    ', ' #BODY#', '
    ', '
    ', ' #APP_VERSION#', ' #CUSTOMIZE#', ' #SCREEN_READER_TOGGLE#', ' #REGION_POSITION_05#', '
    ', '
    ', '
    ', '
    ', ' ', '
    ', ' #REGION_POSITION_03#', '
    ', '
    ', '
    ', '
    ', ' #REGION_POSITION_04#', '
    ')) ,p_footer_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '#FORM_CLOSE#', '#DEVELOPER_TOOLBAR#', '#APEX_JAVASCRIPT#', '#GENERATED_CSS#', '#THEME_JAVASCRIPT#', '#TEMPLATE_JAVASCRIPT#', '#APPLICATION_JAVASCRIPT#', '#PAGE_JAVASCRIPT# ', '#GENERATED_JAVASCRIPT#', '', '')) ,p_success_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_notification_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_navigation_bar=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '')) ,p_navbar_entry=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ', ' ', ' #TEXT#', ' ', '
  • ')) ,p_region_table_cattributes=>' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"' ,p_sidebar_def_reg_pos=>'REGION_POSITION_03' ,p_breadcrumb_def_reg_pos=>'REGION_POSITION_01' ,p_theme_class_id=>17 ,p_error_page_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ', '

    #MESSAGE#

    ', '

    #ADDITIONAL_INFO#

    ', '
    #TECHNICAL_INFO#
    ', '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ')) ,p_grid_type=>'FIXED' ,p_grid_max_columns=>12 ,p_grid_always_use_max_columns=>true ,p_grid_has_column_span=>true ,p_grid_always_emit=>true ,p_grid_emit_empty_leading_cols=>true ,p_grid_emit_empty_trail_cols=>false ,p_grid_default_label_col_span=>3 ,p_grid_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#ROWS#', '
    ')) ,p_grid_row_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#COLUMNS#', '
    ')) ,p_grid_column_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#CONTENT#', '
    ')) ,p_grid_first_column_attributes=>'alpha' ,p_grid_last_column_attributes=>'omega' ,p_dialog_js_init_code=>'apex.navigation.dialog(#PAGE_URL#,{title:#TITLE#,height:#DIALOG_HEIGHT#,width:#DIALOG_WIDTH#,maxWidth:#DIALOG_MAX_WIDTH#,modal:#IS_MODAL#,dialog:#DIALOG#,#DIALOG_ATTRIBUTES#},#DIALOG_CSS_CLASSES#,#TRIGGERING_ELEMENT#);' ,p_dialog_js_close_code=>'apex.navigation.dialog.close(#IS_MODAL#,#TARGET#);' ,p_dialog_js_cancel_code=>'apex.navigation.dialog.cancel(#IS_MODAL#);' ,p_dialog_browser_frame=>'MODAL' ,p_reference_id=>1996914646461572319 ,p_translate_this_template=>'N' ); end; / begin wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991765706527545756) ,p_page_template_id=>wwv_flow_api.id(7991765611849545755) ,p_name=>'Content Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>8 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991765828358545756) ,p_page_template_id=>wwv_flow_api.id(7991765611849545755) ,p_name=>'Breadcrumb Bar' ,p_placeholder=>'REGION_POSITION_01' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991765918039545756) ,p_page_template_id=>wwv_flow_api.id(7991765611849545755) ,p_name=>'Master Detail' ,p_placeholder=>'REGION_POSITION_02' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991766044062545756) ,p_page_template_id=>wwv_flow_api.id(7991765611849545755) ,p_name=>'Right Side Column' ,p_placeholder=>'REGION_POSITION_03' ,p_has_grid_support=>false ,p_glv_new_row=>false ,p_max_fixed_grid_columns=>4 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991766180070545756) ,p_page_template_id=>wwv_flow_api.id(7991765611849545755) ,p_name=>'Inline Dialogs' ,p_placeholder=>'REGION_POSITION_04' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991766275975545757) ,p_page_template_id=>wwv_flow_api.id(7991765611849545755) ,p_name=>'Footer' ,p_placeholder=>'REGION_POSITION_05' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>8 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991766375836545757) ,p_page_template_id=>wwv_flow_api.id(7991765611849545755) ,p_name=>'Page Navigation' ,p_placeholder=>'REGION_POSITION_06' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991766484639545757) ,p_page_template_id=>wwv_flow_api.id(7991765611849545755) ,p_name=>'Page Header' ,p_placeholder=>'REGION_POSITION_07' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991766572644545757) ,p_page_template_id=>wwv_flow_api.id(7991765611849545755) ,p_name=>'Before Navigation Bar' ,p_placeholder=>'REGION_POSITION_08' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_template( p_id=>wwv_flow_api.id(7991766603608545757) ,p_theme_id=>42 ,p_name=>'Minimal (No Navigation)' ,p_is_popup=>false ,p_javascript_code_onload=>'apex.theme42.initializePage.noSideCol();' ,p_header_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '', '', '', '', '', '', '', ' ', '', ' ', ' #TITLE#', ' #APEX_CSS#', ' #THEME_CSS#', ' #TEMPLATE_CSS#', ' #THEME_STYLE_CSS#', ' #APPLICATION_CSS#', ' #PAGE_CSS# ', ' #FAVICONS#', ' #HEAD#', ' ', '', '', '#FORM_OPEN#', '
    ', ' #REGION_POSITION_07#', '
    ', '
    ', ' ', '
    ', ' ', '
    ', ' #NAVIGATION_BAR#', '
    ', '
    ', '
    ', ' ')) ,p_box=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' #REGION_POSITION_01#', '
    ', '
    ', ' #SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#', '
    ', ' #BODY#', '
    ', ' ', '
    ', '
    ', '
    ', '
    ', ' #REGION_POSITION_04#', '
    ')) ,p_footer_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '#FORM_CLOSE#', '#DEVELOPER_TOOLBAR#', '#APEX_JAVASCRIPT#', '#GENERATED_CSS#', '#THEME_JAVASCRIPT#', '#TEMPLATE_JAVASCRIPT#', '#APPLICATION_JAVASCRIPT#', '#PAGE_JAVASCRIPT# ', '#GENERATED_JAVASCRIPT#', '', '', '')) ,p_success_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_notification_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_navigation_bar=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '')) ,p_navbar_entry=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ', ' ', ' #TEXT#', ' ', '
  • ')) ,p_region_table_cattributes=>' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"' ,p_breadcrumb_def_reg_pos=>'REGION_POSITION_01' ,p_theme_class_id=>4 ,p_error_page_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ', '

    #MESSAGE#

    ', '

    #ADDITIONAL_INFO#

    ', '
    #TECHNICAL_INFO#
    ', '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ')) ,p_grid_type=>'FIXED' ,p_grid_max_columns=>12 ,p_grid_always_use_max_columns=>true ,p_grid_has_column_span=>true ,p_grid_always_emit=>true ,p_grid_emit_empty_leading_cols=>true ,p_grid_emit_empty_trail_cols=>false ,p_grid_default_label_col_span=>3 ,p_grid_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#ROWS#', '
    ')) ,p_grid_row_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#COLUMNS#', '
    ')) ,p_grid_column_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#CONTENT#', '
    ')) ,p_grid_first_column_attributes=>'alpha' ,p_grid_last_column_attributes=>'omega' ,p_dialog_js_init_code=>'apex.navigation.dialog(#PAGE_URL#,{title:#TITLE#,height:#DIALOG_HEIGHT#,width:#DIALOG_WIDTH#,maxWidth:#DIALOG_MAX_WIDTH#,modal:#IS_MODAL#,dialog:#DIALOG#,#DIALOG_ATTRIBUTES#},#DIALOG_CSS_CLASSES#,#TRIGGERING_ELEMENT#);' ,p_dialog_js_close_code=>'apex.navigation.dialog.close(#IS_MODAL#,#TARGET#);' ,p_dialog_js_cancel_code=>'apex.navigation.dialog.cancel(#IS_MODAL#);' ,p_dialog_browser_frame=>'MODAL' ,p_reference_id=>2977628563533209425 ,p_translate_this_template=>'N' ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991766797076545758) ,p_page_template_id=>wwv_flow_api.id(7991766603608545757) ,p_name=>'Content Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991766853629545758) ,p_page_template_id=>wwv_flow_api.id(7991766603608545757) ,p_name=>'Breadcrumb Bar' ,p_placeholder=>'REGION_POSITION_01' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991766937412545758) ,p_page_template_id=>wwv_flow_api.id(7991766603608545757) ,p_name=>'Inline Dialogs' ,p_placeholder=>'REGION_POSITION_04' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991767040755545758) ,p_page_template_id=>wwv_flow_api.id(7991766603608545757) ,p_name=>'Footer' ,p_placeholder=>'REGION_POSITION_05' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991767161352545758) ,p_page_template_id=>wwv_flow_api.id(7991766603608545757) ,p_name=>'Page Navigation' ,p_placeholder=>'REGION_POSITION_06' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991767271537545758) ,p_page_template_id=>wwv_flow_api.id(7991766603608545757) ,p_name=>'Page Header' ,p_placeholder=>'REGION_POSITION_07' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991767368931545758) ,p_page_template_id=>wwv_flow_api.id(7991766603608545757) ,p_name=>'Before Navigation Bar' ,p_placeholder=>'REGION_POSITION_08' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_template( p_id=>wwv_flow_api.id(7991767475307545758) ,p_theme_id=>42 ,p_name=>'Modal Dialog' ,p_is_popup=>true ,p_javascript_code_onload=>'apex.theme42.initializePage.modalDialog();' ,p_header_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '', '', '', '', '', '', '', ' ', '', ' ', ' #TITLE#', ' #APEX_CSS#', ' #THEME_CSS#', ' #TEMPLATE_CSS#', ' #THEME_STYLE_CSS#', ' #APPLICATION_CSS#', ' #PAGE_CSS#', ' #FAVICONS#', ' #HEAD#', ' ', '', '', '#FORM_OPEN#')) ,p_box=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '')) ,p_footer_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '#FORM_CLOSE#', '#DEVELOPER_TOOLBAR#', '#APEX_JAVASCRIPT#', '#GENERATED_CSS#', '#THEME_JAVASCRIPT#', '#TEMPLATE_JAVASCRIPT#', '#APPLICATION_JAVASCRIPT#', '#PAGE_JAVASCRIPT# ', '#GENERATED_JAVASCRIPT#', '', '')) ,p_success_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_notification_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_region_table_cattributes=>' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"' ,p_breadcrumb_def_reg_pos=>'REGION_POSITION_01' ,p_theme_class_id=>3 ,p_error_page_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ', '

    #MESSAGE#

    ', '

    #ADDITIONAL_INFO#

    ', '
    #TECHNICAL_INFO#
    ', '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ')) ,p_grid_type=>'FIXED' ,p_grid_max_columns=>12 ,p_grid_always_use_max_columns=>true ,p_grid_has_column_span=>true ,p_grid_always_emit=>true ,p_grid_emit_empty_leading_cols=>true ,p_grid_emit_empty_trail_cols=>false ,p_grid_default_label_col_span=>3 ,p_grid_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#ROWS#', '
    ')) ,p_grid_row_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#COLUMNS#', '
    ')) ,p_grid_column_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#CONTENT#', '
    ')) ,p_grid_first_column_attributes=>'alpha' ,p_grid_last_column_attributes=>'omega' ,p_dialog_js_init_code=>'apex.navigation.dialog(#PAGE_URL#,{title:#TITLE#,height:#DIALOG_HEIGHT#,width:#DIALOG_WIDTH#,maxWidth:#DIALOG_MAX_WIDTH#,modal:#IS_MODAL#,dialog:#DIALOG#,#DIALOG_ATTRIBUTES#},#DIALOG_CSS_CLASSES#,#TRIGGERING_ELEMENT#);' ,p_dialog_js_close_code=>'apex.navigation.dialog.close(#IS_MODAL#,#TARGET#);' ,p_dialog_js_cancel_code=>'apex.navigation.dialog.cancel(#IS_MODAL#);' ,p_dialog_height=>'500' ,p_dialog_width=>'720' ,p_dialog_max_width=>'960' ,p_dialog_css_classes=>'t-Dialog--standard' ,p_dialog_browser_frame=>'MODAL' ,p_reference_id=>2098960803539086924 ,p_translate_this_template=>'N' ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991767510978545758) ,p_page_template_id=>wwv_flow_api.id(7991767475307545758) ,p_name=>'Content Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991767695642545758) ,p_page_template_id=>wwv_flow_api.id(7991767475307545758) ,p_name=>'Dialog Header' ,p_placeholder=>'REGION_POSITION_01' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991767754992545758) ,p_page_template_id=>wwv_flow_api.id(7991767475307545758) ,p_name=>'Dialog Footer' ,p_placeholder=>'REGION_POSITION_03' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_template( p_id=>wwv_flow_api.id(7991767806614545758) ,p_theme_id=>42 ,p_name=>'Right Side Column' ,p_is_popup=>false ,p_javascript_code_onload=>'apex.theme42.initializePage.rightSideCol();' ,p_header_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '', '', '', '', '', '', '', ' ', '', ' ', ' #TITLE#', ' #APEX_CSS#', ' #THEME_CSS#', ' #TEMPLATE_CSS#', ' #THEME_STYLE_CSS#', ' #APPLICATION_CSS#', ' #PAGE_CSS#', ' #FAVICONS#', ' #HEAD#', ' ', '', '', '#FORM_OPEN#', '
    ', ' #REGION_POSITION_07#', '
    ', '
    ', ' ', '
    ', ' ', '
    ', ' #NAVIGATION_BAR#', '
    ', '
    ', '
    ', ' #TOP_GLOBAL_NAVIGATION_LIST#', ' #REGION_POSITION_06#', '
    ', '
    ')) ,p_box=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#SIDE_GLOBAL_NAVIGATION_LIST#', '
    ', '
    ', ' #REGION_POSITION_01#', '
    ', '
    ', ' #SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#', '
    ', ' #BODY#', '
    ', '
    ', ' #APP_VERSION#', ' #CUSTOMIZE#', ' #SCREEN_READER_TOGGLE#', ' #REGION_POSITION_05#', '
    ', '
    ', '
    ', '
    ', ' ', '
    ', ' #REGION_POSITION_03#', '
    ', '
    ', '
    ', '
    ', ' #REGION_POSITION_04#', '
    ')) ,p_footer_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '#FORM_CLOSE#', '#DEVELOPER_TOOLBAR#', '#APEX_JAVASCRIPT#', '#GENERATED_CSS#', '#THEME_JAVASCRIPT#', '#TEMPLATE_JAVASCRIPT#', '#APPLICATION_JAVASCRIPT#', '#PAGE_JAVASCRIPT# ', '#GENERATED_JAVASCRIPT#', '', '')) ,p_success_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_notification_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_navigation_bar=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '')) ,p_navbar_entry=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ', ' ', ' #TEXT#', ' ', '
  • ')) ,p_region_table_cattributes=>' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"' ,p_sidebar_def_reg_pos=>'REGION_POSITION_03' ,p_breadcrumb_def_reg_pos=>'REGION_POSITION_01' ,p_theme_class_id=>17 ,p_error_page_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ', '

    #MESSAGE#

    ', '

    #ADDITIONAL_INFO#

    ', '
    #TECHNICAL_INFO#
    ', '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ')) ,p_grid_type=>'FIXED' ,p_grid_max_columns=>12 ,p_grid_always_use_max_columns=>true ,p_grid_has_column_span=>true ,p_grid_always_emit=>false ,p_grid_emit_empty_leading_cols=>true ,p_grid_emit_empty_trail_cols=>false ,p_grid_default_label_col_span=>3 ,p_grid_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#ROWS#', '
    ')) ,p_grid_row_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#COLUMNS#', '
    ')) ,p_grid_column_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#CONTENT#', '
    ')) ,p_grid_first_column_attributes=>'alpha' ,p_grid_last_column_attributes=>'omega' ,p_dialog_js_init_code=>'apex.navigation.dialog(#PAGE_URL#,{title:#TITLE#,height:#DIALOG_HEIGHT#,width:#DIALOG_WIDTH#,maxWidth:#DIALOG_MAX_WIDTH#,modal:#IS_MODAL#,dialog:#DIALOG#,#DIALOG_ATTRIBUTES#},#DIALOG_CSS_CLASSES#,#TRIGGERING_ELEMENT#);' ,p_dialog_js_close_code=>'apex.navigation.dialog.close(#IS_MODAL#,#TARGET#);' ,p_dialog_js_cancel_code=>'apex.navigation.dialog.cancel(#IS_MODAL#);' ,p_dialog_browser_frame=>'MODAL' ,p_reference_id=>2525200116240651575 ,p_translate_this_template=>'N' ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991767930293545759) ,p_page_template_id=>wwv_flow_api.id(7991767806614545758) ,p_name=>'Content Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>8 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991768067480545759) ,p_page_template_id=>wwv_flow_api.id(7991767806614545758) ,p_name=>'Breadcrumb Bar' ,p_placeholder=>'REGION_POSITION_01' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991768161680545759) ,p_page_template_id=>wwv_flow_api.id(7991767806614545758) ,p_name=>'Right Column' ,p_placeholder=>'REGION_POSITION_03' ,p_has_grid_support=>false ,p_glv_new_row=>false ,p_max_fixed_grid_columns=>4 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991768292482545759) ,p_page_template_id=>wwv_flow_api.id(7991767806614545758) ,p_name=>'Inline Dialogs' ,p_placeholder=>'REGION_POSITION_04' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991768337932545759) ,p_page_template_id=>wwv_flow_api.id(7991767806614545758) ,p_name=>'Footer' ,p_placeholder=>'REGION_POSITION_05' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>8 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991768451623545759) ,p_page_template_id=>wwv_flow_api.id(7991767806614545758) ,p_name=>'Page Navigation' ,p_placeholder=>'REGION_POSITION_06' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991768536043545759) ,p_page_template_id=>wwv_flow_api.id(7991767806614545758) ,p_name=>'Page Header' ,p_placeholder=>'REGION_POSITION_07' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991768613223545759) ,p_page_template_id=>wwv_flow_api.id(7991767806614545758) ,p_name=>'Before Navigation Bar' ,p_placeholder=>'REGION_POSITION_08' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_template( p_id=>wwv_flow_api.id(7991768780415545759) ,p_theme_id=>42 ,p_name=>'Standard' ,p_is_popup=>false ,p_javascript_code_onload=>'apex.theme42.initializePage.noSideCol();' ,p_header_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '', '', '', '', '', '', '', ' ', '', ' ', ' #TITLE#', ' #APEX_CSS#', ' #THEME_CSS#', ' #TEMPLATE_CSS#', ' #THEME_STYLE_CSS#', ' #APPLICATION_CSS#', ' #PAGE_CSS# ', ' #FAVICONS#', ' #HEAD#', ' ', '', '', '#FORM_OPEN#', '
    ', ' #REGION_POSITION_07#', '
    ', '
    ', ' ', '
    ', ' ', '
    ', ' #NAVIGATION_BAR#', '
    ', '
    ', '
    ', ' #TOP_GLOBAL_NAVIGATION_LIST#', ' #REGION_POSITION_06#', '
    ', '
    ', ' ')) ,p_box=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' #SIDE_GLOBAL_NAVIGATION_LIST#', '
    ', '
    ', ' #REGION_POSITION_01#', '
    ', '
    ', ' #SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#', '
    ', ' #BODY#', '
    ', ' ', '
    ', '
    ', '
    ', '
    ', ' #REGION_POSITION_04#', '
    ')) ,p_footer_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '#FORM_CLOSE#', '#DEVELOPER_TOOLBAR#', '#APEX_JAVASCRIPT#', '#GENERATED_CSS#', '#THEME_JAVASCRIPT#', '#TEMPLATE_JAVASCRIPT#', '#APPLICATION_JAVASCRIPT#', '#PAGE_JAVASCRIPT# ', '#GENERATED_JAVASCRIPT#', '', '', '')) ,p_success_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_notification_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_navigation_bar=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '')) ,p_navbar_entry=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ', ' ', ' #TEXT#', ' ', '
  • ')) ,p_region_table_cattributes=>' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"' ,p_breadcrumb_def_reg_pos=>'REGION_POSITION_01' ,p_theme_class_id=>1 ,p_error_page_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ', '

    #MESSAGE#

    ', '

    #ADDITIONAL_INFO#

    ', '
    #TECHNICAL_INFO#
    ', '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ')) ,p_grid_type=>'FIXED' ,p_grid_max_columns=>12 ,p_grid_always_use_max_columns=>true ,p_grid_has_column_span=>true ,p_grid_always_emit=>true ,p_grid_emit_empty_leading_cols=>true ,p_grid_emit_empty_trail_cols=>false ,p_grid_default_label_col_span=>3 ,p_grid_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#ROWS#', '
    ')) ,p_grid_row_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#COLUMNS#', '
    ')) ,p_grid_column_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#CONTENT#', '
    ')) ,p_grid_first_column_attributes=>'alpha' ,p_grid_last_column_attributes=>'omega' ,p_dialog_js_init_code=>'apex.navigation.dialog(#PAGE_URL#,{title:#TITLE#,height:#DIALOG_HEIGHT#,width:#DIALOG_WIDTH#,maxWidth:#DIALOG_MAX_WIDTH#,modal:#IS_MODAL#,dialog:#DIALOG#,#DIALOG_ATTRIBUTES#},#DIALOG_CSS_CLASSES#,#TRIGGERING_ELEMENT#);' ,p_dialog_js_close_code=>'apex.navigation.dialog.close(#IS_MODAL#,#TARGET#);' ,p_dialog_js_cancel_code=>'apex.navigation.dialog.cancel(#IS_MODAL#);' ,p_dialog_browser_frame=>'MODAL' ,p_reference_id=>4070909157481059304 ,p_translate_this_template=>'N' ); end; / begin wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991768817608545760) ,p_page_template_id=>wwv_flow_api.id(7991768780415545759) ,p_name=>'Content Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991768934066545760) ,p_page_template_id=>wwv_flow_api.id(7991768780415545759) ,p_name=>'Breadcrumb Bar' ,p_placeholder=>'REGION_POSITION_01' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991769039625545760) ,p_page_template_id=>wwv_flow_api.id(7991768780415545759) ,p_name=>'Inline Dialogs' ,p_placeholder=>'REGION_POSITION_04' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991769199991545760) ,p_page_template_id=>wwv_flow_api.id(7991768780415545759) ,p_name=>'Footer' ,p_placeholder=>'REGION_POSITION_05' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991769295656545760) ,p_page_template_id=>wwv_flow_api.id(7991768780415545759) ,p_name=>'Page Navigation' ,p_placeholder=>'REGION_POSITION_06' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991769345227545760) ,p_page_template_id=>wwv_flow_api.id(7991768780415545759) ,p_name=>'Page Header' ,p_placeholder=>'REGION_POSITION_07' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991769432669545760) ,p_page_template_id=>wwv_flow_api.id(7991768780415545759) ,p_name=>'Before Navigation Bar' ,p_placeholder=>'REGION_POSITION_08' ,p_has_grid_support=>false ,p_glv_new_row=>false ); wwv_flow_api.create_template( p_id=>wwv_flow_api.id(7991769581513545760) ,p_theme_id=>42 ,p_name=>'Wizard Modal Dialog' ,p_is_popup=>true ,p_javascript_code_onload=>'apex.theme42.initializePage.wizardModal();' ,p_header_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '', '', '', '', '', '', '', ' ', '', ' ', ' #TITLE#', ' #APEX_CSS#', ' #THEME_CSS#', ' #TEMPLATE_CSS#', ' #THEME_STYLE_CSS#', ' #APPLICATION_CSS#', ' #PAGE_CSS#', ' #FAVICONS#', ' #HEAD#', ' ', '', '', '#FORM_OPEN#')) ,p_box=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '')) ,p_footer_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '#FORM_CLOSE#', '#DEVELOPER_TOOLBAR#', '#APEX_JAVASCRIPT#', '#GENERATED_CSS#', '#THEME_JAVASCRIPT#', '#TEMPLATE_JAVASCRIPT#', '#APPLICATION_JAVASCRIPT#', '#PAGE_JAVASCRIPT# ', '#GENERATED_JAVASCRIPT#', '', '')) ,p_success_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_notification_message=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' ', '
    ')) ,p_region_table_cattributes=>' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"' ,p_theme_class_id=>3 ,p_error_page_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ', '

    #MESSAGE#

    ', '

    #ADDITIONAL_INFO#

    ', '
    #TECHNICAL_INFO#
    ', '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ')) ,p_grid_type=>'FIXED' ,p_grid_max_columns=>12 ,p_grid_always_use_max_columns=>true ,p_grid_has_column_span=>true ,p_grid_always_emit=>true ,p_grid_emit_empty_leading_cols=>true ,p_grid_emit_empty_trail_cols=>false ,p_grid_default_label_col_span=>3 ,p_grid_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#ROWS#', '
    ')) ,p_grid_row_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#COLUMNS#', '
    ')) ,p_grid_column_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#CONTENT#', '
    ')) ,p_grid_first_column_attributes=>'alpha' ,p_grid_last_column_attributes=>'omega' ,p_dialog_js_init_code=>'apex.navigation.dialog(#PAGE_URL#,{title:#TITLE#,height:#DIALOG_HEIGHT#,width:#DIALOG_WIDTH#,maxWidth:#DIALOG_MAX_WIDTH#,modal:#IS_MODAL#,dialog:#DIALOG#,#DIALOG_ATTRIBUTES#},#DIALOG_CSS_CLASSES#,#TRIGGERING_ELEMENT#);' ,p_dialog_js_close_code=>'apex.navigation.dialog.close(#IS_MODAL#,#TARGET#);' ,p_dialog_js_cancel_code=>'apex.navigation.dialog.cancel(#IS_MODAL#);' ,p_dialog_height=>'480' ,p_dialog_width=>'720' ,p_dialog_max_width=>'960' ,p_dialog_css_classes=>'t-Dialog--wizard' ,p_dialog_browser_frame=>'MODAL' ,p_reference_id=>2120348229686426515 ,p_translate_this_template=>'N' ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991769697751545760) ,p_page_template_id=>wwv_flow_api.id(7991769581513545760) ,p_name=>'Wizard Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991769718362545760) ,p_page_template_id=>wwv_flow_api.id(7991769581513545760) ,p_name=>'Wizard Progress Bar' ,p_placeholder=>'REGION_POSITION_01' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_page_tmpl_display_point( p_id=>wwv_flow_api.id(7991769800816545760) ,p_page_template_id=>wwv_flow_api.id(7991769581513545760) ,p_name=>'Wizard Buttons' ,p_placeholder=>'REGION_POSITION_03' ,p_has_grid_support=>false ,p_glv_new_row=>true ); end; / prompt --application/shared_components/user_interface/templates/button begin wwv_flow_api.create_button_templates( p_id=>wwv_flow_api.id(7991800293880545806) ,p_template_name=>'Icon' ,p_template=>'' ,p_hot_template=>'' ,p_reference_id=>2347660919680321258 ,p_translate_this_template=>'N' ,p_theme_class_id=>5 ,p_theme_id=>42 ); wwv_flow_api.create_button_templates( p_id=>wwv_flow_api.id(7991800355752545808) ,p_template_name=>'Text' ,p_template=>'' ,p_hot_template=>'' ,p_reference_id=>4070916158035059322 ,p_translate_this_template=>'N' ,p_theme_class_id=>1 ,p_theme_id=>42 ); wwv_flow_api.create_button_templates( p_id=>wwv_flow_api.id(7991800455458545809) ,p_template_name=>'Text with Icon' ,p_template=>'' ,p_hot_template=>'' ,p_reference_id=>2081382742158699622 ,p_translate_this_template=>'N' ,p_theme_class_id=>4 ,p_preset_template_options=>'t-Button--iconRight' ,p_theme_id=>42 ); end; / prompt --application/shared_components/user_interface/templates/region begin wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991769944730545761) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '
    ', '

    #TITLE#

    ', '
    ', '
    ', ' #BODY#', '
    ', '
    ', '
    #PREVIOUS##CLOSE##CREATE##NEXT#
    ', '
    ', '
    ')) ,p_page_plug_template_name=>'Alert' ,p_plug_table_bgcolor=>'#ffffff' ,p_theme_id=>42 ,p_theme_class_id=>21 ,p_preset_template_options=>'t-Alert--horizontal:t-Alert--defaultIcons:t-Alert--warning' ,p_plug_heading_bgcolor=>'#ffffff' ,p_plug_font_size=>'-1' ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>2039236646100190748 ,p_translate_this_template=>'N' ,p_template_comment=>'Red Theme' ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991770051702545762) ,p_plug_template_id=>wwv_flow_api.id(7991769944730545761) ,p_name=>'Region Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991771411066545767) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '#PREVIOUS##BODY##SUB_REGIONS##NEXT#', '
    ')) ,p_page_plug_template_name=>'Blank with Attributes' ,p_theme_id=>42 ,p_theme_class_id=>7 ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>4499993862448380551 ,p_translate_this_template=>'N' ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991771568140545767) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    #PREVIOUS##DELETE##CLOSE#
    ', '
    ', '

    #TITLE#

    ', ' #BODY#', '
    #CHANGE#
    ', '
    ', '
    #EDIT##CREATE##NEXT#
    ', '
    ', '
    ')) ,p_page_plug_template_name=>'Buttons Container' ,p_plug_table_bgcolor=>'#ffffff' ,p_theme_id=>42 ,p_theme_class_id=>17 ,p_plug_heading_bgcolor=>'#ffffff' ,p_plug_font_size=>'-1' ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>2124982336649579661 ,p_translate_this_template=>'N' ,p_template_comment=>'Red Theme' ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991771651838545767) ,p_plug_template_id=>wwv_flow_api.id(7991771568140545767) ,p_name=>'Region Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991771759746545767) ,p_plug_template_id=>wwv_flow_api.id(7991771568140545767) ,p_name=>'Sub Regions' ,p_placeholder=>'SUB_REGIONS' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991772405993545768) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '')) ,p_sub_plug_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' #SUB_REGION#', '
    ')) ,p_page_plug_template_name=>'Carousel Container' ,p_plug_table_bgcolor=>'#ffffff' ,p_theme_id=>42 ,p_theme_class_id=>5 ,p_default_template_options=>'t-Region--showCarouselControls' ,p_preset_template_options=>'t-Region--hiddenOverflow' ,p_plug_heading_bgcolor=>'#ffffff' ,p_plug_font_size=>'-1' ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>2865840475322558786 ,p_translate_this_template=>'N' ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991772510376545768) ,p_plug_template_id=>wwv_flow_api.id(7991772405993545768) ,p_name=>'Region Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991772681222545768) ,p_plug_template_id=>wwv_flow_api.id(7991772405993545768) ,p_name=>'Slides' ,p_placeholder=>'SUB_REGIONS' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991775822437545772) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' ', '
    ', '
    ', '

    #TITLE#

    ', '
    ', '
    #EDIT#
    ', '
    ', '
    ', '
    ', '
    #CLOSE#
    ', '
    #CREATE#
    ', '
    ', '
    ', ' #COPY#', ' #BODY#', ' #SUB_REGIONS#', ' #CHANGE#', '
    ', '
    ', '
    #PREVIOUS#
    ', '
    #NEXT#
    ', '
    ', '
    ', '
    ')) ,p_page_plug_template_name=>'Collapsible' ,p_plug_table_bgcolor=>'#ffffff' ,p_theme_id=>42 ,p_theme_class_id=>1 ,p_preset_template_options=>'is-expanded:t-Region--scrollBody' ,p_plug_heading_bgcolor=>'#ffffff' ,p_plug_font_size=>'-1' ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>2662888092628347716 ,p_translate_this_template=>'N' ,p_template_comment=>'Red Theme' ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991775962827545772) ,p_plug_template_id=>wwv_flow_api.id(7991775822437545772) ,p_name=>'Region Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991776025356545772) ,p_plug_template_id=>wwv_flow_api.id(7991775822437545772) ,p_name=>'Sub Regions' ,p_placeholder=>'SUB_REGIONS' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991777953245545773) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', '
    ', '

    #TITLE#

    ', ' #BODY#', '
    ', '
    #SUB_REGIONS#
    #NEXT#
    ', '
    ', '
    ')) ,p_page_plug_template_name=>'Hero' ,p_theme_id=>42 ,p_theme_class_id=>22 ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>2672571031438297268 ,p_translate_this_template=>'N' ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991778015677545774) ,p_plug_template_id=>wwv_flow_api.id(7991777953245545773) ,p_name=>'Region Body' ,p_placeholder=>'#BODY#' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991778151350545774) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '', '
    ')) ,p_page_plug_template_name=>'Inline Dialog' ,p_theme_id=>42 ,p_theme_class_id=>24 ,p_default_template_options=>'js-modal:js-draggable:js-resizable' ,p_preset_template_options=>'js-dialog-size600x400' ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>2671226943886536762 ,p_translate_this_template=>'N' ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991778253983545774) ,p_plug_template_id=>wwv_flow_api.id(7991778151350545774) ,p_name=>'Region Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991779025828545775) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '

    #TITLE#

    ', '#PREVIOUS##BODY##SUB_REGIONS##NEXT#', '
    ')) ,p_page_plug_template_name=>'Interactive Report' ,p_theme_id=>42 ,p_theme_class_id=>9 ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>2099079838218790610 ,p_translate_this_template=>'N' ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991779373165545775) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', ' ', '

    #TITLE#

    ', '
    ', '
    ', ' #BODY#', '
    ', '
    ', ' #NEXT#', '
    ', ' ', ' #SUB_REGIONS#', '
    ')) ,p_page_plug_template_name=>'Login' ,p_theme_id=>42 ,p_theme_class_id=>23 ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>2672711194551076376 ,p_translate_this_template=>'N' ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991779406387545775) ,p_plug_template_id=>wwv_flow_api.id(7991779373165545775) ,p_name=>'Content Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991779584888545775) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', '

    #TITLE#

    ', '
    ', '
    #COPY##EDIT#
    ', '
    ', '
    ', '
    ', '
    #PREVIOUS#
    ', '
    #NEXT#
    ', '
    ', '
    ', ' #BODY#', ' #SUB_REGIONS#', '
    ', '
    ', '
    #CLOSE##HELP#
    ', '
    #DELETE##CHANGE##CREATE#
    ', '
    ', '
    ', '
    ', '')) ,p_page_plug_template_name=>'Standard' ,p_plug_table_bgcolor=>'#ffffff' ,p_theme_id=>42 ,p_theme_class_id=>8 ,p_preset_template_options=>'t-Region--scrollBody' ,p_plug_heading_bgcolor=>'#ffffff' ,p_plug_font_size=>'-1' ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>4070912133526059312 ,p_translate_this_template=>'N' ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991779643873545775) ,p_plug_template_id=>wwv_flow_api.id(7991779584888545775) ,p_name=>'Region Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991779776668545775) ,p_plug_template_id=>wwv_flow_api.id(7991779584888545775) ,p_name=>'Sub Regions' ,p_placeholder=>'SUB_REGIONS' ,p_has_grid_support=>true ,p_glv_new_row=>true ,p_max_fixed_grid_columns=>12 ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991781669894545777) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' #BODY#', '
    ', ' #SUB_REGIONS#', '
    ', '
    ')) ,p_sub_plug_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', ' #SUB_REGION#', '
    ')) ,p_page_plug_template_name=>'Tabs Container' ,p_theme_id=>42 ,p_theme_class_id=>5 ,p_preset_template_options=>'t-TabsRegion-mod--simple' ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>3221725015618492759 ,p_translate_this_template=>'N' ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991781713127545777) ,p_plug_template_id=>wwv_flow_api.id(7991781669894545777) ,p_name=>'Region Body' ,p_placeholder=>'BODY' ,p_has_grid_support=>true ,p_glv_new_row=>true ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991781846444545777) ,p_plug_template_id=>wwv_flow_api.id(7991781669894545777) ,p_name=>'Tabs' ,p_placeholder=>'SUB_REGIONS' ,p_has_grid_support=>false ,p_glv_new_row=>true ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991782868119545778) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '
    ', ' #BODY#', '
    ', '
    ', '

    #TITLE#

    ', '
    ', '
    ', '
    #PREVIOUS##CLOSE##DELETE##HELP##CHANGE##EDIT##COPY##CREATE##NEXT#
    ', '
    ')) ,p_page_plug_template_name=>'Title Bar' ,p_theme_id=>42 ,p_theme_class_id=>6 ,p_default_template_options=>'t-BreadcrumbRegion--showBreadcrumb' ,p_preset_template_options=>'t-BreadcrumbRegion--useBreadcrumbTitle' ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>2530016523834132090 ,p_translate_this_template=>'N' ); wwv_flow_api.create_plug_template( p_id=>wwv_flow_api.id(7991783371828545778) ,p_layout=>'TABLE' ,p_template=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
    ', '
    ', '

    #TITLE#

    ', '
    ', '
    #PREVIOUS##CLOSE#
    ', '
    ', ' #BODY#', '
    ', '
    #NEXT#
    ', '
    ', '
    ', '
    ', ' #SUB_REGIONS#', '
    ', '
    ')) ,p_page_plug_template_name=>'Wizard Container' ,p_theme_id=>42 ,p_theme_class_id=>8 ,p_preset_template_options=>'t-Wizard--hideStepsXSmall' ,p_default_label_alignment=>'RIGHT' ,p_default_field_alignment=>'LEFT' ,p_reference_id=>2117602213152591491 ,p_translate_this_template=>'N' ); wwv_flow_api.create_plug_tmpl_display_point( p_id=>wwv_flow_api.id(7991783470094545778) ,p_plug_template_id=>wwv_flow_api.id(7991783371828545778) ,p_name=>'Wizard Sub Regions' ,p_placeholder=>'SUB_REGIONS' ,p_has_grid_support=>true ,p_glv_new_row=>true ); end; / prompt --application/shared_components/user_interface/templates/list begin wwv_flow_api.create_list_template( p_id=>wwv_flow_api.id(7991791592955545792) ,p_list_template_current=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' #TEXT#', ' #A01#', '
  • ', '')) ,p_list_template_noncurrent=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' #TEXT#', ' #A01#', '
  • ', '')) ,p_list_template_name=>'Badge List' ,p_theme_id=>42 ,p_theme_class_id=>3 ,p_default_template_options=>'t-BadgeList--responsive' ,p_preset_template_options=>'t-BadgeList--large:t-BadgeList--fixed' ,p_list_template_before_rows=>'' ,p_a01_label=>'Value' ,p_a02_label=>'List item CSS Classes' ,p_a03_label=>'Link Attributes' ,p_reference_id=>2062482847268086664 ,p_list_template_comment=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'A01: Large Number', 'A02: List Item Classes', 'A03: Link Attributes')) ); wwv_flow_api.create_list_template( p_id=>wwv_flow_api.id(7991793238381545796) ,p_list_template_current=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', '
    ', ' ', '
    #A03#
    ', '

    #TEXT#

    ', '
    ', '
    #A01#
    ', '
    #A02#
    ', '
    ', '
    ', '
    ', '
  • ')) ,p_list_template_noncurrent=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', '
    ', ' ', '
    #A03#
    ', '

    #TEXT#

    ', '
    ', '
    #A01#
    ', '
    #A02#
    ', '
    ', '
    ', '
    ', '
  • ')) ,p_list_template_name=>'Cards' ,p_theme_id=>42 ,p_theme_class_id=>4 ,p_preset_template_options=>'t-Cards--3cols:t-Cards--featured' ,p_list_template_before_rows=>'' ,p_a01_label=>'Description' ,p_a02_label=>'Secondary Information' ,p_a03_label=>'Initials' ,p_a04_label=>'List Item CSS Classes' ,p_reference_id=>2885322685880632508 ); wwv_flow_api.create_list_template( p_id=>wwv_flow_api.id(7991795383705545798) ,p_list_template_current=>'' ,p_list_template_noncurrent=>'' ,p_list_template_name=>'Links List' ,p_theme_id=>42 ,p_theme_class_id=>18 ,p_list_template_before_rows=>'' ,p_before_sub_list=>'' ,p_sub_list_item_current=>'' ,p_sub_list_item_noncurrent=>'' ,p_item_templ_curr_w_child=>'' ,p_item_templ_noncurr_w_child=>'' ,p_a01_label=>'Badge Value' ,p_a02_label=>'Link Attributes' ,p_a03_label=>'List Item CSS Classes' ,p_reference_id=>4070914341144059318 ); wwv_flow_api.create_list_template( p_id=>wwv_flow_api.id(7991796107857545798) ,p_list_template_current=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ', '
    ', ' ', '
    ', '
    ', '

    #TEXT#

    ', '

    #A01#

    ', '
    ', '
    ', ' #A02#', '
    ', '
    ', '
  • ')) ,p_list_template_noncurrent=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ', '
    ', ' ', '
    ', '
    ', '

    #TEXT#

    ', '

    #A01#

    ', '
    ', '
    ', ' #A02#', '
    ', '
    ', '
  • ')) ,p_list_template_name=>'Media List' ,p_theme_id=>42 ,p_theme_class_id=>5 ,p_default_template_options=>'t-MediaList--showDesc:t-MediaList--showIcons' ,p_list_template_before_rows=>'' ,p_a01_label=>'Description' ,p_a02_label=>'Badge Value' ,p_a03_label=>'Link Attributes' ,p_a04_label=>'List Item CSS Classes' ,p_reference_id=>2066548068783481421 ); wwv_flow_api.create_list_template( p_id=>wwv_flow_api.id(7991797077374545799) ,p_list_template_current=>'
  • #TEXT_ESC_SC#
  • ' ,p_list_template_noncurrent=>'
  • #TEXT_ESC_SC#
  • ' ,p_list_template_name=>'Menu Bar' ,p_javascript_code_onload=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'var e = apex.jQuery("##PARENT_STATIC_ID#_menubar", apex.gPageContext$);', 'if (e.hasClass("js-addActions")) {', ' if ( apex.actions ) {', ' apex.actions.addFromMarkup( e );', ' } else {', ' apex.debug.warn("Include actions.js to support menu shortcuts");', ' }', '}', 'e.menu({', ' behaveLikeTabs: e.hasClass("js-tabLike"),', ' menubarShowSubMenuIcon: e.hasClass("js-showSubMenuIcons") || null,', ' iconType: ''fa'',', ' slide: e.hasClass("js-slide"),', ' menubar: true,', ' menubarOverflow: true', '});')) ,p_theme_id=>42 ,p_theme_class_id=>20 ,p_default_template_options=>'js-showSubMenuIcons' ,p_list_template_before_rows=>'
    ' ,p_before_sub_list=>'' ,p_sub_list_item_current=>'
  • #TEXT_ESC_SC#
  • ' ,p_sub_list_item_noncurrent=>'
  • #TEXT_ESC_SC#
  • ' ,p_item_templ_curr_w_child=>'
  • #TEXT_ESC_SC#' ,p_item_templ_noncurr_w_child=>'
  • #TEXT_ESC_SC#' ,p_sub_templ_curr_w_child=>'
  • #TEXT_ESC_SC#' ,p_sub_templ_noncurr_w_child=>'
  • #TEXT_ESC_SC#' ,p_reference_id=>2008709236185638887 ); wwv_flow_api.create_list_template( p_id=>wwv_flow_api.id(7991797514588545800) ,p_list_template_current=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • #TEXT_ESC_SC#
  • ', '')) ,p_list_template_noncurrent=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • #TEXT_ESC_SC#
  • ', '')) ,p_list_template_name=>'Menu Popup' ,p_javascript_code_onload=>wwv_flow_utilities.join(wwv_flow_t_varchar2( 'var e = apex.jQuery("##PARENT_STATIC_ID#_menu", apex.gPageContext$);', 'if (e.hasClass("js-addActions")) {', ' if ( apex.actions ) {', ' apex.actions.addFromMarkup( e );', ' } else {', ' apex.debug.warn("Include actions.js to support menu shortcuts");', ' }', '}', 'e.menu({ slide: e.hasClass("js-slide")});', '')) ,p_theme_id=>42 ,p_theme_class_id=>20 ,p_list_template_before_rows=>'' ,p_before_sub_list=>'' ,p_sub_list_item_current=>'
  • #TEXT_ESC_SC#
  • ' ,p_sub_list_item_noncurrent=>'
  • #TEXT_ESC_SC#
  • ' ,p_item_templ_curr_w_child=>'
  • #TEXT_ESC_SC#' ,p_item_templ_noncurr_w_child=>'
  • #TEXT_ESC_SC#' ,p_sub_templ_curr_w_child=>'
  • #TEXT_ESC_SC#' ,p_sub_templ_noncurr_w_child=>'
  • #TEXT_ESC_SC#' ,p_a01_label=>'Data ID' ,p_a02_label=>'Disabled (True/False)' ,p_a03_label=>'Hidden (True/False)' ,p_a04_label=>'Title Attribute' ,p_a05_label=>'Shortcut' ,p_reference_id=>3492264004432431646 ); wwv_flow_api.create_list_template( p_id=>wwv_flow_api.id(7991797656311545800) ,p_list_template_current=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ', ' #TEXT_ESC_SC##A01#', ' ', '
  • ')) ,p_list_template_noncurrent=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ', ' #TEXT_ESC_SC##A01#', ' ', '
  • ')) ,p_list_template_name=>'Navigation Bar' ,p_theme_id=>42 ,p_theme_class_id=>20 ,p_list_template_before_rows=>'' ,p_before_sub_list=>'' ,p_sub_list_item_current=>'
  • #TEXT_ESC_SC#
  • ' ,p_sub_list_item_noncurrent=>'
  • #TEXT_ESC_SC#
  • ' ,p_item_templ_curr_w_child=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ')) ,p_item_templ_noncurr_w_child=>wwv_flow_utilities.join(wwv_flow_t_varchar2( '
  • ', ' ')) ,p_sub_templ_curr_w_child=>'
  • #TEXT_ESC_SC#