Search Results igs_gr_val_gac




Overview
Explore in AI Chat

Overview

IGS_GR_VAL_GAC is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family with an API classification of OTHER. The suffix "GAC" denotes Graduation Award Calculation, and the package forms part of the graduation-processing framework that governs how students are validated against, and credited toward, the requirements of an award. Its principal role is to evaluate graduation award criteria and to persist the results of that evaluation into the graduation award tables. The package operates against the campus, course, and calendar structures maintained by the institution and interacts with the standard exception and message frameworks (APP_EXCEPTION, FND_MESSAGE, IGS_GE_MSG_STACK) to raise and stack user-facing errors during validation.

The object carries a VALID status in the documented environment and is a dependent component rather than a calling entry point; it is not referenced by any other database object, which indicates that it is invoked internally by graduation-processing logic rather than exposed as a standalone public API.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions within this package body. Their names indicate the following responsibilities:

  • GRDP_VAL_GAC_INSERT — Inserts new graduation award calculation records, establishing the validation outcome for a student's award within the graduation process.
  • GRDP_VAL_GAC_IU — Performs the combined insert-or-update operation on graduation award calculation data, handling both new and existing rows.
  • GRDP_VAL_GAC_RQRD — Evaluates whether required award criteria have been satisfied, forming a core validation step in the graduation check.
  • GRDP_VAL_GAC_SEAT — Handles the seating or placement aspect of award validation, relating to progression or standing within a course.
  • GRDP_VAL_GAC_SUSA — Addresses suspended or interrupted study status, validating award eligibility where a student's attempt record shows suspension.
  • GRDP_VAL_GAC_GRD_CI — Validates graduation criteria against the graduand record, reconciling academic outcome data.
  • GRDP_VAL_GAC_ORDER — Manages the ordering or sequencing of award calculation records, ensuring deterministic processing order.
  • GRDP_VAL_MSR_CLOSED — Validates measurement closure, confirming that the measures underpinning an award have been finalised before graduation proceeds.

No parameter lists are documented; the procedures are described here by purpose only.

Tables Accessed

Via APPS synonyms, the package reads and writes the following documented tables:

Usage Notes

IGS_GR_VAL_GAC is invoked indirectly by the graduation validation flow rather than directly from a form or concurrent program. It is referenced by two other packages, which act as callers within the graduation-processing chain. Typical invocation occurs when a graduation award calculation is executed for a graduand, at which point the validation procedures assess criteria, measurement closure, and status before inserting or updating award calculation rows. Customisations should not call the package directly; instead, developers should route through the documented graduation APIs so that message stack handling and exception behaviour remain consistent.