APPS.PO_DOCS_INTERFACE_PURGE dependencies on PO_HEADERS_INTERFACE

Line 45: -- PO_HEADERS_INTERFACE

41: --
42: -- The whole procedure is refactored to remove repetitive code
43: -- Also, this procedure will now delete data from the following interface
44: -- tables:
45: -- PO_HEADERS_INTERFACE
46: -- PO_LINES_INTERFACE
47: -- PO_LINE_LOCATIONS_INTERFACE
48:
49: d_position := 0;

Line 66: FROM po_headers_interface

62: process_code
63: BULK COLLECT
64: INTO l_intf_header_id_tbl,
65: l_process_code_tbl
66: FROM po_headers_interface
67: WHERE (batch_id = X_selected_batch_id
68: OR X_selected_batch_id IS NULL )
69:
70: AND ((process_code = PO_PDOI_CONSTANTS.g_process_code_ACCEPTED and X_accepted_flag = 'Y')

Line 106: DELETE FROM po_headers_interface

102:
103: -- bug5471513
104: -- delete header interface records after filtering
105: FORALL i IN 1..l_intf_header_id_tbl.COUNT
106: DELETE FROM po_headers_interface
107: WHERE interface_header_id = l_intf_header_id_tbl(i);
108:
109: IF (PO_LOG.d_stmt) THEN
110: PO_LOG.stmt(d_module, d_position, '# hdr intf rec deleted' || SQL%ROWCOUNT);