Search Results assp_val_sua_ai_acot

Overview

IGS_AS_VAL_UAI is an Oracle E-Business Suite validation package owned by the APPS schema and classified under the Student System (IGS) assessment product family. Its name derives from its role as a validator ("VAL") over the Unit Assessment Item ("UAI") entity within the Oracle Student System academic records model, where units of study are linked to assessment items that carry grades and marks.

The package encapsulates reusable validation logic that enforces referential integrity, calendar and cutoff-date rules, and uniqueness constraints whenever unit-assessment relationships are created or modified. It centralises rules that would otherwise be duplicated across forms, concurrent programs and other PL/SQL APIs. The header identifies it as source file IGSAS34S.pls and records change history dating from 2001, including Bug 2162831 and Bug 1956374, which added and rationalised validation routines as the Student System matured.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions, listed by the ETRM metadata. Referential validators confirm that the assessment items and units referenced by a transaction actually exist and are open. ASSP_VAL_AI_EXISTS checks assessment item existence; CRSP_VAL_UM_CLOSED and CRSP_VAL_UCL_CLOSED check the unit mode and unit class closed indicators respectively; CRSP_VAL_CRS_CI and CRSP_VAL_UO_CAL_TYPE validate course and unit-offering calendar context.

The ASSP_VAL_UAI_* family handles relationships between a unit assessment instance and its assessment items. ASSP_VAL_UAI_LINKS rejects invalid combinations; ASSP_VAL_UAI_UNIQREF and ASSP_VAL_UAI_OPT_REF enforce uniqueness and optionality of references; ASSP_VAL_UAI_CAL checks calendar consistency; ASSP_VAL_UAI_SAMEREF verifies that linked records share the same reference; and ASSP_VAL_UAI_UAPI validates against the unit assessment pattern item. Related checks include ASSP_VAL_SUA_UAI and ASSP_VAL_SUA_AI_ACOT, which validate student unit attempt assessment links, and ASSP_VAL_UNIT_SEC_UNIQREF and ASSP_VAL_CUTOFF_DT, which enforce uniqueness and date-cutoff rules. Each routine conventionally returns a BOOLEAN and an OUT message name for error reporting.

Tables Accessed

The package reads and validates against the following tables, accessed through APPS synonyms: IGS_AS_ASSESSMNT_ITM_ALL, the master assessment item table; IGS_AS_UNITASS_ITEM_ALL and IGS_PS_UNITASS_ITEM, which hold unit-to-assessment-item associations; IGS_AS_UNIT_CLASS_ALL and IGS_AS_UNIT_MODE, the unit class and mode definitions whose closed indicators are checked; IGS_AS_ASSESSMNT_TYP, defining assessment types; and the calendar tables IGS_AS_CAL_CONF, IGS_CA_STAT and IGS_CA_TYPE, which supply calendar type, status and configuration context for the date validations.

Usage Notes

IGS_AS_VAL_UAI is an internal validation utility rather than a public API, so it is invoked indirectly. It is referenced by thirty other packages, indicating heavy reuse across the Student System, and is called from Oracle Forms in the assessment and unit enrolment flows when users create or amend unit assessment items. Concurrent programs and custom extensions that insert into the unit assessment tables should call the relevant validation routines before committing, passing the message name parameter and raising the corresponding error when a function returns FALSE. Because PRAGMA RESTRICT_REFERENCES(WNDS) is declared on several functions, they are pure read-only validators and may be safely called from SQL contexts. The package is present in both EBS 12.1.1 and 12.2.2, where it remains part of the IGS assessment validation layer.