Search Results igs_da_trns_imp




Overview
Explore in AI Chat

Overview

The APPS.IGS_DA_TRNS_IMP package is a component of the Oracle E-Business Suite student systems data-import layer, functionally belonging to the Academic Records (IGS) product family. Its name follows the IGS_DA convention, denoting packages that service the "Data Acquisition" or legacy-records interface used to bring external academic history and transcript information into the EBS academic structure. Specifically, IGS_DA_TRNS_IMP handles the import of external transcript, term, and unit details so that prior-learning and transferred-credit information can be associated with a party's education record. The package is classified in the ETRM repository under API classification OTHER, indicating it is an internal utility rather than a formally published public API. It is referenced by no other packages, which confirms its position as a top-level import driver that is invoked directly by concurrent processes, forms, or external loads rather than being called from within the PL/SQL application stack.

Key Procedures and Functions

Five documented procedures comprise the functional surface of this package:

  • CREATE_ACAD_HIST_REC — Creates a new or updates an existing academic history record together with the corresponding term and unit detail rows for a supplied source unit. It accepts batch, program, person-identification, term, date, course, grade, and credit inputs, and is the central routine for staging imported transcript data into the academic tables.
  • CREATE_ADV_STND_UNIT — Creates an advanced-standing unit, translating an evaluated external course or legacy unit into the standing recognized within the institution's curriculum structure.
  • CREATE_OR_GET_BATCH_ID — Establishes or retrieves the batch identifier under which a group of imported records is processed, providing a controlling key for the import run.
  • DELETE_ADV_STND_RECORDS — Removes advanced-standing records, allowing an import batch to be reversed or corrected before final commitment.
  • COMPLETE_IMPORT_PROCESS — Concludes the import cycle, finalising the batch after all records have been created or updated. This is the procedure associated with the search term complete_import_process, and it represents the terminal step of the transcript-import workflow.

Tables Accessed

The package reads and writes across the academic, person, and interface schemas. Academic history and transcript data are persisted in IGS_AD_TRANSCRIPT, IGS_AD_TERM_DETAILS, and IGS_AD_TERM_UNITDTLS; the legacy-unit interface is represented by IGS_AV_LGCY_UNT_INT, IGS_AD_TRMDT_INT, and IGS_AD_TXCPT_INT. Person identity is resolved through IGS_PE_ALT_PERS_ID, HZ_PARTIES, and HZ_EDUCATION. Batch control references IGS_DA_REQ_STDNTS and IGS_DA_RQST. Validation and grading lookups draw on IGS_AD_CODE_CLASSES and IGS_AS_GRD_SCH_GRADE. Operational messaging and audit use FND_NEW_MESSAGES and FND_USER.

Usage Notes

IGS_DA_TRNS_IMP is ordinarily driven by the transcript-import concurrent programs and associated setup forms within the Academic Records responsibility. A typical execution sequence is: obtain a batch identifier via CREATE_OR_GET_BATCH_ID, populate academic history and advanced-standing records through CREATE_ACAD_HIST_REC and CREATE_ADV_STND_UNIT, correct or roll back erroneous rows with DELETE_ADV_STND_RECORDS, and close the run with COMPLETE_IMPORT_PROCESS. Because the package is not referenced by any other package, custom code that calls it must invoke the procedures directly and must supply the batch and person-identification parameters consistent with the underlying interface tables. In 12.1.1 and 12.2.2 the package remains an APPS-owned object; direct modification is unsupported, and extensions should be implemented through wrapper code or the documented import interfaces.