APPS.EGO_VALIDATE_CATALOG_GROUP dependencies on MTL_ITEM_CATALOG_GROUPS

Line 183: SELECT inactive_date INTO l_parent_inactive_date FROM mtl_item_catalog_groups_b

179: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM
180: THEN
181:
182: BEGIN
183: SELECT inactive_date INTO l_parent_inactive_date FROM mtl_item_catalog_groups_b
184: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id;
185: EXCEPTION WHEN OTHERS THEN
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: Error_Handler.Add_Error_Token

Line 307: FROM mtl_item_catalog_groups MICG

303: BEGIN
304:
305: SELECT MICG.item_catalog_group_id
306: INTO l_ccid
307: FROM mtl_item_catalog_groups MICG
308: WHERE upper(decode(MICG.item_catalog_group_id, NULL, NULL,
309: FND_FLEX_SERVER.GET_KFV_CONCAT_SEGS_BY_CCID('COMPACT',401,'MICG',
310: 101,MICG.item_catalog_group_id,NULL) )) = upper(EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
311:

Line 397: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_item_catalog_groups_b

393:
394: BEGIN
395: -- dbms_output.put_line('Checking for parent catalog group during delete');
396:
397: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_item_catalog_groups_b
398: WHERE parent_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id);
399:
400: -- dbms_output.put_line('Found parent catalog group during delete');
401: