APPS.PO_LINES_DRAFT_PKG dependencies on PO_LINES_DRAFT_ALL

Line 83: DELETE FROM po_lines_draft_all

79: p_po_line_id||'-'||p_draft_id,
80: '', '', '', '', '');
81: END IF;
82:
83: DELETE FROM po_lines_draft_all
84: WHERE draft_id = p_draft_id
85: AND po_line_id = NVL(p_po_line_id, po_line_id);
86:
87: d_position := 10;

Line 200: INSERT INTO po_lines_draft_all

196: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
197: END IF;
198:
199: FORALL i IN 1..p_po_line_id_tbl.COUNT
200: INSERT INTO po_lines_draft_all
201: (
202: draft_id,
203: delete_flag,
204: change_accepted_flag,

Line 602: UPDATE po_lines_draft_all

598: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
599: END IF;
600:
601: FORALL i IN 1..p_po_line_id_tbl.COUNT
602: UPDATE po_lines_draft_all
603: SET delete_flag = p_delete_flag_tbl(i)
604: WHERE po_line_id = p_po_line_id_tbl(i)
605: AND draft_id = p_draft_id_tbl(i)
606: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 757: FROM po_lines_draft_all PLD

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
758: WHERE PLD.draft_id = p_draft_id
759: AND PLD.delete_flag = 'Y'
760: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y';
761:

Line 765: FROM po_lines_draft_all PLD

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
767: AND PLD.delete_flag = 'Y'
768: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y' );
769: */

Line 1002: FROM po_lines_draft_all PLD

998: PLD.clm_approved_undef_amount,
999: PLD.clm_uda_pricing_total,
1000: PLD.clm_pop_exception_reason,
1001: PLD.clm_exhibit_name
1002: FROM po_lines_draft_all PLD
1003: WHERE PLD.draft_id = p_draft_id
1004: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y'
1005: ) PLDV
1006: ON (PL.po_line_id = PLDV.po_line_id)

Line 1597: FROM po_lines_draft_all

1593: END IF;
1594:
1595: SELECT 1
1596: INTO l_dummy
1597: FROM po_lines_draft_all
1598: WHERE po_line_id = p_po_line_id
1599: AND draft_id = p_draft_id
1600: FOR UPDATE NOWAIT;
1601: