Search Results igs_gr_gen_002




Overview
Explore in AI Chat

Overview

IGS_GR_GEN_002 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, operating within the Student Systems / Higher Education product family (the IGS schema prefix denotes the Oracle Student System modules). Its name and position in the dependency chain identify it as a graduation-processing utility package: the internal procedures carry the "GRDP_" prefix, indicating they belong to the Graduation Data Processing family of routines. The package supports the awarding and recording of graduand records, graduation history, and the ordering of award criteria associated with a graduand's programme of study. As documented in ETRM for release 12.1.1, the object is classified as OTHER rather than as a formally published public API, meaning it is intended principally as an internal engine called by other IGS graduation objects and by concurrent processing rather than by external integrations. Its status remains VALID in both 12.1.1 and 12.2.2, and its dependency list is entirely confined to Student System tables and Oracle-supplied infrastructure (SYS.STANDARD, DBMS_LOCK, DBMS_SQL), confirming it is a native component of the graduation subsystem rather than a customer extension.

Key Procedures and Functions

  • GRDP_INS_GRADUAND — Inserts graduand records, creating the link between a person and the graduation cycle in which they are expected to be conferred. It is the primary entry point for establishing new graduand rows.
  • GRDP_INS_GR_HIST — Inserts graduation history rows, preserving a record of graduation events for the graduand so that previously conferred awards remain auditable after further processing or amendment.
  • GRDP_PRC_GAC — Processes graduand award criteria. This is the evaluation routine that determines whether recorded award criteria are satisfied in the context of the graduand's award and course enrolment.
  • GRDP_SET_GR_GST — Sets the graduation status value, applying the appropriate status code to the graduand or graduation record.
  • GRDP_UPD_GAC_ORDER — Updates the ordering of graduand award criteria, controlling the sequence in which criteria are considered or presented.

Tables Accessed

The package reads and writes the core graduation and programme tables. IGS_GR_GRADUAND_ALL is the central graduand table into which GRDP_INS_GRADUAND writes. IGS_GR_STAT and IGS_GR_APRV_STAT supply graduation status and approval status codes referenced by GRDP_SET_GR_GST. IGS_PS_AWD and IGS_PS_COURSE (together with IGS_PS_AWARD) provide the award and course definitions required for award-criteria evaluation, while IGS_GR_AWD_CRMN, IGS_GR_AWD_CRM_US_GP, IGS_GR_CRM_ROUND_PRD and IGS_EN_SPA_AWD_AIM hold the award criterion, grouping and rounding-period rules manipulated by GRDP_PRC_GAC and GRDP_UPD_GAC_ORDER. IGS_AD_LOCATION_ALL is accessed for location details associated with the graduand record. FND_NEW_MESSAGES is used for message retrieval, and DBMS_LOCK and DBMS_SQL are employed for concurrency control and dynamic SQL respectively.

Usage Notes

IGS_GR_GEN_002 is invoked by IGS_GR_GRADUAND_PKG, which depends on it, and it is also referenced recursively, indicating internal calls between its own procedures during multi-step graduation processing. Typical invocation occurs from the Oracle Student System graduation forms and from concurrent programs that build graduand cohorts, apply graduation statuses, and evaluate award criteria in batch. Because the package is not exposed as a public API, customisations should call the documented wrapper packages (such as IGS_GR_GRADUAND_PKG) rather than this package directly, ensuring that locking and history-recording behaviour remain consistent across releases 12.1.1 and 12.2.2.