Results for “exp_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PN_VAR_TRUEUP_PKG is a property management package body within the Oracle E-Business Suite Property Manager (PN) module. Its principal business function is the calculation and posting of true-up adjustments for variable rent arrangements. Variable rent, common in retail leasing, ties a tenant's rent obligation to a percentage of reported sales. When actual sales for a reporting period are known, the system must reconcile estimated or provisional rent billed in advance against the rent that was contractually owed, generating a true-up (either an additional charge or a credit). This package performs that reconciliation.

The package maintains several package-level collections declared as associative arrays of a record type (two_nums_rec) holding a period identifier and an amount. These global collections accumulate abatement applied, allowance applied, un-abated rent, abated rent, and total abatement across processing steps. A global flag, G_IS_TU_CONC_FLAG, distinguishes whether the package was invoked as part of a standard calculation versus a true-up run, and g_precision governs monetary rounding. The header comment indicates the package has been maintained under version control since at least 2009 (PNVRTRPB.pls, version 120.0.12010000.2).

Key Procedures and Functions

The package exposes fourteen documented program units:

• CAN_DO_TRUEUP — A Boolean function determining whether true-up processing is permissible for a given variable rent and period. It tests for the existence of transaction headers carrying reported group sales and whether approved sales records exist for the period.
• POST_SUMMARY_TRUEUP — Posts the summarized true-up results, presumably writing the consolidated adjustment to the invoice interface.
• INSERT_INVOICE_TRUEUP — Inserts true-up invoice lines into the variable rent invoice tables.
• APPLY_ABATEMENTS — Applies abatement rules to the computed true-up amounts.
• APPLY_ALLOW — Applies allowance amounts against rent due.
• APPLY_ABAT — Applies abatement to individual calculation records.
• POPULATE_ABAT — Populates the abatement collections used in subsequent calculations.
• RESET_ABATEMENTS — Clears previously accumulated abatement values, supporting repeat or re-run processing.
• GET_DATED_ALLOW — Retrieves date-effective allowance information for a given period.
• POPULATE_NEG_RENT — Populates negative rent (credit) figures arising from true-up.
• APPLY_DEF_NEG_RENT — Applies default negative rent handling rules.
• CALCULATE_TRUEUP — The core calculation routine producing the true-up amount for the period.
• TRUEUP_BATCH_PROCESS — The batch driver that iterates processing across multiple variable rent arrangements.
• SET_TRUEUP_FLAG — Sets the package-level indicator controlling true-up versus calculation behavior.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

• PN_VAR_RENTS / PN_VAR_RENTS_ALL — The variable rent definitions and their translated/attribute rows.
• PN_VAR_GRP_DATES / PN_VAR_GRP_DATES_ALL — Reporting group date ranges used to determine approved sales periods.
• PN_VAR_PERIODS_ALL — Variable rent reporting periods, providing end dates for period validation.
• PN_VAR_RENT_DATES_ALL — Date-effective rent rate information.
• PN_VAR_RENT_INV / PN_VAR_RENT_INV_ALL — Variable rent invoice records where true-up lines are written.
• PN_VAR_ABAT_DEFAULTS_ALL and PN_VAR_BKPTS_HEAD_ALL — Abatement defaults and breakpoint header definitions.
• PN_LEASES / PN_LEASES_ALL, PN_LOCATIONS_ALL, PN_PROPERTIES_ALL, PN_PAYMENT_TERMS_ALL — Lease, location, property, and payment term master data supplying context for invoice generation.

Usage Notes

PN_VAR_TRUEUP_PKG is typically invoked from the Property Manager variable rent calculation and true-up flows, most commonly through the true-up batch concurrent program that drives TRUEUP_BATCH_PROCESS. It is also referenced by one additional package, indicating programmatic reuse. The search term "exp_code" is relevant because true-up adjustments frequently carry an expenditure or accounting code that distinguishes the true-up charge from ordinary rent billing; the invoice insertion logic must resolve the appropriate code before posting to the invoice interface. Customizations should call CAN_DO_TRUEUP before attempting processing, and must set the true-up flag and reset abatement collections between runs to avoid residual accumulation in the package-level arrays.