APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_K_LINES_BH

Line 5474: -- Manager processing for OKC_K_LINES_BH table

5470: P_Num_Workers in number)
5471: IS
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);

Line 5480: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');

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',

Line 5629: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');

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: --

Line 5671: okc_k_lines_bh cle

5667: / (cle.end_date - cle.start_date + 1)
5668: ELSE cle.annualized_factor
5669: end new_annualized_factor
5670: from okc_k_headers_all_bh hdr,
5671: okc_k_lines_bh cle
5672: where hdr.rowid between l_start_rowid and l_end_rowid
5673: and hdr.id = cle.dnz_chr_id
5674: and hdr.major_version = cle.major_version
5675: and hdr.scs_code in ('SERVICE', 'WARRANTY', 'SUBSCRIPTION'))

Line 5689: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_BH table completed successfully');

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