APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_SKU_VARIANT_ATTR_USAGES

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

6150: END Copy_Attachments;
6151:
6152: /*
6153: * This method is called at the end of import processing.
6154: * If any SKUs are created in EGO_SKU_VARIANT_ATTR_USAGES table
6155: * but corresponding variant attributes are not present in
6156: * production table, then delete that entry.
6157: */
6158: PROCEDURE Clean_Dirty_SKUs( retcode OUT NOCOPY VARCHAR2,

Line 6181: DELETE FROM EGO_SKU_VARIANT_ATTR_USAGES esvas

6177: AND DATA_LEVEL_NAME = 'ITEM_LEVEL';
6178:
6179: Debug_Conc_Log('Clean_Dirty_SKUs : l_item_dl_id='||l_item_dl_id);
6180:
6181: DELETE FROM EGO_SKU_VARIANT_ATTR_USAGES esvas
6182: WHERE EXISTS (SELECT NULL
6183: FROM
6184: EGO_FND_DSC_FLX_CTX_EXT ag_ext,
6185: EGO_OBJ_AG_ASSOCS_B assoc,