APPS.OKS_TAX_UTIL_PVT dependencies on OKS_K_HEADERS_BH

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