Search Results igs_gr_crmn_round_pkg




Overview
Explore in AI Chat

Overview

IGS_GR_CRMN_ROUND_PKG is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite, specifically within the Student System (IGS) product family used by higher education institutions. The prefix "IGS_GR_CRMN_ROUND" identifies this package as part of the Graduation Management (GR) module, more precisely the "Cohort Round" (CRMN_ROUND) functionality. In this context, a "round" represents a processing instance — typically a graduation round, ceremony round, or academic awarding round — through which a cohort of graduands is evaluated, confirmed, and progressed toward the conferral of an award. This package encapsulates the business logic and low-level data manipulation routines required to create, maintain, and validate records in the underlying cohort round entity. It sits within the generation layer of ETRM's package architecture, meaning it is an internal implementation package rather than a public API. Its primary role is to support the persistence and integrity of cohort round data against the IGS_GR_CRMN_ROUND_ALL table, adhering to Oracle Forms' standard transactional model through the DML sequence of insert, lock, update, and pre-insert validation logic.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions within this package. Their names follow the conventional Oracle EBS Forms-generated package pattern, where each routine supports a discrete part of the record maintenance lifecycle:

  • INSERT_ROW — Performs the physical insert of a new cohort round record into the base table.
  • LOCK_ROW — Issues the row-level lock (SELECT FOR UPDATE) to guarantee exclusive access during an update, supporting optimistic concurrency.
  • UPDATE_ROW — Applies modifications to an existing cohort round record, persisting changed attributes.
  • ADD_ROW — Provides the higher-level "create" entry point that orchestrates pre-insert setup and then invokes INSERT_ROW.
  • GET_PK_FOR_VALIDATION — Retrieves or derives the primary key value used to validate uniqueness and referential integrity of the record.
  • GET_FK_IGS_CA_INST — Resolves the foreign key to the institution/calendar instance (IGS_CA_INST) that owns or relates to the round.
  • GET_FK_IGS_CA_DA_INST — Resolves the foreign key to the detailed institution/calendar instance (IGS_CA_DA_INST).
  • CHECK_CONSTRAINTS — Validates business and database constraints prior to committing changes.
  • BEFORE_DML — The standard Forms trigger routine invoked before insert or update to set WHO columns and enforce consistency.

Tables Accessed

The package's documented data access centres on the APPS synonym IGS_GR_CRMN_ROUND_ALL. This is the base table storing cohort round records, holding identifiers, round descriptors, and foreign-key references to institutional calendar instances. The "_ALL" suffix indicates a multi-organisation-enabled table, meaning rows are partitioned by operating unit and filtered by the associated institution context. The foreign-key resolution routines (GET_FK_IGS_CA_INST and GET_FK_IGS_CA_DA_INST) indicate dependencies on the calendar instance tables, although those tables are accessed indirectly through the FK lookups rather than being listed as direct table references. The sole explicit dependency at the database level is the SYS.STANDARD package, implying minimal external library reliance and confirming the package operates as a tightly scoped data-access layer.

Usage Notes

IGS_GR_CRMN_ROUND_PKG is not intended for direct invocation by end users or external integrations. Instead, it is referenced by seven higher-level packages — IGS_CA_DA_INST_PKG, IGS_CA_INST_PKG, IGS_GR_AWD_CRMN_PKG, IGS_GR_CRMN_PKG, IGS_GR_CRM_ROUND_PRD_PKG, IGS_GR_GRADUAND_PKG, and IGS_GR_GRD_LGCY_PUB — which together manage award ceremonies, graduand processing, and legacy graduation logic. These callers invoke the package either directly or as part of the Oracle Forms transactional framework, where the AUTOCOMMIT-independent DML routines drive insert/update/delete operations behind a graduation management form. Typical invocation occurs when a user creates or amends a cohort round within the graduation setup, or when a concurrent program processes graduands through the awarding lifecycle. Customisations should avoid calling this package directly and instead use the documented public APIs of the referencing packages, preserving upgrade safety across Oracle EBS 12.1.1 and 12.2.2.