Search Results bix_dm_real_queue_summary_pkg

Overview

BIX_DM_REAL_QUEUE_SUMMARY_PKG is an Oracle E-Business Suite package owned by the APPS schema and classified under the API classification "OTHER" in the ETRM repository. It forms part of the Oracle Business Intelligence (BIX) and Interaction Center (IHC/JTF) subsystem, specifically the component concerned with summarizing real-time interaction queue activity. The package is defined with AUTHID CURRENT_USER, meaning that its unqualified references to database objects resolve under the privileges and schema of the invoking user rather than the defining schema, a common convention for packages intended to be called from multiple application contexts within EBS.

The header comment carries the revision marker $Header: bixxrqss.pls 115.2 2003/01/10 00:14:20 achanda noship $, indicating the source file was last modified in January 2003. This places the object in the earlier generation of EBS code base artifacts and explains its availability across 12.1.1 and 12.2.2, where such legacy PL/SQL units are carried forward largely unchanged.

Key Procedures and Functions

The package exposes a single documented procedure:

• GET_CALLS — The sole entry point in the package specification. It accepts a session identifier parameter (documented as p_session_id IN NUMBER) that scopes the operation to a single interaction session. Its purpose is to generate or refresh the real-time queue summary records for the calls associated with that session, drawing on goal definitions, classification data, and interactive media item metadata. Because the procedure returns no value and is declared in the package body only through the specification, it is intended to be invoked for its side effects — namely, populating or updating summary data used by downstream reporting and queue monitoring.

No other procedures or functions are documented in the package specification, and the metadata records one documented callable in total.

Tables Accessed

The package reads from and writes to the following tables, referenced through APPS synonyms:

• BIX_DM_GOALS — Stores goal definitions used by the BIX data mining and summarization layer; accessed to determine the targets against which real-time queue performance is evaluated.
• BIX_DM_REAL_QUEUE_SUM — The summary table that holds aggregated real-time queue statistics; this is the principal destination for the data produced by GET_CALLS.
• CCT_CLASSIFICATIONS — Classification definitions used to categorize interactions, supporting the grouping performed in the summary.
• JTF_IH_MEDIA_ITEMS — Interaction Center media item master data describing the communication channels (for example, telephony or email) involved in the session.
• JTF_IH_MEDIA_ITEM_LC_SEGS — Localized segment attributes for media items, supplying language-specific descriptive values.
• JTF_IH_MEDIA_ITM_LC_SEG_TYS — The type definitions that govern those localized media item segments.

Usage Notes

BIX_DM_REAL_QUEUE_SUMMARY_PKG is not intended for direct end-user invocation. It is typically called programmatically by other BIX or Interaction Center components during real-time queue processing, when a session's interactions must be rolled up into summary form for monitoring dashboards or analytical reporting. The metadata records that the package is referenced by one other package, confirming this internal dependency pattern.

Custom code should treat GET_CALLS as an internal integration point: callers must supply a valid session identifier and must possess the appropriate privileges on the underlying synonyms, since AUTHID CURRENT_USER defers privilege checking to the invoker. Because the object has remained stable since 2003 and carries no shipped customization hooks, extensions should be implemented in separate custom packages rather than by modifying this file.