Search Results delete_position_structure




Overview
Explore in AI Chat

Overview

APPS.PER_POSITION_STRUCTURE_API is a public Oracle E-Business Suite API belonging to the Oracle HRMS (PER) product family. Its principal business function is to provide a controlled, validated interface for the creation, maintenance, and deletion of position structures within the enterprise position hierarchy. Position structures define the hierarchical arrangement of positions that underpins position management, budgeting, and reporting relationships in Oracle HRMS. This package is classified as an API in the ETRM repository, indicating that it is intended for programmatic invocation by other application modules, forms, and custom code rather than being a purely internal implementation unit.

The package encapsulates the business rules, validation routines, and multi-row datetrack operations required to keep the PER_POSITION_STRUCTURES table consistent. Callers interact only through the documented public procedures, allowing Oracle to evolve the underlying data model without breaking dependent integrations. The package body header indicates a long-standing, shipped object (pepstapi.pkb), reinforcing its status as a supported extension point across EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes four documented procedures:

  • CREATE_POS_STRUCT_AND_DEF_VER — Creates both a position structure and its default version in a single call. It is the combined creation entry point, accepting a validation flag, an effective date, a business group identifier, a name, comments, a primary position flag, standard concurrent-program audit columns (request id, program application id, program id, program update date), and a full set of twenty descriptive flexfield attribute columns. It returns the new position structure identifier and object version number as out parameters.
  • CREATE_POSITION_STRUCTURE — Creates a position structure record. In the source listing this procedure is invoked by CREATE_POS_STRUCT_AND_DEF_VER, indicating that it performs the lower-level insert logic for the structure entity.
  • UPDATE_POSITION_STRUCTURE — Updates an existing position structure, applying the same datetrack, validation, and object version semantics as the creation routines.
  • DELETE_POSITION_STRUCTURE — Removes a position structure, presumably subject to validation of dependent position assignments and hierarchy integrity.

Tables Accessed

The documented table accessed through APPS synonyms is:

  • PER_POSITION_STRUCTURES — The primary datetracked table that stores position hierarchy definitions. The API reads and writes this table to persist new structures, apply amendments, and perform deletes.

Usage Notes

PER_POSITION_STRUCTURE_API is typically invoked from Oracle HRMS forms, from concurrent programs that bulk-load or migrate position structures, and from custom PL/SQL integrations. The presence of the p_validate parameter across the create and update routines means callers can perform a dry run in which all business rules and datetrack validations execute without committing any data — a pattern recommended during data conversion and interface testing.

Callers should always supply a meaningful p_effective_date and p_business_group_id, capture the returned position structure id and object version number for subsequent updates, and route concurrent invocations through the standard request id and program id parameters to preserve audit lineage. Because this API is referenced by one other package, changes to its behavior can propagate to dependent Oracle code; custom code should therefore invoke only the documented procedures and avoid direct DML against PER_POSITION_STRUCTURES.