[Home] [Help]
189: and a.intent_id=b.classification_id
190: order by b.score desc;
191:
192: l_intent_str varchar2(700);
193: l_header_rec iem_ms_base_headers%rowtype;
194: l_email_user_name iem_mstemail_accounts.user_name%type;
195: l_email_address iem_mstemail_accounts.user_name%type;
196: l_email_domain_name varchar2(300);
197: l_auto_msgstatus varchar2(10); -- will store msg status for autoreply/autoxredirect;
237: raise NO_RECORD_TO_PROCESS ;
238: END IF;
239: l_message_id:=l_post_rec.message_id;
240: select * into l_header_Rec
241: from iem_ms_base_headers
242: where message_id=l_message_id;
243: select user_name,kem_flag,email_address,account_type
244: into l_email_user_name,l_intent_flg,l_email_address,l_acct_type
245: from iem_mstemail_accounts
4357: l_dflt_sender varchar2(250);
4358: l_sender varchar2(256);
4359: l_from1 number;
4360: l_from2 number;
4361: l_header_rec iem_ms_base_headers%rowtype;
4362: l_notification_id number;
4363: BEGIN
4364: select * into l_header_rec from iem_ms_base_headers
4365: where message_id=p_post_rec.message_id;
4360: l_from2 number;
4361: l_header_rec iem_ms_base_headers%rowtype;
4362: l_notification_id number;
4363: BEGIN
4364: select * into l_header_rec from iem_ms_base_headers
4365: where message_id=p_post_rec.message_id;
4366: l_from1:=instr(l_header_rec.from_str,'<',1,1);
4367: l_from2:=instr(l_header_rec.from_str,'>',1,1);
4368: IF l_from1>0 then -- From Address Contains Both Name and Address
4879: x_return_status OUT NOCOPY VARCHAR2,
4880: x_msg_count OUT NOCOPY NUMBER,
4881: x_msg_data OUT NOCOPY VARCHAR2) IS
4882:
4883: l_header_rec iem_ms_base_headers%rowtype;
4884: l_mail_rec iem_rt_proc_emails%rowtype;
4885: l_class_val_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
4886: l_counter number;
4887: l_message_id number;
4981: raise abort_reprocessing;
4982: END;
4983:
4984: select * into l_header_Rec
4985: from iem_ms_base_headers
4986: where message_id=l_mail_Rec.message_id;
4987:
4988: select user_name,email_address
4989: into l_email_user_name,l_email_address