APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_MS_BASE_HEADERS

Line 163: l_header_rec iem_ms_base_headers%rowtype;

159: iem_intents a,iem_email_classifications b
160: where b.message_id=l_message_id
161: and a.intent_id=b.classification_id;
162: l_intent_str varchar2(700);
163: l_header_rec iem_ms_base_headers%rowtype;
164: l_email_user_name iem_mstemail_accounts.user_name%type;
165: l_email_address iem_mstemail_accounts.user_name%type;
166: l_email_domain_name varchar2(300);
167: l_auto_msgstatus varchar2(10); -- will store msg status for autoreply/autoxredirect;

Line 201: from iem_ms_base_headers

197: raise NO_RECORD_TO_PROCESS ;
198: END IF;
199: l_message_id:=l_post_rec.message_id;
200: select * into l_header_Rec
201: from iem_ms_base_headers
202: where message_id=l_message_id;
203: select user_name,kem_flag,email_address,account_type
204: into l_email_user_name,l_intent_flg,l_email_address,l_acct_type
205: from iem_mstemail_accounts

Line 3266: l_header_rec iem_ms_base_headers%rowtype;

3262: l_dflt_sender varchar2(250);
3263: l_sender varchar2(256);
3264: l_from1 number;
3265: l_from2 number;
3266: l_header_rec iem_ms_base_headers%rowtype;
3267: l_notification_id number;
3268: BEGIN
3269: select * into l_header_rec from iem_ms_base_headers
3270: where message_id=p_post_rec.message_id;

Line 3269: select * into l_header_rec from iem_ms_base_headers

3265: l_from2 number;
3266: l_header_rec iem_ms_base_headers%rowtype;
3267: l_notification_id number;
3268: BEGIN
3269: select * into l_header_rec from iem_ms_base_headers
3270: where message_id=p_post_rec.message_id;
3271: l_from1:=instr(l_header_rec.from_str,'<',1,1);
3272: l_from2:=instr(l_header_rec.from_str,'>',1,1);
3273: IF l_from1>0 then -- From Address Contains Both Name and Address

Line 3788: l_header_rec iem_ms_base_headers%rowtype;

3784: x_return_status OUT NOCOPY VARCHAR2,
3785: x_msg_count OUT NOCOPY NUMBER,
3786: x_msg_data OUT NOCOPY VARCHAR2) IS
3787:
3788: l_header_rec iem_ms_base_headers%rowtype;
3789: l_mail_rec iem_rt_proc_emails%rowtype;
3790: l_class_val_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
3791: l_counter number;
3792: l_message_id number;

Line 3890: from iem_ms_base_headers

3886: raise abort_reprocessing;
3887: END;
3888:
3889: select * into l_header_Rec
3890: from iem_ms_base_headers
3891: where message_id=l_mail_Rec.message_id;
3892:
3893: select user_name,email_address
3894: into l_email_user_name,l_email_address