Search Results set_column_values

Overview

The APPS.IGS_PS_FAC_TCFT_TMP_PKG package body is a temporary-table maintenance API within the Oracle E-Business Suite Student Systems (IGS) product family. It is classified under the ETRM as an OTHER API, meaning it is not a public, externally-supported interface, but rather an internal helper package used by the Student Records and Prospect/Applicant processing modules. The package operates against the table IGS_PS_FAC_TCFT_TMP, a staging or temporary table (indicated by the _TMP suffix) that holds interim rows for tuition/credit/fee transfer (TCFT) or facility-based academic data. Its central purpose is to encapsulate DML and locking logic for this staging table so that higher-level business processes can insert, update, delete and lock rows through a controlled, consistent interface. The package body exposes private state variables (l_rowid, old_references, new_references) and a column-initialisation routine, set_column_values, which reconciles old and new row images before an UPDATE is applied.

Key Procedures and Functions

ETRM documents five procedures for this package body. Parameter lists are intentionally not reproduced here; only the documented purpose of each is described.

• INSERT_ROW — Performs the insertion of a new record into IGS_PS_FAC_TCFT_TMP, applying the standard EBS auditing columns (creation date, created by, last update date, last updated by, last update login) and calling the column-value initialiser.
• ADD_ROW — A convenience variant of INSERT_ROW, typically invoked where a caller must unconditionally add a staging row without first validating for an existing key.
• UPDATE_ROW — Modifies an existing staging row. The body preserves the original creation_date and created_by values when the action is 'UPDATE', ensuring that the EBS audit trail is not overwritten.
• DELETE_ROW — Removes a staging row identified by ROWID, supporting the standard delete path for the temporary table.
• LOCK_ROW — Acquires a row-level lock using a SELECT ... FOR UPDATE against the target ROWID, serialising concurrent modifications and preventing lost updates during multi-step processing.

The private routine set_column_values underpins these operations. It opens a cursor on the row identified by x_rowid, and if no record is found while the action is not INSERT or VALIDATE_INSERT, it raises the standard FND_MSG_PUB message FORM_RECORD_DELETED and aborts via APP_EXCEPTION.RAISE_EXCEPTION. Otherwise it populates the old_references and new_references record variables.

Tables Accessed

The package reads and writes the single documented table IGS_PS_FAC_TCFT_TMP, referenced through an APPS synonym. The cursor cur_old_ref_values selects the current row image by ROWID for comparison and audit preservation, while the DML procedures insert, update, or delete rows in the same table. No other tables are documented as being referenced.

Usage Notes

This package is referenced by one other packaged object, indicating it forms part of an internal dependency chain rather than a public API surface. It is typically invoked from Oracle Forms-based Student System windows, from concurrent programs that stage and post TCFT data, or from custom PL/SQL that needs to manipulate the temporary table while respecting EBS audit conventions and row-locking semantics. Because the classification is OTHER, developers should treat the package as internal: the supported extension point for TCFT staging remains the documented table structure and the surrounding IGS business APIs. The set_column_values routine is the historical target of the search term and is significant because it is the single point that enforces the FORM_RECORD_DELETED guard and audit-field preservation for all updates to the staging table.