Search Results okl_srl_pvt




Overview
Explore in AI Chat

Overview

The APPS.OKL_SRL_PVT package body is a private PL/SQL API within the Oracle Lease and Finance Management (OLFM) module of Oracle E-Business Suite. Its name and dependency profile indicate responsibility for the Service Request Line (SRL) private processing layer — the internal engine that the public OLFM service-request APIs delegate to for row-level manipulation of service request return information. In ETRM terms the package is classified as a PVT (private) API, meaning it is not intended for direct invocation by external callers; it is consumed by sibling and parent packages within the OLFM service architecture.

The body is documented as VALID in the APPS schema and is structured around the standard Oracle Application Object Library (AOL) API idiom, as evidenced by its dependency on FND_API, FND_GLOBAL, FND_MSG_PUB and APP_EXCEPTIONS. This confirms that the package follows the canonical EBS error-handling and message-stack conventions (p_init_msg_list / p_return_status patterns) used consistently across OLFM and OKC (Contracts) APIs.

Key Procedures and Functions

The ETRM metadata documents 18 procedures and functions in this package. The principal documented entry points are:

  • QC — Quality-control / consistency check routine used to validate the internal state of service request line records before or after DML.
  • CHANGE_VERSION — Implements optimistic locking and version stamping, advancing the record version to detect concurrent updates, consistent with ETRM versioning conventions.
  • API_COPY — Copies a service request line record, typically used during duplication or re-instantiation of service requests.
  • INSERT_ROW — Inserts a new service request line row into the underlying return-levels structures.
  • LOCK_ROW — Acquires a row-level lock (SELECT ... FOR UPDATE) to serialise concurrent modifications, invoked before update or delete operations.
  • UPDATE_ROW — Applies modifications to an existing service request line row.
  • DELETE_ROW — Removes a service request line row, subject to validation and referential checks.
  • VALIDATE_ROW — Performs mandatory and conditional attribute validation prior to DML, raising messages through FND_MSG_PUB.

Each routine is designed to be called by higher-level public APIs rather than by end users directly.

Tables Accessed

Two tables are documented as referenced through APPS synonyms:

  • OKL_SIF_RET_LEVELS — The core OLFM table storing service request return level definitions and associated attributes for return authorisations. This is the primary target of the INSERT_ROW, UPDATE_ROW, DELETE_ROW and VALIDATE_ROW operations.
  • PLITBLM — The PL/SQL integer-indexed table of messages used by the AOL message framework to build and propagate error/warning message lists between nested API calls.

The package also references the views OKL_SIF_RETS_V and OKL_SIF_RET_LEVELS_V, which expose the return and return-level data for read-only validation and query purposes.

Usage Notes

OKL_SRL_PVT is a private package and is not referenced by any external database object, per the ETRM dependency record. It is invoked exclusively from within the OLFM service request processing stack — in practice by public APIs and the service request forms and concurrent programs that drive return authorisation and service line maintenance. Custom code should target the corresponding public OLFM APIs rather than this package, since private APIs are subject to change without notice between releases (12.1.1 and 12.2.2). The ETRM metadata records this package as referenced by nine other packages, confirming its role as a shared internal utility for SRL DML and validation.