Search Results process_price_list

Overview

QP_LIST_HEADERS_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle Advanced Pricing price list and modifier infrastructure. Its classification as a PVT package indicates that it is not intended to be called directly by external consumers; instead it exposes the internal processing logic that underpins the public APIs, most notably QP_PRICE_LIST_PUB, on which it depends. The package operates against the header records of pricing entities stored in QP_LIST_HEADERS_B and the associated lines, qualifiers, and related modifier records, providing the routines required to validate, lock, retrieve, and process list headers throughout the pricing lifecycle.

In Oracle EBS 12.1.1 and 12.2.2, this package participates in both Online and concurrent processing paths for price lists and modifiers, including import, upgrade, bulk maintenance, and attribute defaulting operations. It is closely related to the companion public package QP_PRICE_LIST_PUB and to utility packages such as QP_UTIL, QP_SECURITY, and the QP_DEFAULT_* family referenced in the dependency list.

Key Procedures and Functions

The ETRM documentation records three procedures or functions within QP_LIST_HEADERS_PVT. Parameter signatures are not published in the metadata and are therefore not reproduced here.

• PROCESS_PRICE_LIST — The principal worker routine, responsible for applying the business logic that transforms or persists a price list header as part of a larger transaction. It is typically invoked by the public pricing APIs and by concurrent request processes rather than by end users directly.
• LOCK_PRICE_LIST — Acquires the concurrency control required to prevent conflicting updates to a price list header during processing. This supports the locking protocol expected by the public API layers so that validation and update steps execute consistently.
• GET_PRICE_LIST — Retrieves price list header information for downstream use. It serves as the internal accessor providing header attributes and related context to the other routines in the package and to its public callers.

These three routines constitute the documented interface of the package. All depend on the standard FND_API, FND_GLOBAL, FND_MESSAGE, and FND_PROFILE facilities for API return status, session context, messaging, and profile option retrieval.

Tables Accessed

The package reads and writes data in the core Advanced Pricing schema tables, accessed through APPS synonyms. QP_LIST_HEADERS_B holds the base-table header records for price lists and modifiers and is the focal point of the package. QP_LIST_LINES stores the price list lines or modifier lines attached to those headers. QP_QUALIFIERS holds qualifier definitions used to determine applicability. QP_RLTD_MODIFIERS and its sequence QP_RLTD_MODIFIERS_S maintain relationships between modifier list headers. DUAL is used for singleton SQL expressions, and PLITBLM is a PL/SQL index-by table type referenced from the STANDARD package specification. The presence of these tables confirms that the package operates on header, line, qualifier, and modifier-relationship data as a coordinated set.

Usage Notes

Because QP_LIST_HEADERS_PVT is an internal package body, it is not called from Oracle Forms or custom code directly. It is invoked indirectly through the public pricing APIs, such as QP_PRICE_LIST_PUB, and through the concurrent programs that perform price list import, copy, upgrade, and attribute regeneration. The dependency metadata further shows that it is referenced by ten other packages but does not itself reference any database object as a calling dependency, which is consistent with a lower-level internal component whose callers sit above it in the call stack. Developers customizing pricing behavior should extend the public APIs or use supported hooks rather than calling this private package directly, as its interface may change between maintenance releases.