Search Results ten_recoverable_area

Overview

PN_REC_CALC_PKG is the recoverability calculation engine within the Oracle Property Manager (PN) module of Oracle E-Business Suite. The package encapsulates the business logic required to compute recoverable amounts on lease agreements, typically for tenants operating under operating lease or real estate arrangements where landlords and tenants allocate common-area maintenance, taxes, insurance, and other recoverable expenses. In Oracle EBS 12.1.1 and 12.2.2, the package is owned by the APPS schema and is documented as VALID with an API classification of OTHER, indicating it is an internally consumed calculation utility rather than a formally published public API.

The core business function is to determine, for a given billing period, how much of a landlord's incurred expense or a tenant's actual recovery is recoverable, and then to persist that determination into the period billing and period line tables that drive downstream invoicing and reconciliation. The package sits between raw agreement setup data (payment terms, clauses, abatements, constraints, and recoverable area configurations) and the billed recovery records that ultimately reach subledger accounting.

Key Procedures and Functions

The documented procedures and functions fall into several functional groups:

• Amount calculation: CALCULATE_REC_AMOUNT and CALCULATE_REC_AMOUNT_BATCH are the primary entry points; the batch variant processes multiple agreements or periods in a single invocation.
• Area and expense retrieval: GET_RECOVERABLE_AREA, TEN_RECOVERABLE_AREA, and GET_TOT_PROP_AREA resolve recoverable and total property areas used as allocation bases. GET_LINE_EXPENSES, GET_BUDGET_EXPENSES, and GET_BILLED_RECOVERY retrieve actual, budgeted, and billed expense components, while GET_CONTR_ACTUAL_RECOVERY derives contractual actual recovery.
• Clause and term retrieval: GET_LINE_CONSTRAINTS and GET_LINE_ABATEMENTS return the constraint and abatement rules that cap or reduce recoverable amounts.
• Period line maintenance: FIND_IF_PERIOD_LINE_EXISTS, INSERT_PERIOD_LINES_ROW, UPDATE_PERIOD_LINES_ROW, and DELETE_PERIOD_LINES_ROW provide create/read/update/delete access to period line records.
• Period billing maintenance: FIND_IF_PERIOD_BILLREC_ROW equivalents, INSERT_PERIOD_BILLREC_ROW, UPDATE_PERIOD_BILLREC_ROW, and DELETE_PERIOD_BILLREC_ROW manage the associated billing records.
• Payment terms: CREATE_PAYMENT_TERMS and FIND_IF_REC_PAYTERM_EXISTS manage recoverable payment term rows arising from the calculation.

Tables Accessed

The package reads and writes a tightly scoped set of Property Manager base and transaction tables through APPS synonyms. Agreement definition data is sourced from PN_REC_AGREEMENTS_ALL, PN_REC_AGR_LINES_ALL, PN_REC_AGR_LINCONST_ALL, and PN_REC_AGR_LINABAT_ALL. Calculation configuration is read from PN_REC_CALC_PERIODS_ALL, PN_REC_ARCL_DTL_ALL, PN_REC_ARCL_DTLLN_ALL, and PN_REC_EXPCL_DTLLN_ALL. Output is persisted to PN_REC_PERIOD_LINES_ALL, PN_REC_PERIOD_BILL_ALL, and PN_PAYMENT_TERMS_ALL. Related lease and distribution data is referenced from PN_LEASES, PN_LEASES_ALL, PN_DISTRIBUTIONS, and PN_DISTRIBUTIONS_ALL. GL_SETS_OF_BOOKS is referenced to resolve ledger context.

Usage Notes

PN_REC_CALC_PKG is referenced internally by the package itself and by PN_SCHEDULES_ITEMS, confirming it is invoked during schedule generation rather than directly by end users. It is typically triggered from the Property Manager recoverability calculation concurrent programs and related forms, and may be called from custom PL/SQL where organizations extend recoverability logic. Because it writes to period line and period billing tables, custom callers should respect transaction boundaries and avoid invoking procedures concurrently for the same agreement and period.