Results for “igs_as_exm_loc_spvsr_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AS_EXM_LOC_SPVSR_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM API classification of OTHER. It belongs to the Oracle Student Systems / Institutional Graduation and Student (IGS) product family, specifically the assessment and examination (IGS_AS) module. The package encapsulates the server-side data manipulation logic for the IGS_AS_EXM_LOC_SPVSR entity, which associates an exam location with an eligible supervisor or invigilator (identified by person). In practical terms, it maintains the mapping between examination venues and the staff members authorized to supervise examinations at those venues.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, and its header carries the revision marker $Header: IGSDI25S.pls 115.3 2002/11/28, indicating a long-standing, stable component of the IGS data model. It exposes eight documented program units and is referenced by two other packages, confirming its role as a shared maintenance layer rather than an end-user entry point.

Key Procedures and Functions

The package provides the standard Oracle Forms-generated table handler interface. INSERT_ROW creates a new supervisor-to-exam-location assignment, accepting the person identifier, the exam location code, and an operational mode flag defaulting to 'R'. LOCK_ROW performs the pessimistic locking check required by Forms to detect concurrent modification before an update or delete. DELETE_ROW removes an assignment identified through its rowid.

GET_PK_FOR_VALIDATION is a Boolean function that validates the combination of person identifier and exam location code as a legitimate primary key, returning TRUE when the pair is valid. GET_FK_IGS_AS_EXM_SUPRVISOR is the foreign-key validation routine for the supervisor reference, taking a person identifier and confirming that the person exists as a valid supervisor. GET_FK_IGS_AD_LOCATION performs the equivalent validation against the location entity, accepting a location code.

CHECK_CONSTRAINTS enforces column-level constraints, optionally scoped to a named column and value. BEFORE_DML is the central pre-DML hook invoked internally to populate WHO columns and apply derived defaults across insert, update, and delete operations.

Tables Accessed

The package operates on a single documented table, IGS_AS_EXM_LOC_SPVSR, accessed through its APPS synonym. This table stores the intersection rows linking exam locations to supervising persons. INSERT_ROW, LOCK_ROW, DELETE_ROW, and BEFORE_DML all read or write against it. The foreign-key validation routines conceptually verify the parent keys in the supervisor and location entities, although the documented metadata attributes only the IGS_AS_EXM_LOC_SPVSR table directly to this package.

Usage Notes

This package is normally invoked indirectly. Oracle Forms-based maintenance screens for exam location supervisors call the INSERT_ROW, LOCK_ROW, and DELETE_ROW procedures on save and delete, and the validation routines on field-level validation. Custom PL/SQL, interfaces, or concurrent programs that load supervisor-to-location assignments should call the public procedures rather than issuing direct DML, preserving constraint checking and WHO column auditing. Because the package is referenced by two other packages, changes to its behavior can propagate through the IGS_AS dependency chain. The user search term "get_fk_igs_as_exm_suprvisor" corresponds to the documented GET_FK_IGS_AS_EXM_SUPRVISOR procedure, whose name differs slightly in spelling from the table synonym, a common source of confusion when searching for this routine.