Search Results igs_fi_fee_as_rate_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_FI_FEE_AS_RATE_PKG package is a component of the Oracle E-Business Suite (EBS) Student Systems / Financial Aid module, operating within the Integrated Grants and Student (IGS) schema family. In Oracle EBS 12.1.1 and 12.2.2, this package encapsulates the business logic governing Fee Assessment Rates — the assignment of fee rate structures to student records based on attributes such as attendance mode, attendance type, unit set, location, and government HEC contribution/scheme parameters. As a stored PL/SQL package owned by the APPS schema and reported with a status of VALID, it functions as a table-handler (also referred to as a "TAPI-style" package) that centralizes row-level data manipulation for the IGS_FI_FEE_AS_RATE entity. It provides the procedural interface through which both delivered Oracle forms and dependent packages create, lock, update, validate, and delete fee assessment rate records, while enforcing primary key, unique key, and foreign key integrity consistent with the entity-relationship model of the Student Financials domain.

Key Procedures and Functions

The package exposes nineteen documented program units, organized into logical groups:

Parameter lists are not specified in the ETRM metadata and should be confirmed against the package specification in the live instance.

Tables Accessed

The package reads from and writes to the following objects through APPS synonyms:

  • IGS_FI_FEE_AS_RATE — the primary transactional table storing fee assessment rate records; the target of all DML handlers.
  • IGS_FI_FEE_AS_RATE_FAR_ID_S — the sequence supplying primary key values for new rows.
  • HZ_PARTIES and IGS_PE_HZ_PARTIES — party tables consulted to validate the person/organization associated with the fee assessment rate.
  • DUAL — used for single-row evaluations, typically in the key-generation and validation functions.

Usage Notes

This package is typically invoked indirectly. It is referenced by twelve other APPS packages, including IGS_AD_LOCATION_PKG, IGS_AS_UNIT_MODE_PKG, IGS_EN_ATD_MODE_PKG, IGS_EN_ATD_TYPE_PKG, IGS_EN_UNIT_SET_PKG, IGS_FI_ELM_RANGE_RT_PKG, IGS_FI_GOVT_HEC_CNTB_PKG, IGS_FI_GOV_HEC_PA_OP_PKG, IGS_FI_PRC_FEE_ROLLV, IGS_FI_SUB_ER_RT_PKG, IGS_PR_CLASS_STD_PKG, and IGS_PS_VER_PKG. These callers include Oracle Forms-based maintenance screens and concurrent programs that roll up or process fee assessment rates. Custom extensions should call the documented APIs rather than performing direct DML on IGS_FI_FEE_AS_RATE, ensuring that constraint validation, key derivation, and audit hooks remain intact.