Search Results igs_gr_awd_ceremony_pkg




Overview
Explore in AI Chat

Overview

The package body APPS.IGS_GR_AWD_CEREMONY_PKG is the compiled PL/SQL implementation that supports maintenance of award ceremony records within the Oracle E-Business Suite (EBS) Student System / Graduation and Awards (IGS) product family. In both Oracle EBS 12.1.1 and 12.2.2, this object resides in the APPS schema, holds a status of VALID, and is not referenced by any other database object, indicating it functions as a top-level procedural entry point rather than an internal helper for a larger dependency chain. Its API classification is documented as OTHER rather than a standard interface or concurrent processing API, which is consistent with a package built primarily to service the Award Ceremony maintenance form and its associated DML processing.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions within this package. Their names follow Oracle Forms-generated Table Handler naming conventions, indicating the package was produced from a Forms block tied to the IGS_GR_AWD_CEREMONY base table:

  • INSERT_ROW — Inserts a new award ceremony row into the underlying table.
  • LOCK_ROW — Acquires a row-level lock on the selected award ceremony record, typically invoked before an update or delete to prevent concurrent modification.
  • UPDATE_ROW — Applies changes to an existing award ceremony record.
  • ADD_ROW — Initialises a new row, populating default and derived values prior to insertion.
  • DELETE_ROW — Removes an award ceremony record.
  • GET_PK_FOR_VALIDATION — Retrieves primary key values used by the validation framework.
  • GET_UK_FOR_VALIDATION — Retrieves unique key values used during uniqueness validation.
  • GET_FK_IGS_GR_CRMN — Retrieves the foreign key linking the ceremony to the associated ceremony master record.
  • BEFORE_DML — Central pre-DML routine that enforces business rules, derives attribute values (such as the AWC_ID from the sequence) and populates the standard WHO columns via FND_GLOBAL before insert, update or delete.
  • CHECK_CONSTRAINTS — Validates the row against database and business constraints before the DML proceeds.

The package also references supporting validation and messaging utilities, including IGS_GR_VAL_AWC, IGS_GR_VAL_GC, IGS_GE_MSG_STACK, FND_MESSAGE, APP_EXCEPTION and IGS_GE_NUMBER, which are used for error raising, message token substitution and numeric handling. Integration logic is delegated to IGS_GR_AWD_CRMN_PKG, IGS_GR_AWD_CRM_US_GP_PKG and IGS_GR_CRMN_PKG, which propagate ceremony changes to related award ceremony master and grouping structures.

Tables Accessed

  • IGS_GR_AWD_CEREMONY_ALL — The primary DML target. Holds award ceremony records, including the associated award and ceremony details maintained through the form.
  • IGS_GR_AWD_CEREMONY_AWC_ID_S — The sequence supplying surrogate primary key values for new ceremony records.
  • IGS_PS_AWARD — Referenced to validate and resolve award information tied to a ceremony, and through dependencies IGS_PS_AWARD_PKG and IGS_PS_AWD_PKG.
  • DUAL — Used for singleton SQL operations, commonly to fetch sequence next values or system-level constants.

Usage Notes

The package is typically invoked indirectly through the Oracle Forms Award Ceremony maintenance window, where the block-level triggers call INSERT_ROW, UPDATE_ROW, LOCK_ROW, DELETE_ROW and ADD_ROW. BEFORE_DML and CHECK_CONSTRAINTS execute as part of the pre-insert, pre-update and pre-delete processing to enforce data integrity. The GET_*_FOR_VALIDATION and GET_FK_IGS_GR_CRMN routines are used by the Forms validation units and by other student-system components that must resolve a ceremony primary key or foreign key. Because the package is not referenced by any other database object, custom extensions, SQL*Loader routines or concurrent programs should call it explicitly only when performing ceremony maintenance outside the standard form. As with all APPS schema code, customisations should be applied through supported extension mechanisms rather than direct modification of this package body, since it is regenerated by Oracle patch and upgrade cycles affecting release 12.1.1 and 12.2.2.