Search Results apply_for_job

Overview

APPS.HR_CONTINGENT_WORKER_API is a public PL/SQL API in Oracle E-Business Suite (12.1.1 / 12.2.2) that supports the Oracle iRecruitment and Contingent Worker (CWK) business flows. It encapsulates the business logic required to register, convert, place, and terminate contingent workers — individuals engaged on a temporary, contract, or project basis rather than as full-time employees. The package is classified as an API in the ETRM metadata, indicating that it is intended for programmatic invocation by other Oracle applications and by customer extensions rather than by end users directly. The file header (pecwkapi.pkb, version 120.4.12010000.1) confirms it has been part of the EBS codebase since the 11i/12.0 lineage and remains present in 12.1.1 and 12.2.2. Because contingent workers are represented as people and assignments in Oracle HRMS, this API acts as a controlled entry point that maintains data integrity across PER and PAY tables while enforcing the CWK-specific rules established by the hiring and placement process. The package is referenced by 19 other packages, reflecting its central role in the contingent workforce module.

Key Procedures and Functions

• CREATE_CWK — Creates a new contingent worker record. It accepts a wide set of personal and placement attributes, including start date, business group, last name, person type, NPW number, background check status and date, and numerous optional descriptive fields (date of birth, email, nationality, marital status, and so on), and returns the generated NPW number.
• CONVERT_TO_CWK — Converts an existing person or applicant into a contingent worker, establishing the associated period of placement and person type usage.
• APPLY_FOR_JOB — Supports the application of a contingent worker to a job requisition or vacancy. This is the procedure most commonly associated with the "apply_for_job" search term and is the entry point used when a CWK candidate applies for a posted opening.
• ACTUAL_TERMINATION_PLACEMENT — Records the actual termination of an existing placement, updating the period of placement with the effective end date and related termination information.
• FINAL_PROCESS_PLACEMENT — Performs the final processing steps for a placement, finalizing the assignment and placement records once the engagement has concluded.
• TERMINATE_PLACEMENT — Terminates a placement, with support for reversal where the termination was applied in error.
• REVERSE_TERMINATE_PLACEMENT — Reverses a previously executed placement termination, restoring the placement to its prior active state.
• GET_LENGTH_OF_PLACEMENT — Returns the computed length of a placement, based on the start and end dates held in the period of placement record.

Tables Accessed

The package reads and writes a focused set of HRMS and payroll tables through APPS synonyms. PER_ALL_PEOPLE_F and PER_PERSON_TYPES/PER_PERSON_TYPE_USAGES_F hold the person and person-type data for the contingent worker. PER_PERIODS_OF_PLACEMENT stores the placement period that drives the CWK lifecycle, while PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES, and PER_ASSIGNMENT_BUDGET_VALUES_F carry the assignment-level detail. Supporting data such as PER_BOOKINGS, PER_EVENTS, and PER_PERFORMANCE_REVIEWS are used for related worker activities. Payroll integration relies on PAY_ASSIGNMENT_ACTIONS, PAY_COST_ALLOCATIONS_F, PAY_GRADE_RULES_F, PAY_PAYROLL_ACTIONS, and PAY_PERSONAL_PAYMENT_METHODS_F to drive payroll processing and cost allocation for the contingent worker.

Usage Notes

HR_CONTINGENT_WORKER_API is normally invoked indirectly through the Oracle iRecruitment and Contingent Worker forms, and through concurrent programs that manage CWK placement and termination. Custom code and integrations may call the procedures directly when automating contingent worker onboarding, job applications (via APPLY_FOR_JOB), or termination processing. Because it is a public API, callers should pass the p_validate flag as TRUE to perform validation without committing data, populate mandatory parameters such as the start date and business group, and rely on the package to maintain the PER/PAY integrity of the resulting records.