Search Results get_ufk_igs_as_exam_session

Overview

IGS_AS_EXMVNU_SESAVL_PKG is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Student System (formerly Oracle iLearning/Student Systems), specifically the Assessments (IGS_AS) product family. It declares AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the calling user rather than the definer, which is consistent with the EBS "table handler" pattern used by Oracle Forms–based products such as this one.

The package functions as the DML and validation handler for the entity that links an examination venue to a scheduled exam session. The underlying table, IGS_AS_EXMVNU_SESAVL_ALL, stores rows describing when a given venue is available for a specific exam session, including the venue code, exam calendar type and sequence, date alias/sequence, start and end times, and the exam session identifier. The package therefore underpins the maintenance of exam venue/session availability records, which are consumed by examination scheduling and room allocation processes.

Key Procedures and Functions

• INSERT_ROW — Inserts a new availability row, accepting the venue, exam calendar, date alias, time window, and exam session columns, plus X_ORG_ID and a mode flag (X_MODE, default 'R').
• LOCK_ROW — Performs a locking read against an existing row (identified by X_ROWID plus the key columns) to support optimistic concurrency control, typically invoked before an update in a form.
• UPDATE_ROW — Updates the mutable attributes of an existing row, again carrying X_MODE with a default of 'R'.
• ADD_ROW — Provides the combined insert-or-update ("add") behaviour expected by the forms layer, mirroring INSERT_ROW's parameter set including X_ORG_ID.
• DELETE_ROW — Removes the row identified by X_ROWID.
• GET_PK_FOR_VALIDATION — Returns BOOLEAN indicating whether the supplied natural/primary key combination (venue, exam calendar type, sequence numbers, date alias, start and end times) identifies a valid row; used by the forms validation logic.
• GET_UFK_IGS_AS_EXAM_SESSION — The user-facing key lookup routine that validates or derives the exam session (ESE_ID) relationship — the procedure the user searched for. It is named using the EBS UFK (unique foreign key) convention, so it is called from forms to check that a valid exam session is being associated with the availability record.
• GET_FK_IGS_AS_EXAM_SESSION and GET_FK_IGS_GR_VENUE — Foreign-key helper routines validating references to the exam session entity and the venue entity respectively.
• CHECK_CONSTRAINTS — Executes the package's constraint validation logic against the current row context.
• BEFORE_DML — A pre-DML hook that enforces business rules and derives default/audit values before insert, update, or delete is applied.

Tables Accessed

The documented table operated on by this package is IGS_AS_EXMVNU_SESAVL_ALL, referenced through an APPS synonym. This is the multi-org (_ALL) table holding exam venue/session availability records. All insert, update, delete, lock, and validation operations target this table. The foreign-key helpers imply read access to the parent exam session and venue entities, though only IGS_AS_EXMVNU_SESAVL_ALL is listed in the documented metadata.

Usage Notes

Because API classification is OTHER and the package exposes the classic Forms handler interface (INSERT_ROW/UPDATE_ROW/DELETE_ROW/LOCK_ROW), it is invoked primarily by Oracle Forms used to maintain exam venue/session availability. Custom code should call the documented procedures rather than issuing direct DML, so that BEFORE_DML, CHECK_CONSTRAINTS, and the foreign-key validations continue to fire. Four other packages reference this package, indicating shared use within the Assessments scheduling modules. Callers must supply X_ROWID (as returned by an insert or fetched by a preceding query) for lock, update, and delete operations, and should treat GET_UFK_IGS_AS_EXAM_SESSION as the supported path for validating the exam session linkage.