APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 678: FROM po_line_locations_all PLLA

674: AND PLLD.po_line_id = l_po_line_id_tbl(i)
675: AND PLLD.line_location_id = PPDD.entity_id
676: UNION ALL
677: SELECT 1
678: FROM po_line_locations_all PLLA
679: WHERE PLLA.po_line_id = l_po_line_id_tbl(i)
680: AND PLLA.line_location_id = PPDD.entity_id);
681:
682: IF (PO_LOG.d_proc) THEN

Line 3268: UPDATE po_line_locations_all

3264: END IF;
3265:
3266: -- Shipments/Price Breaks should be marked as APPROVED if the document
3267: -- is imported as approved
3268: UPDATE po_line_locations_all
3269: SET approved_flag = 'Y',
3270: approved_date = l_approved_date,
3271: last_update_date = SYSDATE,
3272: last_updated_by = FND_GLOBAL.user_id,

Line 4243: --Update the templated id in po_line_locations_all

4239: IF (PO_LOG.d_stmt) THEN
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;