APPS.IEM_CLASSIFICATIONS_PVT dependencies on IEM_ACCOUNT_INTENT_DOCS

Line 891: delete from iem_account_intent_docs

887: DELETE
888: FROM IEM_CLASSIFICATIONS
889: WHERE classification_id = p_clas_ids_tbl(i);
890: END LOOP;
891: delete from iem_account_intent_docs
892: where classification_id not in
893: (select classification_id from iem_classifications);
894: delete from iem_theme_docs
895: where account_intent_doc_id not in

Line 896: (select account_intent_doc_id from iem_account_intent_docs);

892: where classification_id not in
893: (select classification_id from iem_classifications);
894: delete from iem_theme_docs
895: where account_intent_doc_id not in
896: (select account_intent_doc_id from iem_account_intent_docs);
897: iem_themes_pvt.calculate_weight (l_email_account_id,
898: 'Q' ,
899: l_status );
900: iem_themes_pvt.calculate_weight (l_email_account_id,

Line 1161: update iem_account_intent_docs

1157: IF l_email_account_id <>p_email_account_id THEN
1158:
1159: -- In this case need to recalculate the score for both email accounts.
1160:
1161: update iem_account_intent_docs
1162: set email_account_id=p_email_account_id
1163: where classification_id=p_classification_id;
1164: t_email_account_id:=l_email_account_id;
1165: iem_themes_pvt.calculate_weight (t_email_account_id ,