Results for “qp_price_list_pub”

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

Overview

QP_PRICE_LIST_PUB is a public PL/SQL API in the Oracle Advanced Pricing module (schema APPS) whose purpose is to expose price list maintenance and query operations to external callers. In Oracle E-Business Suite 12.1.1 and 12.2.2, price lists are the master containers in which pricing lines, qualifiers, and modifier relationships are organized. Rather than interacting directly with the underlying tables, callers invoke QP_PRICE_LIST_PUB, which wraps the corresponding private implementation package, QP_PRICE_LIST_UTIL, and returns structured API results. The package follows the standard Oracle EBS API pattern: it leverages FND_API for its return status, FND_MESSAGE for user-facing error text, and OE_MSG_PUB and OE_DEBUG_PUB for message and debug handling. Its classification as a PUB package means the procedures are intended for supported, external invocation by forms, concurrent programs, and custom extensions.

Key Procedures and Functions

The package body documents three public entry points:

• PROCESS_PRICE_LIST — The primary transactional procedure. It drives creation, update, and deletion of a price list header together with its associated list lines. Internally it delegates to QP_LIST_HEADERS_PVT and QP_LIST_HEADERS_B for header persistence and to QP_PRICE_LIST_LINE_UTIL for line-level processing, applying the standard API commit and validation logic. It is the routine most commonly called by integration and bulk-loading programs.
• LOCK_PRICE_LIST — Obtains a logical lock on a price list record so that concurrent updates cannot corrupt header or line data. Locking is applied before a modification sequence, mirroring the locking conventions used elsewhere in Advanced Pricing.
• GET_PRICE_LIST — Retrieves price list header and line information for a given price list, returning the data through OUT parameters. It is the read-side counterpart to PROCESS_PRICE_LIST and is used by enquiry screens and downstream processes that need validated price list details.

No parameter lists are reproduced here; the interface definitions reside in the package specification (QP_PRICE_LIST_PUB) and should be referenced when coding against the API.

Tables Accessed

The package operates against three documented tables, resolved through APPS synonyms:

• QP_LIST_HEADERS_B — Stores price list header records (name, currency, effective dates, and related attributes). PROCESS_PRICE_LIST and GET_PRICE_LIST read and write this table through QP_LIST_HEADERS_B and QP_LIST_HEADERS_PVT.
• QP_LIST_LINES — Stores the individual price list lines belonging to a header. Line inserts, updates, and deletions are handled via QP_PRICE_LIST_LINE_UTIL and QP_PRICE_LIST_UTIL, which in turn resolve identifiers using QP_VALUE_TO_ID.
• PLITBLM — A PL/SQL index-by table type used internally for bulk processing and parameter passing within the pricing APIs, notably in mass-maintenance operations driven by QP_MOD_LOADER_PUB and QP_PRL_LOADER_PUB.

Usage Notes

QP_PRICE_LIST_PUB is typically invoked from the Oracle Pricing Setup and Price List windows, from concurrent programs that mass-maintain price lists, and from custom PL/SQL integrations that require supported price list maintenance. The API honors Multi-Org security through MO_GLOBAL and reads environment settings via FND_PROFILE, so callers must ensure the correct operating unit context is initialized. Because the package is referenced by thirty-three other database objects, changes to its specification can have wide-ranging impact; extensions should consume the published API rather than modifying the package. Error handling should follow the standard FND_API convention of checking the return status and retrieving messages via FND_MESSAGE, and debug output can be enabled through OE_DEBUG_PUB when diagnosing processing failures. Related qualifier and modifier logic is exposed separately through QP_QUALIFIER_RULES_PUB and QP_QUALIFIERS_UTIL.