Results for “pn_var_rents_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.PN_VAR_RENTS_PKG package body is a core PL/SQL API within the Oracle Property Manager (PN) module, one of the enterprise applications comprising the Oracle E-Business Suite. Property Manager manages real estate leases and the associated financial obligations, including variable rent arrangements that fluctuate according to sales volume, cumulative usage, or other contractual metrics. The package encapsulates the data manipulation and business-rule logic governing the PN_VAR_RENTS entity, exposing a set of public procedures through which variable rent records are created, modified, validated, and retired. It is a low-level API owned by APPS and classified as OTHER, meaning it is an internal implementation artifact rather than a public integration interface, yet it remains accessible to dependent forms, concurrent programs, and custom code that must manipulate variable rent data programmatically.

Key Procedures and Functions

The package documents eight procedures and functions. INSERT_ROW is the primary creation routine, accepting the full column set of a variable rent record including rent number, lease and location identifiers, proration attributes, purpose and type codes, commencement and termination dates, cumulative volume and accrual indicators, UOM code, invoicing and negative-rent flags, term and agreement template identifiers, and the standard descriptive flexfield attributes. Its internal cursor selects from the PN_VAR_RENTS_AL alias, reflecting the migration to the _ALL table established under Bug 4284035 (21-JUN-05), which introduced multi-organization (Or) support. LOCK_ROW provides the standard optimistic-locking mechanism used by Oracle Forms to serialize concurrent updates. UPDATE_ROW and DELETE_ROW perform the corresponding mutation and removal operations. CHECK_UNIQUE_RENT_NUMBER enforces uniqueness of the rent number before insertion or update. The higher-level procedures CREATE_VAR_RENT_AGREEMENT, MODIF_VAR_RENT, and DELETE_VAR_RENT_AGREEMENT orchestrate the end-to-end lifecycle of a variable rent agreement, invoking the CRUD primitives and coordinating related payment and date records.

Tables Accessed

The package operates against the multi-organization tables PN_VAR_RENTS_ALL and PN_VAR_RENT_DATES_ALL, the latter holding the effective-dated volume and rent schedules that drive calculation. It references PN_LEASES_ALL to validate the parent lease and PN_VAR_RENT_INV_ALL to maintain invoice associations. Payment-side integration is achieved through PN_PAYMENT_ITEMS_ALL, PN_PAYMENT_SCHEDULES_ALL, and PN_PAYMENT_TERMS_ALL, which carry the financial terms generated from a rent agreement. The sequence PN_VAR_RENTS_S supplies the primary key for X_VAR_RENT_ID, and DUAL is used for scalar lookups.

Usage Notes

This package is typically invoked from the Property Manager variable rent maintenance forms and from concurrent programs that generate payment schedules, as well as by other PL/SQL packages; the metadata records it as referenced by three other packages. Customizations should treat INSERT_ROW, UPDATE_ROW, and DELETE_ROW as the canonical write path so that the WHO columns and ORG_ID are populated consistently, and should call CHECK_UNIQUE_RENT_NUMBER before committing new rows.