DBA Data[Home] [Help]

APPS.IEM_SPV_MONITORING_PVT dependencies on JTF_NUMBER_TABLE

Line 31: l_email_account_id_tbl jtf_number_table:=jtf_number_table() ;

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() ;

Line 33: l_queue_count_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:

Line 34: l_wait_time_tbl jtf_number_table:=jtf_number_table() ;

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')) ;

Line 35: l_class_id_tbl jtf_number_table:=jtf_number_table() ;

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:

Line 237: l_resource_id_tbl jtf_number_table:=jtf_number_table() ;

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() ;

Line 239: l_email_count_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() ;

Line 240: l_average_age_tbl jtf_number_table:=jtf_number_table() ;

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:

Line 241: l_oldest_age_tbl jtf_number_table:=jtf_number_table() ;

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')) ;

Line 242: l_account_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')) ;
246: