Search Results get_fk_igs_as_grd_sch_grade

Overview

IGS_AD_ADM_UT_STA_GD_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified in the ETRM repository under the generic API classification "OTHER." It belongs to the Oracle Student System (formerly Oracle iLearning / Student Information) product family, as indicated by the IGS_ prefix and the AD (Admissions) module prefix. The package provides the standard table-handling API layer for the IGS_AD_ADM_UT_STA_GD entity, which associates an administrative unit status with a grading schema grade. In business terms, this table and its API capture the relationship between an administrative unit status (such as an applicant or student status) and a specific grading schema, version, and grade combination used during admissions and grading processing.

The package declares AUTHID CURRENT_USER, and the source header shows a last build date of 2003/02/18 (header revision 115.4). Despite its age, the object remains present and documented through release 12.1.1 and 12.2.2 of Oracle EBS.

Key Procedures and Functions

The package exposes seven documented subprograms:

• INSERT_ROW — Inserts a new row into the administrative unit status / grade association table, accepting the row identifier plus the administrative unit status, grading schema code, version number, grade, and an optional mode flag (default 'R').
• LOCK_ROW — Acquires a row-level lock on an existing record identified by rowid and the key columns, supporting the standard optimistic locking pattern used by Oracle Forms and concurrent processing.
• DELETE_ROW — Deletes the row identified by the supplied rowid.
• GET_PK_FOR_VALIDATION — A BOOLEAN function that validates whether a primary key combination (administrative unit status, grading schema code, version number, grade) exists. It is the standard primary key validation hook used by the generated API layer.
• GET_FK_IGS_AS_GRD_SCH_GRADE — The foreign key validation procedure the user searched for. It validates that the supplied grading schema code, version number, and grade combination exists in the parent grading schema grade table (IGS_AS_GRD_SCH_GRADE), thereby enforcing the foreign key relationship before a dependent row is inserted or updated.
• CHECK_CONSTRAINTS — Applies and validates the table's column-level constraints, accepting an optional column name and column value.
• BEFORE_DML — A central pre-DML hook that populates WHO columns (creation date, created by, last update date, last updated by, last update login) and enforces the standard auditing and validation logic prior to insert, update, or delete operations.

Tables Accessed

The package reads and writes the base table IGS_AD_ADM_UT_STA_GD, accessed through its APPS synonym. This table stores the association records keyed by administrative unit status, grading schema code, version number, and grade. Validation of the grading schema relationship is delegated to the parent grading schema grade entity, referenced in the GET_FK_IGS_AS_GRD_SCH_GRADE procedure name. The ETRM documentation lists no additional referenced tables beyond this primary entity.

Usage Notes

As a generated-style table-handling API, this package is typically invoked from Oracle Forms user exits, from other PL/SQL packages within the Student System, or from custom extensions performing direct data manipulation against the administrative unit status / grade association. The ETRM metadata records that the package is referenced by one other package, confirming it participates in a layered call graph rather than being called directly by end users. The GET_FK_IGS_AS_GRD_SCH_GRADE procedure is most commonly called during validation of new or changed records to ensure the referenced grading schema grade exists before the row is committed. Because the package is AUTHID CURRENT_USER, it executes with the privileges of the calling schema; callers should ensure appropriate grants on the underlying table and on the parent grading schema grade table are in place.