Search Results qp_attr_mapping_pub




Overview
Explore in AI Chat

Overview

QP_BUILD_SOURCING_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle Advanced Pricing (QP) module. It forms part of the sourcing engine infrastructure used to construct and evaluate sourcing rules that determine which price list, agreement, or promotion applies to a given transaction line. Within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 codebase, the package is classified as a Private (PVT) API, meaning it is an internal implementation package not intended for direct invocation by external or customer-written code. Its responsibilities center on resolving attribute values that drive the sourcing determination process and on evaluating whether specific attributes participate in the qualification or sourcing logic.

The package sits alongside public-facing counterparts such as QP_PREQ_PUB and QP_ATTR_MAPPING_PUB, which orchestrate pricing and sourcing requests but delegate lower-level attribute resolution work to this private package. This separation of concerns is characteristic of Oracle's layered pricing architecture, where public APIs provide a stable contract while private packages encapsulate volatile internal logic.

Key Procedures and Functions

The ETRM documentation records two documented procedures for this package:

  • GET_ATTRIBUTE_VALUES — Resolves and returns the attribute values required by the sourcing engine for a given pricing or sourcing context. It supplies the attribute data that downstream qualification and sourcing routines use to match transaction lines against sourcing rules and price lists.
  • IS_ATTRIBUTE_USED — Determines whether a specified attribute is actively used within the sourcing configuration. This supports optimization and short-circuit logic, allowing callers to skip unnecessary attribute processing when an attribute is not referenced by any active sourcing rule.

Both procedures are internal helpers; the metadata does not document their formal parameter lists, and no parameter signatures should be assumed beyond their stated purposes.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed through an APPS synonym. PLITBLM is a standard Oracle EBS PL/SQL table type (a PL/SQL index-by table construct) used within the pricing and sourcing stack for in-memory collections. The package interacts with this structure rather than directly against persistent base tables, reflecting its role as an in-memory processing and evaluation layer that operates on data already retrieved by higher-level packages. No persistent application tables are documented as directly read or written by QP_BUILD_SOURCING_PVT.

Usage Notes

Because QP_BUILD_SOURCING_PVT is a private package, it is not invoked directly from Oracle Forms, concurrent programs, or custom extensions. Instead, it is called internally by the following dependent packages:

  • QP_ATTR_MAPPING_PUB — the public attribute-mapping API, which both references and is referenced by this package.
  • QP_BUILD_SOURCING_PVT — recursive or internal self-reference within the sourcing build logic.
  • QP_BULK_PREQ_GRP — group-level pricing request processing for bulk operations.
  • QP_PREQ_GRP — group-level pricing request handling.
  • QP_PREQ_PUB — the primary public pricing request API.

Practically, this package is exercised whenever a pricing or sourcing request is submitted through the standard public APIs, during price list and agreement qualification, and in bulk pricing operations. Developers investigating sourcing determination issues should trace execution through QP_PREQ_PUB and QP_ATTR_MAPPING_PUB rather than calling QP_BUILD_SOURCING_PVT directly, since its private status means its interface is subject to change across patch levels and releases. When the user searches on "qp_attr_mapping_pub," this package appears because QP_ATTR_MAPPING_PUB depends on QP_BUILD_SOURCING_PVT for attribute value resolution and attribute-usage determination during sourcing evaluation.