Search Results igs_ad_per_stm_typ_pkg




Overview
Explore in AI Chat

Overview

The package APPS.IGS_AD_PER_STM_TYP_PKG is a PL/SQL database package owned by the APPS schema that forms part of the Oracle E-Business Suite (EBS) Student Systems product family, specifically the Student Records (IGS) module. It encapsulates the data access and maintenance logic for the IGS_AD_PER_STM_TYP entity, which stores "person statement type" reference data used in academic advising and student progression processing. The package provides standardized DML operations — insert, update, delete, and row-level locking — for this reference table, ensuring that all consumers apply consistent validation and concurrency rules. According to the documented ETRM metadata for release 12.1.1, the package is classified as "OTHER" (not a formal public API) and was validated in the APPS schema. It exposes seven documented procedures and depends only on SYS.STANDARD, indicating a self-contained wrapper around the underlying table.

Key Procedures and Functions

The package implements the seven documented procedures listed below. Parameter lists are intentionally omitted; only their purposes are described.

  • INSERT_ROW — Inserts a new record into the underlying table. This is the core programmatic entry point for creating person statement type entries.
  • LOCK_ROW — Obtains a row-level lock on an existing record, typically by primary key, to prevent concurrent modification during a transaction.
  • UPDATE_ROW — Modifies an existing record, applying the caller-supplied column values to the identified row.
  • ADD_ROW — Provides a higher-level creation path, likely combining defaulting logic with insertion before delegating to the insert routine.
  • DELETE_ROW — Removes an existing record from the table, generally after the row has been locked for a controlled deletion.
  • GET_PK_FOR_VALIDATION — Retrieves or derives the primary key of a record for use in validation routines, allowing callers to confirm existence and identity before write operations.
  • BEFORE_DML — A pre-DML hook that centralizes validation or defaulting logic executed prior to the insert, update, or delete operations performed by the package.

Tables Accessed

The package operates on a single documented table, IGS_AD_PER_STM_TYP, accessed through an APPS synonym. This table holds the person statement type reference data consumed by academic advising and student statement processing. All seven procedures revolve around this table: the insert, add, update, and delete routines perform DML against it, LOCK_ROW locks specific rows within it, and GET_PK_FOR_VALIDATION queries it to return the primary key required for validation. No other tables are documented in the ETRM metadata, confirming the package's narrow, single-entity scope.

Usage Notes

Because IGS_AD_PER_STM_TYP_PKG is referenced by three other packages — IGS_AD_APPL_PERSTAT_PKG, IGS_AD_APTYP_PESTAT_PKG, and IGS_AD_SS_APPL_UPD_PAGE — its routines are typically invoked indirectly by higher-level advising and application-processing logic rather than by end users directly. In Oracle EBS 12.1.1 and 12.2.2, such packages are commonly called from OAF-based self-service pages, forms, or concurrent programs that maintain person statement type configuration data. Custom code may call the procedures when extending student advising functionality, but the package is classified as "OTHER" rather than a published API, so it should be used with caution and validated against a specific patch level before adoption. The BEFORE_DML and LOCK_ROW pattern indicates that callers should follow the package's prescribed sequence — validate, lock, then modify — to maintain data integrity and avoid concurrent update conflicts.