[Home] [Help]
1: PACKAGE BODY BIX_QUEUE_DETAIL_REPORT AS
2: /*$Header: bixxrqdb.pls 115.31 2003/01/10 00:14:25 achanda ship $*/
3:
4: g_time_range NUMBER;
5: g_session_id NUMBER;
33:
34: /* delete data from the previous runs */
35: delete bix_dm_report
36: where session_id = g_session_id
37: and report_code = 'BIX_QUEUE_DETAIL_REPORT';
38:
39: /* find how many calls have no classification */
40: select count(*)
41: into l_unclassified_count
64: , col12
65: , col14
66: , col16)
67: (SELECT
68: 'BIX_QUEUE_DETAIL_REPORT'
69: , g_session_id
70: , 'c' || to_char(v_classification_id) || 'd' || '0'
71: , v_classification
72: , l_index
98: , col12
99: , col14
100: , col16)
101: (SELECT
102: 'BIX_QUEUE_DETAIL_REPORT'
103: , g_session_id
104: , l_index
105: , null
106: , l_index
127: /* update the drilldown to contract on click */
128: /* g_drilldown = 1 implies contract */
129: update bix_dm_report
130: set col1 = 'c' || to_char(v_classification_id) || 'd' || '1'
131: where report_code = 'BIX_QUEUE_DETAIL_REPORT'
132: and session_id = g_session_id
133: and col2 = v_classification
134: and v_classification = g_classification;
135: END IF;
155: , col12
156: , col14
157: , col16)
158: (SELECT
159: 'BIX_QUEUE_DETAIL_REPORT'
160: , g_session_id
161: , 'c' || to_char(-9999) || 'd' || '0'
162: -- ,g_null_desc
163: ,'unClassified'
193: , col12
194: , col14
195: , col16)
196: (SELECT
197: 'BIX_QUEUE_DETAIL_REPORT'
198: , g_session_id
199: , l_index
200: , null
201: , l_index
223: /* update the drilldown to contract on click */
224: /* g_drilldown = 1 implies contract */
225: update bix_dm_report
226: set col1 = 'c' || to_char(-9999) || 'd' || '1'
227: where report_code = 'BIX_QUEUE_DETAIL_REPORT'
228: and session_id = g_session_id
229: and col2 = g_null_desc;
230: end if; /* detailed rows for unclassified calls */
231: end if; /* data for unclassified calls */
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;
287: /* find if the classification was clicked in the report */
288: /* g_drilldown = 0 means the classification needs to be expanded, else */
340: l_message := fnd_message.get_string('BIX', 'BIX_DM_REFRESH_MSG') ;
341: l_label := l_message || ' ' ||to_char(l_date, 'DD-MON-YYYY HH12:MI:SS AM');
342: return l_label;
343: END;
344: END BIX_QUEUE_DETAIL_REPORT;