Search Results v_check

Overview

IGS_PS_VAL_GFOS is a validation package body owned by the APPS schema within the Oracle E-Business Suite Higher Education / Student System product family (the IGS module). Its documented purpose is to validate updates made to a government field of study record, ensuring that the data integrity rules governing government field of study maintenance are enforced before a record is committed. The package is classified as OTHER under its API classification, indicating that it is an internal validation utility rather than a published, externally supported API. In EBS 12.1.1 and 12.2.2 deployments, packages of this type are typically invoked by the forms and business logic layers of the Student System to guard against invalid state transitions on setup and reference data.

Key Procedures and Functions

The package exposes a single documented function:

• CRSP_VAL_GFOS_UPD — Validates the update of a government field of study record. Its role is to determine whether a proposed change to a government field of study is permissible given the current state of related field-of-study data. Notably, the source reveals the local variable referenced in the user's search term: v_check CHAR; is a work variable used to detect whether any open (non-closed) field-of-study records reference the government field of study in question. When the update requests that the government field of study be closed, the function checks for surviving open field-of-study rows; if any exist, it returns a failure outcome and signals the message name IGS_PS_CANCLS_GOVT_FOS. When no conflicting open rows are found, the function returns success and clears the message name. An exception handler traps unexpected errors and routes them through the standard IGS message stack (IGS_GE_UNHANDLED_EXCEPTION), attaching the token NAME set to IGS_PS_VAL_GFOS.CRSP_VAL_GFOS_UPD before re-raising via App_Exception.Raise_Exception.

Tables Accessed

The package queries one documented table through its APPS synonym:

• IGS_PS_FLD_OF_STUDY — Read during the validation to determine whether any non-closed (closed_ind = 'N') field-of-study records are associated with the government field of study being updated. The cursor selects an existence marker constrained by govt_field_of_study and the open status of the field-of-study record.

The package performs read-only validation; no inserts, updates, or deletes are documented.

Usage Notes

IGS_PS_VAL_GFOS is an internal validation layer intended to be called by the Student System forms and by the business logic that governs government field of study setup. Because the only documented routine returns a boolean outcome plus a message name, callers are expected to inspect the return value and surface the resulting message name through the standard IGS message infrastructure when validation fails. The v_check variable is an implementation detail of the existence check rather than a public interface element. One other package references this package, confirming it is a dependency within the IGS validation set rather than a standalone entry point. Customizations should not modify this package directly; extensions should be built around the documented behavior or the underlying data rules. As with all APPS-owned IGS packages, behavior may differ across 12.1.1 and 12.2.2 patch levels, so version-specific testing is advisable before relying on the package in custom code.