Search Results tradein_lines_from_installbase

Overview

ASO_QUOTE_PUB_W is the public API surface for Oracle E-Business Suite's Oracle Quoting (ASO) module. Unlike the core ASO_QUOTE_PUB validation and business-logic layer, this package is classified in ETRM as a "rosetta wrapper" — its purpose is to translate between the PL/SQL data types used by the public API and the serialized or interface-friendly types expected by callers such as Java-based UIs, eBusiness Center integrations, and web service bridges. The package body carries a legacy header marker ($Header: asovqw1b.pls 120.9 2005/12/30) indicating it originated in the 11i-era Rosetta integration effort and has been carried forward into 12.1.1 and 12.2.2 largely unchanged.

A distinguishing characteristic of the wrapper is its handling of the special "missing" sentinel values ROSETTA_G_MISTAKE_DATE and ROSETTA_G_MISS_NUM, mapped via the rosetta_g_miss_num_map function. This allows the wrapper to reconcile FND_API.G_MISS_NUM (Oracle's standard null sentinel) with the Rosetta framework's alternative encoding, ensuring that absent values survive serialization without being misinterpreted as legitimate data.

Key Procedures and Functions

The package exposes 29 documented procedures and functions spanning the full quoting lifecycle:

• CREATE_QUOTE — the primary entry point for creating a quote header together with its lines, line details, price attributes, payments, taxes, sales credits, shipments, templates, and related objects. Its signature returns a large set of OUT NOCOPY parameters containing the newly generated primary keys for each child entity.
• UPDATE_QUOTE, DELETE_QUOTES, COPY_QUOTE, COPY_LINE — maintenance operations on existing quotes and their lines.
• SUBMIT_QUOTE — transitions a draft quote into the submitted/approved workflow.
• CREATE_QTE_OPPORTUNITY, UPDATE_OBJECT_RELATIONSHIP — manage the links between a quote and its associated sales opportunity or CRM object.
• ADD_RESOURCE, DELETE_RESOURCE — attach or detach sales resources (team members) on a quote.
• ADD_TEMPLATES_TO_QUOTE — apply document templates to an existing quote.
• GET_CONFIG_DETAILS, GET_CONFIG_LAUNCH_INFO — retrieve configuration model information for configurable items.
• GET_QUOTE_EXP_DATE — return the expiration date of a quote.
• VALIDATE_QUANTITY, CREDIT_CHECK — pre-submission validations.
• GET_DEFAULT_PARTY_SITES — resolve default ship-to/bill-to party sites.
• TRADEIN_LINES_FROM_INSTALLBASE — the procedure the user searched for; it populates trade-in quote lines by reading the customer's installed base (IB) assets, allowing Telesales/Quoting users to propose credit on returned equipment.
• SUBMIT_PRICE_TAX_REQ, CANCEL_PRICE_TAX_REQ — dispatch and cancel asynchronous pricing and tax engine requests.

Tables Accessed

The package operates against the ASO and HZ base tables via APPS synonyms:

• ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES_ALL, ASO_QUOTE_LINE_DETAILS — the quote header, line, and line-detail hierarchy.
• ASO_PRICE_ADJUSTMENTS — price adjustment/discount records attached to quote lines.
• ASO_TAX_DETAILS — tax lines generated by the tax engine.
• ASO_QUOTE_RELATED_OBJECTS — links between quotes and external CRM objects.
• HZ_PARTIES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HZ_RELATIONSHIPS — customer, site, and relationship data used for defaulting and trade-in lookups.
• PLITBLM — a legacy 11i reference table retained for backward compatibility in certain wrapper paths.

Usage Notes

ASO_QUOTE_PUB_W is not intended to be called directly from custom code on a routine basis; Oracle recommends using ASO_QUOTE_PUB for standard PL/SQL integration. The wrapper is primarily invoked by the Quoting Java UI layer, by eBusiness Center web service endpoints, and by the Oracle Telesales forms where the Rosetta type mapping is required. ETRM records zero dependent packages referencing this object, confirming its role as an integration endpoint rather than a shared library.

Because the package uses FND_API.G_MISS_DATE and G_MISS_CHAR defaults throughout its parameter lists, callers must pass explicit sentinel values rather than NULL when they intend "no change," and must be aware of the Rosetta sentinel translation performed internally. The date-sentinel constant ROSETTA_G_MISTAKE_DATE encodes Julian date 01/01/4713 BC, a value chosen to avoid collision with any legitimate transactional date. In 12.2.2 the package remains functionally identical to its 12.1.1 form, with no online patching changes affecting its callable signature.