Search Results per_ri_create_hier_element




Overview
Explore in AI Chat

Overview

PER_RI_CREATE_HIER_ELEMENT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM metadata as an "OTHER" API object. Its name and documented dependencies indicate that it belongs to the Oracle Human Resources (HR) "RI" family of utilities — packages associated with the Recruitment/Requisition Interface and the hierarchical element construction used by Oracle HRMS organization structures. The package exists to construct and persist hierarchy elements that represent nodes within an organization hierarchy, then attach user-key and batch-line information to those elements so that downstream HR processes — primarily the HR Pump (batch loader) — can carry the constructed hierarchy through the standard import and validation pipeline.

In Oracle EBS 12.1.1 and 12.2.2, organization hierarchies are built on PER_ORGANIZATION_STRUCTURES combined with PER_ORG_STRUCTURE_VERSIONS (the date-effective versioning table). PER_RI_CREATE_HIER_ELEMENT operates in that context: it reads structural and version data, computes or validates each hierarchical element, and writes batch lines that the HR Pump consumes. The package is marked VALID and depends only on SYS.STANDARD, confirming it is a self-contained utility with no external package dependencies.

Key Procedures and Functions

ETRM documents two callable units in this package:

  • GET_LINE_STATUS — returns the processing status of a batch line, allowing the caller to determine whether a given hierarchy element line has been created, processed, or rejected by the HR Pump.
  • INSERT_BATCH_LINES — inserts the batch line records that represent hierarchy elements, supplying the user keys required by the HR Pump to process the hierarchy. This is the primary write operation of the package.

No parameters are documented in the ETRM metadata, and no parameter lists should be assumed.

Tables Accessed

Four objects are referenced through APPS synonyms:

  • HR_PUMP_BATCH_LINE_USER_KEYS — stores the surrogate user keys associated with each batch line; INSERT_BATCH_LINES and GET_LINE_STATUS operate against this table.
  • PER_ORGANIZATION_STRUCTURES — defines the organization hierarchy itself (name, primary/secondary classification, top organization).
  • PER_ORG_STRUCTURE_VERSIONS — the date-effective versions of each organization structure, supplying the version context for the hierarchy element being created.
  • DUAL — used for single-row scalar computations and status checks within PL/SQL logic.

Usage Notes

This package is an internal HR utility rather than a public, supported API. It is not referenced by any other package ("Referenced by 0 other packages" in ETRM), indicating it is invoked directly from Oracle HRMS forms, from the HR Pump batch-processing framework, or from custom concurrent programs that build and load organization hierarchies. Typical invocation occurs during organization hierarchy load/import routines, where the caller first establishes a batch, calls INSERT_BATCH_LINES to seed hierarchy elements and user keys, and then calls GET_LINE_STATUS to inspect results after the HR Pump runs. Because the package carries no documented parameter signatures and is classified as OTHER, customizations should treat it as a version-sensitive internal object: verify the exact specification in the target instance (12.1.1 or 12.2.2) before calling it directly, and prefer supported public APIs where available.