APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on EGO_AML_INTF

Line 147: ( -- Looking for failure rows in EGO_AML_INTF

143: AND Nvl(MICI.BUNDLE_ID,0) = Nvl(I.BUNDLE_ID,0)
144: AND ROWNUM = 1
145: )
146: ,
147: ( -- Looking for failure rows in EGO_AML_INTF
148: SELECT 'PARTIAL'
149: FROM EGO_AML_INTF EAI
150: WHERE
151: ( EAI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID

Line 149: FROM EGO_AML_INTF EAI

145: )
146: ,
147: ( -- Looking for failure rows in EGO_AML_INTF
148: SELECT 'PARTIAL'
149: FROM EGO_AML_INTF EAI
150: WHERE
151: ( EAI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
152: OR ( EAI.ITEM_NUMBER = I.ITEM_NUMBER
153: AND (

Line 255: FROM EGO_AML_INTF

251:
252: UNION
253:
254: SELECT DISTINCT DATA_SET_ID set_process_id, organization_id, ORGANIZATION_CODE, REQUEST_ID, INVENTORY_ITEM_ID, item_number, null BUNDLE_ID , PROCESS_FLAG
255: FROM EGO_AML_INTF
256: WHERE PROCESS_FLAG IN (3,6,7)
257:
258: /* UNION
259:

Line 406: DELETE FROM EGO_AML_INTF

402:
403:
404: FORALL item IN l_item_table.first .. l_item_table.last
405:
406: DELETE FROM EGO_AML_INTF
407: WHERE DATA_SET_ID = TREAT( l_item_table(item) AS Ego_item_list_inf).SET_PROCESS_ID
408: AND ( organization_id = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_id
409: OR ( organization_code = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_code
410: AND ( organization_code IS NULL OR TREAT( l_item_table(item) AS Ego_item_list_inf).organization_code IS NULL )

Line 1071: DELETE FROM EGO_AML_INTF WHERE DATA_SET_ID = p_batch_id AND PROCESS_FLAG IN (3,6,7);

1067:
1068: stm_num :=7;
1069:
1070:
1071: DELETE FROM EGO_AML_INTF WHERE DATA_SET_ID = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1072:
1073:
1074:
1075: DELETE FROM EGO_ITM_USR_ATTR_INTRFC WHERE DATA_SET_ID = p_batch_id AND PROCESS_STATUS IN (3,4,6,7);