Results for “igf_gr_rfms_pkg”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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:
- INSERT_ROW — Inserts a new row into the RFMS entity table.
- LOCK_ROW — Acquires an exclusive cursor lock on a specific RFMS row to prevent concurrent modification.
- UPDATE_ROW — Updates an existing RFMS row.
- ADD_ROW — Adds a row, typically used in the context of batch or bulk RFMS record creation.
- DELETE_ROW — Removes an RFMS row.
- GET_PK_FOR_VALIDATION — Returns the primary key of the current row, used for validation logic in calling code.
- GET_FK_IGF_GR_RFMS_BATCH — Retrieves the foreign key linking the row to its parent RFMS batch record.
- GET_FK_IGS_CA_INST — Returns the foreign key to the student/recipient instance (IGS_CA_INST).
- GET_FK_IGF_AW_AWARD — Returns the foreign key to the originating award record (IGF_AW_AWARD).
- GET_FK_IGF_AP_FA_BASE_REC — Returns the foreign key to the base award/disbursement record (IGF_AP_FA_BASE_REC).
- BEFORE_DML — A standard pre-DML trigger-style procedure typically used to populate WHO columns and audit fields prior to insert or update.
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.
-
12.1.1 DBA Data 12.1.1
-
PACKAGE: APPS.IGF_GR_PELL 12.1.1
-
PACKAGE: APPS.IGF_GR_GEN_XML 12.1.1
-
12.1.1 DBA Data 12.1.1
-
PACKAGE: APPS.IGF_GR_GEN 12.1.1
-
12.1.1 DBA Data 12.1.1