Search Results per_abs_upd




Overview
Explore in AI Chat

Overview

PER_ABS_UPD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the maintenance and update of employee absence and attendance records within Oracle Human Resources (Oracle HRMS). The package operates as a lower-level implementation component within the absence management stack, complementing the public-facing HR_PERSON_ABSENCE_API package. Its central responsibility is to apply modifications to existing absence records held in the PER_ABSENCE_ATTENDANCES table, ensuring the update logic is encapsulated and reusable across the application. The package is documented with a status of VALID in both EBS 12.1.1 and 12.2.2, with an API classification of OTHER, indicating it is a supporting internal utility rather than a formally published business API.

Key Procedures and Functions

The ETRM documentation records a single documented procedure for this package:

  • UPD — The update procedure encapsulates the logic required to modify absence and attendance records. It is the primary entry point for change operations against existing absence data and coordinates the underlying persistence logic. No parameter list is documented, and customizations should not assume a fixed signature without direct inspection of the package specification.

The package body may contain additional private helpers; only the UPD procedure is surfaced in the documented metadata. Developers requiring the complete interface should inspect the package specification in the database dictionary.

Tables Accessed

The documented table reference is:

  • PER_ABSENCE_ATTENDANCES — The core Oracle HRMS table storing employee absence and attendance entries, including absence type, start and end dates, reasons, and related assignment context. PER_ABS_UPD reads and writes this table through APPS synonyms as part of the update flow.

The dependency metadata also shows references to PER_ABS_SHD (the absence shadow table used for audit/history tracking), the HR_API package, and the SYS STANDARD package. The PER_ABS_SHD reference indicates that updates performed by this package may participate in the standard HRMS audit trail mechanism, preserving prior values for historical reporting.

Usage Notes

PER_ABS_UPD is invoked indirectly rather than called directly by end users or typical customizations. Documented dependency information shows that it is referenced by HR_PERSON_ABSENCE_API, which is the supported public API for creating and maintaining person absence records. The package is also shown as self-referencing, indicating internal recursion or reuse within its own body. Oracle's standard design pattern directs developers and integrators to transact absence data through HR_PERSON_ABSENCE_API so that validation, date-effectivity checks, and audit handling remain intact; PER_ABS_UPD acts as the underlying update engine for that API.

Typical invocation paths include the Oracle HRMS absence entry forms, self-service absence workflows, and batch or interface programs that call the HR_PERSON_ABSENCE_API. Custom code should avoid direct calls to PER_ABS_UPD, as its signature and behavior are not guaranteed across patch levels or releases. Where direct access is unavoidable, it should be limited to read-only analysis, and any update requirement should be routed through the documented HR_PERSON_ABSENCE_API to preserve data integrity and upgrade safety.