eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_KB_RESULTS

Line 2176: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,

2172: for v_item in c_item LOOP
2173: select count(*) into l_kb_rank
2174: from iem_doc_usage_stats
2175: where kb_doc_id=v_item.item_id;
2176: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
2177: p_init_msg_list=>'F' ,
2178: p_commit=>'F' ,
2179: p_message_id =>l_post_rec.message_id,
2180: p_classification_id=>0,

Line 4281: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,

4277: for v_item in c_item LOOP
4278: select count(*) into l_kb_rank
4279: from iem_doc_usage_stats
4280: where kb_doc_id=v_item.item_id;
4281: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
4282: p_init_msg_list=>'F' ,
4283: p_commit=>'F' ,
4284: p_message_id =>l_mail_rec.message_id,
4285: p_classification_id=>0,

Line 4378: l_kb_repos iem_kb_results.kb_repository_name%type;

4374: l_return_status VARCHAR2(20);
4375: l_msg_count NUMBER;
4376: l_msg_data VARCHAR2(400);
4377: l_doc_id number;
4378: l_kb_repos iem_kb_results.kb_repository_name%type;
4379: l_rows_returned cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4380: l_next_row_pos cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4381: l_total_row_cnt cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4382: l_logmessage varchar2(500);

Line 4427: select document_id,KB_REPOSITORY_NAME,score,kb_result_id from iem_kb_results

4423: cursor c2 is
4424: select keyword,weight from iem_intent_dtls where intent_id=l_classification_id
4425: and query_response='R';
4426: cursor c_doc is
4427: select document_id,KB_REPOSITORY_NAME,score,kb_result_id from iem_kb_results
4428: where message_id=l_msg_id
4429: order by 2,1,score asc;
4430: begin
4431: select count(*) into l_cnt from iem_kb_results

Line 4431: select count(*) into l_cnt from iem_kb_results

4427: select document_id,KB_REPOSITORY_NAME,score,kb_result_id from iem_kb_results
4428: where message_id=l_msg_id
4429: order by 2,1,score asc;
4430: begin
4431: select count(*) into l_cnt from iem_kb_results
4432: where message_id=l_msg_id
4433: and classification_id=l_classification_id
4434: and email_account_id=l_email_account_id;
4435: IF l_cnt=0 THEN

Line 4510: -- Insert The Data into IEM_KB_RESULTS

4506: if g_statement_log then
4507: l_logmessage:= 'End Calling the Specific Search For Message Id '||l_msg_id||' No of document Returned '||l_result_array.count;
4508: iem_logger(l_logmessage);
4509: end if;
4510: -- Insert The Data into IEM_KB_RESULTS
4511:
4512: FOR l_count IN 1..l_result_array.count LOOP
4513: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
4514: p_init_msg_list=>'F' ,

Line 4513: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,

4509: end if;
4510: -- Insert The Data into IEM_KB_RESULTS
4511:
4512: FOR l_count IN 1..l_result_array.count LOOP
4513: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
4514: p_init_msg_list=>'F' ,
4515: p_commit=>'F' ,
4516: p_message_id =>l_msg_id,
4517: p_classification_id=>l_classification_id,

Line 4584: -- Insert The Data into IEM_KB_RESULTS

4580: if g_statement_log then
4581: l_logmessage:= 'End Calling the Specific Search For Message Id '||l_msg_id||' No of document Returned '||l_result_array.count;
4582: iem_logger(l_logmessage);
4583: end if;
4584: -- Insert The Data into IEM_KB_RESULTS
4585:
4586: FOR l_count IN 1..l_result_array.count LOOP
4587: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
4588: p_init_msg_list=>'F' ,

Line 4587: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,

4583: end if;
4584: -- Insert The Data into IEM_KB_RESULTS
4585:
4586: FOR l_count IN 1..l_result_array.count LOOP
4587: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
4588: p_init_msg_list=>'F' ,
4589: p_commit=>'F' ,
4590: p_message_id =>l_msg_id,
4591: p_classification_id=>l_classification_id,

Line 4672: -- Insert The Data into IEM_KB_RESULTS

4668: if g_statement_log then
4669: l_logmessage:= 'End Calling the Specific Search For Message Id '||l_msg_id||' No of document Returned '||l_result_array.count;
4670: iem_logger(l_logmessage);
4671: end if;
4672: -- Insert The Data into IEM_KB_RESULTS
4673:
4674: FOR l_count IN 1..l_result_array.count LOOP
4675: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
4676: p_init_msg_list=>'F' ,

Line 4675: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,

4671: end if;
4672: -- Insert The Data into IEM_KB_RESULTS
4673:
4674: FOR l_count IN 1..l_result_array.count LOOP
4675: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
4676: p_init_msg_list=>'F' ,
4677: p_commit=>'F' ,
4678: p_message_id =>l_msg_id,
4679: p_classification_id=>l_classification_id,

Line 4746: -- Insert The Data into IEM_KB_RESULTS

4742: if g_statement_log then
4743: l_logmessage:= 'End Calling the Specific Search For Message Id '||l_msg_id||' No of document Returned '||l_result_array.count;
4744: iem_logger(l_logmessage);
4745: end if;
4746: -- Insert The Data into IEM_KB_RESULTS
4747:
4748: FOR l_count IN 1..l_result_array.count LOOP
4749: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
4750: p_init_msg_list=>'F' ,

Line 4749: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,

4745: end if;
4746: -- Insert The Data into IEM_KB_RESULTS
4747:
4748: FOR l_count IN 1..l_result_array.count LOOP
4749: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
4750: p_init_msg_list=>'F' ,
4751: p_commit=>'F' ,
4752: p_message_id =>l_msg_id,
4753: p_classification_id=>l_classification_id,

Line 4794: delete from iem_kb_results where message_id=l_msg_id and kb_result_id=v_doc.kb_result_id;

4790: l_doc_id:=0;
4791: l_kb_repos:=null;
4792: for v_doc in c_doc LOOP
4793: if (v_doc.document_id = l_doc_id and v_doc.kb_repository_name=l_kb_repos) then
4794: delete from iem_kb_results where message_id=l_msg_id and kb_result_id=v_doc.kb_result_id;
4795: end if;
4796: l_doc_id:=v_doc.document_id;
4797: l_kb_repos:=v_doc.kb_repository_name;
4798: END LOOP;