Results for “igf_gr_repackage”
35 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGF_GR_REPACKAGE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under ETRM as an "OTHER" API object. It forms part of the Oracle Financial Aid / Student Aid (IGF) module, which supports the administration of grants, Pell awards, and federal student aid disbursement processing within an Oracle EBS 12.1.1 or 12.2.2 environment. The package exists to support the repackaging of award data — that is, the recalculation and redistribution of financial aid awards when a student's eligibility, enrollment status, or institutional funding configuration changes. Its single documented procedure, REPACKAGE_PELL, indicates that its principal responsibility is directed toward the Pell Grant processing cycle, where repackaging occurs after an ISIR is matched, after disbursement schedules are adjusted, or when award amounts must be aligned to updated RFMS (Recipient Financial Management System) disbursement data. The object status is VALID, confirming the package compiles cleanly and is available for execution in the supported releases.
Key Procedures and Functions
The ETRM metadata documents one procedure for this package: REPACKAGE_PELL. As the name implies, this procedure drives the repackaging of Pell Grant awards. Its purpose is to reconcile existing award records against current eligibility and disbursement data and then apply the necessary adjustments to the award, disbursement, and RFMS tables. Because the metadata does not publish the formal parameter list, the calling signature should be confirmed by inspecting the package specification in the database rather than assumed. No functions are documented for this package.
Tables Accessed
The package reads and writes a wide set of IGF and IGS tables through APPS synonyms, reflecting its position at the center of the financial aid award lifecycle:
- IGF_AP_FA_BASE_REC_ALL — base financial aid record for the applicant.
- IGF_AW_AWARD_ALL — the student's award header records that are repackaged.
- IGF_AW_AWD_DISB_ALL — award disbursement schedules adjusted during repackaging.
- IGF_AW_FUND_CAT_ALL and IGF_AW_FUND_MAST_ALL — fund category and fund master definitions governing eligibility.
- IGF_AP_ISIR_MATCHED_ALL — matched ISIR data used to determine Pell eligibility.
- IGF_GR_PELL_SETUP_ALL — Pell Grant configuration parameters.
- IGF_GR_RFMS_ALL and IGF_GR_RFMS_DISB_ALL — RFMS award and disbursement records reconciled during the process.
- IGS_PE_PERSID_GROUP_ALL, IGS_CA_INST_ALL — person identifier groups and calendar/term instances.
- HZ_PARTIES — party records for the student.
- FND_NEW_MESSAGES and PLITBLM — message handling and PL/SQL internal tables.
Collectively these tables provide eligibility input, award and disbursement state, and the RFMS reference data required to recalculate Pell awards.
Usage Notes
IGF_GR_REPACKAGE is an internal processing package rather than a public integration API. It is typically invoked by higher-level financial aid processes — batch repackaging concurrent programs, ISIR correction flows, or RFMS reconciliation routines — rather than being called directly from a form or custom extension. The ETRM dependency listing shows it references standard Oracle packages and is referenced only by itself, meaning no other documented APPS object calls it directly. Customizations that need Pell repackaging behavior should invoke the supported business flows that call this package rather than calling REPACKAGE_PELL directly, since the parameter contract is not published in the reference documentation and may change between patch levels. DBAs should note that the package depends on IGF, IGS, and HZ objects, so those schemas must be valid prior to execution.
-
VIEW: APPS.IGF_GR_RFMS_DISB 12.1.1
-
VIEW: APPS.IGF_AW_AWARD_T 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
VIEW: APPS.IGF_LOOKUPS_VIEW 12.1.1
-
VIEW: APPS.IGF_GR_PELL_SETUP 12.1.1
-
VIEW: APPS.IGF_AW_AWD_DISB 12.1.1
-
VIEW: APPS.IGF_GR_RFMS 12.1.1
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program
-
SYNONYM: APPS.HZ_PARTIES 12.1.1
-
SYNONYM: PUBLIC.PLITBLM 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.