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,
901: 'R' ,
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,
901: 'R' ,
902: l_status );
903:
904: --Standard check of p_commit
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 ,
1166: 'Q' ,
1167: l_status );
1168: iem_themes_pvt.calculate_weight (t_email_account_id ,
1169: 'R' ,
1164: t_email_account_id:=l_email_account_id;
1165: iem_themes_pvt.calculate_weight (t_email_account_id ,
1166: 'Q' ,
1167: l_status );
1168: iem_themes_pvt.calculate_weight (t_email_account_id ,
1169: 'R' ,
1170: l_status );
1171: t_email_account_id:=p_email_account_id;
1172: iem_themes_pvt.calculate_weight (p_email_account_id ,
1168: iem_themes_pvt.calculate_weight (t_email_account_id ,
1169: 'R' ,
1170: l_status );
1171: t_email_account_id:=p_email_account_id;
1172: iem_themes_pvt.calculate_weight (p_email_account_id ,
1173: 'Q',
1174: l_status );
1175: iem_themes_pvt.calculate_weight (p_email_account_id ,
1176: 'R',
1171: t_email_account_id:=p_email_account_id;
1172: iem_themes_pvt.calculate_weight (p_email_account_id ,
1173: 'Q',
1174: l_status );
1175: iem_themes_pvt.calculate_weight (p_email_account_id ,
1176: 'R',
1177: l_status );
1178: END IF;
1179: