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
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);