[Home] [Help]
1217: AND mrc_tax_line_flag = 'N'
1218: ORDER BY tax_regime_code, tax, tax_apportionment_line_number;
1219:
1220: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1221: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1222: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1223: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1224: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1225:
1218: ORDER BY tax_regime_code, tax, tax_apportionment_line_number;
1219:
1220: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1221: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1222: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1223: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1224: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1225:
1226: l_current_line_amt zx_lines.line_amt%TYPE;
1219:
1220: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1221: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1222: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1223: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1224: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1225:
1226: l_current_line_amt zx_lines.line_amt%TYPE;
1227: l_rownum BINARY_INTEGER;
1220: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1221: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1222: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1223: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1224: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1225:
1226: l_current_line_amt zx_lines.line_amt%TYPE;
1227: l_rownum BINARY_INTEGER;
1228: l_error_buffer VARCHAR2(200);
1270: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1271:
1272: -- populate tax cache : bug 5167406
1273: --
1274: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1275: p_tax_id => tax_line_rec.tax_id,
1276: p_return_status => x_return_status,
1277: p_error_buffer => l_error_buffer);
1278:
1280: IF (g_level_statement >= g_current_runtime_level ) THEN
1281: FND_LOG.STRING(g_level_statement,
1282: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1283: 'Incorrect return_status after calling ' ||
1284: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1285: FND_LOG.STRING(g_level_statement,
1286: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1287: 'RETURN_STATUS = ' || x_return_status);
1288: FND_LOG.STRING(g_level_statement,
1382: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1383:
1384: -- populate tax cache : bug 5167406
1385: --
1386: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1387: p_tax_id => tax_line_rec.tax_id,
1388: p_return_status => x_return_status,
1389: p_error_buffer => l_error_buffer);
1390:
1392: IF (g_level_statement >= g_current_runtime_level ) THEN
1393: FND_LOG.STRING(g_level_statement,
1394: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1395: 'Incorrect return_status after calling ' ||
1396: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1397: FND_LOG.STRING(g_level_statement,
1398: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1399: 'RETURN_STATUS = ' || x_return_status);
1400: FND_LOG.STRING(g_level_statement,
1533: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1534:
1535: -- populate tax cache : bug 5167406
1536: --
1537: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1538: p_tax_id => tax_line_rec.tax_id,
1539: p_return_status => x_return_status,
1540: p_error_buffer => l_error_buffer);
1541:
1543: IF (g_level_statement >= g_current_runtime_level ) THEN
1544: FND_LOG.STRING(g_level_statement,
1545: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1546: 'Incorrect return_status after calling ' ||
1547: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1548: FND_LOG.STRING(g_level_statement,
1549: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1550: 'RETURN_STATUS = ' || x_return_status);
1551: FND_LOG.STRING(g_level_statement,
1636: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1637:
1638: -- populate tax cache : bug 5167406
1639: --
1640: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1641: p_tax_id => tax_line_rec.tax_id,
1642: p_return_status => x_return_status,
1643: p_error_buffer => l_error_buffer);
1644:
1646: IF (g_level_statement >= g_current_runtime_level ) THEN
1647: FND_LOG.STRING(g_level_statement,
1648: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1649: 'Incorrect return_status after calling ' ||
1650: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1651: FND_LOG.STRING(g_level_statement,
1652: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1653: 'RETURN_STATUS = ' || x_return_status);
1654: FND_LOG.STRING(g_level_statement,
1739: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1740:
1741: -- populate tax cache : bug 5167406
1742: --
1743: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1744: p_tax_id => tax_line_rec.tax_id,
1745: p_return_status => x_return_status,
1746: p_error_buffer => l_error_buffer);
1747:
1749: IF (g_level_statement >= g_current_runtime_level ) THEN
1750: FND_LOG.STRING(g_level_statement,
1751: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1752: 'Incorrect return_status after calling ' ||
1753: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1754: FND_LOG.STRING(g_level_statement,
1755: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1756: 'RETURN_STATUS = ' || x_return_status);
1757: FND_LOG.STRING(g_level_statement,
1846: --
1847: -- set x_begin_index
1848: --
1849: -- Bug 8220741
1850: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1851: p_tax_id => tax_line_rec.tax_id,
1852: p_return_status => x_return_status,
1853: p_error_buffer => l_error_buffer);
1854: -- End Bug 8220741
1893: --End of Bug 7383041
1894: ELSE
1895: -- validate and populate tax_regime_id
1896: --
1897: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
1898: tax_line_rec.tax_regime_code,
1899: p_tax_determine_date,
1900: l_tax_regime_rec,
1901: x_return_status,
1905: IF (g_level_statement >= g_current_runtime_level ) THEN
1906: FND_LOG.STRING(g_level_statement,
1907: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1908: 'Incorrect return_status after calling ' ||
1909: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
1910: FND_LOG.STRING(g_level_statement,
1911: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1912: 'RETURN_STATUS = ' || x_return_status);
1913: FND_LOG.STRING(g_level_statement,
1922: l_tax_regime_rec.tax_regime_id;
1923:
1924: -- validate and populate tax_id
1925: --
1926: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
1927: tax_line_rec.tax_regime_code,
1928: tax_line_rec.tax,
1929: p_tax_determine_date,
1930: l_tax_rec,
1935: IF (g_level_statement >= g_current_runtime_level ) THEN
1936: FND_LOG.STRING(g_level_statement,
1937: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1938: 'Incorrect return_status after calling ' ||
1939: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1940: FND_LOG.STRING(g_level_statement,
1941: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1942: 'RETURN_STATUS = ' || x_return_status);
1943: FND_LOG.STRING(g_level_statement,
1953: --
1954: -- validate and populate tax_jurisdiction_id
1955: --
1956: IF tax_line_rec.tax_jurisdiction_code is not NULL THEN
1957: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
1958: tax_line_rec.tax_regime_code,
1959: tax_line_rec.tax,
1960: tax_line_rec.tax_jurisdiction_code,
1961: p_tax_determine_date,
1967: IF (g_level_statement >= g_current_runtime_level ) THEN
1968: FND_LOG.STRING(g_level_statement,
1969: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1970: 'Incorrect return_status after calling ' ||
1971: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
1972: FND_LOG.STRING(g_level_statement,
1973: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1974: 'RETURN_STATUS = ' || x_return_status);
1975: FND_LOG.STRING(g_level_statement,
1985: END IF;
1986:
1987:
1988: -- validate and populate tax_status_id
1989: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
1990: tax_line_rec.tax,
1991: tax_line_rec.tax_regime_code,
1992: tax_line_rec.tax_status_code,
1993: p_tax_determine_date,
1999: IF (g_level_statement >= g_current_runtime_level ) THEN
2000: FND_LOG.STRING(g_level_statement,
2001: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2002: 'Incorrect return_status after calling ' ||
2003: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2004: FND_LOG.STRING(g_level_statement,
2005: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2006: 'RETURN_STATUS = ' || x_return_status);
2007: FND_LOG.STRING(g_level_statement,
2015: l_rownum).tax_status_id := l_tax_status_rec.tax_status_id;
2016:
2017: -- validate and populate tax_rate_id
2018: --
2019: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
2020: tax_line_rec.tax_regime_code,
2021: tax_line_rec.tax,
2022: tax_line_rec.tax_jurisdiction_code,
2023: tax_line_rec.tax_status_code,
2032: IF (g_level_statement >= g_current_runtime_level ) THEN
2033: FND_LOG.STRING(g_level_statement,
2034: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2035: 'Incorrect return_status after calling ' ||
2036: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2037: FND_LOG.STRING(g_level_statement,
2038: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2039: 'RETURN_STATUS = ' || x_return_status);
2040: FND_LOG.STRING(g_level_statement,
2297: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2298: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2299: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2300: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2301: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2302: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2303:
2304: l_error_buffer VARCHAR2(200);
2305: l_tax_tbl_subscript NUMBER;
2298: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2299: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2300: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2301: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2302: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2303:
2304: l_error_buffer VARCHAR2(200);
2305: l_tax_tbl_subscript NUMBER;
2306:
2531: END IF;
2532:
2533: -- populate g_tax_rec_tbl, if it does not exist
2534: --
2535: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(l_tax_rec.tax_id) THEN
2536:
2537: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id) := l_tax_rec;
2538:
2539: /* Following are commented out since the select column in the cursor
2533: -- populate g_tax_rec_tbl, if it does not exist
2534: --
2535: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(l_tax_rec.tax_id) THEN
2536:
2537: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id) := l_tax_rec;
2538:
2539: /* Following are commented out since the select column in the cursor
2540: get_all_taxes_for_regime_cur has the same set of column as the definition
2541: of ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl and in the same order. Changed to
2537: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id) := l_tax_rec;
2538:
2539: /* Following are commented out since the select column in the cursor
2540: get_all_taxes_for_regime_cur has the same set of column as the definition
2541: of ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl and in the same order. Changed to
2542: assignment as above. If later new columns added to get_all_taxes_for_regime_cur,
2543: but not need to cache, we need to uncomment this part and add the assignment
2544: individually.
2545:
2542: assignment as above. If later new columns added to get_all_taxes_for_regime_cur,
2543: but not need to cache, we need to uncomment this part and add the assignment
2544: individually.
2545:
2546: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2547: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
2548: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2549: l_tax_rec.tax_id).tax := l_tax_rec.tax;
2550: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2544: individually.
2545:
2546: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2547: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
2548: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2549: l_tax_rec.tax_id).tax := l_tax_rec.tax;
2550: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2551: l_tax_rec.tax_id).def_place_of_supply_type_code :=
2552: l_tax_rec.def_place_of_supply_type_code;
2546: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2547: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
2548: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2549: l_tax_rec.tax_id).tax := l_tax_rec.tax;
2550: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2551: l_tax_rec.tax_id).def_place_of_supply_type_code :=
2552: l_tax_rec.def_place_of_supply_type_code;
2553: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2554: l_tax_rec.tax_id).place_of_supply_rule_flag :=
2549: l_tax_rec.tax_id).tax := l_tax_rec.tax;
2550: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2551: l_tax_rec.tax_id).def_place_of_supply_type_code :=
2552: l_tax_rec.def_place_of_supply_type_code;
2553: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2554: l_tax_rec.tax_id).place_of_supply_rule_flag :=
2555: l_tax_rec.place_of_supply_rule_flag;
2556: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2557: l_tax_rec.tax_id).applicability_rule_flag :=
2552: l_tax_rec.def_place_of_supply_type_code;
2553: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2554: l_tax_rec.tax_id).place_of_supply_rule_flag :=
2555: l_tax_rec.place_of_supply_rule_flag;
2556: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2557: l_tax_rec.tax_id).applicability_rule_flag :=
2558: l_tax_rec.applicability_rule_flag;
2559: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2560: l_tax_rec.tax_id).direct_rate_rule_flag :=
2555: l_tax_rec.place_of_supply_rule_flag;
2556: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2557: l_tax_rec.tax_id).applicability_rule_flag :=
2558: l_tax_rec.applicability_rule_flag;
2559: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2560: l_tax_rec.tax_id).direct_rate_rule_flag :=
2561: l_tax_rec.direct_rate_rule_flag;
2562: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2563: l_tax_rec.tax_id).def_registr_party_type_code :=
2558: l_tax_rec.applicability_rule_flag;
2559: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2560: l_tax_rec.tax_id).direct_rate_rule_flag :=
2561: l_tax_rec.direct_rate_rule_flag;
2562: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2563: l_tax_rec.tax_id).def_registr_party_type_code :=
2564: l_tax_rec.def_registr_party_type_code;
2565: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2566: l_tax_rec.tax_id).registration_type_rule_flag :=
2561: l_tax_rec.direct_rate_rule_flag;
2562: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2563: l_tax_rec.tax_id).def_registr_party_type_code :=
2564: l_tax_rec.def_registr_party_type_code;
2565: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2566: l_tax_rec.tax_id).registration_type_rule_flag :=
2567: l_tax_rec.registration_type_rule_flag;
2568: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2569: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
2564: l_tax_rec.def_registr_party_type_code;
2565: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2566: l_tax_rec.tax_id).registration_type_rule_flag :=
2567: l_tax_rec.registration_type_rule_flag;
2568: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2569: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
2570: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2571: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
2572: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2566: l_tax_rec.tax_id).registration_type_rule_flag :=
2567: l_tax_rec.registration_type_rule_flag;
2568: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2569: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
2570: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2571: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
2572: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2573: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
2574: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2568: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2569: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
2570: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2571: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
2572: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2573: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
2574: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2575: l_tax_rec.tax_id).minimum_accountable_unit :=
2576: l_tax_rec.minimum_accountable_unit;
2570: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2571: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
2572: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2573: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
2574: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2575: l_tax_rec.tax_id).minimum_accountable_unit :=
2576: l_tax_rec.minimum_accountable_unit;
2577: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2578: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
2573: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
2574: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2575: l_tax_rec.tax_id).minimum_accountable_unit :=
2576: l_tax_rec.minimum_accountable_unit;
2577: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2578: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
2579: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2580: l_tax_rec.tax_id).tax_status_rule_flag :=
2581: l_tax_rec.tax_status_rule_flag;
2575: l_tax_rec.tax_id).minimum_accountable_unit :=
2576: l_tax_rec.minimum_accountable_unit;
2577: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2578: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
2579: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2580: l_tax_rec.tax_id).tax_status_rule_flag :=
2581: l_tax_rec.tax_status_rule_flag;
2582: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2583: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
2578: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
2579: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2580: l_tax_rec.tax_id).tax_status_rule_flag :=
2581: l_tax_rec.tax_status_rule_flag;
2582: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2583: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
2584: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2585: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
2586: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2580: l_tax_rec.tax_id).tax_status_rule_flag :=
2581: l_tax_rec.tax_status_rule_flag;
2582: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2583: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
2584: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2585: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
2586: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2587: l_tax_rec.tax_id).taxable_basis_rule_flag :=
2588: l_tax_rec.taxable_basis_rule_flag;
2582: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2583: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
2584: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2585: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
2586: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2587: l_tax_rec.tax_id).taxable_basis_rule_flag :=
2588: l_tax_rec.taxable_basis_rule_flag;
2589: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2590: l_tax_rec.tax_id).def_tax_calc_formula :=
2585: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
2586: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2587: l_tax_rec.tax_id).taxable_basis_rule_flag :=
2588: l_tax_rec.taxable_basis_rule_flag;
2589: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2590: l_tax_rec.tax_id).def_tax_calc_formula :=
2591: l_tax_rec.def_tax_calc_formula;
2592: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2593: l_tax_rec.tax_id).def_taxable_basis_formula :=
2588: l_tax_rec.taxable_basis_rule_flag;
2589: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2590: l_tax_rec.tax_id).def_tax_calc_formula :=
2591: l_tax_rec.def_tax_calc_formula;
2592: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2593: l_tax_rec.tax_id).def_taxable_basis_formula :=
2594: l_tax_rec.def_taxable_basis_formula;
2595: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2596: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
2591: l_tax_rec.def_tax_calc_formula;
2592: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2593: l_tax_rec.tax_id).def_taxable_basis_formula :=
2594: l_tax_rec.def_taxable_basis_formula;
2595: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2596: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
2597: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2598: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
2599: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2593: l_tax_rec.tax_id).def_taxable_basis_formula :=
2594: l_tax_rec.def_taxable_basis_formula;
2595: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2596: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
2597: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2598: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
2599: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2600: l_tax_rec.tax_id).def_inclusive_tax_flag :=
2601: l_tax_rec.def_inclusive_tax_flag;
2595: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2596: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
2597: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2598: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
2599: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2600: l_tax_rec.tax_id).def_inclusive_tax_flag :=
2601: l_tax_rec.def_inclusive_tax_flag;
2602: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2603: l_tax_rec.tax_id).applied_amt_handling_flag :=
2598: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
2599: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2600: l_tax_rec.tax_id).def_inclusive_tax_flag :=
2601: l_tax_rec.def_inclusive_tax_flag;
2602: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2603: l_tax_rec.tax_id).applied_amt_handling_flag :=
2604: l_tax_rec.applied_amt_handling_flag;
2605: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2606: l_tax_rec.tax_id).exchange_rate_type :=
2601: l_tax_rec.def_inclusive_tax_flag;
2602: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2603: l_tax_rec.tax_id).applied_amt_handling_flag :=
2604: l_tax_rec.applied_amt_handling_flag;
2605: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2606: l_tax_rec.tax_id).exchange_rate_type :=
2607: l_tax_rec.exchange_rate_type;
2608: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2609: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
2604: l_tax_rec.applied_amt_handling_flag;
2605: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2606: l_tax_rec.tax_id).exchange_rate_type :=
2607: l_tax_rec.exchange_rate_type;
2608: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2609: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
2610: l_tax_rec.has_other_jurisdictions_flag;
2611: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2612: l_tax_rec.tax_id).tax_exmpt_source_tax :=
2607: l_tax_rec.exchange_rate_type;
2608: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2609: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
2610: l_tax_rec.has_other_jurisdictions_flag;
2611: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2612: l_tax_rec.tax_id).tax_exmpt_source_tax :=
2613: l_tax_rec.tax_exmpt_source_tax;
2614: */
2615:
2630: p_trx_line_index) = 'INTERCOMPANY_TRX')
2631: THEN
2632: -- Check if this tax line exists in the new created applicable tax lines
2633: --
2634: l_tax_tbl_subscript := ZX_TDS_UTILITIES_PKG.get_tax_index(
2635: l_tax_rec.tax_regime_code,
2636: l_tax_rec.tax,
2637: l_trx_line_id,
2638: l_trx_level_type,
2644: IF (g_level_statement >= g_current_runtime_level ) THEN
2645: FND_LOG.STRING(g_level_statement,
2646: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2647: 'Incorrect return_status after calling ' ||
2648: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
2649: FND_LOG.STRING(g_level_statement,
2650: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2651: 'RETURN_STATUS = ' || x_return_status);
2652: FND_LOG.STRING(g_level_statement,
3116: l_direct_rate_result_rec.rate_result;
3117:
3118: -- populate tax_status_id
3119: --
3120: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
3121: l_tax_rec.tax,
3122: l_tax_rec.tax_regime_code,
3123: l_direct_rate_result_rec.status_result,
3124: p_tax_determine_date,
3130: IF (g_level_error >= g_current_runtime_level ) THEN
3131: FND_LOG.STRING(g_level_error,
3132: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3133: 'Incorrect return_status after calling '||
3134: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
3135: FND_LOG.STRING(g_level_error,
3136: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3137: 'RETURN_STATUS = ' || x_return_status);
3138: FND_LOG.STRING(g_level_error,
3500: l_new_row_num NUMBER;
3501: l_begin_index BINARY_INTEGER;
3502: l_error_buffer VARCHAR2(200);
3503: l_line_amt_current NUMBER;
3504: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;
3505: l_applied_amt_handling_flag ZX_TAXES_B.APPLIED_AMT_HANDLING_FLAG%TYPE;
3506:
3507: BEGIN
3508:
3523: l_begin_index := l_new_row_num + 1;
3524:
3525: FOR tax_line_rec in get_tax_lines LOOP
3526:
3527: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,
3528: -- if it does not exists there.
3529: --
3530: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
3531: p_tax_id => tax_line_rec.tax_id,
3526:
3527: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,
3528: -- if it does not exists there.
3529: --
3530: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
3531: p_tax_id => tax_line_rec.tax_id,
3532: p_return_status => x_return_status,
3533: p_error_buffer => l_error_buffer);
3534:
3536: IF (g_level_statement >= g_current_runtime_level ) THEN
3537: FND_LOG.STRING(g_level_statement,
3538: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3539: 'Incorrect return_status after calling ' ||
3540: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
3541: FND_LOG.STRING(g_level_statement,
3542: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3543: 'RETURN_STATUS = ' || x_return_status);
3544: FND_LOG.STRING(g_level_statement,
3603: -- bug 5077691: populate legal_reporting_status
3604: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
3605: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3606: l_new_row_num).legal_reporting_status :=
3607: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
3608: tax_line_rec.tax_id).legal_reporting_status_def_val;
3609: END IF;
3610:
3611: -- For prepayment trx, tax lines are fetched from the original document and status codes
3611: -- For prepayment trx, tax lines are fetched from the original document and status codes
3612: -- are copied to the new tax lines. However, since tax determiniation date most likely
3613: -- are different for the current document, the status id will need to be repopulated.
3614:
3615: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
3616: tax_line_rec.tax,
3617: tax_line_rec.tax_regime_code,
3618: tax_line_rec.tax_status_code,
3619: p_tax_determine_date,
3625: IF (g_level_error >= g_current_runtime_level ) THEN
3626: FND_LOG.STRING(g_level_error,
3627: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3628: 'Incorrect return_status after calling ' ||
3629: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
3630: FND_LOG.STRING(g_level_error,
3631: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3632: 'RETURN_STATUS = ' || x_return_status);
3633: FND_LOG.STRING(g_level_error,
3668: -- 2. If applied_amt_handling_flag ='R', populate tax rate Code from
3669: -- applied document. Tax rate is determined in the current document.
3670: -- Tax is recalculated based one the tax rate in the current document.
3671:
3672: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
3673: tax_line_rec.tax_id).applied_amt_handling_flag = 'P' THEN
3674:
3675: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3676: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
3691: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3692: l_new_row_num).tax_currency_conversion_rate :=
3693: tax_line_rec.tax_currency_conversion_rate;
3694:
3695: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
3696: tax_line_rec.tax_id).applied_amt_handling_flag = 'R' THEN
3697:
3698: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3699: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
3808: l_new_row_num).other_doc_source := 'APPLIED_FROM';
3809: --
3810: -- Bug#7302008 (Fusion Bug#7301957)- populate unrounded taxable amt and unrounded tax amt
3811: --
3812: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
3813: tax_line_rec.tax_id).applied_amt_handling_flag = 'P' THEN
3814:
3815: -- set unrounded taxable amt and unrounded tax amt
3816: --
4097: l_begin_index := l_new_row_num + 1;
4098:
4099: FOR tax_line_rec in get_tax_lines LOOP
4100:
4101: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,
4102: -- if it does not exists there.
4103: --
4104: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
4105: p_tax_id => tax_line_rec.tax_id,
4100:
4101: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,
4102: -- if it does not exists there.
4103: --
4104: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
4105: p_tax_id => tax_line_rec.tax_id,
4106: p_return_status => x_return_status,
4107: p_error_buffer => l_error_buffer);
4108:
4110: IF (g_level_statement >= g_current_runtime_level ) THEN
4111: FND_LOG.STRING(g_level_statement,
4112: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4113: 'Incorrect return_status after calling ' ||
4114: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
4115: FND_LOG.STRING(g_level_statement,
4116: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4117: 'RETURN_STATUS = ' || x_return_status);
4118: FND_LOG.STRING(g_level_statement,
4210: -- bug 5077691: populate legal_reporting_status
4211: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
4212: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4213: l_new_row_num).legal_reporting_status :=
4214: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
4215: tax_line_rec.tax_id).legal_reporting_status_def_val;
4216: END IF;
4217:
4218: -- If the value of p_event_class_rec.tax_recovery_flag is 'N',
5258: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
5259: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
5260:
5261: -- Bug#5395227
5262: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
5263: l_has_other_jurisdictions_flag VARCHAR2(1);
5264:
5265: BEGIN
5266: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5487: -- BEGIN
5488: -- Bug#5395227
5489: l_has_other_jurisdictions_flag := NULL;
5490:
5491: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
5492: p_tax_regime_code,
5493: p_tax,
5494: p_tax_determine_date,
5495: l_tax_rec,
5807: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule IS NOT NULL THEN
5808: x_rounding_rule_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule;
5809: ELSE
5810: x_rounding_rule_code :=
5811: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
5812: END IF;
5813:
5814: ELSE -- g_rounding_level = 'LINE'
5815:
5817: -- is 'N', that means, user can not override the
5818: -- rounding rule at other levels, rounding rule
5819: -- should come from tax level directly
5820: --
5821: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).allow_rounding_override_flag =
5822: 'N' THEN
5823: x_rounding_rule_code :=
5824: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
5825: ELSE
5820: --
5821: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).allow_rounding_override_flag =
5822: 'N' THEN
5823: x_rounding_rule_code :=
5824: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
5825: ELSE
5826: --
5827: -- the rounding rule defined at tax level
5828: -- was overridden at other levels
5851: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule IS NOT NULL THEN
5852: x_rounding_rule_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule;
5853: ELSE
5854: x_rounding_rule_code :=
5855: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
5856: END IF;
5857: END IF;
5858: END IF;
5859: END IF;
5871: WHEN OTHERS THEN
5872: x_registration_number := NULL;
5873: x_self_assessment_flg := 'N';
5874: x_tax_inclusion_flag := NULL;
5875: -- ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).def_inclusive_tax_flag;
5876:
5877: -- x_rounding_rule_code
5878: --
5879: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule IS NOT NULL THEN
5879: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule IS NOT NULL THEN
5880: x_rounding_rule_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule;
5881: ELSE
5882: x_rounding_rule_code :=
5883: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
5884: END IF;
5885:
5886: IF (g_level_statement >= g_current_runtime_level ) THEN
5887: FND_LOG.STRING(g_level_statement,
6000: p_parent_ptp_id => l_hq_estb_ptp_id,
6001: p_site_ptp_id => l_party_ptp_id,
6002: p_account_type_code => NULL,
6003: p_tax_determine_date => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date,
6004: p_tax => ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax,
6005: p_tax_regime_code => ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_regime_code,
6006: p_jurisdiction_code => l_jurisdiction_code,
6007: p_account_id => NULL,
6008: p_account_site_id => NULL,
6001: p_site_ptp_id => l_party_ptp_id,
6002: p_account_type_code => NULL,
6003: p_tax_determine_date => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date,
6004: p_tax => ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax,
6005: p_tax_regime_code => ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_regime_code,
6006: p_jurisdiction_code => l_jurisdiction_code,
6007: p_account_id => NULL,
6008: p_account_site_id => NULL,
6009: p_site_use_id => NULL,
6436: l_begin_index_from_acct BINARY_INTEGER;
6437: l_end_index_from_acct BINARY_INTEGER;
6438:
6439: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
6440: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6441: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6442:
6443: l_jurisdiction_id NUMBER;
6444: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6437: l_end_index_from_acct BINARY_INTEGER;
6438:
6439: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
6440: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6441: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6442:
6443: l_jurisdiction_id NUMBER;
6444: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6445:
6583:
6584: -- Check if this tax line exists in the applicable tax lines
6585: --
6586: IF l_begin_index IS NOT NULL THEN
6587: l_tax_tbl_subscript := ZX_TDS_UTILITIES_PKG.get_tax_index(
6588: l_tax_rec.tax_regime_code,
6589: l_tax_rec.tax,
6590: l_trx_line_id,
6591: l_trx_level_type,
6597: IF (g_level_statement >= g_current_runtime_level ) THEN
6598: FND_LOG.STRING(g_level_statement,
6599: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6600: 'Incorrect return_status after calling ' ||
6601: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
6602: FND_LOG.STRING(g_level_statement,
6603: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6604: 'RETURN_STATUS = ' || x_return_status);
6605: FND_LOG.STRING(g_level_statement,
6616: -- Create a new tax line in p_detail_tax_lines_tbl
6617: --
6618: -- populate g_tax_rec_tbl, if it does not exist
6619: --
6620: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(l_tax_rec.tax_id) THEN
6621:
6622:
6623: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6624: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
6619: --
6620: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(l_tax_rec.tax_id) THEN
6621:
6622:
6623: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6624: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
6625: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6626: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
6627: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id).tax :=l_tax_rec.tax;
6621:
6622:
6623: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6624: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
6625: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6626: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
6627: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id).tax :=l_tax_rec.tax;
6628:
6629: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6623: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6624: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
6625: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6626: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
6627: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id).tax :=l_tax_rec.tax;
6628:
6629: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6630: l_tax_rec.tax_id).def_place_of_supply_type_code :=
6631: l_tax_rec.def_place_of_supply_type_code;
6625: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6626: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
6627: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id).tax :=l_tax_rec.tax;
6628:
6629: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6630: l_tax_rec.tax_id).def_place_of_supply_type_code :=
6631: l_tax_rec.def_place_of_supply_type_code;
6632: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6633: l_tax_rec.tax_id).place_of_supply_rule_flag :=
6628:
6629: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6630: l_tax_rec.tax_id).def_place_of_supply_type_code :=
6631: l_tax_rec.def_place_of_supply_type_code;
6632: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6633: l_tax_rec.tax_id).place_of_supply_rule_flag :=
6634: l_tax_rec.place_of_supply_rule_flag;
6635: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6636: l_tax_rec.tax_id).applicability_rule_flag :=
6631: l_tax_rec.def_place_of_supply_type_code;
6632: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6633: l_tax_rec.tax_id).place_of_supply_rule_flag :=
6634: l_tax_rec.place_of_supply_rule_flag;
6635: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6636: l_tax_rec.tax_id).applicability_rule_flag :=
6637: l_tax_rec.applicability_rule_flag;
6638: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6639: l_tax_rec.tax_id).direct_rate_rule_flag :=
6634: l_tax_rec.place_of_supply_rule_flag;
6635: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6636: l_tax_rec.tax_id).applicability_rule_flag :=
6637: l_tax_rec.applicability_rule_flag;
6638: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6639: l_tax_rec.tax_id).direct_rate_rule_flag :=
6640: l_tax_rec.direct_rate_rule_flag;
6641: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6642: l_tax_rec.tax_id).def_registr_party_type_code :=
6637: l_tax_rec.applicability_rule_flag;
6638: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6639: l_tax_rec.tax_id).direct_rate_rule_flag :=
6640: l_tax_rec.direct_rate_rule_flag;
6641: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6642: l_tax_rec.tax_id).def_registr_party_type_code :=
6643: l_tax_rec.def_registr_party_type_code;
6644: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6645: l_tax_rec.tax_id).registration_type_rule_flag :=
6640: l_tax_rec.direct_rate_rule_flag;
6641: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6642: l_tax_rec.tax_id).def_registr_party_type_code :=
6643: l_tax_rec.def_registr_party_type_code;
6644: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6645: l_tax_rec.tax_id).registration_type_rule_flag :=
6646: l_tax_rec.registration_type_rule_flag;
6647:
6648: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6644: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6645: l_tax_rec.tax_id).registration_type_rule_flag :=
6646: l_tax_rec.registration_type_rule_flag;
6647:
6648: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6649: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
6650: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6651: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
6652: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6646: l_tax_rec.registration_type_rule_flag;
6647:
6648: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6649: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
6650: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6651: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
6652: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6653: l_tax_rec.tax_id).minimum_accountable_unit :=
6654: l_tax_rec.minimum_accountable_unit;
6648: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6649: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
6650: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6651: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
6652: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6653: l_tax_rec.tax_id).minimum_accountable_unit :=
6654: l_tax_rec.minimum_accountable_unit;
6655: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6656: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
6651: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
6652: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6653: l_tax_rec.tax_id).minimum_accountable_unit :=
6654: l_tax_rec.minimum_accountable_unit;
6655: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6656: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
6657: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6658: l_tax_rec.tax_id).tax_status_rule_flag :=
6659: l_tax_rec.tax_status_rule_flag;
6653: l_tax_rec.tax_id).minimum_accountable_unit :=
6654: l_tax_rec.minimum_accountable_unit;
6655: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6656: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
6657: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6658: l_tax_rec.tax_id).tax_status_rule_flag :=
6659: l_tax_rec.tax_status_rule_flag;
6660: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6661: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
6656: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
6657: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6658: l_tax_rec.tax_id).tax_status_rule_flag :=
6659: l_tax_rec.tax_status_rule_flag;
6660: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6661: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
6662: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6663: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
6664: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6658: l_tax_rec.tax_id).tax_status_rule_flag :=
6659: l_tax_rec.tax_status_rule_flag;
6660: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6661: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
6662: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6663: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
6664: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6665: l_tax_rec.tax_id).taxable_basis_rule_flag :=
6666: l_tax_rec.taxable_basis_rule_flag;
6660: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6661: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
6662: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6663: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
6664: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6665: l_tax_rec.tax_id).taxable_basis_rule_flag :=
6666: l_tax_rec.taxable_basis_rule_flag;
6667: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6668: l_tax_rec.tax_id).def_tax_calc_formula :=
6663: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
6664: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6665: l_tax_rec.tax_id).taxable_basis_rule_flag :=
6666: l_tax_rec.taxable_basis_rule_flag;
6667: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6668: l_tax_rec.tax_id).def_tax_calc_formula :=
6669: l_tax_rec.def_tax_calc_formula;
6670: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6671: l_tax_rec.tax_id).def_taxable_basis_formula :=
6666: l_tax_rec.taxable_basis_rule_flag;
6667: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6668: l_tax_rec.tax_id).def_tax_calc_formula :=
6669: l_tax_rec.def_tax_calc_formula;
6670: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6671: l_tax_rec.tax_id).def_taxable_basis_formula :=
6672: l_tax_rec.def_taxable_basis_formula;
6673: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6674: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
6669: l_tax_rec.def_tax_calc_formula;
6670: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6671: l_tax_rec.tax_id).def_taxable_basis_formula :=
6672: l_tax_rec.def_taxable_basis_formula;
6673: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6674: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
6675: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6676: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
6677: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6671: l_tax_rec.tax_id).def_taxable_basis_formula :=
6672: l_tax_rec.def_taxable_basis_formula;
6673: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6674: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
6675: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6676: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
6677: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6678: l_tax_rec.tax_id).def_inclusive_tax_flag :=
6679: l_tax_rec.def_inclusive_tax_flag;
6673: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6674: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
6675: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6676: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
6677: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6678: l_tax_rec.tax_id).def_inclusive_tax_flag :=
6679: l_tax_rec.def_inclusive_tax_flag;
6680: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6681: l_tax_rec.tax_id).applied_amt_handling_flag :=
6676: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
6677: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6678: l_tax_rec.tax_id).def_inclusive_tax_flag :=
6679: l_tax_rec.def_inclusive_tax_flag;
6680: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6681: l_tax_rec.tax_id).applied_amt_handling_flag :=
6682: l_tax_rec.applied_amt_handling_flag;
6683: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6684: l_tax_rec.tax_id).exchange_rate_type :=
6679: l_tax_rec.def_inclusive_tax_flag;
6680: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6681: l_tax_rec.tax_id).applied_amt_handling_flag :=
6682: l_tax_rec.applied_amt_handling_flag;
6683: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6684: l_tax_rec.tax_id).exchange_rate_type :=
6685: l_tax_rec.exchange_rate_type;
6686: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6687: l_tax_rec.tax_id).effective_from := l_tax_rec.effective_from;
6682: l_tax_rec.applied_amt_handling_flag;
6683: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6684: l_tax_rec.tax_id).exchange_rate_type :=
6685: l_tax_rec.exchange_rate_type;
6686: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6687: l_tax_rec.tax_id).effective_from := l_tax_rec.effective_from;
6688: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6689: l_tax_rec.tax_id).effective_to := l_tax_rec.effective_to;
6690: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6684: l_tax_rec.tax_id).exchange_rate_type :=
6685: l_tax_rec.exchange_rate_type;
6686: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6687: l_tax_rec.tax_id).effective_from := l_tax_rec.effective_from;
6688: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6689: l_tax_rec.tax_id).effective_to := l_tax_rec.effective_to;
6690: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6691: l_tax_rec.tax_id).compounding_precedence :=
6692: l_tax_rec.compounding_precedence;
6686: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6687: l_tax_rec.tax_id).effective_from := l_tax_rec.effective_from;
6688: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6689: l_tax_rec.tax_id).effective_to := l_tax_rec.effective_to;
6690: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6691: l_tax_rec.tax_id).compounding_precedence :=
6692: l_tax_rec.compounding_precedence;
6693: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6694: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
6689: l_tax_rec.tax_id).effective_to := l_tax_rec.effective_to;
6690: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6691: l_tax_rec.tax_id).compounding_precedence :=
6692: l_tax_rec.compounding_precedence;
6693: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6694: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
6695: l_tax_rec.has_other_jurisdictions_flag;
6696: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6697: l_tax_rec.tax_id).live_for_processing_flag :=
6692: l_tax_rec.compounding_precedence;
6693: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6694: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
6695: l_tax_rec.has_other_jurisdictions_flag;
6696: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6697: l_tax_rec.tax_id).live_for_processing_flag :=
6698: l_tax_rec.live_for_processing_flag;
6699: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6700: l_tax_rec.tax_id).regn_num_same_as_le_flag:=
6695: l_tax_rec.has_other_jurisdictions_flag;
6696: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6697: l_tax_rec.tax_id).live_for_processing_flag :=
6698: l_tax_rec.live_for_processing_flag;
6699: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6700: l_tax_rec.tax_id).regn_num_same_as_le_flag:=
6701: l_tax_rec.regn_num_same_as_le_flag;
6702: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6703: l_tax_rec.tax_id).applicable_by_default_flag :=
6698: l_tax_rec.live_for_processing_flag;
6699: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6700: l_tax_rec.tax_id).regn_num_same_as_le_flag:=
6701: l_tax_rec.regn_num_same_as_le_flag;
6702: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6703: l_tax_rec.tax_id).applicable_by_default_flag :=
6704: l_tax_rec.applicable_by_default_flag;
6705: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6706: l_tax_rec.tax_id).record_type_code :=
6701: l_tax_rec.regn_num_same_as_le_flag;
6702: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6703: l_tax_rec.tax_id).applicable_by_default_flag :=
6704: l_tax_rec.applicable_by_default_flag;
6705: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6706: l_tax_rec.tax_id).record_type_code :=
6707: l_tax_rec.record_type_code;
6708: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6709: l_tax_rec.tax_id).tax_exmpt_cr_method_code :=
6704: l_tax_rec.applicable_by_default_flag;
6705: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6706: l_tax_rec.tax_id).record_type_code :=
6707: l_tax_rec.record_type_code;
6708: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6709: l_tax_rec.tax_id).tax_exmpt_cr_method_code :=
6710: l_tax_rec.tax_exmpt_cr_method_code;
6711: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6712: l_tax_rec.tax_id).tax_exmpt_source_tax :=
6707: l_tax_rec.record_type_code;
6708: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6709: l_tax_rec.tax_id).tax_exmpt_cr_method_code :=
6710: l_tax_rec.tax_exmpt_cr_method_code;
6711: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6712: l_tax_rec.tax_id).tax_exmpt_source_tax :=
6713: l_tax_rec.tax_exmpt_source_tax;
6714: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6715: l_tax_rec.tax_id).legal_reporting_status_def_val :=
6710: l_tax_rec.tax_exmpt_cr_method_code;
6711: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6712: l_tax_rec.tax_id).tax_exmpt_source_tax :=
6713: l_tax_rec.tax_exmpt_source_tax;
6714: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6715: l_tax_rec.tax_id).legal_reporting_status_def_val :=
6716: l_tax_rec.legal_reporting_status_def_val;
6717: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6718: l_tax_rec.tax_id).def_rec_settlement_option_code :=
6713: l_tax_rec.tax_exmpt_source_tax;
6714: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6715: l_tax_rec.tax_id).legal_reporting_status_def_val :=
6716: l_tax_rec.legal_reporting_status_def_val;
6717: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6718: l_tax_rec.tax_id).def_rec_settlement_option_code :=
6719: l_tax_rec.def_rec_settlement_option_code;
6720: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6721: l_tax_rec.tax_id).zone_geography_type :=
6716: l_tax_rec.legal_reporting_status_def_val;
6717: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6718: l_tax_rec.tax_id).def_rec_settlement_option_code :=
6719: l_tax_rec.def_rec_settlement_option_code;
6720: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6721: l_tax_rec.tax_id).zone_geography_type :=
6722: l_tax_rec.zone_geography_type;
6723: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6724: l_tax_rec.tax_id).override_geography_type :=
6719: l_tax_rec.def_rec_settlement_option_code;
6720: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6721: l_tax_rec.tax_id).zone_geography_type :=
6722: l_tax_rec.zone_geography_type;
6723: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6724: l_tax_rec.tax_id).override_geography_type :=
6725: l_tax_rec.override_geography_type;
6726: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6727: l_tax_rec.tax_id).tax_account_source_tax :=
6722: l_tax_rec.zone_geography_type;
6723: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6724: l_tax_rec.tax_id).override_geography_type :=
6725: l_tax_rec.override_geography_type;
6726: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6727: l_tax_rec.tax_id).tax_account_source_tax :=
6728: l_tax_rec.tax_account_source_tax;
6729:
6730:
6736: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0) + 1;
6737:
6738: -- validate and populate tax_regime_id
6739: --
6740: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
6741: l_tax_rec.tax_regime_code,
6742: p_tax_determine_date,
6743: l_tax_regime_rec,
6744: x_return_status,
6748: IF (g_level_statement >= g_current_runtime_level ) THEN
6749: FND_LOG.STRING(g_level_statement,
6750: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6751: 'Incorrect return_status after calling ' ||
6752: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
6753: FND_LOG.STRING(g_level_statement,
6754: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6755: 'RETURN_STATUS = ' || x_return_status);
6756: FND_LOG.STRING(g_level_statement,
6764: l_new_row_num).tax_regime_id := l_tax_regime_rec.tax_regime_id;
6765:
6766: -- validate and populate tax_status_id
6767: --
6768: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
6769: l_tax_rec.tax,
6770: l_tax_rec.tax_regime_code,
6771: l_tax_rec.tax_status_code,
6772: p_tax_determine_date,
6778: IF (g_level_statement >= g_current_runtime_level ) THEN
6779: FND_LOG.STRING(g_level_statement,
6780: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6781: 'Incorrect return_status after calling ' ||
6782: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
6783: FND_LOG.STRING(g_level_statement,
6784: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6785: 'RETURN_STATUS = ' || x_return_status);
6786: FND_LOG.STRING(g_level_statement,
6794: l_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
6795:
6796: -- validate and populate tax_rate_id
6797: --
6798: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
6799: l_tax_rec.tax_regime_code,
6800: l_tax_rec.tax,
6801: NULL, --++++
6802: l_tax_rec.tax_status_code,
6811: IF (g_level_statement >= g_current_runtime_level ) THEN
6812: FND_LOG.STRING(g_level_statement,
6813: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6814: 'Incorrect return_status after calling ' ||
6815: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
6816: FND_LOG.STRING(g_level_statement,
6817: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6818: 'RETURN_STATUS = ' || x_return_status);
6819: FND_LOG.STRING(g_level_statement,
6905: -- bug 5077691: populate legal_reporting_status
6906: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
6907: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
6908: l_new_row_num).legal_reporting_status :=
6909: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
6910: l_tax_rec.tax_id).legal_reporting_status_def_val;
6911: END IF;
6912:
6913: -- populate tax registration info
7113: AND tax_class <> 'INPUT'
7114: ORDER BY subscription_level_code;
7115:
7116: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
7117: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
7118: l_tax_status_rec zx_tds_utilities_pkg.zx_status_info_rec;
7119: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7120: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7121: l_rownum BINARY_INTEGER;
7114: ORDER BY subscription_level_code;
7115:
7116: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
7117: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
7118: l_tax_status_rec zx_tds_utilities_pkg.zx_status_info_rec;
7119: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7120: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7121: l_rownum BINARY_INTEGER;
7122: l_error_buffer VARCHAR2(200);
7115:
7116: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
7117: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
7118: l_tax_status_rec zx_tds_utilities_pkg.zx_status_info_rec;
7119: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7120: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7121: l_rownum BINARY_INTEGER;
7122: l_error_buffer VARCHAR2(200);
7123: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
7116: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
7117: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
7118: l_tax_status_rec zx_tds_utilities_pkg.zx_status_info_rec;
7119: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7120: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7121: l_rownum BINARY_INTEGER;
7122: l_error_buffer VARCHAR2(200);
7123: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
7124: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
7200: -- the tax is not migrated from 11i, it is not madatory to define the same
7201: -- tax in AP as that in AR. In this case, we do not need to error out if
7202: -- the validations fail because we can ignore the tax lines fetched from AR
7203: --
7204: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
7205: tax_line_rec.tax_regime_code,
7206: p_tax_determine_date,
7207: l_tax_regime_rec,
7208: x_return_status,
7213: IF (g_level_statement >= g_current_runtime_level ) THEN
7214: FND_LOG.STRING(g_level_statement,
7215: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7216: 'Incorrect return_status after calling ' ||
7217: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
7218: FND_LOG.STRING(g_level_statement,
7219: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7220: 'RETURN_STATUS = ' || x_return_status);
7221: FND_LOG.STRING(g_level_statement,
7233:
7234: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
7235: l_rownum).tax_regime_id := l_tax_regime_rec.tax_regime_id;
7236:
7237: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
7238: tax_line_rec.tax_regime_code,
7239: tax_line_rec.tax,
7240: p_tax_determine_date,
7241: l_tax_rec,
7247: IF (g_level_statement >= g_current_runtime_level ) THEN
7248: FND_LOG.STRING(g_level_statement,
7249: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7250: 'Incorrect return_status after calling ' ||
7251: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
7252: FND_LOG.STRING(g_level_statement,
7253: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7254: 'RETURN_STATUS = ' || x_return_status);
7255: FND_LOG.STRING(g_level_statement,
7269: --
7270: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
7271: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
7272: l_rownum).legal_reporting_status :=
7273: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7274: l_tax_rec.tax_id).legal_reporting_status_def_val;
7275: END IF;
7276: END IF;
7277: END IF; -- l_is_valid for tax validation
7279: -- validate tax_jurisdiction_id
7280: --
7281: IF l_is_valid AND tax_line_rec.tax_jurisdiction_code is not NULL THEN
7282:
7283: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
7284: tax_line_rec.tax_regime_code,
7285: tax_line_rec.tax,
7286: tax_line_rec.tax_jurisdiction_code,
7287: p_tax_determine_date,
7294: IF (g_level_statement >= g_current_runtime_level ) THEN
7295: FND_LOG.STRING(g_level_statement,
7296: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7297: 'Incorrect return_status after calling ' ||
7298: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
7299: FND_LOG.STRING(g_level_statement,
7300: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7301: 'RETURN_STATUS = ' || x_return_status);
7302: FND_LOG.STRING(g_level_statement,
7317: -- validate tax_status_id
7318: --
7319: IF l_is_valid THEN
7320:
7321: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
7322: tax_line_rec.tax,
7323: tax_line_rec.tax_regime_code,
7324: tax_line_rec.tax_status_code,
7325: p_tax_determine_date,
7332: IF (g_level_statement >= g_current_runtime_level ) THEN
7333: FND_LOG.STRING(g_level_statement,
7334: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7335: 'Incorrect return_status after calling ' ||
7336: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
7337: FND_LOG.STRING(g_level_statement,
7338: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7339: 'RETURN_STATUS = ' || x_return_status);
7340: FND_LOG.STRING(g_level_statement,
7353:
7354: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
7355: l_rownum).tax_status_id := l_tax_status_rec.tax_status_id;
7356:
7357: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
7358: tax_line_rec.tax_regime_code,
7359: tax_line_rec.tax,
7360: tax_line_rec.tax_jurisdiction_code,
7361: tax_line_rec.tax_status_code,
7371: IF (g_level_statement >= g_current_runtime_level ) THEN
7372: FND_LOG.STRING(g_level_statement,
7373: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7374: 'Incorrect return_status after calling ' ||
7375: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
7376: FND_LOG.STRING(g_level_statement,
7377: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7378: 'RETURN_STATUS = ' || x_return_status);
7379: FND_LOG.STRING(g_level_statement,
7560:
7561: -- Tax Defined in AP or other product.
7562: -- Need to validate and populate tax_regime_id
7563: --
7564: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
7565: l_tax_regime_code,
7566: p_tax_determine_date,
7567: l_tax_regime_rec,
7568: x_return_status,
7572: IF (g_level_statement >= g_current_runtime_level ) THEN
7573: FND_LOG.STRING(g_level_statement,
7574: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7575: 'Incorrect return_status after calling ' ||
7576: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
7577: FND_LOG.STRING(g_level_statement,
7578: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7579: 'RETURN_STATUS = ' || x_return_status);
7580: FND_LOG.STRING(g_level_statement,
7590: l_rownum).tax_regime_id := l_tax_regime_rec.tax_regime_id;
7591:
7592: -- validate and populate tax_id
7593: --
7594: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
7595: l_tax_regime_code,
7596: l_tax,
7597: p_tax_determine_date,
7598: l_tax_rec,
7603: IF (g_level_statement >= g_current_runtime_level ) THEN
7604: FND_LOG.STRING(g_level_statement,
7605: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7606: 'Incorrect return_status after calling ' ||
7607: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
7608: FND_LOG.STRING(g_level_statement,
7609: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7610: 'RETURN_STATUS = ' || x_return_status);
7611: FND_LOG.STRING(g_level_statement,
7623: -- bug 5077691: populate legal_reporting_status
7624: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
7625: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
7626: l_rownum).legal_reporting_status :=
7627: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7628: l_tax_rec.tax_id).legal_reporting_status_def_val;
7629: END IF;
7630: --
7631: -- validate and populate tax_jurisdiction_id
7630: --
7631: -- validate and populate tax_jurisdiction_id
7632: --
7633: IF tax_line_rec.tax_jurisdiction_code is not NULL THEN
7634: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
7635: l_tax_regime_code,
7636: l_tax,
7637: l_tax_jurisdiction_code,
7638: p_tax_determine_date,
7644: IF (g_level_statement >= g_current_runtime_level ) THEN
7645: FND_LOG.STRING(g_level_statement,
7646: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7647: 'Incorrect return_status after calling ' ||
7648: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
7649: FND_LOG.STRING(g_level_statement,
7650: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7651: 'RETURN_STATUS = ' || x_return_status);
7652: FND_LOG.STRING(g_level_statement,
7663:
7664:
7665: -- validate and populate tax_status_id
7666: --
7667: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
7668: l_tax,
7669: l_tax_regime_code,
7670: l_tax_status_code,
7671: p_tax_determine_date,
7677: IF (g_level_statement >= g_current_runtime_level ) THEN
7678: FND_LOG.STRING(g_level_statement,
7679: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7680: 'Incorrect return_status after calling ' ||
7681: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
7682: FND_LOG.STRING(g_level_statement,
7683: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7684: 'RETURN_STATUS = ' || x_return_status);
7685: FND_LOG.STRING(g_level_statement,
7699: THEN
7700:
7701: -- validate and populate tax_rate_id and retain rate % and tax amount
7702: --
7703: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
7704: l_tax_regime_code,
7705: l_tax,
7706: l_tax_jurisdiction_code,
7707: l_tax_status_code,
7716: IF (g_level_statement >= g_current_runtime_level ) THEN
7717: FND_LOG.STRING(g_level_statement,
7718: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7719: 'Incorrect return_status after calling ' ||
7720: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
7721: FND_LOG.STRING(g_level_statement,
7722: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7723: 'RETURN_STATUS = ' || x_return_status);
7724: FND_LOG.STRING(g_level_statement,
8124: l_exception_set_tbl exception_set_tbl;
8125: l_counter NUMBER;
8126: i NUMBER;
8127: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
8128: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
8129: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
8130: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
8131: l_error_buffer VARCHAR2(200);
8132: l_rownum BINARY_INTEGER;
8125: l_counter NUMBER;
8126: i NUMBER;
8127: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
8128: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
8129: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
8130: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
8131: l_error_buffer VARCHAR2(200);
8132: l_rownum BINARY_INTEGER;
8133: l_curr_rownum BINARY_INTEGER;
8126: i NUMBER;
8127: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
8128: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
8129: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
8130: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
8131: l_error_buffer VARCHAR2(200);
8132: l_rownum BINARY_INTEGER;
8133: l_curr_rownum BINARY_INTEGER;
8134: l_tax_class zx_rates_b.tax_class%TYPE;
8323: l_tax_index := NULL;
8324:
8325: l_end_index := NVL( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);
8326: -- Check if this tax line exists in the new created applicable tax lines
8327: l_tax_index := ZX_TDS_UTILITIES_PKG.get_tax_index(
8328: l_tax_regime_code_tbl(j),
8329: l_tax_tbl(j),
8330: l_trx_line_id,
8331: l_trx_level_type,
8337: IF (g_level_statement >= g_current_runtime_level ) THEN
8338: FND_LOG.STRING(g_level_statement,
8339: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8340: 'Incorrect return_status after calling ' ||
8341: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
8342: FND_LOG.STRING(g_level_statement,
8343: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8344: 'RETURN_STATUS = ' || x_return_status);
8345: FND_LOG.STRING(g_level_statement,
8562: 1,
8563: 8192);
8564:
8565:
8566: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index)
8567: THEN
8568: -- cehck the product family from the cached structure
8569:
8570: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NULL THEN
8566: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index)
8567: THEN
8568: -- cehck the product family from the cached structure
8569:
8570: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NULL THEN
8571:
8572: l_rate_exists_same_prod_family := TRUE;
8573:
8574: ELSIF (ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NOT NULL
8570: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NULL THEN
8571:
8572: l_rate_exists_same_prod_family := TRUE;
8573:
8574: ELSIF (ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NOT NULL
8575: AND ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class = l_tax_class)
8576: THEN
8577:
8578: l_rate_exists_same_prod_family := TRUE;
8571:
8572: l_rate_exists_same_prod_family := TRUE;
8573:
8574: ELSIF (ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NOT NULL
8575: AND ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class = l_tax_class)
8576: THEN
8577:
8578: l_rate_exists_same_prod_family := TRUE;
8579:
8576: THEN
8577:
8578: l_rate_exists_same_prod_family := TRUE;
8579:
8580: ELSIF (ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NOT NULL
8581: AND ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class <> l_tax_class)
8582: THEN
8583:
8584: l_rate_exists_same_prod_family := FALSE;
8577:
8578: l_rate_exists_same_prod_family := TRUE;
8579:
8580: ELSIF (ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NOT NULL
8581: AND ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class <> l_tax_class)
8582: THEN
8583:
8584: l_rate_exists_same_prod_family := FALSE;
8585:
8583:
8584: l_rate_exists_same_prod_family := FALSE;
8585:
8586: END IF;
8587: END IF; -- ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index)
8588:
8589: IF ( NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index) )
8590: OR l_rate_exists_same_prod_family = FALSE THEN
8591: -- check product family using cursor
8585:
8586: END IF;
8587: END IF; -- ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index)
8588:
8589: IF ( NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index) )
8590: OR l_rate_exists_same_prod_family = FALSE THEN
8591: -- check product family using cursor
8592:
8593: OPEN check_tax_rate_class_csr(
8627: --
8628:
8629: -- Bug 5252411
8630:
8631: l_index := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.FIRST;
8632: l_tax_rec := NULL;
8633: WHILE l_index IS NOT NULL LOOP
8634:
8635: IF (l_tax_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax AND
8631: l_index := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.FIRST;
8632: l_tax_rec := NULL;
8633: WHILE l_index IS NOT NULL LOOP
8634:
8635: IF (l_tax_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax AND
8636: l_tax_regime_code_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax_regime_code)
8637: THEN
8638: IF (g_level_statement >= g_current_runtime_level ) THEN
8639: FND_LOG.STRING(g_level_statement,
8632: l_tax_rec := NULL;
8633: WHILE l_index IS NOT NULL LOOP
8634:
8635: IF (l_tax_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax AND
8636: l_tax_regime_code_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax_regime_code)
8637: THEN
8638: IF (g_level_statement >= g_current_runtime_level ) THEN
8639: FND_LOG.STRING(g_level_statement,
8640: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info',
8636: l_tax_regime_code_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax_regime_code)
8637: THEN
8638: IF (g_level_statement >= g_current_runtime_level ) THEN
8639: FND_LOG.STRING(g_level_statement,
8640: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info',
8641: 'tax found in tax cache, at index '||
8642: to_char(l_index));
8643: END IF;
8644:
8641: 'tax found in tax cache, at index '||
8642: to_char(l_index));
8643: END IF;
8644:
8645: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_from <= p_tax_determine_date
8646: AND (ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to >= p_tax_determine_date
8647: OR ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to IS NULL)
8648: THEN
8649: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index);
8642: to_char(l_index));
8643: END IF;
8644:
8645: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_from <= p_tax_determine_date
8646: AND (ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to >= p_tax_determine_date
8647: OR ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to IS NULL)
8648: THEN
8649: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index);
8650:
8643: END IF;
8644:
8645: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_from <= p_tax_determine_date
8646: AND (ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to >= p_tax_determine_date
8647: OR ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to IS NULL)
8648: THEN
8649: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index);
8650:
8651: END IF;
8645: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_from <= p_tax_determine_date
8646: AND (ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to >= p_tax_determine_date
8647: OR ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to IS NULL)
8648: THEN
8649: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index);
8650:
8651: END IF;
8652: EXIT;
8653: END IF; -- tax found in cache
8651: END IF;
8652: EXIT;
8653: END IF; -- tax found in cache
8654:
8655: l_index := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.NEXT(l_index);
8656: END LOOP;
8657:
8658: -- tax not exists in the cache structure, retrieve tax info from table
8659: IF l_tax_rec.TAX IS NULL THEN
8665: CLOSE get_tax_info_csr;
8666:
8667: -- bug fix 5579156: cache the tax detail info when tax found effective.
8668: IF l_tax_rec.tax_id IS NOT NULL THEN
8669: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id) := l_tax_rec;
8670: END IF;
8671:
8672: END IF;
8673:
8854: l_rownum := l_rownum + 1;
8855:
8856: -- validate and populate tax_regime_id
8857: --
8858: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
8859: l_tax_regime_code_tbl(j),
8860: p_tax_determine_date,
8861: l_tax_regime_rec,
8862: x_return_status,
8866: IF (g_level_statement >= g_current_runtime_level ) THEN
8867: FND_LOG.STRING(g_level_statement,
8868: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8869: 'Incorrect return_status after calling ' ||
8870: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
8871: FND_LOG.STRING(g_level_statement,
8872: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8873: 'RETURN_STATUS = ' || x_return_status);
8874: FND_LOG.STRING(g_level_statement,
8887: -- bug 5077691: populate legal_reporting_status
8888: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
8889: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
8890: l_rownum).legal_reporting_status :=
8891: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
8892: l_tax_rec.tax_id).legal_reporting_status_def_val;
8893: END IF;
8894:
8895: IF l_jurisdictions_found = 'Y'
8904:
8905: IF l_status_result_tbl(j) IS NOT NULL THEN
8906: -- validate and populate tax_status_id
8907: --
8908: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
8909: l_tax_tbl(j),
8910: l_tax_regime_code_tbl(j),
8911: l_status_result_tbl(j),
8912: p_tax_determine_date,
8918: IF (g_level_statement >= g_current_runtime_level ) THEN
8919: FND_LOG.STRING(g_level_statement,
8920: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8921: 'Incorrect return_status after calling ' ||
8922: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
8923: FND_LOG.STRING(g_level_statement,
8924: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8925: 'RETURN_STATUS = ' || x_return_status);
8926: FND_LOG.STRING(g_level_statement,
8947: -- multiple jurisdictions situation
8948:
8949: FOR i IN 1 .. nvl(l_jurisdiction_rec_tbl.count, 0) LOOP
8950:
8951: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
8952: l_tax_regime_code_tbl(j),
8953: l_tax_tbl(j),
8954: l_jurisdiction_rec_tbl(i).tax_jurisdiction_code,
8955: l_status_result_tbl(j),
8973: ELSE
8974:
8975: -- Single Jurisdiction
8976:
8977: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
8978: l_tax_regime_code_tbl(j),
8979: l_tax_tbl(j),
8980: l_jurisdiction_rec.tax_jurisdiction_code,
8981: l_status_result_tbl(j),
8992: IF (g_level_statement >= g_current_runtime_level ) THEN
8993: FND_LOG.STRING(g_level_statement,
8994: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8995: 'Incorrect return_status after calling ' ||
8996: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
8997: FND_LOG.STRING(g_level_statement,
8998: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8999: 'RETURN_STATUS = ' || x_return_status);
9000: FND_LOG.STRING(g_level_statement,
9455: -- Local variables
9456: l_current_line_amt zx_lines.line_amt%TYPE;
9457: l_tax_line_rec zx_lines%ROWTYPE;
9458:
9459: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
9460: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
9461: l_error_buffer VARCHAR2(200);
9462:
9463: l_tax_class zx_rates_b.tax_class%TYPE;
9456: l_current_line_amt zx_lines.line_amt%TYPE;
9457: l_tax_line_rec zx_lines%ROWTYPE;
9458:
9459: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
9460: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
9461: l_error_buffer VARCHAR2(200);
9462:
9463: l_tax_class zx_rates_b.tax_class%TYPE;
9464:
9634: p_row_num).orig_tax_status_id := l_tax_line_rec.orig_tax_status_id;
9635:
9636: -- populate tax_status_id
9637: --
9638: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
9639: p_tax,
9640: p_tax_regime_code,
9641: l_tax_line_rec.tax_status_code,
9642: p_tax_determine_date,
9648: IF (g_level_error >= g_current_runtime_level ) THEN
9649: FND_LOG.STRING(g_level_error,
9650: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9651: 'Incorrect return_status after calling '||
9652: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9653: FND_LOG.STRING(g_level_error,
9654: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9655: 'RETURN_STATUS = ' || x_return_status);
9656: FND_LOG.STRING(g_level_error,
9685: p_row_num).orig_tax_rate := l_tax_line_rec.orig_tax_rate;
9686:
9687: -- populate tax_status_id
9688: --
9689: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
9690: p_tax,
9691: p_tax_regime_code,
9692: l_tax_line_rec.tax_status_code,
9693: p_tax_determine_date,
9699: IF (g_level_error >= g_current_runtime_level ) THEN
9700: FND_LOG.STRING(g_level_error,
9701: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9702: 'Incorrect return_status after calling '||
9703: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9704: FND_LOG.STRING(g_level_error,
9705: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9706: 'RETURN_STATUS = ' || x_return_status);
9707: FND_LOG.STRING(g_level_error,
9717: l_tax_status_rec.tax_status_id;
9718:
9719: -- validate and populate tax_rate_id
9720: --
9721: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
9722: p_tax_regime_code,
9723: p_tax,
9724: x_tax_jurisdiction_code,
9725: l_tax_line_rec.tax_status_code,
9734: IF (g_level_error >= g_current_runtime_level ) THEN
9735: FND_LOG.STRING(g_level_error,
9736: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9737: 'Incorrect return_status after calling '||
9738: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9739: FND_LOG.STRING(g_level_error,
9740: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9741: 'RETURN_STATUS = ' || x_return_status);
9742: FND_LOG.STRING(g_level_error,
9772: p_row_num).orig_tax_rate := l_tax_line_rec.orig_tax_rate;
9773:
9774: -- populate tax_status_id
9775: --
9776: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
9777: p_tax,
9778: p_tax_regime_code,
9779: l_tax_line_rec.tax_status_code,
9780: p_tax_determine_date,
9786: IF (g_level_error >= g_current_runtime_level ) THEN
9787: FND_LOG.STRING(g_level_error,
9788: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9789: 'Incorrect return_status after calling '||
9790: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9791: FND_LOG.STRING(g_level_error,
9792: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9793: 'RETURN_STATUS = ' || x_return_status);
9794: FND_LOG.STRING(g_level_error,
9804: l_tax_status_rec.tax_status_id;
9805:
9806: -- validate and populate tax_rate_id
9807: --
9808: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
9809: p_tax_regime_code,
9810: p_tax,
9811: x_tax_jurisdiction_code,
9812: l_tax_line_rec.tax_status_code,
9821: IF (g_level_error >= g_current_runtime_level ) THEN
9822: FND_LOG.STRING(g_level_error,
9823: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9824: 'Incorrect return_status after calling '||
9825: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9826: FND_LOG.STRING(g_level_error,
9827: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9828: 'RETURN_STATUS = ' || x_return_status);
9829: FND_LOG.STRING(g_level_error,
9881: l_tax_line_rec.taxable_basis_formula;
9882:
9883: -- populate tax_status_id
9884: --
9885: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
9886: p_tax,
9887: p_tax_regime_code,
9888: l_tax_line_rec.tax_status_code,
9889: p_tax_determine_date,
9895: IF (g_level_error >= g_current_runtime_level ) THEN
9896: FND_LOG.STRING(g_level_error,
9897: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9898: 'Incorrect return_status after calling '||
9899: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9900: FND_LOG.STRING(g_level_error,
9901: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9902: 'RETURN_STATUS = ' || x_return_status);
9903: FND_LOG.STRING(g_level_error,
9913: l_tax_status_rec.tax_status_id;
9914:
9915: -- validate and populate tax_rate_id
9916: --
9917: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
9918: p_tax_regime_code,
9919: p_tax,
9920: x_tax_jurisdiction_code,
9921: l_tax_line_rec.tax_status_code,
9930: IF (g_level_error >= g_current_runtime_level ) THEN
9931: FND_LOG.STRING(g_level_error,
9932: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9933: 'Incorrect return_status after calling '||
9934: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9935: FND_LOG.STRING(g_level_error,
9936: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9937: 'RETURN_STATUS = ' || x_return_status);
9938: FND_LOG.STRING(g_level_error,
10049: x_return_status OUT NOCOPY VARCHAR2) IS
10050:
10051: -- Local variables
10052: i NUMBER;
10053: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
10054: l_error_buffer VARCHAR2(200);
10055:
10056: -- Cursor definitions
10057: CURSOR enforce_rate_code_from_ref_doc(
10125: i).other_doc_source := 'REFERENCE';
10126:
10127: -- bugfix 5176149:populate tax_status_id
10128: --
10129: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
10130: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax,
10131: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code,
10132: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code,
10133: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date,
10139: IF (g_level_statement >= g_current_runtime_level ) THEN
10140: FND_LOG.STRING(g_level_statement,
10141: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10142: 'Incorrect return_status after calling ' ||
10143: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
10144: FND_LOG.STRING(g_level_statement,
10145: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10146: 'RETURN_STATUS = ' || x_return_status);
10147: FND_LOG.STRING(g_level_statement,