Search Results igs_en_val_sua




Overview
Explore in AI Chat

Overview

IGS_EN_VAL_SUA is a PL/SQL validation package in the APPS schema of Oracle E-Business Suite, belonging to the Student Systems / Student Records (IGS) product family. The suffix "SUA" denotes "Student Unit Attempt," and the package serves as the central validation engine governing the creation, confirmation, update, and deletion of student unit attempt records stored in IGS_EN_SU_ATTEMPT_ALL. In the Oracle Student System data model, a student unit attempt represents a student's enrolment in a specific unit offering within a teaching period, and it is one of the most heavily validated entities in the enrolment subsystem.

The package enforces institutional enrolment rules at the database tier, ensuring that every insert or modification to a unit attempt satisfies academic, administrative, and structural constraints before it is committed. Its documented API classification is OTHER, indicating it is an internal validation utility rather than a public-facing extension API, though its procedures are invoked extensively throughout the IGS enrolment codebase.

Key Procedures and Functions

The package exposes 31 documented procedures, whose names reveal a clear division of responsibilities:

Tables Accessed

The package reads and writes IGS_EN_SU_ATTEMPT_ALL as its primary table. Supporting validation draws on a broad set of reference and transactional tables, including IGS_AD_ADM_UT_STA_GD and IGS_AV_STND_UNIT_ALL for admission and standing unit data, IGS_AS_GRD_SCHEMA and IGS_AS_GRD_SCH_GRADE for grade scheme definitions, IGS_AS_SC_ATMPT_ENR for assessed attempt enrolment records, IGS_AS_UNIT_MODE for unit mode of delivery, IGS_CA_INST_ALL, IGS_CA_INST_REL, IGS_CA_STAT, and IGS_CA_TYPE for calendar instance and status information, IGS_EN_INTM_TYPES and IGS_EN_METHOD_TYPE for intermediate and enrolment method types, and HZ_PARTIES for party (person) identity data. FND_NEW_MESSAGES is referenced for the standard Oracle message dictionary, allowing validation failures to be surfaced as translatable, user-facing errors.

Usage Notes

IGS_EN_VAL_SUA is referenced by 18 other packages, including IGS_EN_ADD_UNITS_API, IGS_EN_SU_ATTEMPT_PKG, IGS_EN_SUA_LGCY_PUB, IGS_EN_ELGBL_UNIT, IGS_EN_ELGB_OVR_UOO_PKG, IGS_EN_ENROLL_WLST, IGS_EN_TRANSFER_APIS, IGS_EN_VAL_BULKRULE, IGS_EN_VAL_SCA, and several IGS_EN_GEN_xxx and IGS_AV_GEN_001 generic processing packages. This breadth of dependency confirms that the package is invoked indirectly whenever a student's unit attempt is created, amended, discontinued, or transferred through the standard enrolment forms, self-service pages, bulk processing concurrent programs, and legacy import routines. Custom code that manipulates unit attempts should call the public enrolment APIs such as IGS_EN_ADD_UNITS_API and IGS_EN_SU_ATTEMPT_PKG rather than IGS_EN_VAL_SUA directly, ensuring validation is applied consistently and that message handling remains compatible with the delivered validation framework. Because the object is delivered as a VALID APPS package, it should be treated as read-only reference code; extensions should be implemented through supported APIs or documented personalisation points.