Search Results update_es_org_info

Overview

PER_ES_ORG_INFO is an Oracle EBS Application Object Library (APPS) schema PL/SQL package whose name indicates a Spanish (ES) localization or country-specific extension for organization information (ORG_INFO). Within the Oracle E-Business Suite 12.1.1 and 12.2.2 releases, packages bearing this naming pattern are used to satisfy statutory or country-specific requirements that are not covered by the standard, global HR organization model. In this context, PER_ES_ORG_INFO provides the programmatic interface through which Spanish-specific organization attributes are created and maintained in the Human Resources (PER) schema. The package is a VALID, compiled object in the APPS schema and is classified as a generic ("OTHER") API rather than a public HRMS business API. It therefore serves an internal, localization-driven role: it encapsulates the insert and update logic required to persist Spanish organization information records while preserving referential integrity with the core HR organization tables.

Key Procedures and Functions

The ETRM metadata documents two callable units in this package:

• CREATE_ES_ORG_INFO — Creates a new Spanish-specific organization information record. It is the entry point used when a new organization or organization unit requires the additional country-specific attributes mandated for Spain.
• UPDATE_ES_ORG_INFO — Modifies an existing Spanish-specific organization information record, allowing the maintained attributes to be changed as the organization's statutory details evolve.

No parameter lists are documented in the ETRM repository, and the exact signatures should be obtained from the package source before any custom invocation. The naming convention implies a straightforward create/update pairing consistent with other localization packages of this class.

Tables Accessed

The package references three tables through APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS — The base HR organization definition table. It provides and validates the organization identifier against which the Spanish-specific information is keyed.
• HR_ORGANIZATION_INFORMATION — The generic, extensible repository for organization-level attributes. This is the table into which the Spanish-specific organization information is most likely written, using the organization information type reserved for the ES localization.
• DUAL — Used for standard SQL utility operations, such as sequence or sysdate retrieval and existence checks.

Usage Notes

PER_ES_ORG_INFO is not typically invoked directly by end users. Its principal documented consumer is the HR_ORGANIZATION_BK1 and HR_ORGANIZATION_BK2 packages, which are the "Before" (BK) row-level trigger packages on the HR_ORGANIZATION form. This means the package is called during the normal save processing of the Spanish organization setup form: when a user creates or updates an organization, the base-table triggers fire and invoke CREATE_ES_ORG_INFO or UPDATE_ES_ORG_INFO to synchronize the localization data. Custom code should avoid duplicating this logic, since calling the package independently risks inconsistent data if the base triggers are bypassed. Because the package writes to HR_ORGANIZATION_INFORMATION rather than directly to HR_ALL_ORGANIZATION_UNITS, it respects the extensible organization information architecture. In EBS 12.2.2 the object is deployed as part of the APPS edition, and any reference should use the APPS synonym rather than a direct schema reference. The complete dependency list should be reviewed before any modification, as the package is referenced by two other packages and any change can cascade through the organization save path.