DBA Data[Home] [Help]

APPS.AR_INVOICE_TABLE_HANDLER dependencies on RA_BATCHES

Line 238: INSERT INTO RA_BATCHES

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,

Line 267: RA_BATCHES_S.NEXTVAL,

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))),

Line 268: -(RA_BATCHES_S.currval),

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',

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

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),