Search Results igs_as_val_els




Overview
Explore in AI Chat

Overview

IGS_AS_VAL_ELS is a PL/SQL validation package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Student Systems (IGS) product family, specifically the Assessment (IGS_AS) module, and serves as a centralized validation utility for assessment-related entities. The package encapsulates business rules that verify the state and eligibility of students and organizational locations before assessment transactions are committed. Its classification as an "OTHER" API indicates that it is not a public, externally supported interface but an internal validation component consumed by higher-level assessment packages.

The package is documented in ETRM 12.1.1 with a VALID status and persists in the same form through 12.1.1 and 12.2.2, where the APPS schema remains the owner and the object continues to be flagged VALID. Because it is a validation (VAL) package within the IGS_AS namespace, its responsibilities are confined to returning validation outcomes or raising application errors rather than performing DML on transactional assessment tables.

Key Procedures and Functions

Two program units are documented in the ETRM metadata:

  • ASSP_VAL_ACTV_STDNT — Validates that a student is active. The "ASSP" prefix identifies the Assessment Student Person context, and the name denotes a check on the active status of the student record. Higher-level packages invoke this routine before creating or processing assessment data to ensure that only active students are included in examination, marks, or progression handling.
  • ORGP_VAL_LOC_CLOSED — Validates that a location is not closed. The "ORGP" prefix denotes the Organization Person context, and the routine tests the closure status of a venue or location. It prevents scheduling or assessment activities from being attached to locations that have been deactivated.

No parameter lists, return types, or formal signatures are documented in the ETRM excerpt; the descriptions above reflect the documented names and their evident validation purpose. The package contains no other public procedures or functions.

Tables Accessed

The package references two application tables through APPS synonyms:

  • IGS_AD_LOCATION_ALL — The location definition table. It is read to resolve and confirm the status of a location, supporting the ORGP_VAL_LOC_CLOSED validation.
  • IGS_GR_VENUE_ALL — The venue definition table. It is read to confirm venue attributes, particularly whether a venue or its location is closed, complementing the location validation.

Both accesses are read-oriented; the validation logic depends on the current state of these reference tables to return a pass/fail decision to the calling package.

Usage Notes

IGS_AS_VAL_ELS is not intended for direct invocation by end users or custom code. It is an internal dependency of at least four higher-level packages: IGS_AS_EXM_LOC_SPVSR_PKG (exam location supervisor), IGS_AS_NON_ENR_STDOT_PKG (non-enrolled student), IGS_AS_VAL_VE (validation for venues), and IGS_GR_VENUE_PKG (venue maintenance). These callers invoke its validation routines as a pre-condition check before performing their own inserts, updates, or confirmations.

Typical invocation paths include assessment forms within the Oracle EBS Student System responsibility and the concurrent programs and business flows that ultimately call the four dependent packages. Customizations should treat IGS_AS_VAL_ELS as a read-only validation service and avoid modifying it, since changes could affect every dependent assessment and venue process. Organizations extending assessment functionality should call the documented validation routines rather than reinventing location or student-active checks, thereby preserving consistency with seeded validation behavior across 12.1.1 and 12.2.2.