DBA Data[Home] [Help]

APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_LINES_DRAFT_ALL

Line 629: DELETE FROM po_lines_draft_all

625: IF (PO_LOG.d_proc) THEN
626: PO_LOG.proc_begin(d_module);
627: END IF;
628:
629: DELETE FROM po_lines_draft_all
630: WHERE draft_id = p_draft_id
631: AND change_accepted_flag = PO_DRAFTS_PVT.g_chg_accepted_flag_NOTIFY
632: RETURNING po_line_id
633: BULK COLLECT

Line 2787: po_lines_draft_all PLD

2783: x_lines.effective_date_tbl,
2784: x_lines.expiration_date_tbl
2785: FROM po_headers_interface PHI,
2786: po_lines_interface PLI,
2787: po_lines_draft_all PLD
2788: WHERE PHI.interface_header_id = p_doc_rec.interface_header_id
2789: AND PHI.interface_header_id = PLI.interface_header_id
2790: AND PHI.draft_id = PLD.draft_id
2791: AND PLI.po_line_id = PLD.po_line_id

Line 4225: UPDATE po_lines_draft_all SET

4221: IF (PO_LOG.d_stmt) THEN
4222: PO_LOG.stmt(d_module, d_position,'l_line_template_id was null in postproc: ' || l_line_template_id);
4223: END IF;
4224: --Update the templated id in po_lines_all
4225: UPDATE po_lines_draft_all SET
4226: uda_template_id = l_line_template_id
4227: WHERE po_header_id = p_po_header_id
4228: AND Nvl(draft_id,-1) = p_draft_id;
4229: