Search Results hr_applicant_api




Overview
Explore in AI Chat

Overview

HR_APPLICANT_API is a public PL/SQL package owned by the APPS schema that provides the supported programmatic interface for creating and maintaining applicant records within Oracle Human Resources and Oracle iRecruitment. In Oracle EBS 12.1.1 and 12.2.2, it acts as the central business logic layer that abstracts the underlying person, application, assignment, and recruitment tables, ensuring that all applicant-related DML passes through validated HR API logic rather than direct table manipulation. The package is therefore the entry point relied upon by seeded forms, concurrent programs, country-specific localizations, and customer extensions whenever an applicant or application must be inserted, updated, converted, or terminated.

The ETRM 12.2.2 metadata classifies HR_APPLICANT_API as an API object and documents 14 procedures and functions. Because it encapsulates the HR person and application model, it preserves data integrity across the PER_APPLICATIONS, PER_ALL_PEOPLE_F, and PER_ALL_ASSIGNMENTS_F entities and supports the recruitment lifecycle from initial candidate registration through hire.

Key Procedures and Functions

The documented API surface includes the following entry points:

  • CREATE_APPLICANT — Generic procedure that creates an applicant (person and application) using the standard, non-country-specific business rules.
  • CREATE_GB_APPLICANT — Country-specific variant that applies United Kingdom statutory and legislative validation when creating an applicant.
  • CREATE_US_APPLICANT — Country-specific variant that applies United States statutory and legislative validation when creating an applicant.
  • HIRE_APPLICANT — Converts an existing applicant into an employee by establishing the appropriate assignment and person type changes.
  • TERMINATE_APPLICANT — Ends the applicant relationship, updating the applicant's status and related application records.
  • CONVERT_TO_APPLICANT — Transitions an existing person record (for example, an ex-employee or external person) into an applicant.
  • APPLY_FOR_JOB_ANYTIME — Enables a candidate to apply for a vacancy outside the standard recruitment window.

Parameter lists are deliberately not reproduced here; callers should obtain the exact signatures from the packaged procedure headers in the EBS instance. All entry points delegate shared validation and DML to the HR_API layer and to country-specific localization packages such as HR_GB_APPLICANT_API, HR_US_APPLICANT_API, and the other regional variants listed in the dependency tree.

Tables Accessed

The package reads and writes the core HR and recruitment tables through APPS synonyms, including:

Usage Notes

HR_APPLICANT_API is invoked by the iRecruitment and HR forms, by seeded concurrent programs such as HRDPP_CREATE_APPLICANT, HRDPP_CREATE_US_APPLICANT, and HRDPP_CREATE_GB_APPLICANT, and by workflows and business events including PER_QH_ACTION, PER_QH_MAINTAIN_UPDATE, and PQP_HROSS_INTEGRATION. The ETRM metadata records that the package is referenced by 34 other packages, spanning country localizations (AE, AU, CA, CN, DK, ES, FI, FR, HK, HU, JP, KW, MX, NO, NZ, PL, RU, SA, SE, SG), the generic GHR_APPLICANT_API and HR_ASSIGNMENT_SWI, HR_PERSON_API, IRC_PARTY_API, PER_OTHERBG_APL_API, and PQP* integration packages.

Customizations must call this API rather than inserting directly into PER_APPLICATIONS or PER_ALL_PEOPLE_F, because the API enforces HR validation, effective dating, person type rules, and country-specific legislative checks. Because the package sits beneath many dependent objects, changes to its behavior can cascade across recruitment, person management, and payroll integration flows. Always confirm the current signature in the target EBS release (12.1.1 or 12.2.2) before coding against it.