Search Results create_mx_cwk




Overview
Explore in AI Chat

Overview

HR_MX_CONTINGENT_WORKER_API is a Mexican localization wrapper package within the Oracle EBS Human Resources (HR) module. Its primary business function is to provide a country-specific (Mexico) layer over the global HR_CONTINGENT_WORKER_API, allowing the creation of contingent worker records that comply with Mexican statutory and business requirements. Contingent workers in Mexico include temporary staff, contractors, and outsourced personnel who must be registered in the HR system with the same rigor as regular employees, capturing personal identification details, background verification status, and organizational assignment data.

The package was created in June 2004 (version 115.0) and revised in July 2004 (version 115.1, Bug 3695738) to relax the mandatory requirement on the first name attribute, reflecting the practical reality that some Mexican workers may be registered with only paternal and maternal surnames or under abbreviated naming conventions. The package is classified as an API in ETRM 12.2.2 and is owned by the APPS schema. It is built as a wrapper, meaning it delegates actual record creation logic to the underlying global HR contingent worker API while layering Mexican-specific validation and defaults.

Key Procedures and Functions

The package exposes one documented procedure:

  • CREATE_MX_CWK — This procedure acts as a wrapper for HR_CONTINGENT_WORKER_API.CREATE_CWK. Its purpose is to create a contingent worker record in the Mexican localization context. The procedure accepts parameters covering the validation flag, start date, business group identifier, personal name components (paternal last name), person type identifier, national population registry (NPW) number, and background check information including background check status and background check date. The p_npw_number parameter is defined as an IN OUT NOCOPY parameter, indicating that the API both consumes an incoming value and may return a generated or normalized value to the caller.

No other procedures or functions are documented for this package. The single entry point reflects its narrow scope as a localization wrapper rather than a full-featured API suite.

h4>Tables Accessed

The documented metadata does not list explicit base tables accessed via APPS synonyms. In practice, this package operates indirectly through the underlying HR_CONTINGENT_WORKER_API, which writes to core HR tables such as PER_PEOPLE_F, PER_ASSIGNMENTS_F, PER_PERSON_TYPES, and related person and assignment tables. Background check information may be stored in person extra information or a Mexican-specific background verification structure. Because the wrapper delegates to the global API, direct DML against these tables is not expected; instead, the package relies on the parent API's persistence logic.

Usage Notes

HR_MX_CONTINGENT_WORKER_API.CREATE_MX_CWK is typically invoked from Oracle HR forms (such as the Contingent Worker or Person entry forms), concurrent programs, or custom PL/SQL routines that register Mexican contingent workers. Because it wraps the global API, callers should prefer this procedure over HR_CONTINGENT_WORKER_API.CREATE_CWK when processing Mexican business groups, ensuring the localization defaults and validations — including the optional first name behavior introduced in version 115.1 — are applied consistently.

Developers integrating this API should note that it is classified as a public API and is referenced by no other packages within the documented ETRM scope, meaning it is intended primarily for external or form-based invocation. Validation errors raised by the underlying API will propagate to the caller, so exception handling should account for standard HR API error patterns. The p_validate parameter permits a dry-run mode, allowing callers to verify data without committing the contingent worker record.