Search Results get_fk_igs_gr_venue




Overview
Explore in AI Chat

Overview

IGS_GR_CRMN_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) with an API classification of OTHER. The "IGS" prefix identifies it as belonging to the Oracle Student System (formerly Oracle Higher Education), while the "GR" component associates it with the Graduation functional area and "CRMN" denotes Ceremony. The package therefore serves as the core table-handling API for graduation ceremony records—the events at which awards and degrees are formally conferred. Its eleven documented procedures provide the standard insert, update, delete, lock, and validation operations required to maintain ceremony master data. It is referenced by five other packages, confirming its role as a foundational dependency within the graduation module.

Key Procedures and Functions

The documented program units fall into three groups:

  • DML procedures: INSERT_ROW, UPDATE_ROW, DELETE_ROW, and ADD_ROW perform the core create, modify, and remove operations against ceremony records. ADD_ROW typically combines insertion logic with prerequisite handling, while DELETE_ROW removes an existing ceremony record.
  • Concurrency and validation: LOCK_ROW enforces optimistic locking on a ceremony record before it is modified, preventing concurrent update conflicts. BEFORE_DML and CHECK_CONSTRAINTS execute pre-DML processing and integrity validation respectively. GET_PK_FOR_VALIDATION retrieves the primary key needed to validate a ceremony row, supporting referential integrity checks by dependent packages.
  • Foreign key resolvers: GET_FK_IGS_CA_DA_INST, GET_FK_IGS_GR_CRMN_ROUND, and GET_FK_IGS_GR_VENUE return the foreign key values linking a ceremony to its associated institution, ceremony round, and venue. These accessors allow calling packages to resolve parent keys without duplicating query logic.

Tables Accessed

The sole documented base table accessed by this package is IGS_GR_CRMN_ALL (via its APPS synonym). The "_ALL" suffix indicates the table holds all ceremony records across operating units, consistent with a multi-organization graduation model. INSERT_ROW, ADD_ROW, and UPDATE_ROW write to this table, DELETE_ROW removes rows, LOCK_ROW selects for update, and the GET_FK functions read foreign key columns. The GET_FK_IGS_GR_CRMN_ROUND and GET_FK_IGS_GR_VENUE procedures imply that ceremony records carry references to a ceremony round entity and a venue entity, whose keys this package surfaces to callers.

Usage Notes

IGS_GR_CRMN_PKG is an internal server-side API rather than an end-user-facing interface. It is invoked indirectly through higher-level packages: IGS_GR_AWD_CEREMONY_PKG, IGS_GR_CRMN_NOTE_PKG, IGS_GR_CRMN_ROUND_PKG, IGS_GR_VENUE_PKG, and IGS_CA_DA_INST_PKG all reference it. For example, the ceremony round and venue packages rely on it to resolve foreign keys, while the award ceremony package uses its DML procedures to manage ceremony records. It may be called from Student System forms, concurrent programs, or custom PL/SQL that maintains ceremony data. The package also references itself, indicating internal recursive or shared helper calls. Because it depends only on SYS.STANDARD, it carries no dependency on other application packages and is therefore low-risk as a foundational layer. Customizations should call the documented procedures rather than issuing direct DML against IGS_GR_CRMN_ALL, so that locking, validation, and constraint logic remain intact.