Search Results hr_startup_data_api_support




Overview
Explore in AI Chat

Overview

The APPS.HR_STARTUP_DATA_API_SUPPORT package body is a supporting PL/SQL unit within the Oracle E-Business Suite Human Resources (HR) module. Its documented classification is OTHER, indicating that it does not conform to the standard HR_API interface pattern, although it references HR_API as a dependency. The package serves as infrastructure that governs transactional "startup mode" behavior affecting how HR owner definitions are created and validated during data initialization or migration events.

Startup mode is a controlled state in which the HR application permits bulk creation or modification of HR owner data — typically records that identify which business groups and legislative contexts own particular HR data sets. The HR_STARTUP_DATA_API_SUPPORT package provides the plumbing that enables this state, probes whether it is currently engaged, and enforces validation rules before startup-related insert, update, or delete operations are committed. In Oracle EBS 12.1.1 and 12.2.2, the object is recorded as VALID under the APPS schema, confirming that it is a compiled and supported component of the delivered application rather than a customer extension.

Key Procedures and Functions

The ETRM metadata documents six procedures/functions within the package body:

  • ENABLE_STARTUP_MODE — Activates startup mode so that downstream HR API calls can bypass or relax standard validation constraints during initialization activities.
  • RETURN_STARTUP_MODE — Returns the current startup-mode indicator to the calling program, allowing conditional logic to branch on whether startup context is active.
  • CREATE_OWNER_DEFINITION — Creates an HR owner definition record, populating the owner definition structure during startup processing.
  • DELETE_OWNER_DEFINITIONS — Removes owner definition records, typically used to clean up or reset startup data.
  • CHK_STARTUP_ACTION — Performs validation checks governing whether a requested startup action is permissible in the current state.
  • CHK_UPD_DEL_STARTUP_ACTION — Extends validation specifically to startup-mode update and delete operations, ensuring they are only performed under acceptable conditions.

Parameter lists are not exposed in the available metadata and are deliberately not reproduced here; consult the package specification for exact signatures.

Tables Accessed

The package reads and writes against HR_OWNER_DEFINITIONS (through its APPS synonym), which stores the mapping of HR owner identifiers and their associated legislative or business-group contexts. This table is the persistent store manipulated by CREATE_OWNER_DEFINITION and DELETE_OWNER_DEFINITIONS, and it is consulted by the check routines. In addition, the package selects from DUAL, reflecting standard PL/SQL calls such as SYSDATE, sequence retrieval, or simple existence tests that do not require a real table.

Usage Notes

Because HR_STARTUP_DATA_API_SUPPORT is not referenced by any other database object according to the ETRM dependency report, it is an entry-point utility invoked directly by callers rather than being called internally by other stored units. In practice, it is driven by HR setup or migration tools, concurrent programs that load owner definitions, and the forms-based startup data interface. Custom code performing bulk HR initialization may invoke ENABLE_STARTUP_MODE before calling the owner-definition APIs and should pair every enable with the corresponding mode-return and validation checks to avoid leaving the application in an inconsistent startup state. The package depends on FND_MESSAGE, HR_API, HR_UTILITY, and STANDARD, indicating that it raises translatable messages, delegates to standard HR utility logic, and can surface API-level errors through the message dictionary.