Search Results lns_fee_schedules_pkg




Overview
Explore in AI Chat

Overview

APPS.LNS_FEE_SCHEDULES_PKG is a stored PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Lease Management (LNS) module's fee schedule functionality. In the context of Oracle EBS 12.1.1 and 12.2.2, this package forms part of the ETRM (E-Business Suite Technical Reference Manual) object inventory and is classified as an "OTHER" API, meaning it is an internal support package rather than a formally published public API. Its primary business purpose is to provide the low-level data manipulation and concurrency primitives required to maintain fee schedule definitions used by the Lease Management fee calculation engine. The package holds a VALID status and is documented with four procedures that perform the standard DML and locking operations against the underlying fee schedule tables.

Key Procedures and Functions

The ETRM documentation records four procedures within this package. Their purposes are as follows:

  • INSERT_ROW — Creates a new fee schedule record in the base fee schedules table, populating the columns required to define a fee schedule header or schedule definition.
  • UPDATE_ROW — Modifies an existing fee schedule record, applying changes to the schedule attributes maintained by the Lease Management fee engine.
  • DELETE_ROW — Removes an existing fee schedule record, typically used when a schedule is superseded or no longer applicable.
  • LOCK_ROW — Acquires a row-level lock on a fee schedule record to enforce concurrency control, ensuring that concurrent updates to the same schedule do not produce inconsistent results.

The metadata does not document parameter signatures for these procedures, and parameter lists are therefore not enumerated here. The naming conventions follow the standard Oracle EBS table-handler pattern, in which INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW operate as a cohesive set for maintaining a single logical entity.

Tables Accessed

Through APPS synonyms, the package reads and writes two documented tables:

  • LNS_FEE_SCHEDULES — The base table holding fee schedule definitions, including the schedule header and associated attributes used by the fee engine.
  • LNS_FEE_SCHEDULE_S — The corresponding MLS (Multi-Language Support) translation table holding language-specific descriptions or names for fee schedules stored in the base table.

The INSERT_ROW, UPDATE_ROW, and DELETE_ROW procedures perform the DML against these tables, while LOCK_ROW supports the concurrency model required to protect them. The dependency listing additionally shows a reference to the SYS.STANDARD package, which is a normal artifact of compiled PL/SQL units.

Usage Notes

LNS_FEE_SCHEDULES_PKG is referenced by three other packages, one of which is documented as LNS_FEE_ENGINE. This indicates that the package is invoked indirectly through the Lease Management fee processing flow rather than being called directly by end users. In practice, it is typically reached from fee engine logic that validates or persists fee schedule data during lease setup, fee assessment, or schedule maintenance operations. Because it is classified as an OTHER API and is not a published public interface, it should not be called directly from custom code; customizations should instead use the supported API surface exposed by the fee engine or the Lease Management module's documented interfaces. When troubleshooting fee schedule issues in EBS 12.1.1 or 12.2.2, DBAs and developers may inspect this package's compiled body to understand the exact DML behavior, but modifications to the package are not supported and would be overwritten by patching. The presence of a LOCK_ROW procedure confirms that the package participates in Oracle Forms-based or concurrent processing where pessimistic locking is required to maintain data integrity.