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=>10001 ,p_default_id_offset=>0 ,p_default_owner=>'STUDENT' ); wwv_flow_imp_page.create_page( p_id=>7 ,p_name=>'Task' ,p_alias=>'TASK' ,p_step_title=>'Task' ,p_autocomplete_on_off=>'OFF' ,p_page_template_options=>'#DEFAULT#' ,p_protection_level=>'C' ,p_page_component_map=>'21' ,p_last_updated_by=>'STUDENT_DEV' ,p_last_upd_yyyymmddhh24miss=>'20230908173153' ); wwv_flow_imp_page.create_page_plug( p_id=>wwv_flow_imp.id(19124456792160600) ,p_plug_name=>'Task' ,p_icon_css_classes=>'app-icon' ,p_region_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_imp.id(16094697015514771) ,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) ,p_plug_name=>'Task Calendar' ,p_region_template_options=>'#DEFAULT#:js-showMaximizeButton:i-h640:t-Region--scrollBody' ,p_escape_on_http_output=>'Y' ,p_plug_template=>wwv_flow_imp.id(16116793714514810) ,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', ' ST.TASK_ID,', ' ST.TASK_NAME,', ' ST.TASK_DESCRIPTION,', ' ST.SUBJECT_ID,', ' ST.START_DATE,', ' ST.END_DATE,', ' ST.COMPLETION_PERCENT,', ' ST.CREATED_BY,', ' ST.CREATION_DATE,', ' ST.LAST_UPDATED_BY,', ' ST.LAST_UPDATE_DATE,', ' ST.STUDENT_ID,', ' ST.TERM_ID,', ' ST.TENANT_ID,', ' CASE', ' WHEN (ST.COMPLETION_PERCENT = 100) THEN ''apex-cal-green''', ' WHEN (SYSDATE >= ST.END_DATE + 1 AND ST.COMPLETION_PERCENT <> 100) THEN ''apex-cal-red''', ' ELSE NVL(SS.CALENDAR_COLOR, ''apex-cal-black'')', ' END css_class,', ' CASE', unistr(' WHEN (ST.COMPLETION_PERCENT = 100) THEN ''[\5B8C\6210] '''), unistr(' WHEN (SYSDATE >= ST.END_DATE + 1 AND ST.COMPLETION_PERCENT <> 100) THEN ''[\8D85\65F6] '''), ' END', ' || ''['' || SUBSTR(SS.SUBJECT_NAME, 1, 1) || '']''', ' || ST.TASK_NAME || '' - '' || TO_CHAR(ST.COMPLETION_PERCENT) || ''%''', ' ||', ' CASE', ' WHEN ST.IMAGE_01 IS NULL', ' AND ST.IMAGE_02 IS NULL', ' AND ST.IMAGE_03 IS NULL', ' AND ST.IMAGE_04 IS NULL', ' AND ST.IMAGE_05 IS NULL THEN', ' NULL', ' ELSE', ' '' <''', ' ||', ' (TO_NUMBER(CASE', ' WHEN ST.IMAGE_01 IS NOT NULL THEN', ' 1', ' ELSE', ' 0', ' END)', ' +', ' TO_NUMBER(CASE', ' WHEN ST.IMAGE_02 IS NOT NULL THEN', ' 1', ' ELSE', ' 0', ' END)', ' +', ' TO_NUMBER(CASE', ' WHEN ST.IMAGE_03 IS NOT NULL THEN', ' 1', ' ELSE', ' 0', ' END)', ' +', ' TO_NUMBER(CASE', ' WHEN ST.IMAGE_04 IS NOT NULL THEN', ' 1', ' ELSE', ' 0', ' END)', ' +', ' TO_NUMBER(CASE', ' WHEN ST.IMAGE_05 IS NOT NULL THEN', ' 1', ' ELSE', ' 0', ' END))', ' ||', unistr(' ''\4E2A\9644\4EF6>'''), ' END as task_display', 'FROM STDT_TASKS st,', ' STDT_SUBJECTS ss', 'WHERE 1 = 1', 'AND ST.SUBJECT_ID = SS.SUBJECT_ID (+)', 'AND ST.tenant_id = (SELECT tenant_id', ' FROM stdt_users su', ' WHERE su.user_name = :APP_USER)', 'ORDER BY SS.SUBJECT_ID')) ,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.::P8_START_DATE,P8_END_DATE:&APEX$NEW_START_DATE.,&APEX$NEW_END_DATE.' ,p_attribute_07=>'Y' ,p_attribute_08=>wwv_flow_string.join(wwv_flow_t_varchar2( 'BEGIN', '', ' UPDATE stdt_tasks st', ' SET st.start_date = TRUNC(to_date(:APEX$NEW_START_DATE, ''YYYYMMDDHH24MISS'')),', ' st.end_date = TRUNC(to_date(:APEX$NEW_END_DATE, ''YYYYMMDDHH24MISS'')) - 1', ' WHERE st.task_id = :APEX$PK_VALUE;', '', 'END;')) ,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) ,p_plug_name=>'Task Data' ,p_region_template_options=>'#DEFAULT#:t-Region--hideShowIconsMath:is-collapsed:t-Region--scrollBody' ,p_plug_template=>wwv_flow_imp.id(16080935615514698) ,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) ,p_plug_name=>'Task' ,p_parent_plug_id=>wwv_flow_imp.id(19125980031169007) ,p_region_template_options=>'#DEFAULT#' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_imp.id(16112462865514800) ,p_plug_display_sequence=>10 ,p_plug_display_point=>'SUB_REGIONS' ,p_query_type=>'TABLE' ,p_query_table=>'STDT_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=>'Task' ,p_prn_page_header_font_color=>'#000000' ,p_prn_page_header_font_family=>'Helvetica' ,p_prn_page_header_font_weight=>'normal' ,p_prn_page_header_font_size=>'12' ,p_prn_page_footer_font_color=>'#000000' ,p_prn_page_footer_font_family=>'Helvetica' ,p_prn_page_footer_font_weight=>'normal' ,p_prn_page_footer_font_size=>'12' ,p_prn_header_bg_color=>'#EEEEEE' ,p_prn_header_font_color=>'#000000' ,p_prn_header_font_family=>'Helvetica' ,p_prn_header_font_weight=>'bold' ,p_prn_header_font_size=>'10' ,p_prn_body_bg_color=>'#FFFFFF' ,p_prn_body_font_color=>'#000000' ,p_prn_body_font_family=>'Helvetica' ,p_prn_body_font_weight=>'normal' ,p_prn_body_font_size=>'10' ,p_prn_border_width=>.5 ,p_prn_page_header_alignment=>'CENTER' ,p_prn_page_footer_alignment=>'CENTER' ,p_prn_border_color=>'#666666' ); wwv_flow_imp_page.create_region_column( p_id=>wwv_flow_imp.id(18533865392824644) ,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) ,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=>'Task Name' ,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) ,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=>'Task Description' ,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) ,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=>'Subject' ,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) ,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=>'Start Date' ,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) ,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=>'End Date' ,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) ,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=>'Completion Percent' ,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) ,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) ,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) ,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) ,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) ,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=>'Student' ,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) ,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=>'Term' ,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) ,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) ,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) ,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) ,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_ig_report( p_id=>wwv_flow_imp.id(19131667740187913) ,p_interactive_grid_id=>wwv_flow_imp.id(18533761496824643) ,p_static_id=>'191317' ,p_type=>'PRIMARY' ,p_default_view=>'GRID' ,p_show_row_number=>false ,p_settings_area_expanded=>true ); wwv_flow_imp_page.create_ig_report_view( p_id=>wwv_flow_imp.id(19131860786187914) ,p_report_id=>wwv_flow_imp.id(19131667740187913) ,p_view_type=>'GRID' ,p_stretch_columns=>true ,p_srv_exclude_null_values=>false ,p_srv_only_display_columns=>true ,p_edit_mode=>false ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19132303876187925) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>1 ,p_column_id=>wwv_flow_imp.id(18533865392824644) ,p_is_visible=>true ,p_is_frozen=>false ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19133214237187938) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>2 ,p_column_id=>wwv_flow_imp.id(18533972708824645) ,p_is_visible=>true ,p_is_frozen=>false ,p_width=>120 ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19134137173187947) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>3 ,p_column_id=>wwv_flow_imp.id(18534032435824646) ,p_is_visible=>true ,p_is_frozen=>false ,p_width=>200 ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19135005200187954) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>6 ,p_column_id=>wwv_flow_imp.id(18534177551824647) ,p_is_visible=>true ,p_is_frozen=>false ,p_width=>100 ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19135933851187961) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>8 ,p_column_id=>wwv_flow_imp.id(18534200964824648) ,p_is_visible=>true ,p_is_frozen=>false ,p_width=>100 ,p_sort_order=>1 ,p_sort_direction=>'DESC' ,p_sort_nulls=>'FIRST' ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19136881354187968) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>8 ,p_column_id=>wwv_flow_imp.id(18534340282824649) ,p_is_visible=>true ,p_is_frozen=>false ,p_width=>100 ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19137741206187975) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>12 ,p_column_id=>wwv_flow_imp.id(18534401381824650) ,p_is_visible=>true ,p_is_frozen=>false ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19138607406187992) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>8 ,p_column_id=>wwv_flow_imp.id(19125366862169001) ,p_is_visible=>true ,p_is_frozen=>false ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19139476212188006) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>9 ,p_column_id=>wwv_flow_imp.id(19125466121169002) ,p_is_visible=>true ,p_is_frozen=>false ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19140386381188014) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>10 ,p_column_id=>wwv_flow_imp.id(19125597395169003) ,p_is_visible=>true ,p_is_frozen=>false ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19141207644188022) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>11 ,p_column_id=>wwv_flow_imp.id(19125622921169004) ,p_is_visible=>true ,p_is_frozen=>false ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19142107004188029) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>4 ,p_column_id=>wwv_flow_imp.id(19125737366169005) ,p_is_visible=>true ,p_is_frozen=>false ,p_width=>80 ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19143069392188040) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>5 ,p_column_id=>wwv_flow_imp.id(19125886420169006) ,p_is_visible=>true ,p_is_frozen=>false ,p_width=>160 ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19144849164188997) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>0 ,p_column_id=>wwv_flow_imp.id(19126091717169008) ,p_is_visible=>true ,p_is_frozen=>true ,p_width=>40 ); wwv_flow_imp_page.create_ig_report_column( p_id=>wwv_flow_imp.id(19717285019545206) ,p_view_id=>wwv_flow_imp.id(19131860786187914) ,p_display_seq=>13 ,p_column_id=>wwv_flow_imp.id(19446983702876438) ,p_is_visible=>true ,p_is_frozen=>false ); wwv_flow_imp_page.create_page_plug( p_id=>wwv_flow_imp.id(20578384400116509) ,p_plug_name=>'Region Display Selector' ,p_region_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_imp.id(16062384265514656) ,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) ,p_plug_name=>'Gantt Chart' ,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) ,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) ,p_region_id=>wwv_flow_imp.id(20578425049116510) ,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) ,p_chart_id=>wwv_flow_imp.id(20578519770116511) ,p_seq=>10 ,p_name=>'Tasks' ,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) ,p_chart_id=>wwv_flow_imp.id(20578519770116511) ,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) ,p_chart_id=>wwv_flow_imp.id(20578519770116511) ,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) ,p_plug_name=>'Gantt Chart (Concise)' ,p_region_template_options=>'#DEFAULT#:js-showMaximizeButton:t-Region--scrollBody' ,p_escape_on_http_output=>'Y' ,p_plug_template=>wwv_flow_imp.id(16116793714514810) ,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) ,p_region_id=>wwv_flow_imp.id(20579160720116517) ,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) ,p_chart_id=>wwv_flow_imp.id(20579290395116518) ,p_seq=>10 ,p_name=>'Tasks' ,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) ,p_chart_id=>wwv_flow_imp.id(20579290395116518) ,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) ,p_chart_id=>wwv_flow_imp.id(20579290395116518) ,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.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_branch( p_id=>wwv_flow_imp.id(17501440186568906) ,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) ,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) ,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) ,p_event_id=>wwv_flow_imp.id(19126534726169013) ,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) ); wwv_flow_imp_page.create_page_da_event( p_id=>wwv_flow_imp.id(17501215297568904) ,p_name=>'Handle Gantt Chart Link' ,p_event_sequence=>20 ,p_triggering_element_type=>'REGION' ,p_triggering_region_id=>wwv_flow_imp.id(20578425049116510) ,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) ,p_event_id=>wwv_flow_imp.id(17501215297568904) ,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) ,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) ,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) ,p_event_id=>wwv_flow_imp.id(19128200806169030) ,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_process( p_id=>wwv_flow_imp.id(19126231005169010) ,p_process_sequence=>10 ,p_process_point=>'AFTER_SUBMIT' ,p_region_id=>wwv_flow_imp.id(18533660019824642) ,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 ); wwv_flow_imp_page.create_page_process( p_id=>wwv_flow_imp.id(19127482657169022) ,p_process_sequence=>20 ,p_process_point=>'AFTER_SUBMIT' ,p_region_id=>wwv_flow_imp.id(18533660019824642) ,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 ); wwv_flow_imp.component_end; end; /