Search Results find_source_cat_rule

Overview

IGS_AD_IMP_001 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student Systems (IGS) product family, specifically the Admissions (AD) module. Its business function is to orchestrate the import and validation of legacy admissions and applicant data into the EBS data model. The package serves as a central import controller, reading staged records from the admissions interface tables and transforming them into the final admissions tables used by the institution's admissions processes.

The package is classified as OTHER, indicating it is an internal implementation package rather than a published public API. It is registered as VALID in the ETRM documentation for 12.1.1 and 12.2.2, and it is heavily interconnected: it is referenced by 29 other packages, making it a foundational utility for admissions data conversion and batch import routines.

Key Procedures and Functions

The documented package exposes ten procedures/functions. Their documented purposes are as follows:

• IMPORT_LEGACY_DATA — the principal entry point for loading legacy admissions records into the interface tables and initiating processing.
• IMP_ADM_DATA — performs the actual import of admissions data from the interface staging area into the destination tables.
• FIND_SOURCE_CAT_RULE — resolves the source category rule applicable to an incoming record, supporting data mapping and validation decisions.
• UPDATE_PARENT_RECORD_STATUS — updates the status of a parent record, typically after its child interface rows have been processed.
• SET_MESSAGE — sets a message used for user or log feedback during import execution.
• LOGERRORMESSAGE — writes error messages encountered during import to the logging structures.
• LOGHEADER — writes a header entry, delimiting a new batch or processing block in the log.
• LOGDETAIL — writes detailed log records for individual processing events.
• PRINT_STATS — outputs processing statistics for the import run.
• STORE_STATS — persists processing statistics to the statistics table for later reporting.

Tables Accessed

The package references the following tables (through APPS synonyms):

• FND_LOOKUP_VALUES — for decoding and validating lookup-based values during import.
• IGS_AD_INTERFACE_ALL and IGS_AD_INTERFACE_CTL — the main admissions interface and control tables that stage incoming data and manage batch control.
• Interface tables IGS_AD_ACADHIS_INT_ALL, IGS_AD_ACADINT_INT, IGS_AD_APL_INT, IGS_AD_APPHIST_INT, IGS_AD_APPINT_INT, IGS_AD_EDUGOAL_INT, IGS_AD_FEE_INT, IGS_AD_INSTHIST_INT, and IGS_AD_NOTES_INT — holding applicant academic history, interests, application, application history, educational goals, fees, institution history, and notes respectively.
• IGS_AD_IMP_BATCH_DET — batch detail records for each import run.
• IGS_AD_IMP_STATS — storage of import statistics collected by STORE_STATS.
• USER_TABLES — used to verify table existence during processing.

Usage Notes

IGS_AD_IMP_001 is typically invoked from concurrent programs and other import packages. The metadata shows it is referenced by sibling packages IGS_AD_IMP_002 through IGS_AD_IMP_028, as well as by IGR_IMP_002 through IGR_IMP_004, IGS_AD_ACT_ASSESSMENTS_PKG, IGS_HE_IMPORT_DATA, IGS_PE_PERS_IMP_001, and the UC export/processing packages. It is therefore a shared import utility rather than a standalone user-facing API.

Because the package writes to interface, batch, and statistics tables and drives parent status updates, it is intended to be run as part of a controlled batch import or data conversion effort, with error logging handled by LOGERRORMESSAGE, LOGHEADER, and LOGDETAIL. Custom code should not call internal steps out of sequence; the supported entry point is IMPORT_LEGACY_DATA.