APPS.IEM_UTILS_PUB dependencies on IEM_RT_PROC_EMAILS

Line 102: cursor c1 is select distinct resource_id from iem_rt_proc_emails

98: x_email_count out NOCOPY email_status_count_tbl,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2) IS
102: cursor c1 is select distinct resource_id from iem_rt_proc_emails
103: where resource_id>0;
104: l_agent_id number;
105: cursor c_new is select ih_media_item_id from iem_rt_proc_emails
106: where resource_id=l_agent_id and mail_item_status in ('A','N','T');

Line 105: cursor c_new is select ih_media_item_id from iem_rt_proc_emails

101: x_msg_data OUT NOCOPY VARCHAR2) IS
102: cursor c1 is select distinct resource_id from iem_rt_proc_emails
103: where resource_id>0;
104: l_agent_id number;
105: cursor c_new is select ih_media_item_id from iem_rt_proc_emails
106: where resource_id=l_agent_id and mail_item_status in ('A','N','T');
107: cursor c_read is select ih_media_item_id from iem_rt_proc_emails
108: where resource_id=l_agent_id and mail_item_status in ('R','S');
109: l_counter number;

Line 107: cursor c_read is select ih_media_item_id from iem_rt_proc_emails

103: where resource_id>0;
104: l_agent_id number;
105: cursor c_new is select ih_media_item_id from iem_rt_proc_emails
106: where resource_id=l_agent_id and mail_item_status in ('A','N','T');
107: cursor c_read is select ih_media_item_id from iem_rt_proc_emails
108: where resource_id=l_agent_id and mail_item_status in ('R','S');
109: l_counter number;
110: l_new_count number;
111: l_read_count number;

Line 230: cursor c1 is select distinct resource_id from iem_rt_proc_emails

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.
234: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 256: FROM iem_rt_proc_emails a

252: IF p_resource_id=0 THEN
253: FOR v1 in c1 loop
254: SELECT count(*)
255: into l_new_count_1
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)))

Line 271: FROM iem_rt_proc_emails

267: END LOOP;
268: ELSE
269: SELECT count(*)
270: into l_new_count_1
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)))