Search Results create_graduand

Overview

IGS_GR_GRD_LGCY_PUB is a public PL/SQL package body owned by APPS in the Oracle E-Business Suite higher-education data model. Its business purpose is to process legacy graduation records and convert them into canonical graduand records within the Student Records (IGS) schema — most notably the area that manages graduands, awards, and graduation status. The package acts as a published API layer over the underlying legacy graduation interface, shielding callers from the internal steps required to validate, derive, and persist graduand data.

The header comment records that the package was created on 11-Nov-2002 by Manu Srinivasan and modified on 03-Jan-2003 by Kalyan Dande, who changed the create_graduand message name to IGS_AV_UNHANDLED_ERROR. The package is classified as PUB (public API) within the ETRM documentation, and it is referenced by one other package.

Key Procedures and Functions

The documentation identifies a single top-level documented procedure, CREATE_GRADUAND, which is the primary reason the package is invoked. Additional internal helper functions are declared in the source: VALIDATE_PARAMETERS, DERIVE_GRADUAND_DATA, VALIDATE_GRAD_DB_CONS, and VALIDATE_GRADUANDS.

• CREATE_GRADUAND — Creates or advances the graduand record from the supplied legacy graduation data. It is the entry point called by external consumers.
• VALIDATE_PARAMETERS — Performs preliminary validation of the incoming legacy graduation record before processing proceeds.
• DERIVE_GRADUAND_DATA — Derives the person, calendar instance, sequence number, and proxy-award attributes needed to build the graduand record.
• VALIDATE_GRAD_DB_CONS — Validates database-level consistency constraints for the graduand record.
• VALIDATE_GRADUANDS — Validates the graduand data against the person and calendar instance context.

Tables Accessed

The package references the following tables via APPS synonyms:

• IGS_GR_LGCY_GRD_INT — the legacy graduation interface table that supplies the inbound record to be processed.
• IGS_GR_GRADUAND_ALL — the graduand entity where derived and validated data is written or compared.
• IGS_GR_APRV_STAT and IGS_GR_STAT — graduation approval and status reference tables used to resolve or validate the graduand status.
• IGS_PS_AWD — the award definition used during derivation and validation of award context.
• IGS_PS_STDNT_APV_ALT — the student award/approval alternative used in the graduand validation logic.
• FND_NEW_MESSAGES — accessed to obtain or resolve error and message text surfaced through the API's message stack.

Usage Notes

IGS_GR_GRD_LGCY_PUB is invoked during legacy graduation data conversion and processing, typically from custom PL/SQL programs, concurrent programs, or migration scripts that load rows into IGS_GR_LGCY_GRD_INT and need them converted into standard graduand records. Callers should supply the standard API parameters documented in the header — p_api_version, p_init_msg_list, p_commit, p_validation_level, and p_lgcy_grd_rec, with x_return_status, x_msg_count, and x_msg_data returned for error handling.

When errors occur, the package reports through the message stack; the 03-Jan-2003 modification changed the create_graduand error message name to IGS_AV_UNHANDLED_ERROR. Because the package is documented as public and referenced by one other package, it should be treated as a supported integration point rather than modified directly. As with all ETRM 12.1.1/12.2.2 public APIs, callers should check x_return_status and iterate the message stack before committing.