Search Results prc_appl_inst_hist

Overview

IGS_AD_IMP_027 is a PL/SQL package in the APPS schema belonging to the Oracle E-Business Suite 12.1.1 / 12.2.2 higher education product family, specifically the Student Systems (IGS) admissions module. It is classified under the ETRM object registry as an "OTHER" API type, meaning it is not a public, supported interface but an internal implementation package used by the admissions data-import infrastructure.

The package participates in the batch import of applicant and application history records. Its documented responsibilities center on moving staged admissions data from the IGS_AD_INTERFACE_ALL staging table into the operational interface tables that feed the admissions application history and institution history entities. In the standard Oracle Student System import architecture, staged interface rows are validated, transformed and transferred by a chain of numbered import packages; IGS_AD_IMP_027 is one link in that chain, handling the application-level and institution-level history segments of the load.

Key Procedures and Functions

The ETRM metadata documents two procedures for this package:

• PRC_APPL_HIST — Processes the application history portion of the import. It reads pending applicant history rows from the staging area, resolves the associated party and application records, and inserts or updates the corresponding application history interface rows for downstream validation and loading.
• PRC_APPL_INST_HIST — Processes the application institution history portion of the import. It handles the institution-level history attributes attached to an application, moving them from the generic interface staging table into the dedicated institution history interface table.

No public parameter lists are documented in the ETRM extract; callers should not assume a signature. The procedures are intended to be invoked by the parent import driver, not directly.

Tables Accessed

The package operates over the following documented tables (accessed through APPS synonyms):

• IGS_AD_INTERFACE_ALL — the shared admissions staging table that holds raw imported applicant, application and history rows awaiting processing. This is the primary source table for both procedures.
• IGS_AD_APPHIST_INT — the application history interface table, populated by PRC_APPL_HIST and subsequently consumed by the validation/loading stages.
• IGS_AD_INSTHIST_INT — the institution history interface table, populated by PRC_APPL_INST_HIST.
• IGS_AD_NOTES_INT — the notes interface table, used to carry admissions notes associated with the imported history records.
• HZ_PARTIES — the Trading Community Architecture party table, read to resolve the correct party identifier for each imported person so that history records are attached to the right party.

Usage Notes

IGS_AD_IMP_027 is an internal worker package and is not intended for direct invocation. In practice it is called from within the admissions import batch flow, most commonly orchestrated by sibling package IGS_AD_IMP_015, which the ETRM dependency listing identifies as the sole referencing object. This confirms the package forms part of a numbered import sequence in which an earlier package drives the population and the subsequent package (IGS_AD_IMP_027) is invoked to complete specific history segments.

Typical invocation paths include the standard admissions interface concurrent programs and any custom wrapper that reuses the delivered import chain. Because IGS_AD_IMP_027 writes to interface tables rather than to base admissions tables, its output must still pass through the standard validation and loading programs before it becomes visible in the application. When debugging import failures, DBAs and technical consultants should inspect the interface tables listed above and trace back to the staging rows in IGS_AD_INTERFACE_ALL. Note that package status is VALID in the reported environment, and no direct end-user form calls this package.