Search Results igs_gr_val_crdp




Overview
Explore in AI Chat

Overview

IGS_GR_VAL_CRDP is a PL/SQL package body in the APPS schema belonging to the Oracle E-Business Suite Student Systems / Student Records (IGS) product family. The IGS_GR prefix identifies it as part of the Graduation and Progression module, specifically the Graduation Records component. The package participates in the validation and maintenance of graduation-related credit point data, functioning as a server-side validation layer that enforces business rules before graduation records are written or updated.

The package is classified under the OTHER API classification and is documented as VALID in the ETRM repository for release 12.1.1, with equivalent behavior in 12.2.2. It is a supporting validation utility rather than a public, externally-facing API, and it exposes a single documented entry point. It is referenced by one other database object, confirming that its role is subordinate to a higher-level graduation processing package.

Key Procedures and Functions

The documented interface consists of one procedure:

  • GRDP_VAL_CRDP_IUD — The Insert/Update/Delete validation routine for graduation credit point data. The name follows the IGS convention of combining the entity abbreviation (CRDP, for credit points), the operation indicator (IUD, meaning it handles Insert, Update, and Delete operations), and the VAL prefix denoting a validation routine. This procedure validates credit point records prior to database modification, raising errors or messages through the message stack when business rules are violated.

The metadata does not disclose parameter lists, and no additional public procedures or functions are documented. Any further callable elements are private to the package body.

Tables Accessed

The documented dependency list shows the package referencing the view IGS_CA_DA_INST_V. This instance-level calendar/assessment view supplies the institutional and calendar context required to validate credit point records against the correct teaching instance. The package does not reference any base tables directly; all data retrieval is mediated through this exposed view and through the referenced graduation objects listed below.

Supporting dependencies include IGS_GR_CRMN_ROUND, which handles credit point rounding rules applied during validation, and the exception and messaging utilities APP_EXCEPTION, FND_MESSAGE, and IGS_GE_MSG_STACK, which are used to raise and accumulate validation errors. Because the package body is not referenced by any database object, its table footprint is limited to the documented view dependency.

Usage Notes

IGS_GR_VAL_CRDP is invoked indirectly by the graduation processing package that calls it, and would normally execute within the context of a Forms-based graduation maintenance window or a concurrent program performing bulk graduation record maintenance. The IUD procedure fires during insert, update, and delete actions on credit point data, applying institutional validation rules and accumulating messages on the IGS_GR message stack.

  • Customizations should call the package only through its documented parent object rather than directly, since it is an internal validation routine.
  • Error handling is message-stack based; callers must inspect IGS_GE_MSG_STACK after invocation.
  • Rounding behavior is delegated to IGS_GR_CRMN_ROUND, so institutions changing rounding policy should review that package rather than modifying validation logic here.
  • The package is unchanged in dependency structure between 12.1.1 and 12.2.2; no editioning or online patching conflicts are indicated.