Search Results igs_uc_export_decision_reply




Overview
Explore in AI Chat

Overview

The APPS.IGS_UC_EXPORT_DECISION_REPLY package is a PL/SQL API belonging to the Oracle E-Business Suite Student System (formerly Oracle Student System / OSS) module, specifically the UCAS (Universities and Colleges Admissions Service) integration area. In the ETRM 12.1.1 documentation it is classified with an API classification of OTHER and is owned by the APPS schema, with the package declared as AUTHID CURRENT_USER. Its business purpose is to export admissions decision and reply information from the Oracle student records environment outward toward the UCAS processing channel, ensuring that applicant status changes captured within EBS are propagated to the external admissions workflow.

The AUTHID CURRENT_USER declaration indicates the package executes with the privileges of the invoking user rather than the definer, so callers must hold the appropriate grants on the underlying UCAS and admissions interface objects.

Key Procedures and Functions

The package exposes two documented procedures. No functions are documented.

  • EXPORT_DECISION — Accepts an application number (p_app_no) and a choice number (p_choice_number) and performs the export of the admissions decision associated with that applicant choice. This is the routine responsible for transmitting the institution's decision outcome for a given UCAS choice.
  • EXPORT_REPLY — Accepts the same application number and choice number parameters and exports the applicant's reply data for the corresponding choice. It handles the propagation of reply information recorded against the application/choice combination.

Both procedures are parameterised by the same two identifiers, reflecting that decisions and replies are keyed at the application-and-choice granularity within the UCAS data model.

Tables Accessed

The ETRM metadata lists the following tables referenced through APPS synonyms. The core driving table is IGS_UC_APP_CHOICES, which supplies the application number and choice number columns used as the procedure parameters and holds the UCAS applicant choice records being exported. The admissions interface layer is represented by tables such as IGS_AD_APPL_ALL, IGS_AD_PS_APPL_ALL, IGS_AD_PS_APPL_INST_ALL, IGS_AD_ADMDE_INT_ALL, IGS_AD_OFFRESP_INT and its sequence IGS_AD_OFFRESP_INT_S, IGS_AD_OFFRESP_BATCH and IGS_AD_OFFRESP_BATCH_S, and IGS_AD_BATC_DEF_DET_ALL. Supporting reference and control objects include IGS_AD_SS_APPL_TYP, IGS_AD_CODE_CLASSES, IGS_AD_OU_STAT, and IGS_AD_INTERFACE_CTL_S. The FND_NEW_MESSAGES table is used for Oracle Application Object Library messaging and notification during processing.

Usage Notes

The package is referenced by one other package in the ETRM metadata and is therefore typically invoked programmatically rather than directly by end users. In a UCAS admissions integration it would normally be called from batch or interface processing logic that evaluates newly recorded decisions and replies and drives the outbound export to UCAS. Callers should supply a valid application number and choice number pair as held in IGS_UC_APP_CHOICES. Because the package is AUTHID CURRENT_USER, the invoking session must have the necessary object privileges on the UCAS and admissions interface tables. The header revision context (IGSUC65S.pls 115.2) indicates this is a student-system 11.5.x-era object carried forward into the 12.1.1 and 12.2.2 releases, so integrators should confirm behaviour against their specific patch level before use.