APPS.EGO_UI_ITEM_PUB dependencies on EGO_MTL_SY_ITEMS_EXT_B

Line 1447: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;

1443: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
1444: X_MSG_COUNT := 0;
1445:
1446: IF (P_ITEM_CATALOG_GROUP_ID IS NULL) THEN
1447: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1448: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1449: ELSE
1450: UPDATE EGO_MTL_SY_ITEMS_EXT_B SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_ID
1451: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;

Line 1450: UPDATE EGO_MTL_SY_ITEMS_EXT_B SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_ID

1446: IF (P_ITEM_CATALOG_GROUP_ID IS NULL) THEN
1447: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1448: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1449: ELSE
1450: UPDATE EGO_MTL_SY_ITEMS_EXT_B SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_ID
1451: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1452:
1453: UPDATE EGO_MTL_SY_ITEMS_EXT_TL SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_ID
1454: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;

Line 1652: l_dynamic_sql := ' DELETE FROM EGO_MTL_SY_ITEMS_EXT_B'||

1648:
1649: ----------------------------------------------------------------------
1650: -- ...and then delete all rows in the list from the B and TL tables --
1651: ----------------------------------------------------------------------
1652: l_dynamic_sql := ' DELETE FROM EGO_MTL_SY_ITEMS_EXT_B'||
1653: ' WHERE EXTENSION_ID IN ('||l_ext_id_to_delete_list||')';
1654: EXECUTE IMMEDIATE l_dynamic_sql;
1655:
1656: l_dynamic_sql := ' DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL'||