Search Results create_quote_service

Overview

ASO_QUOTE_EBIZAD is a public PL/SQL package in the APPS schema belonging to the Order Capture (ASO) product. Its purpose is to provide a thin wrapper around the core service procedure ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE, exposing that service for invocation from the Oracle Applications Adapter. The Oracle Applications Adapter communicates through SQL object types rather than PL/SQL record types, so this package bridges the two type systems. It defines conversion functions that transform SQL object type instances into their PL/SQL record equivalents, and vice versa, so that the underlying business logic in ASO_QUOTE_PUB remains unchanged while being callable from integration middleware.

The package is declared with AUTHID CURRENT_USER and is classified as an "active" public API in the ETRM repository, with compatibility level S. Its header identifies it as the "Order Capture" displayable object under the ASO_QUOTE business entity. The package contains 72 documented procedures and functions, indicating a comprehensive set of type-conversion helpers surrounding the single service entry point.

Key Procedures and Functions

The documented program units fall into two families. The PL_TO_SQL* functions convert PL/SQL record types into SQL object types, while the SQL_TO_PL* functions perform the reverse conversion, from SQL object types into PL/SQL record types. Both families are numbered sequentially (for example PL_TO_SQL0 through PL_TO_SQL23 and SQL_TO_PL0 through SQL_TO_PL23), reflecting the many composite parameter structures required by the quote creation service.

• CREATE_QUOTE_SERVICE — the primary entry point. It accepts SQL object types as parameters, converts them to PL/SQL records, invokes ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE, and converts the returned PL/SQL records back into SQL object types.
• PL_TO_SQL* functions — convert individual PL/SQL record structures (control, header, pricing attributes, payment, shipment, freight charges, tax detail, line attributes, sales credits, and quote party) into SQL object types.
• SQL_TO_PL* functions — convert the corresponding SQL object types back into PL/SQL records, used both for input preparation and for translating service output.

Because the metadata documents only the names of these helpers, the precise parameter lists should not be assumed; each function maps one composite type to its counterpart.

Tables Accessed

The only documented table referenced through APPS synonyms is PLITBLM. This table is not part of the quote business data model; it is a generic infrastructure table commonly used in EBS for handling PL/SQL table or collection conversions. Its presence here is consistent with the package's role as a type-conversion and adapter layer, where collections must be materialized or iterated. All substantive quote persistence is performed by the underlying ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE logic rather than by this wrapper. No direct inserts or updates to quote headers or lines are attributed to ASO_QUOTE_EBIZAD itself.

Usage Notes

This package is invoked by the Oracle Applications Adapter when an external system needs to create a quote through the standard Order Capture service. It is not intended for direct use by Oracle Forms, concurrent programs, or ordinary custom code; those callers should use ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE directly. The wrapper exists specifically to satisfy the Adapter's requirement for SQL object type interfaces. The metadata records zero packages referencing ASO_QUOTE_EBIZAD, confirming its role as an external integration boundary rather than an internal dependency. Available in both 12.1.1 and 12.2.2, the package should be treated as a stable public API whose interface is tied to the SQL object types it exposes.