Search Results select_row

Overview

GL_TAX_CODES_PKG is a PL/SQL package owned by the APPS schema that supports the Oracle General Ledger tax code infrastructure. Its role is to provide a controlled, encapsulated lookup interface against the tax code definitions maintained in General Ledger, allowing callers to retrieve a tax code value for a given tax code identifier and tax type without issuing a direct query against the underlying view. The package follows a common EBS pattern in which a private worker routine performs the actual row retrieval and one or more public routines expose a narrower, parameter-driven interface to external callers. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, the package header and body are compiled into the APPS schema, and the body carries a version header referencing a 2006 revision (120.4), indicating the object has been stable across many releases.

Key Procedures and Functions

• select_columns — The sole documented public procedure. It accepts a tax code identifier, a tax type code, and an OUT NOCOPY tax code value. Internally it populates a record structure from the view's row type, delegates the actual lookup to the private select_row routine, and returns the retrieved tax code to the caller. This is the supported entry point for external code.
• select_row (private) — The internal retrieval routine that the user's search term "select_row" refers to. It takes an IN OUT NOCOPY record based on the gl_tax_codes_v row type, uses the tax_code_id and tax_type_code supplied in that record to query the view, and returns the full row. The query filters on tax_code_id and applies a DECODE-based condition so that a specific tax type ('I' or 'O') is matched when provided, while the value 'T' is also accepted.

Tables Accessed

The package operates exclusively against the view gl_tax_codes_v, which is referenced through the APPS synonym layer. No base tables are documented as being written to; this is a read-only utility. The view supplies the tax code identifier, tax type code, and the descriptive tax code value that select_columns returns. Because access is through a view, the package inherits whatever row-level security and column projection the view defines, which is consistent with EBS practice of shielding callers from direct table access.

Usage Notes

GL_TAX_CODES_PKG is classified as OTHER rather than as a formal public API, and the ETRM metadata records no other packages that reference it. In practice it is invoked from custom PL/SQL, forms-based validation logic, or Concurrent Program code that needs to resolve a tax code from its identifier and type. Callers should invoke select_columns rather than attempting to call the private select_row routine, which is not exposed in the specification. Because the routine uses NOCOPY parameters and a SELECT INTO against a view, callers must ensure exactly one matching row exists for the supplied identifier and type; otherwise a NO_DATA_FOUND or TOO_MANY_ROWS exception will propagate. Given its age and stability, the package should be treated as a low-risk read-only dependency, but it is not a substitute for the current tax configuration APIs when tax setup itself must be created or modified.