Search Results es_form_labels

Overview

APPS.PER_ES_CREATE_APPLICANT is a Spanish (ES) legislative localization package body within the Oracle Human Resources (PER) product family. Its business purpose is to create an applicant (a person record used in recruitment) while correctly processing the identifier attributes required by Spanish statutory regulations. The package is delivered as a "noship" object, meaning it is a non-shipped, localization-specific component rather than part of the base global product code, and it is registered in ETRM under the API classification "OTHER." The single documented procedure, CREATE_ES_APPLICANT, is the localization wrapper that performs product-install checks, validates caller-supplied arguments, and applies Spanish identifier-type logic before the underlying applicant is created. The package header comment block (lines 3–5) maps the legacy parameters to canonical person attributes: p_first_last_name / p_last_name, p_identifier_type / p_per_information2, and p_identifier_value / p_per_information3.

Key Procedures and Functions

• CREATE_ES_APPLICANT — The sole documented procedure. It accepts a last name, first name, national identifier, and three generic PER information attributes (p_per_information1 through p_per_information3, where the second and third carry the Spanish identifier type and identifier value respectively). It first guards execution with hr_utility.chk_product_install('Oracle Human Resources', 'ES') so the procedure only runs when the Spanish HR product is installed and licensed. It then enforces mandatory arguments through hr_api.mandatory_arg_error, and validates the identifier pairing: supplying an identifier value without a type, or a type without a value, raises the HR_ES_INVALID_VALUE error with a decoded field label token. The nested cursor get_lookup_type queries HR_LOOKUPS for lookup_type='ES_IDENTIFIER_TYPE' to confirm the supplied identifier type is valid before proceeding; if the lookup fails, the same error is raised. Error text is localized via hr_general.decode_lookup against the ES_FORM_LABELS lookup type.

Tables Accessed

• PER_ALL_PEOPLE_F — Referenced as the target table for the applicant/person record. The package operates on person data types such as national_identifier (declared as per_all_people_f.national_identifier%TYPE), indicating it interacts with the base person entity where the applicant is ultimately persisted.
• HR_LOOKUPS — Read-only access. The cursor validates that the supplied identifier type exists as a valid lookup_code under lookup_type='ES_IDENTIFIER_TYPE', providing the Spanish identifier-type validation that distinguishes this localization package.

Usage Notes

PER_ES_CREATE_APPLICANT is intended to be invoked from Spanish localization flows that capture applicant or employee registration data, most likely the Spanish person/application entry form or a localization concurrent process. It is referenced by one other package in the ETRM dependency graph, indicating it is called programmatically by higher-level localization code rather than executed directly by end users. Customizations should call it only when the 'Oracle Human Resources', 'ES' product is installed, because the leading product-install check short-circuits execution otherwise. Callers must supply a last name (mandatory), and must pass the Spanish identifier type and value consistently: p_per_information2 must be a valid ES_IDENTIFIER_TYPE lookup code, and p_per_information3 must accompany it. Violations raise HR_ES_INVALID_VALUE with a localized field token. As a "noship" localization object, it is supported only within Oracle EBS 12.1.1 and 12.2.2 environments where the Spanish HR localization has been applied, and it should not be modified or relied upon for functionality outside that legislative scope.