APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 16: g_account_type IEM_MSTEMAIL_ACCOUNTS.ACCOUNT_TYPE%TYPE;

12:
13: --siahmed 12.1.3 advanced sr creation
14: --global variable for customer_id
15: g_customer_id NUMBER;
16: g_account_type IEM_MSTEMAIL_ACCOUNTS.ACCOUNT_TYPE%TYPE;
17: --global variable for contact_party_id and party_type
18: g_contact_party_id NUMBER;
19: g_contact_party_type VARCHAR2(100);
20: g_contact_point_id NUMBER;

Line 163: l_acct_type iem_mstemail_accounts.account_type%type;

159: l_to_address varchar2(200);
160: l_redirect_flag varchar2(1):='N';
161: l_intent_flg number(15,0);
162: l_rule_id number;
163: l_acct_type iem_mstemail_accounts.account_type%type;
164: --12.1.3 Dev Threading
165: l_thread_id number;
166: --siahmed 12.1.3 Advanced SR creation
167: l_parser_id NUMBER;

Line 194: l_email_user_name iem_mstemail_accounts.user_name%type;

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;
198: l_cust_contact_id number;

Line 195: l_email_address iem_mstemail_accounts.user_name%type;

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;
198: l_cust_contact_id number;
199: STOP_AUTO_PROCESSING EXCEPTION;

Line 245: from iem_mstemail_accounts

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
246: where email_account_id=l_post_rec.email_account_id;
247: l_email_domain_name:=substr(l_email_address,instr(l_email_address,'@',1)+1,length(l_email_address));
248:
249:

Line 4617: from IEM_MSTEMAIL_ACCOUNTS

4613: l_reply_address iem_email_accounts.reply_to_address%type;
4614: begin
4615: select from_name,reply_to_address
4616: INTO l_from_name,l_reply_address
4617: from IEM_MSTEMAIL_ACCOUNTS
4618: where email_account_id=p_email_account_id;
4619: l_index:=instr(p_mailer,'<',1,1);
4620: IF l_index>0 then
4621: l_sender_name:=substr(p_mailer,1,l_index-1);

Line 4729: FROM IEM_MSTEMAIL_ACCOUNTS

4725: begin
4726: l_theme_status:='S';
4727: select kem_flag,account_language
4728: INTO l_theme_code,l_lang
4729: FROM IEM_MSTEMAIL_ACCOUNTS
4730: WHERE EMAIL_ACCOUNT_ID=l_email_account_id;
4731: l_theme_buf.delete;
4732: l_token_buf.delete;
4733: IF l_theme_code=1 then -- Theme processing

Line 4990: from iem_mstemail_accounts

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
4990: from iem_mstemail_accounts
4991: where email_account_id=l_mail_rec.email_account_id;
4992: l_email_domain_name:=substr(l_email_address,instr(l_email_address,'@',1)+1,length(l_email_address));
4993: l_from1:=instr(l_header_rec.from_str,'<',1,1);
4994: l_from2:=instr(l_header_rec.from_str,'>',1,1);