Search Results fa_lease_pitems_pkg




Overview
Explore in AI Chat

Overview

FA_LEASE_PITEMS_PKG is a PL/SQL package in the APPS schema of Oracle E-Business Suite that manages payment line records for leased assets in Oracle Assets. The package name reflects its role as the "Lease Payment Items" API, and its documented purpose is to provide programmatic control over the contents of the FA_LEASE_PAYMENT_ITEMS table. This table stores the individual payment items that make up a lease payment schedule, including lessor, invoice, distribution account, and term references.

The package is declared with AUTHID CURRENT_USER and is classified as an API of type OTHER in the ETRM 12.2.2 metadata. Its header identifies it as a set of wrapper procedures, meaning it encapsulates the insert, update, delete, and locking logic used by Oracle Assets lease processing so that callers do not manipulate FA_LEASE_PAYMENT_ITEMS directly. The latest shipped version of the source in the file header is 120.2, dated March 27, 2009, which is consistent with the code line present in both 12.1.1 and 12.2.2.

Key Procedures and Functions

  • Insert_Row — Inserts a single row into FA_LEASE_PAYMENT_ITEMS. It accepts the lease identifier, payment schedule identifier, schedule amortization line number, export status, lessor and lessor site identifiers, distribution code combination identifier, invoice number and identifiers, terms identifier, standard WHO audit columns, request identifier, and logging information.
  • Update_Row — Updates an existing FA_LEASE_PAYMENT_ITEMS row. It is keyed by the ROWID of the target record plus the lease and payment schedule identifiers, and carries the same business and audit attributes as Insert_Row.
  • Lock_Rows — Locks all rows in FA_LEASE_PAYMENT_ITEMS associated with a specified lease identifier. This is the procedure most directly relevant to the user's search for "lock_rows." It serializes concurrent access to a lease's payment items so that a subsequent update or delete operates on a consistent set of rows.
  • Delete_Rows — Deletes all FA_LEASE_PAYMENT_ITEMS rows associated with a specified lease identifier.
  • Payments_Itemize — Itemizes payments, that is, performs the business operation that breaks payments down into their constituent line items and persists them through this API.

Tables Accessed

Three tables are referenced through APPS synonyms. FA_LEASE_PAYMENT_ITEMS is the primary table manipulated by all four data-maintenance procedures (Insert_Row, Update_Row, Lock_Rows, and Delete_Rows) and is the object that the row-level locking in Lock_Rows targets. FA_LEASES supplies lease header information, in particular the lease identifier that keys all operations in the package. FA_AMORT_SCHEDULES holds the amortization schedules from which payment items are derived, linking scheduled lease amounts to the payment item rows that are inserted or maintained.

Usage Notes

The package is a server-side API. It is typically invoked from Oracle Assets lease entry forms, from concurrent programs that itemize lease payments, and from custom extensions or interfaces that must load or maintain lease payment items without bypassing Oracle's validation and audit-column handling. The presence of the p_log_level_rec parameter of type FA_API_TYPES.log_level_rec_type indicates that callers are expected to pass the standard logging record so that FA-level debug and trace messages flow through the normal Oracle Assets logging framework. Because the package is declared AUTHID CURRENT_USER, the invoking schema must have the necessary privileges on the underlying APPS synonyms.

From an integration standpoint, FA_LEASE_PITEMS_PKG is a self-contained utility: the ETRM metadata records that it is referenced by zero other packages. This means it is not an internal building block consumed by other PL/SQL units, but rather a boundary API invoked directly by forms, concurrent managers, or external code. When using Lock_Rows, callers should supply the lease identifier and expect all payment items for that lease to be locked together, which enforces lease-level rather than row-level concurrency control.