prompt --application/pages/page_00017
begin
--   Manifest
--     PAGE: 00017
--   Manifest End
wwv_flow_imp.component_begin (
 p_version_yyyy_mm_dd=>'2023.10.31'
,p_release=>'23.2.0'
,p_default_workspace_id=>16017191443360494
,p_default_application_id=>10001
,p_default_id_offset=>0
,p_default_owner=>'STUDENT'
);
wwv_flow_imp_page.create_page(
 p_id=>17
,p_name=>'Practice Result'
,p_alias=>'PRACTICE-RESULT'
,p_step_title=>'Practice Result'
,p_autocomplete_on_off=>'OFF'
,p_javascript_code=>wwv_flow_string.join(wwv_flow_t_varchar2(
'// Go through every div element inside of table cell, having colorContainer CSS class',
'$(''td>div.colorContainer'').each(function() {',
'    // find the parent td element and add the same class as the child div element',
'    $(this).closest(''td'').addClass( $(this).attr("class") ) ;',
'});'))
,p_inline_css=>wwv_flow_string.join(wwv_flow_t_varchar2(
'.css-cell-correct {',
'    background-color: green;',
'    color: white;',
'}',
'',
'.css-cell-incorrect {',
'    background-color: yellow;',
'    color: black;',
'}',
'',
'.css-cell-reference {',
'    background-color: lightblue;',
'    color: black;',
'}',
''))
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_page_component_map=>'03'
,p_last_updated_by=>'STUDENT_DEV'
,p_last_upd_yyyymmddhh24miss=>'20231004163516'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(18868197799537273)
,p_plug_name=>'Practice Result'
,p_region_template_options=>'#DEFAULT#:t-Wizard--hideStepsXSmall'
,p_plug_template=>wwv_flow_imp.id(16133604317514901)
,p_plug_display_sequence=>10
,p_list_id=>wwv_flow_imp.id(18860483386537150)
,p_plug_source_type=>'NATIVE_LIST'
,p_list_template_id=>wwv_flow_imp.id(16164979301515009)
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(18868266789537273)
,p_plug_name=>'Practice Result'
,p_parent_plug_id=>wwv_flow_imp.id(18868197799537273)
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(16062384265514656)
,p_plug_display_sequence=>10
,p_plug_display_point=>'SUB_REGIONS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
,p_attribute_03=>'Y'
);
wwv_flow_imp_page.create_report_region(
 p_id=>wwv_flow_imp.id(18976171519793542)
,p_name=>'Practice Result CR'
,p_parent_plug_id=>wwv_flow_imp.id(18868266789537273)
,p_template=>wwv_flow_imp.id(16112462865514800)
,p_display_sequence=>10
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#:t-Report--altRowsDefault:t-Report--rowHighlight'
,p_display_point=>'SUB_REGIONS'
,p_source_type=>'NATIVE_SQL_REPORT'
,p_query_type=>'SQL'
,p_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT',
'    verb_id,',
'    row_num,',
'    verb_name,',
'    translation,',
'    past_tense_1,',
'    past_tense_2,',
'    past_tense_3,',
'    past_tense_1',
'    || NVL2(past_tense_2,',
'           '', '' || past_tense_2,',
'           NULL)',
'    || NVL2(past_tense_3,',
'           '', '' || past_tense_3,',
'           NULL) AS past_tense_reference,',
'    perfect_tense_1,',
'    perfect_tense_2,',
'    perfect_tense_3,',
'    perfect_tense_1',
'    || NVL2(perfect_tense_2,',
'           '', '' || perfect_tense_2,',
'           NULL)',
'    || NVL2(perfect_tense_3,',
'           '', '' || perfect_tense_3,',
'           NULL) AS perfect_tense_reference,',
'    past_tense,',
'    perfect_tense,',
'    CASE',
'        WHEN past_tense IN (past_tense_1, past_tense_2, past_tense_3) THEN',
'            ''css-cell-correct''',
'        ELSE',
'            ''css-cell-incorrect''',
'    END     AS css_past_tense,',
'    CASE',
'        WHEN perfect_tense IN (perfect_tense_1, perfect_tense_2, perfect_tense_3) THEN',
'            ''css-cell-correct''',
'        ELSE',
'            ''css-cell-incorrect''',
'    END     AS css_perfect_tense,',
'    ',
'    CASE',
'        WHEN past_tense IN (past_tense_1, past_tense_2, past_tense_3) THEN',
'            NULL',
'        ELSE',
'            ''css-cell-reference''',
'    END     AS css_past_tense_reference,',
'    CASE',
'        WHEN perfect_tense IN (perfect_tense_1, perfect_tense_2, perfect_tense_3) THEN',
'            NULL',
'        ELSE',
'            ''css-cell-reference''',
'    END     AS css_perfect_tense_reference',
'FROM',
'    stdt_en_verb_tenses_temp',
'ORDER BY',
'    row_num'))
,p_ajax_enabled=>'Y'
,p_lazy_loading=>false
,p_query_row_template=>wwv_flow_imp.id(16151769603514974)
,p_query_num_rows=>50
,p_query_options=>'DERIVED_REPORT_COLUMNS'
,p_query_num_rows_type=>'ROWS_X_TO_Y'
,p_pagination_display_position=>'BOTTOM_RIGHT'
,p_csv_output=>'N'
,p_prn_output=>'N'
,p_sort_null=>'L'
,p_plug_query_strip_html=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19026132882040927)
,p_query_column_id=>1
,p_column_alias=>'VERB_ID'
,p_column_display_sequence=>10
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19026256061040928)
,p_query_column_id=>2
,p_column_alias=>'ROW_NUM'
,p_column_display_sequence=>20
,p_column_heading=>'Row Num'
,p_use_as_row_header=>'N'
,p_column_alignment=>'RIGHT'
,p_heading_alignment=>'RIGHT'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19026362517040929)
,p_query_column_id=>3
,p_column_alias=>'VERB_NAME'
,p_column_display_sequence=>30
,p_column_heading=>'Verb Name'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19026488247040930)
,p_query_column_id=>4
,p_column_alias=>'TRANSLATION'
,p_column_display_sequence=>40
,p_column_heading=>'Translation'
,p_use_as_row_header=>'N'
,p_heading_alignment=>'LEFT'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19026510317040931)
,p_query_column_id=>5
,p_column_alias=>'PAST_TENSE_1'
,p_column_display_sequence=>50
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19026644365040932)
,p_query_column_id=>6
,p_column_alias=>'PAST_TENSE_2'
,p_column_display_sequence=>60
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19026776457040933)
,p_query_column_id=>7
,p_column_alias=>'PAST_TENSE_3'
,p_column_display_sequence=>70
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19028013611040946)
,p_query_column_id=>8
,p_column_alias=>'PAST_TENSE_REFERENCE'
,p_column_display_sequence=>80
,p_column_heading=>'Past Tense Reference'
,p_use_as_row_header=>'N'
,p_column_html_expression=>'<div class="colorContainer #CSS_PAST_TENSE_REFERENCE#">#PAST_TENSE_REFERENCE#</div>'
,p_heading_alignment=>'LEFT'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19026875023040934)
,p_query_column_id=>9
,p_column_alias=>'PERFECT_TENSE_1'
,p_column_display_sequence=>100
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19026957606040935)
,p_query_column_id=>10
,p_column_alias=>'PERFECT_TENSE_2'
,p_column_display_sequence=>110
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19027053804040936)
,p_query_column_id=>11
,p_column_alias=>'PERFECT_TENSE_3'
,p_column_display_sequence=>120
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19028155357040947)
,p_query_column_id=>12
,p_column_alias=>'PERFECT_TENSE_REFERENCE'
,p_column_display_sequence=>130
,p_column_heading=>'Perfect Tense Reference'
,p_use_as_row_header=>'N'
,p_column_html_expression=>'<div class="colorContainer #CSS_PERFECT_TENSE_REFERENCE#">#PERFECT_TENSE_REFERENCE#</div>'
,p_heading_alignment=>'LEFT'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19027140830040937)
,p_query_column_id=>13
,p_column_alias=>'PAST_TENSE'
,p_column_display_sequence=>90
,p_column_heading=>'Past Tense'
,p_use_as_row_header=>'N'
,p_column_html_expression=>'<div class="colorContainer #CSS_PAST_TENSE#">#PAST_TENSE#</div>'
,p_heading_alignment=>'LEFT'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19027205014040938)
,p_query_column_id=>14
,p_column_alias=>'PERFECT_TENSE'
,p_column_display_sequence=>140
,p_column_heading=>'Perfect Tense'
,p_use_as_row_header=>'N'
,p_column_html_expression=>'<div class="colorContainer #CSS_PERFECT_TENSE#">#PERFECT_TENSE#</div>'
,p_heading_alignment=>'LEFT'
,p_derived_column=>'N'
,p_include_in_export=>'Y'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19027374038040939)
,p_query_column_id=>15
,p_column_alias=>'CSS_PAST_TENSE'
,p_column_display_sequence=>150
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19027496722040940)
,p_query_column_id=>16
,p_column_alias=>'CSS_PERFECT_TENSE'
,p_column_display_sequence=>160
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19028232923040948)
,p_query_column_id=>17
,p_column_alias=>'CSS_PAST_TENSE_REFERENCE'
,p_column_display_sequence=>180
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_report_columns(
 p_id=>wwv_flow_imp.id(19028339285040949)
,p_query_column_id=>18
,p_column_alias=>'CSS_PERFECT_TENSE_REFERENCE'
,p_column_display_sequence=>190
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(18869526492537276)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(18868197799537273)
,p_button_name=>'CANCEL'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16189347253515098)
,p_button_image_alt=>'Cancel'
,p_button_position=>'CLOSE'
,p_button_redirect_url=>'f?p=&APP_ID.:1:&APP_SESSION.::&DEBUG.:::'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(18869617199537276)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_imp.id(18868197799537273)
,p_button_name=>'FINISH'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16189347253515098)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Finish'
,p_button_position=>'NEXT'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(18869735427537276)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(18868197799537273)
,p_button_name=>'PREVIOUS'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16188659571515092)
,p_button_image_alt=>'Previous'
,p_button_position=>'PREVIOUS'
,p_button_execute_validations=>'N'
,p_icon_css_classes=>'fa-chevron-left'
);
wwv_flow_imp_page.create_page_branch(
 p_id=>wwv_flow_imp.id(18871257554537279)
,p_branch_action=>'f?p=&APP_ID.:1:&APP_SESSION.::&DEBUG.:::&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'AFTER_PROCESSING'
,p_branch_type=>'REDIRECT_URL'
,p_branch_when_button_id=>wwv_flow_imp.id(18869617199537276)
,p_branch_sequence=>1
);
wwv_flow_imp_page.create_page_branch(
 p_id=>wwv_flow_imp.id(18870596117537278)
,p_branch_action=>'f?p=&APP_ID.:16:&APP_SESSION.::&DEBUG.:::&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'BEFORE_VALIDATION'
,p_branch_type=>'REDIRECT_URL'
,p_branch_when_button_id=>wwv_flow_imp.id(18869735427537276)
,p_branch_sequence=>10
);
wwv_flow_imp.component_end;
end;
/
