APPS.RCV_TRX_INTERFACE_INSERT_PKG dependencies on RCV_SHIPMENT_HEADERS

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

539: CLOSE C;
540: END Insert_Row;
541:
542:
543: -- Procedure for updating vendor site id in rcv_shipment_headers.
544: PROCEDURE UPDATE_SITE_ID(X_GROUP_ID IN NUMBER,
545: X_SHIPMENT_HEADER_ID IN NUMBER,
546: X_ADD_RECEIPT IN VARCHAR2) IS
547:

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

553:
554: BEGIN
555:
556: /*
557: ** Determining the value of vendor_site_id to be populated in rcv_shipment_headers
558: */
559:
560: /* The following select statement sequences thru the RTI
561: ** for our group_id and determines whether the records have

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

559:
560: /* The following select statement sequences thru the RTI
561: ** for our group_id and determines whether the records have
562: ** the same vendor_site_id or not. If the vendor_site_id
563: ** is the same, we populate this value in rcv_shipment_headers
564: ** else we null it out.
565: */
566:
567: select count(count(vendor_site_id))

Line 576: from rcv_shipment_headers

572:
573:
574: select vendor_site_id
575: into hdr_vendor_site_id
576: from rcv_shipment_headers
577: where shipment_header_id = x_shipment_header_id;
578:
579:
580: if (x_site_id_count = 1) then

Line 601: update rcv_shipment_headers

597: end if;
598:
599: -- Bug 8340719 : Do not update rsh.vendor_site_id if no line/RTI is selected.
600: if (x_site_id_count > 0) then
601: update rcv_shipment_headers
602: set vendor_site_id = hdr_vendor_site_id
603: where shipment_header_id = x_shipment_header_id;
604: end if;
605: