Search Results grdp_val_hl_closed
Overview
IGS_GR_VAL_GR is a PL/SQL validation package in the APPS schema belonging to the Oracle Student System (formerly Oracle iLearning/Student System) graduation processing module, used in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name reflects its role: "IGS" identifies the Student System product, "GR" denotes the Graduation and Awards functionality, and "VAL" indicates that the package is responsible for validation logic. The package encapsulates the business rules applied to graduation applications, graduand records, award eligibility, and encumbrance effectivity before data is committed to the database.
Within the graduation workflow, records pass through status transitions (application, approval, award, conferral). IGS_GR_VAL_GR provides the reusable validation routines invoked by the higher-level graduation processing packages to ensure that only consistent, rule-compliant records are accepted. The dependency metadata classifies this package as an "OTHER" API object, meaning it is intended primarily for internal use by Oracle's delivered graduation programs rather than as a public integration interface.
Key Procedures and Functions
The ETRM repository documents seventeen procedures and functions within this package. Representing the validation core are:
- GRDP_VAL_GR_RQRD — validates mandatory attributes on the graduation record.
- GRDP_VAL_GR_TYPE — validates the graduation record type against permitted values.
- GRDP_VAL_GR_CRD_CI — validates credit and course-instance related data for the graduand.
- GRDP_VAL_GR_SCA — validates the student course attempt / award component association for the graduation record.
- GRDP_VAL_GR_GST and GRDP_VAL_GR_GAS — validate graduand status and graduand award status respectively.
- GRDP_VAL_GR_CAW and GRDP_VAL_GR_SUR_CAW — validate the award (course award) associated with the graduand and its surrogate reference.
- GRDP_VAL_GR_PROXY — validates proxy or substitute attendance arrangements for the graduation record.
- GRDP_VAL_GR_UNIQUE — enforces uniqueness constraints on a graduation record to prevent duplicates.
- GRDP_VAL_GR_IU and GRDP_VAL_GR_UPD — drive insert/update validation for graduation records.
- GRDP_VAL_AW_ELIGIBLE — determines whether a graduand is eligible to receive a particular award.
- GRDP_VAL_GAS_CLOSED, GRDP_VAL_GST_CLOSED, and GRDP_VAL_HL_CLOSED — check whether graduation award status, graduand status, or holding records are closed and therefore not amendable.
- ENRP_VAL_ENCMB_EFCT — validates encumbrance effectivity linked to person records relevant to graduation eligibility.
Tables Accessed
The package reads and validates against the following objects, referenced through APPS synonyms: HZ_PARTIES (person-party identity), IGS_GR_GRADUAND_ALL and IGS_GR_GRADUAND_V (base and view of graduand records), IGS_GR_STAT and IGS_CA_STAT (graduand and course attempt statuses), IGS_GR_APRV_STAT (approval status), IGS_GR_AWD_CRMN (award conferment), IGS_CA_TYPE (course attempt types), IGS_PS_COURSE (course definition), IGS_EN_ENCMB_EFCTTYP (encumbrance effectivity types), IGS_PE_PERSENC_EFFCT and IGS_PE_PERS_ENCUMB (person encumbrance records), IGS_PE_ALTERNATV_EXT (person alternative identifiers), and IGS_PS_STDNT_APV_ALT (student alternative records). These tables supply the reference, status, and eligibility data required for the validation rules.
Usage Notes
IGS_GR_VAL_GR is invoked indirectly rather than directly by end users. The dependency metadata shows that IGS_GR_GEN_002 (graduation conferral generation), IGS_GR_GRADUAND_PKG (graduand maintenance), and IGS_GR_GRD_LGCY_PUB (graduation legacy public API) reference this package, and the package references itself (recursive validation calls). In practice these routines execute when graduation records are entered, updated, or processed through the graduation form and concurrent programs such as award conferral. Sites customizing graduation behavior should follow Oracle's API guidance rather than calling these procedures directly, because parameter interfaces are internal and may change between point releases.