prompt --application/pages/page_00007
begin
--   Manifest
--     PAGE: 00007
--   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=>10002
,p_default_id_offset=>0
,p_default_owner=>'STUDENT'
);
wwv_flow_imp_page.create_page(
 p_id=>7.10002
,p_name=>unistr('\4F5C\4E1A')
,p_alias=>'TASK'
,p_step_title=>unistr('\4F5C\4E1A')
,p_autocomplete_on_off=>'OFF'
,p_page_template_options=>'#DEFAULT#'
,p_protection_level=>'C'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(19124456792160600.10002)
,p_plug_name=>unistr('\4F5C\4E1A')
,p_icon_css_classes=>'app-icon'
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(16094697015514771.10002)
,p_plug_display_sequence=>10
,p_plug_display_point=>'REGION_POSITION_01'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(19124958541160604.10002)
,p_plug_name=>unistr('\4F5C\4E1A\65E5\5386')
,p_region_template_options=>'#DEFAULT#:js-showMaximizeButton:t-Region--scrollBody'
,p_escape_on_http_output=>'Y'
,p_plug_template=>wwv_flow_imp.id(16116793714514810.10002)
,p_plug_display_sequence=>40
,p_include_in_reg_disp_sel_yn=>'Y'
,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,',
'    CASE',
'        WHEN (COMPLETION_PERCENT = 100) THEN ''apex-cal-green''',
'        WHEN (SYSDATE >= END_DATE + 1 AND COMPLETION_PERCENT <> 100) THEN ''apex-cal-red''',
'        WHEN (MOD(SUBJECT_ID, 5) = 0) THEN ''apex-cal-lime''',
'        WHEN (MOD(SUBJECT_ID, 5) = 1) THEN ''apex-cal-bluesky''',
'        WHEN (MOD(SUBJECT_ID, 5) = 2) THEN ''apex-cal-brown''',
'        WHEN (MOD(SUBJECT_ID, 5) = 3) THEN ''apex-cal-orange''',
'        WHEN (MOD(SUBJECT_ID, 5) = 4) THEN ''apex-cal-yellow''',
'    END css_class,',
'    CASE',
unistr('        WHEN (COMPLETION_PERCENT = 100) THEN ''[\5B8C\6210] '''),
unistr('        WHEN (SYSDATE >= END_DATE + 1 AND COMPLETION_PERCENT <> 100) THEN ''[\8D85\65F6] '''),
'    END',
'    || TASK_NAME || '' - '' || TO_CHAR(COMPLETION_PERCENT) || ''%''',
'    ||',
'    CASE',
'        WHEN IMAGE_01 IS NULL',
'        AND IMAGE_02 IS NULL',
'        AND IMAGE_03 IS NULL',
'        AND IMAGE_04 IS NULL',
'        AND IMAGE_05 IS NULL THEN',
'            NULL',
'        ELSE',
'            '' <''',
'            ||',
'            (TO_NUMBER(CASE',
'                WHEN IMAGE_01 IS NOT NULL THEN',
'                    1',
'                ELSE',
'                    0',
'            END)',
'            +',
'            TO_NUMBER(CASE',
'                WHEN IMAGE_02 IS NOT NULL THEN',
'                    1',
'                ELSE',
'                    0',
'            END)',
'            +',
'            TO_NUMBER(CASE',
'                WHEN IMAGE_03 IS NOT NULL THEN',
'                    1',
'                ELSE',
'                    0',
'            END)',
'            +',
'            TO_NUMBER(CASE',
'                WHEN IMAGE_04 IS NOT NULL THEN',
'                    1',
'                ELSE',
'                    0',
'            END)',
'            +',
'            TO_NUMBER(CASE',
'                WHEN IMAGE_05 IS NOT NULL THEN',
'                    1',
'                ELSE',
'                    0',
'            END))',
'            ||',
unistr('            ''\4E2A\9644\4EF6>'''),
'    END as task_display',
'  from STDT_TASKS st',
'where tenant_id = (SELECT tenant_id',
'             FROM   stdt_users su',
'             WHERE  su.user_name = :APP_USER)'))
,p_lazy_loading=>false
,p_plug_source_type=>'NATIVE_CSS_CALENDAR'
,p_attribute_01=>'START_DATE'
,p_attribute_02=>'END_DATE'
,p_attribute_03=>'TASK_DISPLAY'
,p_attribute_04=>'TASK_ID'
,p_attribute_05=>'f?p=&APP_ID.:8:&SESSION.::&DEBUG.::P8_TASK_ID:&TASK_ID.'
,p_attribute_06=>'f?p=&APP_ID.:8:&SESSION.::&DEBUG.:::'
,p_attribute_07=>'N'
,p_attribute_09=>'list:navigation'
,p_attribute_13=>'N'
,p_attribute_14=>'CSS_CLASS'
,p_attribute_17=>'Y'
,p_attribute_19=>'Y'
,p_attribute_21=>'10'
,p_attribute_22=>'Y'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(19125980031169007.10002)
,p_plug_name=>unistr('\4F5C\4E1A\6570\636E')
,p_region_template_options=>'#DEFAULT#:t-Region--hideShowIconsMath:is-collapsed:t-Region--scrollBody'
,p_plug_template=>wwv_flow_imp.id(16080935615514698.10002)
,p_plug_display_sequence=>70
,p_include_in_reg_disp_sel_yn=>'Y'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(18533660019824642.10002)
,p_plug_name=>unistr('\4F5C\4E1A')
,p_parent_plug_id=>wwv_flow_imp.id(19125980031169007.10002)
,p_region_template_options=>'#DEFAULT#'
,p_component_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(16112462865514800.10002)
,p_plug_display_sequence=>10
,p_plug_display_point=>'SUB_REGIONS'
,p_query_type=>'TABLE'
,p_query_table=>'STDT_TASKS'
,p_query_where=>wwv_flow_string.join(wwv_flow_t_varchar2(
'tenant_id = (SELECT tenant_id',
'             FROM   stdt_users su',
'             WHERE  su.user_name = :APP_USER)'))
,p_include_rowid_column=>false
,p_plug_source_type=>'NATIVE_IG'
,p_prn_units=>'INCHES'
,p_prn_paper_size=>'LETTER'
,p_prn_width=>11
,p_prn_height=>8.5
,p_prn_orientation=>'HORIZONTAL'
,p_prn_page_header=>unistr('\4F5C\4E1A')
,p_prn_page_header_font_color=>'#000000'
,p_prn_page_header_font_family=>'Helvetica'
,p_prn_page_header_font_weight=>'normal'
,p_prn_page_header_font_size=>'12'
,p_prn_page_footer_font_color=>'#000000'
,p_prn_page_footer_font_family=>'Helvetica'
,p_prn_page_footer_font_weight=>'normal'
,p_prn_page_footer_font_size=>'12'
,p_prn_header_bg_color=>'#EEEEEE'
,p_prn_header_font_color=>'#000000'
,p_prn_header_font_family=>'Helvetica'
,p_prn_header_font_weight=>'bold'
,p_prn_header_font_size=>'10'
,p_prn_body_bg_color=>'#FFFFFF'
,p_prn_body_font_color=>'#000000'
,p_prn_body_font_family=>'Helvetica'
,p_prn_body_font_weight=>'normal'
,p_prn_body_font_size=>'10'
,p_prn_border_width=>.5
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18533865392824644.10002)
,p_name=>'TASK_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'TASK_ID'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>30
,p_attribute_01=>'Y'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>true
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18533972708824645.10002)
,p_name=>'TASK_NAME'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'TASK_NAME'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXTAREA'
,p_heading=>unistr('\4F5C\4E1A\540D\79F0')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>40
,p_value_alignment=>'LEFT'
,p_attribute_01=>'Y'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'BOTH'
,p_is_required=>true
,p_max_length=>150
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18534032435824646.10002)
,p_name=>'TASK_DESCRIPTION'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'TASK_DESCRIPTION'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_TEXTAREA'
,p_heading=>unistr('\4F5C\4E1A\8BF4\660E')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>50
,p_value_alignment=>'LEFT'
,p_attribute_01=>'Y'
,p_attribute_02=>'N'
,p_attribute_03=>'N'
,p_attribute_04=>'BOTH'
,p_is_required=>false
,p_max_length=>2000
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_lov_type=>'NONE'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18534177551824647.10002)
,p_name=>'SUBJECT_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'SUBJECT_ID'
,p_data_type=>'NUMBER'
,p_is_query_only=>false
,p_item_type=>'NATIVE_SELECT_LIST'
,p_heading=>unistr('\8BFE\7A0B')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>80
,p_value_alignment=>'LEFT'
,p_is_required=>false
,p_lov_type=>'SHARED'
,p_lov_id=>wwv_flow_imp.id(16428091443662991)
,p_lov_display_extra=>true
,p_lov_display_null=>true
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_exact_match=>true
,p_filter_lov_type=>'LOV'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18534200964824648.10002)
,p_name=>'START_DATE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'START_DATE'
,p_data_type=>'DATE'
,p_is_query_only=>false
,p_item_type=>'NATIVE_DATE_PICKER_APEX'
,p_heading=>unistr('\5F00\59CB\65E5\671F')
,p_heading_alignment=>'CENTER'
,p_display_sequence=>90
,p_value_alignment=>'CENTER'
,p_attribute_01=>'N'
,p_attribute_02=>'POPUP'
,p_attribute_03=>'NONE'
,p_attribute_06=>'NONE'
,p_attribute_09=>'N'
,p_attribute_11=>'Y'
,p_is_required=>true
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_date_ranges=>'ALL'
,p_filter_lov_type=>'DISTINCT'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18534340282824649.10002)
,p_name=>'END_DATE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'END_DATE'
,p_data_type=>'DATE'
,p_is_query_only=>false
,p_item_type=>'NATIVE_DATE_PICKER_APEX'
,p_heading=>unistr('\7ED3\675F\65E5\671F')
,p_heading_alignment=>'CENTER'
,p_display_sequence=>100
,p_value_alignment=>'CENTER'
,p_attribute_01=>'N'
,p_attribute_02=>'POPUP'
,p_attribute_03=>'NONE'
,p_attribute_06=>'NONE'
,p_attribute_09=>'N'
,p_attribute_11=>'Y'
,p_is_required=>true
,p_enable_filter=>true
,p_filter_is_required=>false
,p_filter_date_ranges=>'ALL'
,p_filter_lov_type=>'DISTINCT'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(18534401381824650.10002)
,p_name=>'COMPLETION_PERCENT'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'COMPLETION_PERCENT'
,p_data_type=>'NUMBER'
,p_is_query_only=>false
,p_item_type=>'NATIVE_SELECT_LIST'
,p_heading=>unistr('\5B8C\6210\767E\5206\6BD4')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>110
,p_value_alignment=>'LEFT'
,p_is_required=>true
,p_lov_type=>'SHARED'
,p_lov_id=>wwv_flow_imp.id(19402336381261186)
,p_lov_display_extra=>true
,p_lov_display_null=>true
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_exact_match=>true
,p_filter_lov_type=>'LOV'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_default_type=>'STATIC'
,p_default_expression=>'0'
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(19125366862169001.10002)
,p_name=>'CREATED_BY'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'CREATED_BY'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>120
,p_attribute_01=>'Y'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_default_type=>'EXPRESSION'
,p_default_language=>'SQL'
,p_default_expression=>':APP_USER'
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(19125466121169002.10002)
,p_name=>'CREATION_DATE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'CREATION_DATE'
,p_data_type=>'TIMESTAMP_LTZ'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>130
,p_attribute_01=>'Y'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_default_type=>'EXPRESSION'
,p_default_language=>'SQL'
,p_default_expression=>'LOCALTIMESTAMP'
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(19125597395169003.10002)
,p_name=>'LAST_UPDATED_BY'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'LAST_UPDATED_BY'
,p_data_type=>'VARCHAR2'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>140
,p_attribute_01=>'Y'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_default_type=>'EXPRESSION'
,p_default_language=>'SQL'
,p_default_expression=>':APP_USER'
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(19125622921169004.10002)
,p_name=>'LAST_UPDATE_DATE'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'LAST_UPDATE_DATE'
,p_data_type=>'TIMESTAMP_LTZ'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>150
,p_attribute_01=>'Y'
,p_use_as_row_header=>false
,p_enable_sort_group=>false
,p_is_primary_key=>false
,p_default_type=>'EXPRESSION'
,p_default_language=>'SQL'
,p_default_expression=>'LOCALTIMESTAMP'
,p_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(19125737366169005.10002)
,p_name=>'STUDENT_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'STUDENT_ID'
,p_data_type=>'NUMBER'
,p_is_query_only=>false
,p_item_type=>'NATIVE_SELECT_LIST'
,p_heading=>unistr('\5B66\751F')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>60
,p_value_alignment=>'LEFT'
,p_is_required=>false
,p_lov_type=>'SHARED'
,p_lov_id=>wwv_flow_imp.id(16427841110660741)
,p_lov_display_extra=>true
,p_lov_display_null=>true
,p_enable_filter=>true
,p_filter_operators=>'C:S:CASE_INSENSITIVE:REGEXP'
,p_filter_is_required=>false
,p_filter_text_case=>'MIXED'
,p_filter_exact_match=>true
,p_filter_lov_type=>'LOV'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(19125886420169006.10002)
,p_name=>'TERM_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'TERM_ID'
,p_data_type=>'NUMBER'
,p_is_query_only=>false
,p_item_type=>'NATIVE_SELECT_LIST'
,p_heading=>unistr('\5B66\671F')
,p_heading_alignment=>'LEFT'
,p_display_sequence=>70
,p_value_alignment=>'LEFT'
,p_is_required=>false
,p_lov_type=>'SQL_QUERY'
,p_lov_source=>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 = :STUDENT_ID',
'ORDER BY',
'    ST.TERM_START_DATE'))
,p_lov_display_extra=>true
,p_lov_display_null=>true
,p_lov_cascade_parent_items=>'STUDENT_ID'
,p_ajax_items_to_submit=>'STUDENT_ID'
,p_ajax_optimize_refresh=>true
,p_filter_is_required=>false
,p_use_as_row_header=>false
,p_enable_hide=>true
,p_is_primary_key=>false
,p_duplicate_value=>true
,p_include_in_export=>true
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(19126091717169008.10002)
,p_name=>'APEX$ROW_ACTION'
,p_item_type=>'NATIVE_ROW_ACTION'
,p_display_sequence=>20
,p_use_as_row_header=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(19126116879169009.10002)
,p_name=>'APEX$ROW_SELECTOR'
,p_item_type=>'NATIVE_ROW_SELECTOR'
,p_display_sequence=>10
,p_attribute_01=>'Y'
,p_attribute_02=>'Y'
,p_attribute_03=>'N'
,p_use_as_row_header=>false
);
wwv_flow_imp_page.create_region_column(
 p_id=>wwv_flow_imp.id(19446983702876438.10002)
,p_name=>'TENANT_ID'
,p_source_type=>'DB_COLUMN'
,p_source_expression=>'TENANT_ID'
,p_data_type=>'NUMBER'
,p_session_state_data_type=>'VARCHAR2'
,p_is_query_only=>false
,p_item_type=>'NATIVE_HIDDEN'
,p_display_sequence=>160
,p_attribute_01=>'Y'
,p_use_as_row_header=>false
,p_enable_sort_group=>true
,p_enable_control_break=>true
,p_is_primary_key=>false
,p_default_type=>'SQL_QUERY'
,p_default_expression=>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_duplicate_value=>true
,p_include_in_export=>false
);
wwv_flow_imp_page.create_interactive_grid(
 p_id=>wwv_flow_imp.id(18533761496824643.10002)
,p_internal_uid=>18533761496824643
,p_is_editable=>true
,p_edit_operations=>'i:u:d'
,p_lost_update_check_type=>'VALUES'
,p_add_row_if_empty=>true
,p_submit_checked_rows=>false
,p_lazy_loading=>false
,p_requires_filter=>false
,p_select_first_row=>true
,p_fixed_row_height=>true
,p_pagination_type=>'SCROLL'
,p_show_total_row_count=>true
,p_show_toolbar=>true
,p_enable_save_public_report=>false
,p_enable_subscriptions=>true
,p_enable_flashback=>true
,p_define_chart_view=>true
,p_enable_download=>true
,p_download_formats=>'CSV:HTML:XLSX:PDF'
,p_enable_mail_download=>true
,p_fixed_header=>'PAGE'
,p_show_icon_view=>false
,p_show_detail_view=>false
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(20578384400116509.10002)
,p_plug_name=>unistr('\9009\62E9\663E\793A\7684\533A\57DF')
,p_region_template_options=>'#DEFAULT#'
,p_plug_template=>wwv_flow_imp.id(16062384265514656.10002)
,p_plug_display_sequence=>30
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_source_type=>'NATIVE_DISPLAY_SELECTOR'
,p_attribute_01=>'STANDARD'
,p_attribute_02=>'Y'
,p_attribute_03=>'SESSION'
,p_attribute_04=>'N'
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(20578425049116510.10002)
,p_plug_name=>unistr('\7518\7279\56FE')
,p_region_name=>'gantt'
,p_region_template_options=>'#DEFAULT#:js-showMaximizeButton:t-Region--scrollBody'
,p_escape_on_http_output=>'Y'
,p_plug_template=>wwv_flow_imp.id(16116793714514810.10002)
,p_plug_display_sequence=>50
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_source_type=>'NATIVE_JET_CHART'
,p_plug_query_num_rows=>15
);
wwv_flow_imp_page.create_jet_chart(
 p_id=>wwv_flow_imp.id(20578519770116511.10002)
,p_region_id=>wwv_flow_imp.id(20578425049116510.10002)
,p_chart_type=>'gantt'
,p_height=>'600'
,p_animation_on_display=>'auto'
,p_animation_on_data_change=>'auto'
,p_tooltip_rendered=>'Y'
,p_show_label=>true
,p_show_row=>true
,p_show_start=>true
,p_show_end=>true
,p_show_progress=>true
,p_show_baseline=>true
,p_horizontal_grid=>'visible'
,p_vertical_grid=>'visible'
,p_row_axis_rendered=>'on'
,p_gantt_axis_position=>'top'
,p_javascript_code=>wwv_flow_string.join(wwv_flow_t_varchar2(
'function( options ) {',
'',
'    var event = new Date();',
'    // Define Reference Object line on the chart',
'    var constantLine = [ { value: event.toISOString() } ];',
'    ',
'    // Set the referenceObjects option as part of the chart initialization',
'    options.referenceObjects = constantLine;',
'    ',
'    // enable selection',
'    options.selectionMode = "single";',
'',
'    return options;',
'}'))
);
wwv_flow_imp_page.create_jet_chart_series(
 p_id=>wwv_flow_imp.id(20578635148116512.10002)
,p_chart_id=>wwv_flow_imp.id(20578519770116511.10002)
,p_seq=>10
,p_name=>unistr('\4F5C\4E1A')
,p_data_source_type=>'SQL'
,p_data_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT',
'    st.task_name     task_name,',
'    st.task_id       task_id,',
'    st.start_date    task_start_date,',
'    st.end_date + 1  task_end_date,',
'    st.completion_percent / 100    status,',
'    MIN(st.start_date) OVER(PARTITION BY 1) - 7 gantt_start_date,',
'    MAX(st.end_date) OVER(PARTITION BY 1) + 7 gantt_end_date,',
'    CASE',
'        WHEN (COMPLETION_PERCENT = 100) THEN ''apex-cal-green''',
'        WHEN (SYSDATE >= END_DATE + 1 AND COMPLETION_PERCENT <> 100) THEN ''apex-cal-red''',
'        WHEN (MOD(SUBJECT_ID, 5) = 0) THEN ''apex-cal-lime''',
'        WHEN (MOD(SUBJECT_ID, 5) = 1) THEN ''apex-cal-bluesky''',
'        WHEN (MOD(SUBJECT_ID, 5) = 2) THEN ''apex-cal-brown''',
'        WHEN (MOD(SUBJECT_ID, 5) = 3) THEN ''apex-cal-orange''',
'        WHEN (MOD(SUBJECT_ID, 5) = 4) THEN ''apex-cal-yellow''',
'    END css_class,',
'    CASE',
unistr('        WHEN (COMPLETION_PERCENT = 100) THEN ''[\5B8C\6210] '''),
unistr('        WHEN (SYSDATE >= END_DATE + 1 AND COMPLETION_PERCENT <> 100) THEN ''[\8D85\65F6] '''),
unistr('        ELSE ''[\8FDB\884C\4E2D] '''),
'    END',
'    || TASK_NAME || '' - '' || TO_CHAR(COMPLETION_PERCENT) || ''%''',
'    as task_display',
'FROM',
'    stdt_tasks st',
'WHERE',
'    st.tenant_id = (SELECT',
'                        tenant_id',
'                    FROM',
'                        stdt_users su',
'                    WHERE',
'                        su.user_name = :APP_USER)',
'ORDER BY',
'    st.end_date,',
'    st.task_id'))
,p_items_label_rendered=>false
,p_gantt_start_date_source=>'DB_COLUMN'
,p_gantt_start_date_column=>'GANTT_START_DATE'
,p_gantt_end_date_source=>'DB_COLUMN'
,p_gantt_end_date_column=>'GANTT_END_DATE'
,p_gantt_task_id=>'TASK_ID'
,p_gantt_task_name=>'TASK_DISPLAY'
,p_gantt_task_start_date=>'TASK_START_DATE'
,p_gantt_task_end_date=>'TASK_END_DATE'
,p_gantt_progress_column=>'STATUS'
);
wwv_flow_imp_page.create_jet_chart_axis(
 p_id=>wwv_flow_imp.id(20579041199116516.10002)
,p_chart_id=>wwv_flow_imp.id(20578519770116511.10002)
,p_axis=>'minor'
,p_format_type=>'decimal'
,p_axis_scale=>'days'
,p_zoom_order_seconds=>false
,p_zoom_order_minutes=>false
,p_zoom_order_hours=>false
,p_zoom_order_days=>false
,p_zoom_order_weeks=>false
,p_zoom_order_months=>false
,p_zoom_order_quarters=>false
,p_zoom_order_years=>false
);
wwv_flow_imp_page.create_jet_chart_axis(
 p_id=>wwv_flow_imp.id(20578961005116515.10002)
,p_chart_id=>wwv_flow_imp.id(20578519770116511.10002)
,p_axis=>'major'
,p_is_rendered=>'on'
,p_axis_scale=>'weeks'
,p_zoom_order_seconds=>false
,p_zoom_order_minutes=>false
,p_zoom_order_hours=>false
,p_zoom_order_days=>true
,p_zoom_order_weeks=>true
,p_zoom_order_months=>true
,p_zoom_order_quarters=>true
,p_zoom_order_years=>false
);
wwv_flow_imp_page.create_page_plug(
 p_id=>wwv_flow_imp.id(20579160720116517.10002)
,p_plug_name=>unistr('\7518\7279\56FE(\7B80\5316)')
,p_region_template_options=>'#DEFAULT#:js-showMaximizeButton:t-Region--scrollBody'
,p_escape_on_http_output=>'Y'
,p_plug_template=>wwv_flow_imp.id(16116793714514810.10002)
,p_plug_display_sequence=>60
,p_include_in_reg_disp_sel_yn=>'Y'
,p_plug_source_type=>'NATIVE_JET_CHART'
,p_plug_query_num_rows=>15
);
wwv_flow_imp_page.create_jet_chart(
 p_id=>wwv_flow_imp.id(20579290395116518.10002)
,p_region_id=>wwv_flow_imp.id(20579160720116517.10002)
,p_chart_type=>'gantt'
,p_height=>'600'
,p_animation_on_display=>'auto'
,p_animation_on_data_change=>'auto'
,p_tooltip_rendered=>'Y'
,p_show_label=>true
,p_show_row=>true
,p_show_start=>true
,p_show_end=>true
,p_show_progress=>true
,p_show_baseline=>true
,p_horizontal_grid=>'visible'
,p_vertical_grid=>'visible'
,p_row_axis_rendered=>'on'
,p_gantt_axis_position=>'top'
,p_javascript_code=>wwv_flow_string.join(wwv_flow_t_varchar2(
'function( options ) {',
'',
'    var event = new Date();',
'    // Define Reference Object line on the chart',
'    var constantLine = [ { value: event.toISOString() } ];',
'    ',
'    // Set the referenceObjects option as part of the chart initialization',
'    options.referenceObjects = constantLine;',
'    ',
'    // enable selection',
'    options.selectionMode = "single";',
'    ',
'    return options;',
'}'))
);
wwv_flow_imp_page.create_jet_chart_series(
 p_id=>wwv_flow_imp.id(20579351023116519.10002)
,p_chart_id=>wwv_flow_imp.id(20579290395116518.10002)
,p_seq=>10
,p_name=>unistr('\4F5C\4E1A')
,p_data_source_type=>'SQL'
,p_data_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT',
'    st.task_name     task_name,',
'    CASE',
'        WHEN LENGTH(st.task_name) <= 7 THEN st.task_name',
'        ELSE SUBSTR(st.task_name, 1, 7) || ''...''',
'    END              task_name_concise,',
'    st.task_id       task_id,',
'    st.start_date    task_start_date,',
'    st.end_date + 1  task_end_date,',
'    st.completion_percent / 100    status,',
'    MIN(st.start_date) OVER(PARTITION BY 1) - 7 gantt_start_date,',
'    MAX(st.end_date) OVER(PARTITION BY 1) + 7 gantt_end_date,',
'    CASE',
'        WHEN (COMPLETION_PERCENT = 100) THEN ''apex-cal-green''',
'        WHEN (SYSDATE >= END_DATE + 1 AND COMPLETION_PERCENT <> 100) THEN ''apex-cal-red''',
'        WHEN (MOD(SUBJECT_ID, 5) = 0) THEN ''apex-cal-lime''',
'        WHEN (MOD(SUBJECT_ID, 5) = 1) THEN ''apex-cal-bluesky''',
'        WHEN (MOD(SUBJECT_ID, 5) = 2) THEN ''apex-cal-brown''',
'        WHEN (MOD(SUBJECT_ID, 5) = 3) THEN ''apex-cal-orange''',
'        WHEN (MOD(SUBJECT_ID, 5) = 4) THEN ''apex-cal-yellow''',
'    END css_class,',
'    CASE',
unistr('        WHEN (COMPLETION_PERCENT = 100) THEN ''[\5B8C\6210] '''),
unistr('        WHEN (SYSDATE >= END_DATE + 1 AND COMPLETION_PERCENT <> 100) THEN ''[\8D85\65F6] '''),
unistr('        ELSE ''[\8FDB\884C\4E2D] '''),
'    END',
'    || TASK_NAME || '' - '' || TO_CHAR(COMPLETION_PERCENT) || ''%''',
'    as task_display',
'FROM',
'    stdt_tasks st',
'WHERE',
'    st.tenant_id = (SELECT',
'                        tenant_id',
'                    FROM',
'                        stdt_users su',
'                    WHERE',
'                        su.user_name = :APP_USER)',
'ORDER BY',
'    st.end_date,',
'    st.task_id'))
,p_items_label_rendered=>false
,p_gantt_start_date_source=>'DB_COLUMN'
,p_gantt_start_date_column=>'GANTT_START_DATE'
,p_gantt_end_date_source=>'DB_COLUMN'
,p_gantt_end_date_column=>'GANTT_END_DATE'
,p_gantt_row_name=>'TASK_NAME_CONCISE'
,p_gantt_task_id=>'TASK_ID'
,p_gantt_task_name=>'TASK_DISPLAY'
,p_gantt_task_start_date=>'TASK_START_DATE'
,p_gantt_task_end_date=>'TASK_END_DATE'
,p_gantt_progress_column=>'STATUS'
);
wwv_flow_imp_page.create_jet_chart_axis(
 p_id=>wwv_flow_imp.id(20579434189116520.10002)
,p_chart_id=>wwv_flow_imp.id(20579290395116518.10002)
,p_axis=>'major'
,p_is_rendered=>'on'
,p_axis_scale=>'weeks'
,p_zoom_order_seconds=>false
,p_zoom_order_minutes=>false
,p_zoom_order_hours=>false
,p_zoom_order_days=>true
,p_zoom_order_weeks=>true
,p_zoom_order_months=>true
,p_zoom_order_quarters=>true
,p_zoom_order_years=>false
);
wwv_flow_imp_page.create_jet_chart_axis(
 p_id=>wwv_flow_imp.id(20579540092116521.10002)
,p_chart_id=>wwv_flow_imp.id(20579290395116518.10002)
,p_axis=>'minor'
,p_format_type=>'decimal'
,p_axis_scale=>'days'
,p_zoom_order_seconds=>false
,p_zoom_order_minutes=>false
,p_zoom_order_hours=>false
,p_zoom_order_days=>false
,p_zoom_order_weeks=>false
,p_zoom_order_months=>false
,p_zoom_order_quarters=>false
,p_zoom_order_years=>false
);
wwv_flow_imp_page.create_page_branch(
 p_id=>wwv_flow_imp.id(17501440186568906.10002)
,p_branch_name=>'Navigate to Task Edit Page'
,p_branch_action=>'f?p=&APP_ID.:8:&SESSION.::&DEBUG.::P8_TASK_ID:&P7_TASK_ID.&success_msg=#SUCCESS_MSG#'
,p_branch_point=>'AFTER_PROCESSING'
,p_branch_type=>'REDIRECT_URL'
,p_branch_sequence=>10
);
wwv_flow_imp_page.create_page_item(
 p_id=>wwv_flow_imp.id(17501151021568903.10002)
,p_name=>'P7_TASK_ID'
,p_item_sequence=>80
,p_display_as=>'NATIVE_HIDDEN'
,p_attribute_01=>'N'
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(19126534726169013.10002)
,p_name=>'Dialog Closed'
,p_event_sequence=>10
,p_triggering_element_type=>'JAVASCRIPT_EXPRESSION'
,p_triggering_element=>'window'
,p_triggering_condition_type=>'JAVASCRIPT_EXPRESSION'
,p_triggering_expression=>'this.browserEvent != "load" && this.data.dialogPageId == "8"'
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'apexafterclosedialog'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(19126600717169014.10002)
,p_event_id=>wwv_flow_imp.id(19126534726169013.10002)
,p_event_result=>'TRUE'
,p_action_sequence=>20
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_REFRESH'
,p_affected_elements_type=>'REGION'
,p_affected_region_id=>wwv_flow_imp.id(18533660019824642.10002)
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(17501215297568904.10002)
,p_name=>'Handle Gantt Chart Link'
,p_event_sequence=>20
,p_triggering_element_type=>'REGION'
,p_triggering_region_id=>wwv_flow_imp.id(20578425049116510.10002)
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'custom'
,p_bind_event_type_custom=>'ojoptionchange'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(17501330575568905.10002)
,p_event_id=>wwv_flow_imp.id(17501215297568904.10002)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_JAVASCRIPT_CODE'
,p_attribute_01=>wwv_flow_string.join(wwv_flow_t_varchar2(
'try {',
'  var data = this.data;',
'  //check which data is avilable from Gantt Chart',
'  //console.log(data);',
'  var lTaskId;',
'  // check if selection is changed',
'  if (data.option === "selection") {',
'    // get current selection',
'    // This gives column value selected at "Gantt Chart > Series > Column Mapping > Task ID"',
'    lTaskId = data.value[0];',
'    // Set Task id to hidden page item and submit the page with EDIT_TASK request',
'    apex.page.submit({',
'      request: "EDIT_TASK",',
'      set: {',
'        "P7_TASK_ID": lTaskId',
'      },',
'      showWait: false',
'    });',
'  }',
'} catch (err) {',
'  apex.message.clearErrors();',
'  apex.message.showErrors({',
'    type: "error",',
'    location: "page",',
'    message: "JavaScript Error" + err.message,',
'    unsafe: false',
'  });',
'}'))
);
wwv_flow_imp_page.create_page_da_event(
 p_id=>wwv_flow_imp.id(19128200806169030.10002)
,p_name=>'Handle Gantt Chart Link for Gantt Concise'
,p_event_sequence=>30
,p_triggering_element_type=>'REGION'
,p_triggering_region_id=>wwv_flow_imp.id(20579160720116517.10002)
,p_bind_type=>'bind'
,p_execution_type=>'IMMEDIATE'
,p_bind_event_type=>'custom'
,p_bind_event_type_custom=>'ojoptionchange'
);
wwv_flow_imp_page.create_page_da_action(
 p_id=>wwv_flow_imp.id(19128338872169031.10002)
,p_event_id=>wwv_flow_imp.id(19128200806169030.10002)
,p_event_result=>'TRUE'
,p_action_sequence=>10
,p_execute_on_page_init=>'N'
,p_action=>'NATIVE_JAVASCRIPT_CODE'
,p_attribute_01=>wwv_flow_string.join(wwv_flow_t_varchar2(
'try {',
'  var data = this.data;',
'  //check which data is avilable from Gantt Chart',
'  //console.log(data);',
'  var lTaskId;',
'  // check if selection is changed',
'  if (data.option === "selection") {',
'    // get current selection',
'    // This gives column value selected at "Gantt Chart > Series > Column Mapping > Task ID"',
'    lTaskId = data.value[0];',
'    // Set Task id to hidden page item and submit the page with EDIT_TASK request',
'    apex.page.submit({',
'      request: "EDIT_TASK",',
'      set: {',
'        "P7_TASK_ID": lTaskId',
'      },',
'      showWait: false',
'    });',
'  }',
'} catch (err) {',
'  apex.message.clearErrors();',
'  apex.message.showErrors({',
'    type: "error",',
'    location: "page",',
'    message: "JavaScript Error" + err.message,',
'    unsafe: false',
'  });',
'}'))
);
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=>10002
,p_default_id_offset=>0
,p_default_owner=>'STUDENT'
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19126231005169010.10002)
,p_process_sequence=>10
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_imp.id(18533660019824642.10002)
,p_process_type=>'NATIVE_IG_DML'
,p_process_name=>'Task - Save Interactive Grid Data'
,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=>19126231005169010.10002
);
wwv_flow_imp_page.create_page_process(
 p_id=>wwv_flow_imp.id(19127482657169022.10002)
,p_process_sequence=>20
,p_process_point=>'AFTER_SUBMIT'
,p_region_id=>wwv_flow_imp.id(18533660019824642.10002)
,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',
'    IF (:APEX$ROW_STATUS = ''U'') THEN',
'        UPDATE',
'            stdt_tasks st',
'        SET',
'            last_update_date = LOCALTIMESTAMP,',
'            last_updated_by = :APP_USER',
'        WHERE',
'            task_id = :TASK_ID;',
'    END IF;',
'',
'END;'))
,p_process_clob_language=>'PLSQL'
,p_error_display_location=>'INLINE_IN_NOTIFICATION'
,p_internal_uid=>19127482657169022.10002
);
wwv_flow_imp.component_end;
end;
/
