Search Results get_fk_igs_gr_aprv_stat




Overview
Explore in AI Chat

Overview

IGS_GR_GRADUAND_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, belonging to the Student System (IGS) product family. It encapsulates the data-access and validation logic for the graduand entity, the record that links a person to an academic award program and captures their graduation candidacy and outcome. The package follows the standard Oracle Forms-generated table handler pattern, providing the insert, update, lock, and delete primitives, primary and unique key retrieval functions, foreign key lookup routines, and constraint-checking logic required to maintain the integrity of the graduand table. It is a private implementation package rather than a public API; its procedures are invoked by the generated form-level packages and by other IGS processing packages that create or maintain graduand records. Because it centralizes constraint validation, it ensures that award program references, approval statuses, and related graduation attributes are validated consistently wherever graduand data is touched. In ETRM documentation the object is classified as OTHER and carries a VALID status, confirming it is a supported, deployed component in both 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new row into the graduand table, populating WHO columns and enforcing column defaults.
  • UPDATE_ROW — Updates an existing graduand row after the record has been locked.
  • LOCK_ROW — Acquires a row-level lock on the graduand record to prevent concurrent modification.
  • ADD_ROW — Convenience routine that creates a new row in the form block's local record set prior to database insert.
  • DELETE_ROW — Removes a graduand row from the table.
  • GET_PK_FOR_VALIDATION — Returns the primary key value used by the constraint-checking logic to validate the current row.
  • GET_UK_FOR_VALIDATION — Returns the unique key value used during validation checks.
  • GET_FK_IGS_GR_CRMN_ROUND — Resolves the foreign key to the ceremony round, validating that the referenced ceremony round exists.
  • GET_FK_IGS_GR_APRV_STAT — Resolves the foreign key to the approval status.
  • GET_FK_IGS_GR_STAT — Resolves the foreign key to the graduation status.
  • GET_FK_IGS_GR_HONOURS_LEVEL — Resolves the foreign key to the honours level classification.
  • GET_FK_IGS_EN_SPA_AWD — Resolves the foreign key to the student program attempt award.
  • GET_FK_IGS_PE_PERSON — Resolves the foreign key to the person record.
  • GET_FK_IGS_EN_STDNT_PS_ATT — Resolves the foreign key to the student program attempt.
  • CHECK_CONSTRAINTS — Evaluates mandatory and referential constraints for the graduand row before DML is permitted.
  • BEFORE_DML — Trigger-style routine invoked prior to insert, update, or delete to execute constraint checks and defaulting.

Tables Accessed

The package operates against IGS_GR_GRADUAND_ALL, the base table storing graduand records including award, ceremony, status, and honours information. It also references IGS_PS_AWARD, the award program definition table, to validate that the award associated with a graduand is legitimate. Access to these tables is made through APPS synonyms, consistent with the dependency information showing references to SYS.STANDARD and the APPS schema. The foreign key functions listed above resolve values from related IGS tables (ceremony round, approval and graduation status, honours level, student program attempt award, person, and student program attempt) but the documented direct table references remain IGS_GR_GRADUAND_ALL and IGS_PS_AWARD.

Usage Notes

IGS_GR_GRADUAND_PKG is invoked primarily through the Oracle Forms-based graduation maintenance windows, where it supplies the block-level table handler logic. It is also referenced by at least thirteen other PL/SQL packages, including IGS_GR_GEN_001, IGS_GR_GEN_002, IGS_GR_APRV_STAT_PKG, IGS_GR_AWD_CRMN_PKG, IGS_GR_AWD_CRMN_HIST_PKG, IGS_GR_CRMN_ROUND_PKG, IGS_GR_STAT_PKG, IGS_GR_HONOURS_LEVEL_PKG, IGS_GR_GRD_LGCY_PUB, IGS_EN_FUTURE_DT_TRANS, IGS_EN_SPA_AWD_AIM_PKG, IGS_EN_STDNT_PS_ATT_PKG, and IGS_AD_GEN_001. These dependencies indicate the package participates in award ceremony generation, status maintenance, and enrollment-driven graduation processing. Custom code should avoid calling this private package directly; integrations should use the supported public APIs within the IGS schema, while administrators should treat the object as internal infrastructure whose signatures may change across patches.