DBA Data[Home] [Help]

APPS.ZX_UPGRADE_CONTROL_PKG dependencies on ZX_MIGRATE_TAX_DEF

Line 1658: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);

1654: INTO l_tax,l_name
1655: FROM AP_TAX_CODES_ALL
1656: WHERE TAX_ID = P_TAX_CODE_ID;
1657:
1658: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
1659: Zx_Migrate_Tax_Default_Hier.create_process_results
1660: (p_tax_id => p_tax_code_id,
1661: p_sync_module => 'AP');
1662: -- End of sync for Default Hierarchy

Line 1659: Zx_Migrate_Tax_Default_Hier.create_process_results

1655: FROM AP_TAX_CODES_ALL
1656: WHERE TAX_ID = P_TAX_CODE_ID;
1657:
1658: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
1659: Zx_Migrate_Tax_Default_Hier.create_process_results
1660: (p_tax_id => p_tax_code_id,
1661: p_sync_module => 'AP');
1662: -- End of sync for Default Hierarchy
1663: ELSIF P_TAX_GROUP_TYPE = 'AR' AND P_DML_TYPE = 'I' THEN

Line 1676: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);

1672: INTO l_tax , l_name
1673: FROM AR_VAT_TAX_ALL
1674: WHERE VAT_TAX_ID = P_TAX_CODE_ID;
1675:
1676: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
1677: Zx_Migrate_Tax_Default_Hier.create_process_results
1678: (p_tax_id => p_tax_code_id,
1679: p_sync_module => 'AR');
1680: -- End of sync for Default Hierarchy

Line 1677: Zx_Migrate_Tax_Default_Hier.create_process_results

1673: FROM AR_VAT_TAX_ALL
1674: WHERE VAT_TAX_ID = P_TAX_CODE_ID;
1675:
1676: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
1677: Zx_Migrate_Tax_Default_Hier.create_process_results
1678: (p_tax_id => p_tax_code_id,
1679: p_sync_module => 'AR');
1680: -- End of sync for Default Hierarchy
1681:

Line 1800: Zx_Migrate_Tax_Def.Create_Tax_Classifications(p_tax_id);

1796:
1797: --IF control_table THEN
1798:
1799: IF p_dml_type = 'I' AND p_tax_type <> 'AWT' THEN
1800: Zx_Migrate_Tax_Def.Create_Tax_Classifications(p_tax_id);
1801: END IF;
1802:
1803: IF p_dml_type = 'I' AND p_tax_type = 'TAX_GROUP' THEN
1804: -- For Sync of Default Hierarchy

Line 1809: Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_name);

1805: /* Following code creates CONDITION's entities for the new
1806: TAX GROUP and the associated RULE entities for each
1807: Tax code within the Tax Group will be created in the SYNC process
1808: of AR_TAX_GROUP_CODES */
1809: Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_name);
1810: -- End of sync for Default Hierarchy
1811:
1812: ELSIF p_dml_type = 'I' AND p_tax_type = 'OFFSET' THEN
1813:

Line 1815: ZX_MIGRATE_TAX_DEF.migrate_unassign_offset_codes(p_tax_id);

1811:
1812: ELSIF p_dml_type = 'I' AND p_tax_type = 'OFFSET' THEN
1813:
1814: -- For sync of eB-Tax defintion entities.
1815: ZX_MIGRATE_TAX_DEF.migrate_unassign_offset_codes(p_tax_id);
1816: IF p_tax_recovery_rate is not null THEN
1817: ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);
1818: END IF;
1819: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);

Line 1817: ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);

1813:
1814: -- For sync of eB-Tax defintion entities.
1815: ZX_MIGRATE_TAX_DEF.migrate_unassign_offset_codes(p_tax_id);
1816: IF p_tax_recovery_rate is not null THEN
1817: ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);
1818: END IF;
1819: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);
1820: ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);
1821:

Line 1819: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);

1815: ZX_MIGRATE_TAX_DEF.migrate_unassign_offset_codes(p_tax_id);
1816: IF p_tax_recovery_rate is not null THEN
1817: ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);
1818: END IF;
1819: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);
1820: ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);
1821:
1822: /******************************************************************************
1823: * Important!!! please check why this API ZX_MIGRATE_TAX_DEF.create_zx_regimes *

Line 1820: ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);

1816: IF p_tax_recovery_rate is not null THEN
1817: ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);
1818: END IF;
1819: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);
1820: ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);
1821:
1822: /******************************************************************************
1823: * Important!!! please check why this API ZX_MIGRATE_TAX_DEF.create_zx_regimes *
1824: * was dropped and see if this API call needs to be replaced with another one *

Line 1823: * Important!!! please check why this API ZX_MIGRATE_TAX_DEF.create_zx_regimes *

1819: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);
1820: ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);
1821:
1822: /******************************************************************************
1823: * Important!!! please check why this API ZX_MIGRATE_TAX_DEF.create_zx_regimes *
1824: * was dropped and see if this API call needs to be replaced with another one *
1825: * Commentiong out this call temporarily ge get this package body valid for *
1826: * sanity testing *
1827: ******************************************************************************/

Line 1828: -- bug 4507349 ZX_MIGRATE_TAX_DEF.create_zx_regimes(p_tax_id);

1824: * was dropped and see if this API call needs to be replaced with another one *
1825: * Commentiong out this call temporarily ge get this package body valid for *
1826: * sanity testing *
1827: ******************************************************************************/
1828: -- bug 4507349 ZX_MIGRATE_TAX_DEF.create_zx_regimes(p_tax_id);
1829: -- End of sync for eB-Tax defintion entities.
1830:
1831: ELSIF p_dml_type = 'I' AND p_tax_type <> 'AWT' THEN
1832:

Line 1834: ZX_MIGRATE_TAX_DEF.migrate_normal_tax_codes(p_tax_id);

1830:
1831: ELSIF p_dml_type = 'I' AND p_tax_type <> 'AWT' THEN
1832:
1833: -- For sync of eB-Tax defintion entities.
1834: ZX_MIGRATE_TAX_DEF.migrate_normal_tax_codes(p_tax_id);
1835: IF p_tax_recovery_rate is not null THEN
1836: ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);
1837: ELSIF p_tax_recovery_rule_id is not null THEN
1838: ZX_MIGRATE_TAX_DEF.create_rules(p_tax_id);

Line 1836: ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);

1832:
1833: -- For sync of eB-Tax defintion entities.
1834: ZX_MIGRATE_TAX_DEF.migrate_normal_tax_codes(p_tax_id);
1835: IF p_tax_recovery_rate is not null THEN
1836: ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);
1837: ELSIF p_tax_recovery_rule_id is not null THEN
1838: ZX_MIGRATE_TAX_DEF.create_rules(p_tax_id);
1839: END IF;
1840: IF p_offset_tax_code_id is not null THEN

Line 1838: ZX_MIGRATE_TAX_DEF.create_rules(p_tax_id);

1834: ZX_MIGRATE_TAX_DEF.migrate_normal_tax_codes(p_tax_id);
1835: IF p_tax_recovery_rate is not null THEN
1836: ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);
1837: ELSIF p_tax_recovery_rule_id is not null THEN
1838: ZX_MIGRATE_TAX_DEF.create_rules(p_tax_id);
1839: END IF;
1840: IF p_offset_tax_code_id is not null THEN
1841: ZX_MIGRATE_TAX_DEF.migrate_assign_offset_codes
1842: (p_offset_tax_code_id);

Line 1841: ZX_MIGRATE_TAX_DEF.migrate_assign_offset_codes

1837: ELSIF p_tax_recovery_rule_id is not null THEN
1838: ZX_MIGRATE_TAX_DEF.create_rules(p_tax_id);
1839: END IF;
1840: IF p_offset_tax_code_id is not null THEN
1841: ZX_MIGRATE_TAX_DEF.migrate_assign_offset_codes
1842: (p_offset_tax_code_id);
1843: END IF;
1844: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);
1845: ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);

Line 1844: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);

1840: IF p_offset_tax_code_id is not null THEN
1841: ZX_MIGRATE_TAX_DEF.migrate_assign_offset_codes
1842: (p_offset_tax_code_id);
1843: END IF;
1844: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);
1845: ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);
1846: /******************************************************************************
1847: * Important!!! please check why this API ZX_MIGRATE_TAX_DEF.create_zx_regimes *
1848: * was dropped and see if this API call needs to be replaced with another one *

Line 1845: ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);

1841: ZX_MIGRATE_TAX_DEF.migrate_assign_offset_codes
1842: (p_offset_tax_code_id);
1843: END IF;
1844: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);
1845: ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);
1846: /******************************************************************************
1847: * Important!!! please check why this API ZX_MIGRATE_TAX_DEF.create_zx_regimes *
1848: * was dropped and see if this API call needs to be replaced with another one *
1849: * Commentiong out this call temporarily ge get this package body valid for *

Line 1847: * Important!!! please check why this API ZX_MIGRATE_TAX_DEF.create_zx_regimes *

1843: END IF;
1844: ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);
1845: ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);
1846: /******************************************************************************
1847: * Important!!! please check why this API ZX_MIGRATE_TAX_DEF.create_zx_regimes *
1848: * was dropped and see if this API call needs to be replaced with another one *
1849: * Commentiong out this call temporarily ge get this package body valid for *
1850: * sanity testing *
1851: ******************************************************************************/

Line 1852: -- bug 4507349 ZX_MIGRATE_TAX_DEF.create_zx_regimes(p_tax_id);

1848: * was dropped and see if this API call needs to be replaced with another one *
1849: * Commentiong out this call temporarily ge get this package body valid for *
1850: * sanity testing *
1851: ******************************************************************************/
1852: -- bug 4507349 ZX_MIGRATE_TAX_DEF.create_zx_regimes(p_tax_id);
1853: -- End of sync for eB-Tax defintion entities.
1854:
1855: -- For Sync of Default Hierarchy
1856: SELECT DECODE(p_global_attribute_category,

Line 1872: Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_name);

1868: FROM DUAL;
1869:
1870: -- Bug 3751717
1871: IF p_tax_type NOT IN('OFFSET','USE') THEN
1872: Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_name);
1873: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
1874: Zx_Migrate_Tax_Default_Hier.create_process_results
1875: (p_tax_id => p_tax_id,
1876: p_sync_module => 'AP');

Line 1873: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);

1869:
1870: -- Bug 3751717
1871: IF p_tax_type NOT IN('OFFSET','USE') THEN
1872: Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_name);
1873: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
1874: Zx_Migrate_Tax_Default_Hier.create_process_results
1875: (p_tax_id => p_tax_id,
1876: p_sync_module => 'AP');
1877: END IF;

Line 1874: Zx_Migrate_Tax_Default_Hier.create_process_results

1870: -- Bug 3751717
1871: IF p_tax_type NOT IN('OFFSET','USE') THEN
1872: Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_name);
1873: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
1874: Zx_Migrate_Tax_Default_Hier.create_process_results
1875: (p_tax_id => p_tax_id,
1876: p_sync_module => 'AP');
1877: END IF;
1878: -- End of sync for Default Hierarchy

Line 2050: ZX_MIGRATE_TAX_DEF.create_condition_groups(p_rate_id);

2046: IF PG_DEBUG = 'Y' THEN
2047: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RATES()+');
2048: END IF;
2049: IF p_dml_type = 'I' THEN
2050: ZX_MIGRATE_TAX_DEF.create_condition_groups(p_rate_id);
2051: END IF;
2052: IF PG_DEBUG = 'Y' THEN
2053: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RATES()-');
2054: END IF;

Line 3632: zx_migrate_tax_def_common.load_results_for_ar(p_vat_tax_id);

3628: arp_util_tax.debug('p_tax_type :'||p_tax_type);
3629:
3630: IF p_dml_type = 'I' THEN
3631: --Tax Code Synch
3632: zx_migrate_tax_def_common.load_results_for_ar(p_vat_tax_id);
3633: zx_migrate_tax_def_common.load_regimes;
3634: --zx_sbscr_options_migrate_pkg.sbscrptn_options_migrate(x_return_status);
3635:
3636: IF p_tax_type = 'LOCATION' THEN

Line 3633: zx_migrate_tax_def_common.load_regimes;

3629:
3630: IF p_dml_type = 'I' THEN
3631: --Tax Code Synch
3632: zx_migrate_tax_def_common.load_results_for_ar(p_vat_tax_id);
3633: zx_migrate_tax_def_common.load_regimes;
3634: --zx_sbscr_options_migrate_pkg.sbscrptn_options_migrate(x_return_status);
3635:
3636: IF p_tax_type = 'LOCATION' THEN
3637: zx_migrate_ar_tax_def.migrate_loc_tax_code (p_vat_tax_id, p_tax_type);

Line 3645: Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_tax_code);

3641: zx_migrate_ar_tax_def.migrate_ar_tax_code_setup (p_vat_tax_id);
3642: END IF;
3643:
3644: --Begin of sync for AR Tax defaulting process.
3645: Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_tax_code);
3646:
3647: -- Bug 3751717
3648: -- If Tax Type is group then we are creating the Tax Rule and Process
3649: -- result in SYNC_AR_TAX_GROUP_CODES procedure

Line 3659: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);

3655: Zx_Migrate_Util.GET_TAX( p_tax_code, p_tax_type) )
3656: INTO l_tax
3657: FROM DUAL;
3658:
3659: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
3660: Zx_Migrate_Tax_Default_Hier.create_process_results
3661: (p_tax_id => p_vat_tax_id,
3662: p_sync_module => 'AR');
3663: END IF;

Line 3660: Zx_Migrate_Tax_Default_Hier.create_process_results

3656: INTO l_tax
3657: FROM DUAL;
3658:
3659: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
3660: Zx_Migrate_Tax_Default_Hier.create_process_results
3661: (p_tax_id => p_vat_tax_id,
3662: p_sync_module => 'AR');
3663: END IF;
3664: