Search Results igs_ad_gen_008




Overview
Explore in AI Chat

Overview

IGS_AD_GEN_008 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified as an API of type OTHER. It belongs to the IGS (Student Systems / Oracle Student System) product family and is grouped with the admissions (AD) generation packages. Its documented status is VALID in both Oracle EBS 12.1.1 and 12.2.2 environments.

The package serves as a utility and status-resolution engine for admissions and academic calendar processing. It encapsulates a library of lookup and retrieval routines that other admissions packages call to resolve status codes, calendar dates, and organizational unit mappings before performing their own business logic. Its name and dependency footprint indicate that it is a shared "gen" (generic) component rather than an end-user facing API: it depends on peer generation packages such as IGS_AD_GEN_003 and IGS_AD_GEN_004, on validation packages such as IGS_AD_VAL_ACAI, and on IGS_RU_GEN_004, and it is in turn referenced by 31 other packages, confirming its role as a low-level reusable helper within the admissions subsystem.

Key Procedures and Functions

The package body exposes nine documented procedures and functions. Their purposes, derived from their names and the surrounding admissions domain, are as follows:

  • ADMP_GET_SAFS — retrieves the system-level admissions application status value set or associated status flag used for display and validation.
  • ADMP_GET_SAODS — returns the system-level application offer/decision status, used when resolving an applicant's offer state.
  • ADMP_GET_SAORS — resolves the system-level application offer response status, typically for tracking accept/decline responses.
  • ADMP_GET_SAOS — retrieves the system-level application outcome status, supporting final admissions decisions.
  • ADMP_GET_SAUOS — returns the system-level application unit outcome status, correlating outcomes with the organizational or academic unit.
  • ADMP_GET_SHORT_DT — produces a shortened or formatted date representation, used for display and comparison of academic calendar dates.
  • ADMP_GET_STATUS_RULE — resolves the applicable status transition or rule definition governing an admissions status change.
  • ADMP_GET_SYS_AAS — returns the system-level academic application status, a core control value used across admissions processing.
  • GET_ACAD_CAL — retrieves academic calendar information, resolving the calendar instance applicable to a given context.

All routines follow the ADMP_ prefix convention used for admissions utility procedures, with the exception of GET_ACAD_CAL, which addresses the shared academic calendar domain.

Tables Accessed

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

  • IGS_CA_TYPE — calendar type definitions, used by GET_ACAD_CAL to identify the category of calendar being resolved.
  • IGS_CA_INST_REL — calendar instance relationships, used to navigate calendar hierarchies.
  • IGS_CA_STAT — calendar status values, used to validate that a calendar is active and usable.
  • IGS_AD_APPL_STAT — application status definitions, the primary source for the ADMP_GET_SA* status resolution routines.
  • IGS_AD_CAL_CONF — admissions calendar configuration, providing the calendar context for admissions processing.
  • IGS_AD_FEE_STAT — fee status values associated with an application.
  • IGS_AD_OFRDFRMT_STAT — offer deferment status values.
  • IGS_AD_OFR_RESP_STAT — offer response status values, supporting ADMP_GET_SAORS.
  • IGS_AD_OU_STAT — organizational unit status values.
  • IGS_AD_UNIT_OU_STAT — unit-to-organizational-unit status mappings, supporting ADMP_GET_SAUOS.

Additional dependencies reference IGS_AD_APPL, IGS_AD_PS_APPL, IGS_AD_PS_APPL_INST, IGS_CA_INST, and the view IGS_CA_DA_INST_V, indicating participation in application and calendar instance processing. Error handling relies on APP_EXCEPTION, FND_MESSAGE, and IGS_GE_MSG_STACK.

Usage Notes

IGS_AD_GEN_008 is not invoked directly by end users. It is called by higher-level admissions packages, forms, and concurrent programs that require consistent status resolution and calendar lookup. Because it is referenced by 31 other packages and references none of its callers in return, it should be treated as a shared internal dependency: modifications carry broad impact across the admissions module. Implementers extending admissions functionality should call the documented ADMP_GET_* routines rather than querying the underlying status tables directly, ensuring consistent handling of system-level status values. The package does not appear in any dependency chain as a dependent object, so it can be safely recompiled in isolation without cascading invalidation, but its own dependencies on IGS_AD_GEN_003, IGS_AD_GEN_004, IGS_AD_VAL_ACAI, and IGS_RU_GEN_004 must be valid before compilation.