Search Results update_service_assets

Overview

OKL_LEASE_QUOTE_SERVICE_PVT is a private PL/SQL API package in the Oracle Lease and Finance Management (OLFM / OKL) module of Oracle E-Business Suite. It encapsulates the business logic that manages service line items attached to lease quotes. In the OLFM data model a lease quote can carry service products (maintenance, insurance, freight, and similar ancillary charges) that are priced and financed alongside the leased asset. This package provides the internal Create, Update, Duplicate, and Delete operations that keep the service records, their associated assets, and their generated cash flows consistent.

The package name carries the standard OLFM private-API conventions. The _PVT suffix classifies it as a private package (API classification: PVT in ETRM 12.2.2), meaning it is not a supported public integration point and is subject to change without notice. Public access is expected to flow through the corresponding public API wrapper, which supplies the FND_API standard parameters (p_init_msg_list, p_commit, x_return_status, x_msg_count, x_msg_data) before delegating to the private package. The header declares the usual FND_API constants, G_PKG_NAME, G_APP_NAME via OKL_API, and G_USER_ID / G_LOGIN_ID from FND_GLOBAL, confirming that the package follows the OLFM API error-handling and auditing framework.

In 12.1.1 and 12.2.2 the package is identical in purpose; no ETRM change is recorded between those releases for this object. The header revision ($Header: OKLRQUSS.pls 120.3) indicates a stable, long-lived implementation.

Key Procedures and Functions

Six documented procedures constitute the package surface. Parameter lists are intentionally omitted here; only purpose is described.

• CREATE_SERVICE — Inserts a new service record against a lease quote, populating OKL_SERVICES_B and its translation row, and establishing the line relationship that links the service to its parent quote or asset line.
• UPDATE_SERVICE — Modifies the attributes of an existing service record, including descriptive text and pricing attributes, and synchronises the related line relationship and cash-flow rows.
• UPDATE_SERVICE_ASSETS — Maintains the association between a service and the assets it applies to, writing to OKL_ASSETS_B. This supports the common case where one service charge covers multiple leased assets on the same quote.
• DUPLICATE_SERVICE — Copies an existing service, together with its relationships and coverage, to create a new service line. This supports quote versioning and the "copy quote" user flows.
• DELETE_SERVICE — Removes a service record and its dependent rows, including line relationships, asset associations, and generated cash flows. This is the procedure relevant to a search for delete_service. Note the ETRM-documented operation name is DELETE_SERVICE; callers invoking it directly bypass public-API validation and should be aware that OLFM enforces delete restrictions through the surrounding quote or application state.

The package also declares a line_relation_rec_type record and a line_relation_tbl_type PL/SQL table type, plus a subtype aliased to okl_lre_pvt.lrev_tbl_type. These structures carry line-relationship data (source and related line type and ID, amount, descriptions, record mode) between the private package and the line-relationship engine, and they explain why the package requires OKL_LINE_RELATIONSHIPS_B and OKL_LINE_RELATIONSHIPS_TL.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• OKL_SERVICES_B — the base service entity, created, updated, and deleted by the service procedures.
• OKL_LINE_RELATIONSHIPS_B and OKL_LINE_RELATIONSHIPS_TL — the parent/child links and their translated descriptive columns, populated from the package's record type.
• OKL_ASSETS_B — asset coverage for a service, maintained by UPDATE_SERVICE_ASSETS.
• OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, and OKL_CASH_FLOW_OBJECTS — the cash-flow hierarchy that prices a service and rolls it into the quote's stream of payments.
• OKL_LEASE_QUOTES_B, OKL_LEASE_APPLICATIONS_B, and OKL_LEASE_OPPORTUNITIES_B — the quote and its application/opportunity parents, validated to confirm the service belongs to a valid, editable quote context.
• PLITBLM — the standard EBS index-by-table PL/SQL utility package used for internal collections.

Usage Notes

OKL_LEASE_QUOTE_SERVICE_PVT is invoked from the OLFM Lease Quotes (OKL) forms and from the public quote APIs. The quote entry form calls the service procedures when a user adds, changes, duplicates, or removes a service line, and when the quote is saved or submitted the cash-flow tables are regenerated. Concurrent programs such as quote re-pricing and mass quote maintenance may also drive the package indirectly. Because it is a private (PVT) package, customer extensions should call the public wrapper rather than this object directly; direct calls bypass FND_API message-stack handling and the documented commit/validation contract. The package is referenced by two other packages in the OKL schema, which are the expected public or higher-level private callers.