APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_K_LINES_BH

Line 5465: -- Manager processing for OKC_K_LINES_BH table

5461: P_Num_Workers in number)
5462: IS
5463: BEGIN
5464: --
5465: -- Manager processing for OKC_K_LINES_BH table
5466: --
5467: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5468: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5469: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

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

5467: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5468: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5469: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5470:
5471: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5472:
5473: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5474: X_retcode,
5475: 'OKS',

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

5616: then
5617: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5618: end if;
5619:
5620: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5621: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5622: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5623:
5624: --

Line 5662: okc_k_lines_bh cle

5658: / (cle.end_date - cle.start_date + 1)
5659: ELSE cle.annualized_factor
5660: end new_annualized_factor
5661: from okc_k_headers_all_bh hdr,
5662: okc_k_lines_bh cle
5663: where hdr.rowid between l_start_rowid and l_end_rowid
5664: and hdr.id = cle.dnz_chr_id
5665: and hdr.major_version = cle.major_version
5666: and hdr.scs_code in ('SERVICE', 'WARRANTY', 'SUBSCRIPTION'))

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

5676: l_any_rows_to_process,
5677: P_batch_size,
5678: FALSE);
5679: end loop;
5680: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_BH table completed successfully');
5681: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5682: X_errbuf := ' ';
5683: EXCEPTION
5684: WHEN OTHERS THEN