DBA Data[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_KB_RESULTS_PVT

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