APPS.RCV_UTILITIES dependencies on RCV_TRANSACTIONS

Line 67: -- Updating rcv_transactions

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
69: SET vendor_id = p_vendor_id,
70: vendor_site_id = p_vendor_site_id,
71: last_updated_by = l_last_updated_by,

Line 68: UPDATE rcv_transactions

64: asn_debug.put_line('Updating rcv_shipment_headers: count =' || sql%rowcount);
65: END IF;
66:
67: -- Updating rcv_transactions
68: UPDATE rcv_transactions
69: SET vendor_id = p_vendor_id,
70: vendor_site_id = p_vendor_site_id,
71: last_updated_by = l_last_updated_by,
72: last_update_date = sysdate

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

74: AND vendor_id = p_dup_vendor_id
75: AND vendor_site_id = p_dup_vendor_site_id ;
76:
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

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);

Line 177: FROM rcv_transactions rt,

173: nvl(pll.lcm_flag,'N')
174: INTO x_pll_id,
175: x_org_id,
176: x_lcm_flag
177: FROM rcv_transactions rt,
178: po_line_locations_all pll
179: WHERE rt.po_line_location_id is not null
180: AND rt.po_line_location_id = pll.line_location_id
181: AND transaction_id = p_rcv_transaction_id;