27: l_string varchar2(32767):='';
28: Type email_activity_rec is REF CURSOR ;
29: email_activity_cur email_activity_rec;
30:
31: l_email_account_id_tbl jtf_number_table:=jtf_number_table() ;
32: l_account_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
33: l_queue_count_tbl jtf_number_table:=jtf_number_table() ;
34: l_wait_time_tbl jtf_number_table:=jtf_number_table() ;
35: l_class_id_tbl jtf_number_table:=jtf_number_table() ;
29: email_activity_cur email_activity_rec;
30:
31: l_email_account_id_tbl jtf_number_table:=jtf_number_table() ;
32: l_account_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
33: l_queue_count_tbl jtf_number_table:=jtf_number_table() ;
34: l_wait_time_tbl jtf_number_table:=jtf_number_table() ;
35: l_class_id_tbl jtf_number_table:=jtf_number_table() ;
36: l_class_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
37:
30:
31: l_email_account_id_tbl jtf_number_table:=jtf_number_table() ;
32: l_account_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
33: l_queue_count_tbl jtf_number_table:=jtf_number_table() ;
34: l_wait_time_tbl jtf_number_table:=jtf_number_table() ;
35: l_class_id_tbl jtf_number_table:=jtf_number_table() ;
36: l_class_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
37:
38: l_current_user NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
31: l_email_account_id_tbl jtf_number_table:=jtf_number_table() ;
32: l_account_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
33: l_queue_count_tbl jtf_number_table:=jtf_number_table() ;
34: l_wait_time_tbl jtf_number_table:=jtf_number_table() ;
35: l_class_id_tbl jtf_number_table:=jtf_number_table() ;
36: l_class_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
37:
38: l_current_user NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
39:
233: l_where_clause varchar2(32767):='';
234: Type agent_activity_rec is REF CURSOR ;
235: agent_activity_cur agent_activity_rec;
236:
237: l_resource_id_tbl jtf_number_table:=jtf_number_table() ;
238: l_resource_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
239: l_email_count_tbl jtf_number_table:=jtf_number_table() ;
240: l_average_age_tbl jtf_number_table:=jtf_number_table() ;
241: l_oldest_age_tbl jtf_number_table:=jtf_number_table() ;
235: agent_activity_cur agent_activity_rec;
236:
237: l_resource_id_tbl jtf_number_table:=jtf_number_table() ;
238: l_resource_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
239: l_email_count_tbl jtf_number_table:=jtf_number_table() ;
240: l_average_age_tbl jtf_number_table:=jtf_number_table() ;
241: l_oldest_age_tbl jtf_number_table:=jtf_number_table() ;
242: l_account_id_tbl jtf_number_table:=jtf_number_table() ;
243: l_account_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
236:
237: l_resource_id_tbl jtf_number_table:=jtf_number_table() ;
238: l_resource_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
239: l_email_count_tbl jtf_number_table:=jtf_number_table() ;
240: l_average_age_tbl jtf_number_table:=jtf_number_table() ;
241: l_oldest_age_tbl jtf_number_table:=jtf_number_table() ;
242: l_account_id_tbl jtf_number_table:=jtf_number_table() ;
243: l_account_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
244:
237: l_resource_id_tbl jtf_number_table:=jtf_number_table() ;
238: l_resource_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
239: l_email_count_tbl jtf_number_table:=jtf_number_table() ;
240: l_average_age_tbl jtf_number_table:=jtf_number_table() ;
241: l_oldest_age_tbl jtf_number_table:=jtf_number_table() ;
242: l_account_id_tbl jtf_number_table:=jtf_number_table() ;
243: l_account_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
244:
245: l_current_user NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
238: l_resource_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
239: l_email_count_tbl jtf_number_table:=jtf_number_table() ;
240: l_average_age_tbl jtf_number_table:=jtf_number_table() ;
241: l_oldest_age_tbl jtf_number_table:=jtf_number_table() ;
242: l_account_id_tbl jtf_number_table:=jtf_number_table() ;
243: l_account_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
244:
245: l_current_user NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
246: