101: else
102:
103: close cur_route_exists;
104:
105: hr_utility.trace(p_route_name || ' route already exists.');
106: hr_utility.trace('Updating route .... ' || p_route_name);
107:
108: update ff_routes
109: set text = p_text
102:
103: close cur_route_exists;
104:
105: hr_utility.trace(p_route_name || ' route already exists.');
106: hr_utility.trace('Updating route .... ' || p_route_name);
107:
108: update ff_routes
109: set text = p_text
110: where route_id = l_route_id;