APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on EGO_ITM_USR_ATTR_INTRFC

Line 172: ( -- Looking for failure rows in EGO_ITM_USR_ATTR_INTRFC

168: AND EAI.REQUEST_ID = I.REQUEST_ID
169: AND ROWNUM = 1
170: )
171: ,
172: ( -- Looking for failure rows in EGO_ITM_USR_ATTR_INTRFC
173: SELECT 'PARTIAL'
174: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
175: WHERE
176: ( EIUAI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID

Line 174: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

170: )
171: ,
172: ( -- Looking for failure rows in EGO_ITM_USR_ATTR_INTRFC
173: SELECT 'PARTIAL'
174: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
175: WHERE
176: ( EIUAI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
177: OR ( EIUAI.ITEM_NUMBER = I.ITEM_NUMBER
178: AND (

Line 261: FROM EGO_ITM_USR_ATTR_INTRFC

257:
258: /* UNION
259:
260: SELECT DISTINCT DATA_SET_ID set_process_id, organization_id, ORGANIZATION_CODE, REQUEST_ID, INVENTORY_ITEM_ID, item_number, BUNDLE_ID , Decode ( PROCESS_STATUS,4,7,PROCESS_STATUS) PROCESS_FLAG
261: FROM EGO_ITM_USR_ATTR_INTRFC
262: WHERE PROCESS_STATUS IN (3,6,4)*/
263:
264: UNION
265:

Line 426: DELETE FROM EGO_ITM_USR_ATTR_INTRFC

422:
423:
424: FORALL item IN l_item_table.first .. l_item_table.last
425:
426: DELETE FROM EGO_ITM_USR_ATTR_INTRFC
427: WHERE DATA_SET_ID = TREAT( l_item_table(item) AS Ego_item_list_inf).SET_PROCESS_ID
428: AND ( organization_id = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_id
429: OR ( organization_code = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_code
430: AND ( organization_code IS NULL OR TREAT( l_item_table(item) AS Ego_item_list_inf).organization_code IS NULL )

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

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);
1076:
1077:
1078:
1079: