Search Results igs_ps_val_uai




Overview
Explore in AI Chat

Overview

The APPS.IGS_PS_VAL_UAI package body is a validation package within the Oracle E-Business Suite Student System (formerly Oracle Student System / OSS), part of the higher-education application family that ships under the IGS schema prefix in Releases 12.1.1 and 12.2.2. Its name decomposes as IGS (the Student System product family), PS (the programme/unit-of-study subsystem), VAL (validation), and UAI (unit assessment item). The package therefore exists to enforce the business rules that govern the relationship between a student's enrolled unit attempt and the assessment items attached to it. In practical terms, it is a server-side rule engine that checks whether assessment item definitions and the reference data behind them are consistent before assessment records are created or modified.

The object is documented in ETRM as an OTHER classification API with three documented entry points. It holds a VALID status in the APPS schema, meaning it has been successfully compiled and is deployable in a standard EBS installation. It is not exposed as a public interface; rather, it supports the internal validation responsibilities of the Student System assessment and enrolment flows.

Key Procedures and Functions

  • CRSP_VAL_CRS_CI — Performs validation relating to course and course-instance context for a unit attempt. Its naming convention (CRS / CI) indicates that it checks the course and course-instance dimension before the assessment item is accepted against the attempt.
  • ASSP_VAL_UAI_OPT_REF — Validates the option reference associated with a unit assessment item. This concerns the unit offering option (UOO) to which the assessment item belongs, ensuring the referenced option is a legitimate and currently valid one.
  • ASSP_VAL_UAI_SAMEREF — Validates that assessment items share a common reference or are consistently referenced across the assessment structure, guarding against duplicate or conflicting item references on the same unit attempt.

Because parameter lists are not published in the ETRM excerpt, the exact signatures are not reproduced here. Each procedure operates as an internal validation unit and is normally invoked by calling code rather than directly by end users.

Tables Accessed

Dependency metadata records that IGS_PS_VAL_UAI references the following tables (through APPS synonyms):

  • IGS_AS_ASSESSMNT_TYP — assessment type reference data; used to confirm that the assessment item being validated is of a recognised, valid type.
  • IGS_AS_ASSESSMNT_ITM — the assessment item definition; the core entity being validated against the unit attempt.
  • IGS_CA_INST and IGS_CA_INST_ALL — calendar/teaching instance data, supplying the delivery context (instance and instance-all) in which the validation is performed.
  • IGS_CA_STAT — calendar instance status; used to confirm the instance is in an allowable status before validation proceeds.
  • IGS_PS_UNITASS_ITEM — the unit assessment item record; the principal target of the validation logic.
  • IGS_PS_UNIT_OFR_OPT — unit offering options; validated by ASSP_VAL_UAI_OPT_REF.

All reads are performed against the owning IGS base tables via APPS synonyms, and no DML against these tables is documented, confirming the package's read-only, validation-only role.

Usage Notes

The package is typically invoked indirectly. The ETRM metadata states that IGS_PS_VAL_UAI is referenced by three other database objects, which means forms, concurrent programs, or other Student System packages call it when a user creates or updates assessment items against a unit attempt. It is not referenced by external custom objects in the standard installation. Because it is an OTHER-classified package, it should not be treated as a supported public API; customisations should call the higher-level assessment APIs instead. In Release 12.1.1 and 12.2.2 the dependency chain remains identical, as the Student System assessment model was not restructured between these releases.