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.

[Home] [Help]

APPS.GCS_CONS_IMPACT_ANALYSIS_PKG dependencies on GCS_UTILITY_PKG

Line 29: l_end_date_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

25: NVL(gcr.end_date, p_end_date);
26:
27: l_rows_updated NUMBER(1);
28: l_child_entity_id NUMBER(15);
29: l_end_date_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
30: .attribute_id;
31: l_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
32: .version_id;
33: l_period_num_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

Line 31: l_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

27: l_rows_updated NUMBER(1);
28: l_child_entity_id NUMBER(15);
29: l_end_date_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
30: .attribute_id;
31: l_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
32: .version_id;
33: l_period_num_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
34: .attribute_id;
35: l_period_num_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

Line 33: l_period_num_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

29: l_end_date_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
30: .attribute_id;
31: l_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
32: .version_id;
33: l_period_num_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
34: .attribute_id;
35: l_period_num_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
36: .version_id;
37: l_acct_year_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

Line 35: l_period_num_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

31: l_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
32: .version_id;
33: l_period_num_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
34: .attribute_id;
35: l_period_num_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
36: .version_id;
37: l_acct_year_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
38: .attribute_id;
39: l_acct_year_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

Line 37: l_acct_year_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

33: l_period_num_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
34: .attribute_id;
35: l_period_num_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
36: .version_id;
37: l_acct_year_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
38: .attribute_id;
39: l_acct_year_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
40: .version_id;
41: l_end_date DATE;

Line 39: l_acct_year_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

35: l_period_num_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
36: .version_id;
37: l_acct_year_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
38: .attribute_id;
39: l_acct_year_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
40: .version_id;
41: l_end_date DATE;
42: l_cal_period_id NUMBER;
43: l_target_cal_period_id NUMBER;

Line 50: l_cal_period_record gcs_utility_pkg.r_cal_period_info;

46: l_src_dimension_group_id NUMBER;
47: l_tgt_calendar_id NUMBER;
48: l_tgt_dimension_group_id NUMBER;
49: l_cal_period_map_id NUMBER;
50: l_cal_period_record gcs_utility_pkg.r_cal_period_info;
51:
52: BEGIN
53: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
54: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 131: gcs_utility_pkg.get_cal_period_details(p_cal_period_id,

127: g_api || '.ROLLUP_IMPACT',
128: '<< Calendar Period Mapping required >>');
129: END IF;
130:
131: gcs_utility_pkg.get_cal_period_details(p_cal_period_id,
132: l_cal_period_record);
133: SELECT fcpb.cal_period_id
134: INTO l_target_cal_period_id
135: FROM fem_cal_periods_b fcpb,

Line 358: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

354: l_parent_entity_id NUMBER;
355: l_child_entity_id NUMBER;
356: l_run_name VARCHAR2(80);
357: l_impact_occurred BOOLEAN := FALSE;
358: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
359: .attribute_id;
360: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
361: .version_id;
362: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')

Line 360: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

356: l_run_name VARCHAR2(80);
357: l_impact_occurred BOOLEAN := FALSE;
358: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
359: .attribute_id;
360: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
361: .version_id;
362: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
363: .attribute_id;
364: l_cp_start_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')

Line 362: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')

358: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
359: .attribute_id;
360: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
361: .version_id;
362: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
363: .attribute_id;
364: l_cp_start_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
365: .version_id;
366: l_parent_entity_name VARCHAR2(80);

Line 364: l_cp_start_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')

360: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
361: .version_id;
362: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
363: .attribute_id;
364: l_cp_start_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
365: .version_id;
366: l_parent_entity_name VARCHAR2(80);
367: l_child_entity_name VARCHAR2(80);
368: l_email VARCHAR2(200);

Line 776: l_cal_period_end_date_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

772: l_ledger_id NUMBER(15);
773: l_errbuf VARCHAR2(200);
774: l_retcode VARCHAR2(200);
775:
776: l_cal_period_end_date_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
777: .attribute_id;
778: l_cal_period_end_date_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
779: .version_id;
780: l_func_currency_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

Line 778: l_cal_period_end_date_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

774: l_retcode VARCHAR2(200);
775:
776: l_cal_period_end_date_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
777: .attribute_id;
778: l_cal_period_end_date_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
779: .version_id;
780: l_func_currency_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
781: .attribute_id;
782: l_func_currency_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

Line 780: l_func_currency_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

776: l_cal_period_end_date_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
777: .attribute_id;
778: l_cal_period_end_date_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
779: .version_id;
780: l_func_currency_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
781: .attribute_id;
782: l_func_currency_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
783: .version_id;
784:

Line 782: l_func_currency_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

778: l_cal_period_end_date_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
779: .version_id;
780: l_func_currency_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
781: .attribute_id;
782: l_func_currency_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
783: .version_id;
784:
785: CURSOR c_impacted_runs(p_cal_period_id IN NUMBER, p_currency_code IN VARCHAR2, p_entity_id IN NUMBER, p_balance_type_code IN VARCHAR2) IS
786:

Line 870: gcs_utility_pkg.populate_calendar_map_details(l_data_sub_info.cal_period_id,

866: AND fla.attribute_id = l_func_currency_attr
867: AND fla.version_id = l_func_currency_ver;
868:
869: --Explode into calendar period maps table gcs_cal_period_maps_gt
870: gcs_utility_pkg.populate_calendar_map_details(l_data_sub_info.cal_period_id,
871: 'Y',
872: 'N');
873:
874: FOR v_impacted_runs IN c_impacted_runs(l_data_sub_info.cal_period_id,

Line 980: l_cal_period_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

976: l_start_cp_end_date DATE;
977: l_end_cp_end_date DATE;
978: l_entity_type_code VARCHAR2(1);
979: l_cons_entity_id NUMBER;
980: l_cal_period_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
981: .attribute_id;
982: l_cal_period_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
983: .version_id;
984:

Line 982: l_cal_period_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

978: l_entity_type_code VARCHAR2(1);
979: l_cons_entity_id NUMBER;
980: l_cal_period_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
981: .attribute_id;
982: l_cal_period_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
983: .version_id;
984:
985: BEGIN
986:

Line 1207: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

1203: FROM gcs_entry_headers geh, fem_cal_periods_attr fcpa_start
1204: WHERE geh.entry_id = l_entry_id
1205: AND geh.start_cal_period_id = fcpa_start.cal_period_id
1206: AND fcpa_start.attribute_id =
1207: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1208: .attribute_id
1209: AND fcpa_start.version_id =
1210: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1211: .version_id;

Line 1210: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

1206: AND fcpa_start.attribute_id =
1207: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1208: .attribute_id
1209: AND fcpa_start.version_id =
1210: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1211: .version_id;
1212:
1213: SELECT parent_entity_id
1214: INTO l_cons_entity_id

Line 1293: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

1289: l_from_conversion_date DATE;
1290: l_to_conversion_date DATE;
1291: l_conversion_type VARCHAR2(30);
1292:
1293: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1294: .attribute_id;
1295: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1296: .version_id;
1297:

Line 1295: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

1291: l_conversion_type VARCHAR2(30);
1292:
1293: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1294: .attribute_id;
1295: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1296: .version_id;
1297:
1298: CURSOR c_impacted_runs(p_from_currency IN VARCHAR2, p_to_currency IN VARCHAR2, p_from_conv_date IN DATE, p_to_conv_date IN DATE, p_conversion_type IN VARCHAR2) IS
1299: SELECT gcer.run_name,

Line 1519: l_cal_period_info gcs_utility_pkg.r_cal_period_info;

1515:
1516: l_parent_entity_id NUMBER;
1517: l_run_parent_entity_id NUMBER;
1518: l_run_name VARCHAR2(240);
1519: l_cal_period_info gcs_utility_pkg.r_cal_period_info;
1520:
1521: BEGIN
1522:
1523: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 1609: gcs_utility_pkg.get_cal_period_details(p_cal_period_id => p_cal_period_id,

1605: END IF;
1606:
1607: BEGIN
1608: -- Check to see if subsequent period impacted
1609: gcs_utility_pkg.get_cal_period_details(p_cal_period_id => p_cal_period_id,
1610: p_cal_period_record => l_cal_period_info);
1611:
1612: SELECT run_name
1613: INTO l_run_name

Line 1672: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

1668: l_tab_run_entity_info t_run_entity_info;
1669: l_run_entity_info r_run_entity_info;
1670: l_character_index VARCHAR2(255);
1671:
1672: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1673: .attribute_id;
1674: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1675: .version_id;
1676: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')

Line 1674: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

1670: l_character_index VARCHAR2(255);
1671:
1672: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1673: .attribute_id;
1674: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1675: .version_id;
1676: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
1677: .attribute_id;
1678: l_cp_start_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')

Line 1676: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')

1672: l_cp_end_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1673: .attribute_id;
1674: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1675: .version_id;
1676: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
1677: .attribute_id;
1678: l_cp_start_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
1679: .version_id;
1680: l_ledger_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')

Line 1678: l_cp_start_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')

1674: l_cp_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1675: .version_id;
1676: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
1677: .attribute_id;
1678: l_cp_start_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
1679: .version_id;
1680: l_ledger_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
1681: .attribute_id;
1682: l_ledger_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')

Line 1680: l_ledger_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')

1676: l_cp_start_date_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
1677: .attribute_id;
1678: l_cp_start_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
1679: .version_id;
1680: l_ledger_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
1681: .attribute_id;
1682: l_ledger_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
1683: .version_id;
1684: l_gvsc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

Line 1682: l_ledger_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')

1678: l_cp_start_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_START_DATE')
1679: .version_id;
1680: l_ledger_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
1681: .attribute_id;
1682: l_ledger_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
1683: .version_id;
1684: l_gvsc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
1685: .attribute_id;
1686: l_gvsc_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

Line 1684: l_gvsc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

1680: l_ledger_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
1681: .attribute_id;
1682: l_ledger_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
1683: .version_id;
1684: l_gvsc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
1685: .attribute_id;
1686: l_gvsc_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
1687: .version_id;
1688:

Line 1686: l_gvsc_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

1682: l_ledger_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
1683: .version_id;
1684: l_gvsc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
1685: .attribute_id;
1686: l_gvsc_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
1687: .version_id;
1688:
1689: CURSOR c_impacted_hierarchies IS
1690: SELECT min(gcer.cal_period_id) cal_period_id,

Line 1912: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

1908: FROM gcs_entry_headers geh, fem_cal_periods_attr fcpa_start
1909: WHERE geh.entry_id = l_entry_id
1910: AND geh.start_cal_period_id = fcpa_start.cal_period_id
1911: AND fcpa_start.attribute_id =
1912: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1913: .attribute_id
1914: AND fcpa_start.version_id =
1915: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1916: .version_id;

Line 1915: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

1911: AND fcpa_start.attribute_id =
1912: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1913: .attribute_id
1914: AND fcpa_start.version_id =
1915: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1916: .version_id;
1917:
1918: SELECT parent_entity_id
1919: INTO l_cons_entity_id