APPS.BIX_QUEUE_DETAIL_REPORT dependencies on JTFB_DCF

Line 282: v_parent := jtfb_dcf.get_parameter_value(p_context, 'pContext');

278: g_drilldown := 0; /* drilldown default to yes */
279: g_session_id := bix_util_pkg.get_icx_session_id; /* get current session id */
280: BIX_DM_REAL_QUEUE_SUMMARY_PKG.get_calls(g_session_id);
281: /* get the classification id for the clicked row or data */
282: v_parent := jtfb_dcf.get_parameter_value(p_context, 'pContext');
283: /* to make the report listing link work */
284: if (v_parent = 'BIX_QUEUE_DETAIL_REPORT') then
285: v_parent := 'NOT_FOUND';
286: end if;

Line 307: if (jtfb_dcf.get_parameter_value(p_context,'P_CLASSIFICATION_ID') = 'NOT_FOUND') THEN

303: IF g_time_range IS NULL THEN
304: g_time_range := 1;
305: END IF;
306: /* retrieve the values for report user parameters */
307: if (jtfb_dcf.get_parameter_value(p_context,'P_CLASSIFICATION_ID') = 'NOT_FOUND') THEN
308: v_classification_id := -999;
309: else
310: v_classification_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));
311: end if;

Line 310: v_classification_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));

306: /* retrieve the values for report user parameters */
307: if (jtfb_dcf.get_parameter_value(p_context,'P_CLASSIFICATION_ID') = 'NOT_FOUND') THEN
308: v_classification_id := -999;
309: else
310: v_classification_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));
311: end if;
312: if (jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID') = 'NOT_FOUND') THEN
313: v_site_id := -999;
314: else

Line 312: if (jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID') = 'NOT_FOUND') THEN

308: v_classification_id := -999;
309: else
310: v_classification_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));
311: end if;
312: if (jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID') = 'NOT_FOUND') THEN
313: v_site_id := -999;
314: else
315: v_site_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID'));
316: end if;

Line 315: v_site_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID'));

311: end if;
312: if (jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID') = 'NOT_FOUND') THEN
313: v_site_id := -999;
314: else
315: v_site_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID'));
316: end if;
317:
318: /* initialize data date range for today */
319: v_start_period := trunc(sysdate);