2354: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2355:
2356: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_b update worker ');
2357:
2358: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
2359: X_retcode,
2360: 'OKS',
2361: 'OKSTAXBWKR',
2362: P_batch_size,
2381: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2382:
2383: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_bh update worker ');
2384:
2385: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
2386: X_retcode,
2387: 'OKS',
2388: 'OKSTAXHWKR',
2389: P_batch_size,
2522: P_batch_size,
2523: FALSE);
2524: end loop;
2525: fnd_file.put_line(FND_FILE.LOG,'Upgrade for tax columns in OKS_K_LINES_B table completed successfully');
2526: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
2527: X_errbuf := ' ';
2528: EXCEPTION
2529: WHEN OTHERS THEN
2530: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
2526: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
2527: X_errbuf := ' ';
2528: EXCEPTION
2529: WHEN OTHERS THEN
2530: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
2531: X_errbuf := SQLERRM;
2532: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
2533: fnd_file.put_line(FND_FILE.LOG,' ');
2534: raise;
2662: P_batch_size,
2663: FALSE);
2664: end loop;
2665: fnd_file.put_line(FND_FILE.LOG,'Upgrade for tax columns in OKS_K_LINES_BH table completed successfully');
2666: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
2667: X_errbuf := ' ';
2668: EXCEPTION
2669: WHEN OTHERS THEN
2670: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
2666: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
2667: X_errbuf := ' ';
2668: EXCEPTION
2669: WHEN OTHERS THEN
2670: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
2671: X_errbuf := SQLERRM;
2672: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
2673: fnd_file.put_line(FND_FILE.LOG,' ');
2674: raise;