Search Results igs_en_lgcy_prc




Overview
Explore in AI Chat

Overview

IGS_EN_LGCY_PRC is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family. Its name derives from "Legacy Process" within the Enrollment (EN) module, and it exists to support the bulk migration of legacy student enrollment data into the Oracle Student System tables. The package header, declared with AUTHID CURRENT_USER, carries a single documented procedure, LEGACY_BATCH_PROCESS, and its revision history indicates it was modified in November 2002 to align with the Legacy Import process for both Enrollment and Records (EN and REC) data.

The business purpose is to orchestrate the staged transformation and loading of externally supplied enrollment records — applications, unit attempts, status changes, and related data — that arrive through the interface tables prefixed IGS_EN_LGCY_* and IGS_AS_LGCY_*. Rather than exposing granular load logic, the package presents a single batch entry point that a concurrent program calls for a given batch and table code.

Key Procedures and Functions

  • LEGACY_BATCH_PROCESS — The sole documented procedure. It is the batch driver for legacy enrollment import. Its parameters include the standard concurrent program out parameters (errbuf, retcode), plus a batch identifier (p_batch_id), a table code (p_table_code) selecting which interface table family to process, and a delete flag (p_delete_flag) controlling whether successfully processed staging rows are purged. The procedure reads rows from the relevant interface table, validates and transforms them, writes any rejects to the error interface table, and inserts or updates the corresponding destination records. No internal call sequence or cursor logic is documented, and none should be assumed beyond this contract.

Tables Accessed

The documented table references fall into three functional groups:

Usage Notes

This package is not a public API in the usual sense. It is invoked through the Oracle Student System legacy import concurrent programs, which supply the batch identifier and table code and receive the standard errbuf/retcode pair. Administrators run the import after populating the IGS_EN_LGCY_* interface tables from external source extracts. The delete flag allows a rerun to be idempotent by clearing processed staging rows.

The package is referenced by no other documented packages, so it sits at the top of its own call chain. Custom code should call it only when replicating the supported concurrent program behaviour, and should treat the out parameters as the authoritative success/failure signal. Because the metadata records only one procedure, any additional logic is internal and unsupported for direct invocation.