Search Results igs_as_exm_suprvisor_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_AS_EXM_SUPRVISOR_PKG package is a database-tier PL/SQL component within the Oracle E-Business Suite (EBS) Student System / Higher Education product family, specifically belonging to the Assessment (IGS_AS) module. It manages records relating to exam supervisors within the institution's academic assessment framework. The "EXM_SUPRVISOR" naming convention indicates that this package encapsulates the data manipulation logic for the exam supervisor entity — the individuals assigned to oversee or invigilate examinations.

This package provides the programmatic interface to the underlying IGS_AS_EXM_SUPRVISOR_ALL table, which stores exam supervisor definitions. It follows Oracle's standard table-handler (TPH) pattern, exposing a well-defined set of procedures and functions that allow other packages, forms, and concurrent programs to perform CRUD operations, row locking, and constraint validation consistently and reliably. The package is classified as OTHER in the Oracle E-Business Suite API classification, meaning it is an internal or supporting package rather than a public, externally versioned API.

Key Procedures and Functions

The ETRM documentation records eleven procedures and functions. The primary data manipulation entries are:

  • INSERT_ROW — Creates a new exam supervisor record in the IGS_AS_EXM_SUPRVISOR_ALL table.
  • UPDATE_ROW — Modifies an existing exam supervisor row's attributes.
  • DELETE_ROW — Removes an exam supervisor record from the table.
  • LOCK_ROW — Issues a SELECT FOR UPDATE to obtain a row-level lock, preventing concurrent modification of a supervisor record during editing.
  • ADD_ROW — A convenience wrapper that orchestrates insertion, possibly performing validation and sequencing prior to INSERT_ROW.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of a row to support validation logic before or after DML.
  • GET_FK_IGS_AS_EXM_SPRVSRTYP — Returns the foreign key reference to the exam supervisor type entity.
  • GET_FK_IGS_OR_UNIT — Returns the foreign key reference to the organizational unit (IGS_OR_UNIT) entity.
  • GET_FK_IGS_PE_PERSON — Returns the foreign key reference to the person entity (IGS_PE_PERSON) identifying the supervisor.
  • CHECK_CONSTRAINTS — Performs validation of foreign key and business constraints on a supervisor record before committing changes.
  • BEFORE_DML — A trigger-body helper invoked automatically prior to insert, update, or delete operations to populate WHO columns, enforce validation, and set derived fields.

Tables Accessed

The package reads from and writes to the IGS_AS_EXM_SUPRVISOR_ALL table (accessed via an APPS synonym). This table holds the exam supervisor assignments, including references to the supervisor's person record, the supervisor type, and the organizational unit responsible for the examination. As the sole documented table, it forms the transactional core of the package.

Usage Notes

This package is not typically invoked directly by end users or external applications. Instead, it is consumed by four other packages that depend upon it:

It is invoked through Oracle Forms (typically attached to the exam supervisor setup or examination scheduling forms), via the dependent packages, or from custom PL/SQL code that needs to maintain exam supervisor data. Correct sequencing (BEFORE_DML, CHECK_CONSTRAINTS, then INSERT_ROW/UPDATE_ROW/DELETE_ROW) should be observed to preserve data integrity. The package is documented as VALID in APPS for EBS 12.1.1 and 12.2.2.