Search Results igs_ad_interface_ctl_s

Overview

The APPS.IGS_AD_INTERFACE_CTL_PKG package body is a server-side PL/SQL unit within the Oracle E-Business Suite (12.1.1 and 12.2.2) Student System / Academic and Admissions (IGS) product family. Its primary business function is to manage the persistence and validation logic for the IGS_AD_INTERFACE_CTL entity — an interface control record used to orchestrate the import and processing of external admissions and prospect data into the institution's Oracle Student System. It follows the standard Oracle Forms "table handler" generation pattern, in which a package body encapsulates row-level DML operations, primary and foreign key resolution, constraint enforcement, and pre-DML event handling for a specific base table.

The package is a member of the AD (Admissions) module infrastructure and operates strictly against APPS synonyms, ensuring schema-independent access to the underlying IGS objects.

Key Procedures and Functions

ETRM documents ten procedures and functions in this package body. Their documented purposes are as follows:

• INSERT_ROW — Inserts a new interface control row into the base table.
• LOCK_ROW — Applies a row-level lock to guard against concurrent modification during a transaction.
• UPDATE_ROW — Updates an existing interface control row with modified attribute values.
• ADD_ROW — Adds a fully validated row, typically combining insert semantics with derived or defaulted column values.
• DELETE_ROW — Removes an interface control row from the base table.
• GET_PK_FOR_VALIDATION — Returns the primary key of the current record for use in validation routines.
• GET_FK_IGS_PE_SRC_TYPES — Resolves the foreign key referencing the source types entity (IGS_PE_SRC_TYPES), invoked via IGS_PE_SRC_TYPES_PKG.
• GET_FK_IGS_PE_MATCH_SETS — Resolves the foreign key referencing the matching sets entity (IGS_PE_MATCH_SETS), invoked via IGS_PE_MATCH_SETS_PKG.
• CHECK_CONSTRAINTS — Performs programmatic validation of database constraints before a DML statement is committed.
• BEFORE_DML — A pre-DML trigger-style handler that runs preparatory logic (defaulting, derived columns, auditing) prior to INSERT or UPDATE.

Tables Accessed

The package operates against two documented objects, both referenced through APPS synonyms:

• IGS_AD_INTERFACE_CTL — The primary base table holding interface control records. All INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, and ADD_ROW operations target this table.
• IGS_AD_INTERFACE_CTL_S — The corresponding translated/security (TL-style) table, referenced in the object dependency list and consistent with the standard Forms table-handler pattern for multi-language or descriptive support.

Foreign key resolution against IGS_PE_SRC_TYPES and IGS_PE_MATCH_SETS is performed indirectly through the IGS_PE package APIs rather than by direct query.

Usage Notes

Because this is a generated table-handler package body, it is typically invoked from the corresponding Oracle Forms module for the Admissions Interface Control window, where form triggers (KEY-COMMIT, KEY-CREREC, KEY-DELREC, and block-level PRE-INSERT/PRE-UPDATE) delegate to the documented procedures. It may also be called from custom PL/SQL code or concurrent processing that needs to programmatically create, modify, or lock admissions interface control records while respecting the same constraint and defaulting rules applied interactively.

Supporting dependencies include APP_EXCEPTION, FND_GLOBAL, FND_MESSAGE, and IGS_GE_MSG_STACK for error handling and message resolution. The dependency listing confirms the package is not referenced by any other database object, but two other packages reference it — indicating its role as a leaf-level DML utility rather than a shared API foundation. Any modification must preserve the BEFORE_DML and CHECK_CONSTRAINTS sequencing to maintain data integrity.