Search Results igs_gr_grd_lgcy_pub




Overview
Explore in AI Chat

Overview

The APPS.IGS_GR_GRD_LGCY_PUB package is a public (PUB) PL/SQL API belonging to the Oracle E-Business Suite Student Systems / Graduation Management product family. In EBS 12.1.1 and 12.2.2, the IGS schema is the legacy Student System schema, and this particular package bridges the legacy graduation data model with the current graduand processing logic. Its name — IGS_GR_GRD_LGCY_PUB — decomposes as IGS (Student System), GR (Graduation), GRD (Graduand/Graduation Result), and LGCY (Legacy), indicating that it exposes a public interface for migrating or synchronising legacy graduand records into the institution's graduation tables.

The package is recorded in the ETRM repository with a VALID status and an API classification of PUB, meaning it is intended to be called by external components — concurrent programs, other packages, or custom extensions — rather than being an internal helper. Its primary business purpose is to accept legacy graduand data sitting in an interface table and to validate, approve, and create formal graduand records in the operational graduation tables. This supports institutions that maintain historical graduation data in legacy formats and need to reconcile it with the live Oracle Student System.

Key Procedures and Functions

The ETRM metadata documents a single public program unit within this package:

  • CREATE_GRADUAND — The sole documented procedure. It is the public entry point that consumes a legacy graduand record (sourced from the interface table) and creates the corresponding graduand entry in the graduation tables. While the exact parameter list is not exposed in the supplied metadata and should not be assumed, the procedure is understood to accept identifying keys for the student, award, and legacy record, together with any graduation status values needed to persist the graduand. The presence of FND_API in the dependency list indicates that the procedure follows the standard Oracle API programming conventions, including the FND_API.G_MISS_*, FND_API.G_RET_STS_SUCCESS/ERROR, and the x_return_status, x_msg_count, x_msg_data error-handling triplet.

Tables Accessed

Based on the documented dependencies, IGS_GR_GRD_LGCY_PUB reads and writes the following tables via APPS synonyms:

  • IGS_GR_LGCY_GRD_INT — the legacy graduand interface (staging) table; the source of incoming records.
  • IGS_GR_GRADUAND_ALL — the core graduand table; the primary target of the create operation.
  • IGS_GR_APRV_STAT — approval status reference data, used to set or validate the graduand's approval state.
  • IGS_GR_STAT — graduation status reference data, used to derive the graduand's status.
  • IGS_PS_AWD — the student award/programme award table, providing award context for the graduand.
  • IGS_PS_STDNT_APV_ALT — student approval/alternate data, used to validate eligibility context.
  • FND_NEW_MESSAGES — the Oracle Application Object Library message table, accessed for error and validation messaging during API processing.

Usage Notes

As a PUB API, IGS_GR_GRD_LGCY_PUB is not intended for direct table manipulation; it should be invoked through its documented procedure to preserve data integrity and messaging behaviour. The dependency listing shows it is referenced by IGS_GR_GRD_LGCY_PUB itself (recursive body reference) and by IGS_EN_LGCY_PRC, indicating that a legacy enrolment processing package calls it as part of a broader bulk-processing routine. Typical invocation paths include custom concurrent programs that load legacy graduation extracts into IGS_GR_LGCY_GRD_INT and then call CREATE_GRADUAND per record, and custom PL/SQL that wraps the call with standard FND_API return-status handling. Consult the specific package body and the caller IGS_EN_LGCY_PRC for the exact signature before integrating. Oracle proprietary and confidential — refer to the ETRM and Legal Notices for authoritative detail.