Results for “x_ex”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PN_RIGHTS_PKG is a PL/SQL package in the APPS schema that supports the Oracle Property Manager (PN) module's rights processing functionality. Oracle Property Manager manages real estate leases, rights, and related financial obligations. Within that framework, the rights entity represents a party's or organization's interests in a lease—such as usage rights, access rights, or other contractual entitlements—and this package provides the core data manipulation interface for the PN_RIGHTS_ALL table and its associated history and audit structures.
The package is classified as OTHER in the ETRM metadata, meaning it is not an API explicitly published for external integration use, but rather an internal package used by Oracle Property Manager's own forms, concurrent processes, and dependent packages. It operates on the base tables directly via APPS synonyms and implements the standard Oracle Forms "table handler" pattern—INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW—that forms-based EBS modules rely on to persist user-entered changes.
Key Procedures and Functions
The package exposes four documented procedures:
- INSERT_ROW — Creates a new rights record. It inserts a row into PN_RIGHTS_ALL, populating the operational columns from the form block, and also writes the corresponding history and audit rows into the associated _H (history) and _S (security/audit) tables so that a complete change trail is retained.
- LOCK_ROW — Acquires a row-level lock on a specific rights record, typically via a SELECT ... FOR UPDATE, to prevent concurrent modification while a user is editing the record in the form. This is standard behaviour for an Oracle Forms on-lock trigger.
- UPDATE_ROW — Applies changes made to an existing rights record, updating PN_RIGHTS_ALL and synchronously updating the related history and audit tables (PN_RIGHTS_HISTORY, PN_RIGHTS_HISTORY_S, PN_RIGHTS_S).
- DELETE_ROW — Removes a rights record from the base table and records the deletion in the associated history and audit structures.
Notably, the package does not expose query or validation procedures; retrieval and validation are handled elsewhere by the form's standard querying mechanisms and by other Property Manager packages.
Tables Accessed
The package references the following tables through APPS synonyms:
- PN_RIGHTS_ALL — The primary rights table, holding the current definition of each right. INSERT, UPDATE, and DELETE operations against this table are the package's central purpose.
- PN_RIGHTS_S — The security/audit shadow table, used to record who made each change and when, supporting row-level audit tracking.
- PN_RIGHTS_HISTORY — The history table that retains a versioned snapshot of rights records for audit and reporting.
- PN_RIGHTS_HISTORY_S — The security/audit counterpart to the history table.
- PN_LEASES_ALL — Referenced to validate or derive the lease context to which a right belongs.
- DUAL — Used for standard single-row operations.
Cursor definitions in the package body drive these DML operations against the base and history tables.
Usage Notes
PN_RIGHTS_PKG is an internal, forms-support package rather than a published integration API. It is primarily invoked from the Oracle Property Manager rights maintenance form when a user inserts, updates, or deletes a rights record. The form's block-level triggers call these procedures to persist changes consistently across the base, history, and audit tables.
Because the package is documented as referenced by only one other package, its usage surface is narrow—dependent code consists essentially of the Property Manager form and that single referencing package. Custom code and integrations should not call PN_RIGHTS_PKG directly; instead, they should use supported Property Manager APIs or interface tables, since this package assumes the form context and does not perform the level of validation and defaulting expected of a public API. The package is present and VALID in both Oracle EBS 12.1.1 and 12.2.2.
-
PACKAGE: APPS.PN_RIGHTS_PKG 12.1.1
-
PACKAGE: APPS.PN_RIGHTS_PKG 12.2.2
-
PACKAGE: APPS.POS_SBD_PKG 12.2.2