Search Results create_repurchase_quote




Overview
Explore in AI Chat

Overview

OKL_AM_REPURCHASE_ASSET_PUB is a public API package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It exposes a stable, callable interface over the private implementation package OKL_AM_REPURCHASE_ASSET_PVT, and its business purpose is to support the repurchase of leased assets. In the leasing lifecycle, a lessee may return an asset, or the lessor may exercise an end-of-term repurchase or residual-value option. This package creates and maintains the quote structures that capture the terms, quantities, pricing, and value information associated with a repurchase transaction so that downstream asset management, contract, and accounting processes can consume them. The public/private architecture is a deliberate Oracle construct: callers interact only with the PUB layer, allowing Oracle to change the underlying PL/SQL implementation without breaking customer code. The header comment indicates the file is under configuration management (OKLPRQUB.pls) and carries a "noship" designation, meaning it is an internal, unshipped component not exposed as supported customization surface.

Key Procedures and Functions

The documented API surface consists of two procedures; the excerpt above details the first of these, which is the object the user searched for.

  • CREATE_REPURCHASE_QUOTE — Creates a repurchase quote. The procedure receives standard Oracle API control parameters (initialization message list, return status, message count, message data) together with an input quote entity record and an input collection of quote value records. It returns the corresponding output quote entity record and output value table. The implementation follows the canonical Oracle API pattern: it opens a savepoint, internally delegates to OKL_AM_REPURCHASE_ASSET_PVT.create_repurchase_quote, checks the returned status against FND_API.G_RET_STS_ERROR and FND_API.G_RET_STS_UNEXP_ERROR, and raises the matching FND_API exceptions. On error it rolls back to the savepoint, then assigns the local status, message count, and message data to the OUT parameters before returning.
  • UPDATE_REPURCHASE_QUOTE — Modifies an existing repurchase quote, following the same delegation-to-private-package and exception-handling convention as the create procedure.

Tables Accessed

The supplied metadata does not enumerate the underlying tables referenced through APPS synonyms; no table list is documented for this object. Based on the OKL data model, the package operates on the repurchase quote entity and its associated quote value records — the structures represented by the incoming and outgoing quote entity records and value tables — which correspond to the OKL quote tables that store repurchase quote headers and their associated quantity/value lines. Because the documented evidence does not confirm specific table names, precise table identification should be verified against the installed OKL schema version.

Usage Notes

This package is the supported entry point for any custom or extension code that must create or change repurchase quotes; direct calls to OKL_AM_REPURCHASE_ASSET_PVT are not sanctioned. Within standard EBS flows it is typically invoked from the Repurchase/End-of-Term processing UI, from the OKL forms layer, or from concurrent programs and workflow activities that process returning and repurchased assets. The dependency metadata shows the package is referenced by three other packages, confirming it sits within a broader call chain rather than being called only from the UI. Callers should follow the standard API contract: supply a version number in the API version parameter, initialize the message list as required, and honour the return status values G_RET_STS_SUCCESS, G_RET_STS_ERROR, and G_RET_STS_UNEXP_ERROR, retrieving detailed messages via FND_MSG_PUB when the message count exceeds one. Both 12.1.1 and 12.2.2 rely on the same API contract.