DBA Data[Home] [Help]

APPS.GCS_CREATE_LEVELS_PKG dependencies on FEM_HIER_DIM_GRPS_T

Line 231: -- Insert data into fem_hier_dim_grps_t

227: -- Continue only if there are no conflicting levels
228:
229: IF ( p_level_exists = 'N') THEN
230:
231: -- Insert data into fem_hier_dim_grps_t
232:
233: IF p_analysis_flag = 'Y' THEN
234:
235: -- get rid of orphan records

Line 236: DELETE FROM fem_hier_dim_grps_t

232:
233: IF p_analysis_flag = 'Y' THEN
234:
235: -- get rid of orphan records
236: DELETE FROM fem_hier_dim_grps_t
237: WHERE hierarchy_object_name = p_hierarchy_name
238: AND dimension_group_display_code IN
239: ( SELECT dimension_group_display_code FROM GCS_EPB_LEVELS_GT );
240:

Line 241: INSERT INTO fem_hier_dim_grps_t (

237: WHERE hierarchy_object_name = p_hierarchy_name
238: AND dimension_group_display_code IN
239: ( SELECT dimension_group_display_code FROM GCS_EPB_LEVELS_GT );
240:
241: INSERT INTO fem_hier_dim_grps_t (
242: hierarchy_object_name,
243: language,
244: status,
245: dimension_group_display_code)