Search Results create_mass_rbk_set_values

Overview

OKL_MASS_REBOOK_PVT is a private (PVT) PL/SQL package in the Oracle Lease and Finance Management (OKL / ETRM) application, owned by the APPS schema and declared with AUTHID CURRENT_USER. Its business purpose is to support the mass rebooking of lease and finance contracts — that is, the simultaneous rebooking of a set of contracts that share common selection criteria, rather than rebooking each contract individually. This addresses scenarios such as mid-term contract restructuring, asset changes, or accounting corrections that must be propagated consistently across many contracts at once.

The package encapsulates the validation, selection, processing, and persistence logic for a mass rebooking request. It defines a series of error constants (for example G_UNEXPECTED_ERROR, G_INVALID_CRITERIA, G_NO_MATCH_FOUND, G_DUPLICATE_REQUEST, and G_NO_SEL_CONTRACT) that are surfaced when a request fails validation or cannot be fulfilled, providing a controlled error-handling interface for callers. The package also declares numerous SUBTYPE aliases (mrbv, mstv, tcnv, thpv, tlpv, adpv, khrv, chrv, klev, clev) that mirror record and table types from the broader OKL public and private APIs, allowing mass-rebooking logic to interoperate with contract, asset, transaction, and migration structures.

Key Procedures and Functions

The documented API exposes thirteen procedures and functions covering the mass rebooking lifecycle:

• BUILD_AND_GET_CONTRACTS — assembles and retrieves the set of contracts that qualify for mass rebooking based on the supplied selection criteria.
• CREATE_MASS_RBK_SET_VALUES — creates the set of attribute values (set values) that drive the mass rebooking rules and their evaluation.
• PROCESS_MASS_REBOOK — the central driver that executes the mass rebooking process across the selected contracts.
• APPLY_MASS_REBOOK — applies the rebooking action to the eligible contracts, writing the resulting changes. This is the procedure most commonly referenced by the "apply_mass_rebook" search term.
• UPDATE_MASS_RBK_CONTRACT — updates the individual contract records affected by a mass rebooking request.
• MASS_REBOOK_AFTER_YIELD — handles the post-yield rebooking path, invoked when rebooking must occur after yield calculation.
• MASS_REBOOK_ACTIVATE — activates the contracts resulting from the mass rebooking operation.

The remaining documented members complete the internal control flow around these operations. Parameter lists are not published for this private package.

Tables Accessed

The package operates over the core OKL and OKC contract data model. It reads and writes OKL_MASS_RBK_CRITERIA and OKL_RBK_SELECTED_CONTRACT — the staging tables that hold mass-rebooking selection criteria and the contracts selected for rebooking. Contract header and line data are manipulated through OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_STATUSES_B, and the OKL-specific OKL_K_HEADERS and OKL_K_LINES. Asset information is sourced from OKL_TRX_ASSETS, OKL_TXL_ASSETS_B, and the transaction structures referenced by OKL_TRX_CONTRACTS; product and stream context come from OKL_PRODUCTS and OKL_STREAMS. OKL_TRX_TYPES_TL supplies transaction type descriptions. Accounting book information relevant to the rebooking is read from FA_BOOKS. Together these tables provide the contract, asset, product, stream, transaction-type, and accounting context required to validate and post a mass rebooking.

Usage Notes

As a PVT-classified package, OKL_MASS_REBOOK_PVT is not intended for direct invocation by end users or external integrations. It is referenced by eleven other packages and is typically driven by the OKL mass rebooking concurrent program or the corresponding Lease Management forms, which gather user-supplied criteria and invocation parameters. In Oracle EBS 12.1.1 and 12.2.2, the public entry point for mass rebooking remains the application UI or the seeded concurrent request, with this package performing the underlying processing. Custom code, if required, should invoke the documented public APIs that wrap this package rather than calling OKL_MASS_REBOOK_PVT directly. Because the package is AUTHID CURRENT_USER, callers must ensure the invoking schema has appropriate privileges on the underlying OKL and OKC objects.