[Home] [Help]
1301: | 2. Populates data into zx_regimes_b for Brazilian IPI
1302: | 3. Populates data into zx_regimes_b for Brazilian ISS
1303: | 4. Populates data into zx_regimes_b for GTE US Sales Tax Regimes
1304: | 5. Populates data into zx_regimes_b for Tax Vendor Regimes
1305: | 6. Populates data into zx_regimes_tl
1306: |
1307: |
1308: | NOTES
1309: | 1. Select distinct of tax_regime_code and country_code. Update Criteria UI
1337: l_temp_rounding_rule_code VARCHAR2(30); --ar_system_parameters_all.tax_rounding_rule%TYPE
1338: l_temp_tax_invoice_print VARCHAR2(30); --ar_system_parameters_all.tax_invoice_print%TYPE
1339: l_temp_allow_rounding_override VARCHAR2(30); --ar_system_parameters_all.tax_rounding_allow_override%TYPE
1340: l_temp_org_id NUMBER(15); --ar_system_parameters_all.org_id%TYPE
1341: l_tax_regime_name VARCHAR2(80); --zx_regimes_tl.tax_regime_name%TYPE
1342: l_tax_regime_code VARCHAR2(30); --zx_regimes_b.tax_regime_code%TYPE
1343:
1344:
1345: -- ****** CURSORS ******
1911: IF zx_migrate_util.is_installed('AR') = 'Y' THEN
1912: /*-------------------------------------------------------------------------
1913: |
1914: | For GTE US Sales Tax Regimes
1915: | It also inserts zx_regimes_tl.
1916: |
1917: | Regime Code :
1918: | 1. Country Code || '-SALES-TAX-' || location structure id
1919: |
2255: ) THEN
2256: -- Need to insert _TL table for current language as l_tax_regime_name is
2257: -- derived using the following logic :
2258: -- Country Code '-SALES-TAX-' Seg Att1 '-' Seg Att2 '-' ...
2259: INTO ZX_REGIMES_TL
2260: (
2261: LANGUAGE ,
2262: SOURCE_LANG ,
2263: TAX_REGIME_NAME ,
2478:
2479:
2480: /*-------------------------------------------------------------------------
2481: |
2482: | Populates data into zx_regimes_tl table
2483: |
2484: +--------------------------------------------------------------------------*/
2485: -- Bug 4688151 : LTE Tax Codes will derive tax_regime_name from
2486: IF L_MULTI_ORG_FLAG = 'Y'
2485: -- Bug 4688151 : LTE Tax Codes will derive tax_regime_name from
2486: IF L_MULTI_ORG_FLAG = 'Y'
2487: THEN
2488:
2489: INSERT INTO ZX_REGIMES_TL
2490: (
2491: LANGUAGE ,
2492: SOURCE_LANG ,
2493: TAX_REGIME_NAME ,
2559: --
2560: AND b.tax_regime_code = d.tax_regime_code (+)
2561: AND not exists
2562: (select NULL
2563: from ZX_REGIMES_TL T
2564: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
2565: and T.LANGUAGE = L.LANGUAGE_CODE);
2566: ELSE
2567:
2564: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
2565: and T.LANGUAGE = L.LANGUAGE_CODE);
2566: ELSE
2567:
2568: INSERT INTO ZX_REGIMES_TL
2569: (
2570: LANGUAGE ,
2571: SOURCE_LANG ,
2572: TAX_REGIME_NAME ,
2640: --
2641: AND b.tax_regime_code = d.tax_regime_code (+)
2642: AND not exists
2643: (select NULL
2644: from ZX_REGIMES_TL T
2645: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
2646: and T.LANGUAGE = L.LANGUAGE_CODE);
2647:
2648: