DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on MTL_CROSS_REFERENCES_TL

Line 5370: UPDATE MTL_CROSS_REFERENCES_TL

5366: OR (i.EXISTING_GTIN_DESC IS NULL AND i.GTIN_DESCRIPTION IS NOT NULL)
5367: )
5368: THEN
5369: Debug_Conc_Log('Existing GTIN found. Description needs to be updated.');
5370: UPDATE MTL_CROSS_REFERENCES_TL
5371: SET DESCRIPTION = i.GTIN_DESCRIPTION,
5372: LAST_UPDATE_DATE = SYSDATE,
5373: LAST_UPDATED_BY = l_user_id,
5374: LAST_UPDATE_LOGIN = l_login_id,

Line 5714: UPDATE MTL_CROSS_REFERENCES_TL

5710: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5711: l_inventory_item_id := i.INVENTORY_ITEM_ID;
5712:
5713: IF l_inventory_item_id IS NOT NULL THEN
5714: UPDATE MTL_CROSS_REFERENCES_TL
5715: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5716: LAST_UPDATE_DATE = SYSDATE,
5717: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5718: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 5839: UPDATE MTL_CROSS_REFERENCES_TL

5835: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5836: l_inventory_item_id := i.INVENTORY_ITEM_ID;
5837:
5838: IF l_inventory_item_id IS NOT NULL THEN
5839: UPDATE MTL_CROSS_REFERENCES_TL
5840: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5841: LAST_UPDATE_DATE = SYSDATE,
5842: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5843: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,