APPS.IEM_MAILITEM_PUB dependencies on JTF_NUMBER_TABLE

Line 16: i_tbl jtf_number_table:=jtf_number_table();

12: x_msg_data OUT NOCOPY VARCHAR2)
13:
14: IS
15: l_tbl t_number_table:=t_number_table();
16: i_tbl jtf_number_table:=jtf_number_table();
17: CURSOR c1 IS
18: SELECT a.EMAIL_ACCOUNT_ID,a.RT_CLASSIFICATION_ID,
19: b.USER_NAME,c.name,count(*) Total,
20: nvl(max(sysdate-a.received_date)*24*60,0) wait_time

Line 28: AND a.group_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))

24: and a.email_account_id=b.email_account_id
25: and a.rt_classification_id=c.route_classification_id
26: AND a.email_account_id=d.email_account_id
27: AND d.resource_id=p_resource_id
28: AND a.group_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))
29: and a.message_id not in (select message_id from iem_reroute_hists where agent_id=p_resource_id)
30: GROUP by a.email_account_id,a.rt_classification_id,b.USER_NAME,c.name;
31: CURSOR c_11 IS
32: SELECT a.EMAIL_ACCOUNT_ID,a.RT_CLASSIFICATION_ID,

Line 237: i_tbl jtf_number_table:=jtf_number_table();

233: x_msg_data OUT NOCOPY VARCHAR2)
234:
235: IS
236: l_tbl t_number_table:=t_number_table();
237: i_tbl jtf_number_table:=jtf_number_table();
238: CURSOR c1 IS
239: SELECT a.RT_CLASSIFICATION_ID,b.name,COUNT(*) TOTAL
240: FROM iem_rt_proc_emails a,iem_route_classifications b
241: where a.email_account_id=p_email_account_id

Line 244: AND a.group_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))

240: FROM iem_rt_proc_emails a,iem_route_classifications b
241: where a.email_account_id=p_email_account_id
242: and a.resource_id =0
243: and a.rt_classification_id=b.route_classification_id
244: AND a.group_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))
245: GROUP by a.rt_classification_id,b.name;
246: l_index number:=1;
247: l_api_version_number number:=1.0;
248: l_api_name varchar2(30):='GetMailItemCount';

Line 465: i_tbl jtf_number_table:=jtf_number_table();

461: x_msg_data OUT NOCOPY VARCHAR2) IS
462: l_api_version_number number:=1.0;
463: l_api_name varchar2(30):='GetMailItemCount';
464: l_tbl t_number_table:=t_number_table();
465: i_tbl jtf_number_table:=jtf_number_table();
466: l_ret_status varchar2(10);
467: l_msg_count number;
468: l_msg_data varchar2(500);
469: IEM_NO_DATA EXCEPTION;

Line 517: and group_id in (select * from TABLE(cast(i_tbl as jtf_number_table)));

513: from iem_rt_proc_emails
514: where email_account_id=p_email_account_id
515: and rt_classification_id=p_classification_id
516: and resource_id=0
517: and group_id in (select * from TABLE(cast(i_tbl as jtf_number_table)));
518: IF x_count=0 THEN
519: RAISE IEM_NO_DATA;
520: END IF;
521: -- Standard Check Of p_commit.

Line 592: i_tbl jtf_number_table:=jtf_number_table();

588: l_date date;
589: l_api_version_number number:=1.0;
590: l_api_name varchar2(30):='GetMailItem';
591: l_tbl t_number_table:=t_number_table();
592: i_tbl jtf_number_table:=jtf_number_table();
593: l_ret_status varchar2(10);
594: l_where varchar2(255);
595: l_string varchar2(32000):='';
596: l_msg_count number;