APPS.IEM_UTILS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 41

   select email_account_id, account_name, email_user, domain bulk collect into l_account_id_tbl, l_account_name_tbl, l_email_user_tbl, l_domain_tbl from iem_email_accounts
   where upper(email_user)<>upper('intent') and upper(email_user)<>upper('acknowledgements') order by upper(email_user) ||'@'||upper(domain) asc;

Line: 62

	ROLLBACK TO update_item_PVT;

Line: 69

	ROLLBACK TO update_item_PVT;

Line: 76

	ROLLBACK TO update_item_PVT;

Line: 102

cursor c1 is select distinct resource_id from iem_rt_proc_emails
where resource_id>0;

Line: 105

cursor c_new is select ih_media_item_id from iem_rt_proc_emails
where resource_id=l_agent_id and mail_item_status in ('A','N','T');

Line: 107

cursor c_read is select ih_media_item_id from iem_rt_proc_emails
where resource_id=l_agent_id and mail_item_status in ('R','S');

Line: 124

SAVEPOINT select_mail_count_pvt;

Line: 133

	select max(start_date_time) into l_time
	from jtf_ih_media_item_lc_segs
	where media_id=v2.ih_media_item_id;

Line: 142

	select max(start_date_time) into l_time
	from jtf_ih_media_item_lc_segs
	where media_id=v3.ih_media_item_id;

Line: 159

	select max(start_date_time) into l_time
	from jtf_ih_media_item_lc_segs
	where media_id=v2.ih_media_item_id;

Line: 168

	select max(start_date_time) into l_time
	from jtf_ih_media_item_lc_segs
	where media_id=v3.ih_media_item_id;

Line: 181

	ROLLBACK TO select_mail_count_PVT;

Line: 188

	ROLLBACK TO select_mail_count_PVT;

Line: 195

	ROLLBACK TO select_mail_count_PVT;

Line: 230

cursor c1 is select distinct resource_id from iem_rt_proc_emails
where resource_id>0;

Line: 241

SAVEPOINT select_mail_count_pvt;

Line: 254

 	SELECT count(*)
	into l_new_count_1
 	FROM iem_rt_proc_emails a
	WHERE resource_id=v1.resource_id
	and a.ih_media_item_id in
	(select  media_id from jtf_ih_media_item_lc_segs
	WHERE milcs_type_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))
	AND resource_id=v1.resource_id and (sysdate-start_date_time)*24>=p_duration);

Line: 269

 	SELECT count(*)
	into l_new_count_1
 	FROM iem_rt_proc_emails
	WHERE resource_id=p_resource_id
	and ih_media_item_id in
	(select distinct media_id from jtf_ih_media_item_lc_segs
	where milcs_type_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))
	and resource_id=p_resource_id and (sysdate-start_date_time)*24>=p_duration);

Line: 282

	ROLLBACK TO select_mail_count_PVT;

Line: 289

	ROLLBACK TO select_mail_count_PVT;

Line: 296

	ROLLBACK TO select_mail_count_PVT;