Search Results igs_ad_code_classes_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_AD_CODE_CLASSES_PKG package body is a server-side PL/SQL component within the Oracle E-Business Suite Advanced Degree (IGS_AD) product family, a module of the Oracle Student System (formerly Oracle Student Administration). Its primary business function is to encapsulate the data manipulation logic for the IGS_AD_CODE_CLASSES entity, which stores classification codes associated with admissions applications and related records. By centralizing insert, update, delete, and validation logic in a single package, the component enforces consistent integrity rules across the many Admissions subprocesses that depend on classification data. The package body has a documented status of VALID in the APPS schema and is classified as an OTHER API type within the ETRM repository. It does not expose a formal public API contract in the same manner as a delivered business API, but rather serves as the internal procedural layer beneath the Admissions forms and adjunct packages. The metadata confirms that this package body references no fewer than twenty-five other IGS_AD packages, indicating that it sits at a foundational level in the Admissions dependency hierarchy.

Key Procedures and Functions

The package body exposes ten documented procedures and functions:

  • INSERT_ROW — Inserts a new classification code row into the base table, applying default and derived column values.
  • LOCK_ROW — Acquires a row-level lock on an existing record to serialize concurrent updates.
  • UPDATE_ROW — Modifies an existing classification record, maintaining audit columns.
  • ADD_ROW — Higher-level insertion routine that may perform additional validation or cross-entity processing before delegating to INSERT_ROW.
  • DELETE_ROW — Removes a classification record, subject to referential and business-rule checks.
  • GET_PK_FOR_VALIDATION — Derives or retrieves the primary key value used to validate uniqueness and existence.
  • GET_UK_FOR_VALIDATION — Retrieves the first unique key value for validation purposes.
  • GET_UK2_FOR_VALIDATION — Retrieves the secondary unique key value for validation purposes.
  • CHECK_CONSTRAINTS — Evaluates business and referential constraints before DML is committed.
  • BEFORE_DML — A pre-DML hook that standardizes WHO-column population (creation/update user and date) and other mandatory derivations.

Tables Accessed

The package operates against two documented tables, both accessed through APPS synonyms: IGS_AD_CODE_CLASSES, the base transactional table holding classification code records, and IGS_AD_CODE_CLASSES_S, the corresponding translated/secure shadow table that stores language-dependent or secured attribute values. Reads and writes are targeted exclusively at these two objects; no other base tables are documented as directly referenced.

Usage Notes

The package is not referenced by any database object at the schema level, meaning it is invoked at runtime rather than through static dependency chains. It is typically called from the Admissions maintenance forms, from concurrent programs that load or migrate classification data, and from custom code that must honor the same validation and WHO-audit conventions. Because twenty-five sibling packages depend on it for their own classification processing, modifications to its logic should be assessed for downstream impact across the IGS_AD module. All calls should be made in the APPS schema context, with FND_GLOBAL and FND_PROFILE available for session and profile-option resolution.