DBA Data[Home] [Help]

APPS.CN_LEDGER_JE_BATCHES_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30

      INSERT INTO cn_ledger_je_batches
	(batch_id, reason, who, status, total)
	VALUES (cn_ledger_je_batches_s.nextval, X_reason, X_who,
		'UNPOSTED', 0);
Line: 35

      SELECT cn_ledger_je_batches_s.currval INTO Batch_Return FROM dual;
Line: 55

      INSERT INTO cn_ledger_je_batches
	(batch_id, reason, who, status, total,
			batch_name, batch_date)
	VALUES (cn_ledger_je_batches_s.nextval, X_reason, X_who,
		'UNPOSTED', 0, X_name, X_date);
Line: 61

      SELECT cn_ledger_je_batches_s.currval INTO Batch_Return FROM dual;