prompt --application/pages/page_00025
begin
--   Manifest
--     PAGE: 00025
--   Manifest End
wwv_flow_imp.component_begin (
 p_version_yyyy_mm_dd=>'2023.10.31'
,p_release=>'23.2.4'
,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=>25
,p_name=>'Vocabulary Practice Result'
,p_alias=>'VOCABULARY-PRACTICE-RESULT'
,p_step_title=>'Vocabulary Practice Result'
,p_autocomplete_on_off=>'OFF'
,p_javascript_file_urls=>'[require jet]'
,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_javascript_code_onload=>'require(["ojs/ojgauge"], function() {});'
,p_css_file_urls=>'#JET_CSS_DIRECTORY#alta/oj-alta-notag-min.css'
,p_inline_css=>wwv_flow_string.join(wwv_flow_t_varchar2(
'.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=>'20240220210738'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(10933822777902802)
,p_plug_name=>'Vocabulary 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(10926169243902728)
,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(10933958534902802)
,p_plug_name=>'Vocabulary Practice Result'
,p_parent_plug_id=>wwv_flow_imp.id(10933822777902802)
,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(10944945701306620)
,p_name=>'Vocabulary Practice Result CR'
,p_parent_plug_id=>wwv_flow_imp.id(10933958534902802)
,p_template=>wwv_flow_imp.id(16116793714514810)
,p_display_sequence=>10
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,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',
'    sevt.vocabulary_id,',
'    sevt.row_num,',
'    sevt.vocabulary_name,',
'    sevt."TRANSLATION",',
'    sevt.vocabulary_answer,',
'    ROUND(UTL_MATCH.JARO_WINKLER(',
'        DECODE(',
'            :P25_PRACTICE_DIRECTION,',
'            ''E2C'', sevt."TRANSLATION",',
'            ''C2E'', sevt.vocabulary_name,',
'            NULL',
'        ),',
'        sevt.vocabulary_answer',
'    ) * 100, 2)                 AS match_level,',
'    DECODE(',
'        :P25_PRACTICE_DIRECTION,',
'        ''E2C'', NULL,',
'        ''C2E'', ''css-cell-reference''',
'    )                           AS css_vocabulary_name,',
'    DECODE(',
'        :P25_PRACTICE_DIRECTION,',
'        ''E2C'', ''css-cell-reference'',',
'        ''C2E'', NULL',
'    )                           AS css_translation',
'FROM',
'    stdt_en_vocabularies_temp sevt',
'WHERE',
'    sevt.session_id = APEX_CUSTOM_AUTH.GET_SESSION_ID',
'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=>'NEXT_PREVIOUS_LINKS'
,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(10945061418306621)
,p_query_column_id=>1
,p_column_alias=>'VOCABULARY_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(10945171890306622)
,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(10945253269306623)
,p_query_column_id=>3
,p_column_alias=>'VOCABULARY_NAME'
,p_column_display_sequence=>30
,p_column_heading=>'Vocabulary Name'
,p_use_as_row_header=>'N'
,p_column_html_expression=>'<div class="colorContainer #CSS_VOCABULARY_NAME#">#VOCABULARY_NAME#</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(10945447909306625)
,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_column_html_expression=>'<div class="colorContainer #CSS_TRANSLATION#">#TRANSLATION#</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(10945352395306624)
,p_query_column_id=>5
,p_column_alias=>'VOCABULARY_ANSWER'
,p_column_display_sequence=>50
,p_column_heading=>'Vocabulary Answer'
,p_use_as_row_header=>'N'
,p_column_html_expression=>'<div class="colorContainer css-cell-reference">#VOCABULARY_ANSWER#</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(10945790151306628)
,p_query_column_id=>6
,p_column_alias=>'MATCH_LEVEL'
,p_column_display_sequence=>60
,p_column_heading=>'Match Level'
,p_use_as_row_header=>'N'
,p_column_html_expression=>wwv_flow_string.join(wwv_flow_t_varchar2(
'</div style="width: 200px; height: 100px; position: relative;">',
'    <oj-status-meter-gauge',
'        value=#MATCH_LEVEL#',
'        min=''0''',
'        max=''100''',
'        animation-on-display="auto"',
'        animation-duration=''2000''',
'        orientation=''horizontal''',
'        label.position=''center''',
'        label.text=#MATCH_LEVEL#',
'        start-angle=180',
'        angle-extent=180',
'        readonly=true',
'        thresholds=''[{"max": 95}, {"max": 99}, {}]''''',
'        x=0',
'        y=0',
'        width=100%',
'        height=50%>',
'    </oj-status-meter-gauge>',
'</div>'))
,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(10945808920306629)
,p_query_column_id=>7
,p_column_alias=>'CSS_VOCABULARY_NAME'
,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(10945969119306630)
,p_query_column_id=>8
,p_column_alias=>'CSS_TRANSLATION'
,p_column_display_sequence=>80
,p_hidden_column=>'Y'
,p_derived_column=>'N'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(10935264325902808)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(10933822777902802)
,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.:::'
,p_button_condition_type=>'NEVER'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(10935301416902808)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_imp.id(10933822777902802)
,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(10935410892902808)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(10933822777902802)
,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_button_condition_type=>'NEVER'
,p_icon_css_classes=>'fa-chevron-left'
);
wwv_flow_imp_page.create_page_branch(
 p_id=>wwv_flow_imp.id(10936982853902812)
,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(10935301416902808)
,p_branch_sequence=>1
);
wwv_flow_imp_page.create_page_branch(
 p_id=>wwv_flow_imp.id(10936277436902810)
,p_branch_action=>'f?p=&APP_ID.:24:&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(10935410892902808)
,p_branch_sequence=>10
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(10945676252306627)
,p_name=>'P25_PRACTICE_DIRECTION'
,p_item_sequence=>20
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(10945564303306626)
,p_process_sequence=>10
,p_process_point=>'AFTER_BOX_BODY'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'New'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'BEGIN',
'',
'    DELETE FROM',
'        stdt_en_vocabularies_temp sevt',
'    WHERE',
'        sevt.session_id = APEX_CUSTOM_AUTH.GET_SESSION_ID;',
'',
'END;'))
,p_process_clob_language=>'PLSQL'
,p_internal_uid=>10945564303306626
);
wwv_flow_imp.component_end;
end;
/