Search Results update_pos_hier_elem_internal

Overview

HR_POS_HIERARCHY_ELE_SWI is a self-service wrapper package in the Oracle E-Business Suite APPS schema that exposes position hierarchy element maintenance operations to self-service (typically web-based) callers. In Oracle EBS, position hierarchies describe reporting relationships between positions within a business group and a position structure version. The _SWI suffix denotes "self-service web interface," a naming convention used throughout Oracle HRMS to distinguish thin wrapper packages from their underlying business logic APIs.

The package wraps the corresponding server-side API, HR_POS_HIERARCHY_ELE_API, which performs the actual validation and database manipulation. Each wrapper procedure mirrors its API counterpart, accepting the same parameters, delegating processing to the API, and returning a standard return status indicator. This layering allows self-service pages—which operate under restricted privileges and with derived input parameters—to create, update, and delete position hierarchy elements without calling the core API directly.

Because the package is declared AUTHID CURRENT_USER, its procedures execute with the privileges of the invoking session rather than the definer, consistent with the security model expected of self-service entry points invoked through the Oracle Applications middle tier.

Key Procedures and Functions

The package documents six procedures, organized as three logical operations, each with a public (self-service) name and an internal counterpart:

• CREATE_POS_HIERARCHY_ELE — The self-service wrapper for hr_pos_hierarchy_ele_api.create_pos_hierarchy_ele. It establishes a new position hierarchy element that links a parent position to a subordinate position within a specified position structure version and business group. It returns the new position structure element identifier and object version number, along with a return status. A validation mode parameter allows the caller to exercise all business rules without committing data.
• CREATE_POS_HIER_ELEM_INTERNAL — The internal-facing counterpart to the create operation. This is the procedure the user's search term ("create_pos_hier_elem_internal") refers to. It is intended for controlled internal invocation, providing the same creation capability without the external self-service framing.
• UPDATE_POS_HIERARCHY_ELE — The self-service wrapper for the update operation on hr_pos_hierarchy_ele_api. It modifies an existing hierarchy element, for example to re-point the parent or subordinate position, honoring effective dating and object version control.
• UPDATE_POS_HIER_ELEM_INTERNAL — The internal update counterpart, used for programmatic maintenance of hierarchy elements outside the standard self-service flow.
• DELETE_POS_HIERARCHY_ELE — The self-service wrapper for the delete operation, removing a position hierarchy element while preserving the API's validation and referential checks.
• DELETE_POS_HIER_ELEM_INTERNAL — The internal delete counterpart for use in controlled or backend processing scenarios.

All procedures return a status value (p_return_status) indicating success or failure; the create operations additionally return the generated element identifier and object version number as OUT parameters.

Tables Accessed

The ETRM metadata for this package does not enumerate specific base tables through APPS synonyms. Functionally, the package operates on the position hierarchy element entity, which in Oracle HRMS is persisted in PER_POS_STRUCTURE_ELEMENTS (the table holding position structure version elements) and validated against position and hierarchy definitions in PER_POS_STRUCTURE_VERSIONS, PER_ALL_POSITIONS, and business group context in HR_ALL_ORGANIZATION_UNITS / PER_BUSINESS_GROUPS. Because the package merely wraps HR_POS_HIERARCHY_ELE_API, all direct DML is performed by the API layer; the wrapper itself performs no independent table access.

Usage Notes

This package is classified for internal development use only, as stated in its header comments. It is not intended for direct invocation by customers or third-party integrators. Typical invocation occurs from self-service position management functionality within Oracle iRecruitment, Oracle Self-Service HR, and related HRMS self-service flows, where the middle tier calls the wrapper rather than the API directly.

Custom code should call HR_POS_HIERARCHY_ELE_API instead, since the SWI layer assumes that all IN parameters have already been appropriately derived by the calling self-service layer. Direct calls to the wrapper without that derivation may bypass expected defaults. Standard practice is to run create and update operations in validation mode first, then re-invoke with validation disabled to commit. Effective dating and object version numbers must be supplied correctly to avoid concurrent update conflicts on position hierarchy data.