APPS.FUN_TRX_PUB dependencies on DUAL

Line 767: Select fun_trx_batches_s.nextval INTO l_batch_id from dual;

763:
764: IF p_batch_rec.batch_id is not null then
765: l_batch_id :=p_batch_rec.batch_id;
766: Else
767: Select fun_trx_batches_s.nextval INTO l_batch_id from dual;
768: END IF;
769:
770: /* If all Validations pass then the record should be inserted into Fun Tables with status as New */
771: If x_return_Status = FND_API.G_RET_STS_SUCCESS then

Line 1226: /* -- Send Batch not individual transactions

1222:
1223: END LOOP; -- l_line_count
1224: End If; -- p_ dist_line_tbl not null
1225:
1226: /* -- Send Batch not individual transactions
1227: --raise Workflow event if p_sent='Y'
1228: IF p_sent = 'Y' THEN
1229: Print('Val and Insert >>>>'||'Raise Business Event');
1230: select FUN_TRX_BATCHES_S.CURRVAL into l_batch_id from dual;

Line 1230: select FUN_TRX_BATCHES_S.CURRVAL into l_batch_id from dual;

1226: /* -- Send Batch not individual transactions
1227: --raise Workflow event if p_sent='Y'
1228: IF p_sent = 'Y' THEN
1229: Print('Val and Insert >>>>'||'Raise Business Event');
1230: select FUN_TRX_BATCHES_S.CURRVAL into l_batch_id from dual;
1231: select FUN_TRX_HEADERS_S.CURRVAL into l_trx_id from dual;
1232: l_wfkey := fun_initiator_wf_pkg.generate_key(l_batch_id, l_trx_id);
1233: fun_wf_common.raise_wf_bus_event(l_batch_id, l_trx_id, l_wfkey, 'oracle.apps.fun.manualtrx.batch.send');
1234: END IF;

Line 1231: select FUN_TRX_HEADERS_S.CURRVAL into l_trx_id from dual;

1227: --raise Workflow event if p_sent='Y'
1228: IF p_sent = 'Y' THEN
1229: Print('Val and Insert >>>>'||'Raise Business Event');
1230: select FUN_TRX_BATCHES_S.CURRVAL into l_batch_id from dual;
1231: select FUN_TRX_HEADERS_S.CURRVAL into l_trx_id from dual;
1232: l_wfkey := fun_initiator_wf_pkg.generate_key(l_batch_id, l_trx_id);
1233: fun_wf_common.raise_wf_bus_event(l_batch_id, l_trx_id, l_wfkey, 'oracle.apps.fun.manualtrx.batch.send');
1234: END IF;
1235: */