Search Results pn_distributions_pkg




Overview
Explore in AI Chat

Overview

PN_DISTRIBUTIONS_PKG is an APPS-owned PL/SQL package within the Oracle Property Manager (PN) module of Oracle E-Business Suite. Property Manager manages real estate leases, payment terms, and the accounting distributions that arise from lease obligations. This package encapsulates the core data-manipulation logic for distribution records stored in the PN_DISTRIBUTIONS_ALL table and its related setup tables. In the 12.1.1 and 12.2.2 releases, the package is validated, with both a package specification and package body present in the APPS schema, and is classified as an OTHER API rather than a formally published public API. Its principal responsibility is to provide a stable, reusable layer through which other Property Manager components insert, update, lock, and delete distribution rows, shielding callers from the physical layout and sequencing requirements of the underlying tables. Because distributions feed lease accounting, payment schedules, operating expense calculations, and recurring billing, this package sits on a critical path for lease financial data integrity.

Key Procedures and Functions

The documented interface exposes four procedures. Only their purposes are described here; parameter signatures are not invented.

  • INSERT_ROW — Creates a new distribution record. It is the standard entry point for persisting a distribution generated by lease calculations, schedules, or term processing.
  • UPDATE_ROW — Modifies an existing distribution record, allowing corrected or recalculated distribution values to be written back without direct table access.
  • LOCK_ROW — Acquires a lock on a distribution row, providing concurrency control so that a caller can safely read, validate, and subsequently modify the record within the same transaction.
  • DELETE_ROW — Removes a distribution record, used when lease terms change, schedules are regenerated, or distribution data is otherwise superseded.

Collectively these procedures implement a conventional create/read-modify/delete contract for the distribution entity.

Tables Accessed

The package operates against the following tables, referenced through APPS synonyms:

  • PN_DISTRIBUTIONS_ALL — The primary transactional table holding distribution records; the target of insert, update, lock, and delete operations.
  • PN_DISTRIBUTIONS_S — The sequence/identifier source used to allocate or validate distribution identifiers during row creation.
  • PN_PAYMENT_TERMS and PN_PAYMENT_TERMS_ALL — Payment term definitions consulted to derive or validate the financial attributes associated with a distribution.
  • PN_TERM_TEMPLATES_ALL — Term template definitions that supply default or governing terms for generated distributions.
  • DUAL — Used for singleton evaluations and scalar lookups within package logic.

Usage Notes

PN_DISTRIBUTIONS_PKG is referenced by six other packages — PN_INDEX_AMOUNT_PKG, PN_LEASE_PVT, PN_OPEX_TERMS_PKG, PN_REC_CALC_PKG, PN_SCHEDULES_ITEMS, and PN_VARIABLE_TERM_PKG — indicating that it is invoked internally by lease, payment term, operating expense, recurring calculation, schedule, and variable term processing rather than by external applications. In typical EBS operation it is called from Property Manager forms and concurrent programs that generate or regenerate lease distributions, and it should be treated as an internal module API. Customizations should avoid direct DML against PN_DISTRIBUTIONS_ALL and instead route changes through this package to preserve identifier allocation, locking, and dependency behavior. Because it is classified as OTHER rather than a frozen public API, its interface may change across patches; custom code depending on it should be regression-tested on upgrade to 12.1.1 or 12.2.2.