Search Results get_dated_allow




Overview
Explore in AI Chat

Overview

PN_VAR_TRUEUP_PKG is an Oracle Property Manager (PN) PL/SQL package owned by APPS and declared with AUTHID CURRENT_USER, meaning its unqualified references resolve against the invoking schema's synonym set rather than the owner's. It is classified as an OTHER API rather than a maintained public interface. The package implements the variable rent true-up logic used during the reconciliation stage of percentage rent processing. In Property Manager, tenants subject to variable (percentage) rent report actual sales for a period, and the application compares those sales against breakpoint thresholds, applies abatements, allowances, and negative rent defaults, and then posts the resulting adjustment. PN_VAR_TRUEUP_PKG encapsulates that entire calculation and posting sequence, from eligibility checks through invoice creation, so that true-up amounts computed for a variable rent period are reflected correctly on the tenant's rent invoice.

Key Procedures and Functions

  • SET_TRUEUP_FLAG — Sets the true-up indicator for a variable rent record or period. This is the entry point most commonly reached when a user or program needs to mark a period as eligible for, or as having undergone, true-up processing.
  • CAN_DO_TRUEUP — Function that returns a Boolean indicating whether true-up may proceed for a given variable rent record and period.
  • CALCULATE_TRUEUP — Performs the core true-up amount calculation for a variable rent record as of a supplied period date.
  • POST_SUMMARY_TRUEUP — Posts the summarized true-up result, honoring a proration rule.
  • INSERT_INVOICE_TRUEUP — Creates the invoice line(s) associated with the computed true-up.
  • APPLY_ABATEMENTS — Drives abatement application for the period, accepting a controlling flag.
  • APPLY_ALLOW — Applies dated allowances held in the ALLOW_TBL collection and returns the abated rent.
  • APPLY_ABAT — Applies abatement amounts to the period, returning the abated rent.
  • POPULATE_ABAT — Populates abatement data for the period and invoice context.
  • RESET_ABATEMENTS — Clears previously applied abatement data for a variable rent record.
  • GET_DATED_ALLOW — Function returning the subset of allowances that fall within a given date range.
  • POPULATE_NEG_RENT — Populates negative rent amounts and returns the abated rent.
  • APPLY_DEF_NEG_RENT — Applies default negative rent values, returning the abated rent.
  • TRUEUP_BATCH_PROCESS — Concurrent-program entry point, exposing errbuf/retcode and selection parameters such as property code and lease number range.

Tables Accessed

The package reads and writes the core Property Manager variable rent schema. PN_VAR_RENTS and PN_VAR_RENTS_ALL hold variable rent definitions and their multi-organization rows; PN_VAR_PERIODS_ALL holds the reporting periods; PN_VAR_RENT_DATES_ALL and PN_VAR_GRP_DATES / PN_VAR_GRP_DATES_ALL supply date ranges used for breakpoint and proration logic; PN_VAR_BKPTS_HEAD_ALL stores breakpoint thresholds; PN_VAR_ABAT_DEFAULTS_ALL and PN_VAR_RENT_INV / PN_VAR_RENT_INV_ALL support abatement defaults and the invoice linkage created by the true-up. Lease, property, location, and payment terms information is drawn from PN_LEASES, PN_LEASES_ALL, PN_PROPERTIES_ALL, PN_LOCATIONS_ALL, and PN_PAYMENT_TERMS_ALL.

Usage Notes

Because SET_TRUEUP_FLAG and the surrounding procedures are not part of a formally published API set, direct calls should be treated as an extension or integration point rather than a guaranteed interface, and they are not upward-compatible across releases without validation. Typical invocation paths are the Property Manager variable rent windows, where true-up is triggered interactively, and the TRUEUP_BATCH_PROCESS concurrent program for bulk lease selection. Custom code should favor the batch entry point with its errbuf/retcode contract, or invoke CAN_DO_TRUEUP before SET_TRUEUP_FLAG to confirm eligibility. Any wrapper must respect the AUTHID CURRENT_USER semantics and ensure the APPS synonyms are visible to the calling schema.