Search Results igs_ad_interface_batch_id_s

Overview

IGR_GEN_002 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The package forms part of the Student System (IGS) advanced admissions integration layer, providing utility logic for managing the interface staging tables that bridge external admissions data and the core student records. Its central responsibility is batch management for the advanced admissions interface: it resolves the correct interface batch identifier and purges staged inquiry detail rows that have already been processed or are no longer required.

The package is classified under ETRM as an "OTHER" API type, meaning it is not a formally registered public API with guaranteed interface contracts, but rather an internal supporting program invoked by other components of the admissions integration flow. The presence of the IGS_AD_INTERFACE_BATCH_ID_S sequence among its dependencies indicates the package participates directly in the creation and retrieval of batch identifiers used to group interface records for processing.

Key Procedures and Functions

• GET_LATEST_BATCH_ID — Returns the most recent interface batch identifier, allowing callers to obtain the current active batch for admissions data loading or validation logic. This is commonly used when a process needs to reconcile or report against the latest staged batch.
• GET_BATCH_ID — Resolves a batch identifier for a given context. Whereas GET_LATEST_BATCH_ID returns the newest batch, GET_BATCH_ID provides a targeted lookup, typically for a specific interface run or user context derived from FND_GLOBAL and FND_USER (for example, the logged-in user who initiated the load).
• DELETE_INQUIRY_DTLS — Removes inquiry-level detail records from the interface staging tables. This procedure supports housekeeping of the admissions interface, clearing intermediate data after it has been transferred to the production tables, thereby keeping the staging area performant.

All three routines interact with the sequence IGS_AD_INTERFACE_BATCH_ID_S and the control table IGS_AD_INTERFACE_CTL to coordinate batch numbering. No parameter lists are documented in the ETRM metadata, so callers should reference the deployed package specification for exact signatures.

Tables Accessed

The package references a substantial set of advanced admissions and person interface tables through APPS synonyms. The primary control and staging tables are:

• IGS_AD_INTERFACE_CTL — the control table governing batch processing state.
• IGS_AD_INTERFACE_ALL — the principal advanced admissions interface table holding staged applicant and inquiry records.
• IGS_AD_INTERFACE_BATCH_ID_S — the sequence that generates unique batch identifiers.
• IGS_AD_IMP_BATCH_DET — import batch detail records associated with each load.

Supporting interface tables include IGS_AD_ACADHIS_INT_ALL (academic history), IGS_AD_ADDR_INT_ALL (addresses), IGS_AD_CONTACTS_INT_ALL (contacts) and IGS_AD_STAT_INT (status). Person-related staging is handled via IGS_PE_RACE_INT, while IGR_I_APPL_INT and IGR_I_LINES_INT carry inquiry application and line-level data. FND_USER and FND_GLOBAL supply the runtime user and session context, DUAL is used for singleton queries, and FND_MESSAGE with IGS_GE_MSG_STACK and APP_EXCEPTION provide the error and message handling framework used for exception reporting.

Usage Notes

IGR_GEN_002 is invoked internally by the advanced admissions interface concurrent programs and by related packages rather than being called directly from Oracle Forms. Typical invocation points are batch validation, batch load and inquiry purge processes where the program must determine the active batch identifier before writing staged rows, and where obsolete inquiry detail must be deleted after successful promotion.

Because the package is not referenced by any other database object per the ETRM dependency report, it functions as an entry-level utility within its own integration flow. Customizations that call GET_LATEST_BATCH_ID, GET_BATCH_ID or DELETE_INQUIRY_DTLS should treat the sequence IGS_AD_INTERFACE_BATCH_ID_S as the authoritative source of batch numbering and must respect the same user context conventions applied by the standard concurrent programs. The package is not a supported public API, so use in extension code should be validated against the specific EBS point release, as internal logic may differ between 12.1.1 and 12.2.2.