APPS.PO_POXREQIM_XMLP_PKG dependencies on PO_REQUISITIONS_INTERFACE

Line 16: DELETE po_requisitions_interface

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
19: WHERE process_flag='ERROR';
20:

Line 29: FROM po_requisitions_interface

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
30: WHERE process_flag = 'ERROR'
31: AND interface_source_code = P_interface_source_code
32: );
33: DELETE po_requisitions_interface

Line 33: DELETE po_requisitions_interface

29: FROM po_requisitions_interface
30: WHERE process_flag = 'ERROR'
31: AND interface_source_code = P_interface_source_code
32: );
33: DELETE po_requisitions_interface
34: WHERE process_flag = 'ERROR'
35: AND interface_source_code = P_interface_source_code;
36: DELETE po_req_dist_interface
37: WHERE process_flag='ERROR'

Line 47: FROM po_requisitions_interface

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
48: WHERE process_flag = 'ERROR'
49: AND batch_id = P_batch_id
50: );
51: DELETE po_requisitions_interface

Line 51: DELETE po_requisitions_interface

47: FROM po_requisitions_interface
48: WHERE process_flag = 'ERROR'
49: AND batch_id = P_batch_id
50: );
51: DELETE po_requisitions_interface
52: WHERE process_flag = 'ERROR'
53: AND batch_id = P_batch_id ;
54: DELETE po_req_dist_interface
55: WHERE process_flag='ERROR'

Line 66: FROM po_requisitions_interface

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
67: WHERE process_flag = 'ERROR'
68: AND interface_source_code = P_interface_source_code
69: AND batch_id = P_batch_id
70: );

Line 71: DELETE po_requisitions_interface

67: WHERE process_flag = 'ERROR'
68: AND interface_source_code = P_interface_source_code
69: AND batch_id = P_batch_id
70: );
71: DELETE po_requisitions_interface
72: WHERE process_flag = 'ERROR'
73: AND interface_source_code = P_interface_source_code
74: AND batch_id = P_batch_id;
75: DELETE po_req_dist_interface