APPS.RCV_BILL_UPDATING_SV dependencies on RCV_TRANSACTIONS

Line 171: PROCEDURE ap_update_rcv_transactions( X_rcv_transaction_id IN NUMBER,

167: END ap_update_po_line_locations;
168:
169:
170:
171: PROCEDURE ap_update_rcv_transactions( X_rcv_transaction_id IN NUMBER,
172: X_quantity_billed IN NUMBER,
173: X_uom_lookup_code IN VARCHAR2,
174: X_amount_billed IN NUMBER,
175: X_matching_basis IN VARCHAR2) IS

Line 198: rcv_transactions rt,

194: X_rcv_quantity_billed,
195: X_rcv_amount_billed,
196: X_item_id
197: FROM
198: rcv_transactions rt,
199: rcv_shipment_lines rs
200: WHERE
201: rt.transaction_id = X_rcv_transaction_id AND
202: rs.shipment_line_id = rt.shipment_line_id;

Line 222: /* Update RCV_TRANSACTIONS */

218: X_rcv_amount_billed := X_rcv_amount_billed + X_amount_billed;
219:
220: X_progress := '003';
221:
222: /* Update RCV_TRANSACTIONS */
223: --Bug#2602981.Changed the X_rcv_quantity_billed to round(X_rcv_quantity_billed,15)
224: --Bug 12886371. Added the updation of who columns
225: UPDATE
226: rcv_transactions

Line 226: rcv_transactions

222: /* Update RCV_TRANSACTIONS */
223: --Bug#2602981.Changed the X_rcv_quantity_billed to round(X_rcv_quantity_billed,15)
224: --Bug 12886371. Added the updation of who columns
225: UPDATE
226: rcv_transactions
227: SET
228: quantity_billed = round(X_rcv_quantity_billed,15),
229: amount_billed = X_rcv_amount_billed,
230: last_updated_by = fnd_global.user_id,

Line 241: po_message_s.sql_error('ap_update_rcv_transactions', X_progress, sqlcode);

237:
238: EXCEPTION
239:
240: when others then
241: po_message_s.sql_error('ap_update_rcv_transactions', X_progress, sqlcode);
242: raise;
243:
244: END ap_update_rcv_transactions;
245:

Line 244: END ap_update_rcv_transactions;

240: when others then
241: po_message_s.sql_error('ap_update_rcv_transactions', X_progress, sqlcode);
242: raise;
243:
244: END ap_update_rcv_transactions;
245:
246:
247:
248: END RCV_BILL_UPDATING_SV;