APPS.IEM_SPV_ACTIONS_PVT dependencies on IEM_ROUTE_CLASSIFICATIONS

Line 22: l_class_name iem_route_classifications.name%type;

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;
26: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

Line 209: /*select name into l_class_name from iem_route_classifications where route_classification_id=l_post_mdts.rt_classification_id;

205: raise MOVE_MSG_FAIL;
206: END IF;
207:
208: -- Move Messages between folders
209: /*select name into l_class_name from iem_route_classifications where route_classification_id=l_post_mdts.rt_classification_id;
210:
211: iem_movemsg_pvt.moveOesMessage (p_api_version_number => 1.0,
212: p_init_msg_list => FND_API.G_FALSE,
213: p_commit=> FND_API.G_FALSE,