APPS.RCV_TRX_INTERFACE_INSERT_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 537: -- Procedure for updating vendor site id in rcv_shipment_headers.

533: CLOSE C;
534: END Insert_Row;
535:
536:
537: -- Procedure for updating vendor site id in rcv_shipment_headers.
538: PROCEDURE UPDATE_SITE_ID(X_GROUP_ID IN NUMBER,
539: X_SHIPMENT_HEADER_ID IN NUMBER,
540: X_ADD_RECEIPT IN VARCHAR2) IS
541:

Line 551: ** Determining the value of vendor_site_id to be populated in rcv_shipment_headers

547:
548: BEGIN
549:
550: /*
551: ** Determining the value of vendor_site_id to be populated in rcv_shipment_headers
552: */
553:
554: /* The following select statement sequences thru the RTI
555: ** for our group_id and determines whether the records have

Line 557: ** is the same, we populate this value in rcv_shipment_headers

553:
554: /* The following select statement sequences thru the RTI
555: ** for our group_id and determines whether the records have
556: ** the same vendor_site_id or not. If the vendor_site_id
557: ** is the same, we populate this value in rcv_shipment_headers
558: ** else we null it out.
559: */
560:
561: select count(count(vendor_site_id))

Line 570: from rcv_shipment_headers

566:
567:
568: select vendor_site_id
569: into hdr_vendor_site_id
570: from rcv_shipment_headers
571: where shipment_header_id = x_shipment_header_id;
572:
573:
574: if (x_site_id_count = 1) then

Line 593: update rcv_shipment_headers

589: hdr_vendor_site_id := '';
590:
591: end if;
592:
593: update rcv_shipment_headers
594: set vendor_site_id = hdr_vendor_site_id
595: where shipment_header_id = x_shipment_header_id;
596:
597: EXCEPTION