APPS.BIX_DM_REAL_QUEUE_SUMMARY_PKG dependencies on BIX_DM_REAL_QUEUE_SUM

Line 1: PACKAGE BODY BIX_DM_REAL_QUEUE_SUMMARY_PKG AS

1: PACKAGE BODY BIX_DM_REAL_QUEUE_SUMMARY_PKG AS
2: /*$Header: bixxrqsb.pls 115.7 2003/01/09 20:19:48 achanda noship $ */
3:
4:
5: FUNCTION GET_CLASSIFICATION (p_classification in varchar2) return NUMBER is

Line 31: -- table BIX_DM_REAL_QUEUE_SUM:

27: WHEN OTHERS THEN
28: return NULL;
29: END;
30: -- GET_CALLS collects calls from OLTP to the temporary
31: -- table BIX_DM_REAL_QUEUE_SUM:
32:
33:
34: PROCEDURE GET_CALLS(p_session_id IN NUMBER)
35: AS

Line 184: delete from bix_dm_real_queue_sum

180:
181: BEGIN
182: l_start_date := trunc(sysdate);
183: l_end_date := sysdate;
184: delete from bix_dm_real_queue_sum
185: where session_id = p_session_id;
186:
187: FOR call in call_info LOOP
188: v_calls_offered := call.calls_offered;

Line 229: insert into BIX_DM_REAL_QUEUE_SUM

225: v_talk_time := calldata4.talk_time;
226: v_calls_handled := calldata4.calls_handled;
227: end LOOP;
228:
229: insert into BIX_DM_REAL_QUEUE_SUM
230: (
231: calls_offered,
232: calls_abandoned,
233: abandon_time,

Line 268: END BIX_DM_REAL_QUEUE_SUMMARY_PKG;

264: );
265: END LOOP;
266: COMMIT;
267: END GET_CALLS;
268: END BIX_DM_REAL_QUEUE_SUMMARY_PKG;