Search Results delete_service_line




Overview
Explore in AI Chat

Overview

The APPS.OKL_SERVICE_LINE_PROCESS_PVT package body is a private (PVT-classified) API within the Oracle E-Business Suite Lease Management (OKL) module, part of the Enterprise Contract and Lease Management (ETRM) application family. Its central purpose is to manage the creation, maintenance, and removal of service lines on lease and contract instruments. Service lines represent the ongoing service components attached to a lease, such as maintenance, insurance, and other recurring charges that accompany the financed asset.

Because the package is classified as PVT, it is not intended for direct invocation by external or customer-written code. Rather, it serves as the internal implementation layer behind the public OKL service line APIs, encapsulating validation, record transformation, and persistence logic for the service line entities in the Lease Management data model. The package was last modified in the 12.1.1-era source base (header revision 120.3) and remains documented in ETRM 12.2.2, indicating continuity of behavior across both releases.

Key Procedures and Functions

The package exposes four documented procedures:

  • CREATE_SERVICE_LINE — The primary entry point invoked to establish a new service line on an existing contract or lease header. As seen in the source extract, it accepts API versioning and message-list initialization parameters, along with four record-type inputs (the clev, klev, cimv, and cplv record structures) carrying the service line attributes, and returns corresponding output record structures together with the standard x_return_status, x_msg_count, and x_msg_data diagnostic parameters. It derives the contract header identifier from the incoming clev record and validates the underlying header state before persisting the new line.
  • CREATE_SERVICE_ASSET — Creates the asset association linked to a service line, binding the service component to the leased asset so that the service obligation is properly attributed within the contract structure.
  • UPDATE_SERVICE_LINE — Modifies the attributes of an existing service line, allowing changes to term, pricing, or related service details without recreating the line.
  • DELETE_SERVICE_LINE — Removes a service line from the contract, typically subject to validation of downstream dependencies before the record is retired or logically deleted.

Tables Accessed

  • OKC_K_HEADERS_B — The core contract/lease header table, accessed via the c_hdr cursor in CREATE_SERVICE_LINE to retrieve the header's sts_code (status) and currency_code. These values drive status validation and default currency derivation for the new service line.
  • OKC_LINE_STYLES_B — The line style definition table, consulted to resolve the valid service line style and its associated behavior when creating or updating lines.

The package relies on APPS synonyms for these tables, consistent with OKL's layered architecture over the OKC contract foundation.

Usage Notes

As a PVT package, OKL_SERVICE_LINE_PROCESS_PVT is normally invoked indirectly through the corresponding public OKL API wrappers rather than being called directly. Standard invocation paths include Lease Management forms (such as the contract and service line maintenance screens) and concurrent programs that generate or refresh service lines. Custom integrations should call the public API layer, which in turn delegates to this private package, preserving the standard OKL_API.START_ACTIVITY / END_ACTIVITY message-handling and error-propagation conventions. The package is referenced by one other package, reflecting its role as a shared internal service-line processing utility.