APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 639: DELETE FROM po_line_locations_draft_all

635:
636: d_position := 10;
637:
638: FORALL i IN 1..l_po_line_id_tbl.COUNT
639: DELETE FROM po_line_locations_draft_all
640: WHERE draft_id = p_draft_id
641: AND po_line_id = l_po_line_id_tbl(i);
642:
643: d_position := 20;

Line 672: FROM po_line_locations_draft_all PLLD

668: DELETE FROM po_price_diff_draft PPDD
669: WHERE draft_id = p_draft_id
670: AND entity_type = 'PRICE BREAK'
671: AND EXISTS (SELECT 1
672: FROM po_line_locations_draft_all PLLD
673: WHERE PLLD.draft_id = p_draft_id
674: AND PLLD.po_line_id = l_po_line_id_tbl(i)
675: AND PLLD.line_location_id = PPDD.entity_id
676: UNION ALL

Line 4244: UPDATE po_line_locations_draft_all SET

4240: PO_LOG.stmt(d_module, d_position,'l_shipment_template_id was null in postproc: ' || l_shipment_template_id);
4241: END IF;
4242:
4243: --Update the templated id in po_line_locations_all
4244: UPDATE po_line_locations_draft_all SET
4245: uda_template_id = l_shipment_template_id
4246: WHERE po_header_id = p_po_header_id
4247: AND Nvl(draft_id,-1) = p_draft_id;
4248: