Search Results igs_as_unit_ai_grp_s

Overview

APPS.IGS_AS_UNIT_AI_GRP_PKG is a PL/SQL package body belonging to the Oracle E-Business Suite Student Systems (IGS) product family, specifically the Academic Assessment (AS) module. Its name indicates a role in maintaining unit assessment item group data — the entities that hold together assessment items associated with a teaching unit, so that institutions can define weighted components, grouping structures, and rules that feed into final unit grade calculation. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package is documented in the E-Business Suite Technical Reference Manual (ETRM) with an API classification of OTHER, denoting it as a generated or internal implementation utility rather than a formally published public API.

Functionally, the package encapsulates the Data Manipulation Logic required to create, modify, lock, and delete rows in the unit assessment item group entities. It is a companion to the table-level objects IGS_AS_UNIT_AI_GRP (base table) and IGS_AS_UNIT_AI_GRP_S (translation table), and it also depends on IGS_AS_UNITASS_ITEM_PKG to maintain consistency between group headers and their constituent assessment items.

Key Procedures and Functions

The ETRM lists nine documented program units within the package body:

• INSERT_ROW — performs a direct insert into the base table for a unit assessment item group record.
• LOCK_ROW — acquires a row-level lock to support concurrency control before an update or delete.
• UPDATE_ROW — applies changes to an existing unit assessment item group row.
• ADD_ROW — the primary create operation, invoked by higher-level business logic; it validates the incoming record and delegates to INSERT_ROW.
• DELETE_ROW — removes a unit assessment item group row, allowing associated item records to be cleaned up or re-parented.
• GET_PK_FOR_VALIDATION — returns the primary key value of the target record so validation routines can confirm existence and identity.
• GET_UK_FOR_VALIDATION — returns unique key information used to enforce uniqueness constraints and prevent duplicates.
• GET_FK_IGS_PS_UNIT_OFR_PAT — resolves the foreign key relationship to the unit offering pattern entity (IGS_PS_UNIT_OFR_PAT_PKG), establishing which offering pattern the group belongs to.
• BEFORE_DML — a pre-DML hook that executes standard column value derivation and validation, such as WHO columns and record-level checks, before insert/update/delete proceeds.

Tables Accessed

The package reads and writes two documented tables via APPS synonyms. IGS_AS_UNIT_AI_GRP is the primary base table holding unit assessment item group definition rows. IGS_AS_UNIT_AI_GRP_S is the corresponding translation table, which stores the same logical rows in additional languages so that group descriptions and names can be rendered in multiple locales. Both are manipulated exclusively through this package's DML routines to preserve integrity. The foreign-key resolution routine additionally links group records to the unit offering pattern via IGS_PS_UNIT_OFR_PAT_PKG.

Usage Notes

Because the package is classified as OTHER and is not referenced by any other database object, it is typically invoked indirectly — by Student Systems forms, by related packages such as IGS_AS_UNITASS_ITEM_PKG, or by institution-specific extensions that manipulate assessment item group data. Direct invocation is discouraged; integrators should prefer the higher-level unit assessment APIs. Any custom code calling this package must honor the BEFORE_DML conventions, supply valid WHO audit context through FND_GLOBAL, and expect errors to be raised via FND_MESSAGE, IGS_GE_MSG_STACK, and APP_EXCEPTION. The package is valid in both 12.1.1 and 12.2.2, with no functional divergence documented between the two releases.