Search Results get_pell_efc_code

Overview

IGF_GR_GEN is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Financial Aid module of the Oracle Student System / ETRM (Enterprise Tax and Regulatory Management for higher education) product family. It serves as a general-purpose utility package supporting Pell Grant origination, disbursement, and acknowledgement processing. The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, which allows it to operate within the security context of the invoking process.

The package header carries a version history indicating it was actively maintained between 2002 and 2003, with updates tied to Financial Aid (FA) builds and bug fixes. Notable revisions include the removal of the get_rep_pell_id function in December 2003 (FA 131), the replacement of the igf_ap_fa_base_h_all.derived_attend_type%TYPE reference with igs_en_stdnt_ps_att_all.derived_att_type%TYPE as part of FA-114 (obsoletion of the FA base record history), and the addition of routines such as update_current_ssn, update_pell_status, match_file_version, and get_min_disb_number in support of FA116. The package is extensively integrated, referenced by 47 other packages within the application, underscoring its foundational role in Pell Grant processing.

Key Procedures and Functions

The ETRM metadata documents 41 procedures and functions. Among these, the following are specifically relevant to the user's search for process_pell_ack:

• PROCESS_PELL_ACK — Processes Pell Grant acknowledgement records received from the Common Origination and Disbursement (COD) system, validating and applying acknowledgement statuses against origination and disbursement data.
• GET_PELL_HEADER — Retrieves Pell Grant header information, typically for a student's origination record.
• GET_PELL_TRAILER — Retrieves Pell Grant trailer information, complementing the header for a complete origination record.
• GET_PELL_EFC — Obtains the Expected Family Contribution (EFC) value associated with a Pell Grant record.
• GET_PELL_EFC_CODE — Returns the EFC code designation used for Pell eligibility determination.
• GET_MIN_DISB_NUMBER — Determines the minimum disbursement number in a sequence, supporting disbursement sequencing.
• GET_MIN_PELL_DISB — Identifies the minimum Pell disbursement, used in reconciliation logic.
• GET_MIN_AWD_DISB — Establishes the minimum award disbursement reference.
• DISB_HAS_ADJ — Checks whether a disbursement has an adjustment applied.
• SEND_ORIG_DISB — Transmits origination and disbursement data to the external system.
• FRESH_ORIGINTN — Supports fresh origination processing.
• INSERT_SYS_HOLDS — Inserts system-generated holds against a student record.
• GET_FUND_ID, GET_ALT_CODE, GET_CYCLE_YEAR, GET_PER_NUM, GET_PERSON_ID, GET_PER_NUM_OSS, GET_SSN_DIGITS, GET_CALENDAR_DESC — Retrieval utilities for identifying funds, codes, award years, person identifiers, and calendar descriptions.

Tables Accessed

IGF_GR_GEN references a broad set of tables through APPS synonyms, reflecting its role in Pell processing:

• IGF_GR_ATTEND_PELL and IGF_GR_PELL_SETUP_ALL — Pell attendance and setup configuration.
• IGF_AW_AWARD_ALL and IGF_AW_AWD_DISB_ALL — Core award and disbursement records.
• IGF_AP_FA_BASE_REC_ALL and IGF_AP_ISIR_MATCHED_ALL — Financial aid base records and ISIR matching data.
• IGF_AW_COA_GROUP_ALL, IGF_AW_COA_GRP_ITEM_ALL, IGF_AW_COA_ITEMS, IGF_AW_COA_ITM_TERMS, IGF_AW_COA_LD_ALL — Cost of Attendance (COA) configuration and item/term structures.
• IGF_AW_FUND_CAT_ALL and IGF_AW_CIT_LD_OVRD_ALL — Fund category and citizenship/loan override data.
• IGF_DB_DISB_HOLDS_ALL — Disbursement hold records.
• FND_NEW_MESSAGES — Oracle Application Object Library message repository.

Usage Notes

IGF_GR_GEN is typically invoked from Financial Aid forms, concurrent programs, and custom PL/SQL code that manage Pell Grant origination and disbursement cycles. PROCESS_PELL_ACK, in particular, is called during the acknowledgement processing phase, after originations and disbursements have been submitted to COD and responses have been received. Because the package is referenced by 47 other packages, modifications should be approached with caution; any change to a public routine signature risks breaking dependent code. In Oracle EBS 12.1.1 and 12.2.2, the package remains part of the APPS schema, and its AUTHID CURRENT_USER declaration requires that the invoking session possess appropriate privileges on the referenced tables.