Search Results igs_da_setup_pkg




Overview
Explore in AI Chat

Overview

IGS_DA_SETUP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (formerly Oracle Higher Education) product family, as indicated by the IGS prefix. The package conforms to the standard Oracle EBS "table handler" design pattern, in which a single package encapsulates the full set of Data Manipulation Language operations and validation logic for one underlying table. In this case, the package manages the IGS_DA_SETUP table, which stores setup and configuration data used by the Oracle Student System's data administration and related processing components. Because the package is documented as VALID and is classified as "OTHER" rather than a public API, it functions primarily as an internal building block invoked by forms and by higher-level packages rather than as a direct integration point.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions within IGS_DA_SETUP_PKG. Their names follow the conventional Oracle EBS CML (Common Module Logic) naming standard:

  • INSERT_ROW — Inserts a new record into the IGS_DA_SETUP table.
  • LOCK_ROW — Obtains a row-level lock on an existing IGS_DA_SETUP record, typically in preparation for an update or delete, ensuring concurrency control.
  • UPDATE_ROW — Modifies the attributes of an existing IGS_DA_SETUP record.
  • ADD_ROW — Provides an alternative or higher-level entry point for adding a record, often wrapping validation and INSERT_ROW logic.
  • DELETE_ROW — Removes a record from the IGS_DA_SETUP table.
  • GET_PK_FOR_VALIDATION — Returns the primary key value of an IGS_DA_SETUP record, used for validation lookups.
  • GET_FK_IGS_EN_UNIT_SET_CAT — Retrieves a foreign key value relating to the IGS_EN_UNIT_SET_CAT entity, supporting referential validation against unit set categories.
  • GET_FK_IGS_OR_ORG_ALT_IDTYP — Retrieves a foreign key value relating to the IGS_OR_ORG_ALT_IDTYP entity, supporting validation against organization alternate identifier types.
  • BEFORE_DML — A standard pre-DML processing routine that applies common attribute defaulting, auditing, and validation logic before insert, update, or delete operations are committed.

Tables Accessed

The documented table accessed by this package is IGS_DA_SETUP, referenced through APPS synonyms. All DML operations within the package target this single table, which holds the setup rows that govern the package's related student-system functionality. The foreign-key retrieval routines indicate implicit dependency on IGS_EN_UNIT_SET_CAT and IGS_OR_ORG_ALT_IDTYP for cross-entity validation, although the metadata does not confirm direct table access to those entities.

Usage Notes

IGS_DA_SETUP_PKG is referenced by two other packages, IGS_EN_UNIT_SET_CAT_PKG and IGS_OR_ORG_ALT_IDTYP_PKG, which suggests it is called during unit set category and organization alternate identifier type processing to validate or fetch setup data. Consistent with EBS table-handler conventions, the package is most likely invoked from an Oracle Forms-based setup screen dedicated to IGS_DA_SETUP maintenance, where the form's block-level triggers call INSERT_ROW, UPDATE_ROW, LOCK_ROW, and DELETE_ROW directly. The BEFORE_DML routine would be invoked automatically by each DML procedure. Custom code or concurrent programs should avoid calling this internal package directly; instead, integration should occur through the supported public APIs of the Oracle Student System. Where direct invocation is unavoidable, the standard EBS rules apply: initialize the FND_GLOBAL session context (user, responsibility, application) before calling, and issue an explicit COMMIT after successful execution.