Search Results update_absence_dev_desc_flex

Overview

The APPS.HR_AU_ABSENCE_HOOK package is a country-specific (Australian) localization hook within the Oracle E-Business Suite Human Resources (HR) module. Its primary business function is to support the Australian absence and attendance processing requirements by allowing descriptive flexfield (DFF) information associated with absence records to be updated in a controlled, programmatic manner. The package is classified as an "OTHER" API type in the ETRM metadata, indicating that it is not a standard public APIs but rather a specialized hook intended to extend or supplement absence processing logic specific to the Australian legislative and reporting context.

The package header carries a version identifier referencing pea­ulhab.pkh, and the source comments indicate it has been part of the HR Australian localization since at least 2006. The hook acts as a bridge between the core Oracle HR absence framework and the additional descriptive attributes that Australian customers frequently require on absence records — most notably the "Developer Descriptive Flexfield" segments.

Key Procedures and Functions

The documented package exposes a single procedure:

• UPDATE_ABSENCE_DEV_DESC_FLEX — This procedure is responsible for updating the developer descriptive flexfield (DFF) segments associated with a specific absence or attendance record. It accepts the absence attendance identifier as its input to locate the target record and then applies the DFF updates accordingly. Because it operates on the developer DFF, it is typically used to enforce or propagate values that are derived from absence-related business rules rather than entered directly by end users.

No additional procedures or functions are documented for this package. The single procedure reflects the narrow, hook-style purpose of the package: to provide a targeted extension point for Australian absence DFF maintenance.

Tables Accessed

The package references several core HR and Payroll tables through APPS synonyms:

• PER_ABSENCE_ATTENDANCES — The primary absence/attendance record table. The procedure reads and updates the row identified by the absence attendance ID to maintain the developer DFF segments.
• PER_ALL_ASSIGNMENTS_F — The assignment table, used to link the absence record to the employee assignment, often to derive context or validation values for the flexfield.
• PAY_ELEMENT_ENTRIES_F — Payroll element entries associated with the absence, potentially used when absence values feed payroll processing.
• PAY_ELEMENT_TYPES_F — Element type definitions, used to identify or validate the payroll elements related to the absence.

These tables indicate that the hook is positioned at the intersection of HR absence management and Payroll element processing, ensuring that Australian-specific DFF data remains consistent with the underlying payroll and assignment data.

Usage Notes

HR_AU_ABSENCE_HOOK is typically invoked indirectly rather than by end users. It is called by at least one other package (per ETRM metadata), which triggers it during absence creation or update flows — for example, when absence records are processed through the Australian localization of the absence form or through absence-related concurrent programs. The package may also be called from custom PL/SQL code where Australian customers need to programmatically maintain DFF values on absence records.

Because the procedure is a hook, direct invocation should be undertaken with care. Any calling code must supply a valid absence attendance ID and ensure the developer DFF is configured for the relevant absence DFF context. The package is available in both Oracle EBS 12.1.1 and 12.2.2, with the same documented interface, making it a stable integration point across releases.