Search Results apply_constraints_fy

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.

• Calculation core: CALCULATE_RENT drives the primary rent computation for variable rent records. GET_RENT_APPLICABLE and GET_RENT_APPLICABLE_FOR determine whether rent is due for a given record or transaction context.
• Proration helpers: GET_FY_PRORATION_FACTOR and GET_LY_PRORATION_FACTOR compute proration factors for fiscal year and lease year boundaries, allowing partial-period charges to be allocated correctly.
• Prior-billed lookups: FIND_PREV_BILLED and FIND_PREV_BILLED_FOR retrieve amounts previously billed, enabling true-up and incremental billing logic.
• Abatement handling: APPLY_ABATEMENTS, APPLY_ABAT, POPULATE_ABAT, and RESET_ABATEMENTS manage rent-free or reduced-rent periods, populate abatement records, and reset them when recalculation is required.
• Constraint and allowance logic: APPLY_CONSTRAINTS, APPLY_CONSTRAINTS_FY, and APPLY_ALLOW enforce contractual caps, floors, and allowances against calculated rent.
• Posting and invoicing: POST_SUMMARY, POST_SUMMARY_FOR, INSERT_INVOICE, and INSERT_INVOICE_FOR persist summarized results and create invoice lines for the variable rent transactions.
• Support utilities: CACHE_VR_DETAILS caches variable rent detail data for performance during bulk processing, and EXISTS_APPROVED_SALES checks for approved sales data that qualifies the variable rent condition.

Tables Accessed

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

• Variable rent transaction tables: PN_VAR_RENTS_ALL, PN_VAR_TRX_HEADERS_ALL, and PN_VAR_TRX_DETAILS_ALL store the rent definitions, transaction headers, and line details that the package calculates and updates.
• Lease and property master data: PN_LEASES, PN_LEASE_DETAILS_ALL, PN_INDEX_LEASES_ALL, PN_INDEX_LEASE_TERMS_ALL, PN_LOCATIONS_ALL, PN_PROPERTIES_ALL, and PN_PAYMENT_TERMS_ALL provide the lease terms, indexed lease terms, payment terms, and location context required for accurate computation.
• Abatement and constraint configuration: PN_VAR_ABATEMENTS_ALL, PN_VAR_ABAT_DEFAULTS_ALL, PN_VAR_CONSTRAINTS_ALL, PN_VAR_BKPTS_HEAD_ALL, and PN_VAR_BKPTS_DET_ALL supply abatement rules, default abatement settings, constraint definitions, and breakpoint head/detail thresholds used during calculation.

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.