Search Results pn_var_rent_calc_pkg




Overview
Explore in AI Chat

Overview

PN_VAR_RENT_CALC_PKG is the core rental calculation engine within the Oracle Property Manager (PN) variable rent subsystem. In Oracle EBS 12.1.1 and 12.2.2, variable rent refers to lease charges that fluctuate based on sales volume, thresholds, breakpoints, or other contractual measures rather than a fixed periodic amount. This package encapsulates the business logic required to evaluate those variable rent terms, apply contractual constraints and abatements, and generate the resulting rent transactions.

The package resides in the APPS schema with a status of VALID and is classified as an OTHER API type, meaning it is primarily an internal engine rather than a public integration interface. Its responsibilities span proration of rent across fiscal and lease years, determination of rent applicability, prior-billed amount lookup, abatement handling, constraint application, and the posting of summarized rent results. Because it underpins both calculation and invoicing flows, it is among the most heavily referenced packages in the variable rent module.

Key Procedures and Functions

The package exposes 76 documented procedures and functions. The most significant groups are summarized below.

Tables Accessed

The package reads and writes several core Property Manager tables through APPS synonyms.

Usage Notes

PN_VAR_RENT_CALC_PKG is invoked indirectly rather than directly by end users. It is referenced by twelve other packages, including PN_APPROVE_VARENT_PKG, PN_VARIABLE_TERM_PKG, PN_VAR_RENT_INV_PKG, PN_VAR_RENT_PKG, PN_VAR_TRUEUP_PKG, and PN_VAR_TRX_PKG, which orchestrate approval, true-up, and invoicing workflows. It also backs several database views, including PN_VAR_PERIODS_V, PN_VAR_RENT_ADJ_V, PN_VAR_RENT_DETAILS_V, PN_VAR_RENT_INV_V, PN_VAR_RENT_SUMM_V, and PN_VAR_SUMM_DET_V.

Typical invocation occurs through Property Manager concurrent programs and forms that process variable rent, generate rent adjustments, or create invoices. Custom extensions should call the higher-level wrapper packages rather than PN_VAR_RENT_CALC_PKG directly, since the calculation engine assumes prerequisite seeding of transaction headers and details. Because the package is classified as an OTHER internal API, Oracle does not guarantee its signature across releases; any custom dependency should be reviewed carefully during upgrades between 12.1.1 and 12.2.2.