APPS.IEM_CLIENT_PUB dependencies on IEM_ROUTE_CLASSIFICATIONS

Line 150: FROM iem_route_classifications

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;

Line 692: FROM iem_route_classifications

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

Line 843: l_rt_classification_name IEM_ROUTE_CLASSIFICATIONS.NAME%TYPE;

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:

Line 3683: FROM iem_route_classifications

3679: -- Get the name of the route classification from the ID returned above.
3680: -- This is the name of the folder where the inbound message exists on the
3681: -- master account.
3682: SELECT name INTO x_route_classification
3683: FROM iem_route_classifications
3684: WHERE ROUTE_CLASSIFICATION_ID = l_email_data_rec.RT_CLASSIFICATION_ID;
3685:
3686: -- Set the folder name
3687: x_folder_name := x_route_classification;

Line 4500: FROM iem_route_classifications

4496: if p_reason='O' then
4497: l_folder_name:='Inbox';
4498: else
4499: SELECT name INTO l_folder_name
4500: FROM iem_route_classifications
4501: WHERE ROUTE_CLASSIFICATION_ID = l_email_data_rec.RT_CLASSIFICATION_ID;
4502: end if;
4503:
4504: -- Extract tag key value from key value table