Search Results igs_ad_admde_int_s

Overview

The IGS_AD_ADMDE_INT_PKG package body in the APPS schema is a component of the Oracle E-Business Suite Student Systems (Advanced Education / Admissions) product family. The "AD_ADMDE_INT" naming convention designates the Admissions Admission Decision interest (INT) entity, a standard Oracle EBS interface construct that maintains a staging table (IGS_AD_ADMDE_INT_ALL) and a corresponding sequence (IGS_AD_ADMDE_INT_S) for assigning primary keys. The package encapsulates the transactional row-handling logic required to insert, update, lock, and delete admission decision interface records in a controlled, multi-tier fashion. It is classified under ETRM as an API of type OTHER, meaning it is not a formally published public API but is nonetheless a stable, dependency-bearing package relied upon by other Admissions components. Placing the DML logic in a package body rather than in a form or report allows consistent validation, key generation, and error propagation across all consumers. The object status is VALID in ETRM 12.1.1, and the same structure is carried forward in 12.1.1 / 12.2.2 environments.

Key Procedures and Functions

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

• INSERT_ROW — Performs the physical insert into the admission decision interface table, populating audit and system columns as required.
• UPDATE_ROW — Applies modifications to an existing admission decision interface row after validation.
• DELETE_ROW — Removes a specified interface row from the staging table.
• LOCK_ROW — Issues a row-level lock (SELECT ... FOR UPDATE) to serialize concurrent access to a given record, preventing lost updates.
• ADD_ROW — Higher-level insertion routine that combines key generation and row creation; typically called by external consumers rather than invoking INSERT_ROW directly.
• GET_PK_FOR_VALIDATION — Retrieves the primary key value (normally sourced from IGS_AD_ADMDE_INT_S) for validation and referential checks prior to DML.
• BEFORE_DML — Standard pre-DML hook that enforces mandatory-column, audit, and business-rule validation before any insert, update, or delete is committed.

The package depends on FND_GLOBAL and FND_MESSAGE for session context and user-facing message text, and on APP_EXCEPTION / IGS_GE_MSG_STACK for exception raising and message stacking. IGS_GE_GEN_003 provides generic entity utilities.

Tables Accessed

Two tables are documented via APPS synonyms:

• IGS_AD_ADMDE_INT_ALL — The main interface/staging table into which admission decision records are written. All DML (insert, update, delete) is directed here.
• IGS_AD_ADMDE_INT_S — The Oracle sequence supplying unique primary keys for new rows. This is the object referenced by the user's search term "igs_ad_admde_int_s".

Reads and writes are gated by the validation logic in BEFORE_DML and LOCK_ROW to preserve data integrity during concurrent admissions processing.

Usage Notes

Because IGS_AD_ADMDE_INT_PKG is a package body with no reverse dependencies documented and is referenced by three other packages, it is typically invoked indirectly rather than called ad hoc. It is commonly executed from:

• Oracle Forms modules in the Admissions responsibility that manage admission decision interface data.
• Concurrent programs that bulk-load or reconcile admission decision interface records.
• Custom PL/SQL code and other Admissions packages that require standardized DML against the interface table.

Callers should respect the package's locking protocol by invoking LOCK_ROW before UPDATE_ROW or DELETE_ROW, and should rely on BEFORE_DML for validation rather than re-implementing checks. Because the underlying table is a staging/interface entity, records are expected to be processed by downstream admissions decision logic after successful commit. The package is schema-qualified as APPS.IGS_AD_ADMDE_INT_PKG and should not be modified without a full dependency review of the three referencing packages.