APPS.BIX_REAL_TIME_BINS_PKG dependencies on BIX_DM_BIN

Line 41: delete from bix_dm_bin

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
43: and bin_code = 'BIX_QUEUE_STATUS';
44:
45: /* for all calls in queue */

Line 67: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4, col6)

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,
69: rec.calls_waiting,l_timestring);
70: end loop; /* end for all calls in queue */
71:

Line 102: delete from bix_dm_bin

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
104: and bin_code = 'BIX_AGENT_STATUS';
105:
106: /* get available agents */

Line 168: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)

164: idle := loggedin - talk - available - wrap;
165:
166:
167: /* insert the agent data into table for reporting */
168: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
169: values ('BIX_AGENT_STATUS', g_session_id, '2', 'Available', available);
170:
171: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
172: values ('BIX_AGENT_STATUS', g_session_id, '3', 'Talk', talk);

Line 171: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)

167: /* insert the agent data into table for reporting */
168: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
169: values ('BIX_AGENT_STATUS', g_session_id, '2', 'Available', available);
170:
171: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
172: values ('BIX_AGENT_STATUS', g_session_id, '3', 'Talk', talk);
173:
174: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
175: values ('BIX_AGENT_STATUS', g_session_id, '4', 'Wrap', wrap);

Line 174: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)

170:
171: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
172: values ('BIX_AGENT_STATUS', g_session_id, '3', 'Talk', talk);
173:
174: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
175: values ('BIX_AGENT_STATUS', g_session_id, '4', 'Wrap', wrap);
176:
177: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
178: values ('BIX_AGENT_STATUS', g_session_id, '5', 'Out', out);

Line 177: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)

173:
174: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
175: values ('BIX_AGENT_STATUS', g_session_id, '4', 'Wrap', wrap);
176:
177: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
178: values ('BIX_AGENT_STATUS', g_session_id, '5', 'Out', out);
179:
180: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
181: values ('BIX_AGENT_STATUS', g_session_id, '1', 'Idle', idle);

Line 180: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)

176:
177: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
178: values ('BIX_AGENT_STATUS', g_session_id, '5', 'Out', out);
179:
180: insert into bix_dm_bin (bin_code, session_id, col1, col2, col4)
181: values ('BIX_AGENT_STATUS', g_session_id, '1', 'Idle', idle);
182:
183: END populate_agent_status_bin;
184: