17: p_end_date,
18: p_no_of_workers
19: );
20: EXCEPTION
21: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
22: retcode := -2;
23: ROLLBACK;
24: WHEN OTHERS THEN
25: errbuf := sqlerrm;
44: p_start_date,
45: p_end_date
46: );
47: EXCEPTION
48: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
49: retcode := -2;
50: ROLLBACK;
51: WHEN OTHERS THEN
52: errbuf := sqlerrm;
75: p_no_of_workers
76: );
77:
78: EXCEPTION
79: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
80: retcode := -2;
81: ROLLBACK;
82: WHEN OTHERS THEN
83: errbuf := sqlerrm;