Search Results check_child_existence

Overview

IGS_OR_INSTITUTION_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under the OTHER API category. It supports the Oracle Student System (formerly Oracle iLearning / OSS) institutions module by providing validation and referential integrity helper routines around the IGS_OR_INSTITUTION base table, which stores the academic and government institution records used throughout enrollment, admissions, and financial aid processing.

The current package body (header IGSOI02B.pls, version 115.8, last shipped 2002/10/28) reflects a significant architectural change. As documented in the change-history block, routines such as INSERT_ROW, UPDATE_ROW, LOCK_ROW, BEFORE_DML, CHECK_PARENT_EXISTENCE, CHECK_CHILD_EXISTENCE, CHECK_CONSTRAINTS, SET_COLUMN_VALUES, and AFTER_DML were deliberately removed because the corresponding TCA (Trading Community Architecture) related processing is now handled through TCA table handlers. This is important context for the search term "check_child_existence": that procedure no longer exists in this package body. Callers that historically relied on CHECK_CHILD_EXISTENCE for child-record validation during DML on IGS_OR_INSTITUTION must now rely on the TCA table handler infrastructure instead. The surviving procedures are read-only validation helpers that raise predefined messages when a foreign key or primary key relationship is violated.

Key Procedures and Functions

• GET_PK_FOR_VALIDATION — Confirms that a supplied institution code exists as a primary key value in IGS_OR_INSTITUTION. It opens a cursor selecting ROW_ID for the matching institution_cd, returns TRUE when a row is found, and FALSE otherwise. Typically used by calling APIs to short-circuit processing when the parent institution is absent.
• GET_FK_IGS_OR_GOVT_INST_CD — Checks whether any IGS_OR_INSTITUTION row references the supplied government institution code. If a match is found, it sets message IGS_OR_INS_GIC_FK on the FND_MESSAGE stack, adds it via IGS_GE_MSG_STACK.ADD, and raises App_Exception.Raise_Exception, preventing deletion or update of a referenced government institution.
• GET_FK_IGS_OR_INST_STAT — Performs the equivalent referential check for the institution status column, guarding against modification or removal of status values still in use by institution records.
• GET_FK_IGS_OR_ORG_INST_TYPE — Validates the institution type foreign key relationship, raising the standard message-stack exception when dependent rows exist.
• GET_FK_IGS_OR_ORG_IN_CTLTYP — Validates the institution control type foreign key, applying the same message-stack and exception pattern.

Tables Accessed

The package reads the IGS_OR_INSTITUTION table exclusively. Every documented routine issues a SELECT against this table (returning ROW_ID) to establish existence of a primary key value or to detect dependent rows for a foreign key column. No INSERT, UPDATE, or DELETE statements are present in the surviving code; all DML on this entity is delegated to TCA table handlers. The package is referenced by ten other packages within the Oracle Student System, indicating it functions as a shared validation utility layer rather than a transactional API.

Usage Notes

These routines are not invoked directly by end users. They are called programmatically from forms, concurrent programs, and custom PL/SQL that must confirm institution existence before processing, or that must enforce foreign key integrity when maintaining related reference data such as government institutions, institution statuses, institution types, and control types. Because the functions communicate failure through FND_MESSAGE and App_Exception rather than return codes, callers should invoke them within a normal exception-handling block. In 12.1.1 and 12.2.2 environments the package remains an APPS-owned dependency; customization should avoid modifying it and instead wrap calls in a local package so that future patching of IGSOI02B.pls is not disrupted.