Search Results aso_validate_pricing_pvt




Overview
Explore in AI Chat

Overview

ASO_VALIDATE_PRICING_PVT is a private PL/SQL package in the Oracle E-Business Suite Order-to-Cash (ASO) application, owned by the APPS schema and classified under the PVT (private) API convention. Its declared purpose is to perform server-side validation of pricing data for Oracle Quoting (Oracle Sales Online / ASO) quotations and orders before those records are committed to the database. The package is defined with AUTHID CURRENT_USER, meaning that its SQL statements execute with the privileges of the invoking user rather than the owner.

The package header carries a low version stamp (120.1, dated 29 June 2005), indicating that it belongs to the original Oracle 11i-era Quoting pricing validation infrastructure that was carried forward unchanged into Release 12.1.1 and 12.2.2. Architecturally, it sits behind the public pricing interfaces (notably ASO_PRICING_INT and ASO_QUOTE_PUB) and applies business rules to quote headers, lines, line details, shipments, and price attributes prior to persistence.

Key Procedures and Functions

The ETRM metadata documents exactly one program unit in this package:

  • Validate_Pricing_Order — The single documented procedure. It accepts an API version number, an initialization flag for the message list, a commit flag, a pricing control record, and full quote header, shipment, price attribute, quote line, line relationship, line detail, and line shipment structures as input, together with corresponding output structures that return the validated header, lines, line details, price adjustments, price adjustment attributes, and price adjustment relationships. Based on the standard ASO private API pattern, it validates the supplied pricing order data and returns the validated collections and adjustment results through its OUT parameters, along with the standard return status, message count, and message data outputs (x_return_status, x_msg_count, x_msg_data) used by all FND-style APIs.

No other procedures or functions are documented in the package header.

Tables Accessed

The documented table reference for this package is PLITBLM, an APPS synonym in the Oracle EBS schema. PLITBLM is a materialized view or table used by the pricing and list-price calculation layer of Oracle Advanced Pricing that ASO depends on. In the validation flow, Validate_Pricing_Order reads from this table to resolve and confirm pricing list information when checking that quoted prices are consistent with established price lists, and to support the price adjustment logic that produces the adjustment output collections.

Usage Notes

ASO_VALIDATE_PRICING_PVT is a private package and is not intended to be called directly from customer extensions. It is invoked internally by the public ASO pricing and quoting APIs, and the metadata records that it is referenced by two other packages, which are the typical callers. It is therefore reached indirectly from the Oracle Quoting application UI (the quote and order entry forms), from pricing validation logic triggered during quote submission or order capture, and from any concurrent program or custom code that calls the public ASO pricing APIs such as ASO_PRICING_INT. Because the API version and message list parameters default to the FND_API standard values, callers that do invoke it programmatically are expected to supply an explicit API version and to inspect x_return_status and the message stack to handle validation failures.