APPS.IEM_SPV_ACTIONS_PVT dependencies on IEM_RT_PROC_EMAILS

Line 21: l_post_mdts iem_rt_proc_emails%rowtype;

17: l_status NUMBER := 0;
18: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
19: l_msg_count NUMBER := 0;
20: l_msg_data VARCHAR2(2000);
21: l_post_mdts iem_rt_proc_emails%rowtype;
22: l_class_name iem_route_classifications.name%type;
23: MOVE_MSG_FAIL exception;
24: l_current_user NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
25: l_spv_resource_id number := 0;

Line 56: select * into l_post_mdts from iem_rt_proc_emails where message_id=p_message_id for update;

52:
53: --Initialize API status return
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: select * into l_post_mdts from iem_rt_proc_emails where message_id=p_message_id for update;
57:
58: --l_current_user := 1003651;
59:
60: select resource_id into l_spv_resource_id from jtf_rs_resource_extns where user_id=l_current_user;