280:
281: END get_account;
282:
283: /************************************************************************/
284: /* Procedure ins_ra_batches */
285: /* Purpose : Get all the fields to insert row in ra_batches */
286: /************************************************************************/
287:
288: PROCEDURE ins_ra_batches (
281: END get_account;
282:
283: /************************************************************************/
284: /* Procedure ins_ra_batches */
285: /* Purpose : Get all the fields to insert row in ra_batches */
286: /************************************************************************/
287:
288: PROCEDURE ins_ra_batches (
289: X_batch_source_id IN NUMBER,
284: /* Procedure ins_ra_batches */
285: /* Purpose : Get all the fields to insert row in ra_batches */
286: /************************************************************************/
287:
288: PROCEDURE ins_ra_batches (
289: X_batch_source_id IN NUMBER,
290: X_invoice_amount IN NUMBER,
291: X_invoice_currency_code IN VARCHAR2,
292: X_user_id IN NUMBER,
293: X_batch_id IN OUT NOCOPY NUMBER
294: ) IS
295: X_batch_name VARCHAR2(50);
296: X_set_of_books_id NUMBER(15);
297: X_batch_rec ra_batches%ROWTYPE;
298: BEGIN
299:
300: SELECT set_of_books_id
301: INTO X_set_of_books_id
310: X_batch_rec.control_amount := X_invoice_amount;
311: X_batch_rec.currency_code := X_invoice_currency_code;
312: --arp_tbat_pkg.insert_p(X_batch_rec, X_batch_id, X_batch_name);
313:
314: END ins_ra_batches;
315:
316: /************************************************************************/
317: /* Function : Generate_Interest_DM_Number */
318: /* Purpose : Get the number to the transaction */
1093: FROM ra_customer_trx, fnd_currencies_vl
1094: WHERE customer_trx_id = X_original_customer_trx_id
1095: AND invoice_currency_code = currency_code;
1096:
1097: jl_br_ar_generate_debit_memo.ins_ra_batches ( X_batch_source_id,
1098: X_invoice_amount,
1099: X_invoice_currency_code,
1100: X_user_id,
1101: X_batch_id );