Search Results igs_ad_val_apac




Overview
Explore in AI Chat

Overview

IGS_AD_VAL_APAC is a PL/SQL validation package in the APPS schema belonging to the Oracle E-Business Suite Student System (formerly Oracle Student System / OSS) product family. Its name follows the IGS_AD prefix convention used for Admissions (AD) components, with the suffix VAL indicating validation logic and APAC denoting the admissions period, admission category, and applicant category configuration area. The package encapsulates the business rules that govern the integrity of admissions period setup, admission category assignment, applicant category classification, and the defaulting of certain admission period attributes.

The package operates as a supporting validation layer rather than as a public API. The ETRM metadata classifies it as OTHER, and its dependency graph confirms an internal role: it is referenced by other admissions packages (IGS_AD_INS_ADMPERD, IGS_AD_PECRS_OFOP_DT_PKG, and IGS_AD_PERD_AD_CAT_PKG) and by itself, and it depends only on SYS.STANDARD and its own internal objects. Because it has no external form or concurrent program registered against it, callers invoke it indirectly through the admissions setup flows that depend on it.

Key Procedures and Functions

  • ADMP_VAL_APAC_DUP — Validates for duplicates within the admissions period, admission category, and applicant category configuration. It prevents overlapping or repeated effective-dated records from being created for the same combination.
  • ADMP_VAL_APAC_CI — Performs the cross-instance or cross-entity validation (CI) for the admissions period/admission category combination, ensuring that the referenced instance relationships and statuses are consistent before a record is committed.
  • ADMP_INS_DFLT_APAPC — Handles insertion and defaulting of admission period applicant category values. It supplies default attributes when a user creates a new admissions period record without fully specifying every category detail.
  • ADMP_VAL_ADM_CI — Validates the admission category and instance (CI) pairing, confirming that the chosen admission category is valid for the applicable calendar instance and its status before the period configuration is saved.

The procedures collectively enforce referential and business-rule integrity across the admissions period calendar, admission categories, and applicant categories.

Tables Accessed

The following tables are accessed through APPS synonyms:

  • IGS_AD_PERD_AD_CAT — Stores the admissions period and admission category associations; the package validates and defaults against these rows.
  • IGS_AD_PRD_AD_PRC_CA — Holds the admissions period, admission category, and applicant category pricing or processing associations used in duplicate and default checks.
  • IGS_AD_PRD_PS_OF_OPT — Defines admission period options that feed the defaulting logic.
  • IGS_CA_INST_REL — The calendar instance relationship table, used by the CI validations to confirm valid instance pairings.
  • IGS_CA_STAT — The calendar status table, checked to ensure referenced instances are in an appropriate status.
  • IGS_CA_TYPE — The calendar type table, used to confirm the correct calendar context for admissions period setup.

Usage Notes

IGS_AD_VAL_APAC is invoked from the admissions setup screens within the Student System responsibility, particularly the maintenance of admissions periods, admission categories, and applicant categories. It is called by IGS_AD_PERD_AD_CAT_PKG and IGS_AD_INS_ADMPERD during the insert and update of period and category records, and by IGS_AD_PECRS_OFOP_DT_PKG and IGS_AD_VAL_APAC itself for related validation checks.

Because the procedures are internal, customizations should not call them directly unless the calling code reproduces the same validation ordering used by the standard packages. Any custom form, concurrent program, or interface that inserts or updates admissions period category data should ideally be routed through the standard admissions packages so that these validations and defaults are applied.