Search Results update_period_status

Overview

OKL_PERD_STATUS_PUB is the public PL/SQL package that exposes period status maintenance functionality for the Oracle Lease and Finance Management (OKL) module in Oracle E-Business Suite 12.1.1 and 12.2.2. The package body follows the standard EBS API architecture: the private implementation logic resides in the companion package OKL_PERD_STATUS_PVT, while the PUB package provides a thin, stable, publicly callable interface that validates the API version, initializes the message stack, and delegates processing to the private layer. The module identifier registered with the debug framework is LEASE.ACCOUNTING.PERIOD, confirming that the package supports the accounting period lifecycle within lease contracts.

The package body begins with automatically generated debug wrapper code, which permits diagnostic logging of each API call when debugging is enabled through OKL_DEBUG_PUB. This instrumentation reflects the package's status as a supported, production-grade interface.

Key Procedures and Functions

• SEARCH_PERIOD_STATUS — A query-oriented API that returns period status records matching the supplied search criteria. The caller passes a period record as input and receives a collection (table type) of matching period status rows. Internally, the procedure declares a local API version constant of 1.0, establishes a savepoint named SEARCH_PERIOD_STATUS, sets the return status to success, and then delegates to OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS. Standard EBS API conventions apply: p_api_version for version compatibility checking and p_init_msg_list to control message stack initialization, with x_return_status, x_msg_count, and x_msg_data returned to the caller. It also participates in the debug logging framework.
• UPDATE_PERIOD_STATUS — The maintenance counterpart that updates period status information. Because the documentation classifies this package as a PUB API, UPDATE_PERIOD_STATUS follows the same delegation pattern: it is expected to accept the period record, validate the input, and forward the request to the corresponding private procedure in OKL_PERD_STATUS_PVT while returning standard API status and message outputs.

Tables Accessed

The ETRM metadata for this package does not enumerate specific tables referenced through APPS synonyms. By design, the PUB layer performs no direct DML; all table access, including reads and updates against the underlying period status entities, is encapsulated within OKL_PERD_STATUS_PVT. Consumers requiring a definitive table list should inspect the private package (OKL_PERD_STATUS_PVT) and the OKL accounting period schema objects directly.

Usage Notes

OKL_PERD_STATUS_PUB is the supported entry point for programmatic interaction with lease accounting period status. It is typically invoked from:

• Oracle Forms and OAF pages within the Lease Management responsibility that present period status information.
• Concurrent programs or batch processes that need to query or reconcile period status across lease contracts.
• Custom PL/SQL integrations and extensions that must search or update period status using a version-controlled, message-aware API rather than direct table manipulation.

Callers should always check x_return_status for FND_API.G_RET_STS_SUCCESS or error, and inspect x_msg_count and x_msg_data for diagnostics. Because UPDATE_PERIOD_STATUS modifies lease accounting data, invocations should participate in the caller's transaction and be committed or rolled back deliberately. Use of the private package directly is not supported. The package is referenced by one other package, indicating it forms part of a larger dependency chain within OKL accounting; changes should therefore be assessed for downstream impact.