Results for “pn_norm_renorm_pkg”
43 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PN_NORM_RENORM_PKG is an Oracle Applications (APPS) PL/SQL package body that belongs to the Property Manager (PN) module of Oracle E-Business Suite. The package encapsulates the normalization and renormalization logic used for lease payment schedules and payment items. In lease management, payment schedules and payment items are frequently stored in a form that must be aligned to standardized periods, lease terms, and payment frequencies before they can be reported, invoiced, or interfaced to downstream financial processes. Normalization produces a consistent representation of lease payment data, while renormalization recalculates or re-aligns that representation whenever underlying lease attributes change, such as changes to lease details, payment terms, or schedule definitions. The object is documented as VALID with owner APPS in ETRM 12.2.2 and is classified as an OTHER API, meaning it is an internal utility package rather than a publicly supported interface. It is not referenced by any other database object, confirming that it is an internal building block in the Property Manager data model.
Key Procedures and Functions
The ETRM metadata documents a single procedure or function:
- NORMALIZE_RENORMALIZE — The central routine that performs both normalization and renormalization of payment schedule and payment item data. Its purpose is to transform or re-transform the lease payment records so that scheduled amounts, dates, and item distributions conform to the active lease terms and schedule definitions. Parameter lists are not published in the documentation; only the procedure name and behavior are documented.
The metadata further identifies dependencies on the utility package PNP_DEBUG_PKG, which provides debugging and tracing output, and on PN_MO_CACHE_UTILS, which supplies cached lease data. The presence of PNP_DEBUG_PKG indicates that NORMALIZE_RENORMALIZE supports diagnostic logging during execution.
Tables Accessed
The package references the following tables, all through APPS synonyms:
- PN_PAYMENT_ITEMS_ALL — Stores lease payment item records; these are read and updated as part of item-level normalization.
- PN_PAYMENT_ITEMS_S — The sequence or primary key source for payment items; referenced in the context of the user's search term pn_payment_items_s. This table supplies the surrogate identifiers used when inserting or renumbering item rows.
- PN_PAYMENT_SCHEDULES_ALL — Holds the payment schedule headers associated with a lease; read and written to align schedule periods and amounts.
- PN_SCHEDULES_ITEMS — Defines the schedule item structure that drives how payments are broken into items during normalization.
- PN_LEASES_ALL and PN_LEASES — Lease header data, used to obtain lease context such as term and currency.
- PN_LEASE_DETAILS_ALL — Lease detail records that constrain normalization rules.
- PN_LEASE_CHANGES_ALL — Change records that trigger renormalization when lease attributes are modified.
- PN_PAYMENT_TERMS_ALL — Payment terms that determine the timing and frequency of normalized payment items.
- DUAL — Used for single-row utility constructs.
- PLITBLM — A PL/SQL-supplied table used internally by the runtime for bulk operations.
Currency handling is supported through FND_CURRENCY, and profile options are read via FND_PROFILE, allowing normalization to respect the functional currency and site-level settings.
Usage Notes
Because PN_NORM_RENORM_PKG is classified as an OTHER API and is not referenced by any database object, it is intended for internal use within the Property Manager module. It is typically invoked by Oracle Property Manager forms and concurrent programs when lease payment schedules and payment items must be synchronized with lease terms, or when lease changes or payment term modifications require recalculation. Custom code should invoke it only with full awareness that the interface is unsupported and subject to change. The dependency on PN_LEASE_CHANGES_ALL suggests the routine is called during lease change processing to renormalize affected payment schedules and items. For debugging, the package leverages PNP_DEBUG_PKG, so DBMS output can be enabled through the standard Property Manager debug profile options when tracing its execution.
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: APPS.PN_LEASES 12.1.1
-
SYNONYM: APPS.PN_LEASES_ALL 12.1.1
-
SYNONYM: APPS.PN_LEASES 12.2.2
-
SYNONYM: APPS.PN_LEASES_ALL 12.2.2
-
SYNONYM: PUBLIC.DUAL 12.1.1
-
SYNONYM: PUBLIC.DUAL 12.2.2
-
SYNONYM: PUBLIC.PLITBLM 12.1.1
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: PUBLIC.PLITBLM 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1