Search Results update_pricing_phase

Overview

QP_DELAYED_REQUESTS_UTIL is a utility package in the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite, owned by APPS and classified by ETRM as a utility (UTIL) API. Its business purpose is to support the creation, validation, and maintenance of pricing entities that cannot be resolved in a single pass — list headers and lines, price breaks, qualifiers, and modifier attributes — by deferring or re-executing dependent processing. The package is particularly relevant to bulk import, upgrade, and concurrent maintenance of price lists, discount lists, and modifiers, where line-level qualification flags, pricing phases, and break structures must remain internally consistent. The presence of UPDATE_PRICING_PHASE and UPDATE_PRICING_ATTR_PHASE confirms that the package performs direct DML against the pricing phase configuration, which is why it is a common search target for practitioners investigating how pricing phase assignments are changed programmatically. The package follows the standard EBS API conventions, returning status through FND_API.G_RET_STS_SUCCESS and G_RET_STS_ERROR and emitting messages via OE_MSG_PUB and FND_MESSAGE.

Key Procedures and Functions

The documented interface exposes 37 procedures and functions. They fall into several functional groups.

• Duplicate and conflict detection: CHECK_FOR_DUPLICATE_QUALIFIERS, CHECK_DUPLICATE_MODIFIER_LINES, CHECK_DUPLICATE_LIST_LINES, CHECK_MULTIPLE_PRL, CHECK_MIXED_QUAL_SEG_LEVELS, CHECK_FOR_OVERLAPPING_BREAKS, CHECK_CONTINUOUS_PRICE_BREAKS, and CHECK_MULT_PRICE_BREAK_ATTRS validate that qualifier combinations, modifier lines, list lines, price break ranges, and segment levels do not overlap or duplicate one another.
• Phase and attribute maintenance: UPDATE_PRICING_PHASE, UPDATE_PRICING_ATTR_PHASE, and MAINTAIN_LIST_HEADER_PHASES manage the assignment of pricing phases to list headers and pricing attributes. UPDATE_MANUAL_MODIFIER_FLAG sets or clears the manual modifier indicator.
• Qualification and limit maintenance: UPDATE_LIST_QUALIFICATION_IND, UPDATE_LINE_QUALIFICATION_IND, MAINTAIN_QUALIFIER_DEN_COLS, and UPDATE_LIMITS_COLUMNS maintain qualification indicators, qualifier denominator columns, and limit-related columns on pricing records.
• Structural maintenance and upgrade: VALIDATE_LINES_FOR_CHILD, UPDATE_CHILD_BREAK_LINES, UPGRADE_PRICE_BREAKS, and MAINTAIN_FACTOR_LIST_ATTRS manage parent-child line relationships, break line propagation, price break upgrades, and factor list attributes.

The excerpt from the package body illustrates the coding pattern: CHECK_FOR_DUPLICATE_QUALIFIERS opens an explicit cursor over QP_QUALIFIERS performing a self-join on qualifier_rule_id, qualifier_grouping_no, qualifier_context, and qualifier_attribute, and raises the DUPLICATE_DISCOUNT exception when a duplicate is found. On detection it sets x_return_status to FND_API.G_RET_STS_ERROR, conditionally registers the ONT message OE_DIS_DUPLICATE_LIN_DISC through FND_MESSAGE and OE_MSG_PUB at error message level, and re-raises the exception. Debug tracing is emitted through OE_DEBUG_PUB. This confirms the package is defensive: it does not silently correct conflicting data but reports it to the caller for resolution.

Tables Accessed

The package reads and writes the core Advanced Pricing dictionary tables. QP_LIST_HEADERS and QP_LIST_HEADERS_B supply list header and header translation records; QP_LIST_LINES holds the pricing lines that qualification indicators, child break lines, and duplicate checks operate upon. QP_LIST_HEADER_PHASES and QP_PRICING_PHASES store phase assignments, while QP_PRICING_ATTRIBUTES and QP_PRC_CONTEXTS_B supply pricing attribute and context definitions used when phases are updated. QP_QUALIFIERS stores qualifier rows validated for duplicates and mixed segment levels. QP_LIMITS and QP_LIMIT_ATTRIBUTES support limit column maintenance. QP_PTE_SEGMENTS and QP_PTE_SOURCE_SYSTEMS relate to price type entity segmentation and source systems. QP_ADV_MOD_PRODUCTS, QP_CURRENCY_DETAILS, and QP_RLTD_MODIFIERS cover advanced modifier products, currency detail, and related modifier relationships.

Usage Notes

QP_DELAYED_REQUESTS_UTIL is an internal utility rather than a user-facing API. It is invoked from Advanced Pricing forms and concurrent programs during price list creation, modifier setup, and price break maintenance, and it is referenced by one other package in the ETRM inventory, indicating callers depend on its procedures rather than end users. Because it contains direct update procedures such as UPDATE_PRICING_PHASE and UPDATE_PRICING_ATTR_PHASE, customizations that call it must set up the FND_API return status convention and must not bypass the validation procedures that precede the updates. Callers should always inspect x_return_status after each invocation, since the package reports duplicate and overlap conditions as errors rather than raising unhandled exceptions, except where it deliberately propagates exceptions such as DUPLICATE_DISCOUNT. Oracle recommends using it only through supported flows in 12.1.1 and 12.2.2, as the underlying logic is version-specific and may change between patch levels.