prompt --application/pages/page_00015
begin
--   Manifest
--     PAGE: 00015
--   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=>15
,p_name=>'Choose Practice Options'
,p_alias=>'CHOOSE-PRACTICE-OPTIONS'
,p_step_title=>'Choose Practice Options'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_page_component_map=>'16'
,p_last_updated_by=>'STUDENT_DEV'
,p_last_upd_yyyymmddhh24miss=>'20231222154238'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(18861253835537211)
,p_plug_name=>'Choose Practice Options'
,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(18861374589537211)
,p_plug_name=>'Choose Practice Options'
,p_parent_plug_id=>wwv_flow_imp.id(18861253835537211)
,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_button(
 p_id=>wwv_flow_imp.id(18862659402537248)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(18861253835537211)
,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(18862961513537248)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_imp.id(18861253835537211)
,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_icon_css_classes=>'fa-chevron-right'
);
wwv_flow_imp_page.create_page_branch(
 p_id=>wwv_flow_imp.id(18863655742537253)
,p_branch_name=>'Go To Page 16'
,p_branch_action=>'f?p=&APP_ID.:16:&SESSION.::&DEBUG.::P16_PRACTICE_COUNT,P16_SHOW_TRANSLATION:&P15_PRACTICE_COUNT.,&P15_SHOW_TRANSLATION.&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'AFTER_PROCESSING'
,p_branch_type=>'REDIRECT_URL'
,p_branch_when_button_id=>wwv_flow_imp.id(18862961513537248)
,p_branch_sequence=>20
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(16706018394764241)
,p_name=>'P15_PRACTICE_COUNT'
,p_is_required=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(18861374589537211)
,p_prompt=>'Practice Count'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_lov=>'STATIC:10;10,15;15,20;20,25;25,30;30'
,p_cHeight=>1
,p_field_template=>wwv_flow_imp.id(16186900279515084)
,p_item_template_options=>'#DEFAULT#'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'NONE'
,p_attribute_02=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19027548734040941)
,p_name=>'P15_SHOW_TRANSLATION'
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(18861374589537211)
,p_prompt=>'Show Translation'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'LOV_YES_NO'
,p_lov=>'.'||wwv_flow_imp.id(19239815662798745)||'.'
,p_cHeight=>1
,p_field_template=>wwv_flow_imp.id(16186900279515084)
,p_item_template_options=>'#DEFAULT#'
,p_lov_display_extra=>'NO'
,p_attribute_01=>'NONE'
,p_attribute_02=>'N'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(3287885422056413)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Re-Populate Temp Table'
,p_process_sql_clob=>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 <= :P15_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_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_imp.id(18862961513537248)
,p_internal_uid=>3287885422056413
);
wwv_flow_imp.component_end;
end;
/