Results for “in_funding”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.LNS_EXT_LOAN_PUB package is a public PL/SQL API within the Oracle E-Business Suite Lease and Loan Management (LNS) module. It provides the programmatic interface for managing loan extensions — the business process by which an existing loan's terms (term length, balloon structure, amortization period, rate, and interest-only characteristics) are renegotiated or extended without originating a new loan instrument. The package encapsulates the logic required to persist, approve, reject, and recalculate extension terms, allowing callers to interact with the loan extension lifecycle through a supported, versioned API rather than through direct DML against the underlying tables.

The header declares the package with AUTHID CURRENT_USER, meaning execution privileges are evaluated against the invoking schema rather than the package owner. It also defines two public record types — LOAN_EXT_REC, which models the loan extension attributes (extension ID, loan ID, description, extended term and period, balloon type and amount, amortization term, extended rate and spread, interest-only and floating flags, and index date), and NEW_TERM_REC, which carries both input and output values for term recalculation, including old and new term, balloon, maturity, and installment figures.

Key Procedures and Functions

• SAVE_LOAN_EXTENSION — Inserts or updates a loan extension record in the LNS_LOAN_EXTENSIONS table. This is the primary entry point for creating or modifying extension data captured by the caller.
• APPROVE_LOAN_EXTENSION — Transitions a pending loan extension into an approved state, applying the approved terms to the loan.
• REJECT_LOAN_EXTENSION — Reverses or declines a pending extension request, leaving the original loan terms intact.
• CALC_NEW_TERMS — Computes the recalculated terms resulting from an extension, populating the output members of the NEW_TERM_REC structure (new term, new balloon type and amount, new amortization term, new maturity date, and new installment count).

All four routines are documented as public API members; callers should treat them as the supported surface of the package and avoid referencing internal package state.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• LNS_LOAN_EXTENSIONS and LNS_LOAN_EXTENSIONS_S — the base and translated/seed tables storing loan extension records.
• LNS_LOAN_HEADERS_ALL — the parent loan header, providing loan-level context and the terms being extended.
• LNS_TERMS — term definitions used when recalculating extension terms.
• LNS_RATE_SCHEDULES and LNS_RATE_SCHEDULES_S — rate schedule and associated translation detail, consulted when extended rate or spread values are applied.
• LNS_CUSTOM_PAYMNT_SCHEDS — custom payment schedules referenced during extension processing to align payment timing with revised terms.
• DUAL and PLITBLM — utility objects used for single-row selection and PL/SQL table/bulk processing support.

Usage Notes

LNS_EXT_LOAN_PUB is typically invoked from Lease and Loan Management forms when a user records, approves, or rejects a loan extension, and from concurrent programs or custom extensions that automate term recalculation across a portfolio of loans. Because it is classified as a public API and is referenced by one other package, customizations should call these procedures rather than writing directly to the extension tables. In EBS 12.1.1 and 12.2.2, the package is delivered under the APPS schema; the caller must hold execute privilege and appropriate data access to the underlying LNS tables.