Results for “igs_uc_proc_com_inst_data”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.IGS_UC_PROC_COM_INST_DATA package body forms part of the Oracle E-Business Suite UK Higher Education (UCAS) integration layer. Its business purpose is to process and derive common reference data from the UCAS interface tables into the institution-facing community data structures used by the Student System. The package performs the transformation and loading of inbound reference records—institutions, offers, subjects, schools, courses, course keywords, and school contacts—that are staged in the UCAS control and interface tables. It is classified under the ETRM as API classification OTHER, indicating it is an internal processing package rather than a public, externally callable API.

A significant portion of the package's logic is governed by a shared setup routine that validates the UCAS environment before any reference processing is executed.

Key Procedures and Functions

The package exposes ten documented procedures, all consistent with a data-loading role:

• COMMON_DATA_SETUP — Establishes the working context for all subsequent processing. It retrieves the current institution code from IGS_UC_DEFAULTS for the FTUG system ('U'). If the value is null, it raises message IGS_UC_CURR_INST_NOT_SET, writes it to the log, and returns a retcode of 2. It additionally validates that the HZ_GENERATE_PARTY_NUMBER profile option is set to 'Y', otherwise raising IGS_UC_GEN_PRTY_PROF_NOT_SET. An OTHERS exception handler records IGS_GE_UNHANDLED_EXP.
• PROCESS_UVINSTITUTION and PROCESS_CVINSTITUTION — Process institution reference data from the UCAS "UV" and "CV" source variants respectively.
• PROCESS_UVOFFERABBREV — Processes offer abbreviation reference data.
• PROCESS_CVEBLSUBJECT — Processes EBL subject reference data.
• PROCESS_CVSCHOOL and PROCESS_CVSCHOOLCONTACT — Process school and school-site contact reference data.
• PROCESS_CVCOURSE, PROCESS_UVCOURSE, and PROCESS_UVCOURSEKEYWORD — Process course and course keyword reference data.

Tables Accessed

The package reads from and writes to the following documented APPS synonyms:

• Control and interface staging tables: IGS_UC_CCONTRL_INTS, IGS_UC_CCRSE_INTS, IGS_UC_CEBLSBJ_INTS, IGS_UC_CINST_INTS, IGS_UC_CSCHCNT_INTS, IGS_UC_CVSCH_INTS, IGS_UC_INST_CONTROL.
• Target community/reference tables: IGS_UC_COM_INST, IGS_UC_COM_SCH, IGS_UC_COM_SCHSITES, IGS_UC_COM_SCSICNTS, IGS_UC_COM_EBL_SUBJ, IGS_UC_CRSE_DETS, IGS_UC_CRSE_KEYWRDS.
• Configuration table: IGS_UC_DEFAULTS, used to obtain the current institution.

Interface tables hold staged UCAS downloads, while the COM and CRSE tables hold the derived community and course reference data.

Usage Notes

The package is typically invoked by UCAS reference data concurrent programs rather than by end-user forms. Each PROCESS_* procedure corresponds to a load step, with COMMON_DATA_SETUP executed first so that the institution context and party-number profile are validated. Because setup failures cause a retcode of 2 and a log message, callers should inspect the concurrent request log—particularly for IGS_UC_CURR_INST_NOT_SET, the diagnostic associated with a missing UCAS institution configuration. The ETRM notes the package is referenced by one other package, consistent with its role as a supporting internal component.