Search Results pn_space_assign_cust_pkg




Overview
Explore in AI Chat

Overview

PN_SPACE_ASSIGN_CUST_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API. It belongs to the Property Manager (PN) module, which supports lease and space management for real estate portfolios. The package encapsulates the core business logic for customer space assignments, the mechanism by which a tenant or customer is allocated specific areas within a leased or owned property. Such assignments underpin chargeback calculations, occupancy reporting, and lease administration, since accurate customer-to-space mapping is a prerequisite for billing and utilization analysis.

The package maintains a status of VALID and is documented in both EBS 12.1.1 and 12.2.2. It is referenced by four other packages, including PNP_UTIL_FUNC, PN_MTM_ROLLFORWARD_PKG, and PN_TENANCIES_PKG, indicating it is a foundational utility within the Property Manager data model rather than a standalone interface.

Key Procedures and Functions

The ETRM documents 14 procedures and functions, which fall into three functional groupings.

Tables Accessed

The package operates on the central Property Manager assignment tables via APPS synonyms. PN_SPACE_ASSIGN_CUST and PN_SPACE_ASSIGN_CUST_ALL store customer space assignment header and detail data; PN_SPACE_ASSIGN_EMP and PN_SPACE_ASSIGN_EMP_ALL hold equivalent employee assignments; PN_LOCATIONS and PN_LOCATIONS_ALL define the physical locations being assigned. PN_SPACE_ASSIGN_CUST_S is the sequence/primary key source for customer assignments. PN_REC_ARCL_DTLLN_ALL provides archive detail lines used by validation logic. DUAL and PLITBLM support PL/SQL and Oracle Forms constructs.

Usage Notes

PN_SPACE_ASSIGN_CUST_PKG is an internal supporting package rather than a public, externally supported API. Its documented callers — PNP_UTIL_FUNC, PN_MTM_ROLLFORWARD_PKG, PN_TENANCIES_PKG, and itself — indicate that it is invoked from Property Manager forms, concurrent programs (notably rollforward and tenancy processes), and other PL/SQL routines. Customizations should avoid calling the DML procedures directly unless standard form or program paths cannot satisfy the requirement; instead, prefer supported interfaces where available. Because it is referenced by multiple packages, changes to its behavior carry regression risk across the Property Manager module.