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_HEADERS_B

Line 39: FROM OKS_K_HEADERS_B

35: EXEMPT_REASON_CODE,
36: TAX_EXEMPTION_ID,
37: TAX_CLASSIFICATION_CODE,
38: TAX_CODE
39: FROM OKS_K_HEADERS_B
40: WHERE chr_id = p_chr_id;
41:
42:
43: CURSOR okc_line_csr (p_chr_id NUMBER, p_line_id NUMBER) IS

Line 265: --need to copy the tax_exempt_flag from oks_k_headers_b (p_oks_rec)

261: END IF;
262:
263: x_return_status := OKC_API.G_RET_STS_SUCCESS;
264:
265: --need to copy the tax_exempt_flag from oks_k_headers_b (p_oks_rec)
266: --to px_rail_rec
267: --the IF condition is so that we don't overwrite the tax information from the line
268: IF px_rail_rec.TAX_EXEMPT_FLAG IS NULL THEN
269: px_rail_rec.TAX_EXEMPT_FLAG := p_oks_rec.tax_status;

Line 1292: FROM OKC_K_HEADERS_ALL_B a, OKS_K_HEADERS_B b

1288:
1289:
1290: CURSOR cur_k_header(cp_chr_id IN NUMBER) IS
1291: SELECT a.ORG_ID, a.CUST_ACCT_ID, b.INV_TRX_TYPE
1292: FROM OKC_K_HEADERS_ALL_B a, OKS_K_HEADERS_B b
1293: WHERE a.id = cp_chr_id
1294: AND b.chr_id = a.id;
1295:
1296: CURSOR cur_okc_lines(cp_chr_id IN NUMBER) IS

Line 1306: l_inv_trx_type OKS_K_HEADERS_B.inv_trx_type%TYPE;

1302: l_legal_entity_id NUMBER;
1303: l_bill_to_cust_acct_id NUMBER;
1304: l_cust_trx_type_id NUMBER;
1305: l_org_id NUMBER;
1306: l_inv_trx_type OKS_K_HEADERS_B.inv_trx_type%TYPE;
1307:
1308: l_return_status VARCHAR2(1);
1309: l_msg_data VARCHAR2(2000);
1310:

Line 2325: OKS_K_HEADERS_B:

2321:
2322: /*
2323: This is a concurrent program to migrate the pre-R12 tax data
2324: to R12 eBTax. We do not remove the old values.
2325: OKS_K_HEADERS_B:
2326: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER and EXEMPT_REASON_CODE
2327:
2328: OKS_K_HEADERS_BH:
2329: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER and EXEMPT_REASON_CODE

Line 2328: OKS_K_HEADERS_BH:

2324: to R12 eBTax. We do not remove the old values.
2325: OKS_K_HEADERS_B:
2326: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER and EXEMPT_REASON_CODE
2327:
2328: OKS_K_HEADERS_BH:
2329: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER and EXEMPT_REASON_CODE
2330: */
2331: PROCEDURE TAX_MIGRATION
2332: (

Line 2346: UPDATE /+ parallel(oks) / OKS_K_HEADERS_B oks

2342: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2343:
2344: --migrate the header level tax_exemption_id to exempt_certificate_number and exempt_reason_code
2345: --npalepu updating tax_code and tax_exemption_id to null for bug # 4908543
2346: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_B oks
2347: SET (EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE)
2348: = (SELECT zx.EXEMPT_CERTIFICATE_NUMBER, zx.EXEMPT_REASON_CODE
2349: FROM ZX_EXEMPTIONS zx
2350: WHERE zx.TAX_EXEMPTION_ID = oks.tax_exemption_id)

Line 2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_B');

2353: WHERE oks.tax_exemption_id IS NOT NULL
2354: AND (oks.EXEMPT_CERTIFICATE_NUMBER IS NULL OR oks.EXEMPT_REASON_CODE IS NULL);
2355: --end npalepu
2356:
2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_B');
2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2359:
2360: /*npalepu added migration of tax_exemption_id to exempt_certificate_number and exempt_reason_code in oks_k_headers_bh table.
2361: updating tax_code and tax_exemption_id to null for bug # 4908543 */

Line 2360: /*npalepu added migration of tax_exemption_id to exempt_certificate_number and exempt_reason_code in oks_k_headers_bh table.

2356:
2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_B');
2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2359:
2360: /*npalepu added migration of tax_exemption_id to exempt_certificate_number and exempt_reason_code in oks_k_headers_bh table.
2361: updating tax_code and tax_exemption_id to null for bug # 4908543 */
2362: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_BH oks
2363: SET (EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE)
2364: = (SELECT zx.EXEMPT_CERTIFICATE_NUMBER, zx.EXEMPT_REASON_CODE

Line 2362: UPDATE /+ parallel(oks) / OKS_K_HEADERS_BH oks

2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2359:
2360: /*npalepu added migration of tax_exemption_id to exempt_certificate_number and exempt_reason_code in oks_k_headers_bh table.
2361: updating tax_code and tax_exemption_id to null for bug # 4908543 */
2362: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_BH oks
2363: SET (EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE)
2364: = (SELECT zx.EXEMPT_CERTIFICATE_NUMBER, zx.EXEMPT_REASON_CODE
2365: FROM ZX_EXEMPTIONS zx
2366: WHERE zx.TAX_EXEMPTION_ID = oks.tax_exemption_id)

Line 2373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_BH');

2369: WHERE oks.tax_exemption_id IS NOT NULL
2370: AND (oks.EXEMPT_CERTIFICATE_NUMBER IS NULL OR oks.EXEMPT_REASON_CODE IS NULL);
2371: --end npalepu
2372:
2373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_BH');
2374: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2375: --end npalepu
2376:
2377: COMMIT;