Search Results validate_line_tradein

Overview

ASO_TRADEIN_PVT is a private PL/SQL package in the APPS schema that supports trade-in processing within the Oracle E-Business Suite Order-to-Cash flow. Trade-in functionality allows a customer to apply the residual value of an existing item, typically tracked through Oracle Installed Base, as a credit against a new sales order or a new quote line. In the context of Oracle Quoting, this package underpins the logic that identifies eligible installed base instances, converts them into trade-in lines on a quote, and validates the quantity and order-type relationships associated with those lines.

The package is classified as a PVT (private) API, meaning it is not intended as a public integration surface and should be invoked only by other Oracle Application Object Library packages within the ASO (Oracle Quoting) module. The ETRM metadata confirms a VALID status, indicating the compiled package is syntactically sound and available in the 12.1.1 and 12.2.2 instances.

Its direct dependencies include ASO_QUOTE_HEADERS_PVT, ASO_QUOTE_PUB, and FND_API, while it is referenced by ASO_QUOTE_HEADERS_PVT, ASO_QUOTE_LINES_PVT, and the ASO_QUOTE_PUB_W wrapper. This dependency pattern places ASO_TRADEIN_PVT squarely beneath the public quoting APIs, providing internal trade-in validation and line-generation services rather than exposing a callable interface of its own.

Key Procedures and Functions

The package exposes five documented programs, each addressing a discrete aspect of trade-in processing:

• VALIDATE_LINE_TRADEIN — Validates that a given quote or order line qualifies as a trade-in line, checking the associated data against trade-in business rules before the line is accepted or committed.
• ORDERTYPE — Derives or returns the order type context relevant to the trade-in transaction, ensuring the line is processed under the correct order category.
• LINETYPE — Derives or returns the line type applicable to the trade-in line, distinguishing trade-in lines from standard quoted or ordered items.
• ADD_LINES_FROM_INSTALLBASE — Creates trade-in lines on the quote from qualifying records in Oracle Installed Base, transferring item instance data into ASO quote structures.
• VALIDATE_IB_RETURN_QTY — Validates the return quantity for an installed base item against the quantity available to be traded in, preventing over-return of a given instance.

The private nature of the package means these procedures are called indirectly through ASO_QUOTE_PUB and ASO_QUOTE_HEADERS_PVT rather than directly by end users or external applications.

Tables Accessed

ASO_TRADEIN_PVT reads and writes the following documented tables through APPS synonyms:

• ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES_ALL, ASO_QUOTE_LINE_DETAILS, ASO_LINE_RELATIONSHIPS — The core quoting tables where trade-in lines and their relationships to parent lines are stored.
• CSI_ITEM_INSTANCES, CSI_II_RELATIONSHIPS — Oracle Installed Base tables that identify the customer's existing items eligible for trade-in and their relationship hierarchy.
• MTL_SYSTEM_ITEMS_B — Provides item master attributes required for validation and line creation.
• OE_ORDER_LINES_ALL — Supports order-line references where trade-in lines intersect with the order capture model.
• PLITBLM — The PL/SQL item index table used for passing arrays of line identifiers between internal routines.

Usage Notes

This package is invoked indirectly. Oracle Quoting forms and the public ASO_QUOTE_PUB API call ASO_QUOTE_HEADERS_PVT and ASO_QUOTE_LINES_PVT, which in turn delegate trade-in validation and line generation to ASO_TRADEIN_PVT. Customizations should not call ASO_TRADEIN_PVT directly; the supported integration point is ASO_QUOTE_PUB. Organizations extending trade-in behavior should wrap the public API rather than modify this private package, preserving upgrade safety across 12.1.1 and 12.2.2. As with all PVT packages, signature changes can occur between releases without prior notice.