Search Results get_tax_id

Overview

ZX_TDS_OFFSET_TAX_DETM_PKG is an Oracle E-Business Tax (E-BTax / ETRM) package body in the APPS schema that supports determination of withholding tax (TDS, Tax Deducted at Source) offset taxes. In Oracle EBS 12.1.1 and 12.2.2, offset taxes allow a jurisdiction to recover or net a previously deducted tax against a later tax liability. This package provides the internal determination plumbing used during tax calculation to resolve the offsetting tax rate, resolve key identifiers such as the tax identifier and tax status identifier, and populate the detail tax lines global temporary table (ZX_DETAIL_TAX_LINES_GT) with the appropriate rate, amount, and flag columns. The classification in ETRM is OTHER, meaning it is an internal helper package rather than a public API intended for direct customer extension. Its header comment carries a 120.43 revision from 2008, confirming the code base is common to the 12.1.1 and 12.2.2 codelines with minimal change across releases.

Key Procedures and Functions

• get_offset_info — Determines the offset tax rate applicable to a given combination of rate code, tax, regime, status, determination date, jurisdiction, and tax class, returning the offset tax rate identifier and the numeric tax rate.
• get_tax_id — Resolves the TAX_ID from ZX_TAXES_B for a supplied tax regime code, tax name, and tax determination date. This is the lookup invoked when the application needs to translate a regime/tax pair into the internal tax identifier before further offset processing.
• get_tax_status_id — Resolves the TAX_STATUS_ID from ZX_STATUS_B using the regime, tax, status code, and determination date, providing the status identifier required by downstream determinations.
• set_null_columns — Clears designated columns on a ZX_DETAIL_TAX_LINES_GT record so that offset lines inherit no residual values from the generating taxable line.
• set_flg_columns — Initialises the indicator and flag columns on the offset detail tax line record.
• set_amt_columns — Populates the amount and rate columns on the offset detail tax line record, taking the parent tax rate and initial tax rate as inputs to derive the offset amounts.
• PROCESS_OFFSET_TAX — The documented entry point that orchestrates offset tax processing; the other procedures supply the identifiers, rates, and column populations it requires.

All identifier and rate procedures return a standard return status and error buffer, following the E-BTax API convention for error propagation.

Tables Accessed

• ZX_RATES_B — Tax rate definitions; source of TAX_RATE_ID, TAX_RATE_CODE and TAX_CLASS.
• ZX_TAXES_B — Tax definitions; source of TAX_ID and the TAX name.
• ZX_REGIMES_B — Tax regime definitions used for regime-code validation.
• ZX_STATUS_B — Tax status definitions; source of TAX_STATUS_ID.
• ZX_JURISDICTIONS_B — Jurisdiction definitions used in offset rate resolution.
• ZX_DETAIL_TAX_LINES_GT — The detail tax lines global temporary table that receives the populated offset records.
• ZX_LINES — Line-level tax results supplying evaluation date and rate context.
• PLITBLM — Standard PL/SQL table utility used internally for collection handling.

Usage Notes

ZX_TDS_OFFSET_TAX_DETM_PKG is invoked internally by the E-BTax determination engine during tax calculation, typically from the tax lines processing flow that calls PROCESS_OFFSET_TAX. It is referenced by one other package, which drives it as part of the offset determination path rather than through a user-facing form. Because the package is classified as OTHER and is not documented as a public API, custom code should not call its procedures directly; instead, callers should use the supported E-BTax APIs and let the engine invoke this package. The presence of get_tax_id in the specification confirms that tax identifier resolution is performed at determination time against ZX_TAXES_B, respecting the tax determination date so that date-effective tax definitions resolve correctly.