APPS.IEM_SPV_MONITORING_PVT dependencies on IEM_AGENTS

Line 61: from iem_mstemail_accounts a, iem_agents b, jtf_rs_resource_extns c

57: -- Initialize API return status to SUCCESS
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60: select a.email_account_id, a.from_name bulk collect into l_email_account_id_tbl, l_account_name_tbl
61: from iem_mstemail_accounts a, iem_agents b, jtf_rs_resource_extns c
62: where a.email_account_id=b.email_account_id and b.resource_id = c.resource_id and c.user_id = l_current_user
63: order by UPPER(a.from_name);
64:
65:

Line 83: select count(*) into l_agent_acct_count from iem_agents where email_account_id=l_email_account_id_tbl(l_index);

79: FROM iem_rt_proc_emails a, iem_rt_media_items b
80: WHERE a.resource_id <> 0 and a.message_id=b.message_id and b.expire='N' and
81: a.email_account_id=l_email_account_id_tbl(l_index);
82:
83: select count(*) into l_agent_acct_count from iem_agents where email_account_id=l_email_account_id_tbl(l_index);
84:
85: select count(*) into l_total_count from iem_rt_proc_emails where email_account_id=l_email_account_id_tbl(l_index);
86:
87: x_email_activity_tbl(l_monitor_index).email_account_id:=l_email_account_id_tbl(l_index);

Line 280: and res.resource_id in (select resource_id from iem_agents)

276: and rel.role_resource_type = 'RS_INDIVIDUAL'
277: -- and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
278: -- and trunc(nvl(rel.end_date_active, sysdate))
279: )
280: and res.resource_id in (select resource_id from iem_agents)
281: and (upper(res.source_last_name) like upper(p_resource_name) or upper(res.source_first_name) like upper(p_resource_name)
282: or upper(res.user_name) like upper(p_resource_name))
283: order by resource_name;
284: else

Line 296: and res.resource_id in (select resource_id from iem_agents)

292: and rel.role_resource_type = 'RS_INDIVIDUAL'
293: -- and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
294: -- and trunc(nvl(rel.end_date_active, sysdate))
295: )
296: and res.resource_id in (select resource_id from iem_agents)
297: order by resource_name;
298: end if;
299: else
300: /* if p_resource_role = 2 then

Line 323: and res.resource_id in (select resource_id from iem_agents)

319: rel.role_id in (28, 29, 30) and rel.delete_flag = 'N'
320: and rel.role_resource_type = 'RS_INDIVIDUAL'
321: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
322: and trunc(nvl(rel.end_date_active, sysdate)) )
323: and res.resource_id in (select resource_id from iem_agents)
324: and (upper(res.source_last_name) like upper(p_resource_name) or upper(res.source_first_name) like upper(p_resource_name)
325: or upper(res.user_name) like upper(p_resource_name))
326: order by resource_name;
327: else

Line 338: and res.resource_id in (select resource_id from iem_agents)

334: rel.role_id in (28, 29, 30) and rel.delete_flag = 'N'
335: and rel.role_resource_type = 'RS_INDIVIDUAL'
336: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
337: and trunc(nvl(rel.end_date_active, sysdate)) )
338: and res.resource_id in (select resource_id from iem_agents)
339: order by resource_name;
340: end if;
341: end if; -- if p_resource_role = 0
342:

Line 355: (select a.email_account_id from iem_agents a, jtf_rs_resource_extns b

351: select Count(*) Total into l_assigned_email_count
352: FROM iem_rt_proc_emails a, iem_rt_media_items b
353: WHERE a.message_id=b.message_id and b.expire='N'
354: and a.resource_id = l_resource_id_tbl(l_index) and a.email_account_id in
355: (select a.email_account_id from iem_agents a, jtf_rs_resource_extns b
356: where a.resource_id = b.resource_id and b.user_id=l_current_user);
357:
358: select Count(*) Total into l_requeue_all_count
359: FROM iem_rt_proc_emails a, iem_rt_media_items b

Line 362: (select email_account_id from iem_agents c, jtf_rs_resource_extns d

358: select Count(*) Total into l_requeue_all_count
359: FROM iem_rt_proc_emails a, iem_rt_media_items b
360: WHERE a.message_id=b.message_id and b.expire='N'
361: and a.resource_id = l_resource_id_tbl(l_index) and a.email_account_id in
362: (select email_account_id from iem_agents c, jtf_rs_resource_extns d
363: where c.resource_id=d.resource_id and d.user_id=l_current_user);
364:
365: select count(*) into l_agent_acct_count from iem_agents where resource_id=l_resource_id_tbl(l_index);
366:

Line 365: select count(*) into l_agent_acct_count from iem_agents where resource_id=l_resource_id_tbl(l_index);

361: and a.resource_id = l_resource_id_tbl(l_index) and a.email_account_id in
362: (select email_account_id from iem_agents c, jtf_rs_resource_extns d
363: where c.resource_id=d.resource_id and d.user_id=l_current_user);
364:
365: select count(*) into l_agent_acct_count from iem_agents where resource_id=l_resource_id_tbl(l_index);
366:
367: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
368: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id_tbl(l_index);
369:

Line 389: from iem_mstemail_accounts a, iem_agents b

385:
386: l_monitor_index := l_monitor_index + 1;
387:
388: select a.email_account_id, a.from_name bulk collect into l_account_id_tbl, l_account_name_tbl
389: from iem_mstemail_accounts a, iem_agents b
390: where a.email_account_id=b.email_account_id and b.resource_id=l_resource_id_tbl(l_index)
391: order by UPPER(a.from_name);
392:
393: for i in l_account_id_tbl.FIRST..l_account_id_tbl.LAST LOOP

Line 402: select count(*) into l_email_count_flag from iem_agents a, jtf_rs_resource_extns b

398: WHERE a.message_id=b.message_id and b.expire='N'
399: and a.resource_id = l_resource_id_tbl(l_index)
400: and a.email_account_id=l_account_id_tbl(i);
401:
402: select count(*) into l_email_count_flag from iem_agents a, jtf_rs_resource_extns b
403: where a.email_account_id=l_account_id_tbl(i)
404: and a.resource_id = b.resource_id and b.user_id=l_current_user;
405:
406: if (l_email_count_flag = 0) then