Search Results igf_gr_rfms_pkg




Overview
Explore in AI Chat

Overview

IGF_GR_RFMS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Grants Management (IGF) module's integration with the federal RFMS (Recipient Federal Management System) reporting framework. In Oracle EBS 12.1.1 and 12.2.2, the package acts as the DML engine for the IGF_GR_RFMS_ALL entity, which stores RFMS-related grant data such as federal drawdown, disbursement, and reporting records. The package encapsulates row-level operations for this entity, providing a controlled interface so that higher-level grant packages—such as IGF_GR_RFMS_BATCH_PKG, IGF_GR_RFMS_DISB_PKG, and IGF_GR_RFMS_ORIG—do not manipulate the underlying table directly. ETRM classifies this package as an "Other" API, indicating it is an internal utility rather than a formally published public API, and the object is documented as VALID in the APPS schema.

Key Procedures and Functions

The package exposes eleven documented procedures and functions:

The GET_FK_* functions collectively expose the referential relationships the RFMS entity maintains with batched RFMS runs, awards, recipients, and base financial aid records, enabling callers to resolve these links without direct table access.

Tables Accessed

The documented table accessed through APPS synonyms is IGF_GR_RFMS_ALL. This is the primary RFMS entity table, and the package's DML procedures (INSERT_ROW, UPDATE_ROW, ADD_ROW, DELETE_ROW) and the BEFORE_DML procedure read from and write to it. The GET_FK_* functions return foreign key values that reference related entities elsewhere in the grants schema, allowing callers to join or navigate to IGF_GR_RFMS_BATCH, IGS_CA_INST, IGF_AW_AWARD, and IGF_AP_FA_BASE_REC without the package itself performing those joins.

Usage Notes

IGF_GR_RFMS_PKG is an internal dependency rather than an end-user-invoked API. It is referenced by thirteen packages in the APPS schema, including IGF_GR_RFMS_BATCH_PKG, IGF_GR_RFMS_DISB_PKG, IGF_GR_RFMS_ORIG, IGF_GR_GEN, IGF_GR_GEN_XML, IGF_GR_PELL, IGF_GR_LI_IMPORT, IGF_GR_REPACKAGE, IGF_AW_AWARD_PKG, IGF_AW_AWD_DISB_PKG, IGF_AW_PACKAGING, IGF_AP_FA_BASE_REC_PKG, and IGF_SL_UPLOAD_XML. Invocation typically occurs from Grants Management concurrent programs that generate RFMS batch files, from award and disbursement processing flows, and from XML upload/import routines such as IGF_GR_GEN_XML and IGF_SL_UPLOAD_XML. Custom code should avoid calling this package directly where a higher-level RFMS package provides the same functionality, since the "Other" classification indicates no formal API stability guarantee across releases.