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.

APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_KB_RESULTS

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

3198: for v_item in c_item LOOP
3199: select count(*) into l_kb_rank
3200: from iem_doc_usage_stats
3201: where kb_doc_id=v_item.item_id;
3202: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
3203: p_init_msg_list=>'F' ,
3204: p_commit=>'F' ,
3205: p_message_id =>l_post_rec.message_id,
3206: p_classification_id=>0,

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

5372: for v_item in c_item LOOP
5373: select count(*) into l_kb_rank
5374: from iem_doc_usage_stats
5375: where kb_doc_id=v_item.item_id;
5376: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
5377: p_init_msg_list=>'F' ,
5378: p_commit=>'F' ,
5379: p_message_id =>l_mail_rec.message_id,
5380: p_classification_id=>0,

Line 5473: l_kb_repos iem_kb_results.kb_repository_name%type;

5469: l_return_status VARCHAR2(20);
5470: l_msg_count NUMBER;
5471: l_msg_data VARCHAR2(400);
5472: l_doc_id number;
5473: l_kb_repos iem_kb_results.kb_repository_name%type;
5474: l_rows_returned cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
5475: l_next_row_pos cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
5476: l_total_row_cnt cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
5477: l_logmessage varchar2(500);

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

5518: cursor c2 is
5519: select keyword,weight from iem_intent_dtls where intent_id=l_classification_id
5520: and query_response='R';
5521: cursor c_doc is
5522: select document_id,KB_REPOSITORY_NAME,score,kb_result_id from iem_kb_results
5523: where message_id=l_msg_id
5524: order by 2,1,score asc;
5525: begin
5526: select count(*) into l_cnt from iem_kb_results

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

5522: select document_id,KB_REPOSITORY_NAME,score,kb_result_id from iem_kb_results
5523: where message_id=l_msg_id
5524: order by 2,1,score asc;
5525: begin
5526: select count(*) into l_cnt from iem_kb_results
5527: where message_id=l_msg_id
5528: and classification_id=l_classification_id
5529: and email_account_id=l_email_account_id;
5530: IF l_cnt=0 THEN

Line 5605: -- Insert The Data into IEM_KB_RESULTS

5601: if g_statement_log then
5602: l_logmessage:= 'End Calling the Specific Search For Message Id '||l_msg_id||' No of document Returned '||l_result_array.count;
5603: iem_logger(l_logmessage);
5604: end if;
5605: -- Insert The Data into IEM_KB_RESULTS
5606:
5607: FOR l_count IN 1..l_result_array.count LOOP
5608: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
5609: p_init_msg_list=>'F' ,

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

5604: end if;
5605: -- Insert The Data into IEM_KB_RESULTS
5606:
5607: FOR l_count IN 1..l_result_array.count LOOP
5608: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
5609: p_init_msg_list=>'F' ,
5610: p_commit=>'F' ,
5611: p_message_id =>l_msg_id,
5612: p_classification_id=>l_classification_id,

Line 5679: -- Insert The Data into IEM_KB_RESULTS

5675: if g_statement_log then
5676: l_logmessage:= 'End Calling the Specific Search For Message Id '||l_msg_id||' No of document Returned '||l_result_array.count;
5677: iem_logger(l_logmessage);
5678: end if;
5679: -- Insert The Data into IEM_KB_RESULTS
5680:
5681: FOR l_count IN 1..l_result_array.count LOOP
5682: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
5683: p_init_msg_list=>'F' ,

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

5678: end if;
5679: -- Insert The Data into IEM_KB_RESULTS
5680:
5681: FOR l_count IN 1..l_result_array.count LOOP
5682: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
5683: p_init_msg_list=>'F' ,
5684: p_commit=>'F' ,
5685: p_message_id =>l_msg_id,
5686: p_classification_id=>l_classification_id,

Line 5767: -- Insert The Data into IEM_KB_RESULTS

5763: if g_statement_log then
5764: l_logmessage:= 'End Calling the Specific Search For Message Id '||l_msg_id||' No of document Returned '||l_result_array.count;
5765: iem_logger(l_logmessage);
5766: end if;
5767: -- Insert The Data into IEM_KB_RESULTS
5768:
5769: FOR l_count IN 1..l_result_array.count LOOP
5770: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
5771: p_init_msg_list=>'F' ,

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

5766: end if;
5767: -- Insert The Data into IEM_KB_RESULTS
5768:
5769: FOR l_count IN 1..l_result_array.count LOOP
5770: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
5771: p_init_msg_list=>'F' ,
5772: p_commit=>'F' ,
5773: p_message_id =>l_msg_id,
5774: p_classification_id=>l_classification_id,

Line 5841: -- Insert The Data into IEM_KB_RESULTS

5837: if g_statement_log then
5838: l_logmessage:= 'End Calling the Specific Search For Message Id '||l_msg_id||' No of document Returned '||l_result_array.count;
5839: iem_logger(l_logmessage);
5840: end if;
5841: -- Insert The Data into IEM_KB_RESULTS
5842:
5843: FOR l_count IN 1..l_result_array.count LOOP
5844: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
5845: p_init_msg_list=>'F' ,

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

5840: end if;
5841: -- Insert The Data into IEM_KB_RESULTS
5842:
5843: FOR l_count IN 1..l_result_array.count LOOP
5844: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
5845: p_init_msg_list=>'F' ,
5846: p_commit=>'F' ,
5847: p_message_id =>l_msg_id,
5848: p_classification_id=>l_classification_id,

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

5885: l_doc_id:=0;
5886: l_kb_repos:=null;
5887: for v_doc in c_doc LOOP
5888: if (v_doc.document_id = l_doc_id and v_doc.kb_repository_name=l_kb_repos) then
5889: delete from iem_kb_results where message_id=l_msg_id and kb_result_id=v_doc.kb_result_id;
5890: end if;
5891: l_doc_id:=v_doc.document_id;
5892: l_kb_repos:=v_doc.kb_repository_name;
5893: END LOOP;