Search Results prc_pe_passport

Overview

IGS_AD_IMP_026 is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the import and validation of student visa, passport, and visitor history data within the Oracle Student System (formerly Oracle iGS, now part of the Student Information System). Its principal business purpose is to move records from interface (staging) tables into the base tables that hold person-level immigration data, and to expose validation routines that public APIs can call before committing data. The package is closely associated with the SEVIS (Student and Exchange Visitor Information System) build, originally created to satisfy U.S. regulatory reporting requirements for international students. The header identifies bug numbers 2599109 and 3847525, indicating maintenance driven by statutory reporting compliance.

Key Procedures and Functions

The package exposes four data movement procedures and three public validation functions:

• PRC_PE_VISA — Processes visa records from the interface tables into the base visa tables for a given source type and batch.
• PRC_PE_PASSPORT — Processes passport interface records into the base passport tables, keyed by source type and batch identifier.
• PRC_PE_VISIT_HISTRY — Processes visitor history interface records into the base visit history tables.
• PRC_PE_EIT — Processes EIT (Extra Information Type) records held in the EIT interface table.
• PRC_PE_ADDR — Processes address records from the address interface table; this procedure was added later than the original build.
• VALIDATE_VISA_PUB — A public validation function that accepts a visa record structure of type IGS_PE_VISAPASS_PUB.visa_rec_type, returns a BOOLEAN validity indicator, and provides an error code out parameter. This is the routine matched by the search term "validate_visa_pub."
• VALIDATE_VISIT_HISTRY_PUB — The equivalent validator for visitor history records.
• VALIDATE_PASSPORT_PUB — The equivalent validator for passport records.

The three _PUB functions were deliberately relocated to package level so that the Visa, Passport, and Visit History Public APIs can invoke consistent validation logic.

Tables Accessed

The package reads and writes interface tables and their corresponding base tables through APPS synonyms. Inbound staging data is held in IGS_PE_VISA_INT, IGS_PE_PASSPORT_INT, IGS_PE_VST_HIST_INT, IGS_PE_EIT_INT, IGS_AD_INTERFACE_ALL, and IGS_AD_ADDR_INT_ALL. Processed results are written to the base tables IGS_PE_VISA, IGS_PE_PASSPORT, IGS_PE_VISIT_HISTRY, and IGS_PE_EIT. Validation routines consult TCA tables HZ_LOCATIONS and HZ_PARTY_SITES to resolve and confirm address geography. IGS_PE_VISA_INT supplies the error code data type used by the validators, and PLITBLM is referenced for standard EBS PL/SQL table handling utilities.

Usage Notes

IGS_AD_IMP_026 is an internal import engine rather than an end-user API. It is typically invoked from concurrent programs and batch import jobs that load international student data in bulk, and the validation functions are called by the higher-level Visa, Passport, and Visit History Public APIs before records are committed. Because the package is documented as referenced by three other packages, care should be taken when modifying signatures, particularly the record types sourced from IGS_PE_VISAPASS_PUB. The dependency on TCA (HZ) tables means the package operates in environments where Trading Community Architecture is installed and configured. Customizations should extend, rather than replace, the existing validation logic so that SEVIS-related data integrity rules remain intact.