Results for “igs_tr_group_member_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.IGS_TR_GROUP_MEMBER_PKG package body is a core member of the Oracle E-Business Suite Student Systems / Academic Records family of PL/SQL APIs. It manages the association between admission test groups and the individual test items (tests) that belong to those groups. In the broader IGS (Intelligent Graduate/Student Systems) data model, IGS_TR_GROUP_MEMBER acts as the intersection or child entity that records which IGS_TR_ITEM rows are members of a given IGS_TR_GROUP record. The package therefore provides the low-level DML layer that other IGS test-and-results packages rely upon to create, lock, validate, and delete group membership records. ETRM classifies this object as an "OTHER" API, meaning it is an internal, table-handler-style package rather than a published business API, and it is documented for technical reference in Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

ETRM documents seven callable units in the package body. Each is described below by purpose only; parameter signatures are deliberately not restated.

• INSERT_ROW — Inserts a new group membership record into IGS_TR_GROUP_MEMBER, establishing the link between a group and a test item.
• LOCK_ROW — Acquires a row-level lock on an existing group membership record, typically used before an update or delete to enforce concurrency control.
• DELETE_ROW — Removes an existing group membership record, unassigning a test item from its group.
• GET_PK_FOR_VALIDATION — Resolves and returns the primary key value for a membership row, supporting validation logic before DML is attempted.
• BEFORE_DML — A pre-DML hook that applies standard WHO-column population and validation checks prior to insert, update, or delete processing.
• GET_FK_IGS_TR_GROUP — Returns the foreign key reference to the parent IGS_TR_GROUP record associated with a membership row.
• GET_FK_IGS_TR_ITEM — Returns the foreign key reference to the child IGS_TR_ITEM record associated with a membership row.

Tables Accessed

The documented base table accessed by this package is IGS_TR_GROUP_MEMBER, referenced through the APPS synonym. This is the primary DML target for INSERT_ROW, DELETE_ROW, and LOCK_ROW. Supporting DML utility packages IGS_TR_GROUP_PKG and IGS_TR_ITEM_PKG are referenced so that group and item context can be resolved when validating membership. The package further depends on APP_EXCEPTION, FND_MESSAGE, FND_GLOBAL, and IGS_GE_MSG_STACK for error raising, message translation, and session context, and on STANDARD for standard PL/SQL constructs.

Usage Notes

IGS_TR_GROUP_MEMBER_PKG is not referenced by any other database object per ETRM, which confirms its role as a leaf-level table handler invoked directly by application forms, most likely the Test Group maintenance form in the IGS setup responsibility. It is also a candidate for invocation from custom code or concurrent programs that must programmatically build test groups. Because the package encapsulates the foreign key helpers to both the group and the item, callers should prefer the packaged procedures over direct DML against IGS_TR_GROUP_MEMBER to preserve validation, locking, and WHO-column integrity. All calls execute against the APPS schema and assume the standard EBS session initialization provided by FND_GLOBAL.