Search Results igs_as_val_esvs




Overview
Explore in AI Chat

Overview

IGS_AS_VAL_ESVS is a validation package in the Oracle EBS Student Systems (IGS) product family, owned by the APPS schema. The name encodes its role: "AS" denotes the Assessment module, and "VAL" indicates validation logic. "ESVS" refers to exam session venue supervisors — the individuals assigned to oversee examination sittings at specific venues. In the Oracle EBS 12.1.1 and 12.2.2 releases, the package is documented in ETRM as an OTHER-classified API, meaning it is a supporting validation engine rather than a public integration API. Its responsibility is to enforce the business rules that govern exam supervisor records: verifying that a nominated supervisor holds the appropriate standing for the venue, session, and examination being scheduled, and confirming that supervisor assignments do not violate institutional constraints before data is committed. The package is status VALID and depends only on the SYS.STANDARD package, indicating a lightweight, self-contained validation layer with no downstream dependencies on other application packages.

Key Procedures and Functions

ETRM documents four procedures or functions within IGS_AS_VAL_ESVS:

  • ASSP_VAL_EI_VENUE — validates exam instance (EI) information against venue data. It is invoked to confirm that the examination instance being processed is consistent with the venue to which it is linked.
  • ASSP_VAL_ELS_VENUE — validates examination location/session (ELS) records against venue definitions, ensuring the venue referenced for a sitting is valid and permissible for that session.
  • ASSP_VAL_ESU_ESE_EL — validates the relationship between an exam supervisor unit (ESU), an exam session element (ESE), and an exam location, confirming the combination conforms to institutional rules.
  • ASSP_VAL_ESU_ESE_VE — performs the equivalent validation for the supervisor/session-element/venue combination, checking that the nominated supervisor is valid for the specified venue within that session element.

Because ETRM does not publish parameter lists for these units, callers should treat them as internal validation entry points rather than documented APIs and should not assume a stable signature across patches.

Tables Accessed

The package operates against three documented tables through APPS synonyms:

  • IGS_AS_EXM_SES_VN_SP — the exam session venue supervisor table, holding the supervisor assignments that the package validates.
  • IGS_AS_EXM_LOC_SPVSR — the exam location supervisor table, providing the venue-level supervisor reference data used in the ELS and venue validations.
  • IGS_AS_EXM_INS_SPVSR — the exam instance supervisor table, supplying instance-level supervisor records checked by ASSP_VAL_EI_VENUE.

These tables are read to confirm that supervisor appointments are internally consistent across the instance, location, session, and venue dimensions before the records are accepted.

Usage Notes

IGS_AS_VAL_ESVS is referenced by IGS_AS_EXM_SES_VN_SP_PKG and IGS_AS_GEN_006, and it references itself, indicating recursive or chained validation calls within the assessment validation flow. It is therefore not normally invoked directly by end users; it is called from the Exam Session Venue Supervisor maintenance form and from concurrent or batch processes that load or update supervisor assignments. Customizations that insert or update supervisor rows in the three tables above should call this package to preserve the standard validation behaviour. Because the package is an internal (OTHER-classified) API and its procedures are undocumented in terms of parameter signatures, any custom invocation should be tested carefully after applying assessment module patches in both 12.1.1 and 12.2.2 environments.