Search Results last_schedule_day

Overview

PN_OPEX_TERMS_PKG is an Oracle Property Manager (ETRM) PL/SQL package owned by the APPS schema. It encapsulates the business logic governing operating expense (opex) payment terms, reconciliation terms, and estimated payment schedules associated with lease agreements. In Oracle EBS 12.1.1 and 12.2.2, this package supports the generation, adjustment, and approval of payment term records that determine when and how much a tenant or landlord owes for recoverable operating expenses tied to a lease. The package is classified as OTHER in the ETRM API taxonomy, meaning it is a supporting internal package rather than a formally published public API. Its procedures read from and write to the family of PN_OPEX and PN_LEASE tables, forming part of the engine behind the Property Manager opex agreement workflow.

Key Procedures and Functions

The documented interface exposes thirteen procedures and functions. The primary creation routines are CREATE_OPEX_PAYMENT_TERMS, which builds estimated payment term and catch-up term records for a lease, and CREATE_RECON_PAY_TERM, which creates reconciliation payment terms keyed to an agreement. LAST_SCHEDULE_DAY determines the final scheduled day of a payment term for a given lease. Several getter functions support downstream logic: GET_CURR_EST_PAY_TERM returns the current estimated payment term for an agreement, GET_LATEST_RECON returns the most recent reconciliation, GET_STMT_DUE_DATE returns a statement due date, and GET_PROP_ID resolves a property identifier from a location. CONTRACT_PREV_EST_TERM handles the carry-forward of a prior estimated term across contracts, while RECON_PCT_CHANGE computes the percentage change associated with a reconciliation.

The procedure most relevant to the search term "delete_agreement" is DELETE_AGREEMENT, which removes an opex agreement and its dependent term data. Approval processing is handled by APPROVE_OPEX_PAY_TERM and its batch counterpart APPROVE_OPEX_PAY_TERM_BATCH, and GET_UNPAID_AMT returns outstanding amounts. These routines collectively manage the term lifecycle from creation through approval, reconciliation, and deletion.

Tables Accessed

The package reads and writes a broad set of ETRM base and _ALL tables via APPS synonyms. Agreement and term records reside in PN_OPEX_AGREEMENTS_ALL, PN_OPEX_EST_PAYMENTS_ALL, and PN_OPEX_RECON_ALL, with reconciliation credits in PN_OPEX_RECON_CRDT_ALL. Supporting configuration and detail tables include PN_OPEX_CRITICAL_DATES_ALL, PN_OPEX_EXP_GRPS_ALL, PN_OPEX_NOTES_ALL, and PN_OPEX_PRORAT_BASIS_DTLS_ALL. Lease context is drawn from PN_LEASES, PN_LEASES_ALL, PN_LEASE_DETAILS, and PN_LEASE_DETAILS_ALL, while PN_LOCATIONS_ALL provides property and location resolution and PN_DISTRIBUTIONS / PN_DISTRIBUTIONS_ALL supply distribution accounting detail.

Usage Notes

PN_OPEX_TERMS_PKG is invoked primarily from Property Manager forms such as the Opex Agreement and Payment Terms windows, and from concurrent programs that generate or approve estimated and reconciliation payment terms in batch. The metadata records zero references by other packages, indicating the package is a top-level consumer rather than a shared library. Customizations should treat DELETE_AGREEMENT and the approval routines with care, since they cascade across the opex term, reconciliation, and distribution tables. Direct modification is generally discouraged in favor of the standard forms and concurrent processes, given the package's internal classification and lack of a published API contract.