Search Results igf_gr_gen
Overview
IGF_GR_GEN is the core PL/SQL package body within the Oracle E-Business Suite financial aid module responsible for Pell Grant disbursement generation and acknowledgement processing. In Oracle EBS 12.1.1 and 12.2.2, the package operates under the APPS schema and is classified as an "OTHER" API type, indicating it supports internal processing logic rather than a published integration interface. The package name, combining the "IGF" (financial aid) and "GR" (grant) prefixes, reflects its role in student grant administration. Its primary business function is to assemble, validate, and transmit Pell Grant origination and disbursement records to the federal Common Origination and Disbursement (COD) system, and to process the electronic responses returned by that system.
Key Procedures and Functions
The package exposes 41 documented procedures and functions, several of which are central to grant processing:
- GET_CYCLE_YEAR — Retrieves the award cycle year associated with a processing period, anchoring calculations to the correct federal award year.
- DISB_HAS_ADJ — Determines whether a disbursement carries an adjustment, guarding downstream logic against duplicate or conflicting transmissions.
- GET_ALT_CODE, GET_PER_NUM, GET_PER_NUM_OSS, GET_PERSON_ID — Resolve student and person identifiers, including alternate identifiers used for federal reporting.
- GET_CALENDAR_DESC, GET_FUND_ID, GET_SSN_DIGITS — Supply descriptive and identifying attributes such as fund references and partial Social Security Number data.
- GET_MIN_AWD_DISB, GET_MIN_PELL_DISB — Compute minimum award and Pell disbursement thresholds.
- GET_PELL_HEADER, GET_PELL_TRAILER — Build the header and trailer segments of the Pell origination/disbursement transmission file.
- GET_PELL_EFC, GET_PELL_EFC_CODE — Derive the Expected Family Contribution and its associated code for the student record.
- PROCESS_PELL_ACK — Parses and applies the acknowledgement response returned by the federal system.
- INSERT_SYS_HOLDS, SEND_ORIG_DISB, FRESH_ORIGINTN, OVRD_COA_EXIST — Manage system holds, transmit origination and disbursement data, refresh origination status, and detect existing Chart of Accounts override records.
Tables Accessed
The package reads and writes a broad set of financial aid tables, most referenced through APPS synonyms:
- IGF_GR_ATTEND_PELL, IGF_GR_PELL_SETUP_ALL — Store Pell attendance and configuration data used to build transmissions.
- IGF_AW_AWARD_ALL, IGF_AW_AWD_DISB_ALL — Supply award and disbursement detail.
- IGF_AP_FA_BASE_REC_ALL, IGF_AP_ISIR_MATCHED_ALL — Provide base financial aid records and ISIR matching results.
- IGF_AW_COA_ITEMS, IGF_AW_COA_ITM_TERMS, IGF_AW_COA_GROUP_ALL, IGF_AW_COA_GRP_ITEM_ALL — Support cost-of-attendance calculation and grouping.
- IGF_AW_CIT_LD_OVRD_ALL, IGF_AW_FUND_CAT_ALL, IGF_DB_DISB_HOLDS_ALL, FND_NEW_MESSAGES — Persist overrides, fund category references, disbursement holds, and application messages.
Usage Notes
IGF_GR_GEN is invoked indirectly by concurrent programs and forms that drive Pell Grant origination and disbursement cycles, and it is referenced by 47 other packages, confirming its role as a shared utility layer. Typical invocation occurs during the financial aid disbursement run, when origination and acknowledgement files are produced or consumed. Because the package is classified as OTHER and not a public API, customizations should avoid direct calls; developers extending Pell processing generally wrap or replicate the documented behavior through supported extension points or data-level integration.
-
SYNONYM: APPS.IGF_AW_COA_GRP_ITEM_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_COA_GRP_ITEM_ALL, status:VALID,
-
SYNONYM: APPS.IGF_AW_COA_GROUP_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_COA_GROUP_ALL, status:VALID,
-
SYNONYM: APPS.IGF_GR_REPORT_PELL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_GR_REPORT_PELL, status:VALID,
-
SYNONYM: APPS.IGF_GR_PELL_SETUP_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_GR_PELL_SETUP_ALL, status:VALID,
-
SYNONYM: APPS.IGF_DB_DISB_HOLDS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_DB_DISB_HOLDS_ALL, status:VALID,
-
SYNONYM: APPS.IGF_GR_ATTEND_PELL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_GR_ATTEND_PELL, status:VALID,
-
SYNONYM: APPS.IGF_AW_COA_LD_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_COA_LD_ALL, status:VALID,
-
SYNONYM: APPS.IGF_AW_CIT_LD_OVRD_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_CIT_LD_OVRD_ALL, status:VALID,
-
SYNONYM: APPS.IGF_GR_RFMS_BATCH_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_GR_RFMS_BATCH_ALL, status:VALID,
-
SYNONYM: APPS.IGF_AW_COA_ITM_TERMS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_COA_ITM_TERMS, status:VALID,
-
SYNONYM: APPS.IGF_AW_COA_ITEMS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_COA_ITEMS, status:VALID,
-
SYNONYM: APPS.IGF_GR_RFMS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_GR_RFMS_ALL, status:VALID,
-
PACKAGE BODY: APPS.IGF_GR_GEN
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_GR_GEN, status:VALID,
-
SYNONYM: APPS.IGF_AW_AWD_DISB_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_AWD_DISB_ALL, status:VALID,
-
SYNONYM: APPS.IGF_AP_ISIR_MATCHED_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AP_ISIR_MATCHED_ALL, status:VALID,
-
PACKAGE: APPS.IGF_GR_GEN
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_GR_GEN, status:VALID,
-
PACKAGE: APPS.IGF_AW_COA_LD_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_AW_COA_LD_PKG, status:VALID,
-
SYNONYM: APPS.IGF_AW_FUND_CAT_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_FUND_CAT_ALL, status:VALID,
-
VIEW: APPS.IGF_GR_RFMS_BATCH
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGF.IGF_GR_RFMS_BATCH, object_name:IGF_GR_RFMS_BATCH, status:VALID,
-
SYNONYM: APPS.IGF_GR_TUITION_FEE_CODES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_GR_TUITION_FEE_CODES, status:VALID,
-
PACKAGE: APPS.IGF_AW_CIT_LD_OVRD_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_AW_CIT_LD_OVRD_PKG, status:VALID,
-
SYNONYM: APPS.IGF_GR_LOAD_FILE_T
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_GR_LOAD_FILE_T, status:VALID,
-
PACKAGE: APPS.IGF_GR_RFMS_DISB_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_GR_RFMS_DISB_PKG, status:VALID,
-
PACKAGE: APPS.IGF_AW_COA_GRP_ITEM_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_AW_COA_GRP_ITEM_PKG, status:VALID,
-
PACKAGE: APPS.IGF_AW_COA_ITM_TERMS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_AW_COA_ITM_TERMS_PKG, status:VALID,
-
SYNONYM: APPS.IGF_GR_RFMS_ERROR
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_GR_RFMS_ERROR, status:VALID,
-
PACKAGE: APPS.IGF_GR_RFMS_BATCH_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_GR_RFMS_BATCH_PKG, status:VALID,
-
SYNONYM: APPS.IGS_PE_ALT_PERS_ID
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_ALT_PERS_ID, status:VALID,
-
PACKAGE BODY: APPS.IGF_GR_ESS_ESD_DATA
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_GR_ESS_ESD_DATA, status:VALID,
-
PACKAGE BODY: APPS.IGF_GR_YTD_LOAD_DATA
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_GR_YTD_LOAD_DATA, status:VALID,
-
PACKAGE BODY: APPS.IGF_AW_LOCK_ASSGN_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_AW_LOCK_ASSGN_PKG, status:VALID,
-
PACKAGE BODY: APPS.IGF_SL_AWARD
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_AWARD, status:VALID,
-
PACKAGE BODY: APPS.IGF_SL_DL_RECORD
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_RECORD, status:VALID,
-
PACKAGE: APPS.IGF_GR_RFMS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_GR_RFMS_PKG, status:VALID,
-
PACKAGE BODY: APPS.IGF_GR_VERIFY_PROCESS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_GR_VERIFY_PROCESS, status:VALID,
-
PACKAGE BODY: APPS.IGF_GR_MRR_LOAD_DATA
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_GR_MRR_LOAD_DATA, status:VALID,
-
PACKAGE: APPS.IGF_DB_DISB_HOLDS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_DB_DISB_HOLDS_PKG, status:VALID,
-
PACKAGE BODY: APPS.IGF_DB_DL_DISB_ORIG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_DB_DL_DISB_ORIG, status:VALID,
-
PACKAGE BODY: APPS.IGF_SL_DL_PRINT_MANIFEST
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_PRINT_MANIFEST, status:VALID,
-
PACKAGE: APPS.IGF_AW_COA_ITEMS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGF_AW_COA_ITEMS_PKG, status:VALID,
-
PACKAGE BODY: APPS.IGF_AP_SS_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_AP_SS_PKG, status:VALID,
-
SYNONYM: APPS.IGS_EN_STDNT_PS_ATT_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_EN_STDNT_PS_ATT_ALL, status:VALID,
-
SYNONYM: APPS.IGF_AW_AWARD_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AW_AWARD_ALL, status:VALID,
-
PACKAGE BODY: APPS.IGF_SL_CL_VALIDATION
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_CL_VALIDATION, status:VALID,
-
PACKAGE BODY: APPS.IGF_AW_CANCEL_AWD
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_AW_CANCEL_AWD, status:VALID,
-
PACKAGE BODY: APPS.IGF_SL_DL_PRINT_PNOTE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_SL_DL_PRINT_PNOTE, status:VALID,
-
SYNONYM: APPS.IGF_AP_BATCH_AW_MAP_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGF_AP_BATCH_AW_MAP_ALL, status:VALID,
-
PACKAGE BODY: APPS.IGF_GR_RFMS_DISB_ORIG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_GR_RFMS_DISB_ORIG, status:VALID,
-
PACKAGE BODY: APPS.IGF_AP_GEN_001
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_AP_GEN_001, status:VALID,
-
PACKAGE BODY: APPS.IGF_AP_BATCH_VER_PRC_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGF_AP_BATCH_VER_PRC_PKG, status:VALID,