Search Results igs_as_assessmnt_itm_pkg




Overview
Explore in AI Chat

Overview

The IGS_AS_ASSESSMNT_ITM_PKG package is a PL/SQL database object owned by the APPS schema in Oracle E-Business Suite. It belongs to the Student Systems (IGS) product family, specifically the Assessment (IGS_AS) module, which supports higher-education institutions in managing assessment items, results capture, and grading. This package encapsulates the core data-management logic for assessment item records — the individual components that make up an assessment, such as a question, task, or graded element within a course or unit assessment.

The package is registered in ETRM with an API classification of OTHER, meaning it is not a formally published open interface or public API, but rather an internal implementation package used by forms and other IGS packages. It provides low-level DML operations (insert, update, lock, and add) against the assessment item entity, together with validation and constraint-checking routines. Because it is referenced by seven other packages in the IGS_AS schema, it functions as a foundational dependency within the assessment subsystem rather than a standalone entry point for external callers.

Key Procedures and Functions

The documented package exposes eight procedures and functions, which fall into three functional groups:

  • INSERT_ROW — Inserts a new assessment item record into the underlying table.
  • UPDATE_ROW — Modifies an existing assessment item record.
  • LOCK_ROW — Acquires a row-level lock on an assessment item, typically before an update, to enforce concurrency control.
  • ADD_ROW — Adds a row to the assessment item entity, generally serving as a higher-level wrapper around the insert logic and defaulting.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of an assessment item for use in validation routines, allowing callers to confirm identity before proceeding.
  • GET_FK_IGS_AS_ASSESSMNT_TYP — Returns the foreign key reference to the assessment type, linking each item to its parent assessment type definition.
  • CHECK_CONSTRAINTS — Performs validation of business and referential constraints prior to committing data.
  • BEFORE_DML — A pre-DML trigger-style routine invoked before insert, update, or delete operations to enforce standard validation and auditing conventions.

Together these routines implement the standard Oracle Forms "table handler" pattern, where a package centralizes insert, update, lock, and validation logic so that multiple user interfaces and callers share consistent rules. Parameter lists are not documented in the ETRM record and are intentionally omitted here.

Tables Accessed

The package reads and writes the IGS_AS_ASSESSMNT_ITM_ALL table through APPS synonyms. This table stores assessment item definitions for all operating units, with the _ALL suffix indicating a multi-org enabled object. The package's insert, update, lock, and add routines operate directly against this table, while the getter routines (GET_PK_FOR_VALIDATION and GET_FK_IGS_AS_ASSESSMNT_TYP) retrieve key values needed for validation and referential integrity. Constraint checks and the BEFORE_DML logic ensure that data written to IGS_AS_ASSESSMNT_ITM_ALL satisfies the assessment type foreign key relationship and other business rules before the transaction proceeds.

Usage Notes

Because IGS_AS_ASSESSMNT_ITM_PKG is classified as OTHER and is referenced by seven other packages — including IGS_AS_ASSESSMNT_TYP_PKG, IGS_AS_COURSE_TYPE_PKG, IGS_AS_EXAM_INSTANCE_PKG, IGS_AS_ITEM_ASSESSOR_PKG, IGS_AS_ITM_EXAM_MTRL_PKG, IGS_AS_SU_ATMPT_ITM_PKG, and IGS_AS_UNITASS_ITEM_PKG — it is normally invoked indirectly. These higher-level packages call its insert, update, and validation routines while managing assessment types, exam instances, assessors, and unit attempts, making this package a shared sub-layer rather than a direct integration point.

Typical invocation paths include the Oracle Forms-based assessment maintenance screens, where the form's block-level DML events trigger the row handlers, and batch or concurrent processing within the IGS_AS module that creates or maintains assessment item records. Customizations should not call this package directly unless the calling code fully replicates the surrounding validation performed by its parent packages; the recommended pattern is to use the higher-level assessment packages or the supported APIs that already wrap this logic. As with all APPS schema objects in EBS 12.1.1 and 12.2.2, the package is shipped with STATUS VALID, and any modifications should be applied through the standard patching and customization mechanisms rather than direct edits.