[Home] [Help]
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,
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,
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,
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,
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,
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,