APPS.OKS_TAX_UTIL_PVT dependencies on OKS_K_HEADERS_BH

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 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;