Search Results igs_ad_val_aal




Overview
Explore in AI Chat

Overview

IGS_AD_VAL_AAL is a PL/SQL validation package body in the APPS schema belonging to the Oracle Student System (formerly Oracle iSIMS / Oracle Student Administration) product family. The prefix "IGS" identifies the Student System modules, and the "AD" segment indicates the Admissions subsystem, while "VAL" denotes that the package's primary role is validation logic. The suffix "AAL" most plausibly refers to Applicant Letter or Admission Letter processing, consistent with the Application Letter table (IGS_AD_APPL_LTR) that the package references. The package is classified as an API of type OTHER, indicating it is not a fully published public API but is nonetheless a stable, callable component used by admissions letter processing routines.

In Oracle EBS 12.1.1 and 12.2.2, such validation packages are typically invoked during transactional processing to confirm that applicant and letter data are internally consistent and that prerequisite conditions such as letter type validity and processing category state are satisfied before a record is committed.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within this package body:

  • ADMP_VAL_AAL_CORT — A validation routine executed in the context of Admissions letter processing, whose purpose is to verify the correctness of an Admissions Letter record prior to processing or persistence. The "CORT" suffix typically denotes a correlation or correspondence routine.
  • ADMP_VAL_AAL_EXISTS — A validation function that confirms the existence of an Admissions Letter record. It is likely used to prevent duplicate insertions or to guard downstream logic against missing rows.
  • CORP_VAL_CORT_CLOSED — A validation routine that checks whether a correspondence or correlation record is in a closed state, preventing further modification or reuse of a finalized letter.

The package also exposes a public specification reference (IGS_AD_VAL_AAL) and depends on internal helper functions ADMP_VAL_* which may be private to the body. No parameter lists are documented in the metadata, so callers should inspect the package specification directly.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

  • IGS_AD_APPL_LTR — Stores Admissions applicant letter instances; the core subject of validation.
  • IGS_AD_PRCS_CAT_LTR — Associates processing categories with letter types, establishing rules the validation procedures apply.
  • IGS_CO_S_LTR — The letter setup table defining available letter codes and configurations.
  • IGS_CO_TYPE — A flexible lookup table holding type codes and their values, used for enumerations such as letter status.

Usage Notes

IGS_AD_VAL_AAL is referenced by five other database objects and does not reference any user-defined objects beyond its documented dependencies. It is normally invoked from within Admissions letter forms, concurrent programs that generate or dispatch applicant correspondence, and custom extensions that must reuse standard validation rules. Because the package is classified as OTHER, direct modification is not supported, and callers should treat it as a read-validated helper rather than an extension point. Error reporting relies on APP_EXCEPTION, FND_MESSAGE, and IGS_GE_MSG_STACK for message stack integration.