APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_ITEM_PEOPLE_INTF

Line 4570: UPDATE EGO_ITEM_PEOPLE_INTF eipi

4566: );
4567:
4568: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_ASSOCIATIONS_INTF Processed rows='||SQL%ROWCOUNT);
4569:
4570: UPDATE EGO_ITEM_PEOPLE_INTF eipi
4571: SET PROCESS_STATUS = 10
4572: WHERE DATA_SET_ID = p_batch_id
4573: AND PROCESS_STATUS = 1
4574: AND EXISTS (SELECT NULL FROM MTL_SYSTEM_ITEMS_INTERFACE msii

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

4588: IF SQL%ROWCOUNT > 0 THEN
4589: EGO_WF_WRAPPER_PVT.Set_Item_People_Event(p_true_false => p_enable_sku_processing);
4590: END IF;
4591:
4592: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_PEOPLE_INTF Processed rows='||SQL%ROWCOUNT);
4593:
4594: ELSIF p_enable_sku_processing = 'T' THEN
4595: Debug_Conc_Log('Enable_Disable_SKU_Processing: Enabling SKUs');
4596:

Line 4688: UPDATE EGO_ITEM_PEOPLE_INTF eipi

4684: AND PROCESS_FLAG = 10;
4685:
4686: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_ASSOCIATIONS_INTF Processed rows='||SQL%ROWCOUNT);
4687:
4688: UPDATE EGO_ITEM_PEOPLE_INTF eipi
4689: SET PROCESS_STATUS = 1
4690: WHERE DATA_SET_ID = p_batch_id
4691: AND PROCESS_STATUS = 10;
4692:

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

4693: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
4694: IF SQL%ROWCOUNT > 0 THEN
4695: EGO_WF_WRAPPER_PVT.Set_Item_People_Event(p_true_false => p_enable_sku_processing);
4696: END IF;
4697: Debug_Conc_Log('Enable_Disable_SKU_Processing: EGO_ITEM_PEOPLE_INTF Processed rows='||SQL%ROWCOUNT);
4698: END IF;
4699:
4700: RETCODE := '0';
4701: ERRBUF := NULL;

Line 4894: EGO_ITEM_PEOPLE_INTF intf,

4890: ) GRANTEE_KEY,
4891: intf.END_DATE
4892: FROM
4893: MTL_SYSTEM_ITEMS_KFV msik,
4894: EGO_ITEM_PEOPLE_INTF intf,
4895: MTL_PARAMETERS mp,
4896: FND_MENUS menus
4897: WHERE intf.DATA_SET_ID = p_batch_id
4898: AND intf.PROCESS_STATUS = 4

Line 5191: UPDATE EGO_ITEM_PEOPLE_INTF

5187: AND SET_PROCESS_ID = p_batch_id
5188: AND SOURCE_SYSTEM_ID = p_ss_id
5189: AND ( ITEM_NUMBER = p_old_item_number OR SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5190:
5191: UPDATE EGO_ITEM_PEOPLE_INTF
5192: SET ITEM_NUMBER = p_item_number
5193: WHERE PROCESS_STATUS = 1
5194: AND DATA_SET_ID = p_batch_id
5195: AND SOURCE_SYSTEM_ID = p_ss_id