Search Results g_gms_true

Overview

APPS.GMS_BUDGET_PUB is the public PL/SQL API for Oracle Grants Accounting (GMS) that manages the full lifecycle of award budgets. Its header identifies the package as the "Budget API" and states that it "provides a set of procedures to create, modify, delete, and submit a draft award budget and to designate a draft award budget as the baseline budget." The package is declared with AUTHID CURRENT_USER, carries a public scope and active lifecycle classification, and is associated with the GMS_AWARD business entity. The version shipped in the 120.12 header file establishes an API version constant of 1.0, which callers can use for compatibility validation.

The package supports two entry points for budget creation — one driven by a full award structure and one driven by direct budget line insertion — and pairs those with corresponding update, delete, validation, submission, and baseline operations. This makes it the central programmatic interface through which Grants Accounting maintains draft and baseline award budgets outside of the concurrent and form-based flows.

Key Procedures and Functions

• CREATE_DRAFT_BUDGET — Creates a new draft award budget.
• ADD_BUDGET_LINE — Adds an individual line to an existing draft budget; the most granular of the budget maintenance entry points.
• UPDATE_BUDGET — Modifies budget-level attributes of a draft budget.
• UPDATE_BUDGET_LINE — Modifies the attributes of an existing budget line.
• DELETE_BUDGET_LINE — Removes a single line from a draft budget.
• DELETE_DRAFT_BUDGET — Removes an entire draft budget and its associated lines.
• VALIDATE_BUDGET — Performs validation of a draft budget prior to submission.
• SUBMIT_BUDG_CONC_PROCESS — Submits the budget to a concurrent process for further processing.
• SUBMIT_BASELINE_BUDGET — Submits a draft budget for baselining.
• BASELINE_BUDGET — Designates a draft award budget as the baseline budget.
• SUMMERIZE_PROJECT_TOTALS — Summarizes project totals, typically after budget line changes.
• Utility functions — G_PA_MISS_NUM, G_PA_MISS_CHAR, and G_PA_MISS_DATE expose the missing-value sentinels; G_GMS_TRUE and G_GMS_FALSE return the package's boolean representations.

Tables Accessed

The package reads and writes the core budget tables GMS_BUDGET_LINES, GMS_BUDGET_VERSIONS, and GMS_BUDGET_VERSIONS_S, which hold line detail and version headers. It also references GMS_AWARDS and GMS_AWARDS_ALL for award context, GMS_BALANCES and GMS_SUMMARY_PROJECT_FUNDINGS for summarized funding, GMS_BUDGETARY_CONTROLS for control settings, GMS_RESOURCE_ASSIGNMENTS and its _S variant for resource mappings, and GMS_BC_PACKETS, GMS_INSTALLMENTS, and GMS_NOTIFICATIONS for packet and workflow-related information. Profile settings are read via FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES. All accesses are made through APPS synonyms. Six other packages reference this API.

Usage Notes

The package is typically invoked from Grants Accounting forms, from concurrent programs that submit or baseline budgets, and from custom code that programmatically maintains draft award budgets. Because it is a published API with an explicit version constant, it is the supported integration point for callers that need to add budget lines, update or delete them, or move a draft budget to baseline.