Search Results igs_or_inst_imp_002




Overview
Explore in AI Chat

Overview

The APPS.IGS_OR_INST_IMP_002 package is a PL/SQL import/staging package belonging to the Oracle E-Business Suite higher education product family (IGS). It plays a supporting role in the inbound processing of institution and crosswalk data within Oracle Student System / Oracle Academic Enterprise modules. Specifically, the package namespace (IGS_OR_INST_IMP) indicates that it forms part of a multi-unit import routine — the "_002" suffix suggests it is one segment of a chained or sequenced import process — responsible for moving external or interface data from an intermediate staging table into the base transactional tables. Its object metadata identifies it as a VALID package in the APPS schema, with the API classification of OTHER, meaning it is a private internal import package rather than a published open interface API. It is not directly invoked by end users; instead it is coordinated by a sibling package, IGS_OR_INST_IMP_001, which references it, and it in turn references the staging table IGS_OR_INST_INT.

Key Procedures and Functions

ETRM documentation lists seven documented constructs in this package:

  • CREATE_INSTITUTION — Creates the institution record in the base tables from staged data.
  • CREATE_CROSSWALK_MASTER — Creates the master-level crosswalk record linking an institution to its organizational representation.
  • CREATE_CROSSWALK_DETAIL — Creates the detail lines associated with a crosswalk master record.
  • CREATE_ALTERNATE_ID — Creates alternate identifier entries for the organization or institution, writing to the alternate ID table.
  • UPDATE_INSTITUTION — Applies updates to an existing institution record based on staged change data.
  • UPDATE_CROSSWALK_MASTER — Applies updates to existing crosswalk master records.
  • AUTOGENERATELOGIC — A helper routine that drives the automatic generation of derived key logic used during creation and update.

The visible naming convention confirms a create/update pattern paired with helper logic for automatic generation of the crosswalk relationship between institutions and their party-based organization records.

Tables Accessed

Per ETRM, the package interacts with the following tables through APPS synonyms:

  • IGS_OR_INST_INT — the interface/staging table holding inbound institution and crosswalk data; this is the primary source of the import.
  • HZ_PARTIES and IGS_PE_HZ_PARTIES — the TCA party tables holding party and organization records against which institution and organization data is created or maintained.
  • IGS_OR_CWLK — the crosswalk master table receiving create/update activity.
  • IGS_OR_CWLK_DTL — the crosswalk detail table.
  • IGS_OR_ORG_ALT_IDS — the organization alternate identifiers table written by CREATE_ALTERNATE_ID.

Usage Notes

This package is an internal worker unit within the IGS institution import chain. It is referenced by IGS_OR_INST_IMP_001, which acts as the orchestrating routine; end users do not call IGS_OR_INST_IMP_002 directly. It is typically invoked during batch execution of the institution import concurrent program, where staged rows in IGS_OR_INST_INT are processed into HZ_PARTIES, IGS_OR_CWLK, IGS_OR_CWLK_DTL, and IGS_OR_ORG_ALT_IDS. Because the API classification is OTHER, it should not be treated as a supported public API; customizations should use the documented open interfaces (001 layer) rather than calling 002 subprograms directly. Any dependency on the object should be reviewed prior to upgrade, since import package internals may change between releases.