[Home] [Help]
23: -- For Bug 4945916 - Corrected the Save point from
24: -- update_account_class to update_account_class_PVT.
25: -- PKESANI 05/23/2006 Changed the code to get the count of emails with
26: -- the classification, that is to be deleted.
27: -- changed it from iem_post_mdts to iem_rt_proc_emails table.
28: -- --------- ------ ------------------------------------------
29: -- Enter procedure, function bodies as shown below
30: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ROUTE_CLASS_PVT ';
31:
182:
183: -- Commented out from R12
184: -- select count(*) into l_count_msg_postmdt from iem_post_mdts where rt_classification_id=p_class_ids_tbl(i);
185:
186: select count(*) into l_count_msg_postmdt from iem_rt_proc_emails where rt_classification_id=p_class_ids_tbl(i);
187:
188: if l_count_msg_postmdt <> 0 then
189: select name into l_undeleted_class_name_1 from iem_route_classifications where route_classification_id=p_class_ids_tbl(i);
190: l_undeleted_class_name := l_undeleted_class_name||l_undeleted_class_name_1||', ';
2376:
2377: FOR i IN p_class_ids_tbl.FIRST..p_class_ids_tbl.LAST LOOP
2378: --pkesani--
2379: -- select count(*) into l_count_msg_postmdt from iem_post_mdts where rt_classification_id=p_class_ids_tbl(i) and email_account_id = p_account_id;
2380: select count(*) into l_count_msg_postmdt from iem_rt_proc_emails where rt_classification_id=p_class_ids_tbl(i) and email_account_id = p_account_id;
2381:
2382: if l_count_msg_postmdt <> 0 then
2383: select name into l_undeleted_class_name_1 from iem_route_classifications where route_classification_id=p_class_ids_tbl(i);
2384: l_undeleted_class_name := l_undeleted_class_name||l_undeleted_class_name_1||', ';