Search Results igs_as_exam_session_pkg




Overview
Explore in AI Chat

Overview

IGS_AS_EXAM_SESSION_PKG is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite (EBS) environment, applicable to releases 12.1.1 and 12.2.2. It belongs to the Student Systems / Academic Scheduling (IGS) product family, a component of the Oracle Student System and related academic modules. The package provides the core data-access and validation logic for the IGS_AS_EXAM_SESSION entity, which represents an organized examination session — a scheduled sitting under which one or more examination instances are conducted. Exam sessions are the parent structures that tie together examination venues, supervisors, dates, and the individual student examination instances.

The package encapsulates the standard EBS Table API (TAPI) pattern, offering row-level insert, update, delete, lock, and validation operations against the underlying entity table. It is classified with an API classification of OTHER, indicating it functions as an internal table handler rather than an exposed public business API. It is referenced by seven other packages and itself references the STANDARD schema package, confirming its role as a foundational dependency for examination scheduling and timetabling logic.

Key Procedures and Functions

The package exposes twelve documented procedures and functions organized around the conventional TAPI lifecycle:

  • INSERT_ROW / ADD_ROW — Core insertion routines that create a new exam session record, populating mandatory columns and derived attributes. ADD_ROW typically wraps INSERT_ROW with additional defaulting logic.
  • UPDATE_ROW — Updates an existing exam session record after attribute changes.
  • DELETE_ROW — Removes an exam session record, subject to referential and business constraints.
  • LOCK_ROW — Obtains a row-level lock to support concurrency control during transactional processing.
  • BEFORE_DML — Central pre-DML hook that enforces WHO column population and shared validation before insert, update, or delete.
  • GET_PK_FOR_VALIDATION / GET_UK_FOR_VALIDATION — Retrieve the primary key and unique key values used by the validation framework.
  • GET_FK_IGS_CA_DA_INST / GET_FK_IGS_CA_INST — Resolve and validate foreign key relationships to the calendar instance and calendar day-instance entities, ensuring exam sessions are correctly anchored to a valid academic calendar.
  • CHECK_UNIQUENESS / CHECK_CONSTRAINTS — Enforce uniqueness rules and remaining integrity constraints prior to committing changes.

Tables Accessed

The package operates primarily against IGS_AS_EXAM_SESSION_ALL, accessed through the APPS synonym. This table stores exam session header data, including identifiers, session dates, venue references, and calendar linkage columns. The GET_FK_IGS_CA_DA_INST and GET_FK_IGS_CA_INST functions imply read access to the IGS_CA_INST and IGS_CA_DA_INST calendar tables (directly or via the session table's foreign keys), used to validate that an exam session falls within a legitimate calendar period. Primary and unique key access functions read the session table's PK and UK columns for validation purposes.

Usage Notes

IGS_AS_EXAM_SESSION_PKG is an internal table handler invoked by higher-level examination packages rather than called directly by end users. Its documented dependents include IGS_AS_EXAM_INSTANCE_PKG, IGS_AS_EXMVNU_SESAVL_PKG, IGS_AS_EXM_INS_SPVSR_PKG, IGS_AS_EXM_SES_VN_SP_PKG, IGS_AS_STD_EXM_INSTN_PKG, IGS_CA_DA_INST_PKG, and IGS_CA_INST_PKG. These dependents manage exam instances, session availability, supervisor assignments, student examination instances, and calendar definitions, indicating that exam session rows are created and maintained indirectly through exam scheduling forms, concurrent scheduling programs, and custom extensions built on the Student System schema. Custom code should not bypass this package's validation routines when manipulating exam session data, as uniqueness and calendar foreign-key integrity would otherwise be compromised.