Search Results ghr_applicant_api




Overview
Explore in AI Chat

Overview

The APPS.GHR_APPLICANT_API package is a public PL/SQL API within the Oracle E-Business Suite Human Resources (HR) module. Its principal business function is to provide a controlled, programmatic interface for creating and registering applicants in the Oracle HRMS applicant tracking schema. Rather than permitting direct inserts into the underlying applicant tables, Oracle exposes this API so that external processes, customizations, and integrated applications can register applicants while honoring the validation, defaulting, and referential integrity rules enforced by the HRMS data model.

The package is classified as an API in the ETRM metadata and carries a status of VALID in both Oracle EBS 12.1.1 and 12.2.2. It is owned by the APPS schema and is therefore callable from custom code executed under APPS privileges or granted execute rights. The package body relies on the SYS.STANDARD package and is referenced by the GHR_MTI_INT integration package, indicating its participation in the broader HRMS integration layer where applicant data is exchanged with external or downstream recruiting systems.

Key Procedures and Functions

The documented interface exposes a single public program unit:

  • CREATE_APPLICANT — The primary entry point for registering a new applicant record. This procedure accepts the caller-supplied applicant attributes and performs the required validations, defaulting, and inserts needed to establish the applicant within the HRMS applicant model. It is the supported mechanism for programmatic applicant creation and should be used in preference to direct table manipulation. The ETRM documentation does not publish the parameter list; developers should inspect the package specification in the target instance to confirm the exact arguments and their data types before invoking the procedure.

No other procedures or functions are enumerated in the documented metadata for this package.

Tables Accessed

The package operates on the following documented base table, reached through APPS synonyms:

  • PER_APPLICATIONS — The core applicant/application record table in the HRMS schema. CREATE_APPLICANT writes the new applicant row into this table, which stores the essential identity and application details for a candidate. Because the API mediates the insert, any business defaults, mandatory columns, and validation checks associated with PER_APPLICATIONS are applied consistently.

Additional supporting tables may be touched indirectly through the HRMS data model, but only PER_APPLICATIONS is documented in the ETRM entry.

Usage Notes

GHR_APPLICANT_API is typically invoked by integration components rather than by end users directly. The most significant documented consumer is GHR_MTI_INT, the HRMS mass transaction and integration package, which calls CREATE_APPLICANT when applicant data is loaded from external sources. Custom concurrent programs, interface tables, and third-party recruiting or onboarding integrations should likewise route applicant creation through this API to preserve data integrity.

In Oracle EBS 12.1.1 and 12.2.2, the package resides in the APPS schema and is subject to the standard online patching and editioning considerations of the 12.2 AD/TXK model; custom callers should be edition-aware and avoid caching references across edition boundaries. Because the published documentation omits the parameter specification, implementers should always confirm the signature against the installed package and test against a non-production instance before deployment.