Search Results igs_as_sua_ai_group_s

Overview

The APPS.IGS_AS_SUA_AI_GROUP_PKG package body is a component of the Oracle E-Business Suite (EBS) Student Systems product family, specifically the Institution of Higher Education (HE) Assessment module (IGS AS). It provides the server-side PL/SQL implementation that supports the entity IGS_AS_SUA_AI_GROUP — the association between a Student Unit Attempt (SUA) and its Assessment Item (AI) Group. In Oracle EBS 12.1.1 and 12.2.2, this package supplies the standard insert, update, delete, lock, and validation logic used by the corresponding maintenance form (for example, the "Assessment Item Group" window within the Student Unit Attempt entry flow). It enforces business rules, maintains audit columns, and writes error messages to the IGS message stack. The object is classified as OTHER rather than an open public API, and the package is documented as not being referenced by any other database object, confirming it is a terminal, form-facing component within the assessment hierarchy.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions. Their purposes are:

• INSERT_ROW — Performs the physical insert of a new IGS_AS_SUA_AI_GROUP record, populating mandatory and audit columns.
• LOCK_ROW — Acquires a row-level lock (SELECT FOR UPDATE) to serialise concurrent access before update or delete.
• UPDATE_ROW — Applies changes to an existing record, including WHO audit columns.
• ADD_ROW — The primary entry point invoked by the form; orchestrates validation, primary/foreign key derivation, and delegates to INSERT_ROW.
• DELETE_ROW — Removes a record after checking for dependent or protected data.
• GET_PK_FOR_VALIDATION — Retrieves the primary key values required to validate uniqueness and existence.
• GET_UK_FOR_VALIDATION — Retrieves the unique key values used to detect duplicate records.
• GET_FK_IGS_EN_SU_ATTEMPT — Resolves the foreign key reference to the underlying Student Unit Attempt.
• GET_FK_IGS_AS_UNIT_AI_GRP — Resolves the foreign key to the Unit Assessment Item Group parent record.
• GET_FK_IGS_AS_US_AI_GROUP — Resolves the foreign key to the associated assessment group definition.
• BEFORE_DML — A consolidation routine executed before DML operations to apply defaulting and validation logic.

Tables Accessed

The package reads and writes two documented tables through APPS synonyms:

• IGS_AS_SUA_AI_GROUP — The base transactional table that stores each Student Unit Attempt to Assessment Item Group association. All insert, update, delete, and lock operations target this table.
• IGS_AS_SUA_AI_GROUP_S — The complementary sequence/identifier table (indicated by the _S suffix) used to generate or hold key values required when creating new rows.

Dependencies listed in the metadata confirm that it also relies on IGS_AS_SUAAI_OUHIST_PKG, IGS_AS_SU_ATMPT_ITM_PKG, IGS_AS_UNIT_AI_GRP_PKG, IGS_AS_US_AI_GROUP_PKG, and IGS_EN_SU_ATTEMPT_PKG for cross-entity validation and history maintenance, together with FND_GLOBAL, FND_MESSAGE, and IGS_GE_MSG_STACK for session context and error handling.

Usage Notes

IGS_AS_SUA_AI_GROUP_PKG is invoked primarily from the Oracle Forms front-end of the Assessment module whenever a user adds, changes, or removes an Assessment Item Group against a Student Unit Attempt. The form calls ADD_ROW, UPDATE_ROW, and DELETE_ROW, with LOCK_ROW protecting concurrent transactions. The GET_*_FOR_VALIDATION and GET_FK_* functions are called internally to enforce referential integrity against the Student Unit Attempt, Unit Assessment Item Group, and Unit Set AI Group parents. The package is referenced by four other packages, so custom extensions or concurrent programs that process assessment data should call it rather than issuing direct DML, ensuring that the message stack, audit columns, and dependent history logic remain consistent. Because it is classified as OTHER, it should be treated as internal and subject to change