Search Results gms_transactions_pub




Overview
Explore in AI Chat

Overview

APPS.GMS_TRANSACTIONS_PUB is the public PL/SQL API for the Oracle E-Business Suite Grants Management module. It serves as the programmatic entry point through which Grants transactions are loaded, validated, updated, and removed within the transaction interface staging tables before they are ultimately processed against the grants and projects schema. The package belongs to the GMS (Grants Management System) application and is classified as a public API, meaning it is intended for invocation by external callers such as concurrent programs, forms, and third-party integrations rather than being restricted to internal package use.

Its core business function is to control the flow of transaction records into and out of the GMS transaction interface. It enforces grants-specific business rules — allowable expenditure validation, award and funding pattern checks, sponsored project determination, and award validation — ensuring that only conforming data progresses toward the standard project transaction import in Oracle Projects (PA_TRX_IMPORT).

Key Procedures and Functions

  • LOAD_GMS_XFACE_API — Loads transaction records into the GMS transaction interface staging table, applying grants validation logic before the data is made available for downstream processing.
  • UPDATE_GMS_XFACE_API — Updates previously loaded interface records, allowing corrections or adjustments to staged grants transactions.
  • DELETE_GMS_XFACE_API — Removes transaction records from the interface staging area, typically used to purge rejected, obsolete, or superseded rows.
  • VALIDATE_TRANSACTION — Performs transaction-level validation, verifying that a staged transaction satisfies the grants and projects rules before it is accepted.
  • IS_SPONSORED_PROJECT — Returns a determination of whether a given project is a sponsored (grants-funded) project, used to drive conditional processing and validation paths.
  • VALIDATE_AWARD — Validates an award record against grants configuration, confirming that the award is active, correctly associated, and eligible for the attempted transaction.

Tables Accessed

The package reads and writes through APPS synonyms. Its central staging table is GMS_TRANSACTION_INTERFACE_ALL, which holds inbound grants transactions. Validation draws on master grants data including GMS_AWARDS and GMS_AWARDS_ALL (award header information), GMS_ALLOWABLE_EXPENDITURES (expenditure eligibility rules), GMS_BUDGET_VERSIONS, GMS_FUNDING_PATTERNS_ALL and GMS_FP_DISTRIBUTIONS (funding pattern and distribution definitions), GMS_INSTALLMENTS, GMS_IMPLEMENTATIONS and GMS_SUMMARY_PROJECT_FUNDINGS. Project-side validation references PA_PROJECTS_ALL, PA_PROJECT_TYPES_ALL, PA_TASKS, and PA_IMPLEMENTATIONS from Oracle Projects. DUAL supports scalar lookups.

Usage Notes

GMS_TRANSACTIONS_PUB is typically invoked indirectly through Grants Management concurrent programs and window-driven processes rather than being called directly by end users. The metadata confirms that it is referenced by 23 other packages, indicating it sits at the center of a broader dependency graph spanning GMS and Oracle Projects utilities such as PA_TRX_IMPORT and GMS_ERROR_PKG. When custom integrations require staged grants transaction processing, developers should call this public API rather than manipulating GMS_TRANSACTION_INTERFACE_ALL directly, so that validation logic and grants business rules are consistently applied. API classification as PUB signals that Oracle supports the documented signature for upgrade-safe use across EBS 12.1.1 and 12.2.2.