APPS.IEM_UTILS_PUB dependencies on JTF_NUMBER_TABLE

Line 16: l_account_id_tbl jtf_number_table:=jtf_number_table();

12: x_msg_data OUT NOCOPY VARCHAR2)
13: is
14: l_api_name VARCHAR2(255):='show_all_accounts';
15: l_api_version_number NUMBER:=1.0;
16: l_account_id_tbl jtf_number_table:=jtf_number_table();
17: l_account_name_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100();
18: l_email_user_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100();
19: l_domain_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100();
20: l_index number:=1;

Line 229: i_tbl jtf_number_table:=jtf_number_table();

225: l_api_name varchar2(50):='Get_Mailcount_by_MILCS';
226: l_api_version_number number:=1.0;
227: l_resource_id number;
228: l_milcs_id number;
229: i_tbl jtf_number_table:=jtf_number_table();
230: cursor c1 is select distinct resource_id from iem_rt_proc_emails
231: where resource_id>0;
232: BEGIN
233: -- Standard call to check for call compatibility.

Line 260: WHERE milcs_type_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))

256: FROM iem_rt_proc_emails a
257: WHERE resource_id=v1.resource_id
258: and a.ih_media_item_id in
259: (select media_id from jtf_ih_media_item_lc_segs
260: WHERE milcs_type_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))
261: AND resource_id=v1.resource_id and (sysdate-start_date_time)*24>=p_duration);
262: IF l_new_count_1>0 THEN
263: x_email_count(l_counter).resource_id:=v1.resource_id;
264: x_email_count(l_counter).count:=l_new_count_1;

Line 275: where milcs_type_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))

271: FROM iem_rt_proc_emails
272: WHERE resource_id=p_resource_id
273: and ih_media_item_id in
274: (select distinct media_id from jtf_ih_media_item_lc_segs
275: where milcs_type_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))
276: and resource_id=p_resource_id and (sysdate-start_date_time)*24>=p_duration);
277: x_email_count(l_counter).resource_id:=p_resource_id;
278: x_email_count(l_counter).count:=l_new_count_1;
279: END IF;