Search Results sevis_primary_foreign

Overview

IGS_SV_NI_BATCH_PROCESS_PKG is an Oracle E-Business Suite PL/SQL package owned by APPS that supports the Student and Exchange Visitor Information System (SEVIS) batch processing requirements for higher-education institutions. Its documented purpose is to gather, validate, and stage SEVIS-related information for transmission to the U.S. federal SEVIS system, which tracks international students and exchange visitors. The package originated in October 2002 under the direction of Don Shellito, with the initial code authored by Arkadi Tereshenkov. Subsequent change history reflects a series of bug fixes through 2005, covering multiple transaction issues, address-related logic, status handling for addresses in site validation, and the replacement of FND user customer identifiers with person party identifiers (Bug 4293911). The package is classified as OTHER in the ETRM catalog, indicating it is an internal processing utility rather than a published public API.

Key Procedures and Functions

ETRM documents a single program unit within the package body:

• NIMG_BATCH_PROCESS — The batch processing routine that drives the collection and staging of SEVIS information for transmission. The name follows the NIMG (non-immigrant) naming convention used by the IGS (International Graduate/Student) product family. No parameter list is documented; the procedure is intended to be invoked in a batch or concurrent context to process multiple records in a single run.

The source header notes that the concurrent programs to be executed are defined globally, while all other procedures are defined internally within the package body. These internal units are not exposed in the documented metadata.

Tables Accessed

The package reads and writes a set of EBS base and interface tables through APPS synonyms, including:

• ECX_EXT_PROCESSES, ECX_TP_DETAILS, ECX_TP_HEADERS, ECX_TRANSACTIONS — E-Business Suite e-commerce exchange (ECX) tables used to define, stage, and track outbound SEVIS transmissions and their status.
• FND_LOOKUP_VALUES — Reference lookups used for code validation and translation.
• FND_USER — User context and audit information.
• HZ_CITIZENSHIP, HZ_PARTIES, HZ_PERSON_PROFILES, HZ_RELATIONSHIPS — Trading Community Architecture tables holding party, citizenship, profile, and relationship data for students.
• HZ_LOCATIONS, HZ_PARTY_SITES — Address and site information, consistent with the documented address-usage constants (SEVIS_PRIMARY_US, SEVIS_PRIMARY_FOREIGN, SEVIS_SITE_OF_ACTIVITY) and the SEVIS_SITE_OF_ACTIVITY usage.
• IGS_PE_ALT_PERS_ID, IGS_PE_DEPD_ACTIVE, IGS_PE_EV_FORM — Student-system tables for alternate person identifiers, dependent activity records, and event forms required for SEVIS reporting.

Usage Notes

IGS_SV_NI_BATCH_PROCESS_PKG is invoked in batch mode, typically through a concurrent program registered against the NIMG_BATCH_PROCESS entry point, to process groups of SEVIS-relevant records rather than individual transactions. The package is not referenced by other PL/SQL packages, which confirms it functions as a top-level processor rather than a reusable API. Institutions running the SEVIS reporting cycle invoke it to stage data for ECX-based transmission to the federal system. Custom extensions should treat the package as internal, since only the batch entry point is documented and no public API contract is published.