146: -- Get the name of the route classification from the ID returned above.
147: -- This is the name of the folder where the inbound message exists on the
148: -- master account.
149: SELECT name INTO x_route_classification
150: FROM iem_route_classifications
151: WHERE ROUTE_CLASSIFICATION_ID = l_email_data_rec.RT_CLASSIFICATION_ID;
152:
153: -- Set the folder name
154: x_folder_name := x_route_classification;
688: FROM IEM_RT_PROC_EMAILS
689: WHERE message_id = x_mdt_message_id;
690:
691: SELECT name into x_route_classification
692: FROM iem_route_classifications
693: WHERE ROUTE_CLASSIFICATION_ID = x_route_classification_id;
694:
695: EXCEPTION
696: WHEN OTHERS THEN
839: l_i_sequence NUMBER;
840: l_m_sequence NUMBER;
841: l_db_server_id NUMBER;
842: l_classification_id NUMBER;
843: l_rt_classification_name IEM_ROUTE_CLASSIFICATIONS.NAME%TYPE;
844: l_ih_subject VARCHAR2(80);
845:
846: BEGIN
847:
3743: -- Get the name of the route classification from the ID returned above.
3744: -- This is the name of the folder where the inbound message exists on the
3745: -- master account.
3746: SELECT name INTO x_route_classification
3747: FROM iem_route_classifications
3748: WHERE ROUTE_CLASSIFICATION_ID = l_email_data_rec.RT_CLASSIFICATION_ID;
3749:
3750: -- Set the folder name
3751: x_folder_name := x_route_classification;
4571: if p_reason='O' then
4572: l_folder_name:='Inbox';
4573: else
4574: SELECT name INTO l_folder_name
4575: FROM iem_route_classifications
4576: WHERE ROUTE_CLASSIFICATION_ID = l_email_data_rec.RT_CLASSIFICATION_ID;
4577: end if;
4578:
4579: -- Extract tag key value from key value table