Search Results qp_build_sourcing_pvt_tmp




Overview
Explore in AI Chat

Overview

QP_BUILD_SOURCING_PVT_TMP is a private PL/SQL package body in the APPS schema that supports the Oracle Advanced Pricing sourcing engine during order capture and pricing. Its "PVT" designation indicates it is a private implementation package, not a public API intended for direct customer invocation. It is closely associated with QP_BUILD_SOURCING_PVT, the sibling private package that performs the core sourcing logic, and the two are typically deployed together.

The package's business role is to resolve and return attribute values required by the pricing and sourcing engine when matching modifiers, qualifiers, and price lists. In Oracle EBS order-to-cash flows, sourcing decisions depend on evaluating attribute values from the order line context, such as customer, item, ship-to, and pricing attributes. QP_BUILD_SOURCING_PVT_TMP provides the mechanism by which those attribute values are fetched and mapped into the structures consumed by the pricing engine. Its classification in the ETRM metadata is "OTHER," reflecting that it is an internal helper rather than a published API.

Key Procedures and Functions

The ETRM documentation for Oracle EBS 12.2.2 records a single documented program unit within this package body:

  • GET_ATTRIBUTE_VALUES — Resolves and returns the attribute values used by the sourcing and pricing build process. It is the entry point through which the calling sourcing routine obtains the contextual attribute data needed to evaluate pricing and modifier qualifiers.

No parameter lists or return types are documented in the ETRM metadata, and none should be assumed. The procedure is intended for internal use only; it is not part of the supported public API surface of Oracle Advanced Pricing.

Tables Accessed

Per the documented metadata, the only table referenced through APPS synonyms is PLITBLM, a standard Oracle EBS PL/SQL table type used for passing collections of values rather than a persistent application table. Its use here is consistent with the package's role of collecting and returning attribute values as an in-memory structure. The dependency list confirms reliance on QP_PREQ_GRP, QP_ATTR_MAPPING_PUB, QP_UTIL_PUB, and QP_DEBUG_UTIL for pricing group and attribute-mapping logic, and on OE_ORDER_PUB and ASO_PRICING_INT for order and pricing context. Additional dependencies include FND_API, STANDARD, and OE_DEBUG_PUB, which supply the standard API and error-handling framework.

Usage Notes

QP_BUILD_SOURCING_PVT_TMP is not invoked directly by end users. It is called internally by the pricing and sourcing build routines, and the ETRM metadata records that it is not referenced by any other database object, confirming its position at the edge of the call graph as a helper invoked from within the Advanced Pricing engine. It is relevant when order capture, order import, or pricing concurrent processes trigger sourcing and modifier evaluation.

Because the package is private and undocumented as a public interface, customizations should never call it directly. Customers extending pricing behavior should use supported public APIs such as QP_PREQ_GRP and QP_ATTR_MAPPING_PUB instead. The package is present in both Oracle EBS 12.1.1 and 12.2.2; in 12.2.x its behavior remains part of the shared Advanced Pricing and Order Management codebase, with no Online Patching-specific changes documented. Its status is VALID in the reference environment.