Search Results lns_payoff_pub




Overview
Explore in AI Chat

Overview

APPS.LNS_PAYOFF_PUB is a public PL/SQL API package within the Oracle E-Business Suite Lease Management (LNS) module. It encapsulates the business logic required to process loan payoffs, apply payoff receipts, and manage loan cancellation and loan split approval workflows. The package is classified as a PUBLIC API, indicating it is intended for invocation by external EBS components, Oracle Forms, concurrent programs, and customer-written extensions rather than being restricted to internal use. Its status is VALID, and it resides in the APPS schema, consistent with standard EBS API deployment conventions. The package sits at the boundary between the Lease Management loan subsystem and Oracle Receivables, coordinating the financial impact of closing, cancelling, or restructuring loan obligations.

Key Procedures and Functions

The package exposes ten documented procedures and functions. PROCESSPAYOFF serves as the primary entry point for executing a loan payoff transaction, driving the overall payoff business flow. GETLOANINVOICES retrieves the open invoices associated with a loan, providing the caller with the receivables items that must be settled. APPLY_RECEIPT applies a cash receipt against the loan, and GETCONVERTEDRECEIPTAMOUNT returns the receipt amount converted into the appropriate functional or loan currency. GETINVOICESFORLOANCANCELLATION identifies the invoices eligible for reversal or adjustment when a loan cancellation is initiated. SAVELOANCANCELREQUEST persists a loan cancellation request, while APPROVELOANCANCELREQUEST and REJECTLOANCANCELREQUEST support the corresponding approval and rejection outcomes. In parallel, APPROVELOANSPLITREQUEST and REJECTLOANSPLITREQUEST manage the approval and rejection of loan split requests. Parameter lists are not reproduced here; callers should consult the package specification for exact signatures.

Tables Accessed

The package reads and writes across the Lease Management loan tables and Oracle Receivables. Loan header data is held in LNS_LOAN_HEADERS and LNS_LOAN_HEADERS_ALL, which anchor the loan being processed. LNS_AMORTIZATION_SCHEDS supports amortization calculations, while LNS_FEES and LNS_FEE_SCHEDULES carry fee information relevant to the payoff amount. Cancellation processing relies on LNS_LOAN_CANCELLATIONS, LNS_LOAN_CANCELLATIONS_S, LNS_LOAN_CANCEL_DETAILS, and LNS_LOAN_CANCEL_DETAILS_S. On the receivables side, AR_CASH_RECEIPTS, AR_PAYMENT_SCHEDULES, AR_PAYMENT_SCHEDULES_ALL, and AR_RECEIVABLE_APPLICATIONS are accessed to apply receipts and manage invoice balances. FND_CURRENCIES supplies currency conversion data, and HZ_PARTIES provides trading partner information. Tables are referenced through APPS synonyms, as is standard in EBS.

Usage Notes

LNS_PAYOFF_PUB is typically invoked from Lease Management Oracle Forms during payoff, cancellation, and loan split approval actions, and from concurrent programs that automate these workflows. It may also be called from custom PL/SQL code when integrating external systems with Lease Management. The package depends on standard Oracle infrastructure such as SYS.STANDARD, and it is referenced by the LNS_PAYOFF_PUB wrapper package and its corresponding _W variants, indicating a layered API design. Because the procedures affect financial balances in Oracle Receivables, callers should invoke them within a properly scoped transaction and rely on the package's own error handling rather than reimplementing validation. As with all EBS public APIs, customizations should use the documented entry points and avoid direct DML against the underlying tables.