Search Results gms_bc_packets_s

Overview

GMS_FC_SYS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified as a Grants Management System (GMS) funds-control utility. Its role is to perform funds-checking operations against award budgets and encumbrance balances and to submit funds-check concurrent processing. In Oracle EBS 12.1.1 and 12.2.2, GMS funds control determines whether sufficient authorized award budget exists before encumbrances or expenditures are committed.

The package interfaces with the Budgetary Control engine through GL_BC_PACKETS_S and GMS_BC_PACKETS_S, which store journal and subledger budgetary control packets. The package's status is VALID in both releases, and it depends on FND_CONCURRENT, FND_GLOBAL, FND_PROFILE, and FND_REQUEST for environment and concurrent request handling. It is not referenced by any other database object, indicating it functions as a top-level entry point for funds checking rather than a shared library.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents two procedures:

FUNDS_CHECK_ENC — Performs the funds check for encumbrance records. It validates available award budget against encumbrance distributions and writes resulting budgetary control data to the GMS_BC_PACKETS_S and GL_BC_PACKETS_S tables. It relies on GMS_FUNDS_CONTROL_PKG for award funds-control logic.
SUBMIT_FUNDS_CHECK_ENC — Submits the funds-check-encumbrance process as a concurrent request, using FND_REQUEST.SUBMIT_REQUEST and FND_CONCURRENT to schedule or return the request identifier.

No parameter lists are asserted here, as the ETRM excerpt does not publish them.

Tables Accessed

The package reads and writes award, budget, and encumbrance data to execute funds checking:

GMS_AWARD_DISTRIBUTIONS and GMS_BUDGET_VERSIONS — provide award distribution and active budget version context for the check.
GMS_ENCUMBRANCES_ALL, GMS_ENCUMBRANCE_GROUPS_ALL, GMS_ENCUMBRANCE_ITEMS_ALL — supply the encumbrance header, group, and line details being validated.
GMS_BC_PACKETS, GMS_BC_PACKETS_S, and GL_BC_PACKETS_S — budgetary control packet tables written during funds checking.
GL_PERIOD_STATUSES — validates the accounting period is open before processing.
PA_EXPENDITURE_TYPES and PA_IMPLEMENTATIONS — resolve expenditure type and project accounting installation parameters.
DUAL and PLITBLM — standard single-row and PL/SQL table utilities.

Usage Notes

GMS_FC_SYS is typically invoked from Grants Management funds-control flows, particularly when encumbrance records require budgetary validation. The SUBMIT_FUNDS_CHECK_ENC procedure allows the check to be dispatched as a concurrent program, useful for batch or scheduled processing in large award portfolios. Custom code should call the documented procedures rather than manipulate the budgetary control packet tables directly, since the package encapsulates period validation, encumbrance grouping, and packet generation. Because it references GMS_FUNDS_CONTROL_PKG and GMS_AWARDS_DIST_PKG, callers receive consolidated award funds-control behavior. The related GMS_BC_PACKETS_S table is frequently queried alongside this package to inspect generated funds-check results.

SEQUENCE: GMS.GMS_BC_PACKETS_S 12.1.1
owner:GMS, object_type:SEQUENCE, object_name:GMS_BC_PACKETS_S, status:VALID,
SEQUENCE: GMS.GMS_BC_PACKETS_S 12.2.2
owner:GMS, object_type:SEQUENCE, object_name:GMS_BC_PACKETS_S, status:VALID,
SYNONYM: APPS.GMS_BC_PACKETS_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMS_BC_PACKETS_S, status:VALID,
SYNONYM: APPS.GMS_BC_PACKETS_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:GMS_BC_PACKETS_S, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.GMS_FC_SYS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_FC_SYS, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.GMS_PA_COSTING_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_PA_COSTING_PKG, status:VALID,
PACKAGE BODY: APPS.GMS_PA_COSTING_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_PA_COSTING_PKG, status:VALID,
PACKAGE BODY: APPS.GMS_COST_PLUS_EXTN 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_COST_PLUS_EXTN, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.GMS_FC_SYS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_FC_SYS, status:VALID,
PACKAGE BODY: APPS.GMS_PA_API 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_PA_API, status:VALID,
PACKAGE BODY: APPS.GMS_BUDGET_BALANCE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_BUDGET_BALANCE, status:VALID,
PACKAGE BODY: APPS.GMS_COST_PLUS_EXTN 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_COST_PLUS_EXTN, status:VALID,
PACKAGE BODY: APPS.GMS_FUNDS_CONTROL_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_FUNDS_CONTROL_PKG, status:VALID,
PACKAGE BODY: APPS.GMS_BUDGET_BALANCE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_BUDGET_BALANCE, status:VALID,
PACKAGE BODY: APPS.GMS_PA_API 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_PA_API, status:VALID,
PACKAGE BODY: APPS.GMS_AWARD_DIST_ENG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_AWARD_DIST_ENG, status:VALID,
PACKAGE BODY: APPS.GMS_AWARD_DIST_ENG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_AWARD_DIST_ENG, status:VALID,
PACKAGE BODY: APPS.GMS_FUNDS_CONTROL_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_FUNDS_CONTROL_PKG, status:VALID,
APPS.GMS_PA_COSTING_PKG dependencies on GMS_BC_PACKETS_S 12.1.1
APPS.GMS_FC_SYS dependencies on GMS_BC_PACKETS_S 12.2.2
APPS.GMS_AWARD_DIST_ENG dependencies on GMS_BC_PACKETS_S 12.2.2
APPS.GMS_COST_PLUS_EXTN dependencies on GMS_BC_PACKETS_S 12.1.1
APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_BC_PACKETS_S 12.1.1
APPS.GMS_BUDGET_BALANCE dependencies on GMS_BC_PACKETS_S 12.2.2
APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_BC_PACKETS_S 12.2.2
APPS.GMS_PA_API dependencies on GMS_BC_PACKETS_S 12.2.2
APPS.GMS_FC_SYS dependencies on GMS_BC_PACKETS_S 12.1.1
APPS.GMS_BUDGET_BALANCE dependencies on GMS_BC_PACKETS_S 12.1.1
APPS.GMS_PA_API dependencies on GMS_BC_PACKETS_S 12.1.1
APPS.GMS_COST_PLUS_EXTN dependencies on GMS_BC_PACKETS_S 12.2.2
APPS.GMS_AWARD_DIST_ENG dependencies on GMS_BC_PACKETS_S 12.1.1
APPS.GMS_PA_COSTING_PKG dependencies on GMS_BC_PACKETS_S 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1