Search Results lns_fee_assignment_pub_w

Overview

APPS.LNS_FEE_ASSIGNMENT_PUB_W is a public PL/SQL package within the Oracle E-Business Suite Lease and Loan Management (LNS) module. The "_PUB_W" suffix identifies it as a public API wrapper, a naming convention Oracle uses to mark packages intended for external invocation by forms, concurrent programs, workflows, or custom code rather than for internal-only use. The package provides the programmatic entry point for creating and maintaining fee assignment records in the lease and loan fee management process. Fee assignments define how fees associated with a lease or loan contract are allocated, applied, and recognized across the contractual lifecycle, and this package exposes controlled operations that enforce the business rules surrounding those records.

The object is owned by the APPS schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. Its API classification in the ETRM metadata is recorded as OTHER, indicating it is a supporting public API rather than one of the primary transaction interfaces.

Key Procedures and Functions

The ETRM metadata documents two procedures for this package:

• CREATE_FEE_ASSIGNMENT — Establishes a new fee assignment record. This procedure is the entry point for associating a fee with the appropriate contract, fee component, and assignment attributes, applying the validation and defaulting logic required before the record is persisted.
• UPDATE_FEE_ASSIGNMENT — Modifies an existing fee assignment. This procedure supports maintenance of previously created assignments, allowing attributes to be changed in accordance with the fee management business rules while preserving referential integrity.

The published documentation does not enumerate parameter lists for these procedures, and no additional subprograms are recorded. Callers should therefore obtain the exact signatures from the deployed package specification in the target environment.

Tables Accessed

The dependency metadata for LNS_FEE_ASSIGNMENT_PUB_W lists references only to SYS.STANDARD, which reflects PL/SQL language dependencies rather than business tables accessed directly by name. The package body is anticipated to perform its database work through the LNS fee assignment base and interface tables, but the ETRM record does not expose those table references explicitly. Implementers should confirm the underlying table usage by reviewing the package body in the EBS instance.

Usage Notes

Because this is a public wrapper package, it is the supported surface for any external integration touching fee assignment data. Typical invocation paths include the Lease and Loan Management application forms that maintain fee assignments, concurrent programs that process or generate fee records in batch, and custom extensions or interfaces that need to create or amend assignments without bypassing validation logic.

Two practical considerations apply. First, direct DML against the underlying fee assignment tables should be avoided; routing all changes through CREATE_FEE_ASSIGNMENT and UPDATE_FEE_ASSIGNMENT preserves consistency with the module's business rules. Second, the metadata shows the package is referenced by no other packages, confirming it is an entry point rather than a shared internal utility. Where integration is required, callers should initialize the standard EBS API context — login, responsibility, and application initialization — before invoking these procedures so that the session context matches the expected runtime environment. Testing in a cloned environment prior to production deployment is recommended given the absence of documented parameter and return-value details in the ETRM record.