APPS.RCV_UTILITIES dependencies on RCV_SHIPMENT_HEADERS

Line 44: -- Updating rcv_shipment_headers

40:
41: x_msg_count := 0;
42: x_msg_data := null;
43:
44: -- Updating rcv_shipment_headers
45: UPDATE rcv_shipment_headers
46: SET vendor_id = p_vendor_id,
47: vendor_site_id = p_vendor_site_id,
48: last_updated_by = l_last_updated_by,

Line 45: UPDATE rcv_shipment_headers

41: x_msg_count := 0;
42: x_msg_data := null;
43:
44: -- Updating rcv_shipment_headers
45: UPDATE rcv_shipment_headers
46: SET vendor_id = p_vendor_id,
47: vendor_site_id = p_vendor_site_id,
48: last_updated_by = l_last_updated_by,
49: last_update_date = sysdate

Line 55: UPDATE rcv_shipment_headers

51: AND vendor_id = p_dup_vendor_id
52: AND vendor_site_id is not null
53: AND vendor_site_id = p_dup_vendor_site_id ;
54:
55: UPDATE rcv_shipment_headers
56: SET vendor_id = p_vendor_id,
57: last_updated_by = l_last_updated_by,
58: last_update_date = sysdate
59: WHERE receipt_source_code = 'VENDOR'

Line 64: asn_debug.put_line('Updating rcv_shipment_headers: count =' || sql%rowcount);

60: AND vendor_id = p_dup_vendor_id
61: AND vendor_site_id is null;
62:
63: IF (g_asn_debug = 'Y') THEN
64: asn_debug.put_line('Updating rcv_shipment_headers: count =' || sql%rowcount);
65: END IF;
66:
67: -- Updating rcv_transactions
68: UPDATE rcv_transactions