APPS.PO_LINES_DRAFT_PKG dependencies on PO_LINES_ALL

Line 591: FROM po_lines_all

587: clm_pop_exception_reason,
588: clm_exhibit_name,
589: unit_meas_lookup_code, --- Old UOM
590: Nvl(revision_num, 0) --
591: FROM po_lines_all
592: WHERE po_line_id = p_po_line_id_tbl(i)
593: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
594: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
595:

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 762: /*DELETE FROM po_lines_all PL

758: WHERE PLD.draft_id = p_draft_id
759: AND PLD.delete_flag = 'Y'
760: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y';
761:
762: /*DELETE FROM po_lines_all PL
763: WHERE PL.po_line_id IN
764: ( SELECT PLD.po_line_id
765: FROM po_lines_draft_all PLD
766: WHERE PLD.draft_id = p_draft_id

Line 772: DELETE FROM po_lines_all

768: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y' );
769: */
770:
771: FORALL i IN 1..l_line_id_tbl.Count()
772: DELETE FROM po_lines_all
773: WHERE po_line_id = l_line_id_tbl(i);
774:
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

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

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

Line 812: MERGE INTO po_lines_all PL

808: --PL.bid_line_number
809: --PL.svc_amount_notif_sent
810: --PL.svc_completion_notif_sent
811: --PL.uda_template_id
812: MERGE INTO po_lines_all PL
813: USING (
814: SELECT
815: PLD.draft_id,
816: PLD.delete_flag,

Line 1641: FROM po_lines_all

1637: END IF;
1638:
1639: SELECT 1
1640: INTO l_dummy
1641: FROM po_lines_all
1642: WHERE po_line_id = p_po_line_id
1643: FOR UPDATE NOWAIT;
1644:
1645: IF (PO_LOG.d_proc) THEN