APPS.FUN_TRX_PUB dependencies on DUAL

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

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

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

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

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

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

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

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