Search Results handle_mtm_act

Overview

PN_INDEX_RENT_PERIODS_PKG is an Oracle Property Manager (PN) package in the APPS schema, declared with AUTHID CURRENT_USER. It maintains index rent periods — the date-bounded intervals against which index-based rent adjustments are calculated and applied across a lease's index lease records. The package supports the full lifecycle of these periods: generating them, regenerating them on demand, reversing them, and recomputing them when the underlying lease terms or dates change. Its header history (created March 2001, extended through Bug 5960582 in 2007) reflects its role as a long-lived component of the index rent calculation engine in Oracle EBS release 12.1.1 and 12.2.2.

Key Procedures and Functions

• GENERATE_PERIODS_BATCH — A concurrent-program entry point that generates index rent periods for an index lease, accepting an index lease number and a regenerate flag. It returns the standard errbuf and retcode OUT parameters.
• GENERATE_PERIODS — Generates index rent periods for a single index lease identified by its internal ID and returns a status message.
• PRINT_BASIS_PERIODS — Prints or reports the basis periods associated with an index lease, used for verification and audit of the calculated intervals.
• UNDO_PERIODS — Reverses previously generated index rent periods for a given index lease, allowing a clean regeneration.
• PROCESS_NEW_TERMINATION_DATE — Recomputes index rent periods when a lease receives a new termination date, truncating or adjusting periods that extend beyond the termination.
• GENERATE_BASIS_DATA_CHECK — Performs validation of the data required to generate basis periods before generation proceeds.
• PROCESS_MAIN_LEASE_TERM_DATE — Handles processing of main lease term dates; its signature was modified under Bug 4931780.
• DELETE_PERIODS — Removes index rent periods for an index lease.
• PROCESS_PAYMENT_TERM_AMENDMENT — Processes the impact of a payment term amendment on index rent periods; added in July 2001.
• HANDLE_MTM_ACT — The procedure the user searched for. It handles mark-to-market (MTM) activity on an index lease, driving the recalculation of index rent periods and related financial data in response to a mark-to-market event.
• HANDLE_TERM_DATE_CHANGE — Added under Bug 5960582 (April 2007); coordinates period adjustments when lease term dates change.

Tables Accessed

The package operates primarily on PN_INDEX_LEASES, PN_INDEX_LEASES_ALL, PN_INDEX_LEASE_PERIODS_ALL (the core period store), PN_INDEX_LEASE_TERMS_ALL, PN_INDEX_LEASE_CONSTRAINTS_ALL, and PN_INDEX_EXCLUDE_TERM_ALL, which together define the index lease structure and which terms are excluded from indexing. It also reads and writes related property lease tables — PN_LEASES_ALL, PN_LEASE_DETAILS_ALL, PN_LEASE_DETAILS_HISTORY, PN_LEASE_CHANGES_ALL, PN_PAYMENT_TERMS, PN_PAYMENT_TERMS_ALL, PN_PAYMENT_SCHEDULES_ALL, PN_PAYMENT_ITEMS_ALL, and PN_DISTRIBUTIONS_ALL — so that rent distributions, payment items, and schedules stay consistent with recalculated periods. All access occurs through APPS synonyms.

Usage Notes

Invocation occurs mainly from Oracle Property Manager lease-indexing forms and from concurrent programs such as the batch generation entry point. The package is referenced by three other packages, so it forms part of a broader dependency chain in the index rent calculation flow. Custom or extension code should call the documented public procedures rather than manipulate PN_INDEX_LEASE_PERIODS_ALL directly, because period integrity depends on coordinated updates to payment schedules and distributions. Because the unit uses AUTHID CURRENT_USER, execute privileges on the package and the underlying tables must be granted to the invoking schema.