Results for “pre_write_process”

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

Overview

QP_PLL_PRICING_ATTR_UTIL is a utility PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an internal API supporting the Advanced Pricing module. Its central business function is to manage the pricing attributes — the qualifier context values that determine which price list lines, modifiers, and qualifiers apply to a given transaction line — associated with price list headers. In practice, the package centralizes the low-level create, read, update, delete, and locking logic for the QP_PRICING_ATTRIBUTES records that a price list header maintains. This abstraction allows the public pricing APIs and the Price List Setup form to manipulate pricing attributes consistently without duplicating DML and validation logic.

Because the package is shared by the public pricing API layer (QP_PRICE_LIST_PUB) and by multiple internal processing units, it acts as the common persistence gateway for pricing attribute data across interactive setup, bulk maintenance, and transactional pricing flows.

Key Procedures and Functions

The package exposes thirteen documented units that fall into several functional groups:

• Row persistence: INSERT_ROW, UPDATE_ROW, and DELETE_ROW perform the core DML against pricing attribute records. COMPLETE_RECORD and PRE_WRITE_PROCESS supply the defaulting, derivation, and pre-save processing that ensure a record is complete and valid before it is committed.
• Query and retrieval: QUERY_ROW returns a single pricing attribute record, QUERY_ROWS returns a set of records, and GET_VALUES and GET_IDS retrieve decoded attribute values and their associated identifiers for a given context or segment combination.
• Concurrency control: LOCK_ROW obtains a row-level lock to protect a record against concurrent modification during interactive or batch processing.
• Attribute change management: APPLY_ATTRIBUTE_CHANGES and CLEAR_DEPENDENT_ATTR propagate or reset dependent attribute values when a context or qualifier structure changes, ensuring the pricing attribute hierarchy remains internally consistent. CONVERT_MISS_TO_NULL normalizes missing (MISS) values to NULL as part of the same consistency effort.

The package depends on FND_API for standard API conventions and on QP_PRICE_LIST_PUB, indicating it is invoked beneath the public price list interface.

Tables Accessed

All tables are touched through APPS synonyms. QP_PRICING_ATTRIBUTES is the primary target and stores the pricing attribute records themselves. QP_LIST_HEADERS_ALL_B and QP_LIST_LINES hold price list header and line definitions that the attributes qualify. QP_PRC_CONTEXTS_B, QP_SEGMENTS_B, and QP_PTE_SEGMENTS define the pricing context and segment structure used to validate and resolve attributes, while QP_RLTD_MODIFIERS links qualifiers to modifiers. PLITBLM is the pricing list temporary table used in bulk and interface processing. Together these tables allow the utility to resolve attribute values against the pricing context model and to persist them against price list headers and lines.

Usage Notes

QP_PLL_PRICING_ATTR_UTIL is not a customer-facing API; it is invoked indirectly. The Price List Setup form calls it through QP_QP_FORM_PLL_PRICING_ATTR and QP_PLL_PRICING_ATTR_UTIL dependencies, while the public API entry point QP_PRICE_LIST_PUB delegates the pricing attribute maintenance work to it. Bulk maintenance and migration paths route through QP_BULK_VALIDATE, QP_BULK_EXPORT_TMP_PVT, and QP_DEFAULT_PLL_PRICING_ATTR. Pricing and order capture flows reach it via OE_PRICING_CONT_PUB. Because it is referenced by nine packages, customizations should not call it directly; developers requiring pricing attribute maintenance should use QP_PRICE_LIST_PUB or the supported forms, and treat this package as internal. Users searching for "qp_price_list_pub" should note that QP_PLL_PRICING_ATTR_UTIL is the underlying utility invoked by that public API.