Search Results crsp_val_cacus_sub

Overview

IGS_PS_VAL_CACUS is a validation package within the Oracle E-Business Suite Student System (formerly Oracle Student System, now part of the Higher Education / Student Information product line). Its naming convention places it in the IGS_PS family, where "IGS" denotes the Student System schema and "PS" typically refers to programme or prospectus-related structures. The suffix "VAL" indicates a validation package, and the source header (IGSPS13S.pls) associates it with student programme validations. As shipped in EBS 12.1.1 and 12.2.2, the package body has been reduced to an empty specification with no executable program units. The AUTHID CURRENT_USER clause confirms the package was designed to execute with the privileges of the calling user, a common convention for Student System validation routines that reference APPS synonyms.

Key Procedures and Functions

The documented metadata lists zero procedures or functions in the current version. The package header comment records that three functions were removed under Bug ID 1956374, "Removal of Duplicate Program Units from OSS." Those removed units were:

• crsp_val_cacus_sub — a validation function historically used to validate student/prospectus "CACUS" data. This is the exact identifier the user searched for. It no longer exists in the shipped package.
• crsp_val_iud_us_dtl — a validation routine associated with insert, update, and delete (IUD) operations on user/detail records.
• crsp_val_iud_crv_dtl — a validation routine associated with IUD operations on curriculum or course detail records.

No parameter lists are documented for any of these units, and no replacement signature is provided in the current release. The package now terminates immediately after the header (line 11: "END IGS_PS_VAL_CACUS;").

Tables Accessed

The ETRM metadata records no tables referenced via APPS synonyms for the current version, which is consistent with an empty package body. Historically, validation packages of this class read and wrote student programme, curriculum, and detail tables to enforce business rules during data entry and maintenance. Because no table access is documented in the shipped release, integrators should treat any table dependencies as the responsibility of replacement validation logic elsewhere in the IGS_PS validation framework.

Usage Notes

IGS_PS_VAL_CACUS is not referenced by any other package according to the metadata, and it exposes no callable API. It should not be invoked from forms, concurrent programs, or custom code in its current state; doing so would yield no validation behaviour. The original crsp_val_cacus_sub function was likely triggered during prospectus or student programme maintenance, but the Bug 1956374 consolidation relocated or eliminated that logic. Developers maintaining customisations or extensions that previously called crsp_val_cacus_sub must identify the replacement validation point in the current Student System validation layer, as direct calls to this package will fail or return without effect. The package remains in the APPS schema only for backward compatibility of the object definition.