Search Results igf_db_disb_holds_pkg




Overview
Explore in AI Chat

Overview

IGF_DB_DISB_HOLDS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, positioned within the Oracle Grants Management and disbursement processing subsystem (the IGF product family). Its role is to encapsulate the data-access and transactional logic for the IGF_DB_DISB_HOLDS_ALL table, which stores hold records applied against disbursement transactions. In the grants and awards lifecycle, holds can prevent or defer the release of funds tied to an award, award line, or disbursement. This package supplies the insert, update, delete, locking, and validation operations that surround those hold records, ensuring that every modification to the underlying table passes through a consistent, centrally maintained code path.

The package is classified as an OTHER API rather than a public-integration API, indicating that it is an internal utility layer consumed primarily by other EBS packages rather than a documented interface intended for external callers. The ETRM record confirms a VALID status, and the dependency information notes only a reference to the SYS STANDARD package, which is typical for packages with no external package dependencies at the header level.

Key Procedures and Functions

The package exposes eight documented procedures and functions:

  • INSERT_ROW — Performs the physical insertion of a new hold row into the holds table.
  • UPDATE_ROW — Applies modifications to an existing hold record.
  • DELETE_ROW — Removes a hold record from the table.
  • LOCK_ROW — Acquires a row-level lock to serialize concurrent access before DML.
  • ADD_ROW — Higher-level entry point that orchestrates adding a hold record, typically by combining validation and insertion.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key needed by the validation logic prior to a DML operation.
  • GET_FK_IGF_AW_AWD_DISB — Retrieves the foreign-key reference to the associated award disbursement record.
  • BEFORE_DML — A pre-DML handler invoked to prepare and validate a row before insert, update, or delete processing proceeds.

As documented metadata does not include parameter lists, callers should reference the live package specification for exact signatures.

Tables Accessed

The package operates against three objects, accessed through APPS synonyms:

  • IGF_DB_DISB_HOLDS_ALL — The primary transactional table holding disbursement hold records; inserted, updated, deleted, and queried.
  • IGF_DB_DISB_HOLDS_S — The sequence used to generate unique primary keys for new rows in the _ALL table.
  • DUAL — Used for scalar evaluations of the sequence and similar single-value lookups.

Usage Notes

IGF_DB_DISB_HOLDS_PKG is invoked indirectly through the award and disbursement processing stack rather than being called directly from Oracle Forms or a standalone concurrent program. Its documented dependents include IGF_AW_AWD_DISB_PKG, IGF_AW_GEN_003, IGF_AW_LI_IMPORT, IGF_AW_PACKAGING, IGF_GR_GEN, IGF_SL_CL_ORIG_ACK, and IGF_SL_DL_PNOTE_ACK, confirming that it is reached during award disbursement generation, award line import, packaging, letter generation, and subledger acknowledgment flows. Custom code should avoid direct DML on IGF_DB_DISB_HOLDS_ALL and instead route writes through this package or the higher-level APIs that call it, preserving the locking, validation, and key-generation sequencing that the procedures enforce.