Search Results update_entry_qual_status

Overview

IGS_ADMAPPLICATION_PUB is the public PL/SQL API package within the Oracle E-Business Suite Student System (product code IGS) responsible for recording and maintaining key admissions decisions against an applicant's admission application. Classified as a PUBLIC API in the ETRM metadata and tagged as active with compatibility S status, it exposes a controlled, supported interface for assigning ratings, outcomes, offer responses, and qualification codes to admission applications. The package encapsulates the business logic required to update the underlying admissions tables, insulating external callers from direct data manipulation and ensuring that validation, message handling, and commit semantics follow the standard Oracle EBS API framework conventions (FND_API).

The header comment (IGSPAPPS.pls 120.5) confirms its scope as the public API for granting ratings, outcomes, offer responses, and qualification codes. It is the interface of record for downstream and custom integrations that must feed admissions results into the Student System without touching the base tables directly.

Key Procedures and Functions

The package documents five public procedures/functions:

• RECORD_ACADEMIC_INDEX — Records the academic index (and, where applicable, the predicted GPA) value for a given application instance. It identifies the applicant by person, admission application number, nominated program code, and sequence number, and validates the values before writing them to the application record.
• RECORD_OUTCOME_ADMAPPLICATION — Records the admission outcome (for example, an admit, reject, or waitlist decision) against an admission application. This is the primary procedure for reflecting a final or interim admissions decision.
• RECORD_OFFER_RESPONSE — The procedure matching the user's search term. It records the applicant's response to an offer of admission — that is, whether the offer is accepted or declined — against the associated application. This is the API used to close the offer/acceptance loop in the admissions process. It is documented as part of the public API surface for recording offer responses for an admission application.
• RECORD_QUALIFICATION_CODE — Records a qualification code associated with the applicant's application, capturing the qualification basis on which admission is being considered or granted.
• UPDATE_ENTRY_QUAL_STATUS — Updates the entry qualification status of the application, reflecting the progress or standing of the applicant against entry qualification requirements.

All five procedures share the standard public API signature pattern (p_api_version, p_init_msg_list, p_commit, p_validation_level) that governs initialization, message list handling, and transactional control.

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms, including:

• IGS_AD_APPL_ALL and IGS_AD_PS_APPL_INST_ALL — the core admission application and application-instance tables where outcomes, academic indices, and entry qualification statuses are persisted.
• IGS_AD_OFFRESP_INT — the offer response interface table, central to RECORD_OFFER_RESPONSE, holding the recorded acceptance or decline response.
• IGS_AD_APPQUAL_CODE and IGS_AD_CODE_CLASSES — qualification and code-class reference data used to validate qualification codes.
• IGS_AD_OU_STAT, IGS_AD_PRD_AD_PRC_CA, and IGS_UC_TRANSACTIONS — supporting status, program/process, and UCAS transaction data referenced during processing.
• HZ_PARTIES — the trading community party record identifying the applicant.
• FND_TABLES and FND_COLUMNS — Oracle Application Object Library metadata used for dynamic validation and attribute handling.

Usage Notes

IGS_ADMAPPLICATION_PUB is typically invoked from the Oracle Student System admissions forms (such as the Admission Application entry and Offer/Response forms), from concurrent programs that process admissions decisions in bulk, and from custom PL/SQL integrations. It is referenced by two other packages, indicating it is a dependency for higher-level admissions processing routines. Because it is a published, supported API, customizations should call it rather than updating the underlying IGS_AD_* tables directly, preserving upgrade safety and correct validation behavior.