Search Results get_disp_sequence

Overview

PA_STRUCT_UPGR_PUB is a public PL/SQL package in the APPS schema that supports the upgrade and reorganization of project structures within Oracle Projects. Its name, combining "STRUCT" and "UPGR," indicates its role in migrating or transforming the hierarchical work breakdown structure (WBS) and related structural data when a project's structure definition is changed or upgraded. In Oracle EBS 12.1.1 and 12.2.2, Project Structures define the arrangement of WBS, tasks, and deliverables, and structural changes require coordinated processing to preserve numbering, display sequencing, and cached session state. This package exposes a small public surface of utility routines used during such structural operations.

Key Procedures and Functions

The documented public surface consists of three routines. They are described by purpose only; parameter lists are not part of the available metadata.

• GET_WBS_NUMBER — Retrieves the WBS number associated with a project structure element, allowing callers to resolve the correct structure identifier during or after an upgrade operation.
• GET_DISP_SEQUENCE — Returns the display sequence value used to order structure elements, supporting consistent presentation and hierarchy ordering when structures are reorganized.
• CLEAR_GLOBALS — Resets package-level global variables, ensuring that cached state does not persist between calls or sessions. This is essential in long-running upgrade routines where stale values could corrupt subsequent processing.

Tables Accessed

The package references the table PLITBLM through APPS synonyms. PLITBLM is an Oracle Projects structure table whose naming convention ("PLI" prefix) associates it with project structure and organization-level data. The package reads from and/or writes to this table to obtain and persist the WBS numbering and display sequencing information manipulated by the procedures above.

Usage Notes

PA_STRUCT_UPGR_PUB is referenced by PA_PROJECT_STRUCTURE_PVT1, the private package that encapsulates core project structure logic, and is also self-referenced, indicating that public and private layers of the same package family interoperate. It is a PUB-classified API, meaning it may be invoked by other Oracle Projects components and, in principle, by custom code performing structure upgrades.

Typical invocation occurs during project structure upgrade or reorganization processing rather than through direct end-user forms. When structural changes are applied programmatically, the calling routine opens the operation, resolves WBS numbers and display sequences through the getter functions, and calls CLEAR_GLOBALS on completion to release in-memory state. Developers integrating with this package should treat CLEAR_GLOBALS as mandatory at the end of a processing block to avoid cross-contamination of cached values. Because the package depends on SYS.STANDARD and the PLITBLM structure table, its behavior is tightly bound to the Oracle Projects data model, and any custom usage should be validated against the release-specific implementation in 12.1.1 and 12.2.2, as internal details may differ between versions.