273: PROCEDURE validate_qualification_type
274: (
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_qualification_type IN PER_QUALIFICATION_TYPES.name%TYPE,
278: p_x_qualification_type_id IN OUT NOCOPY PER_QUALIFICATION_TYPES.qualification_type_id%TYPE
279: );
280:
281: -- Procedure to validate whether the Route is in Updatable status
274: (
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_qualification_type IN PER_QUALIFICATION_TYPES.name%TYPE,
278: p_x_qualification_type_id IN OUT NOCOPY PER_QUALIFICATION_TYPES.qualification_type_id%TYPE
279: );
280:
281: -- Procedure to validate whether the Route is in Updatable status
282: PROCEDURE validate_route_status