Search Results igs_as_us_ai_group_s

Overview

IGS_AS_US_AI_GROUP_PKG is an Oracle EBS Student Systems (IGS) package body owned by the APPS schema. It provides the transactional data-access layer for the IGS_AS_US_AI_GROUP entity, which stores "Application Item Group" setup records used by the Admission/Application processing components of Oracle Student System. The package encapsulates standard Oracle Forms-style DML against the base table and its translated (_S / _TL) counterpart, while also exposing validation and surrogate-key resolution routines required by the surrounding admissions setup screens. It is classified as an OTHER API, meaning it is not an officially published public API and should be treated as an internal support package. The body is documented as VALID in ETRM for 12.1.1 and remains present, with unchanged documented signatures, in 12.2.2.

Key Procedures and Functions

The documented metadata lists nine procedures/functions:

• INSERT_ROW — Inserts a new row into the base group table, populating WHO columns and driving the associated translated row.
• LOCK_ROW — Acquires a row-level lock (SELECT FOR UPDATE) on the target record to guarantee serialized mutation.
• UPDATE_ROW — Applies changes to an existing row in the base table.
• ADD_ROW — Adds a row, typically combining lock/validation with insertion to support a single "add" call from the UI.
• DELETE_ROW — Removes a group record (and by convention its translated rows) from the base and translated tables.
• GET_PK_FOR_VALIDATION — Returns the primary key value used by validation routines for the target entity.
• GET_UK_FOR_VALIDATION — Returns the unique key value used for validation lookups.
• GET_UFK_IGS_PS_UNIT_OFR_OPT — Resolves the "unique foreign key" reference into IGS_PS_UNIT_OFR_OPT, i.e. the offering-option context to which a group belongs. This is the package's principal integration point with the program-of-study hierarchy.
• BEFORE_DML — Centralized row-level validation hook invoked prior to insert/update/delete, raising errors through the message stack.

Tables Accessed

• IGS_AS_US_AI_GROUP — The base application-item-group table. All INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW and validation operations target this table.
• IGS_AS_US_AI_GROUP_S — The translated/denormalized counterpart holding language-specific text such as the group name and description. The package keeps this table synchronized with the base table on every DML operation.
• IGS_AS_US_AI_GROUP_PKG — Self-referenced for inter-procedure calls.
• IGS_PS_UNIT_OFR_OPT_PKG — Invoked via GET_UFK_IGS_PS_UNIT_OFR_OPT to validate the offering-option foreign key.
• IGS_PS_UNITASS_ITEM_PKG — Used to validate/look up unit-assessment item context when resolving group memberships.

Utility dependencies include FND_GLOBAL (WHO column population), FND_MESSAGE, APP_EXCEPTION and IGS_GE_MSG_STACK for user-facing error signalling. IGS_AS_US_AI_GROUP is referenced directly by the package body and by no other documented database object (i.e. the base table is written only through this package).

Usage Notes

The package is not referenced by any database object and is therefore invoked from the client tier: the Oracle Forms setup screens for Application Item Groups, where standard block DML triggers (ON-INSERT, ON-UPDATE, ON-DELETE, ON-LOCK) delegate to the corresponding procedures. Concurrent programs that load or migrate admissions setup data may also call ADD_ROW or INSERT_ROW directly. As an OTHER-classification API, custom code should avoid depending on it; IGS_AS_US_AI_GROUP_S is the naming convention targeted by the user search, but programmatic integration should preferably use published IGS APIs. Ensure FND_GLOBAL session initialization (APPS_INITIALIZE) is performed before invocation, since the body relies on it for audit columns and language context.