Search Results okl_variable_interest_pvt




Overview
Explore in AI Chat

Overview

The APPS.OKL_VAR_INT_REAMORT_PVT package is a private (PVT) PL/SQL API within the Oracle E-Business Suite Lease Management (OKL) module, which forms part of the Enterprise Territory and Resource Management (ETRM) family of applications. Its business purpose is to support the re-amortization of variable interest leases. In lease contracts where the interest rate or rental stream varies over the contract term, the system must periodically recalculate the amortization and rental-level schedules to reflect those changes. This package provides the internal processing logic that performs that recalculation, deriving new rental levels and re-amortizing interest against fixed asset depreciation data. Because it is a private package, its procedures are intended for invocation by other ETRM packages rather than directly by end users or external interfaces.

Key Procedures and Functions

The ETRM documentation records two procedures or functions belonging to this package:

  • VAR_INT_RENT_LEVEL — Supports determination of rental levels for variable interest leases. This routine participates in computing the rental-level values that drive the amortization schedule when interest terms vary, likely reading and reconciling stream or line-level rental data held in the OKL stream interface tables.
  • PROCESS_INTEREST_REAMORT — Drives the actual re-amortization of interest for the contract. This is the principal processing routine invoked when a lease with variable interest must be re-amortized, coordinating with fixed asset depreciation records so that the recalculated interest aligns with the asset book information.

Because the package is classified as PVT, its signatures are not exposed as public API entry points; the procedures are called internally as part of broader lease processing flows. The documentation does not enumerate individual parameters, and callers should reference the packaged specification for exact argument lists.

Tables Accessed

The package accesses a range of contract and asset tables through APPS synonyms. On the contract side, it reads from OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_LINE_STYLES_B, OKC_RULES_B, OKC_RULE_GROUPS_B, and OKC_STATUSES_B — core Oracle Contracts tables that define the header, line, style, rule, and status structures governing the lease. Lease-specific data comes from OKL_K_HEADERS, OKL_K_LINES, OKL_SIF_LINES, OKL_SIF_RETS, and OKL_SIF_RET_LEVELS, which hold lease headers, lines, and stream interface rentals and returns. On the asset side, the package reads FA_BOOKS, FA_BOOK_CONTROLS, and FA_DEPRN_SUMMARY to obtain depreciation book definitions, book controls, and depreciation summaries. This integration ensures re-amortized interest figures remain consistent with the fixed asset depreciation records.

Usage Notes

OKL_VAR_INT_REAMORT_PVT is referenced by two other ETRM packages: OKL_PROCESS_STREAMS_PVT and OKL_VARIABLE_INTEREST_PVT. It also references OKL_VARIABLE_INTEREST_PVT, OKL_API, and OKC_API, indicating a layered internal dependency where stream processing and the parent variable interest package delegate re-amortization work to this private unit. Typical invocation occurs during lease processing streams and variable interest recalculations triggered by concurrent programs or internal business flows, rather than from a standard EBS form field. Customizations or extensions that need this functionality should call the documented public APIs (such as OKL_VARIABLE_INTEREST_PVT) instead of invoking the private package directly, preserving upgrade safety across EBS 12.1.1 and 12.2.2. The package status is VALID in the APPS schema, confirming it is compiled and operational within the environment documented.