1: Package Body OKS_INTEGRATION_UTIL_PUB AS
2: /* $Header: OKSRIUTB.pls 120.2 2006/05/30 19:32:02 jvarghes noship $ */
3:
4:
5: -- Global constant for the maximum allowed sub-requests (parallel workers)
725: for idx in 1..l_subrequests loop
726:
727: ----errorout('1 range '||range_arr(idx).lo||'hi '||range_arr(idx).hi);
728: dbms_job.submit(range_arr(idx).jobno,
729: 'OKS_INTEGRATION_UTIL_PUB.get_dates(' ||
730: range_arr(idx).lo ||','|| range_arr(idx).hi ||');',
731: instance => get_instance_id);
732: commit;
733:
760:
761:
762:
763:
764: END OKS_INTEGRATION_UTIL_PUB;