prompt --application/pages/page_00008
begin
--   Manifest
--     PAGE: 00008
--   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=>8
,p_name=>'Task Detail'
,p_alias=>'TASK-DETAIL'
,p_page_mode=>'MODAL'
,p_step_title=>'Task Detail'
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
,p_page_component_map=>'02'
,p_last_updated_by=>'STUDENT_DEV'
,p_last_upd_yyyymmddhh24miss=>'20230813212825'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(19209274713880426)
,p_plug_name=>'Task Detail'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(16062384265514656)
,p_plug_display_sequence=>10
,p_query_type=>'SQL'
,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'select',
'    TASK_ID,',
'    TASK_NAME,',
'    TASK_DESCRIPTION,',
'    SUBJECT_ID,',
'    START_DATE,',
'    END_DATE,',
'    COMPLETION_PERCENT,',
'    CREATED_BY,',
'    CREATION_DATE,',
'    LAST_UPDATED_BY,',
'    LAST_UPDATE_DATE,',
'    STUDENT_ID,',
'    TERM_ID,',
'    TENANT_ID,',
'    IMAGE_01,',
'    IMAGE_01_MIME_TYPE,',
'    IMAGE_01_FILE_NAME,',
'    IMAGE_02,',
'    IMAGE_02_MIME_TYPE,',
'    IMAGE_02_FILE_NAME,',
'    IMAGE_03,',
'    IMAGE_03_MIME_TYPE,',
'    IMAGE_03_FILE_NAME,',
'    IMAGE_04,',
'    IMAGE_04_MIME_TYPE,',
'    IMAGE_04_FILE_NAME,',
'    IMAGE_05,',
'    IMAGE_05_MIME_TYPE,',
'    IMAGE_05_FILE_NAME',
'from STDT_TASKS',
'where tenant_id = (SELECT tenant_id',
'             FROM   stdt_users su',
'             WHERE  su.user_name = :APP_USER)'))
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_plug_source_type=>'NATIVE_FORM'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(19413379414315143)
,p_plug_name=>'Image 01'
,p_parent_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16116793714514810)
,p_plug_display_sequence=>140
,p_plug_display_condition_type=>'FUNCTION_BODY'
,p_plug_display_when_condition=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_length NUMBER;',
'',
'BEGIN',
'',
'    IF :P8_TASK_ID IS NOT NULL THEN',
'',
'        SELECT NVL(dbms_lob.getlength(st.image_01), 0)',
'        INTO   ln_length',
'        FROM   stdt_tasks st',
'        WHERE  st.task_id = :P8_TASK_ID;',
'',
'        IF (ln_length > 0) THEN',
'',
'            RETURN TRUE;',
'        ',
'        END IF;',
'',
'    END IF;',
'',
'    RETURN FALSE;',
'',
'EXCEPTION',
'',
'    WHEN NO_DATA_FOUND THEN',
'        RETURN FALSE;',
'',
'END;'))
,p_plug_display_when_cond2=>'PLSQL'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(19414064887315150)
,p_plug_name=>'Image 02'
,p_parent_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16116793714514810)
,p_plug_display_sequence=>170
,p_plug_display_condition_type=>'FUNCTION_BODY'
,p_plug_display_when_condition=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_length NUMBER;',
'',
'BEGIN',
'',
'    IF :P8_TASK_ID IS NOT NULL THEN',
'',
'        SELECT NVL(dbms_lob.getlength(st.image_02), 0)',
'        INTO   ln_length',
'        FROM   stdt_tasks st',
'        WHERE  st.task_id = :P8_TASK_ID;',
'',
'        IF (ln_length > 0) THEN',
'',
'            RETURN TRUE;',
'        ',
'        END IF;',
'',
'    END IF;',
'',
'    RETURN FALSE;',
'',
'EXCEPTION',
'',
'    WHEN NO_DATA_FOUND THEN',
'        RETURN FALSE;',
'',
'END;'))
,p_plug_display_when_cond2=>'PLSQL'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(19443498912876403)
,p_plug_name=>'Image 03'
,p_parent_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16116793714514810)
,p_plug_display_sequence=>200
,p_plug_display_condition_type=>'FUNCTION_BODY'
,p_plug_display_when_condition=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_length NUMBER;',
'',
'BEGIN',
'',
'    IF :P8_TASK_ID IS NOT NULL THEN',
'',
'        SELECT NVL(dbms_lob.getlength(st.image_03), 0)',
'        INTO   ln_length',
'        FROM   stdt_tasks st',
'        WHERE  st.task_id = :P8_TASK_ID;',
'',
'        IF (ln_length > 0) THEN',
'',
'            RETURN TRUE;',
'        ',
'        END IF;',
'',
'    END IF;',
'',
'    RETURN FALSE;',
'',
'EXCEPTION',
'',
'    WHEN NO_DATA_FOUND THEN',
'        RETURN FALSE;',
'',
'END;'))
,p_plug_display_when_cond2=>'PLSQL'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(19443748926876406)
,p_plug_name=>'Image 04'
,p_parent_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16116793714514810)
,p_plug_display_sequence=>230
,p_plug_display_condition_type=>'FUNCTION_BODY'
,p_plug_display_when_condition=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_length NUMBER;',
'',
'BEGIN',
'',
'    IF :P8_TASK_ID IS NOT NULL THEN',
'',
'        SELECT NVL(dbms_lob.getlength(st.image_04), 0)',
'        INTO   ln_length',
'        FROM   stdt_tasks st',
'        WHERE  st.task_id = :P8_TASK_ID;',
'',
'        IF (ln_length > 0) THEN',
'',
'            RETURN TRUE;',
'        ',
'        END IF;',
'',
'    END IF;',
'',
'    RETURN FALSE;',
'',
'EXCEPTION',
'',
'    WHEN NO_DATA_FOUND THEN',
'        RETURN FALSE;',
'',
'END;'))
,p_plug_display_when_cond2=>'PLSQL'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(19444001306876409)
,p_plug_name=>'Image 05'
,p_parent_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16116793714514810)
,p_plug_display_sequence=>260
,p_plug_display_condition_type=>'FUNCTION_BODY'
,p_plug_display_when_condition=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_length NUMBER;',
'',
'BEGIN',
'',
'    IF :P8_TASK_ID IS NOT NULL THEN',
'',
'        SELECT NVL(dbms_lob.getlength(st.image_05), 0)',
'        INTO   ln_length',
'        FROM   stdt_tasks st',
'        WHERE  st.task_id = :P8_TASK_ID;',
'',
'        IF (ln_length > 0) THEN',
'',
'            RETURN TRUE;',
'        ',
'        END IF;',
'',
'    END IF;',
'',
'    RETURN FALSE;',
'',
'EXCEPTION',
'',
'    WHEN NO_DATA_FOUND THEN',
'        RETURN FALSE;',
'',
'END;'))
,p_plug_display_when_cond2=>'PLSQL'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(19219425217880465)
,p_plug_name=>'Buttons'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(16065140485514661)
,p_plug_display_sequence=>20
,p_plug_display_point=>'REGION_POSITION_03'
,p_attribute_01=>'N'
,p_attribute_02=>'TEXT'
,p_attribute_03=>'Y'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(19413652985315146)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(19413379414315143)
,p_button_name=>'P8_REMOVE_IMAGE_01'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16188659571515092)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Remove Image 01'
,p_button_redirect_url=>unistr('javascript:apex.confirm(''\662F\5426\786E\5B9A\8981\5220\9664\56FE\72471?'',''P8_REMOVE_IMAGE_01'')')
,p_icon_css_classes=>'fa-remove'
,p_grid_new_row=>'Y'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(19443336516876402)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(19414064887315150)
,p_button_name=>'P8_REMOVE_IMAGE_02'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16188659571515092)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Remove Image 02'
,p_button_redirect_url=>unistr('javascript:apex.confirm(''\662F\5426\786E\5B9A\8981\5220\9664\56FE\72472?'',''P8_REMOVE_IMAGE_02'')')
,p_icon_css_classes=>'fa-remove'
,p_grid_new_row=>'Y'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(19443661574876405)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(19443498912876403)
,p_button_name=>'P8_REMOVE_IMAGE_03'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16188659571515092)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Remove Image 03'
,p_button_redirect_url=>unistr('javascript:apex.confirm(''\662F\5426\786E\5B9A\8981\5220\9664\56FE\72473?'',''P8_REMOVE_IMAGE_03'')')
,p_icon_css_classes=>'fa-remove'
,p_grid_new_row=>'Y'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(19443903848876408)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(19443748926876406)
,p_button_name=>'P8_REMOVE_IMAGE_04'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16188659571515092)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Remove Image 04'
,p_button_redirect_url=>unistr('javascript:apex.confirm(''\662F\5426\786E\5B9A\8981\5220\9664\56FE\72474?'',''P8_REMOVE_IMAGE_04'')')
,p_icon_css_classes=>'fa-remove'
,p_grid_new_row=>'Y'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(19444249222876411)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(19444001306876409)
,p_button_name=>'P8_REMOVE_IMAGE_05'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16188659571515092)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Remove Image 05'
,p_button_redirect_url=>unistr('javascript:apex.confirm(''\662F\5426\786E\5B9A\8981\5220\9664\56FE\72475?'',''P8_REMOVE_IMAGE_05'')')
,p_icon_css_classes=>'fa-remove'
,p_grid_new_row=>'Y'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(19219884139880466)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(19219425217880465)
,p_button_name=>'CANCEL'
,p_button_action=>'DEFINED_BY_DA'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16189347253515098)
,p_button_image_alt=>'Cancel'
,p_button_position=>'CLOSE'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(19221293952880473)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(19219425217880465)
,p_button_name=>'DELETE'
,p_button_action=>'SUBMIT'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16189347253515098)
,p_button_image_alt=>'Delete'
,p_button_position=>'DELETE'
,p_button_execute_validations=>'N'
,p_confirm_message=>'&APP_TEXT$DELETE_MSG!RAW.'
,p_confirm_style=>'danger'
,p_button_condition=>'P8_TASK_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'DELETE'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(19221663506880474)
,p_button_sequence=>30
,p_button_plug_id=>wwv_flow_imp.id(19219425217880465)
,p_button_name=>'SAVE'
,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=>'Apply Changes'
,p_button_position=>'NEXT'
,p_button_condition=>'P8_TASK_ID'
,p_button_condition_type=>'ITEM_IS_NOT_NULL'
,p_database_action=>'UPDATE'
);
wwv_flow_imp_page.create_page_button(
 p_id=>wwv_flow_imp.id(19222020527880475)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_imp.id(19219425217880465)
,p_button_name=>'CREATE'
,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=>'Create'
,p_button_position=>'NEXT'
,p_button_condition=>'P8_TASK_ID'
,p_button_condition_type=>'ITEM_IS_NULL'
,p_database_action=>'INSERT'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19209509606880430)
,p_name=>'P8_TASK_ID'
,p_source_data_type=>'NUMBER'
,p_is_primary_key=>true
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Task Id'
,p_source=>'TASK_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_protection_level=>'S'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19209951704880439)
,p_name=>'P8_TASK_NAME'
,p_source_data_type=>'VARCHAR2'
,p_is_required=>true
,p_item_sequence=>20
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'Task Name'
,p_source=>'TASK_NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXT_FIELD'
,p_cSize=>60
,p_cMaxlength=>150
,p_field_template=>wwv_flow_imp.id(16188186001515088)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'N'
,p_attribute_04=>'TEXT'
,p_attribute_05=>'BOTH'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19210372666880444)
,p_name=>'P8_TASK_DESCRIPTION'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>30
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_use_cache_before_default=>'NO'
,p_prompt=>'Task Description'
,p_source=>'TASK_DESCRIPTION'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_TEXTAREA'
,p_cSize=>60
,p_cMaxlength=>2000
,p_cHeight=>4
,p_label_alignment=>'RIGHT'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'BOTH'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19210720866880444)
,p_name=>'P8_SUBJECT_ID'
,p_source_data_type=>'NUMBER'
,p_item_sequence=>60
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'Subject'
,p_source=>'SUBJECT_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'LOV_SUBJECT'
,p_lov_display_null=>'YES'
,p_cHeight=>1
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'YES'
,p_attribute_01=>'NONE'
,p_attribute_02=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19211124726880445)
,p_name=>'P8_START_DATE'
,p_source_data_type=>'DATE'
,p_is_required=>true
,p_item_sequence=>70
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'Start Date'
,p_source=>'START_DATE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DATE_PICKER_APEX'
,p_cSize=>32
,p_cMaxlength=>255
,p_field_template=>wwv_flow_imp.id(16188186001515088)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'POPUP'
,p_attribute_03=>'NONE'
,p_attribute_06=>'NONE'
,p_attribute_09=>'N'
,p_attribute_11=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19211522346880446)
,p_name=>'P8_END_DATE'
,p_source_data_type=>'DATE'
,p_is_required=>true
,p_item_sequence=>80
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'End Date'
,p_source=>'END_DATE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DATE_PICKER_APEX'
,p_cSize=>32
,p_cMaxlength=>255
,p_field_template=>wwv_flow_imp.id(16188186001515088)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'N'
,p_attribute_02=>'POPUP'
,p_attribute_03=>'NONE'
,p_attribute_06=>'NONE'
,p_attribute_09=>'N'
,p_attribute_11=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19211942799880447)
,p_name=>'P8_COMPLETION_PERCENT'
,p_source_data_type=>'NUMBER'
,p_is_required=>true
,p_item_sequence=>90
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_default=>'0'
,p_prompt=>'Completion Percent'
,p_source=>'COMPLETION_PERCENT'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'LOV_COMPLETION_PERCENT'
,p_lov=>'.'||wwv_flow_imp.id(19402336381261186)||'.'
,p_lov_display_null=>'YES'
,p_cHeight=>1
,p_field_template=>wwv_flow_imp.id(16188186001515088)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'YES'
,p_attribute_01=>'NONE'
,p_attribute_02=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19212373719880448)
,p_name=>'P8_CREATED_BY'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>100
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_default=>':APP_USER'
,p_item_default_type=>'EXPRESSION'
,p_item_default_language=>'SQL'
,p_source=>'CREATED_BY'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19212783955880449)
,p_name=>'P8_CREATION_DATE'
,p_source_data_type=>'TIMESTAMP_LTZ'
,p_item_sequence=>110
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_default=>'LOCALTIMESTAMP'
,p_item_default_type=>'EXPRESSION'
,p_item_default_language=>'SQL'
,p_source=>'CREATION_DATE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19213505975880452)
,p_name=>'P8_LAST_UPDATED_BY'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>120
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_default=>':APP_USER'
,p_item_default_type=>'EXPRESSION'
,p_item_default_language=>'SQL'
,p_source=>'LAST_UPDATED_BY'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19213977085880453)
,p_name=>'P8_LAST_UPDATE_DATE'
,p_source_data_type=>'TIMESTAMP_LTZ'
,p_item_sequence=>130
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_default=>'LOCALTIMESTAMP'
,p_item_default_type=>'EXPRESSION'
,p_item_default_language=>'SQL'
,p_source=>'LAST_UPDATE_DATE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19214772366880455)
,p_name=>'P8_STUDENT_ID'
,p_source_data_type=>'NUMBER'
,p_item_sequence=>40
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'Student'
,p_source=>'STUDENT_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_named_lov=>'LOV_STUDENT'
,p_lov_display_null=>'YES'
,p_cHeight=>1
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'YES'
,p_attribute_01=>'NONE'
,p_attribute_02=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19215167639880456)
,p_name=>'P8_TERM_ID'
,p_source_data_type=>'NUMBER'
,p_item_sequence=>50
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'Term'
,p_source=>'TERM_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_SELECT_LIST'
,p_lov=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT',
'    ST.TERM_NAME AS TERM_NAME,',
'    ST.TERM_ID AS TERM_ID',
'FROM',
'    STDT_TERMS ST',
'WHERE',
'    ST.STUDENT_ID = :P8_STUDENT_ID',
'ORDER BY',
'    ST.TERM_START_DATE'))
,p_lov_display_null=>'YES'
,p_lov_cascade_parent_items=>'P8_STUDENT_ID'
,p_ajax_items_to_submit=>'P8_SUBJECT_ID'
,p_ajax_optimize_refresh=>'Y'
,p_cHeight=>1
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_lov_display_extra=>'YES'
,p_attribute_01=>'NONE'
,p_attribute_02=>'N'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19410891295315118)
,p_name=>'P8_IMAGE_01'
,p_source_data_type=>'BLOB'
,p_item_sequence=>160
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'Image 01'
,p_source=>'IMAGE_01'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>30
,p_begin_on_new_line=>'N'
,p_display_when=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_length NUMBER;',
'',
'BEGIN',
'',
'    IF :P8_TASK_ID IS NOT NULL THEN',
'',
'        SELECT NVL(dbms_lob.getlength(st.image_01), 0)',
'        INTO   ln_length',
'        FROM   stdt_tasks st',
'        WHERE  st.task_id = :P8_TASK_ID;',
'',
'        IF (ln_length > 0) THEN',
'',
'            RETURN FALSE;',
'        ',
'        END IF;',
'',
'    END IF;',
'',
'    RETURN TRUE;',
'',
'EXCEPTION',
'',
'    WHEN NO_DATA_FOUND THEN',
'        RETURN TRUE;',
'',
'END;'))
,p_display_when2=>'PLSQL'
,p_display_when_type=>'FUNCTION_BODY'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_02=>'IMAGE_01_MIME_TYPE'
,p_attribute_03=>'IMAGE_01_FILE_NAME'
,p_attribute_06=>'Y'
,p_attribute_08=>'attachment'
,p_attribute_12=>'DROPZONE_INLINE'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19410913241315119)
,p_name=>'P8_IMAGE_02'
,p_source_data_type=>'BLOB'
,p_item_sequence=>190
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'Image 02'
,p_source=>'IMAGE_02'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>30
,p_begin_on_new_line=>'N'
,p_display_when=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_length NUMBER;',
'',
'BEGIN',
'',
'    IF :P8_TASK_ID IS NOT NULL THEN',
'',
'        SELECT NVL(dbms_lob.getlength(st.image_02), 0)',
'        INTO   ln_length',
'        FROM   stdt_tasks st',
'        WHERE  st.task_id = :P8_TASK_ID;',
'',
'        IF (ln_length > 0) THEN',
'',
'            RETURN FALSE;',
'        ',
'        END IF;',
'',
'    END IF;',
'',
'    RETURN TRUE;',
'',
'EXCEPTION',
'',
'    WHEN NO_DATA_FOUND THEN',
'        RETURN TRUE;',
'',
'END;'))
,p_display_when2=>'PLSQL'
,p_display_when_type=>'FUNCTION_BODY'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_02=>'IMAGE_02_MIME_TYPE'
,p_attribute_03=>'IMAGE_02_FILE_NAME'
,p_attribute_06=>'Y'
,p_attribute_08=>'attachment'
,p_attribute_12=>'DROPZONE_INLINE'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19411007901315120)
,p_name=>'P8_IMAGE_03'
,p_source_data_type=>'BLOB'
,p_item_sequence=>220
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'Image 03'
,p_source=>'IMAGE_03'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>30
,p_begin_on_new_line=>'N'
,p_display_when=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_length NUMBER;',
'',
'BEGIN',
'',
'    IF :P8_TASK_ID IS NOT NULL THEN',
'',
'        SELECT NVL(dbms_lob.getlength(st.image_03), 0)',
'        INTO   ln_length',
'        FROM   stdt_tasks st',
'        WHERE  st.task_id = :P8_TASK_ID;',
'',
'        IF (ln_length > 0) THEN',
'',
'            RETURN FALSE;',
'        ',
'        END IF;',
'',
'    END IF;',
'',
'    RETURN TRUE;',
'',
'EXCEPTION',
'',
'    WHEN NO_DATA_FOUND THEN',
'        RETURN TRUE;',
'',
'END;'))
,p_display_when2=>'PLSQL'
,p_display_when_type=>'FUNCTION_BODY'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_02=>'IMAGE_03_MIME_TYPE'
,p_attribute_03=>'IMAGE_03_FILE_NAME'
,p_attribute_06=>'Y'
,p_attribute_08=>'attachment'
,p_attribute_12=>'DROPZONE_INLINE'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19411155186315121)
,p_name=>'P8_IMAGE_04'
,p_source_data_type=>'BLOB'
,p_item_sequence=>250
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'Image 04'
,p_source=>'IMAGE_04'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>30
,p_begin_on_new_line=>'N'
,p_display_when=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_length NUMBER;',
'',
'BEGIN',
'',
'    IF :P8_TASK_ID IS NOT NULL THEN',
'',
'        SELECT NVL(dbms_lob.getlength(st.image_04), 0)',
'        INTO   ln_length',
'        FROM   stdt_tasks st',
'        WHERE  st.task_id = :P8_TASK_ID;',
'',
'        IF (ln_length > 0) THEN',
'',
'            RETURN FALSE;',
'        ',
'        END IF;',
'',
'    END IF;',
'',
'    RETURN TRUE;',
'',
'EXCEPTION',
'',
'    WHEN NO_DATA_FOUND THEN',
'        RETURN TRUE;',
'',
'END;'))
,p_display_when2=>'PLSQL'
,p_display_when_type=>'FUNCTION_BODY'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_02=>'IMAGE_04_MIME_TYPE'
,p_attribute_03=>'IMAGE_04_FILE_NAME'
,p_attribute_06=>'Y'
,p_attribute_08=>'attachment'
,p_attribute_12=>'DROPZONE_INLINE'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19411203995315122)
,p_name=>'P8_IMAGE_05'
,p_source_data_type=>'BLOB'
,p_item_sequence=>270
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_prompt=>'Image 05'
,p_source=>'IMAGE_05'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_FILE'
,p_cSize=>30
,p_begin_on_new_line=>'N'
,p_display_when=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'    ln_length NUMBER;',
'',
'BEGIN',
'',
'    IF :P8_TASK_ID IS NOT NULL THEN',
'',
'        SELECT NVL(dbms_lob.getlength(st.image_05), 0)',
'        INTO   ln_length',
'        FROM   stdt_tasks st',
'        WHERE  st.task_id = :P8_TASK_ID;',
'',
'        IF (ln_length > 0) THEN',
'',
'            RETURN FALSE;',
'        ',
'        END IF;',
'',
'    END IF;',
'',
'    RETURN TRUE;',
'',
'EXCEPTION',
'',
'    WHEN NO_DATA_FOUND THEN',
'        RETURN TRUE;',
'',
'END;'))
,p_display_when2=>'PLSQL'
,p_display_when_type=>'FUNCTION_BODY'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
,p_attribute_02=>'IMAGE_05_MIME_TYPE'
,p_attribute_03=>'IMAGE_05_FILE_NAME'
,p_attribute_06=>'Y'
,p_attribute_08=>'attachment'
,p_attribute_12=>'DROPZONE_INLINE'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19412399717315133)
,p_name=>'P8_IMAGE_01_MIME_TYPE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>280
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_01_MIME_TYPE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19412436842315134)
,p_name=>'P8_IMAGE_01_FILE_NAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>290
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_01_FILE_NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19412572470315135)
,p_name=>'P8_IMAGE_02_MIME_TYPE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>300
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_02_MIME_TYPE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19412656147315136)
,p_name=>'P8_IMAGE_02_FILE_NAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>310
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_02_FILE_NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19412783849315137)
,p_name=>'P8_IMAGE_03_MIME_TYPE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>320
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_03_MIME_TYPE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19412865089315138)
,p_name=>'P8_IMAGE_03_FILE_NAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>330
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_03_FILE_NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19412997520315139)
,p_name=>'P8_IMAGE_04_MIME_TYPE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>340
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_04_MIME_TYPE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19413077802315140)
,p_name=>'P8_IMAGE_04_FILE_NAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>350
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_04_FILE_NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19413157001315141)
,p_name=>'P8_IMAGE_05_MIME_TYPE'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>360
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_05_MIME_TYPE'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19413267213315142)
,p_name=>'P8_IMAGE_05_FILE_NAME'
,p_source_data_type=>'VARCHAR2'
,p_item_sequence=>370
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_05_FILE_NAME'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19413477850315144)
,p_name=>'P8_IMAGE_01_DISPLAY'
,p_source_data_type=>'BLOB'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(19413379414315143)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_01'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DISPLAY_IMAGE'
,p_display_when=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT',
'    image_01_mime_type',
'FROM',
'    stdt_tasks st',
'WHERE',
'    st.task_id = :P8_TASK_ID',
'AND st.image_01_mime_type LIKE ''image%'''))
,p_display_when_type=>'EXISTS'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
);
wwv_flow_imp.component_end;
end;
/
begin
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_item(
 p_id=>wwv_flow_imp.id(19443250911876401)
,p_name=>'P8_IMAGE_02_DISPLAY'
,p_source_data_type=>'BLOB'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(19414064887315150)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_02'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DISPLAY_IMAGE'
,p_display_when=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT',
'    image_02_mime_type',
'FROM',
'    stdt_tasks st',
'WHERE',
'    st.task_id = :P8_TASK_ID',
'AND st.image_02_mime_type LIKE ''image%'''))
,p_display_when_type=>'EXISTS'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19443520741876404)
,p_name=>'P8_IMAGE_03_DISPLAY'
,p_source_data_type=>'BLOB'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(19443498912876403)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_03'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DISPLAY_IMAGE'
,p_display_when=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT',
'    image_03_mime_type',
'FROM',
'    stdt_tasks st',
'WHERE',
'    st.task_id = :P8_TASK_ID',
'AND st.image_03_mime_type LIKE ''image%'''))
,p_display_when_type=>'EXISTS'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19443834491876407)
,p_name=>'P8_IMAGE_04_DISPLAY'
,p_source_data_type=>'BLOB'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(19443748926876406)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_04'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DISPLAY_IMAGE'
,p_display_when=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT',
'    image_04_mime_type',
'FROM',
'    stdt_tasks st',
'WHERE',
'    st.task_id = :P8_TASK_ID',
'AND st.image_04_mime_type LIKE ''image%'''))
,p_display_when_type=>'EXISTS'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19444141709876410)
,p_name=>'P8_IMAGE_05_DISPLAY'
,p_source_data_type=>'BLOB'
,p_item_sequence=>10
,p_item_plug_id=>wwv_flow_imp.id(19444001306876409)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_05'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_DISPLAY_IMAGE'
,p_display_when=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT',
'    image_05_mime_type',
'FROM',
'    stdt_tasks st',
'WHERE',
'    st.task_id = :P8_TASK_ID',
'AND st.image_05_mime_type LIKE ''image%'''))
,p_display_when_type=>'EXISTS'
,p_field_template=>wwv_flow_imp.id(16186811375515083)
,p_item_template_options=>'#DEFAULT#'
,p_is_persistent=>'N'
,p_attribute_01=>'DB_COLUMN'
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(19447056509876439)
,p_name=>'P8_TENANT_ID'
,p_source_data_type=>'NUMBER'
,p_item_sequence=>380
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_default=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT',
'    st.tenant_id',
'FROM',
'    stdt_tenants    st,',
'    stdt_users      su',
'WHERE',
'    su.tenant_id = st.tenant_id',
'AND su.user_name = :APP_USER'))
,p_item_default_type=>'SQL_QUERY'
,p_source=>'TENANT_ID'
,p_source_type=>'REGION_SOURCE_COLUMN'
,p_display_as=>'NATIVE_HIDDEN'
,p_is_persistent=>'N'
,p_attribute_01=>'Y'
);
wwv_flow_imp_page.create_page_validation(
 p_id=>wwv_flow_imp.id(19213214893880452)
,p_validation_name=>'P8_CREATION_DATE must be timestamp'
,p_validation_sequence=>80
,p_validation=>'P8_CREATION_DATE'
,p_validation_type=>'ITEM_IS_TIMESTAMP'
,p_error_message=>'#LABEL# must be a valid timestamp.'
,p_associated_item=>wwv_flow_imp.id(19212783955880449)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_imp_page.create_page_validation(
 p_id=>wwv_flow_imp.id(19214492190880454)
,p_validation_name=>'P8_LAST_UPDATE_DATE must be timestamp'
,p_validation_sequence=>100
,p_validation=>'P8_LAST_UPDATE_DATE'
,p_validation_type=>'ITEM_IS_TIMESTAMP'
,p_error_message=>'#LABEL# must be a valid timestamp.'
,p_associated_item=>wwv_flow_imp.id(19213977085880453)
,p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(19219932932880466)
,p_name=>'Cancel Dialog'
,p_event_sequence=>10
,p_triggering_element_type=>'BUTTON'
,p_triggering_button_id=>wwv_flow_imp.id(19219884139880466)
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'click'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(19220747659880472)
,p_event_id=>wwv_flow_imp.id(19219932932880466)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_DIALOG_CANCEL'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19222819637880477)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_imp.id(19209274713880426)
,p_process_type=>'NATIVE_FORM_DML'
,p_process_name=>'Process form Task Detail'
,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=>19222819637880477
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19413757840315147)
,p_process_sequence=>30
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Delete Image 01'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'UPDATE',
'    stdt_tasks st',
'SET',
'    st.image_01 = NULL,',
'    st.image_01_mime_type = NULL,',
'    st.image_01_file_name = NULL',
'WHERE',
'    st.task_id = :P8_TASK_ID;'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_imp.id(19413652985315146)
,p_process_success_message=>'Image 01 deleted'
,p_internal_uid=>19413757840315147
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19444319612876412)
,p_process_sequence=>40
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Delete Image 02'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'UPDATE',
'    stdt_tasks st',
'SET',
'    st.image_02 = NULL,',
'    st.image_02_mime_type = NULL,',
'    st.image_02_file_name = NULL',
'WHERE',
'    st.task_id = :P8_TASK_ID;'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_imp.id(19443336516876402)
,p_process_success_message=>'Image 02 deleted'
,p_internal_uid=>19444319612876412
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19444462152876413)
,p_process_sequence=>50
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Delete Image 03'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'UPDATE',
'    stdt_tasks st',
'SET',
'    st.image_03 = NULL,',
'    st.image_03_mime_type = NULL,',
'    st.image_03_file_name = NULL',
'WHERE',
'    st.task_id = :P8_TASK_ID;'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_imp.id(19443661574876405)
,p_process_success_message=>'Image 03 deleted'
,p_internal_uid=>19444462152876413
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19444586107876414)
,p_process_sequence=>60
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Delete Image 04'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'UPDATE',
'    stdt_tasks st',
'SET',
'    st.image_04 = NULL,',
'    st.image_04_mime_type = NULL,',
'    st.image_04_file_name = NULL',
'WHERE',
'    st.task_id = :P8_TASK_ID;'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_imp.id(19443903848876408)
,p_process_success_message=>'Image 04 deleted'
,p_internal_uid=>19444586107876414
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19444623173876415)
,p_process_sequence=>70
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Delete Image 05'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'UPDATE',
'    stdt_tasks st',
'SET',
'    st.image_05 = NULL,',
'    st.image_05_mime_type = NULL,',
'    st.image_05_file_name = NULL',
'WHERE',
'    st.task_id = :P8_TASK_ID;'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_imp.id(19444249222876411)
,p_process_success_message=>'Image 05 deleted'
,p_internal_uid=>19444623173876415
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19127502494169023)
,p_process_sequence=>80
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Update Who Columns'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'',
'BEGIN',
'    UPDATE',
'        stdt_tasks ss',
'    SET',
'        last_update_date = LOCALTIMESTAMP,',
'        last_updated_by = :APP_USER',
'    WHERE',
'        task_id = :P8_TASK_ID;',
'END;'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>19127502494169023
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19223237597880478)
,p_process_sequence=>90
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_CLOSE_WINDOW'
,p_process_name=>'Close Dialog'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when=>'CREATE,SAVE,DELETE'
,p_process_when_type=>'REQUEST_IN_CONDITION'
,p_internal_uid=>19223237597880478
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19222467351880477)
,p_process_sequence=>10
,p_process_point=>'BEFORE_HEADER'
,p_region_id=>wwv_flow_imp.id(19209274713880426)
,p_process_type=>'NATIVE_FORM_INIT'
,p_process_name=>'Initialize form Task Detail'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>19222467351880477
);
wwv_flow_imp.component_end;
end;
/
