Search Results gms_multi_funding




Overview
Explore in AI Chat

Overview

GMS_MULTI_FUNDING is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the OTHER API category. Its principal business purpose is to support the Oracle Grants Management module's multi-funding model, in which a single sponsored award or project may draw upon multiple funding sources, agreements, and customer records. The package provides the programmatic backbone for creating and maintaining the interlocking records that tie an award to its associated project, funding sources, billing agreements, and installment schedules.

The package declares AUTHID CURRENT_USER, meaning that runtime privilege resolution is performed against the invoking schema rather than the defining schema. It exposes a package-level variable, p_msg_count, used to track the number of messages generated during processing — a common convention in EBS PL/SQL APIs that complements the standard RETCODE and ERRBUF out parameters.

Key Procedures and Functions

The ETRM metadata documents nine procedures, organized into three functional groups:

  • CREATE_AWARD_PROJECT, UPDATE_AWARD_PROJECT, DELETE_AWARD_PROJECT — These procedures manage the association between an award and the Oracle Projects project that carries out the sponsored work. CREATE_AWARD_PROJECT accepts a broad set of award and project attributes, including project name and number, customer and bill-to identifiers, carrying-out organization, IDC schedule and fixed date, labor and non-labor invoice formats, personnel and term references, start, end, and close dates, agreement type, revenue and invoice limit flags, billing frequency and cycle, billing offset, bill-to and ship-to address and contact identifiers, output and retention tax codes, and operating unit. It returns the generated award/project identifier, agreement identifier, resolved billing address identifiers, application short name, message count, and the standard return status and error buffer.
  • CREATE_AWARD_FUNDING, UPDATE_AWARD_FUNDING, DELETE_AWARD_FUNDING — These procedures maintain the funding source records that allocate sponsored monies against an award or project, supporting the multi-funding construct central to the package's name.
  • CREATE_AGREEMENT, UPDATE_AGREEMENT, DELETE_AGREEMENT — These procedures create, modify, and remove the billing agreements that govern how an award's expenditures are invoiced to the sponsoring customer.

Tables Accessed

The package reads from and writes to a focused set of tables via APPS synonyms:

Usage Notes

GMS_MULTI_FUNDING is typically invoked indirectly, from Oracle Grants Management forms or concurrent programs that create and maintain awards and their funding. The metadata indicates it is referenced by two other packages, confirming its role as a lower-level API consumed by higher-level Grants Management logic rather than an end-user-callable interface. In the context of Oracle EBS 12.1.1 and 12.2.2, the package operates under the MOAC (Multi-Org Access Control) model, as evidenced by the ORG_ID parameter added for the Shared Service enhancement. Developers integrating custom award creation or funding logic should call these procedures from within the standard Grants Management API layer to preserve referential integrity and message handling conventions. Related Grants Management APIs, including GMS_AWARD_PUB and GMS_AGREEMENT_PUB, provide companion interfaces for higher-level award and agreement lifecycle operations.