Search Results igf_gr_rfms_disb_s

Overview

IGF_GR_RFMS_DISB_PKG is a PL/SQL package body owned by the APPS schema within Oracle E-Business Suite, specifically part of the Oracle Grants / E-Business Tax (ETRM) family of objects associated with the IGF (Grants) application. Its name and dependency footprint identify it as a database-side helper package that supports RFMS (Rapid Funds Management System) disbursement processing for grant awards. In EBS 12.1.1 and 12.2.2, the package encapsulates the low-level row-level Data Manipulation Language (DML) and validation logic required to maintain records in the RFMS disbursement entity. Because the package is classified as an OTHER API rather than a formally published public API, it is intended for internal use by the Grants RFMS sub-ledger rather than for direct invocation by external integrations. It is currently in VALID status within the APPS schema.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions. These provide the standard table-handler pattern used throughout EBS for maintaining a single base table, together with look-up and foreign-key validation helpers:

• INSERT_ROW — Inserts a new RFMS disbursement row, populating the primary key and applying defaults.
• LOCK_ROW — Acquires a row lock (typically via SELECT ... FOR UPDATE) to serialize concurrent access during updates or deletes.
• UPDATE_ROW — Applies modifications to an existing RFMS disbursement row.
• ADD_ROW — Creates a new row, typically combining key derivation with the insert operation.
• DELETE_ROW — Removes an RFMS disbursement row.
• GET_PK_FOR_VALIDATION — Returns the primary key value used to validate a row before DML.
• GET_UK_FOR_VALIDATION — Returns the unique key value used for uniqueness validation.
• GET_FK_IGF_GR_RFMS_BATCH — Resolves the foreign key to the RFMS batch entity, ensuring the parent batch exists.
• GET_FK_IGF_GR_RFMS — Resolves the foreign key to the parent RFMS record.
• BEFORE_DML — Central pre-DML routine that performs validation, key assignment, and audit column population before insert, update, or delete.

The dependency list additionally shows references to APP_EXCEPTION, FND_GLOBAL, FND_MESSAGE, IGS_GE_MSG_STACK, and IGF_AW_GEN, indicating error handling, message retrieval, and audit context (WHO columns) are handled through standard EBS frameworks.

Tables Accessed

Through APPS synonyms, the package reads and writes the following documented tables:

• IGF_GR_RFMS_DISB_ALL — The base RFMS disbursement table, holding disbursement records across operating units. Core insert, update, and delete operations target this table.
• IGF_GR_RFMS_DISB_S — The security/validation subset view or table associated with RFMS disbursements, used for filtered or security-checked access.
• DUAL — Used for singleton evaluations, key sequence look-ups, and lightweight validation queries.

Additional dependencies reference IGF_GR_RFMS_BATCH_PKG, IGF_GR_RFMS_PKG, and IGF_GR_RFMS_PKG, indicating that batch and award-level RFMS processing invokes this package during disbursement maintenance.

Usage Notes

IGF_GR_RFMS_DISB_PKG is not referenced by any database object directly, and it is therefore invoked indirectly through higher-level RFMS packages (IGF_GR_RFMS_BATCH_PKG and IGF_GR_RFMS_PKG) and is documented as referenced by eight other packages. Typical invocation scenarios include:

• Grants RFMS concurrent programs that generate, adjust, or reconcile disbursement records.
• Oracle Forms or OAF pages within the Grants RFMS module that edit disbursement details and rely on the row-handler procedures for DML.
• Batch processing that creates disbursement rows against awards and batches, calling BEFORE_DML and the FK resolution routines for validation.
• Custom extensions that must maintain RFMS disbursement data consistently with standard Grants behavior — such code should call the package's procedures rather than issuing direct DML against IGF_GR_RFMS_DISB_ALL.

Because the object is an internal helper package, direct calls from custom code should be treated as unsupported and subject to change across EBS releases.