APPS.RCV_BILL_UPDATING_SV dependencies on RCV_TRANSACTIONS

Line 163: PROCEDURE ap_update_rcv_transactions( X_rcv_transaction_id IN NUMBER,

159: END ap_update_po_line_locations;
160:
161:
162:
163: PROCEDURE ap_update_rcv_transactions( X_rcv_transaction_id IN NUMBER,
164: X_quantity_billed IN NUMBER,
165: X_uom_lookup_code IN VARCHAR2,
166: X_amount_billed IN NUMBER,
167: X_matching_basis IN VARCHAR2) IS

Line 190: rcv_transactions rt,

186: X_rcv_quantity_billed,
187: X_rcv_amount_billed,
188: X_item_id
189: FROM
190: rcv_transactions rt,
191: rcv_shipment_lines rs
192: WHERE
193: rt.transaction_id = X_rcv_transaction_id AND
194: rs.shipment_line_id = rt.shipment_line_id;

Line 214: /* Update RCV_TRANSACTIONS */

210: X_rcv_amount_billed := X_rcv_amount_billed + X_amount_billed;
211:
212: X_progress := '003';
213:
214: /* Update RCV_TRANSACTIONS */
215: --Bug#2602981.Changed the X_rcv_quantity_billed to round(X_rcv_quantity_billed,15)
216: UPDATE
217: rcv_transactions
218: SET

Line 217: rcv_transactions

213:
214: /* Update RCV_TRANSACTIONS */
215: --Bug#2602981.Changed the X_rcv_quantity_billed to round(X_rcv_quantity_billed,15)
216: UPDATE
217: rcv_transactions
218: SET
219: quantity_billed = round(X_rcv_quantity_billed,15),
220: amount_billed = X_rcv_amount_billed
221: WHERE

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

225:
226: EXCEPTION
227:
228: when others then
229: po_message_s.sql_error('ap_update_rcv_transactions', X_progress, sqlcode);
230: raise;
231:
232: END ap_update_rcv_transactions;
233:

Line 232: END ap_update_rcv_transactions;

228: when others then
229: po_message_s.sql_error('ap_update_rcv_transactions', X_progress, sqlcode);
230: raise;
231:
232: END ap_update_rcv_transactions;
233:
234:
235:
236: END RCV_BILL_UPDATING_SV;