DBA Data[Home] [Help]

APPS.EGO_VALIDATE_CATALOG_GROUP dependencies on MTL_ITEM_CATALOG_GROUPS_B

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 393: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_item_catalog_groups_b

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