Search Results pn_modify_pmt_sched




Overview
Explore in AI Chat

Overview

PN_MODIFY_PMT_SCHED is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Project Billing and Project Payments functionality within the Oracle Project Management (PA/PN) module. Its principal business role is to modify payment schedules and their associated payment items that govern how project-related invoices and payments are generated for contracts and project agreements. The package is classified as an "OTHER" API in the ETRM documentation, meaning it is not part of the officially supported public Oracle Integration API set, but is instead an internal helper package invoked by Oracle's own application code to manipulate the payment scheduling data stored in the PN (Project Payments) tables.

Key Procedures and Functions

The package exposes a single documented program unit:

  • MODIFY_SCHED_AND_ITEMS — As the name indicates, this procedure modifies both a payment schedule record and its dependent payment items in a coordinated fashion. Its purpose is to update an existing payment schedule definition and, in the same logical unit of work, adjust the payment items that reference that schedule so that the schedule and its items remain consistent. This avoids raising orphaned or inconsistent payment items when schedule-level attributes (such as dates, amounts, or term references) are changed.

No parameter list is documented in the ETRM metadata; consumers should treat the procedure as an internal routine rather than a callable public interface. Invocation by custom code is discouraged unless the calling program fully reproduces the pre- and post-validation that Oracle's internal callers perform.

Tables Accessed

The package reads and writes the following tables (accessed through APPS synonyms):

  • PN_PAYMENT_SCHEDULES_ALL — The base table storing payment schedule headers, including effective dates and schedule-level attributes. MODIFY_SCHED_AND_ITEMS updates the schedule row here.
  • PN_PAYMENT_SCHEDULES_S — The translated (TL) companion of the ALL table, holding language-specific schedule text such as schedule names and descriptions.
  • PN_PAYMENT_ITEMS_ALL — Stores the individual payment items belonging to a schedule, such as milestone amounts or percentage splits. These are the rows the procedure modifies alongside the schedule.
  • PN_PAYMENT_ITEMS_S — The translated companion of the items table, holding language-specific item text.
  • PN_PAYMENT_TERMS_ALL — Holds payment term definitions referenced by schedules and items, used to validate or re-derive term-driven attributes.
  • DUAL — The standard Oracle single-row utility table, typically used for simple value derivation or existence checks within the procedure.

Usage Notes

PN_MODIFY_PMT_SCHED is not a standalone concurrent program and does not appear on any standard Oracle form as a directly invoked client. Instead it is called from within Oracle's Project Payments transaction flows—most commonly when a user edits a payment schedule through the Project Payments or Project Billing user interface, or when a billing process needs to recalculate schedule and item details. The ETRM metadata records no other package referencing PN_MODIFY_PMT_SCHED, indicating that its callers reside in forms or PL/SQL libraries rather than in dependent database packages.

Because the package manipulates the underlying PN payment tables directly, any custom extension that calls MODIFY_SCHED_AND_ITEMS must respect the same ordering, validation, and concurrency rules as Oracle's internal callers, and should execute within the appropriate transaction context. Direct DML against PN_PAYMENT_SCHEDULES_ALL and PN_PAYMENT_ITEMS_ALL is strongly discouraged when this package can be used, since bypassing it risks creating schedule/item inconsistencies.