DBA Data[Home] [Help]

APPS.EGO_UI_ITEM_PUB dependencies on EGO_MTL_SY_ITEMS_EXT_TL

Line 1448: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;

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;
1452:

Line 1453: UPDATE EGO_MTL_SY_ITEMS_EXT_TL SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_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;
1455: END IF;
1456: developer_debug ('::2960442::Update_Item_Attr_Ext::end');
1457: COMMIT;

Line 1656: l_dynamic_sql := ' DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL'||

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'||
1657: ' WHERE EXTENSION_ID IN ('||l_ext_id_to_delete_list||')';
1658: EXECUTE IMMEDIATE l_dynamic_sql;
1659: END IF;
1660: