begin
null;
end;
/
prompt --application/shared_components/globalization/translations
begin
null;
end;
/
prompt --application/shared_components/logic/build_options
begin
null;
end;
/
prompt --application/shared_components/globalization/messages
begin
null;
end;
/
prompt --application/shared_components/globalization/dyntranslations
begin
null;
end;
/
prompt --application/shared_components/user_interface/shortcuts/delete_confirm_msg
begin
wwv_flow_api.create_shortcut(
 p_id=>wwv_flow_api.id(19555134285222164)
,p_shortcut_name=>'DELETE_CONFIRM_MSG'
,p_shortcut_type=>'TEXT_ESCAPE_JS'
,p_shortcut=>unistr('\3053\306E\524A\9664\64CD\4F5C\3092\5B9F\884C\3057\307E\3059\304B\3002')
);
end;
/
prompt --application/shared_components/security/authentications/application_expressアカウント
begin
wwv_flow_api.create_authentication(
 p_id=>wwv_flow_api.id(19411661509221894)
,p_name=>unistr('Application Express\30A2\30AB\30A6\30F3\30C8')
,p_scheme_type=>'NATIVE_APEX_ACCOUNTS'
,p_invalid_session_type=>'LOGIN'
,p_use_secure_cookie_yn=>'N'
,p_ras_mode=>0
);
end;
/
prompt --application/user_interfaces
begin
wwv_flow_api.create_user_interface(
 p_id=>wwv_flow_api.id(19552109231222152)
,p_ui_type_name=>'DESKTOP'
,p_display_name=>unistr('\30C7\30B9\30AF\30C8\30C3\30D7')
,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_login_url=>'f?p=&APP_ID.:LOGIN:&APP_SESSION.::&DEBUG.:::'
,p_theme_style_by_user_pref=>false
,p_built_with_love=>false
,p_global_page_id=>0
,p_navigation_list_id=>wwv_flow_api.id(19412400298221896)
,p_navigation_list_position=>'SIDE'
,p_navigation_list_template_id=>wwv_flow_api.id(19518694697222078)
,p_nav_list_template_options=>'#DEFAULT#:t-TreeNav--styleA:js-navCollapsed--hidden'
,p_css_file_urls=>'#APP_IMAGES#app-icon.css?version=#APP_VERSION#'
,p_nav_bar_type=>'LIST'
,p_nav_bar_list_id=>wwv_flow_api.id(19551820715222152)
,p_nav_bar_list_template_id=>wwv_flow_api.id(19518209463222077)
,p_nav_bar_template_options=>'#DEFAULT#'
);
end;
/
prompt --application/user_interfaces/combined_files
begin
null;
end;
/
prompt --application/pages/page_00000
begin
wwv_flow_api.create_page(
 p_id=>0
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\30B0\30ED\30FC\30D0\30EB\30FB\30DA\30FC\30B8 - \30C7\30B9\30AF\30C8\30C3\30D7')
,p_step_title=>unistr('\30B0\30ED\30FC\30D0\30EB\30FB\30DA\30FC\30B8 - \30C7\30B9\30AF\30C8\30C3\30D7')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'D'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210730075152'
);
end;
/
prompt --application/pages/page_00001
begin
wwv_flow_api.create_page(
 p_id=>1
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\30DB\30FC\30E0')
,p_alias=>'HOME'
,p_step_title=>unistr('\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\6587\66F8\7BA1\7406')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210813015917'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(19564089425222209)
,p_plug_name=>unistr('\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\6587\66F8\7BA1\7406')
,p_icon_css_classes=>'app-icon'
,p_region_template_options=>'#DEFAULT#'
,p_escape_on_http_output=>'Y'
,p_plug_template=>wwv_flow_api.id(19457395488221974)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_plug_query_num_rows=>15
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
,p_attribute_03=>'Y'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(19600846450224500)
,p_plug_name=>unistr('\30DA\30FC\30B8\30FB\30CA\30D3\30B2\30FC\30B7\30E7\30F3')
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#:u-colors:t-Cards--featured t-Cards--block force-fa-lg:t-Cards--displayIcons:t-Cards--4cols:t-Cards--hideBody:t-Cards--animColorFill'
,p_plug_template=>wwv_flow_api.id(19438548418221945)
,p_plug_display_sequence=>30
,p_plug_display_point=>'BODY'
,p_list_id=>wwv_flow_api.id(19600109555224499)
,p_plug_source_type=>'NATIVE_LIST'
,p_list_template_id=>wwv_flow_api.id(19506658742222057)
,p_plug_query_num_rows=>15
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30516250932647337)
,p_plug_name=>unistr('\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_08'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'<p>',
unistr('\3053\306E\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\306F\3001Oracle Database\306E\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306E\3075\305F\3064\306E\7279\6027\2015<b>\8010\6539\3056\3093\6027</b>\3068<b>\76E3\67FB\6027</b>\2015\3092\3001\6587\66F8\30D5\30A1\30A4\30EB\306E\7BA1\7406\FF08\4FDD\7BA1\3068\691C\7D22\3001\95B2\89A7\FF09\306E\30B7\30CA\30EA\30AA\3092\901A\3058\3066\4F53\9A13\3044\305F\3060\304F\305F\3081\306E\30B5\30F3\30D7\30EB\3067\3059\3002'),
'</p>',
'<p>',
unistr('\3053\306E\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\3067\306F\3001\6587\66F8\FF08\306E\30D5\30A1\30A4\30EB\FF09\306E\7BA1\7406\3068\3044\3046\30B7\30CA\30EA\30AA\3092\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\3092\6D3B\7528\3057\3066\5B9F\88C5\3057\3066\3044\307E\3059\3002<br>'),
unistr('\30FBWORD\3001PDF\3001Excel\3001\30C6\30AD\30B9\30C8\306A\3069\4EFB\610F\306E\5F62\5F0F\306E\6587\66F8\30D5\30A1\30A4\30EB\3092\4FDD\5B58\53EF\80FD\3067\3059\3002<br>'),
unistr('\30FB\3042\308B\6587\66F8\306B\3064\3044\3066\306E\30C7\30FC\30BF\FF08\6587\66F8\30C7\30FC\30BF\FF09\306F\3001\6587\66F8\30D5\30A1\30A4\30EB\305D\306E\3082\306E\3068\3001\30C9\30AD\30E5\30E1\30F3\30C8ID\3001\30D0\30FC\30B8\30E7\30F3\3001\30C9\30AD\30E5\30E1\30F3\30C8\540D\3001\767B\9332\8005\306A\3069\306E\30C7\30FC\30BF\304B\3089\6210\308A\307E\3059\3002<br>'),
unistr('  - \6587\66F8\30C7\30FC\30BF\306F\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\767B\9332\5F8C\306F\66F4\65B0\4E0D\80FD\3067\3059\3002<br>'),
unistr('  - \3072\3068\3064\306E\6587\66F8\FF08\540C\4E00\306E\30C9\30AD\30E5\30E1\30F3\30C8ID\3092\4ED8\4E0E\3055\308C\305F\6587\66F8\30C7\30FC\30BF\FF09\306B\5BFE\3057\3066\3072\3068\3064\FF5E\8907\6570\306E\30D0\30FC\30B8\30E7\30F3\306E\6587\66F8\30C7\30FC\30BF\3092\7BA1\7406\53EF\80FD\3067\3059\3002<br>'),
unistr('\30FB\307E\305F\3001\6587\66F8\306E\30B9\30C6\30FC\30BF\30B9\3001\30AB\30C6\30B4\30EA\30FC\3001\5099\8003\304B\3089\6210\308B\4ED8\52A0\60C5\5831\30C7\30FC\30BF\3092\6587\66F8\306B\4ED8\4E0E\3067\304D\307E\3059\3002<br>'),
unistr('  - \4ED8\52A0\60C5\5831\306E\30C7\30FC\30BF\306F\901A\5E38\306E\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\5F8C\304B\3089\66F4\65B0\3059\308B\3053\3068\304C\3067\304D\307E\3059\3002<br>'),
unistr('  - \4ED8\52A0\60C5\5831\306F\3072\3068\3064\306E\6587\66F8\306B\5BFE\3057\3066\3072\3068\3064\3067\3059\FF08\8907\6570\30D0\30FC\30B8\30E7\30F3\304C\5B58\5728\3059\308B\5834\5408\3082\5171\901A\3067\3059\FF09\3002'),
'</p>',
'<p>',
unistr('<b>\4E3B\306A\6A5F\80FD</b>'),
'<br>',
unistr('\6587\66F8\7BA1\7406\306B\95A2\308F\308B\6A5F\80FD\3068\3001\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306E\7279\6027\3067\3042\308B\8010\6539\3056\3093\6027\3068\76E3\67FB\6027\3092\4F53\9A13\3059\308B\305F\3081\306E\6A5F\80FD\3092\5099\3048\3066\3044\307E\3059\3002<br>'),
unistr('\30FB\6587\66F8\7BA1\7406\306B\95A2\308F\308B\6A5F\80FD<br>'),
unistr('  - \6587\66F8\30C7\30FC\30BF\304A\3088\3073\4ED8\52A0\60C5\5831\306E\767B\9332<br>'),
unistr('  - \6587\66F8\30C7\30FC\30BF\306E\691C\7D22\3001\4E00\89A7\8868\793A\3001\6587\66F8\306E\30C0\30A6\30F3\30ED\30FC\30C9<br>'),
unistr('  - \3042\308B\6587\66F8\306B\3064\3044\3066\306E\65B0\30D0\30FC\30B8\30E7\30F3\306E\6587\66F8\30C7\30FC\30BF\306E\767B\9332<br>'),
unistr('  - \4ED8\52A0\60C5\5831\306E\66F4\65B0<br>'),
unistr('\30FB\8010\6539\3056\3093\6027\3068\76E3\67FB\6027\306B\95A2\308F\308B\6A5F\80FD<br>'),
unistr('  - \30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306E\884C\306E\6574\5408\6027\691C\8A3C\FF08\30CF\30C3\30B7\30E5\30C1\30A7\30FC\30F3\306E\691C\8A3C\FF09<br>'),
unistr('  - \30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\4E0A\306E\6587\66F8\30C7\30FC\30BF\306EUPDATE\3001DELETE\4E0D\80FD\306E\78BA\8A8D<br>'),
'</p>'))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
end;
/
prompt --application/pages/page_00003
begin
wwv_flow_api.create_page(
 p_id=>3
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\6587\66F8\4E00\89A7\FF08\5168\30D0\30FC\30B8\30E7\30F3\FF09')
,p_alias=>unistr('\6587\66F8\4E00\89A7-\5168\30D0\30FC\30B8\30E7\30F3')
,p_step_title=>unistr('\6587\66F8\4E00\89A7\FF08\5168\30D0\30FC\30B8\30E7\30F3\FF09')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210812115531'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(59047621614423173)
,p_plug_name=>unistr('\30EC\30DD\30FC\30C81')
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19465095800221986)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT d.document_id, a.status, d.revision, d.document_title, d.registerer_name,',
'    d.publish_date, d.update_type, DBMS_LOB.GETLENGTH(d.document) DOCUMENT, a.category,',
'    d.document_filename',
'    FROM document_bct d',
'    LEFT JOIN additional_info a ON d.document_id = a.document_id'))
,p_plug_source_type=>'NATIVE_IR'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_prn_page_header=>unistr('\30EC\30DD\30FC\30C81')
);
wwv_flow_api.create_worksheet(
 p_id=>wwv_flow_api.id(59047950919423174)
,p_name=>unistr('\30EC\30DD\30FC\30C81')
,p_max_row_count_message=>unistr('\3053\306E\30EC\30DD\30FC\30C8\306E\6700\5927\884C\6570\306F#MAX_ROW_COUNT#\884C\3067\3059\3002\30D5\30A3\30EB\30BF\3092\9069\7528\3057\3066\3001\554F\5408\305B\306E\30EC\30B3\30FC\30C9\6570\3092\524A\6E1B\3057\3066\304F\3060\3055\3044\3002')
,p_no_data_found_message=>unistr('\30C7\30FC\30BF\304C\898B\3064\304B\308A\307E\305B\3093\3002')
,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:XLSX:PDF:RTF'
,p_detail_link=>'f?p=&APP_ID.:6:&SESSION.::&DEBUG.:RP,:P6_DOCUMENT_ID:#DOCUMENT_ID#'
,p_detail_link_text=>'<img src="#IMAGE_PREFIX#app_ui/img/icons/apex-edit-view.png" class="apex-edit-view" alt="">'
,p_owner=>'DOCUMENT_BCT'
,p_internal_uid=>59047950919423174
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30657017307833408)
,p_db_column_name=>'CATEGORY'
,p_display_order=>20
,p_column_identifier=>'J'
,p_column_label=>unistr('\30AB\30C6\30B4\30EA\30FC')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30653897383833398)
,p_db_column_name=>'DOCUMENT_ID'
,p_display_order=>30
,p_column_identifier=>'B'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8ID')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30654633228833405)
,p_db_column_name=>'REVISION'
,p_display_order=>40
,p_column_identifier=>'D'
,p_column_label=>unistr('\30D0\30FC\30B8\30E7\30F3')
,p_column_type=>'NUMBER'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30654235151833404)
,p_db_column_name=>'STATUS'
,p_display_order=>50
,p_column_identifier=>'C'
,p_column_label=>unistr('\30B9\30C6\30FC\30BF\30B9')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30656286276833407)
,p_db_column_name=>'UPDATE_TYPE'
,p_display_order=>60
,p_column_identifier=>'H'
,p_column_label=>unistr('\66F4\65B0\7A2E\5225')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30655079944833405)
,p_db_column_name=>'DOCUMENT_TITLE'
,p_display_order=>70
,p_column_identifier=>'E'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8\540D')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30655489010833406)
,p_db_column_name=>'REGISTERER_NAME'
,p_display_order=>80
,p_column_identifier=>'F'
,p_column_label=>unistr('\767B\9332\8005\540D')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30655880111833406)
,p_db_column_name=>'PUBLISH_DATE'
,p_display_order=>90
,p_column_identifier=>'G'
,p_column_label=>unistr('\767A\884C\65E5')
,p_column_type=>'DATE'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30657415866833409)
,p_db_column_name=>'DOCUMENT_FILENAME'
,p_display_order=>110
,p_column_identifier=>'K'
,p_column_label=>'Document Filename'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30516140162647336)
,p_db_column_name=>'DOCUMENT'
,p_display_order=>120
,p_column_identifier=>'S'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8')
,p_column_type=>'NUMBER'
,p_heading_alignment=>'LEFT'
,p_format_mask=>'DOWNLOAD:DOCUMENT_BCT:DOCUMENT:DOCUMENT_ID:REVISION:DOCUMENT_MIMETYPE:DOCUMENT_FILENAME:DOCUMENT_REGISTER_DATE:DOCUMENT_CHARSET:attachment:#DOCUMENT_FILENAME#:'
);
wwv_flow_api.create_worksheet_rpt(
 p_id=>wwv_flow_api.id(59054488028424702)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'306578'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'DOCUMENT_ID:REVISION:STATUS:REGISTERER_NAME:PUBLISH_DATE:UPDATE_TYPE:CATEGORY:DOCUMENT'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(59052889842423203)
,p_plug_name=>unistr('\30D6\30EC\30C3\30C9\30AF\30E9\30E0')
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19476376565222003)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_api.id(19411976577221895)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_api.id(19530842457222109)
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(61165786657480662)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_08'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
unistr('<p>\6587\66F8\3068\305D\306E\4ED8\52A0\60C5\5831\306E\30C7\30FC\30BF\3092\4E00\89A7\5F62\5F0F\3067\8868\793A\3057\307E\3059\3002\3053\306E\30DA\30FC\30B8\3067\306F\3001\5404\6587\66F8\306B\3064\3044\3066\306E\904E\53BB\FF5E\6700\65B0\30D0\30FC\30B8\30E7\30F3\306E\30C7\30FC\30BF\3092\8868\793A\3057\307E\3059\3002<br>'),
unistr('\307E\305F\3001\4E00\89A7\306E\5DE6\7AEF\306E\866B\773C\93E1\306E\30A2\30A4\30B3\30F3\3092\30AF\30EA\30C3\30AF\3059\308B\3068\3001\305D\306E\6587\66F8\306E\5168\30D0\30FC\30B8\30E7\30F3\8868\793A\3001\4ED8\52A0\60C5\5831\3092\66F4\65B0\3001\65B0\30D0\30FC\30B8\30E7\30F3\3092\767B\9332\3059\308B\753B\9762\304C\958B\304D\307E\3059\3002'),
'</p>',
unistr('<p>\6587\66F8\306B\3064\3044\3066\FF1A<br>'),
unistr('\30FB\6587\66F8\30C7\30FC\30BF\306F\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\767B\9332\5F8C\306F\66F4\65B0\4E0D\80FD\3067\3059\3002<br>'),
unistr('\30FB\4ED8\52A0\60C5\5831\306E\30C7\30FC\30BF\306F\901A\5E38\306E\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\5F8C\304B\3089\66F4\65B0\3059\308B\3053\3068\304C\3067\304D\307E\3059\3002<br>'),
unistr('\30FB\3072\3068\3064\306E\6587\66F8\FF08\540C\4E00\306E\30C9\30AD\30E5\30E1\30F3\30C8ID\3092\4ED8\4E0E\3055\308C\305F\6587\66F8\30C7\30FC\30BF\FF09\306B\5BFE\3057\3066\3072\3068\3064\FF5E\8907\6570\306E\30D0\30FC\30B8\30E7\30F3\306E\6587\66F8\30C7\30FC\30BF\304C\5B58\5728\3057\307E\3059\3002<br>'),
unistr('\30FB\4ED8\52A0\60C5\5831\306F\3072\3068\3064\306E\6587\66F8\306B\5BFE\3057\3066\3072\3068\3064\3067\3059\FF08\8907\6570\30D0\30FC\30B8\30E7\30F3\304C\5B58\5728\3059\308B\5834\5408\3082\5171\901A\3067\3059\FF09\3002<br></p>')))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
end;
/
prompt --application/pages/page_00004
begin
wwv_flow_api.create_page(
 p_id=>4
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\6587\66F8\65B0\898F\767B\9332')
,p_alias=>unistr('\6587\66F8\65B0\898F\767B\9332')
,p_step_title=>unistr('\6587\66F8\65B0\898F\767B\9332')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210812115610'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(20310179814835707)
,p_plug_name=>unistr('\6587\66F8\FF08\767B\9332\5F8C\66F4\65B0\4E0D\80FD\FF09')
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19466940555221989)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'DOCUMENT_BCT'
,p_include_rowid_column=>true
,p_is_editable=>false
,p_plug_source_type=>'NATIVE_FORM'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(20311498999835720)
,p_plug_name=>unistr('\4ED8\52A0\60C5\5831\FF08\5F8C\304B\3089\66F4\65B0\53EF\80FD\FF09')
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19466940555221989)
,p_plug_display_sequence=>20
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'ADDITIONAL_INFO'
,p_include_rowid_column=>true
,p_is_editable=>false
,p_plug_source_type=>'NATIVE_FORM'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(28372334414729802)
,p_plug_name=>'Breadcrumb'
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19476376565222003)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_api.id(19411976577221895)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_api.id(19530842457222109)
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30512805212647303)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_08'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
unistr('<p>\6587\66F8\3068\305D\306E\4ED8\52A0\60C5\5831\306E\30C7\30FC\30BF\3092\767B\9332\3057\307E\3059\3002</p>'),
unistr('<p>\6587\66F8\306B\3064\3044\3066\FF1A<br>'),
unistr('\30FB\6587\66F8\30C7\30FC\30BF\306F\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\767B\9332\5F8C\306F\66F4\65B0\4E0D\80FD\3067\3059\3002<br>'),
unistr('\30FB\4ED8\52A0\60C5\5831\306E\30C7\30FC\30BF\306F\901A\5E38\306E\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\5F8C\304B\3089\66F4\65B0\3059\308B\3053\3068\304C\3067\304D\307E\3059\3002<br>'),
unistr('\30FB\3072\3068\3064\306E\6587\66F8\FF08\540C\4E00\306E\30C9\30AD\30E5\30E1\30F3\30C8ID\3092\4ED8\4E0E\3055\308C\305F\6587\66F8\30C7\30FC\30BF\FF09\306B\5BFE\3057\3066\3072\3068\3064\FF5E\8907\6570\306E\30D0\30FC\30B8\30E7\30F3\306E\6587\66F8\30C7\30FC\30BF\304C\5B58\5728\3057\307E\3059\3002<br>'),
unistr('\30FB\4ED8\52A0\60C5\5831\306F\3072\3068\3064\306E\6587\66F8\306B\5BFE\3057\3066\3072\3068\3064\3067\3059\FF08\8907\6570\30D0\30FC\30B8\30E7\30F3\304C\5B58\5728\3059\308B\5834\5408\3082\5171\901A\3067\3059\FF09\3002<br></p>')))
,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(28372490126729803)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(28372334414729802)
,p_button_name=>unistr('\767B\9332')
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(19529478185222106)
,p_button_is_hot=>'Y'
,p_button_image_alt=>unistr('\767B\9332')
,p_button_position=>'REGION_TEMPLATE_NEXT'
,p_database_action=>'INSERT'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(20310324840835709)
,p_name=>'P4_DOCUMENT_ID_D'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(20310179814835707)
,p_item_source_plug_id=>wwv_flow_api.id(20310179814835707)
,p_prompt=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8ID')
,p_source=>'DOCUMENT_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_cMaxlength=>128
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(20310485225835710)
,p_name=>'P4_REVISION'
,p_source_data_type=>'NUMBER'
,p_is_required=>true
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(20310179814835707)
,p_item_source_plug_id=>wwv_flow_api.id(20310179814835707)
,p_item_default=>'1'
,p_prompt=>unistr('\30D0\30FC\30B8\30E7\30F3')
,p_source=>'REVISION'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_NUMBER_FIELD'
,p_cSize=>30
,p_read_only_when_type=>'ALWAYS'
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_03=>'left'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(20310594164835711)
,p_name=>'P4_DOCUMENT_TITLE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(20310179814835707)
,p_item_source_plug_id=>wwv_flow_api.id(20310179814835707)
,p_prompt=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8\540D')
,p_source=>'DOCUMENT_TITLE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_cMaxlength=>256
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(20310634152835712)
,p_name=>'P4_REGISTERER_NAME'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_api.id(20310179814835707)
,p_item_source_plug_id=>wwv_flow_api.id(20310179814835707)
,p_prompt=>unistr('\767B\9332\8005\540D')
,p_source=>'REGISTERER_NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_cMaxlength=>128
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(20310736676835713)
,p_name=>'P4_PUBLISH_DATE'
,p_source_data_type=>'DATE'
,p_is_required=>true
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_api.id(20310179814835707)
,p_item_source_plug_id=>wwv_flow_api.id(20310179814835707)
,p_item_default=>'select sysdate from dual'
,p_item_default_type=>'SQL_QUERY'
,p_prompt=>unistr('\767A\884C\65E5')
,p_source=>'PUBLISH_DATE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DATE_PICKER'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_04=>'button'
,p_attribute_05=>'N'
,p_attribute_07=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(20310828571835714)
,p_name=>'P4_UPDATE_TYPE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>60
,p_item_plug_id=>wwv_flow_api.id(20310179814835707)
,p_item_source_plug_id=>wwv_flow_api.id(20310179814835707)
,p_prompt=>unistr('\66F4\65B0\7A2E\5225')
,p_source=>'UPDATE_TYPE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'UPDATE_TYPE_LIST'
,p_cHeight=>1
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,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(20310955928835715)
,p_name=>'P4_DOCUMENT'
,p_source_data_type=>'BLOB'
,p_is_required=>true
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_api.id(20310179814835707)
,p_item_source_plug_id=>wwv_flow_api.id(20310179814835707)
,p_prompt=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8')
,p_source=>'DOCUMENT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_02=>'DOCUMENT_MIMETYPE'
,p_attribute_03=>'DOCUMENT_FILENAME'
,p_attribute_04=>'DOCUMENT_CHARSET'
,p_attribute_05=>'DOCUMENT_REGISTER_DATE'
,p_attribute_06=>'N'
,p_attribute_12=>'DROPZONE_INLINE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(20311890812835724)
,p_name=>'P4_STATUS'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(20311498999835720)
,p_item_source_plug_id=>wwv_flow_api.id(20311498999835720)
,p_prompt=>unistr('\30B9\30C6\30FC\30BF\30B9')
,p_source=>'STATUS'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'STATUS_LIST'
,p_lov_display_null=>'YES'
,p_cHeight=>1
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,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(20311956078835725)
,p_name=>'P4_REMARKS'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_api.id(20311498999835720)
,p_item_source_plug_id=>wwv_flow_api.id(20311498999835720)
,p_prompt=>unistr('\5099\8003')
,p_source=>'REMARKS'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXTAREA'
,p_cSize=>30
,p_cMaxlength=>4000
,p_cHeight=>5
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(20312051881835726)
,p_name=>'P4_ROWID_D'
,p_source_data_type=>'ROWID'
,p_is_primary_key=>true
,p_item_sequence=>120
,p_item_plug_id=>wwv_flow_api.id(20310179814835707)
,p_item_source_plug_id=>wwv_flow_api.id(20310179814835707)
,p_source=>'ROWID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(20312189459835727)
,p_name=>'P4_ROWID_A'
,p_source_data_type=>'ROWID'
,p_is_primary_key=>true
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_api.id(20311498999835720)
,p_item_source_plug_id=>wwv_flow_api.id(20311498999835720)
,p_source=>'ROWID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(20313026426835736)
,p_name=>'P4_CATEGORY'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(20311498999835720)
,p_item_source_plug_id=>wwv_flow_api.id(20311498999835720)
,p_prompt=>unistr('\30AB\30C6\30B4\30EA\30FC')
,p_source=>'CATEGORY'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'CATEGORY_LIST'
,p_lov_display_null=>'YES'
,p_cHeight=>1
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,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(28372505324729804)
,p_name=>'P4_DOCUMENT_ID_A'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(20311498999835720)
,p_item_source_plug_id=>wwv_flow_api.id(20311498999835720)
,p_source=>'DOCUMENT_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(28373092560729809)
,p_name=>unistr('\5909\66F4')
,p_event_sequence=>10
,p_triggering_element_type=>'ITEM'
,p_triggering_element=>'P4_DOCUMENT_ID_D'
,p_bind_type=>'bind'
,p_bind_event_type=>'change'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(28373103349729810)
,p_event_id=>wwv_flow_api.id(28373092560729809)
,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=>'P4_DOCUMENT_ID_A'
,p_attribute_01=>'SQL_STATEMENT'
,p_attribute_03=>'SELECT :P4_DOCUMENT_ID_D FROM DUAL'
,p_attribute_07=>'P4_DOCUMENT_ID_D'
,p_attribute_08=>'Y'
,p_attribute_09=>'N'
,p_wait_for_result=>'Y'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(20314395601835749)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(20310179814835707)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>unistr('\30D7\30ED\30BB\30B9\6587\66F8')
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_process_error_message=>unistr('\3010\6587\66F8\30C7\30FC\30BF\306E\767B\9332\30FC\5931\6557\3011')
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_success_message=>unistr('\3010\6587\66F8\30C7\30FC\30BF\306E\767B\9332\30FC\6210\529F\3011')
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(20314436574835750)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(20311498999835720)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>unistr('\30D7\30ED\30BB\30B9\4ED8\52A0\60C5\5831')
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_process_error_message=>unistr('\3010\4ED8\52A0\60C5\5831\30C7\30FC\30BF\306E\767B\9332\30FC\6210\529F\3011')
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_success_message=>unistr('\3010\4ED8\52A0\60C5\5831\30C7\30FC\30BF\306E\767B\9332\30FC\6210\529F\3011')
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(20310244825835708)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(20310179814835707)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>unistr('\521D\671F\5316\30D5\30A9\30FC\30E0\6587\66F8\65B0\898F\767B\9332\FF0F\6587\66F8')
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(20311528639835721)
,p_process_sequence=>20
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(20311498999835720)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>unistr('\521D\671F\5316\30D5\30A9\30FC\30E0\6587\66F8\65B0\898F\767B\9332\FF0F\4ED8\52A0\60C5\5831')
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
end;
/
prompt --application/pages/page_00005
begin
wwv_flow_api.create_page(
 p_id=>5
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\6587\66F8\4E00\89A7\FF08\6700\65B0\30D0\30FC\30B8\30E7\30F3\FF09')
,p_alias=>unistr('\6587\66F8\4E00\89A7\FF08\6700\65B0\30D0\30FC\30B8\30E7\30F3\FF09')
,p_step_title=>unistr('\6587\66F8\4E00\89A7\FF08\6700\65B0\30D0\30FC\30B8\30E7\30F3\FF09')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210812115621'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(28395075258589818)
,p_plug_name=>unistr('\30EC\30DD\30FC\30C81')
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19465095800221986)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_query_type=>'SQL'
,p_plug_source=>'select "DOCUMENT_ID","STATUS","REVISION","DOCUMENT_TITLE","REGISTERER_NAME","PUBLISH_DATE","UPDATE_TYPE", DBMS_LOB.GETLENGTH(DOCUMENT) "DOCUMENT","CATEGORY", "DOCUMENT_FILENAME" from "LATEST_DOCUMENT_WITH_ADDITIONAL_INFO"'
,p_plug_source_type=>'NATIVE_IR'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_prn_page_header=>unistr('\30EC\30DD\30FC\30C81')
);
wwv_flow_api.create_worksheet(
 p_id=>wwv_flow_api.id(28395404563589819)
,p_name=>unistr('\30EC\30DD\30FC\30C81')
,p_max_row_count_message=>unistr('\3053\306E\30EC\30DD\30FC\30C8\306E\6700\5927\884C\6570\306F#MAX_ROW_COUNT#\884C\3067\3059\3002\30D5\30A3\30EB\30BF\3092\9069\7528\3057\3066\3001\554F\5408\305B\306E\30EC\30B3\30FC\30C9\6570\3092\524A\6E1B\3057\3066\304F\3060\3055\3044\3002')
,p_no_data_found_message=>unistr('\30C7\30FC\30BF\304C\898B\3064\304B\308A\307E\305B\3093\3002')
,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:XLSX:PDF:RTF'
,p_detail_link=>'f?p=&APP_ID.:6:&SESSION.::&DEBUG.:RP,:P6_DOCUMENT_ID:#DOCUMENT_ID#'
,p_detail_link_text=>'<img src="#IMAGE_PREFIX#app_ui/img/icons/apex-edit-view.png" class="apex-edit-view" alt="">'
,p_owner=>'DOCUMENT_BCT'
,p_internal_uid=>28395404563589819
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(28399056608589834)
,p_db_column_name=>'CATEGORY'
,p_display_order=>10
,p_column_identifier=>'J'
,p_column_label=>unistr('\30AB\30C6\30B4\30EA\30FC')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(28395945983589828)
,p_db_column_name=>'DOCUMENT_ID'
,p_display_order=>20
,p_column_identifier=>'B'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8ID')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(28396662735589830)
,p_db_column_name=>'REVISION'
,p_display_order=>30
,p_column_identifier=>'D'
,p_column_label=>unistr('\30D0\30FC\30B8\30E7\30F3')
,p_column_type=>'NUMBER'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(28396210300589829)
,p_db_column_name=>'STATUS'
,p_display_order=>40
,p_column_identifier=>'C'
,p_column_label=>unistr('\30B9\30C6\30FC\30BF\30B9')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(28398295840589832)
,p_db_column_name=>'UPDATE_TYPE'
,p_display_order=>50
,p_column_identifier=>'H'
,p_column_label=>unistr('\66F4\65B0\7A2E\5225')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(28397031217589830)
,p_db_column_name=>'DOCUMENT_TITLE'
,p_display_order=>60
,p_column_identifier=>'E'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8\540D')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(28397417289589831)
,p_db_column_name=>'REGISTERER_NAME'
,p_display_order=>70
,p_column_identifier=>'F'
,p_column_label=>unistr('\767B\9332\8005\540D')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(28397881715589832)
,p_db_column_name=>'PUBLISH_DATE'
,p_display_order=>80
,p_column_identifier=>'G'
,p_column_label=>unistr('\767A\884C\65E5')
,p_column_type=>'DATE'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30080840008935115)
,p_db_column_name=>'DOCUMENT_FILENAME'
,p_display_order=>100
,p_column_identifier=>'K'
,p_column_label=>'Document Filename'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30515974641647334)
,p_db_column_name=>'DOCUMENT'
,p_display_order=>110
,p_column_identifier=>'M'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8')
,p_column_type=>'NUMBER'
,p_heading_alignment=>'LEFT'
,p_format_mask=>'DOWNLOAD:DOCUMENT_BCT:DOCUMENT:DOCUMENT_ID:REVISION:DOCUMENT_MIMETYPE:DOCUMENT_FILENAME:DOCUMENT_REGISTER_DATE:DOCUMENT_CHARSET:attachment:#DOCUMENT_FILENAME#:'
);
wwv_flow_api.create_worksheet_rpt(
 p_id=>wwv_flow_api.id(28401941672591347)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'284020'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'DOCUMENT_ID:REVISION:DOCUMENT_TITLE:STATUS:REGISTERER_NAME:PUBLISH_DATE:UPDATE_TYPE:CATEGORY:DOCUMENT:'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(28400343486589848)
,p_plug_name=>unistr('\30D6\30EC\30C3\30C9\30AF\30E9\30E0')
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19476376565222003)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_api.id(19411976577221895)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_api.id(19530842457222109)
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30513240301647307)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_08'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
unistr('<p>\6587\66F8\3068\305D\306E\4ED8\52A0\60C5\5831\306E\30C7\30FC\30BF\3092\4E00\89A7\5F62\5F0F\3067\8868\793A\3057\307E\3059\3002\3053\306E\30DA\30FC\30B8\3067\306F\3001\5404\6587\66F8\306B\3064\3044\3066\306E\6700\65B0\30D0\30FC\30B8\30E7\30F3\306E\30C7\30FC\30BF\306E\307F\3092\8868\793A\3057\307E\3059\3002<br>'),
unistr('\307E\305F\3001\4E00\89A7\306E\5DE6\7AEF\306E\866B\773C\93E1\306E\30A2\30A4\30B3\30F3\3092\30AF\30EA\30C3\30AF\3059\308B\3068\3001\305D\306E\6587\66F8\306E\5168\30D0\30FC\30B8\30E7\30F3\8868\793A\3001\4ED8\52A0\60C5\5831\3092\66F4\65B0\3001\65B0\30D0\30FC\30B8\30E7\30F3\3092\767B\9332\3059\308B\753B\9762\304C\958B\304D\307E\3059\3002'),
'</p>',
unistr('<p>\6587\66F8\306B\3064\3044\3066\FF1A<br>'),
unistr('\30FB\6587\66F8\30C7\30FC\30BF\306F\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\767B\9332\5F8C\306F\66F4\65B0\4E0D\80FD\3067\3059\3002<br>'),
unistr('\30FB\4ED8\52A0\60C5\5831\306E\30C7\30FC\30BF\306F\901A\5E38\306E\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\5F8C\304B\3089\66F4\65B0\3059\308B\3053\3068\304C\3067\304D\307E\3059\3002<br>'),
unistr('\30FB\3072\3068\3064\306E\6587\66F8\FF08\540C\4E00\306E\30C9\30AD\30E5\30E1\30F3\30C8ID\3092\4ED8\4E0E\3055\308C\305F\6587\66F8\30C7\30FC\30BF\FF09\306B\5BFE\3057\3066\3072\3068\3064\FF5E\8907\6570\306E\30D0\30FC\30B8\30E7\30F3\306E\6587\66F8\30C7\30FC\30BF\304C\5B58\5728\3057\307E\3059\3002<br>'),
unistr('\30FB\4ED8\52A0\60C5\5831\306F\3072\3068\3064\306E\6587\66F8\306B\5BFE\3057\3066\3072\3068\3064\3067\3059\FF08\8907\6570\30D0\30FC\30B8\30E7\30F3\304C\5B58\5728\3059\308B\5834\5408\3082\5171\901A\3067\3059\FF09\3002<br></p>')))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
end;
/
prompt --application/pages/page_00006
begin
wwv_flow_api.create_page(
 p_id=>6
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\6587\66F8\30D0\30FC\30B8\30E7\30F3\4E00\89A7\30FB\4ED8\52A0\60C5\5831\66F4\65B0')
,p_alias=>unistr('\6587\66F8\30D0\30FC\30B8\30E7\30F3\4E00\89A7\30FB\4ED8\52A0\60C5\5831\66F4\65B0')
,p_step_title=>unistr('\6587\66F8\30D0\30FC\30B8\30E7\30F3\4E00\89A7\30FB\4ED8\52A0\60C5\5831\66F4\65B0')
,p_autocomplete_on_off=>'OFF'
,p_javascript_code=>'var htmldb_delete_message=''"DELETE_CONFIRM_MSG"'';'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210812115631'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(28388539320589780)
,p_plug_name=>unistr('\4ED8\52A0\60C5\5831')
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19466940555221989)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'ADDITIONAL_INFO'
,p_include_rowid_column=>true
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_plug_source_type=>'NATIVE_FORM'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(28400914997589851)
,p_plug_name=>unistr('\30D6\30EC\30C3\30C9\30AF\30E9\30E0')
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19476376565222003)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_api.id(19411976577221895)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_api.id(19530842457222109)
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(29974239390687949)
,p_plug_name=>unistr('\3053\306E\6587\66F8\306E\30D0\30FC\30B8\30E7\30F3\4E00\89A7')
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19466940555221989)
,p_plug_display_sequence=>20
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select DOCUMENT_ID,',
'       REVISION,',
'       DOCUMENT_TITLE,',
'       REGISTERER_NAME,',
'       PUBLISH_DATE,',
'       UPDATE_TYPE,',
'       sys.dbms_lob.getlength(DOCUMENT) DOCUMENT,',
'       DOCUMENT_FILENAME',
'  from DOCUMENT_BCT',
'  where DOCUMENT_ID = :P6_DOCUMENT_ID',
'  order by REVISION'))
,p_plug_source_type=>'NATIVE_IR'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_prn_content_disposition=>'ATTACHMENT'
,p_prn_document_header=>'APEX'
,p_prn_units=>'MILLIMETERS'
,p_prn_paper_size=>'A4'
,p_prn_width=>297
,p_prn_height=>210
,p_prn_orientation=>'HORIZONTAL'
,p_prn_page_header=>unistr('\3053\306E\6587\66F8\306E\30D0\30FC\30B8\30E7\30F3\4E00\89A7')
,p_prn_page_header_font_color=>'#000000'
,p_prn_page_header_font_family=>'Helvetica'
,p_prn_page_header_font_weight=>'normal'
,p_prn_page_header_font_size=>'12'
,p_prn_page_footer_font_color=>'#000000'
,p_prn_page_footer_font_family=>'Helvetica'
,p_prn_page_footer_font_weight=>'normal'
,p_prn_page_footer_font_size=>'12'
,p_prn_header_bg_color=>'#EEEEEE'
,p_prn_header_font_color=>'#000000'
,p_prn_header_font_family=>'Helvetica'
,p_prn_header_font_weight=>'bold'
,p_prn_header_font_size=>'10'
,p_prn_body_bg_color=>'#FFFFFF'
,p_prn_body_font_color=>'#000000'
,p_prn_body_font_family=>'Helvetica'
,p_prn_body_font_weight=>'normal'
,p_prn_body_font_size=>'10'
,p_prn_border_width=>.5
,p_prn_page_header_alignment=>'CENTER'
,p_prn_page_footer_alignment=>'CENTER'
,p_prn_border_color=>'#666666'
);
wwv_flow_api.create_worksheet(
 p_id=>wwv_flow_api.id(29974362511687950)
,p_max_row_count=>'1000000'
,p_pagination_type=>'ROWS_X_TO_Y'
,p_pagination_display_pos=>'BOTTOM_RIGHT'
,p_report_list_mode=>'TABS'
,p_show_detail_link=>'C'
,p_show_notify=>'Y'
,p_download_formats=>'CSV:HTML:XLSX:PDF:RTF:EMAIL'
,p_detail_link=>'f?p=&APP_ID.:8:&SESSION.::&DEBUG.::P8_DOCUMENT_ID,P8_REVISION:#DOCUMENT_ID#,#REVISION#'
,p_detail_link_text=>'<img src="#IMAGE_PREFIX#app_ui/img/icons/apex-edit-view.png" class="apex-edit-view" alt="">'
,p_owner=>'DOCUMENT_BCT'
,p_internal_uid=>29974362511687950
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30079465758935101)
,p_db_column_name=>'DOCUMENT_ID'
,p_display_order=>10
,p_column_identifier=>'A'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8ID')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30079578204935102)
,p_db_column_name=>'REVISION'
,p_display_order=>20
,p_column_identifier=>'B'
,p_column_label=>unistr('\30D0\30FC\30B8\30E7\30F3')
,p_column_type=>'NUMBER'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30079689677935103)
,p_db_column_name=>'DOCUMENT_TITLE'
,p_display_order=>30
,p_column_identifier=>'C'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8\540D')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30079780194935104)
,p_db_column_name=>'REGISTERER_NAME'
,p_display_order=>40
,p_column_identifier=>'D'
,p_column_label=>unistr('\767B\9332\8005\540D')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30079814897935105)
,p_db_column_name=>'PUBLISH_DATE'
,p_display_order=>50
,p_column_identifier=>'E'
,p_column_label=>unistr('\767A\884C\65E5')
,p_column_type=>'DATE'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30079959647935106)
,p_db_column_name=>'UPDATE_TYPE'
,p_display_order=>60
,p_column_identifier=>'F'
,p_column_label=>unistr('\66F4\65B0\7A2E\5225')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30080690022935113)
,p_db_column_name=>'DOCUMENT'
,p_display_order=>70
,p_column_identifier=>'M'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8')
,p_column_type=>'NUMBER'
,p_heading_alignment=>'LEFT'
,p_format_mask=>'DOWNLOAD:DOCUMENT_BCT:DOCUMENT:DOCUMENT_ID:REVISION:DOCUMENT_MIMETYPE:DOCUMENT_FILENAME:DOCUMENT_REGISTER_DATE:DOCUMENT_CHARSET:attachment:#DOCUMENT_FILENAME#:'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30080798234935114)
,p_db_column_name=>'DOCUMENT_FILENAME'
,p_display_order=>80
,p_column_identifier=>'N'
,p_column_label=>'Document Filename'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_rpt(
 p_id=>wwv_flow_api.id(30088508169937335)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'300886'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'DOCUMENT_ID:REVISION:DOCUMENT_TITLE:REGISTERER_NAME:PUBLISH_DATE:UPDATE_TYPE:DOCUMENT:'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30513303842647308)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_08'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
unistr('<p>\3042\308B\6587\66F8\306E\5168\3066\306E\30D0\30FC\30B8\30E7\30F3\306E\30C7\30FC\30BF\3001\304A\3088\3073\4ED8\52A0\60C5\5831\306E\30C7\30FC\30BF\3092\8868\793A\3057\307E\3059\3002<br>'),
unistr('\307E\305F\3001\305D\306E\6587\66F8\306B\3064\3044\3066\306E\4ED8\52A0\60C5\5831\306E\66F4\65B0\3001\304A\3088\3073\65B0\30D0\30FC\30B8\30E7\30F3\306E\767B\9332\3092\884C\3046\3053\3068\304C\3067\304D\307E\3059\3002</p>'),
unistr('<p>\6587\66F8\306B\3064\3044\3066\FF1A<br>'),
unistr('\30FB\6587\66F8\30C7\30FC\30BF\306F\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\767B\9332\5F8C\306F\66F4\65B0\4E0D\80FD\3067\3059\3002<br>'),
unistr('\30FB\4ED8\52A0\60C5\5831\306E\30C7\30FC\30BF\306F\901A\5E38\306E\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\5F8C\304B\3089\66F4\65B0\3059\308B\3053\3068\304C\3067\304D\307E\3059\3002<br>'),
unistr('\30FB\3072\3068\3064\306E\6587\66F8\FF08\540C\4E00\306E\30C9\30AD\30E5\30E1\30F3\30C8ID\3092\4ED8\4E0E\3055\308C\305F\6587\66F8\30C7\30FC\30BF\FF09\306B\5BFE\3057\3066\3072\3068\3064\FF5E\8907\6570\306E\30D0\30FC\30B8\30E7\30F3\306E\6587\66F8\30C7\30FC\30BF\304C\5B58\5728\3057\307E\3059\3002<br>'),
unistr('\30FB\4ED8\52A0\60C5\5831\306F\3072\3068\3064\306E\6587\66F8\306B\5BFE\3057\3066\3072\3068\3064\3067\3059\FF08\8907\6570\30D0\30FC\30B8\30E7\30F3\304C\5B58\5728\3059\308B\5834\5408\3082\5171\901A\3067\3059\FF09\3002<br></p>')))
,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(28429100819920523)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(28400914997589851)
,p_button_name=>unistr('\65B0\30D0\30FC\30B8\30E7\30F3\767B\9332')
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(19529478185222106)
,p_button_is_hot=>'Y'
,p_button_image_alt=>unistr('\65B0\30D0\30FC\30B8\30E7\30F3\767B\9332')
,p_button_position=>'REGION_TEMPLATE_CREATE'
,p_button_redirect_url=>'f?p=&APP_ID.:7:&SESSION.::&DEBUG.::P7_DOCUMENT_ID,P7_REVISION:&P6_DOCUMENT_ID.,&P6_CURRENT_MAX_REVISION.'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(28392880858589809)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(28388539320589780)
,p_button_name=>'SAVE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(19529478185222106)
,p_button_is_hot=>'Y'
,p_button_image_alt=>unistr('\5909\66F4\306E\9069\7528')
,p_button_position=>'REGION_TEMPLATE_EDIT'
,p_button_condition=>'P6_DOCUMENT_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'UPDATE'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(28391602069589803)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(28400914997589851)
,p_button_name=>'CANCEL'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(19529478185222106)
,p_button_image_alt=>unistr('\4E00\89A7\306B\623B\308B')
,p_button_position=>'REGION_TEMPLATE_PREVIOUS'
,p_button_redirect_url=>'f?p=&APP_ID.:5:&SESSION.::&DEBUG.:::'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(28373200815729811)
,p_name=>'P6_REMARKS'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>60
,p_item_plug_id=>wwv_flow_api.id(28388539320589780)
,p_item_source_plug_id=>wwv_flow_api.id(28388539320589780)
,p_prompt=>unistr('\5099\8003')
,p_source=>'REMARKS'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXTAREA'
,p_cSize=>30
,p_cMaxlength=>4000
,p_cHeight=>5
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(28389261460589792)
,p_name=>'P6_DOCUMENT_ID'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_is_primary_key=>true
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(28388539320589780)
,p_item_source_plug_id=>wwv_flow_api.id(28388539320589780)
,p_prompt=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8ID')
,p_source=>'DOCUMENT_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>60
,p_cMaxlength=>128
,p_read_only_when_type=>'ALWAYS'
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(28389601067589797)
,p_name=>'P6_STATUS'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_api.id(28388539320589780)
,p_item_source_plug_id=>wwv_flow_api.id(28388539320589780)
,p_prompt=>unistr('\30B9\30C6\30FC\30BF\30B9')
,p_source=>'STATUS'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'STATUS_LIST'
,p_lov_display_null=>'YES'
,p_cHeight=>1
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,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(28390079243589799)
,p_name=>'P6_CATEGORY'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_api.id(28388539320589780)
,p_item_source_plug_id=>wwv_flow_api.id(28388539320589780)
,p_prompt=>unistr('\30AB\30C6\30B4\30EA\30FC')
,p_source=>'CATEGORY'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'CATEGORY_LIST'
,p_lov_display_null=>'YES'
,p_cHeight=>1
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,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(29970840712687915)
,p_name=>'P6_CURRENT_MAX_REVISION'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(28400914997589851)
,p_use_cache_before_default=>'NO'
,p_source=>'SELECT MAX(revision) FROM document_bct WHERE document_id = :P6_DOCUMENT_ID'
,p_source_type=>'QUERY'
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(28394464167589814)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(28388539320589780)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>unistr('\30D7\30ED\30BB\30B9\30FB\30D5\30A9\30FC\30E0\6587\66F8\8A73\7D30')
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(28394057887589812)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(28388539320589780)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>unistr('\521D\671F\5316\30D5\30A9\30FC\30E0\6587\66F8\8A73\7D30')
);
end;
/
prompt --application/pages/page_00007
begin
wwv_flow_api.create_page(
 p_id=>7
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\6587\66F8\65B0\30D0\30FC\30B8\30E7\30F3\767B\9332')
,p_alias=>unistr('\6587\66F8\65B0\30D0\30FC\30B8\30E7\30F3\767B\9332')
,p_page_mode=>'MODAL'
,p_step_title=>unistr('\6587\66F8\65B0\30D0\30FC\30B8\30E7\30F3\767B\9332')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210812115644'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30513883738647313)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_01'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
unistr('<p>\3042\308B\6587\66F8\306E\65B0\3057\3044\30D0\30FC\30B8\30E7\30F3\3092\767B\9332\3057\307E\3059\3002</p>'),
unistr('<p>\6587\66F8\306B\3064\3044\3066\FF1A<br>'),
unistr('\30FB\6587\66F8\30C7\30FC\30BF\306F\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\767B\9332\5F8C\306F\66F4\65B0\4E0D\80FD\3067\3059\3002<br>'),
unistr('\30FB\4ED8\52A0\60C5\5831\306E\30C7\30FC\30BF\306F\901A\5E38\306E\30C6\30FC\30D6\30EB\306B\4FDD\5B58\3055\308C\3001\5F8C\304B\3089\66F4\65B0\3059\308B\3053\3068\304C\3067\304D\307E\3059\3002<br>'),
unistr('\30FB\3072\3068\3064\306E\6587\66F8\FF08\540C\4E00\306E\30C9\30AD\30E5\30E1\30F3\30C8ID\3092\4ED8\4E0E\3055\308C\305F\6587\66F8\30C7\30FC\30BF\FF09\306B\5BFE\3057\3066\3072\3068\3064\FF5E\8907\6570\306E\30D0\30FC\30B8\30E7\30F3\306E\6587\66F8\30C7\30FC\30BF\304C\5B58\5728\3057\307E\3059\3002<br>'),
unistr('\30FB\4ED8\52A0\60C5\5831\306F\3072\3068\3064\306E\6587\66F8\306B\5BFE\3057\3066\3072\3068\3064\3067\3059\FF08\8907\6570\30D0\30FC\30B8\30E7\30F3\304C\5B58\5728\3059\308B\5834\5408\3082\5171\901A\3067\3059\FF09\3002<br></p>')))
,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(50252241298280149)
,p_plug_name=>unistr('\6587\66F8\FF08\767B\9332\5F8C\66F4\65B0\4E0D\80FD\FF09')
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19466940555221989)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select DOCUMENT_ID,',
'       REVISION,',
'       DOCUMENT_TITLE,',
'       REGISTERER_NAME,',
'       PUBLISH_DATE,',
'       UPDATE_TYPE,',
'       DOCUMENT,',
'       DOCUMENT_MIMETYPE,',
'       DOCUMENT_FILENAME,',
'       DOCUMENT_REGISTER_DATE,',
'       DOCUMENT_CHARSET',
'  from DOCUMENT_BCT',
' where document_id = :P7_DOCUMENT_ID',
'   and revision = :P7_REVISION'))
,p_is_editable=>false
,p_plug_source_type=>'NATIVE_FORM'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(29949397037444495)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(50252241298280149)
,p_button_name=>unistr('\767B\9332')
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(19529478185222106)
,p_button_is_hot=>'Y'
,p_button_image_alt=>unistr('\767B\9332')
,p_button_position=>'REGION_TEMPLATE_CREATE'
,p_database_action=>'INSERT'
);
wwv_flow_api.create_page_branch(
 p_id=>wwv_flow_api.id(29970981114687916)
,p_branch_action=>'f?p=&APP_ID.:6:&SESSION.::&DEBUG.::P6_DOCUMENT_ID:&P7_DOCUMENT_ID.&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'AFTER_PROCESSING'
,p_branch_type=>'REDIRECT_URL'
,p_branch_sequence=>10
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(28431413865920546)
,p_name=>'P7_DOCUMENT_MIMETYPE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>90
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_source=>'DOCUMENT_MIMETYPE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(28431559410920547)
,p_name=>'P7_DOCUMENT_FILENAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>100
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_source=>'DOCUMENT_FILENAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(28431603745920548)
,p_name=>'P7_DOCUMENT_REGISTER_DATE'
,p_source_data_type=>'DATE'
,p_item_sequence=>110
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_source=>'DOCUMENT_REGISTER_DATE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(28431790294920549)
,p_name=>'P7_DOCUMENT_CHARSET'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>120
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_source=>'DOCUMENT_CHARSET'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(28431898377920550)
,p_name=>'P7_REVISION'
,p_source_data_type=>'NUMBER'
,p_is_primary_key=>true
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_source=>'REVISION'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(29942659788444478)
,p_name=>'P7_DOCUMENT_ID'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_is_primary_key=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_prompt=>'Document Id'
,p_source=>'DOCUMENT_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_cMaxlength=>128
,p_read_only_when_type=>'ALWAYS'
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(29943406773444481)
,p_name=>'P7_DOCUMENT_TITLE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_prompt=>'Document Title'
,p_source=>'DOCUMENT_TITLE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_cMaxlength=>256
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(29943870589444482)
,p_name=>'P7_REGISTERER_NAME'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_prompt=>'Registerer Name'
,p_source=>'REGISTERER_NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_cMaxlength=>128
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(29944212710444483)
,p_name=>'P7_PUBLISH_DATE'
,p_source_data_type=>'DATE'
,p_is_required=>true
,p_item_sequence=>60
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_default=>'select sysdate from dual'
,p_item_default_type=>'SQL_QUERY'
,p_prompt=>'Publish Date'
,p_source=>'PUBLISH_DATE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DATE_PICKER'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_04=>'button'
,p_attribute_05=>'N'
,p_attribute_07=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(29944639354444483)
,p_name=>'P7_UPDATE_TYPE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_default=>unistr('\4FEE\6B63')
,p_prompt=>'Update Type'
,p_source=>'UPDATE_TYPE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'UPDATE_TYPE_LIST'
,p_lov_display_null=>'YES'
,p_cHeight=>1
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,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(29945092342444484)
,p_name=>'P7_DOCUMENT'
,p_source_data_type=>'BLOB'
,p_is_required=>true
,p_item_sequence=>80
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_item_source_plug_id=>wwv_flow_api.id(50252241298280149)
,p_prompt=>'Document'
,p_source=>'DOCUMENT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_02=>'DOCUMENT_MIMETYPE'
,p_attribute_03=>'DOCUMENT_FILENAME'
,p_attribute_04=>'DOCUMENT_CHARSET'
,p_attribute_05=>'DOCUMENT_REGISTER_DATE'
,p_attribute_06=>'N'
,p_attribute_12=>'DROPZONE_INLINE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(29970358098687910)
,p_name=>'P7_REVISION_DUMMY'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(50252241298280149)
,p_prompt=>'New Revision'
,p_display_as=>'NATIVE_DISPLAY_ONLY'
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_attribute_01=>'N'
,p_attribute_02=>'VALUE'
,p_attribute_04=>'Y'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(29970109211687908)
,p_name=>unistr('\65B0REVISION\5024\306E\8A08\7B97')
,p_event_sequence=>20
,p_bind_type=>'bind'
,p_bind_event_type=>'ready'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(29970020687687907)
,p_event_id=>wwv_flow_api.id(29970109211687908)
,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=>'P7_REVISION'
,p_attribute_01=>'SQL_STATEMENT'
,p_attribute_03=>'select :P7_REVISION+1 from dual'
,p_attribute_07=>'P7_REVISION'
,p_attribute_08=>'N'
,p_attribute_09=>'N'
,p_wait_for_result=>'Y'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(29970425008687911)
,p_name=>unistr('\8868\793A\7528REVISION\5024\306E\5909\66F4')
,p_event_sequence=>30
,p_triggering_element_type=>'ITEM'
,p_triggering_element=>'P7_REVISION'
,p_bind_type=>'bind'
,p_bind_event_type=>'change'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(29970518089687912)
,p_event_id=>wwv_flow_api.id(29970425008687911)
,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=>'P7_REVISION_DUMMY'
,p_attribute_01=>'SQL_STATEMENT'
,p_attribute_03=>'SELECT :P7_REVISION from DUAL'
,p_attribute_07=>'P7_REVISION'
,p_attribute_08=>'N'
,p_attribute_09=>'N'
,p_wait_for_result=>'Y'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(29948632078444493)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(50252241298280149)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>unistr('\30D7\30ED\30BB\30B9\6587\66F8')
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_process_error_message=>unistr('\6587\66F8\306E\65B0\30D0\30FC\30B8\30E7\30F3\767B\9332\304C\5931\6557\3057\307E\3057\305F')
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_success_message=>unistr('\6587\66F8\306E\65B0\30D0\30FC\30B8\30E7\30F3\767B\9332\304C\6210\529F\3057\307E\3057\305F')
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(29948242672444492)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(50252241298280149)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>unistr('\521D\671F\5316\30D5\30A9\30FC\30E0\6587\66F8\65B0\898F\767B\9332\FF0F\6587\66F8')
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
end;
/
prompt --application/pages/page_00008
begin
wwv_flow_api.create_page(
 p_id=>8
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\6587\66F8\30D0\30FC\30B8\30E7\30F3\8A73\7D30\8868\793A')
,p_alias=>unistr('\6587\66F8\30D0\30FC\30B8\30E7\30F3\8A73\7D30\8868\793A')
,p_page_mode=>'MODAL'
,p_step_title=>unistr('\6587\66F8\30D0\30FC\30B8\30E7\30F3\8A73\7D30\8868\793A')
,p_warn_on_unsaved_changes=>'N'
,p_autocomplete_on_off=>'OFF'
,p_javascript_code=>'var htmldb_delete_message=''"DELETE_CONFIRM_MSG"'';'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_read_only_when_type=>'ALWAYS'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210804145317'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30465722474831577)
,p_plug_name=>unistr('\6587\66F8\8A73\7D30\8868\793A')
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19438548418221945)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'DOCUMENT_BCT'
,p_include_rowid_column=>false
,p_is_editable=>false
,p_plug_source_type=>'NATIVE_FORM'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30466008490831578)
,p_name=>'P8_DOCUMENT_ID'
,p_source_data_type=>'VARCHAR2'
,p_is_primary_key=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(30465722474831577)
,p_item_source_plug_id=>wwv_flow_api.id(30465722474831577)
,p_prompt=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8ID')
,p_source=>'DOCUMENT_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,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(30466453319831581)
,p_name=>'P8_REVISION'
,p_source_data_type=>'NUMBER'
,p_is_primary_key=>true
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(30465722474831577)
,p_item_source_plug_id=>wwv_flow_api.id(30465722474831577)
,p_prompt=>unistr('\30D0\30FC\30B8\30E7\30F3')
,p_source=>'REVISION'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,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(30466852147831584)
,p_name=>'P8_DOCUMENT_TITLE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(30465722474831577)
,p_item_source_plug_id=>wwv_flow_api.id(30465722474831577)
,p_prompt=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8\540D')
,p_source=>'DOCUMENT_TITLE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>60
,p_cMaxlength=>256
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30467273849831588)
,p_name=>'P8_REGISTERER_NAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_api.id(30465722474831577)
,p_item_source_plug_id=>wwv_flow_api.id(30465722474831577)
,p_prompt=>unistr('\767B\9332\8005\540D')
,p_source=>'REGISTERER_NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>60
,p_cMaxlength=>128
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30467631620831588)
,p_name=>'P8_PUBLISH_DATE'
,p_source_data_type=>'DATE'
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_api.id(30465722474831577)
,p_item_source_plug_id=>wwv_flow_api.id(30465722474831577)
,p_prompt=>unistr('\767A\884C\65E5')
,p_source=>'PUBLISH_DATE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>32
,p_cMaxlength=>255
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30468043371831595)
,p_name=>'P8_UPDATE_TYPE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>60
,p_item_plug_id=>wwv_flow_api.id(30465722474831577)
,p_item_source_plug_id=>wwv_flow_api.id(30465722474831577)
,p_prompt=>unistr('\66F4\65B0\7A2E\5225')
,p_source=>'UPDATE_TYPE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>60
,p_cMaxlength=>128
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30468483215831596)
,p_name=>'P8_DOCUMENT'
,p_source_data_type=>'BLOB'
,p_item_sequence=>80
,p_item_plug_id=>wwv_flow_api.id(30465722474831577)
,p_item_source_plug_id=>wwv_flow_api.id(30465722474831577)
,p_source=>'DOCUMENT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>60
,p_cMaxlength=>255
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_02=>'DOCUMENT_MIMETYPE'
,p_attribute_03=>'DOCUMENT_FILENAME'
,p_attribute_04=>'DOCUMENT_CHARSET'
,p_attribute_05=>'DOCUMENT_REGISTER_DATE'
,p_attribute_06=>'Y'
,p_attribute_08=>'attachment'
,p_attribute_12=>'INLINE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30468857212831597)
,p_name=>'P8_DOCUMENT_FILENAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_api.id(30465722474831577)
,p_item_source_plug_id=>wwv_flow_api.id(30465722474831577)
,p_prompt=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8\30D5\30A1\30A4\30EB\540D')
,p_source=>'DOCUMENT_FILENAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>60
,p_cMaxlength=>256
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(30476900306831614)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(30465722474831577)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>unistr('\521D\671F\5316\30D5\30A9\30FC\30E0\6587\66F8\8A73\7D30\8868\793A')
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
end;
/
prompt --application/pages/page_00010
begin
wwv_flow_api.create_page(
 p_id=>10
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\76E3\67FB')
,p_alias=>unistr('\76E3\67FB')
,p_step_title=>unistr('\76E3\67FB')
,p_warn_on_unsaved_changes=>'N'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210805013458'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30081204273935119)
,p_plug_name=>unistr('\8010\6539\3056\3093\6027\3001\691C\8A3C\53EF\80FD\6027\62C5\4FDD\306E\305F\3081\306E\30C7\30FC\30BF\4E00\89A7')
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19466940555221989)
,p_plug_display_sequence=>40
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'BODY'
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select document_id, revision, ORABCTAB_INST_ID$,ORABCTAB_CHAIN_ID$,ORABCTAB_SEQ_NUM$,ORABCTAB_CREATION_TIME$, ORABCTAB_USER_NUMBER$, ORABCTAB_HASH$, ORABCTAB_SIGNATURE$, ORABCTAB_SIGNATURE_ALG$, ORABCTAB_SIGNATURE_CERT$ ',
'from document_bct',
'order by ORABCTAB_CREATION_TIME$;'))
,p_plug_source_type=>'NATIVE_IR'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_prn_content_disposition=>'ATTACHMENT'
,p_prn_document_header=>'APEX'
,p_prn_units=>'MILLIMETERS'
,p_prn_paper_size=>'A4'
,p_prn_width=>297
,p_prn_height=>210
,p_prn_orientation=>'HORIZONTAL'
,p_prn_page_header=>unistr('\8010\6539\3056\3093\6027\3001\691C\8A3C\53EF\80FD\6027\62C5\4FDD\306E\305F\3081\306E\30C7\30FC\30BF\4E00\89A7')
,p_prn_page_header_font_color=>'#000000'
,p_prn_page_header_font_family=>'Helvetica'
,p_prn_page_header_font_weight=>'normal'
,p_prn_page_header_font_size=>'12'
,p_prn_page_footer_font_color=>'#000000'
,p_prn_page_footer_font_family=>'Helvetica'
,p_prn_page_footer_font_weight=>'normal'
,p_prn_page_footer_font_size=>'12'
,p_prn_header_bg_color=>'#EEEEEE'
,p_prn_header_font_color=>'#000000'
,p_prn_header_font_family=>'Helvetica'
,p_prn_header_font_weight=>'bold'
,p_prn_header_font_size=>'10'
,p_prn_body_bg_color=>'#FFFFFF'
,p_prn_body_font_color=>'#000000'
,p_prn_body_font_family=>'Helvetica'
,p_prn_body_font_weight=>'normal'
,p_prn_body_font_size=>'10'
,p_prn_border_width=>.5
,p_prn_page_header_alignment=>'CENTER'
,p_prn_page_footer_alignment=>'CENTER'
,p_prn_border_color=>'#666666'
);
wwv_flow_api.create_worksheet(
 p_id=>wwv_flow_api.id(30081337074935120)
,p_max_row_count=>'1000000'
,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:XLSX:PDF:RTF:EMAIL'
,p_owner=>'DOCUMENT_BCT'
,p_internal_uid=>30081337074935120
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30081483132935121)
,p_db_column_name=>'DOCUMENT_ID'
,p_display_order=>10
,p_column_identifier=>'A'
,p_column_label=>'Document Id'
,p_column_type=>'STRING'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30081565115935122)
,p_db_column_name=>'REVISION'
,p_display_order=>20
,p_column_identifier=>'B'
,p_column_label=>'Revision'
,p_column_type=>'NUMBER'
,p_column_alignment=>'RIGHT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30081646545935123)
,p_db_column_name=>'ORABCTAB_INST_ID$'
,p_display_order=>30
,p_column_identifier=>'C'
,p_column_label=>'Orabctab Inst Id$'
,p_column_type=>'NUMBER'
,p_column_alignment=>'RIGHT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30081711629935124)
,p_db_column_name=>'ORABCTAB_CHAIN_ID$'
,p_display_order=>40
,p_column_identifier=>'D'
,p_column_label=>'Orabctab Chain Id$'
,p_column_type=>'NUMBER'
,p_column_alignment=>'RIGHT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30081817186935125)
,p_db_column_name=>'ORABCTAB_SEQ_NUM$'
,p_display_order=>50
,p_column_identifier=>'E'
,p_column_label=>'Orabctab Seq Num$'
,p_column_type=>'NUMBER'
,p_column_alignment=>'RIGHT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30081959964935126)
,p_db_column_name=>'ORABCTAB_CREATION_TIME$'
,p_display_order=>60
,p_column_identifier=>'F'
,p_column_label=>'Orabctab Creation Time$'
,p_column_type=>'DATE'
,p_column_alignment=>'CENTER'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30082057426935127)
,p_db_column_name=>'ORABCTAB_USER_NUMBER$'
,p_display_order=>70
,p_column_identifier=>'G'
,p_column_label=>'Orabctab User Number$'
,p_column_type=>'NUMBER'
,p_column_alignment=>'RIGHT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30082188909935128)
,p_db_column_name=>'ORABCTAB_HASH$'
,p_display_order=>80
,p_column_identifier=>'H'
,p_column_label=>'Orabctab Hash$'
,p_column_type=>'STRING'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30082267574935129)
,p_db_column_name=>'ORABCTAB_SIGNATURE$'
,p_display_order=>90
,p_column_identifier=>'I'
,p_column_label=>'Orabctab Signature$'
,p_column_type=>'STRING'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30082349652935130)
,p_db_column_name=>'ORABCTAB_SIGNATURE_ALG$'
,p_display_order=>100
,p_column_identifier=>'J'
,p_column_label=>'Orabctab Signature Alg$'
,p_column_type=>'NUMBER'
,p_column_alignment=>'RIGHT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30082479205935131)
,p_db_column_name=>'ORABCTAB_SIGNATURE_CERT$'
,p_display_order=>110
,p_column_identifier=>'K'
,p_column_label=>'Orabctab Signature Cert$'
,p_column_type=>'STRING'
);
wwv_flow_api.create_worksheet_rpt(
 p_id=>wwv_flow_api.id(30250529659682080)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'302506'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'DOCUMENT_ID:REVISION:ORABCTAB_INST_ID$:ORABCTAB_CHAIN_ID$:ORABCTAB_SEQ_NUM$:ORABCTAB_CREATION_TIME$:ORABCTAB_USER_NUMBER$:ORABCTAB_HASH$:ORABCTAB_SIGNATURE$:ORABCTAB_SIGNATURE_ALG$:ORABCTAB_SIGNATURE_CERT$'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30513404790647309)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_08'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'<p>',
unistr('\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306B\306F\884C\3054\3068\306B\81EA\52D5\7684\306B\4ED8\4E0E\3055\308C\308B\30CF\30C3\30B7\30E5\5024\306E\30C1\30A7\30FC\30F3\3092\691C\8A3C\3059\308B\3053\3068\3067\3001\30C6\30FC\30D6\30EB\4E0A\306E\884C\306E\6574\5408\6027\3068\771F\6B63\6027\FF08\884C\306E\767B\9332\5F8C\3001\4E0D\6B63\306B\524A\9664\3084\6539\3056\3093\3092\3055\308C\3066\3044\306A\3044\3053\3068\FF09\3092\78BA\8A8D\3059\308B\6A5F\80FD\304C\3042\308A\307E\3059\3002<br>'),
unistr('\3053\306E\30DA\30FC\30B8\3067\306F\884C\306E\6574\5408\6027\78BA\8A8D\306E\5B9F\884C\3068\3001\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306E\8010\6539\3056\3093\6027\3001\691C\8A3C\53EF\80FD\6027\62C5\4FDD\306E\305F\3081\306E\30C7\30FC\30BF\306E\4E00\89A7\8868\793A\304C\3067\304D\307E\3059\3002'),
'</p>',
'<p>',
unistr('\884C\306E\6574\5408\6027\78BA\8A8D\306B\3064\3044\3066\FF1A<br>'),
unistr('\30FB\6574\5408\6027\78BA\8A8D\3092\884C\3044\305F\3044\671F\9593\3092\6307\5B9A\3057\3066\304F\3060\3055\3044<br>'),
unistr('\30FB\767B\9332\65E5\6642\FF08ORACBTAB_CREATION_TIME$\FF09\304C\6307\5B9A\3057\305F\671F\9593\306B\542B\307E\308C\308B\884C\3092\5BFE\8C61\306B\691C\8A3C\304C\884C\308F\308C\307E\3059'),
'</p>',
'<p>',
unistr('\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\306E\8010\6539\3056\3093\6027\3001\691C\8A3C\53EF\80FD\6027\62C5\4FDD\306E\305F\3081\306E\30C7\30FC\30BF\4E00\89A7\306B\3064\3044\3066<br>'),
unistr('\30FB\30C9\30AD\30E5\30E1\30F3\30C8ID\3001\30D0\30FC\30B8\30E7\30F3\306E\60C5\5831\3068\3001\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\304C\81EA\52D5\7684\306B\4ED8\4E0E\3059\308B\96A0\3057\30AB\30E9\30E0\306E\60C5\5831\304C\8868\793A\3055\308C\307E\3059<br>'),
'</p>'))
,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(87589394174138276)
,p_plug_name=>unistr('\884C\306E\6574\5408\6027\78BA\8A8D')
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19466940555221989)
,p_plug_display_sequence=>20
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_new_grid_row=>false
,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(87591397504138296)
,p_plug_name=>unistr('\30D6\30EC\30C3\30C9\30AF\30E9\30E0')
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19476376565222003)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_api.id(19411976577221895)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_api.id(19530842457222109)
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(30160775795906812)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(87589394174138276)
,p_button_name=>unistr('\671F\9593\6307\5B9A\3092\30EA\30BB\30C3\30C8')
,p_button_action=>'DEFINED_BY_DA'
,p_button_template_options=>'#DEFAULT#:t-Button--iconRight'
,p_button_template_id=>wwv_flow_api.id(19529517854222107)
,p_button_image_alt=>unistr('\671F\9593\6307\5B9A\3092\30EA\30BB\30C3\30C8')
,p_button_position=>'REGION_TEMPLATE_COPY'
,p_warn_on_unsaved_changes=>null
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(30161186568906813)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(87589394174138276)
,p_button_name=>unistr('\691C\8A3C')
,p_button_action=>'DEFINED_BY_DA'
,p_button_template_options=>'#DEFAULT#:t-Button--iconRight'
,p_button_template_id=>wwv_flow_api.id(19529517854222107)
,p_button_is_hot=>'Y'
,p_button_image_alt=>unistr('\691C\8A3C')
,p_button_position=>'REGION_TEMPLATE_EDIT'
,p_warn_on_unsaved_changes=>null
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30082743603935134)
,p_name=>'P10_VERIFY_RESULT'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(87589394174138276)
,p_item_default=>unistr('\671F\9593\3092\6307\5B9A\3057\3001\691C\8A3C\3092\5B9F\884C\3057\3066\304F\3060\3055\3044\3002')
,p_prompt=>unistr('\691C\8A3C\7D50\679C\306E\8868\793A')
,p_display_as=>'NATIVE_DISPLAY_ONLY'
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'VALUE'
,p_attribute_04=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30161516195906819)
,p_name=>'P10_STARTDATE'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(87589394174138276)
,p_prompt=>unistr('\958B\59CB')
,p_display_as=>'NATIVE_DATE_PICKER'
,p_cSize=>30
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_04=>'button'
,p_attribute_05=>'N'
,p_attribute_07=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30161958679906823)
,p_name=>'P10_ENDDATE'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(87589394174138276)
,p_prompt=>unistr('\7D42\4E86')
,p_display_as=>'NATIVE_DATE_PICKER'
,p_cSize=>30
,p_begin_on_new_line=>'N'
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_04=>'button'
,p_attribute_05=>'N'
,p_attribute_07=>'NONE'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(30166533709906841)
,p_name=>unistr('\5024\306E\30AF\30EA\30A2')
,p_event_sequence=>10
,p_triggering_element_type=>'BUTTON'
,p_triggering_button_id=>wwv_flow_api.id(30160775795906812)
,p_bind_type=>'bind'
,p_bind_event_type=>'click'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(30167022533906844)
,p_event_id=>wwv_flow_api.id(30166533709906841)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'Y'
,p_action=>'NATIVE_CLEAR'
,p_affected_elements_type=>'ITEM'
,p_affected_elements=>'P10_STARTDATE,P10_ENDDATE'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(30082576807935132)
,p_name=>unistr('\691C\8A3C\306E\5B9F\884C')
,p_event_sequence=>20
,p_triggering_element_type=>'BUTTON'
,p_triggering_button_id=>wwv_flow_api.id(30161186568906813)
,p_bind_type=>'bind'
,p_bind_event_type=>'click'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(30082687217935133)
,p_event_id=>wwv_flow_api.id(30082576807935132)
,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=>'P10_VERIFY_RESULT'
,p_attribute_01=>'FUNCTION_BODY'
,p_attribute_06=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'    verify_rows NUMBER;',
'    current_schema VARCHAR2(256);',
'    return_string VARCHAR2(256);',
'BEGIN',
'SELECT SYS_CONTEXT(''USERENV'',''CURRENT_SCHEMA'') INTO current_schema FROM DUAL;',
'DBMS_BLOCKCHAIN_TABLE.VERIFY_ROWS(current_schema,''document_bct'', :P10_STARTDATE, :P10_ENDDATE, NULL, NULL, verify_rows);',
'',
unistr('return_string := verify_rows || ''\4EF6\306E\884C\306E\691C\8A3C\304C\5B8C\4E86\3057\3001\6574\5408\6027\306B\554F\984C\306A\3044\3053\3068\304C\78BA\8A8D\3067\304D\307E\3057\305F\3002'';'),
'',
'return return_string;',
'END;',
''))
,p_attribute_07=>'P10_STARTDATE,P10_ENDDATE'
,p_attribute_08=>'Y'
,p_attribute_09=>'N'
,p_wait_for_result=>'Y'
);
end;
/
prompt --application/pages/page_00011
begin
wwv_flow_api.create_page(
 p_id=>11
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\4E0D\5909\6027\306E\78BA\8A8D\FF1A\4E00\89A7')
,p_alias=>unistr('\4E0D\5909\6027\306E\78BA\8A8D-\4E00\89A7')
,p_step_title=>unistr('\4E0D\5909\6027\306E\78BA\8A8D\FF1A\4E00\89A7')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210813030040'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30515724464647332)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_08'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
unistr('\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\4E0A\306B\4FDD\5B58\3055\308C\305F\30C7\30FC\30BF\FF08\884C\FF09\306F\767B\9332\FF08INSERT)\5F8C\3001\66F4\65B0\FF08UPDATE\FF09\3084\524A\9664\FF08DELETE\FF09\304C\884C\3048\307E\305B\3093\3002<br>'),
unistr('\3053\306E\30DA\30FC\30B8\3067\306F\3001\66F4\65B0\3001\524A\9664\306E\64CD\4F5C\3059\308B\3068\30A8\30E9\30FC\304C\767A\751F\3057\3001\5B9F\884C\3067\304D\306A\3044\3053\3068\3092\78BA\8A8D\3067\304D\307E\3059\3002<br>'),
unistr('\3044\305A\308C\304B\306E\6587\66F8\306B\3064\3044\3066\3001\4E00\89A7\306E\5DE6\7AEF\306E\7DE8\96C6\30A2\30A4\30B3\30F3\3092\30AF\30EA\30C3\30AF\3057\3066\66F4\65B0\30FB\524A\9664\753B\9762\3092\958B\3044\3066\304F\3060\3055\3044\3002')))
,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(30741914504120109)
,p_plug_name=>unistr('\30EC\30DD\30FC\30C81')
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19465095800221986)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select "DOCUMENT_ID",',
'       "REVISION",',
'       "DOCUMENT_TITLE",',
'       "REGISTERER_NAME",',
'       "PUBLISH_DATE",',
'       "UPDATE_TYPE",',
'       sys.dbms_lob.getlength("DOCUMENT")"DOCUMENT",',
'       "DOCUMENT_FILENAME",',
'       ORABCTAB_CREATION_TIME$,',
'       ORABCTAB_HASH$',
'       from "DOCUMENT_BCT"'))
,p_plug_source_type=>'NATIVE_IR'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_prn_page_header=>unistr('\30EC\30DD\30FC\30C81')
);
wwv_flow_api.create_worksheet(
 p_id=>wwv_flow_api.id(30742396695120110)
,p_name=>unistr('\30EC\30DD\30FC\30C81')
,p_max_row_count_message=>unistr('\3053\306E\30EC\30DD\30FC\30C8\306E\6700\5927\884C\6570\306F#MAX_ROW_COUNT#\884C\3067\3059\3002\30D5\30A3\30EB\30BF\3092\9069\7528\3057\3066\3001\554F\5408\305B\306E\30EC\30B3\30FC\30C9\6570\3092\524A\6E1B\3057\3066\304F\3060\3055\3044\3002')
,p_no_data_found_message=>unistr('\30C7\30FC\30BF\304C\898B\3064\304B\308A\307E\305B\3093\3002')
,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:XLSX:PDF:RTF'
,p_detail_link=>'f?p=&APP_ID.:12:&SESSION.::&DEBUG.:RP:P12_DOCUMENT_ID,P12_REVISION:\#DOCUMENT_ID#\,\#REVISION#\'
,p_detail_link_text=>'<span aria-label="&#x7DE8;&#x96C6;"><span class="fa fa-edit" aria-hidden="true" title="&#x7DE8;&#x96C6;"></span></span>'
,p_owner=>'DOCUMENT_BCT'
,p_internal_uid=>30742396695120110
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30742472686120112)
,p_db_column_name=>'DOCUMENT_ID'
,p_display_order=>1
,p_column_identifier=>'A'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8ID')
,p_column_type=>'STRING'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30742803670120113)
,p_db_column_name=>'REVISION'
,p_display_order=>2
,p_column_identifier=>'B'
,p_column_label=>unistr('\30D0\30FC\30B8\30E7\30F3')
,p_column_type=>'NUMBER'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30743251844120114)
,p_db_column_name=>'DOCUMENT_TITLE'
,p_display_order=>3
,p_column_identifier=>'C'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8\540D')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30743628297120115)
,p_db_column_name=>'REGISTERER_NAME'
,p_display_order=>4
,p_column_identifier=>'D'
,p_column_label=>unistr('\767B\9332\8005\540D')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30744053211120115)
,p_db_column_name=>'PUBLISH_DATE'
,p_display_order=>5
,p_column_identifier=>'E'
,p_column_label=>unistr('\767A\884C\65E5')
,p_column_type=>'DATE'
,p_column_alignment=>'CENTER'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30744405753120116)
,p_db_column_name=>'UPDATE_TYPE'
,p_display_order=>6
,p_column_identifier=>'F'
,p_column_label=>unistr('\66F4\65B0\7A2E\5225')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30744819195120117)
,p_db_column_name=>'DOCUMENT'
,p_display_order=>7
,p_column_identifier=>'G'
,p_column_label=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8')
,p_allow_sorting=>'N'
,p_allow_filtering=>'N'
,p_allow_highlighting=>'N'
,p_allow_ctrl_breaks=>'N'
,p_allow_aggregations=>'N'
,p_allow_computations=>'N'
,p_allow_charting=>'N'
,p_allow_group_by=>'N'
,p_allow_pivot=>'N'
,p_column_type=>'NUMBER'
,p_heading_alignment=>'LEFT'
,p_format_mask=>'DOWNLOAD:DOCUMENT_BCT:DOCUMENT:REVISION::::::attachment:#DOCUMENT_FILENAME#:'
,p_rpt_show_filter_lov=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30745229042120117)
,p_db_column_name=>'DOCUMENT_FILENAME'
,p_display_order=>8
,p_column_identifier=>'H'
,p_column_label=>'Document Filename'
,p_column_type=>'STRING'
,p_display_text_as=>'HIDDEN'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30515537024647330)
,p_db_column_name=>'ORABCTAB_CREATION_TIME$'
,p_display_order=>18
,p_column_identifier=>'L'
,p_column_label=>'Orabctab Creation Time$'
,p_column_type=>'DATE'
,p_column_alignment=>'CENTER'
,p_tz_dependent=>'N'
);
wwv_flow_api.create_worksheet_column(
 p_id=>wwv_flow_api.id(30515664741647331)
,p_db_column_name=>'ORABCTAB_HASH$'
,p_display_order=>28
,p_column_identifier=>'M'
,p_column_label=>'Orabctab Hash$'
,p_column_type=>'STRING'
);
wwv_flow_api.create_worksheet_rpt(
 p_id=>wwv_flow_api.id(30750163376122437)
,p_application_user=>'APXWS_DEFAULT'
,p_report_seq=>10
,p_report_alias=>'307502'
,p_status=>'PUBLIC'
,p_is_default=>'Y'
,p_report_columns=>'DOCUMENT_ID:REVISION:DOCUMENT_TITLE:REGISTERER_NAME:PUBLISH_DATE:UPDATE_TYPE:DOCUMENT:DOCUMENT_FILENAME:ORABCTAB_CREATION_TIME$:ORABCTAB_HASH$'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30748640397120134)
,p_plug_name=>unistr('\30D6\30EC\30C3\30C9\30AF\30E9\30E0')
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19476376565222003)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_api.id(19411976577221895)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_api.id(19530842457222109)
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(30747569727120123)
,p_name=>unistr('\30EC\30DD\30FC\30C8\306E\7DE8\96C6 - \30C0\30A4\30A2\30ED\30B0\306E\30AF\30ED\30FC\30BA')
,p_event_sequence=>10
,p_triggering_element_type=>'REGION'
,p_triggering_region_id=>wwv_flow_api.id(30741914504120109)
,p_bind_type=>'bind'
,p_bind_event_type=>'apexafterclosedialog'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(30748036946120125)
,p_event_id=>wwv_flow_api.id(30747569727120123)
,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(30741914504120109)
);
end;
/
prompt --application/pages/page_00012
begin
wwv_flow_api.create_page(
 p_id=>12
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\4E0D\5909\6027\306E\78BA\8A8D\FF1A\66F4\65B0\30FB\524A\9664')
,p_alias=>unistr('\4E0D\5909\6027\306E\78BA\8A8D-\66F4\65B0-\524A\9664')
,p_page_mode=>'MODAL'
,p_step_title=>unistr('\4E0D\5909\6027\306E\78BA\8A8D\FF1A\66F4\65B0\30FB\524A\9664')
,p_autocomplete_on_off=>'OFF'
,p_javascript_code=>'var htmldb_delete_message=''"DELETE_CONFIRM_MSG"'';'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210805091522'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30515811455647333)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_01'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
unistr('\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\4E0A\306B\4FDD\5B58\3055\308C\305F\30C7\30FC\30BF\FF08\884C\FF09\306F\767B\9332\FF08INSERT)\5F8C\3001\66F4\65B0\FF08UPDATE\FF09\3084\524A\9664\FF08DELETE\FF09\304C\884C\3048\307E\305B\3093\3002<br>'),
unistr('\3053\306E\30DA\30FC\30B8\3067\306F\3001\66F4\65B0\3001\524A\9664\306E\64CD\4F5C\3059\308B\3068\30A8\30E9\30FC\304C\767A\751F\3057\3001\5B9F\884C\3067\304D\306A\3044\3053\3068\3092\78BA\8A8D\3067\304D\307E\3059\3002<br>'),
unistr('\30FB\5185\5BB9\3092\7DE8\96C6\3057\3001\5909\66F4\306E\9069\7528\3092\8A66\3057\3066\307F\307E\3057\3087\3046<br>'),
unistr('\30FB\524A\9664\3092\8A66\3057\3066\307F\307E\3057\3087\3046<br>')))
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30729356640120038)
,p_plug_name=>unistr('\4E0D\5909\6027\306E\78BA\8A8D\FF1A\4FEE\6B63\30FB\524A\9664')
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19438548418221945)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'DOCUMENT_BCT'
,p_include_rowid_column=>false
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_plug_source_type=>'NATIVE_FORM'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30737350386120075)
,p_plug_name=>unistr('\30DC\30BF\30F3')
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19439599017221946)
,p_plug_display_sequence=>20
,p_plug_display_point=>'REGION_POSITION_03'
,p_attribute_01=>'N'
,p_attribute_02=>'TEXT'
,p_attribute_03=>'Y'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(30737701208120075)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_api.id(30737350386120075)
,p_button_name=>'CANCEL'
,p_button_action=>'DEFINED_BY_DA'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(19529478185222106)
,p_button_image_alt=>unistr('\53D6\6D88')
,p_button_position=>'REGION_TEMPLATE_CLOSE'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(30739341092120092)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_api.id(30737350386120075)
,p_button_name=>'DELETE'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(19529478185222106)
,p_button_is_hot=>'Y'
,p_button_image_alt=>unistr('\524A\9664')
,p_button_position=>'REGION_TEMPLATE_DELETE'
,p_button_redirect_url=>'javascript:apex.confirm(htmldb_delete_message,''DELETE'');'
,p_button_execute_validations=>'N'
,p_button_condition=>'P12_DOCUMENT_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'DELETE'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(30739713823120093)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_api.id(30737350386120075)
,p_button_name=>'SAVE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(19529478185222106)
,p_button_is_hot=>'Y'
,p_button_image_alt=>unistr('\5909\66F4\306E\9069\7528')
,p_button_position=>'REGION_TEMPLATE_NEXT'
,p_button_condition=>'P12_DOCUMENT_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'UPDATE'
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(30740131737120094)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_api.id(30737350386120075)
,p_button_name=>'CREATE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(19529478185222106)
,p_button_is_hot=>'Y'
,p_button_image_alt=>unistr('\4F5C\6210')
,p_button_position=>'REGION_TEMPLATE_NEXT'
,p_button_condition=>'P12_DOCUMENT_ID'
,p_button_condition_type=>'ITEM_IS_NULL'
,p_database_action=>'INSERT'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30729626370120039)
,p_name=>'P12_DOCUMENT_ID'
,p_source_data_type=>'VARCHAR2'
,p_is_primary_key=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(30729356640120038)
,p_item_source_plug_id=>wwv_flow_api.id(30729356640120038)
,p_prompt=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8ID')
,p_source=>'DOCUMENT_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DISPLAY_ONLY'
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,p_attribute_01=>'Y'
,p_attribute_02=>'VALUE'
,p_attribute_04=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30730027561120045)
,p_name=>'P12_REVISION'
,p_source_data_type=>'NUMBER'
,p_is_primary_key=>true
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(30729356640120038)
,p_item_source_plug_id=>wwv_flow_api.id(30729356640120038)
,p_prompt=>unistr('\30D0\30FC\30B8\30E7\30F3')
,p_source=>'REVISION'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DISPLAY_ONLY'
,p_field_template=>wwv_flow_api.id(19528393985222101)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,p_attribute_01=>'Y'
,p_attribute_02=>'VALUE'
,p_attribute_04=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30730425167120048)
,p_name=>'P12_DOCUMENT_TITLE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(30729356640120038)
,p_item_source_plug_id=>wwv_flow_api.id(30729356640120038)
,p_prompt=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8\540D')
,p_source=>'DOCUMENT_TITLE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>60
,p_cMaxlength=>256
,p_field_template=>wwv_flow_api.id(19528638039222103)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30730802095120059)
,p_name=>'P12_REGISTERER_NAME'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_api.id(30729356640120038)
,p_item_source_plug_id=>wwv_flow_api.id(30729356640120038)
,p_prompt=>unistr('\767B\9332\8005\540D')
,p_source=>'REGISTERER_NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>60
,p_cMaxlength=>128
,p_field_template=>wwv_flow_api.id(19528638039222103)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30731211845120060)
,p_name=>'P12_PUBLISH_DATE'
,p_source_data_type=>'DATE'
,p_is_required=>true
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_api.id(30729356640120038)
,p_item_source_plug_id=>wwv_flow_api.id(30729356640120038)
,p_prompt=>unistr('\767A\884C\65E5')
,p_source=>'PUBLISH_DATE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DATE_PICKER'
,p_cSize=>32
,p_cMaxlength=>255
,p_field_template=>wwv_flow_api.id(19528638039222103)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_04=>'button'
,p_attribute_05=>'N'
,p_attribute_07=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(30731627745120061)
,p_name=>'P12_UPDATE_TYPE'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>60
,p_item_plug_id=>wwv_flow_api.id(30729356640120038)
,p_item_source_plug_id=>wwv_flow_api.id(30729356640120038)
,p_prompt=>unistr('\66F4\65B0\7A2E\5225')
,p_source=>'UPDATE_TYPE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'UPDATE_TYPE_LIST'
,p_lov_display_null=>'YES'
,p_cHeight=>1
,p_field_template=>wwv_flow_api.id(19528638039222103)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,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(30732065371120061)
,p_name=>'P12_DOCUMENT'
,p_source_data_type=>'BLOB'
,p_is_required=>true
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_api.id(30729356640120038)
,p_item_source_plug_id=>wwv_flow_api.id(30729356640120038)
,p_prompt=>unistr('\30C9\30AD\30E5\30E1\30F3\30C8')
,p_source=>'DOCUMENT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>60
,p_cMaxlength=>255
,p_field_template=>wwv_flow_api.id(19528638039222103)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_02=>'DOCUMENT_MIMETYPE'
,p_attribute_03=>'DOCUMENT_FILENAME'
,p_attribute_04=>'DOCUMENT_CHARSET'
,p_attribute_05=>'DOCUMENT_REGISTER_DATE'
,p_attribute_06=>'N'
,p_attribute_12=>'DROPZONE_INLINE'
);
wwv_flow_api.create_page_da_event(
 p_id=>wwv_flow_api.id(30737868197120075)
,p_name=>'Cancel Dialog'
,p_event_sequence=>10
,p_triggering_element_type=>'BUTTON'
,p_triggering_button_id=>wwv_flow_api.id(30737701208120075)
,p_bind_type=>'bind'
,p_bind_event_type=>'click'
);
wwv_flow_api.create_page_da_action(
 p_id=>wwv_flow_api.id(30738683878120084)
,p_event_id=>wwv_flow_api.id(30737868197120075)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_DIALOG_CANCEL'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(30740953055120106)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(30729356640120038)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>unistr('\30D7\30ED\30BB\30B9\30FB\30D5\30A9\30FC\30E0\4E0D\5909\6027\306E\78BA\8A8D\FF1A\4FEE\6B63\30FB\524A\9664')
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(30741377207120106)
,p_process_sequence=>50
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_CLOSE_WINDOW'
,p_process_name=>unistr('\30C0\30A4\30A2\30ED\30B0\3092\9589\3058\308B')
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when=>'CREATE,SAVE,DELETE'
,p_process_when_type=>'REQUEST_IN_CONDITION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(30740519060120095)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_api.id(30729356640120038)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>unistr('\521D\671F\5316\30D5\30A9\30FC\30E0\4E0D\5909\6027\306E\78BA\8A8D\FF1A\4FEE\6B63\30FB\524A\9664')
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
end;
/
prompt --application/pages/page_00091
begin
wwv_flow_api.create_page(
 p_id=>91
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\66F4\65B0\7A2E\5225\30DE\30B9\30BF\7BA1\7406')
,p_alias=>unistr('\66F4\65B0\7A2E\5225\30DE\30B9\30BF\7BA1\74061')
,p_step_title=>unistr('\66F4\65B0\7A2E\5225\30DE\30B9\30BF\7BA1\7406')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210804153009'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30513687468647311)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_08'
,p_plug_source=>unistr('\66F4\65B0\7A2E\5225\306E\9078\629E\30EA\30B9\30C8\FF08\30C9\30ED\30C3\30D7\30C0\30A6\30F3\30EA\30B9\30C8\FF09\306E\5019\88DC\5024\3092\7BA1\7406\3059\308B\753B\9762\3067\3059\3002\9078\629E\30EA\30B9\30C8\306E\4E2D\3067\306E\5019\88DC\5024\306E\9806\5E8F\306F\3001\66F4\65B0\7A2E\5225\306E\6587\5B57\5217\306E\6607\9806\306B\306A\308A\307E\3059\3002')
,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(30564919367049588)
,p_plug_name=>unistr('\30D6\30EC\30C3\30C9\30AF\30E9\30E0')
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19476376565222003)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_api.id(19411976577221895)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_api.id(19530842457222109)
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30565581325049594)
,p_plug_name=>unistr('\66F4\65B0\7A2E\5225\30DE\30B9\30BF\7BA1\7406')
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19465095800221986)
,p_plug_display_sequence=>20
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'UPDATE_TYPE_MASTER'
,p_query_order_by=>'update_type'
,p_include_rowid_column=>true
,p_plug_source_type=>'NATIVE_IG'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_prn_page_header=>unistr('\66F4\65B0\7A2E\5225\30DE\30B9\30BF\7BA1\7406')
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30566866298049603)
,p_name=>'APEX$ROW_SELECTOR'
,p_item_type=>'NATIVE_ROW_SELECTOR'
,p_display_sequence=>10
,p_attribute_01=>'Y'
,p_attribute_02=>'Y'
,p_attribute_03=>'N'
,p_enable_hide=>true
,p_is_primary_key=>false
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30567345763049604)
,p_name=>'APEX$ROW_ACTION'
,p_item_type=>'NATIVE_ROW_ACTION'
,p_label=>unistr('\30A2\30AF\30B7\30E7\30F3')
,p_heading_alignment=>'CENTER'
,p_display_sequence=>20
,p_value_alignment=>'CENTER'
,p_enable_hide=>true
,p_is_primary_key=>false
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30568388446049609)
,p_name=>'ROWID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'ROWID'
,p_data_type=>'ROWID'
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>30
,p_attribute_01=>'Y'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_control_break=>false
,p_enable_hide=>true
,p_enable_pivot=>false
,p_is_primary_key=>true
,p_include_in_export=>false
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30569367625049613)
,p_name=>'UPDATE_TYPE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'UPDATE_TYPE'
,p_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>unistr('\66F4\65B0\7A2E\5225')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>40
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>true
,p_max_length=>128
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>true
,p_enable_pivot=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30570324441049615)
,p_name=>'DESCRIPTION'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'DESCRIPTION'
,p_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>unistr('\8AAC\660E')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>50
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>false
,p_max_length=>512
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>true
,p_enable_pivot=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_api.create_interactive_grid(
 p_id=>wwv_flow_api.id(30566036503049597)
,p_internal_uid=>30566036503049597
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_add_row_if_empty=>true
,p_submit_checked_rows=>false
,p_lazy_loading=>false
,p_requires_filter=>false
,p_select_first_row=>true
,p_fixed_row_height=>true
,p_pagination_type=>'SCROLL'
,p_show_total_row_count=>true
,p_show_toolbar=>true
,p_enable_save_public_report=>false
,p_enable_subscriptions=>true
,p_enable_flashback=>true
,p_define_chart_view=>true
,p_enable_download=>true
,p_enable_mail_download=>true
,p_fixed_header=>'PAGE'
,p_show_icon_view=>false
,p_show_detail_view=>false
);
wwv_flow_api.create_ig_report(
 p_id=>wwv_flow_api.id(30566472469049598)
,p_interactive_grid_id=>wwv_flow_api.id(30566036503049597)
,p_static_id=>'305665'
,p_type=>'PRIMARY'
,p_default_view=>'GRID'
,p_show_row_number=>false
,p_settings_area_expanded=>true
);
wwv_flow_api.create_ig_report_view(
 p_id=>wwv_flow_api.id(30566680042049599)
,p_report_id=>wwv_flow_api.id(30566472469049598)
,p_view_type=>'GRID'
,p_srv_exclude_null_values=>false
,p_srv_only_display_columns=>true
,p_edit_mode=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30567785360049607)
,p_view_id=>wwv_flow_api.id(30566680042049599)
,p_display_seq=>0
,p_column_id=>wwv_flow_api.id(30567345763049604)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30568764083049609)
,p_view_id=>wwv_flow_api.id(30566680042049599)
,p_display_seq=>1
,p_column_id=>wwv_flow_api.id(30568388446049609)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30569793413049615)
,p_view_id=>wwv_flow_api.id(30566680042049599)
,p_display_seq=>2
,p_column_id=>wwv_flow_api.id(30569367625049613)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30570788191049616)
,p_view_id=>wwv_flow_api.id(30566680042049599)
,p_display_seq=>3
,p_column_id=>wwv_flow_api.id(30570324441049615)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(30571385205049617)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(30565581325049594)
,p_process_type=>'NATIVE_IG_DML'
,p_process_name=>unistr('\66F4\65B0\7A2E\5225\30DE\30B9\30BF\7BA1\7406 - \5BFE\8A71\30B0\30EA\30C3\30C9\30FB\30C7\30FC\30BF\306E\4FDD\5B58')
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
end;
/
prompt --application/pages/page_00092
begin
wwv_flow_api.create_page(
 p_id=>92
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\30AB\30C6\30B4\30EA\30FC\30DE\30B9\30BF\7BA1\7406')
,p_alias=>unistr('\30AB\30C6\30B4\30EA\30FC\30DE\30B9\30BF\7BA1\7406')
,p_step_title=>unistr('\30AB\30C6\30B4\30EA\30FC\30DE\30B9\30BF\7BA1\7406')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210804152818'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30513598776647310)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_08'
,p_plug_source=>unistr('\30AB\30C6\30B4\30EA\30FC\306E\9078\629E\30EA\30B9\30C8\FF08\30C9\30ED\30C3\30D7\30C0\30A6\30F3\30EA\30B9\30C8\FF09\306E\5019\88DC\5024\3092\7BA1\7406\3059\308B\753B\9762\3067\3059\3002\9078\629E\30EA\30B9\30C8\306E\4E2D\3067\306E\5019\88DC\5024\306E\9806\5E8F\306F\3001\30AB\30C6\30B4\30EA\30FC\306E\6587\5B57\5217\306E\6607\9806\306B\306A\308A\307E\3059\3002')
,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(30578925519092498)
,p_plug_name=>unistr('\30D6\30EC\30C3\30C9\30AF\30E9\30E0')
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19476376565222003)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_api.id(19411976577221895)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_api.id(19530842457222109)
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30579509561092499)
,p_plug_name=>unistr('\30AB\30C6\30B4\30EA\30FC\30DE\30B9\30BF\7BA1\7406')
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19465095800221986)
,p_plug_display_sequence=>20
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'CATEGORY_MASTER'
,p_query_order_by=>'category'
,p_include_rowid_column=>true
,p_plug_source_type=>'NATIVE_IG'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_prn_page_header=>unistr('\30AB\30C6\30B4\30EA\30FC\30DE\30B9\30BF\7BA1\7406')
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30580891883092501)
,p_name=>'APEX$ROW_SELECTOR'
,p_item_type=>'NATIVE_ROW_SELECTOR'
,p_display_sequence=>10
,p_attribute_01=>'Y'
,p_attribute_02=>'Y'
,p_attribute_03=>'N'
,p_enable_hide=>true
,p_is_primary_key=>false
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30581361440092501)
,p_name=>'APEX$ROW_ACTION'
,p_item_type=>'NATIVE_ROW_ACTION'
,p_label=>unistr('\30A2\30AF\30B7\30E7\30F3')
,p_heading_alignment=>'CENTER'
,p_display_sequence=>20
,p_value_alignment=>'CENTER'
,p_enable_hide=>true
,p_is_primary_key=>false
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30582391916092503)
,p_name=>'ROWID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'ROWID'
,p_data_type=>'ROWID'
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>30
,p_attribute_01=>'Y'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_control_break=>false
,p_enable_hide=>true
,p_enable_pivot=>false
,p_is_primary_key=>true
,p_include_in_export=>false
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30583314895092506)
,p_name=>'CATEGORY'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'CATEGORY'
,p_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>unistr('\30AB\30C6\30B4\30EA\30FC')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>40
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>true
,p_max_length=>128
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>true
,p_enable_pivot=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30584387869092507)
,p_name=>'DESCRIPTION'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'DESCRIPTION'
,p_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>unistr('\8AAC\660E')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>50
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>false
,p_max_length=>512
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>true
,p_enable_pivot=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_api.create_interactive_grid(
 p_id=>wwv_flow_api.id(30580081241092499)
,p_internal_uid=>30580081241092499
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_add_row_if_empty=>true
,p_submit_checked_rows=>false
,p_lazy_loading=>false
,p_requires_filter=>false
,p_select_first_row=>true
,p_fixed_row_height=>true
,p_pagination_type=>'SCROLL'
,p_show_total_row_count=>true
,p_show_toolbar=>true
,p_enable_save_public_report=>false
,p_enable_subscriptions=>true
,p_enable_flashback=>true
,p_define_chart_view=>true
,p_enable_download=>true
,p_enable_mail_download=>true
,p_fixed_header=>'PAGE'
,p_show_icon_view=>false
,p_show_detail_view=>false
);
wwv_flow_api.create_ig_report(
 p_id=>wwv_flow_api.id(30580433217092500)
,p_interactive_grid_id=>wwv_flow_api.id(30580081241092499)
,p_static_id=>'305805'
,p_type=>'PRIMARY'
,p_default_view=>'GRID'
,p_show_row_number=>false
,p_settings_area_expanded=>true
);
wwv_flow_api.create_ig_report_view(
 p_id=>wwv_flow_api.id(30580620679092500)
,p_report_id=>wwv_flow_api.id(30580433217092500)
,p_view_type=>'GRID'
,p_srv_exclude_null_values=>false
,p_srv_only_display_columns=>true
,p_edit_mode=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30581771434092502)
,p_view_id=>wwv_flow_api.id(30580620679092500)
,p_display_seq=>0
,p_column_id=>wwv_flow_api.id(30581361440092501)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30582721646092503)
,p_view_id=>wwv_flow_api.id(30580620679092500)
,p_display_seq=>1
,p_column_id=>wwv_flow_api.id(30582391916092503)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30583716529092506)
,p_view_id=>wwv_flow_api.id(30580620679092500)
,p_display_seq=>2
,p_column_id=>wwv_flow_api.id(30583314895092506)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30584752845092508)
,p_view_id=>wwv_flow_api.id(30580620679092500)
,p_display_seq=>3
,p_column_id=>wwv_flow_api.id(30584387869092507)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(30585380652092509)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(30579509561092499)
,p_process_type=>'NATIVE_IG_DML'
,p_process_name=>unistr('\30AB\30C6\30B4\30EA\30FC\30DE\30B9\30BF\7BA1\7406 - \5BFE\8A71\30B0\30EA\30C3\30C9\30FB\30C7\30FC\30BF\306E\4FDD\5B58')
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
end;
/
prompt --application/pages/page_00093
begin
wwv_flow_api.create_page(
 p_id=>93
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\30B9\30C6\30FC\30BF\30B9\30DE\30B9\30BF\7BA1\7406')
,p_alias=>unistr('\30B9\30C6\30FC\30BF\30B9\30DE\30B9\30BF\7BA1\7406')
,p_step_title=>unistr('\30B9\30C6\30FC\30BF\30B9\30DE\30B9\30BF\7BA1\7406')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210804152754'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30513713445647312)
,p_plug_name=>unistr('\30DA\30FC\30B8\306E\8AAC\660E')
,p_region_template_options=>'#DEFAULT#:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_api.id(19449984931221963)
,p_plug_display_sequence=>10
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_display_point=>'REGION_POSITION_08'
,p_plug_source=>unistr('\30B9\30C6\30FC\30BF\30B9\306E\9078\629E\30EA\30B9\30C8\FF08\30C9\30ED\30C3\30D7\30C0\30A6\30F3\30EA\30B9\30C8\FF09\306E\5019\88DC\5024\3092\7BA1\7406\3059\308B\753B\9762\3067\3059\3002\9078\629E\30EA\30B9\30C8\306E\4E2D\3067\306E\5019\88DC\5024\306E\9806\5E8F\306F\3001\30B9\30C6\30FC\30BF\30B9\306E\6587\5B57\5217\306E\6607\9806\306B\306A\308A\307E\3059\3002')
,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(30587771720106172)
,p_plug_name=>unistr('\30D6\30EC\30C3\30C9\30AF\30E9\30E0')
,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19476376565222003)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_menu_id=>wwv_flow_api.id(19411976577221895)
,p_plug_source_type=>'NATIVE_BREADCRUMB'
,p_menu_template_id=>wwv_flow_api.id(19530842457222109)
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(30588311656106174)
,p_plug_name=>unistr('\30B9\30C6\30FC\30BF\30B9\30DE\30B9\30BF\7BA1\7406')
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19465095800221986)
,p_plug_display_sequence=>20
,p_plug_display_point=>'BODY'
,p_query_type=>'TABLE'
,p_query_table=>'STATUS_MASTER'
,p_query_order_by=>'status'
,p_include_rowid_column=>true
,p_plug_source_type=>'NATIVE_IG'
,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
,p_prn_page_header=>unistr('\30B9\30C6\30FC\30BF\30B9\30DE\30B9\30BF\7BA1\7406')
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30589626435106177)
,p_name=>'APEX$ROW_SELECTOR'
,p_item_type=>'NATIVE_ROW_SELECTOR'
,p_display_sequence=>10
,p_attribute_01=>'Y'
,p_attribute_02=>'Y'
,p_attribute_03=>'N'
,p_enable_hide=>true
,p_is_primary_key=>false
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30590104043106178)
,p_name=>'APEX$ROW_ACTION'
,p_item_type=>'NATIVE_ROW_ACTION'
,p_label=>unistr('\30A2\30AF\30B7\30E7\30F3')
,p_heading_alignment=>'CENTER'
,p_display_sequence=>20
,p_value_alignment=>'CENTER'
,p_enable_hide=>true
,p_is_primary_key=>false
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30591135326106179)
,p_name=>'ROWID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'ROWID'
,p_data_type=>'ROWID'
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>30
,p_attribute_01=>'Y'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_control_break=>false
,p_enable_hide=>true
,p_enable_pivot=>false
,p_is_primary_key=>true
,p_include_in_export=>false
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30592184208106182)
,p_name=>'STATUS'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'STATUS'
,p_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>unistr('\30B9\30C6\30FC\30BF\30B9')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>40
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>true
,p_max_length=>128
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>true
,p_enable_pivot=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_api.create_region_column(
 p_id=>wwv_flow_api.id(30593157123106184)
,p_name=>'DESCRIPTION'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'DESCRIPTION'
,p_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>unistr('\8AAC\660E')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>50
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>false
,p_max_length=>512
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>true
,p_enable_pivot=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_api.create_interactive_grid(
 p_id=>wwv_flow_api.id(30588882834106175)
,p_internal_uid=>30588882834106175
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_add_row_if_empty=>true
,p_submit_checked_rows=>false
,p_lazy_loading=>false
,p_requires_filter=>false
,p_select_first_row=>true
,p_fixed_row_height=>true
,p_pagination_type=>'SCROLL'
,p_show_total_row_count=>true
,p_show_toolbar=>true
,p_enable_save_public_report=>false
,p_enable_subscriptions=>true
,p_enable_flashback=>true
,p_define_chart_view=>true
,p_enable_download=>true
,p_enable_mail_download=>true
,p_fixed_header=>'PAGE'
,p_show_icon_view=>false
,p_show_detail_view=>false
);
wwv_flow_api.create_ig_report(
 p_id=>wwv_flow_api.id(30589248761106177)
,p_interactive_grid_id=>wwv_flow_api.id(30588882834106175)
,p_static_id=>'305893'
,p_type=>'PRIMARY'
,p_default_view=>'GRID'
,p_show_row_number=>false
,p_settings_area_expanded=>true
);
wwv_flow_api.create_ig_report_view(
 p_id=>wwv_flow_api.id(30589475425106177)
,p_report_id=>wwv_flow_api.id(30589248761106177)
,p_view_type=>'GRID'
,p_srv_exclude_null_values=>false
,p_srv_only_display_columns=>true
,p_edit_mode=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30590591713106178)
,p_view_id=>wwv_flow_api.id(30589475425106177)
,p_display_seq=>0
,p_column_id=>wwv_flow_api.id(30590104043106178)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30591527817106180)
,p_view_id=>wwv_flow_api.id(30589475425106177)
,p_display_seq=>1
,p_column_id=>wwv_flow_api.id(30591135326106179)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30592592926106183)
,p_view_id=>wwv_flow_api.id(30589475425106177)
,p_display_seq=>2
,p_column_id=>wwv_flow_api.id(30592184208106182)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_ig_report_column(
 p_id=>wwv_flow_api.id(30593523389106185)
,p_view_id=>wwv_flow_api.id(30589475425106177)
,p_display_seq=>3
,p_column_id=>wwv_flow_api.id(30593157123106184)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(30594135684106186)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_api.id(30588311656106174)
,p_process_type=>'NATIVE_IG_DML'
,p_process_name=>unistr('\30B9\30C6\30FC\30BF\30B9\30DE\30B9\30BF\7BA1\7406 - \5BFE\8A71\30B0\30EA\30C3\30C9\30FB\30C7\30FC\30BF\306E\4FDD\5B58')
,p_attribute_01=>'REGION_SOURCE'
,p_attribute_05=>'Y'
,p_attribute_06=>'Y'
,p_attribute_08=>'Y'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
end;
/
prompt --application/pages/page_09999
begin
wwv_flow_api.create_page(
 p_id=>9999
,p_user_interface_id=>wwv_flow_api.id(19552109231222152)
,p_name=>unistr('\30ED\30B0\30A4\30F3\30FB\30DA\30FC\30B8')
,p_alias=>'LOGIN'
,p_step_title=>unistr('\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\6587\66F8\7BA1\7406 - \30B5\30A4\30F3\30A4\30F3')
,p_warn_on_unsaved_changes=>'N'
,p_first_item=>'AUTO_FIRST_ITEM'
,p_autocomplete_on_off=>'OFF'
,p_step_template=>wwv_flow_api.id(19418648361221911)
,p_page_template_options=>'#DEFAULT#'
,p_page_is_public_y_n=>'Y'
,p_last_updated_by=>'DOCUMENT_BCT'
,p_last_upd_yyyymmddhh24miss=>'20210730075152'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(19557229717222185)
,p_plug_name=>unistr('\30D6\30ED\30C3\30AF\30C1\30A7\30FC\30F3\30C6\30FC\30D6\30EB\6587\66F8\7BA1\7406')
,p_icon_css_classes=>'app-icon'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_api.id(19465607115221987)
,p_plug_display_sequence=>10
,p_plug_display_point=>'BODY'
,p_attribute_01=>'N'
,p_attribute_02=>'TEXT'
,p_attribute_03=>'Y'
);
wwv_flow_api.create_page_plug(
 p_id=>wwv_flow_api.id(19561967586222203)
,p_plug_name=>unistr('\8A00\8A9E\30BB\30EC\30AF\30BF')
,p_parent_plug_id=>wwv_flow_api.id(19557229717222185)
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#'
,p_escape_on_http_output=>'Y'
,p_plug_template=>wwv_flow_api.id(19438548418221945)
,p_plug_display_sequence=>20
,p_plug_display_point=>'BODY'
,p_plug_source=>'apex_lang.emit_language_selector_list;'
,p_plug_source_type=>'NATIVE_PLSQL'
,p_plug_query_num_rows=>15
);
wwv_flow_api.create_page_button(
 p_id=>wwv_flow_api.id(19560065542222196)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_api.id(19557229717222185)
,p_button_name=>'LOGIN'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_api.id(19529478185222106)
,p_button_is_hot=>'Y'
,p_button_image_alt=>unistr('\30B5\30A4\30F3\30A4\30F3')
,p_button_position=>'REGION_TEMPLATE_NEXT'
,p_button_alignment=>'LEFT'
,p_grid_new_row=>'Y'
,p_grid_new_column=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(19557697085222187)
,p_name=>'P9999_USERNAME'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_api.id(19557229717222185)
,p_prompt=>unistr('\30E6\30FC\30B6\30FC\540D')
,p_placeholder=>unistr('\30E6\30FC\30B6\30FC\540D')
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>40
,p_cMaxlength=>100
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_api.id(19528050754222100)
,p_item_icon_css_classes=>'fa-user'
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'NONE'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(19558027959222189)
,p_name=>'P9999_PASSWORD'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_api.id(19557229717222185)
,p_prompt=>unistr('\30D1\30B9\30EF\30FC\30C9')
,p_placeholder=>unistr('\30D1\30B9\30EF\30FC\30C9')
,p_display_as=>'NATIVE_PASSWORD'
,p_cSize=>40
,p_cMaxlength=>100
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_api.id(19528050754222100)
,p_item_icon_css_classes=>'fa-key'
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_api.create_page_item(
 p_id=>wwv_flow_api.id(19559119896222194)
,p_name=>'P9999_REMEMBER'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_api.id(19557229717222185)
,p_prompt=>unistr('\30E6\30FC\30B6\30FC\540D\3092\8A18\61B6')
,p_display_as=>'NATIVE_CHECKBOX'
,p_named_lov=>'LOGIN_REMEMBER_USERNAME'
,p_lov=>'.'||wwv_flow_api.id(19558300596222190)||'.'
,p_label_alignment=>'RIGHT'
,p_display_when=>'apex_authentication.persistent_cookies_enabled'
,p_display_when2=>'PLSQL'
,p_display_when_type=>'EXPRESSION'
,p_field_template=>wwv_flow_api.id(19528050754222100)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'NO'
,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
'<p>',
unistr('\3053\306E\30C1\30A7\30C3\30AF\30FB\30DC\30C3\30AF\30B9\3092\9078\629E\3059\308B\3068\3001\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\3067\306F\3001"LOGIN_USERNAME_COOKIE"\3068\3044\3046\540D\524D\306E\6C38\7D9A\7684\306A\30D6\30E9\30A6\30B6cookie\306B\30E6\30FC\30B6\30FC\540D\304C\4FDD\5B58\3055\308C\307E\3059\3002'),
unistr('\6B21\56DE\30ED\30B0\30A4\30F3\30FB\30DA\30FC\30B8\306B\30A2\30AF\30BB\30B9\3059\308B\3068\3001'),
unistr('\30E6\30FC\30B6\30FC\540D\30D5\30A3\30FC\30EB\30C9\306B\3053\306E\5024\304C\81EA\52D5\7684\306B\79FB\5165\3055\308C\307E\3059\3002'),
'</p>',
'<p>',
unistr('\3053\306E\30C1\30A7\30C3\30AF\30FB\30DC\30C3\30AF\30B9\306E\9078\629E\3092\89E3\9664\3057\3001\30E6\30FC\30B6\30FC\540D\304C\3059\3067\306Bcookie\306B\4FDD\5B58\3055\308C\3066\3044\308B\5834\5408\3001'),
unistr('\7A7A\306E\5024\3067\4E0A\66F8\3055\308C\307E\3059\3002'),
unistr('\30D6\30E9\30A6\30B6\306E\958B\767A\8005\30C4\30FC\30EB\3092\4F7F\7528\3057\3066\3001cookie\3092\5B8C\5168\306B\524A\9664\3059\308B\3053\3068\3082\3067\304D\307E\3059\3002'),
'</p>'))
,p_attribute_01=>'1'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(19560872934222200)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>unistr('Cookie\306E\30E6\30FC\30B6\30FC\540D\3092\8A2D\5B9A')
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'apex_authentication.send_login_username_cookie (',
'    p_username => lower(:P9999_USERNAME),',
'    p_consent  => :P9999_REMEMBER = ''Y'' );'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(19560421473222199)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Login'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'apex_authentication.login(',
'    p_username => :P9999_USERNAME,',
'    p_password => :P9999_PASSWORD );'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(19561648102222202)
,p_process_sequence=>30
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_SESSION_STATE'
,p_process_name=>unistr('\30DA\30FC\30B8\30FB\30AD\30E3\30C3\30B7\30E5\306E\30AF\30EA\30A2')
,p_attribute_01=>'CLEAR_CACHE_CURRENT_PAGE'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
);
wwv_flow_api.create_page_process(
 p_id=>wwv_flow_api.id(19561279047222200)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>unistr('Cookie\306E\30E6\30FC\30B6\30FC\540D\3092\53D6\5F97')
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
':P9999_USERNAME := apex_authentication.get_login_username_cookie;',
':P9999_REMEMBER := case when :P9999_USERNAME is not null then ''Y'' end;'))
,p_process_clob_language=>'PLSQL'
);
end;
/
prompt --application/deployment/definition
begin
wwv_flow_api.create_install(
 p_id=>wwv_flow_api.id(20458028519806161)
,p_welcome_message=>unistr('\3053\306E\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\30FB\30A4\30F3\30B9\30C8\30FC\30E9\3067\306F\3001\30C7\30FC\30BF\30D9\30FC\30B9\30FB\30AA\30D6\30B8\30A7\30AF\30C8\3068\30B7\30FC\30C9\30FB\30C7\30FC\30BF\306E\4F5C\6210\30D7\30ED\30BB\30B9\306E\624B\9806\304C\793A\3055\308C\307E\3059\3002')
,p_configuration_message=>unistr('\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\306E\6B21\306E\5C5E\6027\3092\69CB\6210\3067\304D\307E\3059\3002')
,p_build_options_message=>unistr('\6B21\306E\30D3\30EB\30C9\30FB\30AA\30D7\30B7\30E7\30F3\3092\542B\3081\308B\3088\3046\306B\9078\629E\3067\304D\307E\3059\3002')
,p_validation_message=>unistr('\6B21\306E\691C\8A3C\306F\3001\3054\4F7F\7528\306E\30B7\30B9\30C6\30E0\3068\3053\306E\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\306E\4E92\63DB\6027\3092\78BA\8A8D\3059\308B\305F\3081\306B\5B9F\884C\3057\307E\3059\3002')
,p_install_message=>unistr('\3053\306E\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\304C\30B5\30DD\30FC\30C8\3059\308B\30AA\30D6\30B8\30A7\30AF\30C8\3092\30A4\30F3\30B9\30C8\30FC\30EB\3059\308B\3053\3068\3092\78BA\8A8D\3057\3066\304F\3060\3055\3044\3002')
,p_upgrade_message=>unistr('\3053\306E\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\306E\30B5\30DD\30FC\30C8\3059\308B\30AA\30D6\30B8\30A7\30AF\30C8\3092\4EE5\524D\306B\30A4\30F3\30B9\30C8\30FC\30EB\3057\305F\3053\3068\304C\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\30FB\30A4\30F3\30B9\30C8\30FC\30E9\306B\3088\3063\3066\691C\51FA\3055\308C\307E\3057\305F\3002\3053\306E\30A6\30A3\30B6\30FC\30C9\3067\306F\3001\3053\308C\3089\306E\30B5\30DD\30FC\30C8\3059\308B\30AA\30D6\30B8\30A7\30AF\30C8\306E\30A2\30C3\30D7\30B0\30EC\30FC\30C9\30FB\30D7\30ED\30BB\30B9\3092\3001\9806\3092\8FFD\3063\3066\8AAC\660E\3057\307E\3059\3002')
,p_upgrade_confirm_message=>unistr('\3053\306E\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\304C\30B5\30DD\30FC\30C8\3059\308B\30AA\30D6\30B8\30A7\30AF\30C8\3092\30A4\30F3\30B9\30C8\30FC\30EB\3059\308B\3053\3068\3092\78BA\8A8D\3057\3066\304F\3060\3055\3044\3002')
,p_upgrade_success_message=>unistr('\30A2\30D7\30EA\30B1\30FC\30B7\30E7\30F3\306E\30B5\30DD\30FC\30C8\3057\3066\3044\308B\30AA\30D6\30B8\30A7\30AF\30C8\304C\30A4\30F3\30B9\30C8\30FC\30EB\3055\308C\307E\3057\305F\3002')
,p_upgrade_failure_message=>unistr('\30C7\30FC\30BF\30D9\30FC\30B9\30FB\30AA\30D6\30B8\30A7\30AF\30C8\3068\30B7\30FC\30C9\30FB\30C7\30FC\30BF\306E\30A4\30F3\30B9\30C8\30FC\30EB\306B\5931\6557\3057\307E\3057\305F\3002')
,p_deinstall_success_message=>unistr('\524A\9664\306F\5B8C\4E86\3057\307E\3057\305F\3002')
,p_deinstall_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
unistr('-- \30D3\30E5\30FC\304A\3088\3073\30C6\30FC\30D6\30EB\306E\524A\9664'),
'DROP VIEW latest_document_with_additional_info;',
'DROP TABLE additional_info CASCADE CONSTRAINTS;',
'DROP TABLE status_master CASCADE CONSTRAINTS;',
'DROP TABLE category_master CASCADE CONSTRAINTS;',
'DROP TABLE update_type_master CASCADE CONSTRAINTS;',
'DROP TABLE document_bct CASCADE CONSTRAINTS;'))
,p_required_free_kb=>100
,p_required_sys_privs=>'CREATE PROCEDURE:CREATE TABLE:CREATE TRIGGER:CREATE VIEW'
,p_required_names_available=>'DOCUMENT_BCT:ADDITIONAL_INFO:CATEGORY_MASTER:LATEST_DOCUMENT_WITH_ADDITIONAL_INFO:STATUS_MASTER:TITLE_AND_CONTENT_EXTRACT:UPDATE_TYPE_MASTER'
);
end;
/
prompt --application/deployment/install/install_テーブルとビューの作成
begin
wwv_flow_api.create_install_script(
 p_id=>wwv_flow_api.id(30709286472407097)
,p_install_id=>wwv_flow_api.id(20458028519806161)
,p_name=>unistr('\30C6\30FC\30D6\30EB\3068\30D3\30E5\30FC\306E\4F5C\6210')
,p_sequence=>10
,p_script_type=>'INSTALL'
,p_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
unistr('-- \30C6\30FC\30D6\30EB\3068\30D3\30E5\30FC\306E\4F5C\6210'),
'',
unistr('-- document_bct\3068\3044\3046\540D\524D\306E\30C9\30AD\30E5\30E1\30F3\30C8\3092\4FDD\7BA1\3059\308BBlockchain Table\3092\4F5C\6210'),
'CREATE BLOCKCHAIN TABLE document_bct (',
'    document_id VARCHAR2(128) NOT NULL,',
'    revision NUMBER(6,0) DEFAULT ON NULL 1,',
'    document_title VARCHAR2(256) NOT NULL,',
'    registerer_name VARCHAR2(128) NOT NULL,',
'    publish_date date NOT NULL,',
'    update_type varchar2(128) NOT NULL,',
'    document BLOB NOT NULL,',
'    document_filename VARCHAR2(256),',
'    document_mimetype VARCHAR2(32),',
'    document_charset VARCHAR2(32),',
'    document_register_date DATE,',
'    PRIMARY KEY(document_id, revision) ',
')',
unistr('    NO DROP UNTIL 0 DAYS IDLE -- \958B\767A\FF0F\30C6\30B9\30C8\6642\306E\5229\4FBF\6027\306E\305F\3081\306B\3044\3064\3067\3082DROP\53EF\80FD\306B\3057\3066\304A\304F'),
'    NO DELETE UNTIL 16 DAYS AFTER INSERT',
'    HASHING USING "SHA2_512" VERSION "v1"',
';',
'',
'',
unistr('-- \66F4\65B0\7A2E\5225\30DE\30B9\30BF'),
'CREATE TABLE update_type_master (',
'    update_type VARCHAR2(128) NOT NULL,',
'    description VARCHAR2(512),',
'    PRIMARY KEY(update_type)',
');',
'',
unistr('-- \30AB\30C6\30B4\30EA\30FC\30DE\30B9\30BF'),
'CREATE TABLE category_master (',
'    category VARCHAR2(128) NOT NULL,',
'    description VARCHAR2(512),',
'    PRIMARY KEY(category)',
');',
'',
unistr('-- \30B9\30C6\30FC\30BF\30B9\30DE\30B9\30BF'),
'CREATE TABLE status_master (',
'    status VARCHAR2(128) NOT NULL,',
'    description VARCHAR2(512),',
'    PRIMARY KEY(status)',
');',
'',
unistr('-- \66F4\65B0\53EF\80FD\306A\4ED8\52A0\60C5\5831\3092\4FDD\5B58\3059\308B\30C6\30FC\30D6\30EB\3092\4F5C\6210\3059\308B'),
'CREATE TABLE additional_info (',
'    document_id VARCHAR2(128) NOT NULL,',
'    category VARCHAR2(128) NOT NULL,',
'    status VARCHAR2(128) NOT NULL,',
'    remarks VARCHAR2(4000),',
'    PRIMARY KEY(document_id)',
');',
'',
unistr('-- \6700\65B0\306EREVISION\306E\30EC\30B3\30FC\30C9\306E\307F\3092\4ED8\52A0\60C5\5831\3068\3068\3082\306B\62BD\51FA\3059\308BVIEW'),
'CREATE VIEW latest_document_with_additional_info AS',
'SELECT d.document_id, a.status, d.revision, d.document_title, d.registerer_name,',
'    d.publish_date, d.update_type, d.document, a.category,',
'    d.document_mimetype, d.document_filename, d.document_charset, d.document_register_date',
'    FROM document_bct d',
'    LEFT JOIN additional_info a ON d.document_id = a.document_id',
'    WHERE revision = (',
'        SELECT MAX(revision) FROM document_bct d2 WHERE d.document_id = d2.document_id',
'    )',
';'))
);
end;
/
prompt --application/deployment/install/install_サンプルマスタデータの登録
begin
wwv_flow_api.create_install_script(
 p_id=>wwv_flow_api.id(30788686283733431)
,p_install_id=>wwv_flow_api.id(20458028519806161)
,p_name=>unistr('\30B5\30F3\30D7\30EB\30DE\30B9\30BF\30C7\30FC\30BF\306E\767B\9332')
,p_sequence=>20
,p_script_type=>'INSTALL'
,p_script_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
unistr('-- \30DE\30B9\30BF\30C7\30FC\30BF\30B5\30F3\30D7\30EB\306E\30BB\30C3\30C8\30A2\30C3\30D7'),
unistr('INSERT INTO update_type_master VALUES(''00:\65B0\898F\767B\9332'',''\65B0\898F\306B\767B\9332\3059\308B\30C9\30AD\30E5\30E1\30F3\30C8'');'),
unistr('INSERT INTO update_type_master VALUES(''11:\5B9A\671F\7684\306A\66F4\65B0'',''\9031\6B21\3001\6708\6B21\3001\5E74\6B21\306A\3069\306E\4E88\3081\5B9A\3081\3089\308C\305F\5B9A\671F\7684\306A\66F4\65B0'');'),
unistr('INSERT INTO update_type_master VALUES(''21:\8EFD\5FAE\306A\4FEE\6B63'',''\8AA4\5B57\3001\8131\5B57\3084\66F8\5F0F\3001\30EC\30A4\30A2\30A6\30C8\306A\3069\306E\5185\5BB9\306B\95A2\308F\3089\306A\3044\8EFD\5FAE\306A\4FEE\6B63'');'),
unistr('INSERT INTO category_master VALUES(''1010:\4F1A\8A08\FF0F\5951\7D04\66F8'', '''');'),
unistr('INSERT INTO category_master VALUES(''1020:\4F1A\8A08\FF0F\8ACB\6C42\66F8'', '''');'),
unistr('INSERT INTO category_master VALUES(''2010:\54C1\8CEA\FF0F\691C\67FB\7D50\679C'', '''');'),
unistr('INSERT INTO category_master VALUES(''2020:\54C1\8CEA\FF0F\8A3C\660E\66F8'', '''');'),
unistr('INSERT INTO category_master VALUES(''9999:\305D\306E\4ED6'', '''');'),
unistr('INSERT INTO status_master VALUES(''00:\6709\52B9'', ''\6709\52B9\306A\30C9\30AD\30E5\30E1\30F3\30C8'');'),
unistr('INSERT INTO status_master VALUES(''10:\7121\52B9'', ''\7121\52B9\306A\30C9\30AD\30E5\30E1\30F3\30C8'');'),
unistr('INSERT INTO status_master VALUES(''99:\7834\68C4'', ''\7834\68C4\6271\3044\306E\30C9\30AD\30E5\30E1\30F3\30C8'');')))
);
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
