[Home] [Help]
1848: IF Is_Country_Installed(7002, 'jehuloc') THEN
1849:
1850: arp_util_tax.debug( ' Creating data for Hungary..' );
1851:
1852: INSERT INTO ZX_FC_COUNTRY_DEFAULTS (
1853: COUNTRY_CODE,
1854: PRIMARY_INVENTORY_CATEGORY_SET,
1855: INTENDED_USE_DEFAULT,
1856: PRODUCT_CATEG_DEFAULT,
1867: OWNER_ID_NUM,
1868: Null,
1869: Null,
1870: 'MIGRATED',
1871: zx_fc_country_defaults_s.nextval,
1872: fnd_global.user_id,
1873: SYSDATE,
1874: fnd_global.user_id,
1875: SYSDATE,
1879: WHERE
1880: classification_type_code = 'STATISTICAL_CODE'
1881: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1882: AND NOT EXISTS
1883: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'HU');
1884:
1885: END IF;
1886:
1887: -- If Poland is installed then
1888: IF Is_Country_Installed(7002, 'jeplloc') THEN
1889:
1890: arp_util_tax.debug( ' Creating data for Poland..' );
1891:
1892: INSERT INTO ZX_FC_COUNTRY_DEFAULTS (
1893: COUNTRY_CODE,
1894: PRIMARY_INVENTORY_CATEGORY_SET,
1895: INTENDED_USE_DEFAULT,
1896: PRODUCT_CATEG_DEFAULT,
1907: OWNER_ID_NUM,
1908: Null,
1909: Null,
1910: 'MIGRATED',
1911: zx_fc_country_defaults_s.nextval,
1912: fnd_global.user_id,
1913: SYSDATE,
1914: fnd_global.user_id,
1915: SYSDATE,
1919: WHERE
1920: classification_type_code = 'STATISTICAL_CODE'
1921: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1922: AND NOT EXISTS
1923: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'PL');
1924:
1925:
1926: END IF; -- End of Poland checking
1927:
1928: IF Is_Country_Installed(7004, 'jlarloc') THEN
1929:
1930: arp_util_tax.debug( ' Creating data for Argentina..' );
1931:
1932: INSERT INTO ZX_FC_COUNTRY_DEFAULTS (
1933: COUNTRY_CODE,
1934: PRIMARY_INVENTORY_CATEGORY_SET,
1935: INTENDED_USE_DEFAULT,
1936: PRODUCT_CATEG_DEFAULT,
1947: OWNER_ID_NUM,
1948: Null,
1949: Null,
1950: 'MIGRATED',
1951: zx_fc_country_defaults_s.nextval,
1952: fnd_global.user_id,
1953: SYSDATE,
1954: fnd_global.user_id,
1955: SYSDATE,
1958: FROM ZX_FC_TYPES_B
1959: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1960: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1961: AND NOT EXISTS
1962: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'AR');
1963: END IF;
1964:
1965:
1966: -- If Hungary is installed then
1967: IF Is_Country_Installed(7004, 'jlbrloc') THEN
1968:
1969: arp_util_tax.debug( ' Creating data for Brazil..' );
1970:
1971: INSERT INTO ZX_FC_COUNTRY_DEFAULTS (
1972: COUNTRY_CODE,
1973: PRIMARY_INVENTORY_CATEGORY_SET,
1974: INTENDED_USE_DEFAULT,
1975: PRODUCT_CATEG_DEFAULT,
1986: OWNER_ID_NUM,
1987: Null,
1988: Null,
1989: 'MIGRATED',
1990: zx_fc_country_defaults_s.nextval,
1991: fnd_global.user_id,
1992: SYSDATE,
1993: fnd_global.user_id,
1994: SYSDATE,
1997: FROM ZX_FC_TYPES_B
1998: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1999: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
2000: AND NOT EXISTS
2001: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'BR');
2002: END IF;
2003:
2004: IF Is_Country_Installed(7004, 'jlcoloc') THEN
2005:
2003:
2004: IF Is_Country_Installed(7004, 'jlcoloc') THEN
2005:
2006: arp_util_tax.debug( ' Creating data for Colombia..' );
2007: INSERT INTO ZX_FC_COUNTRY_DEFAULTS (
2008: COUNTRY_CODE,
2009: PRIMARY_INVENTORY_CATEGORY_SET,
2010: INTENDED_USE_DEFAULT,
2011: PRODUCT_CATEG_DEFAULT,
2022: OWNER_ID_NUM,
2023: Null,
2024: Null,
2025: 'MIGRATED',
2026: zx_fc_country_defaults_s.nextval,
2027: fnd_global.user_id,
2028: SYSDATE,
2029: fnd_global.user_id,
2030: SYSDATE,
2033: FROM ZX_FC_TYPES_B
2034: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
2035: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
2036: AND NOT EXISTS
2037: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'CO');
2038: END IF;
2039:
2040: End if; -- End of Inventory checking
2041: