Results for “create_var_rent_agreement”

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

Overview

APPS.PN_VAR_RENTS_PKG is a PL/SQL package within the Oracle Property Manager (PN) module of Oracle E-Business Suite. It encapsulates the core business logic required to create, maintain, and delete variable rent agreements associated with leases. In the context of property and lease administration, variable rent refers to rental charges whose amounts fluctuate based on measurable business activity, such as sales volume, cumulative turnover, or other periodic performance metrics rather than a fixed contractual amount.

The package provides a programmatic interface for managing records in the variable rent schema, ensuring that rent schedules, payment items, and payment schedules remain synchronized when rent terms change. The header comment identifies the source file as PNVRENTS.pls, with a revision date of 2007/01/30, indicating it has been a stable component of the Property Manager data model across releases including 12.1.1 and 12.2.2. The API classification is listed as OTHER, and the package is referenced by three other packages, confirming its role as a reusable service layer rather than a standalone utility.

Key Procedures and Functions

The package exposes eight documented procedures, spanning low-level row maintenance and higher-level agreement lifecycle operations:

• INSERT_ROW — Creates a new variable rent record, populating the identifier, rent number, lease and location references, proration details, purpose and type codes, commencement and termination dates, accrual and UOM attributes, invoice handling flags, currency, and the full set of descriptive flexfield attribute columns.
• LOCK_ROW — Acquires a row-level lock on an existing variable rent record, validating the supplied key and descriptive values to prevent concurrent modification.
• UPDATE_ROW — Modifies an existing variable rent record, applying changed values while preserving referential and audit integrity.
• DELETE_ROW — Removes a variable rent record from the underlying tables.
• CHECK_UNIQUE_RENT_NUMBER — Validates that the rent number assigned to a variable rent agreement is unique, preventing duplicate identifiers.
• CREATE_VAR_RENT_AGREEMENT — Performs the end-to-end creation of a variable rent agreement, orchestrating dependent payment items and payment schedules.
• MODIF_VAR_RENT — Handles modification of an existing variable rent agreement, including recalculating associated schedules and payment terms.
• DELETE_VAR_RENT_AGREEMENT — Removes a variable rent agreement along with its dependent child records.

Tables Accessed

The package operates against the following documented tables through APPS synonyms:

• PN_VAR_RENTS_ALL and PN_VAR_RENTS_S — the primary and sequence/security tables storing variable rent definitions.
• PN_VAR_RENT_DATES_ALL — stores the date ranges governing periodic variable rent calculation.
• PN_VAR_RENT_INV_ALL — holds invoice-related variable rent data.
• PN_LEASES_ALL — the parent lease records to which variable rents belong.
• PN_PAYMENT_ITEMS_ALL, PN_PAYMENT_SCHEDULES_ALL, and PN_PAYMENT_TERMS_ALL — payment structures generated or updated as a consequence of variable rent changes.
• DUAL — used for singleton queries and sequence retrieval.

Usage Notes

PN_VAR_RENTS_PKG is typically invoked from Property Manager forms, concurrent programs, and custom extensions rather than called directly by end users. The high-level procedures (CREATE_VAR_RENT_AGREEMENT, MODIF_VAR_RENT, DELETE_VAR_RENT_AGREEMENT) are the preferred entry points for application integration, as they manage the full transactional context across the variable rent and payment tables. The lower-level INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW procedures support form-based maintenance and follow the standard Oracle EBS row-handling pattern. The presence of ORG_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN parameters confirms multitenant, WHO-column audit compliance suitable for multi-org deployments.