APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_EMAIL_CLASSIFICATIONS

Line 97: select classification_id from iem_email_classifications

93: NO_ITEM_FOUND EXCEPTION;
94: NO_RECORD_TO_PROCESS EXCEPTION;
95: STOP_REDIRECT_PROCESSING EXCEPTION;
96: cursor c_class_id is
97: select classification_id from iem_email_classifications
98: where message_id=l_message_id
99: order by score desc;
100: l_intent_counter number;
101: l_start_search number:=0;

Line 187: iem_intents a,iem_email_classifications b

183: l_top_score number;
184:
185: -- sardas ,modified query for intent issue fix bug#13946049
186: cursor c_intent is select a.intent,b.score from
187: iem_intents a,iem_email_classifications b
188: where b.message_id=l_message_id
189: and a.intent_id=b.classification_id
190: order by b.score desc;
191:

Line 2717: delete from iem_email_classifications where message_id=l_post_rec.message_id;

2713: END LOOP;
2714: -- Need new code to complete this .
2715: -- Create a Record for New Email Accounts in PREPROC Tables and Stop Processing for the
2716: -- Current One
2717: delete from iem_email_classifications where message_id=l_post_rec.message_id;
2718: -- Fix for bug 14010115 ,update ih_interaction_id also with latest interaction_id in case new interaction is created.
2719: -- else, row will be updated with old interaction id, in case of auto-redirect rule.
2720: update iem_rt_preproc_emails
2721: set email_account_id=l_redirect_id,

Line 3766: from iem_email_classifications

3762: end;
3763: -- Call the specific search API
3764: BEGIN
3765: select classification_id into l_class
3766: from iem_email_classifications
3767: where message_id=p_message_id
3768: and score = (select max(score) from iem_email_classifications
3769: where message_id=p_message_id)
3770: and rownum=1;

Line 3768: and score = (select max(score) from iem_email_classifications

3764: BEGIN
3765: select classification_id into l_class
3766: from iem_email_classifications
3767: where message_id=p_message_id
3768: and score = (select max(score) from iem_email_classifications
3769: where message_id=p_message_id)
3770: and rownum=1;
3771: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(
3772: p_message_id ,

Line 4891: iem_intents a,iem_email_classifications b

4887: l_message_id number;
4888: l_top_intent varchar2(50);
4889: l_top_score number;
4890: cursor c_intent is select a.intent,b.score from
4891: iem_intents a,iem_email_classifications b
4892: where b.message_id=l_message_id
4893: and a.intent_id=b.classification_id;
4894: g_statement_log boolean; -- Statement Level Logging
4895: l_intent_str varchar2(700);

Line 4934: select classification_id from iem_email_classifications

4930: l_status varchar2(10);
4931: l_out_text varchar2(255);
4932: l_uid number;
4933: cursor c_class_id is
4934: select classification_id from iem_email_classifications
4935: where message_id=l_message_id
4936: order by score desc;
4937: l_start_search number;
4938: ABORT_REPROCESSING EXCEPTION;

Line 5557: from IEM_EMAIL_CLASSIFICATIONS

5553: l_param_array := AMV_SEARCH_PVT.amv_searchpar_varray_type();
5554: l_rep :=cs_kb_varchar100_tbl_type() ;
5555: begin
5556: select classification_string into l_imt_string
5557: from IEM_EMAIL_CLASSIFICATIONS
5558: WHERE MESSAGE_ID=l_msg_id AND EMAIL_ACCOUNT_ID=l_email_account_id
5559: and classification_id=l_classification_id;
5560: IF l_repos is null then
5561: l_search_repos:=FND_PROFILE.VALUE_SPECIFIC('IEM_KNOWLEDGE_BASE');