Search Results igs_fi_fee_cat_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_FI_FEE_CAT_PKG package is a core Oracle Student System (formerly Oracle Student Administration / iGS) database object that manages the population, maintenance, and validation of rows in the Fee Category entity. Its underlying table, IGS_FI_FEE_CAT_ALL, stores the fee category definitions used throughout the financials area of the Student System, providing the classification layer by which chargeable items are grouped, priced, and attributed to students, program enrollments, and calendar instances. In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema, is registered with a status of VALID, and is classified under the ETRM as an OTHER API rather than a published public API. This classification indicates that although the package exposes callable procedures, it is intended primarily as an internal persistence layer rather than a formally supported integration interface.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions within the package:

  • INSERT_ROW — Performs the physical insertion of a new fee category record into IGS_FI_FEE_CAT_ALL, applying the WHO columns and default attributes required by the table definition.
  • LOCK_ROW — Acquires a row-level lock on an existing fee category record to guarantee serialized access prior to an update or delete within the same transaction.
  • UPDATE_ROW — Applies modified attribute values to an existing fee category row, updating the audit columns as part of the DML operation.
  • ADD_ROW — Provides a higher-level entry point that orchestrates row creation, typically sequencing validation and the underlying insert logic.
  • DELETE_ROW — Removes an existing fee category record from the table, normally after lock and constraint checks have succeeded.
  • GET_PK_FOR_VALIDATION — Resolves or confirms the primary key value for a fee category so that dependent validation logic can be executed against the correct record.
  • CHECK_CONSTRAINTS — Evaluates the business and referential rules that govern fee category data, ensuring that dependent records and cross-entity relationships remain consistent before DML proceeds.
  • BEFORE_DML — Acts as the pre-DML hook that fires on insert, update, or delete, centralizing the attribute derivation, locking, and validation that must occur before the row is committed.

Tables Accessed

The package operates against a single documented base table, accessed through an APPS synonym: IGS_FI_FEE_CAT_ALL. All insert, update, delete, and lock operations described above are directed at this table, which holds the fee category definitions and their validation attributes. The package does not, per the ETRM dependency listing, reference additional application tables directly; broader cross-entity validation is delegated to packages that call into it.

Usage Notes

IGS_FI_FEE_CAT_PKG is referenced by eight other packages, including IGS_AD_PS_APLINSTHST_PKG, IGS_AD_PS_APPL_INST_PKG, IGS_EN_SPA_TERMS_PKG, IGS_EN_STDNT_PS_ATT_PKG, IGS_FI_FEE_CAT_MAP_PKG, IGS_FI_F_CAT_CA_INST_PKG, and the legacy SPA packages IGS_EN_SPAT_LGCY_PUB and IGS_EN_SPA_LGCY_PUB. This dependency pattern confirms the package is invoked indirectly from admissions, enrollment, and fee mapping processes whenever fee category data must be created or validated. Typical invocation occurs through the Fee Category maintenance form, through concurrent processes that generate fee category mappings, and from custom extensions that require controlled DML against IGS_FI_FEE_CAT_ALL. Because the ETRM classifies the package as OTHER, customizations should avoid calling the low-level row procedures directly; instead, changes to fee category data should be routed through supported forms or the enclosing business flows so that BEFORE_DML, CHECK_CONSTRAINTS, and LOCK_ROW execute in the intended sequence.