Search Results submit_depr_adjustment




Overview
Explore in AI Chat

Overview

The APPS.OKL_ACCRUAL_DEPRN_ADJ_PUB package body is a public PL/SQL API within the Oracle Lease Management (OKL) module of Oracle E-Business Suite. It serves as the externally callable interface for submitting accrual depreciation adjustments — a process used to correct or re-align depreciation amounts that were accrued against leased assets but subsequently require adjustment due to changes in the lease terms, asset values, or accounting periods.

As a "PUB" classified API, the package is intended for direct invocation by external callers, including concurrent programs, forms, or custom extensions. The package body is a thin wrapper that delegates the substantive business logic to the private companion package OKL_ACCRUAL_DEPRN_ADJ_PVT, while enforcing Oracle's standard API error-handling conventions (SAVEPOINT, exception trapping, message stacking). The header comment references version 115.3 dated 2003/10/08, indicating that the implementation is stable and has been carried forward into EBS 12.1.1 and 12.2.2 largely unchanged.

Key Procedures and Functions

The package exposes a single documented function: SUBMIT_DEPRN_ADJUSTMENT.

  • SUBMIT_DEPRN_ADJUSTMENT — The primary entry point for initiating a depreciation adjustment run. It accepts a batch name and a date range, then submits the underlying concurrent request via the private package OKL_ACCRUAL_DEPRN_ADJ_PVT.SUBMIT_DEPRN_ADJUSTMENT. The function returns the concurrent request ID, allowing the caller to monitor the job through the standard FND request interface. On failure, it rolls back to the local savepoint SUBMIT_DEPR_ADJUSTMENT and returns the appropriate return status (G_RET_STS_SUCCESS, G_RET_STS_ERROR, or G_RET_STS_UNEXP_ERROR). Error details are populated via FND_MSG_PUB.Count_and_get.

No other public procedures or functions are documented in this package.

Tables Accessed

The ETRM metadata does not list any direct table references from this package body. This is expected because OKL_ACCRUAL_DEPRN_ADJ_PUB delegates all data manipulation to OKL_ACCRUAL_DEPRN_ADJ_PVT. Any table reads or writes — such as those against lease accrual, depreciation, or contract accounting tables — occur in the private layer, not here. Callers requiring knowledge of the affected schema objects should consult the private package documentation.

Usage Notes

Typical invocation scenarios include:

  • Concurrent Programs — The function is designed to be called from a concurrent program wrapper so that the depreciation adjustment executes in the background and returns a request ID for FND request monitoring.
  • Forms and Custom Code — The API may be called from Oracle Forms or custom PL/SQL when a user triggers an adjustment for a specific batch and date range.
  • Error Handling Contract — Callers must pass the standard x_return_status, x_msg_count, and x_msg_data OUT parameters and should inspect the return status before acting on the returned request ID. The l_api_version is initialised to 1.0 internally, so callers should pass a compatible version.
  • Transaction Control — Because the function uses SAVEPOINT and rolls back on error, callers should not wrap it inside a larger transaction that must commit atomically with other operations, unless prepared to handle partial rollback semantics.

Being referenced by one other package, the API is not a highly reused entry point; it is purpose-built for the accrual depreciation adjustment submission flow.