Search Results fetch_list_price

Overview

APPS.CZ_OM_LIST_PRICE is a server-side PL/SQL package body residing in the APPS schema that belongs to the Oracle Configurator / Oracle Order Management pricing integration layer. Its business purpose in Oracle EBS 12.1.1 and 12.2.2 is to resolve a list price for a configured item or service at the moment an order line is priced. Within the Configurator and Order Management flow, list price is a foundational input: it anchors the pricing engine before modifiers, discounts, surcharges, and qualifiers are applied. The package encapsulates the logic that retrieves the published price list value, the associated list price percent, and the rounding factor needed to normalize the returned numeric values.

Notably, in the shipped code the body is a stub. The header comment identifies the file as czomlprb.pls 115.9, dated 2002/12/03. The single procedure sets p_return_status to the error constant and returns the literal message "Stubbed procedure", indicating the production implementation is either delivered separately or replaced by customer-specific logic. This is a common pattern in older Configurator-adjacent modules where a stable public interface is published while the implementation is deferred to a later patch or intended to be extended.

Key Procedures and Functions

• FETCH_LIST__PRICE — The only documented procedure in the package. Its purpose is to fetch the list price information for a given item, price list, and pricing context, returning the resolved list price along with the list percent, rounding factor, and the pricing method code actually used. The procedure exposes a broad input surface covering the price list identifier, inventory item, unit of measure code, service duration, item type code, pricing method code, fifteen generic pricing attributes, a base price, a pricing date, and a configurable number of fetch attempts. Calibration of these inputs allows the caller to request price resolution under a specific pricing date and attribute combination, which matters when price lists carry effective-date ranges and attribute-based eligibility. Output is returned through flexibly typed OUT parameters together with a return status and message data pair, following the standard EBS API error-handling convention.

The wide OUT parameter set (list price, list percent, rounding factor, and outbound pricing method code) reflects the requirement that downstream pricing arithmetic know not just the price but how it was derived and how it should be rounded.

Tables Accessed

The documented ETRM metadata for this package lists no concrete base tables referenced through APPS synonyms. This is consistent with the stubbed body, which performs no DML or queries at all. In a completed implementation, the procedure would be expected to read the Oracle Advanced Pricing list price structures — most plausibly QP_LIST_HEADERS, QP_LIST_LINES, and related pricing attribute tables — to resolve the effective list price for the supplied item and date. Because no table references are documented, integrations should not assume any specific table dependency and should treat the object strictly through its declared API surface.

Usage Notes

The package is classified under API classification OTHER and is referenced by zero other packages in the documented metadata, meaning it is a leaf dependency rather than a shared utility. It is typically invoked from Order Management pricing flows, Configurator-related extensions, or custom code that needs to obtain a list price without directly querying Advanced Pricing tables. Callers should check p_return_status before consuming the OUT values; with the stub in place, any invocation returns the error status and the "Stubbed procedure" message, so production extensions relying on this API must supply or enable a functional implementation. In 12.1.1 and 12.2.2 the calling convention is unchanged, and because the body performs no work as shipped, this object should be treated as an extension point rather than a ready-to-use pricing service.