Search Results per_pse_ins




Overview
Explore in AI Chat

Overview

PER_PSE_INS is the insert-handler package body in the Oracle E-Business Suite (EBS) Human Resources (HR) schema, owned by the APPS schema and distributed as part of the Oracle HRMS position management infrastructure. The acronym "PSE" denotes Position Structure Element, and the package operates on the PER_POS_STRUCTURE_ELEMENTS entity — the intersection table that records which positions belong to which position hierarchies or structures. Within Oracle EBS 12.1.1 and 12.2.2, this object is classified as an internal API (API classification: OTHER) that supports the row-level Data Manipulation Language layer for the position structure elements table.

The package forms part of the standard Oracle HRMS "INS/RKI/UPD/DEL" package family pattern. PER_PSE_INS is responsible for inserting new records; its sibling packages PER_PSE_RKI (row key information/validation) and PER_PSE_SHD (shadow/history table maintenance) complete the transactional ecosystem. Where the PER_PSE_BUS package encapsulates the business logic, PER_PSE_INS performs the physical insert and base-key management operations required to persist a validated row. The package is marked VALID in the APPS schema, confirming it is compiled and operational in the documented release.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents three callable units within PER_PSE_INS. Note that the packaged procedures and functions are intended for internal use by the HR position management code path rather than direct external invocation.

  • SET_BASE_KEY_VALUE — Populates the primary or base key value for a position structure element row prior to insertion. It ensures the surrogate identifier required by the underlying table is generated or assigned deterministically within the insert transaction.
  • INS — The primary insert procedure. It performs the insertion of a row into the PER_POS_STRUCTURE_ELEMENTS table, orchestrating key assignment, column population, and the associated row-key information derived from PER_PSE_RKI. It operates in conjunction with PER_PSE_BUS business validation logic.

The third documented unit, in addition to the two above, completes the minimal API surface through which the package maintains position structure element data.

Tables Accessed

The package references two documented tables through APPS synonyms:

  • PER_POS_STRUCTURE_ELEMENTS — The primary transactional table into which new position structure element rows are inserted. Each row associates a position with its parent structure context and carries the effective-dating and key columns required for HRMS date-tracked entities.
  • PER_POS_STRUCTURE_ELEMENTS_S — The "shadow" or secondary table used by Oracle HRMS for future-dated and history-tracked row management. The _S table retains the physical row while the primary table holds the logically current version, following the standard DateTrack pairing convention.

In addition, the dependency list shows calls into shared HR infrastructure objects — HR_API, HR_UTILITY, and the SYS.STANDARD and SYS.DUAL constructs — for error handling, key generation, and environment services.

Usage Notes

PER_PSE_INS is not referenced by any database object, and it is therefore not intended as a public entry point. It is invoked indirectly through the position structure element business flow, typically triggered by the Position management forms or by HRMS concurrent processes that create or copy position hierarchies. Custom code should not call PER_PSE_INS directly; instead, developers should route through the supported HRMS business API layer so that DateTrack, row-key, and history-shadow logic remain consistent. The presence of only one referencing package indicates tightly coupled internal usage within the position structure element subsystem.