Search Results update_change_request_lines

Overview

OKL_VP_CHANGE_REQUEST_PVT is a private PL/SQL API package in the Oracle E-Business Suite (EBS) applications schema (APPS), belonging to the Enterprise Contracts / OKL (Leasing and Finance Management) module — more specifically the ETRM (Enterprise Trading and Risk Management) product family. In EBS 12.1.1 and 12.2.2, this package encapsulates the business logic required to create, modify, and manage Change Requests associated with Operating Agreements and Program Agreements. A change request represents a structured, auditable request to alter the terms or configuration of an agreement, and may pass through an approval workflow before being applied.

The package is classified as a "PVT" (private) API. This designation indicates that it is intended for internal consumption by public APIs, forms, and other framework components rather than being directly callable as a supported public interface. It defines its own subtypes and global constants (for example, G_PKG_NAME, G_APP_NAME, and the exception G_EXCEPTION_HALT_VALIDATION) and wraps the underlying record structures from okl_vcr_pvt and okl_vrr_pvt.

Key Procedures and Functions

The package exposes twelve documented procedures and functions that together cover the full lifecycle of an agreement change request:

• CREATE_CHANGE_REQUEST_HEADER — Handles creation of the change request header for Operating Agreements and Program Agreements.
• UPDATE_CHANGE_REQUEST_HEADER — Modifies an existing change request header.
• CREATE_CHANGE_REQUEST_LINES — Creates the detail lines associated with a change request.
• UPDATE_CHANGE_REQUEST_LINES — Updates existing change request lines.
• DELETE_CHANGE_REQUEST_LINES — Removes change request lines.
• CREATE_CHANGE_REQUEST — Orchestrates creation of a complete change request (header and lines).
• ABANDON_CHANGE_REQUEST — Cancels or abandons a change request before completion.
• SET_CHANGE_REQUEST_STATUS — Sets or transitions the status of a change request.
• CASCADE_REQUEST_STATUS_EDIT — Propagates status changes to related records.
• SUBMIT_CR_FOR_APPROVAL — Submits a change request into the approval process.
• GET_ASSOC_AGR_NUMBER — Retrieves the associated agreement number.
• GET_ASSOC_AGR_ID — Retrieves the associated agreement identifier.

Each creation and update routine follows the standard EBS API convention of returning x_return_status, x_msg_count, and x_msg_data for error handling.

Tables Accessed

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

• OKL_VP_CHANGE_REQUESTS — the primary store of change request records.
• OKL_VP_CR_REASONS — valid reasons associated with a change request.
• OKL_VP_CHANGE_REQ_NUM_SEQ — sequence used to generate unique change request numbers.
• OKC_K_HEADERS_B and OKL_K_HEADERS — contract header tables providing agreement context.
• FND_LOG_MESSAGES and FND_NEW_MESSAGES — the EBS logging and messaging framework for diagnostics and user messages.
• DUAL and PLITBLM — utility references used for validation and collection handling.

Usage Notes

Because OKL_VP_CHANGE_REQUEST_PVT is a private package, it is typically invoked indirectly — by public OKL APIs, by the Oracle Forms user interface for agreement change requests, or by concurrent programs that process change requests. Custom code should generally call the corresponding public API rather than this private package directly, since private APIs are not part of the supported integration surface and may change between releases. When invoked, the package is referenced by four other packages within the OKL module, confirming its role as a shared internal service. The metadata confirms compatibility with both 12.1.1 and 12.2.2.