Search Results igs_ad_disablty_int_s

Overview

IGS_HE_IMPORT_DATA is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Higher Education (HE) product family. Its business purpose is to orchestrate the import of external admission and student data — typically supplied by bodies such as UCAS (Universities and Colleges Admissions Service) — into the Oracle EBS interface and staging tables used by the Student System. The package acts as the central driver that reads inbound records from the batch interface, validates and maps them against reference data, and then invokes the appropriate application programming interfaces to create or update person, admission, disability, and citizenship records.

The dependency inventory confirms this role. IGS_HE_IMPORT_DATA references core HE tables such as IGS_HE_BATCH_INT, IGS_HE_CODE_MAP_VAL, IGS_HE_CODE_VALUES, and the IGS_HE_UCAS_IMP_INT / IGS_HE_UCAS_IMP_ERR tables, which together form the inbound staging and error-reporting layer. It also depends on registration and placement packages such as IGS_HE_ST_SPA_ALL_PKG and IGS_HE_UT_CALC_TYPE, indicating responsibility for tariff-point and award-level processing.

Key Procedures and Functions

The documented package exposes a single entry point:

• MAIN_PROCESS — The controlling procedure that drives the entire import cycle. It reads pending records from the HE batch interface, performs code mapping and validation, routes valid records to the relevant sub-processes, and records failures to the UCAS import error tables. As the name implies, it is the procedural entry point that callers invoke to execute the import end to end.

Although MAIN_PROCESS is the only documented procedure, the package body logically coordinates a broader set of activities evidenced by its dependencies: handling of academic history (via IGS_AD_ACAD_HISTORY_PKG), of disability data (via IGS_PE_PERS_DISABLTY_PKG), and of citizenship (via IGS_PE_CITIZEN_INT). Parameter lists are not documented and should not be assumed.

Tables Accessed

The package reads and writes a mix of interface, staging, and base tables, all accessed through APPS synonyms:

• Staging/interface tables — IGS_HE_BATCH_INT, IGS_AD_ACADHIS_INT_ALL, IGS_AD_ACADHIS_INT_S, IGS_AD_API_INT_S, IGS_AD_DISABLTY_INT_S, IGS_AD_INTERFACE_ALL, IGS_AD_INTERFACE_BATCH_ID_S, IGS_AD_INTERFACE_CTL, IGS_AD_INTERFACE_S, IGS_AD_STAT_INT_S. These hold inbound admission, disability, status, and academic-history data awaiting processing.
• Base and transactional tables — HZ_CITIZENSHIP, HZ_PARTIES, HZ_PERSON_PROFILES, IGS_AS_GRD_SCH_GRADE, and IGS_AD_IMP_BATCH_DET. These store the resulting party, person, and grade records once validation succeeds.

The presence of both interface and base tables confirms the classic EBS import pattern: extract from staging, validate, then persist to the operational schema.

Usage Notes

IGS_HE_IMPORT_DATA is not referenced by any other database object (referenced by 0 packages), which indicates it is an entry-point routine rather than a reusable utility. It is typically invoked from a concurrent program or scheduled batch job within the Student System, where an operator submits the HE import process and the program calls MAIN_PROCESS to consume queued interface records. Execution is generally performed against the APPS schema under standard EBS responsibilities, with output and diagnostics routed through FND_FILE and FND_MESSAGE and errors logged to IGS_HE_UCAS_IMP_ERR. Environments running 12.1.1 and 12.2.2 share the same dependency structure, and the package may also be called from custom wrappers where institutions need to integrate external admission feeds.