Search Results igf_gr_rfms_batch_pkg




Overview
Explore in AI Chat

Overview

IGF_GR_RFMS_BATCH_PKG is an APPS-owned PL/SQL package within the Oracle E-Business Suite Grants Management (IGF) module. It supports the batch processing infrastructure used by the RFMS (Recipient Financial Management System) integration for federal grant recipients. In Oracle EBS 12.1.1 and 12.2.2, the package is catalogued with an API classification of OTHER, indicating that it is a supporting package rather than a formal public API. Its primary role is to manage the persistent state of RFMS batch records: creating, locking, updating, and deleting individual batch rows that represent scheduled or in-progress transmissions between EBS and the external RFMS system.

The package operates in conjunction with the related packages IGF_GR_RFMS_PKG, IGF_GR_RFMS_DISB_PKG, IGF_GR_GEN, and IGF_GR_LI_IMPORT, which together orchestrate the generation and import of RFMS batch content. IGF_GR_RFMS_BATCH_PKG thus serves as the low-level data maintenance layer behind the higher-level RFMS processing flows.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

  • INSERT_ROW — inserts a new batch record into the RFMS batch table, populating the identifying and descriptive columns for a new batch.
  • LOCK_ROW — acquires a row-level lock on an existing batch record to prevent concurrent modification during processing.
  • UPDATE_ROW — modifies the attributes of an existing RFMS batch record, typically to reflect status or processing outcome changes.
  • ADD_ROW — adds a batch row, functioning as a higher-level entry point that may combine insertion and validation logic.
  • DELETE_ROW — removes a batch record, used when an obsolete or rolled-back batch must be cleared.
  • GET_PK_FOR_VALIDATION — retrieves the primary key of a batch record for validation purposes, allowing callers to confirm the existence and identity of a batch before further DML.
  • BEFORE_DML — a pre-DML handler that enforces standard WHO-column maintenance and other row preparation logic prior to insert, update, or delete operations.

No parameter lists are documented in the ETRM metadata; only the names and roles above should be assumed.

Tables Accessed

The package references the following tables through APPS synonyms:

  • IGF_GR_RFMS_BATCH_ALL — the primary RFMS batch table, which stores the header-level batch records maintained by the insert, update, lock, and delete operations.
  • IGF_GR_RFMS_BATCH_S — the corresponding sequence or secondary table used to obtain unique identifiers for new batch rows.
  • DUAL — the standard Oracle single-row utility table, used for scalar evaluations such as sequence retrieval or validation checks.

The dependency listing also shows a reference to SYS.STANDARD, which is the implicit package underlying all PL/SQL datatype support and does not represent a business data dependency.

Usage Notes

IGF_GR_RFMS_BATCH_PKG is not intended for direct end-user invocation. It is referenced by four other APPS packages — IGF_GR_GEN, IGF_GR_LI_IMPORT, IGF_GR_RFMS_BATCH_PKG itself (via recursive calls from its own package body), IGF_GR_RFMS_DISB_PKG, and IGF_GR_RFMS_PKG — which call its procedures during RFMS batch generation, disbursement processing, and import routines. Typical invocation paths include concurrent programs and forms-based processes in the Grants Management module that create or advance RFMS batches, as well as any custom code that participates in the RFMS integration. Developers extending RFMS functionality should call the documented procedures rather than issuing direct DML against IGF_GR_RFMS_BATCH_ALL, so that validation and WHO-column handling performed by BEFORE_DML are preserved.