Search Results delete_budget_line

Overview

The APPS.IGW_BUDGET_DETAILS_PVT package is a private PL/SQL API that supports budget line maintenance within the Oracle E-Business Suite Grants and Proposal management modules. The package header carries a revision marker of version 120.3, dated 2005/10/30, which places the source lineage firmly within the pre-R12 development stream and confirms longstanding stability through the 12.1.1 and 12.2.2 releases. Its name prefix, IGW, associates it with the Oracle Grants/Costing application family, while the _PVT suffix denotes an internal, private package intended to be invoked by another layer of code rather than directly by end users.

The business purpose of the package is to encapsulate the create, update, and delete lifecycle of budget line items on proposals and awards, together with supporting retrieval logic for derived attributes such as the personnel attachment flag and the budget justification text. By centralizing this logic, the package enforces consistent validation, message handling, and commit semantics through the FND_API conventions used across the EBS technology stack.

Key Procedures and Functions

• GET_PERSONNEL_ATTACHED_FLAG — A function that returns a flag indicating whether personnel are attached, derived from the supplied expenditure type and expenditure category flag.
• GET_BUDGET_JUSTIFICATION — A function that retrieves the budget justification text associated with a given line item identifier.
• CREATE_BUDGET_LINE — The primary procedure for inserting a new budget line. It accepts proposal, version, and budget period context, expenditure and budget category attributes, cost and cost-sharing amounts, and optional project, task, and award references.
• UPDATE_BUDGET_LINE — The counterpart procedure for modifying an existing budget line, following the same FND_API initialization, commit, and validate-only parameter conventions as the create procedure.
• DELETE_BUDGET_LINE — The procedure that removes a budget line item. The user's search term, delete_budget_line, maps directly to this documented procedure, which is the supported programmatic path for removing budget detail records.

Tables Accessed

The ETRM metadata for this object does not enumerate specific base tables through APPS synonyms. By convention, the procedures operate against the IGW budget detail and proposal/award-related tables that hold line item, expenditure category, and justification data. Callers should treat the underlying tables as implementation details of the private package and interact only through the documented interfaces.

Usage Notes

Because this is a private (_PVT) API referenced by zero other documented packages, it is not intended for direct invocation by external custom code. It is typically called from within the Grants/Proposal budget entry forms and any public wrapper package that shares the IGW_BUDGET_DETAILS namespace. Standard API practices apply: pass FND_API.G_FALSE for commit unless the caller controls the transaction boundary, inspect the returned x_return_status, x_msg_count, and x_msg_data outputs, and use the validate-only mode when performing pre-commit checking.