Search Results process_offset_tax




Overview
Explore in AI Chat

Overview

The APPS.ZX_TDS_OFFSET_TAX_DETM_PKG package is a component of the Oracle E-Business Tax (E-Business Tax / ETRM) engine in Oracle EBS 12.1.1 and 12.2.2. Its responsibility is the determination of offset taxes — that is, the computation and population of the offset tax line records that arise when a tax regime, tax, or rate is configured with an offset tax, most commonly in the context of withholding or self-assessed tax scenarios. The package header (version 120.10, dated April 2004) declares a single public procedure, PROCESS_OFFSET_TAX, and is shipped under the APPS schema as a compiled PL/SQL specification and body. Because it operates on the tax detail lines global temporary table, the package is an internal detemination (determination) engine used during tax calculation rather than an end-user-facing API. Within the ETRM API classification, the package is documented as "OTHER," reflecting its role as a supporting determination routine invoked by the core tax calculation flow.

Key Procedures and Functions

  • process_offset_tax — The sole documented procedure in the package. It accepts an offset tax line record (based on ZX_DETAIL_TAX_LINES_GT%ROWTYPE) as an IN OUT NOCOPY parameter, together with an event class record of type ZX_API_PUB.EVENT_CLASS_REC_TYPE. It returns a status code and an error buffer through OUT NOCOPY parameters. In operation, the procedure evaluates the applicable offset tax configuration for the supplied line context and enriches the line record accordingly.

No additional procedures or functions are publicly documented in the package specification. The parameter handling pattern (IN OUT NOCOPY for the line record, OUT NOCOPY for status and error buffer) follows the standard E-Business Tax determination convention, allowing callers to both supply context and receive the populated offset line result.

Tables Accessed

The package references the following objects via APPS synonyms during offset tax determination:

  • ZX_DETAIL_TAX_LINES_GT — The tax detail lines global temporary table, populated with candidate tax lines; the offset tax line record passed in and out is modeled on its row structure.
  • ZX_LINES — Stores tax line records used for tax line determination and linkage of offset taxes to originating tax lines.
  • ZX_JURISDICTIONS_B, ZX_RATES_B, ZX_TAXES_B, ZX_REGIMES_B, ZX_STATUS_B — Configuration base tables providing jurisdiction, rate, tax, regime, and status definitions needed to resolve the offset tax setup.
  • PLITBLM — The PL/SQL index-by table used for bulk processing and temporary storage of intermediate values.

Usage Notes

ZX_TDS_OFFSET_TAX_DETM_PKG is an internal determination package and is not intended for direct invocation by end users or as a public integration API. It is typically invoked from within the E-Business Tax calculation flow, whenever a tax line requires offset tax determination, and it is referenced by one other package in the tax engine. Because the offset tax line is passed as an IN OUT NOCOPY parameter, callers construct the line record from the tax detail lines global temporary table, invoke the procedure, and then persist or propagate the returned record. The event class record supplied by the caller gives the procedure the transactional context (such as invoice or payment event class) required to select the correct offset tax. Custom code should not call this package directly; any extension of offset tax behaviour should be implemented through the supported E-Business Tax configuration and public APIs, since the package is Oracle proprietary and subject to change between releases.