[Home] [Help]
1378: | 2. Populates data into zx_regimes_b for Brazilian IPI
1379: | 3. Populates data into zx_regimes_b for Brazilian ISS
1380: | 4. Populates data into zx_regimes_b for GTE US Sales Tax Regimes
1381: | 5. Populates data into zx_regimes_b for Tax Vendor Regimes
1382: | 6. Populates data into zx_regimes_tl
1383: |
1384: |
1385: | NOTES
1386: | 1. Select distinct of tax_regime_code and country_code. Update Criteria UI
1414: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%TYPE
1415: l_temp_tax_invoice_print VARCHAR2(30); --ar_system_parameters_all.tax_invoice_print%TYPE
1416: l_temp_allow_rounding_override VARCHAR2(30); --ar_system_parameters_all.tax_rounding_allow_override%TYPE
1417: l_temp_org_id NUMBER(15); --ar_system_parameters_all.org_id%TYPE
1418: l_tax_regime_name VARCHAR2(80); --zx_regimes_tl.tax_regime_name%TYPE
1419: l_tax_regime_code VARCHAR2(30); --zx_regimes_b.tax_regime_code%TYPE
1420:
1421:
1422: -- ****** CURSORS ******
1988: IF zx_migrate_util.is_installed('AR') = 'Y' THEN
1989: /*-------------------------------------------------------------------------
1990: |
1991: | For GTE US Sales Tax Regimes
1992: | It also inserts zx_regimes_tl.
1993: |
1994: | Regime Code :
1995: | 1. Country Code || '-SALES-TAX-' || location structure id
1996: |
2332: ) THEN
2333: -- Need to insert _TL table for current language as l_tax_regime_name is
2334: -- derived using the following logic :
2335: -- Country Code '-SALES-TAX-' Seg Att1 '-' Seg Att2 '-' ...
2336: INTO ZX_REGIMES_TL
2337: (
2338: LANGUAGE ,
2339: SOURCE_LANG ,
2340: TAX_REGIME_NAME ,
2555:
2556:
2557: /*-------------------------------------------------------------------------
2558: |
2559: | Populates data into zx_regimes_tl table
2560: |
2561: +--------------------------------------------------------------------------*/
2562: -- Bug 4688151 : LTE Tax Codes will derive tax_regime_name from
2563: IF L_MULTI_ORG_FLAG = 'Y'
2562: -- Bug 4688151 : LTE Tax Codes will derive tax_regime_name from
2563: IF L_MULTI_ORG_FLAG = 'Y'
2564: THEN
2565:
2566: INSERT INTO ZX_REGIMES_TL
2567: (
2568: LANGUAGE ,
2569: SOURCE_LANG ,
2570: TAX_REGIME_NAME ,
2636: --
2637: AND b.tax_regime_code = d.tax_regime_code (+)
2638: AND not exists
2639: (select NULL
2640: from ZX_REGIMES_TL T
2641: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
2642: and T.LANGUAGE = L.LANGUAGE_CODE);
2643: ELSE
2644:
2641: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
2642: and T.LANGUAGE = L.LANGUAGE_CODE);
2643: ELSE
2644:
2645: INSERT INTO ZX_REGIMES_TL
2646: (
2647: LANGUAGE ,
2648: SOURCE_LANG ,
2649: TAX_REGIME_NAME ,
2717: --
2718: AND b.tax_regime_code = d.tax_regime_code (+)
2719: AND not exists
2720: (select NULL
2721: from ZX_REGIMES_TL T
2722: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
2723: and T.LANGUAGE = L.LANGUAGE_CODE);
2724:
2725: