Search Results genp_set_time

Overview

IGS_AS_VAL_ESVS is a validation package body in the Oracle E-Business Suite Student Systems (IGS) product family, owned by the APPS schema. Its classification is OTHER within the ETRM repository, meaning it is an internal validation library rather than a public API. The package supports the examination and assessment scheduling sub-module, specifically the allocation of supervisors to exam venues and exam locations. Its core responsibility is to confirm that a requested supervisory assignment is legitimate before it is persisted — that an exam instance actually exists at the nominated venue, that the venue is valid for the exam session, and that the student, session, and element combinations involved are internally consistent.

The unit is invoked from the supervisor allocation routines rather than directly by end users. The header comment records a change history entry dated 28-AUG-2001 (Bug 1956374) in which the function genp_val_staff_prsn was removed, indicating that earlier versions performed staff-person validation that later migrated elsewhere. The shipped source revision is IGSAS21B.pls 115.5, dated 2002/11/28.

Key Procedures and Functions

• ASSP_VAL_EI_VENUE — Validates that at least one exam instance exists for the supplied exam calendar type, calendar instance sequence, date alias, date alias instance sequence, and venue code. It compares the start and end times of the retrieved exam instance against the requested times, normalising both through Igs_Ge_Gen_003.GENP_SET_TIME so that time-of-day comparison is consistent. Returns a Boolean and an OUT message name.
• ASSP_VAL_ELS_VENUE — Performs the equivalent venue-level validation for exam locations, confirming that a valid exam location and venue combination exists for the supervisor allocation being created.
• ASSP_VAL_ESU_ESE_EL — Validates the relationship between an exam setup unit, exam setup element, and exam location, ensuring the element is legitimately scheduled at that location before allocation proceeds.
• ASSP_VAL_ESU_ESE_VE — Validates the same exam setup unit and element pairing against a venue rather than a location, servicing the venue-based allocation path.

Tables Accessed

The package reads from three APPS synonyms. IGS_AS_EXM_INS_SPVSR holds exam instance supervisor assignments and is consulted to determine whether a supervisory record already exists for the given instance. IGS_AS_EXM_LOC_SPVSR stores exam location supervisor assignments, supporting the location-based validation routines. IGS_AS_EXM_SES_VN_SP links exam sessions to venues and supervisors, providing the session/venue combination used by the venue validation functions. All access is read-only; the package performs no inserts, updates, or deletes, consistent with its role as a pre-allocation gatekeeper.

Usage Notes

IGS_AS_VAL_ESVS is referenced by two other packages in the ETRM repository, which are the normal callers — typically the supervisor allocation or exam scheduling packages that must confirm validity before writing to the supervisor tables. It is not designed for direct invocation from concurrent programs or from the Applications forms layer, and because the functions return BOOLEAN plus an OUT NOCOPY message parameter, they are not directly callable from Oracle Forms PL/SQL. Customers extending exam scheduling logic should call the documented public wrapper routines in the calling packages rather than these validation functions, and should treat ASSP_VAL_EI_VENUE and its siblings as internal implementation details subject to change without notice.