APPS.BIX_REAL_TIME_BINS_PKG dependencies on BIX_UTIL_PKG

Line 38: g_session_id := bix_util_pkg.get_icx_session_id;

34: l_date_low := trunc(sysdate);
35: l_date_high := sysdate;
36:
37: /* get the session identifier for the web session */
38: g_session_id := bix_util_pkg.get_icx_session_id;
39:
40: /* delete data from previous runs */
41: delete from bix_dm_bin
42: where session_id = g_session_id

Line 64: l_timestring := bix_util_pkg.get_hrmiss_frmt(rec.avg_queue_time);

60: else
61: l_classification_id := -999;
62: end if;
63:
64: l_timestring := bix_util_pkg.get_hrmiss_frmt(rec.avg_queue_time);
65:
66: /* insert the calls in queue in table for the reporting */
67: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4, col6)
68: Values ('BIX_QUEUE_STATUS',g_session_id, l_classification_id, rec.classification,

Line 99: g_session_id := bix_util_pkg.get_icx_session_id;

95: l_date_low := trunc(sysdate);
96: l_date_high := sysdate;
97:
98: /* get session identifier for the web session calling this procedure */
99: g_session_id := bix_util_pkg.get_icx_session_id;
100:
101: /* delete data from pervious runs */
102: delete from bix_dm_bin
103: where session_id = g_session_id