Search Results get_fk_igs_tr_group




Overview
Explore in AI Chat

Overview

The APPS.IGS_TR_GROUP_MEMBER_PKG package is a member of the Oracle E-Business Suite (EBS) student systems module, specifically within the IGS (Student Systems) schema family that supports the Academic Tracking / Tracking Group functionality. In Oracle EBS 12.1.1 and 12.2.2, this package manages the association between tracking groups and individual tracking items, maintaining the intersection data stored in the IGS_TR_GROUP_MEMBER table. It is a generic, table-handling package (classified as OTHER in the ETRM repository) that provides the standard DML foundation — insert, lock, delete, foreign-key validation, primary-key validation, and a BEFORE_DML trigger helper — used to keep group-member relationships consistent and auditable.

The package is owned by APPS and declared AUTHID CURRENT_USER, meaning its database operations execute under the privileges of the calling user rather than the definer. It is referenced by three other packages, indicating that it functions as a reusable building block consumed by higher-level business logic rather than being invoked directly by end users.

Key Procedures and Functions

The package exposes seven documented program units. None of the parameter lists below should be assumed beyond the documented names; each entry describes the intent of the unit only.

  • INSERT_ROW — Inserts a new row into the group-member table, assigning the row identifier and the tracking group and tracking item keys.
  • LOCK_ROW — Acquires a row-level lock on an existing group-member record, using the row identifier together with the tracking group and tracking item keys to guard against concurrent modification.
  • DELETE_ROW — Removes a group-member record identified by its row identifier.
  • GET_PK_FOR_VALIDATION — Boolean function that confirms whether a valid primary key combination (tracking group plus tracking item) exists; used by forms or callers to validate user input.
  • BEFORE_DML — Centralized pre-DML hook that populates WHO columns (creation and update audit fields) and enforces referential and business rules prior to insert, update, or delete operations.
  • GET_FK_IGS_TR_GROUP — Foreign-key validation routine for the tracking group, verifying that the supplied group identifier references a legitimate parent record.
  • GET_FK_IGS_TR_ITEM — Foreign-key validation routine for the tracking item; confirms that the supplied tracking item identifier exists before a membership row is written. This is the routine most commonly associated with the search term.

Tables Accessed

The only documented table referenced is IGS_TR_GROUP_MEMBER (accessed via an APPS synonym). All of the package’s insert, lock, delete, and validation logic targets this table. The foreign-key routines, including GET_FK_IGS_TR_ITEM, perform existence checks that logically relate to the tracking item and tracking group parents, but the documented metadata attributes only IGS_TR_GROUP_MEMBER directly to this package.

Usage Notes

Because this is a generated table-handling package, it is normally called by the Oracle Forms-based UI layer for the Tracking Group Member maintenance screen and by other PL/SQL packages that create or modify group memberships programmatically. Customizations and extensions should invoke INSERT_ROW, DELETE_ROW, and the foreign-key validation routines rather than issuing direct DML against IGS_TR_GROUP_MEMBER, so that the BEFORE_DML audit logic and key validation are preserved. Callers requiring validation of a tracking item should use GET_FK_IGS_TR_ITEM prior to insert or update; when migrating or troubleshooting, note that the package signature is stable across 12.1.1 and 12.2.2, and no public parameters have changed.