Search Results create_budget_line

Overview

The OKL_SUBSIDY_POOL_BUDGET_PVT package is a private PL/SQL API within the Oracle E-Business Suite (EBS) Enterprise Contract and Transaction Management (ETRM) module, historically delivered as part of Oracle Lease Management (OKL). It encapsulates the internal business logic that governs budget line maintenance for subsidy pools, which are used to allocate, track, and consume subsidy funding across lease or contract portfolios. The package is declared with AUTHID CURRENT_USER and conforms to the standard Oracle API pattern, carrying the private suffix _PVT in the G_PKG_NAME constant and registering _PVT in G_API_TYPE. It defines the subtypes budget_line_rec and budget_line_tbl, derived from okl_sib_pvt.sibv_rec_type and okl_sib_pvt.sibv_tbl_type, to standardise the record and table structures used for bulk budget line processing. In practice, this package is the private implementation layer that supports a subsidy pool's budgeting lifecycle, including record creation, modification, status decisions, and validation.

Key Procedures and Functions

The documented interface exposes four procedures:

• CREATE_BUDGET_LINE — Inserts new budget line records into the subsidy pool budgets table. The procedure accepts an API version, an initialisation flag for message list handling, standard return status and message outputs, and a budget line table, returning a corresponding output table. Its business rule is to create budget lines for the subsidy pool identified by the subsidy pool ID held on the budget line records.
• UPDATE_BUDGET_LINE — Modifies existing subsidy pool budget lines, applying the same standard API parameters for versioning, message handling, and bulk table input/output.
• SET_DECISION_STATUS_CODE — Sets the decision status code on budget lines, supporting the approval or rejection workflow that determines whether a budget line is active and usable against its subsidy pool.
• VALIDATE_BUDGET_LINE — Performs the validation logic for budget lines, raising G_EXCEPTION_HALT_VALIDATION when the caller must stop further processing. Validation typically precedes creation or update to ensure data integrity and business rule compliance.

No public parameter lists beyond those documented are asserted; the package is not intended for direct external invocation.

Tables Accessed

The package operates against the following objects referenced via APPS synonyms:

• OKL_SUBSIDY_POOL_BUDGETS_B — The base table holding subsidy pool budget line records. The create procedure inserts here, and the update and decision-status procedures modify rows in this table.
• FND_LOG_MESSAGES — Used to record debug and diagnostic log messages through the FND logging framework.
• WF_EVENTS and WF_PARAMETER_LIST_T — Utilised by the Workflow engine to raise business events and pass associated parameter lists, enabling downstream subscriptions or notifications when budget lines are created or statuses change.

Usage Notes

Because the package is classified as PVT, it is invoked indirectly rather than directly by end users. Standard entry points include the Lease Management subsidy pool forms, concurrent programs, and the public (non-private) OKL API layer that wraps this private package. The package is referenced by three other packages, confirming that it serves as a shared internal utility for subsidy pool processing. Developers extending Oracle ETRM should call the corresponding public API rather than OKL_SUBSIDY_POOL_BUDGET_PVT directly, since private APIs are subject to change across EBS releases such as 12.1.1 and 12.2.2. Custom integrations that must use this package should follow the standard API pattern: initialise the message list, supply a populated budget line table, and inspect x_return_status and the message outputs for error handling.