Search Results igs_ad_imp_015




Overview
Explore in AI Chat

Overview

IGS_AD_IMP_015 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API type. It belongs to the Student Systems product family (prefix IGS), specifically the Admissions (AD) module. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is consistent with Oracle's standard convention for import and interface processing packages.

The business function of this package is to support the import and validation of admissions applicant data from external or legacy source systems into the Oracle Student System interface tables. It selects, validates, categorizes, and stages admissions-related data records as part of a batch import process, and performs statistical tracking and cleanup of records that have completed processing. The header comment (IGSAD93S.pls, version 115.5) indicates the package has been in production since at least 2003, reflecting its role as a stable component of the admissions import toolset.

Key Procedures and Functions

The package exposes four documented procedures:

  • SEL_AD_SRC_CAT_IMP — Selects admissions source and category data for import. It identifies records belonging to a given source type and batch, preparing them for subsequent categorization and validation steps.
  • PRC_AD_CATEGORY — Processes admissions category data for the identified batch. This is the core validation/transformation routine that applies categorization rules to the selected records prior to final load.
  • STORE_AD_STATS — Stores processing statistics for the batch, capturing counts and outcomes to support audit and error reporting for the interface run.
  • DEL_CMPLD_AD_RECORDS — Deletes completed admissions records. Following a successful import run, this procedure removes processed staging rows to keep the interface tables manageable.

The procedures share a common parameter signature pattern referencing a source type ID, batch ID, interface run ID, logging flag, and legacy indicator, reflecting a batch-oriented processing model. The parameter lists are not reproduced here beyond what the documented metadata confirms.

Tables Accessed

The package operates against fifteen admissions interface tables via APPS synonyms, all following the _INT / _INT_ALL naming convention designating interface (staging) tables:

These tables hold inbound, pre-validated admissions data drawn from external systems. The package reads them to select and categorize records, updates/marks them on successful processing, and deletes completed rows.

Usage Notes

IGS_AD_IMP_015 is typically invoked as part of the admissions import batch flow, most likely from concurrent programs that orchestrate the end-to-end load: selecting staged data, validating and categorizing it, recording statistics, and purging completed records. The procedures would be called in sequence by a controlling program or wrapper rather than directly by end users. The package is referenced by one other package, confirming it forms part of a layered import framework. Customizations or integrations should invoke the procedures in the documented order and honor the batch and interface run identifiers to preserve auditability. Because the package uses AUTHID CURRENT_USER, callers must possess appropriate privileges on the underlying interface tables.