5445: BEGIN
5446: --
5447: -- Manager processing for OKC_K_LINES_B table
5448: --
5449: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5450: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5451: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5446: --
5447: -- Manager processing for OKC_K_LINES_B table
5448: --
5449: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5450: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5451: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5454:
5447: -- Manager processing for OKC_K_LINES_B table
5448: --
5449: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5450: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5451: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5454:
5455: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5449: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5450: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5451: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5454:
5455: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5456: X_retcode,
5457: 'OKS',
5458: 'OKSUBAFWKR',
5459: P_batch_size,
5460: P_Num_Workers);
5461:
5462: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5463: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5464:
5465: END Update_Annualized_Factor_BMGR;
5466:
5459: P_batch_size,
5460: P_Num_Workers);
5461:
5462: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5463: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5464:
5465: END Update_Annualized_Factor_BMGR;
5466:
5467: PROCEDURE Update_Annualized_Factor_HMGR(X_errbuf out NOCOPY varchar2,
5472: BEGIN
5473: --
5474: -- Manager processing for OKC_K_LINES_BH table
5475: --
5476: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5477: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5478: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5473: --
5474: -- Manager processing for OKC_K_LINES_BH table
5475: --
5476: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5477: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5478: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5481:
5474: -- Manager processing for OKC_K_LINES_BH table
5475: --
5476: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5477: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5478: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5481:
5482: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5476: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5477: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5478: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5481:
5482: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5483: X_retcode,
5484: 'OKS',
5485: 'OKSUHAFWKR',
5486: P_batch_size,
5487: P_Num_Workers);
5488:
5489: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5490: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5491:
5492: END Update_Annualized_Factor_HMGR;
5493:
5486: P_batch_size,
5487: P_Num_Workers);
5488:
5489: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5490: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5491:
5492: END Update_Annualized_Factor_HMGR;
5493:
5494: PROCEDURE Update_Annualized_Factor_BWKR(X_errbuf out NOCOPY varchar2,
5521: then
5522: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5523: end if;
5524:
5525: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5526: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5527: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5528:
5529: --
5522: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5523: end if;
5524:
5525: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5526: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5527: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5528:
5529: --
5530: -- Worker processing
5523: end if;
5524:
5525: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5526: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5527: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5528:
5529: --
5530: -- Worker processing
5531: --
5581: l_any_rows_to_process,
5582: P_batch_size,
5583: FALSE);
5584: end loop;
5585: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_B table completed successfully');
5586: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5587: X_errbuf := ' ';
5588: EXCEPTION
5589: WHEN OTHERS THEN
5588: EXCEPTION
5589: WHEN OTHERS THEN
5590: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5591: X_errbuf := SQLERRM;
5592: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5593: fnd_file.put_line(FND_FILE.LOG,' ');
5594: raise;
5595: END;
5596: END Update_Annualized_Factor_BWKR;
5589: WHEN OTHERS THEN
5590: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5591: X_errbuf := SQLERRM;
5592: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5593: fnd_file.put_line(FND_FILE.LOG,' ');
5594: raise;
5595: END;
5596: END Update_Annualized_Factor_BWKR;
5597:
5625: then
5626: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5627: end if;
5628:
5629: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5630: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5631: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5632:
5633: --
5626: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5627: end if;
5628:
5629: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5630: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5631: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5632:
5633: --
5634: -- Worker processing
5627: end if;
5628:
5629: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5630: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5631: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5632:
5633: --
5634: -- Worker processing
5635: --
5685: l_any_rows_to_process,
5686: P_batch_size,
5687: FALSE);
5688: end loop;
5689: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_BH table completed successfully');
5690: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5691: X_errbuf := ' ';
5692: EXCEPTION
5693: WHEN OTHERS THEN
5692: EXCEPTION
5693: WHEN OTHERS THEN
5694: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5695: X_errbuf := SQLERRM;
5696: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5697: fnd_file.put_line(FND_FILE.LOG,' ');
5698: raise;
5699: END;
5700: END Update_Annualized_Factor_HWKR;
5693: WHEN OTHERS THEN
5694: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5695: X_errbuf := SQLERRM;
5696: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5697: fnd_file.put_line(FND_FILE.LOG,' ');
5698: raise;
5699: END;
5700: END Update_Annualized_Factor_HWKR;
5701: --end npalepu