Search Results okl_variable_interest_pub




Overview
Explore in AI Chat

Overview

The APPS.OKL_VARIABLE_INTEREST_PUB package body is a public API within the Oracle E-Business Suite Lease Management (Oracle Lease and Finance Management, OKL) module. It belongs to the receivables and rate-related functional area, as indicated by the internal debug module identifier LEASE.RECEIVABLES.RATE. The package provides the public-facing entry points for processing variable interest on lease contracts, allowing interest rates tied to variable indices to be recalculated and applied across contract schedules. In the context of Oracle EBS 12.1.1 and 12.2.2, this public package acts as the thin wrapper that invokes the underlying private worker package OKL_VARIABLE_INTEREST_PVT, which performs the substantive business logic. The public package isolates callers from internal implementation details, standardizes the Oracle EBS API contract (return status, message count, message data), and manages transaction and error handling.

Key Procedures and Functions

The documented metadata lists a single public procedure, VARIABLE_INTEREST, which drives variable interest processing for a contract. Its purpose is to initiate variable interest recalculation or processing for a specified lease contract across a date range, delegating the actual work to the private package. Consistent with Oracle EBS API conventions, the procedure accepts standard API parameters (API version, initialization of the message list), the contract identifier and effective date range, and returns the standard outcome parameters including return status, message count, and message data.

The excerpt also documents an internal initiate_request routine. This is a private helper that calls OKL_VARIABLE_INTEREST_PVT.initiate_request, passing back request identifier and transaction status values. It is not part of the public contract but illustrates how the package submits or initiates variable interest processing as a background request. Because the metadata does not enumerate formal parameter lists for the public procedure, no parameter details are asserted here.

Tables Accessed

The documented metadata does not list any tables referenced directly through APPS synonyms by this package. This is expected for a public wrapper package: the public layer primarily performs API housekeeping (version checking, message initialization, exception translation) and delegates all database reads and writes to OKL_VARIABLE_INTEREST_PVT. Consequently, table access for variable interest processing — including lease contract, stream, rate index, and schedule tables owned by the OKL schema — occurs in the private package rather than in this public body. From the SAVEPOINT name VARIABLE_INTEREST used in the exception handler, it is evident that the package participates in a transaction that may be rolled back to a caller-defined savepoint on error.

Usage Notes

OKL_VARIABLE_INTEREST_PUB.VARIABLE_INTEREST is invoked whenever variable interest on a lease must be processed, typically from Lease Management forms or concurrent programs that recalculate contract rates when an underlying index changes. The procedure follows the standard Oracle EBS API pattern: it checks the API version, calls the private implementation, inspects the return status, and raises Fnd_Api.G_EXC_ERROR or G_EXC_UNEXPECTED_ERROR as appropriate. Callers should pass a valid contract identifier and date range, initialize the message list when required, and inspect the returned status and messages. Custom code integrating with this API should call the public package rather than the private _PVT package to remain supported across releases. The metadata notes that no other packages reference this package, so it serves as a top-level entry point invoked externally.