Search Results igs_admapplication_pub




Overview
Explore in AI Chat

Overview

IGS_ADMAPPLICATION_PUB is a public PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite Student Systems / Admissions (IGS) product family. The _PUB suffix designates it as a documented, supported public API intended for external invocation by forms, concurrent programs, and custom code, as opposed to internal (private) packages that Oracle reserves the right to change. The package exposes admission application processing logic — capturing academic qualifications, recording applicant outcomes and offer responses, and maintaining entry qualification status — that would otherwise be embedded in tightly coupled private routines. It is classified as VALID in the ETRM registry and is referenced by two other database objects, confirming it is a stable dependency point in the IGS Admissions call hierarchy. The package reflects the standard Oracle API conventions: it depends on FND_API for the common error-handling and message framework, FND_MSG_PUB and FND_MESSAGE for message stack management, and FND_PROFILE for environment/profile option retrieval.

Key Procedures and Functions

The documented public interface exposes five procedures/functions, each scoped to a discrete admissions activity:

  • RECORD_ACADEMIC_INDEX — Captures or updates the academic index value associated with an admission application, used in scoring or ranking applicants against entry criteria.
  • RECORD_OUTCOME_ADMAPPLICATION — Records the decision or outcome of an admission application, driving subsequent status changes and downstream offer/responses processing.
  • RECORD_OFFER_RESPONSE — Persists an applicant's response to an admission offer, including acceptance or decline, and enables the associated status transitions handled by the offer-response status logic (IGS_AD_OFR_RESP_STAT_PKG).
  • RECORD_QUALIFICATION_CODE — Associates or maintains qualification codes on an application, leveraging the qualification code validations in IGS_AD_APPQUAL_CODE_PKG.
  • UPDATE_ENTRY_QUAL_STATUS — Updates the entry qualification status of an applicant, typically reflecting verification against admissions standards and institution/OU-status rules.

Parameter lists are not reproduced here; callers should obtain signatures from the installed package specification (DBA_SOURCE / USER_SOURCE) in their specific environment.

Tables Accessed

The package operates against the core admissions base tables and several reference/lookup tables via APPS synonyms:

Usage Notes

Because this is a _PUB API, it is the supported entry point for external integration. It is typically invoked from Admissions forms (e.g. the application-entry and offer-response windows), from concurrent programs that batch-process application outcomes or qualification updates, and from custom PL/SQL or workflow components — note the direct workflow dependency on IGS_AD_WF_001. Callers should follow the standard Oracle API pattern: initialise the message stack, optionally load a message list in debug/validation mode, call the procedure, then check the return/exception and iterate FND_MSG_PUB messages before committing. Do not call the private dependencies (the IGS_AD_GEN_00x helpers, IGS_AD_PS_APPL_PKG, IGS_AD_APPQUAL_CODE_PKG, and so on) directly, as their signatures and behaviour are not part of the supported interface. The package body itself is not referenced by any database object beyond the two packages noted, so its public procedures remain the recommended, upgrade-safe integration surface in both 12.1.1 and 12.2.2.