Search Results crsp_val_um_closed

Overview

IGS_AS_VAL_NESO is a validation package within the Oracle E-Business Suite Student System (IGS) product family. It supports the Academic Support / Assessment (IGS_AS) module by enforcing business rules governing the insertion and maintenance of non-enrolled student unit attempt records. In Oracle EBS 12.1.1 and 12.2.2, the IGS_AS schema captures assessment outcomes for students who attempt units but are not necessarily enrolled in the standard institutional census. The package encapsulates the logic required to validate the creation of records in the IGS_AS_NON_ENR_STDOT entity, ensuring that only legally consistent combinations of student, course, unit, version, mark, grade, grading schema, and grade creation method reach the persistence layer.

Preserving such validation in a dedicated package isolates it from UI and concurrent processing logic, allowing the same rules to be reused across multiple front-office forms and integration channels.

Key Procedures and Functions

The package exposes a single documented program unit:

• ASSP_VAL_NESO_INS — A function that validates the insertion of an IGS_AS_NON_ENR_STDOT record. It accepts identifiers for the person, course, unit, version, mark, grade, grading schema, grading schema version, and the grade creation method type, and returns a Boolean indicating validation success. A message name output parameter is provided so that callers can retrieve a translatable message describing any failure condition. The function does not itself perform the insert; it acts as a gatekeeper called immediately before a DML operation.

The ETRM metadata records only this one program unit. The header comments confirm that earlier versions of the package also contained the functions crsp_val_um_closed and crsp_val_ucl_closed, along with orgp_val_loc_closed, but these were removed under Bug 1956374 (26-AUG-2001). Consequently, the search term crsp_val_um_closed no longer resolves to a live package member in supported releases; it represents a deprecated function that existed only in pre-11i/early 11i builds. Implementers migrating very old customizations that reference crsp_val_um_closed must instead locate the substituted validation logic elsewhere in the IGS_AS stack, as the function is not part of the shipped 12.1.1 or 12.2.2 package.

Tables Accessed

The only documented table referenced through APPS synonyms is IGS_PS_UNIT_STAT. This table stores unit attempt status information keyed against a person, unit, and version. The validation function consults it to confirm that the unit status underpinning a non-enrolled student attempt is valid and consistent before the IGS_AS_NON_ENR_STDOT row is created. Because the package declares AUTHID CURRENT_USER, all synonym resolution and privilege checks are performed against the invoking schema, which is the normal pattern for APPS-owned IGS APIs.

Usage Notes

ASSP_VAL_NESO_INS is typically invoked from Oracle Forms or OAF-based self-service pages during entry of assessment data for non-enrolled students, immediately prior to the insert of the underlying record. It may also be called from PL/SQL batch uploads, APIs, or concurrent programs that load assessment outcomes from external systems. Callers receive a Boolean result and, on failure, look up the returned message name via the standard Oracle message dictionary (FND_MESSAGE). Because the function is a pure validation routine, it should be wrapped in a conditional block that aborts the DML when the returned value is FALSE. The package is referenced by at least one other IGS package, confirming its role as a shared validation service rather than an internal helper. Custom code extending the IGS_AS module should invoke this function rather than reimplementing its rules, and should not reference the retired crsp_val_um_closed element.