Search Results get_fk_igs_fi_fee_cat

Overview

IGS_FI_FEE_CAT_MAP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API type. It belongs to the Oracle Student System (formerly Oracle iLearning/Student Systems) family of objects, specifically the Financials component of the IGS (Intelligent Graduation System / Student Information) module. The package manages the mapping relationship between fee categories and admissions categories, providing the persistence logic for the IGS_FI_FEE_CAT_MAP table. It functions as a lower-level data-maintenance utility rather than a standalone business API, handling row-level insert, update, delete, lock, and validation operations for fee-to-admissions category assignments. Its status is documented as VALID in release 12.1.1, and it remains present in the 12.2.2 schema. The package encapsulates the DML logic that higher-level packages such as IGS_AD_CAT_PKG and IGS_FI_FEE_CAT_PKG rely upon when maintaining category mappings.

Key Procedures and Functions

The ETRM documentation records ten documented procedures and functions. Their purposes are as follows:

• INSERT_ROW — Inserts a new mapping row into IGS_FI_FEE_CAT_MAP.
• UPDATE_ROW — Updates an existing mapping row identified by its primary key.
• DELETE_ROW — Removes a mapping row from the table.
• ADD_ROW — Convenience wrapper that combines insertion logic for a new mapping record.
• LOCK_ROW — Issues a row-level lock (SELECT ... FOR UPDATE) to serialize concurrent modifications.
• GET_PK_FOR_VALIDATION — Retrieves the primary key used to validate the existence of a mapping record.
• GET_FK_IGS_AD_CAT — Returns the admissions category foreign key associated with a mapping.
• GET_FK_IGS_FI_FEE_CAT — Returns the fee category foreign key associated with a mapping.
• CHECK_CONSTRAINTS — Performs referential and business-rule validation before DML.
• BEFORE_DML — Pre-DML hook handling standard WHO column population and validation sequencing.

No parameter signatures are documented; the descriptions above reflect the documented procedure names and their evident roles within the mapping-maintenance pattern.

Tables Accessed

The package references one documented table via its APPS synonym: IGS_FI_FEE_CAT_MAP. This table stores the association between fee categories and admissions categories, and the package performs all its core DML against it. Foreign-key getters (GET_FK_IGS_AD_CAT, GET_FK_IGS_FI_FEE_CAT) confirm that the table carries references to the admissions category entity and the fee category entity respectively. By routing all access through this single table, the package isolates row-level integrity logic for fee-category mapping in one place. No other application tables are documented as directly referenced.

Usage Notes

IGS_FI_FEE_CAT_MAP_PKG is an internal utility package. The ETRM dependency listing shows it is referenced by two other packages: IGS_AD_CAT_PKG and IGS_FI_FEE_CAT_PKG (and it references itself, a common pattern for shared private helpers). It is therefore normally invoked indirectly rather than directly by end users. Typical invocation paths include:

• Forms or OAF pages in the Student Financials setup flow that establish fee-to-category mappings.
• Concurrent programs or batch loads that populate category mapping data.
• Custom PL/SQL extensions that need to insert, update, or validate mapping rows using the sanctioned DML and constraint-check routines instead of direct SQL.

Because the API classification is OTHER and no formal public API contract is documented, direct calls should be limited to controlled extension scenarios. Any custom code should invoke CHECK_CONSTRAINTS and the FK getter functions before DML to preserve referential integrity, and should respect the row-locking behaviour of LOCK_ROW in multi-user environments. Given the schema is stable across 12.1.1 and 12.2.2, no migration-specific changes to this package are documented.