prompt --application/pages/page_00016 begin -- Manifest -- PAGE: 00016 -- 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=>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=>'20231222154723' ); 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=>'TABLE' ,p_query_table=>'STDT_EN_VERB_TENSES_TEMP' ,p_query_order_by_type=>'STATIC' ,p_query_order_by=>'ROW_NUM' ,p_include_rowid_column=>false ,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(3287640911056411) ,p_name=>'ROW_NUM' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'ROW_NUM' ,p_data_type=>'NUMBER' ,p_session_state_data_type=>'VARCHAR2' ,p_is_query_only=>false ,p_item_type=>'NATIVE_DISPLAY_ONLY' ,p_heading=>'Row' ,p_heading_alignment=>'LEFT' ,p_display_sequence=>40 ,p_value_alignment=>'LEFT' ,p_attribute_02=>'VALUE' ,p_attribute_05=>'PLAIN' ,p_enable_filter=>true ,p_filter_is_required=>false ,p_filter_lov_type=>'NONE' ,p_use_as_row_header=>false ,p_enable_sort_group=>true ,p_enable_control_break=>true ,p_enable_hide=>true ,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=>50 ,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=>60 ,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=>70 ,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=>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(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=>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(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=>110 ,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=>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(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=>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(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=>100 ,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=>140 ,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_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=>'ACTIONS_MENU' ,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(5022858052399924) ,p_view_id=>wwv_flow_imp.id(18978102288793817) ,p_display_seq=>16 ,p_column_id=>wwv_flow_imp.id(3287640911056411) ,p_is_visible=>true ,p_is_frozen=>false ); 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_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=>'Re-populate Temp Table' ,p_event_sequence=>10 ,p_bind_type=>'bind' ,p_bind_event_type=>'ready' ,p_display_when_type=>'NEVER' ); 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=>'Y' ,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'';', ' DELETE FROM stdt_en_verb_tenses_temp;', '', ' apex_debug.log_message(', ' p_message => ''------'',', ' p_level => apex_debug.c_log_level_info', ' );', '', ' apex_debug.log_message(', ' p_message => ''Table has been deleted, SQL%ROWCOUNT = '' || SQL%ROWCOUNT,', ' p_level => apex_debug.c_log_level_info', ' );', '', ' INSERT INTO stdt_en_verb_tenses_temp sevtt(', ' verb_id,', ' row_num,', ' verb_name,', ' translation,', ' past_tense_1,', ' past_tense_2,', ' past_tense_3,', ' perfect_tense_1,', ' perfect_tense_2,', ' perfect_tense_3,', ' past_tense,', ' perfect_tense', ' )', '', ' 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', ' cte.verb_id AS VERB_ID,', ' ROWNUM AS ROW_NUM,', ' 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;', '', ' apex_debug.log_message(', ' p_message => ''Table has been populated, SQL%ROWCOUNT = '' || SQL%ROWCOUNT,', ' p_level => apex_debug.c_log_level_info', ' );', '', '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' ,p_display_when_type=>'NEVER' ); 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', '', ' apex_debug.log_message(', ' p_message => ''------'',', ' p_level => apex_debug.c_log_level_info', ' );', '', ' apex_debug.log_message(', ' p_message => '':APEX$ROW_STATUS => '' || :APEX$ROW_STATUS,', ' p_level => apex_debug.c_log_level_info', ' );', '', ' apex_debug.log_message(', ' p_message => '':VERB_NAME => '' || :VERB_NAME,', ' p_level => apex_debug.c_log_level_info', ' );', '', ' 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_process_when_type=>'NEVER' ,p_internal_uid=>18973455673793515 ); wwv_flow_imp_page.create_page_process( p_id=>wwv_flow_imp.id(3287732369056412) ,p_process_sequence=>20 ,p_process_point=>'AFTER_SUBMIT' ,p_region_id=>wwv_flow_imp.id(16706110817764242) ,p_process_type=>'NATIVE_IG_DML' ,p_process_name=>'Verb Tense Practise - Save IG' ,p_attribute_01=>'REGION_SOURCE' ,p_attribute_05=>'Y' ,p_attribute_06=>'Y' ,p_attribute_08=>'Y' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ,p_internal_uid=>3287732369056412 ); 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);', '', '', ' apex_debug.log_message(', ' p_message => ''------ STORE_RESULT -----'',', ' p_level => apex_debug.c_log_level_info', ' );', '', ' apex_debug.log_message(', ' p_message => ''lv_verb_name => '' || lv_verb_name,', ' p_level => apex_debug.c_log_level_info', ' );', '', ' 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_process_when_type=>'NEVER' ,p_internal_uid=>19024330755040909 ); wwv_flow_imp.component_end; end; /