Search Results igs_en_spa_terms_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_EN_SPA_TERMS_PKG package body is a student-systems PL/SQL component within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and carrying a VALID status. It belongs to the Student Information Management (IGS) product family and specifically supports the student program attempt (SPA) terms entity, exposed through the base table IGS_EN_SPA_TERMS. The package encapsulates the standard Oracle Forms-generated table handler logic — insert, update, delete, locking, foreign key validation, uniqueness checks, and pre-DML processing — allowing Forms-based maintenance of term-level program attempt records and providing a reusable API layer for other packages and custom code that must manipulate the same data. The naming convention IGS_EN_SPA_TERMS_PKG reflects the student enrollment (EN) module, the SPA TERMS table, and the standard _PKG interface, consistent with the wider ETRM-documented API classification of OTHER. Package body metadata records 14 documented procedures and functions and confirms the package does not participate in the dependency graph as a referenced object (it is invoked, not consumed, by other compiled objects). Twelve other packages reference it, indicating it is a foundational low-level table handler.

Key Procedures and Functions

The documented procedures follow the standard Oracle EBS table-handler pattern:

  • INSERT_ROW — inserts a new row into the base table, applying default and audit columns.
  • LOCK_ROW — issues a SELECT ... FOR UPDATE to lock an existing row, supporting the Forms optimistic locking model.
  • UPDATE_ROW — updates a locked row with the supplied column values and audit information.
  • ADD_ROW — combines insert-and-lock semantics for new rows within a Forms block.
  • DELETE_ROW — removes a row from the base table.
  • GET_FK_IGS_CA_INST — validates and returns the foreign key to the calendar instance.
  • GET_FK_IGS_EN_STDNT_PS_ATT — validates and returns the foreign key to the student program attempt.
  • GET_FK_IGS_FI_FEE_CAT — validates and returns the foreign key to the fee category.
  • GET_FK_IGS_PR_CLASS_STD — validates and returns the foreign key to the class standing.
  • GET_UFK_IGS_PS_OFR_OPT — resolves and returns the user-visible foreign key for the offering option.
  • CHECK_CHILD_EXISTENCE — verifies whether dependent child records exist before allowing DML.
  • GET_PK_FOR_VALIDATION — returns the primary key used for validation lookups.
  • GET_UK_FOR_VALIDATION — returns the unique (alternate) key used for validation lookups.
  • BEFORE_DML — central pre-DML hook that enforces validation, defaults, and audit rules across the block.

Tables Accessed

The package reads and writes the following base tables through their APPS synonyms: IGS_EN_SPA_TERMS (the primary entity holding term-level program attempt data), IGS_EN_SPA_TERMS_S (the corresponding translated sequence/stable table used by the Forms table handler), and IGS_CA_INST_REL (calendar instance relationships, consulted during foreign key and date validation). Dependencies also include IGS_PS_OFR_OPT for offering option validation.

Usage Notes

The package is typically invoked from the Oracle Forms UI that maintains SPA terms records, where it is bound to the block-level DML events and FK validation items. It is also called programmatically by the twelve dependent packages, including IGS_EN_PLAN_UNITS_PKG, IGS_EN_STDNT_PS_ATT_PKG, IGS_FI_FEE_CAT_PKG, and IGS_PR_CLASS_STD_PKG, whenever those components must create, read, or lock SPA term rows. Because it is an internal Forms-generated table handler rather than a published business API, custom integrations should exercise caution when calling it directly; it relies on FND_GLOBAL for session context and on APP_EXCEPTION, FND_MESSAGE, and IGS_GE_MSG_STACK for error propagation, so callers must expect and handle Oracle Forms-standard exceptions. Message tokens are drawn from standards such as IGS_GE_GEN_003 and IGS_SC_GEN_001.