Search Results igs_ps_val_co

Overview

IGS_PS_VAL_CO is a validation package belonging to the Oracle Student System (formerly Oracle iLearning / Higher Education) product family within Oracle E-Business Suite. The suffix IGS_PS identifies it as part of the Student Systems "PS" (Programs and Schedules, or Planned Course) validation layer, while the trailing CO denotes that the package is specifically concerned with Course Offering records. In the terminology of the product, a "Course Offering" is a calendared instance of an academic course, tied to a specific calendar type and academic period.

The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the APPS schema, and it is registered under owner APPS with an API classification of OTHER. It exposes a single public program unit whose sole responsibility is to validate the calendar type associated with a course offering, returning a Boolean success indicator and an out-bound message name that callers can use to surface a user-facing error. The package header carries a revision tag of version 115.3, dated November 2002, indicating that it is a long-standing, stable component of the Student System's validation framework.

Key Procedures and Functions

• CRSP_VAL_CO_CAL_TYPE — the single documented function in the package. Its stated purpose, per the embedded comment, is to "Validate IGS_PS_COURSE Offering Calendar Type." It returns a BOOLEAN indicating whether the supplied calendar type is valid for the course offering context. It also returns an out-bound p_message_name parameter (declared OUT NOCOPY VARCHAR2) that carries the name of a message to be displayed when validation fails. Callers are expected to check the Boolean return value and, when FALSE, retrieve the corresponding message text using the returned message name. The function is used as a guard before a course offering is created, updated, or associated with a calendar type, ensuring referential and business-rule consistency.

Tables Accessed

• IGS_CA_TYPE — accessed through an APPS synonym. This is the Calendar Type reference table, which maintains the set of valid calendar types (for example, academic year, semester, term). CRSP_VAL_CO_CAL_TYPE reads this table to confirm that the calendar type passed into the function exists and is enabled before allowing the course offering operation to proceed. The lookup is read-only in nature, consistent with a validation package.

Usage Notes

IGS_PS_VAL_CO is a low-level validation utility rather than a user-facing API. It is not intended to be called directly from Oracle Forms or concurrent programs in the normal course of business; instead, it is invoked by higher-level Student System packages that orchestrate the creation and maintenance of course offerings. The ETRM metadata records that the package is referenced by five other packages, reflecting its role as a shared validator in the Course Offering processing chain.

Custom or extension code that programmatically inserts or updates Course Offering rows should mirror the standard behavior by calling CRSP_VAL_CO_CAL_TYPE before committing, checking the returned Boolean, and using p_message_name to raise a meaningful error. Because the package is compiled with AUTHID CURRENT_USER, callers must have appropriate privileges on IGS_CA_TYPE and on the IGS_PS_VAL_CO object itself. The package is present and unchanged across EBS 12.1.1 and 12.2.2, so customizations written against the 12.1.1 release remain compatible after an upgrade to 12.2.2.