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 2398: -- Manager processing for OKS_K_LINES_B table

2394: P_Num_Workers in number)
2395: IS
2396: BEGIN
2397: --
2398: -- Manager processing for OKS_K_LINES_B table
2399: --
2400: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_BMGR ');
2401: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2402: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

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

2400: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_BMGR ');
2401: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2402: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2403:
2404: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_b update worker ');
2405:
2406: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
2407: X_retcode,
2408: 'OKS',

Line 2425: -- Manager processing for OKS_K_LINES_BH table

2421: P_Num_Workers in number)
2422: IS
2423: BEGIN
2424: --
2425: -- Manager processing for OKS_K_LINES_BH table
2426: --
2427: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_HMGR ');
2428: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2429: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

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

2427: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_HMGR ');
2428: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2429: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2430:
2431: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_bh update worker ');
2432:
2433: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
2434: X_retcode,
2435: 'OKS',

Line 2448: OKS_K_LINES_B:

2444:
2445: /*
2446: This is a concurrent program to migrate the pre-R12 tax data
2447: to R12 eBTax. We do not remove the old values.
2448: OKS_K_LINES_B:
2449: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE and TAX_CLASSIFICATION_CODE
2450: TAX_CODE --> TAX_CLASSIFICATION_CODE
2451: */
2452: PROCEDURE Update_Tax_BWKR(X_errbuf out NOCOPY varchar2,

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

2456: P_Num_Workers in number)
2457: IS
2458: l_worker_id number;
2459: l_product varchar2(30) := 'OKS';
2460: l_table_name varchar2(30) := 'OKS_K_LINES_B';
2461: l_update_name varchar2(30) := 'OKSTAXUPG_CP';
2462: l_status varchar2(30);
2463: l_industry varchar2(30);
2464: l_retstatus boolean;

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

2479: then
2480: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
2481: end if;
2482:
2483: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_B table ');
2484: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
2485: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2486:
2487: --

Line 2513: FROM OKS_K_LINES_B oks

2509: oks.TAX_CODE TAX_CODE,
2510: oks.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER,
2511: oks.EXEMPT_REASON_CODE EXEMPT_REASON_CODE,
2512: oks.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
2513: FROM OKS_K_LINES_B oks
2514: WHERE oks.rowid BETWEEN l_start_rowid and l_end_rowid
2515: --npalepu added on 07-jul-2006 for bug # 4908543
2516: AND (oks.TAX_CODE IS NOT NULL OR TAX_EXEMPTION_ID IS NOT NULL)
2517: --end npalepu

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

2569: l_any_rows_to_process,
2570: P_batch_size,
2571: FALSE);
2572: end loop;
2573: fnd_file.put_line(FND_FILE.LOG,'Upgrade for tax columns in OKS_K_LINES_B table completed successfully');
2574: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
2575: X_errbuf := ' ';
2576: EXCEPTION
2577: WHEN OTHERS THEN

Line 2589: OKS_K_LINES_BH:

2585:
2586: /*
2587: This is a concurrent program to migrate the pre-R12 tax data
2588: to R12 eBTax. We do not remove the old values.
2589: OKS_K_LINES_BH:
2590: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE and TAX_CLASSIFICATION_CODE
2591: TAX_CODE --> TAX_CLASSIFICATION_CODE
2592: */
2593: PROCEDURE Update_Tax_HWKR(X_errbuf out NOCOPY varchar2,

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

2597: P_Num_Workers in number)
2598: IS
2599: l_worker_id number;
2600: l_product varchar2(30) := 'OKS';
2601: l_table_name varchar2(30) := 'OKS_K_LINES_BH';
2602: l_update_name varchar2(30) := 'OKSTAXUPH_CP';
2603: l_status varchar2(30);
2604: l_industry varchar2(30);
2605: l_retstatus boolean;

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

2620: then
2621: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
2622: end if;
2623:
2624: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_BH table ');
2625: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
2626: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2627:
2628: --

Line 2653: FROM OKS_K_LINES_BH oks

2649: oks.TAX_CODE TAX_CODE,
2650: oks.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER,
2651: oks.EXEMPT_REASON_CODE EXEMPT_REASON_CODE,
2652: oks.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
2653: FROM OKS_K_LINES_BH oks
2654: WHERE oks.rowid BETWEEN l_start_rowid and l_end_rowid
2655: --npalepu added on 07-jul-2006 for bug # 4908543
2656: AND (oks.TAX_CODE IS NOT NULL OR TAX_EXEMPTION_ID IS NOT NULL)
2657: --end npalepu

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

2709: l_any_rows_to_process,
2710: P_batch_size,
2711: FALSE);
2712: end loop;
2713: fnd_file.put_line(FND_FILE.LOG,'Upgrade for tax columns in OKS_K_LINES_BH table completed successfully');
2714: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
2715: X_errbuf := ' ';
2716: EXCEPTION
2717: WHEN OTHERS THEN