Search Results per_es_create_employee




Overview
Explore in AI Chat

Overview

The APPS.PER_ES_CREATE_EMPLOYEE package body is a Spanish localization (ES) utility within the Oracle E-Business Suite Human Resources (PER) product family. It supports the country-specific employee creation process required for Spain, providing the application programming interface through which an employee record can be programmatically established with the attributes, validations, and derived values expected by Spanish statutory and business rules. The package is classified in the ETRM as an API of type OTHER, indicating that it is not one of the publicly certified HRMS APIs but rather a localization helper that layers Spanish-specific logic on top of the standard Oracle HR infrastructure.

Key Procedures and Functions

The ETRM documentation records a single documented entry point for this package body:

  • CREATE_ES_EMPLOYEE — The primary routine that creates an employee record within the Spanish localization context. Its purpose is to encapsulate the sequence of validation, defaulting, and insertion activities required to produce a valid employee row. Because the metadata does not expose a parameter list, the exact signature is intentionally not restated here; consultants should inspect the package source or a validated call from existing Spanish localization code before invoking it directly. The routine is expected to coordinate with the standard HR infrastructure rather than performing unrestricted DML.

As the object is a package body with a corresponding specification, only the procedures declared in the specification are externally callable; internal helper routines within the body are not documented and should not be referenced by custom code.

h4>Dependencies and Tables Accessed

The package relies on the standard HR building blocks. Documented dependencies include HR_API and HR_ES_UTILITY (Spanish localization utility routines), HR_GENERAL and HR_UTILITY (generic HR helper routines), HR_LOOKUPS (validation of lookup values), FND_PROFILE (retrieval of profile option values that govern business group and legislative behavior), and the STANDARD package supplied by SYS for standard PL/SQL constructs.

The principal table touched through APPS synonyms is PER_ALL_PEOPLE_F, the date-tracked people table that stores the core person and employee attributes. The package reads and writes this table to persist the newly created employee. Effective-dating is handled in accordance with the standard HR model, and the localization logic ensures Spain-specific fields are populated consistently with the employee's effective start date.

Usage Notes

This package is a Spanish localization component and is invoked in environments where the Spanish legislative or business group context applies. Typical invocations originate from the Spanish employee entry forms and from concurrent or batch processes that create employees in bulk. Because it is an OTHER-classified API, Oracle does not guarantee the same backward-compatibility commitment as for certified HRMS APIs; callers should treat the signature and behavior as subject to change between releases and should always validate against a test instance before promotion.

The package is not referenced by any other database object according to the ETRM, so it sits at the top of its dependency chain and is intended to be called directly. When extending or troubleshooting employee creation for Spain, consultants should first determine whether the requirement can be met through the standard HR_EMPLOYEE_API before introducing a direct call to CREATE_ES_EMPLOYEE. Both Oracle EBS 12.1.1 and 12.2.2 share the same package structure, though the online patching model in 12.2.2 means changes to the APPS edition must follow the editioning and ADOP rules during deployment.