13: SELECT icx_sec.g_session_id
14: INTO l_session_id
15: FROM dual;
16:
17: /* Delete the rows from the table bix_dm_bin for the current icx session and bin */
18: /* so that we donot display the leftover rows from the previous execution of the bin */
19: DELETE bix_dm_bin
20: WHERE bin_code = 'BIX_CALLS_TYPE_BIN'
21: AND session_id = l_session_id;
15: FROM dual;
16:
17: /* Delete the rows from the table bix_dm_bin for the current icx session and bin */
18: /* so that we donot display the leftover rows from the previous execution of the bin */
19: DELETE bix_dm_bin
20: WHERE bin_code = 'BIX_CALLS_TYPE_BIN'
21: AND session_id = l_session_id;
22:
23: /* The bin will always display data for maximum date for which data has been collected */
25: INTO l_reporting_date
26: FROM bix_dm_agent_call_sum;
27:
28: /* Fetch all the records from the summary table for l_reporting_date grouped by classification */
29: INSERT /*+ PARALLEL(tb,2) */ INTO bix_dm_bin tb (
30: session_id
31: , bin_code
32: , col1
33: , col2