Search Results pn_var_abatements_pkg




Overview
Explore in AI Chat

Overview

The APPS.PN_VAR_ABATEMENTS_PKG package is a PL/SQL API within Oracle Property Manager (the PN product family) that manages variable rent abatement records. Variable rent abatements represent negotiated reductions or free-rent concessions applied against variable or percentage rent obligations, typically tied to sales-based lease terms. In Oracle EBS 12.1.1 and 12.2.2, this package functions as the underlying programmatic layer that maintains the abatement data stored in the PN_VAR_ABATEMENTS entity, supporting the calculation engine that determines final rent charges. The package is classified as an OTHER API, indicating it is primarily an internal procedural component rather than a formally published public interface. It is registered in the APPS schema with a status of VALID and depends on the SYS.STANDARD package. Its principal consumer is PN_VAR_RENT_CALC_PKG, which drives variable rent calculation logic, and it is also referenced by the database view PN_VAR_TERMS_V, confirming that abatement data is exposed through the terms view for inquiry and reporting.

Key Procedures and Functions

The package exposes twelve documented procedures and functions that form a complete maintenance and validation API for the abatement entity:

  • INSERT_ROW — creates a new variable rent abatement record for a lease term.
  • UPDATE_ROW — modifies an existing abatement record.
  • DELETE_ROW — removes an abatement record.
  • LOCK_ROW — obtains a row-level lock to support concurrent-safe maintenance.
  • CHECK_CALC_INV_EXISTS — verifies whether calculated invoices exist that would constrain changes to the abatement data.
  • CHECK_TRUE_UP_INVOICE — determines whether a true-up invoice exists, a prerequisite for validating adjustments.
  • ABTMT_EXISTS — tests for the prior existence of an abatement on the term.
  • ROLL_FWD_ON_UPD — controls roll-forward behavior when an abatement is updated.
  • ROLL_FWD_FST_ON_UPD — manages roll-forward processing of a first-period or similar abatement variant during update.
  • RESET_UPDATE_FLAG — clears the internal update indicator after processing.
  • GET_INCLUDE_TERM — returns whether the term is included in abatement treatment.
  • GET_INCLUDE_INCREASES — returns whether rent increases are included in the abatement calculation.

Together these routines enforce business rules around when abatement data may be changed and how downstream rent calculations are re-derived.

Tables Accessed

The package operates against the following application tables (accessed via APPS synonyms):

Usage Notes

This package is not intended for direct end-user invocation. It is called programmatically by PN_VAR_RENT_CALC_PKG during variable rent calculation and by the PN_VAR_TERMS_V view. In Oracle Property Manager, abatement data is typically entered or adjusted through the Lease Terms or Variable Rent windows; those forms ultimately invoke this package's INSERT, UPDATE, DELETE, and LOCK routines. The validation functions (CHECK_CALC_INV_EXISTS, CHECK_TRUE_UP_INVOICE) prevent users from altering abatements once invoicing has occurred, preserving audit integrity. Custom extensions that add abatement logic should reuse these procedures rather than writing directly to the underlying tables, ensuring that roll-forward flags and update indicators remain consistent. Because the package is APPS-owned and VALID in both 12.1.1 and 12.2.2, no version-specific signature differences are expected; however, any code referencing it should be revalidated after patching, as dependency changes can invalidate the package body.