APPS.PO_LINES_DRAFT_PKG dependencies on PO_LINES_ALL_EXT_B

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 779: DELETE FROM po_lines_all_ext_b

775: -- Note that draft_id condition is not required here, as line deletion is
776: -- allowed only for unapproved lines. Thus there will be only one row for
777: -- the po_line_id
778: FORALL i IN 1..l_line_id_tbl.Count()
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