Search Results assp_val_actv_stdnt

Overview

The APPS.IGS_AS_VAL_EIS package is a PL/SQL validation package within the Oracle E-Business Suite (EBS) Advanced Studies (IGS) module, specifically the Assessment and Examination sub-module. Its name, incorporating the "VAL" convention, indicates that it is a validation-only package — it performs rule checks and business-rule verification rather than data manipulation or transactional processing. In the ETRM classification scheme it is registered as an OTHER API, meaning it is not exposed as a formal public API but rather serves an internal, dependency-driven role supporting higher-level IGS Assessment processes.

The package is deeply tied to examination and supervisory (Examiner/Instructor/InCharge) data validation. It is referenced by IGS_AS_GEN_006, a package that in IGS terminology typically handles general assessment operations, and it also references itself, indicating internal recursive or cross-procedure calls. The package depends on SYS.STANDARD and is owned by the APPS schema, as is standard for seeded Oracle EBS 12.1.1 / 12.2.2 components.

Key Procedures and Functions

The package exposes four documented validation procedures, all prefixed ASSP_ (Advanced Studies Stored Procedure). Each targets a distinct institutional rule:

• ASSP_VAL_ACTV_STDNT — Validates the active student status associated with an assessment record, ensuring the student's enrolment state is consistent with the assessment being processed.
• ASSP_VAL_ESE_INCHRG — Validates the "Examiner Session/Exam In-Charge" relationship, verifying that supervisory in-charge assignments for an examination session are correctly and consistently configured.
• ASSP_VAL_EST_INCHRG — Validates the "Exam Supervisor/Estimator In-Charge" assignment, checking that the responsible in-charge officer is properly designated for the examination or assessment event.
• ASSP_VAL_ESU_ESE_LMT — Validates Examination Session Unit / Examination Session Event limits, enforcing configured thresholds and constraints on examination session enrolment or activity.

These procedures are internal and invoked programmatically; ETRM does not document their parameter signatures, so integrators should treat them as supporting logic rather than callable entry points.

Tables Accessed

Rather than owning tables, the package reads directly from three IGS Assessment tables (accessed via APPS synonyms):

• IGS_AS_EXM_INS_SPVSR — Examination Instructor Supervisor data, used to verify supervisor/in-charge assignments.
• IGS_AS_EXM_SES_VN_SP — Examination Session Venue/Supervisor mapping, consulted for session-level validation.
• IGS_AS_EXM_SPRVSRTYP — Examination Supervisor Type reference data, used to validate the category of supervisory role assigned.

The read-only nature of these accesses reinforces the package's validation-only design: it interrogates data to confirm correctness but does not insert, update, or delete.

Usage Notes

IGS_AS_VAL_EIS is not intended for direct invocation by end users. It is called from within other PL/SQL packages — most notably IGS_AS_GEN_006 — during assessment and examination processing. In a typical Oracle EBS 12.1.1 / 12.2.2 deployment, this occurs through the Advanced Studies Assessment forms or their supporting concurrent program logic, where validation is triggered before an examination session or supervisor assignment is committed. Custom extensions or integrations that must enforce the same institutional rules can reference these procedures, but doing so carries upgrade risk because they are undocumented internal components. As with all seeded APPS packages, direct modification is unsupported, and reliance should be limited to the calling patterns established by the parent IGS Assessment packages.