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=>'20230908160756'
);
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,',
'    func_get_oss_url(image_01_key) as image_01_url_hidden,',
'    func_get_oss_url(image_02_key) as image_02_url_hidden,',
'    func_get_oss_url(image_03_key) as image_03_url_hidden,',
'    func_get_oss_url(image_04_key) as image_04_url_hidden,',
'    func_get_oss_url(image_05_key) as image_05_url_hidden',
'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(17502424097568916)
,p_plug_name=>'Image 01 OSS'
,p_parent_plug_id=>wwv_flow_imp.id(19413379414315143)
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader js-removeLandmark:t-Region--noBorder:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16116793714514810)
,p_plug_display_sequence=>10
,p_plug_source=>'<image src=''&P8_IMAGE_01_URL_HIDDEN.'' width=500>'
,p_plug_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_plug_display_when_condition=>'P8_IMAGE_01_URL_HIDDEN'
,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(17502526404568917)
,p_plug_name=>'Image 02 OSS'
,p_parent_plug_id=>wwv_flow_imp.id(19414064887315150)
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader js-removeLandmark:t-Region--noBorder:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16116793714514810)
,p_plug_display_sequence=>10
,p_plug_source=>'<image src=''&P8_IMAGE_02_URL_HIDDEN.'' width=500>'
,p_plug_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_plug_display_when_condition=>'P8_IMAGE_02_URL_HIDDEN'
,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(17502681267568918)
,p_plug_name=>'Image 03 OSS'
,p_parent_plug_id=>wwv_flow_imp.id(19443498912876403)
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader js-removeLandmark:t-Region--noBorder:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16116793714514810)
,p_plug_display_sequence=>10
,p_plug_source=>'<image src=''&P8_IMAGE_03_URL_HIDDEN.'' width=500>'
,p_plug_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_plug_display_when_condition=>'P8_IMAGE_03_URL_HIDDEN'
,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(17502739474568919)
,p_plug_name=>'Image 04 OSS'
,p_parent_plug_id=>wwv_flow_imp.id(19443748926876406)
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader js-removeLandmark:t-Region--noBorder:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16116793714514810)
,p_plug_display_sequence=>10
,p_plug_source=>'<image src=''&P8_IMAGE_04_URL_HIDDEN.'' width=500>'
,p_plug_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_plug_display_when_condition=>'P8_IMAGE_04_URL_HIDDEN'
,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(17502813120568920)
,p_plug_name=>'Image 05 OSS'
,p_parent_plug_id=>wwv_flow_imp.id(19444001306876409)
,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader js-removeLandmark:t-Region--noBorder:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16116793714514810)
,p_plug_display_sequence=>10
,p_plug_source=>'<image src=''&P8_IMAGE_05_URL_HIDDEN.'' width=500>'
,p_plug_display_condition_type=>'ITEM_IS_NOT_NULL'
,p_plug_display_when_condition=>'P8_IMAGE_05_URL_HIDDEN'
,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=>40
,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=>40
,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=>40
,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=>40
,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=>40
,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(20580868724116534)
,p_button_sequence=>10
,p_button_plug_id=>wwv_flow_imp.id(19219425217880465)
,p_button_name=>'DUPLICATE'
,p_button_action=>'REDIRECT_URL'
,p_button_template_options=>'#DEFAULT#'
,p_button_template_id=>wwv_flow_imp.id(16189347253515098)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'Duplicate'
,p_button_position=>'NEXT'
,p_button_redirect_url=>unistr('javascript:apex.confirm(''\662F\5426\786E\5B9A\590D\5236\4F5C\4E1A?'',''DUPLICATE'')')
,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(19221663506880474)
,p_button_sequence=>20
,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=>30
,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(17501918866568911)
,p_name=>'P8_IMAGE_01_URL_HIDDEN'
,p_source_data_type=>'VARCHAR2'
,p_is_query_only=>true
,p_item_sequence=>390
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_01_URL_HIDDEN'
,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(17502017480568912)
,p_name=>'P8_IMAGE_02_URL_HIDDEN'
,p_source_data_type=>'VARCHAR2'
,p_is_query_only=>true
,p_item_sequence=>400
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_02_URL_HIDDEN'
,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(17502161719568913)
,p_name=>'P8_IMAGE_03_URL_HIDDEN'
,p_source_data_type=>'VARCHAR2'
,p_is_query_only=>true
,p_item_sequence=>410
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_03_URL_HIDDEN'
,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(17502259986568914)
,p_name=>'P8_IMAGE_04_URL_HIDDEN'
,p_source_data_type=>'VARCHAR2'
,p_is_query_only=>true
,p_item_sequence=>420
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_04_URL_HIDDEN'
,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(17502394468568915)
,p_name=>'P8_IMAGE_05_URL_HIDDEN'
,p_source_data_type=>'VARCHAR2'
,p_is_query_only=>true
,p_item_sequence=>430
,p_item_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_item_source_plug_id=>wwv_flow_imp.id(19209274713880426)
,p_source=>'IMAGE_05_URL_HIDDEN'
,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(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',
'AND NVL(ST.DELETED_FLAG, ''N'') <> ''Y''',
'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.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(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=>30
,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%''',
'AND st.image_01_key IS NULL'))
,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(19443250911876401)
,p_name=>'P8_IMAGE_02_DISPLAY'
,p_source_data_type=>'BLOB'
,p_item_sequence=>30
,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%''',
'AND st.image_02_key IS NULL'))
,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=>30
,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%''',
'AND st.image_03_key IS NULL'))
,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=>30
,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%''',
'AND st.image_04_key IS NULL'))
,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=>20
,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%''',
'AND st.image_05_key IS NULL'))
,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,',
'    st.image_01_key = NULL,',
'    st.image_01_etag = 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,',
'    st.image_02_key = NULL,',
'    st.image_02_etag = 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,',
'    st.image_03_key = NULL,',
'    st.image_03_etag = 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,',
'    st.image_04_key = NULL,',
'    st.image_04_etag = 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,',
'    st.image_05_key = NULL,',
'    st.image_05_etag = 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(17501853134568910)
,p_process_sequence=>90
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Upload Files to COS'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'DECLARE',
'    -- Write file',
'    lb_blob1        BLOB;',
'    lb_blob2        BLOB;',
'    lb_blob3        BLOB;',
'    lb_blob4        BLOB;',
'    lb_blob5        BLOB;',
'    ln_blob_len     NUMBER;',
'    lv_db_dir       VARCHAR2(4000) := ''APEX_COS'';',
'    lv_os_dir       VARCHAR2(4000) := ''/home/oracle/python/apex/tmp'';',
'',
'    lv_file1_name   VARCHAR2(4000);',
'    lv_file2_name   VARCHAR2(4000);',
'    lv_file3_name   VARCHAR2(4000);',
'    lv_file4_name   VARCHAR2(4000);',
'    lv_file5_name   VARCHAR2(4000);',
'',
'    -- Call File Upload Service',
'    lv_method       VARCHAR2(30)  := ''POST'';',
'    lc_req_body     CLOB;',
'    lv_url          VARCHAR(4000) := ''http://localhost:8000/upload/'';',
'    lc_res_body     CLOB;',
'  ',
'    lj_object       JSON_OBJECT_T;',
'    lv_result       VARCHAR2(4000);',
'    lv_result_message VARCHAR2(4000);',
'    lv_file1_key    VARCHAR2(4000);',
'    lv_file1_etag   VARCHAR2(4000);',
'    lv_file2_key    VARCHAR2(4000);',
'    lv_file2_etag   VARCHAR2(4000);',
'    lv_file3_key    VARCHAR2(4000);',
'    lv_file3_etag   VARCHAR2(4000);',
'    lv_file4_key    VARCHAR2(4000);',
'    lv_file4_etag   VARCHAR2(4000);',
'    lv_file5_key    VARCHAR2(4000);',
'    lv_file5_etag   VARCHAR2(4000);',
'',
'    lv_retcode      VARCHAR2(1);',
'    lv_errmsg       VARCHAR2(32767);',
'BEGIN',
'    -- Read the BLOB content of the uploaded file',
'    SELECT IMAGE_01,',
'           IMAGE_02,',
'           IMAGE_03,',
'           IMAGE_04,',
'           IMAGE_05',
'    INTO   lb_blob1,',
'           lb_blob2,',
'           lb_blob3,',
'           lb_blob4,',
'           lb_blob5',
'    FROM   STDT_TASKS',
'    WHERE  TASK_ID = :P8_TASK_ID;',
'',
'    -- Write BLOB to file',
'    lv_file1_name := SUBSTRB(:P8_IMAGE_01, INSTRB(:P8_IMAGE_01, ''/'') + 1);',
'    lv_file2_name := SUBSTRB(:P8_IMAGE_02, INSTRB(:P8_IMAGE_02, ''/'') + 1);',
'    lv_file3_name := SUBSTRB(:P8_IMAGE_03, INSTRB(:P8_IMAGE_03, ''/'') + 1);',
'    lv_file4_name := SUBSTRB(:P8_IMAGE_04, INSTRB(:P8_IMAGE_04, ''/'') + 1);',
'    lv_file5_name := SUBSTRB(:P8_IMAGE_05, INSTRB(:P8_IMAGE_05, ''/'') + 1);',
'--',
'    proc_blob_to_file(',
'        ov_retcode      =>  lv_retcode,',
'        ov_errmsg       =>  lv_errmsg,',
'        ib_blob         =>  lb_blob1,',
'        iv_dir          =>  lv_db_dir,',
'        iv_file_name    =>  lv_file1_name',
'    );',
'--',
'    IF (lv_retcode = ''0'') THEN',
'        NULL;',
'    ELSE',
'        APEX_ERROR.ADD_ERROR(',
'            p_message      => ''Failed to write file ['' || lv_file1_name || ''] to folder ['' || lv_db_dir || '']'',',
'            p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION',
'        );',
'    END IF;',
'--',
'    proc_blob_to_file(',
'        ov_retcode      =>  lv_retcode,',
'        ov_errmsg       =>  lv_errmsg,',
'        ib_blob         =>  lb_blob2,',
'        iv_dir          =>  lv_db_dir,',
'        iv_file_name    =>  lv_file2_name',
'    );',
'--',
'    IF (lv_retcode = ''0'') THEN',
'        NULL;',
'    ELSE',
'        APEX_ERROR.ADD_ERROR(',
'            p_message      => ''Failed to write file ['' || lv_file2_name || ''] to folder ['' || lv_db_dir || '']'',',
'            p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION',
'        );',
'    END IF;',
'--',
'    proc_blob_to_file(',
'        ov_retcode      =>  lv_retcode,',
'        ov_errmsg       =>  lv_errmsg,',
'        ib_blob         =>  lb_blob3,',
'        iv_dir          =>  lv_db_dir,',
'        iv_file_name    =>  lv_file3_name',
'    );',
'--',
'    IF (lv_retcode = ''0'') THEN',
'        NULL;',
'    ELSE',
'        APEX_ERROR.ADD_ERROR(',
'            p_message      => ''Failed to write file ['' || lv_file3_name || ''] to folder ['' || lv_db_dir || '']'',',
'            p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION',
'        );',
'    END IF;',
'--',
'--',
'    proc_blob_to_file(',
'        ov_retcode      =>  lv_retcode,',
'        ov_errmsg       =>  lv_errmsg,',
'        ib_blob         =>  lb_blob4,',
'        iv_dir          =>  lv_db_dir,',
'        iv_file_name    =>  lv_file4_name',
'    );',
'--',
'    IF (lv_retcode = ''0'') THEN',
'        NULL;',
'    ELSE',
'        APEX_ERROR.ADD_ERROR(',
'            p_message      => ''Failed to write file ['' || lv_file4_name || ''] to folder ['' || lv_db_dir || '']'',',
'            p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION',
'        );',
'    END IF;',
'--',
'    proc_blob_to_file(',
'        ov_retcode      =>  lv_retcode,',
'        ov_errmsg       =>  lv_errmsg,',
'        ib_blob         =>  lb_blob5,',
'        iv_dir          =>  lv_db_dir,',
'        iv_file_name    =>  lv_file5_name',
'    );',
'--',
'    IF (lv_retcode = ''0'') THEN',
'        NULL;',
'    ELSE',
'        APEX_ERROR.ADD_ERROR(',
'            p_message      => ''Failed to write file ['' || lv_file5_name || ''] to folder ['' || lv_db_dir || '']; '' || lv_errmsg,',
'            p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION',
'        );',
'    END IF;',
'--',
'    -- Call File Upload Service',
'    apex_web_service.g_request_headers(1).name := ''Content-Type'';',
'    apex_web_service.g_request_headers(1).Value := ''application/json; charset=utf-8'';',
' ',
'',
'    lc_req_body := ''{',
'                        "dir": "'' || lv_os_dir || ''",',
'                        "file1_name": "'' || lv_file1_name || ''",',
'                        "file2_name": "'' || lv_file2_name || ''",',
'                        "file3_name": "'' || lv_file3_name || ''",',
'                        "file4_name": "'' || lv_file4_name || ''",',
'                        "file5_name": "'' || lv_file5_name || ''"',
'                    }'';',
'',
'    lc_res_body := APEX_WEB_SERVICE.make_rest_request(',
'        p_url         => lv_url,',
'        p_http_method => lv_method,',
'        p_body        => lc_req_body',
'    );',
'',
'    -- Parse Service Result',
'    lj_object := JSON_OBJECT_T.parse(lc_res_body);',
'    lv_result := lj_object.get_string(''result'');',
'    lv_result_message := lj_object.get_string(''result_message'');',
'    lv_file1_key := lj_object.get_string(''file1_key'');',
'    lv_file1_etag := lj_object.get_string(''file1_etag'');',
'    lv_file2_key := lj_object.get_string(''file2_key'');',
'    lv_file2_etag := lj_object.get_string(''file2_etag'');',
'    lv_file3_key := lj_object.get_string(''file3_key'');',
'    lv_file3_etag := lj_object.get_string(''file3_etag'');',
'    lv_file4_key := lj_object.get_string(''file4_key'');',
'    lv_file4_etag := lj_object.get_string(''file4_etag'');',
'    lv_file5_key := lj_object.get_string(''file5_key'');',
'    lv_file5_etag := lj_object.get_string(''file5_etag'');',
'',
'    IF (lv_result <> ''0'') THEN',
'        APEX_ERROR.ADD_ERROR(',
'            p_message      => ''Failed to upload file to OSS: '' || lv_result_message,',
'            p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION',
'        );',
'    END IF;',
'',
'    -- Write Back to Table',
'    UPDATE STDT_TASKS',
'    SET    IMAGE_01_KEY     = NVL(lv_file1_key, IMAGE_01_KEY),',
'           IMAGE_01_ETAG    = NVL(lv_file1_etag, IMAGE_01_ETAG),',
'           IMAGE_02_KEY     = NVL(lv_file2_key, IMAGE_02_KEY),',
'           IMAGE_02_ETAG    = NVL(lv_file2_etag, IMAGE_02_ETAG),',
'           IMAGE_03_KEY     = NVL(lv_file3_key, IMAGE_03_KEY),',
'           IMAGE_03_ETAG    = NVL(lv_file3_etag, IMAGE_03_ETAG),',
'           IMAGE_04_KEY     = NVL(lv_file4_key, IMAGE_04_KEY),',
'           IMAGE_04_ETAG    = NVL(lv_file4_etag, IMAGE_04_ETAG),',
'           IMAGE_05_KEY     = NVL(lv_file5_key, IMAGE_05_KEY),',
'           IMAGE_05_ETAG    = NVL(lv_file5_etag, IMAGE_05_ETAG)',
'    WHERE TASK_ID = :P8_TASK_ID;',
'',
'    /*APEX_ERROR.ADD_ERROR(',
'        p_message      => ''lv_file1_key -> '' || lv_file1_key,',
'        p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION',
'    );',
'',
'    APEX_ERROR.ADD_ERROR(',
'        p_message      => ''lv_file1_etag -> '' || lv_file1_etag,',
'        p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION',
'    );*/',
'',
'EXCEPTION',
'    WHEN OTHERS THEN',
'        -- Close the file if something goes wrong.',
'        APEX_ERROR.ADD_ERROR(',
'            p_message      => ''Exception -> '' || SQLERRM || dbms_utility.format_error_backtrace,',
'            p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION',
'        );',
'        APEX_ERROR.ADD_ERROR(',
'            p_message      => ''Current User  -> '' || USER,',
'            p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION',
'        );',
'END;'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_imp.id(19221663506880474)
,p_internal_uid=>17501853134568910
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(20580952457116535)
,p_process_sequence=>100
,p_process_point=>'AFTER_SUBMIT'
,p_process_type=>'NATIVE_PLSQL'
,p_process_name=>'Duplicate Task'
,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
'BEGIN',
'',
'    INSERT INTO stdt_tasks st(',
'    	"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"',
'    )',
'    VALUES(',
'    	:P8_TASK_NAME,          -- "TASK_NAME"',
'    	:P8_TASK_DESCRIPTION,   -- "TASK_DESCRIPTION"',
'    	:P8_SUBJECT_ID,         -- "SUBJECT_ID"',
'    	TRUNC(SYSDATE),         -- "START_DATE"',
'    	TRUNC(SYSDATE),         -- "END_DATE"',
'    	0,                      -- "COMPLETION_PERCENT"',
'    	:APP_USER,              -- "CREATED_BY"',
'    	LOCALTIMESTAMP,         -- "CREATION_DATE"',
'    	:APP_USER,              -- "LAST_UPDATED_BY"',
'    	LOCALTIMESTAMP,         -- "LAST_UPDATE_DATE"',
'    	:P8_STUDENT_ID,         -- "STUDENT_ID"',
'    	:P8_TERM_ID,            -- "TERM_ID"',
'    	:P8_TENANT_ID           -- "TENANT_ID"',
'    );',
'',
'END;'))
,p_process_clob_language=>'PLSQL'
,p_process_error_message=>'Failed to duplicate task!'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_process_when_button_id=>wwv_flow_imp.id(20580868724116534)
,p_process_success_message=>'New task has been duplicated.'
,p_internal_uid=>20580952457116535
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19223237597880478)
,p_process_sequence=>110
,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,DUPLICATE'
,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;
/