Search Results igs_as_exm_ins_spvsr_pkg




Overview
Explore in AI Chat

Overview

The package body APPS.IGS_AS_EXM_INS_SPVSR_PKG is a transactional PL/SQL API within the Oracle E-Business Suite Student Systems (Oracle Student System / OSS) product family, specifically belonging to the Academic Assessment (IGS_AS) module. Its functional remit is to manage the association between an exam instance and the supervisors assigned to it. The underlying table, IGS_AS_EXM_INS_SPVSR, stores the row-level data that links an exam instance to a supervisor record, and this package encapsulates all insert, update, delete, locking, and validation logic for that entity. In the 12.1.1 and 12.2.2 releases the object is documented as VALID under the APPS schema with a classification of OTHER, indicating it is an internal, non-public API used by the institution's assessment-processing components rather than a formally published interface. Because it is not referenced by any database object, it is a leaf package that is itself consumed by higher-level packages.

Key Procedures and Functions

The documented API surface comprises twelve procedures and functions that together implement the standard EBS row-handling and constraint-enforcement pattern for a detail entity:

  • INSERT_ROW — performs the core insert of a new exam-instance supervisor association into the base table.
  • ADD_ROW — a wrapper/entry-point variant that augments the insert with the surrounding business validation and auditing logic.
  • UPDATE_ROW — updates an existing association row while enforcing the same validation and audit rules applied on insert.
  • DELETE_ROW — removes an association row, respecting dependent and constraint rules.
  • LOCK_ROW — issues a SELECT FOR UPDATE to serialize concurrent modification of a specific row, supporting optimistic/conservative concurrency control.
  • GET_PK_FOR_VALIDATION — returns the primary key components, permitting downstream validation routines to identify the target record uniquely.
  • GET_FK_IGS_AS_EXAM_INSTANCE — derives the foreign key to the parent exam instance, used to validate that the referenced exam instance exists and is current.
  • GET_UFK_IGS_AS_EXAM_SESSION — resolves the user/unique foreign key to the exam session, supporting session-level consistency checks.
  • GET_FK_IGS_AS_EXM_SPRVSRTYP — returns the foreign key to the supervisor type record, used for supervisor-type validation.
  • GET_FK_IGS_AS_EXM_SUPRVISOR — returns the foreign key to the supervisor record, validating that the assigned supervisor is valid.
  • CHECK_CONSTRAINTS — executes the full set of relational and business constraints before DML is permitted to commit.
  • BEFORE_DML — a pre-DML hook applying defaulting, WHO-column population, and audit/message-stack handling.

Tables Accessed

The package reads and writes the APPS synonym IGS_AS_EXM_INS_SPVSR, which is the transactional table recording exam-instance-to-supervisor assignments. Insert, update, and delete operations target this table, while the GET_FK and validation routines query it to confirm referential integrity with parent entities. The documented dependency list shows that parent-entity validation is delegated to IGS_AS_EXAM_INSTANCE_PKG, IGS_AS_EXAM_SESSION_PKG, IGS_AS_EXM_SPRVSRTYP_PKG, and IGS_AS_EXM_SUPRVISOR_PKG, each exposing the corresponding lookup for exam instance, exam session, supervisor type, and supervisor. Message and error handling relies on FND_MESSAGE, IGS_GE_MSG_STACK, IGS_AS_GEN_006, and APP_EXCEPTION, while FND_GLOBAL supplies the runtime session context and IGS_GE_NUMBER provides numeric sequence/ID generation. Constraint checks are performed through IGS_AS_VAL_ESU.

Usage Notes

The package is not referenced by any database object, so it is invoked from higher-level assessment packages and, typically, from Oracle Forms or OAF pages that maintain exam supervisor data. Callers should invoke LOCK_ROW prior to update or delete, allowing CHECK_CONSTRAINTS and BEFORE_DML to run, then commit through the standard EBS transaction boundary. Because it is classified as OTHER rather than a public API, direct custom calls should be restricted to controlled extensions, with error conditions inspected via the message stack. The package is referenced by five other packages, confirming that it functions as a reusable detail-level service layer within the IGS_AS exam scheduling and supervisor-management flow.