APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on EGO_ITEM_ASSOCIATIONS_INTF

Line 198: /* ( -- Looking for failure rows in EGO_ITEM_ASSOCIATIONS_INTF

194: AND Nvl(EIUAI.BUNDLE_ID,0) = Nvl(I.BUNDLE_ID,0)
195: AND ROWNUM = 1
196: )
197: ,
198: /* ( -- Looking for failure rows in EGO_ITEM_ASSOCIATIONS_INTF
199: SELECT 'PARTIAL'
200: FROM EGO_ITEM_ASSOCIATIONS_INTF EIAI
201: WHERE
202: ( EIAI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID

Line 200: FROM EGO_ITEM_ASSOCIATIONS_INTF EIAI

196: )
197: ,
198: /* ( -- Looking for failure rows in EGO_ITEM_ASSOCIATIONS_INTF
199: SELECT 'PARTIAL'
200: FROM EGO_ITEM_ASSOCIATIONS_INTF EIAI
201: WHERE
202: ( EIAI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
203: OR ( EIAI.ITEM_NUMBER = I.ITEM_NUMBER
204: AND (

Line 267: FROM EGO_ITEM_ASSOCIATIONS_INTF

263:
264: UNION
265:
266: SELECT DISTINCT BATCH_ID set_process_id, organization_id, ORGANIZATION_CODE, REQUEST_ID, INVENTORY_ITEM_ID, item_number, BUNDLE_ID, PROCESS_FLAG
267: FROM EGO_ITEM_ASSOCIATIONS_INTF
268: WHERE PROCESS_FLAG IN (3,6,7)
269: ) I
270: WHERE set_process_id = batch_id );
271:

Line 446: DELETE FROM EGO_ITEM_ASSOCIATIONS_INTF EIAI

442:
443:
444: FORALL item IN l_item_table.first .. l_item_table.last
445:
446: DELETE FROM EGO_ITEM_ASSOCIATIONS_INTF EIAI
447: WHERE TREAT( l_item_table(item) AS Ego_item_list_inf).status=p_purge_criteria
448: AND BATCH_ID = TREAT( l_item_table(item) AS Ego_item_list_inf).SET_PROCESS_ID
449: AND ( organization_id = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_id
450: OR ( ORGANIZATION_CODE = TREAT( l_item_table(item) AS Ego_item_list_inf).ORGANIZATION_CODE

Line 1063: DELETE FROM EGO_ITEM_ASSOCIATIONS_INTF WHERE BATCH_ID = p_batch_id AND PROCESS_FLAG IN (3,6,7);

1059:
1060: stm_num :=6;
1061:
1062:
1063: DELETE FROM EGO_ITEM_ASSOCIATIONS_INTF WHERE BATCH_ID = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1064:
1065: fnd_file.put_line(fnd_file.Log,'No.of Item Association Entities deleted are '||SQL%ROWCOUNT);
1066:
1067: