APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 144: l_acct_type iem_mstemail_accounts.account_type%type;

140: l_to_address varchar2(200);
141: l_redirect_flag varchar2(1):='N';
142: l_intent_flg number(15,0);
143: l_rule_id number;
144: l_acct_type iem_mstemail_accounts.account_type%type;
145: cursor c_item is select ib.item_id,ib.item_name,ib.last_update_date
146: from amv_c_chl_item_match cim,jtf_amv_items_vl ib
147: where cim.channel_category_id = l_cm_cat_id
148: and cim.channel_id is null

Line 164: l_email_user_name iem_mstemail_accounts.user_name%type;

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

Line 165: l_email_address iem_mstemail_accounts.user_name%type;

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;
168: l_cust_contact_id number;
169: STOP_AUTO_PROCESSING EXCEPTION;

Line 205: from iem_mstemail_accounts

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
206: where email_account_id=l_post_rec.email_account_id;
207: l_email_domain_name:=substr(l_email_address,instr(l_email_address,'@',1)+1,length(l_email_address));
208: -- Do Intent Processing if Enabled for Intent
209: IF l_intent_flg>0 THEN -- intent is enabled for the account

Line 3522: from IEM_MSTEMAIL_ACCOUNTS

3518: l_reply_address iem_email_accounts.reply_to_address%type;
3519: begin
3520: select from_name,reply_to_address
3521: INTO l_from_name,l_reply_address
3522: from IEM_MSTEMAIL_ACCOUNTS
3523: where email_account_id=p_email_account_id;
3524: l_index:=instr(p_mailer,'<',1,1);
3525: IF l_index>0 then
3526: l_sender_name:=substr(p_mailer,1,l_index-1);

Line 3634: FROM IEM_MSTEMAIL_ACCOUNTS

3630: begin
3631: l_theme_status:='S';
3632: select kem_flag,account_language
3633: INTO l_theme_code,l_lang
3634: FROM IEM_MSTEMAIL_ACCOUNTS
3635: WHERE EMAIL_ACCOUNT_ID=l_email_account_id;
3636: l_theme_buf.delete;
3637: l_token_buf.delete;
3638: IF l_theme_code=1 then -- Theme processing

Line 3895: from iem_mstemail_accounts

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
3895: from iem_mstemail_accounts
3896: where email_account_id=l_mail_rec.email_account_id;
3897: l_email_domain_name:=substr(l_email_address,instr(l_email_address,'@',1)+1,length(l_email_address));
3898: l_from1:=instr(l_header_rec.from_str,'<',1,1);
3899: l_from2:=instr(l_header_rec.from_str,'>',1,1);