Search Results hr_mx_person_absence_api




Overview
Explore in AI Chat

Overview

APPS.HR_MX_PERSON_ABSENCE_API is a PL/SQL package that forms part of the Oracle E-Business Suite localization layer for Mexico (HRMS MX). Its purpose is to provide a programmatic, business-logic-encapsulated interface for recording and maintaining person-level absence records within the Mexican statutory framework. Rather than allowing direct DML against the underlying absence tables, the package exposes formally classified API entry points that validate absence data and preserve the integrity of Oracle HRMS date-tracked records. The package is classified as a Public API in the Oracle ETRM repository, meaning it is intended for invocation by external callers such as forms, concurrent programs, and customer extensions. In the 12.1.1 and 12.2.2 releases the object resides in the APPS schema and reports a VALID status, confirming that the package and its body compile successfully against the shipped database objects.

Key Procedures and Functions

The ETRM metadata documents two callable procedures within the package specification.

  • CREATE_MX_PERSON_ABSENCE — Creates a new Mexican person absence record. It encapsulates the validation and insertion logic required to register an absence against an employee, so that downstream payroll and absence-processing routines receive a consistent, correctly dated record.
  • UPDATE_MX_PERSON_ABSENCE — Modifies an existing Mexican person absence record. It applies the same validation rules as the create routine so that subsequent corrections to an absence remain compliant with the localization requirements.

Both procedures follow the standard Oracle HRMS API convention: they accept a business-group context and an effective date, perform server-side validation, and signal errors through the standard HR message mechanism rather than by unhandled exceptions. Parameter lists are deliberately not reproduced here; developers should reference the package specification or the ETRM documentation for the exact argument signatures.

Tables Accessed

The package operates against the core Oracle HRMS absence structures exposed to the APPS schema through synonyms.

  • PER_ABSENCE_ATTENDANCES — The primary table holding absence and attendance records. Both the create and update procedures read and write this table to persist the Mexican absence rows, including the absence type, start and end dates, and associated person reference.
  • PER_ALL_PEOPLE_F — The date-tracked person table, used to validate that the employee identified in the call is a valid, current person for the effective date supplied, and to resolve the person and assignment context required by the absence record.

Consistent with standard HRMS design, the package centralizes writes so that absence data is created only through validated API logic rather than by ad-hoc inserts.

Usage Notes

APPS.HR_MX_PERSON_ABSENCE_API is invoked in the same circumstances as other HRMS person-absence APIs. Typical callers include the Oracle Forms-based Mexican absence and absence-tracking screens, which delegate their save logic to the API, and concurrent or batch processes that load or adjust absence data in bulk. Customer-written extensions, interfaces, and conversions targeting Mexican absence records should call these procedures rather than inserting into PER_ABSENCE_ATTENDANCES directly, so that validation, date-track handling, and any localization-specific business rules remain intact. Callers must supply a valid business-group identifier, an effective date, and appropriate session context. Because the package depends on HR_API and PER_ABSENCE_ATTENDANCES, it should be invoked within the standard HRMS setup rather than in isolation. According to the documented dependency information, the package is not referenced by any other packaged API, indicating that it functions as a top-level entry point rather than as an internal helper to be chained from other APIs.