Search Results crsp_val_crs_ci

Overview

IGS_PS_VAL_COP is a validation package within the Oracle Student System (formerly Oracle iLearning / Oracle Student Administration) schema, owned by APPS and classified as an "OTHER" API in the ETRM 12.1.1 metadata. Its business purpose is to centralise validation logic for course offering data, ensuring that records conform to institutional rules before they are committed to the underlying IGS tables. The package header identifies it as an AUTHID CURRENT_USER unit, meaning it executes with the privileges of the calling schema — standard practice for APPS-owned validation routines invoked from forms, concurrent programs, or other PL/SQL units.

The source header reflects the package's long evolution. It carries a revision marker of 115.4 2002/11/29 and a change history documenting the removal of several procedures and functions under Bug No. 1956374 (August 2001). Specifically, the function declaration genp_val_staff_prsn was removed, and the procedures crsp_val_Crs_ci and crsp_val_ent_ass_scr were deleted, with the procedure assp_val_gs_cur_fut also removed under the same bug. These historical removals explain why a search for crsp_val_crs_ci returns no live implementation: the identifier no longer exists in the shipped 12.1.1 / 12.2.2 package body.

Key Procedures and Functions

• CRSP_VAL_COO_INACTIV — The single documented function remaining in the package. Its name indicates validation of course offering option ("COO") activity status. It accepts contextual parameters describing the course code, version number, calendar type, location code, attendance mode, and attendance type, and returns a BOOLEAN result. It also exposes an OUT p_message_name parameter (declared NOCOPY) that carries a message name for error reporting when validation fails. The function validates that a given IGS_PS_COURSE Offering Option is active and is not marked inactive, allowing the calling application to block or flag invalid offerings.

No other procedures or functions are documented in the 12.1.1 metadata. The removed identifiers — crsp_val_Crs_ci, crsp_val_ent_ass_scr, genp_val_staff_prsn, and assp_val_gs_cur_fut — are no longer part of the package surface.

Tables Accessed

The ETRM metadata for this object records no directly referenced tables via APPS synonyms. In practice, validation packages of this type query the base IGS tables corresponding to their parameters — such as course offering and course option definition tables — to determine whether a record is active or inactive. Because the package is compiled AUTHID CURRENT_USER, any table references resolve through the calling schema's synonyms rather than being hard-coded in the header. Implementers should therefore confirm actual table dependencies by inspecting the package body (not exposed in this metadata extract) rather than by assuming a synonym list.

Usage Notes

IGS_PS_VAL_COP is referenced by two other packages, indicating it is a dependent validation utility rather than a top-level entry point. Typical invocation is from PL/SQL forms or APIs that manage course offerings, where the caller executes CRSP_VAL_COO_INACTIV prior to insert or update, then inspects the returned BOOLEAN and the p_message_name output to raise an appropriate user message. Custom code should not rely on the removed procedures historically listed in the change history, as they are absent from the shipped 12.1.1 and 12.2.2 versions; any legacy customisation calling crsp_val_crs_ci will fail to compile and must be re-pointed to the supported validation entry point or to the underlying IGS API.