Results for “ghr_par_upd”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GHR_PAR_UPD is an Oracle EBS Application Object Library package body owned by the APPS schema, part of the Oracle Human Resources (GHR) module. The naming convention identifies it as the update-side member of the GHR_PAR (Public API Request) package family: GHR_PAR_SHD supplies the shadow (date-tracked) row handling, GHR_PAR_BUS carries the business logic and validation rules, GHR_PAR_RKU performs the row-key-uniqueness check, and GHR_PAR_UPD performs the actual update processing. The package has no dependents ("not referenced by any database object"), confirming it sits at the bottom of the call stack — an internal worker invoked by its siblings rather than a standalone public entry point. It is documented as VALID in ETRM for both 12.1.1 and 12.2.2.

Key Procedures and Functions

• UPD — the sole documented procedure. It performs the physical update of the target row in the underlying table after all validation, datetrack, and row-key-uniqueness processing has been completed by the other members of the GHR_PAR family. Within Oracle HRMS datetrack design, the update routine applies the new column values to the currently effective row and relies on the shadow and business-layer packages for the redundant-column and effective-date logic that surrounds the operation.

The documented interface lists one procedure total, meaning no public functions are exposed. No parameter list is reproduced here, as the ETRM metadata does not document it; the arguments follow the internal GHR_PAR convention of primary key, column values, and an effective-date mode.

Tables Accessed

• GHR_PA_REQUESTS — the only table documented as referenced via APPS synonyms. GHR_PA_REQUESTS stores requests associated with the Public API Request functionality in Oracle Human Resources. GHR_PAR_UPD writes updated attribute values back to this table after the business and shadow layers have accepted the change.

Dependency information confirms additional compile-time references to APPS.GHR_PAR_BUS, APPS.GHR_PAR_RKU, APPS.GHR_PAR_SHD and APPS.GHR_PAR_UPD itself (recursive/overload reference), plus HR_API, HR_UTILITY, HR_PA_REQUESTS, and the SYS STANDARD package. HR_UTILITY provides HRMS generic utility routines, while HR_API supplies the standard Oracle HRMS API error and message handling framework.

Usage Notes

• Not intended for direct invocation. GHR_PAR_UPD is not referenced by any database object, so external custom code should call the documented public API (or the GHR_PAR_BUS layer) rather than this package.
• Invoked internally by the GHR_PAR family as the final write step following validation and datetrack processing.
• Referenced by 16 other packages in ETRM 12.2.2, which is consistent with a shared, cross-module update worker used wherever PAR request rows are amended.
• Customizations that require additional update behavior should be implemented through the supported HR_API hooks and error handling rather than by modifying or directly calling GHR_PAR_UPD, since the package is an Oracle-owned APPS object and is recompiled on patching.
• Because the package is VALID and documented identically for 12.1.1 and 12.2.2, behavior is expected to be consistent across both releases.