Search Results unrounded_tax_amt




Overview
Explore in AI Chat

Overview

The APPS.ZX_TDS_CALC_PKG package body resides within the Oracle E-Business Suite Tax (E-Business Tax / ETRM) module and constitutes the core tax computation engine for transactional tax lines. In Oracle EBS 12.1.1 and 12.2.2, this package is classified under the API classification OTHER, indicating that it is an internal engine component rather than a formally published public API. Its primary responsibility is to determine and compute tax amounts for every tax line associated with a given transaction line, driving the arithmetic defined by tax rules, formulas, and regime configurations.

The package header comment identifies the source version as zxdicalctaxspkgb.pls 120.37.12020000.2, dated 2012, which places it firmly within the 12.1.x and 12.2.x code lines. The package name prefix ZX_TDS (Tax Determination Service) reflects its role in the tax determination and calculation pipeline. The user's search term, unrounded_tax_amt, relates directly to the intermediate and final tax amount variables that this package computes and stores in the tax lines results tables — the calculated tax amount prior to rounding adjustments being a critical intermediate value in the calculation chain.

Key Procedures and Functions

The documented metadata exposes a single public routine: GET_TAX_AMOUNT. The header comments describe it as "the main procedure in this package," used to calculate tax for all tax lines belonging to a transaction line, identified by the p_begin_index and p_end_index parameters. It accepts the applicable event class record, structure name, structure index, and returns a status and error buffer to the calling process.

Internally, GET_TAX_AMOUNT declares a rich set of working variables, including tax calculation rule flags, formula codes and identifiers, line and discount amounts, basis and constant coefficients (used by formula evaluation), compounding tax attributes, and determination dates. A local record type ZX_TAX_INFO_CACHE_REC from ZX_TDS_UTILITIES_PKG supplies cached tax information, while a PL/SQL associative array tax_amt_tbl_type indexes tax amounts by binary integer. The package also references ZX_PROCESS_RESULTS%ROWTYPE to stage computed results.

Tables Accessed

  • ZX_LINES — Stores the transaction tax lines; the package reads line data and writes computed tax amounts (including the unrounded and rounded tax amount values) back to this table.
  • ZX_DETAIL_TAX_LINES_GT — A global temporary table holding detailed tax line data during calculation.
  • ZX_FORMULA_DETAILS and ZX_SCO_FORMULA — Provide the formula definitions and scope formula mappings used to compute tax, including basis and constant coefficients.
  • ZX_TAXES_B — Supplies tax configuration, including the Tax_Calc_Rule_Flag that governs how tax is calculated for a given tax.
  • ZX_PROCESS_RESULTS — Receives staged calculation results before they are persisted to the transaction lines.
  • ZX_REPORTING_CODES_B — Provides reporting code lookups referenced during calculation.
  • PLITBLM — Used for character/string manipulation utilities (such as trimming or parsing formula expressions).

Usage Notes

Because this package is classified as OTHER and is referenced by only two other packages, it is not intended for direct invocation by external customers or customizations. It is invoked internally by the E-Business Tax calculation flow — typically triggered from tax determination and calculation APIs when a transaction (invoice, order, or similar event) requires tax to be computed. It is also reachable indirectly through the Tax Simulator and tax calculation concurrent processes.

Developers diagnosing the unrounded_tax_amt should treat ZX_LINES as the authoritative post-calculation source, understanding that ZX_TDS_CALC_PKG.GET_TAX_AMOUNT is the engine that populates those values. Modifications are unsupported; any diagnostic trace should use FND_LOG levels declared in the package.