Search Results hrdpp_create_applicant




Overview
Explore in AI Chat

Overview

APPS.HRDPP_CREATE_APPLICANT is a PL/SQL package in the Oracle E-Business Suite APPS schema that supports the Oracle iRecruitment and HRMS data pump infrastructure. Its primary business function is to create applicant records by staging and processing data through the HR pump batch tables. The package operates as part of the "HRDPP" (HR Data Pump Processing) family of packages, which are used by Oracle iRecruitment to import external applicant and assignment data into the core HR schema. In ETRM 12.2.2, the package is classified as an OTHER API, indicating that it is not a public, business-facing API intended for direct customer invocation, but rather an internal component that supports higher-level processing flows. The package is documented as VALID, and it holds a dependency on the SYS.STANDARD package, which is the standard base package available to all PL/SQL programs.

Key Procedures and Functions

The ETRM metadata records seven documented program units within the package: DC, D, N, DD, ND, INSERT_BATCH_LINES, and CALL.

  • DC — A documented procedure/function that forms part of the internal data pump processing logic.
  • D — A documented procedure/function within the package.
  • N — A documented procedure/function within the package.
  • DD — A documented procedure/function within the package.
  • ND — A documented procedure/function within the package.
  • INSERT_BATCH_LINES — A procedure responsible for inserting records into the HR pump batch line tables, forming the core of the staging mechanism used to prepare applicant data for subsequent processing.
  • CALL — The entry-point procedure typically used to invoke the package's processing logic.

The abbreviated names (D, N, DC, DD, ND) reflect internal helper routines rather than public API methods. Parameter lists are not documented and must not be assumed.

Tables Accessed

The package references the following tables through APPS synonyms:

These tables collectively form the data pump staging area where incoming applicant information is written before being validated and transferred into core HR and iRecruitment entities.

Usage Notes

HRDPP_CREATE_APPLICANT is referenced by one other package, HRDPP_CREATE_APPLICANT itself (self-reference in the dependency listing), and by PQP_PERASGADD_RIW, which is a row-instead-of trigger handler associated with person assignment additions. This indicates the package is invoked as part of automated applicant and assignment creation flows rather than through a user-facing form. In practice, the package is called by Oracle iRecruitment processing logic and related data pump routines to stage and process applicant data. It is not intended for direct invocation by custom code, and because it is classified as an OTHER API with limited documentation, customers should avoid calling it directly. Its most common execution path is internal, triggered by higher-level concurrent programs and application logic that manage applicant imports.