Search Results igs_gr_gen_001




Overview
Explore in AI Chat

Overview

IGS_GR_GEN_001 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Higher Education / Student Systems family (the IGS_ prefix denotes the Student Information / Graduation and Awards modules associated with Oracle Student System). The package is documented in ETRM as an OTHER-classified API, meaning it is not published as a formally supported public interface but is exposed for internal use by related graduation and award processing components. Its central role is to support graduation award ceremony and graduation audit processing: maintaining graduation award ceremony history, resolving graduation status and award usage titles, and returning the display names used in graduation records.

The package is byte-valid (Status: VALID) in both 12.1.1 and 12.2.2 environments, and it sits in the dependency chain between the award ceremony definition layer and downstream graduation logic packages.

Key Procedures and Functions

Six documented program units are recorded in the ETRM metadata:

  • GRDP_DEL_GAC_HIST — Deletes graduation award ceremony history rows. Used to purge or roll back historical award ceremony records associated with a graduand.
  • GRDP_DEL_GR_GAC — Deletes the graduation award ceremony association, removing the link between a graduation record and its award ceremony.
  • GRDP_GET_ACUSG_TITLE — Retrieves the award ceremony usage title, providing the descriptive label under which an award ceremony is presented.
  • GRDP_GET_GRAD_NAME — Returns the graduand or graduation name used in graduation reporting and display.
  • GRDP_GET_GR_GHL — Retrieves the graduation record (the "GR GHL" identifier), typically resolving a graduation reference for downstream processing.
  • GRDP_INS_GAC_HIST — Inserts graduation award ceremony history rows, capturing the ceremony assignment for audit and rollback purposes.

The naming convention (GRDP_ prefix) indicates the package is generated or standardised for the graduation award ceremony domain. Parameter lists are not documented in the available metadata and should be confirmed against the live package specification before direct invocation.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

  • IGS_GR_AWD_CRMN — Graduation award ceremony definitions; the primary entity the package manipulates.
  • IGS_GR_AWD_CRMN_HIST — History/audit table populated by GRDP_INS_GAC_HIST and cleaned by GRDP_DEL_GAC_HIST.
  • IGS_GR_AWD_CRM_US_GP — Award ceremony usage groupings, the source of ceremony usage titles.
  • IGS_GR_AWD_CRM_UT_ST — Award ceremony usage status, providing the state context for ceremony usage records.
  • IGS_GR_CRMN_ROUND_ALL — Ceremony round allocations, linking graduands to ceremony rounds.
  • IGS_GR_GRADUAND_ALL — The graduand master record, the subject of graduation name and award resolution.
  • IGS_GR_STAT — Graduation status codes referenced during status resolution.
  • IGS_PS_AWD — Award definitions in the programme/award structure, providing award context.

Usage Notes

IGS_GR_GEN_001 is referenced by six other packages, including IGS_AD_GEN_002, IGS_GR_GEN_002, IGS_GR_GRD_LGCY_PUB, and IGS_GR_AWD_CRMN_PKG, as well as the IGS_GR_AWD_CRM_US_GP_V and IGS_GR_CRMN_ROUND_V views. It is therefore invoked indirectly through graduation award ceremony forms and concurrent graduation processing rather than being called directly by end users. Customisations should call the higher-level wrapper packages or the public views rather than this generated package, since the GRDP_ procedures form an internal implementation layer and their signatures are not guaranteed as a supported interface across upgrades.