Results for “igs_ps_val_crv”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_VAL_CRV is a PL/SQL validation package in the Oracle E-Business Suite Student Systems (formerly Oracle Student System / Higher Education) product family, owned by the APPS schema and declared with AUTHID CURRENT_USER. In the ETRM classification it is registered as an OTHER API. Its business purpose is to centralise the business-rule validation logic applied to course versions — the versioned rows of the IGS_PS_COURSE entity that represent a specific offering of a course for a given version number and date range. The package name decomposes as IGS (Institution of Higher/Graduate Studies), PS (Product/Student System), VAL (validation), and CRV (Course version). Functionally it guards the integrity of course version data during entry and maintenance: government special course type rules, course type consistency, organisational unit system status, end-date and status relationships, expiry-date rules, status transitions, and a composite "quality" check that inspects the version and its dependent detail rows.

Key Procedures and Functions

• crsp_val_crv_gsct — Validates the government special course type associated with an IGS_PS_COURSE version. Returns Boolean and passes back a message name for the calling form to translate.
• crsp_val_crv_type — Validates the course type for a given course code and version number combination.
• crsp_val_ou_sys_sts — Confirms that the organisational unit's system status is ACTIVE as of a supplied start date, preventing course versions from being attached to inactive organisational units.
• crsp_val_crv_end_sts — Validates the relationship between the course version end date and its course status.
• crsp_val_crv_exp_sts — Validates the course version expiry date against the course status for the identified course code and version number.
• crsp_val_crv_status — Validates a proposed course status transition, comparing the new status against the old status to enforce permitted state changes.
• CRSP_VAL_CRV_QUALITY — Performs composite quality validation checks on a course version and its associated detail records, taking the old course status into account.
• CRSP_VAL_CRV_END — Validates end-of-life conditions for the course version.

All functions follow the standard Oracle Student Systems convention of returning BOOLEAN and exporting an OUT NOCOPY message name rather than raising exceptions, so callers can present translated error messages. Per the header comments, earlier members crsp_val_ver_dt and crsp_val_caw_insert were removed under Bug #1956374.

Tables Accessed

Reads are performed through APPS synonyms. The status-related tables IGS_PS_STAT and IGS_OR_STATUS supply valid course statuses and organisational status values used by the status, end-status and expiry validations. IGS_PS_GOVT_SPL_TYPE and IGS_PS_REF_CD back the government special course type check. Reference and structure tables including IGS_PS_ENT_PT_REF_CD, IGS_PS_FIELD_STUDY, IGS_PS_GRP_MBR, IGS_PS_OFR_INST, IGS_PS_ANL_LOAD_U_LN and IGS_FI_FND_SRC_RSTN are consulted during the composite quality validation of the version and its detail rows. IGS_PS_AWARD participates in award-related consistency checks.

Usage Notes

The package is invoked primarily from the Oracle Forms-based course version maintenance screens, where it is called from WHEN-VALIDATE-ITEM and pre-insert/pre-update triggers. It is also referenced by eleven other PL/SQL packages, indicating reuse inside larger course and program validation flows and possibly enrolment or award processing. The "bv gips" search that surfaced this object relates to the GIPS (Generic Interface/Institution Product) course-version user exits; developers implementing such extensions commonly call these validator functions directly to enforce the same rules as the standard forms. When calling from custom code, always supply the OUT message name and resolve it via the standard message dictionary, and note the AUTHID CURRENT_USER declaration when considering privilege and synonym resolution in a 12.1.1 or 12.2.2 environment.