DBA Data[Home] [Help]

APPS.PAY_CA_VAC_BANK dependencies on HR_UTILITY

Line 32: hr_utility.set_location('Starting calc_years_of_service', 10);

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;

Line 34: hr_utility.set_location('calc_years_of_service', 20);

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;

Line 39: hr_utility.set_location('Ending calc_years_of_service', 40);

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;