APPS.IEM_MAILITEM_PUB dependencies on IEM_EMAIL_CLASSIFICATIONS

Line 823: delete from iem_email_classifications where message_id=p_message_id;

819: WHERE MESSAGE_ID=p_message_id;
820: delete from iem_reroute_hists
821: where message_id=p_message_id;
822: delete from iem_kb_results where message_id=p_message_id;
823: delete from iem_email_classifications where message_id=p_message_id;
824: delete from iem_comp_rt_stats where type='WORKFLOW' and param=to_char(p_message_id);
825:
826: /*
827: delete from iem_encrypted_tags

Line 1430: iem_classifications a,iem_email_classifications b

1426: l_out_message_id number;
1427: l_top_intent iem_classifications.classification%type;
1428: insert_arch_dtl_error EXCEPTION;
1429: cursor c1 is select a.classification,b.score from
1430: iem_classifications a,iem_email_classifications b
1431: where b.message_id=p_message_id
1432: and a.classification_id=b.classification_id
1433: order by score asc;
1434: l_api_version_number number:=1.0;

Line 1538: delete from iem_email_classifications where message_id=p_message_id;

1534: raise insert_arch_dtl_error;
1535: END IF;
1536: -- Delete All RUN TIME DATA and MESSAGE DATA FROM PRIMARY STORE
1537: delete from iem_rt_proc_emails where message_id=p_message_id;
1538: delete from iem_email_classifications where message_id=p_message_id;
1539: delete from iem_kb_results where message_id=p_message_id;
1540: delete from iem_ms_base_headers where message_id=p_message_id;
1541: delete from iem_ms_msgbodys where message_id=p_message_id;
1542: delete from iem_ms_msgparts where message_id=p_message_id;