Search Results igs_ad_offresp_batch_s

Overview

The APPS.IGS_UC_EXPORT_DECISION_REPLY package body is a component of the Oracle E-Business Suite Student System (formerly Oracle Student System / Higher Education), operating under the APPS schema. Its business function is to export admission decision and offer reply data from the Oracle EBS admission tables into the staging and interface structures used by the UCAS (Universities and Colleges Admissions Service) integration, which supports the administration of admissions across UK higher education institutions and colleges.

In the context of Oracle EBS 12.1.1 and 12.2.2, this package participates in the inbound/outbound batch exchange of admissions decisions and applicant offer responses. Status is recorded as VALID in the ETRM repository. The package is classified as an API of type OTHER, indicating it is not a seeded public API but rather an internal integration utility. It is not referenced by any database object, although it depends on a broad set of admission, offer, and UCAS-specific tables and packages.

Key Procedures and Functions

The documented package metadata exposes two procedures or functions:

• EXPORT_DECISION — Extracts and exports admission decision records. It reads applicant and application data and writes the corresponding decision rows into the admission interface / outbound staging structures.
• EXPORT_REPLY — Extracts and exports applicant offer reply data (such as firm, insurance or decline responses). It derives reply records from the offer and application tables and populates the outbound interface tables.

No parameter lists are documented in the ETRM extract, and the internal signatures are not reproduced here. Both procedures rely on the package-level dependencies, including IGS_AD_OFFRESP_INT_PKG, IGS_AD_ADMDE_INT_PKG, IGS_AD_BATC_DEF_DET_PKG, IGS_UC_APP_CHOICES_PKG and IGS_UC_OLD_OUSTAT_PKG, and on the messaging and logging utilities FND_FILE, FND_MESSAGE, FND_NEW_MESSAGES, FND_GLOBAL, APP_EXCEPTION and IGS_GE_MSG_STACK.

Tables Accessed

The package reads and writes a defined set of APPS synonyms. The principal referenced tables include:

• IGS_AD_OFFRESP_BATCH and IGS_AD_OFFRESP_BATCH_S — the offer response batch header and its sequence. The user query term igs_ad_offresp_batch_s corresponds directly to this sequence, which is used to generate batch identifiers during export processing.
• IGS_AD_OFFRESP_INT and IGS_AD_OFFRESP_INT_S — offer response interface tables and their sequence, which receive the exported reply records.
• IGS_AD_ADMDE_INT_ALL — the admission decision interface table, populated by EXPORT_DECISION.
• IGS_AD_APPL_ALL, IGS_AD_PS_APPL_ALL, IGS_AD_PS_APPL_INST_ALL — applicant and application instance data used to derive the export set.
• IGS_AD_BATC_DEF_DET_ALL — batch definition detail controlling which records are selected.
• IGS_AD_OU_STAT, IGS_AD_SS_APPL_TYP, IGS_AD_CODE_CLASSES, IGS_AD_INTERFACE_CTL_S, FND_NEW_MESSAGES — supporting control, status, application-type and error logging data.
• UCAS-side tables: IGS_UC_APPLICANTS, IGS_UC_APP_CHOICES, IGS_UC_DEFAULTS, IGS_UC_MAP_OFF_RESP, IGS_UC_MAP_OUT_STAT, IGS_UC_OLD_OUSTAT, IGS_UC_SYS_CALNDRS and IGS_UC_TRANSACTIONS, together with DUAL and PLITBLM.

Usage Notes

This package body is typically invoked from the admissions offer-response export concurrent program or as part of the batch processing lifecycle defined by IGS_AD_BATC_DEF_DET_PKG. It is not intended for ad-hoc execution and exposes no documented public interface beyond EXPORT_DECISION and EXPORT_REPLY. Administrators and developers should treat it as an internal integration utility; direct calls should be avoided in customisations. Validation and exception handling depend on FND_MESSAGE, FND_NEW_MESSAGES, APP_EXCEPTION and IGS_GE_MSG_STACK, so errors surface through the standard Oracle EBS message stack and the concurrent manager log written by FND_FILE.