Search Results hr_cgd_shd




Overview
Explore in AI Chat

Overview

HR_CGD_SHD is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, present and valid in both the 12.1.1 and 12.2.2 releases. Its naming convention follows the Oracle HRMS pattern in which the _SHD suffix denotes a "shadow" or private helper package that supports a primary package. In this case the package functions as the supporting implementation layer for the Compensation and Grading Definitions (CGD) functionality centered on the PER_CAGR_GRADES_DEF table, which stores grade definition records within the Oracle Human Resources (PER) product family. The package provides the internal conversion and maintenance logic invoked by its parent packages rather than exposing a public business API of its own, and ETRM classifies it under the generic API type OTHER. It depends only on the SYS STANDARD package at the compiled level, confirming that it is a thin, internally oriented utility rather than a large business processing module.

Key Procedures and Functions

ETRM documents two callable units within the package:

  • API_UPDATING — The internal routine that carries out the update processing for the grade definition data. Its presence indicates the package participates in the update half of the grade-definition lifecycle, most likely performing the record-level maintenance that the public grade definition APIs delegate to this shadow package.
  • CONVERT_ARGS — A conversion helper that prepares or transforms arguments before they are passed to the main processing routines. This is a common pattern in HRMS shadow packages, where a private conversion routine normalizes incoming parameter values into the format the parent package expects.

No public parameter signatures are documented, and none should be assumed. Both units are implementation-level entry points called from the associated primary packages rather than from customer code.

Tables Accessed

The single documented table reference is PER_CAGR_GRADES_DEF, reached through an APPS synonym. This table holds grade definitions used by HRMS compensation and grading setup, so the package reads and writes grade definition records as part of the update flow exposed through API_UPDATING. No other base tables are documented as accessed by this package.

Usage Notes

HR_CGD_SHD is an internal shadow package and is not intended for direct invocation. It is referenced by HR_CGD_SHD itself and by HR_CGD_UPD, both in the APPS schema, which indicates that the primary grade definition update package calls into this module during normal maintenance of grade records. In practice it is exercised indirectly when grade definitions are created or maintained through the Oracle HRMS forms for grade setup, through concurrent programs that process grade data, or through the public grade definition APIs; customers should call those public APIs rather than this shadow package. Customizations that attempt to call API_UPDATING or CONVERT_ARGS directly risk breaking on patching or upgrade, because Oracle may change the internal signatures of shadow packages without notice. Because the package is compiled VALID against only STANDARD, its dependency footprint is minimal, and ordinary patch application maintains it along with the rest of the HRMS grade definition code set.