[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,
1420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1421:
1422: -- populate tax cache : bug 5167406
1423: --
1424: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1425: p_tax_id => tax_line_rec.tax_id,
1426: p_return_status => x_return_status,
1427: p_error_buffer => l_error_buffer);
1428:
1430: IF (g_level_statement >= g_current_runtime_level ) THEN
1431: FND_LOG.STRING(g_level_statement,
1432: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1433: 'Incorrect return_status after calling ' ||
1434: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1435: FND_LOG.STRING(g_level_statement,
1436: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1437: 'RETURN_STATUS = ' || x_return_status);
1438: FND_LOG.STRING(g_level_statement,
1571: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1572:
1573: -- populate tax cache : bug 5167406
1574: --
1575: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1576: p_tax_id => tax_line_rec.tax_id,
1577: p_return_status => x_return_status,
1578: p_error_buffer => l_error_buffer);
1579:
1581: IF (g_level_statement >= g_current_runtime_level ) THEN
1582: FND_LOG.STRING(g_level_statement,
1583: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1584: 'Incorrect return_status after calling ' ||
1585: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1586: FND_LOG.STRING(g_level_statement,
1587: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1588: 'RETURN_STATUS = ' || x_return_status);
1589: FND_LOG.STRING(g_level_statement,
1674: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1675:
1676: -- populate tax cache : bug 5167406
1677: --
1678: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1679: p_tax_id => tax_line_rec.tax_id,
1680: p_return_status => x_return_status,
1681: p_error_buffer => l_error_buffer);
1682:
1684: IF (g_level_statement >= g_current_runtime_level ) THEN
1685: FND_LOG.STRING(g_level_statement,
1686: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1687: 'Incorrect return_status after calling ' ||
1688: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1689: FND_LOG.STRING(g_level_statement,
1690: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1691: 'RETURN_STATUS = ' || x_return_status);
1692: FND_LOG.STRING(g_level_statement,
1777: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1778:
1779: -- populate tax cache : bug 5167406
1780: --
1781: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1782: p_tax_id => tax_line_rec.tax_id,
1783: p_return_status => x_return_status,
1784: p_error_buffer => l_error_buffer);
1785:
1787: IF (g_level_statement >= g_current_runtime_level ) THEN
1788: FND_LOG.STRING(g_level_statement,
1789: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1790: 'Incorrect return_status after calling ' ||
1791: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1792: FND_LOG.STRING(g_level_statement,
1793: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1794: 'RETURN_STATUS = ' || x_return_status);
1795: FND_LOG.STRING(g_level_statement,
1897: --
1898: -- set x_begin_index
1899: --
1900: -- Bug 8220741
1901: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
1902: p_tax_id => tax_line_rec.tax_id,
1903: p_return_status => x_return_status,
1904: p_error_buffer => l_error_buffer);
1905: -- End Bug 8220741
1944: --End of Bug 7383041
1945: ELSE
1946: -- validate and populate tax_regime_id
1947: --
1948: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
1949: tax_line_rec.tax_regime_code,
1950: p_tax_determine_date,
1951: l_tax_regime_rec,
1952: x_return_status,
1956: IF (g_level_statement >= g_current_runtime_level ) THEN
1957: FND_LOG.STRING(g_level_statement,
1958: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1959: 'Incorrect return_status after calling ' ||
1960: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
1961: FND_LOG.STRING(g_level_statement,
1962: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1963: 'RETURN_STATUS = ' || x_return_status);
1964: FND_LOG.STRING(g_level_statement,
1973: l_tax_regime_rec.tax_regime_id;
1974:
1975: -- validate and populate tax_id
1976: --
1977: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
1978: tax_line_rec.tax_regime_code,
1979: tax_line_rec.tax,
1980: p_tax_determine_date,
1981: l_tax_rec,
1986: IF (g_level_statement >= g_current_runtime_level ) THEN
1987: FND_LOG.STRING(g_level_statement,
1988: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1989: 'Incorrect return_status after calling ' ||
1990: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1991: FND_LOG.STRING(g_level_statement,
1992: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1993: 'RETURN_STATUS = ' || x_return_status);
1994: FND_LOG.STRING(g_level_statement,
2004: --
2005: -- validate and populate tax_jurisdiction_id
2006: --
2007: IF tax_line_rec.tax_jurisdiction_code is not NULL THEN
2008: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
2009: tax_line_rec.tax_regime_code,
2010: tax_line_rec.tax,
2011: tax_line_rec.tax_jurisdiction_code,
2012: p_tax_determine_date,
2018: IF (g_level_statement >= g_current_runtime_level ) THEN
2019: FND_LOG.STRING(g_level_statement,
2020: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2021: 'Incorrect return_status after calling ' ||
2022: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
2023: FND_LOG.STRING(g_level_statement,
2024: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2025: 'RETURN_STATUS = ' || x_return_status);
2026: FND_LOG.STRING(g_level_statement,
2036: END IF;
2037:
2038:
2039: -- validate and populate tax_status_id
2040: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
2041: tax_line_rec.tax,
2042: tax_line_rec.tax_regime_code,
2043: tax_line_rec.tax_status_code,
2044: p_tax_determine_date,
2050: IF (g_level_statement >= g_current_runtime_level ) THEN
2051: FND_LOG.STRING(g_level_statement,
2052: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2053: 'Incorrect return_status after calling ' ||
2054: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2055: FND_LOG.STRING(g_level_statement,
2056: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2057: 'RETURN_STATUS = ' || x_return_status);
2058: FND_LOG.STRING(g_level_statement,
2066: l_rownum).tax_status_id := l_tax_status_rec.tax_status_id;
2067:
2068: -- validate and populate tax_rate_id
2069: --
2070: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
2071: tax_line_rec.tax_regime_code,
2072: tax_line_rec.tax,
2073: tax_line_rec.tax_jurisdiction_code,
2074: tax_line_rec.tax_status_code,
2083: IF (g_level_statement >= g_current_runtime_level ) THEN
2084: FND_LOG.STRING(g_level_statement,
2085: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2086: 'Incorrect return_status after calling ' ||
2087: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2088: FND_LOG.STRING(g_level_statement,
2089: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2090: 'RETURN_STATUS = ' || x_return_status);
2091: FND_LOG.STRING(g_level_statement,
2355: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2356: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2357: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2358: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2359: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2360: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2361:
2362: l_error_buffer VARCHAR2(200);
2363: l_tax_tbl_subscript NUMBER;
2356: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2357: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2358: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2359: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2360: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2361:
2362: l_error_buffer VARCHAR2(200);
2363: l_tax_tbl_subscript NUMBER;
2364:
2602: END IF;
2603:
2604: -- populate g_tax_rec_tbl, if it does not exist
2605: --
2606: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(l_tax_rec.tax_id) THEN
2607:
2608: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id) := l_tax_rec;
2609:
2610: /* Following are commented out since the select column in the cursor
2604: -- populate g_tax_rec_tbl, if it does not exist
2605: --
2606: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(l_tax_rec.tax_id) THEN
2607:
2608: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id) := l_tax_rec;
2609:
2610: /* Following are commented out since the select column in the cursor
2611: get_all_taxes_for_regime_cur has the same set of column as the definition
2612: of ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl and in the same order. Changed to
2608: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id) := l_tax_rec;
2609:
2610: /* Following are commented out since the select column in the cursor
2611: get_all_taxes_for_regime_cur has the same set of column as the definition
2612: of ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl and in the same order. Changed to
2613: assignment as above. If later new columns added to get_all_taxes_for_regime_cur,
2614: but not need to cache, we need to uncomment this part and add the assignment
2615: individually.
2616:
2613: assignment as above. If later new columns added to get_all_taxes_for_regime_cur,
2614: but not need to cache, we need to uncomment this part and add the assignment
2615: individually.
2616:
2617: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2618: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
2619: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2620: l_tax_rec.tax_id).tax := l_tax_rec.tax;
2621: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2615: individually.
2616:
2617: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2618: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
2619: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2620: l_tax_rec.tax_id).tax := l_tax_rec.tax;
2621: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2622: l_tax_rec.tax_id).def_place_of_supply_type_code :=
2623: l_tax_rec.def_place_of_supply_type_code;
2617: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2618: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
2619: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2620: l_tax_rec.tax_id).tax := l_tax_rec.tax;
2621: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2622: l_tax_rec.tax_id).def_place_of_supply_type_code :=
2623: l_tax_rec.def_place_of_supply_type_code;
2624: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2625: l_tax_rec.tax_id).place_of_supply_rule_flag :=
2620: l_tax_rec.tax_id).tax := l_tax_rec.tax;
2621: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2622: l_tax_rec.tax_id).def_place_of_supply_type_code :=
2623: l_tax_rec.def_place_of_supply_type_code;
2624: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2625: l_tax_rec.tax_id).place_of_supply_rule_flag :=
2626: l_tax_rec.place_of_supply_rule_flag;
2627: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2628: l_tax_rec.tax_id).applicability_rule_flag :=
2623: l_tax_rec.def_place_of_supply_type_code;
2624: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2625: l_tax_rec.tax_id).place_of_supply_rule_flag :=
2626: l_tax_rec.place_of_supply_rule_flag;
2627: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2628: l_tax_rec.tax_id).applicability_rule_flag :=
2629: l_tax_rec.applicability_rule_flag;
2630: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2631: l_tax_rec.tax_id).direct_rate_rule_flag :=
2626: l_tax_rec.place_of_supply_rule_flag;
2627: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2628: l_tax_rec.tax_id).applicability_rule_flag :=
2629: l_tax_rec.applicability_rule_flag;
2630: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2631: l_tax_rec.tax_id).direct_rate_rule_flag :=
2632: l_tax_rec.direct_rate_rule_flag;
2633: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2634: l_tax_rec.tax_id).def_registr_party_type_code :=
2629: l_tax_rec.applicability_rule_flag;
2630: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2631: l_tax_rec.tax_id).direct_rate_rule_flag :=
2632: l_tax_rec.direct_rate_rule_flag;
2633: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2634: l_tax_rec.tax_id).def_registr_party_type_code :=
2635: l_tax_rec.def_registr_party_type_code;
2636: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2637: l_tax_rec.tax_id).registration_type_rule_flag :=
2632: l_tax_rec.direct_rate_rule_flag;
2633: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2634: l_tax_rec.tax_id).def_registr_party_type_code :=
2635: l_tax_rec.def_registr_party_type_code;
2636: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2637: l_tax_rec.tax_id).registration_type_rule_flag :=
2638: l_tax_rec.registration_type_rule_flag;
2639: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2640: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
2635: l_tax_rec.def_registr_party_type_code;
2636: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2637: l_tax_rec.tax_id).registration_type_rule_flag :=
2638: l_tax_rec.registration_type_rule_flag;
2639: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2640: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
2641: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2642: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
2643: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2637: l_tax_rec.tax_id).registration_type_rule_flag :=
2638: l_tax_rec.registration_type_rule_flag;
2639: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2640: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
2641: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2642: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
2643: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2644: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
2645: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2639: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2640: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
2641: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2642: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
2643: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2644: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
2645: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2646: l_tax_rec.tax_id).minimum_accountable_unit :=
2647: l_tax_rec.minimum_accountable_unit;
2641: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2642: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
2643: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2644: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
2645: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2646: l_tax_rec.tax_id).minimum_accountable_unit :=
2647: l_tax_rec.minimum_accountable_unit;
2648: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2649: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
2644: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
2645: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2646: l_tax_rec.tax_id).minimum_accountable_unit :=
2647: l_tax_rec.minimum_accountable_unit;
2648: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2649: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
2650: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2651: l_tax_rec.tax_id).tax_status_rule_flag :=
2652: l_tax_rec.tax_status_rule_flag;
2646: l_tax_rec.tax_id).minimum_accountable_unit :=
2647: l_tax_rec.minimum_accountable_unit;
2648: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2649: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
2650: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2651: l_tax_rec.tax_id).tax_status_rule_flag :=
2652: l_tax_rec.tax_status_rule_flag;
2653: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2654: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
2649: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
2650: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2651: l_tax_rec.tax_id).tax_status_rule_flag :=
2652: l_tax_rec.tax_status_rule_flag;
2653: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2654: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
2655: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2656: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
2657: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2651: l_tax_rec.tax_id).tax_status_rule_flag :=
2652: l_tax_rec.tax_status_rule_flag;
2653: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2654: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
2655: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2656: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
2657: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2658: l_tax_rec.tax_id).taxable_basis_rule_flag :=
2659: l_tax_rec.taxable_basis_rule_flag;
2653: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2654: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
2655: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2656: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
2657: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2658: l_tax_rec.tax_id).taxable_basis_rule_flag :=
2659: l_tax_rec.taxable_basis_rule_flag;
2660: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2661: l_tax_rec.tax_id).def_tax_calc_formula :=
2656: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
2657: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2658: l_tax_rec.tax_id).taxable_basis_rule_flag :=
2659: l_tax_rec.taxable_basis_rule_flag;
2660: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2661: l_tax_rec.tax_id).def_tax_calc_formula :=
2662: l_tax_rec.def_tax_calc_formula;
2663: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2664: l_tax_rec.tax_id).def_taxable_basis_formula :=
2659: l_tax_rec.taxable_basis_rule_flag;
2660: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2661: l_tax_rec.tax_id).def_tax_calc_formula :=
2662: l_tax_rec.def_tax_calc_formula;
2663: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2664: l_tax_rec.tax_id).def_taxable_basis_formula :=
2665: l_tax_rec.def_taxable_basis_formula;
2666: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2667: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
2662: l_tax_rec.def_tax_calc_formula;
2663: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2664: l_tax_rec.tax_id).def_taxable_basis_formula :=
2665: l_tax_rec.def_taxable_basis_formula;
2666: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2667: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
2668: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2669: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
2670: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2664: l_tax_rec.tax_id).def_taxable_basis_formula :=
2665: l_tax_rec.def_taxable_basis_formula;
2666: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2667: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
2668: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2669: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
2670: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2671: l_tax_rec.tax_id).def_inclusive_tax_flag :=
2672: l_tax_rec.def_inclusive_tax_flag;
2666: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2667: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
2668: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2669: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
2670: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2671: l_tax_rec.tax_id).def_inclusive_tax_flag :=
2672: l_tax_rec.def_inclusive_tax_flag;
2673: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2674: l_tax_rec.tax_id).applied_amt_handling_flag :=
2669: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
2670: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2671: l_tax_rec.tax_id).def_inclusive_tax_flag :=
2672: l_tax_rec.def_inclusive_tax_flag;
2673: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2674: l_tax_rec.tax_id).applied_amt_handling_flag :=
2675: l_tax_rec.applied_amt_handling_flag;
2676: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2677: l_tax_rec.tax_id).exchange_rate_type :=
2672: l_tax_rec.def_inclusive_tax_flag;
2673: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2674: l_tax_rec.tax_id).applied_amt_handling_flag :=
2675: l_tax_rec.applied_amt_handling_flag;
2676: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2677: l_tax_rec.tax_id).exchange_rate_type :=
2678: l_tax_rec.exchange_rate_type;
2679: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2680: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
2675: l_tax_rec.applied_amt_handling_flag;
2676: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2677: l_tax_rec.tax_id).exchange_rate_type :=
2678: l_tax_rec.exchange_rate_type;
2679: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2680: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
2681: l_tax_rec.has_other_jurisdictions_flag;
2682: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2683: l_tax_rec.tax_id).tax_exmpt_source_tax :=
2678: l_tax_rec.exchange_rate_type;
2679: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2680: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
2681: l_tax_rec.has_other_jurisdictions_flag;
2682: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
2683: l_tax_rec.tax_id).tax_exmpt_source_tax :=
2684: l_tax_rec.tax_exmpt_source_tax;
2685: */
2686:
2701: p_trx_line_index) = 'INTERCOMPANY_TRX')
2702: THEN
2703: -- Check if this tax line exists in the new created applicable tax lines
2704: --
2705: l_tax_tbl_subscript := ZX_TDS_UTILITIES_PKG.get_tax_index(
2706: l_tax_rec.tax_regime_code,
2707: l_tax_rec.tax,
2708: l_trx_line_id,
2709: l_trx_level_type,
2715: IF (g_level_statement >= g_current_runtime_level ) THEN
2716: FND_LOG.STRING(g_level_statement,
2717: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2718: 'Incorrect return_status after calling ' ||
2719: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
2720: FND_LOG.STRING(g_level_statement,
2721: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2722: 'RETURN_STATUS = ' || x_return_status);
2723: FND_LOG.STRING(g_level_statement,
3266:
3267:
3268: -- populate tax_status_id
3269: --
3270: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
3271: l_tax_rec.tax,
3272: l_tax_rec.tax_regime_code,
3273: l_direct_rate_result_rec.status_result,
3274: p_tax_determine_date,
3280: IF (g_level_error >= g_current_runtime_level ) THEN
3281: FND_LOG.STRING(g_level_error,
3282: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3283: 'Incorrect return_status after calling '||
3284: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
3285: FND_LOG.STRING(g_level_error,
3286: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3287: 'RETURN_STATUS = ' || x_return_status);
3288: FND_LOG.STRING(g_level_error,
3652: l_new_row_num NUMBER;
3653: l_begin_index BINARY_INTEGER;
3654: l_error_buffer VARCHAR2(200);
3655: l_line_amt_current NUMBER;
3656: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;
3657: l_applied_amt_handling_flag ZX_TAXES_B.APPLIED_AMT_HANDLING_FLAG%TYPE;
3658:
3659: l_orig_amt NUMBER;
3660: l_appl_tax_amt NUMBER;
3680: l_begin_index := l_new_row_num + 1;
3681:
3682: FOR tax_line_rec in get_tax_lines LOOP
3683:
3684: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,
3685: -- if it does not exists there.
3686: --
3687: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
3688: p_tax_id => tax_line_rec.tax_id,
3683:
3684: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,
3685: -- if it does not exists there.
3686: --
3687: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
3688: p_tax_id => tax_line_rec.tax_id,
3689: p_return_status => x_return_status,
3690: p_error_buffer => l_error_buffer);
3691:
3693: IF (g_level_statement >= g_current_runtime_level ) THEN
3694: FND_LOG.STRING(g_level_statement,
3695: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3696: 'Incorrect return_status after calling ' ||
3697: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
3698: FND_LOG.STRING(g_level_statement,
3699: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3700: 'RETURN_STATUS = ' || x_return_status);
3701: FND_LOG.STRING(g_level_statement,
3774: -- bug 5077691: populate legal_reporting_status
3775: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
3776: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3777: l_new_row_num).legal_reporting_status :=
3778: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
3779: tax_line_rec.tax_id).legal_reporting_status_def_val;
3780: END IF;
3781:
3782: -- For prepayment trx, tax lines are fetched from the original document and status codes
3782: -- For prepayment trx, tax lines are fetched from the original document and status codes
3783: -- are copied to the new tax lines. However, since tax determiniation date most likely
3784: -- are different for the current document, the status id will need to be repopulated.
3785:
3786: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
3787: tax_line_rec.tax,
3788: tax_line_rec.tax_regime_code,
3789: tax_line_rec.tax_status_code,
3790: p_tax_determine_date,
3796: IF (g_level_error >= g_current_runtime_level ) THEN
3797: FND_LOG.STRING(g_level_error,
3798: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3799: 'Incorrect return_status after calling ' ||
3800: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
3801: FND_LOG.STRING(g_level_error,
3802: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3803: 'RETURN_STATUS = ' || x_return_status);
3804: FND_LOG.STRING(g_level_error,
3830: -- 2. If applied_amt_handling_flag ='R', populate tax rate Code from
3831: -- applied document. Tax rate is determined in the current document.
3832: -- Tax is recalculated based one the tax rate in the current document.
3833:
3834: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
3835: tax_line_rec.tax_id).applied_amt_handling_flag = 'P' THEN
3836:
3837: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3838: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
3853: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3854: l_new_row_num).tax_currency_conversion_rate :=
3855: tax_line_rec.tax_currency_conversion_rate;
3856:
3857: ELSIF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
3858: tax_line_rec.tax_id).applied_amt_handling_flag = 'R' THEN
3859:
3860: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3861: l_new_row_num).tax_rate_code := tax_line_rec.tax_rate_code;
3970: l_new_row_num).other_doc_source := 'APPLIED_FROM';
3971: --
3972: -- Bug#7302008 (Fusion Bug#7301957)- populate unrounded taxable amt and unrounded tax amt
3973: --
3974: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
3975: tax_line_rec.tax_id).applied_amt_handling_flag = 'P' THEN
3976:
3977: -- set unrounded taxable amt and unrounded tax amt
3978: --
4420: l_begin_index := l_new_row_num + 1;
4421:
4422: FOR tax_line_rec in get_tax_lines LOOP
4423:
4424: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,
4425: -- if it does not exists there.
4426: --
4427: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
4428: p_tax_id => tax_line_rec.tax_id,
4423:
4424: -- populate tax cache ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl with this tax_id,
4425: -- if it does not exists there.
4426: --
4427: ZX_TDS_UTILITIES_PKG.populate_tax_cache (
4428: p_tax_id => tax_line_rec.tax_id,
4429: p_return_status => x_return_status,
4430: p_error_buffer => l_error_buffer);
4431:
4433: IF (g_level_statement >= g_current_runtime_level ) THEN
4434: FND_LOG.STRING(g_level_statement,
4435: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4436: 'Incorrect return_status after calling ' ||
4437: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
4438: FND_LOG.STRING(g_level_statement,
4439: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4440: 'RETURN_STATUS = ' || x_return_status);
4441: FND_LOG.STRING(g_level_statement,
4581: -- bug 5077691: populate legal_reporting_status
4582: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
4583: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4584: l_new_row_num).legal_reporting_status :=
4585: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
4586: tax_line_rec.tax_id).legal_reporting_status_def_val;
4587: END IF;
4588:
4589: -- If the value of p_event_class_rec.tax_recovery_flag is 'N',
4863: := NVL(tax_line_rec.unrounded_tax_amt,tax_line_rec.tax_amt);
4864: END IF;
4865: END IF;
4866: ELSE -- both current tax line and original tax line are inclusive and exclusive
4867: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(tax_line_rec.tax_id).compounding_precedence IS NULL
4868: and tax_line_rec.tax_amt_included_flag = 'Y'
4869: and nvl(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(tax_line_rec.tax_id).taxable_basis_rule_flag,'N') = 'N'
4870: and tax_line_rec.TRX_LINE_QUANTITY <> tax_line_rec.taxable_amt THEN
4871: tax_line_rec.unrounded_taxable_amt := tax_line_rec.line_amt * 100 / (100 + tax_line_rec.tax_rate);
4865: END IF;
4866: ELSE -- both current tax line and original tax line are inclusive and exclusive
4867: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(tax_line_rec.tax_id).compounding_precedence IS NULL
4868: and tax_line_rec.tax_amt_included_flag = 'Y'
4869: and nvl(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(tax_line_rec.tax_id).taxable_basis_rule_flag,'N') = 'N'
4870: and tax_line_rec.TRX_LINE_QUANTITY <> tax_line_rec.taxable_amt THEN
4871: tax_line_rec.unrounded_taxable_amt := tax_line_rec.line_amt * 100 / (100 + tax_line_rec.tax_rate);
4872: tax_line_rec.unrounded_tax_amt := tax_line_rec.line_amt * tax_line_rec.tax_rate / (100 + tax_line_rec.tax_rate);
4873: END IF;
5756: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
5757: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
5758:
5759: -- Bug#5395227
5760: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
5761: l_has_other_jurisdictions_flag VARCHAR2(1);
5762:
5763: BEGIN
5764: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5984: -- BEGIN
5985: -- Bug#5395227
5986: l_has_other_jurisdictions_flag := NULL;
5987:
5988: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
5989: p_tax_regime_code,
5990: p_tax,
5991: p_tax_determine_date,
5992: l_tax_rec,
6305: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule IS NOT NULL THEN
6306: x_rounding_rule_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule;
6307: ELSE
6308: x_rounding_rule_code :=
6309: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
6310: END IF;
6311:
6312: ELSE -- g_rounding_level = 'LINE'
6313:
6315: -- is 'N', that means, user can not override the
6316: -- rounding rule at other levels, rounding rule
6317: -- should come from tax level directly
6318: --
6319: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).allow_rounding_override_flag =
6320: 'N' THEN
6321: x_rounding_rule_code :=
6322: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
6323: ELSE
6318: --
6319: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).allow_rounding_override_flag =
6320: 'N' THEN
6321: x_rounding_rule_code :=
6322: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
6323: ELSE
6324: --
6325: -- the rounding rule defined at tax level
6326: -- was overridden at other levels
6349: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule IS NOT NULL THEN
6350: x_rounding_rule_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule;
6351: ELSE
6352: x_rounding_rule_code :=
6353: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
6354: END IF;
6355: END IF;
6356: END IF;
6357: END IF;
6369: WHEN OTHERS THEN
6370: x_registration_number := NULL;
6371: x_self_assessment_flg := 'N';
6372: x_tax_inclusion_flag := NULL;
6373: -- ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).def_inclusive_tax_flag;
6374:
6375: -- x_rounding_rule_code
6376: --
6377: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule IS NOT NULL THEN
6377: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule IS NOT NULL THEN
6378: x_rounding_rule_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_rounding_rule;
6379: ELSE
6380: x_rounding_rule_code :=
6381: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
6382: END IF;
6383:
6384: IF (g_level_statement >= g_current_runtime_level ) THEN
6385: FND_LOG.STRING(g_level_statement,
6498: p_parent_ptp_id => l_hq_estb_ptp_id,
6499: p_site_ptp_id => l_party_ptp_id,
6500: p_account_type_code => NULL,
6501: p_tax_determine_date => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date,
6502: p_tax => ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax,
6503: p_tax_regime_code => ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_regime_code,
6504: p_jurisdiction_code => l_jurisdiction_code,
6505: p_account_id => NULL,
6506: p_account_site_id => NULL,
6499: p_site_ptp_id => l_party_ptp_id,
6500: p_account_type_code => NULL,
6501: p_tax_determine_date => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date,
6502: p_tax => ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax,
6503: p_tax_regime_code => ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_regime_code,
6504: p_jurisdiction_code => l_jurisdiction_code,
6505: p_account_id => NULL,
6506: p_account_site_id => NULL,
6507: p_site_use_id => NULL,
6938: l_begin_index_from_acct BINARY_INTEGER;
6939: l_end_index_from_acct BINARY_INTEGER;
6940:
6941: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
6942: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6943: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6944:
6945: l_jurisdiction_id NUMBER;
6946: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6939: l_end_index_from_acct BINARY_INTEGER;
6940:
6941: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
6942: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6943: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6944:
6945: l_jurisdiction_id NUMBER;
6946: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6947:
7089:
7090: -- Check if this tax line exists in the applicable tax lines
7091: --
7092: IF l_begin_index IS NOT NULL THEN
7093: l_tax_tbl_subscript := ZX_TDS_UTILITIES_PKG.get_tax_index(
7094: l_tax_rec.tax_regime_code,
7095: l_tax_rec.tax,
7096: l_trx_line_id,
7097: l_trx_level_type,
7103: IF (g_level_statement >= g_current_runtime_level ) THEN
7104: FND_LOG.STRING(g_level_statement,
7105: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7106: 'Incorrect return_status after calling ' ||
7107: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
7108: FND_LOG.STRING(g_level_statement,
7109: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7110: 'RETURN_STATUS = ' || x_return_status);
7111: FND_LOG.STRING(g_level_statement,
7130: -- Create a new tax line in p_detail_tax_lines_tbl
7131: --
7132: -- populate g_tax_rec_tbl, if it does not exist
7133: --
7134: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(l_tax_rec.tax_id) THEN
7135:
7136:
7137: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7138: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
7133: --
7134: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(l_tax_rec.tax_id) THEN
7135:
7136:
7137: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7138: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
7139: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7140: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
7141: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id).tax :=l_tax_rec.tax;
7135:
7136:
7137: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7138: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
7139: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7140: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
7141: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id).tax :=l_tax_rec.tax;
7142:
7143: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7137: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7138: l_tax_rec.tax_id).tax_regime_code := l_tax_rec.tax_regime_code;
7139: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7140: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
7141: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id).tax :=l_tax_rec.tax;
7142:
7143: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7144: l_tax_rec.tax_id).def_place_of_supply_type_code :=
7145: l_tax_rec.def_place_of_supply_type_code;
7139: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7140: l_tax_rec.tax_id).tax_id := l_tax_rec.tax_id;
7141: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id).tax :=l_tax_rec.tax;
7142:
7143: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7144: l_tax_rec.tax_id).def_place_of_supply_type_code :=
7145: l_tax_rec.def_place_of_supply_type_code;
7146: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7147: l_tax_rec.tax_id).place_of_supply_rule_flag :=
7142:
7143: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7144: l_tax_rec.tax_id).def_place_of_supply_type_code :=
7145: l_tax_rec.def_place_of_supply_type_code;
7146: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7147: l_tax_rec.tax_id).place_of_supply_rule_flag :=
7148: l_tax_rec.place_of_supply_rule_flag;
7149: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7150: l_tax_rec.tax_id).applicability_rule_flag :=
7145: l_tax_rec.def_place_of_supply_type_code;
7146: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7147: l_tax_rec.tax_id).place_of_supply_rule_flag :=
7148: l_tax_rec.place_of_supply_rule_flag;
7149: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7150: l_tax_rec.tax_id).applicability_rule_flag :=
7151: l_tax_rec.applicability_rule_flag;
7152: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7153: l_tax_rec.tax_id).direct_rate_rule_flag :=
7148: l_tax_rec.place_of_supply_rule_flag;
7149: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7150: l_tax_rec.tax_id).applicability_rule_flag :=
7151: l_tax_rec.applicability_rule_flag;
7152: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7153: l_tax_rec.tax_id).direct_rate_rule_flag :=
7154: l_tax_rec.direct_rate_rule_flag;
7155: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7156: l_tax_rec.tax_id).def_registr_party_type_code :=
7151: l_tax_rec.applicability_rule_flag;
7152: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7153: l_tax_rec.tax_id).direct_rate_rule_flag :=
7154: l_tax_rec.direct_rate_rule_flag;
7155: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7156: l_tax_rec.tax_id).def_registr_party_type_code :=
7157: l_tax_rec.def_registr_party_type_code;
7158: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7159: l_tax_rec.tax_id).registration_type_rule_flag :=
7154: l_tax_rec.direct_rate_rule_flag;
7155: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7156: l_tax_rec.tax_id).def_registr_party_type_code :=
7157: l_tax_rec.def_registr_party_type_code;
7158: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7159: l_tax_rec.tax_id).registration_type_rule_flag :=
7160: l_tax_rec.registration_type_rule_flag;
7161:
7162: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7158: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7159: l_tax_rec.tax_id).registration_type_rule_flag :=
7160: l_tax_rec.registration_type_rule_flag;
7161:
7162: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7163: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
7164: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7165: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
7166: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7160: l_tax_rec.registration_type_rule_flag;
7161:
7162: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7163: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
7164: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7165: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
7166: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7167: l_tax_rec.tax_id).minimum_accountable_unit :=
7168: l_tax_rec.minimum_accountable_unit;
7162: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7163: l_tax_rec.tax_id).tax_currency_code := l_tax_rec.tax_currency_code;
7164: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7165: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
7166: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7167: l_tax_rec.tax_id).minimum_accountable_unit :=
7168: l_tax_rec.minimum_accountable_unit;
7169: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7170: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
7165: l_tax_rec.tax_id).tax_precision := l_tax_rec.tax_precision;
7166: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7167: l_tax_rec.tax_id).minimum_accountable_unit :=
7168: l_tax_rec.minimum_accountable_unit;
7169: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7170: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
7171: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7172: l_tax_rec.tax_id).tax_status_rule_flag :=
7173: l_tax_rec.tax_status_rule_flag;
7167: l_tax_rec.tax_id).minimum_accountable_unit :=
7168: l_tax_rec.minimum_accountable_unit;
7169: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7170: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
7171: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7172: l_tax_rec.tax_id).tax_status_rule_flag :=
7173: l_tax_rec.tax_status_rule_flag;
7174: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7175: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
7170: l_tax_rec.tax_id).rounding_rule_code :=l_tax_rec.rounding_rule_code;
7171: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7172: l_tax_rec.tax_id).tax_status_rule_flag :=
7173: l_tax_rec.tax_status_rule_flag;
7174: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7175: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
7176: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7177: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
7178: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7172: l_tax_rec.tax_id).tax_status_rule_flag :=
7173: l_tax_rec.tax_status_rule_flag;
7174: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7175: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
7176: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7177: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
7178: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7179: l_tax_rec.tax_id).taxable_basis_rule_flag :=
7180: l_tax_rec.taxable_basis_rule_flag;
7174: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7175: l_tax_rec.tax_id).tax_rate_rule_flag := l_tax_rec.tax_rate_rule_flag;
7176: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7177: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
7178: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7179: l_tax_rec.tax_id).taxable_basis_rule_flag :=
7180: l_tax_rec.taxable_basis_rule_flag;
7181: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7182: l_tax_rec.tax_id).def_tax_calc_formula :=
7177: l_tax_rec.tax_id).tax_calc_rule_flag := l_tax_rec.tax_calc_rule_flag;
7178: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7179: l_tax_rec.tax_id).taxable_basis_rule_flag :=
7180: l_tax_rec.taxable_basis_rule_flag;
7181: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7182: l_tax_rec.tax_id).def_tax_calc_formula :=
7183: l_tax_rec.def_tax_calc_formula;
7184: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7185: l_tax_rec.tax_id).def_taxable_basis_formula :=
7180: l_tax_rec.taxable_basis_rule_flag;
7181: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7182: l_tax_rec.tax_id).def_tax_calc_formula :=
7183: l_tax_rec.def_tax_calc_formula;
7184: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7185: l_tax_rec.tax_id).def_taxable_basis_formula :=
7186: l_tax_rec.def_taxable_basis_formula;
7187: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7188: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
7183: l_tax_rec.def_tax_calc_formula;
7184: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7185: l_tax_rec.tax_id).def_taxable_basis_formula :=
7186: l_tax_rec.def_taxable_basis_formula;
7187: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7188: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
7189: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7190: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
7191: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7185: l_tax_rec.tax_id).def_taxable_basis_formula :=
7186: l_tax_rec.def_taxable_basis_formula;
7187: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7188: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
7189: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7190: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
7191: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7192: l_tax_rec.tax_id).def_inclusive_tax_flag :=
7193: l_tax_rec.def_inclusive_tax_flag;
7187: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7188: l_tax_rec.tax_id).tax_type_code := l_tax_rec.tax_type_code;
7189: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7190: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
7191: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7192: l_tax_rec.tax_id).def_inclusive_tax_flag :=
7193: l_tax_rec.def_inclusive_tax_flag;
7194: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7195: l_tax_rec.tax_id).applied_amt_handling_flag :=
7190: l_tax_rec.tax_id).reporting_only_flag := l_tax_rec.reporting_only_flag;
7191: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7192: l_tax_rec.tax_id).def_inclusive_tax_flag :=
7193: l_tax_rec.def_inclusive_tax_flag;
7194: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7195: l_tax_rec.tax_id).applied_amt_handling_flag :=
7196: l_tax_rec.applied_amt_handling_flag;
7197: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7198: l_tax_rec.tax_id).exchange_rate_type :=
7193: l_tax_rec.def_inclusive_tax_flag;
7194: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7195: l_tax_rec.tax_id).applied_amt_handling_flag :=
7196: l_tax_rec.applied_amt_handling_flag;
7197: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7198: l_tax_rec.tax_id).exchange_rate_type :=
7199: l_tax_rec.exchange_rate_type;
7200: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7201: l_tax_rec.tax_id).effective_from := l_tax_rec.effective_from;
7196: l_tax_rec.applied_amt_handling_flag;
7197: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7198: l_tax_rec.tax_id).exchange_rate_type :=
7199: l_tax_rec.exchange_rate_type;
7200: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7201: l_tax_rec.tax_id).effective_from := l_tax_rec.effective_from;
7202: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7203: l_tax_rec.tax_id).effective_to := l_tax_rec.effective_to;
7204: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7198: l_tax_rec.tax_id).exchange_rate_type :=
7199: l_tax_rec.exchange_rate_type;
7200: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7201: l_tax_rec.tax_id).effective_from := l_tax_rec.effective_from;
7202: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7203: l_tax_rec.tax_id).effective_to := l_tax_rec.effective_to;
7204: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7205: l_tax_rec.tax_id).compounding_precedence :=
7206: l_tax_rec.compounding_precedence;
7200: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7201: l_tax_rec.tax_id).effective_from := l_tax_rec.effective_from;
7202: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7203: l_tax_rec.tax_id).effective_to := l_tax_rec.effective_to;
7204: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7205: l_tax_rec.tax_id).compounding_precedence :=
7206: l_tax_rec.compounding_precedence;
7207: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7208: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
7203: l_tax_rec.tax_id).effective_to := l_tax_rec.effective_to;
7204: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7205: l_tax_rec.tax_id).compounding_precedence :=
7206: l_tax_rec.compounding_precedence;
7207: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7208: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
7209: l_tax_rec.has_other_jurisdictions_flag;
7210: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7211: l_tax_rec.tax_id).live_for_processing_flag :=
7206: l_tax_rec.compounding_precedence;
7207: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7208: l_tax_rec.tax_id).has_other_jurisdictions_flag :=
7209: l_tax_rec.has_other_jurisdictions_flag;
7210: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7211: l_tax_rec.tax_id).live_for_processing_flag :=
7212: l_tax_rec.live_for_processing_flag;
7213: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7214: l_tax_rec.tax_id).regn_num_same_as_le_flag:=
7209: l_tax_rec.has_other_jurisdictions_flag;
7210: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7211: l_tax_rec.tax_id).live_for_processing_flag :=
7212: l_tax_rec.live_for_processing_flag;
7213: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7214: l_tax_rec.tax_id).regn_num_same_as_le_flag:=
7215: l_tax_rec.regn_num_same_as_le_flag;
7216: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7217: l_tax_rec.tax_id).applicable_by_default_flag :=
7212: l_tax_rec.live_for_processing_flag;
7213: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7214: l_tax_rec.tax_id).regn_num_same_as_le_flag:=
7215: l_tax_rec.regn_num_same_as_le_flag;
7216: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7217: l_tax_rec.tax_id).applicable_by_default_flag :=
7218: l_tax_rec.applicable_by_default_flag;
7219: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7220: l_tax_rec.tax_id).record_type_code :=
7215: l_tax_rec.regn_num_same_as_le_flag;
7216: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7217: l_tax_rec.tax_id).applicable_by_default_flag :=
7218: l_tax_rec.applicable_by_default_flag;
7219: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7220: l_tax_rec.tax_id).record_type_code :=
7221: l_tax_rec.record_type_code;
7222: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7223: l_tax_rec.tax_id).tax_exmpt_cr_method_code :=
7218: l_tax_rec.applicable_by_default_flag;
7219: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7220: l_tax_rec.tax_id).record_type_code :=
7221: l_tax_rec.record_type_code;
7222: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7223: l_tax_rec.tax_id).tax_exmpt_cr_method_code :=
7224: l_tax_rec.tax_exmpt_cr_method_code;
7225: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7226: l_tax_rec.tax_id).tax_exmpt_source_tax :=
7221: l_tax_rec.record_type_code;
7222: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7223: l_tax_rec.tax_id).tax_exmpt_cr_method_code :=
7224: l_tax_rec.tax_exmpt_cr_method_code;
7225: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7226: l_tax_rec.tax_id).tax_exmpt_source_tax :=
7227: l_tax_rec.tax_exmpt_source_tax;
7228: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7229: l_tax_rec.tax_id).legal_reporting_status_def_val :=
7224: l_tax_rec.tax_exmpt_cr_method_code;
7225: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7226: l_tax_rec.tax_id).tax_exmpt_source_tax :=
7227: l_tax_rec.tax_exmpt_source_tax;
7228: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7229: l_tax_rec.tax_id).legal_reporting_status_def_val :=
7230: l_tax_rec.legal_reporting_status_def_val;
7231: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7232: l_tax_rec.tax_id).def_rec_settlement_option_code :=
7227: l_tax_rec.tax_exmpt_source_tax;
7228: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7229: l_tax_rec.tax_id).legal_reporting_status_def_val :=
7230: l_tax_rec.legal_reporting_status_def_val;
7231: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7232: l_tax_rec.tax_id).def_rec_settlement_option_code :=
7233: l_tax_rec.def_rec_settlement_option_code;
7234: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7235: l_tax_rec.tax_id).zone_geography_type :=
7230: l_tax_rec.legal_reporting_status_def_val;
7231: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7232: l_tax_rec.tax_id).def_rec_settlement_option_code :=
7233: l_tax_rec.def_rec_settlement_option_code;
7234: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7235: l_tax_rec.tax_id).zone_geography_type :=
7236: l_tax_rec.zone_geography_type;
7237: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7238: l_tax_rec.tax_id).override_geography_type :=
7233: l_tax_rec.def_rec_settlement_option_code;
7234: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7235: l_tax_rec.tax_id).zone_geography_type :=
7236: l_tax_rec.zone_geography_type;
7237: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7238: l_tax_rec.tax_id).override_geography_type :=
7239: l_tax_rec.override_geography_type;
7240: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7241: l_tax_rec.tax_id).tax_account_source_tax :=
7236: l_tax_rec.zone_geography_type;
7237: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7238: l_tax_rec.tax_id).override_geography_type :=
7239: l_tax_rec.override_geography_type;
7240: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7241: l_tax_rec.tax_id).tax_account_source_tax :=
7242: l_tax_rec.tax_account_source_tax;
7243:
7244:
7278: END IF;
7279:
7280: -- validate and populate tax_regime_id
7281: --
7282: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
7283: l_tax_rec.tax_regime_code,
7284: p_tax_determine_date,
7285: l_tax_regime_rec,
7286: x_return_status,
7290: IF (g_level_statement >= g_current_runtime_level ) THEN
7291: FND_LOG.STRING(g_level_statement,
7292: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7293: 'Incorrect return_status after calling ' ||
7294: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
7295: FND_LOG.STRING(g_level_statement,
7296: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7297: 'RETURN_STATUS = ' || x_return_status);
7298: FND_LOG.STRING(g_level_statement,
7306: l_new_row_num).tax_regime_id := l_tax_regime_rec.tax_regime_id;
7307:
7308: -- validate and populate tax_status_id
7309: --
7310: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
7311: l_tax_rec.tax,
7312: l_tax_rec.tax_regime_code,
7313: l_tax_rec.tax_status_code,
7314: p_tax_determine_date,
7320: IF (g_level_statement >= g_current_runtime_level ) THEN
7321: FND_LOG.STRING(g_level_statement,
7322: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7323: 'Incorrect return_status after calling ' ||
7324: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
7325: FND_LOG.STRING(g_level_statement,
7326: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7327: 'RETURN_STATUS = ' || x_return_status);
7328: FND_LOG.STRING(g_level_statement,
7336: l_new_row_num).tax_status_id := l_tax_status_rec.tax_status_id;
7337:
7338: -- validate and populate tax_rate_id
7339: --
7340: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
7341: l_tax_rec.tax_regime_code,
7342: l_tax_rec.tax,
7343: NULL, --++++
7344: l_tax_rec.tax_status_code,
7353: IF (g_level_statement >= g_current_runtime_level ) THEN
7354: FND_LOG.STRING(g_level_statement,
7355: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7356: 'Incorrect return_status after calling ' ||
7357: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
7358: FND_LOG.STRING(g_level_statement,
7359: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7360: 'RETURN_STATUS = ' || x_return_status);
7361: FND_LOG.STRING(g_level_statement,
7447: -- bug 5077691: populate legal_reporting_status
7448: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
7449: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
7450: l_new_row_num).legal_reporting_status :=
7451: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7452: l_tax_rec.tax_id).legal_reporting_status_def_val;
7453: END IF;
7454:
7455: -- populate tax registration info
7656: AND tax_class <> 'INPUT'
7657: ORDER BY subscription_level_code;
7658:
7659: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
7660: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
7661: l_tax_status_rec zx_tds_utilities_pkg.zx_status_info_rec;
7662: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7663: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7664: l_rownum BINARY_INTEGER;
7657: ORDER BY subscription_level_code;
7658:
7659: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
7660: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
7661: l_tax_status_rec zx_tds_utilities_pkg.zx_status_info_rec;
7662: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7663: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7664: l_rownum BINARY_INTEGER;
7665: l_error_buffer VARCHAR2(200);
7658:
7659: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
7660: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
7661: l_tax_status_rec zx_tds_utilities_pkg.zx_status_info_rec;
7662: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7663: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7664: l_rownum BINARY_INTEGER;
7665: l_error_buffer VARCHAR2(200);
7666: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
7659: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
7660: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
7661: l_tax_status_rec zx_tds_utilities_pkg.zx_status_info_rec;
7662: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7663: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7664: l_rownum BINARY_INTEGER;
7665: l_error_buffer VARCHAR2(200);
7666: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
7667: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
7751: -- the tax is not migrated from 11i, it is not madatory to define the same
7752: -- tax in AP as that in AR. In this case, we do not need to error out if
7753: -- the validations fail because we can ignore the tax lines fetched from AR
7754: --
7755: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
7756: tax_line_rec.tax_regime_code,
7757: p_tax_determine_date,
7758: l_tax_regime_rec,
7759: x_return_status,
7764: IF (g_level_statement >= g_current_runtime_level ) THEN
7765: FND_LOG.STRING(g_level_statement,
7766: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7767: 'Incorrect return_status after calling ' ||
7768: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
7769: FND_LOG.STRING(g_level_statement,
7770: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7771: 'RETURN_STATUS = ' || x_return_status);
7772: FND_LOG.STRING(g_level_statement,
7784:
7785: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
7786: l_rownum).tax_regime_id := l_tax_regime_rec.tax_regime_id;
7787:
7788: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
7789: tax_line_rec.tax_regime_code,
7790: tax_line_rec.tax,
7791: p_tax_determine_date,
7792: l_tax_rec,
7798: IF (g_level_statement >= g_current_runtime_level ) THEN
7799: FND_LOG.STRING(g_level_statement,
7800: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7801: 'Incorrect return_status after calling ' ||
7802: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
7803: FND_LOG.STRING(g_level_statement,
7804: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7805: 'RETURN_STATUS = ' || x_return_status);
7806: FND_LOG.STRING(g_level_statement,
7822: --
7823: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
7824: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
7825: l_rownum).legal_reporting_status :=
7826: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
7827: l_tax_rec.tax_id).legal_reporting_status_def_val;
7828: END IF;
7829: END IF;
7830: END IF; -- l_is_valid for tax validation
7832: -- validate tax_jurisdiction_id
7833: --
7834: IF l_is_valid AND tax_line_rec.tax_jurisdiction_code is not NULL THEN
7835:
7836: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
7837: tax_line_rec.tax_regime_code,
7838: tax_line_rec.tax,
7839: tax_line_rec.tax_jurisdiction_code,
7840: p_tax_determine_date,
7847: IF (g_level_statement >= g_current_runtime_level ) THEN
7848: FND_LOG.STRING(g_level_statement,
7849: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7850: 'Incorrect return_status after calling ' ||
7851: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
7852: FND_LOG.STRING(g_level_statement,
7853: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7854: 'RETURN_STATUS = ' || x_return_status);
7855: FND_LOG.STRING(g_level_statement,
7870: -- validate tax_status_id
7871: --
7872: IF l_is_valid THEN
7873:
7874: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
7875: tax_line_rec.tax,
7876: tax_line_rec.tax_regime_code,
7877: tax_line_rec.tax_status_code,
7878: p_tax_determine_date,
7885: IF (g_level_statement >= g_current_runtime_level ) THEN
7886: FND_LOG.STRING(g_level_statement,
7887: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7888: 'Incorrect return_status after calling ' ||
7889: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
7890: FND_LOG.STRING(g_level_statement,
7891: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7892: 'RETURN_STATUS = ' || x_return_status);
7893: FND_LOG.STRING(g_level_statement,
7906:
7907: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
7908: l_rownum).tax_status_id := l_tax_status_rec.tax_status_id;
7909:
7910: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
7911: tax_line_rec.tax_regime_code,
7912: tax_line_rec.tax,
7913: tax_line_rec.tax_jurisdiction_code,
7914: tax_line_rec.tax_status_code,
7924: IF (g_level_statement >= g_current_runtime_level ) THEN
7925: FND_LOG.STRING(g_level_statement,
7926: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7927: 'Incorrect return_status after calling ' ||
7928: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
7929: FND_LOG.STRING(g_level_statement,
7930: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7931: 'RETURN_STATUS = ' || x_return_status);
7932: FND_LOG.STRING(g_level_statement,
8143:
8144: -- Tax Defined in AP or other product.
8145: -- Need to validate and populate tax_regime_id
8146: --
8147: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
8148: l_tax_regime_code,
8149: p_tax_determine_date,
8150: l_tax_regime_rec,
8151: x_return_status,
8155: IF (g_level_statement >= g_current_runtime_level ) THEN
8156: FND_LOG.STRING(g_level_statement,
8157: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
8158: 'Incorrect return_status after calling ' ||
8159: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
8160: FND_LOG.STRING(g_level_statement,
8161: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
8162: 'RETURN_STATUS = ' || x_return_status);
8163: FND_LOG.STRING(g_level_statement,
8175: l_rownum).tax_regime_code := l_tax_regime_code;
8176:
8177: -- validate and populate tax_id
8178: --
8179: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
8180: l_tax_regime_code,
8181: l_tax,
8182: p_tax_determine_date,
8183: l_tax_rec,
8188: IF (g_level_statement >= g_current_runtime_level ) THEN
8189: FND_LOG.STRING(g_level_statement,
8190: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
8191: 'Incorrect return_status after calling ' ||
8192: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
8193: FND_LOG.STRING(g_level_statement,
8194: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
8195: 'RETURN_STATUS = ' || x_return_status);
8196: FND_LOG.STRING(g_level_statement,
8212: -- bug 5077691: populate legal_reporting_status
8213: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
8214: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
8215: l_rownum).legal_reporting_status :=
8216: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
8217: l_tax_rec.tax_id).legal_reporting_status_def_val;
8218: END IF;
8219: --
8220: -- validate and populate tax_jurisdiction_id
8219: --
8220: -- validate and populate tax_jurisdiction_id
8221: --
8222: IF l_tax_jurisdiction_code is not NULL THEN
8223: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
8224: l_tax_regime_code,
8225: l_tax,
8226: l_tax_jurisdiction_code,
8227: p_tax_determine_date,
8233: IF (g_level_statement >= g_current_runtime_level ) THEN
8234: FND_LOG.STRING(g_level_statement,
8235: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
8236: 'Incorrect return_status after calling ' ||
8237: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
8238: FND_LOG.STRING(g_level_statement,
8239: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
8240: 'RETURN_STATUS = ' || x_return_status);
8241: FND_LOG.STRING(g_level_statement,
8260:
8261:
8262: -- validate and populate tax_status_id
8263: --
8264: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
8265: l_tax,
8266: l_tax_regime_code,
8267: l_tax_status_code,
8268: p_tax_determine_date,
8274: IF (g_level_statement >= g_current_runtime_level ) THEN
8275: FND_LOG.STRING(g_level_statement,
8276: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
8277: 'Incorrect return_status after calling ' ||
8278: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
8279: FND_LOG.STRING(g_level_statement,
8280: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
8281: 'RETURN_STATUS = ' || x_return_status);
8282: FND_LOG.STRING(g_level_statement,
8294: l_rownum).tax_status_code := l_tax_status_code;
8295:
8296: -- validate and populate tax_rate_id and retain rate % and tax amount
8297: --
8298: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
8299: l_tax_regime_code,
8300: l_tax,
8301: l_tax_jurisdiction_code,
8302: l_tax_status_code,
8311: IF (g_level_statement >= g_current_runtime_level ) THEN
8312: FND_LOG.STRING(g_level_statement,
8313: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
8314: 'Incorrect return_status after calling ' ||
8315: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
8316: FND_LOG.STRING(g_level_statement,
8317: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
8318: 'RETURN_STATUS = ' || x_return_status);
8319: FND_LOG.STRING(g_level_statement,
8786: l_exception_set_tbl exception_set_tbl;
8787: l_counter NUMBER;
8788: i NUMBER;
8789: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
8790: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
8791: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
8792: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
8793: l_error_buffer VARCHAR2(200);
8794: l_rownum BINARY_INTEGER;
8787: l_counter NUMBER;
8788: i NUMBER;
8789: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
8790: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
8791: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
8792: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
8793: l_error_buffer VARCHAR2(200);
8794: l_rownum BINARY_INTEGER;
8795: l_curr_rownum BINARY_INTEGER;
8788: i NUMBER;
8789: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
8790: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
8791: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
8792: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
8793: l_error_buffer VARCHAR2(200);
8794: l_rownum BINARY_INTEGER;
8795: l_curr_rownum BINARY_INTEGER;
8796: l_tax_class zx_rates_b.tax_class%TYPE;
8992: l_ref_doc_tax_applicable := FALSE; -- bug 10184087
8993:
8994: l_end_index := NVL( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);
8995: -- Check if this tax line exists in the new created applicable tax lines
8996: l_tax_index := ZX_TDS_UTILITIES_PKG.get_tax_index(
8997: l_tax_regime_code_tbl(j),
8998: l_tax_tbl(j),
8999: l_trx_line_id,
9000: l_trx_level_type,
9006: IF (g_level_statement >= g_current_runtime_level ) THEN
9007: FND_LOG.STRING(g_level_statement,
9008: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9009: 'Incorrect return_status after calling ' ||
9010: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
9011: FND_LOG.STRING(g_level_statement,
9012: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9013: 'RETURN_STATUS = ' || x_return_status);
9014: FND_LOG.STRING(g_level_statement,
9226: 1,
9227: 8192);
9228:
9229:
9230: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index)
9231: THEN
9232: -- cehck the product family from the cached structure
9233:
9234: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NULL THEN
9230: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index)
9231: THEN
9232: -- cehck the product family from the cached structure
9233:
9234: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NULL THEN
9235:
9236: l_rate_exists_same_prod_family := TRUE;
9237:
9238: ELSIF (ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NOT NULL
9234: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NULL THEN
9235:
9236: l_rate_exists_same_prod_family := TRUE;
9237:
9238: ELSIF (ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NOT NULL
9239: AND ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class = l_tax_class)
9240: THEN
9241:
9242: l_rate_exists_same_prod_family := TRUE;
9235:
9236: l_rate_exists_same_prod_family := TRUE;
9237:
9238: ELSIF (ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NOT NULL
9239: AND ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class = l_tax_class)
9240: THEN
9241:
9242: l_rate_exists_same_prod_family := TRUE;
9243:
9240: THEN
9241:
9242: l_rate_exists_same_prod_family := TRUE;
9243:
9244: ELSIF (ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NOT NULL
9245: AND ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class <> l_tax_class)
9246: THEN
9247:
9248: l_rate_exists_same_prod_family := FALSE;
9241:
9242: l_rate_exists_same_prod_family := TRUE;
9243:
9244: ELSIF (ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class is NOT NULL
9245: AND ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index).tax_class <> l_tax_class)
9246: THEN
9247:
9248: l_rate_exists_same_prod_family := FALSE;
9249:
9247:
9248: l_rate_exists_same_prod_family := FALSE;
9249:
9250: END IF;
9251: END IF; -- ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index)
9252:
9253: IF ( NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index) )
9254: OR l_rate_exists_same_prod_family = FALSE THEN
9255: -- check product family using cursor
9249:
9250: END IF;
9251: END IF; -- ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index)
9252:
9253: IF ( NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash.exists(l_tbl_index) )
9254: OR l_rate_exists_same_prod_family = FALSE THEN
9255: -- check product family using cursor
9256:
9257: OPEN check_tax_rate_class_csr(
9291: --
9292:
9293: -- Bug 5252411
9294:
9295: l_index := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.FIRST;
9296: l_tax_rec := NULL;
9297: WHILE l_index IS NOT NULL LOOP
9298:
9299: IF (l_tax_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax AND
9295: l_index := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.FIRST;
9296: l_tax_rec := NULL;
9297: WHILE l_index IS NOT NULL LOOP
9298:
9299: IF (l_tax_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax AND
9300: l_tax_regime_code_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax_regime_code)
9301: THEN
9302: IF (g_level_statement >= g_current_runtime_level ) THEN
9303: FND_LOG.STRING(g_level_statement,
9296: l_tax_rec := NULL;
9297: WHILE l_index IS NOT NULL LOOP
9298:
9299: IF (l_tax_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax AND
9300: l_tax_regime_code_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax_regime_code)
9301: THEN
9302: IF (g_level_statement >= g_current_runtime_level ) THEN
9303: FND_LOG.STRING(g_level_statement,
9304: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info',
9300: l_tax_regime_code_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax_regime_code)
9301: THEN
9302: IF (g_level_statement >= g_current_runtime_level ) THEN
9303: FND_LOG.STRING(g_level_statement,
9304: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info',
9305: 'tax found in tax cache, at index '||
9306: to_char(l_index));
9307: END IF;
9308:
9305: 'tax found in tax cache, at index '||
9306: to_char(l_index));
9307: END IF;
9308:
9309: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_from <= p_tax_determine_date
9310: AND (ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to >= p_tax_determine_date
9311: OR ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to IS NULL)
9312: THEN
9313: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index);
9306: to_char(l_index));
9307: END IF;
9308:
9309: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_from <= p_tax_determine_date
9310: AND (ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to >= p_tax_determine_date
9311: OR ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to IS NULL)
9312: THEN
9313: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index);
9314:
9307: END IF;
9308:
9309: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_from <= p_tax_determine_date
9310: AND (ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to >= p_tax_determine_date
9311: OR ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to IS NULL)
9312: THEN
9313: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index);
9314:
9315: END IF;
9309: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_from <= p_tax_determine_date
9310: AND (ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to >= p_tax_determine_date
9311: OR ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).effective_to IS NULL)
9312: THEN
9313: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index);
9314:
9315: END IF;
9316: EXIT;
9317: END IF; -- tax found in cache
9315: END IF;
9316: EXIT;
9317: END IF; -- tax found in cache
9318:
9319: l_index := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.NEXT(l_index);
9320: END LOOP;
9321:
9322: -- tax not exists in the cache structure, retrieve tax info from table
9323: IF l_tax_rec.TAX IS NULL THEN
9329: CLOSE get_tax_info_csr;
9330:
9331: -- bug fix 5579156: cache the tax detail info when tax found effective.
9332: IF l_tax_rec.tax_id IS NOT NULL THEN
9333: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_rec.tax_id) := l_tax_rec;
9334: END IF;
9335:
9336: END IF;
9337:
9563: l_rownum).trx_id := p_event_class_rec.trx_id;
9564:
9565: -- validate and populate tax_regime_id
9566: --
9567: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
9568: l_tax_regime_code_tbl(j),
9569: p_tax_determine_date,
9570: l_tax_regime_rec,
9571: x_return_status,
9575: IF (g_level_statement >= g_current_runtime_level ) THEN
9576: FND_LOG.STRING(g_level_statement,
9577: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9578: 'Incorrect return_status after calling ' ||
9579: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
9580: FND_LOG.STRING(g_level_statement,
9581: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9582: 'RETURN_STATUS = ' || x_return_status);
9583: FND_LOG.STRING(g_level_statement,
9596: -- bug 5077691: populate legal_reporting_status
9597: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
9598: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9599: l_rownum).legal_reporting_status :=
9600: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
9601: l_tax_rec.tax_id).legal_reporting_status_def_val;
9602: END IF;
9603:
9604: IF l_jurisdictions_found = 'Y'
9613:
9614: IF l_status_result_tbl(j) IS NOT NULL THEN
9615: -- validate and populate tax_status_id
9616: --
9617: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
9618: l_tax_tbl(j),
9619: l_tax_regime_code_tbl(j),
9620: l_status_result_tbl(j),
9621: p_tax_determine_date,
9627: IF (g_level_statement >= g_current_runtime_level ) THEN
9628: FND_LOG.STRING(g_level_statement,
9629: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9630: 'Incorrect return_status after calling ' ||
9631: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
9632: FND_LOG.STRING(g_level_statement,
9633: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9634: 'RETURN_STATUS = ' || x_return_status);
9635: FND_LOG.STRING(g_level_statement,
9656: -- multiple jurisdictions situation
9657:
9658: FOR i IN 1 .. nvl(l_jurisdiction_rec_tbl.count, 0) LOOP
9659:
9660: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
9661: l_tax_regime_code_tbl(j),
9662: l_tax_tbl(j),
9663: l_jurisdiction_rec_tbl(i).tax_jurisdiction_code,
9664: l_status_result_tbl(j),
9682: ELSE
9683:
9684: -- Single Jurisdiction
9685:
9686: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
9687: l_tax_regime_code_tbl(j),
9688: l_tax_tbl(j),
9689: l_jurisdiction_rec.tax_jurisdiction_code,
9690: l_status_result_tbl(j),
9701: IF (g_level_statement >= g_current_runtime_level ) THEN
9702: FND_LOG.STRING(g_level_statement,
9703: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9704: 'Incorrect return_status after calling ' ||
9705: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
9706: FND_LOG.STRING(g_level_statement,
9707: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9708: 'RETURN_STATUS = ' || x_return_status);
9709: FND_LOG.STRING(g_level_statement,
10198: -- Local variables
10199: l_current_line_amt zx_lines.line_amt%TYPE;
10200: l_tax_line_rec zx_lines%ROWTYPE;
10201:
10202: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
10203: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
10204: l_error_buffer VARCHAR2(200);
10205:
10206: l_tax_class zx_rates_b.tax_class%TYPE;
10199: l_current_line_amt zx_lines.line_amt%TYPE;
10200: l_tax_line_rec zx_lines%ROWTYPE;
10201:
10202: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
10203: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
10204: l_error_buffer VARCHAR2(200);
10205:
10206: l_tax_class zx_rates_b.tax_class%TYPE;
10207:
10390: p_row_num).orig_tax_status_id := l_tax_line_rec.orig_tax_status_id;
10391:
10392: -- populate tax_status_id
10393: --
10394: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
10395: p_tax,
10396: p_tax_regime_code,
10397: l_tax_line_rec.tax_status_code,
10398: p_tax_determine_date,
10404: IF (g_level_error >= g_current_runtime_level ) THEN
10405: FND_LOG.STRING(g_level_error,
10406: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10407: 'Incorrect return_status after calling '||
10408: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
10409: FND_LOG.STRING(g_level_error,
10410: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10411: 'RETURN_STATUS = ' || x_return_status);
10412: FND_LOG.STRING(g_level_error,
10441: p_row_num).orig_tax_rate := l_tax_line_rec.orig_tax_rate;
10442:
10443: -- populate tax_status_id
10444: --
10445: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
10446: p_tax,
10447: p_tax_regime_code,
10448: l_tax_line_rec.tax_status_code,
10449: p_tax_determine_date,
10455: IF (g_level_error >= g_current_runtime_level ) THEN
10456: FND_LOG.STRING(g_level_error,
10457: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10458: 'Incorrect return_status after calling '||
10459: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
10460: FND_LOG.STRING(g_level_error,
10461: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10462: 'RETURN_STATUS = ' || x_return_status);
10463: FND_LOG.STRING(g_level_error,
10473: l_tax_status_rec.tax_status_id;
10474:
10475: -- validate and populate tax_rate_id
10476: --
10477: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
10478: p_tax_regime_code,
10479: p_tax,
10480: x_tax_jurisdiction_code,
10481: l_tax_line_rec.tax_status_code,
10490: IF (g_level_error >= g_current_runtime_level ) THEN
10491: FND_LOG.STRING(g_level_error,
10492: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10493: 'Incorrect return_status after calling '||
10494: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
10495: FND_LOG.STRING(g_level_error,
10496: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10497: 'RETURN_STATUS = ' || x_return_status);
10498: FND_LOG.STRING(g_level_error,
10528: p_row_num).orig_tax_rate := l_tax_line_rec.orig_tax_rate;
10529:
10530: -- populate tax_status_id
10531: --
10532: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
10533: p_tax,
10534: p_tax_regime_code,
10535: l_tax_line_rec.tax_status_code,
10536: p_tax_determine_date,
10542: IF (g_level_error >= g_current_runtime_level ) THEN
10543: FND_LOG.STRING(g_level_error,
10544: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10545: 'Incorrect return_status after calling '||
10546: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
10547: FND_LOG.STRING(g_level_error,
10548: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10549: 'RETURN_STATUS = ' || x_return_status);
10550: FND_LOG.STRING(g_level_error,
10560: l_tax_status_rec.tax_status_id;
10561:
10562: -- validate and populate tax_rate_id
10563: --
10564: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
10565: p_tax_regime_code,
10566: p_tax,
10567: x_tax_jurisdiction_code,
10568: l_tax_line_rec.tax_status_code,
10577: IF (g_level_error >= g_current_runtime_level ) THEN
10578: FND_LOG.STRING(g_level_error,
10579: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10580: 'Incorrect return_status after calling '||
10581: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
10582: FND_LOG.STRING(g_level_error,
10583: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10584: 'RETURN_STATUS = ' || x_return_status);
10585: FND_LOG.STRING(g_level_error,
10647: END IF;
10648:
10649: -- populate tax_status_id
10650: --
10651: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
10652: p_tax,
10653: p_tax_regime_code,
10654: l_tax_line_rec.tax_status_code,
10655: p_tax_determine_date,
10661: IF (g_level_error >= g_current_runtime_level ) THEN
10662: FND_LOG.STRING(g_level_error,
10663: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10664: 'Incorrect return_status after calling '||
10665: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
10666: FND_LOG.STRING(g_level_error,
10667: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10668: 'RETURN_STATUS = ' || x_return_status);
10669: FND_LOG.STRING(g_level_error,
10679: l_tax_status_rec.tax_status_id;
10680:
10681: -- validate and populate tax_rate_id
10682: --
10683: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
10684: p_tax_regime_code,
10685: p_tax,
10686: x_tax_jurisdiction_code,
10687: l_tax_line_rec.tax_status_code,
10696: IF (g_level_error >= g_current_runtime_level ) THEN
10697: FND_LOG.STRING(g_level_error,
10698: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10699: 'Incorrect return_status after calling '||
10700: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
10701: FND_LOG.STRING(g_level_error,
10702: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10703: 'RETURN_STATUS = ' || x_return_status);
10704: FND_LOG.STRING(g_level_error,
10815: x_return_status OUT NOCOPY VARCHAR2) IS
10816:
10817: -- Local variables
10818: i NUMBER;
10819: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
10820: l_error_buffer VARCHAR2(200);
10821:
10822: -- Cursor definitions
10823: CURSOR enforce_rate_code_from_ref_doc(
10920: i).other_doc_source := 'REFERENCE';
10921:
10922: -- bugfix 5176149:populate tax_status_id
10923: --
10924: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
10925: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax,
10926: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code,
10927: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code,
10928: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date,
10934: IF (g_level_statement >= g_current_runtime_level ) THEN
10935: FND_LOG.STRING(g_level_statement,
10936: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10937: 'Incorrect return_status after calling ' ||
10938: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
10939: FND_LOG.STRING(g_level_statement,
10940: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10941: 'RETURN_STATUS = ' || x_return_status);
10942: FND_LOG.STRING(g_level_statement,