Search Results get_fk_igs_gr_honours_level




Overview
Explore in AI Chat

Overview

IGS_EN_SPA_AWD_AIM_PKG is an Oracle EBS Student Systems (Student Information / Higher Education) PL/SQL package owned by the APPS schema. It encapsulates the business logic and data access layer for the Award Aim entity within the Student Progress Assessment (SPA) module. The package manages the association between a person (student), a course, and an award aim, together with the associated honours level, award mark, award grade, and grading schema details. Its primary purpose is to provide a controlled API for creating, maintaining, and validating award aim records so that dependent forms, concurrent processes, and other packages do not manipulate the underlying base tables directly. It is classified under ETRM as an OTHER API object and is referenced by eleven other packages, confirming that it acts as a central dependency within the SPA award processing flow. The package header carries the version marker IGSEI59S.pls 120.1.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new award aim record, accepting the person, course, award, date, completion, honours level, conferral, award mark, grade, grading schema, and grading schema version attributes.
  • LOCK_ROW — Acquires a lock on an existing award aim row to enforce optimistic concurrency control before an update.
  • UPDATE_ROW — Updates an existing award aim record identified by its rowid and key attributes.
  • ADD_ROW — Adds a new row, accepting an OUT rowid so the caller receives the generated identifier for subsequent processing.
  • DELETE_ROW — Removes an award aim record from the base table.
  • GET_PK_FOR_VALIDATION — Returns primary key information used to validate that a referenced award aim exists.
  • GET_FK_IGS_EN_STDNT_PS_ATT — Foreign key validation helper for the student personal/attempt reference entity.
  • GET_FK_IGS_GR_HONOURS_LEVEL — Foreign key validation helper that verifies a supplied honours level code exists in the honours level reference table. This is the object surfaced by the user's search term get_fk_igs_gr_honours_level.
  • GET_FK_IGS_AS_GRADING_SCH — Foreign key validation helper for the grading schema code.
  • BEFORE_DML — A pre-DML trigger-style procedure that enforces mandatory and defaulted attribute rules before inserts or updates are applied.

Tables Accessed

  • IGS_EN_SPA_AWD_AIM — The primary base table storing award aim records; read and written by the insert, update, delete, and add operations.
  • IGS_EN_SPAA_HIST — The award aim history/audit table capturing changes for traceability.
  • IGS_PE_PERSON_TYPES — Person type reference data used to validate the person associated with the award aim.
  • IGS_PE_TYP_INSTANCES_ALL — Person type instance data used to validate the effective person type context during DML.

Usage Notes

The package is typically invoked from Oracle Forms based on the Award Aim block, from concurrent programs that process student award outcomes, and from custom PL/SQL code requiring an API-compliant route to award aim data. The GET_FK_* functions are called by validation logic (including the forms' LOV and validation triggers) to confirm that honours level, grading schema, and student attempt references are valid before a record is committed. The ADD_ROW and INSERT_ROW routines expect the caller to pass a rowid OUT parameter, reflecting the standard Oracle EBS table-handler pattern. Because the package is referenced by eleven other packages, changes to its signatures should be treated as high-impact; consumers should rely on the published procedures rather than direct table DML.