Search Results igs_as_su_atmpt_itm_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_AS_SU_ATMPT_ITM_PKG package is a core data-access and maintenance component within the Oracle E-Business Suite (EBS) Student System (the IGS product family), delivered as part of the Advanced Studies / Assessment (AS) module. Its object name resolves to the "Student Unit Attempt Item" entity, indicating that it manages the child records of a student's unit attempt — that is, the individual assessment or item level rows that roll up beneath a student unit attempt. The package encapsulates the standard EBS "table handler" pattern, providing insert, update, delete, locking, primary-key and foreign-key validation, and constraint-checking routines for the underlying IGS_AS_SU_ATMPT_ITM base table.

The package is classified as an OTHER API (not a public open interface or a formally published business API), meaning it is intended primarily for internal consumption by other IGS packages, concurrent programs, and generated forms logic rather than for direct external integration. It resides in the APPS schema, is marked VALID, and carries no invalidated state in the documented metadata, indicating it compiles cleanly against its dependencies.

Key Procedures and Functions

The documented interface exposes fifteen subprograms, all following conventional EBS table-handler conventions:

  • INSERT_ROW, ADD_ROW — create a new student unit attempt item record; ADD_ROW typically wraps additional defaulting or validation logic prior to insertion.
  • UPDATE_ROW — modifies an existing item row for the identified entity.
  • DELETE_ROW — removes an item row, subject to constraint and referential validation.
  • LOCK_ROW — acquires a row-level lock (SELECT ... FOR UPDATE) to serialize concurrent modification of an item.
  • GET_PK_FOR_VALIDATION — resolves and returns the primary-key value used to validate the entity against the base table.
  • GET_FK_* functions — foreign-key resolution routines for the parent entities IGS_AS_ASSESSMNT_ITM, IGS_EN_SU_ATTEMPT, IGS_AS_SUA_AI_GROUP, IGS_TR_ITEM, IGS_AS_GRD_SCH_GRADE, and IGS_LOOKUPS_VIEW; each validates that a supplied foreign-key value exists in the referenced table.
  • GET_UFK_IGS_AS_UNTAS_PATTERN — resolves an unusual (unique) foreign key against the unit-attempt pattern entity.
  • CHECK_CONSTRAINTS — performs declarative constraint validation before DML is committed.
  • BEFORE_DML — the standard pre-DML hook invoked to apply defaulting and validation immediately before insert, update, or delete.

Tables Accessed

The package references three documented base tables through APPS synonyms:

  • IGS_AS_SU_ATMPT_ITM — the primary entity table holding the student unit attempt item records that this package inserts, updates, deletes, and locks.
  • IGS_AS_SPL_CONS_APPL — supporting assessment/special consideration application data consulted during validation and constraint logic.
  • IGS_TR_STATUS — the transfer/status reference table used to resolve or validate status values associated with the item.

Additional references to SYS.STANDARD reflect the PL/SQL built-in package rather than an application table.

Usage Notes

This package is referenced by fifteen other IGS packages, including IGS_AS_ASSESSMNT_ITM_PKG, IGS_AS_ADI_UPLD_AIO_PKG, IGS_AS_GRD_SCH_GRADE_PKG, IGS_EN_SU_ATTEMPT_PKG, IGS_TR_ITEM_PKG, and the generated IGS_AS_GEN_* and IGS_EN_GEN_010 packages. This dependency graph confirms that invocation is predominantly internal: assessment item maintenance, grade/attempt processing, and generated forms handlers call the package rather than end users invoking it directly. Customizations should treat it as an internal table handler, invoking the documented insert/update/delete/lock routines only in the correct DML sequence and honoring the BEFORE_DML hook. Because the package is not a formally published public API, direct use from custom concurrent programs is discouraged in favor of higher-level IGS business APIs.