Search Results hr_se_contingent_worker_api




Overview
Explore in AI Chat

Overview

The APPS.HR_SE_CONTINGENT_WORKER_API package body is a public PL/SQL API in Oracle E-Business Suite that supports the creation of contingent worker records. Its name follows the Oracle naming convention in which the _SE_ infix denotes a Swedish (localization) implementation, while CONTINGENT_WORKER_API identifies the business object being managed — the contingent worker, Oracle EBS terminology for a contractor, temporary employee, or other non-standard worker engaged by the enterprise.

The package is classified as an API in the ETRM 12.2.2 metadata, is owned by the APPS schema, and carries a VALID status. It has a single documented entry point, CREATE_SE_CWK, and is not referenced by any other database object, indicating that it is an entry-point API invoked directly by external callers rather than a shared dependency of other packages.

Key Procedures and Functions

The ETRM metadata documents one procedure or function for this package body:

  • CREATE_SE_CWK — The sole documented entry point. Its naming indicates that it creates a Swedish contingent worker record, encapsulating the validation and insert logic required to establish a contingent worker in the Oracle HRMS data model. Consistent with the ETRM documentation, this description is limited to the procedure's purpose; parameter lists are not reproduced here because the metadata excerpt does not enumerate them.

The package body depends on HR_CONTINGENT_WORKER_API, the global (non-localized) contingent worker API, suggesting that CREATE_SE_CWK delegates core worker creation to that API while applying Swedish localization logic. It also references HR_UTILITY, an internal HRMS utility package, and the STANDARD package, which supplies standard PL/SQL error-raising and message-handling routines.

Tables Accessed

The documented dependencies include two base tables in the APPS schema:

  • PER_PEOPLE_F — The dated, effective-dated person table in Oracle HRMS. It stores person-level attributes such as name, dates of birth, and national identifiers. A contingent worker creation routine generally reads and writes this table to establish the person record underlying the worker assignment.
  • PER_BUSINESS_GROUPS — The business group table that defines the enterprise's HR organization. It is typically queried to derive the business group context, secure the correct legislation, and validate the operating unit under which the contingent worker is created.

These tables are accessed through APPS synonyms, as is standard for Oracle EBS APIs. The metadata does not enumerate additional tables, so no further table usage can be asserted.

Usage Notes

HR_SE_CONTINGENT_WORKER_API is typically invoked by custom PL/SQL code, localization extensions, or integration programs that need to create a contingent worker within a Swedish business group context. Because the package is not referenced by any other database object, it does not participate in internal Oracle EBS call chains; callers must invoke it explicitly.

As a public API, it should be treated as a supported interface and called in preference to direct DML against PER_PEOPLE_F or related HRMS tables, ensuring that validation, business group resolution, and contingent worker type derivation are applied consistently. The presence of the _SE_ prefix indicates that the package is part of the Swedish localization layer and should be used when creating contingent workers for Swedish legislation; for other legislations, the base HR_CONTINGENT_WORKER_API would ordinarily apply. Deployment is supported on both Oracle EBS 12.1.1 and 12.2.2, and the object is reported as VALID in the 12.2.2 ETRM repository.