Search Results aso_quote_pub_w




Overview
Explore in AI Chat

Overview

ASO_QUOTE_PUB_W is the public, wrapper-layer PL/SQL package within the Oracle E-Business Suite Order-to-Cash (ASO) schema that exposes the core Quote Management business API for external invocation. It resides in the APPS schema, holds a VALID status, and is classified under the ETRM as an "OTHER" API type. Its principal role is to provide a stable, callable interface for creating, modifying, submitting, and copying sales quotes and their associated lines, resources, and related objects, while delegating the underlying transactional processing to the internal quotation engine. The "_W" suffix denotes the wrapper variant of the ASO_QUOTE_PUB package family, meaning it encapsulates the primary API and shields consumers from internal implementation changes across releases such as 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes approximately 29 documented procedures and functions. The principal entry points include:

Tables Accessed

The package operates against ASO and HZ tables through APPS synonyms. Quote header and line data are persisted in ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL, with extended line attributes in ASO_QUOTE_LINE_DETAILS. Pricing adjustments are recorded in ASO_PRICE_ADJUSTMENTS, tax computations in ASO_TAX_DETAILS, and cross-object associations in ASO_QUOTE_RELATED_OBJECTS. Customer and site data are sourced from HZ_PARTIES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, and HZ_RELATIONSHIPS. The PLITBLM table stores multiline (CLOB) text associated with quotes. The package further depends on FND_API and the JTF collection types (JTF_DATE_TABLE, JTF_NUMBER_TABLE, and the JTF_VARCHAR2_TABLE_n collections), which are used for array-based parameter passing and standard API error handling.

Usage Notes

ASO_QUOTE_PUB_W is typically invoked from Oracle Quoting forms, from concurrent programs that process or refresh quotes, and from custom PL/SQL extensions that must create or manipulate quotes programmatically. It is not referenced by any other documented package, confirming its position as a top-level public API rather than an internal dependency. Callers should observe standard FND_API conventions, including initialization of the error and message stacks, and should respect the transactional boundaries established by the wrapper. Because the wrapper delegates to underlying quote processing logic, all quote validations, pricing, and tax request handling flow through the routines listed above.