104: 24-OCT-2003 ABlinko 115.22 Replaced hardcoded SATURDAY and SUNDAY references
105: 08-DEC-2003 RMakhija 115.24 Uncommented SMP element entry update when rate
106: changes in next tax year. Also added similar
107: Functionality for SAP, SPP Birth and SPP Adoption.
108: 17-DEC-2003 RMakhija 115.25 Added detection of SMP/SAP/SPP standard rate
109: changes and SMP Higher Rate changes to auto
110: update element entries in next tax year.
111: 12-FEB-2004 RMakhija 115.26 Bug 3437026. Updated csr_affected_leave
112: cursor in update_ssp_smp_entries procedure.
1323: close csr_new_smp_rate;
1324: --
1325: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);
1326: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);
1327: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);
1328: --
1329: /* Find SMP rate for current tax year */
1330: open csr_old_smp_rate;
1331: fetch csr_old_smp_rate into l_old_SMP_rate, l_old_high_smp_rate, l_old_std_smp_rate;
1332: close csr_old_smp_rate;
1333: --
1334: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);
1335: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);
1336: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);
1337: --
1338: if (l_new_SMP_rate = l_old_smp_rate) and (l_new_high_smp_rate = l_old_high_smp_rate) and (l_new_std_smp_rate = l_old_std_smp_rate)
1339: then
1340: return false;
2624: close csr_new_smp_rate;
2625: --
2626: hr_utility.trace('New Lower SMP rate: '||l_new_SMP_rate);
2627: hr_utility.trace('New Higher SMP rate: '||l_new_high_SMP_rate);
2628: hr_utility.trace('New Standard SMP rate: '||l_new_std_SMP_rate);
2629: --
2630: /* Find SMP rate for current tax year */
2631: open csr_old_smp_rate;
2632: fetch csr_old_smp_rate into l_old_SMP_rate, l_old_high_smp_rate, l_old_std_smp_rate;
2633: close csr_old_smp_rate;
2634: --
2635: hr_utility.trace('Old SMP rate: '||l_old_SMP_rate);
2636: hr_utility.trace('Old Higher SMP rate: '||l_old_high_SMP_rate);
2637: hr_utility.trace('Old Standard SMP rate: '||l_old_std_SMP_rate);
2638: --
2639: if (l_new_SMP_rate = l_old_smp_rate) and (l_new_high_smp_rate = l_old_high_smp_rate) and (l_new_std_smp_rate = l_old_std_smp_rate)
2640: then
2641: return false;