Search Results sum_fee

Overview

The APPS.IGS_FI_PRC_FEE_ASS package body is a core component of the Oracle E-Business Suite Student Systems (IGS) fee assessment engine. Its primary business function is to process and calculate student fee assessments, including the derivation of fee amounts, the application of fee categories and rates, and the creation of retention charges. It operates within the financials integration layer of the student information model, where student program enrollments, course attempts, and institutional calendar instances are evaluated against configured fee structures. The package is classified as an OTHER API, meaning it is not a formally published open interface but is still referenced internally by other application modules. According to the ETRM metadata, it is referenced by four other packages, indicating that it occupies an intermediary position in the fee calculation call stack rather than serving as a top-level entry point.

Key Procedures and Functions

• FINP_INS_ENR_FEE_ASS — Documented as a function responsible for inserting enrollment fee assessment records. Change history in the source header shows it was repeatedly modified to (a) return and log a message when no fee category is attached to the Student Program Attempt (SPA), and (b) manage the global waiver calculation flag g_v_wav_calc_flag after invoking the waiver creation procedure. This function also governs whether a rollback should occur: when the fee assessment is invoked from tuition waiver logic, rollback is suppressed to avoid discarding waiver records. The function is central to the enrollment-level assessment path.
• FINPL_CLC_SUA_CP — A calculation procedure associated with Student Unit Attempt (SUA) and related combinations. Based on the naming convention and the surrounding package functions (such as finpl_ins_fee_ass and finpl_prc_fee_cat_fee_liab), this procedure participates in computing assessed amounts from the applicable fee rates and fee categories. It is enumerated in the ETRM metadata as one of the two documented program units.

Tables Accessed

The package reads and writes a broad set of student and fee configuration tables through APPS synonyms:

• IGS_FI_FEE_AS_ITEMS, IGS_FI_FEE_AS_RATE, and IGS_FI_FEE_TYPE_ALL — store the fee assessment line items, applicable rates, and fee type definitions used to derive charge amounts.
• IGS_FI_F_CAT_CA_INST and IGS_FI_F_CAT_FEE_LBL_ALL — link fee categories to calendar instances and provide the fee category labels applied during assessment.
• IGS_FI_FEE_STR_STAT — holds fee structure status information relevant to eligibility and processing state.
• IGS_FI_FAI_DTLS — stores fee assessment instance detail records that the package populates.
• IGS_EN_STDNT_PS_ATT_ALL and IGS_EN_SU_ATTEMPT_ALL — supply student program attempt and student unit attempt data that drive the assessment scope.
• IGS_CA_INST_ALL and IGS_PS_VER_ALL — provide calendar instance and program version context for fee category mapping.
• IGS_AD_APPL_ALL and HZ_PARTIES — supply admission application and party (person) information used to identify the assessed student.
• FND_LOOKUP_VALUES and FND_NEW_MESSAGES — support flexible value lookups and message retrieval for validation and error logging.

Usage Notes

This package is not a standalone entry point. It is invoked indirectly during fee assessment processing, typically triggered from enrollment or registration flows, concurrent programs that assess fees in batch, or from the tuition waiver logic path referenced in the change history. The presence of the global flag g_v_wav_calc_flag indicates that calling contexts must be aware of whether waivers are being processed, because rollback behavior changes accordingly. Custom code that calls this package directly should use the documented procedures only (FINP_INS_ENR_FEE_ASS and FINPL_CLC_SUA_CP) and should not assume any signature beyond what the ETRM registers, as the remaining internal functions are private to the body. Because the package is referenced by four other packages and touches fee assessment detail tables, any direct invocation should be coordinated with the standard fee assessment lifecycle to avoid orphaned or duplicate assessment records.