234: END IF;
235:
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237:
238: INSERT INTO RA_BATCHES
239: (
240: CREATED_BY,
241: CREATION_DATE,
242: LAST_UPDATED_BY,
263: fnd_global.login_id,
264: fnd_global.prog_appl_id,
265: null,
266: sysdate,
267: RA_BATCHES_S.NEXTVAL,
268: -(RA_BATCHES_S.currval),
269: 'AR_INVOICE_API'||'_'||RA_BATCHES_S.currval,
270: sysdate,
271: trunc(nvl(p_batch_source_rec.default_date,trunc(sysdate))),
264: fnd_global.prog_appl_id,
265: null,
266: sysdate,
267: RA_BATCHES_S.NEXTVAL,
268: -(RA_BATCHES_S.currval),
269: 'AR_INVOICE_API'||'_'||RA_BATCHES_S.currval,
270: sysdate,
271: trunc(nvl(p_batch_source_rec.default_date,trunc(sysdate))),
272: 'INV',
265: null,
266: sysdate,
267: RA_BATCHES_S.NEXTVAL,
268: -(RA_BATCHES_S.currval),
269: 'AR_INVOICE_API'||'_'||RA_BATCHES_S.currval,
270: sysdate,
271: trunc(nvl(p_batch_source_rec.default_date,trunc(sysdate))),
272: 'INV',
273: nvl(p_batch_source_rec.batch_source_id, p_trx_profile_rec.ar_ra_batch_source),