Search Results hr_per_deplymt_eit_api




Overview
Explore in AI Chat

Overview

The APPS.HR_PER_DEPLYMT_EIT_API package body is a public Oracle E-Business Suite API that manages Extra Information Types (EITs) associated with a person's deployment record. In Oracle EBS Human Resources (PER), an Extra Information Type provides an extension mechanism allowing customers to capture additional descriptive or legislative-specific attributes against key HR entities without modifying the underlying schema. A deployment record represents a period during which an employee is assigned to a specific location, organization, or assignment configuration, and EITs are attached to that deployment to store supplementary data defined by the enterprise.

The package implements the standard Oracle HRMS API design pattern used throughout the HR module: a thin procedural layer that coordinates validation, row-handler logic, and user hook calls, ensuring that direct DML against the underlying tables is replaced by supported, upgrade-safe interfaces. The header comment hrpdeapi.pkb 120.0 2005/09/23 confirms it has been part of the HRMS codebase since Release 12.0 and remains supported through EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

ETRM documents two public procedures on this package:

  • CREATE_PER_DEPLYMT_EIT — Creates a new deployment EIT record. The procedure accepts an optional p_validate flag (default false) which, when set to true, exercises full processing and validation logic but rolls back the changes without committing, allowing callers to test data before persisting it. It receives the person deployment identifier and person extra information identifier as inputs, and returns the newly generated deployment EIT identifier and the ORACLE object version number as OUT parameters. Internally the procedure takes a savepoint, invokes the before-process user hook HR_PER_DEPLYMT_EIT_BK1.CREATE_PER_DEPLYMT_EIT_B, performs validation in addition to the row-handler checks, delegates the insert to the row handler HR_PDE_INS.INS, and then calls the after-process user hook.
  • DELETE_PER_DEPLYMT_EIT — Removes an existing deployment EIT record. It follows the same savepoint/hook/validation/row-handler pattern, calling the corresponding delete row handler and before/after user hooks to allow customer extensions to intercept the deletion.

Tables Accessed

The package does not directly issue SQL DML. Instead, all persistence is delegated to the row handler HR_PDE_INS, which in turn operates against the deployment EIT base table (typically PER_DEPLYMT_EXTRA_INFO_TYPES or the associated PER_DEPLYMT_EIT structures exposed through APPS synonyms). The package also relies on the HR_API error stack utilities and the HR_UTILITY package for instrumentation via set_location. Because the documented metadata does not enumerate the synonyms explicitly, the exact physical table names should be confirmed against the deployment EIT data model in the target environment.

Usage Notes

The API is typically invoked from:

  • Oracle HRMS forms that capture deployment-level extra information, where the form's underlying block calls the API rather than issuing direct inserts or deletes.
  • Concurrent programs or batch processes that load deployment EIT data from external sources and require validated, hook-aware inserts and deletes.
  • Custom PL/SQL code that must maintain deployment EITs in an upgrade-safe manner, preserving object version numbering and business-group security semantics.

Callers should always invoke the API inside a transaction they control, honour the object version number returned by CREATE for subsequent updates, and use the validate mode during data conversion or dry-run testing. ETRM records that this package is referenced by one other package, indicating a limited but defined call graph within the HRMS API family.