APPS.PO_SHIPMENTS_SV2 dependencies on PO_LINE_LOCATIONS

Line 25: FROM po_line_locations PLL

21: X_progress := '010';
22:
23: SELECT count(PLL.line_location_id)
24: INTO X_number_shipments
25: FROM po_line_locations PLL
26: WHERE PLL.po_line_id = X_po_line_id
27: AND PLL.shipment_type = X_shipment_type;
28:
29: IF (g_po_pdoi_write_to_file = 'Y') THEN

Line 114: FROM po_line_locations PLL

110: SELECT nvl(PLL.approved_flag,'N'),
111: nvl(PLL.encumbered_flag,'N'),
112: nvl(PLL.closed_code,'OPEN'),
113: nvl(PLL.cancel_flag,'N')
114: FROM po_line_locations PLL
115: WHERE PLL.line_location_id = X_line_location_id
116: AND PLL.shipment_type = X_shipment_type;
117:
118: BEGIN

Line 203: UPDATE PO_LINE_LOCATIONS

199: END IF;
200: /*
201: ** Update the purchase order shipment quantity to the lines qty.
202: */
203: UPDATE PO_LINE_LOCATIONS
204: SET quantity = X_line_quantity,
205: approved_flag = decode(approved_flag, 'N', 'N', 'R'),
206: last_update_date = sysdate,
207: last_updated_by = X_last_updated_by,

Line 440: UPDATE PO_LINE_LOCATIONS

436: /*
437: ** Update the purchase order shipment price to the lines unit
438: ** price for all shipments that are not cancelled.
439: */
440: UPDATE PO_LINE_LOCATIONS
441: SET price_override = X_unit_price,
442: approved_flag = decode(approved_flag, 'N', 'N', 'R'),
443: last_update_date = sysdate,
444: last_updated_by = X_last_updated_by,

Line 527: UPDATE PO_LINE_LOCATIONS

523: IF (g_po_pdoi_write_to_file = 'Y') THEN
524: po_debug.put_line('Before update statement');
525: END IF;
526:
527: UPDATE PO_LINE_LOCATIONS
528: SET
529: from_header_id = NULL,
530: from_line_id = NULL,
531: from_line_location_id = NULL