Search Results lns_custom_pub




Overview
Explore in AI Chat

Overview

LNS_CUSTOM_PUB is a public PL/SQL package in the APPS schema that supports custom payment schedule processing within the Oracle E-Business Suite Lease and Loan Management (LNS) module. Its central purpose is to allow users to define, build, validate, and manage customized payment schedules that deviate from standard amortization or billing logic generated by the core LNS financial engine. The package is classified as an API (PUB), meaning its procedures are intended for invocation by other application modules, concurrent programs, or customer extensions rather than being restricted to internal use.

In the leasing and lending lifecycle, standard schedules are frequently overridden to accommodate negotiated terms, irregular installment patterns, deferral periods, or embedded fees. LNS_CUSTOM_PUB provides the programmatic surface for these operations, bridging the loan header and terms data with the custom payment schedule tables. The package depends on LNS_FIN_UTILS for shared financial calculations and on SYS.STANDARD for PL/SQL runtime support. It is referenced by several higher-level packages, including LNS_BILLING_BATCH_PUB, LNS_FINANCIALS, and the LNS_CUSTOM_PUB_W worker package, indicating that it participates in scheduled generation during billing and financial processing runs.

Key Procedures and Functions

The package exposes twenty-two documented procedures spanning the full lifecycle of a custom schedule. Creation and maintenance procedures include CREATECUSTOMSCHEDULE, CREATECUSTOMSCHED, UPDATECUSTOMSCHEDULE, and UPDATECUSTOMSCHED, which instantiate and modify custom schedule records against a loan. VALIDATECUSTOMTABLE and VALIDATECUSTOMROW perform structural and row-level validation of custom table input, ensuring data quality before persistence. LOADCUSTOMSCHEDULE and SAVECUSTOMSCHEDULE move custom schedule data between the application layer and the underlying storage tables, while PARSECLOB interprets a CLOB payload containing schedule definitions.

Calculation and adjustment procedures include RECALCCUSTOMSCHEDULE, which recomputes derived values such as interest, principal splits, and balances; CUSTOMIZESCHEDULE and UNCUSTOMIZESCHEDULE, which convert a standard schedule into a custom one and back again; and SHIFTCUSTOMSCHEDULE, which repositions installment dates. REBUILDCUSTOMDSCHEDULE and BUILDCUSTOMPAYSCHEDULE regenerate custom disbursement and payment schedules respectively. ADDMISSINGINSTALLMENT inserts an installment absent from the computed set, and RESETCUSTOMSCHEDULE restores the schedule to a baseline state.

Retention-related procedures RETAINCUSTOMSCHEDULE, CLEARRETAINEDSCHEDULE, and GETRETAINEDSCHEDULE manage a retained copy of schedule data, supporting comparison or rollback during schedule edits.

Tables Accessed

The package reads and writes a focused set of LNS tables through APPS synonyms. LNS_CUSTOM_PAYMNT_SCHEDS is the primary target for custom installment lines. LNS_AMORTIZATION_SCHEDS and LNS_RATE_SCHEDULES supply baseline amortization and rate data used during recalculation and rebuild. LNS_LOAN_HEADERS, LNS_LOAN_HEADERS_ALL, and LNS_LOAN_LINES provide loan identity and line-level context. LNS_TERMS and LNS_DISB_HEADERS contribute contractual term and disbursement reference data, while LNS_FEES and LNS_FEE_SCHEDULES support fee-related installment components. FND_CURRENCIES is consulted to resolve currency attributes, and DBMS_LOB and PLITBLM are used for large object handling and PL/SQL table manipulation.

Usage Notes

LNS_CUSTOM_PUB is typically invoked from the LNS custom schedule user interface, from concurrent programs that rebuild or recalculate schedules in batch, and from customer-written extensions that automate schedule customization. Because it is a public API, direct invocation is supported, but callers should follow documented sequencing—load or create a schedule, validate it, then save—to avoid inconsistent state. Care should be taken with retention procedures, as they hold prior schedule snapshots.