Search Results final_process_placement

Overview

The APPS.HR_CWK_TERMINATION_SWI package is a self-service wrapper layer within the Oracle E-Business Suite Human Resources (HR) module. Its purpose is to expose termination and placement-related business logic to self-service flows and workflow-driven processes, specifically for contingent workers. The SWI suffix denotes "Self-Service Web Interface," indicating that the package serves as an interface layer between the self-service UI (typically Oracle iRecruitment or the contingent worker self-service pages) and the underlying public HR APIs.

The package is classified as API classification OTHER and is owned by the APPS schema. Each procedure in the package acts as a thin wrapper that derives input parameters appropriately and delegates the actual business processing to lower-level APIs (for example, hr_contingent_worker_api.actual_termination_placement), then returns status codes (p_return_status) to the calling layer. The package header also defines the constant gv_TERMINATION_ACTIVITY_NAME, which maps to the workflow activity name 'HR_CWK_TERMINATION_SWI'.

Key Procedures and Functions

The package exposes eight documented procedures:

• ACTUAL_TERMINATION_PLACEMENT — Self-service wrapper to hr_contingent_worker_api.actual_termination_placement. Records the actual termination date for a contingent worker placement and returns status plus an "entries changed" warning.
• FINAL_PROCESS_PLACEMENT — Performs the final processing step of a placement during termination, finalizing the placement record after the termination has been actioned.
• GET_LENGTH_OF_PLACEMENT — Calculates and returns the length of a contingent worker's period of placement, typically used to inform termination rules or UI displays.
• REVERSE_TERMINATE_PLACEMENT — Reverses a previously applied termination on a placement, restoring the placement to an active status.
• TERMINATE_PLACEMENT — Initiates termination of a contingent worker placement, invoking the underlying API and returning status.
• PROCESS_SAVE — Persists changes made during a self-service transaction, committing the placement/termination data.
• GETTRANSACTIONDETAILS — Retrieves details about a specific HR API transaction, supporting error handling and diagnostics.
• PROCESS_API — Generic dispatcher used internally to route calls to the appropriate API procedure.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

• WF_ITEMS — Workflow item data; used because the package participates in the HR termination workflow (activity name HR_CWK_TERMINATION_SWI).
• HR_API_TRANSACTION_STEPS — Tracks HR API transaction steps for validation, error handling, and rollback support.
• PER_ALL_PEOPLE_F — The core person record; termination logic updates this datetracked table.
• PER_PERIODS_OF_PLACEMENT — The placement history for contingent workers; termination and reversal operations modify this table.

Usage Notes

This package is marked "Internal Development use only." It is not intended for direct invocation by custom code. It is typically called from Oracle self-service modules and from the HR workflow engine as part of the HR_CWK_TERMINATION_SWI workflow activity. Administrators who search for connectivity errors (such as 172.18.10.10:1000 logout) while triggering a contingent worker termination should be aware that the failure may occur at this wrapper layer, producing a p_return_status of failure rather than an exception. Because the wrapper depends on HR_API_TRANSACTION_STEPS and workflow items, diagnosis requires examining both the workflow activity status and the API transaction log. The package is referenced by no other documented packages, confirming its role as a terminal self-service interface rather than a shared utility.