DBA Data[Home] [Help]

APPS.PO_DOCS_INTERFACE_PURGE dependencies on PO_LINE_LOCATIONS_INTERFACE

Line 47: -- PO_LINE_LOCATIONS_INTERFACE

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:
51: IF (PO_LOG.d_proc) THEN

Line 127: DELETE FROM po_line_locations_interface

123:
124: d_position := 20;
125:
126: FORALL i IN 1..l_intf_header_id_tbl.COUNT
127: DELETE FROM po_line_locations_interface
128: WHERE interface_header_id = l_intf_header_id_tbl(i);
129:
130: IF (PO_LOG.d_stmt) THEN
131: PO_LOG.stmt(d_module, d_position, '# line loc intf rec deleted' || SQL%ROWCOUNT);