[Home] [Help]
224: SELECT
225: SUM(NVL(RSL.AMOUNT, RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE))
226: INTO x_po_approved
227: FROM RCV_SHIPMENT_HEADERS RSH,
228: RCV_SHIPMENT_LINES RSL,
229: PO_LINE_LOCATIONS_ALL POLL
230: WHERE RSL.po_header_id = p_po_header_id
231: AND RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
232: AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
321: ELSIF(p_wc_stage = 'SHIPMENT') THEN
322:
323: SELECT SUM(NVL(RSL.AMOUNT_SHIPPED, Round(RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE,POS_WC_VIEW_CANCEL_PVT.get_currency_precision(poll.po_header_id))))
324: INTO l_ship_request
325: FROM RCV_SHIPMENT_LINES RSL,
326: RCV_SHIPMENT_HEADERS RSH,
327: PO_LINE_LOCATIONS_ALL POLL
328: WHERE RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
329: RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
355: --Function : Retrieve the progress on a pay item
356: --Parameter :
357: --IN : p_wc_pay_item_id IN NUMBER Required
358: -- corresponds to the column TRANSACTION_INTERFACE_ID or
359: -- SHIPMENT_LINE_ID in the table RCV_TRANSACTIONS_INTERFACE-- or RCV_SHIPMENT_LINES respectively, depending on the
360: -- p_wc_stage variable. The API is only implemented for
361: -- pay items in 'SHIPMENT' stage at the moment.
362: -- p_wc_stage IN VARCHAR2 Required
363: -- 'INTERFACE' or 'SHIPMENT. Indicates the pay item stage
407: l_amount_ordered,
408: l_quantity_ordered,
409: l_matching_basis,
410: l_line_location_id
411: FROM RCV_SHIPMENT_LINES RSL,
412: PO_LINE_LOCATIONS_ALL POLL
413: WHERE RSL.shipment_line_id = p_wc_pay_item_id and
414: POLL.line_location_id = RSL.po_line_location_id;
415:
502: ELSIF(p_wc_stage = 'SHIPMENT') THEN
503:
504: SELECT RSH.request_date INTO l_request_date
505: FROM RCV_SHIPMENT_HEADERS RSH,
506: RCV_SHIPMENT_LINES RSL
507: WHERE RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
508: RSL.SHIPMENT_LINE_ID = p_wc_pay_item_id;
509:
510: ELSIF(p_wc_stage = 'PO') THEN
550: SELECT sum(NVL(RSL.AMOUNT_SHIPPED, RSL.QUANTITY_SHIPPED))
551: INTO l_wc_prev_submitted_ship
552: FROM PO_LINE_LOCATIONS_ALL POLL,
553: RCV_SHIPMENT_HEADERS RSH,
554: RCV_SHIPMENT_LINES RSL
555: WHERE RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
556: RSL.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
557: (RSL.APPROVAL_STATUS is NULL OR
558: RSL.APPROVAL_STATUS in ('APPROVED', 'REJECTED', 'PROCESSED')) AND
673: UPDATE RCV_SHIPMENT_HEADERS
674: SET APPROVAL_STATUS = null, COMMENTS = null
675: WHERE SHIPMENT_HEADER_ID = p_wc_header_id;
676:
677: UPDATE RCV_SHIPMENT_LINES
678: SET APPROVAL_STATUS = null, COMMENTS = null
679: WHERE SHIPMENT_HEADER_ID = p_wc_header_id;
680:
681:
822: --po_distributions_all pod,
823: po_line_locations_all pll,
824: po_lines_all pl,
825: po_headers_all ph,
826: rcv_shipment_lines rsl,
827: rcv_shipment_headers rsh
828: WHERE
829: rsh.shipment_header_id = l_shipment_header_id
830: AND rsl.po_line_location_id = l_line_location_id