Search Results get_fk_igs_as_us_ai_group

Overview

The APPS.IGS_AS_SUA_AI_GROUP_PKG package is a PL/SQL API belonging to the Oracle Student System (IGS) product family, specifically the Assessment (IGS_AS) module. It manages records in the Student Unit Attempt Assessment Item Group entity, which groups assessment items (such as midterms and finals) associated with a student's unit attempt so that weighted formulas can be applied to derive grades. The package is classified as an "OTHER" API within the ETRM repository and exposes the standard table-handler interface pattern used throughout Oracle EBS: paired INSERT_ROW/UPDATE_ROW/DELETE_ROW procedures, an ADD_ROW convenience wrapper, a LOCK_ROW procedure for optimistic locking, validation helpers, and a BEFORE_DML trigger stub. The header comment indicates an origin date of 2005 and a "noship" designation, reflecting a legacy or internal-only component. The package is referenced by four other packages, indicating it participates in a broader dependency chain within the assessment engine rather than serving as a standalone utility.

Key Procedures and Functions

The package exposes eleven documented program units. The core DML procedures are:

• INSERT_ROW — inserts a new assessment item group row, populating the primary key columns (SUA_ASS_ITEM_GROUP_ID and ROWID) as IN OUT NOCOPY parameters and accepting the full attribute set including person, course, unit occurrence, group name, midterm and final formula codes and quantities, weights, and foreign key references to unit and student assessment item groups.
• UPDATE_ROW and LOCK_ROW — the update procedure modifies an existing row identified by ROWID, while LOCK_ROW acquires a pessimistic lock against the same set of columns to support the standard Forms "check before update" pattern.
• DELETE_ROW — removes the identified assessment item group record.
• ADD_ROW — a convenience wrapper that performs an existence check before inserting, allowing callers to idempotently add a row without first querying for duplicates.
• GET_PK_FOR_VALIDATION and GET_UK_FOR_VALIDATION — return primary key and unique key values respectively, used by the Forms validation layer to confirm that a given identifier is still current.
• GET_FK_IGS_EN_SU_ATTEMPT, GET_FK_IGS_AS_UNIT_AI_GRP, and GET_FK_IGS_AS_US_AI_GROUP — foreign key lookup functions that validate references to the student unit attempt, unit assessment item group, and student assessment item group entities. The user's search term "get_fk_igs_as_us_ai_group" maps directly to the third of these.
• BEFORE_DML — a server-side trigger body stub invoked prior to insert, update, or delete to enforce WHO column defaults and any pre-DML business rules.

Tables Accessed

All data manipulation targets the base table IGS_AS_SUA_AI_GROUP, which stores the assessment item group definitions keyed by SUA_ASS_ITEM_GROUP_ID. Supporting lookups and locking operate against IGS_AS_SUA_AI_GROUP_S, the corresponding shadow/intersection table used for cross-referencing and referential integrity checks. Access is performed through APPS synonyms, so the package resolves objects via the APPS schema regardless of the invoking user.

Usage Notes

This package is typically invoked from Oracle Forms-based assessment maintenance screens (for example, student assessment item group entry), from the BEFORE_DML database trigger attached to the base table, and from custom PL/SQL routines performing bulk insert of assessment formulas. Because the DML procedures use IN OUT NOCOPY parameters for the primary key columns, callers must declare and pass host variables rather than literals when inserting. The GET_FK_* functions are commonly called from Forms LOV validation logic to confirm that foreign key values entered by the user are valid. Direct invocation from concurrent programs should be avoided unless the program explicitly manages commits, as the package does not perform its own commit handling. Given its "noship" legacy status, extensions should prefer the documented API entry points and preserve the existing signature set.