APPS.IEM_MAILPREPROCWF_PUB SQL Statements

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

Line: 166

	select email_account_id into l_email_account_id from
	iem_rt_preproc_emails where message_id=l_msgid;

Line: 348

	select to_str,cc_str,from_str,reply_to_str,subject,message_size into
	l_to_recip,l_cc_recip,l_frm_str,l_reply_to,l_subject,l_msg_size
	from iem_ms_base_headers
	where message_id=l_msgid;

Line: 871

procedure IEM_WF_DELETEMSG(
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out nocopy  varchar2)
is
l_msg_id		number;

Line: 880

l_proc_name	varchar2(30):='IEM_WF_DELETEMSG';

Line: 899

end IEM_WF_DELETEMSG ;