DBA Data[Home] [Help]

APPS.IEM_SPV_MONITORING_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 32: l_account_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;

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() ;
36: l_class_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;

Line 36: l_class_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;

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:
40: BEGIN

Line 238: l_resource_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;

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() ;
242: l_account_id_tbl jtf_number_table:=jtf_number_table() ;

Line 243: l_account_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:
247: BEGIN