Search Results pn_payment_schedules_s




Overview
Explore in AI Chat

Overview

The PL/SQL package body APPS.PN_MODIFY_PMT_SCHED is a component of the Oracle Property Manager (PN) module, which is used to administer real estate leases, payment schedules, and related financial obligations within Oracle E-Business Suite. As its name indicates, the package encapsulates the business logic required to modify payment schedules and the associated payment items that constitute those schedules. In Oracle Property Manager, a payment schedule defines the timing and amount of recurring or one-time payments owed under a lease, while payment items represent the individual line-level components of that schedule. Because these records are contractually sensitive and frequently span multiple periods, any change to them must be applied consistently across the parent schedule and its dependent items.

The package serves as the programmatic point of control for such changes, allowing schedule and item records to be adjusted in a coordinated fashion rather than through ad hoc DML against the base tables. This protects data integrity across the PN_PAYMENT_SCHEDULES and PN_PAYMENT_ITEMS entity pairs and their associated interface tables. The metadata classifies the package as an "OTHER" API, meaning it is not an explicitly published public interface, but it remains a valid, compiled object in the APPS schema and is exposed to the application layer.

Key Procedures and Functions

The documented package body exposes a single procedure:

  • MODIFY_SCHED_AND_ITEMS — This procedure performs the combined modification of payment schedules and their associated payment items. Its purpose is to apply changes to an existing schedule while keeping the corresponding item records synchronized. In practice this centralizes the validation and update logic so that callers do not have to orchestrate the two entities independently. No documented parameter list is published in the ETRM metadata, and its exact signature should be confirmed by inspecting the package source in the database.

Tables Accessed

The package references the following objects, resolved through APPS synonyms:

  • PN_PAYMENT_SCHEDULES_ALL and PN_PAYMENT_SCHEDULES_S — the base and sequence/primary-key tables holding payment schedule headers. These are the primary targets for schedule-level modification.
  • PN_PAYMENT_ITEMS_ALL and PN_PAYMENT_ITEMS_S — the base and key tables for individual payment items. These explain the search term pn_payment_items_s, since the package references this table and depends on the sequence used to generate item identifiers during inserts.
  • PN_PAYMENT_TERMS_ALL — the payment terms definition table, consulted to validate or derive term-related attributes when schedules are altered.
  • PN_LEASES_V — a lease view used to validate the lease context of the schedule being modified.
  • DUAL — the standard Oracle single-row utility table, typically used for sequence retrieval or scalar evaluation.

Usage Notes

PN_MODIFY_PMT_SCHED is an internal package that is not referenced by any other database object, and therefore most commonly invoked from Oracle Property Manager forms or from concurrent programs that manage lease payment data, rather than from a documented public API surface. The ETRM metadata confirms it is referenced by zero other packages, indicating that direct callers are external to the PL/SQL dependency chain — typically the forms layer or custom extensions. Developers extending Property Manager functionality who need to modify existing schedules and items should generally prefer this packaged logic over direct DML, because it applies the module's validations and keeps the _ALL and _S table pairs consistent. When writing custom code that calls this package, care should be taken to obtain the exact procedure signature from the database, since the ETRM documentation does not publish parameter details.