Search Results igs_gr_awd_crmn_hist_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_GR_AWD_CRMN_HIST_PKG package is a VALID PL/SQL package in the Oracle E-Business Suite APPS schema. It belongs to the Oracle Student System (formerly Student Records / Higher Education) product family, specifically the Graduation (IGS_GR) module. The object name resolves into its component parts as follows: IGS (Oracle Student System), GR (Graduation), AWD (Award), CRMN (Ceremony), and HIST (History). The package therefore serves as the persistence and validation layer for the historical record of awards conferred to graduands at graduation ceremonies.

Within the Graduation subsystem, a single graduand may receive one or more awards (for example, a degree, a diploma, or a certificate), and each award is associated with a ceremony at which it is formally conferred. The IGS_GR_AWD_CRMN_HIST entity captures the point-in-time association between an award and the ceremony at which it was conferred, preserving an auditable award-to-ceremony history. This package provides the DML, locking, validation, and foreign-key helper routines that the Oracle Forms block and the surrounding Graduation APIs use to maintain that history reliably and consistently.

Key Procedures and Functions

The ETRM metadata documents ten procedures or functions in this package. They follow a consistent pattern typical of Oracle Forms-generated or Forms-supporting table-handler packages:

  • INSERT_ROW — inserts a new award/ceremony history record into the underlying table.
  • UPDATE_ROW — updates the mutable columns of an existing award/ceremony history record.
  • DELETE_ROW — removes an award/ceremony history record.
  • ADD_ROW — a convenience routine that creates a defaulted row (typically populating the primary key from its sequence) prior to the user entering detail values.
  • LOCK_ROW — issues a SELECT ... FOR UPDATE against the target row so that the Forms block can implement optimistic locking and detect concurrent modification.
  • GET_PK_FOR_VALIDATION — returns the primary key value for validation purposes, allowing the caller to confirm that the row identifier is well-formed before DML.
  • GET_UK_FOR_VALIDATION — returns the unique key value used to validate that a prospective record does not duplicate an existing award/ceremony history entry.
  • GET_FK_IGS_GR_GRADUAND — derives the foreign key reference into the graduand entity, supporting validation that the award/ceremony history record is linked to a valid graduand.
  • CHECK_CONSTRAINTS — evaluates the application-level constraint checks for the row, raising errors when mandatory or referential rules are violated.
  • BEFORE_DML — a hook invoked before insert or update to stamp audit columns (such as created/updated by and date) and to enforce pre-DML validation.

Tables Accessed

The package operates against the following documented objects, accessed through APPS synonyms:

  • IGS_GR_AWD_CRMN_HIST — the base table holding the award-to-ceremony history rows. It is the primary target of INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW.
  • IGS_GR_AWD_CRMN_HIST_GACH_ID_S — the sequence that supplies the primary key (GACH_ID) for new rows, referenced by ADD_ROW and GET_PK_FOR_VALIDATION.
  • DUAL — used for scalar validation queries and sequence retrieval where no table access is otherwise required.

Foreign-key helper logic also references the graduand entity by way of the GET_FK_IGS_GR_GRADUAND routine, which supplies the graduand identifier used to validate the relationship between a conferred award and the student record.

Usage Notes

This package is referenced by five other packages in the APPS schema, notably IGS_AD_GEN_001, IGS_EN_FUTURE_DT_TRANS, IGS_GR_GEN_001, IGS_GR_GRADUAND_PKG, and IGS_GR_PRC_GAC. That dependency pattern indicates the package is invoked both from the Graduation Oracle Forms application (where it underpins the award/ceremony history block) and from other server-side Graduation and Admissions APIs that manage graduand records and process ceremony-related transactions.

Typical invocation is from Forms triggers (POST-QUERY, WHEN-NEW-RECORD-INSTANCE, ON-INSERT, ON-UPDATE, ON-DELETE, and ON-LOCK), which delegate to the corresponding package routines. Because the documented API classification is OTHER, the package is not a published, standalone public API; it is intended for internal use. Custom code that requires this data is generally advised to call the higher-level Graduation APIs rather than the table-handler routines directly, since the routines enforce locking and audit conventions that callers must honour to avoid data corruption. As with other IGS_GR packages, it is present and valid in both Oracle EBS 12.1.1 and 12.2.2; the online patching architecture of 12.2.2 does not alter its functional behavior.