APPS.POS_WC_CREATE_UPDATE_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 227: FROM RCV_SHIPMENT_HEADERS RSH,

223:
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

Line 326: RCV_SHIPMENT_HEADERS RSH,

322:
323: SELECT SUM(NVL(RSL.AMOUNT_SHIPPED, RSL.QUANTITY_SHIPPED*POLL.PRICE_OVERRIDE))
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
330: RSH.SHIPMENT_HEADER_ID = p_wc_id;

Line 505: FROM RCV_SHIPMENT_HEADERS RSH,

501:
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:

Line 553: RCV_SHIPMENT_HEADERS RSH,

549:
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

Line 591: -- the table RCV_SHIPMENT_HEADERS.

587: --Function : complete the WC approval block of the WCAPPRV workflow
588: --Parameter :
589: --IN : p_wc_header_id IN NUMBER Required
590: -- corresponds to the column SHIPMENT_HEADER_ID in
591: -- the table RCV_SHIPMENT_HEADERS.
592: --OUT : x_return_status OUT VARCHAR2
593: -- return status of the procedure.
594: -- x_return_msg OUT VARCHAR2
595: -- return message of the procedure.

Line 615: FROM RCV_SHIPMENT_HEADERS

611: BEGIN
612:
613: SELECT WF_ITEM_KEY, WF_ITEM_TYPE
614: INTO l_wf_item_key,l_wf_item_type
615: FROM RCV_SHIPMENT_HEADERS
616: WHERE SHIPMENT_HEADER_ID = p_wc_header_id;
617:
618: WF_ENGINE.CompleteActivity(l_wf_item_type,
619: l_wf_item_key,

Line 643: -- the table RCV_SHIPMENT_HEADERS.

639: -- : rejected WC
640: --Parameter :
641: --IN : p_wc_header_id IN NUMBER Required
642: -- corresponds to the column SHIPMENT_HEADER_ID in
643: -- the table RCV_SHIPMENT_HEADERS.
644: --OUT : x_return_status OUT VARCHAR2
645: -- return status of the procedure.
646: -- x_return_msg OUT VARCHAR2
647: -- return message of the procedure.

Line 673: UPDATE RCV_SHIPMENT_HEADERS

669: */
670:
671: --1)Reset the Approval Status and Comment columns of the Header and the Lines
672:
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