Search Results delete_other_assignments_emp

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.

• DML operations: INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW provide the base row-level data manipulation for customer space assignment records. LOCK_ROW supports concurrency control by obtaining a lock on a target assignment record.
• Validation and duplicate checking: CHK_DUP_CUST_ASSIGN and GET_DUP_CUST_ASSIGN_COUNT identify and count duplicate customer assignments, preventing overlapping or conflicting allocations. CHECK_ASSIGN_ARCL_LINE validates assignment records against archive detail lines.
• Calculation and allocation utilities: ASSIGNMENT_SPLIT, AREA_PCT_AND_AREA, ASSIGNMENT_COUNT, LOCATION_COUNT, and DEFRAG_CONTIG_ASSIGN handle the partitioning of assigned area, percentage-of-area computations, counting of assignments and locations, and defragmentation of contiguous assignment ranges. DELETE_OTHER_ASSIGNMENTS_EMP and DELETE_OTHER_ASSIGNMENTS_CUST remove competing assignments for an employee or customer, typically during reassignment.

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.