Search Results igs_as_val_gsg




Overview
Explore in AI Chat

Overview

IGS_AS_VAL_GSG is a validation package body in the APPS schema belonging to the Oracle E-Business Suite Student Systems (IGS) product family, specifically the Academic Assessment (AS) module. Its name follows the IGS naming convention in which the AS segment denotes Academic Assessment and GSG refers to grade scale grading, reflecting its role as the validation engine for grade scale and grade scale grade setup. In the Oracle EBS 12.1.1 and 12.2.2 environments, the package encapsulates the business rules that govern how grading schemes, grade scales, and the individual grades within them are defined and maintained. Rather than embedding validation logic directly in the associated maintenance form, the application delegates checks to this centralized package, ensuring that grading configuration data remains consistent across every entry point that touches the IGS_AS grade scale tables.

Key Procedures and Functions

The ETRM repository documents eight procedures and functions within the package body:

  • ASSP_VAL_GS_CUR_FUT — validates the currency and future-dating aspects of a grade scale record, ensuring that effective dates do not conflict with existing definitions.
  • GENP_VAL_DT_RANGE — a general-purpose date range validator used to confirm that a start date precedes an end date and that the range is logically sound before the record is committed.
  • ASSP_VAL_GSG_MRK_RNG — validates the mark range associated with a grade scale grade, confirming that the numeric boundaries assigned to a grade are coherent.
  • ASSP_VAL_GSG_MIN_MAX — checks the minimum and maximum mark values defined for a grade scale grade, enforcing that minimum does not exceed maximum.
  • ASSP_VAL_GSG_M_OVRLP — detects and rejects overlapping mark ranges between grades within the same grade scale, a critical integrity rule for grading schemes.
  • ASSP_VAL_GSG_DFLT — validates default grade assignments, ensuring that the designation of a default grade is permissible for the grade scale.
  • ASSP_VAL_GSG_GSGT — validates grade scale grade type information, verifying that the grade type attributed to a grade is valid for its parent grade scale.
  • ASSP_VAL_GSG_SSGT — validates grade scale sub-type or secondary grade type data associated with the grade scale structure.

Tables Accessed

The package operates against the base tables IGS_AS_GRD_SCHEMA and IGS_AS_GRD_SCH_GRADE, referenced through APPS synonyms. IGS_AS_GRD_SCHEMA holds the grade scheme definitions that underpin assessment grading at the institution level. IGS_AS_GRD_SCH_GRADE stores the individual grades belonging to each scheme, including their mark ranges, grade types, and default indicators. The validation routines query these tables to compare incoming or edited records against existing data, which is how overlap, minimum and maximum, and default-grade rules are enforced. The dependency listing also shows references to IGS_AS_GRD_SCH_TRN, the grade scheme translation table, which supports validation of language-specific grade scheme descriptions.

Usage Notes

IGS_AS_VAL_GSG is typically invoked indirectly from the Academic Assessment grade scheme and grade scale maintenance forms, or from concurrent processes and PL/SQL APIs that create or update grade scale records. Dependency metadata indicates the package is referenced by five other database objects, confirming that it functions as a shared validation library rather than a standalone entry point. It relies on FND_MESSAGE, APP_EXCEPTION, and IGS_GE_MSG_STACK for error message construction and exception handling, and on STANDARD for core PL/SQL constructs. Because the package is not referenced by forms or reports in a way that exposes it directly to users, customizations should call the documented procedures only through the supported maintenance flows to preserve grading data integrity.