Search Results reamort_upgrade




Overview
Explore in AI Chat

Overview

OKL_PRB_UPGRADE_PVT is a private (PVT-classified) PL/SQL package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It provides the internal implementation logic for the Parallel Rebooking (PRB) upgrade process, which converts eligible ESG lease contracts to a rebooked state under effective-dated terms. The package is declared with AUTHID CURRENT_USER and its header identifies it as source version OKLRPRBS.pls 120.1, last modified 2011/03/29. The package exposes both a worker/API entry point and a concurrent-program entry point for the same upgrade operation, allowing the rebooking upgrade to be driven either by a single worker identifier or by a submitted concurrent request.

The package defines a global constant G_ESG_PRB_KHR_UPG_OBJ_TYPE set to 'ESG_PRB_UPGRADE_CONTRACT', which registers the upgrade as a specific object type within the ESG PRB upgrade framework. Commit behavior is batched: G_COMMIT_AFTER_RECORDS is fixed at 500 rows, and a running counter G_COMMIT_COUNT tracks records processed between commits. Standard OKL_API error-handling constants are reused so that exceptions raised inside the package conform to the module's common error framework.

Key Procedures and Functions

  • EFF_DATED_RBK_UPGRADE — The core worker procedure that performs the effective-dated rebooking upgrade for an ESG lease contract. It accepts a worker identifier and returns the standard concurrent-program OUT parameters (errbuf and retcode), enabling it to be called both directly and from concurrent processing.
  • EFF_DATED_RBK_UPGRADE_CONC — The concurrent-program wrapper for the effective-dated rebooking upgrade. This is the entry point referenced by the search term "eff_dated_rbk_upgrade_conc" and is what a concurrent program definition would invoke when a user submits the PRB upgrade request.
  • REAMORT_UPGRADE — Handles the reamortization portion of the upgrade, recalculating or restating amortization schedules as part of the contract upgrade.
  • REAMORT_UPGRADE_CONC — The concurrent-program wrapper for the reamortization upgrade, the counterpart to EFF_DATED_RBK_UPGRADE_CONC.

The package also declares internal record and table types (worker_load_rec, worker_load_tab) used to distribute upgrade work across parallel workers. Because the package is classified PVT and documented as referenced by zero other packages, these procedures are intended for internal framework consumption rather than as a published public API.

Tables Accessed

The package operates across contract, product, and stream-generation data. It reads and writes contract headers through OKC_K_HEADERS_ALL_B, OKC_K_HEADERS_B, and OKL_K_HEADERS, and resolves contract statuses via OKC_STATUSES_TL. Product definitions come from OKL_PRODUCTS, and system accounting options from OKL_SYS_ACCT_OPTS_ALL. The rebooking scope is driven by OKL_RBK_SELECTED_CONTRACT, with sequencing and parallelism managed through OKL_OPP_SEQ and OKL_PARALLEL_PROCESSES. Transaction and asset data are handled via OKL_TRX_ASSETS, OKL_STREAM_INTERFACES, OKL_STREAM_TRX_DATA, and the temporary tables OKL_AE_TMPT_SETS_ALL and OKL_ST_GEN_TMPT_SETS_ALL. Concurrent request status is read from FND_CONCURRENT_REQUESTS.

Usage Notes

OKL_PRB_UPGRADE_PVT is invoked through the Parallel Rebooking upgrade infrastructure rather than by end users directly. The procedures are surfaced to users primarily through concurrent programs, which call the *_CONC variants, while the non-CONC procedures serve as the underlying worker logic. Because the package is marked PVT and is not referenced by any other documented package, customizations should avoid calling it directly; instead, the standard concurrent program should be submitted to trigger the effective-dated rebooking upgrade. The batched commit interval of 500 records means large upgrade runs commit incrementally, so partial progress is preserved if a run is interrupted. Given its 2011 source header, the package reflects the ETRM 12.1.1/12.2.2 code line and should be treated as an internal component subject to change across patches.