Search Results igs_gr_prc_gac




Overview
Explore in AI Chat

Overview

The package body APPS.IGS_GR_PRC_GAC belongs to the Oracle E-Business Suite Graduation Management module, a component of the Student Systems / Student Information product family. The object is classified under the ETRM repository as an OTHER API, meaning it is not a formally published public interface but rather a server-side processing package that supports graduation and award ceremony operations. Its name follows the IGS_GR prefix convention, where IGS denotes the Student System schema family and GR denotes Graduation functionality; the GAC suffix reflects its association with graduation award ceremonies.

In Oracle EBS 12.1.1 and 12.2.2, this package body encapsulates the procedural logic used to process graduand and award ceremony data. It operates within the APPS schema and is marked VALID in the ETRM metadata, indicating that it compiles successfully and its dependencies resolve correctly. The package supports ceremony lifecycle processing, closing activities for award ceremonies and academic usage records, and insertion of graduand ceremony records.

Key Procedures and Functions

The documented package exposes three procedures, each aligned to a distinct processing activity:

  • GRDP_INS_GAC — Handles insertion of graduand award ceremony records. This routine populates ceremony-related data for graduands, drawing on person, award ceremony, and ceremony history information.
  • GRDP_PRC_ACUSG_CLOSE — Performs the closing process for academic usage records associated with graduation processing. It finalizes the state of usage records tied to the ceremony or award lifecycle.
  • GRDP_PRC_AWC_CLOSE — Executes the closing process for award ceremonies. This procedure finalizes ceremony records once the associated processing is complete.

No parameter lists are documented in the ETRM metadata; callers referencing the package should consult the installed package specification (IGS_GR_PRC_GAC) for exact signatures, as the specification defines the public interface consumed by dependent objects.

Tables Accessed

The package reads and writes several graduation and student tables through APPS synonyms. The documented dependencies include IGS_GR_AWD_CRMN (award ceremony header records), IGS_GR_AWD_CRMN_HIST (ceremony history), IGS_GR_AWD_CRM_US_GP (ceremony usage group data), and IGS_GR_AWD_CRM_UT_ST (ceremony usage status). These support ceremony creation, status tracking, and closing operations.

Additional dependencies reflect broader student context: IGS_AD_LOCATION_REL provides venue and location relationships used when associating ceremonies with venues; IGS_AS_SU_SETATMPT supplies student attempt records relevant to graduand eligibility; and IGS_GR_GRADUAND along with person and venue views (IGS_PE_PERSON_BASE_V, IGS_GR_VENUE) provide the demographic and ceremonial detail required during processing.

Usage Notes

IGS_GR_PRC_GAC is a backend processing package; it is not referenced by any other database object per the documented metadata, though it participates in the dependency chain of ceremony processing forms and concurrent programs through its own package specification. Typical invocation occurs from graduation ceremony maintenance forms, award ceremony closing concurrent programs, or custom extensions that manage ceremony lifecycle events in 12.1.1 and 12.2.2.

Because the package relies on IGS_GE_MSG_STACK and FND_MESSAGE for error handling and on FND_FILE for output, it is suited to both interactive and batch execution. Implementers extending graduation functionality should call the documented procedures only in the order implied by their semantics — insertion of graduand ceremony data precedes closing activities — and verify the specification for actual argument lists before use.