Results for “is_attribute_used”

36 results




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

Overview

QP_BUILD_SOURCING_PVT2 is a private Oracle Advanced Pricing package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The name follows Oracle's naming convention for private package bodies: the "PVT" suffix identifies it as an internal, not-public API, and the trailing "2" distinguishes it from earlier iterations of the same logical unit. Its documented header carries the file identifier QPXVAT2S.pls and a revision stamp dated 2012/07/17, consistent with the 12.1.3/12.2 code line.

The package exists to support attribute mapping within the pricing and sourcing engine. Attribute mapping is the mechanism by which Oracle Advanced Pricing determines which pricing attributes, qualifier contexts, and pricing contexts are relevant for a given request type and pricing type. QP_BUILD_SOURCING_PVT2 supplies the attribute-related context metadata that the public attribute mapping API (QP_ATTR_MAPPING_PUB) relies upon when building the sourcing and pricing context for a transaction line. In this sense it sits between the pricing setup data and the runtime pricing engine, resolving which attributes are actually in use before the engine evaluates qualifiers and price lists.

Key Procedures and Functions

The package exposes two documented program units:

  • GET_ATTRIBUTE_VALUES — a procedure that returns the qualifier context and pricing context result sets for a given request type code and pricing type code. It accepts the request type and pricing type as input identifiers and populates two OUT NOCOPY collections typed as QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE. The NOCOPY hint indicates these are bulk result sets returned to the caller without an intermediate copy, appropriate for the potentially large context collections produced during pricing setup evaluation. One result table is designated for qualifier contexts and the other for pricing contexts.
  • IS_ATTRIBUTE_USED — a function that accepts an attribute context and attribute code and returns a VARCHAR2 indicator of whether that attribute is referenced anywhere in the pricing and sourcing configuration. It provides a lightweight, callable check used to avoid building context information for attributes that are not in use.

Tables Accessed

The ETRM metadata does not enumerate specific base tables for this package, and Oracle does not publish the private body. Functionally, the package reads pricing setup and attribute mapping data through APPS synonyms—principally the pricing attribute and context definition tables within the QP schema, and the attribute mapping association tables that record attribute usage. It is a read-only component; no INSERT, UPDATE, or DELETE activity is attributed to it in the metadata.

Usage Notes

Because the header comment explicitly warns against adding package variables, QP_BUILD_SOURCING_PVT2 is intentionally stateless, and the note about session memory images being invalidated is standard Oracle guidance for packages used by long-lived middle-tier connections and by the concurrent manager. It is referenced by one other package in the APPS schema—typically a public attribute mapping or pricing engine wrapper—rather than being invoked directly by Oracle Forms.

Customizations should not call this package directly. The supported integration point is QP_ATTR_MAPPING_PUB, which internally delegates to this private package. Custom code that needs attribute usage information should call the public API so that behavior remains upgrade-safe across 12.1.1 and 12.2.2. Direct calls risk breakage if Oracle changes the private signature in a patch or family pack, since no public compatibility guarantee applies to private packages.

The search phrase "qualcomm 2.51 sdk" does not correspond to any documented feature of this package; it appears unrelated to the Oracle EBS object described here.