DBA Data[Home] [Help]

APPS.PO_DOCS_INTERFACE_PURGE dependencies on PO_LINES_INTERFACE

Line 46: -- PO_LINES_INTERFACE

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;
50:

Line 117: DELETE FROM po_lines_interface

113: d_position := 18;
114:
115:
116: FORALL i IN 1..l_intf_header_id_tbl.COUNT
117: DELETE FROM po_lines_interface
118: WHERE interface_header_id = l_intf_header_id_tbl(i);
119:
120: IF (PO_LOG.d_stmt) THEN
121: PO_LOG.stmt(d_module, d_position, '# line intf rec deleted' || SQL%ROWCOUNT);