Search Results igs_tr_item_pkg




Overview
Explore in AI Chat

Overview

IGS_TR_ITEM_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student Systems / Academic Records product family (the IGS module namespace, historically associated with Oracle Student System and its successor Oracle Student Financial Planning / Campus Solutions integration points). The naming convention — IGS_TR — identifies it as part of the Transcript and Records (TR) functional area. Within that area, the package governs the persistence, validation, and lifecycle management of transcript item records, which are the individual academic achievement lines that appear on a student's official transcript, such as course completions, transfer credits, grade entries, and awarded qualifications.

The package is documented as VALID in ETRM 12.1.1 and appears in the dependency inventory for both 12.1.1 and 12.2.2. It carries an API classification of OTHER, indicating that it is not formally published as a public integration API but is instead an internal data-access layer used by higher-level business packages and concurrent programs.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions within the package body:

  • INSERT_ROW — Inserts a new transcript item record into the underlying table, establishing the initial persisted state of the academic achievement line.
  • LOCK_ROW — Acquires a row-level lock on an existing transcript item to serialize concurrent modifications and prevent lost updates.
  • UPDATE_ROW — Applies changes to an existing transcript item record, such as corrections to grades, credit values, or item status.
  • ADD_ROW — A higher-level creation routine that typically combines validation and insertion logic to add a new item in a single call.
  • DELETE_ROW — Removes a transcript item record from persistent storage.
  • GET_PK_FOR_VALIDATION — Resolves the primary key of a transcript item, generally used by callers or downstream validation routines to confirm identity before performing an operation.
  • CHECK_CONSTRAINTS — Performs the package-level business-rule and referential validation that must pass before a row is committed.
  • BEFORE_DML — A pre-DML hook invoked immediately before insert, update, or delete operations, typically responsible for populating audit columns, WHO columns, and derived attributes.
  • GET_FK_IGS_PE_PERSON — Returns the foreign key reference to the person entity (IGS_PE_PERSON), linking the transcript item to the student record it belongs to.

Tables Accessed

The package operates against a single documented base table, referenced through its APPS synonym: IGS_TR_ITEM_ALL. This table stores transcript item records for all operating units and institutions, hence the _ALL suffix. The package reads and writes this table for every insert, update, delete, and validation operation described above. The primary key resolved by GET_PK_FOR_VALIDATION and the person foreign key returned by GET_FK_IGS_PE_PERSON both derive from columns in IGS_TR_ITEM_ALL.

Usage Notes

IGS_TR_ITEM_PKG is not intended for direct invocation by end users or external integrations. ETRM records that it is referenced by twelve other APPS packages, including IGS_TR_ITEM_NOTE_PKG, IGS_TR_GROUP_MEMBER_PKG, IGS_TR_STEP_PKG, IGS_AS_SU_ATMPT_ITM_PKG, IGS_RE_THESIS_EXAM_PKG, and several generated packages (IGS_AS_GEN_007, IGS_RE_GEN_003, IGS_TR_GEN_002). These callers invoke it whenever transcript item records are created, amended, or validated in the course of admissions, registration, thesis examination, and academic standing processing.

Because the package is classified as OTHER rather than a public API, customizations should avoid calling it directly and instead route through the documented parent packages or Oracle-provided APIs. Developers extending the Transcript module should be aware that BEFORE_DML and CHECK_CONSTRAINTS execute automatically as part of the DML cycle, so any custom logic must respect those hooks to preserve data integrity.