Search Results igs_ad_ss_gen_001




Overview
Explore in AI Chat

Overview

IGS_AD_SS_GEN_001 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (formerly Oracle Higher Education / Student Systems, product family IGS) admissions module. The package name identifies it as a generated staging and self-service utility for the IGS_AD (Admissions) application. Its primary business function is to support the self-service admissions flow by staging application data captured through web-based, one-stop, or applicant-facing channels into the core admissions tables, performing lookups against academic calendars and admissions units, and transferring staged records into the destination application, offer, and fee structures.

In ETRM 12.1.1 the package is reported as VALID with an API classification of OTHER, meaning it is not a formally published public API but is instead an internal utility invoked by forms, concurrent processes, or other IGS packages. It carries 35 documented procedures and functions and is referenced directly by another package, IGS_AD_GEN_014, with which it shares the generated-code naming convention (the _001 suffix indicates a machine-generated or regenerated artifact).

Key Procedures and Functions

Among the 35 documented routines, the following are representative of the package's role:

Tables Accessed

The package reads and writes admissions base tables and supporting reference data through APPS synonyms. Core admissions tables include IGS_AD_APPL_ALL (the applicant master), IGS_AD_PS_APPL_INST and IGS_AD_UNIT_SETS (admissions unit and program-instance data), IGS_AD_SS_LOOKUPS (self-service lookup values), IGS_AD_SS_LOOKUPS and IGS_CA_INST / IGS_CA_TYPE (calendar and calendar-type reference data). It also touches FND_DOCUMENT_CATEGORIES_TL, FND_LOBS, FND_LOBS_S, FND_LOOKUP_VALUES, and FND_NEW_MESSAGES for attachment handling, lookups, and workflow messaging. Human-resources registry data comes from HZ_CITIZENSHIP, HZ_CONTACT_POINTS, HZ_EDUCATION, HZ_EMPLOYMENT_HISTORY, HZ_PERSON_INTEREST, and HZ_PERSON_LANGUAGE, and workflow events use WF_EVENT_T.

Usage Notes

IGS_AD_SS_GEN_001 is an internal generated package rather than a supported public API; direct calls should be avoided. It is normally invoked indirectly through self-service admissions forms or concurrent programs in the IGS Admissions responsibility, most notably during one-stop applicant submissions and staging transfers. Because it is referenced by IGS_AD_GEN_014, any modification must preserve the existing call interfaces. As with all APPS-owned IGS packages, it is subject to patch and regeneration by Oracle Student System maintenance, so customization inside the package body is not advisable. In both EBS 12.1.1 and 12.2.2, the package resides under the same APPS owner with the same VALID status and dependency set.