Search Results igs_ad_gen_003




Overview
Explore in AI Chat

Overview

IGS_AD_GEN_003 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family for Admissions. The "AD" prefix denotes the Admissions module, and the "GEN" designation indicates a general-purpose utility package rather than a single business-entity API. Its status is VALID in the ETRM repository for both 12.1.1 and 12.2.2, confirming that it remains an active component across these releases.

The package encapsulates reusable logic that supports the evaluation and processing of admission applications. It resolves attributes that drive admission decisions — such as admission category, basis for admission, calendar configuration, offer response status, and processing category steps — and returns derived values back to the calling process. Because it is not referenced by any database object, it functions as a leaf-level utility invoked explicitly by forms, concurrent programs, or other packages rather than being triggered by database-level events.

Key Procedures and Functions

The ETRM metadata documents ten callable units. Their names indicate focused retrieval and validation roles within the admissions workflow:

  • ADMP_GET_ACAI_AOS_ID — returns the identifier associated with an admission category application instance and its associated admission outcome or status context.
  • ADMP_GET_ACAI_CRV — retrieves the category-related value for an admission category application instance, typically used to resolve configuration defaults.
  • ADMP_GET_ACAI_STATUS — returns the current status of an admission category application instance.
  • ADMP_GET_AC_BFA — derives the basis-for-admission value applicable to an applicant or application category.
  • ADMP_GET_ADM_PERD_DT — returns the admission period date, generally used to establish the effective window for an intake.
  • ADMP_GET_ADM_PP — retrieves admission processing point or parameter information used during application assessment.
  • ADMP_GET_APCS_MNDTRY — indicates whether a processing category step is mandatory, supporting validation rules in the admission pipeline.
  • GET_ENTR_DOC_APC — returns entry documentation requirements or associated admission processing category information for an applicant.
  • GET_CORE_OR_OPTIONAL_UNIT — determines whether a unit or step is core or optional within the admission structure.
  • GET_APC_DATE — returns the admission processing category date used for sequencing and eligibility checks.

The procedures share the ADMP_ prefix convention for admissions master-data retrieval, while the two GET_ procedures expose broader structural queries. No parameter lists are documented in the metadata; callers should reference the deployed package specification for exact signatures.

Tables Accessed

The package reads and writes through APPS synonyms against the following IGS tables:

Additional runtime dependencies include APP_EXCEPTION, FND_MESSAGE, IGS_AD_GEN_009, IGS_CA_GEN_001, IGS_CA_GEN_002, and IGS_GE_MSG_STACK, indicating integration with the Oracle error and message stack for exception propagation.

Usage Notes

IGS_AD_GEN_003 is referenced by twelve other packages, placing it in a supporting role within the admissions processing chain. It is typically invoked from admissions setup forms, concurrent programs that evaluate applications, and custom extensions that need to resolve admission categories, dates, or basis values. Because the package relies on FND_MESSAGE and the message stack, callers can expect standardized error messages. When extending admissions functionality, developers should call these procedures rather than duplicating lookup logic, ensuring consistency with the ETRM-documented behavior across 12.1.1 and 12.2.2.