Search Results uwq_get_media_func

Overview

IEU_FRM_PVT_W is a wrapper package in the Oracle E-Business Suite (EBS) release 12.1.1 and 12.2.2, owned by the APPS schema and defined with AUTHID CURRENT_USER. It sits within the Interaction and Universal Work Queue (UWQ) framework, which underpins the telephony, interaction center, and agent-facing components of Oracle Service and Oracle Telephony. Its purpose is to expose a small set of callable procedures that bridge the PL/SQL package body IEU_FRM_PVT to the Java and JTF (Java Technology Foundation) client tiers, and to adapt strongly typed PL/SQL collection records to a transportable set of flat JTF_VARCHAR2_TABLE_4000 index-by tables. This pattern is commonly referred to as a "Rosetta" or parameter-translation wrapper, enabling heterogeneous runtimes (typically Java agent console code) to invoke EBS business logic without direct knowledge of PL/SQL record structures.

Key Procedures and Functions

The package exposes four documented procedures, two of which perform bidirectional data marshalling and two of which serve as action dispatch entry points:

• ROSETTA_TABLE_COPY_IN_P1 — Converts inbound flat character tables (a0, a1, a2) into the strongly typed IEU_FRM_PVT.T_IEU_MEDIA_DATA collection used internally by the media-serving logic. This is the ingress side of the marshalling contract.
• ROSETTA_TABLE_COPY_OUT_P1 — Performs the reverse transformation, decomposing an IEU_FRM_PVT.T_IEU_MEDIA_DATA instance back into the three out-bound JTF_VARCHAR2_TABLE_4000 parameters. This is the egress side.
• UWQ_GET_MEDIA_FUNC — A media retrieval entry point invoked with an application procedure name and inbound media tables. It returns an action type, an action name, and an action parameter, allowing the caller (typically a Java agent console) to resolve the next media-handling operation for the current interaction.
• UWQ_GET_ACTION_FUNC — A broader action-resolution entry point. In addition to action type, name, and parameter, it returns message name, message parameter, dialog style, and message application short name, enabling the caller to construct a fully localized, styled user prompt or dialog in response to the requested action.

Tables Accessed

The only documented table reference is PLITBLM, accessed via an APPS synonym. PLITBLM is a standard Oracle EBS message and translation storage table; in the IEU/UWQ context it is used to resolve translatable message text and ML strings required for the dialog and message outputs produced by UWQ_GET_ACTION_FUNC. The package does not directly own transactional media tables — media persistence is delegated to IEU_FRM_PVT and its underlying schema objects.

Usage Notes

IEU_FRM_PVT_W is not intended for direct invocation from Forms or concurrent programs. Its canonical callers are Java-based interaction-center agent consoles and related JTF clients that need to invoke IEU media and action logic across the PL/SQL/Java boundary. The wrapper is registered with ETRM as an API classification of OTHER, and no other APPS packages are documented as referencing it, indicating it is a leaf-level integration shim. Because it is AUTHID CURRENT_USER, effective privileges are those of the invoking session, not the definer; callers must therefore be granted execute on the package and appropriate privileges on any underlying objects. Any customization that calls these procedures should preserve the documented table-parameter ordering and must not alter the signature, since the Java descriptor mapping assumes the exact parameter layout shown in the header.