214: BEGIN
215: --
216: SELECT user_entity_id
217: INTO l_user_entity_id
218: FROM ff_user_entities
219: WHERE user_entity_name = upper(p_user_entity_name);
220: --
221: EXCEPTION WHEN NO_DATA_FOUND THEN
222: --
237: );
238: --
239: SELECT user_entity_id
240: INTO l_user_entity_id
241: FROM ff_user_entities
242: WHERE user_entity_name = p_user_entity_name;
243: --
244: -- Add any route parameter values
245: --