Search Results per_org_structure_elements_s




Overview
Explore in AI Chat

Overview

PER_OSE_INS is a packaged insert handler within the Oracle E-Business Suite Human Resources (HR) module, owned by the APPS schema. The name follows the Oracle HR API naming convention, in which "OSE" abbreviates Org Structure Elements and "INS" denotes the insert operation. The package body therefore provides the internal row-level insertion logic for records held in the PER_ORG_STRUCTURE_ELEMENTS entity, which stores the individual structure elements that make up an organization hierarchy — for example, the positioning of organizations within an organization structure version.

Rather than being called directly by end users, PER_OSE_INS operates as a supporting component beneath the public business API. Its primary role is to accept validated attribute values, populate the base key, and perform the physical insert into the organization structure elements table. It is classified under the ETRM as an OTHER API type, reflecting that it is an internal implementation package rather than a formally published interface.

Key Procedures and Functions

The ETRM documents three procedures within the package body:

  • SET_BASE_KEY_VALUE — Establishes the base key value for the row being processed. In Oracle HR date-tracked (datetrack) entities, the base key is a derived identifier that uniquely identifies a logical row across its dated versions. This procedure ensures that the primary key components required by the insert are correctly computed before the row is written.
  • INS — Performs the core insert operation for a single organization structure element record. It applies the supplied column values, invokes the base key logic, and executes the insertion against the underlying table.
  • A third documented procedure completes the package's procedural interface. Consistent with the naming pattern, it supports the insert workflow by managing row-level preparation or completion tasks required before the record becomes visible through the public API.

The package does not expose these procedures as a supported customer-facing interface; they are intended for invocation by peer packages within the APPS schema.

Tables Accessed

The package body references two documented tables through APPS synonyms:

  • PER_ORG_STRUCTURE_ELEMENTS — The base table holding organization structure element rows. PER_OSE_INS writes new records to this table.
  • PER_ORG_STRUCTURE_ELEMENTS_S — The corresponding translateable (_S) table used for user-entered text such as element names or descriptions. Rows are inserted here in parallel with the base table record to maintain multilingual support.

The dependency list further shows references to PER_OSE_BUS (the business logic package), PER_OSE_RKI (row key information), PER_OSE_SHD (shadow table handling), and the shared HR_API and HR_UTILITY packages, which supply error handling, validation, and datetrack utilities. DUAL and STANDARD are referenced for basic SQL and PL/SQL operations.

Usage Notes

PER_OSE_INS is invoked indirectly, typically through the PER_ORG_STRUCTURE_ELEMENTS public API or the business logic layer in PER_OSE_BUS. End users trigger it via the Organization Hierarchy or Organization Structures forms, and it may also be reached through concurrent processes that build organization hierarchies. Because it is a private insertion handler, direct calls from custom code are discouraged; developers integrating organization structure data should use the supported public API, which enforces validation and date-track rules. The package is documented as VALID and is not referenced by any other database object, confirming its position as a leaf-level implementation component. Both Oracle EBS 12.1.1 and 12.2.2 share this package structure.