eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_TAX_UTIL_PVT dependencies on OKS_K_LINES_B

Line 72: FROM OKS_K_LINES_B

68: EXEMPT_REASON_CODE,
69: TAX_EXEMPTION_ID,
70: TAX_CLASSIFICATION_CODE,
71: TAX_CODE
72: FROM OKS_K_LINES_B
73: WHERE dnz_chr_id = p_chr_id
74: AND cle_id = p_line_id;
75:
76: ------------------------ End pakcage body declarations ----------------------------------

Line 2350: -- Manager processing for OKS_K_LINES_B table

2346: P_Num_Workers in number)
2347: IS
2348: BEGIN
2349: --
2350: -- Manager processing for OKS_K_LINES_B table
2351: --
2352: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_BMGR ');
2353: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2354: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

Line 2356: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_b update worker ');

2352: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_BMGR ');
2353: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
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',

Line 2377: -- Manager processing for OKS_K_LINES_BH table

2373: P_Num_Workers in number)
2374: IS
2375: BEGIN
2376: --
2377: -- Manager processing for OKS_K_LINES_BH table
2378: --
2379: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_HMGR ');
2380: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2381: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

Line 2383: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_bh update worker ');

2379: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_HMGR ');
2380: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||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',

Line 2400: OKS_K_LINES_B:

2396:
2397: /*
2398: This is a concurrent program to migrate the pre-R12 tax data
2399: to R12 eBTax. We do not remove the old values.
2400: OKS_K_LINES_B:
2401: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE and TAX_CLASSIFICATION_CODE
2402: TAX_CODE --> TAX_CLASSIFICATION_CODE
2403: */
2404: PROCEDURE Update_Tax_BWKR(X_errbuf out NOCOPY varchar2,

Line 2412: l_table_name varchar2(30) := 'OKS_K_LINES_B';

2408: P_Num_Workers in number)
2409: IS
2410: l_worker_id number;
2411: l_product varchar2(30) := 'OKS';
2412: l_table_name varchar2(30) := 'OKS_K_LINES_B';
2413: l_update_name varchar2(30) := 'OKSTAXUPG_CP';
2414: l_status varchar2(30);
2415: l_industry varchar2(30);
2416: l_retstatus boolean;

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

2431: then
2432: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
2433: end if;
2434:
2435: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_B table ');
2436: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
2437: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2438:
2439: --

Line 2465: FROM OKS_K_LINES_B oks

2461: oks.TAX_CODE TAX_CODE,
2462: oks.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER,
2463: oks.EXEMPT_REASON_CODE EXEMPT_REASON_CODE,
2464: oks.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
2465: FROM OKS_K_LINES_B oks
2466: WHERE oks.rowid BETWEEN l_start_rowid and l_end_rowid
2467: --npalepu added on 07-jul-2006 for bug # 4908543
2468: AND (oks.TAX_CODE IS NOT NULL OR TAX_EXEMPTION_ID IS NOT NULL)
2469: --end npalepu

Line 2525: fnd_file.put_line(FND_FILE.LOG,'Upgrade for tax columns in OKS_K_LINES_B table completed successfully');

2521: l_any_rows_to_process,
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

Line 2541: OKS_K_LINES_BH:

2537:
2538: /*
2539: This is a concurrent program to migrate the pre-R12 tax data
2540: to R12 eBTax. We do not remove the old values.
2541: OKS_K_LINES_BH:
2542: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE and TAX_CLASSIFICATION_CODE
2543: TAX_CODE --> TAX_CLASSIFICATION_CODE
2544: */
2545: PROCEDURE Update_Tax_HWKR(X_errbuf out NOCOPY varchar2,

Line 2553: l_table_name varchar2(30) := 'OKS_K_LINES_BH';

2549: P_Num_Workers in number)
2550: IS
2551: l_worker_id number;
2552: l_product varchar2(30) := 'OKS';
2553: l_table_name varchar2(30) := 'OKS_K_LINES_BH';
2554: l_update_name varchar2(30) := 'OKSTAXUPH_CP';
2555: l_status varchar2(30);
2556: l_industry varchar2(30);
2557: l_retstatus boolean;

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

2572: then
2573: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
2574: end if;
2575:
2576: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_BH table ');
2577: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
2578: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2579:
2580: --

Line 2605: FROM OKS_K_LINES_BH oks

2601: oks.TAX_CODE TAX_CODE,
2602: oks.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER,
2603: oks.EXEMPT_REASON_CODE EXEMPT_REASON_CODE,
2604: oks.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
2605: FROM OKS_K_LINES_BH oks
2606: WHERE oks.rowid BETWEEN l_start_rowid and l_end_rowid
2607: --npalepu added on 07-jul-2006 for bug # 4908543
2608: AND (oks.TAX_CODE IS NOT NULL OR TAX_EXEMPTION_ID IS NOT NULL)
2609: --end npalepu

Line 2665: fnd_file.put_line(FND_FILE.LOG,'Upgrade for tax columns in OKS_K_LINES_BH table completed successfully');

2661: l_any_rows_to_process,
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