Search Results hr_pl_contingent_worker_api




Overview
Explore in AI Chat

Overview

The APPS.HR_PL_CONTINGENT_WORKER_API package is a PL/SQL API owned by the APPS schema within Oracle E-Business Suite. Its name and classification identify it as a public API belonging to the Oracle Human Resources (HR) product family, with the "PL" component signifying its association with Oracle Payroll or placement-related processing and "CONTINGENT_WORKER" denoting its specific focus on contingent worker records. In Oracle EBS 12.1.1 and 12.2.2, contingent workers represent a distinct category of person and assignment records managed through the HR foundation, separate from full-time regular employees. This package provides programmatic access to create and manage such records without requiring direct DML against the underlying HR tables, thereby preserving the integrity of the HR data model and ensuring that all validation, date-tracked datetrack logic, and business rules are correctly applied. The package is documented in ETRM as VALID and is classified as an API, confirming that it is intended for supported programmatic invocation rather than internal use only.

Key Procedures and Functions

The documented API surface of this package consists of a single entry point, CREATE_PL_CWK. As its name implies, this procedure is responsible for creating a contingent worker record within the Oracle HR and Payroll placement context. The procedure encapsulates the business logic required to instantiate the person and assignment data necessary for a contingent worker engagement, applying Oracle HR validation rules during execution. Because the ETRM metadata does not enumerate the formal parameter signatures for this procedure, the exact argument list is not reproduced here; developers should consult the package specification in the database or the Oracle HRMS API documentation for the authoritative parameter definitions. The presence of a single documented procedure indicates that the package is narrowly scoped to the creation of contingent worker records, with related maintenance operations handled through other HR APIs.

Tables Accessed

The ETRM documentation for this object does not enumerate specific base tables referenced through APPS synonyms. In practice, a contingent worker creation API of this nature operates against the core Oracle HR datetracked entities, typically including the person, assignment, and associated payroll or placement tables that store contingent worker attributes. No explicit table list is recorded in the supplied metadata, and therefore the specific read and write targets cannot be confirmed from documentation alone. Consumers should treat the underlying table dependencies as internal to the package and rely on the API contract rather than direct table access.

Usage Notes

This package is typically invoked from custom PL/SQL code, Oracle Forms personalizations, or concurrent programs that need to programmatically register contingent workers as part of an integrated HR or payroll process. It is not referenced by any other documented packages, indicating that it is a leaf-level API invoked directly by application code rather than by other shared libraries. Because it is classified as a public API in the APPS schema and carries a VALID status, it is supported for customer use, provided callers supply the required arguments and handle exceptions appropriately. Developers integrating with external staffing or vendor management systems should call CREATE_PL_CWK rather than inserting into HR tables directly, ensuring that datetrack validation and business rules remain intact across both 12.1.1 and 12.2.2 releases.