APPS.RCV_ROI_HEADER_COMMON dependencies on RCV_SHIPMENT_HEADERS

Line 216: FROM rcv_shipment_headers

212: IF p_header_record.header_record.receipt_header_id IS NULL THEN
213: BEGIN
214: SELECT MAX(shipment_header_id) -- if we ever have 2 shipments with the same combo
215: INTO p_header_record.header_record.receipt_header_id
216: FROM rcv_shipment_headers
217: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
218: AND vendor_id = p_header_record.header_record.vendor_id
219: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
220: AND shipment_num = p_header_record.header_record.shipment_num

Line 322: FROM rcv_shipment_headers rsh

318:
319: IF (x_shipment_header_id IS NULL and x_shipment_num IS NOT NULL) THEN
320: SELECT MAX(rsh.shipment_header_id)
321: INTO x_shipment_header_id
322: FROM rcv_shipment_headers rsh
323: WHERE rsh.shipment_num = x_shipment_num;
324: END IF;
325:
326: IF (x_shipment_header_id IS NOT NULL) THEN

Line 437: FROM rcv_shipment_headers

433:
434: LOOP
435: SELECT COUNT(*)
436: INTO l_count
437: FROM rcv_shipment_headers
438: WHERE receipt_num = p_header_record.header_record.receipt_num
439: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
440:
441: IF l_count = 0 THEN

Line 590: SELECT rcv_shipment_headers_s.NEXTVAL

586: /* generate the shipment_header_id */
587: /* shipment_header_id - receipt_header_id is the same */
588: IF p_header_record.header_record.receipt_header_id IS NULL
589: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
590: SELECT rcv_shipment_headers_s.NEXTVAL
591: INTO p_header_record.header_record.receipt_header_id
592: FROM SYS.DUAL;
593:
594: /* Bug#4523892 */

Line 886: FROM rcv_shipment_headers

882: p_header_record.header_record.receipt_num IS NOT NULL
883: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
884: SELECT COUNT(*)
885: INTO x_count
886: FROM rcv_shipment_headers
887: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num
888: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
889:
890: IF x_count > 0 THEN

Line 887: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num

883: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
884: SELECT COUNT(*)
885: INTO x_count
886: FROM rcv_shipment_headers
887: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num
888: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
889:
890: IF x_count > 0 THEN
891: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;