DBA Data[Home] [Help]

APPS.GCS_HIERARCHIES_PKG dependencies on GCS_UTILITY_PKG

Line 2244: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')

2240: AND fda.attribute_id = fdab.attribute_id
2241: AND fdab.attribute_id = fdavb.attribute_id
2242: AND fda.version_id = fdavb.version_id
2243: AND fdavb.default_version_flag = 'Y'
2244: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-DATASET_BALANCE_TYPE_CODE')
2245: AND gdtcb.data_type_code = p_data_type_code;
2246:
2247: -- If the source dataset is a budget or encumbrance, get the budget or encumbrance type id of the source dataset
2248: IF l_fem_balance_type = 'BUDGET' THEN

Line 2258: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-BUDGET_ID')

2254: WHERE fda.attribute_id = fdab.attribute_id
2255: AND fdab.attribute_id = fdavb.attribute_id
2256: AND fda.version_id = fdavb.version_id
2257: AND fdavb.default_version_flag = 'Y'
2258: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-BUDGET_ID')
2259: AND fda.dataset_code = l_dataset_code;
2260: END IF;
2261:
2262: IF l_fem_balance_type = 'ENCUMBRANCE' THEN

Line 2272: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-ENCUMBRANCE_TYPE_ID')

2268: WHERE fda.attribute_id = fdab.attribute_id
2269: AND fdab.attribute_id = fdavb.attribute_id
2270: AND fda.version_id = fdavb.version_id
2271: AND fdavb.default_version_flag = 'Y'
2272: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
2273: AND fda.dataset_code = l_dataset_code;
2274: END IF;
2275:
2276: l_base_balance_type := p_data_type_code;

Line 2446: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-DATASET_BALANCE_TYPE_CODE');

2442: AND fda.attribute_id = fdab.attribute_id
2443: AND fdab.attribute_id = fdavb.attribute_id
2444: AND fda.version_id = fdavb.version_id
2445: AND fdavb.default_version_flag = 'Y'
2446: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-DATASET_BALANCE_TYPE_CODE');
2447:
2448: IF l_data_type_info.FIRST IS NOT NULL AND
2449: l_data_type_info.LAST IS NOT NULL THEN
2450: FOR l_counter IN l_data_type_info.FIRST .. l_data_type_info.LAST LOOP

Line 2473: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-BUDGET_ID')

2469: WHERE fda.attribute_id = fdab.attribute_id
2470: AND fdab.attribute_id = fdavb.attribute_id
2471: AND fda.version_id = fdavb.version_id
2472: AND fdavb.default_version_flag = 'Y'
2473: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-BUDGET_ID')
2474: AND fda.dataset_code = l_dataset_code;
2475: END IF;
2476:
2477: IF l_fem_balance_type = 'ENCUMBRANCE' THEN

Line 2487: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-ENCUMBRANCE_TYPE_ID')

2483: WHERE fda.attribute_id = fdab.attribute_id
2484: AND fdab.attribute_id = fdavb.attribute_id
2485: AND fda.version_id = fdavb.version_id
2486: AND fdavb.default_version_flag = 'Y'
2487: AND fda.attribute_id = gcs_utility_pkg.get_dimension_attribute('DATASET_CODE-ENCUMBRANCE_TYPE_ID')
2488: AND fda.dataset_code = l_dataset_code;
2489: END IF;
2490:
2491: fnd_message.set_name('GCS', 'GCS_HIER_NEW_DATASET_DESC');