Search Results igs_ps_val_uv




Overview
Explore in AI Chat

Overview

IGS_PS_VAL_UV is a PL/SQL validation package in the APPS schema that belongs to the Oracle Student System (formerly Oracle iLearning / Higher Education) product family. The "PS" segment of the name identifies it as part of the Person/Student "Program of Study" area, while "VAL_UV" identifies it as the validation logic for "Unit Offerings" and their "Unit Versions." In practice, the package encapsulates the business rules that govern whether a specific unit offering (a scheduled delivery of a course unit) and its associated unit version are valid before they can be used in enrollment, progression, or examination processing.

The package is classified as OTHER rather than a public API, meaning it is intended primarily as internal validation plumbing called by other EBS packages and enrollment processing logic rather than being invoked directly by end users or third-party integrations. It depends on and is depended upon by several other Student System packages, positioning it near the core of unit-offering validation.

Key Procedures and Functions

The ETRM 12.1.1 metadata documents 14 procedures and functions. They cluster into several validation categories:

Each routine returns an outcome (typically an error code or boolean) that the calling package interprets to either accept or reject the unit-offering record.

Tables Accessed

The package reads and, where appropriate, validates against the following documented tables (accessed through APPS synonyms): IGS_PS_UNIT_OFR_OPT_ALL (unit offering options), IGS_PS_USEC_CPS (credit-point scheme usage), IGS_AS_GRD_SCH_GRADE (grade scheme grades), IGS_PS_UNIT_DSCP (unit descriptions), IGS_PS_UNIT_INT_LVL (unit internal levels), IGS_PS_UNIT_OFR (unit offerings), IGS_PS_UNIT_REF_CD (unit reference codes) and IGS_PS_UNIT_STAT (unit status). These represent the master and reference data against which the validation logic is applied.

Usage Notes

IGS_PS_VAL_UV is referenced by five other packages — notably IGS_EN_PRC_LOAD (enrollment processing load), IGS_PS_UNIT_LVL_PKG, IGS_PS_UNIT_VER_PKG, IGS_PS_VALIDATE_LGCY_PKG, and IGS_SS_ENR_DETAILS. It is therefore typically invoked indirectly, whenever a unit offering or unit version is inserted, updated, or enrolled against through those higher-level packages.

In EBS 12.1.1 and 12.2.2, the package behaves identically at the database level; the 12.2 online patching edition does not modify the validation contract. Customizations should never call its procedures directly in a way that bypasses the owning public APIs, because the internal procedure signatures are not part of a supported public interface. Where institutions need additional validation, the correct approach is to extend through the supported public packages rather than modify IGS_PS_VAL_UV.