[Home] [Help]
1841: IF Is_Country_Installed(7002, 'jehuloc') THEN
1842:
1843: arp_util_tax.debug( ' Creating data for Hungary..' );
1844:
1845: INSERT INTO ZX_FC_COUNTRY_DEFAULTS (
1846: COUNTRY_CODE,
1847: PRIMARY_INVENTORY_CATEGORY_SET,
1848: INTENDED_USE_DEFAULT,
1849: PRODUCT_CATEG_DEFAULT,
1860: OWNER_ID_NUM,
1861: Null,
1862: Null,
1863: 'MIGRATED',
1864: zx_fc_country_defaults_s.nextval,
1865: fnd_global.user_id,
1866: SYSDATE,
1867: fnd_global.user_id,
1868: SYSDATE,
1872: WHERE
1873: classification_type_code = 'STATISTICAL_CODE'
1874: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1875: AND NOT EXISTS
1876: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'HU');
1877:
1878: END IF;
1879:
1880: -- If Poland is installed then
1881: IF Is_Country_Installed(7002, 'jeplloc') THEN
1882:
1883: arp_util_tax.debug( ' Creating data for Poland..' );
1884:
1885: INSERT INTO ZX_FC_COUNTRY_DEFAULTS (
1886: COUNTRY_CODE,
1887: PRIMARY_INVENTORY_CATEGORY_SET,
1888: INTENDED_USE_DEFAULT,
1889: PRODUCT_CATEG_DEFAULT,
1900: OWNER_ID_NUM,
1901: Null,
1902: Null,
1903: 'MIGRATED',
1904: zx_fc_country_defaults_s.nextval,
1905: fnd_global.user_id,
1906: SYSDATE,
1907: fnd_global.user_id,
1908: SYSDATE,
1912: WHERE
1913: classification_type_code = 'STATISTICAL_CODE'
1914: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1915: AND NOT EXISTS
1916: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'PL');
1917:
1918:
1919: END IF; -- End of Poland checking
1920:
1921: IF Is_Country_Installed(7004, 'jlarloc') THEN
1922:
1923: arp_util_tax.debug( ' Creating data for Argentina..' );
1924:
1925: INSERT INTO ZX_FC_COUNTRY_DEFAULTS (
1926: COUNTRY_CODE,
1927: PRIMARY_INVENTORY_CATEGORY_SET,
1928: INTENDED_USE_DEFAULT,
1929: PRODUCT_CATEG_DEFAULT,
1940: OWNER_ID_NUM,
1941: Null,
1942: Null,
1943: 'MIGRATED',
1944: zx_fc_country_defaults_s.nextval,
1945: fnd_global.user_id,
1946: SYSDATE,
1947: fnd_global.user_id,
1948: SYSDATE,
1951: FROM ZX_FC_TYPES_B
1952: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1953: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1954: AND NOT EXISTS
1955: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'AR');
1956: END IF;
1957:
1958:
1959: -- If Hungary is installed then
1960: IF Is_Country_Installed(7004, 'jlbrloc') THEN
1961:
1962: arp_util_tax.debug( ' Creating data for Brazil..' );
1963:
1964: INSERT INTO ZX_FC_COUNTRY_DEFAULTS (
1965: COUNTRY_CODE,
1966: PRIMARY_INVENTORY_CATEGORY_SET,
1967: INTENDED_USE_DEFAULT,
1968: PRODUCT_CATEG_DEFAULT,
1979: OWNER_ID_NUM,
1980: Null,
1981: Null,
1982: 'MIGRATED',
1983: zx_fc_country_defaults_s.nextval,
1984: fnd_global.user_id,
1985: SYSDATE,
1986: fnd_global.user_id,
1987: SYSDATE,
1990: FROM ZX_FC_TYPES_B
1991: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1992: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1993: AND NOT EXISTS
1994: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'BR');
1995: END IF;
1996:
1997: IF Is_Country_Installed(7004, 'jlcoloc') THEN
1998:
1996:
1997: IF Is_Country_Installed(7004, 'jlcoloc') THEN
1998:
1999: arp_util_tax.debug( ' Creating data for Colombia..' );
2000: INSERT INTO ZX_FC_COUNTRY_DEFAULTS (
2001: COUNTRY_CODE,
2002: PRIMARY_INVENTORY_CATEGORY_SET,
2003: INTENDED_USE_DEFAULT,
2004: PRODUCT_CATEG_DEFAULT,
2015: OWNER_ID_NUM,
2016: Null,
2017: Null,
2018: 'MIGRATED',
2019: zx_fc_country_defaults_s.nextval,
2020: fnd_global.user_id,
2021: SYSDATE,
2022: fnd_global.user_id,
2023: SYSDATE,
2026: FROM ZX_FC_TYPES_B
2027: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
2028: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
2029: AND NOT EXISTS
2030: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'CO');
2031: END IF;
2032:
2033: End if; -- End of Inventory checking
2034: