Search Results per_ose_ins




Overview
Explore in AI Chat

Overview

PER_OSE_INS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM metadata as an "OTHER" API type. Its naming convention follows the PER module prefix used for Oracle Human Resources (HR) and PeopleSoft-derived HRMS objects, with the "OSE" fragment corresponding to "Org Structure Element." In Oracle EBS 12.1.1 and 12.2.2, organization structure elements represent the individual nodes and hierarchy entries that make up an organization hierarchy — for example, the placement of a business group, legal entity, operating unit, inventory organization, or position within a reporting tree. The PER_OSE_INS package provides insert-focused processing for these rows, serving as the low-level insertion utility used by higher-level HRMS APIs when new organization structure element records must be created in the underlying tables. It acts as a supporting component rather than an end-user-facing API.

Key Procedures and Functions

The documented package exposes three selectable units of logic, of which two are named procedures:

  • SET_BASE_KEY_VALUE — Establishes or initializes the base key value associated with an organization structure element record prior to insertion. This is a preparatory step ensuring the surrogate or primary key context is set consistently before the row is written.
  • INS — The core insertion routine. It performs the actual insertion of an organization structure element row, applying the key values established by SET_BASE_KEY_VALUE and enforcing the referential and structural integrity required for hierarchy records.
  • The third documented unit completes the package's internal processing but is not separately itemized in the metadata; the two named procedures above constitute the public interface of interest.

No parameter lists are documented in the ETRM metadata, and none should be assumed. The procedures are invoked for their side effects on the organization structure element tables rather than for returned values.

Tables Accessed

The package operates against two documented tables, both accessed through APPS synonyms:

  • PER_ORG_STRUCTURE_ELEMENTS — the base (non-date-tracked) table holding organization structure element definitions, including the element's relationship to its parent structure and its position in the hierarchy.
  • PER_ORG_STRUCTURE_ELEMENTS_S — the date-tracked (_S) companion table that stores the effective-dated attribute rows for each element, enabling historical and future-dated versions of hierarchy membership.

The INS procedure is expected to write to PER_ORG_STRUCTURE_ELEMENTS and, where dated attributes apply, to PER_ORG_STRUCTURE_ELEMENTS_S. The package also references the view PER_OSE_SHD, a shadow (audit) view over the same element data, which supports the date-tracked insert pattern typical of HRMS tables.

Usage Notes

PER_OSE_INS is referenced by HR_HIERARCHY_ELEMENT_API, indicating that it is consumed as a subordinate utility during organization hierarchy creation and maintenance operations. It is therefore typically invoked indirectly — through the hierarchy element API or through forms and concurrent programs that maintain organization hierarchies — rather than called directly by end users. Custom code should prefer the higher-level API entry points; where direct invocation is necessary, the caller is responsible for supplying consistent key values via SET_BASE_KEY_VALUE and for honoring the effective-dating rules governing the _S table. The package depends on SYS.STANDARD and on the PER_OSE_SHD shadow view, and it is itself self-referential in the dependency listing, reflecting internal procedure calls. As with all APPS-owned HRMS packages, wrapper or seeding considerations for multi-org and Business Group contexts apply.