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.GCS_IMPACT_WRITER_PKG dependencies on GCS_UTILITY_PKG

Line 33: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info := gcs_utility_pkg.g_dimension_attr_info;

29: TYPE t_ledger_period_bsv_info IS TABLE OF ldg_period_bsv_info_rec_type;
30: l_ledger_period_bsv_info t_ledger_period_bsv_info;
31: -- Eng Bugfix 5613525
32:
33: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info := gcs_utility_pkg.g_dimension_attr_info;
34:
35: CURSOR c_get_all_period_bsv_combos( p_ledger_id NUMBER,
36: p_cal_period_id NUMBER) -- Bugfix 5303024
37: IS

Line 69: AND fcpa.attribute_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id

65: FROM gcs_entities_attr gea,
66: fem_cal_periods_attr fcpa
67: WHERE gea.ledger_id = p_ledger_id
68: AND gea.data_type_code = DECODE(p_bal_type_code, 'A', 'ACTUAL', 'N/A')
69: AND fcpa.attribute_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
70: AND fcpa.version_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id
71: AND fcpa.cal_period_id = p_cal_period_id
72: AND fcpa.date_assign_value BETWEEN gea.effective_start_date
73: AND NVL(gea.effective_end_date, fcpa.date_assign_value);

Line 70: AND fcpa.version_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id

66: fem_cal_periods_attr fcpa
67: WHERE gea.ledger_id = p_ledger_id
68: AND gea.data_type_code = DECODE(p_bal_type_code, 'A', 'ACTUAL', 'N/A')
69: AND fcpa.attribute_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
70: AND fcpa.version_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id
71: AND fcpa.cal_period_id = p_cal_period_id
72: AND fcpa.date_assign_value BETWEEN gea.effective_start_date
73: AND NVL(gea.effective_end_date, fcpa.date_assign_value);
74:

Line 168: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id

164: AND fcpt.calendar_id = ficm.calendar_id
165: AND fcpt.dimension_group_id = ficm.dimension_group_id
166: AND ficm.period_set_name = gjb.period_set_name
167: AND ficm.period_type = gjb.accounted_period_type
168: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id
169: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id
170: AND fla.ledger_id = gjh.ledger_id
171: AND gvcd.global_vs_combo_id = fla.dim_attribute_numeric_member
172: AND gvcd.dimension_id = 8

Line 169: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id

165: AND fcpt.dimension_group_id = ficm.dimension_group_id
166: AND ficm.period_set_name = gjb.period_set_name
167: AND ficm.period_type = gjb.accounted_period_type
168: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id
169: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id
170: AND fla.ledger_id = gjh.ledger_id
171: AND gvcd.global_vs_combo_id = fla.dim_attribute_numeric_member
172: AND gvcd.dimension_id = 8
173: AND fsav.id_flex_num = gjb.chart_of_accounts_id

Line 254: AND fcpa.attribute_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id

250: fem_xdim_dimensions fxd,
251: fem_cal_periods_attr fcpa
252: WHERE fodb.object_id = fxd.default_mvs_hierarchy_obj_id
253: AND dimension_id = 8
254: AND fcpa.attribute_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
255: AND fcpa.version_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id
256: AND fcpa.cal_period_id = l_ledger_period_bsv_info(l_ledger_period_bsv_index).cal_period_id
257: AND fcpa.date_assign_value BETWEEN effective_start_date AND effective_end_date;
258:

Line 255: AND fcpa.version_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id

251: fem_cal_periods_attr fcpa
252: WHERE fodb.object_id = fxd.default_mvs_hierarchy_obj_id
253: AND dimension_id = 8
254: AND fcpa.attribute_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
255: AND fcpa.version_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id
256: AND fcpa.cal_period_id = l_ledger_period_bsv_info(l_ledger_period_bsv_index).cal_period_id
257: AND fcpa.date_assign_value BETWEEN effective_start_date AND effective_end_date;
258:
259: -- Append the extra filter clause here

Line 279: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id

275: SELECT dim_attribute_numeric_member
276: INTO l_company_id
277: FROM fem_cctr_orgs_attr fda
278: WHERE fda.company_cost_center_org_id = rec_list_of_orgs.company_cost_center_org_id
279: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
280: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id;
281:
282: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
283: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'l_company_id: '||l_company_id);

Line 280: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id;

276: INTO l_company_id
277: FROM fem_cctr_orgs_attr fda
278: WHERE fda.company_cost_center_org_id = rec_list_of_orgs.company_cost_center_org_id
279: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
280: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id;
281:
282: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
283: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'l_company_id: '||l_company_id);
284: END IF;