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 1244: FROM OKC_K_HEADERS_ALL_B a, OKS_K_HEADERS_B b

1240:
1241:
1242: CURSOR cur_k_header(cp_chr_id IN NUMBER) IS
1243: SELECT a.ORG_ID, a.CUST_ACCT_ID, b.INV_TRX_TYPE
1244: FROM OKC_K_HEADERS_ALL_B a, OKS_K_HEADERS_B b
1245: WHERE a.id = cp_chr_id
1246: AND b.chr_id = a.id;
1247:
1248: CURSOR cur_okc_lines(cp_chr_id IN NUMBER) IS

Line 1258: l_inv_trx_type OKS_K_HEADERS_B.inv_trx_type%TYPE;

1254: l_legal_entity_id NUMBER;
1255: l_bill_to_cust_acct_id NUMBER;
1256: l_cust_trx_type_id NUMBER;
1257: l_org_id NUMBER;
1258: l_inv_trx_type OKS_K_HEADERS_B.inv_trx_type%TYPE;
1259:
1260: l_return_status VARCHAR2(1);
1261: l_msg_data VARCHAR2(2000);
1262:

Line 2277: OKS_K_HEADERS_B:

2273:
2274: /*
2275: This is a concurrent program to migrate the pre-R12 tax data
2276: to R12 eBTax. We do not remove the old values.
2277: OKS_K_HEADERS_B:
2278: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER and EXEMPT_REASON_CODE
2279:
2280: OKS_K_HEADERS_BH:
2281: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER and EXEMPT_REASON_CODE

Line 2280: OKS_K_HEADERS_BH:

2276: to R12 eBTax. We do not remove the old values.
2277: OKS_K_HEADERS_B:
2278: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER and EXEMPT_REASON_CODE
2279:
2280: OKS_K_HEADERS_BH:
2281: TAX_EXEMPTION_ID --> EXEMPT_CERTIFICATE_NUMBER and EXEMPT_REASON_CODE
2282: */
2283: PROCEDURE TAX_MIGRATION
2284: (

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

2294: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2295:
2296: --migrate the header level tax_exemption_id to exempt_certificate_number and exempt_reason_code
2297: --npalepu updating tax_code and tax_exemption_id to null for bug # 4908543
2298: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_B oks
2299: SET (EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE)
2300: = (SELECT zx.EXEMPT_CERTIFICATE_NUMBER, zx.EXEMPT_REASON_CODE
2301: FROM ZX_EXEMPTIONS zx
2302: WHERE zx.TAX_EXEMPTION_ID = oks.tax_exemption_id)

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

2305: WHERE oks.tax_exemption_id IS NOT NULL
2306: AND (oks.EXEMPT_CERTIFICATE_NUMBER IS NULL OR oks.EXEMPT_REASON_CODE IS NULL);
2307: --end npalepu
2308:
2309: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_B');
2310: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2311:
2312: /*npalepu added migration of tax_exemption_id to exempt_certificate_number and exempt_reason_code in oks_k_headers_bh table.
2313: updating tax_code and tax_exemption_id to null for bug # 4908543 */

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

2308:
2309: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_B');
2310: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2311:
2312: /*npalepu added migration of tax_exemption_id to exempt_certificate_number and exempt_reason_code in oks_k_headers_bh table.
2313: updating tax_code and tax_exemption_id to null for bug # 4908543 */
2314: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_BH oks
2315: SET (EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE)
2316: = (SELECT zx.EXEMPT_CERTIFICATE_NUMBER, zx.EXEMPT_REASON_CODE

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

2310: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2311:
2312: /*npalepu added migration of tax_exemption_id to exempt_certificate_number and exempt_reason_code in oks_k_headers_bh table.
2313: updating tax_code and tax_exemption_id to null for bug # 4908543 */
2314: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_BH oks
2315: SET (EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE)
2316: = (SELECT zx.EXEMPT_CERTIFICATE_NUMBER, zx.EXEMPT_REASON_CODE
2317: FROM ZX_EXEMPTIONS zx
2318: WHERE zx.TAX_EXEMPTION_ID = oks.tax_exemption_id)

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

2321: WHERE oks.tax_exemption_id IS NOT NULL
2322: AND (oks.EXEMPT_CERTIFICATE_NUMBER IS NULL OR oks.EXEMPT_REASON_CODE IS NULL);
2323: --end npalepu
2324:
2325: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_BH');
2326: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2327: --end npalepu
2328:
2329: COMMIT;