Search Results okl_seeded_functions_pvt




Overview
Explore in AI Chat

Overview

OKL_SEEDED_FUNCTIONS_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It is classified as a PVT (private) API, meaning it is intended for internal consumption by other ETRM packages rather than direct invocation by external customers or forms. The package encapsulates the seeded financial calculation functions that the leasing application uses to derive monetary and accounting values across contracts and contract lines. Its central role is to compute contract-level and line-level financial measures — residual values, rents, capitalized amounts, discounts, and depreciation-related figures — consistently so that downstream processes (funding, loss provisioning, cure calculations, financial extraction, and workflow) all draw from a single authoritative source of calculation logic.

Key Procedures and Functions

The package exposes 129 documented functions and procedures, organized as parallel contract-level and line-level calculators. Representative members include:

The dual structure (LINE_* versus CONTRACT_*) lets callers request a value scoped either to an individual contract line or rolled up to the full contract.

Tables Accessed

The package reads from a broad set of ETRM and Oracle Financials tables through APPS synonyms:

It also references OKL_API and SYS.STANDARD for error handling and standard utilities.

Usage Notes

Because OKL_SEEDED_FUNCTIONS_PVT is a private package, it is not called directly from Oracle Forms or concurrent programs by end users. Instead it is referenced by eleven other APPS packages, including OKL_FUNDING_PVT, OKL_FUNDING_WF, OKL_CURE_CALC_PVT, OKL_LOSS_PROV_PVT, OKL_MAINTAIN_FEE_PVT, OKL_OPI_PVT, OKL_CNTRCT_FIN_EXTRACT_PVT, OKL_K_LINE_FIN_EXT_PVT, OKL_CO_WF, the OKL_CREDITLINES_UV view, and IEX_CASE_INFO_PUB. These callers invoke the appropriate seeded function during funding, provisioning, cure evaluation, or financial extraction. Customizations should invoke the calling public APIs rather than OKL_SEEDED_FUNCTIONS_PVT directly, since the private package signature is not guaranteed across patches. When troubleshooting lease financial figures in 12.1.1 or 12.2.2, this package is a key starting point for tracing how a displayed amount was derived.