Search Results do_launch_client_sdk




Overview
Explore in AI Chat

Overview

The APPS.CCT_PLGN_FUNC_PVT package body is a private (PVT-classified) PL/SQL construct within the Oracle E-Business Suite Customer Care / Telephony (CCT) and Interaction Center (IEU) technology stack. Its documented purpose is to support the Interaction Center's plugin selection logic by exposing a single function, DO_LAUNCH_CLIENT_SDK, which determines whether the Oracle Contact Center (CCC) client SDK plugin should be launched for a given telephony resource and application user. In effect, this package acts as a decision helper: given a resource identifier and session context, it inspects which media types and client plugins are eligible and returns a simple "Y"/"N" answer that the calling form or component can use to decide whether to instantiate the CCC client-side SDK GUI component.

The header comment (cctvplgb.pls 115.0, dated 2002) indicates this is an early-generation component of the CCT/IEU integration, consistent with the CTI (computer telephony integration) middleware used across Oracle EBS 12.1.1 and 12.2.2. As a _PVT package, it is not part of the public API surface and is not referenced by any other documented package.

Key Procedures and Functions

The ETRM metadata documents exactly one program unit, the function DO_LAUNCH_CLIENT_SDK. The user's search term matches this function directly. Its documented behavior is as follows:

  • It accepts a resource identifier, a user identifier, a responsibility identifier, a responsibility application identifier, and a user language as inputs (these identify the telephony resource and the runtime session context).
  • It returns a single-character VARCHAR2 value, initialized to 'N', and set to 'Y' only when the launch condition is satisfied.
  • It first invokes IEU_PVT.DETERMINE_ALL_MEDIA_TYPES_EXTN to populate the eligible media types and a telephone-eligibility flag (l_tel_eligible_flag).
  • It then invokes IEU_PVT.DETERMINE_CLI_PLUGINS to populate a collection of client plugin class names (l_classes, of type IEU_PVT.ClientClasses).
  • It iterates over the plugin collection and returns 'Y' when the telephone-eligibility flag is 'Y' and a plugin matching oracle.apps.cct.ccc.clientsdk.gui.MediaControllerPlugginImpl is present; otherwise it returns 'N'.
  • An WHEN OTHERS exception handler returns NULL, ensuring the caller fails safely.

A local boolean l_ao_man_mode is declared but is not referenced in the documented body logic.

Tables Accessed

The documented table reference is PLITBLM, accessed via an APPS synonym. This is the Interaction Center's media/plugin configuration table that underpins the IEU_PVT helper routines. Rather than querying this table directly, the package relies on IEU_PVT to read the eligible media types and plugin definitions, so the table access is indirect through those calls. The package itself performs no direct DML; it is purely a read-and-evaluate decision function.

Usage Notes

Because CCT_PLGN_FUNC_PVT is classified as a private package and is referenced by no other documented package, it is intended for internal use by CCT/IEU framework components rather than by customer extension code. Typical invocation occurs from Oracle Forms-based Interaction Center agent UIs or from CTI integration components that need to decide, at agent login or resource-selection time, whether the CCC client SDK media controller plugin should be launched. Custom developers should prefer the public IEU_PVT APIs when building extensions; direct calls to this private function are unsupported and may change between releases. The function's reliance on l_tel_eligible_flag makes it effective only for telephone-type resources configured for CTI operation.