Results for “qp_price_list_util”

50+ results




Overview
Explore in AI Chat

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

Overview

QP_PRICE_LIST_UTIL is a utility package in the APPS schema that supports the Oracle Advanced Pricing (QP) module's price list maintenance operations. It is classified as a utility (UTIL) API, meaning it is not a public interface intended for customer extension work but rather an internal helper used by other pricing packages and public APIs to perform lower-level row manipulation against price list headers, lines, qualifiers, and pricing attribute data. Its status is VALID, confirming that it compiles cleanly in the documented 12.2.2 environment. The package depends on FND_API and QP_PRICE_LIST_PUB, placing it within the standard Oracle pricing stack rather than the Oracle E-Business Suite Public API layer.

In Oracle EBS 12.1.1 and 12.2.2, this package serves as the record-level utility layer for price list entities. It abstracts the mechanics of inserting, updating, deleting, locking, and querying rows in the QP_LIST_HEADERS and related child tables, and it provides supporting routines for attribute-change propagation, language-driven lookups, and defaulting.

Key Procedures and Functions

  • CLEAR_DEPENDENT_ATTR — Clears dependent pricing attribute values when a parent attribute no longer applies, maintaining consistency across qualifier and attribute segments.
  • APPLY_ATTRIBUTE_CHANGES — Applies attribute change sets to price list records during maintenance operations.
  • COMPLETE_RECORD — Finalizes a record after insert or update, populating derived or defaulted columns.
  • CONVERT_MISS_TO_NULL — Normalizes placeholder or missing-marker values to NULL before persistence.
  • UPDATE_ROW — Updates an existing price list header or child row via the standard pricing table handler.
  • INSERT_ROW — Inserts a new price list header or child row.
  • DELETE_ROW — Removes a price list row.
  • QUERY_ROW — Retrieves a single record for display or validation.
  • LOCK_ROW — Locks a record for concurrent-safe update.
  • GET_VALUES — Returns descriptive values (translations and display attributes) for a record.
  • GET_IDS — Returns primary key identifiers for records matching the supplied criteria.
  • GET_ORIG_SYS_HDR — Retrieves the originating system header, used for multi-source price list reconciliation.

Tables Accessed

The package reads and writes through APPS synonyms. QP_LIST_HEADERS_B, QP_LIST_HEADERS_ALL_B, and QP_LIST_HEADERS_TL supply the base, all-organization, and translated header records. QP_LIST_LINES stores price list line details. QP_QUALIFIERS, QP_PRC_CONTEXTS_B, QP_PTE_SEGMENTS, QP_SEGMENTS_B, and QP_PRICING_ATTRIBUTES hold pricing qualifier context, segment, and attribute definitions used when applying attribute changes. FND_LANGUAGES provides language membership and current-language checks for GET_VALUES. These tables map directly to the insert, update, query, lock, attribute, and translation routines described above.

Usage Notes

QP_PRICE_LIST_UTIL is invoked indirectly rather than called from customer code. ETRM metadata records that it is referenced by 13 packages, including QP_PRICE_LIST_PUB, QP_LIST_HEADERS_PKG, QP_LIST_HEADERS_PVT, QP_DEFAULT_PRICE_LIST, QP_COPY_PRICELIST_PVT, QP_LOCK_PRICELIST_PVT, QP_BULK_VALIDATE, QP_BULK_EXPORT_TMP_PVT, QP_UTIL_PUB, QP_PRICE_FORMULA_UPG_UTIL_PVT, QP_PRICE_LIST_GRP, QP_QP_FORM_PRICE_LIST, and OE_PRICING_CONT_PUB. Consequently it executes during price list form interactions in the Oracle Pricing and Order Management windows, during concurrent price list copy and bulk validation programs, and during bulk export processing. Because its procedures operate at row level without performing full business validation, custom code should normally call QP_PRICE_LIST_PUB instead; QP_PRICE_LIST_UTIL should be treated as an internal dependency whose signatures may change between releases. Where direct calls are unavoidable, ensure a valid FND_API global context and appropriate locking discipline, since several routines assume the caller has already locked the target row.