Search Results okl_rbk_seq




Overview
Explore in AI Chat

Overview

OKL_MAINTAIN_CONTRACT_PVT is a private (PVT-classified) PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Lease and Finance Management (OKL) module of the ETRM (Enterprise Trade and Risk Management) product family. The package encapsulates the internal business logic used to maintain lease and finance contract records, including the validation, confirmation, and cancellation workflows that govern the contract lifecycle.

As a PVT-classified package, OKL_MAINTAIN_CONTRACT_PVT is not intended to be called directly by external or customer-written code. It is a supporting implementation layer beneath the public OKL_API and OKL_LEASE_APP_PVT interfaces, which expose the sanctioned, supported entry points for contract maintenance. Its status is VALID, confirming it is compiled and operational in the documented environment.

Key Procedures and Functions

The documented interface exposes one procedure:

  • CONFIRM_CANCEL_CONTRACT — Confirms the cancellation of a lease or finance contract. This routine is the internal handler that completes the cancellation transaction after the appropriate validations and prerequisite steps have been satisfied. It coordinates the update of contract header and line status, the removal or reversal of associated party roles, and the flagging of related transaction records such as AP and AR invoices. Its placement in a private package indicates that callers reach it indirectly, typically through the public OKL_API wrappers.

The metadata documents only this single public subprogram; additional private helper routines may exist but are not enumerated in the ETRM catalogue.

Tables Accessed

The package references the following tables (accessed through APPS synonyms) to perform its contract maintenance duties:

  • OKC_K_HEADERS_B, OKC_K_LINES_B, OKC_K_LINES_TL — Core contract header and line base and translation tables. The package updates the status of contract headers and lines during confirmation or cancellation and reads translated line descriptions for validation.
  • OKC_K_PARTY_ROLES_B — Stores the parties and roles associated with a contract; the package manages these role assignments when a contract is cancelled.
  • OKC_LINE_STYLES_B — Defines line style attributes that drive business rules applied during maintenance.
  • IEX_BANKRUPTCIES — Bankruptcy information from the Collections (IEX) module, consulted to determine customer status before confirming a contract action.
  • OKL_RBK_SEQ — The sequence used for generating "RBK" (rebate/recoup) identifiers. Given the user search term okl_rbk_seq, this sequence is the documented source of unique keys generated within the contract maintenance flow.
  • OKL_FAN_SEQ — A companion sequence (financial/FAN identifiers) used for key generation.
  • OKL_TRX_AP_INVOICES_B, OKL_TRX_AR_INVOICES_B — Lease transaction invoice tables for payables and receivables; the package reads and updates these to reflect contract cancellation.
  • DUAL — Used for single-row expression evaluation and sequence retrieval.

Usage Notes

Because OKL_MAINTAIN_CONTRACT_PVT is classified PVT and is referenced by two other packages, it is invoked indirectly rather than through direct SQL or concurrent program registration. Typical invocation paths include the Lease Management forms, the public OKL_API and OKL_LEASE_APP_PVT interfaces, and other OKL package code that delegates contract maintenance operations. It depends on OKL_API, OKC_API, OKL_TAP_PVT, OKL_LEASE_APP_PVT, FND_API, and FND_LOOKUPS, indicating it participates in the standard API/validation framework. Custom developers should not call it directly; supported customization should go through the public OKL_API entry points.