Search Results igf_db_dl_disb_orig




Overview
Explore in AI Chat

Overview

The APPS.IGF_DB_DL_DISB_ORIG package is a stored PL/SQL program unit within the Oracle E-Business Suite (EBS) that belongs to the Oracle Grants / Higher Education (IGF) application family, specifically the discretionary disbursement processing domain. The package name follows the convention of the grants-funded disbursement sub-ledger, where the "DL" segment denotes "disbursement line" and "DISB_ORIG" denotes disbursement origination. Its role is to encapsulate the business logic used to originate, or create, disbursement records against an award, thereby bridging the award-charge tracking layer with the actual disbursement postings in the grants sub-ledger.

In EBS 12.1.1 and 12.2.2, the package is deployed as a standard PL/SQL package in the APPS schema with a documented status of VALID. It is classified as a general API (classification OTHER), meaning it is not a public published interface but an internal component intended to be called from within the application's own program units rather than from arbitrary external callers.

Key Procedures and Functions

The ETRM metadata documents exactly one program unit within this package:

  • DISB_ORIGINATE — The single documented procedure. Its purpose is to perform the disbursement origination activity, that is, to create or initialize a disbursement for the given award context. In the IGf disbursement model this step precedes charging and posting, and produces the base disbursement record that subsequent processing phases consume. No parameter list is documented in the metadata; consumers should refer to the deployed package specification in the target instance before attempting to invoke it by signature.

Because the package body is not otherwise documented, only the presence and intent of DISB_ORIGINATE can be stated with confidence. No additional public procedures or functions are recorded in the ETRM documentation for this object.

Tables Accessed

The documented dependencies list the following tables referenced through APPS synonyms:

  • IGF_AW_AWARD_ALL — The awards master table for the IGF grants module. This table supplies the award eligibility, funding, and institutional context required to determine whether and how a disbursement should be originated.
  • IGF_AW_DB_CHG_DTLS — The award disbursement charge details table, which stores charge-level information associated with award disbursements. This is the natural target or source for the disbursement lines the origination logic maintains.

The package also carries the implicit dependency of all PL/SQL units on SYS.STANDARD. No other application tables are documented as referenced.

Usage Notes

Although the object is catalogued as an API, no other package in the ETRM registry documents a dependency on IGF_DB_DL_DISB_ORIG ("referenced by 0 other packages"). This indicates that, in the ETRM reference set, the package is invoked from the application's form or concurrent program layer rather than from a documented PL/SQL caller. Typical invocation points for a disbursement-origination routine of this kind include:

  • Grants forms that create or adjust award disbursements.
  • Concurrent programs that batch-originate disbursements across a set of awards.
  • Internal support routines in the IGF schema that initiate the disbursement lifecycle.

Because DISB_ORIGINATE accepts an undocumented signature, custom code should not be written against it without first inspecting the deployed specification. Oracle's legal notice classifies this metadata as proprietary and confidential, and no public substitution or extension API is recorded for this unit in ETRM.