Search Results get_fk_igs_en_su_attempt

Overview

IGS_PS_STDNT_UNT_TRN_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an "OTHER" API type. It belongs to the Student System (IGS) product family and governs the maintenance and validation of student unit transfer records held in the IGS_PS_STDNT_UNT_TRN table. In higher-education implementations, this table records the transfer of academic units — course units previously completed at another institution or programme — into a student's current programme of study. The package provides the standard EBS table-handling API surface: insert, lock, delete, foreign-key lookup, constraint checking, and a pre-DML processing hook. The package header carries the AUTHID CURRENT_USER clause, meaning it executes with the privileges of the calling user rather than the definer, and it ships with the version marker "$Header: IGSPI67S.pls 115.5 2003/05/20", confirming its lineage in the 11i codebase that was carried forward into 12.1.1 and 12.2.2.

Key Procedures and Functions

• INSERT_ROW — Inserts a new student unit transfer row, accepting the transfer identity columns (person, course, transfer course, calendar type, sequence number, unit, transfer date and unit occurrence) and returning the new ROWID. A mode parameter defaults to 'R'.
• LOCK_ROW — Obtains a row-level lock on an existing transfer record for the supplied ROWID and key values, supporting concurrent-update protection.
• DELETE_ROW — Deletes a transfer record identified by its ROWID.
• GET_PK_FOR_VALIDATION — Boolean validation function confirming that a primary key exists for the supplied person, course, transfer course, transfer date and unit occurrence combination.
• GET_FK_IGS_PS_STDNT_TRN — Foreign-key validation against the parent IGS_PS_STDNT_TRN entity, confirming a related student transfer record exists.
• GET_FK_IGS_EN_SU_ATTEMPT — Foreign-key validation against the IGS_EN_SU_ATTEMPT entity; the query term "get_fk_igs_en_su_attempt" maps to this procedure, which verifies that a matching student unit attempt exists for the supplied person, course and unit occurrence before transfer data is accepted.
• CHECK_CONSTRAINTS — Validates column-level constraints, accepting an optional column name and value.
• BEFORE_DML — The pre-DML hook that performs WHO-column defaulting and cross-field validation before any insert, update or delete is applied.

Tables Accessed

The package operates on the base table IGS_PS_STDNT_UNT_TRN, accessed through the APPS synonym. This table stores the transfer unit records that INSERT_ROW, LOCK_ROW, DELETE_ROW and BEFORE_DML manipulate, and that GET_PK_FOR_VALIDATION queries for primary-key existence. The two GET_FK procedures additionally validate against the parent entities IGS_PS_STDNT_TRN and IGS_EN_SU_ATTEMPT, ensuring referential integrity before a transfer row is committed.

Usage Notes

The package is documented as being referenced by five other packages, indicating it is a shared dependency within the Student System PL/SQL layer rather than a standalone entry point. It is typically invoked from the Student System Forms modules that maintain transfer credit and from custom PL/SQL that needs to create or validate transfer records through supported API calls instead of direct DML. The GET_FK_IGS_EN_SU_ATTEMPT procedure is commonly called from validation logic that must confirm a student has an existing unit attempt before recording the associated transfer. Because the API follows the standard EBS table-handler pattern, direct inserts or updates against IGS_PS_STDNT_UNT_TRN should be avoided in favour of BEFORE_DML and INSERT_ROW so that WHO columns and constraints are applied consistently.