[Home] [Help]
7710: | Src_Sys_select_stmt
7711: |
7712: | DESCRIPTION
7713: | Identifies the Source System Codes for the load
7714: | specifically, for the purposes of updating FEM_DIM_LOAD_STATUS
7715: | after the load is complete
7716: | SCOPE - PRIVATE
7717: |
7718: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
13396:
13397: ----------------------------------------------------------------------
13398: -- Post Dimension Status (called by Main)
13399: --
13400: -- This procedure puts an entry into FEM_DIM_LOAD_STATUS
13401: -- for each source system code in the load
13402: --
13403: -- If # of records in source attr table =0, the entry is 'INCOMPLETE'
13404: -- Otherwise, it is 'INCOMPLETE'
13433: WHEN no_data_found THEN
13434: RAISE e_invalid_src_sys;
13435: END;
13436:
13437: -- Is there an existing status row in FEM_DIM_LOAD_STATUS
13438: -- for the Source System Code and Dimension combination?
13439: SELECT count(*)
13440: INTO v_status_count
13441: FROM fem_dim_load_status
13437: -- Is there an existing status row in FEM_DIM_LOAD_STATUS
13438: -- for the Source System Code and Dimension combination?
13439: SELECT count(*)
13440: INTO v_status_count
13441: FROM fem_dim_load_status
13442: WHERE dimension_id = p_dimension_id
13443: AND source_system_code = v_source_system_code;
13444:
13445: -- Check the record count in the source ATTR_T table
13458: ELSE v_dim_load_status := 'INCOMPLETE';
13459: END IF;
13460:
13461: IF v_status_count = 0 THEN
13462: INSERT INTO fem_dim_load_status (DIMENSION_ID
13463: ,SOURCE_SYSTEM_CODE
13464: ,LOAD_STATUS
13465: ,REPROCESS_ERRORS_FLAG
13466: ,CREATION_DATE
13480: ,gv_login_id
13481: ,1
13482: FROM dual;
13483: ELSE
13484: UPDATE fem_dim_load_status
13485: SET load_status = v_dim_load_status,
13486: last_updated_by = gv_apps_user_id,
13487: last_update_date = sysdate,
13488: last_update_login = gv_login_id
16735:
16736: END IF; -- Simple Dimension Flag = 'N' (for Attr validation and Attr Update)
16737:
16738: ----------------------------------------------------------------------------------
16739: -- Post Dimension Member load status to FEM_DIM_LOAD_STATUS
16740: ----------------------------------------------------------------------------------
16741: IF v_simple_dimension_flag = 'N' THEN
16742: v_src_sys_last_row := NVL(tg_src_system_dc.LAST,0);
16743: FEM_ENGINES_PKG.TECH_MESSAGE