Search Results igs_en_spa_awd_aim_pkg




Overview
Explore in AI Chat

Overview

IGS_EN_SPA_AWD_AIM_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema, classified under the Student Systems product family (the IGS_ prefix denotes Oracle Student System / Student Information Management). Its domain is the recording of student award aims and the historical audit trail that surrounds changes to those aims. In Oracle EBS terminology, an "award aim" represents the qualification or award that a student is pursuing, together with the attributes that describe the intended outcome, the grading scheme to be applied, and the honours level expected. The package provides the standard forms-and-API style row management layer for the IGS_EN_SPA_AWD_AIM base table, supplying insert, update, delete, locking, primary-key validation, foreign-key validation, and a BEFORE_DML trigger body used to enforce business rules, default values, and audit stamping. It is a dependency of eleven other database objects, indicating that it functions as a lower-level building block invoked by higher-level award, progression, and graduation processes rather than as an end-user-facing component.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new award-aim record into the underlying table, applying the package's defaulting and validation logic.
  • UPDATE_ROW — Updates an existing award-aim record, preserving audit columns and re-validating dependent attributes.
  • ADD_ROW — Performs the combined create operation typically invoked from the maintenance form, orchestrating validation before insert.
  • DELETE_ROW — Removes an award-aim record, subject to referential and business-rule checks.
  • LOCK_ROW — Acquires a row-level lock on the target record to support optimistic concurrency control during form editing.
  • GET_PK_FOR_VALIDATION — Resolves and returns the primary key of the record being validated; used internally by the validation routines.
  • GET_FK_IGS_EN_STDNT_PS_ATT — Foreign-key lookup routine that validates and returns the student program attempt identifier associated with the award aim.
  • GET_FK_IGS_GR_HONOURS_LEVEL — Foreign-key lookup routine that validates and returns the honours level reference for the award aim.
  • GET_FK_IGS_AS_GRADING_SCH — Foreign-key lookup routine that validates and returns the grading scheme applicable to the award aim.
  • BEFORE_DML — Pre-DML trigger logic executed prior to insert, update, or delete, enforcing mandatory attributes, who-column stamping, and consistency rules.

Tables Accessed

  • IGS_EN_SPA_AWD_AIM — The base table that stores the award aim records themselves; the package's DML procedures operate directly against it.
  • IGS_EN_SPAA_HIST — The audit history table for award aims. History rows are maintained through IGS_EN_SPAA_HIST_PKG so that changes to aims are traceable.
  • IGS_PE_PERSON_TYPES — Person type reference data, validated when determining the student's status category.
  • IGS_PE_TYP_INSTANCES_ALL — Person type instance records, used to confirm that the person holds a valid student-type instance at the time the award aim is created or amended.

Usage Notes

This package is not intended to be called directly by end users or external applications. It is invoked from the award-aim maintenance form, from concurrent programs that build or refresh award data, and by the higher-level packages listed in its dependency chain, including IGS_PS_AWD_PKG, IGS_EN_STDNT_PS_ATT_PKG, IGS_EN_SPAA_HIST_PKG, IGS_GR_GRADUAND_PKG, IGS_AS_GRD_SCHEMA_PKG, IGS_PE_TYP_INSTANCES_PKG, and IGS_GE_DATE. Supporting utilities such as FND_GLOBAL, FND_MESSAGE, IGS_GE_MSG_STACK, APP_EXCEPTION, and IGS_SC_GEN_001 are used for who-column population, message retrieval, error stacking, and exception handling respectively. In Oracle EBS 12.1.1 and 12.2.2, the package body is a VALID object in the APPS schema and depends on the package specification of the same name. Customizations should extend behaviour through the supported higher-level APIs rather than modifying this body, since a direct change would invalidate eleven dependent objects and compromise Oracle Support coverage. Any direct DML on IGS_EN_SPA_AWD_AIM that bypasses the package will omit audit history recording and foreign-key validation.