Search Results igs_ad_val_apcoo




Overview
Explore in AI Chat

Overview

IGS_AD_VAL_APCOO is a PL/SQL validation package in the Oracle E-Business Suite Student System (also marketed as Oracle Student Financial Planning / Student Information) that governs the integrity of admission period course offering option data. The package name decomposes as follows: IGS (the Student System module prefix), AD (Admissions), VAL (validation), and APCOO (Admission Period Course Offering Option). It is registered under the APPS schema with AUTHID CURRENT_USER and is classified as an OTHER API, indicating that it is primarily an internal validation and maintenance utility rather than a public, externally-facing API.

The package's central responsibility is to validate and default the relationships that bind an admission period, an admission category, an admission process type, a course, a course version, and the optional attributes of location, attendance mode, and attendance type. These relationships determine which course offering options a prospective student may select during the admissions cycle. The header comment records a change history entry (user avenkatr, 29-AUG-2001, Bug 1956374) that added a PRAGMA to the crsp_val_att_closed function; the same bug specifically removed the previously existing function crsp_val_loc_cd.

Key Procedures and Functions

  • admp_val_apcoo_co — Validates an admission period course offering option against a specific course offering, verifying the combination of course code, course version number, academic calendar type, admission category, admission process type, admission calendar type, and calendar instance sequence number. Returns a Boolean and an output message name.
  • admp_val_apcoo_links — Validates the optional links associated with an admission period course offering option, extending validation to location code, attendance mode, and attendance type.
  • admp_ins_dflt_apcoo — Inserts default admission period course offering option records for a given admission calendar type, calendar instance sequence number, admission category, and admission process type.
  • genp_val_optnl_coo — Performs generic validation of course offering option optional links, checking new location code, new attendance mode, and new attendance type values.
  • crsp_val_am_closed — Validates whether an attendance mode is closed, preventing selection of a closed mode.
  • crsp_val_att_closed — Validates whether an attendance type is closed. This is the object surfaced by the search term "crsp_val_att_closed" and is the function modified by the PRAGMA directive noted in the change history.
  • admp_val_apcoo_opt — Validates the admission period course offering option itself.

Tables Accessed

  • IGS_AD_PRD_AD_PRC_CA — the admission period / admission process / calendar association table that underpins the admission category and process type validation logic.
  • IGS_AD_PRD_PS_OF_OPT — the admission period course offering option table, the primary entity being validated and defaulted.
  • IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S — the sequence generator supplying unique identifiers for newly inserted default options in admp_ins_dflt_apcoo.
  • IGS_CA_INST_REL — the calendar instance relationship table used to resolve academic calendar instance dependencies.
  • IGS_PS_OFR_PAT — the program offering pattern / course offering pattern table referenced for course offering validation.
  • DUAL — used for single-row PL/SQL expression evaluation.

Usage Notes

IGS_AD_VAL_APCOO is invoked indirectly rather than called directly by end users. It is referenced by five other packages, meaning the validation entry points are typically triggered from higher-level admissions APIs, Oracle Forms-based admissions windows, or the course offering option maintenance screens. Because all functions return BOOLEAN and emit a message name through an OUT NOCOPY parameter, callers are expected to handle error messaging themselves, often translating the returned message name into a user-visible FND_MESSAGE. Customizations should not modify the package directly; extensions should be attempted through supported APIs or by wrapping the validation entry points. The removal of crsp_val_loc_cd under Bug 1956374 means any legacy code still referencing that function will fail and must be corrected.