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_DATASUB_WF_PKG dependencies on GCS_UTILITY_PKG

Line 7: g_entity_ledger_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')

3:
4: g_api VARCHAR2(80) := 'gcs.plsql.GCS_DATASUB_WF_PKG';
5:
6: -- Dimension Attribute Information
7: g_entity_ledger_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
8: .attribute_id;
9: g_entity_ledger_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
10: .version_id;
11: g_ledger_curr_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

Line 9: g_entity_ledger_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')

5:
6: -- Dimension Attribute Information
7: g_entity_ledger_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
8: .attribute_id;
9: g_entity_ledger_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
10: .version_id;
11: g_ledger_curr_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
12: .attribute_id;
13: g_ledger_curr_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

Line 11: g_ledger_curr_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

7: g_entity_ledger_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
8: .attribute_id;
9: g_entity_ledger_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
10: .version_id;
11: g_ledger_curr_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
12: .attribute_id;
13: g_ledger_curr_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
14: .version_id;
15: g_ledger_system_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')

Line 13: g_ledger_curr_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

9: g_entity_ledger_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID')
10: .version_id;
11: g_ledger_curr_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
12: .attribute_id;
13: g_ledger_curr_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
14: .version_id;
15: g_ledger_system_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
16: .attribute_id;
17: g_ledger_system_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')

Line 15: g_ledger_system_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')

11: g_ledger_curr_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
12: .attribute_id;
13: g_ledger_curr_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
14: .version_id;
15: g_ledger_system_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
16: .attribute_id;
17: g_ledger_system_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
18: .version_id;
19: g_ledger_vs_combo_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

Line 17: g_ledger_system_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')

13: g_ledger_curr_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
14: .version_id;
15: g_ledger_system_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
16: .attribute_id;
17: g_ledger_system_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
18: .version_id;
19: g_ledger_vs_combo_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
20: .attribute_id;
21: g_ledger_vs_combo_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

Line 19: g_ledger_vs_combo_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

15: g_ledger_system_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
16: .attribute_id;
17: g_ledger_system_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
18: .version_id;
19: g_ledger_vs_combo_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
20: .attribute_id;
21: g_ledger_vs_combo_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
22: .version_id;
23:

Line 21: g_ledger_vs_combo_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

17: g_ledger_system_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
18: .version_id;
19: g_ledger_vs_combo_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
20: .attribute_id;
21: g_ledger_vs_combo_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
22: .version_id;
23:
24: -- Beginning of Private Procedures
25:

Line 32: l_balance_type_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')

28: PROCEDURE get_datasub_dtls(p_load_id IN NUMBER,
29: p_datasub_info IN OUT NOCOPY r_datasub_info) IS
30:
31: -- Bugfix 5066041: Added support for additional data types
32: l_balance_type_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')
33: .attribute_id;
34: l_balance_type_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')
35: .version_id;
36: l_budget_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')

Line 34: l_balance_type_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')

30:
31: -- Bugfix 5066041: Added support for additional data types
32: l_balance_type_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')
33: .attribute_id;
34: l_balance_type_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')
35: .version_id;
36: l_budget_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')
37: .attribute_id;
38: l_budget_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')

Line 36: l_budget_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')

32: l_balance_type_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')
33: .attribute_id;
34: l_balance_type_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')
35: .version_id;
36: l_budget_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')
37: .attribute_id;
38: l_budget_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')
39: .version_id;
40: l_encumbrance_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID')

Line 38: l_budget_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')

34: l_balance_type_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')
35: .version_id;
36: l_budget_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')
37: .attribute_id;
38: l_budget_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')
39: .version_id;
40: l_encumbrance_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
41: .attribute_id;
42: l_encumbrance_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID')

Line 40: l_encumbrance_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID')

36: l_budget_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')
37: .attribute_id;
38: l_budget_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')
39: .version_id;
40: l_encumbrance_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
41: .attribute_id;
42: l_encumbrance_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
43: .version_id;
44:

Line 42: l_encumbrance_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID')

38: l_budget_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID')
39: .version_id;
40: l_encumbrance_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
41: .attribute_id;
42: l_encumbrance_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
43: .version_id;
44:
45: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
46: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

Line 46: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

42: l_encumbrance_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
43: .version_id;
44:
45: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
46: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
47: .attribute_id;
48: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
49: .version_id;
50:

Line 48: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

44:
45: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
46: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
47: .attribute_id;
48: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
49: .version_id;
50:
51: BEGIN
52: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 331: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

327: l_bal_rule_obj_def_id NUMBER;
328: l_cal_period_end_date DATE;
329:
330:
331: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
332: .attribute_id;
333: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
334: .version_id;
335: l_balances_rule_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')

Line 333: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

329:
330:
331: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
332: .attribute_id;
333: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
334: .version_id;
335: l_balances_rule_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
336: .attribute_id;
337: l_balances_rule_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')

Line 335: l_balances_rule_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')

331: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
332: .attribute_id;
333: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
334: .version_id;
335: l_balances_rule_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
336: .attribute_id;
337: l_balances_rule_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
338: .version_id;
339: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

Line 337: l_balances_rule_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')

333: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
334: .version_id;
335: l_balances_rule_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
336: .attribute_id;
337: l_balances_rule_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
338: .version_id;
339: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
340: .attribute_id;
341: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

Line 339: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

335: l_balances_rule_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
336: .attribute_id;
337: l_balances_rule_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
338: .version_id;
339: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
340: .attribute_id;
341: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
342: .version_id;
343: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')

Line 341: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

337: l_balances_rule_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-BALANCES_RULE_ID')
338: .version_id;
339: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
340: .attribute_id;
341: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
342: .version_id;
343: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
344: .attribute_id;
345: l_company_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')

Line 343: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')

339: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
340: .attribute_id;
341: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
342: .version_id;
343: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
344: .attribute_id;
345: l_company_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
346: .version_id;
347: l_global_vs_combo_id NUMBER(9);

Line 345: l_company_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')

341: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
342: .version_id;
343: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
344: .attribute_id;
345: l_company_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
346: .version_id;
347: l_global_vs_combo_id NUMBER(9);
348: l_status_code VARCHAR2(1);
349: l_hier_obj_definition_id NUMBER(9);

Line 609: gcs_utility_pkg.g_fch_global_vs_combo_id

605: l_fch_org_vs_id
606: FROM fem_global_vs_combo_defs fgvcd_fch_company,
607: fem_global_vs_combo_defs fgvcd_fch_org
608: WHERE fgvcd_fch_company.global_vs_combo_id =
609: gcs_utility_pkg.g_fch_global_vs_combo_id
610: AND fgvcd_fch_org.global_vs_combo_id =
611: fgvcd_fch_company.global_vs_combo_id
612: AND fgvcd_fch_org.dimension_id = 8
613: AND fgvcd_fch_company.dimension_id = 112;

Line 1314: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')

1310:
1311: IS
1312: PRAGMA AUTONOMOUS_TRANSACTION;
1313:
1314: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
1315: .attribute_id;
1316: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
1317: .version_id;
1318: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

Line 1316: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')

1312: PRAGMA AUTONOMOUS_TRANSACTION;
1313:
1314: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
1315: .attribute_id;
1316: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
1317: .version_id;
1318: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
1319: .attribute_id;
1320: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

Line 1318: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

1314: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
1315: .attribute_id;
1316: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
1317: .version_id;
1318: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
1319: .attribute_id;
1320: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
1321: .version_id;
1322:

Line 1320: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

1316: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
1317: .version_id;
1318: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
1319: .attribute_id;
1320: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
1321: .version_id;
1322:
1323: BEGIN
1324:

Line 1872: l_cal_period_info gcs_utility_pkg.r_cal_period_info;

1868:
1869: l_datasub_info r_datasub_info;
1870: l_currency_type_code VARCHAR2(30);
1871: l_first_ever_loaded VARCHAR2(1);
1872: l_cal_period_info gcs_utility_pkg.r_cal_period_info;
1873:
1874: BEGIN
1875:
1876: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 1902: gcs_utility_pkg.get_cal_period_details(p_cal_period_id => l_datasub_info.cal_period_id,

1898: p_currency_type_code => l_currency_type_code,
1899: p_first_ever_loaded => l_first_ever_loaded);
1900:
1901: IF (l_first_ever_loaded = 'N') THEN
1902: gcs_utility_pkg.get_cal_period_details(p_cal_period_id => l_datasub_info.cal_period_id,
1903: p_cal_period_record => l_cal_period_info);
1904:
1905: --Bugfix 4969879: Remove call to get_reference_data_info
1906:

Line 1961: l_cal_period_info gcs_utility_pkg.r_cal_period_info;

1957:
1958: l_datasub_info r_datasub_info;
1959: l_currency_type_code VARCHAR2(30);
1960: l_first_ever_loaded VARCHAR2(1);
1961: l_cal_period_info gcs_utility_pkg.r_cal_period_info;
1962: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1963: .attribute_id;
1964: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1965: .version_id;

Line 1962: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

1958: l_datasub_info r_datasub_info;
1959: l_currency_type_code VARCHAR2(30);
1960: l_first_ever_loaded VARCHAR2(1);
1961: l_cal_period_info gcs_utility_pkg.r_cal_period_info;
1962: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1963: .attribute_id;
1964: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1965: .version_id;
1966: l_period_num_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

Line 1964: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

1960: l_first_ever_loaded VARCHAR2(1);
1961: l_cal_period_info gcs_utility_pkg.r_cal_period_info;
1962: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1963: .attribute_id;
1964: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1965: .version_id;
1966: l_period_num_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
1967: .attribute_id;
1968: l_period_num_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

Line 1966: l_period_num_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

1962: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1963: .attribute_id;
1964: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1965: .version_id;
1966: l_period_num_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
1967: .attribute_id;
1968: l_period_num_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
1969: .version_id;
1970: l_period_end_date DATE;

Line 1968: l_period_num_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

1964: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
1965: .version_id;
1966: l_period_num_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
1967: .attribute_id;
1968: l_period_num_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
1969: .version_id;
1970: l_period_end_date DATE;
1971: l_period_num NUMBER(15);
1972: l_period_dim_grp_disp_code VARCHAR2(50);

Line 2338: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

2334: l_entity_list DBMS_SQL.NUMBER_TABLE;
2335: l_xlated_curr_list DBMS_SQL.VARCHAR2_TABLE;
2336: l_generated_load_list DBMS_SQL.NUMBER_TABLE;
2337:
2338: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
2339: .attribute_id;
2340: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
2341: .version_id;
2342: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')

Line 2340: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

2336: l_generated_load_list DBMS_SQL.NUMBER_TABLE;
2337:
2338: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
2339: .attribute_id;
2340: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
2341: .version_id;
2342: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
2343: .attribute_id;
2344: l_company_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')

Line 2342: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')

2338: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
2339: .attribute_id;
2340: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
2341: .version_id;
2342: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
2343: .attribute_id;
2344: l_company_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
2345: .version_id;
2346: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

Line 2344: l_company_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')

2340: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
2341: .version_id;
2342: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
2343: .attribute_id;
2344: l_company_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
2345: .version_id;
2346: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
2347: .attribute_id;
2348: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

Line 2346: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

2342: l_company_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
2343: .attribute_id;
2344: l_company_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
2345: .version_id;
2346: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
2347: .attribute_id;
2348: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
2349: .version_id;
2350:

Line 2348: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

2344: l_company_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY')
2345: .version_id;
2346: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
2347: .attribute_id;
2348: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
2349: .version_id;
2350:
2351: BEGIN
2352:

Line 3281: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

3277: -- Bugfix 5664023 :End
3278:
3279: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
3280:
3281: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
3282: .attribute_id;
3283: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
3284: .version_id;
3285:

Line 3283: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

3279: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
3280:
3281: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
3282: .attribute_id;
3283: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
3284: .version_id;
3285:
3286:
3287: BEGIN