28: l_years_of_service NUMBER := 0;
29:
30: BEGIN
31:
32: hr_utility.set_location('Starting calc_years_of_service', 10);
33: IF p_date_type = 'HD' THEN
34: hr_utility.set_location('calc_years_of_service', 20);
35: OPEN c_years_of_service;
36: FETCH c_years_of_service INTO l_years_of_service;
30: BEGIN
31:
32: hr_utility.set_location('Starting calc_years_of_service', 10);
33: IF p_date_type = 'HD' THEN
34: hr_utility.set_location('calc_years_of_service', 20);
35: OPEN c_years_of_service;
36: FETCH c_years_of_service INTO l_years_of_service;
37: CLOSE c_years_of_service;
38: END IF;
35: OPEN c_years_of_service;
36: FETCH c_years_of_service INTO l_years_of_service;
37: CLOSE c_years_of_service;
38: END IF;
39: hr_utility.set_location('Ending calc_years_of_service', 40);
40:
41: RETURN l_years_of_service;
42:
43: END;