Search Results igw_ss_record_changed

Overview

The APPS.IGW_SUBJECT_INFORMATION_TBH package body is a table handler (the _TBH suffix denotes a Table Handler) that encapsulates DML operations against the IGW_SUBJECT_INFORMATION table within the Oracle E-Business Suite Grants and Awards (IGW) module. Its principal business function is to maintain subject demographic data associated with study titles, storing the type of subject, race code, ethnicity code, and the number of subjects recorded for a given study. The package originated in the early 11.5.x releases and, as indicated by its header, has remained largely stable into the 12.1.1 and 12.2.2 codelines.

Key Procedures and Functions

Three documented procedures constitute the public interface of this package:

• INSERT_ROW — Inserts a new subject information row into IGW_SUBJECT_INFORMATION, initialising the record version number to 1 and returning the generated ROWID and a standard FND return status to the caller. Errors are routed through FND_MSG_PUB.add_exc_msg, and unexpected errors are re-raised as Fnd_Api.G_Exc_Unexpected_Error.
• UPDATE_ROW — Updates an existing subject information row identified by ROWID, allowing modification of the study title, subject type, race, ethnicity, subject count, and record version number. A NULL ROWID triggers a NO_DATA_FOUND exception, preserving data integrity.
• DELETE_ROW — Removes a subject information row, typically keyed by ROWID or the composite study/subject-type identifier.

All procedures follow the standard FND API conventions, exposing an X_RETURN_STATUS OUT parameter set to FND_API.G_RET_STS_SUCCESS on completion and to an error constant on failure. No signature details beyond those shown in the source excerpt should be inferred.

Tables Accessed

The package operates exclusively against IGW_SUBJECT_INFORMATION, accessed through its APPS synonym. This table holds subject demographic breakdowns linked by STUDY_TITLE_ID and SUBJECT_TYPE_CODE. The INSERT_ROW procedure performs a post-insert cursor fetch on those same key columns to return the assigned ROWID, confirming that the composite key uniquely identifies a row. The RECORD_VERSION_NUMBER column supports optimistic locking for downstream concurrency control.

Usage Notes

As an _TBH package, IGW_SUBJECT_INFORMATION_TBH is typically invoked indirectly — by higher-level IGW business APIs, form-level triggers in the Grants module, or custom extensions that require controlled DML against subject information. The related search term igw_ss_record_changed suggests usage in change-detection or record-version workflows, where RECORD_VERSION_NUMBER is compared before permitting an update. Because the package is owned by APPS and is referenced by at least one other package, developers extending or troubleshooting IGW subject data should treat this table handler as the sanctioned write path rather than issuing direct SQL against the underlying table. Standard FND error-handling conventions apply, so callers must inspect X_RETURN_STATUS and query the FND message stack on failure.