Search Results create_normalize_items




Overview
Explore in AI Chat

Overview

APPS.PN_SCHEDULES_ITEMS is a core PL/SQL package body within the Oracle Enterprise Asset Management / Property Manager (PN) module of Oracle E-Business Suite, deployed on releases 12.1.1 and 12.2.2. Its principal business function is the generation, normalization, and maintenance of payment schedules and payment items associated with property leases. The package translates the payment terms defined on a lease contract into concrete, dated payment items, applying escalation, contraction, expansion, and index-based adjustments. The header comment in the source identifies the main procedure, referenced by concurrent program executable PNSCHITM, as the orchestrator that calls all other procedures in the package. As documented in the ETRM metadata, the package exposes eighteen procedures and functions and is referenced by seven other packages, confirming its role as a central scheduling engine for lease-related financial processing.

Key Procedures and Functions

The documented procedures serve distinct stages of schedule generation. SCHEDULES_ITEMS is the main entry point invoked by the concurrent program, accepting lease, term, context, and called-from parameters and driving the remaining logic. CREATE_SCHEDULE and CREATE_NORMALIZE_ITEMS build the payment schedule and the normalized (evenly spread) payment items respectively; CREATE_NORMALIZE_ITEMS is the procedure most closely associated with the user search term create_normalize_items, and is responsible for applying a lease payment term's normalize attribute so that amounts are distributed evenly across periods. CREATE_CASH_ITEMS and CREATE_PAYMENT_TERM generate cash items and payment term records, while INSERT_PAYMENT_TERM persists new terms. EXTEND_PAYMENT_TERM and ROLLOVER_LEASE handle term extension and rollover scenarios.

Tables Accessed

The package reads and writes a broad set of PN tables through APPS synonyms. Lease master data is drawn from PN_LEASES, PN_LEASES_ALL, PN_LEASE_DETAILS_ALL, PN_LEASE_DETAILS, and PN_LEASE_DETAILS_HISTORY, with change context provided by PN_LEASE_CHANGES_ALL. Payment term and scheduling data resides in PN_PAYMENT_TERMS_ALL and PN_PAYMENT_SCHEDULES. Generated financial output is stored in PN_DISTRIBUTIONS_ALL, PN_PAYMENT_ITEMS, PN_PAYMENT_ITEMS_ALL, and PN_PAYMENT_ITEMS_S. Index-based lease adjustments rely on PN_INDEX_LEASES_ALL and PN_INDEX_LEASE_PERIODS_ALL, and location references are resolved through PN_LOCATIONS_ALL. These tables collectively support the derivation, storage, and updating of dated payment obligations.

Usage Notes

PN_SCHEDULES_ITEMS is normally invoked indirectly through the PNSCHITM concurrent program, which executes SCHEDULES_ITEMS with the standard errbuf and retcode arguments plus lease and term identifiers. Lease context values (ABS, EXP, CON, ADD) and called-from values (MAIN, IND, VAR) determine which internal branches execute. Because the package is referenced by seven other packages, custom code and forms should call the public procedures rather than replicate scheduling logic. Direct modification of generated payment items should use UPDATE_CASH_ITEM to preserve normalization and distribution integrity.