APPS.GCS_FEM_HIER_SYNC_PKG dependencies on FEM_ENTITIES_HIER

Line 144: INSERT INTO fem_entities_hier_t

140: );
141:
142: -- Step 3: insert all relationships
143:
144: INSERT INTO fem_entities_hier_t
145: ( hierarchy_object_name,
146: hierarchy_obj_def_display_name,
147: parent_display_code,
148: parent_value_set_display_code,

Line 177: INSERT INTO fem_entities_hier_t

173: AND gcr.child_entity_id = fev_c.entity_id;
174:
175: -- we need to insert a record for the top node
176:
177: INSERT INTO fem_entities_hier_t
178: (
179: hierarchy_object_name,
180: hierarchy_obj_def_display_name,
181: parent_display_code,

Line 358: FROM fem_entities_hier feh

354:
355: BEGIN
356: SELECT feh.parent_depth_num
357: INTO l_parent_depth_num
358: FROM fem_entities_hier feh
359: WHERE feh.hierarchy_obj_def_id = l_object_definition_id
360: AND feh.parent_id = l_parent_entity_id
361: AND feh.single_depth_flag = 'Y'
362: AND ROWNUM < 2;

Line 367: FROM fem_entities_hier feh

363: EXCEPTION
364: WHEN OTHERS THEN
365: SELECT feh.child_depth_num
366: INTO l_parent_depth_num
367: FROM fem_entities_hier feh
368: WHERE feh.hierarchy_obj_def_id = l_object_definition_id
369: AND feh.child_id = l_parent_entity_id
370: AND feh.single_depth_flag = 'Y'
371: AND ROWNUM < 2;

Line 374: INSERT INTO fem_entities_hier

370: AND feh.single_depth_flag = 'Y'
371: AND ROWNUM < 2;
372: END;
373:
374: INSERT INTO fem_entities_hier
375: (hierarchy_obj_def_id,
376: parent_depth_num,
377: parent_id,
378: parent_value_set_id,

Line 412: INSERT INTO fem_entities_hier

408: 'N'
409: );
410:
411: IF (l_entity_type = 'C') THEN
412: INSERT INTO fem_entities_hier
413: (hierarchy_obj_def_id,
414: parent_depth_num,
415: parent_id,
416: parent_value_set_id,