Results for “lns_financials”

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

Overview

LNS_FINANCIALS is the core financial calculation engine within the Oracle E-Business Suite Lease and Loan Management (LNS) module. Declared with AUTHID CURRENT_USER, it executes under the privileges of the calling session and serves as the shared library through which the application derives amortization schedules, interest accruals, payoff figures, and loan projections. Its documented scope, as reflected in the ETRM metadata for release 12.2.2, encompasses forty-one public procedures and functions, twelve dependent packages, and direct access to fifteen base tables through APPS synonyms.

The package defines several public PL/SQL record and collection types that structure its interfaces. INTEREST_RATE_REC captures rate details such as annual rate, spread, phase, and floating flag, while RATE_SCHEDULE_TBL is an index-by table used to model multi-rate loans. AMORTIZATION_REC is the principal output structure returned to the user interface, carrying installment number, due dates, principal, interest, fee and other amounts, cumulative balances, and rate identifiers for each schedule line.

Key Procedures and Functions

The documented entry points divide into several functional groups:

• Amortization: AMORTIZELOAN, AMORTIZEEPLOAN, RUNAMORTIZATION, and LOANPROJECTION generate and project repayment schedules, with RUNOPENPROJECTION handling projection from an existing open position.
• Interest and rate handling: GETANNUALRATE, GETACTIVERATE, GETPERIODICRATE, GETWEIGHTEDRATE, GETRATESCHEDULE, and GETRATEDETAILS retrieve rate information and schedule detail; COMPOUNDINTEREST performs compounding logic.
• Balance and accrual: GETAVERAGEDAILYBALANCE, GETWEIGHTEDBALANCE, and GETREMAININGBALANCE compute balances used for accrual and payoff purposes.
• Loan maintenance: SHIFTLOAN and SHIFTLOANDATES adjust loan and date attributes; GETLOANDETAILS returns loan-level information; VALIDATELOAN and VALIDATEPAYOFF enforce business rules before processing.

Tables Accessed

The package reads and writes the LNS amortization tables LNS_AMORTIZATION_SCHEDS, LNS_AMORTIZATION_SCHEDS_S, and LNS_AMORTIZATION_LINES, which store schedule headers and generated lines. Rate data is drawn from LNS_INT_RATE_LINES. Loan master and extension data come from LNS_LOAN_HEADERS, LNS_LOAN_HEADERS_ALL, LNS_LOAN_DOCUMENTS, and LNS_LOAN_EXTENSIONS. Fee processing references LNS_FEES and LNS_FEE_SCHEDULES, and payment scheduling references LNS_CUSTOM_PAYMNT_SCHEDS. Disbursement activity is captured through LNS_DISB_HEADERS and LNS_DISB_LINES. External references include AP_INVOICE_PAYMENTS_ALL, used for payment reconciliation, and FND_CURRENCIES, used for currency attributes.

Usage Notes

LNS_FINANCIALS is not intended for direct end-user invocation. It is called by the Lease and Loan Management forms, by loan-related concurrent programs such as amortization and projection generators, and by other packages in the LNS schema, consistent with the twelve dependent packages reported in the metadata. Customizations should treat the package as a controlled API surface: invoke the documented public procedures through supported entry points rather than calling internal logic, and observe that AUTHID CURRENT_USER requires the calling session to hold appropriate privileges on the referenced tables. The ETRM metadata does not publish parameter lists for the documented entry points, so integrators should confirm signatures against the deployed specification for the target release, 12.1.1 or 12.2.2, before coding dependencies. The search term "neslig inc" does not correspond to any documented object, table, or procedure associated with this package and appears unrelated to its content.