Search Results igs_as_itm_exam_mtrl_pkg




Overview
Explore in AI Chat

Overview

IGS_AS_ITM_EXAM_MTRL_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as OTHER within the ETRM repository. It belongs to the Oracle Student System (IGS) product family and specifically supports the assessment domain. The package encapsulates the transactional logic for the IGS_AS_ITM_EXAM_MTRL entity, which records examination materials associated with assessment items. In institutional terms, this table captures what examination or assessment materials are required for a given assessment item, together with the quantity needed per student and any descriptive comments.

The package is declared AUTHID CURRENT_USER, meaning executing privileges are resolved against the invoking schema rather than the package owner. This is consistent with Oracle Application Object Library (AOL) generated API conventions, where such packages are typically produced by the Oracle Forms generator to service a specific base table. The package was shipped at version 115.3, with a revision header dating to 2002, indicating it is a long-standing component of the Student Systems data model available in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes ten documented program units that collectively provide a complete row-level DML API for the underlying entity. INSERT_ROW creates a new examination-material record, while ADD_ROW provides the analogous insert path used by the AOL table handler. UPDATE_ROW modifies an existing record identified by its rowid, and LOCK_ROW performs the standard AOL optimistic locking check, re-reading the row to confirm that no other session has changed the values being edited. DELETE_ROW removes a record.

Validation and constraint support is provided by GET_PK_FOR_VALIDATION, a boolean function that verifies the existence of a primary-key combination, and by CHECK_CONSTRAINTS, which enforces declarative column constraints. Two foreign-key lookup procedures, GET_FK_IGS_AS_ASSESSMNT_ITM and GET_FK_IGS_AS_EXM_MTRL_TYPE, expose referential relationships to the assessment item and examination material type domains. BEFORE_DML is an internal pre-processing hook invoked prior to insert, update, or delete operations to populate WHO columns and apply standard auditing and validation logic.

Tables Accessed

The package reads and writes a single documented table, IGS_AS_ITM_EXAM_MTRL, accessed through an APPS synonym. This table stores one row per assessment-item/material-type combination, holding the assessment item identifier, the examination material type, the material category, the quantity required per student, and free-text comments. All DML procedures operate against this table. The foreign-key procedures reference the parent entities—assessment items and examination material types—to validate that the values supplied are valid and available.

Usage Notes

As a generator-produced API, this package is invoked primarily by the Oracle Forms module that maintains examination materials for assessment items. The form calls INSERT_ROW, UPDATE_ROW, LOCK_ROW, and DELETE_ROW in response to end-user actions, while CHECK_CONSTRAINTS and the foreign-key procedures validate data before commit. The package is also referenced by two other packages within the IGS schema, indicating that some reassessment or material-allocation logic depends on its programmatic interface. Custom integrations should call these procedures rather than issuing direct DML against IGS_AS_ITM_EXAM_MTRL, so that the BEFORE_DML auditing logic and locking conventions are preserved. Because the API is AUTHID CURRENT_USER, any custom code invoking it must have appropriate privileges on the underlying table and on the sequence or key-derivation logic used at insert time.