Search Results get_term_exists




Overview
Explore in AI Chat

Overview

The APPS.PN_VAR_ABATEMENT_AMOUNT_PKG package belongs to the Oracle Property Manager (PN) module of Oracle E-Business Suite. Its primary business function is to compute and process variable rent abatement amounts associated with variable rent invoices. Variable rent in Property Manager represents rent calculated from a tenant's reported sales or usage rather than a fixed contractual figure, and abatements represent negotiated reductions or free-rent concessions applied against that variable rent. This package encapsulates the logic needed to determine how much abatement should be applied to a given variable rent invoice across one or more grouping date ranges. It is classified as an OTHER API within the ETRM 12.2.2 metadata, indicating that it is an internal supporting package rather than a formally published open interface. The package header was last revised under the source control tag PNVRCABS.pls 120.2, reflecting its role as a stable, long-lived calculation engine within the Property Manager variable rent subsystem.

Key Procedures and Functions

The metadata documents five program units. As declared in the package specification, the two global constants G_INCLUDE_TERM_YES and G_INCLUDE_TERM_NO hold the values 'Y' and 'N' respectively and govern whether payment terms are considered during abatement evaluation.

  • CALC_ABATEMENT — Appears as two overloaded functions. One signature calculates an abatement amount for a variable rent invoice across a minimum and maximum grouping date range. The second overload adds a variable rent identifier, period identifier, invoice identifier, grouping dates, and a transaction reporting (TRP) flag, allowing calculation scoped to a specific variable rent period. Both return a numeric abatement value.
  • PROCESS_ABATEMENT — A procedure that drives the abatement processing workflow. Its parameters include the variable rent invoice, a negative rent flag, the p_term_exists indicator, the variable rent type, and the minimum and maximum grouping dates. This is the orchestration routine that applies abatement results to the invoice.
  • GET_GROUP_DT — A function returning a date derived from an invoice date, period identifier, and date type. It resolves the appropriate grouping date used when aggregating variable rent for abatement purposes.
  • GET_TERM_EXISTS — A function that accepts a payment term identifier and a variable rent invoice identifier and returns a VARCHAR2 value, typically 'Y' or 'N', indicating whether a qualifying payment term exists for that invoice. This aligns with the G_INCLUDE_TERM_YES/G_INCLUDE_TERM_NO constants, which are passed downstream as the p_term_exists argument to PROCESS_ABATEMENT.

Tables Accessed

The package reads and writes through APPS synonyms across the Property Manager schema. PN_VAR_RENTS_ALL, PN_VAR_PERIODS_ALL, and PN_VAR_GRP_DATES_ALL supply the variable rent definitions, period boundaries, and grouping date information. PN_VAR_RENT_INV_ALL and PN_VAR_ABATEMENTS_ALL hold the invoice and abatement records that are updated. PN_PAYMENT_TERMS_ALL, PN_PAYMENT_SCHEDULES_ALL, and PN_PAYMENT_ITEMS_ALL provide payment term and schedule details required by GET_TERM_EXISTS and the abatement calculation. DUAL is used for singleton lookups.

Usage Notes

This package is referenced by two other packages and is typically invoked from Property Manager concurrent programs and forms that generate or recalculate variable rent invoices. The GET_TERM_EXISTS function is often called first to establish whether payment terms apply, before PROCESS_ABATEMENT is executed. Custom integrations should treat this as an internal API and avoid direct invocation unless replicating standard Property Manager behavior.