APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_ITEM_PEOPLE_INTF

Line 5270: UPDATE EGO_ITEM_PEOPLE_INTF eipi

5266: );
5267:
5268: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_ASSOCIATIONS_INTF Processed rows='||SQL%ROWCOUNT);
5269:
5270: UPDATE EGO_ITEM_PEOPLE_INTF eipi
5271: SET PROCESS_STATUS = 10
5272: WHERE DATA_SET_ID = p_batch_id
5273: AND PROCESS_STATUS = 1
5274: AND EXISTS (SELECT NULL FROM MTL_SYSTEM_ITEMS_INTERFACE msii

Line 5292: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_PEOPLE_INTF Processed rows='||SQL%ROWCOUNT);

5288: IF SQL%ROWCOUNT > 0 THEN
5289: EGO_WF_WRAPPER_PVT.Set_Item_People_Event(p_true_false => p_enable_sku_processing);
5290: END IF;
5291:
5292: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_PEOPLE_INTF Processed rows='||SQL%ROWCOUNT);
5293:
5294: ELSIF p_enable_sku_processing = 'T' THEN
5295: Debug_Conc_Log('Enable_Disable_SKU_Processing: Enabling SKUs');
5296:

Line 5432: UPDATE EGO_ITEM_PEOPLE_INTF eipi

5428: -- Bug 9678667 : change end
5429:
5430: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_ASSOCIATIONS_INTF Processed rows='||SQL%ROWCOUNT);
5431:
5432: UPDATE EGO_ITEM_PEOPLE_INTF eipi
5433: SET PROCESS_STATUS = 1
5434: WHERE DATA_SET_ID = p_batch_id
5435: AND PROCESS_STATUS = 10;
5436:

Line 5447: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_PEOPLE_INTF Processed rows='||SQL%ROWCOUNT);

5443: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
5444: IF SQL%ROWCOUNT > 0 THEN
5445: EGO_WF_WRAPPER_PVT.Set_Item_People_Event(p_true_false => p_enable_sku_processing);
5446: END IF;
5447: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_PEOPLE_INTF Processed rows='||SQL%ROWCOUNT);
5448: END IF;
5449:
5450: RETCODE := '0';
5451: ERRBUF := NULL;

Line 5644: EGO_ITEM_PEOPLE_INTF intf,

5640: ) GRANTEE_KEY,
5641: intf.END_DATE
5642: FROM
5643: MTL_SYSTEM_ITEMS_KFV msik,
5644: EGO_ITEM_PEOPLE_INTF intf,
5645: MTL_PARAMETERS mp,
5646: FND_MENUS menus
5647: WHERE intf.DATA_SET_ID = p_batch_id
5648: AND intf.PROCESS_STATUS = 4

Line 5958: UPDATE EGO_ITEM_PEOPLE_INTF

5954: AND SET_PROCESS_ID = p_batch_id
5955: AND SOURCE_SYSTEM_ID = p_ss_id
5956: AND ( ITEM_NUMBER = p_old_item_number OR SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5957:
5958: UPDATE EGO_ITEM_PEOPLE_INTF
5959: SET ITEM_NUMBER = p_item_number
5960: WHERE PROCESS_STATUS = 1
5961: AND DATA_SET_ID = p_batch_id
5962: AND SOURCE_SYSTEM_ID = p_ss_id