Search Results igs_gr_val_gc




Overview
Explore in AI Chat

Overview

IGS_GR_VAL_GC is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM registry as an "OTHER" API object. Its prefix (IGS_GR) identifies it as part of the Oracle Student System (also marketed as Oracle Student Information System / iRecruitment for Higher Education), specifically the Graduation (GR) module. The package provides validation logic used at the point of graduation, award conferral, and ceremony processing — verifying that a student's academic record satisfies the criteria required before an award can be granted or a ceremony attendance can be confirmed.

The metadata records that the package is VALID in the 12.1.1 and 12.2.2 environments, that it references only SYS.STANDARD (standard PL/SQL constructs), and that it is referenced by six other packages. The package exposes seven documented procedures/functions, and its documented table access is limited to two Graduation-module tables. This relatively narrow dependency footprint indicates a targeted validation utility rather than a broadly shared business service.

Key Procedures and Functions

The ETRM documents seven callable program units within IGS_GR_VAL_GC. The naming convention (GRDP_ prefix = Graduation Degree Program; ASSP_ prefix = Assessment/Administrative Support Program) signals the validation domain of each procedure. Parameter lists are intentionally not published in the metadata; only purposes are summarized below.

  • GRDP_VAL_GC_DAI — A validation routine associated with Date of Award / Award Instance processing, checking whether the data supplied for a graduation record is internally consistent before the award date is accepted.
  • GRDP_VAL_GC_UPD — Validates a graduation record in the context of an update operation, ensuring that changes to an existing award do not violate the validation rules enforced when the record was created.
  • GRDP_VAL_GC_CRD — Validates credit attainment or credit-related graduation criteria, confirming that the credit position recorded for the learner supports the award being processed.
  • GRDP_VAL_GC_TIMES — Validates time-based or date-sensitive criteria, such as the effective period or the timing of the graduation event relative to the academic calendar.
  • GRDP_VAL_GC_IUD — The umbrella Insert/Update/Delete validator, invoked by the Graduation module to enforce the complete rule set whenever a graduation record is inserted, modified or removed.
  • GRDP_VAL_VE_LOT — A validation entry point for the "VE" (validation event or classification) context relating to a lot or batch, typically used during bulk award or bulk graduation processing.
  • ASSP_VAL_VE_CLOSED — Checks whether the relevant validation event or processing period is closed, preventing graduation actions against a period that has already been sealed.

Tables Accessed

The documented table references resolve through APPS synonyms to two Graduation-module tables:

  • IGS_GR_AWD_CRMN — the Graduation Award Ceremony table, which associates an academic award with a specific ceremony event. This is the primary record against which ceremony- and award-related validation is performed.
  • IGS_GR_CRM_ROUND_PRD — the Ceremony Round Period table, which defines the rounds and periods in which ceremonies are scheduled. Validation here ensures that a ceremony date or award falls within an active, open round period.

Because the package is a validator rather than an inserter, its access to these tables is predominantly read-only (existence, status and period checks); write behaviour, if any, is not disclosed by the metadata and should be confirmed through the package body at the customer site.

Usage Notes

IGS_GR_VAL_GC is not normally invoked directly by end users. It is a supporting validation library called by other Application Programming Interfaces in the Graduation and Assessment modules. The metadata lists six dependent packages, including IGS_AS_EXAM_INSTANCE_PKG, IGS_AS_EXMVNU_SESAVL_PKG, IGS_GR_AWD_CEREMONY_PKG, IGS_GR_AWD_CRM_US_GP_PKG, IGS_GR_AWD_CRM_UT_ST_PKG and IGS_GR_CRMN_PKG, plus a self-reference.

Typical invocation paths are:

  • Oracle Forms in the Student System Graduation responsibility, where ceremony and award maintenance triggers validation on save.
  • Concurrent programs performing bulk award conferral or ceremony assignment, where GRDP_VAL_VE_LOT and ASSP_VAL_VE_CLOSED are especially relevant.
  • Custom extensions or data-conversion routines that must respect the same award and ceremony validation rules as the seeded application.

Because the package is a dependency of six other packages, changes to its logic should be treated as high-impact: a modification can cascade into examination instances, session availability, and all ceremony processing. Any custom variation should be introduced through a wrapper or a separate custom package rather than by altering the delivered body, and the standard Oracle patching path should be preserved.