Search Results assp_get_exam_view

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:

• ASSP_GET_ATYP_EXMNBL — Retrieves whether a given assessment type is examinable.
• ASSP_GET_DFLT_EXLOC — Returns the default exam location, typically derived from location relationship data.
• ASSP_GET_DFLT_FINLS — Returns the default finalisation status for an assessment.
• ASSP_GET_DFLT_GRADE — Resolves the default grade to be applied under given assessment conditions.
• ASSP_GET_EXAM_VIEW — Provides exam-related view data used by downstream assessment logic.
• ASSP_GET_GSG_CNCD — Retrieves the grade scheme grade concatenation/concordance value.
• ASSP_GET_GSG_RANK — Returns the rank associated with a grade scheme grade.
• ASSP_GET_GSG_RESULT — Derives the resulting grade scheme result from assessment marks.
• ASSP_GET_MARK_MNDTRY — Determines whether a mark is mandatory for a given assessment item.
• ASSP_GET_AI_S_TYPE — Returns the assessment item sub-type classification.

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):

• IGS_AS_ASSESSMNT_ITM_ALL — Assessment item definitions, used for mark-mandatory and sub-type checks.
• IGS_AS_UNITASS_ITEM_ALL — Unit assessment items, providing context for grade and result derivation.
• IGS_AS_UNIT_CLASS_ALL — Unit class scheduling data, relevant to examinable flag logic.
• IGS_EN_SU_ATTEMPT_ALL — Student unit attempt records, linking assessments to student enrolments.
• IGS_AD_LOCATION_REL — Location relationships, supplying default exam location values.
• IGS_AS_ASSESSMNT_TYP — Assessment type setup, consulted by ASSP_GET_ATYP_EXMNBL.
• IGS_AS_GRD_SCH_GRADE — Grade scheme grade definitions, used by the GSG rank, result, and concordance routines.
• IGS_AS_SU_STMPTOUT_ALL — Student stamp-out records, referenced during assessment resolution.

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.