APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on EGO_ITEM_PEOPLE_INTF

Line 96: ( -- Looking for failure rows in EGO_ITEM_PEOPLE_INTF

92: AND MIRI.REQUEST_ID = I.REQUEST_ID
93: AND ROWNUM = 1
94: )
95: ,
96: ( -- Looking for failure rows in EGO_ITEM_PEOPLE_INTF
97: SELECT 'PARTIAL'
98: FROM EGO_ITEM_PEOPLE_INTF EIPI
99: WHERE
100: ( EIPI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID

Line 98: FROM EGO_ITEM_PEOPLE_INTF EIPI

94: )
95: ,
96: ( -- Looking for failure rows in EGO_ITEM_PEOPLE_INTF
97: SELECT 'PARTIAL'
98: FROM EGO_ITEM_PEOPLE_INTF EIPI
99: WHERE
100: ( EIPI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
101: OR ( EIPI.ITEM_NUMBER = I.ITEM_NUMBER
102: AND (

Line 243: FROM EGO_ITEM_PEOPLE_INTF

239:
240: UNION
241:
242: SELECT DISTINCT DATA_SET_ID set_process_id, organization_id, ORGANIZATION_CODE, REQUEST_ID, INVENTORY_ITEM_ID, item_number, null BUNDLE_ID , Decode ( PROCESS_STATUS,4,7,PROCESS_STATUS) PROCESS_FLAG
243: FROM EGO_ITEM_PEOPLE_INTF
244: WHERE PROCESS_STATUS IN (3,6,4)
245:
246: UNION
247:

Line 351: DELETE FROM EGO_ITEM_PEOPLE_INTF

347:
348:
349: FORALL item IN l_item_table.first .. l_item_table.last
350:
351: DELETE FROM EGO_ITEM_PEOPLE_INTF
352: WHERE DATA_SET_ID = TREAT( l_item_table(item) AS Ego_item_list_inf).SET_PROCESS_ID
353: AND ( organization_id = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_id
354: OR ( organization_code = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_code
355: AND ( organization_code IS NULL OR TREAT( l_item_table(item) AS Ego_item_list_inf).organization_code IS NULL )

Line 1048: DELETE FROM EGO_ITEM_PEOPLE_INTF WHERE DATA_SET_ID = p_batch_id AND PROCESS_STATUS IN (3,4,6,7);

1044:
1045:
1046: stm_num :=4;
1047:
1048: DELETE FROM EGO_ITEM_PEOPLE_INTF WHERE DATA_SET_ID = p_batch_id AND PROCESS_STATUS IN (3,4,6,7);
1049:
1050: fnd_file.put_line(fnd_file.Log,'No.of Item People Entities deleted are '||SQL%ROWCOUNT);
1051:
1052: