Search Results hr_assignment_swi




Overview
Explore in AI Chat

Overview

HR_ASSIGNMENT_SWI is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. The suffix "SWI" denotes a Self-Service Web Interface wrapper — a family of packages in Oracle HRMS that expose core Human Resources APIs to Oracle Self-Service applications such as iRecruitment and Manager Self-Service. HR_ASSIGNMENT_SWI wraps and orchestrates the base assignment APIs (notably HR_ASSIGNMENT_API and HR_APPLICANT_API) so that web-facing flows can create, update, offer, activate, accept, and terminate assignments without calling the lower-level APIs directly. The package is documented in ETRM metadata for EBS 12.1.1 and 12.2.2 with a status of VALID and an API classification of OTHER. It is not referenced by any other database object, indicating it functions strictly as a top-level entry point invoked by application code. The package consolidates messaging (FND_MESSAGE, HR_MULTI_MESSAGE), key flexfield handling (HR_KFLEX_UTILITY), and general HR utilities (HR_UTILITY) into a single transactional interface, ensuring that assignment changes initiated from self-service pages respect the same business rules, validations, and date-tracked storage as those made through the professional forms interface.

Key Procedures and Functions

ETRM documents eight procedures and functions within HR_ASSIGNMENT_SWI. Their purpose is summarized below; parameter signatures are deliberately omitted.

  • CREATE_SECONDARY_APL_ASG — Creates a secondary assignment for an applicant, allowing a person to hold more than one concurrent assignment record with distinct terms and conditions.
  • OFFER_APL_ASG — Places an offered assignment against an applicant, transitioning the applicant-to-assignment relationship into a pending state during the recruitment process.
  • ACCEPT_APL_ASG — Records an applicant's acceptance of an offered assignment, advancing the assignment toward an active state.
  • ACTIVATE_APL_ASG — Activates an applicant assignment, making it effective as a live assignment record on PER_ALL_ASSIGNMENTS_F.
  • TERMINATE_APL_ASG — Terminates an active applicant assignment, preserving the historical record while setting the effective end date.
  • UPDATE_APL_ASG — Updates assignment attributes for an applicant assignment, applying date-tracked changes through the underlying HR_ASSIGNMENT_API.
  • UPDATE_EMP_ASG — Updates an existing employee assignment, typically invoked from Manager Self-Service or employee self-service pages.
  • UPDATE_EMP_ASG_CRITERIA — Maintains assignment criteria associated with employee assignment updates, supporting rule-based or conditional assignment maintenance.

Tables Accessed

The package operates against the following documented tables, referenced through APPS synonyms:

  • PER_ALL_ASSIGNMENTS_F — The primary date-tracked assignment table; all create, offer, accept, activate, update, and terminate operations ultimately write to this table.
  • PER_ALL_PEOPLE_F and PER_PEOPLE_F — The person records to which assignments belong; read to validate the person and, where required, write to synchronize person-level data during assignment actions.
  • PER_ASSIGNMENT_STATUS_TYPES — Supplies valid assignment status values (for example, Active, Offered, Terminated) used to set the status of the assignment during lifecycle transitions.
  • IRC_ASSIGNMENT_STATUSES — The iRecruitment assignment status table, read and maintained so the recruitment-facing status remains consistent with the HRMS assignment status.
  • PLITBLM — The standard PL/SQL integer table used for bulk binds and multi-message accumulation.

Usage Notes

HR_ASSIGNMENT_SWI is invoked from the Self-Service Web Applications layer, characteristically from iRecruitment offer and applicant management flows and from Manager Self-Service assignment maintenance. Because it is not referenced by other database objects, it acts as an application-level entry point rather than a reusable library for other packages. When extending or troubleshooting these self-service flows, developers should call the same public procedures rather than HR_ASSIGNMENT_API directly; the SWI wrapper supplies multi-message error handling and key flexfield validation that the base API callers otherwise must replicate. Dependencies include APPS.HR_API, HR_ASSIGNMENT_API, HR_APPLICANT_API, HR_MULTI_MESSAGE, HR_KFLEX_UTILITY, HR_UTILITY, FND_MESSAGE, PER_ASG_INS, and PLITBLM. Any custom concurrent program or personalization that must perform the equivalent assignment lifecycle operations should reuse this package to guarantee consistent validations across EBS 12.1.1 and 12.2.2.