Search Results loan_termination

Overview

OKL_AM_LOAN_TRMNT_PVT is a private (PVT) PL/SQL package within the Oracle Lease and Finance Management (OKL) application module of Oracle E-Business Suite. In ETRM 12.1.1 and 12.2.2 it is the loan-side counterpart to the lease termination package OKL_AM_LEASE_TRMNT_PVT. Its business purpose is to support the termination of loan-style contracts originated through the corporate lending service centre, computing and validating the financial settlement that results when a loan agreement is brought to an early or scheduled end.

The package is declared AUTHID CURRENT_USER and is owned by APPS. Because it is classified as PVT, it is not part of the supported public API surface; it is intended to be called only by other packages within the OKL termination framework. Its header declares a comprehensive set of shared constants inherited from OKL_API — including G_PKG_NAME, G_APP_NAME, G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, G_SQLERRM_TOKEN, G_REQUIRED_VALUE, G_INVALID_VALUE and G_COL_NAME_TOKEN — and a global exception G_EXCEPTION_HALT_VALIDATION used to unwind validation logic cleanly. The source header (OKLRLOTS.pls, version 115.8) places the package within the OKL Release Loans family.

Key Procedures and Functions

The documented interface comprises two procedures:

• VALIDATE_LOAN — Performs the validation phase of loan termination. It confirms that the loan is in a state eligible for termination and that the data required to proceed has been supplied, raising G_EXCEPTION_HALT_VALIDATION or the standard OKL_API error tokens when the input fails the business rules.
• LOAN_TERMINATION — Executes the termination itself, applying the validated inputs and driving the settlement processing for the loan contract.

The package also declares subtypes that alias the shared data structures of OKL_AM_LEASE_TRMNT_PVT — term_rec_type, tcnv_rec_type, stmv_tbl_type, adjv_rec_type, ajlv_tbl_type, chrv_rec_type, clev_tbl_type and klev_tbl_type. These aliases indicate that termination records, conversion/settlement records and adjustment, clearance and key-value collections are passed between the lease and loan termination paths in a common format. No public function list or parameter signature should be inferred beyond what is documented.

Tables Accessed

Only DUAL is recorded as a referenced table via APPS synonyms. DUAL is the standard Oracle single-row utility table and is used for constant evaluation, arithmetic checks and single-value lookups; it implies the package performs no direct DML against contract or financial tables itself. Persistence of termination results is delegated to the calling framework or to the shared structures defined by OKL_AM_LEASE_TRMNT_PVT. This is consistent with a PVT package whose role is computation and validation rather than data maintenance.

Usage Notes

Because the package is a private API, it is not certified for direct invocation from custom code, concurrent programs or forms. It is referenced by one other package, and that caller is responsible for sequencing VALIDATE_LOAN before LOAN_TERMINATION and for handling the propagated OKL_API error tokens. In practice the entry point is the corporate lending service centre termination flow, where the user initiates loan termination from the OKL UI; the framework gathers the termination inputs, populates the shared record and table types, invokes the validation procedure, and, on success, invokes the termination procedure to complete the settlement. Customisations should target the supported public OKL APIs and the calling framework, since Oracle may change this private package without notice.