eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_RATE_DETM_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 80: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

76: l_ptp_id NUMBER;
77: l_reg_party_type VARCHAR2(80);
78: l_numeric_result zx_process_results.numeric_result%TYPE;
79:
80: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
81: l_exemption_rec ZX_TCM_GET_EXEMPT_PKG.exemption_rec_type;
82: l_exception_rec ZX_TCM_GET_EXCEPT_PKG.exception_rec_type;
83: l_allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE;
84: l_allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE;

Line 308: ZX_TDS_UTILITIES_PKG.get_tax_rate_info

304: x_tax_rate_rec => l_tax_rate_rec,
305: x_return_status => p_return_status
306: );
307: ELSE
308: ZX_TDS_UTILITIES_PKG.get_tax_rate_info
309: ( l_tax_regime_code,
310: l_tax,
311: l_tax_jurisdiction_code,
312: l_tax_status_code,

Line 575: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag <> 'R')

571: OR ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NOT NULL)
572: )
573: OR
574: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
575: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag <> 'R')
576: ) AND
577: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code <> 'OVERRIDE_TAX'
578: THEN
579: -- In case when the tax line is copied from Applied From (applied_amt_handling_flag on

Line 653: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'R'

649: ('TAX_STATUS', 'TAX_RATE_CODE') -- AND --bug 5237144
650: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
651: ) OR
652: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
653: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'R'
654: ) OR
655: -- Bug 5176149: need to populate tax rate id and tax rate % for matched invoice
656: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'REFERENCE'
657: ) OR

Line 699: l_status_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(

695:
696: -- select the tax rate rule flag from tax status cache
697: -- get the hash value using tax regime code, tax, tax status code
698:
699: l_status_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(
700: l_tax,
701: l_tax_regime_code,
702: l_tax_status_code);
703:

Line 725: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).rule_based_rate_flag;

721: RETURN;
722: ELSE
723:
724: l_tax_rate_rule_flag :=
725: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).rule_based_rate_flag;
726: l_effective_from :=
727: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from;
728: l_effective_to :=
729: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to;

Line 727: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from;

723:
724: l_tax_rate_rule_flag :=
725: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).rule_based_rate_flag;
726: l_effective_from :=
727: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from;
728: l_effective_to :=
729: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to;
730:
731: END IF; -- l_status_index is NULL

Line 729: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to;

725: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).rule_based_rate_flag;
726: l_effective_from :=
727: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from;
728: l_effective_to :=
729: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to;
730:
731: END IF; -- l_status_index is NULL
732:
733: IF l_tax_rate_rule_flag = 'Y' THEN

Line 854: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN

850:
851: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
852: l_tax_jurisdiction_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;
853:
854: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN
855: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id) := l_tax_rate_rec;
856: END IF;
857:
858: IF l_tax_rate_code IS NOT NULL THEN

Line 855: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id) := l_tax_rate_rec;

851: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
852: l_tax_jurisdiction_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;
853:
854: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN
855: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id) := l_tax_rate_rec;
856: END IF;
857:
858: IF l_tax_rate_code IS NOT NULL THEN
859:

Line 1465: -- IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

1461:
1462: l_exemption_rec := NULL;
1463:
1464: -- Bug 8476876: Commet out the reference to l_exempt_info_tbl per Helen
1465: -- IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1466: -- l_tax_id).tax_exmpt_source_tax IS NOT NULL
1467: -- THEN
1468: -- IF (g_level_statement >= g_current_runtime_level ) THEN
1469: -- FND_LOG.STRING(g_level_statement,

Line 1472: -- ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_exmpt_source_tax);

1468: -- IF (g_level_statement >= g_current_runtime_level ) THEN
1469: -- FND_LOG.STRING(g_level_statement,
1470: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1471: -- 'Current tax has a source tax: ' ||
1472: -- ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_exmpt_source_tax);
1473: --
1474: -- END IF;
1475: --
1476: --

Line 1481: -- l_exempt_info_tbl(i).tax = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

1477: -- FOR i IN REVERSE NVL(l_exempt_info_tbl.FIRST, 0)..NVL(l_exempt_info_tbl.LAST, -1) LOOP
1478: --
1479: --
1480: -- IF l_exempt_info_tbl(i).tax_regime_code = l_tax_regime_code AND
1481: -- l_exempt_info_tbl(i).tax = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1482: -- l_tax_id).tax_exmpt_source_tax
1483: -- THEN
1484: --
1485: -- l_exemption_rec.exemption_id := l_exempt_info_tbl(i).exemption_id;

Line 1678: l_status_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(

1674: THEN
1675: -- check whether the tax rate is ad-hoc
1676:
1677: /* commented out for bug 3420310, the following check should have been done on the UI
1678: l_status_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(
1679: l_tax,
1680: l_tax_regime_code,
1681: l_tax_status_code);
1682:

Line 1703: -- ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;

1699: ELSE
1700: -- bug fix 3420310
1701: -- Allow_Adhoc_Tax_Rate_Flag moved to zx_rates_b table, g_tax_status_info_tbl changed accordingly
1702: -- l_adhoc_tax_rate_flg :=
1703: -- ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;
1704: l_adhoc_tax_rate_flg :=
1705: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;
1706:
1707: END IF; -- l_status_index is NULL

Line 1705: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;

1701: -- Allow_Adhoc_Tax_Rate_Flag moved to zx_rates_b table, g_tax_status_info_tbl changed accordingly
1702: -- l_adhoc_tax_rate_flg :=
1703: -- ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;
1704: l_adhoc_tax_rate_flg :=
1705: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;
1706:
1707: END IF; -- l_status_index is NULL
1708:
1709: -- If the tax code is not adhoc then the user cannot specify tax rate on

Line 1737: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from

1733: -- The tax was prorated based on reference document; validate that
1734: -- the tax rate is valid for the transaction date.
1735:
1736: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date >=
1737: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from
1738: and ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date <=
1739: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to
1740: THEN
1741: NULL;

Line 1739: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to

1735:
1736: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date >=
1737: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from
1738: and ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date <=
1739: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to
1740: THEN
1741: NULL;
1742:
1743: else

Line 1894: l_offset_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;

1890: ORDER BY subscription_level_code; -- Bug#5395227
1891: */
1892:
1893: l_tax_rate_id NUMBER;
1894: l_offset_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1895: l_offet_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1896: l_offset_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1897: BEGIN
1898: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1895: l_offet_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

1891: */
1892:
1893: l_tax_rate_id NUMBER;
1894: l_offset_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1895: l_offet_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1896: l_offset_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1897: BEGIN
1898: IF (g_level_procedure >= g_current_runtime_level ) THEN
1899: FND_LOG.STRING(g_level_procedure,

Line 1896: l_offset_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1892:
1893: l_tax_rate_id NUMBER;
1894: l_offset_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1895: l_offet_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1896: l_offset_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1897: BEGIN
1898: IF (g_level_procedure >= g_current_runtime_level ) THEN
1899: FND_LOG.STRING(g_level_procedure,
1900: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.BEGIN',

Line 1906: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

1902: END IF;
1903:
1904: x_return_status := FND_API.G_RET_STS_SUCCESS;
1905:
1906: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
1907: p_tax_regime_code,
1908: p_tax,
1909: p_tax_determine_date,
1910: l_offset_tax_rec,

Line 1918: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info');

1914: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
1915: IF (g_level_error >= g_current_runtime_level ) THEN
1916: FND_LOG.STRING(g_level_error,
1917: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1918: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1919: FND_LOG.STRING(g_level_error,
1920: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1921: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1922: END IF;

Line 1926: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

1922: END IF;
1923: RETURN;
1924: END IF;
1925:
1926: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
1927: p_tax,
1928: p_tax_regime_code,
1929: p_tax_status_code,
1930: p_tax_determine_date,

Line 1939: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');

1935: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
1936: IF (g_level_error >= g_current_runtime_level ) THEN
1937: FND_LOG.STRING(g_level_error,
1938: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1939: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
1940: FND_LOG.STRING(g_level_error,
1941: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1942: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1943: END IF;

Line 1967: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

1963: END IF;
1964: CLOSE get_offset_info_csr;
1965: */
1966:
1967: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
1968: p_tax_regime_code,
1969: p_tax,
1970: p_tax_jurisdiction_code,
1971: p_tax_status_code,

Line 1986: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info');

1982: ELSE
1983: IF (g_level_error >= g_current_runtime_level ) THEN
1984: FND_LOG.STRING(g_level_error,
1985: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1986: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
1987: FND_LOG.STRING(g_level_error,
1988: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1989: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1990: END IF;