DBA Data[Home] [Help]

APPS.AR_INVOICE_TABLE_HANDLER dependencies on RA_BATCHES

Line 237: INSERT INTO RA_BATCHES

233: END IF;
234:
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236:
237: INSERT INTO RA_BATCHES
238: (
239: CREATED_BY,
240: CREATION_DATE,
241: LAST_UPDATED_BY,

Line 266: RA_BATCHES_S.NEXTVAL,

262: fnd_global.login_id,
263: fnd_global.prog_appl_id,
264: null,
265: sysdate,
266: RA_BATCHES_S.NEXTVAL,
267: -(RA_BATCHES_S.currval),
268: 'AR_INVOICE_API'||'_'||RA_BATCHES_S.currval,
269: sysdate,
270: trunc(nvl(p_batch_source_rec.default_date,trunc(sysdate))),

Line 267: -(RA_BATCHES_S.currval),

263: fnd_global.prog_appl_id,
264: null,
265: sysdate,
266: RA_BATCHES_S.NEXTVAL,
267: -(RA_BATCHES_S.currval),
268: 'AR_INVOICE_API'||'_'||RA_BATCHES_S.currval,
269: sysdate,
270: trunc(nvl(p_batch_source_rec.default_date,trunc(sysdate))),
271: 'INV',

Line 268: 'AR_INVOICE_API'||'_'||RA_BATCHES_S.currval,

264: null,
265: sysdate,
266: RA_BATCHES_S.NEXTVAL,
267: -(RA_BATCHES_S.currval),
268: 'AR_INVOICE_API'||'_'||RA_BATCHES_S.currval,
269: sysdate,
270: trunc(nvl(p_batch_source_rec.default_date,trunc(sysdate))),
271: 'INV',
272: nvl(p_batch_source_rec.batch_source_id, p_trx_profile_rec.ar_ra_batch_source),