prompt --application/pages/page_00016
begin
--   Manifest
--     PAGE: 00016
--   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=>10001
,p_default_id_offset=>0
,p_default_owner=>'STUDENT'
);
wwv_flow_imp_page.create_page(
 p_id=>16
,p_name=>'Practice'
,p_alias=>'PRACTICE'
,p_step_title=>'Practice'
,p_autocomplete_on_off=>'OFF'
,p_javascript_code=>wwv_flow_string.join(wwv_flow_t_varchar2(
'function storePracticeResult() {',
'',
'    // alert("storePracticeResult");',
'',
'    // Identify the particular interactive grid',
'    var ig$ = apex.region("IgVerbTensePractice").widget();',
'',
'    // alert("ig$");',
'    // alert(ig$);',
'',
'    var grid = ig$.interactiveGrid("getViews","grid");',
'    ',
'    // alert("grid = " + grid);',
'',
'    // Fetch the model for the interactive grid',
'    var model = grid.model;',
'',
'    // alert("model = " + model);',
'',
'    // Select all rows',
'    ig$.interactiveGrid("getViews").grid.view$.grid("selectAll");',
'',
'    // alert("selectAll");',
'',
'    // Fetch selected records',
'    var selectedRecords = grid.view$.grid("getSelectedRecords");',
'',
'    // alert("getSelectedRecords, length = " + selectedRecords.length);',
'',
'    // Loop selected records',
'    for (idx=0; idx < selectedRecords.length; idx++) {',
'',
'        record = model.getRecord(selectedRecords[idx][0]);',
'        // alert(record);',
'',
'        verbId = model.getValue(record, "VERB_ID");',
'        rowNum = model.getValue(record, "ROW_NUM");',
'        verbName = model.getValue(record, "VERB_NAME");',
'        translation = model.getValue(record, "TRANSLATION");',
'        pastTense1 = model.getValue(record, "PAST_TENSE_1");',
'        pastTense2 = model.getValue(record, "PAST_TENSE_2");',
'        pastTense3 = model.getValue(record, "PAST_TENSE_3");',
'        pastTense = model.getValue(record, "PAST_TENSE");',
'        perfectTense1 = model.getValue(record, "PERFECT_TENSE_1");',
'        perfectTense2 = model.getValue(record, "PERFECT_TENSE_2");',
'        perfectTense3 = model.getValue(record, "PERFECT_TENSE_3");',
'        perfectTense = model.getValue(record, "PERFECT_TENSE");',
'',
'        // alert("Verb Name: " + verbName);',
'',
'        apex.item(''P16_SELECTED_VERB_ID'').setValue(verbId);',
'        apex.item(''P16_SELECTED_ROW_NUM'').setValue(rowNum);',
'        apex.item(''P16_SELECTED_VERB_NAME'').setValue(verbName);',
'        apex.item(''P16_SELECTED_TRANSLATION'').setValue(translation);',
'        apex.item(''P16_SELECTED_PAST_TENSE_1'').setValue(pastTense1);',
'        apex.item(''P16_SELECTED_PAST_TENSE_2'').setValue(pastTense2);',
'        apex.item(''P16_SELECTED_PAST_TENSE_3'').setValue(pastTense3);',
'        apex.item(''P16_SELECTED_PAST_TENSE'').setValue(pastTense);',
'        apex.item(''P16_SELECTED_PERFECT_TENSE_1'').setValue(perfectTense1);',
'        apex.item(''P16_SELECTED_PERFECT_TENSE_2'').setValue(perfectTense2);',
'        apex.item(''P16_SELECTED_PERFECT_TENSE_3'').setValue(perfectTense3);',
'        apex.item(''P16_SELECTED_PERFECT_TENSE'').setValue(perfectTense);',
'',
'        //$.event.trigger(''storeSinglePracticeResult'');',
'        apex.server.process(',
'            "STORE_SINGLE_PRACTICE_RESULT",',
'            {',
'                f01: verbId,',
'                f02: rowNum,',
'                f03: verbName,',
'                f04: translation,',
'                f05: pastTense1,',
'                f06: pastTense2,',
'                f07: pastTense3,',
'                f08: pastTense,',
'                f09: perfectTense1,',
'                f10: perfectTense2,',
'                f11: perfectTense3,',
'                f12: perfectTense',
'            },',
'            {',
'                dataType: "text",',
'                async: false,',
'                complete: function( ajaxResponse ) {                                    ',
'                    updateResult = ajaxResponse.responseText;',
'                }',
'            }',
'        );',
'',
'    }',
'}',
'',
'function hideTranslation() {',
'',
'    gridView = apex.region("IgVerbTensePractice").call("getViews").grid;',
'    gridView.view$.grid("hideColumn", "TRANSLATION");',
'    ',
'}'))
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_page_component_map=>'21'
,p_last_updated_by=>'STUDENT_DEV'
,p_last_upd_yyyymmddhh24miss=>'20231005102902'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(18864334089537259)
,p_plug_name=>'Practice'
,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(18864494057537259)
,p_plug_name=>'Practice'
,p_parent_plug_id=>wwv_flow_imp.id(18864334089537259)
,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_page_plug(
 p_id=>wwv_flow_imp.id(16706110817764242)
,p_plug_name=>'Verb Tense Practice'
,p_region_name=>'IgVerbTensePractice'
,p_parent_plug_id=>wwv_flow_imp.id(18864494057537259)
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(16112462865514800)
,p_plug_display_sequence=>10
,p_plug_display_point=>'SUB_REGIONS'
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'WITH CTE AS (',
'    SELECT',
'        sevt.verb_id,',
'        sevt.verb_name,',
'        sevt."TRANSLATION",',
'        sevt.past_tense_1,',
'        sevt.past_tense_2,',
'        sevt.past_tense_3,',
'        sevt.perfect_tense_1,',
'        sevt.perfect_tense_2,',
'        sevt.perfect_tense_3',
'    FROM',
'        stdt_en_verb_tenses sevt',
'    ORDER BY dbms_random.random',
')',
'SELECT',
'    ROWNUM                  AS ROW_NUM,',
'    cte.verb_id             AS VERB_ID,',
'    cte.verb_name           AS VERB_NAME,',
'    cte."TRANSLATION"       AS "TRANSLATION",',
'    cte.past_tense_1        AS PAST_TENSE_1,',
'    cte.past_tense_2        AS PAST_TENSE_2,',
'    cte.past_tense_3        AS PAST_TENSE_3,',
'    cte.perfect_tense_1     AS PERFECT_TENSE_1,',
'    cte.perfect_tense_2     AS PERFECT_TENSE_2,',
'    cte.perfect_tense_3     AS PERFECT_TENSE_3,',
'    NULL                    AS PAST_TENSE,',
'    NULL                    AS PERFECT_TENSE,',
'    CASE',
'        WHEN :P16_SHOW_TRANSLATION = ''Y'' THEN',
'            NULL',
'        ELSE',
'            ''css-zero-width''',
'    END                     AS CSS_TRANSLATION',
'FROM',
'    cte',
'WHERE',
'    ROWNUM <= :P16_PRACTICE_COUNT'))
,p_plug_source_type=>'NATIVE_IG'
,p_prn_units=>'INCHES'
,p_prn_paper_size=>'LETTER'
,p_prn_width=>11
,p_prn_height=>8.5
,p_prn_orientation=>'HORIZONTAL'
,p_prn_page_header=>'Verb Tense Practice'
,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_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18972092408793501)
,p_name=>'ROW_NUM'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'ROW_NUM'
,p_data_type=>'NUMBER'
,p_is_query_only=>false
,p_item_type=>'NATIVE_NUMBER_FIELD'
,p_heading=>'Row Num'
,p_heading_alignment=>'RIGHT'
,p_display_sequence=>40
,p_value_alignment=>'RIGHT'
,p_attribute_03=>'left'
,p_attribute_04=>'decimal'
,p_is_required=>false
,p_enable_filter=>false
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18972165638793502)
,p_name=>'VERB_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'VERB_ID'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>30
,p_attribute_01=>'Y'
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>true
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18972295465793503)
,p_name=>'VERB_NAME'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'VERB_NAME'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_DISPLAY_ONLY'
,p_heading=>'Verb Name'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>60
,p_value_alignment=>'LEFT'
,p_attribute_02=>'VALUE'
,p_attribute_05=>'PLAIN'
,p_enable_filter=>false
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18972394362793504)
,p_name=>'TRANSLATION'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'TRANSLATION'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_DISPLAY_ONLY'
,p_heading=>'Translation'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>70
,p_value_alignment=>'LEFT'
,p_attribute_02=>'VALUE'
,p_attribute_05=>'PLAIN'
,p_item_css_classes=>'width-zero'
,p_enable_filter=>false
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18972461507793505)
,p_name=>'PAST_TENSE_1'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PAST_TENSE_1'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>80
,p_attribute_01=>'Y'
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18972508218793506)
,p_name=>'PAST_TENSE_2'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PAST_TENSE_2'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>90
,p_attribute_01=>'Y'
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18972684416793507)
,p_name=>'PAST_TENSE_3'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PAST_TENSE_3'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>100
,p_attribute_01=>'Y'
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18972771032793508)
,p_name=>'PERFECT_TENSE_1'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PERFECT_TENSE_1'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>120
,p_attribute_01=>'Y'
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18972832079793509)
,p_name=>'PERFECT_TENSE_2'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PERFECT_TENSE_2'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>130
,p_attribute_01=>'Y'
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18972927615793510)
,p_name=>'PERFECT_TENSE_3'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PERFECT_TENSE_3'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>140
,p_attribute_01=>'Y'
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18973033050793511)
,p_name=>'PAST_TENSE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PAST_TENSE'
,p_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'Past Tense'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>110
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>false
,p_max_length=>240
,p_enable_filter=>false
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18973109667793512)
,p_name=>'PERFECT_TENSE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'PERFECT_TENSE'
,p_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXT_FIELD'
,p_heading=>'Perfect Tense'
,p_heading_alignment=>'LEFT'
,p_display_sequence=>160
,p_value_alignment=>'LEFT'
,p_attribute_05=>'BOTH'
,p_is_required=>false
,p_max_length=>240
,p_enable_filter=>false
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18973299514793513)
,p_name=>'APEX$ROW_ACTION'
,p_item_type=>'NATIVE_ROW_ACTION'
,p_display_sequence=>20
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18973397389793514)
,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'
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(19027727606040943)
,p_name=>'CSS_TRANSLATION'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'CSS_TRANSLATION'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>170
,p_attribute_01=>'Y'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_interactive_grid(
 p_id=>wwv_flow_imp.id(18879341347649650)
,p_internal_uid=>18879341347649650
,p_is_editable=>true
,p_edit_operations=>'u'
,p_lost_update_check_type=>'VALUES'
,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_toolbar_buttons=>null
,p_enable_save_public_report=>false
,p_enable_subscriptions=>true
,p_enable_flashback=>true
,p_define_chart_view=>true
,p_enable_download=>true
,p_download_formats=>'CSV:HTML:XLSX:PDF'
,p_enable_mail_download=>true
,p_fixed_header=>'PAGE'
,p_show_icon_view=>false
,p_show_detail_view=>false
);
wwv_flow_imp_page.create_ig_report(
 p_id=>wwv_flow_imp.id(18977930360793817)
,p_interactive_grid_id=>wwv_flow_imp.id(18879341347649650)
,p_static_id=>'189780'
,p_type=>'PRIMARY'
,p_default_view=>'GRID'
,p_show_row_number=>false
,p_settings_area_expanded=>true
);
wwv_flow_imp_page.create_ig_report_view(
 p_id=>wwv_flow_imp.id(18978102288793817)
,p_report_id=>wwv_flow_imp.id(18977930360793817)
,p_view_type=>'GRID'
,p_stretch_columns=>true
,p_srv_exclude_null_values=>false
,p_srv_only_display_columns=>true
,p_edit_mode=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18978624337793822)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>2
,p_column_id=>wwv_flow_imp.id(18972092408793501)
,p_is_visible=>true
,p_is_frozen=>false
,p_width=>80
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18979560296793831)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>3
,p_column_id=>wwv_flow_imp.id(18972165638793502)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18980443525793839)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>4
,p_column_id=>wwv_flow_imp.id(18972295465793503)
,p_is_visible=>true
,p_is_frozen=>false
,p_width=>120
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18981303588793848)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>5
,p_column_id=>wwv_flow_imp.id(18972394362793504)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18982210169793856)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>6
,p_column_id=>wwv_flow_imp.id(18972461507793505)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18983100661793865)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>7
,p_column_id=>wwv_flow_imp.id(18972508218793506)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18984035309793873)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>8
,p_column_id=>wwv_flow_imp.id(18972684416793507)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18984923491793880)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>9
,p_column_id=>wwv_flow_imp.id(18972771032793508)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18985878895793888)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>10
,p_column_id=>wwv_flow_imp.id(18972832079793509)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18986632684793895)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>11
,p_column_id=>wwv_flow_imp.id(18972927615793510)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18987561109793902)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>12
,p_column_id=>wwv_flow_imp.id(18973033050793511)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18988488234793909)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>13
,p_column_id=>wwv_flow_imp.id(18973109667793512)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(18994171435795764)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>1
,p_column_id=>wwv_flow_imp.id(18973299514793513)
,p_is_visible=>false
,p_is_frozen=>true
);
wwv_flow_imp_page.create_ig_report_column(
 p_id=>wwv_flow_imp.id(19111722537051708)
,p_view_id=>wwv_flow_imp.id(18978102288793817)
,p_display_seq=>14
,p_column_id=>wwv_flow_imp.id(19027727606040943)
,p_is_visible=>true
,p_is_frozen=>false
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(18865710090537263)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(18864334089537259)
,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(18866053160537263)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_imp.id(18864334089537259)
,p_button_name=>'NEXT'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'t-Button--iconRight'
,p_button_template_id=>wwv_flow_imp.id(16189438884515099)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Next'
,p_button_position=>'NEXT'
,p_confirm_message=>'Are you sure you want to complete practice?'
,p_icon_css_classes=>'fa-chevron-right'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(18865900100537263)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(18864334089537259)
,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=>'false'
,p_button_condition2=>'PLSQL'
,p_button_condition_type=>'EXPRESSION'
,p_icon_css_classes=>'fa-chevron-left'
);
wwv_flow_imp_page.create_page_branch(
 p_id=>wwv_flow_imp.id(18867478282537271)
,p_branch_name=>'Go To Page 17'
,p_branch_action=>'f?p=&APP_ID.:17:&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(18866053160537263)
,p_branch_sequence=>20
);
wwv_flow_imp_page.create_page_branch(
 p_id=>wwv_flow_imp.id(18866707034537269)
,p_branch_action=>'f?p=&APP_ID.:15:&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(18865900100537263)
,p_branch_sequence=>10
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(18875137717649608)
,p_name=>'P16_PRACTICE_COUNT'
,p_item_sequence=>20
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19027601991040942)
,p_name=>'P16_SHOW_TRANSLATION'
,p_item_sequence=>30
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(18973595428793516)
,p_name=>'Clear Temp Table'
,p_event_sequence=>10
,p_bind_type=>'bind'
,p_bind_event_type=>'ready'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(18973669983793517)
,p_event_id=>wwv_flow_imp.id(18973595428793516)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_EXECUTE_PLSQL_CODE'
,p_attribute_01=>wwv_flow_string.join(wwv_flow_t_varchar2(
'BEGIN',
'    EXECUTE IMMEDIATE ''TRUNCATE TABLE stdt_en_verb_tenses_temp'';',
'END;'))
,p_attribute_05=>'PLSQL'
,p_wait_for_result=>'Y'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(19023982209040905)
,p_name=>'Store Practice Result'
,p_event_sequence=>20
,p_bind_type=>'bind'
,p_bind_event_type=>'apexbeforepagesubmit'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(19024083364040906)
,p_event_id=>wwv_flow_imp.id(19023982209040905)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_JAVASCRIPT_CODE'
,p_attribute_01=>'storePracticeResult()'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(19216055992340705)
,p_name=>'Hide Translation'
,p_event_sequence=>30
,p_condition_element=>'P16_SHOW_TRANSLATION'
,p_triggering_condition_type=>'EQUALS'
,p_triggering_expression=>'N'
,p_bind_type=>'bind'
,p_bind_event_type=>'ready'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(19216132148340706)
,p_event_id=>wwv_flow_imp.id(19216055992340705)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_JAVASCRIPT_CODE'
,p_attribute_01=>'hideTranslation()'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(18973455673793515)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_imp.id(16706110817764242)
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Verb Tense Practice - Save Interactive Grid Data'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_cnt  NUMBER;',
'',
'BEGIN',
'',
'    IF (:APEX$ROW_STATUS = ''U'') THEN',
'',
'        SELECT',
'            COUNT(*)',
'        INTO',
'            ln_cnt',
'        FROM',
'            stdt_en_verb_tenses_temp;',
'',
'        IF (ln_cnt = 0) THEN',
'',
'            INSERT INTO stdt_en_verb_tenses_temp(',
'                verb_id,',
'                verb_name,',
'                translation,',
'                past_tense_1,',
'                past_tense_2,',
'                past_tense_3,',
'                past_tense,',
'                perfect_tense_1,',
'                perfect_tense_2,',
'                perfect_tense_3,',
'                perfect_tense',
'            )',
'            VALUES(',
'                :VERB_ID,           -- verb_id,',
'                :VERB_NAME,         -- verb_name,',
'                :TRANSLATION,       -- translation,',
'                :PAST_tense_1,      -- past_tense_1,',
'                :PAST_tense_2,      -- past_tense_2,',
'                :PAST_tense_3,      -- past_tense_3,',
'                :PAST_tense,        -- past_tense,',
'                :PERFECT_tense_1,   -- perfect_tense_1,',
'                :PERFECT_tense_2,   -- perfect_tense_2,',
'                :PERFECT_tense_3,   -- perfect_tense_3,',
'                :PERFECT_tense      -- perfect_tense',
'            );',
'',
'        ELSE',
'',
'            UPDATE',
'                stdt_en_verb_tenses_temp t',
'            SET',
'                t.verb_name         = :VERB_NAME,',
'                t.translation       = :TRANSLATION,',
'                t.past_tense_1      = :PAST_tense_1,',
'                t.past_tense_2      = :PAST_tense_2,',
'                t.past_tense_3      = :PAST_tense_3,',
'                t.past_tense        = :PAST_tense,',
'                t.perfect_tense_1   = :PERFECT_tense_1,',
'                t.perfect_tense_2   = :PERFECT_tense_2,',
'                t.perfect_tense_3   = :PERFECT_tense_3,',
'                t.perfect_tense     = :PERFECT_tense',
'            WHERE',
'                t.verb_id = :VERB_ID;',
'',
'        END IF;  ',
'',
'    END IF;',
'',
'END;'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>18973455673793515
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19024330755040909)
,p_process_sequence=>10
,p_process_point=>'ON_DEMAND'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'STORE_SINGLE_PRACTICE_RESULT'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    lv_verb_id          VARCHAR2(2000);',
'    lv_row_num          VARCHAR2(2000);',
'    lv_verb_name        VARCHAR2(2000);',
'    lv_translation      VARCHAR2(2000);',
'    lv_past_tense_1     VARCHAR2(2000);',
'    lv_past_tense_2     VARCHAR2(2000);',
'    lv_past_tense_3     VARCHAR2(2000);',
'    lv_past_tense       VARCHAR2(2000);',
'    lv_perfect_tense_1  VARCHAR2(2000);',
'    lv_perfect_tense_2  VARCHAR2(2000);',
'    lv_perfect_tense_3  VARCHAR2(2000);',
'    lv_perfect_tense    VARCHAR2(2000);',
'',
'BEGIN',
'',
'    lv_verb_id          := apex_application.g_f01(1);',
'    lv_row_num          := apex_application.g_f02(1);',
'    lv_verb_name        := apex_application.g_f03(1);',
'    lv_translation      := apex_application.g_f04(1);',
'',
'    lv_past_tense_1     := apex_application.g_f05(1);',
'    lv_past_tense_2     := apex_application.g_f06(1);',
'    lv_past_tense_3     := apex_application.g_f07(1);',
'    lv_past_tense       := apex_application.g_f08(1);',
'',
'    lv_perfect_tense_1  := apex_application.g_f09(1);',
'    lv_perfect_tense_2  := apex_application.g_f10(1);',
'    lv_perfect_tense_3  := apex_application.g_f11(1);',
'    lv_perfect_tense    := apex_application.g_f12(1);',
'',
'    MERGE INTO stdt_en_verb_tenses_temp temp',
'        USING (',
'            SELECT',
'                lv_verb_id          AS verb_id,',
'                lv_row_num          AS row_num,',
'                lv_verb_name        AS verb_name,',
'                lv_translation      AS "translation",',
'                lv_past_tense_1     AS past_tense_1,',
'                lv_past_tense_2     AS past_tense_2,',
'                lv_past_tense_3     AS past_tense_3,',
'                lv_past_tense       AS past_tense,',
'                lv_perfect_tense_1  AS perfect_tense_1,',
'                lv_perfect_tense_2  AS perfect_tense_2,',
'                lv_perfect_tense_3  AS perfect_tense_3,',
'                lv_perfect_tense    AS perfect_tense',
'            FROM',
'                dual',
'        ) t',
'        ON',
'            (temp.verb_id = t.verb_id)',
'    WHEN MATCHED THEN',
'        UPDATE',
'        SET',
'            temp.row_num            = t.row_num,',
'            temp.verb_name          = t.verb_name,',
'            temp.translation        = t."translation",',
'            temp.past_tense_1       = t.past_tense_1,',
'            temp.past_tense_2       = t.past_tense_2,',
'            temp.past_tense_3       = t.past_tense_3,',
'            temp.past_tense         = t.past_tense,',
'            temp.perfect_tense_1    = t.perfect_tense_1,',
'            temp.perfect_tense_2    = t.perfect_tense_2,',
'            temp.perfect_tense_3    = t.perfect_tense_3,',
'            temp.perfect_tense      = t.perfect_tense',
'        WHERE',
'            temp.verb_id = t.verb_id',
'    WHEN NOT MATCHED THEN',
'        INSERT (',
'            verb_id,',
'            row_num,',
'            verb_name,',
'            "TRANSLATION",',
'            past_tense_1,',
'            past_tense_2,',
'            past_tense_3,',
'            past_tense,',
'            perfect_tense_1,',
'            perfect_tense_2,',
'            perfect_tense_3,',
'            perfect_tense',
'        )',
'        VALUES(',
'            lv_verb_id,          -- verb_id,',
'            lv_row_num,          -- row_num,',
'            lv_verb_name,        -- verb_name,',
'            lv_translation,      -- "TRANSLATION",',
'            lv_past_tense_1,     -- past_tense_1,',
'            lv_past_tense_2,     -- past_tense_2,',
'            lv_past_tense_3,     -- past_tense_3,',
'            lv_past_tense,       -- past_tense,',
'            lv_perfect_tense_1,  -- perfect_tense_1,',
'            lv_perfect_tense_2,  -- perfect_tense_2,',
'            lv_perfect_tense_3,  -- perfect_tense_3,',
'            lv_perfect_tense     -- perfect_tense,  ',
'        );',
'',
'',
'',
'END;'))
,p_process_clob_language=>'PLSQL'
,p_internal_uid=>19024330755040909
);
wwv_flow_imp.component_end;
end;
/
