Search Results per_position_structure_swi

Overview

PER_POSITION_STRUCTURE_SWI is an Oracle EBS Human Resources (HR) package owned by the APPS schema. The suffix "SWI" designates it as a Server-side Web Interface (or Server Web Interface) wrapper package — a naming convention used throughout Oracle EBS to denote PL/SQL packages that provide a bridge between the user interface layer (typically Oracle Forms) and the underlying business logic stored in the HR_API and related PL/SQL APIs. In this role, PER_POSITION_STRUCTURE_SWI serves as the server-side processing layer for maintaining the Position Structure hierarchy, which defines the parent-child relationships among positions in the enterprise position hierarchy used for reporting, budget allocation, and organizational modeling.

The package is documented in ETRM with a classification of OTHER and is currently VALID in the 12.1.1 / 12.2.2 code line. Its existence within the APPS schema and its dependency on HR_API indicate that it acts as a thin, transactional wrapper rather than a source of new business rules; the substantive validation and data manipulation logic resides in the HR_API layer while this package manages the interface invocation and error signalling back to the calling form.

Key Procedures and Functions

The ETRM metadata documents four procedures within this package:

• CREATE_POSITION_STRUCTURE — Creates a new position structure record (a new hierarchy definition or a new node within an existing position hierarchy) as initiated by the user interface. It delegates the underlying insert and validation to the HR_API layer.
• CREATE_POS_STRUCT_AND_DEF_VER — Creates a position structure together with its default version in a single operation. This combined procedure supports the business requirement that a newly defined hierarchy must immediately possess at least one active version before positions may be assigned to it.
• UPDATE_POSITION_STRUCTURE — Applies modifications to an existing position structure record, such as changes to the hierarchy definition, effective dates, or related attributes.
• DELETE_POSITION_STRUCTURE — Removes a position structure record from the system, subject to the referential and business-rule constraints enforced by the HR_API layer.

The metadata does not expose parameter lists, and these are intentionally omitted here; the procedure names describe their functional intent within the position structure maintenance cycle.

Tables Accessed

The ETRM excerpt lists no directly referenced tables for this package. In practice, an SWI wrapper of this nature operates against the core HR position tables — principally PER_POSITION_STRUCTURES and its associated versions and definitions — but it does so indirectly through the HR_API package rather than issuing direct DML. The documented dependency set confirms only APPS.HR_API and the SYS.STANDARD package, which is consistent with a package that performs no direct SQL of its own and instead routes all data access through the HR business API layer. This design preserves the integrity of the HR position model and ensures that row-level security, date-tracked validation, and business group partitioning are applied consistently.

Usage Notes

PER_POSITION_STRUCTURE_SWI is typically invoked from the Oracle Forms-based Position Structure maintenance screens in the HR module, where the form calls the package to persist user-entered changes. Because the SWI convention is reserved for UI-facing entry points, direct invocation from concurrent programs is uncommon; batch or interface-based loads of position hierarchies would normally call HR_API directly or use the relevant open interface processes. Custom code should avoid calling this package directly and instead target the underlying HR_API procedures, since the SWI layer may assume a form session context. The documented "Referenced by 0 other packages" entry confirms that no other PL/SQL unit depends on it, reinforcing its narrow, presentation-adjacent role. Any extension or upgrade effort should treat the package as a thin presentation-facing wrapper whose behaviour is governed entirely by the HR_API package it fronts.