Search Results aso_quote_ebizad




Overview
Explore in AI Chat

Overview

The APPS.ASO_QUOTE_EBIZAD package body is a component of the Oracle E-Business Suite (EBS) Order Capture and Oracle Quoting (ASO) module, deployed in releases 12.1.1 and 12.2.2. Its designation as an "ebizad" (E-Business adapter) object indicates that it acts as an integration adapter layer between Oracle Quoting transactional structures and external or heterogeneous data representations, most notably the PL/SQL-to-SQL and SQL-to-PL/SQL conversion routines implied by its procedure names. In the EBS architecture, adapter packages mediate between the strongly typed PL/SQL record and table structures of the public ASO_QUOTE_PUB API and the flat, column-oriented results required by SQL-based consumers, BI extracts, and Web/Java integration layers.

The package is documented with a status of VALID and is owned by the APPS schema. It is not referenced by any other database object, confirming that it is a terminating integration artifact rather than an internal utility called elsewhere in the quoting stack.

Key Procedures and Functions

The ETRM documentation records 72 procedures and functions, of which the following conversion routines are explicitly named:

  • PL_TO_SQL0 through PL_TO_SQL6 — A family of overloads that transform PL/SQL data structures (records and collection types) into SQL-compatible scalar or relational output. These are the outbound direction of the adapter.
  • PL_TO_SQL19, PL_TO_SQL20, PL_TO_SQL21, PL_TO_SQL22, PL_TO_SQL23 — Additional numbered variants within the same conversion family, corresponding to the many distinct quote entity types (line detail, price attributes, freight charges, sales credits, tax details, payment terms, and so on) defined in ASO_QUOTE_PUB.
  • SQL_TO_PL0 through SQL_TO_PL5 — The inbound direction, reconstructing PL/SQL records and tables from SQL result sets.
  • SQL_TO_PL20, SQL_TO_PL21, SQL_TO_PL22, SQL_TO_PL23 — Inbound overloads associated with the higher-numbered entity types.

The numeric suffixes correspond directly to the ASO_QUOTE_PUB type definitions the package depends upon, including ASO_QUOTE_PUB_CONTROL_REC_TYP, ASO_QUOTE_PUB_LINE_ATTRIBS_EX, ASO_QUOTE_PUB_QTE_LINE_DTL_REC, ASO_QUOTE_PUB_PRICE_ADJ_REC_T, ASO_QUOTE_PUB_SHIPMENT_REC_TY, ASO_QUOTE_PUB_TAX_DETAIL_REC, and ASO_QUOTE_PUB_PAYMENT_REC_TYP, among others.

Tables Accessed

The only documented table reference is PLITBLM, accessed via an APPS synonym. PLITBLM is a standard EBS PL/SQL-interface helper table used to stage and shuttle table-structured data between PL/SQL and SQL execution contexts; the adapter package uses it as the transport mechanism for its conversion routines. No base ASO transactional tables (for example ASO_QUOTE_HEADERS_ALL) are listed as directly referenced, because all quote data is passed in and out through the ASO_QUOTE_PUB typed parameters rather than by direct DML.

Usage Notes

This package is an internal integration utility. It is not intended to be called from Oracle Forms or from standard concurrent programs; no concurrent program or form dependency is documented. It is invoked indirectly by the Oracle Quoting public API layer (ASO_QUOTE_PUB) whenever quote data must be exchanged with SQL-based consumers, and its dependency list includes FND_API, FND_MSG_PUB, and PO_MOAC_UTILS_PVT, indicating that it participates in the standard EBS API error-handling and message-framework conventions. Customizations should avoid modifying this adapter directly; the supported extension point remains the ASO_QUOTE_PUB public API.