DBA Data[Home] [Help]

APPS.RCV_UTILITIES dependencies on RCV_HEADERS_INTERFACE

Line 81: -- Updating rcv_headers_interface

77: IF (g_asn_debug = 'Y') THEN
78: asn_debug.put_line('After updating rcv_transactions: count =' || sql%rowcount);
79: END IF;
80:
81: -- Updating rcv_headers_interface
82: UPDATE rcv_headers_interface
83: SET vendor_id = p_vendor_id,
84: vendor_site_id = p_vendor_site_id,
85: last_updated_by = l_last_updated_by,

Line 82: UPDATE rcv_headers_interface

78: asn_debug.put_line('After updating rcv_transactions: count =' || sql%rowcount);
79: END IF;
80:
81: -- Updating rcv_headers_interface
82: UPDATE rcv_headers_interface
83: SET vendor_id = p_vendor_id,
84: vendor_site_id = p_vendor_site_id,
85: last_updated_by = l_last_updated_by,
86: last_update_date = sysdate

Line 92: UPDATE rcv_headers_interface

88: AND vendor_id = p_dup_vendor_id
89: AND vendor_site_id is not null
90: AND vendor_site_id = p_dup_vendor_site_id ;
91:
92: UPDATE rcv_headers_interface
93: SET vendor_id = p_vendor_id,
94: last_updated_by = l_last_updated_by,
95: last_update_date = sysdate
96: WHERE receipt_source_code = 'VENDOR'

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

97: AND vendor_id = p_dup_vendor_id
98: AND vendor_site_id is null;
99:
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