Search Results okl_split_contract_pvt




Overview
Explore in AI Chat

Overview

OKL_SPLIT_CONTRACT_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. The naming convention identifies its scope: the OKL prefix designates the lease management product family, SPLIT_CONTRACT identifies the business process, and the _PVT suffix marks it as a private (internal) API companion package rather than a public entry point. Its purpose is to support the splitting of an existing lease contract into one or more resulting contracts — a business requirement that arises when a customer, asset set, or stream structure must be partitioned for legal, accounting, or operational reasons.

The package is documented as VALID in the ETRM metadata and is classified as a PVT API, confirming that it is intended to be invoked indirectly through its public wrapper, OKL_SPLIT_CONTRACT_PUB, rather than called directly by external code.

Key Procedures and Functions

The ETRM documentation lists five procedures and functions in this package:

  • SET_CONTEXT — Establishes the session context (likely application and org context) required before any split processing can be performed safely within the OKL schema.
  • CHECK_SPLIT_PROCESS — Validates whether a contract is eligible for splitting, returning status or error information without committing changes.
  • CREATE_SPLIT_CONTRACT — Performs the core creation of the new (child) contract resulting from the split, populating header and line structures derived from the source contract.
  • POST_SPLIT_CONTRACT — Finalizes the split by applying post-creation actions such as stream generation, interface processing, and status updates.
  • CANCEL_SPLIT_PROCESS — Reverses or aborts a split in progress, restoring the source contract to an unsplit state where the transaction has not yet been committed.

No parameter signatures are documented in the ETRM metadata, and none are inferred here.

Tables Accessed

The package references tables through APPS synonyms, including contract and lease-specific structures. Documented dependencies include OKC_K_HEADERS_B and OKC_K_HEADERS_V (contract headers and their view), OKL_TRX_CONTRACTS (OKL transaction-to-contract linkage), OKC_K_ITEMS, OKC_K_LINES_B, OKC_LINE_STYLES_B, OKC_RULES_B, OKC_RULE_GROUPS_B, and OKC_SUBCLASS_TOP_LINE, covering contract lines, rule groups, and line styling. Lease-specific tables include OKL_K_HEADERS, OKL_STREAMS, OKL_STREAM_INTERFACES, OKL_ST_GEN_TMPT_SETS, OKL_TRX_ASSETS, OKL_TRX_TYPES_B, and OKL_TRX_TYPES_TL, supporting stream generation and transaction type lookup during split.

Usage Notes

OKL_SPLIT_CONTRACT_PVT is referenced by three other packages, primarily OKL_SPLIT_CONTRACT_PUB and its wrapper OKL_SPLIT_CONTRACT_PUB_W, and it also recursively references itself. This structure indicates the package is invoked from the public lease contract split API, typically triggered by the Contracts form, a concurrent program, or custom code performing lease restructuring. Because it is a PVT package, direct invocation should be avoided; developers should call the public wrapper instead. The presence of a session context routine suggests that org and application context must be initialized before invocation. On both EBS 12.1.1 and 12.2.2 the dependency structure is consistent.