APPS.CSZ_INTERACTION_PVT dependencies on JTF_IH_ACTION_ITEMS_TL

Line 245: select action_item_id into l_activity_rec.action_item_id from jtf_ih_action_items_tl where short_description = SR_MODULE;

241: l_activity_rec.outcome_id := l_outcome_id;
242: l_activity_rec.reason_id := l_reason_id;
243: l_activity_rec.result_id := l_result_id;
244: begin
245: select action_item_id into l_activity_rec.action_item_id from jtf_ih_action_items_tl where short_description = SR_MODULE;
246: exception
247: when NO_DATA_FOUND then
248: x_return_status := Fnd_Api.G_RET_STS_ERROR;
249: Fnd_Message.SET_NAME('CS','ActionItemId not found for "Service Request" module');

Line 402: select action_item_id into l_activity_rec.action_item_id from jtf_ih_action_items_tl where short_description = SR_MODULE;

398: end;
399: -- dbms_output.put_line ('ActionID=' || l_action_id || ' Status=' || x_return_status);
400: l_activity_rec.action_id := l_action_id; -- Created
401: begin
402: select action_item_id into l_activity_rec.action_item_id from jtf_ih_action_items_tl where short_description = SR_MODULE;
403: exception
404: when NO_DATA_FOUND then
405: x_return_status := Fnd_Api.G_RET_STS_ERROR;
406: Fnd_Message.SET_NAME('CS','ActionItemId not found for "Service Request" module');