DBA Data[Home] [Help]

APPS.PO_POXREQIM_XMLP_PKG dependencies on PO_INTERFACE_ERRORS

Line 14: DELETE po_interface_errors

10:
11: if P_interface_source_code is NULL
12: and P_batch_id is NULL
13: and P_delete_flag = 'Y' then
14: DELETE po_interface_errors
15: WHERE interface_type = 'REQIMPORT';
16: DELETE po_requisitions_interface
17: WHERE process_flag = 'ERROR';
18: DELETE po_req_dist_interface

Line 25: DELETE po_interface_errors

21: elsif
22: P_interface_source_code is not NULL
23: and P_batch_id is NULL
24: and P_delete_flag = 'Y' then
25: DELETE po_interface_errors
26: WHERE interface_type = 'REQIMPORT'
27: AND interface_transaction_id IN
28: (SELECT transaction_id
29: FROM po_requisitions_interface

Line 43: DELETE po_interface_errors

39: elsif
40: P_interface_source_code is NULL
41: and P_batch_id is not NULL
42: and P_delete_flag = 'Y' then
43: DELETE po_interface_errors
44: WHERE interface_type = 'REQIMPORT'
45: AND interface_transaction_id IN
46: (SELECT transaction_id
47: FROM po_requisitions_interface

Line 62: DELETE po_interface_errors

58: elsif
59: P_interface_source_code is not NULL
60: and P_batch_id is not NULL
61: and P_delete_flag = 'Y' then
62: DELETE po_interface_errors
63: WHERE interface_type = 'REQIMPORT'
64: AND interface_transaction_id IN
65: (SELECT transaction_id
66: FROM po_requisitions_interface