Search Results hr_cgd_ins




Overview
Explore in AI Chat

Overview

APPS.HR_CGD_INS is a valid PL/SQL package in the Oracle E-Business Suite database, owned by the APPS schema. It belongs to the Oracle Human Resources (HR) product family, and its name follows Oracle's convention for components that manage Career Grade Definitions (CGD) — the "INS" suffix indicating an insertion-oriented package. In Oracle HRMS, career grades define the graded structure of jobs within an organization and are maintained through the PER_CAGR_GRADES_DEF table. This package provides the low-level insert logic used when new career grade definition records are created, ensuring that the underlying table receives properly validated data.

The package is classified as OTHER in the ETRM API classification scheme rather than as a public or private API, which means it is an internal implementation component rather than a supported integration interface. It functions within a small cluster of cooperating packages that together handle the create, update, and query operations for career grade definitions. Its status of VALID indicates that it compiles cleanly and is present in the database at the documented release levels of EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented metadata lists a single program unit within the package:

  • INS_OR_SEL — As the name indicates, this procedure performs an insert-or-select operation on career grade definition data. Its purpose is to determine whether a given career grade definition already exists and, if not, to insert it; where the record is already present, the existing row is used instead of creating a duplicate. This "insert if absent, otherwise use existing" pattern is common in HRMS reference data handling, where idempotent creation of grade definitions is required by callers that cannot assume the record exists.

No parameter lists are documented, and none should be assumed. The procedure's contract is internal to the HRMS schema and is not published as a supported API.

Tables Accessed

The documented table referenced through APPS synonyms is:

  • PER_CAGR_GRADES_DEF — This is the core table storing career grade definitions in Oracle HRMS. HR_CGD_INS reads from and writes to it, checking for the existence of a grade definition before inserting a new row. The table is the primary store for grade identifiers, validity dates, and related grade attributes used throughout HRMS grade structures, compensation, and grade-rate processing.

No other application tables are documented as accessed directly by this package.

Usage Notes

HR_CGD_INS is an internal dependency rather than a public interface. The ETRM dependency data shows that it references only the SYS.STANDARD package and that it is referenced by other APPS packages, specifically HR_ASSIGNMENT_API, HR_CGD_INS itself, and HR_CGD_UPD. This pattern confirms that the package is invoked indirectly — through HR_CGD_UPD when grades are created or synchronized as part of a broader update flow, and through HR_ASSIGNMENT_API when assignment processing causes grade definitions to be created on demand.

Because it is not a documented public API, direct invocation from forms, concurrent programs, or custom code is not recommended. Customers performing data loading of career grade definitions should use supported open interfaces or the HRMS public APIs rather than calling INS_OR_SEL directly, since the procedure performs no validation of business rules beyond duplicate avoidance and relies on callers to supply correct data. Any extension or modification should be treated as a customization requiring regression testing against HR_ASSIGNMENT_API and HR_CGD_UPD, as changes to this package's behavior could affect assignment and grade maintenance flows.