Search Results get_fk_igs_pe_match_sets




Overview
Explore in AI Chat

Overview

The APPS.IGS_AD_INTERFACE_CTL_PKG package is a PL/SQL interface control package delivered as part of the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 codebase. It resides in the APPS schema and is classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API classification, indicating that it is a generated or supporting package rather than a formally published public API. Its status is recorded as VALID.

The package governs the interface control mechanism for the Student Systems "AD" (Admissions) product line, specifically the IGS_AD_INTERFACE_CTL interface control table used to manage the staging and validation of admissions interface data before it is loaded into the base application tables. In the Oracle Student System (formerly Oracle Student Systems, released with EBS 12.1.x and carried forward into 12.2.x), the IGS_AD schema objects support admissions processing, prospect and applicant data conversion, and integration with external sources. The interface control package provides the low-level data manipulation and validation routines used by the interface control form and by the import infrastructure (including the referenced concurrent program IGS_AD_IMP_001).

Key Procedures and Functions

ETRM documents ten procedures and functions within this package. Their purposes are as follows:

  • INSERT_ROW — Inserts a new row into the interface control table, applying default values and column derivations.
  • LOCK_ROW — Acquires a row-level lock on a specified record to protect it during concurrent update operations.
  • UPDATE_ROW — Updates an existing interface control record with modified attribute values.
  • ADD_ROW — Adds a new interface control entry, typically the first step in registering an inbound admissions interface run.
  • DELETE_ROW — Removes a specified interface control record.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of the target row so that validation logic can reference it.
  • GET_FK_IGS_PE_SRC_TYPES — Returns the foreign key value linking the control record to the IGS_PE_SRC_TYPES source type reference table.
  • GET_FK_IGS_PE_MATCH_SETS — Returns the foreign key value linking the control record to the IGS_PE_MATCH_SETS match set reference table.
  • CHECK_CONSTRAINTS — Enforces referential and business rule constraints before committing a row.
  • BEFORE_DML — A pre-DML trigger-style routine that performs required housekeeping and audit field population before insert, update, or delete operations.

No parameter signatures are published in the ETRM excerpt; only names and functional intent are documented.

Tables Accessed

The package operates against two recorded objects:

  • IGS_AD_INTERFACE_CTL — The primary interface control table. It serves as the header table that records each admissions interface run, its source type, match set, processing status, and audit information.
  • IGS_AD_INTERFACE_CTL_S — The corresponding translations/segments shadow table, which stores attribute values keyed to the control record and, in generated Oracle code, holds the descriptive or seed data associated with the parent table.

Both objects are accessed through APPS synonyms, consistent with standard EBS multi-org and schema-synonym conventions. The package reads and writes these tables to register, update, lock, and validate each admissions interface control entry.

Usage Notes

This package is invoked by the admissions interface form and by the concurrent import program IGS_AD_IMP_001, which ETRM lists as a dependent object. It is also referenced by IGS_PE_SRC_TYPES_PKG, reflecting the lookup and source-type dependency chain. Because the routines follow the standard Oracle Forms-generated TABLE API pattern (INSERT_ROW, LOCK_ROW, UPDATE_ROW, DELETE_ROW, CHECK_CONSTRAINTS, BEFORE_DML), the package is normally called from the interface control maintenance form rather than directly by end users. Oracle does not publish these procedures as a supported public API; customers extending admissions processing should treat IGS_AD_INTERFACE_CTL_PKG as an internal, unsupported object and rely on the documented interface tables and concurrent program instead. Direct modifications to package body logic are lost on patching and are not supported by Oracle Support.