873: , x_return_status OUT NOCOPY VARCHAR2
874: ) IS
875:
876: /*Cursor verifies whether routing associated with any recipe or not*/
877: CURSOR Cur_check_rout(cp_routing_id gmd_recipes.routing_id%TYPE)
878: IS SELECT count(1) FROM gmd_recipes
879: WHERE routing_id = cp_routing_id
880: AND delete_mark = 0;
881: /* Local variable section */
874: ) IS
875:
876: /*Cursor verifies whether routing associated with any recipe or not*/
877: CURSOR Cur_check_rout(cp_routing_id gmd_recipes.routing_id%TYPE)
878: IS SELECT count(1) FROM gmd_recipes
879: WHERE routing_id = cp_routing_id
880: AND delete_mark = 0;
881: /* Local variable section */
882: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROUTING';