Search Results create_cwk

Overview

The APPS.HR_SA_CONTINGENT_WORKER_API package provides the Saudi Arabia–specific implementation of contingent worker creation within Oracle E-Business Suite Human Resources. It is a public, localized API that encapsulates the country-specific logic required to register a contingent worker for a Saudi Arabia business group. The package is declared AUTHID CURRENT_USER and ships under the PER product, with the source header identifying it as pecwksai.pkh.

Functionally, the package acts as a thin wrapper. Its documentation states that it "calls the generic API create_cwk, with parameters set as appropriate for the Saudi person," and that it is "effectively an alternative to the API create_cwk." The Saudi wrapper therefore exists to supply localized defaults and validation while delegating the actual record creation to the global contingent worker API. The package is licensed for use with Oracle Human Resources.

Key Procedures and Functions

The documented package surface contains a single public procedure:

• CREATE_SA_CWK — Creates a contingent worker record for Saudi Arabia. It performs the localized setup and then invokes the generic create_cwk API. The parameters documented for this entry point cover validation mode, start date, business group, family name, person type, and contingent worker number, among others; the reference for detailed parameter semantics is the generic create_cwk API.

Because the specification lists only this one procedure, all other contingent worker processing behavior exposed to callers is inherited through the underlying generic API.

Tables Accessed

The ETRM metadata for this package does not enumerate the tables it touches via APPS synonyms. Based on the operational description — that it inserts a contingent worker record into the database using the generic create_cwk API — the package ultimately writes to the core HR person and contingent worker assignment tables on behalf of that generic API. The localized logic specific to Saudi Arabia may additionally read country or business-group level setup held in HR reference tables. Because the package is a wrapper rather than an independent data-access layer, any direct table interaction is confined to configuration reads; the persistent creation of person, assignment, and contingent worker rows is performed by the generic API.

Usage Notes

HR_SA_CONTINGENT_WORKER_API.CREATE_SA_CWK is intended for programmatic invocation from PL/SQL, most commonly from custom concurrent programs, integrations, or bespoke forms processing that need to onboard Saudi contingent workers without reimplementing localization logic. The p_validate parameter follows standard EBS API convention: when set to true, only validation runs and the database remains unchanged; when false and all checks pass, the contingent worker record is created. On success, the record is committed to the database. On failure, no record is created and the API raises an error.

The package is not referenced by any other database package, so callers should treat it as a country extension point rather than a shared utility. Prerequisites mirror those of the generic create_cwk API, and implementations should consult that reference for the full parameter contract, number-generation behavior for the business group, and validation rules.