APPS.IEM_THEMES_PVT dependencies on IEM_CLASSIFICATIONS

Line 739: from iem_classifications

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,
742: 'Q' ,
743: l_status );

Line 969: from iem_classifications

965: where query_response=p_query_response
966: and classification_id=p_classification_id
967: and theme=p_theme;
968: select email_account_id into l_email_account_id
969: from iem_classifications
970: where classification_id=p_classification_id;
971: IF l_cnt=1 THEN
972: SELECT iem_themes_s1.nextval
973: INTO l_seq_id

Line 1048: from iem_themes a,iem_classifications b

1044: l_class_id number;
1045: CURSOR c_theme is
1046: select a.theme_id,a.classification_id,
1047: a.theme,a.query_response,a.score
1048: from iem_themes a,iem_classifications b
1049: where a.classification_id=b.classification_id
1050: and b.email_account_id=p_email_account_id
1051: and a.query_response=p_query_response;
1052:

Line 1054: from iem_themes a,iem_classifications b

1050: and b.email_account_id=p_email_account_id
1051: and a.query_response=p_query_response;
1052:
1053: cursor c1 is select a.classification_id,sum(power(a.score,2)) score
1054: from iem_themes a,iem_classifications b
1055: where a.classification_id=b.classification_id
1056: and b.email_account_id=p_email_account_id
1057: and a.query_response=p_query_response
1058: group by a.classification_id;

Line 1061: from iem_themes a,iem_classifications b

1057: and a.query_response=p_query_response
1058: group by a.classification_id;
1059:
1060: cursor c_calc is select a.theme_id,a.score
1061: from iem_themes a,iem_classifications b
1062: where a.classification_id=b.classification_id
1063: and b.email_account_id=p_email_account_id
1064: and a.query_response=p_query_response
1065: and a.classification_id=l_class_id;

Line 1091: from iem_themes A,iem_classifications B

1087:
1088: -- no of document matching the theme in the system
1089:
1090: select nvl(sum(a.doc_count),0) into l_Nt
1091: from iem_themes A,iem_classifications B
1092: where A.classification_id=B.classification_id
1093: and B.email_account_id=p_email_account_id
1094: and A.query_response=v1.query_response
1095: and A.theme=v1.theme;

Line 1115: update iem_classifications

1111: END LOOP;
1112: -- Normalised the score using RMS
1113: for v1 in c1 LOOP
1114: l_class_id:=v1.classification_id;
1115: update iem_classifications
1116: set last_update_date=sysdate
1117: where classification_id=v1.classification_id;
1118: for v2 in c_calc loop
1119: update iem_themes