APPS.CSZ_INTERACTION_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 157: SELECT resource_id INTO l_interaction_rec.resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;

153: l_interaction_rec.party_id := p_cust_party_id; -- Customer Party ID
154:
155: -- Agent resource id
156: begin
157: SELECT resource_id INTO l_interaction_rec.resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;
158: exception
159: when NO_DATA_FOUND then
160: x_return_status := Fnd_Api.G_RET_STS_ERROR;
161: Fnd_Message.SET_NAME('CS','No resource Id found for User:' || p_user_id);

Line 445: SELECT resource_id INTO l_interaction_rec.resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;

441: l_interaction_rec.end_date_time := sysdate;
442: l_interaction_rec.interaction_id := p_interaction_id;
443: -- Agent resource id
444: begin
445: SELECT resource_id INTO l_interaction_rec.resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;
446: exception
447: when NO_DATA_FOUND then
448: rollback to end_interaction_sp;
449: x_return_status := Fnd_Api.G_RET_STS_ERROR;