Search Results per_pos_structure_version_swi




Overview
Explore in AI Chat

Overview

PER_POS_STRUCTURE_VERSION_SWI is an Oracle EBS Application Programming Interface (API) package owned by the APPS schema that manages the versioning lifecycle of position structures within Oracle Human Resources (Oracle HRMS). A "position structure" is the hierarchical arrangement that groups positions into organizational reporting lines or work structures, and its version corresponds to a dated, effective instance of that arrangement. The package acts as a Server-side Wrapper Interface (SWI), providing a controlled, business-rule-validated entry point for creating, updating, and deleting position structure versions without requiring callers to manipulate the underlying HR base tables directly.

The package is classified in the ETRM repository as an "OTHER" API type with a status of VALID, confirming it is a supported and deployable object in both Oracle EBS 12.1.1 and 12.2.2. Its role is narrowly focused: it encapsulates the validation and data-integrity logic required whenever the version record of a position structure must change, ensuring that the same rules the standard HRMS forms enforce are also honored by programmatic callers.

Key Procedures and Functions

The ETRM metadata documents three public procedures:

  • CREATE_POS_STRUCTURE_VERSION — Creates a new version record for an existing position structure. It validates the supplied effective dates, structure reference, and version attributes against HRMS business rules before inserting the version row.
  • UPDATE_POS_STRUCTURE_VERSION — Modifies the attributes of an existing position structure version. This is typically used to correct or adjust date-tracked details while preserving the structure's version history.
  • DELETE_POS_STRUCTURE_VERSION — Removes a position structure version. The procedure applies the applicable deletion and referential-integrity checks so that dependent version data is not orphaned.

The package does not expose documented query or validation functions. Each of the three routines relies on the standard HR_API utility package for error handling and message propagation, consistent with other Oracle HRMS APIs.

Tables Accessed

The ETRM metadata for this object does not enumerate specific tables. The dependency listing shows that PER_POS_STRUCTURE_VERSION_SWI references the APPS.HR_API package and the SYS.STANDARD package, indicating that it delegates error raising and HR-specific validation to HR_API rather than embedding that logic locally. By convention, an API of this name operates on the position structure version entity within the PER schema; the base version table is accessed through APPS synonyms, but the metadata provided does not confirm the specific table names. Consumers should therefore treat the table list as undocumented and verify it against the package body before relying on any particular physical table.

Usage Notes

This package is intended for programmatic use rather than direct invocation. Typical callers include Oracle HRMS forms that maintain position structures, concurrent programs that mass-maintain or migrate position hierarchies, and custom PL/SQL extensions or interfaces that must create or modify position structure versions in bulk. Custom code should always call these procedures instead of issuing DML against the underlying tables, so that HRMS validation and date-track logic remain intact.

The dependency metadata confirms that PER_POS_STRUCTURE_VERSION_SWI is referenced by no other packages in the ETRM inventory, indicating it sits at the leaf of the dependency chain and depends only on HR_API and the SYS.STANDARD package. There are consequently no downstream packages whose behavior is affected by changes to this API, which simplifies impact analysis during upgrades or patching between 12.1.1 and 12.2.2.