Search Results load_gms_xface_api




Overview
Explore in AI Chat

Overview

APPS.GMS_TRANSACTIONS_PUB is a public PL/SQL package within the Oracle E-Business Suite Grants Management (GMS) module. It serves as the common table handler for the GMS_TRANSACTION_INTERFACE_ALL interface table, providing the canonical entry points through which external and internal sources load, maintain, and validate grant-related transaction data before it is processed into the Grants Management transaction tables.

The package sits at the boundary between interface data and the core Grants schema. It supports both bulk interface manipulation (inserts, updates, and deletes against the transaction interface) and business validation of sponsored project and award data. In release 12.1.1 and 12.2.2 the package remains a stable public API; its documented metadata shows six procedures and functions, a header dated 2005, and references to twenty-three dependent packages, indicating broad reuse across the Grants integration and expense-reporting flows.

Key Procedures and Functions

  • LOAD_GMS_XFACE_API — Accepts a row of the transaction interface record type and an outcome parameter. Loads a new transaction interface record, returning an outcome string that communicates success or failure. This is the procedure most frequently referenced in integration and conversion scripts, including those that search on load_gms_xface_api.
  • UPDATE_GMS_XFACE_API — Accepts the same interface row type and an outcome parameter. Applies modifications to an existing transaction interface record.
  • DELETE_GMS_XFACE_API — Accepts the same interface row type and an outcome parameter. Removes a transaction interface record.
  • VALIDATE_TRANSACTION — Validates a prospective transaction against project, task, award, expenditure type, and expenditure item date inputs, together with a calling-module indicator and an outcome parameter. Confirms that the combination is valid for grant processing.
  • IS_SPONSORED_PROJECT — A Boolean function that determines whether a given project is sponsored. It is used by the validate_award routine, which in turn is consumed by GMS_OIE_INT_PKG, the OIE integration validation package.
  • VALIDATE_AWARD — Invoked from the Internet Expenses validation package when Grants is implemented, after the user submits an expense report. It validates the award associated with the report and returns a status code and, on failure, an error message.

Tables Accessed

The package reads and writes GMS_TRANSACTION_INTERFACE_ALL, the interface table it manages. Validation logic draws on a broad set of Grants and Projects tables, including GMS_ALLOWABLE_EXPENDITURES, GMS_AWARDS and GMS_AWARDS_ALL, GMS_BUDGET_VERSIONS, GMS_FP_DISTRIBUTIONS, GMS_FUNDING_PATTERNS_ALL, GMS_IMPLEMENTATIONS, GMS_INSTALLMENTS, and GMS_SUMMARY_PROJECT_FUNDINGS, together with PA_PROJECTS_ALL, PA_PROJECT_TYPES_ALL, PA_TASKS, and PA_IMPLEMENTATIONS. These are accessed through APPS synonyms and are used to confirm award status, funding, budget, and project/task validity. DUAL is referenced for scalar lookups.

Usage Notes

GMS_TRANSACTIONS_PUB is typically invoked from Grants Management concurrent programs, from Internet Expenses expense-report submission, and from custom integration or conversion code that populates the transaction interface. Its documented callers include GMS_OIE_INT_PKG and the Internet Expenses validation package. Developers integrating external grant transactions should call LOAD_GMS_XFACE_API, UPDATE_GMS_XFACE_API, and DELETE_GMS_XFACE_API rather than writing directly to the interface table, and should use VALIDATE_TRANSACTION, IS_SPONSORED_PROJECT, and VALIDATE_AWARD to enforce Grants business rules before processing.