Search Results hr_cgd_upd




Overview
Explore in AI Chat

Overview

HR_CGD_UPD is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, validated as VALID against both the 12.1.1 and 12.2.2 releases. The name follows Oracle's HR module naming conventions, where the CGD token denotes "Change Government Data" and the UPD suffix denotes the update layer of the package family. The package therefore belongs to the group of internal utilities that maintain the effective-dated government-reporting and legislative-data structures attached to employee assignments by the Oracle HRMS Legislative Data Model (LDM) — the framework that supports federal, provincial, and statutory reporting for Human Resources.

The package is classified as OTHER in the ETRM API catalogue, not as a public or business API. It is an internal worker package. Oracle's documentation lists APPS.HR_CGD_SHD as a dependency, which is the shadow (synchronised history) table for change-government-data records. HR_CGD_UPD provides the conversion and maintenance logic that writes to and synchronises those shadow structures, thereby exposing changes to the standard HR DateTrack shadow mechanism.

Key Procedures and Functions

Two documented program units are exposed by the package specification:

  • CONVERT_DEFS — Converts or loads government-data definitions into the current data model. It is the package's definition-conversion routine, used when the set of government data elements, or their mapping to the underlying descriptive flexfield/hierarchy, must be transformed or refreshed against the installed legislation.
  • UPD_OR_SEL — Update-or-select logic. As the name indicates, this routine attempts to update an existing government-data row and, if no qualifying row exists, selects (or creates) the applicable record instead. This pattern is standard in HRMS effective-dated code, where an upsert must respect DateTrack context.

No parameter lists are exposed in the ETRM metadata; parameters, overloads, and exception handling should be confirmed by inspecting the package specification directly in the database. The package body additionally contains private helpers that execute the SQL statements listed in the ETRM dependency section.

Tables Accessed

The ETRM dependency listing identifies the following objects referenced by HR_CGD_UPD:

  • HR_API — the HRMS API utility package, providing common validation, DateTrack, and error-handling services used by all HR APIs.
  • HR_CGD_SHD — the shadow table for change-government-data, holding historical versions of the parent rows. HR_CGD_UPD writes here as part of the standard shadow-table maintenance cycle.
  • SYS.STANDARD — the built-in PL/SQL package, used for standard runtime functions.

The ETRM metadata does not enumerate specific business tables via APPS synonyms; the operational tables underlying HR_CGD_SHD (the base change-government-data table and its associated LDM entities) are implied by the shadow-table relationship and should be verified from the package body source.

Usage Notes

HR_CGD_UPD is referenced by HR_ASSIGNMENT_API, the flagship public API for creating and maintaining employee assignments. This entry point is the primary reason the package executes in normal runtime: whenever an assignment is created, updated, or DateTrack-corrected and the operation touches government data, HR_ASSIGNMENT_API calls down into HR_CGD_UPD to persist and synchronise the corresponding rows. Because the package is self-referencing in the ETRM dependency list, its routines call one another internally rather than being invoked in isolation.

The package is not intended for direct invocation from forms, concurrent programs, or customer extension code. It should be treated as a private implementation detail of the HR assignment API layer. Custom development that needs to manipulate change-government-data should call the supported HRMS APIs (HR_ASSIGNMENT_API and the LDM public APIs) rather than HR_CGD_UPD, and any direct dependency on this package risks breakage during patching or upgrade from 12.1.1 to 12.2.2. Support diagnostics should confirm the package status remains VALID after any HRMS patch, since invalidation of HR_CGD_UPD will cascade an error into HR_ASSIGNMENT_API and block assignment maintenance for affected legislation.