Search Results hr_sit_api




Overview
Explore in AI Chat

Overview

APPS.HR_SIT_API is a PL/SQL application programming interface that governs the creation, maintenance, and validation of Special Information Types (SIT) within Oracle E-Business Suite Human Resources. A Special Information Type is an HR configuration structure that allows an enterprise to capture additional, non-standard employee data beyond the standard person record — for example, professional certifications, language proficiencies, security clearances, or medical competencies. Each SIT is associated with descriptive elements such as analysis criteria and special information attributes, and its definition must be held in a consistent state across the HR schema.

The package acts as a controlled gateway over the underlying PER tables. Rather than permitting direct DML against PER_SPECIAL_INFO_TYPES and its related criteria records, Oracle exposes HR_SIT_API so that all definitional changes pass through a single, validated entry point that enforces the HR business rules and maintains the integrity of dependent flexfield and analysis structures. It is classified as an API in the EBS Technical Reference Manual and carries a VALID status in the APPS schema on both 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface exposes four callable units:

  • CREATE_SIT — Establishes a new Special Information Type definition, registering the type and its associated configuration data so that it becomes available to HR users.
  • UPDATE_SIT — Modifies an existing Special Information Type definition, allowing controlled amendment of an already-registered SIT.
  • DELETE_SIT — Removes a Special Information Type definition, subject to the referential and validation checks enforced by the package.
  • LCK — Performs the locking routine associated with the API, used to serialize concurrent operations against SIT definitions and prevent conflicting updates during multi-step processing.

Because the ETRM metadata documents only these entry points without parameter signatures, the package should be invoked strictly in accordance with Oracle's published API specification for the release in use; parameter lists must not be inferred.

Tables Accessed

The package operates against four documented tables through APPS synonyms:

  • PER_SPECIAL_INFO_TYPES — The primary definition table holding the Special Information Type records created, updated, and deleted by the API.
  • PER_ANALYSIS_CRITERIA — Stores the analysis criteria associated with each SIT, defining the dimensions against which special information is evaluated.
  • PER_PERSON_ANALYSES — Holds person-level analysis data linked to the criteria, relevant to validation and dependency checks performed during SIT maintenance.
  • FND_ID_FLEX_STRUCTURES — The flexfield structure definition table, consulted where a Special Information Type relies on a descriptive flexfield or key flexfield structure.

Usage Notes

HR_SIT_API is invoked indirectly by multiple components rather than by end users. Dependency data shows it is referenced by GHR_SIT_API, GHR_SF52_DO_UPDATE, HRDPP_CREATE_SIT, HR_JPBP_API, HR_PROCESS_SIT_SS, HR_SIT_SWI, and PQP_HRTCA_INTEGRATION, indicating use from HR forms, self-service flows, concurrent processing, and localization or integration routines. The package in turn depends on HR_API and STANDARD.

Custom code should call HR_SIT_API rather than writing directly to PER_SPECIAL_INFO_TYPES, since the API encapsulates validation logic, flexfield consistency, and locking behavior. In multi-user or batch environments, callers should respect the LCK routine to avoid concurrent modification conflicts. Direct table updates bypass these safeguards and risk corrupting SIT definitions.