Search Results create_payment_term

Overview

PN_SCHEDULES_ITEMS is an Oracle EBS property management (PN) package owned by the APPS schema. It is the core engine responsible for generating, normalizing, and recalculating payment schedules and payment items for lease agreements. Within Oracle Property Manager, lease financial terms must be decomposed into periodic payment items that drive rent accruals, cash forecasting, and distribution accounting. PN_SCHEDULES_ITEMS performs that decomposition by reading lease, lease detail, and payment-term definitions and producing the schedule rows stored in PN_PAYMENT_ITEMS and PN_PAYMENT_SCHEDULES. The package is registered as VALID in the E-Business Suite environment and belongs to the OTHER API classification, meaning it is an internal supporting package rather than a public, frozen interface. It is tightly coupled to the lease lifecycle: schedule creation, term extension, rollover, indexation, retroactive adjustment, and normalization all funnel through it. Because so many sibling packages call into it, PN_SCHEDULES_ITEMS behaves as a shared utility layer for schedule mathematics across the property management module.

Key Procedures and Functions

The documented 18 procedures and functions divide into schedule generation, amount retrieval, and maintenance utilities.

• SCHEDULES_ITEMS — The package's principal driver, orchestrating creation or regeneration of schedule items for a lease.
• CREATE_SCHEDULE / CREATE_NORMALIZE_ITEMS / CREATE_CASH_ITEMS — Build the base schedule, the normalization items used for straight-line treatment, and the cash-basis items respectively.
• CREATE_PAYMENT_TERM / INSERT_PAYMENT_TERM / EXTEND_PAYMENT_TERM — Create new payment terms, insert term rows, and extend existing terms when a lease is prolonged.
• GET_AMOUNT / GET_PRO_AMT — Return calculated amounts and pro-rated amounts for a given period.
• RECALCULATE_CASH / UPDATE_CASH_ITEM — Recompute and persist cash items after changes to terms.
• GET_FREQUENCY / FIRST_DAY / GET_SCHEDULE_DATE / GET_SCH_START — Date and frequency helpers that determine periodicity and schedule boundaries.
• GET_LEASE_CHANGE_ID — Resolves the lease change context associated with a schedule action.
• ROLLOVER_LEASE — Supports lease rollover processing and regeneration of future schedule items.
• NORM_REPORT — Produces supporting output for normalization reporting.

Tables Accessed

The package reads lease definition and history data from PN_LEASES, PN_LEASES_ALL, PN_LEASE_DETAILS, PN_LEASE_DETAILS_ALL, and PN_LEASE_DETAILS_HISTORY, together with PN_LEASE_CHANGES_ALL for amendment context and PN_LOCATIONS_ALL for location attributes. Payment term definitions come from PN_PAYMENT_TERMS_ALL and PN_PAYMENT_ITEMS_ALL. Generated schedule results are written to PN_PAYMENT_ITEMS, PN_PAYMENT_ITEMS_S, and PN_PAYMENT_SCHEDULES. Indexation logic reads PN_INDEX_LEASES_ALL and PN_INDEX_LEASE_PERIODS_ALL, while distribution accounting interacts with PN_DISTRIBUTIONS_ALL. These relationships confirm the package spans the full lease financial model.

Usage Notes

PN_SCHEDULES_ITEMS is not intended for direct external invocation. It is called by seven dependent packages, including PNT_PAYMENT_TERMS_PKG, PN_APPROVE_VARENT_PKG, PN_INDEX_AMOUNT_PKG, PN_INDEX_RENT_PERIODS_PKG, PN_NORM_RENORM_PKG, PN_OPEX_TERMS_PKG, and PN_RETRO_ADJUSTMENT_PKG. These callers are triggered from Property Manager forms and concurrent programs that create or amend leases, apply index adjustments, approve variances, process operating expense terms, or perform retroactive adjustments. Customizations should not call the package directly; rather, they should invoke the appropriate public entry point so that schedule, normalization, and cash items remain synchronized with the lease change table. All processing is subject to standard APPS schema privileges and the Property Manager application setup.