Search Results gms_evt_billing




Overview
Explore in AI Chat

Overview

The APPS.GMS_EVT_BILLING package is a server-side PL/SQL component within the Oracle E-Business Suite Grants Management (GMS) module. Its principal business function is to support event-based billing and revenue generation against sponsored projects (awards) and their associated tasks. The package name reflects its role: GMS for Grants Management, EVT for event, and BILLING for the billing/revenue recognition activity. The single documented entry point, MANUAL_BILLING, enables the application to create billing or revenue events and the corresponding draft invoice or draft revenue records for a specified project and task. The package is classified under the ETRM API classification of OTHER, indicating it is not exposed as a fully public, versioned API but is nonetheless an internal, callable program unit used by the application’s own processes.

Key Procedures and Functions

The package exposes exactly one documented procedure in the metadata provided:

  • MANUAL_BILLING — This procedure performs manual billing or revenue generation for a specified project and task combination. It accepts the project identifier and, optionally, a top task identifier, allowing the caller to scope the billing activity to a particular task within the project. Additional optional parameters allow the caller to supply calling context information (the calling process and calling place), a billing amount, a percentage, and a revenue or billing date. It can also accept an assignment identifier and a bill extension identifier, which relate the request to specific billing extension configurations. A request identifier parameter supports concurrent program integration by associating the execution with a submitted concurrent request. Because the documented signature terminates with the procedure header, the full parameter list is not reproduced here. The procedure is responsible for determining what is to be billed or recognized and for producing the appropriate event and draft records.

Tables Accessed

The package operates across Grants Management and Projects (PA) tables through APPS synonyms. The documented tables include:

Together these tables indicate that the package both reads configuration and transaction data (awards, fundings, projects, tasks, event types, customer events) and writes draft billing and revenue records.

Usage Notes

Because GMS_EVT_BILLING is not referenced by any other documented package, it is typically invoked directly by Grants Management forms, concurrent programs, or custom extensions rather than being called internally by other packaged APIs. The presence of the X_request_id parameter strongly suggests it is designed to be run in a concurrent program context, where the request identifier links the transaction to the concurrent manager job. The optional amount and percentage parameters support both fixed-amount and percentage-based billing scenarios. In Oracle EBS 12.1.1 and 12.2.2, custom code calling this procedure should pass the project identifier and supply the optional parameters as needed, ensuring the calling process and calling place values are populated for audit and traceability. As the package is classified as OTHER, implementers should treat it as an internal program unit and validate behavior through thorough testing before relying on it in production.