Search Results igs_ad_batc_def_det_pkg




Overview
Explore in AI Chat

Overview

IGS_AD_BATC_DEF_DET_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as a non-public (OTHER) API within the Oracle Student System / Higher Education (IGS) product family. Its name indicates that it manages the "batch definition detail" entity used by the admissions (AD) module for batch processing — for example, batch validation, batch data definition, or batch import/export setup. The package provides the standard table-handling routines that support DML operations against the batch definition detail tables, and it is resolved as VALID in the ETRM 12.1.1 repository with dependencies only on SYS.STANDARD and its own package body.

Key Procedures and Functions

The documented package exposes seven procedures/functions:

  • INSERT_ROW — Inserts a new batch definition detail record into the underlying detail table and populates required columns.
  • LOCK_ROW — Acquires a row-level lock on the specified batch definition detail record to prevent concurrent modification during transactional processing.
  • UPDATE_ROW — Updates an existing batch definition detail record with new attribute values supplied by the caller.
  • ADD_ROW — Convenience routine that adds a batch definition detail row, typically combining validation and insertion logic.
  • GET_PK_FOR_VALIDATION — Returns the primary key needed for validating a batch definition detail record, used internally to derive the correct key prior to DML.
  • DELETE_ROW — Deletes a batch definition detail record identified by the caller's key values.
  • BEFORE_DML — A pre-DML trigger-style routine executed to enforce standard WHO column and validation logic before insert, update, or delete operations.

Tables Accessed

The package operates on two documented tables/views reached through APPS synonyms:

  • IGS_AD_BATC_DEF_DET_ALL — The base (ALL) detail table holding batch definition detail rows; used for insert, update, delete, and lock operations.
  • IGS_AD_BATC_DEF_DET_S — A supporting table/view (commonly a security or sequence-related object) referenced for key derivation and validation, notably by GET_PK_FOR_VALIDATION.

These tables hold the child-level detail records that describe individual entries within a defined batch, so the package's CRUD routines effectively maintain the persistence layer for that entity.

Usage Notes

The package is invoked from within the IGS Student System runtime rather than being called directly by end users. It is referenced by three other packages: IGS_UC_EXPORT_TO_OSS, IGS_UC_EXPORT_DECISION_REPLY, and IGS_UC_EXPUNGE_APP, all of which belong to the UC (UCAS admissions) integration area. This indicates that IGS_AD_BATC_DEF_DET_PKG is typically called during batch export to the OSS, decision reply export, and application expunge processes. The documented routines (INSERT_ROW, UPDATE_ROW, DELETE_ROW, ADD_ROW, LOCK_ROW, BEFORE_DML, GET_PK_FOR_VALIDATION) would normally be invoked through a forms-based maintenance screen for batch definitions or through custom concurrent/callable PL/SQL that reuses the same table-handling API. Because the package is classified as OTHER (not a formally supported public API), customizations should exercise caution, rely on the documented procedures only, and avoid direct DML against the underlying tables without invoking BEFORE_DML logic.