Search Results is_loan_fasgm_editable




Overview
Explore in AI Chat

Overview

The APPS.LNS_FEE_ASSIGNMENT_PUB package is a public PL/SQL API within the Oracle E-Business Suite Lease and Loan Management (LNS) module, which forms part of the Financial Services Accounting and Processing (formerly ETRM) application. It encapsulates the business logic governing the assignment of fees to leases, loans, and related disbursement instruments. In the LNS data model, a fee definition is created once (in LNS_FEES) and then assigned to individual loan or lease contracts, generating fee assignment records that drive amortization, accounting, and cash flow. The _PUB suffix designates this package as a supported public API, meaning it is intended for invocation by other application modules, forms, and customer extensions rather than being an internal-only construct. Its responsibility is to create, maintain, validate, and delete fee assignment records, thereby ensuring that fee-related accounting entries and schedules remain consistent with the underlying contract terms. Because fee assignments affect amortization and distribution processing, the package is a foundational element of the LNS fee lifecycle.

Key Procedures and Functions

The package exposes nine documented program units that cover the full maintenance lifecycle of fee assignments:

  • CREATE_FEE_ASSIGNMENT — Establishes a new fee assignment linking a fee to a specific loan or lease contract.
  • UPDATE_FEE_ASSIGNMENT — Modifies the attributes of an existing fee assignment record.
  • DELETE_FEE_ASSIGNMENT — Removes a fee assignment when it is no longer applicable to the contract.
  • GET_FEE_ASSIGNMENT_REC — Retrieves the details of a fee assignment record for display or downstream processing.
  • IS_EXIST_FEE_ASSIGNMENT — Returns a Boolean or flag indicating whether a fee assignment already exists, supporting duplicate-prevention logic.
  • CREATE_LP_FEE_ASSIGNMENT — Creates fee assignments originating from the loan product line (LP) context, enabling product-level defaulting of fees.
  • CREATE_LP_DISB_FEE_ASSIGNMENT — Creates fee assignments tied specifically to a loan product line disbursement, supporting disbursement-level fee handling.
  • DELETE_DISB_FEE_ASSIGNMENT — Deletes fee assignments associated with a disbursement.
  • IS_LOAN_FASGM_EDITABLE — Determines whether a loan's fee assignment is in an editable state, which is critical for enforcing accounting-period and processing restrictions.

These units collectively support both contract-level and product-level fee assignment scenarios, including the disbursement-specific variants required for accurate fee capitalization and expense recognition.

Tables Accessed

Through APPS synonyms, the package references a broad set of LNS tables. Contract and product context is drawn from LNS_LOAN_HEADERS, LNS_LOAN_HEADERS_ALL, LNS_LOAN_HISTORIES_H, and LNS_LOAN_PRODUCT_LINES. Fee definition and assignment data reside in LNS_FEES, LNS_FEES_ALL, LNS_FEE_ASSIGNMENTS, and LNS_FEE_ASSIGNMENTS_S. Amortization logic relies on LNS_FEE_SCHEDULES, LNS_AMORTIZATION_SCHEDS, and LNS_AMORTIZATION_LINES. Distribution and disbursement processing involves LNS_DISB_HEADERS, LNS_DISTRIBUTIONS, LNS_DISTRIBUTIONS_S, and LNS_DEFAULT_DISTRIBS. These references explain how fee assignment records are validated against contract structure, fed into amortization schedules, and propagated to distribution and disbursement tables.

Usage Notes

This package is typically invoked from LNS setup and transaction forms, from concurrent programs that generate or regenerate fee schedules and amortization, and from custom extensions that automate fee assignment during loan origination or servicing events. The presence of a corresponding wrapper, LNS_FEE_ASSIGNMENT_PUB_W, indicates that the API is also exposed through a thin wrapper layer, a common pattern for form and OA Framework integration. It is referenced by four other packages, notably LNS_FUNDING_PUB, confirming that fee assignment creation is a prerequisite or parallel activity to funding and disbursement processing. Developers invoking the API directly should call the public procedures rather than manipulating the underlying tables, and should respect the editability check exposed by IS_LOAN_FASGM_EDITABLE to avoid violating period-close or processing constraints.