DBA Data[Home] [Help]

APPS.PY_GB_ASG dependencies on HR_UTILITY

Line 22: hr_utility.set_location('payroll_transfer',10);

18: l_person_id number;
19: --
20: BEGIN
21: --
22: hr_utility.set_location('payroll_transfer',10);
23: delete from pay_assignment_latest_balances
24: where assignment_id = p_assignment_id;
25: --
26: hr_utility.set_location('payroll_transfer',20);

Line 26: hr_utility.set_location('payroll_transfer',20);

22: hr_utility.set_location('payroll_transfer',10);
23: delete from pay_assignment_latest_balances
24: where assignment_id = p_assignment_id;
25: --
26: hr_utility.set_location('payroll_transfer',20);
27: open csr_person_details(p_assignment_id);
28: fetch csr_person_details into l_person_id;
29: close csr_person_details;
30: --

Line 32: hr_utility.set_location('payroll_transfer',30);

28: fetch csr_person_details into l_person_id;
29: close csr_person_details;
30: --
31: if l_person_id is not null then
32: hr_utility.set_location('payroll_transfer',30);
33: delete from pay_person_latest_balances
34: where person_id = l_person_id;
35: end if;
36: --

Line 85: hr_utility.set_location(l_function_name,10);

81: open csr_multi_assignments(p_person_id, p_effective_date);
82: fetch csr_multi_assignments into l_num_assgt;
83: close csr_multi_assignments;
84: --
85: hr_utility.set_location(l_function_name,10);
86: if l_num_assgt > 1 then
87: -- more than one asgt at this point in time, check
88: -- aggregated PAYE flag.
89: open csr_person_details(p_person_id, p_effective_date);

Line 93: hr_utility.set_location(l_function_name,20);

89: open csr_person_details(p_person_id, p_effective_date);
90: fetch csr_person_details into l_aggregated_flag;
91: close csr_person_details;
92: --
93: hr_utility.set_location(l_function_name,20);
94: if upper(l_aggregated_flag) = 'Y' then
95: hr_utility.set_location(l_function_name,30);
96: BEGIN
97: DELETE from pay_person_latest_balances

Line 95: hr_utility.set_location(l_function_name,30);

91: close csr_person_details;
92: --
93: hr_utility.set_location(l_function_name,20);
94: if upper(l_aggregated_flag) = 'Y' then
95: hr_utility.set_location(l_function_name,30);
96: BEGIN
97: DELETE from pay_person_latest_balances
98: WHERE person_id = p_person_id;
99: END;