APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_EMAIL_CLASSIFICATIONS

Line 78: select classification_id from iem_email_classifications

74: NO_ITEM_FOUND EXCEPTION;
75: NO_RECORD_TO_PROCESS EXCEPTION;
76: STOP_REDIRECT_PROCESSING EXCEPTION;
77: cursor c_class_id is
78: select classification_id from iem_email_classifications
79: where message_id=l_message_id
80: order by score desc;
81: l_intent_counter number;
82: l_start_search number:=0;

Line 159: iem_intents a,iem_email_classifications b

155: -- Introduce additional key Intent String
156: l_top_intent varchar2(50);
157: l_top_score number;
158: cursor c_intent is select a.intent,b.score from
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;

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

1831: END LOOP;
1832: -- Need new code to complete this .
1833: -- Create a Record for New Email Accounts in PREPROC Tables and Stop Processing for the
1834: -- Current One
1835: delete from iem_email_classifications where message_id=l_post_rec.message_id;
1836: update iem_rt_preproc_emails
1837: set email_account_id=l_redirect_id,
1838: msg_status='REDIRECT',
1839: ih_media_item_id=l_media_id

Line 2671: from iem_email_classifications

2667: end;
2668: -- Call the specific search API
2669: BEGIN
2670: select classification_id into l_class
2671: from iem_email_classifications
2672: where message_id=p_message_id
2673: and score = (select max(score) from iem_email_classifications
2674: where message_id=p_message_id)
2675: and rownum=1;

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

2669: BEGIN
2670: select classification_id into l_class
2671: from iem_email_classifications
2672: where message_id=p_message_id
2673: and score = (select max(score) from iem_email_classifications
2674: where message_id=p_message_id)
2675: and rownum=1;
2676: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(
2677: p_message_id ,

Line 3796: iem_intents a,iem_email_classifications b

3792: l_message_id number;
3793: l_top_intent varchar2(50);
3794: l_top_score number;
3795: cursor c_intent is select a.intent,b.score from
3796: iem_intents a,iem_email_classifications b
3797: where b.message_id=l_message_id
3798: and a.intent_id=b.classification_id;
3799: g_statement_log boolean; -- Statement Level Logging
3800: l_intent_str varchar2(700);

Line 3839: select classification_id from iem_email_classifications

3835: l_status varchar2(10);
3836: l_out_text varchar2(255);
3837: l_uid number;
3838: cursor c_class_id is
3839: select classification_id from iem_email_classifications
3840: where message_id=l_message_id
3841: order by score desc;
3842: l_start_search number;
3843: ABORT_REPROCESSING EXCEPTION;

Line 4462: from IEM_EMAIL_CLASSIFICATIONS

4458: l_param_array := AMV_SEARCH_PVT.amv_searchpar_varray_type();
4459: l_rep :=cs_kb_varchar100_tbl_type() ;
4460: begin
4461: select classification_string into l_imt_string
4462: from IEM_EMAIL_CLASSIFICATIONS
4463: WHERE MESSAGE_ID=l_msg_id AND EMAIL_ACCOUNT_ID=l_email_account_id
4464: and classification_id=l_classification_id;
4465: IF l_repos is null then
4466: l_search_repos:=FND_PROFILE.VALUE_SPECIFIC('IEM_KNOWLEDGE_BASE');