Search Results update_fee_assignment

Overview

APPS.LNS_FEE_ASSIGNMENT_PUB is the public PL/SQL API for the Oracle E-Business Suite Loans (LNS) module that manages fee assignments on loan contracts. A fee assignment links a fee defined in the LNS_FEES / LNS_FEES_ALL tables to a specific loan, an installment range, and a distribution profile, so that the fee is recognized, amortized, and accounted for correctly across the life of the loan. The package body carries the standard ETRM header revision (120.9.12010000.2), confirming it is part of the shipping 12.1.1 and 12.2.2 code line, and its public classification means it is intended to be called from outside the Loans schema rather than used internally only. Search requests for create_fee_assignment map directly to the primary entry point of this package. A debug flag is read from the profile option AFLOG_ENABLED, consistent with standard EBS logging conventions.

Key Procedures and Functions

The package exposes nine documented procedures and functions, supported internally by private helpers such as Set_Defaults, do_create_fee_assignment, do_update_fee_assignment, and do_delete_fee_assignment.

• CREATE_FEE_ASSIGNMENT — Creates a new fee assignment for a loan. It is the most commonly referenced procedure and accepts a FEE_ASSIGNMENT_REC_TYPE record; the private Set_Defaults routine populates missing begin and end installment numbers using LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER.
• UPDATE_FEE_ASSIGNMENT — Modifies an existing fee assignment, using an object version number for optimistic locking.
• DELETE_FEE_ASSIGNMENT — Removes an existing fee assignment by identifier.
• GET_FEE_ASSIGNMENT_REC — Retrieves the full fee assignment record for a given identifier.
• IS_EXIST_FEE_ASSIGNMENT — Validation function that confirms whether a fee assignment exists.
• CREATE_LP_FEE_ASSIGNMENT — Creates a fee assignment in the context of a loan product line.
• CREATE_LP_DISB_FEE_ASSIGNMENT — Creates a disbursement-linked fee assignment for a loan product line.
• DELETE_DISB_FEE_ASSIGNMENT — Deletes the disbursement-associated fee assignment.
• IS_LOAN_FASGM_EDITABLE — Determines whether a loan's fee assignment data is still editable, typically by checking loan status or accounting state.

Tables Accessed

The package reads and writes the core Loans fee and loan tables, all through APPS synonyms. LNS_FEE_ASSIGNMENTS and LNS_FEE_ASSIGNMENTS_S are the primary insert, update, and delete targets, with the _S table holding the audit/intersection rows. LNS_FEES and LNS_FEES_ALL provide fee definitions. LNS_DISTRIBUTIONS and LNS_DISTRIBUTIONS_S, together with LNS_DEFAULT_DISTRIBS, hold the accounting distribution lines created for each fee, while LNS_FEE_SCHEDULES and LNS_AMORTIZATION_SCHEDS with LNS_AMORTIZATION_LINES drive fee amortization and installment schedules. LNS_LOAN_HEADERS, LNS_LOAN_HEADERS_ALL, LNS_LOAN_PRODUCT_LINES, and LNS_LOAN_HISTORIES_H supply loan, product line, and history context. LNS_DISB_HEADERS supports the disbursement-related creation and deletion routines.

Usage Notes

LNS_FEE_ASSIGNMENT_PUB is the supported integration point for creating, changing, or removing fee assignments, and is referenced by four other packages inside the LNS application. It is typically invoked from Loans forms and concurrent programs, and may be called from custom code or interfaces when fee assignments must be created programmatically. Callers should expect standard EBS API conventions: a record-based input, an OUT return status, and object version number handling for updates. Because the API relies on loan status via IS_LOAN_FASGM_EDITABLE, updates are rejected once the loan reaches a non-editable state, and distribution or accounting lines may already exist by that point. The AFLOG_ENABLED profile controls debug logging in the body.