Search Results igs_fi_sub_elm_rng_pkg




Overview
Explore in AI Chat

Overview

IGS_FI_SUB_ELM_RNG_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Student Systems financials subsystem, specifically the fee sub-element range functionality used by Student Financial Aid and student fee processing. In Oracle EBS 12.1.1 and 12.2.2, this package is classified as an internal processing package (API classification OTHER) rather than a public open interface. Its primary business role is to maintain the data integrity of the sub-element range entity by providing the standard table-handling operations used by Oracle Forms-generated code and dependent PL/SQL programs. The package closely follows the conventional Oracle Forms table handler pattern, exposing row-level insert, update, lock, and validation routines along with DML event hooks. It is tightly integrated with other Student Systems fee packages, most notably IGS_FI_GEN_003, IGS_FI_PRC_FEE_ROLLV, and IGS_FI_SUB_ER_RT_PKG, which depend on it to resolve and validate sub-element range definitions during fee calculation, fee rollover, and effective rate processing.

Key Procedures and Functions

ETRM documents eight procedures and functions within this package. Their documented purposes are:

  • INSERT_ROW — Performs the physical insert of a new sub-element range record into the underlying table, applying the package's standard column derivation and audit rules.
  • LOCK_ROW — Acquires a row-level lock for the identified sub-element range record, supporting pessimistic locking during form edits or concurrent processing.
  • UPDATE_ROW — Applies modifications to an existing sub-element range record, enforcing the package's update and audit conventions.
  • ADD_ROW — Handles the addition of a new row, coordinating key generation and validation before invoking the insert path (ADD_ROW no longer exists in later releases, as documented in the metadata).
  • GET_PK_FOR_VALIDATION — Returns the primary key columns required for validation, used to uniquely identify a sub-element range record during validation checks.
  • GET_UK_FOR_VALIDATION — Returns the unique key columns used for validation, ensuring that duplicate or conflicting sub-element range definitions are detected.
  • BEFORE_DML — A pre-DML event hook invoked ahead of insert, update, or delete operations to apply common business rules, defaults, and audit column population.
  • CHECK_CONSTRAINTS — Validates data against the package's business constraints before the DML is committed, raising errors when rules are violated.

Tables Accessed

The package operates against two documented tables accessed through APPS synonyms: IGS_FI_SUB_ELM_RNG, the primary table holding sub-element range definitions, and IGS_FI_SUB_ELM_RNG_S, its corresponding secondary or translation table. Through INSERT_ROW, ADD_ROW, and UPDATE_ROW the package writes to these tables; through LOCK_ROW, GET_PK_FOR_VALIDATION, and GET_UK_FOR_VALIDATION it reads and locks rows for validation and concurrency control. The remaining routines apply constraint checks and pre-DML processing across the same objects.

Usage Notes

IGS_FI_SUB_ELM_RNG_PKG is typically invoked indirectly rather than called directly by end users. It is referenced by IGS_FI_GEN_003, IGS_FI_PRC_FEE_ROLLV, and IGS_FI_SUB_ER_RT_PKG, indicating that it is consumed during fee generation, fee rollover, and sub-element effective rate processing. It is also self-referencing, consistent with an Oracle Forms table handler that maintains an IGS_FI_SUB_ELM_RNG form block, where form events trigger the LOCK_ROW, INSERT_ROW, UPDATE_ROW, ADD_ROW, and CHECK_CONSTRAINTS calls. Custom code should treat this package as an internal implementation detail; where a supported public API is required, callers should prefer the higher-level fee processing packages. Because the ADD_ROW procedure is documented as absent in later releases, any custom code that references it should be reviewed before upgrading from 12.1.1 to 12.2.2.