Search Results qp_attributes_pub




Overview
Explore in AI Chat

Overview

QP_ATTRIBUTES_PVT is a private PL/SQL package in the Oracle EBS Advanced Pricing (QP) module, owned by the APPS schema. It is classified as a Private API (PVT), meaning it is intended for internal consumption by other Oracle EBS packages and forms rather than for direct invocation by customer extensions. The package implements the business logic required to process, lock, and retrieve pricing attribute definitions, which underpin the pricing engine's ability to evaluate qualifiers, modifiers, and context-sensitive pricing rules. Attribute records in Advanced Pricing define the segments and context values used to match pricing rules to transactions; QP_ATTRIBUTES_PVT encapsulates the low-level persistence and record-handling logic that the public layer (QP_ATTRIBUTES_PUB) delegates to.

Key Procedures and Functions

  • PROCESS_ATTRIBUTES — The principal worker procedure. It accepts control information, a current context record, a prior context record, and current/previous segment table collections, then performs the create, update, or delete processing required to synchronize pricing attribute definitions. It returns the resulting context record and segment table to the caller. Its parameter surface is based on the PL/SQL API standard, including API version, message list initialization, commit control, and validation level.
  • LOCK_ATTRIBUTES — Provides the locking operation used to protect an attribute record from concurrent modification during the processing cycle. It follows the same API-standard parameter conventions (api version, init message list, return status, message count, message data) and takes the context record to be locked.
  • GET_ATTRIBUTES — The retrieval routine. This is the procedure targeted by the search term "get_attributes." It is used to fetch pricing attribute context and segment data, typically populating the record structures that the public API or calling forms then display or pass along for further evaluation. Because it is a private procedure, it is reached through the public wrapper rather than invoked directly by external code.

Tables Accessed

The ETRM metadata records a single referenced table, PLITBLM, accessed through an APPS synonym. This table is associated with pricing attribute segment storage used during processing and retrieval operations. The package does not appear to maintain its own dedicated application data store beyond what is exposed through the QP_Attributes_PUB record types (Con_Rec_Type and Seg_Tbl_Type), which carry the context and segment data in and out of the procedures.

Usage Notes

QP_ATTRIBUTES_PVT is referenced by three other packages within the EBS codebase, consistent with its private classification. It is normally invoked indirectly: a public API such as QP_ATTRIBUTES_PUB, a pricing form, or a pricing-engine routine performs validation and then calls into the private procedures to apply the change or read the attribute set. Custom development should generally target the public API and treat QP_ATTRIBUTES_PVT as an implementation detail, since private signatures are not guaranteed to remain stable across patches. Callers should still observe the standard API contract—check x_return_status after each call and inspect x_msg_count/x_msg_data when a failure occurs—and should only request a commit through the p_commit parameter at the top level of a transaction to avoid partial commits.