Search Results gms_ap_api




Overview
Explore in AI Chat

Overview

GMS_AP_API is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that serves as the integration bridge between Oracle Payables (AP) and Oracle Grants Management (GMS). In EBS 12.1.1 and 12.2.2 it carries an API classification, meaning it is intended as a programmatic interface rather than a purely internal utility. Its principal business function is to attribute Payables transactions — invoices, invoice distributions, expense reports, prepayments, and self-assessed tax lines — to awards and their associated funding structures so that grant expenditures remain correctly tracked and reported against project funding.

The package is tightly coupled to the Payables processing stack. The ETRM dependency information shows that GMS_AP_API is referenced by ten Payables packages, including AP_APPROVAL_PKG, AP_IMPORT_VALIDATION_PKG, AP_INVOICE_DISTRIBUTIONS_PKG, AP_INVOICE_LINES_PKG, AP_MATCHING_PKG, AP_PREPAY_PKG, AP_RECT_MATCH_PKG, AP_RCT_AMT_MATCH_PKG, AP_PO_AMT_MATCH_PKG, and AP_ETAX_UTILITY_PKG. This breadth indicates that award distribution logic is woven into standard Payables validation, matching, approval, prepayment, and tax routines rather than being an isolated add-on.

Key Procedures and Functions

  • GMS_AP_ER_HEADERS_AUT1 — Handles award-related processing for expense report headers, integrating expense report activity with award and funding records.
  • V_CHECK_LINE_AWARD_INFO — Validates award information associated with invoice lines, supporting downstream validation during Payables processing.
  • CREATE_AWARD_DISTRIBUTIONS — Creates award distribution records that link Payables transaction distributions to awards, establishing the core grant expenditure attribution.
  • GET_DISTRIBUTION_AWARD — Retrieves the award associated with a given distribution, supporting lookup and verification logic.
  • GMS_DEBUG_SWITCH — Provides a debug toggle used for diagnosing processing behavior during implementation and support.
  • CREATE_PREPAY_ADL — Creates award distribution lines for prepayment transactions so prepayments are attributed to awards.
  • GET_DIST_SET_AWARD — Returns award information for a distribution set, used when distribution sets drive invoice line attribution.
  • VERIFY_CREATE_ADLS — Verifies conditions before creating award distribution lines, guarding the creation logic.
  • VALIDATE_TRANSACTION — Performs validation of Payables transactions against award and funding constraints.
  • VERT_INSTALLMENT — Supports processing of award installment records in conjunction with Payables transactions.

Tables Accessed

The package reads and writes Payables and Grants tables through APPS synonyms. Payables tables include AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_EXPENSE_REPORT_LINES_ALL, AP_DISTRIBUTION_SET_LINES, and AP_SELF_ASSESSED_TAX_DIST_ALL, which supply the transaction and distribution data being attributed. Grants tables include GMS_AWARD_DISTRIBUTIONS (the primary target of award attribution logic), GMS_INSTALLMENTS, and GMS_SUMMARY_PROJECT_FUNDINGS, which hold award funding and installment information. PA_PROJECTS_ALL supplies project context, and PLITBLM is referenced for line-level information. Only SYS and STANDARD are listed as external dependencies, confirming the package operates within the APPS codebase.

Usage Notes

GMS_AP_API is invoked indirectly through standard Payables flows — invoice entry, validation, matching, approval, prepayment application, and tax processing — rather than being called directly by end users. The extensive referencing from AP_* packages means customers relying on Grants Management must keep this package valid and consistent with their Payables patch level. Custom integrations and extensions should call documented procedures only, avoid direct manipulation of GMS_AWARD_DISTRIBUTIONS, and treat GMS_DEBUG_SWITCH as a diagnostic aid. Following an EBS upgrade or Payables patch, the package status and dependencies should be re-verified because recompilation of the AP_* callers depends on it.