Search Results hr_abm_del




Overview
Explore in AI Chat

Overview

HR_ABM_SHD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. Its name follows the Oracle convention for a shadow or "SHD" companion package, indicating that it works alongside a primary business object package rather than exposing end-user functionality directly. In the HR module family, the HR_ABM prefix refers to the Absence Management framework, which manages absence types, accrual plans, absence records, and their associated business logic. HR_ABM_SHD serves as a supporting and shadow package for the HR_ABM family, providing internal utility routines and standardized error, locking, and argument-conversion behavior that the primary DML packages (HR_ABM_INS, HR_ABM_BUS, and HR_ABM_DEL) call during insert, update, and delete processing.

The package is recorded as VALID in the ETRM repository and is classified under the API classification OTHER, meaning Oracle does not document it as a formally supported public API. It is a private implementation package and should be treated as internal infrastructure rather than a callable interface for customers or integrators.

Key Procedures and Functions

  • RETURN_API_DML_STATUS — Returns the current DML status indicator for the API session. This is the standard mechanism by which HR APIs report whether the most recent insert, update, or delete operation completed successfully, allowing calling packages such as HR_ABM_INS and HR_ABM_BUS to propagate status consistently.
  • CONSTRAINT_ERROR — Standardized handler for constraint violations. It interprets database constraint failures encountered during DML and raises them in a consistent, HR-API-compatible format so that callers receive uniform error information.
  • LCK — Locking routine used to serialize concurrent operations against the same absence-management records, preventing lost updates and maintaining data integrity during multi-user processing.
  • CONVERT_ARGS — Argument-conversion helper that normalizes incoming parameter values into the formats expected by the underlying business logic before processing proceeds.

Parameter lists are not documented in the ETRM metadata and are therefore not reproduced here.

Tables Accessed

  • ALL_CONSTRAINTS — Queried through a public synonym to inspect constraint metadata. The CONSTRAINT_ERROR routine uses this data dictionary view to identify and classify constraint violations raised during DML.
  • HR_API_BATCH_MESSAGE_LINES — Accessed through an APPS synonym to write or read batch-level API message lines, supporting the HR API message-queue mechanism that records errors and diagnostics generated during bulk absence processing.

Usage Notes

HR_ABM_SHD is not invoked directly by users, Oracle Forms, or concurrent programs. Its callers are the other packages in the HR_ABM family: HR_ABM_BUS, HR_ABM_DEL, and HR_ABM_INS, each of which invokes the shadow package to obtain consistent status reporting, constraint handling, locking, and argument conversion. The ETRM metadata confirms HR_ABM_SHD is referenced by these three packages.

Because the user search term "hr_abm_ins" corresponds to the insert-side DML package, it is relevant that HR_ABM_INS is the principal consumer of HR_ABM_SHD during absence record creation. Customizations or extensions that call HR_ABM_INS will indirectly exercise HR_ABM_SHD routines. Direct invocation of HR_ABM_SHD from custom code is not recommended, since it is unsupported internal infrastructure that may change between patch levels in Oracle EBS 12.1.1 and 12.2.2.