Search Results hrdpp_create_gb_applicant




Overview
Explore in AI Chat

Overview

HRDPP_CREATE_GB_APPLICANT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. Its naming convention follows the HRDPP prefix used for Oracle Human Resources data pump (batch upload) utilities, with the GB qualifier indicating a localization specific to the United Kingdom legislative environment. The package is designed to populate the HR Pump staging tables with applicant (recruitment candidate) records originating from external sources, converting inbound data into the intermediate structure that Oracle HRMS later processes into the live applicant and person tables. In the context of EBS 12.1.1 and 12.2.2, the package is classified under the ETRM as an "OTHER" API type rather than a public, supported business API, meaning it is intended for internal use by the data pump framework. Its status is VALID in both releases, and it relies on the SYS.STANDARD package only, indicating a self-contained unit with no dependency on other APPS packages.

Key Procedures and Functions

The ETRM documentation records seven callable units within the package. The abbreviated entries (DC, D, N, DD, ND, CALL) are terse identifiers whose names are truncated in the object metadata; they function as the internal driver and utility routines that build and validate the batch payload. INSERT_BATCH_LINES is the most descriptive documented procedure; it is the routine responsible for inserting rows into the HR Pump batch structure, effectively converting the source applicant data into the line-level records the pump expects. No parameter lists are documented for any of these units, so the exact signatures cannot be stated here. Collectively, these procedures represent the interface through which a United Kingdom applicant conversion or integration routine delivers candidate data to the HR Pump engine.

Tables Accessed

The package reads and writes the core HR Pump staging tables, referenced through APPS synonyms:

These tables constitute the standard staging area that the HR Pump concurrent process subsequently reads and loads into the HRMS base tables.

Usage Notes

Because the package is documented as referenced by zero other packages, it is an entry-point utility rather than a shared library. It is therefore invoked directly—typically from a concurrent program, an external data loader, or custom PL/SQL that stages UK applicant records. The recommended pattern is to have the calling program supply the source data, invoke the INSERT_BATCH_LINES procedure to populate the pump tables, and then submit the standard HR Pump process to validate and load the records. Exceptions encountered during loading are retrievable from HR_PUMP_BATCH_EXCEPTIONS. Given its classification as an unsupported "OTHER" API, customizations should treat HRDPP_CREATE_GB_APPLICANT cautiously and validate behavior after any 12.1.1-to-12.2.2 upgrade, since internal routines of this nature are not governed by Oracle's API compatibility guarantees.