Search Results igs_as_gen_002




Overview
Explore in AI Chat

Overview

IGS_AS_GEN_002 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as part of the Student Systems (IGS) product family — specifically the Assessment (IGS_AS) module. Its object type is PACKAGE, with a VALID status in both ETRM 12.1.1 and 12.2.2 environments, and the package exposes both a specification and a body. Functionally, IGS_AS_GEN_002 acts as a shared utility library for assessment processing: it supplies default values, validation lookups, and grade/scheduling resolution logic consumed by other assessment packages, views, and validation routines. The "GEN" naming convention indicates a generic reusable component rather than a transaction-driven API, meaning it is invoked internally by higher-level assessment and progression packages rather than directly by end users.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions within this package:

These routines are parameterised lookups; each encapsulates a business rule that would otherwise be duplicated across forms and validation engines.

Tables Accessed

The package reads and writes against the following documented tables (accessed through APPS synonyms):

Usage Notes

IGS_AS_GEN_002 is not invoked directly by end users; it is a dependency of ten other database objects, including packages IGS_AS_GEN_003, IGS_AS_GEN_006, IGS_AS_GEN_007, IGS_AS_UNITASS_ITEM_PKG, IGS_AS_VAL_GSGT, IGS_PS_GEN_008, IGS_PS_UNITASS_ITEM_PKG, IGS_PS_VALIDATE_GENERIC_PKG, IGS_RU_GEN_001, and the view IGS_AS_UAI_ETISTD_EXAM_V. These consumers invoke IGS_AS_GEN_002 from Student Systems forms and validation routines whenever assessment data is entered, defaulted, or validated. Custom extensions should call these procedures rather than reimplementing grade or examinability logic, ensuring consistent behaviour with seeded assessment processing and grade scheme evaluation.