prompt --application/pages/page_00011
begin
--   Manifest
--     PAGE: 00011
--   Manifest End
wwv_flow_imp.component_begin (
 p_version_yyyy_mm_dd=>'2023.04.28'
,p_release=>'23.1.0'
,p_default_workspace_id=>16017191443360494
,p_default_application_id=>10002
,p_default_id_offset=>0
,p_default_owner=>'STUDENT'
);
wwv_flow_imp_page.create_page(
 p_id=>11.10002
,p_name=>unistr('\8003\8BD5\7ED3\679C\660E\7EC6')
,p_alias=>'EXAM-DETAIL'
,p_step_title=>unistr('\8003\8BD5\7ED3\679C\660E\7EC6')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(17657824202381685.10002)
,p_plug_name=>unistr('\8003\8BD5\7ED3\679C\660E\7EC6')
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(16112462865514800.10002)
,p_plug_display_sequence=>10
,p_query_type=>'TABLE'
,p_query_table=>'STDT_EXAM_RESULTS'
,p_query_where=>wwv_flow_string.join(wwv_flow_t_varchar2(
'tenant_id = (SELECT tenant_id',
'             FROM   stdt_users su',
'             WHERE  su.user_name = :APP_USER)'))
,p_include_rowid_column=>false
,p_plug_source_type=>'NATIVE_IR'
,p_prn_page_header=>unistr('\8003\8BD5\7ED3\679C\660E\7EC6')
);
wwv_flow_imp_page.create_worksheet(
 p_id=>wwv_flow_imp.id(17658247467381686.10002)
,p_name=>'Exam Detail'
,p_max_row_count_message=>'The maximum row count for this report is #MAX_ROW_COUNT# rows.  Please apply a filter to reduce the number of records in your query.'
,p_no_data_found_message=>'No data found.'
,p_allow_save_rpt_public=>'Y'
,p_pagination_type=>'ROWS_X_TO_Y'
,p_pagination_display_pos=>'BOTTOM_RIGHT'
,p_show_display_row_count=>'Y'
,p_report_list_mode=>'TABS'
,p_lazy_loading=>false
,p_show_detail_link=>'C'
,p_show_rows_per_page=>'N'
,p_show_notify=>'Y'
,p_download_formats=>'CSV:HTML:XLSX:PDF'
,p_enable_mail_download=>'N'
,p_detail_link=>'f?p=&APP_ID.:12:&SESSION.::&DEBUG.:RP:P12_RESULT_ID:\#RESULT_ID#\'
,p_detail_link_text=>'<img src="#APEX_FILES#app_ui/img/icons/apex-edit-pencil.png" class="apex-edit-pencil" alt="Edit">'
,p_owner=>'STUDENT_DEV'
,p_internal_uid=>17658247467381686
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17658322249381697.10002)
,p_db_column_name=>'RESULT_ID'
,p_display_order=>1
,p_column_identifier=>'A'
,p_column_label=>'Result Id'
,p_column_type=>'NUMBER'
,p_display_text_as=>'HIDDEN_ESCAPE_SC'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17658662508381709.10002)
,p_db_column_name=>'STUDENT_ID'
,p_display_order=>2
,p_column_identifier=>'B'
,p_column_label=>unistr('\5B66\751F')
,p_column_type=>'NUMBER'
,p_display_text_as=>'LOV_ESCAPE_SC'
,p_heading_alignment=>'LEFT'
,p_rpt_named_lov=>wwv_flow_imp.id(16427841110660741)
,p_rpt_show_filter_lov=>'1'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17659021006381710.10002)
,p_db_column_name=>'TERM_ID'
,p_display_order=>3
,p_column_identifier=>'C'
,p_column_label=>unistr('\5B66\671F')
,p_column_type=>'NUMBER'
,p_display_text_as=>'LOV_ESCAPE_SC'
,p_heading_alignment=>'LEFT'
,p_rpt_named_lov=>wwv_flow_imp.id(16428205955666019)
,p_rpt_show_filter_lov=>'1'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17659483212381710.10002)
,p_db_column_name=>'SUBJECT_ID'
,p_display_order=>4
,p_column_identifier=>'D'
,p_column_label=>unistr('\8BFE\7A0B')
,p_column_type=>'NUMBER'
,p_display_text_as=>'LOV_ESCAPE_SC'
,p_heading_alignment=>'LEFT'
,p_rpt_named_lov=>wwv_flow_imp.id(16428091443662991)
,p_rpt_show_filter_lov=>'1'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17659811227381711.10002)
,p_db_column_name=>'LEVEL_ID'
,p_display_order=>5
,p_column_identifier=>'E'
,p_column_label=>unistr('\91CD\8981\5EA6')
,p_column_type=>'NUMBER'
,p_display_text_as=>'LOV_ESCAPE_SC'
,p_heading_alignment=>'LEFT'
,p_rpt_named_lov=>wwv_flow_imp.id(16428427022670508)
,p_rpt_show_filter_lov=>'1'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17660255547381712.10002)
,p_db_column_name=>'RESULT_DATE'
,p_display_order=>6
,p_column_identifier=>'F'
,p_column_label=>unistr('\65E5\671F')
,p_column_type=>'DATE'
,p_column_alignment=>'CENTER'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17660668004381713.10002)
,p_db_column_name=>'RESULT'
,p_display_order=>7
,p_column_identifier=>'G'
,p_column_label=>unistr('\5206\6570')
,p_column_type=>'NUMBER'
,p_heading_alignment=>'RIGHT'
,p_column_alignment=>'RIGHT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17661050960381713.10002)
,p_db_column_name=>'RANK'
,p_display_order=>8
,p_column_identifier=>'H'
,p_column_label=>unistr('\7B49\7B2C')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17661443070381714.10002)
,p_db_column_name=>'CREATED_BY'
,p_display_order=>9
,p_column_identifier=>'I'
,p_column_label=>unistr('\8BB0\5F55\521B\5EFA\4EBA')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17661809599381715.10002)
,p_db_column_name=>'CREATION_DATE'
,p_display_order=>10
,p_column_identifier=>'J'
,p_column_label=>unistr('\8BB0\5F55\521B\5EFA\65E5\671F')
,p_column_type=>'DATE'
,p_column_alignment=>'CENTER'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17662212148381715.10002)
,p_db_column_name=>'LAST_UPDATED_BY'
,p_display_order=>11
,p_column_identifier=>'K'
,p_column_label=>unistr('\8BB0\5F55\4FEE\6539\4EBA')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17662606343381718.10002)
,p_db_column_name=>'LAST_UPDATE_DATE'
,p_display_order=>12
,p_column_identifier=>'L'
,p_column_label=>unistr('\8BB0\5F55\4FEE\6539\65E5\671F')
,p_column_type=>'DATE'
,p_column_alignment=>'CENTER'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(17663039471381719.10002)
,p_db_column_name=>'DESCRIPTION'
,p_display_order=>13
,p_column_identifier=>'M'
,p_column_label=>unistr('\63CF\8FF0')
,p_column_type=>'STRING'
,p_heading_alignment=>'LEFT'
,p_tz_dependent=>'N'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_worksheet_column(
 p_id=>wwv_flow_imp.id(19447329028876442.10002)
,p_db_column_name=>'TENANT_ID'
,p_display_order=>23
,p_column_identifier=>'N'
,p_column_label=>'Tenant Id'
,p_column_type=>'NUMBER'
,p_display_text_as=>'HIDDEN_ESCAPE_SC'
,p_use_as_row_header=>'N'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(18025794134474792.10002)
,p_plug_name=>unistr('\8003\8BD5\7ED3\679C\660E\7EC6')
,p_icon_css_classes=>'app-icon'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(16094697015514771.10002)
,p_plug_display_sequence=>1
,p_plug_display_point=>'REGION_POSITION_01'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(17665540484381734.10002)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_imp.id(17657824202381685.10002)
,p_button_name=>'CREATE'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16189347253515098.10002)
,p_button_is_hot=>'Y'
,p_button_image_alt=>unistr('\65B0\5EFA')
,p_button_position=>'RIGHT_OF_IR_SEARCH_BAR'
,p_button_redirect_url=>'f?p=&APP_ID.:12:&SESSION.::&DEBUG.:12'
);
wwv_flow_imp.component_end;
end;
/