APPS.IEM_CLASSIFICATIONS_PVT dependencies on IEM_THEMES

Line 260: DELETE FROM IEM_THEMES

256: END IF;
257: -- Initialize API return status to SUCCESS
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: IF p_classification_id IS NOT NULL THEN
260: DELETE FROM IEM_THEMES
261: WHERE CLASSIFICATION_ID=p_classification_id;
262: DELETE FROM IEM_CLASSIFICATIONS
263: WHERE CLASSIFICATION_ID=p_classification_id;
264: ELSE

Line 781: FROM IEM_THEMES

777: --Actual API starts here
778: FOR i IN p_clas_ids_tbl.FIRST..p_clas_ids_tbl.LAST
779: LOOP
780: DELETE
781: FROM IEM_THEMES
782: WHERE classification_id = p_clas_ids_tbl(i);
783: DELETE
784: FROM IEM_CLASSIFICATIONS
785: WHERE classification_id = p_clas_ids_tbl(i);

Line 885: FROM IEM_THEMES

881: where classification_id=l_class_id;
882: FOR i IN p_clas_ids_tbl.FIRST..p_clas_ids_tbl.LAST
883: LOOP
884: DELETE
885: FROM IEM_THEMES
886: WHERE classification_id = p_clas_ids_tbl(i);
887: DELETE
888: FROM IEM_CLASSIFICATIONS
889: WHERE classification_id = p_clas_ids_tbl(i);

Line 897: iem_themes_pvt.calculate_weight (l_email_account_id,

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' ,

Line 900: iem_themes_pvt.calculate_weight (l_email_account_id,

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

Line 1165: iem_themes_pvt.calculate_weight (t_email_account_id ,

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' ,

Line 1168: iem_themes_pvt.calculate_weight (t_email_account_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' ,
1170: l_status );
1171: t_email_account_id:=p_email_account_id;
1172: iem_themes_pvt.calculate_weight (p_email_account_id ,

Line 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',

Line 1175: iem_themes_pvt.calculate_weight (p_email_account_id ,

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: