APPS.RCV_UTILITIES dependencies on RCV_TRANSACTIONS_INTERFACE

Line 104: -- Updating rcv_transactions_interface

100: IF (g_asn_debug = 'Y') THEN
101: asn_debug.put_line('After updating rcv_headers_interface: count =' || sql%rowcount);
102: END IF;
103:
104: -- Updating rcv_transactions_interface
105: UPDATE rcv_transactions_interface
106: SET vendor_id = p_vendor_id,
107: vendor_site_id = p_vendor_site_id,
108: last_updated_by = l_last_updated_by,

Line 105: UPDATE rcv_transactions_interface

101: asn_debug.put_line('After updating rcv_headers_interface: count =' || sql%rowcount);
102: END IF;
103:
104: -- Updating rcv_transactions_interface
105: UPDATE rcv_transactions_interface
106: SET vendor_id = p_vendor_id,
107: vendor_site_id = p_vendor_site_id,
108: last_updated_by = l_last_updated_by,
109: last_update_date = sysdate

Line 115: UPDATE rcv_transactions_interface

111: AND vendor_id = p_dup_vendor_id
112: AND vendor_site_id is not null
113: AND vendor_site_id = p_dup_vendor_site_id ;
114:
115: UPDATE rcv_transactions_interface
116: SET vendor_id = p_vendor_id,
117: last_updated_by = l_last_updated_by,
118: last_update_date = sysdate
119: WHERE source_document_code = 'PO'

Line 124: asn_debug.put_line('After updating rcv_transactions_interface: count =' || sql%rowcount);

120: AND vendor_id = p_dup_vendor_id
121: AND vendor_site_id is null;
122:
123: IF (g_asn_debug = 'Y') THEN
124: asn_debug.put_line('After updating rcv_transactions_interface: count =' || sql%rowcount);
125: END IF;
126:
127: IF (g_asn_debug = 'Y') THEN
128: asn_debug.put_line('x_return_status: ' || x_return_status);