362: -- ---------------------------------------------------------------------------
363: --
364: -- Description:
365: -- Validates that the routing_list_id exists in the table
366: -- ghr_routing_lists
367: --
368: -- Pre-conditions:
369: -- None
370: --
393: l_api_updating boolean;
394: --
395: Cursor c_rout_list_id is
396: select 1
397: from ghr_routing_lists prl
398: where prl.routing_list_id = p_routing_list_id;
399: --
400: begin
401: hr_utility.set_location('Entering:'|| l_proc, 10);