Search Results crsp_val_loc_cd

Overview

IGS_PS_VAL_UOO is a PL/SQL validation package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API type. The package belongs to the Student Systems / Higher Education product family, indicated by the IGS (Integrated Graduate Studies) prefix, and specifically serves the Students/Programs subsystem dealing with Unit Offering Options (UOO). Its core business function is to provide reusable validation routines that verify the correctness and consistency of data associated with unit offering options and course offerings before records are inserted or updated in the underlying base tables.

The source header identifies the package as schema-level code authored with AUTHID CURRENT_USER, and the change history references Bug No. 1956374, during which several declarations were added, modified, or removed — most notably the addition of a pragma for the crsp_val_loc_cd function and the removal of the genp_val_staff_prsn and assp_val_gs_cur_fut elements.

Key Procedures and Functions

• CRSP_VAL_LOC_CD — Validates the IGS_AD_LOCATION code associated with an IGS_PS_COURSE record. This is the function most closely matching the user's search term "crsp_val_loc_cd." It carries the pragma restrict_references(..., wnds) assertion, meaning it writes no database state and is therefore safe to call from read-consistent contexts such as SQL statements or pure validation blocks.
• CRSP_VAL_UOO_UC — Validates the IGS_PS_UNIT class value supplied for an IGS_PS_UNIT offering option, ensuring the class code is permissible for the offering option record.
• CRSP_VAL_UOO_CONTACT — Validates that the IGS_PS_UNIT contact person for a unit offering option is a legitimate staff member, accepting a person identifier for verification.
• CRSP_VAL_UOO_INACTIV — Validates that a given IGS_PS_UNIT Offering Option is active, taking unit code, version number, calendar type, CI sequence number, location code, and unit class as its identifying inputs.

Each function returns a BOOLEAN status and emits a message name through an OUT parameter, following the established Oracle Higher Education validation pattern that separates a success flag from a translatable message key.

Tables Accessed

The only documented table referenced by this package through APPS synonyms is HZ_PARTIES. Access is required to satisfy the staff-member validation logic in CRSP_VAL_UOO_CONTACT, which must confirm that a supplied person identifier corresponds to a valid party record. This indirect use of the TCA (Trading Community Architecture) party model reflects the integration of Student Systems person data with the central Oracle EBS party registry. Additional base tables such as IGS_PS_UNIT and IGS_AD_LOCATION are implied by the validation targets, but only HZ_PARTIES is formally documented in the ETRM metadata.

Usage Notes

IGS_PS_VAL_UOO is not an end-user-facing API. It is a supporting validation library invoked by Oracle Student System forms, concurrent programs, and other PL/SQL packages during the entry, import, or maintenance of unit offering option data. The ETRM records that it is referenced by 17 other packages, confirming its role as a shared utility called throughout the Student Systems module. Customizations and extensions that insert or update unit offering options should call these functions to enforce the same validation rules applied by seeded Oracle code, rather than duplicating validation logic. Because CRSP_VAL_LOC_CD is pragma-restricted with wnds, it may be safely embedded in SQL and read-only contexts where mutation of package state would be inappropriate.