Search Results igs_he_st_spa_all_s

Overview

The package body APPS.IGS_HE_ST_SPA_ALL_PKG is a generated PL/SQL API belonging to the Oracle E-Business Suite Higher Education (IGS) product family. The IGS_HE_ST_SPA_ALL naming convention identifies it as the student progression and awards (SPA) entity within the Higher Education module, and the _ALL suffix confirms it is a multi-org (multi-organization) enabled object. The package body is the implementation counterpart to the package specification and provides the procedural interface through which the SPA base table is inserted, queried, updated, locked, and validated. It encapsulates all row-level Data Manipulation Language (DML) activity and constraint checking for the underlying table, so that forms, concurrent programs, and other EBS APIs do not write to the table directly. The package is owned by APPS and holds a status of VALID in the documented 12.1.1 metadata, with no database objects depending on it, meaning it sits at the top of its dependency chain.

Key Procedures and Functions

Ten documented procedures and functions comprise the public API surface of this package body:

• INSERT_ROW — inserts a new record into the SPA base table.
• UPDATE_ROW — modifies an existing row, typically keyed by the primary key.
• DELETE_ROW — removes an existing row from the base table.
• ADD_ROW — adds a row, applying the set of default and derived values required before insert.
• LOCK_ROW — acquires a row-level lock to guard against concurrent updates before DML is performed.
• GET_PK_FOR_VALIDATION — returns primary key information used during validation routines.
• GET_UK_FOR_VALIDATION — returns unique key information used to enforce uniqueness during validation.
• GET_FK_IGS_EN_STDNT_PS_ATT_ALL — resolves the foreign key relationship to the student attempt entity, preserving referential integrity with IGS_EN_STDNT_PS_ATT_ALL.
• CHECK_CONSTRAINTS — validates business and database constraints prior to committing changes.
• BEFORE_DML — a pre-DML hook that standardizes key population, WHO/audit column assignment, and validation sequencing.

Tables Accessed

The package operates against the following objects, resolved through APPS synonyms:

• IGS_HE_ST_SPA_ALL — the primary base table that stores student progression and award records. All insert, update, delete, and lock operations target this table.
• IGS_HE_ST_SPA_ALL_S — the companion sequence (or shadow) object referenced by the package for surrogate key generation, supporting the primary key lookups exposed by GET_PK_FOR_VALIDATION.
• DUAL — used for single-row selects, typically in default value resolution and validation checks.

Additional read dependencies include IGS_EN_STDNT_PS_ATT_PKG, IGS_HE_ST_SPA_UT_ALL_PKG, IGS_GE_GEN_003, IGS_GE_MSG_STACK, IGS_SC_GEN_001, FND_GLOBAL, FND_MESSAGE, and APP_EXCEPTION, which together supply student attempt retrieval, utility routines, common validations, message stack handling, and user context information.

Usage Notes

Because this is a generated table-handler API, it is not normally invoked directly by end users. It is called by Oracle Forms served from the Higher Education responsibility, by concurrent programs performing bulk progression and award processing, and by custom extensions that require validated, audited inserts into IGS_HE_ST_SPA_ALL. The BEFORE_DML and CHECK_CONSTRAINTS routines are expected to be called first so that WHO columns, keys, and constraint validations are applied before INSERT_ROW, UPDATE_ROW, or DELETE_ROW execute. Callers should wrap invocations in exception handlers because the package propagates errors through the standard APP_EXCEPTION and FND_MESSAGE mechanisms. The metadata records that this package body is referenced by ten other packages and references none that reference it, confirming it is a foundational dependency for the SPA processing flow.