Results for “get_attr_tbl”

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

Overview

QP_PRICING_ATTR_ATTR_REN is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Advanced Pricing (QP) product family and, based on its naming convention, functions as an attribute retrieval and rendering utility within the pricing engine's attribute framework. The suffix "REN" suggests a rendering or resolution role, indicating that the package is responsible for assembling pricing attribute data into table structures that downstream pricing logic—such as qualifier evaluation, modifier sourcing, or attribute mapping—can consume.

ETRM classifies this package under the API classification "OTHER," meaning it is not published as a formal public API. It is an internal, supporting construct rather than a customer-facing interface. Its status is VALID in the documented release, and importantly, the ETRM metadata records that the package does not reference any database object directly and is not referenced by any other package, placing it at the edge of the dependency graph.

Key Procedures and Functions

The documented package exposes two program units:

• GET_ATTR_TBL — Returns a table-type collection of pricing attribute definitions. This routine supplies the set of attributes relevant to a given pricing context so that calling code can iterate over attribute identifiers, names, or metadata rather than querying them individually.
• GET_ATTR_VALUE_TBL — Returns a table-type collection of pricing attribute values. This routine resolves the actual values associated with the attributes produced by GET_ATTR_TBL, enabling bulk processing of attribute-value pairs for a pricing transaction, qualifier, or modifier.

Both units are named with the "_TBL" suffix, confirming they return PL/SQL collection types rather than scalar values. Parameter lists are not documented in the available metadata and should be confirmed against the deployed package specification in the target instance. No other procedures or functions are recorded.

Tables Accessed

ETRM records a single table accessed through APPS synonyms: PLITBLM. This is the standard Oracle Applications table used for temporary storage of PL/SQL index-by or nested table data during runtime processing. The package's use of PLITBLM is consistent with its role: attribute definitions and values are materialized into this table structure to support set-based operations, joins, and lookups within pricing attribute resolution logic. Because the metadata states the package does not reference database objects directly, all table interaction occurs through the synonym layer, which is typical for APPS-owned code in EBS.

Usage Notes

QP_PRICING_ATTR_ATTR_REN is invoked internally by the Oracle Advanced Pricing attribute framework, particularly during pricing engine execution where attribute context must be gathered and rendered for qualifier and modifier processing. It is not intended for direct invocation by end users or through standard Oracle Forms; no form, concurrent program, or public API dependency is documented.

Because the package is referenced by zero other packages and references none directly, it operates as a self-contained utility called at runtime. Customizations that need pricing attribute collections should evaluate the documented GET_ATTR_TBL and GET_ATTR_VALUE_TBL signatures in the deployed specification before use, and should treat the package as unsupported for modification. Any extension should be layered through supported Advanced Pricing APIs rather than altering this internal package.