Search Results igc_cc_sla_bflow_prior_v




Overview
Explore in AI Chat

Overview

APPS.GMS_FUNDS_CONTROL_PKG is a PL/SQL package body in the Oracle E-Business Suite Grants Management (GMS) schema. Its central business purpose is to enforce budgetary and funds controls for sponsored projects and awards. The package evaluates whether transactions such as invoices, purchase orders, requisitions, and other expenditures are permitted to proceed based on available award funding, budgetary control definitions, and encumbrance rules. It serves as the integration layer between Grants Management award data and the Financials budgetary control framework, ensuring that sponsored project spending does not exceed authorized limits. In EBS 12.1.1 and 12.2.2, the package operates within the APPS schema, executing with the privileges required to read and update financial and grants data while depending on a broad set of public and private synonyms.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within this package body:

  • GMS_FCK — The principal funds control check routine used to validate whether a transaction satisfies applicable award and budgetary control rules.
  • GMS_GL_RETURN_CODE — Returns a status or return code related to General Ledger interaction, supporting error handling and control flow.
  • SETUP_RLMI — Handles setup for resource list member logic, supporting the association of resources with sponsored project awards.
  • DELETE_PENDING_TXNS — Removes pending transactions from the control processing queue, typically invoked when transactions are rejected or reprocessed.
  • SPONSORED_PROJECT — Determines whether a given project is a sponsored project, a prerequisite for applying grants funds control rules.
  • COPY_GL_PKT_TO_GMS_PKT — Copies budgetary control packet data from General Ledger structures into Grants Management packet structures.
  • TIEBACK_FAILED_ACCT_STATUS — Reconciles or updates accounting status for transactions that previously failed funds control checks.

Tables Accessed

The package reads and writes a range of AP, PO, GL, and GMS objects through APPS synonyms. Payables tables including AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL, AP_PREPAY_APP_DISTS, AP_PREPAY_HISTORY_ALL, AP_SELF_ASSESSED_TAX_DIST(_ALL), and AP_SYSTEM_PARAMETERS_ALL supply invoice and distribution data required for funds checks. Purchasing tables PO_BC_DISTRIBUTIONS, PO_DISTRIBUTIONS_ALL, PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_REQUISITION_LINES_ALL, PO_REQ_DISTRIBUTIONS(_ALL), and PO_VENDORS provide commitment and obligation detail. General Ledger objects GL_BC_PACKETS, GL_BC_PACKET_ARRIVAL_ORDER, GL_ENCUMBRANCE_TYPES, and GL_PERIOD_STATUSES support budgetary control packet processing and period validation. GMS objects such as GMS_AWARDS, GMS_AWARD_DISTRIBUTIONS, GMS_BALANCES, GMS_BC_PACKETS and its summary/arrival-order variants, GMS_BUDGETARY_CONTROLS, GMS_BUDGET_VERSIONS, GMS_ENCUMBRANCE_ITEMS, and GMS_IMPLEMENTATIONS hold award, budget, and encumbrance definitions. The view IGC_CC_SLA_BFLOW_PRIOR_V is also referenced, linking the package to subledger accounting prior-balance processing.

Usage Notes

GMS_FUNDS_CONTROL_PKG is not referenced by any database object, meaning it is invoked directly by application logic, concurrent programs, or workflows rather than through other package dependencies. It is typically called during transaction validation in Oracle Payables, Purchasing, and Grants Management forms, and through funds control concurrent requests that evaluate pending transactions. Because the package depends on FND_CONCURRENT_REQUESTS, FND_FILE, FND_GLOBAL, and FND_PROFILE, it produces concurrent output, uses application context, and resolves profile options at runtime. Custom code extending funds control logic may call documented procedures such as GMS_FCK or SPONSORED_PROJECT directly, but the absence of documented parameter signatures means callers must obtain exact specifications from the live package source in the target environment.