Search Results igs_uc_app_stats_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_UC_APP_STATS_PKG package body is a server-side PL/SQL component within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and classified under the ETRM repository as an "OTHER" API type. The IGS_UC prefix identifies it as part of the Oracle Student System (formerly Oracle Higher Education) product family, specifically the "UC" module that governs admissions applicant statistics and related reference data. The package provides the standard table-handling application programmatic interface (API) pattern used throughout the E-Business Suite for maintaining rows in the IGS_UC_APP_STATS entity. In this capacity it encapsulates the insert, update, delete, locking, validation, and pre-DML processing logic required to keep the underlying statistics table consistent, secure, and auditable. The dependency list confirms it relies on foundational EBS utilities including FND_GLOBAL, FND_MESSAGE, APP_EXCEPTION, and IGS_GE_MSG_STACK for session context, message resolution, and error stacking, and on IGS_UC_APPLICANTS_PKG for related applicant processing.

Key Procedures and Functions

The documented package metadata lists nine procedures and functions, which collectively implement the canonical EBS table API contract:

  • INSERT_ROW — Inserts a new record into the base statistics table.
  • UPDATE_ROW — Modifies an existing record identified by its primary key.
  • DELETE_ROW — Removes an existing record from the table.
  • ADD_ROW — Provides an overloaded-style entry point that determines whether an insert or update is required, typically routed by the BEFORE_DML logic.
  • LOCK_ROW — Acquires a row-level lock to prevent concurrent modification of a record during a transaction.
  • BEFORE_DML — Centralizes mandatory column defaulting, WHO-column population, and validation prior to any DML operation.
  • GET_PK_FOR_VALIDATION — Resolves the primary key needed for validation checks, returning a surrogate identifier when required.
  • GET_UK_FOR_VALIDATION — Validates and returns the unique key attributes ensuring no duplicate statistics rows are inserted.
  • GET_FK_IGS_UC_APPLICANTS — Derives and validates the foreign key relationship to the applicant entity, enforcing referential integrity.

Tables Accessed

The package operates against three documented tables accessed through APPS synonyms:

  • IGS_UC_APP_STATS — The primary base table storing applicant statistics records; this is the target of INSERT, UPDATE, and DELETE operations.
  • IGS_UC_APP_STATS_S — The corresponding sequence or shadow table used to generate surrogate primary keys for new statistic rows.
  • DUAL — Used for singleton lookups and expression evaluation during validation and defaulting logic.

Usage Notes

This package is typically invoked indirectly rather than called directly by end users. Forms built on the IGS_UC_APP_STATS entity and associated concurrent programs rely on the package's DML procedures to enforce the EBS WHO-column convention (created_by, creation_date, last_updated_by, last_update_date) and to raise standardized FND_MESSAGE errors on validation failure. The metadata indicates the package is referenced by four other database objects, confirming its role as a foundational API consumed by higher-level admissions statistics processing. Custom extensions integrating with the UC applicant statistics domain should call ADD_ROW rather than issuing direct DML, so that BEFORE_DML validation, key derivation via GET_PK_FOR_VALIDATION/GET_UK_FOR_VALIDATION, and applicant foreign-key checks are consistently applied.