Search Results check_draft_budget_exists

Overview

GMS_AWARD_DELETE_PKG is an Oracle Grants Management (GMS) PL/SQL package owned by the APPS schema. Its business function is to validate and execute the deletion of an award, including all dependent and related records that reference that award. The package encapsulates the referential-integrity logic required before an award can be safely removed from the system, preventing orphaned funding, budget, personnel, and distribution records that would otherwise corrupt Grants Management data or leave inconsistent downstream project costing data.

In Oracle EBS 12.1.1 and 12.2.2, this package is classified as an OTHER API within the ETRM repository. It is referenced by one other package, indicating it is invoked programmatically rather than being exposed as a standalone public interface. The package contains five documented procedures and functions, and its header (revision 120.1) reflects an origin predating the parameter clean-up associated with Bug 2355648, in which the p_Billing_Rule and p_Revenue_Rule parameters of DELETE_AWARD_OK were deprecated. This historical detail is relevant when assessing compatibility of older customizations.

Key Procedures and Functions

• DELETE_AWARD_OK — A Boolean function that verifies whether the current user may delete the specified award. It accepts an award identifier and returns a success indicator plus standard RETCODE/ERRBUFF out parameters. The deprecated billing-rule and revenue-rule parameters are retained for backward compatibility but should no longer be supplied.
• DELETE_AWARD_ALL — A procedure that performs the full deletion of an award and all of its associated information once deletion has been authorized. It returns a message count together with RETCODE and ERRBUFF, allowing the caller to inspect errors accumulated during the cascade.
• CHECK_FUNDING_EXISTS — A Boolean function that checks whether project funding exists for the award. This is the object associated with the search term "check_funding_exists." Its result determines whether deletion validation should block or proceed, since funding records tied to the award must be accounted for before removal.
• CHECK_DRAFT_BUDGET_EXISTS — A Boolean function that determines whether a draft budget exists for the award, guarding against deletion when unposted budget versions remain.
• DELETE_AWARD_DETAIL — A procedure added specifically to address Bug 2355648. It accepts an award identifier and an award project identifier and handles the deletion of the associated detail records.

Tables Accessed

The package operates against the following documented GMS and PA tables, referenced through APPS synonyms:

• GMS_PROJECT_FUNDINGS and GMS_SUMMARY_PROJECT_FUNDINGS — read to satisfy the CHECK_FUNDING_EXISTS logic and supporting deletion of funding rows.
• GMS_BUDGET_VERSIONS — queried to detect draft budgets.
• GMS_AWARD_DISTRIBUTIONS, GMS_INSTALLMENTS, and GMS_OVERRIDE_SCHEDULES — removed when the award is deleted, since these represent scheduled financial detail.
• GMS_AWARDS_CONTACTS, GMS_AWARDS_TERMS_CONDITIONS, GMS_PERSONNEL, GMS_REFERENCE_NUMBERS, GMS_NOTIFICATIONS, and GMS_DEFAULT_REPORTS/GMS_REPORTS — supporting award-level attributes deleted as part of the cascade.
• GMS_EVENT_ATTRIBUTE — event-related attribute records linked to the award.
• PA_CREDIT_RECEIVERS — Project Accounting credit receiver rows that must be cleared to preserve cross-module consistency.

Usage Notes

GMS_AWARD_DELETE_PKG is typically invoked from the Oracle Grants Management award maintenance forms and supporting concurrent cleanup logic, where DELETE_AWARD_OK is called first to authorize deletion and DELETE_AWARD_ALL is then executed to perform the cascade. Because it is an OTHER-class API referenced by only one other package, custom code should treat it as internal: callers should assume the documented signatures and not rely on undocumented overloads. In 12.1.1 and 12.2.2 environments, customizations written against older signatures containing the deprecated billing and revenue rule parameters should be reviewed and updated to reflect Bug 2355648. The standard RETCODE/ERRBUFF out parameters must always be inspected to detect partial failures during deletion.