Search Results contingent_worker

Overview

The APPS.HR_CONTINGENT_WORKER_BE5 package body is a generated PL/SQL wrapper belonging to the Oracle E-Business Suite HR (Human Resources) product family, specifically targeting the Contingent Worker placement lifecycle. Its header comment indicates it was code-generated (the embedded $Header string references hrapiwfe.pkb, the HR API Workflow Event generator resource), meaning the package exists to bridge the public HR Contingent Worker API layer and the Oracle Workflow Business Event system. In Oracle EBS 12.1.1 and 12.2.2, this class of BE (Business Event) wrapper package is generated automatically by the HR API generator and is responsible for raising Workflow events that fire subscription-based business logic and integrations when contingent worker placement operations are performed.

The single documented entry point, REVERSE_TERMINATE_PLACEMENT_A, corresponds to the public API HR_CONTINGENT_WORKER_API.REVERSE_TERMINATE_PLACEMENT. Its role is to undo a previously executed termination of a contingent worker placement, restoring the placement to its active state so that the associated assignment, person, and placement records reflect the reversal consistently.

Key Procedures and Functions

• REVERSE_TERMINATE_PLACEMENT_A — The package's sole documented procedure. It implements the business event wrapper for the reverse-terminate-placement operation on a contingent worker. Rather than performing the data change itself, the procedure validates whether the corresponding business event (oracle.apps.per.api.contingent_worker.reverse_terminate_placement) is enabled via WF_EVENT.TEST, obtains a sequence key from PER_WF_EVENTS_S, builds an XML payload containing the validate flag, person identifier, actual termination date, and any related attributes, and raises the Workflow event. Callers pass a validation flag, person identifier, termination date, and clear-details / future-actions warning parameters; the procedure honours the p_validate flag so that a run can be executed in validation-only mode without committing data.

Tables Accessed

• PER_WF_EVENTS_S — The sequence source for the Workflow event key. A SELECT PER_WF_EVENTS_S.NEXTVAL FROM DUAL supplies the unique l_event_key used to correlate the raised business event with its subscriber processing.
• DUAL — Used incidentally to fetch the sequence value in the get_seq cursor.
• DBMS_LOB — Not a table but a PL/SQL-supplied package referenced directly, used to create a temporary CLOB and append the XML event body.

Business data itself is not written by this wrapper; the actual placement reversal is performed by the underlying public API, while this package is responsible only for the event payload and dispatch.

Usage Notes

HR_CONTINGENT_WORKER_BE5 is not intended for direct invocation by end users or custom code. It is invoked programmatically from within the HR Contingent Worker API stack — typically through HR_CONTINGENT_WORKER_API.REVERSE_TERMINATE_PLACEMENT — whenever a placement termination is reversed. Because the package is generated, it should not be modified manually; regeneration occurs automatically as part of the HR API generation process.

The raised business event oracle.apps.per.api.contingent_worker.reverse_terminate_placement must be enabled in the Workflow Business Event System for the payload to be processed. Subscribers configured against that event (for example, integrations to other systems or internal workflow processes) will then execute. In 12.1.1 and 12.2.2, the same object is delivered under the APPS schema; one other generated package references it, reflecting the typical generated-wrapper dependency chain in the HR API structure.