Search Results p_period_from

Overview

OKL_PERIOD_SWEEP_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite applications schema (APPS), owned by the Oracle Leasing (OKL) module. In Oracle EBS 12.1.1 and 12.2.2 it supports the period sweep and period-end processing used by Oracle Lease Management, in which lease transactions, accounting distributions and subledger events are evaluated or swept across an accounting period range so that revenue, receivables and accounting entries are generated for the correct GL periods. The package is classified as PVT, meaning it is an internal implementation package intended for use by the module's public APIs and concurrent program infrastructure rather than for direct customer invocation. The source header identifies the package body as OKLRSWPS.pls (120.4.12010000.2, dated 2008), and the constants G_REQUIRED_VALUE, G_COL_NAME_TOKEN, G_PKG_NAME, G_APP_NAME and G_FILE_NAME are inherited from the common OKC_API and OKL_API error-handling and message conventions used throughout Oracle Contracts and Leasing. A notable structural feature, added under Bug 5707866, is the presence of package-level variables (p_period_from, p_period_to, p_run_option, p_representation_code) that mirror the XML Publisher report input parameters, allowing the concurrent program entry points and the report's BeforeReport trigger to share period selection within a single session.

Key Procedures and Functions

The package exposes three documented program units:

• OKL_PERIOD_SWEEP — the concurrent-program entry point. It follows the standard EBS concurrent program signature (p_errbuf and p_retcode as the OUT NOCOPY error buffer and return code), and accepts the representation code, the period-from and period-to range, and a run option that controls the sweep mode. It performs the period sweep processing and reports success or failure through the standard concurrent manager error mechanism.
• OKL_PERIOD_SWEEP_CON — the API-style wrapper for the same processing. It uses the conventional Contracts/Leasing API parameter pattern (p_init_msg_list, x_return_status, x_msg_count, x_msg_data) and additionally returns x_request_id, which allows the caller to correlate the submission with a concurrent request. This procedure is the appropriate entry point for programmatic or custom invocation.
• BEFOREREPORT — a Boolean function added under Bug 5707866 specifically to support the XML Publisher report. It prepares or validates report parameters before the report layout is generated, returning TRUE on success. It is invoked from the report's BeforeReport trigger and is not intended for external calls.

Tables Accessed

The documented tables reflect the full scope of lease period-end processing. GL_PERIODS and GL_PERIOD_STATUSES provide the General Ledger period definitions and open/closed status used to validate and select the sweep range. OKC_K_HEADERS_ALL_B, OKL_TRX_CONTRACTS_ALL and OKL_TXL_CNTRCT_LNS_ALL supply the contract headers and transaction lines being swept. OKL_TRX_TYPES_B and OKL_STRM_TYPE_TL identify transaction and stream types (the latter with translated descriptions for reporting). OKL_TRNS_ACC_DSTRS holds the transaction accounting distributions that are generated or evaluated, while XLA_EVENTS links the resulting accounting to the Subledger Accounting (XLA) event model. OKL_G_REPORTS_GT is a global temporary table used to stage report output, consistent with the XML Publisher reporting role of the package, and PLITBLM is the standard PL/SQL intermediated table used for bulk parameter or ID handling.

Usage Notes

In practice, OKL_PERIOD_SWEEP_PVT is invoked indirectly. The concurrent program path calls OKL_PERIOD_SWEEP with the user's representation code and p_period_from / p_period_to selections, typically for period-end revenue and accounting sweeps in Lease Management. Custom code should call OKL_PERIOD_SWEEP_CON, checking x_return_status against OKC_API.G_RET_STS_SUCCESS and rolling back on error. Because the package is PVT, its signature is not guaranteed across patch levels, and any direct dependency should be revalidated after applying EBS patches or upgrades. The package-level p_period_from variable is populated by the concurrent program and consumed by the BEFOREREPORT function for the associated XML Publisher report, so report runs and concurrent submissions should not be interleaved in the same database session.