Search Results igs_as_unit_ai_grp_pkg




Overview
Explore in AI Chat

Overview

IGS_AS_UNIT_AI_GRP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student Systems product family (the IGS prefix denotes the Oracle Student System / Student Records components). Within the broader assessment and unit-attempt processing model, this package encapsulates the server-side logic for maintaining Unit Assessment Item Group definitions — the records that group individual assessment items into a logical unit for a given unit offering pattern. It functions as a generated or seeded Table Handler package, providing the canonical insert, update, delete, locking, and validation primitives used by both Oracle-delivered concurrent programs and dependent packages. The package is marked VALID and is classified as an API of type OTHER, indicating it is intended primarily for internal consumption rather than as a released public interface.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new row into the base Unit Assessment Item Group table, populating the surrogate primary key from the sequence and enforcing column-level defaults.
  • LOCK_ROW — Acquires a row-level lock on an existing record to prevent concurrent modification during a transaction.
  • UPDATE_ROW — Applies modifications to an existing Unit Assessment Item Group record.
  • ADD_ROW — Higher-level creation routine that combines row insertion with the supporting validation and dependent-table maintenance required to establish a complete group definition.
  • DELETE_ROW — Removes a Unit Assessment Item Group record, including its associated secondary/translation rows.
  • GET_PK_FOR_VALIDATION — Resolves the surrogate primary key for a candidate row, used by validation logic to confirm uniqueness and referential integrity.
  • GET_UK_FOR_VALIDATION — Resolves the unique-key combination for the entity, supporting duplicate-detection during validation.
  • GET_FK_IGS_PS_UNIT_OFR_PAT — Returns the foreign-key value referencing the Unit Offering Pattern record, used to validate the parent context of the group.
  • BEFORE_DML — Centralized pre-DML trigger logic that stamps WHO columns, applies the primary key when absent, and performs the standard before-insert/update validations.

Tables Accessed

The package reads and writes two documented tables through APPS synonyms. IGS_AS_UNIT_AI_GRP is the base (transaction) table holding Unit Assessment Item Group records, and it is the primary target of the insert, update, delete, and lock procedures. IGS_AS_UNIT_AI_GRP_S is the corresponding secondary/translation table, holding additional descriptive, language-dependent, or flexfield-related columns keyed back to the base table. The package maintains integrity between the two by writing both consistently within ADD_ROW and DELETE_ROW, and by joining them during validation and foreign-key resolution.

Usage Notes

This package is referenced by three other packages — IGS_AS_SUA_AI_GROUP_PKG, IGS_AS_UNITASS_ITEM_PKG, and IGS_PS_GEN_008 — and is therefore invoked indirectly whenever Unit Assessment Item Group data is created, modified, or deleted through those higher-level flows, including concurrent generation programs. It also depends only on the SYS STANDARD package, making it a low-level leaf component. Because it is classified as an internal API rather than a released interface, customizations should prefer invoking the calling packages (such as IGS_AS_UNITASS_ITEM_PKG) rather than calling INSERT_ROW, UPDATE_ROW, or DELETE_ROW directly, so that all dependent validation and secondary-table maintenance is preserved.