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 1616: iem_classifications a,iem_email_classifications b

1612: l_out_message_id number;
1613: l_top_intent iem_classifications.classification%type;
1614: insert_arch_dtl_error EXCEPTION;
1615: cursor c1 is select a.classification,b.score from
1616: iem_classifications a,iem_email_classifications b
1617: where b.message_id=p_message_id
1618: and a.classification_id=b.classification_id
1619: order by score asc;
1620: l_api_version_number number:=1.0;

Line 1724: delete from iem_email_classifications where message_id=p_message_id;

1720: raise insert_arch_dtl_error;
1721: END IF;
1722: -- Delete All RUN TIME DATA and MESSAGE DATA FROM PRIMARY STORE
1723: delete from iem_rt_proc_emails where message_id=p_message_id;
1724: delete from iem_email_classifications where message_id=p_message_id;
1725: delete from iem_kb_results where message_id=p_message_id;
1726: delete from iem_ms_base_headers where message_id=p_message_id;
1727: delete from iem_ms_msgbodys where message_id=p_message_id;
1728: delete from iem_ms_msgparts where message_id=p_message_id;