DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on MTL_CROSS_REFERENCES_TL

Line 5436: UPDATE MTL_CROSS_REFERENCES_TL

5432: OR (i.EXISTING_GTIN_DESC IS NULL AND i.GTIN_DESCRIPTION IS NOT NULL)
5433: )
5434: THEN
5435: Debug_Conc_Log('Existing GTIN found. Description needs to be updated.');
5436: UPDATE MTL_CROSS_REFERENCES_TL
5437: SET DESCRIPTION = i.GTIN_DESCRIPTION,
5438: LAST_UPDATE_DATE = SYSDATE,
5439: LAST_UPDATED_BY = l_user_id,
5440: LAST_UPDATE_LOGIN = l_login_id,

Line 5780: UPDATE MTL_CROSS_REFERENCES_TL

5776: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5777: l_inventory_item_id := i.INVENTORY_ITEM_ID;
5778:
5779: IF l_inventory_item_id IS NOT NULL THEN
5780: UPDATE MTL_CROSS_REFERENCES_TL
5781: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5782: LAST_UPDATE_DATE = SYSDATE,
5783: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5784: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 5905: UPDATE MTL_CROSS_REFERENCES_TL

5901: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5902: l_inventory_item_id := i.INVENTORY_ITEM_ID;
5903:
5904: IF l_inventory_item_id IS NOT NULL THEN
5905: UPDATE MTL_CROSS_REFERENCES_TL
5906: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5907: LAST_UPDATE_DATE = SYSDATE,
5908: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5909: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,