Search Results okl_view_concurrent_pvt




Overview
Explore in AI Chat

Overview

OKL_VIEW_CONCURRENT_PVT is a private PL/SQL package body in the APPS schema that belongs to the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. The "PVT" suffix classifies it as an internal, private API companion to a public package — in this case OKL_VIEW_CONCURRENT — meaning it is not intended to be called directly by external or customer code but rather supports the public package and the concurrent processing framework that surrounds it. Within ETRM, the package deals with the presentation layer of concurrent program output: it produces the diagnostic text and URL information used when a user views or troubleshoots the output of lease-management concurrent requests. It depends on the generic EBS infrastructure packages FND_API, FND_CONC, FND_PROFILE, and FND_WEBFILE for error handling, concurrent request metadata, profile option values, and web-file/URL resolution, as well as OKL_API for lease-module error messages. The object is VALID and is documented at the ETRM 12.2.2 level, applicable to both 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The documented package body exposes a single procedure or function:

  • GET_URL_DIAGNOSTICS_TEXT — This routine assembles the diagnostic text associated with the URL that a concurrent program produces for viewing output within the Oracle Lease and Finance Management application. It is used when a user or support analyst needs to understand why a concurrent request's viewable output could not be displayed or when the system URL that hosts that output must be explained. The procedure draws on FND_CONC for concurrent request data and FND_WEBFILE/FND_PROFILE for resolving the web file and environment-specific URL information, returning the diagnostic message text to the caller. As a private helper, it is invoked only from within OKL_VIEW_CONCURRENT_PVT or its public wrapper, not from end-user code.

No parameter lists are exposed in the ETRM metadata; only the name and purpose are documented.

Tables Accessed

The ETRM dependency listing for OKL_VIEW_CONCURRENT_PVT records no direct references to application tables; the package works through the FND and OKL APIs rather than issuing DML against OKL business tables. Any data retrieved about a concurrent request is obtained through FND_CONC views and profile values are read via FND_PROFILE, while URL and web-file metadata is resolved through FND_WEBFILE. This design keeps the package free of direct table dependencies and confines it to the diagnostic/display concern rather than lease data maintenance.

Usage Notes

Because OKL_VIEW_CONCURRENT_PVT is a PVT-designated package and is not referenced by any other database object, it is invoked only indirectly — through the Oracle Lease and Finance Management concurrent programs and Oracle Forms that call the corresponding public OKL_VIEW_CONCURRENT package. Typical triggers include viewing the output of a lease concurrent request from the Requests form, or diagnosing a URL/file-resolution failure for such output. Custom code should not call OKL_VIEW_CONCURRENT_PVT directly; when customization or extension of lease concurrent output viewing is required, the supported approach is to work through the public OKL_VIEW_CONCURRENT API and the standard FND concurrent processing interfaces. The package is compiled and shipped as VALID APPS code in both 12.1.1 and 12.2.2, and its dependencies should be respected when patching FND or OKL foundation packages.