Search Results per_es_create_applicant




Overview
Explore in AI Chat

Overview

The APPS.PER_ES_CREATE_APPLICANT package is a server-side PL/SQL component within the Oracle E-Business Suite Human Resources (PER) module. Its naming convention reflects the Oracle EBS localization and legislative-data convention: the PER prefix denotes the Human Resources product family, and the _ES infix denotes functionality specific to the Spanish (España) localization. The package is owned by the APPS schema and is documented as VALID in the ETRM metadata for release 12.2.2.

The package supports the creation of applicant records within the Oracle HRMS recruitment and applicant-tracking functionality as it applies to the Spanish localization. Applicant records in EBS are People records held in the applicant person type; creating such a record involves the coordinated population of the person, the person type, and the associated assignment/date-tracked rows. PER_ES_CREATE_APPLICANT encapsulates that creation logic so that callers do not need to manipulate the underlying person tables directly. The API classification is documented as OTHER, indicating that it is an internal or helper API rather than a fully documented public interface.

Key Procedures and Functions

The ETRM documentation records a single callable program unit within this package:

  • CREATE_ES_APPLICANT — The package's principal entry point, responsible for creating a Spanish-localized applicant record. It coordinates the derivation and insertion of the person-level data required to establish the applicant basis record.

The documented interface exposes no additional procedures or functions. ETRM does not record the parameter list for CREATE_ES_APPLICANT; callers should obtain the exact signature from the package specification in the database rather than assuming an argument list. The package body also contains internal, non-documented program units that support the public entry point.

Tables Accessed

The documented table reference for this package, resolved through APPS synonyms, is:

  • PER_ALL_PEOPLE_F — The core, date-tracked People table in Oracle HRMS. PER_ES_CREATE_APPLICANT writes to this table through its synonym in order to create the applicant's base person row, supplying the effective-dated person attributes (for example, name and person type) that identify the individual as an applicant within the Spanish localization.

The dependency listing further shows a reference to SYS.STANDARD, the built-in PL/SQL package, which is a normal dependency of virtually all PL/SQL units and carries no functional significance. No other application tables are recorded in the ETRM metadata for this object; the package specification and body are both listed as documented subobjects.

Usage Notes

PER_ES_CREATE_APPLICANT is not a user-facing entry point and is not typically invoked directly by end users. According to the ETRM dependency data, the package is referenced by a single other application object: the library HR_APPLICANT_BK1. This indicates that the form-level library used by the HRMS applicant entry forms calls into PER_ES_CREATE_APPLICANT when a user creates an applicant in the Spanish localization context.

Custom code should treat the package as an internal implementation detail. Because the package is classified as OTHER and its full parameter list is not published in the reference documentation, direct calls from custom concurrent programs or scripts are not recommended. Where the creation of applicant records is required programmatically, the supported public person and applicant APIs in the PER schema should be used instead. When maintenance or upgrade assessment is performed on Oracle EBS 12.1.1 or 12.2.2, PER_ES_CREATE_APPLICANT should be recognized as a localization-dependent object whose validity must be verified following patching of the Spanish HRMS legislative data.