Search Results igs_tr_group_note_pkg




Overview
Explore in AI Chat

Overview

IGS_TR_GROUP_NOTE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM (E-Business Suite Technical Reference Manual) as an OTHER-type API. It belongs to the Oracle Student System / Student Records (IGS) product family, specifically the transfer credit subsystem (IGS_TR). The package encapsulates the data-access and maintenance logic for the IGS_TR_GROUP_NOTE entity, which associates transfer credit groups with note types and note text. In practice, this table stores the descriptive or instructional notes that accompany a transfer credit group — for example, remarks explaining how a group of external courses maps into an institution's academic structure.

The package is a table-handler style module. Rather than exposing a single business-level API, it provides the standard generated CRUD primitives (insert, update, delete, lock) plus constraint-validation and foreign-key lookup helpers that the Oracle Forms-based Transfer Credit maintenance screens and related IGS packages rely upon. Its objects are all VALID in the documented release, and the package is referenced by three peer packages: IGS_GE_NOTE_PKG, IGS_TR_GROUP_PKG, and IGS_TR_NOTE_TYPE_PKG.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new row into the underlying IGS_TR_GROUP_NOTE table, populating the columns supplied by the caller.
  • UPDATE_ROW — Applies modifications to an existing row identified by its primary key.
  • DELETE_ROW — Removes an existing row from the table by primary key.
  • LOCK_ROW — Acquires a row-level lock (SELECT ... FOR UPDATE) to support optimistic/pessimistic concurrency control in the calling form.
  • ADD_ROW — A convenience wrapper that combines lock/insert semantics, typically used when a form adds a new record to the block.
  • GET_PK_FOR_VALIDATION — Returns the primary key values required for validation checks, allowing callers to confirm uniqueness or existence.
  • CHECK_CONSTRAINTS — Enforces the table's declarative constraints (mandatory columns, check conditions) before DML is committed.
  • BEFORE_DML — A pre-DML trigger routine that sets audit/WHO columns and performs any derived-value preparation prior to insert or update.
  • GET_FK_IGS_GE_NOTE — Foreign-key lookup that resolves the associated note record in IGS_GE_NOTE.
  • GET_FK_IGS_TR_GROUP — Foreign-key lookup resolving the parent transfer credit group in IGS_TR_GROUP.
  • GET_FK_IGS_TR_NOTE_TYPE — Foreign-key lookup resolving the note type in IGS_TR_NOTE_TYPE.

Tables Accessed

The package references the table IGS_TR_GROUP_NOTE through its APPS synonym. This table is the central persistence point for group–note relationships, holding the foreign keys to the transfer credit group, the note, and the note type, together with the ordering or sequence attributes that position the note within the group. The three GET_FK_* routines imply indirect read access to the parent tables IGS_TR_GROUP, IGS_GE_NOTE, and IGS_TR_NOTE_TYPE for validation purposes.

Usage Notes

IGS_TR_GROUP_NOTE_PKG is invoked primarily from the Oracle Forms-based Transfer Credit maintenance windows, where the block-level triggers call ADD_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW as the user navigates and edits records. The BEFORE_DML and CHECK_CONSTRAINTS routines are called automatically during the form's pre-insert/pre-update processing. Because the package is also referenced by IGS_TR_GROUP_PKG and IGS_TR_NOTE_TYPE_PKG, cross-package calls occur whenever a group or note type is created, updated, or deleted and its dependent notes must be validated or cascaded. Custom extensions and concurrent programs that manipulate transfer credit groups should call these APIs rather than issuing direct DML against IGS_TR_GROUP_NOTE, ensuring the same constraint and audit handling is applied. The package shows no dependency on non-standard objects beyond SYS.STANDARD, confirming it is a conventional, self-contained table API suitable for use across Oracle EBS 12.1.1 and 12.2.2.