Results for “get_tax_regimes”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ZX_TDS_CALC_SERVICES_PUB_PKG is the public calculation services layer of the Oracle E-Business Tax (EBS Tax / ETRM) engine. It exposes the PL/SQL entry points through which callers request tax determination, tax calculation, tax line maintenance, and document-level tax operations for a given event class and document. The package body operates on detail and summary tax lines residing in the ZX_LINES and ZX_LINES_SUMMARY structures and is designed to be invoked in the context of a taxable event, such as an invoice or an imported transaction. In Oracle EBS 12.1.1 and 12.2.2 the package is owned by APPS and is classified under the generic API category, meaning it is a public, callable interface rather than a private internal helper. The header comment and constants (including G_LINES_PER_FETCH of 1000 and the message-level constants derived from FND_MSG_PUB) indicate that the package supports bulk processing with buffered fetches and standardized error reporting through the Oracle message stack.

Key Procedures and Functions

The documented API surface comprises 17 procedures and functions that collectively cover the tax lifecycle:

• GET_TAX_REGIMES — retrieves the tax regimes applicable to the transaction context.
• TAX_LINE_DETERMINATION — performs tax line determination for the event.
• CALCULATE_TAX — executes the core tax calculation for the document.
• CALCULATE_TAX_FOR_IMPORT — supports calculation for imported transactions where detail tax lines are supplied externally.
• OVERRIDE_DETAIL_TAX_LINES and OVERRIDE_SUMMARY_TAX_LINES — allow caller-supplied values to override calculated detail or summary tax lines.
• PRORATE_IMPORTED_SUM_TAX_LINES — distributes imported summary tax amounts across detail lines.
• VALIDATE_DOCUMENT_FOR_TAX — validates that a document is eligible for tax processing.
• REVERSE_DOCUMENT — reverses tax for a previously processed document.
• DUMP_DETAIL_TAX_LINES_INTO_GT — loads detail tax lines into the global temporary structure ZX_DETAIL_TAX_LINES_GT, typically for downstream processing or reporting.
• UPDATE_EXCHANGE_RATE — refreshes currency conversion rates applied to tax amounts.
• ROUND_TAX_CURR_XML_INV — performs currency rounding of tax amounts for XML invoice processing.
• GET_PROCESS_FOR_APPL_FLG — resolves the "process for application" flag that governs how a party tax profile is treated.
• GET_REP_CODE_ID — resolves the reporting code identifier used for tax reporting.
• INITIALIZE — resets package-level state and working tables before a processing run.

Additional private helpers declared in the body (for example, fetch_detail_tax_lines, process_taxes_for_xml_inv_line, process_taxes_for_xml_inv_hdr, adjust_tax_for_xml_inv_line, and adjust_tax_for_xml_inv_hdr) support XML invoice tax processing and are not part of the published interface.

Tables Accessed

The package reads the EBS Tax configuration and transaction tables through APPS synonyms. It uses ZX_REGIMES_B, ZX_TAXES_B, ZX_JURISDICTIONS_B, and ZX_CONDITIONS / ZX_CONDITION_GROUPS_B to resolve the tax regime, tax, jurisdiction, and applicability rules. ZX_DET_FACTOR_TEMPL_B and ZX_REPORTING_CODES_B supply determination factor templates and reporting codes, while ZX_PARTY_TAX_PROFILE and ZX_EVNT_CLS_MAPPINGS determine the tax profile and event class behavior. Transactional data is read from and written to ZX_LINES, ZX_LINES_SUMMARY, and ZX_PROCESS_RESULTS, with ZX_DETAIL_TAX_LINES_GT used as a global temporary staging area. HZ_LOCATIONS provides address information used in place-of-supply determination, and FND_CURRENCIES supplies currency definitions for conversion and rounding. This table list directly corresponds to the "tax_curr" search term, since currency handling is central to the calculation and rounding APIs.

Usage Notes

ZX_TDS_CALC_SERVICES_PUB_PKG is referenced by 22 other packages, indicating it is a widely used public service within the EBS Tax engine. It is typically invoked from concurrent programs that recalculate or import tax, from the EBS Tax calculation flows triggered by transaction processing, and from custom PL/SQL code that needs to calculate, override, validate, reverse, or round tax for a document. Callers are expected to initialize package state (INITIALIZE), determine tax regimes and lines, perform calculation, and then apply overrides or rounding as required, checking x_return_status and the FND message stack for outcomes. Because it manipulates the core ZX_LINES structures, it should be invoked within the standard EBS Tax calling sequence rather than in isolation.