Results for “cz_prc_callback_util”

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

Overview

The APPS.CZ_PRC_CALLBACK_UTIL package is a utility package within the Oracle E-Business Suite configuration and pricing framework. It provides the supporting infrastructure for pricing callback processing, which is the mechanism by which Oracle Configurator and Order Management invoke pricing logic when a configured item is instantiated, validated, or repriced. The package status is VALID in the APPS schema, and its classification as a utility package indicates that it is not called directly by end users but rather serves as a shared service layer consumed by higher-level configuration and pricing modules.

In practical terms, the package bridges the gap between the Configurator runtime and the pricing engine. When a user configures an item through Oracle Configurator, the system must determine the applicable price for the resulting configuration, including any option-dependent price adjustments. This package supplies the routines that build and maintain the temporary pricing structures used during that evaluation, then hand control to the appropriate pricing callback routine.

Key Procedures and Functions

• INSERT_PRICING_TABLE — Inserts data into the pricing structure table, establishing the set of components and pricing records that the callback will process.
• INSERT_PRICING_REC — Inserts a single pricing record, allowing incremental construction of the pricing data set.
• DELETE_PRICING_RECS — Clears previously inserted pricing records, providing a housekeeping routine so that stale pricing data does not persist across callback invocations.
• RUN_PRICING_CALLBACK — The primary driver routine; it executes the pricing callback logic against the prepared pricing data.
• RUN_MLS_PRICING_CALLBACK — The multi-lingual (MLS) variant of the callback runner, used where language-specific pricing or descriptive elements must be resolved.
• ROOT_BOM_CONFIG_ITEM_ID — Returns the root bill of materials configuration item identifier, used to anchor a configured structure to its top-level item.

Tables Accessed

Two tables are documented as being referenced through APPS synonyms:

• CZ_PRICING_STRUCTURES — Stores the pricing structure records associated with configured items. The insertion and deletion procedures operate against this table, which serves as the working store for pricing data during callback processing.
• PLITBLM — A standard EBS multilingual table used in conjunction with the MLS pricing callback to resolve language-specific values.

The package also depends on the CZ_PRICE_TBL_TYPE collection type, which defines the PL/SQL table structure used to pass pricing data among the routines.

Usage Notes

This package is referenced by three higher-level packages: ASO_CFG_INT, ASO_CFG_PUB, and OE_CONFIG_PRICE_UTIL. These represent the Configurator integration and public APIs and the Order Management configuration pricing utility, respectively. Invocation therefore occurs indirectly, when configuration pricing is triggered from the Configurator UI, from Order Management order entry forms during configuration validation, or from concurrent or custom code that drives configuration pricing programmatically.

Because the procedures operate on shared temporary pricing structures, callers must sequence them correctly: clear existing records with DELETE_PRICING_RECS, populate the structures through the insert routines, resolve the root configuration item, and then invoke the appropriate callback runner. Customizations should avoid calling these routines directly where an owning API such as ASO_CFG_PUB is available, since that API manages the surrounding transaction and cleanup context. Direct use is generally limited to diagnostics or to extensions that already participate in the Configurator pricing flow.