oracle APEX 18.2版本

prompt --application/set_environment set define off verify off feedback off -------------------------------------------------------------------------------- -- -- ORACLE Application Express (APEX) export file -- -- You should run the script connected to SQL*Plus as the Oracle user -- APEX_180200 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=>'2018.05.24' ,p_release=>'18.2.0.00.08' ,p_default_workspace_id=>10 ,p_default_application_id=>4009 ,p_default_owner=>'APEX_180200' ); end; / prompt APPLICATION 4009 - Oracle APEX AppBuilder -- -- Application Export: -- Application: 4009 -- Name: Oracle APEX AppBuilder -- Exported By: APEX_180200 -- Flashback: 0 -- Export Type: Application Export -- Version: 18.2.0.00.08 -- Instance ID: 248229714707526 -- -- Application Statistics: -- Pages: 1,004 -- Items: 6,155 -- Computations: 774 -- Validations: 1,608 -- Processes: 1,501 -- Regions: 4,360 -- Buttons: 2,766 -- Dynamic Actions: 1,336 -- Shared Components: -- Logic: -- Items: 30 -- Processes: 14 -- Computations: 8 -- Build Options: 5 -- Navigation: -- Lists: 258 -- Breadcrumbs: 1 -- Entries: 868 -- NavBar Entries: 3 -- Security: -- Authentication: 1 -- Authorization: 20 -- User Interface: -- Templates: -- Page: 9 -- Region: 43 -- Label: 11 -- List: 16 -- Popup LOV: 1 -- Calendar: 1 -- Breadcrumb: 1 -- Button: 7 -- Report: 18 -- LOVs: 991 -- Shortcuts: 12 -- Plug-ins: 27 -- Globalization: -- Messages: 432 -- Reports: -- E-Mail: -- Supporting Objects: Excluded prompt --application/delete_application begin wwv_flow_api.remove_flow(wwv_flow.g_flow_id); 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,4009) ,p_owner=>nvl(wwv_flow_application_install.get_schema,'APEX_180200') ,p_name=>nvl(wwv_flow_application_install.get_application_name,'Oracle APEX AppBuilder') ,p_alias=>nvl(wwv_flow_application_install.get_application_alias,'A285092414289194144') ,p_page_view_logging=>'YES' ,p_charset=>'utf-8' ,p_page_protection_enabled_y_n=>'N' ,p_checksum_salt_last_reset=>'20180830074547' ,p_bookmark_checksum_function=>'SH1' ,p_compatibility_mode=>'5.0' ,p_flow_language=>'ja' ,p_flow_language_derived_from=>'SESSION' ,p_date_format=>'&DATE_FORMAT.' ,p_direction_right_to_left=>'N' ,p_flow_image_prefix => nvl(wwv_flow_application_install.get_image_prefix,'') ,p_publish_yn=>'Y' ,p_authentication=>'PLUGIN' ,p_authentication_id=>wwv_flow_api.id(532421019614096524.4009) ,p_populate_roles=>'A' ,p_application_tab_set=>1 ,p_logo_image=>'#IMAGE_PREFIX#apex_ui/apexlogo.png' ,p_logo_image_attributes=>'width="282" height="20" alt="&PRODUCT_NAME."' ,p_public_user=>'APEX_PUBLIC_USER' ,p_proxy_server=>nvl(wwv_flow_application_install.get_proxy,'') ,p_no_proxy_domains=>nvl(wwv_flow_application_install.get_no_proxy_domains,'') ,p_flow_version=>'&PRODUCT_NAME. 18.2.0.00.08' ,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_runtime_api_usage=>'T:O' ,p_security_scheme=>wwv_flow_api.id(12510423405283164) ,p_authorize_public_pages_yn=>'Y' ,p_rejoin_existing_sessions=>'N' ,p_csv_encoding=>'Y' ,p_auto_time_zone=>'N' ,p_error_handling_function=>'wwv_flow_error_dev.internal_error_handler' ,p_substitution_string_01=>'HELP' ,p_substitution_value_01=>unistr('\30D8\30EB\30D7') ,p_substitution_string_02=>'PRODUCT_NAME' ,p_substitution_value_02=>'Application Express' ,p_substitution_string_03=>'MSG_COMPANY' ,p_substitution_value_03=>unistr('\30EF\30FC\30AF\30B9\30DA\30FC\30B9: &COMPANY.') ,p_substitution_string_04=>'MSG_LANGUAGE' ,p_substitution_value_04=>unistr('\8A00\8A9E') ,p_substitution_string_05=>'MSG_COPYRIGHT' ,p_substitution_value_05=>'Copyright © 1999, 2018, Oracle. All rights reserved.' ,p_substitution_string_06=>'MSG_USER' ,p_substitution_value_06=>unistr('\30E6\30FC\30B6\30FC') ,p_substitution_string_07=>'MSG_JSCRIPT' ,p_substitution_value_07=>unistr('\3053\306E\88FD\54C1\306F\3001JavaScript\304C\6709\52B9\306A\72B6\614B\3067\5B9F\884C\3059\308B\5FC5\8981\304C\3042\308A\307E\3059\3002') ,p_substitution_string_08=>'MSG_TBL_SUMMARY' ,p_substitution_value_08=>unistr('\30DA\30FC\30B8\30FB\30EC\30A4\30A2\30A6\30C8\8868') ,p_substitution_string_09=>'EDIT' ,p_substitution_value_09=>unistr('\7DE8\96C6') ,p_substitution_string_10=>'DONE' ,p_substitution_value_10=>unistr('\5B8C\4E86') ,p_substitution_string_11=>'TOP' ,p_substitution_value_11=>unistr('\30C8\30C3\30D7') ,p_substitution_string_12=>'CLOSE' ,p_substitution_value_12=>unistr('\9589\3058\308B') ,p_substitution_string_13=>'CONFIRM' ,p_substitution_value_13=>unistr('\78BA\8A8D') ,p_substitution_string_14=>'DATE_FORMAT' ,p_substitution_value_14=>'rr-mm-dd' ,p_substitution_string_15=>'LONG_DATE_FORMAT' ,p_substitution_value_15=>'yyyy mm dd fmDay' ,p_substitution_string_16=>'TIME_FORMAT' ,p_substitution_value_16=>'hh24:mi:ss' ,p_substitution_string_17=>'DATE_TIME_FORMAT' ,p_substitution_value_17=>'rr-mm-dd hh24:mi:ss' ,p_substitution_string_18=>'RETURN_TO_APP' ,p_substitution_value_18=>unistr('\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\306B\623B\308B') ,p_substitution_string_19=>'DELETE_MSG' ,p_substitution_value_19=>unistr('\3053\306E\524A\9664\64CD\4F5C\3092\5B9F\884C\3057\307E\3059\304B\3002') ,p_substitution_string_20=>'PAGE' ,p_substitution_value_20=>unistr('\30DA\30FC\30B8') ,p_last_updated_by=>'APEX_180200' ,p_last_upd_yyyymmddhh24miss=>'20180830075912' ,p_file_prefix => nvl(wwv_flow_application_install.get_static_app_file_prefix,'') ,p_files_version=>11 ,p_ui_type_name => null ); end; / prompt --application/shared_components/navigation/lists/shared_components_tab_navigation begin wwv_flow_api.create_list( p_id=>wwv_flow_api.id(5297709875.4009) ,p_name=>'shared.components.tab.navigation' ,p_list_status=>'PUBLIC' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(450480819599472048.4009) ,p_list_item_display_sequence=>1 ,p_list_item_link_text=>unistr('\30BF\30D6') ,p_list_item_link_target=>'f?p=&APP_ID.:643:&SESSION.::&DEBUG.::::' ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'643' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(46189308080649570.4009) ,p_list_item_display_sequence=>10 ,p_list_item_link_text=>unistr('\30BF\30D6\306E\7BA1\7406') ,p_list_item_link_target=>'f?p=&APP_ID.:9000:&SESSION.::&DEBUG.::::' ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'9000:9005' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(155545004712893410.4009) ,p_list_item_display_sequence=>40 ,p_list_item_link_text=>unistr('\30BF\30D6\30FB\30BB\30C3\30C8\30FB\30D3\30E5\30FC') ,p_list_item_link_target=>'f?p=&APP_ID.:77:&SESSION.::&DEBUG.::::' ,p_list_item_disp_cond_type=>'CURRENT_PAGE_IN_CONDITION' ,p_list_item_disp_condition=>'77' ,p_list_item_current_type=>'COLON_DELIMITED_PAGE_LIST' ,p_list_item_current_for_pages=>'77' ); wwv_flow_api.create_list_item( p_id=>wwv_flow_api.id(155551816129903365.4009) ,p_list_item_display_seq