APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_SKU_VARIANT_ATTR_USAGES

Line 6938: * If any SKUs are created in EGO_SKU_VARIANT_ATTR_USAGES table

6934: END Copy_Attachments;
6935:
6936: /*
6937: * This method is called at the end of import processing.
6938: * If any SKUs are created in EGO_SKU_VARIANT_ATTR_USAGES table
6939: * but corresponding variant attributes are not present in
6940: * production table, then delete that entry.
6941: */
6942: PROCEDURE Clean_Dirty_SKUs( retcode OUT NOCOPY VARCHAR2,

Line 6965: DELETE FROM EGO_SKU_VARIANT_ATTR_USAGES esvas

6961: AND DATA_LEVEL_NAME = 'ITEM_LEVEL';
6962:
6963: Debug_Conc_Log('Clean_Dirty_SKUs : l_item_dl_id='||l_item_dl_id);
6964:
6965: DELETE FROM EGO_SKU_VARIANT_ATTR_USAGES esvas
6966: WHERE EXISTS (SELECT NULL
6967: FROM
6968: EGO_FND_DSC_FLX_CTX_EXT ag_ext,
6969: EGO_OBJ_AG_ASSOCS_B assoc,