APPS.IEM_THEMES_PVT dependencies on IEM_THEME_DOCS

Line 734: delete from iem_theme_docs where theme_id not in

730: DELETE
731: FROM IEM_THEMES
732: WHERE theme_id = p_thes_ids_tbl(i);
733: -- Score Readjustment using noise reduction algorithim
734: delete from iem_theme_docs where theme_id not in
735: (select theme_id from iem_themes);
736: delete from iem_account_intent_docs where account_intent_doc_id
737: not in (select account_intent_doc_id from iem_theme_docs);
738: select email_account_id into l_email_account_id

Line 737: not in (select account_intent_doc_id from iem_theme_docs);

733: -- Score Readjustment using noise reduction algorithim
734: delete from iem_theme_docs where theme_id not in
735: (select theme_id from iem_themes);
736: delete from iem_account_intent_docs where account_intent_doc_id
737: not in (select account_intent_doc_id from iem_theme_docs);
738: select email_account_id into l_email_account_id
739: from iem_classifications
740: where classification_id=l_class_id;
741: iem_themes_pvt.calculate_weight (l_email_account_id,

Line 998: IEM_THEME_DOCS_PVT.create_item(p_account_intent_doc_id=>p_doc_seq_no ,

994: p_LAST_UPDATED_BY,
995: p_LAST_UPDATE_DATE,
996: p_LAST_UPDATE_LOGIN,
997: l_cnt);
998: IEM_THEME_DOCS_PVT.create_item(p_account_intent_doc_id=>p_doc_seq_no ,
999: p_theme_id=>l_seq_id ,
1000: x_return_status=>l_status);
1001: IF l_status='E' THEN
1002: raise DOC_EXCEP;

Line 1015: IEM_THEME_DOCS_PVT.create_item(p_account_intent_doc_id=>p_doc_seq_no ,

1011: from iem_themes
1012: where query_response=p_query_response
1013: and classification_id=p_classification_id
1014: and theme=p_theme;
1015: IEM_THEME_DOCS_PVT.create_item(p_account_intent_doc_id=>p_doc_seq_no ,
1016: p_theme_id=>l_theme_id ,
1017: x_return_status=>l_status);
1018: IF l_status='E' THEN
1019: raise DOC_EXCEP;