Search Results hr_ae_contingent_worker_api




Overview
Explore in AI Chat

Overview

The APPS.HR_AE_CONTINGENT_WORKER_API package body is a PL/SQL API classified under Oracle EBS Human Resources (HR) that supports the creation and management of contingent worker records within the Applications product family. Contingent workers are non-employee personnel such as contractors, temporary staff, and agency-supplied resources engaged by an enterprise. In Oracle EBS 12.1.1 and 12.2.2, the HR module provides a dedicated API infrastructure for registering and maintaining these workers through the People model, mirroring the way employees are handled but with distinct business rules governing assignments, placements, and eligibility.

This particular package carries the _AE_ infix, which in Oracle EBS naming conventions typically denotes a country-specific or localization-extended variant. In this case the suffix aligns with the United Arab Emirates (AE) localization. The package therefore acts as a regional wrapper or extension layer over the base HR_CONTINGENT_WORKER_API, applying locale-specific validation, statutory defaults, or business logic required for UAE deployments. It resides in the APPS schema, is marked VALID, and is exposed as a public API for downstream consumers.

Key Procedures and Functions

The documented interface exposes a single program unit: CREATE_AE_CWK. As the name indicates, this routine is responsible for creating a contingent worker record in the UAE localization context. It encapsulates the localized business logic that must be applied at the point of worker creation — such as deriving regional defaults, enforcing UAE-specific field requirements, and orchestrating the underlying base-table insert through the standard HR contingent worker API. The procedure is the sole documented entry point for this package, meaning all contingent-worker creation logic channeled through the AE extension flows through CREATE_AE_CWK. The ETRM metadata does not enumerate parameter signatures for this procedure, and no parameter list should be assumed beyond what the source specification declares.

Tables Accessed

The dependency metadata for this package identifies several database objects it interacts with. The package references PER_PEOPLE_F, the primary datastore for person records in Oracle HRMS, which holds the core identity of the contingent worker. It also references PER_BUSINESS_GROUPS, the business group entity that scopes HR data and governs legislative context for the UAE. Beyond these tables, the package depends on the base API package HR_CONTINGENT_WORKER_API and the utility package HR_UTILITY, both of which supply the core creation logic and shared helper routines. The inclusion of HR_CONTINGENT_WORKER_API as a dependency confirms that HR_AE_CONTINGENT_WORKER_API delegates to the standard API rather than duplicating its logic, applying only the localization-specific layer. The STANDARD package reference provides the conventional EBS error-handling and message-stack framework.

Usage Notes

This package is typically invoked from localization-specific extensions, such as UAE payroll or HR forms, and from custom code or concurrent programs that must onboard contingent workers under UAE statutory rules. Because it is a server-side API body, it is not called directly by end users; rather it is called by other PL/SQL routines or by form-level triggers configured for the AE localization. Implementers integrating with the UAE HR product should route contingent-worker creation through CREATE_AE_CWK to ensure correct localization behavior. Notably, the metadata records that this package is not referenced by any other database object, indicating it is a top-level API intended for external callers rather than internal reuse by other packaged APIs. As with all EBS APIs, it should be invoked within the standard API savepoint and error-handling pattern.