Search Results igs_ad_admde_int_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_AD_ADMDE_INT_PKG package is a PL/SQL database object within the Oracle E-Business Suite (EBS) Advanced Education/Student System (IGS) product family. Its name derives from the IGS Admissions (IGS_AD) module, with ADMDE_INT indicating "Admission Decision" interface processing. The package provides the supporting DML (Data Manipulation Language) logic that maintains records in the admissions decision interface staging tables, which hold decision data exchanged with external systems or downstream Oracle Student System components.

In EBS 12.1.1 and 12.2.2, this package is registered in the APPS schema with a status of VALID and is classified under the ETRM API classification of OTHER. It functions primarily as an internal maintenance package rather than a public business API, and its procedures are typically invoked by other packages rather than being called directly by end users. The ETRM documentation confirms that it is referenced by three other packages within the APPS schema, reflecting its role as a shared utility in the admission decision workflow.

Key Procedures and Functions

Seven documented procedures and functions constitute the functional surface of this package:

  • INSERT_ROW — Inserts a new admission decision interface record into the underlying staging table.
  • LOCK_ROW — Acquires a row-level lock on an existing interface record to prevent concurrent modification during a transaction.
  • UPDATE_ROW — Applies updates to an existing interface record, typically following validation.
  • ADD_ROW — Adds a row to the interface structure, functioning as a higher-level entry point that may combine validation and insertion logic.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key value required to validate a specific interface row prior to commit.
  • DELETE_ROW — Removes an interface record, used when a decision record is rejected, superseded, or purged.
  • BEFORE_DML — A trigger-style procedure that executes pre-DML processing such as deriving WHO columns, timestamps, or default values.

This collection follows the standard Oracle EBS Table Handler API pattern, where a package encapsulates all DML operations against a single logical entity.

Tables Accessed

Per the ETRM metadata, the package references two APPS synonym tables:

  • IGS_AD_ADMDE_INT_ALL — The base (multi-org or multilingual) table storing admission decision interface records. Most INSERT, UPDATE, DELETE, and LOCK operations target this table.
  • IGS_AD_ADMDE_INT_S — The corresponding security or sequence-related shadow table, typically used to validate row-level access or primary key integrity during GET_PK_FOR_VALIDATION.

The _ALL and _S suffix convention is standard across Oracle IGS, indicating that the package operates against the complete data set while enforcing security restrictions through the _S table.

Usage Notes

Because IGS_AD_ADMDE_INT_PKG is a table handler rather than a published business API, it is generally not invoked by forms or concurrent programs directly. Instead, it is called by the three dependent packages documented in the ETRM metadata: IGS_AD_ADMDE_INT_PKG (self-referencing wrapper logic), IGS_UC_EXPORT_DECISION_REPLY, IGS_UC_EXPORT_TO_OSS, and IGS_UC_EXPUNGE_APP. These callers handle export of decision replies, outbound transmission to the Oracle Student System, and application expungement respectively.

Customizations and extensions that need to manipulate admission decision interface data should invoke these procedures rather than writing direct DML, preserving the integrity of the BEFORE_DML audit and validation logic. Developers should also note the dependency on SYS.STANDARD, confirming that the package relies on core PL/SQL built-ins only and has no dependency on Java or external libraries. As with all ETRM-documented objects, refer to the Oracle Proprietary and Confidential legal notice before redistributing excerpts.