Search Results hr_person_absence_api




Overview
Explore in AI Chat

Overview

HR_PERSON_ABSENCE_API is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified in the ETRM as an API, meaning it conforms to the Oracle EBS API coding standards—including the HR_API transaction mechanism—and is intended to be called from custom code, forms, or other products rather than being modified. The package provides the supported programmatic interface for creating, maintaining, and querying person absence records in Oracle HRMS. An "absence" represents a contiguous period during which an employee is unavailable for work, such as sick leave, vacation, maternity leave, or a leave of absence. The package encapsulates the business rules that govern absence processing, including validation against absence attendance types, assignment eligibility, and the linkage between an absence record and the payroll element entries that administer it (for example, the element that deducts or accrues absence pay). By centralizing this logic, the package allows absence data to be maintained consistently whether the data originates from the Oracle HRMS forms, from a localized country extension, or from third-party time-and-attendance integration.

Key Procedures and Functions

ETRM documents 13 procedures and functions within the package:

Tables Accessed

Via APPS synonyms, the package accesses absence and payroll tables. PER_ABSENCE_ATTENDANCES stores the absence records themselves, while PER_ABSENCE_ATTENDANCE_TYPES provides the absence categories and their processing rules. PER_ALL_ASSIGNMENTS_F supplies assignment data for the employee. On the payroll side, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_INPUT_VALUES_F, and PAY_ELEMENT_ENTRIES_F hold the element definition, eligibility, input values, and entries created for an absence. HR_API_TRANSACTIONS and HR_API_TRANSACTION_STEPS support the transaction steps used to capture and replay API operations, and PLITBLM is the PL/SQL table structure used internally. XMLDOM and XMLPARSER are referenced for XML processing.

Usage Notes

The package is invoked from the Absence/Attendance windows in the HRMS forms, from concurrent programs and business processes, and from custom PL/SQL that must respect API validation. It is referenced by HR_PERSON_ABSENCE_SWI, HR_LOA_SS, HR_MX_PERSON_ABSENCE_API, PER_ABSENCE_ATTENDANCES_PKG3, PER_ABS_BUS, PER_ES_ABSENCE, and PAY_FR_SICKNESS_ABSENCE, reflecting both the base product and country/localization extensions. Custom callers should use the standard HR_API transaction pattern (initialise, call, commit/rollback) and should not update the underlying absence tables directly.