eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_GL_POST_PROCESS_PKG dependencies on GL_PERIOD_STATUSES

Line 5192: FROM GL_PERIOD_STATUSES per

5188: SELECT per.END_DATE
5189: , per.EFFECTIVE_PERIOD_NUM
5190: INTO pv_from_date
5191: , pv_from_period_eff_num
5192: FROM GL_PERIOD_STATUSES per
5193: WHERE per.APPLICATION_ID = 101
5194: AND per.LEDGER_ID = pv_ledger_id
5195: AND per.PERIOD_NAME = p_from_period;
5196: EXCEPTION

Line 5238: FROM GL_PERIOD_STATUSES per

5234: AND per.END_DATE)
5235: INTO pv_to_date
5236: , pv_to_period_eff_num
5237: , v_dummy_flag
5238: FROM GL_PERIOD_STATUSES per
5239: WHERE per.APPLICATION_ID = 101
5240: AND per.LEDGER_ID = pv_ledger_id
5241: AND per.PERIOD_NAME = p_to_period;
5242: EXCEPTION

Line 5367: FROM GL_PERIOD_STATUSES per

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
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

Line 5433: FROM GL_PERIOD_STATUSES per

5429: , 'P', NULL
5430: , 'INVALID_PERIOD_STATUS')
5431: , 0
5432: , 0
5433: FROM GL_PERIOD_STATUSES per
5434: WHERE per.APPLICATION_ID = 101
5435: AND per.LEDGER_ID = pv_ledger_id
5436: AND per.EFFECTIVE_PERIOD_NUM BETWEEN pv_from_period_eff_num
5437: AND pv_to_period_eff_num;

Line 5472: FROM GL_PERIOD_STATUSES per

5468: -- code if period's period year greater than the latest opened period
5469: -- year of the Budget
5470: , 0
5471: , 0
5472: FROM GL_PERIOD_STATUSES per
5473: , FEM_INTG_BAL_DEF_BUDGTS bget
5474: , FEM_INTG_BUDGT_DS bgetDS
5475: -- Bug 4394404 hkaniven start - to get the latest opened year of each
5476: -- budget

Line 5524: FROM GL_PERIOD_STATUSES per

5520: -- Bug 4394404 hkaniven end - populate 'INVALID_PERIOD_STATUS' error
5521: -- code if period's period year greater than the latest encumbrance year
5522: , 0
5523: , 0
5524: FROM GL_PERIOD_STATUSES per
5525: , FEM_INTG_BAL_DEF_ENCS encType
5526: , FEM_INTG_ENC_TYPE_DS encTypeDS
5527: -- Bug 4394404 hkaniven start - to get latest encumbrance year
5528: , GL_LEDGERS glgr

Line 5597: , GL_PERIOD_STATUSES per

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
5599: AND dl.DATASET_CODE <> pv_dataset_code
5600: AND dl.SOURCE_SYSTEM_CODE = pv_gl_source_system_code
5601: AND dl.TABLE_NAME = 'FEM_BALANCES'

Line 6024: , GL_PERIOD_STATUSES per

6020: , gt.PERIOD_NAME
6021: , gt.EFFECTIVE_PERIOD_NUM
6022: , per.END_DATE
6023: FROM FEM_INTG_EXEC_PARAMS_GT gt
6024: , GL_PERIOD_STATUSES per
6025: WHERE gt.ERROR_CODE IS NULL
6026: AND gt.OUTPUT_DATASET_CODE = p_dataset_code
6027: AND per.PERIOD_NAME = gt.PERIOD_NAME
6028: AND per.APPLICATION_ID = 101

Line 6043: v_first_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;

6039: v_last_load_cal_per_id fem_pl_requests.cal_period_id%TYPE;
6040: v_cal_per_name fem_cal_periods_tl.cal_period_name%TYPE;
6041: v_cal_per_num fem_cal_periods_attr.number_assign_value%TYPE;
6042: v_cal_per_year fem_cal_periods_attr.number_assign_value%TYPE;
6043: v_first_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6044: v_last_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6045: v_first_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6046: v_last_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6047: v_min_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;

Line 6044: v_last_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;

6040: v_cal_per_name fem_cal_periods_tl.cal_period_name%TYPE;
6041: v_cal_per_num fem_cal_periods_attr.number_assign_value%TYPE;
6042: v_cal_per_year fem_cal_periods_attr.number_assign_value%TYPE;
6043: v_first_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6044: v_last_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6045: v_first_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6046: v_last_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6047: v_min_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6048: v_max_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;

Line 6045: v_first_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;

6041: v_cal_per_num fem_cal_periods_attr.number_assign_value%TYPE;
6042: v_cal_per_year fem_cal_periods_attr.number_assign_value%TYPE;
6043: v_first_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6044: v_last_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6045: v_first_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6046: v_last_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6047: v_min_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6048: v_max_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6049: v_any_period_gap VARCHAR2(1);

Line 6046: v_last_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;

6042: v_cal_per_year fem_cal_periods_attr.number_assign_value%TYPE;
6043: v_first_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6044: v_last_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6045: v_first_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6046: v_last_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6047: v_min_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6048: v_max_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6049: v_any_period_gap VARCHAR2(1);
6050:

Line 6047: v_min_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;

6043: v_first_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6044: v_last_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6045: v_first_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6046: v_last_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6047: v_min_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6048: v_max_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6049: v_any_period_gap VARCHAR2(1);
6050:
6051: v_load_method fem_intg_exec_params_gt.load_method_code%TYPE;

Line 6048: v_max_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;

6044: v_last_load_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6045: v_first_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6046: v_last_reg_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6047: v_min_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6048: v_max_valid_eff_per_num gl_period_statuses.effective_period_num%TYPE;
6049: v_any_period_gap VARCHAR2(1);
6050:
6051: v_load_method fem_intg_exec_params_gt.load_method_code%TYPE;
6052: v_dummy_flag VARCHAR2(1);

Line 6282: FROM GL_PERIOD_STATUSES

6278:
6279: -- Find the corresponding GL Effective Period Number
6280: SELECT effective_period_num
6281: INTO v_first_load_eff_per_num
6282: FROM GL_PERIOD_STATUSES
6283: WHERE APPLICATION_ID = 101
6284: AND LEDGER_ID = pv_ledger_id
6285: AND PERIOD_YEAR = v_cal_per_year
6286: AND PERIOD_NUM = v_cal_per_num;

Line 6409: FROM GL_PERIOD_STATUSES

6405:
6406: -- Find the corresponding GL Effective Period Number
6407: SELECT effective_period_num
6408: INTO v_last_load_eff_per_num
6409: FROM GL_PERIOD_STATUSES
6410: WHERE APPLICATION_ID = 101
6411: AND LEDGER_ID = pv_ledger_id
6412: AND PERIOD_YEAR = v_cal_per_year
6413: AND PERIOD_NUM = v_cal_per_num;

Line 6437: FROM GL_PERIOD_STATUSES

6433: INTO v_any_period_gap
6434: FROM DUAL
6435: WHERE EXISTS
6436: (SELECT 'Period gap exists'
6437: FROM GL_PERIOD_STATUSES
6438: WHERE LEDGER_ID = pv_ledger_id
6439: AND APPLICATION_ID = 101
6440: AND ((v_first_load_eff_per_num > v_max_valid_eff_per_num
6441: AND EFFECTIVE_PERIOD_NUM > v_max_valid_eff_per_num

Line 6823: FROM GL_PERIOD_STATUSES

6819: INTO v_any_period_gap
6820: FROM DUAL
6821: WHERE EXISTS
6822: (SELECT 'Period gap exists'
6823: FROM GL_PERIOD_STATUSES
6824: WHERE LEDGER_ID = pv_ledger_id
6825: AND APPLICATION_ID = 101
6826: AND ((v_first_load_eff_per_num > v_last_reg_eff_per_num
6827: AND EFFECTIVE_PERIOD_NUM > v_last_reg_eff_per_num