Search Results get_attribute_values

Overview

QP_BUILD_SOURCING_PVT_TMP is an Oracle Advanced Pricing (QP) private PL/SQL package owned by the APPS schema. It is delivered as a temporary or staging helper used during the sourcing build process within the pricing engine. In Oracle EBS Release 12.1.1 and 12.2.2, the QP schema contains a family of packages responsible for qualifying and pricing sales orders, return orders, and other fulfillment documents. These packages evaluate pricing attributes, resolve qualifiers against pricing contexts, and return the applicable price adjustments. QP_BUILD_SOURCING_PVT_TMP supports that workflow by assembling the set of attribute and context values required to build a sourcing result.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the definer. This is consistent with many QP private APIs called from the pricing engine, where runtime context and security must follow the caller.

Key Procedures and Functions

The package exposes a single documented procedure:

• GET_ATTRIBUTE_VALUES — Accepts a request type code and a pricing type code, and returns two collection outputs: a qualified contexts result table and a price contexts result table, both based on QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE. In practice, this procedure drives the retrieval and structuring of attribute-to-context mappings used when evaluating qualifiers and pricing rules. The request type and pricing type codes determine which category of pricing transaction (for example, a particular document or pricing request class) is being processed, allowing the procedure to filter the relevant contexts.

Tables Accessed

The documented reference for this package lists the APPS synonym PLITBLM as the table accessed. PLITBLM is a standard Oracle EBS table used for storing temporary or interim row data during PL/SQL processing. Its use here indicates that GET_ATTRIBUTE_VALUES performs interim result storage or staging of attribute and context values before returning them through the output collection parameters. No other base tables are documented as directly referenced by this package.

Usage Notes

This is a private package (the _PVT suffix convention in Oracle EBS indicates private/internal use). It is not intended as a public integration API and should not be called directly from custom code; Oracle reserves the right to change private package signatures between releases. In practice, the package is invoked internally by the Advanced Pricing sourcing and qualification logic during pricing engine execution, typically when a pricing call is made against an order or when the Build Sourcing process resolves qualifier and pricing attribute contexts.

Because it is classified as OTHER within the ETRM registry and is referenced by no other documented packages, its usage footprint is narrow. Developers investigating the internal call path for pricing attribute resolution, particularly when troubleshooting how attribute values feed the qualification and pricing context tables, may encounter this package in trace files or debug logs. When diagnosing pricing behavior, this package should be treated as an internal implementation detail rather than a supported extension point. Any custom requirements for attribute value retrieval should be implemented against the public QP_ATTR_MAPPING_PUB package instead.