prompt --application/pages/page_00002 begin -- Manifest -- PAGE: 00002 -- 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=>2.10002 ,p_name=>unistr('\5B66\751F') ,p_alias=>'STUDENT' ,p_step_title=>unistr('\5B66\751F') ,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(18457370834328972.10002) ,p_plug_name=>unistr('\5B66\751F') ,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(18457966815328975.10002) ,p_plug_name=>unistr('\5B66\751F') ,p_region_template_options=>'#DEFAULT#' ,p_component_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_imp.id(16112462865514800.10002) ,p_plug_display_sequence=>20 ,p_plug_new_grid_row=>false ,p_query_type=>'SQL' ,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2( 'select STUDENT_ID,', ' STUDENT_NAME,', ' CREATED_BY,', ' CREATION_DATE,', ' LAST_UPDATED_BY,', ' LAST_UPDATE_DATE,', ' ENABLED,', ' AVATAR_MIME_TYPE,', ' AVATAR_FILE_NAME,', ' AGE,', ' GRADE,', ' TENANT_ID,', ' apex_util.get_blob_file_src(''P6_AVATAR'',STUDENT_ID) IMAGE_HIDDEN,', ' null IMAGE_DISPLAY', ' from STDT_STUDENTS', ' where 1 = 1', ' and NVL(deleted_flag, ''N'') <> ''Y''', ' and tenant_id = (SELECT tenant_id', ' FROM stdt_users su', ' WHERE su.user_name = :APP_USER)')) ,p_plug_source_type=>'NATIVE_IG' ,p_prn_page_header=>unistr('\5B66\751F') ); wwv_flow_imp_page.create_region_column( p_id=>wwv_flow_imp.id(18414813501791223.10002) ,p_name=>'UPLOAD_IMAGE' ,p_source_type=>'NONE' ,p_session_state_data_type=>'VARCHAR2' ,p_item_type=>'NATIVE_HIDDEN' ,p_display_sequence=>110 ,p_attribute_01=>'Y' ,p_use_as_row_header=>false ); wwv_flow_imp_page.create_region_column( p_id=>wwv_flow_imp.id(18459214143328998.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 ,p_enable_hide=>true ,p_is_primary_key=>false ); wwv_flow_imp_page.create_region_column( p_id=>wwv_flow_imp.id(18459659925328999.10002) ,p_name=>'APEX$ROW_ACTION' ,p_item_type=>'NATIVE_ROW_ACTION' ,p_label=>unistr('\64CD\4F5C') ,p_heading_alignment=>'CENTER' ,p_display_sequence=>20 ,p_value_alignment=>'CENTER' ,p_use_as_row_header=>false ,p_enable_hide=>true ,p_is_primary_key=>false ); wwv_flow_imp_page.create_region_column( p_id=>wwv_flow_imp.id(18460601809329010.10002) ,p_name=>'STUDENT_ID' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'STUDENT_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_enable_filter=>false ,p_use_as_row_header=>false ,p_enable_hide=>true ,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(18461614351329015.10002) ,p_name=>'STUDENT_NAME' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'STUDENT_NAME' ,p_data_type=>'VARCHAR2' ,p_session_state_data_type=>'VARCHAR2' ,p_is_query_only=>false ,p_item_type=>'NATIVE_TEXTAREA' ,p_heading=>unistr('\5B66\751F\59D3\540D') ,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_exact_match=>true ,p_filter_lov_type=>'NONE' ,p_use_as_row_header=>false ,p_enable_sort_group=>false ,p_enable_control_break=>false ,p_enable_hide=>true ,p_enable_pivot=>false ,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(18463609325329019.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=>60 ,p_attribute_01=>'Y' ,p_filter_is_required=>false ,p_use_as_row_header=>false ,p_enable_sort_group=>false ,p_enable_pivot=>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(18464614194329020.10002) ,p_name=>'CREATION_DATE' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'CREATION_DATE' ,p_data_type=>'TIMESTAMP' ,p_session_state_data_type=>'VARCHAR2' ,p_is_query_only=>false ,p_item_type=>'NATIVE_HIDDEN' ,p_display_sequence=>70 ,p_attribute_01=>'Y' ,p_filter_is_required=>false ,p_use_as_row_header=>false ,p_enable_sort_group=>false ,p_enable_pivot=>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(18465620152329022.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=>80 ,p_attribute_01=>'Y' ,p_filter_is_required=>false ,p_use_as_row_header=>false ,p_enable_sort_group=>false ,p_enable_pivot=>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(18466647445329024.10002) ,p_name=>'LAST_UPDATE_DATE' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'LAST_UPDATE_DATE' ,p_data_type=>'TIMESTAMP' ,p_session_state_data_type=>'VARCHAR2' ,p_is_query_only=>false ,p_item_type=>'NATIVE_HIDDEN' ,p_display_sequence=>90 ,p_attribute_01=>'Y' ,p_filter_is_required=>false ,p_use_as_row_header=>false ,p_enable_sort_group=>false ,p_enable_pivot=>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(18467699928329026.10002) ,p_name=>'ENABLED' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'ENABLED' ,p_data_type=>'VARCHAR2' ,p_is_query_only=>false ,p_item_type=>'NATIVE_SINGLE_CHECKBOX' ,p_heading=>unistr('\662F\5426\6709\6548') ,p_heading_alignment=>'CENTER' ,p_display_sequence=>100 ,p_value_alignment=>'CENTER' ,p_attribute_01=>'N' ,p_attribute_02=>'Y' ,p_attribute_03=>'N' ,p_is_required=>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=>'DISTINCT' ,p_use_as_row_header=>false ,p_enable_sort_group=>true ,p_enable_control_break=>true ,p_enable_hide=>true ,p_enable_pivot=>false ,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(18531155917824617.10002) ,p_name=>'AGE' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'AGE' ,p_data_type=>'NUMBER' ,p_is_query_only=>false ,p_item_type=>'NATIVE_NUMBER_FIELD' ,p_heading=>unistr('\5E74\9F84') ,p_heading_alignment=>'LEFT' ,p_display_sequence=>140 ,p_value_alignment=>'LEFT' ,p_attribute_03=>'left' ,p_attribute_04=>'decimal' ,p_is_required=>false ,p_enable_filter=>true ,p_filter_is_required=>false ,p_filter_lov_type=>'NONE' ,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(18531265390824618.10002) ,p_name=>'GRADE' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'GRADE' ,p_data_type=>'VARCHAR2' ,p_is_query_only=>false ,p_item_type=>'NATIVE_TEXT_FIELD' ,p_heading=>unistr('\5E74\7EA7') ,p_heading_alignment=>'LEFT' ,p_display_sequence=>150 ,p_value_alignment=>'LEFT' ,p_attribute_05=>'BOTH' ,p_is_required=>false ,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_exact_match=>true ,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(19446092734876429.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_region_column( p_id=>wwv_flow_imp.id(19446590832876434.10002) ,p_name=>'AVATAR_MIME_TYPE' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'AVATAR_MIME_TYPE' ,p_data_type=>'VARCHAR2' ,p_session_state_data_type=>'VARCHAR2' ,p_is_query_only=>false ,p_item_type=>'NATIVE_HIDDEN' ,p_display_sequence=>180 ,p_attribute_01=>'Y' ,p_filter_is_required=>false ,p_use_as_row_header=>false ,p_enable_sort_group=>false ,p_is_primary_key=>false ,p_duplicate_value=>true ,p_include_in_export=>false ); wwv_flow_imp_page.create_region_column( p_id=>wwv_flow_imp.id(19446666862876435.10002) ,p_name=>'AVATAR_FILE_NAME' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'AVATAR_FILE_NAME' ,p_data_type=>'VARCHAR2' ,p_session_state_data_type=>'VARCHAR2' ,p_is_query_only=>false ,p_item_type=>'NATIVE_HIDDEN' ,p_display_sequence=>190 ,p_attribute_01=>'Y' ,p_filter_is_required=>false ,p_use_as_row_header=>false ,p_enable_sort_group=>false ,p_is_primary_key=>false ,p_duplicate_value=>true ,p_include_in_export=>false ); wwv_flow_imp_page.create_region_column( p_id=>wwv_flow_imp.id(19447534244876444.10002) ,p_name=>'IMAGE_HIDDEN' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'IMAGE_HIDDEN' ,p_data_type=>'VARCHAR2' ,p_session_state_data_type=>'VARCHAR2' ,p_is_query_only=>true ,p_item_type=>'NATIVE_HIDDEN' ,p_display_sequence=>200 ,p_attribute_01=>'Y' ,p_use_as_row_header=>false ,p_enable_sort_group=>false ,p_is_primary_key=>false ,p_include_in_export=>false ); wwv_flow_imp_page.create_region_column( p_id=>wwv_flow_imp.id(19447644451876445.10002) ,p_name=>'AVATAR' ,p_source_type=>'DB_COLUMN' ,p_source_expression=>'IMAGE_DISPLAY' ,p_data_type=>'VARCHAR2' ,p_is_query_only=>true ,p_item_type=>'NATIVE_HTML_EXPRESSION' ,p_heading=>unistr('\5934\50CF') ,p_heading_alignment=>'CENTER' ,p_display_sequence=>210 ,p_value_alignment=>'CENTER' ,p_attribute_01=>'' ,p_link_target=>'f?p=&APP_ID.:6:&SESSION.::&DEBUG.::P6_STUDENT_ID:&STUDENT_ID.' ,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_include_in_export=>true ); wwv_flow_imp_page.create_interactive_grid( p_id=>wwv_flow_imp.id(18458487850328977.10002) ,p_internal_uid=>18458487850328977 ,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_enable_mail_download=>true ,p_fixed_header=>'PAGE' ,p_show_icon_view=>false ,p_show_detail_view=>false ); wwv_flow_imp_page.create_page_da_event( p_id=>wwv_flow_imp.id(18414948868791224.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 == "6"' ,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(18415074845791225.10002) ,p_event_id=>wwv_flow_imp.id(18414948868791224.10002) ,p_event_result=>'TRUE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'N' ,p_action=>'NATIVE_REFRESH' ,p_affected_elements_type=>'REGION' ,p_affected_region_id=>wwv_flow_imp.id(18457966815328975.10002) ); wwv_flow_imp_page.create_page_process( p_id=>wwv_flow_imp.id(18468671804329028.10002) ,p_process_sequence=>10 ,p_process_point=>'AFTER_SUBMIT' ,p_region_id=>wwv_flow_imp.id(18457966815328975.10002) ,p_process_type=>'NATIVE_IG_DML' ,p_process_name=>'Student - Save Interactive Grid Data' ,p_attribute_01=>'PLSQL_CODE' ,p_attribute_04=>wwv_flow_string.join(wwv_flow_t_varchar2( 'DECLARE', '', ' ln_student_id NUMBER;', '', 'BEGIN', '', ' IF (:APEX$ROW_STATUS = ''C'') THEN', '', ' SELECT "STDT_STUDENTS_SEQ".nextval', ' INTO ln_student_id', ' FROM dual;', '', ' INSERT INTO stdt_students(', ' student_id,', ' student_name,', ' age,', ' grade,', ' enabled,', ' created_by,', ' creation_date,', ' last_updated_by,', ' last_update_date,', ' tenant_id', ' )', ' VALUES(', ' ln_student_id, -- student_id,', ' :STUDENT_NAME, -- student_name,', ' :AGE, -- age,', ' :GRADE, -- grade,', ' :ENABLED, -- enabled,', ' :CREATED_BY, -- created_by,', ' :CREATION_DATE, -- creation_date,', ' :LAST_UPDATED_BY, -- last_updated_by,', ' :LAST_UPDATE_DATE, -- last_update_date,', ' :TENANT_ID -- tenant_id', ' )', ' RETURNING ln_student_id INTO :STUDENT_ID;', '', ' ELSIF (:APEX$ROW_STATUS = ''D'') THEN', '', ' -- Override delete operation, soft delete the row', ' UPDATE', ' stdt_students ss', ' SET', ' ss.deleted_flag = ''Y'',', ' ss.last_update_date = LOCALTIMESTAMP,', ' ss.last_updated_by = :APP_USER', ' WHERE', ' ss.student_id = :STUDENT_ID;', '', ' ELSIF (:APEX$ROW_STATUS = ''U'') THEN', '', ' -- Update operation', ' UPDATE', ' stdt_students ss', ' SET', ' ss.student_name = :STUDENT_NAME,', ' ss.age = :AGE,', ' ss.grade = :GRADE,', ' ss.enabled = :ENABLED,', ' ss.last_update_date = LOCALTIMESTAMP,', ' ss.last_updated_by = :APP_USER', ' WHERE', ' ss.student_id = :STUDENT_ID;', '', ' END IF;', '', 'END;')) ,p_attribute_05=>'Y' ,p_attribute_06=>'Y' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ,p_internal_uid=>18468671804329028.10002 ); wwv_flow_imp.component_end; end; /