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 FEM_CAL_PERIODS_ATTR

Line 1743: FROM fem_cal_periods_attr

1739: END IF;
1740:
1741: SELECT date_assign_value
1742: INTO pv_cal_per_end_date
1743: FROM fem_cal_periods_attr
1744: WHERE attribute_id = pv_dim_attr_id
1745: AND version_id = pv_dim_attr_ver_id
1746: AND cal_period_id = pv_cal_period_id;
1747:

Line 1805: FROM fem_cal_periods_attr

1801: END IF;
1802:
1803: SELECT number_assign_value
1804: INTO pv_gl_per_number
1805: FROM fem_cal_periods_attr
1806: WHERE attribute_id = pv_dim_attr_id
1807: AND version_id = pv_dim_attr_ver_id
1808: AND cal_period_id = pv_cal_period_id;
1809:

Line 2712: FROM fem_cal_periods_attr

2708: END IF;
2709:
2710: SELECT date_assign_value
2711: INTO pv_cal_per_end_date
2712: FROM fem_cal_periods_attr
2713: WHERE attribute_id = pv_dim_attr_id
2714: AND version_id = pv_dim_attr_ver_id
2715: AND cal_period_id = pv_cal_period_id;
2716:

Line 2766: FROM fem_cal_periods_attr

2762: END IF;
2763:
2764: SELECT number_assign_value
2765: INTO pv_gl_per_number
2766: FROM fem_cal_periods_attr
2767: WHERE attribute_id = pv_dim_attr_id
2768: AND version_id = pv_dim_attr_ver_id
2769: AND cal_period_id = pv_cal_period_id;
2770:

Line 5595: , FEM_CAL_PERIODS_ATTR year

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
5599: AND dl.DATASET_CODE <> pv_dataset_code

Line 6041: v_cal_per_num fem_cal_periods_attr.number_assign_value%TYPE;

6037:
6038: v_first_load_cal_per_id fem_pl_requests.cal_period_id%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;

Line 6042: v_cal_per_year fem_cal_periods_attr.number_assign_value%TYPE;

6038: v_first_load_cal_per_id fem_pl_requests.cal_period_id%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;

Line 6205: FROM fem_cal_periods_attr

6201: END IF;
6202:
6203: SELECT number_assign_value
6204: INTO v_cal_per_num
6205: FROM fem_cal_periods_attr
6206: WHERE attribute_id = pv_dim_attr_id
6207: AND version_id = pv_dim_attr_ver_id
6208: AND cal_period_id = v_first_load_cal_per_id;
6209:

Line 6253: FROM fem_cal_periods_attr

6249: END IF;
6250:
6251: SELECT number_assign_value
6252: INTO v_cal_per_year
6253: FROM fem_cal_periods_attr
6254: WHERE attribute_id = pv_dim_attr_id
6255: AND version_id = pv_dim_attr_ver_id
6256: AND cal_period_id = v_first_load_cal_per_id;
6257:

Line 6332: FROM fem_cal_periods_attr

6328: END IF;
6329:
6330: SELECT number_assign_value
6331: INTO v_cal_per_num
6332: FROM fem_cal_periods_attr
6333: WHERE attribute_id = pv_dim_attr_id
6334: AND version_id = pv_dim_attr_ver_id
6335: AND cal_period_id = v_last_load_cal_per_id;
6336:

Line 6380: FROM fem_cal_periods_attr

6376: END IF;
6377:
6378: SELECT number_assign_value
6379: INTO v_cal_per_year
6380: FROM fem_cal_periods_attr
6381: WHERE attribute_id = pv_dim_attr_id
6382: AND version_id = pv_dim_attr_ver_id
6383: AND cal_period_id = v_last_load_cal_per_id;
6384: