APPS.PO_POXREQIM_XMLP_PKG dependencies on PO_REQ_DIST_INTERFACE

Line 18: DELETE po_req_dist_interface

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:
21: elsif
22: P_interface_source_code is not NULL

Line 36: DELETE po_req_dist_interface

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'
38: AND interface_source_code = P_interface_source_code;
39: elsif
40: P_interface_source_code is NULL

Line 54: DELETE po_req_dist_interface

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'
56: AND batch_id=P_batch_id;
57:
58: elsif

Line 75: DELETE po_req_dist_interface

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
76: WHERE process_flag='ERROR'
77: AND interface_source_code=P_interface_source_code
78: AND batch_id=P_batch_id;
79: