Search Results crsp_val_coo_inactiv




Overview
Explore in AI Chat

Overview

IGS_PS_VAL_COP is a validation package body in the Oracle EBS Student System (formerly Oracle Student System / OSS), owned by the APPS schema. Its role is to centralize cross-entity validation logic for course offering options within the institution's academic structure. Specifically, the package verifies that the components referenced by a course offering option — the course version, the calendar type, the location code, the attendance mode, and the attendance type — are all in a valid, active state before a transaction is allowed to proceed.

The package name follows the IGS (Institution of Higher/Graduate Studies) naming convention and the "VAL" prefix, indicating it is a validation utility. The "_COP" suffix aligns the package with the course offering/offering-option domain. It is classified in ETRM as an OTHER API, meaning it is not a public, supported interface but an internal validation routine invoked by other application logic. The header comment dates the source to the 11i era (Header revision 115.5, 2002), and the object remains present in the 12.1.1 and 12.2.2 ETRM repositories.

Key Procedures and Functions

The documented metadata lists a single callable unit:

  • CRSP_VAL_COO_INACTIV — A boolean-returning function that validates whether a course offering option is inactive or otherwise invalid. It is the core validation entry point of the package. Based on the source excerpt, it accepts the course code, version number, calendar type, location code, attendance mode, and attendance type as inputs, plus an OUT parameter that carries a message name for error reporting. It returns TRUE when all constituent checks pass and FALSE when any single check fails.

The function performs a sequential series of validation calls, returning FALSE immediately upon the first failure:

  • It calls IGS_PS_VAL_CRS.crsp_val_iud_crv_dtl to detect an inactive course version.
  • It calls IGS_CA_GEN_002.CALP_VAL_CI_CAT to detect a closed calendar type.
  • It calls IGS_PS_VAL_UOO.crsp_val_loc_cd to detect a closed location code. The change history notes this call replaced IGS_PS_VAL_COO.crsp_val_loc_cd as part of bug fix 1956374.
  • It calls IGS_PS_VAL_COO.crsp_val_coo_am to detect a closed attendance mode.
  • It calls IGS_PS_VAL_COO.crsp_val_coo_att to detect a closed attendance type.

The change history also records that a function named genp_val_staff_prsn was removed under the same bug fix, narrowing the package's scope to course offering option validation.

Tables Accessed

The ETRM metadata does not explicitly enumerate tables referenced through APPS synonyms; the package logic is delegated to the child validation packages listed above. The implicit data domains are the course version records (IGS_PS_VER), calendar type definitions (IGS_CA_*), location codes (IGS_AD_LOCATION), and attendance mode/type reference data. The package itself reads validation state indirectly via these dependent packages rather than issuing direct DML.

Usage Notes

CRSP_VAL_COO_INACTIV is invoked when a user creates or updates a course offering option, typically from an Oracle Forms-based maintenance screen in the Student System, or from a concurrent program performing bulk validation or data loading. Because it is classified as an internal (OTHER) API, custom code should call it only with awareness of its boolean return convention and message-name OUT parameter. The function is referenced by two other packages in the ETRM repository, confirming it is a shared validation dependency. Callers must pass the OUT message name and inspect it to surface a meaningful error to the end user when the function returns FALSE.