DBA Data[Home] [Help]

APPS.PO_LINES_DRAFT_PKG dependencies on PO_LINES_ALL_EXT_TL

Line 753: -- from tables po_lines_all, po_lines_all_ext_b and po_lines_all_ext_tl.

749: -- bug5187544
750: -- Delete only records that have not been rejected
751: --
752: -- Collect all eligible lines to be deleted into a table, and then delete
753: -- from tables po_lines_all, po_lines_all_ext_b and po_lines_all_ext_tl.
754: SELECT po_line_id
755: BULK COLLECT
756: INTO l_line_id_tbl
757: FROM po_lines_draft_all PLD

Line 783: DELETE FROM po_lines_all_ext_tl

779: DELETE FROM po_lines_all_ext_b
780: WHERE po_line_id = l_line_id_tbl(i);
781:
782: FORALL i IN 1..l_line_id_tbl.Count()
783: DELETE FROM po_lines_all_ext_tl
784: WHERE po_line_id = l_line_id_tbl(i);
785:
786: d_position := 10;
787: IF (PO_LOG.d_proc) THEN