Search Results gl_tax_codes_pkg

Overview

The GL_TAX_CODES_PKG package is a General Ledger utility package within the Oracle E-Business Suite APPS schema. Its documented purpose is simply to define and expose the tax code lookup functionality used by the General Ledger application. Tax codes in Oracle GL represent classifications applied to journal entry lines for tax reporting, tax reconciliation, and statutory reporting purposes. The tax code identifier (tax_code_id) and the associated type and name values are the core attributes this package resolves.

The package header carries a revision marker of 120.3, dated 2005/05/05, with original authorship attributed to D. J. Ogg in December 1996. This long history reflects the package's stability; it predates multiple EBS releases and has continued essentially unchanged through 12.1.1 and 12.2.2. The package is classified as an OTHER API object in the ETRM repository, meaning it is an internal utility rather than a formally published public API. It is documented as not being referenced by any other package, underscoring its role as a leaf-level helper rather than a central integration point.

Key Procedures and Functions

The package exposes a single documented procedure:

• select_columns — Retrieves the tax code name and type for a given tax code identifier. Its documented arguments comprise an input tax code ID, an output tax type code, and an output tax code name. Per the documented example, it can be invoked as gl_tax_codes_pkg.select_columns(12, tax_code);. No other procedures or functions are documented for this package.

The procedure name itself indicates a generic column-selection pattern — likely accepting a key value and returning descriptive columns — consistent with the documented arguments and example. No additional overloads or private helpers are documented in the metadata.

Tables Accessed

The ETRM metadata does not enumerate any tables referenced by this package via APPS synonyms. Because the procedure is documented as returning a tax code name and type from a tax code ID, the underlying data source is presumably the GL tax code definition table, most likely GL_TAX_CODES (or its successor in later releases). However, since no table access is confirmed in the supplied documentation, implementers should treat the package as a read-only lookup utility that must be validated against the current schema before custom use.

Usage Notes

Given that the package is not referenced by other packages and exposes only a single lookup procedure, its typical invocation is from Oracle Forms, reports, or custom PL/SQL that needs to resolve a tax code ID into its descriptive name and type at runtime. Common patterns include:

• General Ledger tax-related forms that display a tax code description for a selected ID.
• Custom concurrent programs or interfaces performing journal import or tax reconciliation that must map stored IDs to human-readable values.
• Ad-hoc diagnostic scripts confirming that a tax code ID exists and identifying its type.

Because the object is classified as OTHER rather than a supported public API, Oracle does not guarantee backward compatibility of its signature. Any custom code should isolate calls to this package behind a wrapper, and the package should be regression-tested during upgrades from 12.1.1 to 12.2.2. The NOCOPY hint on the output parameter indicates the original intent was performance-oriented in-place binding; callers should be aware that the same variable is both supplied and mutated.