[Home] [Help]
5360: INTO v_dummy_flag
5361: FROM DUAL
5362: WHERE EXISTS
5363: (SELECT 'Loaded'
5364: FROM FEM_DL_DIMENSIONS
5365: WHERE LEDGER_ID = pv_ledger_id
5366: AND EXISTS (SELECT 1
5367: FROM GL_PERIOD_STATUSES per
5368: WHERE per.APPLICATION_ID = 101
5366: AND EXISTS (SELECT 1
5367: FROM GL_PERIOD_STATUSES per
5368: WHERE per.APPLICATION_ID = 101
5369: AND per.LEDGER_ID = pv_ledger_id
5370: AND FEM_DL_DIMENSIONS.CAL_PERIOD_ID =
5371: FEM_DIMENSION_UTIL_PKG.Get_Cal_Period_ID( pv_ledger_id
5372: , 'OGL_'||per.PERIOD_TYPE
5373: , per.PERIOD_NUM
5374: , per.PERIOD_YEAR)
5590: UPDATE FEM_INTG_EXEC_PARAMS_GT gt
5591: SET ERROR_CODE = 'OTHER_DS_LOADED'
5592: WHERE EFFECTIVE_PERIOD_NUM IN
5593: (SELECT DISTINCT per.EFFECTIVE_PERIOD_NUM
5594: FROM FEM_DL_DIMENSIONS dl
5595: , FEM_CAL_PERIODS_ATTR year
5596: , FEM_DIM_ATTR_VERSIONS_B yearV
5597: , GL_PERIOD_STATUSES per
5598: WHERE dl.LEDGER_ID = pv_ledger_id
6137: -- For other balance types, get these for this Ledger/Dataset.
6138: SELECT NVL(min(CAL_PERIOD_ID), -1)
6139: , NVL(max(CAL_PERIOD_ID), -1)
6140: INTO v_first_load_cal_per_id, v_last_load_cal_per_id
6141: FROM FEM_DL_DIMENSIONS
6142: WHERE LEDGER_ID = pv_ledger_id
6143: -- 04-26-05: Changed to check balance_type_code only when the dataset
6144: -- balance type is ACTUAL
6145: AND ( (pv_ds_balance_type_cd = 'ACTUAL'
6535: -- Balances have been loaded before for this Ledger/Output
6536: -- Dataset, so we need to check if any balances have been loaded
6537: -- for this Ledger/Output Dataset/Cal Period
6538: BEGIN
6539: -- Bug fix 4170124: Changed to check FEM_DL_DIMENSIONS instead
6540: -- of FEM_PL_REQUESTS
6541: SELECT 'Y'
6542: INTO v_dummy_flag
6543: FROM DUAL
6542: INTO v_dummy_flag
6543: FROM DUAL
6544: WHERE EXISTS
6545: (SELECT 'Loaded'
6546: FROM FEM_DL_DIMENSIONS
6547: WHERE LEDGER_ID = pv_ledger_id
6548: AND CAL_PERIOD_ID = v_cp.cal_period_id
6549: AND DATASET_CODE = v_ds.output_dataset_code
6550: AND SOURCE_SYSTEM_CODE = pv_gl_source_system_code