Search Results create_mx_person_absence




Overview
Explore in AI Chat

Overview

APPS.HR_MX_PERSON_ABSENCE_API is a Mexican localization wrapper package for the global HR person absence API. It is classified in ETRM as an API and is owned by the APPS schema. Its purpose is to provide a country-specific entry point for creating and maintaining person absence records for Mexican business groups, delegating the core processing to the seeded global package HR_PERSON_ABSENCE_API.

This package is part of the Oracle E-Business Suite 12.1.1 / 12.2.2 localization layer for Mexico. Because absence and attendance handling can be subject to country-specific legislative and payroll reporting requirements, Oracle delivers localized wrappers that validate or enrich data before invoking the global API logic. The package body carries the source header identifier hrmxwrpa.pkb, version 120.0, dated 31 May 2005, and is marked noship, consistent with a localization deliverable compiled into the APPS schema.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package body:

  • CREATE_MX_PERSON_ABSENCE — This procedure acts as the wrapper for HR_PERSON_ABSENCE_API.CREATE_PERSON_ABSENCE, which is the exact object referenced in the user's search. It accepts the person absence attributes required by the global API, including the effective date, person identifier, business group, absence attendance type, absence attendance reason, and comments, together with a validation flag. It performs the Mexico-specific handling and then calls the global creation routine to insert the absence record.
  • UPDATE_MX_PERSON_ABSENCE — This procedure provides the corresponding maintenance path for existing Mexican person absence records. The change list records that version 115.1, dated 09-JUL-2004, added a business group check within this procedure, ensuring that updates are constrained to the correct business group before the record is modified.

Only these two procedures are exposed and documented; the package body is the sole implementation unit listed in ETRM.

Tables Accessed

The documented tables referenced through APPS synonyms are:

  • PER_ABSENCE_ATTENDANCES — The primary transactional table for person absence and attendance records. This is where creation inserts the new Mexican absence row and where update modifies the existing row. The absence attendance type and reason identifiers supplied to the procedures resolve against the reference data used by this table.
  • PER_ALL_PEOPLE_F — The dated person table. It is referenced to validate the person and business group context; the business group check added in version 115.1 of the update procedure relies on the person's business group assignment being consistent with the business group passed in.

Usage Notes

This package is intended to be invoked for Mexican business groups in place of direct calls to the global HR_PERSON_ABSENCE_API. It is normally called from the Oracle Forms-based absence and attendance entry screens, from localization concurrent programs that load or correct absence data, and from custom PL/SQL where a Mexico-specific absence must be created or amended.

Because the create wrapper delegates to create_person_absence, callers must supply the same mandatory context the global API expects, notably an effective date, person identifier, business group, and absence attendance type. The p_validate flag, defaulted to false, permits a validation-only run. Developers should be aware that the wrapper is restricted to Mexican business groups; the business group check introduced in version 115.1 means an update attempted against a person outside the expected group will not proceed. The package is not referenced by other packages, so it should be treated as a terminal API layer for customizations and never modified directly.