Search Results update_es_person

Overview

PER_ES_UPDATE_PERSON is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and concerns functionality specific to Spain (the "ES" identifier denotes the Spanish localization). Its primary business purpose is to support the maintenance and synchronization of person records in the Oracle Human Resources (HR) module, applying country-specific logic that governs when and how employee person data is updated. The package is classified as an "OTHER" API rather than a public, officially supported interface, meaning it is intended primarily for internal consumption by Oracle EBS forms and other product code rather than as a documented integration point for external callers. In version 12.1.1 and 12.2.2 the package is reported with a status of VALID, indicating that it compiles cleanly against the standard HR object definitions.

Key Procedures and Functions

The ETRM metadata documents a single program unit within this package:

• UPDATE_ES_PERSON — The sole documented procedure. Its purpose is to perform the update of the Spanish person record, encapsulating the localization-specific processing required whenever a person's data is modified through the HR person maintenance flow. Because the metadata does not publish a parameter list, callers should not assume a particular signature; the procedure is invoked internally by the HR person business logic rather than through a formally documented API contract.

No additional public functions or procedures are enumerated in the metadata, and the package body is not exposed for external reference. The single-unit footprint suggests a narrow, purpose-built utility rather than a broad functional library.

Tables Accessed

The package references the following tables through APPS synonyms:

• PER_ALL_PEOPLE_F — The core, date-effective HR table storing person records. The update procedure reads and modifies person data here, consistent with its name and purpose.
• PER_PERSON_TYPES and PER_PERSON_TYPE_USAGES_F — These define and assign person types (for example, Employee, Applicant, or a Spanish-specific classification). The package consults them to determine the correct person type context before applying an update.
• FND_SESSIONS — The standard Oracle Application Object Library table tracking active user sessions, typically used to obtain the current session, user, or login context when recording or validating the change.
• DUAL — The conventional single-row utility table, generally used for computation, date derivation, or simple validation checks.

The combination of person, person-type, and session tables indicates that the procedure validates the person's type and executing session before committing changes to the person record.

Usage Notes

PER_ES_UPDATE_PERSON is referenced by the HR_PERSON_BK1 package, a standard component of the Oracle HR person maintenance infrastructure. This dependency confirms that the package is invoked automatically as part of the HR person update flow rather than being called directly by end users. Typical invocation therefore occurs when a user edits a person record in the Spanish localization of the People form or a related HR form, at which point HR_PERSON_BK1 delegates the country-specific update to UPDATE_ES_PERSON.

Because the API is classified as "OTHER" and exposes no documented public signature, customizations and third-party integrations should avoid calling it directly. Instead, developers should route person updates through the supported public HR APIs (such as those in HR_PERSON_API) so that the Spanish localization logic executes as intended. Direct invocation risks bypassing validation and date-effective handling maintained by the standard HR business logic.