Results for “bud_ctrl_create”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.GMS_BUDG_CONT_SETUP package is a server-side PL/SQL API within the Oracle E-Business Suite Grants Management module. Its role is to establish and maintain budgetary control records for sponsored projects and awards. Budgetary controls in Oracle Grants Management determine how funds are validated and consumed against a project or award, controlling whether expenditures are checked against an approved budget and at what level of the project hierarchy such checks are enforced. The package is declared with AUTHID CURRENT_USER, meaning its unqualified references to schema objects are resolved in the calling user's schema while it continues to execute under invoker's rights. It supports the automated creation of budgetary control setup rows when projects, awards, tasks, or resource lists are defined or modified, ensuring that the funds control configuration is consistently derived from project budgeting structures. The package is referenced by two other packages and exposed as a callable API rather than as documented user-facing functionality.

Key Procedures and Functions

The package exposes three documented procedures:

• INSERT_REC — Inserts a single budgetary control record, taking the project, funds control code, award, task, parent member, and resource list member as driving identifiers.
• CREATE_RECORDS — Creates budgetary control records in bulk for a given project and award, using the entry level code, resource list, and group resource type to determine what rows are required. It accepts a calling mode (defaulting to BASELINE) and returns the standard concurrent-style RETCODE and ERRBUF output parameters for error reporting.
• BUD_CTRL_CREATE — The primary entry point associated with the user's search term. It manages the transition between a previous entry level code and a new entry level code for a project and award, together with the applicable resource list and group resource type. This procedure reconciles the budgetary control configuration when the budget entry method changes, returning an error code and error stage through its output parameters rather than the standard concurrent convention.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

• GMS_BUDGETARY_CONTROLS and GMS_BUDGETARY_CONTROLS_S — the base and translation tables that store the budgetary control definitions this package creates and maintains.
• PA_BUDGET_ENTRY_METHODS — supplies the entry level code definitions that govern at what level of the project hierarchy budget control is applied.
• PA_RESOURCE_LIST_MEMBERS — provides the resource list membership used to scope which resources are subject to control.
• PA_TASKS — supplies task structure information needed to create task-level control records.
• GMS_AWARDS — provides award context for the projects being configured.
• DUAL — used for single-row selections and sequence-style lookups.

Usage Notes

This package is typically invoked from Grants Management setup forms and from concurrent or baseline processes that generate budgetary control records when projects and awards are established, or when their budget entry methods change. Because CREATE_RECORDS returns RETCODE and ERRBUF, it follows the standard concurrent program calling interface and can be hosted by a concurrent program wrapper. Custom code should call BUD_CTRL_CREATE when synchronizing entry-level changes, checking x_err_code and x_err_stage for diagnostics. As an AUTHID CURRENT_USER package, callers must possess appropriate privileges on the underlying tables, and any customization should respect the existing budgetary control data model rather than inserting directly into the control tables.