Search Results b_s_cont_assets

Overview

IGF_AP_EFC_SUBF is an Oracle Application Object Library (APPS) PL/SQL package within the Oracle E-Business Suite (EBS) environment, specifically associated with the Oracle Financials for India (IGF) module. Its primary business function is to support the calculation and derivation of the Estimated Family Contribution (EFC) and related income and asset contribution values used within the student financial aid and grants processing domain. The EFC_SUBF suffix indicates this package serves as a subroutine or sub-function helper package, supplying foundational computational logic that higher-level EFC processing packages rely upon. The package resides in the APPS schema and is classified as an OTHER API type in the ETRM repository, meaning it is not a standard public API but rather an internal computational utility. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2 systems, confirming that it is actively deployed and compiled against these releases.

Key Procedures and Functions

The ETRM metadata documents 29 procedures and functions within this package. These names follow a structured naming convention that reflects the computational dimensions they address. The A_P_INC, A_ALLOW_AG_P_INC, A_AVAILABLE_INC, A_P_CONT, A_P_CONT_ASSETS, and A_P_CONT_LESS_9 procedures relate to parent income contributions and asset assessments under scenario A, including allowance adjustments and cases involving less than nine dependents. The A_S_INC, A_ALLOW_AG_S_INC, A_S_CONT, A_S_CONT_ASSETS, and A_S_CONT_LESS_9 procedures address student-specific income and contribution calculations for scenario A. The A_EFC and A_EFC_NOT_9 procedures produce the Estimated Family Contribution under scenario A, including a variant for households with fewer than nine members. The A_P_CONT_MORE_9 procedure covers parent contribution for larger dependent counts. The B_S_INC, B_ALLOW_AG_S_INC, B_S_CONT, B_S_CONT_ASSETS, and B_EFC procedures mirror the student income, asset, and EFC computations under an alternative scenario B, with B_EFC_LESS_9 providing the corresponding variant for smaller household sizes.

Tables Accessed

The package references several tables through APPS synonyms. IGF_FC_AST_PC_DT stores asset assessment percentage detail and supports the asset contribution logic. IGF_FC_EFC_FRM_A, IGF_FC_EFC_FRM_B, and IGF_FC_EFC_FRM_C are EFC formula definition tables for their respective scenarios, providing the stored formula elements the package evaluates. IGF_FC_GEN_TAX_RTS supplies general tax rate values used in income-based calculations. IGF_FC_INC_PRCT holds income percentage parameters, and IGF_FC_STATE_TX stores state tax information that adjusts income computations for jurisdictional differences.

Usage Notes

This package is not intended for direct invocation. It is referenced by IGF_AP_ASSUMPTION_REJECT_EDITS and IGF_AP_EFC_CALC, both of which call into its procedures during the EFC determination and validation cycle. It also exhibits recursive self-reference, indicating internal calling among its own procedures. In a standard EBS environment, the package would be invoked indirectly when users run EFC calculations through Oracle Student Financial Planning or associated concurrent programs and forms. Because it is an internal helper package, customization or direct calls should be avoided; any changes to underlying formula tables will propagate through this package when the parent calculation processes execute.