DBA Data[Home] [Help]

APPS.GCS_IC_LOB_ELIM_PARENT_PKG dependencies on GCS_UTILITY_PKG

Line 92: IF (gcs_utility_pkg.g_gcs_dimension_info('USER_DIM1_ID').required_for_gcs = 'N') THEN

88: -- Checking if the User Dimension-01 is a part of the Processing Key
89: BEGIN
90: --SKAMDAR: Ensure user dimension 1 is enabled for processing
91: --Prior check was made against fem_tab_column_prop but we can go straight to utility package
92: IF (gcs_utility_pkg.g_gcs_dimension_info('USER_DIM1_ID').required_for_gcs = 'N') THEN
93: RAISE NO_USER_DIM1_PROC_KEY;
94: END IF;
95: EXCEPTION
96: WHEN NO_DATA_FOUND THEN

Line 165: l_value_set_id := gcs_utility_pkg.g_gcs_dimension_info('USER_DIM1_ID').associated_value_set_id;

161:
162: --SKAMDAR: Information can be retrieved from the utility package rather than executing a select against fem tables
163: BEGIN
164:
165: l_value_set_id := gcs_utility_pkg.g_gcs_dimension_info('USER_DIM1_ID').associated_value_set_id;
166:
167: SELECT value_set_display_code
168: INTO l_vs_display_code
169: FROM fem_value_sets_b fvsb