[Home] [Help]
222: AND pap.accrual_plan_element_type_id = pet.element_type_id
223: AND pap.accrual_category = p_plan_category ;
224:
225: BEGIN
226: hr_utility.trace('In: ' || l_proc) ;
227: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
228: hr_utility.trace(' p_effective_date: ' || to_char(p_effective_date,'dd Mon yyyy')) ;
229: hr_utility.trace(' p_plan_category: ' || p_plan_category) ;
230:
223: AND pap.accrual_category = p_plan_category ;
224:
225: BEGIN
226: hr_utility.trace('In: ' || l_proc) ;
227: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
228: hr_utility.trace(' p_effective_date: ' || to_char(p_effective_date,'dd Mon yyyy')) ;
229: hr_utility.trace(' p_plan_category: ' || p_plan_category) ;
230:
231: OPEN csr_get_accrual_plan_id(p_assignment_id, p_effective_date, p_plan_category) ;
224:
225: BEGIN
226: hr_utility.trace('In: ' || l_proc) ;
227: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
228: hr_utility.trace(' p_effective_date: ' || to_char(p_effective_date,'dd Mon yyyy')) ;
229: hr_utility.trace(' p_plan_category: ' || p_plan_category) ;
230:
231: OPEN csr_get_accrual_plan_id(p_assignment_id, p_effective_date, p_plan_category) ;
232:
225: BEGIN
226: hr_utility.trace('In: ' || l_proc) ;
227: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
228: hr_utility.trace(' p_effective_date: ' || to_char(p_effective_date,'dd Mon yyyy')) ;
229: hr_utility.trace(' p_plan_category: ' || p_plan_category) ;
230:
231: OPEN csr_get_accrual_plan_id(p_assignment_id, p_effective_date, p_plan_category) ;
232:
233: FETCH csr_get_accrual_plan_id INTO l_accrual_plan_id;
234:
235: IF csr_get_accrual_plan_id%NOTFOUND
236: THEN
237: CLOSE csr_get_accrual_plan_id;
238: hr_utility.trace('Crash Out: ' || l_proc) ;
239: hr_utility.set_message(801, 'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
240: hr_utility.raise_error;
241: end if ;
242:
235: IF csr_get_accrual_plan_id%NOTFOUND
236: THEN
237: CLOSE csr_get_accrual_plan_id;
238: hr_utility.trace('Crash Out: ' || l_proc) ;
239: hr_utility.set_message(801, 'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
240: hr_utility.raise_error;
241: end if ;
242:
243: FETCH csr_get_accrual_plan_id INTO l_dummy ;
236: THEN
237: CLOSE csr_get_accrual_plan_id;
238: hr_utility.trace('Crash Out: ' || l_proc) ;
239: hr_utility.set_message(801, 'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
240: hr_utility.raise_error;
241: end if ;
242:
243: FETCH csr_get_accrual_plan_id INTO l_dummy ;
244:
244:
245: IF csr_get_accrual_plan_id%FOUND
246: THEN
247: CLOSE csr_get_accrual_plan_id;
248: hr_utility.trace('Crash Out: ' || l_proc) ;
249: hr_utility.set_message(801, 'HR_NZ_TOO_MANY_ACCRUAL_PLANS');
250: hr_utility.raise_error;
251: END IF;
252:
245: IF csr_get_accrual_plan_id%FOUND
246: THEN
247: CLOSE csr_get_accrual_plan_id;
248: hr_utility.trace('Crash Out: ' || l_proc) ;
249: hr_utility.set_message(801, 'HR_NZ_TOO_MANY_ACCRUAL_PLANS');
250: hr_utility.raise_error;
251: END IF;
252:
253: CLOSE csr_get_accrual_plan_id;
246: THEN
247: CLOSE csr_get_accrual_plan_id;
248: hr_utility.trace('Crash Out: ' || l_proc) ;
249: hr_utility.set_message(801, 'HR_NZ_TOO_MANY_ACCRUAL_PLANS');
250: hr_utility.raise_error;
251: END IF;
252:
253: CLOSE csr_get_accrual_plan_id;
254:
251: END IF;
252:
253: CLOSE csr_get_accrual_plan_id;
254:
255: hr_utility.trace(' return: ' || to_char(l_accrual_plan_id)) ;
256: hr_utility.trace('Out: ' || l_proc) ;
257: RETURN l_accrual_plan_id;
258:
259: END get_accrual_plan_by_category;
252:
253: CLOSE csr_get_accrual_plan_id;
254:
255: hr_utility.trace(' return: ' || to_char(l_accrual_plan_id)) ;
256: hr_utility.trace('Out: ' || l_proc) ;
257: RETURN l_accrual_plan_id;
258:
259: END get_accrual_plan_by_category;
260:
292: l_entitlement_adj NUMBER;
293:
294: BEGIN
295:
296: hr_utility.trace('In: ' || l_proc) ;
297: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
298: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
299: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
300: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
293:
294: BEGIN
295:
296: hr_utility.trace('In: ' || l_proc) ;
297: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
298: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
299: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
300: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
301: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
294: BEGIN
295:
296: hr_utility.trace('In: ' || l_proc) ;
297: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
298: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
299: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
300: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
301: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
302:
295:
296: hr_utility.trace('In: ' || l_proc) ;
297: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
298: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
299: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
300: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
301: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
302:
303: l_assignment_id := p_assignment_id ;
296: hr_utility.trace('In: ' || l_proc) ;
297: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
298: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
299: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
300: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
301: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
302:
303: l_assignment_id := p_assignment_id ;
304: l_plan_id := p_plan_id ;
297: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
298: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
299: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
300: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
301: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
302:
303: l_assignment_id := p_assignment_id ;
304: l_plan_id := p_plan_id ;
305: l_payroll_id := p_payroll_id ;
336: ,p_start_date => l_start_date
337: ,p_end_date => l_end_date));
338:
339:
340: hr_utility.trace('ven_others_ent= '||to_char(l_entitlement_adj));
341:
342: l_adjustment_element := 'Accrual Adjustment Element';
343: l_accrual_adj:= (get_adjustment_values(
344: p_assignment_id => l_assignment_id
348: ,p_start_date => l_start_date
349: ,p_end_date => l_end_date));
350:
351:
352: hr_utility.trace('ven_others_acc= '||to_char(l_accrual_adj));
353:
354:
355: -- venkat ---
356:
356:
357:
358: l_net_entitlement := l_net_entitlement + l_entitlement_adj + l_accrual_adj;
359:
360: hr_utility.trace(' return: ' || to_char(l_net_entitlement)) ;
361: hr_utility.trace('Out: ' || l_proc) ;
362: RETURN l_net_entitlement ;
363:
364: END get_net_accrual ;
357:
358: l_net_entitlement := l_net_entitlement + l_entitlement_adj + l_accrual_adj;
359:
360: hr_utility.trace(' return: ' || to_char(l_net_entitlement)) ;
361: hr_utility.trace('Out: ' || l_proc) ;
362: RETURN l_net_entitlement ;
363:
364: END get_net_accrual ;
365:
437: where accrual_plan_id = v_accrual_plan_id;
438: --
439: BEGIN
440: --
441: hr_utility.set_location('Entering: '||l_proc,10) ;
442: --
443:
444: l_assignment_id := p_assignment_id;
445: l_plan_id := p_plan_id;
483: ,p_accrual_plan_id => p_plan_id
484: ,p_calculation_date => p_calculation_date
485: );
486: --
487: hr_utility.set_location(l_proc,30) ;
488: hr_utility.trace('l_entitlement_end_date = '||to_char(l_entitlement_end_date, 'yyyy/mm/dd'));
489: hr_utility.trace('l_expiry_date = '||to_char(l_expiry_date, 'yyyy/mm/dd'));
490: hr_utility.trace('l_max_co = '||to_char(l_max_co));
491: --
484: ,p_calculation_date => p_calculation_date
485: );
486: --
487: hr_utility.set_location(l_proc,30) ;
488: hr_utility.trace('l_entitlement_end_date = '||to_char(l_entitlement_end_date, 'yyyy/mm/dd'));
489: hr_utility.trace('l_expiry_date = '||to_char(l_expiry_date, 'yyyy/mm/dd'));
490: hr_utility.trace('l_max_co = '||to_char(l_max_co));
491: --
492: -- ============================
485: );
486: --
487: hr_utility.set_location(l_proc,30) ;
488: hr_utility.trace('l_entitlement_end_date = '||to_char(l_entitlement_end_date, 'yyyy/mm/dd'));
489: hr_utility.trace('l_expiry_date = '||to_char(l_expiry_date, 'yyyy/mm/dd'));
490: hr_utility.trace('l_max_co = '||to_char(l_max_co));
491: --
492: -- ============================
493: -- ENTITLEMENT PORTION OF LEAVE
486: --
487: hr_utility.set_location(l_proc,30) ;
488: hr_utility.trace('l_entitlement_end_date = '||to_char(l_entitlement_end_date, 'yyyy/mm/dd'));
489: hr_utility.trace('l_expiry_date = '||to_char(l_expiry_date, 'yyyy/mm/dd'));
490: hr_utility.trace('l_max_co = '||to_char(l_max_co));
491: --
492: -- ============================
493: -- ENTITLEMENT PORTION OF LEAVE
494: -- ============================
537: l_leave_entitlement_amount := l_accrual;
538: end if;
539: end if;
540: --
541: hr_utility.set_location(l_proc,40);
542: hr_utility.trace('l_entitlement_end_date = '||to_char(l_entitlement_end_date, 'yyyy/mm/dd'));
543: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
544: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
545: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
538: end if;
539: end if;
540: --
541: hr_utility.set_location(l_proc,40);
542: hr_utility.trace('l_entitlement_end_date = '||to_char(l_entitlement_end_date, 'yyyy/mm/dd'));
543: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
544: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
545: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
546: hr_utility.trace('l_leave_entitlement_amount = '||to_char(l_leave_entitlement_amount));
539: end if;
540: --
541: hr_utility.set_location(l_proc,40);
542: hr_utility.trace('l_entitlement_end_date = '||to_char(l_entitlement_end_date, 'yyyy/mm/dd'));
543: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
544: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
545: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
546: hr_utility.trace('l_leave_entitlement_amount = '||to_char(l_leave_entitlement_amount));
547:
540: --
541: hr_utility.set_location(l_proc,40);
542: hr_utility.trace('l_entitlement_end_date = '||to_char(l_entitlement_end_date, 'yyyy/mm/dd'));
543: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
544: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
545: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
546: hr_utility.trace('l_leave_entitlement_amount = '||to_char(l_leave_entitlement_amount));
547:
548: --------------------------------------
541: hr_utility.set_location(l_proc,40);
542: hr_utility.trace('l_entitlement_end_date = '||to_char(l_entitlement_end_date, 'yyyy/mm/dd'));
543: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
544: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
545: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
546: hr_utility.trace('l_leave_entitlement_amount = '||to_char(l_leave_entitlement_amount));
547:
548: --------------------------------------
549: --**Bug No : 2366349 Value of Adjustment element for Entitlement is calculated to add
542: hr_utility.trace('l_entitlement_end_date = '||to_char(l_entitlement_end_date, 'yyyy/mm/dd'));
543: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
544: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
545: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
546: hr_utility.trace('l_leave_entitlement_amount = '||to_char(l_leave_entitlement_amount));
547:
548: --------------------------------------
549: --**Bug No : 2366349 Value of Adjustment element for Entitlement is calculated to add
550: --** to the entitlements
560: ,p_start_date => l_start_date
561: ,p_end_date => l_end_date)
562: );
563:
564: hr_utility.trace('ven_others_ent= '||to_char(l_entitlement_adj));
565:
566: --------------------------------------
567: -- Bug No : 2366349 End
568: --------------------------------------
615: --amit
616: --
617: l_leave_total_amount := l_accrual;
618: --
619: hr_utility.set_location(l_proc,50) ;
620: hr_utility.trace('l_leave_total_amount = '||to_char(l_leave_total_amount));
621: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
622: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
623: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
616: --
617: l_leave_total_amount := l_accrual;
618: --
619: hr_utility.set_location(l_proc,50) ;
620: hr_utility.trace('l_leave_total_amount = '||to_char(l_leave_total_amount));
621: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
622: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
623: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
624: --
617: l_leave_total_amount := l_accrual;
618: --
619: hr_utility.set_location(l_proc,50) ;
620: hr_utility.trace('l_leave_total_amount = '||to_char(l_leave_total_amount));
621: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
622: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
623: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
624: --
625:
618: --
619: hr_utility.set_location(l_proc,50) ;
620: hr_utility.trace('l_leave_total_amount = '||to_char(l_leave_total_amount));
621: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
622: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
623: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
624: --
625:
626: ---------------------------------------------------------------------------------
619: hr_utility.set_location(l_proc,50) ;
620: hr_utility.trace('l_leave_total_amount = '||to_char(l_leave_total_amount));
621: hr_utility.trace('l_start_date = '||to_char(l_start_date, 'yyyy/mm/dd'));
622: hr_utility.trace('l_end_date = '||to_char(l_end_date, 'yyyy/mm/dd'));
623: hr_utility.trace('l_accrual_end_date = '||to_char(l_accrual_end_date, 'yyyy/mm/dd'));
624: --
625:
626: ---------------------------------------------------------------------------------
627: --** Bug No : 2366349 : Function returns the accrual adjustment value for the first
658: ,p_end_date => l_end_date));
659:
660:
661:
662: hr_utility.trace('ven_others_acc= '||to_char(l_accrual_adj));
663: --------------------------------------
664: -- Bug No : 2366349 End
665: --------------------------------------
666: l_others_accrual_amount := per_accrual_calc_functions.get_other_net_contribution (p_assignment_id => p_assignment_id
680: ,p_plan_id => p_plan_id
681: ,p_start_date => l_entitlement_end_date + 1
682: ,p_calculation_date => p_calculation_date
683: );
684: hr_utility.trace('Absence calculation start date = '||to_char(l_entitlement_end_date + 1,'yyyy/mm/dd'));
685: l_leave_entitlement_amount := l_leave_total_amount - l_accrual_absences;
686: l_leave_accrual_amount := 0;
687: --
688: else
691: ,p_plan_id => p_plan_id
692: ,p_start_date => l_start_date
693: ,p_calculation_date => p_calculation_date
694: );
695: hr_utility.trace('Absence calculation start date = '||to_char(l_start_date,'yyyy/mm/dd'));
696: --
697: --Get the net entitlement and accrualamount before checking for absences
698: -- Determine the amount to go towards accrual portion by subtracting
699: -- entitlement portion from total
725: l_leave_entitlement_amount := 0;
726: end if;
727: end if;
728: --
729: hr_utility.set_location(l_proc,60) ;
730: hr_utility.trace('Net Entitlement Amount = '||to_char(l_leave_entitlement_amount));
731: hr_utility.trace('Net Accrual Amount = '||to_char(l_leave_accrual_amount));
732: hr_utility.trace('Others accrual = '||to_char(l_others_accrual_amount));
733: hr_utility.trace('Others Entitlement = '||to_char(l_others_entitlement_amount));
726: end if;
727: end if;
728: --
729: hr_utility.set_location(l_proc,60) ;
730: hr_utility.trace('Net Entitlement Amount = '||to_char(l_leave_entitlement_amount));
731: hr_utility.trace('Net Accrual Amount = '||to_char(l_leave_accrual_amount));
732: hr_utility.trace('Others accrual = '||to_char(l_others_accrual_amount));
733: hr_utility.trace('Others Entitlement = '||to_char(l_others_entitlement_amount));
734:
727: end if;
728: --
729: hr_utility.set_location(l_proc,60) ;
730: hr_utility.trace('Net Entitlement Amount = '||to_char(l_leave_entitlement_amount));
731: hr_utility.trace('Net Accrual Amount = '||to_char(l_leave_accrual_amount));
732: hr_utility.trace('Others accrual = '||to_char(l_others_accrual_amount));
733: hr_utility.trace('Others Entitlement = '||to_char(l_others_entitlement_amount));
734:
735: --
728: --
729: hr_utility.set_location(l_proc,60) ;
730: hr_utility.trace('Net Entitlement Amount = '||to_char(l_leave_entitlement_amount));
731: hr_utility.trace('Net Accrual Amount = '||to_char(l_leave_accrual_amount));
732: hr_utility.trace('Others accrual = '||to_char(l_others_accrual_amount));
733: hr_utility.trace('Others Entitlement = '||to_char(l_others_entitlement_amount));
734:
735: --
736: -- set up return values
729: hr_utility.set_location(l_proc,60) ;
730: hr_utility.trace('Net Entitlement Amount = '||to_char(l_leave_entitlement_amount));
731: hr_utility.trace('Net Accrual Amount = '||to_char(l_leave_accrual_amount));
732: hr_utility.trace('Others accrual = '||to_char(l_others_accrual_amount));
733: hr_utility.trace('Others Entitlement = '||to_char(l_others_entitlement_amount));
734:
735: --
736: -- set up return values
737: --
740: p_calc_start_date := l_start_date;
741: p_last_accrual := l_accrual_end_date;
742: p_next_period_end := l_expiry_date;
743: --
744: hr_utility.trace('p_calc_start_date = '||to_char(p_calc_start_date, 'yyyy/mm/dd'));
745: hr_utility.trace('p_last_accrual = '||to_char(p_last_accrual, 'yyyy/mm/dd'));
746: hr_utility.trace('p_next_period_end = '||to_char(p_next_period_end, 'yyyy/mm/dd'));
747: --
748: hr_utility.set_location('Leaving '||l_proc,80);
741: p_last_accrual := l_accrual_end_date;
742: p_next_period_end := l_expiry_date;
743: --
744: hr_utility.trace('p_calc_start_date = '||to_char(p_calc_start_date, 'yyyy/mm/dd'));
745: hr_utility.trace('p_last_accrual = '||to_char(p_last_accrual, 'yyyy/mm/dd'));
746: hr_utility.trace('p_next_period_end = '||to_char(p_next_period_end, 'yyyy/mm/dd'));
747: --
748: hr_utility.set_location('Leaving '||l_proc,80);
749: RETURN (0);
742: p_next_period_end := l_expiry_date;
743: --
744: hr_utility.trace('p_calc_start_date = '||to_char(p_calc_start_date, 'yyyy/mm/dd'));
745: hr_utility.trace('p_last_accrual = '||to_char(p_last_accrual, 'yyyy/mm/dd'));
746: hr_utility.trace('p_next_period_end = '||to_char(p_next_period_end, 'yyyy/mm/dd'));
747: --
748: hr_utility.set_location('Leaving '||l_proc,80);
749: RETURN (0);
750: EXCEPTION
744: hr_utility.trace('p_calc_start_date = '||to_char(p_calc_start_date, 'yyyy/mm/dd'));
745: hr_utility.trace('p_last_accrual = '||to_char(p_last_accrual, 'yyyy/mm/dd'));
746: hr_utility.trace('p_next_period_end = '||to_char(p_next_period_end, 'yyyy/mm/dd'));
747: --
748: hr_utility.set_location('Leaving '||l_proc,80);
749: RETURN (0);
750: EXCEPTION
751: WHEN OTHERS THEN
752: hr_utility.trace('EXCEPTION-'||sqlerrm);
748: hr_utility.set_location('Leaving '||l_proc,80);
749: RETURN (0);
750: EXCEPTION
751: WHEN OTHERS THEN
752: hr_utility.trace('EXCEPTION-'||sqlerrm);
753:
754:
755: END get_accrual_entitlement ;
756:
779: from per_time_periods tp
780: where tp.payroll_id = p_payroll_id;
781: --
782: begin
783: hr_utility.set_location(' In: ' || l_proc,5) ;
784: --
785: -- check payroll periods exist up to calculation_end_date
786: --
787: open c_last_period ( p_payroll_id );
787: open c_last_period ( p_payroll_id );
788: fetch c_last_period into l_end_date;
789: close c_last_period;
790: --
791: hr_utility.set_location(' Out: ' || l_proc,10) ;
792: return(l_end_date);
793: EXCEPTION
794: WHEN others THEN
795: hr_utility.trace('Error - payroll periods not found for payroll_id '||to_char(p_payroll_id));
791: hr_utility.set_location(' Out: ' || l_proc,10) ;
792: return(l_end_date);
793: EXCEPTION
794: WHEN others THEN
795: hr_utility.trace('Error - payroll periods not found for payroll_id '||to_char(p_payroll_id));
796: hr_utility.set_location('Leaving:'||l_proc,99);
797: RETURN NULL;
798: end check_periods ;
799:
792: return(l_end_date);
793: EXCEPTION
794: WHEN others THEN
795: hr_utility.trace('Error - payroll periods not found for payroll_id '||to_char(p_payroll_id));
796: hr_utility.set_location('Leaving:'||l_proc,99);
797: RETURN NULL;
798: end check_periods ;
799:
800:
835: l_return_val NUMBER;
836:
837: BEGIN
838:
839: hr_utility.trace(' In: ' || l_proc) ;
840: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
841: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
842: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
843: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
836:
837: BEGIN
838:
839: hr_utility.trace(' In: ' || l_proc) ;
840: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
841: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
842: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
843: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
844: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
837: BEGIN
838:
839: hr_utility.trace(' In: ' || l_proc) ;
840: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
841: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
842: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
843: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
844: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
845:
838:
839: hr_utility.trace(' In: ' || l_proc) ;
840: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
841: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
842: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
843: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
844: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
845:
846:
839: hr_utility.trace(' In: ' || l_proc) ;
840: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
841: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
842: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
843: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
844: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
845:
846:
847: l_return_val :=hr_nz_holidays.get_accrual_entitlement(p_assignment_id
840: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
841: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
842: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
843: hr_utility.trace(' p_plan_id: ' || to_char(p_plan_id)) ;
844: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
845:
846:
847: l_return_val :=hr_nz_holidays.get_accrual_entitlement(p_assignment_id
848: ,p_payroll_id
858: p_net_entitlement := l_net_entitlement;
859: p_start_date := l_calc_start_date ;
860: p_end_date := p_calculation_date ;
861:
862: hr_utility.trace(' p_net_entitlement: ' || to_char(p_net_entitlement)) ;
863: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
864: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
865: hr_utility.trace('Out: ' || l_proc) ;
866:
859: p_start_date := l_calc_start_date ;
860: p_end_date := p_calculation_date ;
861:
862: hr_utility.trace(' p_net_entitlement: ' || to_char(p_net_entitlement)) ;
863: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
864: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
865: hr_utility.trace('Out: ' || l_proc) ;
866:
867: END annual_leave_net_entitlement;
860: p_end_date := p_calculation_date ;
861:
862: hr_utility.trace(' p_net_entitlement: ' || to_char(p_net_entitlement)) ;
863: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
864: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
865: hr_utility.trace('Out: ' || l_proc) ;
866:
867: END annual_leave_net_entitlement;
868:
861:
862: hr_utility.trace(' p_net_entitlement: ' || to_char(p_net_entitlement)) ;
863: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
864: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
865: hr_utility.trace('Out: ' || l_proc) ;
866:
867: END annual_leave_net_entitlement;
868:
869: /*---------------------------------------------------------------------
887: l_accrual_end_date DATE;
888: l_net_entitlement NUMBER;
889: l_acp_start_date DATE;
890: BEGIN
891: hr_utility.trace('In: ' || l_proc) ;
892: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
893: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
894: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
895: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
888: l_net_entitlement NUMBER;
889: l_acp_start_date DATE;
890: BEGIN
891: hr_utility.trace('In: ' || l_proc) ;
892: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
893: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
894: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
895: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
896:
889: l_acp_start_date DATE;
890: BEGIN
891: hr_utility.trace('In: ' || l_proc) ;
892: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
893: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
894: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
895: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
896:
897: l_plan_id := hr_nz_holidays.get_annual_leave_plan
890: BEGIN
891: hr_utility.trace('In: ' || l_proc) ;
892: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
893: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
894: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
895: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
896:
897: l_plan_id := hr_nz_holidays.get_annual_leave_plan
898: (p_assignment_id => p_assignment_id
891: hr_utility.trace('In: ' || l_proc) ;
892: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
893: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
894: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
895: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
896:
897: l_plan_id := hr_nz_holidays.get_annual_leave_plan
898: (p_assignment_id => p_assignment_id
899: ,p_business_group_id => p_business_group_id
908: (p_assignment_id => p_assignment_id
909: ,p_business_group_id => p_business_group_id
910: ,p_calculation_date => p_calculation_date+1);
911: l_acp_start_date := get_acp_start_date(p_assignment_id,l_plan_id,p_calculation_date+1);
912: hr_utility.trace('acp_strt_date= '||l_acp_start_date);
913: hr_utility.trace('p_cal_1_date = '||p_calculation_date);
914: if ((p_calculation_date+1)=l_acp_start_date) then
915: l_return_code := per_formula_functions.set_number('NET_ENTITLEMENT',0);
916: RETURN 0;
909: ,p_business_group_id => p_business_group_id
910: ,p_calculation_date => p_calculation_date+1);
911: l_acp_start_date := get_acp_start_date(p_assignment_id,l_plan_id,p_calculation_date+1);
912: hr_utility.trace('acp_strt_date= '||l_acp_start_date);
913: hr_utility.trace('p_cal_1_date = '||p_calculation_date);
914: if ((p_calculation_date+1)=l_acp_start_date) then
915: l_return_code := per_formula_functions.set_number('NET_ENTITLEMENT',0);
916: RETURN 0;
917: else
914: if ((p_calculation_date+1)=l_acp_start_date) then
915: l_return_code := per_formula_functions.set_number('NET_ENTITLEMENT',0);
916: RETURN 0;
917: else
918: hr_utility.set_location('Accrual Plan Not Found '||l_proc,10);
919: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
920: hr_utility.raise_error;
921: END IF;
922: end if;
915: l_return_code := per_formula_functions.set_number('NET_ENTITLEMENT',0);
916: RETURN 0;
917: else
918: hr_utility.set_location('Accrual Plan Not Found '||l_proc,10);
919: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
920: hr_utility.raise_error;
921: END IF;
922: end if;
923:
916: RETURN 0;
917: else
918: hr_utility.set_location('Accrual Plan Not Found '||l_proc,10);
919: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
920: hr_utility.raise_error;
921: END IF;
922: end if;
923:
924: hr_nz_holidays.annual_leave_net_entitlement
930: ,p_start_date => l_start_date
931: ,p_end_date => l_end_date
932: ,p_net_entitlement => l_net_entitlement);
933:
934: hr_utility.trace(' START_DATE: ' || to_char(l_start_date,'dd Mon yyyy')) ;
935: l_return_code := per_formula_functions.set_date('START_DATE',l_start_date);
936: hr_utility.trace(' END_DATE: ' || to_char(l_end_date,'dd Mon yyyy')) ;
937: l_return_code := per_formula_functions.set_date('END_DATE',l_end_date);
938: hr_utility.trace(' NET_ENTITLEMENT: ' || to_char(l_net_entitlement)) ;
932: ,p_net_entitlement => l_net_entitlement);
933:
934: hr_utility.trace(' START_DATE: ' || to_char(l_start_date,'dd Mon yyyy')) ;
935: l_return_code := per_formula_functions.set_date('START_DATE',l_start_date);
936: hr_utility.trace(' END_DATE: ' || to_char(l_end_date,'dd Mon yyyy')) ;
937: l_return_code := per_formula_functions.set_date('END_DATE',l_end_date);
938: hr_utility.trace(' NET_ENTITLEMENT: ' || to_char(l_net_entitlement)) ;
939: l_return_code := per_formula_functions.set_number('NET_ENTITLEMENT',l_net_entitlement);
940:
934: hr_utility.trace(' START_DATE: ' || to_char(l_start_date,'dd Mon yyyy')) ;
935: l_return_code := per_formula_functions.set_date('START_DATE',l_start_date);
936: hr_utility.trace(' END_DATE: ' || to_char(l_end_date,'dd Mon yyyy')) ;
937: l_return_code := per_formula_functions.set_date('END_DATE',l_end_date);
938: hr_utility.trace(' NET_ENTITLEMENT: ' || to_char(l_net_entitlement)) ;
939: l_return_code := per_formula_functions.set_number('NET_ENTITLEMENT',l_net_entitlement);
940:
941: hr_utility.trace(' return: 0') ;
942: hr_utility.trace('Out: ' || l_proc) ;
937: l_return_code := per_formula_functions.set_date('END_DATE',l_end_date);
938: hr_utility.trace(' NET_ENTITLEMENT: ' || to_char(l_net_entitlement)) ;
939: l_return_code := per_formula_functions.set_number('NET_ENTITLEMENT',l_net_entitlement);
940:
941: hr_utility.trace(' return: 0') ;
942: hr_utility.trace('Out: ' || l_proc) ;
943: RETURN 0;
944: EXCEPTION
945: WHEN others
938: hr_utility.trace(' NET_ENTITLEMENT: ' || to_char(l_net_entitlement)) ;
939: l_return_code := per_formula_functions.set_number('NET_ENTITLEMENT',l_net_entitlement);
940:
941: hr_utility.trace(' return: 0') ;
942: hr_utility.trace('Out: ' || l_proc) ;
943: RETURN 0;
944: EXCEPTION
945: WHEN others
946: THEN
944: EXCEPTION
945: WHEN others
946: THEN
947:
948: hr_utility.trace('Crash Out: ' || l_proc) ;
949: RETURN 1;
950: END get_net_entitlement;
951:
952: /*---------------------------------------------------------------------
976: AND accrual_plan_name = p_accrual_plan_name;
977:
978:
979: BEGIN
980: hr_utility.trace('In: ' || l_proc) ;
981: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
982: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
983: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
984: hr_utility.trace(' p_accrual_plan_name: ' || p_accrual_plan_name) ;
977:
978:
979: BEGIN
980: hr_utility.trace('In: ' || l_proc) ;
981: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
982: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
983: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
984: hr_utility.trace(' p_accrual_plan_name: ' || p_accrual_plan_name) ;
985: hr_utility.trace(' p_formula_name: ' || p_formula_name) ;
978:
979: BEGIN
980: hr_utility.trace('In: ' || l_proc) ;
981: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
982: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
983: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
984: hr_utility.trace(' p_accrual_plan_name: ' || p_accrual_plan_name) ;
985: hr_utility.trace(' p_formula_name: ' || p_formula_name) ;
986: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
979: BEGIN
980: hr_utility.trace('In: ' || l_proc) ;
981: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
982: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
983: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
984: hr_utility.trace(' p_accrual_plan_name: ' || p_accrual_plan_name) ;
985: hr_utility.trace(' p_formula_name: ' || p_formula_name) ;
986: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
987:
980: hr_utility.trace('In: ' || l_proc) ;
981: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
982: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
983: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
984: hr_utility.trace(' p_accrual_plan_name: ' || p_accrual_plan_name) ;
985: hr_utility.trace(' p_formula_name: ' || p_formula_name) ;
986: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
987:
988: OPEN csr_get_accrual_plan_id;
981: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
982: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
983: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
984: hr_utility.trace(' p_accrual_plan_name: ' || p_accrual_plan_name) ;
985: hr_utility.trace(' p_formula_name: ' || p_formula_name) ;
986: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
987:
988: OPEN csr_get_accrual_plan_id;
989: FETCH csr_get_accrual_plan_id INTO l_accrual_plan_id;
982: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
983: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
984: hr_utility.trace(' p_accrual_plan_name: ' || p_accrual_plan_name) ;
985: hr_utility.trace(' p_formula_name: ' || p_formula_name) ;
986: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
987:
988: OPEN csr_get_accrual_plan_id;
989: FETCH csr_get_accrual_plan_id INTO l_accrual_plan_id;
990: IF (csr_get_accrual_plan_id%NOTFOUND)
989: FETCH csr_get_accrual_plan_id INTO l_accrual_plan_id;
990: IF (csr_get_accrual_plan_id%NOTFOUND)
991: THEN
992: CLOSE csr_get_accrual_plan_id;
993: hr_utility.trace('Crash Out: ' || l_proc) ;
994: hr_utility.set_message(801, 'Accrual Plan Not Found');
995: hr_utility.raise_error;
996: END IF;
997: CLOSE csr_get_accrual_plan_id;
990: IF (csr_get_accrual_plan_id%NOTFOUND)
991: THEN
992: CLOSE csr_get_accrual_plan_id;
993: hr_utility.trace('Crash Out: ' || l_proc) ;
994: hr_utility.set_message(801, 'Accrual Plan Not Found');
995: hr_utility.raise_error;
996: END IF;
997: CLOSE csr_get_accrual_plan_id;
998:
991: THEN
992: CLOSE csr_get_accrual_plan_id;
993: hr_utility.trace('Crash Out: ' || l_proc) ;
994: hr_utility.set_message(801, 'Accrual Plan Not Found');
995: hr_utility.raise_error;
996: END IF;
997: CLOSE csr_get_accrual_plan_id;
998:
999:
1022: ,p_calculation_date => p_calculation_date
1023: ,p_inputs => l_inputs
1024: ,p_outputs => l_get_outputs);
1025:
1026: hr_utility.trace(' return: 0') ;
1027: hr_utility.trace('Out: ' || l_proc) ;
1028: RETURN 0;
1029: EXCEPTION
1030: WHEN others THEN
1023: ,p_inputs => l_inputs
1024: ,p_outputs => l_get_outputs);
1025:
1026: hr_utility.trace(' return: 0') ;
1027: hr_utility.trace('Out: ' || l_proc) ;
1028: RETURN 0;
1029: EXCEPTION
1030: WHEN others THEN
1031: hr_utility.trace('Crash Out: ' || l_proc) ;
1027: hr_utility.trace('Out: ' || l_proc) ;
1028: RETURN 0;
1029: EXCEPTION
1030: WHEN others THEN
1031: hr_utility.trace('Crash Out: ' || l_proc) ;
1032: RETURN 1;
1033: END call_accrual_formula;
1034:
1035: /*---------------------------------------------------------------------
1063: AND c_calculation_date BETWEEN pee.effective_start_date AND pee.effective_end_date
1064: AND pap.accrual_category = 'NZAL' ;
1065:
1066: BEGIN
1067: hr_utility.trace('In: ' || l_proc) ;
1068: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1069: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1070: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1071:
1064: AND pap.accrual_category = 'NZAL' ;
1065:
1066: BEGIN
1067: hr_utility.trace('In: ' || l_proc) ;
1068: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1069: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1070: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1071:
1072: OPEN csr_annual_leave_accrual_plan (p_business_group_id
1065:
1066: BEGIN
1067: hr_utility.trace('In: ' || l_proc) ;
1068: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1069: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1070: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1071:
1072: OPEN csr_annual_leave_accrual_plan (p_business_group_id
1073: ,p_calculation_date
1066: BEGIN
1067: hr_utility.trace('In: ' || l_proc) ;
1068: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1069: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1070: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1071:
1072: OPEN csr_annual_leave_accrual_plan (p_business_group_id
1073: ,p_calculation_date
1074: ,p_assignment_id);
1075:
1076: FETCH csr_annual_leave_accrual_plan INTO l_plan_id;
1077: CLOSE csr_annual_leave_accrual_plan;
1078:
1079: hr_utility.trace(' return: ' || to_char(l_plan_id)) ;
1080: hr_utility.trace('Out: ' || l_proc) ;
1081: RETURN l_plan_id;
1082:
1083: END;
1076: FETCH csr_annual_leave_accrual_plan INTO l_plan_id;
1077: CLOSE csr_annual_leave_accrual_plan;
1078:
1079: hr_utility.trace(' return: ' || to_char(l_plan_id)) ;
1080: hr_utility.trace('Out: ' || l_proc) ;
1081: RETURN l_plan_id;
1082:
1083: END;
1084:
1128: WHERE lookup_type = 'NAME_TRANSLATIONS'
1129: AND lookup_code = 'PTO_CONTINUOUS_SD');
1130:
1131: BEGIN
1132: hr_utility.trace('In: ' || l_proc) ;
1133: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1134: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1135: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
1136:
1129: AND lookup_code = 'PTO_CONTINUOUS_SD');
1130:
1131: BEGIN
1132: hr_utility.trace('In: ' || l_proc) ;
1133: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1134: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1135: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
1136:
1137: OPEN csr_continuous_service_date (p_business_group_id
1130:
1131: BEGIN
1132: hr_utility.trace('In: ' || l_proc) ;
1133: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1134: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1135: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
1136:
1137: OPEN csr_continuous_service_date (p_business_group_id
1138: ,p_accrual_plan_id
1131: BEGIN
1132: hr_utility.trace('In: ' || l_proc) ;
1133: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1134: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1135: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
1136:
1137: OPEN csr_continuous_service_date (p_business_group_id
1138: ,p_accrual_plan_id
1139: ,p_calculation_date
1139: ,p_calculation_date
1140: ,p_assignment_id);
1141: FETCH csr_continuous_service_date INTO l_csd;
1142: CLOSE csr_continuous_service_date;
1143: hr_utility.trace(' return: ' || to_char(l_csd)) ;
1144: hr_utility.trace('Out: ' || l_proc) ;
1145: RETURN l_csd;
1146:
1147: END;
1140: ,p_assignment_id);
1141: FETCH csr_continuous_service_date INTO l_csd;
1142: CLOSE csr_continuous_service_date;
1143: hr_utility.trace(' return: ' || to_char(l_csd)) ;
1144: hr_utility.trace('Out: ' || l_proc) ;
1145: RETURN l_csd;
1146:
1147: END;
1148:
1181: AND c_calculation_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
1182:
1183:
1184: BEGIN
1185: hr_utility.trace('In: ' || l_proc) ;
1186: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1187: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1188: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1189:
1182:
1183:
1184: BEGIN
1185: hr_utility.trace('In: ' || l_proc) ;
1186: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1187: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1188: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1189:
1190: OPEN csr_scl(p_business_group_id
1183:
1184: BEGIN
1185: hr_utility.trace('In: ' || l_proc) ;
1186: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1187: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1188: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1189:
1190: OPEN csr_scl(p_business_group_id
1191: ,p_calculation_date
1184: BEGIN
1185: hr_utility.trace('In: ' || l_proc) ;
1186: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1187: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1188: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1189:
1190: OPEN csr_scl(p_business_group_id
1191: ,p_calculation_date
1192: ,p_assignment_id);
1191: ,p_calculation_date
1192: ,p_assignment_id);
1193: FETCH csr_scl INTO l_anniversary_date;
1194: CLOSE csr_scl;
1195: hr_utility.trace(' return: ' || to_char(l_anniversary_date,'dd Mon yyyy')) ;
1196: hr_utility.trace('Out: ' || l_proc) ;
1197: RETURN l_anniversary_date;
1198:
1199: END;
1192: ,p_assignment_id);
1193: FETCH csr_scl INTO l_anniversary_date;
1194: CLOSE csr_scl;
1195: hr_utility.trace(' return: ' || to_char(l_anniversary_date,'dd Mon yyyy')) ;
1196: hr_utility.trace('Out: ' || l_proc) ;
1197: RETURN l_anniversary_date;
1198:
1199: END;
1200:
1219: l_base_anniversary DATE;
1220: l_last_anniversary DATE := NULL;
1221:
1222: BEGIN
1223: hr_utility.trace('In: ' || l_proc) ;
1224: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1225: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1226: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1227:
1220: l_last_anniversary DATE := NULL;
1221:
1222: BEGIN
1223: hr_utility.trace('In: ' || l_proc) ;
1224: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1225: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1226: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1227:
1228: l_base_anniversary := get_anniversary_date (p_business_group_id => p_business_group_id
1221:
1222: BEGIN
1223: hr_utility.trace('In: ' || l_proc) ;
1224: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1225: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1226: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1227:
1228: l_base_anniversary := get_anniversary_date (p_business_group_id => p_business_group_id
1229: ,p_calculation_date => p_calculation_date
1222: BEGIN
1223: hr_utility.trace('In: ' || l_proc) ;
1224: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1225: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1226: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1227:
1228: l_base_anniversary := get_anniversary_date (p_business_group_id => p_business_group_id
1229: ,p_calculation_date => p_calculation_date
1230: ,p_assignment_id => p_assignment_id);
1229: ,p_calculation_date => p_calculation_date
1230: ,p_assignment_id => p_assignment_id);
1231: IF (l_base_anniversary IS NULL)
1232: THEN
1233: hr_utility.trace('Crash Out: ' || l_proc) ;
1234: hr_utility.set_message(801,'HR_NZ_INVALID_ANNIVERSARY_DATE');
1235: hr_utility.raise_error;
1236: END IF;
1237:
1230: ,p_assignment_id => p_assignment_id);
1231: IF (l_base_anniversary IS NULL)
1232: THEN
1233: hr_utility.trace('Crash Out: ' || l_proc) ;
1234: hr_utility.set_message(801,'HR_NZ_INVALID_ANNIVERSARY_DATE');
1235: hr_utility.raise_error;
1236: END IF;
1237:
1238: -- Assignment Anniversary Date is after the Calculation Date
1231: IF (l_base_anniversary IS NULL)
1232: THEN
1233: hr_utility.trace('Crash Out: ' || l_proc) ;
1234: hr_utility.set_message(801,'HR_NZ_INVALID_ANNIVERSARY_DATE');
1235: hr_utility.raise_error;
1236: END IF;
1237:
1238: -- Assignment Anniversary Date is after the Calculation Date
1239:
1238: -- Assignment Anniversary Date is after the Calculation Date
1239:
1240: IF (l_base_anniversary > p_calculation_date)
1241: THEN
1242: hr_utility.trace('Crash Out: ' || l_proc) ;
1243: hr_utility.set_message(801,'HR_NZ_INVALID_CALC_DATE');
1244: hr_utility.raise_error;
1245: END IF;
1246:
1239:
1240: IF (l_base_anniversary > p_calculation_date)
1241: THEN
1242: hr_utility.trace('Crash Out: ' || l_proc) ;
1243: hr_utility.set_message(801,'HR_NZ_INVALID_CALC_DATE');
1244: hr_utility.raise_error;
1245: END IF;
1246:
1247: l_last_anniversary := TO_DATE(TO_CHAR(l_base_anniversary,'DDMM')||TO_CHAR(p_calculation_date,'YYYY'),'DDMMYYYY');
1240: IF (l_base_anniversary > p_calculation_date)
1241: THEN
1242: hr_utility.trace('Crash Out: ' || l_proc) ;
1243: hr_utility.set_message(801,'HR_NZ_INVALID_CALC_DATE');
1244: hr_utility.raise_error;
1245: END IF;
1246:
1247: l_last_anniversary := TO_DATE(TO_CHAR(l_base_anniversary,'DDMM')||TO_CHAR(p_calculation_date,'YYYY'),'DDMMYYYY');
1248: IF (l_last_anniversary > p_calculation_date) THEN
1247: l_last_anniversary := TO_DATE(TO_CHAR(l_base_anniversary,'DDMM')||TO_CHAR(p_calculation_date,'YYYY'),'DDMMYYYY');
1248: IF (l_last_anniversary > p_calculation_date) THEN
1249: l_last_anniversary := ADD_MONTHS(l_last_anniversary,-12);
1250: END IF;
1251: hr_utility.trace(' return: ' || to_char(l_last_anniversary,'dd Mon yyyy')) ;
1252: hr_utility.trace('Out: ' || l_proc) ;
1253: RETURN l_last_anniversary;
1254:
1255: END;
1248: IF (l_last_anniversary > p_calculation_date) THEN
1249: l_last_anniversary := ADD_MONTHS(l_last_anniversary,-12);
1250: END IF;
1251: hr_utility.trace(' return: ' || to_char(l_last_anniversary,'dd Mon yyyy')) ;
1252: hr_utility.trace('Out: ' || l_proc) ;
1253: RETURN l_last_anniversary;
1254:
1255: END;
1256:
1295: l_annual_entitlement NUMBER := 0;
1296: l_years_service NUMBER := 0;
1297:
1298: BEGIN
1299: hr_utility.trace('In: ' || l_proc) ;
1300: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1301: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1302: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1303:
1296: l_years_service NUMBER := 0;
1297:
1298: BEGIN
1299: hr_utility.trace('In: ' || l_proc) ;
1300: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1301: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1302: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1303:
1304:
1297:
1298: BEGIN
1299: hr_utility.trace('In: ' || l_proc) ;
1300: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1301: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1302: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1303:
1304:
1305: l_accrual_plan_id := hr_nz_holidays.get_annual_leave_plan
1298: BEGIN
1299: hr_utility.trace('In: ' || l_proc) ;
1300: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1301: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1302: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1303:
1304:
1305: l_accrual_plan_id := hr_nz_holidays.get_annual_leave_plan
1306: (p_business_group_id => p_business_group_id
1308: ,p_assignment_id => p_assignment_id);
1309:
1310: IF (l_accrual_plan_id IS NULL)
1311: THEN
1312: hr_utility.trace('Crash Out: ' || l_proc) ;
1313: hr_utility.set_message(801,'HR_NZ_INVALID_ACCRUAL_PLAN');
1314: hr_utility.raise_error;
1315: END IF;
1316:
1309:
1310: IF (l_accrual_plan_id IS NULL)
1311: THEN
1312: hr_utility.trace('Crash Out: ' || l_proc) ;
1313: hr_utility.set_message(801,'HR_NZ_INVALID_ACCRUAL_PLAN');
1314: hr_utility.raise_error;
1315: END IF;
1316:
1317: l_continuous_service := hr_nz_holidays.get_continuous_service_date
1310: IF (l_accrual_plan_id IS NULL)
1311: THEN
1312: hr_utility.trace('Crash Out: ' || l_proc) ;
1313: hr_utility.set_message(801,'HR_NZ_INVALID_ACCRUAL_PLAN');
1314: hr_utility.raise_error;
1315: END IF;
1316:
1317: l_continuous_service := hr_nz_holidays.get_continuous_service_date
1318: (p_business_group_id => p_business_group_id
1320: ,p_calculation_date => p_calculation_date
1321: ,p_assignment_id => p_assignment_id);
1322: IF (l_continuous_service IS NULL)
1323: THEN
1324: hr_utility.trace('Crash Out: ' || l_proc) ;
1325: hr_utility.set_message(801,'HR_NZ_INVALID_SERVICE_DATE');
1326: hr_utility.raise_error;
1327: END IF;
1328:
1321: ,p_assignment_id => p_assignment_id);
1322: IF (l_continuous_service IS NULL)
1323: THEN
1324: hr_utility.trace('Crash Out: ' || l_proc) ;
1325: hr_utility.set_message(801,'HR_NZ_INVALID_SERVICE_DATE');
1326: hr_utility.raise_error;
1327: END IF;
1328:
1329: -- Get the payroll end date
1322: IF (l_continuous_service IS NULL)
1323: THEN
1324: hr_utility.trace('Crash Out: ' || l_proc) ;
1325: hr_utility.set_message(801,'HR_NZ_INVALID_SERVICE_DATE');
1326: hr_utility.raise_error;
1327: END IF;
1328:
1329: -- Get the payroll end date
1330:
1332: FETCH csr_get_payroll_end_date INTO l_payroll_period_end;
1333: IF (csr_get_payroll_end_date%NOTFOUND)
1334: THEN
1335: CLOSE csr_get_payroll_end_date;
1336: hr_utility.trace('Crash Out: ' || l_proc) ;
1337: hr_utility.set_message(801,'HR_NZ_PAYROLL_DATE_NOT_FOUND');
1338: hr_utility.raise_error;
1339: END IF;
1340: CLOSE csr_get_payroll_end_date;
1333: IF (csr_get_payroll_end_date%NOTFOUND)
1334: THEN
1335: CLOSE csr_get_payroll_end_date;
1336: hr_utility.trace('Crash Out: ' || l_proc) ;
1337: hr_utility.set_message(801,'HR_NZ_PAYROLL_DATE_NOT_FOUND');
1338: hr_utility.raise_error;
1339: END IF;
1340: CLOSE csr_get_payroll_end_date;
1341:
1334: THEN
1335: CLOSE csr_get_payroll_end_date;
1336: hr_utility.trace('Crash Out: ' || l_proc) ;
1337: hr_utility.set_message(801,'HR_NZ_PAYROLL_DATE_NOT_FOUND');
1338: hr_utility.raise_error;
1339: END IF;
1340: CLOSE csr_get_payroll_end_date;
1341:
1342: -- Calculate the number of years service
1349: FETCH csr_get_accrual_band INTO l_annual_entitlement;
1350: IF (csr_get_accrual_band%NOTFOUND)
1351: THEN
1352: CLOSE csr_get_accrual_band;
1353: hr_utility.trace('Crash Out: ' || l_proc) ;
1354: hr_utility.set_message(801,'HR_NZ_ACCRUAL_BAND_NOT_FOUND');
1355: hr_utility.raise_error;
1356: END IF;
1357: CLOSE csr_get_accrual_band;
1350: IF (csr_get_accrual_band%NOTFOUND)
1351: THEN
1352: CLOSE csr_get_accrual_band;
1353: hr_utility.trace('Crash Out: ' || l_proc) ;
1354: hr_utility.set_message(801,'HR_NZ_ACCRUAL_BAND_NOT_FOUND');
1355: hr_utility.raise_error;
1356: END IF;
1357: CLOSE csr_get_accrual_band;
1358: hr_utility.trace(' return: ' || to_char(l_annual_entitlement)) ;
1351: THEN
1352: CLOSE csr_get_accrual_band;
1353: hr_utility.trace('Crash Out: ' || l_proc) ;
1354: hr_utility.set_message(801,'HR_NZ_ACCRUAL_BAND_NOT_FOUND');
1355: hr_utility.raise_error;
1356: END IF;
1357: CLOSE csr_get_accrual_band;
1358: hr_utility.trace(' return: ' || to_char(l_annual_entitlement)) ;
1359: hr_utility.trace('Out: ' || l_proc) ;
1354: hr_utility.set_message(801,'HR_NZ_ACCRUAL_BAND_NOT_FOUND');
1355: hr_utility.raise_error;
1356: END IF;
1357: CLOSE csr_get_accrual_band;
1358: hr_utility.trace(' return: ' || to_char(l_annual_entitlement)) ;
1359: hr_utility.trace('Out: ' || l_proc) ;
1360: RETURN l_annual_entitlement;
1361:
1362: END;
1355: hr_utility.raise_error;
1356: END IF;
1357: CLOSE csr_get_accrual_band;
1358: hr_utility.trace(' return: ' || to_char(l_annual_entitlement)) ;
1359: hr_utility.trace('Out: ' || l_proc) ;
1360: RETURN l_annual_entitlement;
1361:
1362: END;
1363:
1379: l_plan_id NUMBER;
1380: l_total_absence NUMBER;
1381:
1382: BEGIN
1383: hr_utility.trace('In: ' || l_proc) ;
1384: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1385: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1386: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1387: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1380: l_total_absence NUMBER;
1381:
1382: BEGIN
1383: hr_utility.trace('In: ' || l_proc) ;
1384: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1385: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1386: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1387: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1388: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
1381:
1382: BEGIN
1383: hr_utility.trace('In: ' || l_proc) ;
1384: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1385: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1386: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1387: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1388: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
1389:
1382: BEGIN
1383: hr_utility.trace('In: ' || l_proc) ;
1384: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1385: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1386: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1387: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1388: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
1389:
1390: l_plan_id := hr_nz_holidays.get_annual_leave_plan
1383: hr_utility.trace('In: ' || l_proc) ;
1384: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1385: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1386: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1387: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1388: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
1389:
1390: l_plan_id := hr_nz_holidays.get_annual_leave_plan
1391: (p_assignment_id => p_assignment_id
1384: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1385: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1386: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1387: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1388: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
1389:
1390: l_plan_id := hr_nz_holidays.get_annual_leave_plan
1391: (p_assignment_id => p_assignment_id
1392: ,p_business_group_id => p_business_group_id
1393: ,p_calculation_date => p_calculation_date);
1394:
1395: IF (l_plan_id IS NULL)
1396: THEN
1397: hr_utility.trace(' ** Accrual Plan Not Found **');
1398: hr_utility.trace('Crash Out: ' || l_proc) ;
1399: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
1400: hr_utility.raise_error;
1401: END IF;
1394:
1395: IF (l_plan_id IS NULL)
1396: THEN
1397: hr_utility.trace(' ** Accrual Plan Not Found **');
1398: hr_utility.trace('Crash Out: ' || l_proc) ;
1399: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
1400: hr_utility.raise_error;
1401: END IF;
1402: hr_utility.set_location(l_proc,15);
1395: IF (l_plan_id IS NULL)
1396: THEN
1397: hr_utility.trace(' ** Accrual Plan Not Found **');
1398: hr_utility.trace('Crash Out: ' || l_proc) ;
1399: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
1400: hr_utility.raise_error;
1401: END IF;
1402: hr_utility.set_location(l_proc,15);
1403: l_total_absence := per_accrual_calc_functions.get_absence
1396: THEN
1397: hr_utility.trace(' ** Accrual Plan Not Found **');
1398: hr_utility.trace('Crash Out: ' || l_proc) ;
1399: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
1400: hr_utility.raise_error;
1401: END IF;
1402: hr_utility.set_location(l_proc,15);
1403: l_total_absence := per_accrual_calc_functions.get_absence
1404: (p_assignment_id => p_assignment_id
1398: hr_utility.trace('Crash Out: ' || l_proc) ;
1399: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
1400: hr_utility.raise_error;
1401: END IF;
1402: hr_utility.set_location(l_proc,15);
1403: l_total_absence := per_accrual_calc_functions.get_absence
1404: (p_assignment_id => p_assignment_id
1405: ,p_plan_id => l_plan_id
1406: ,p_calculation_date => p_end_date
1405: ,p_plan_id => l_plan_id
1406: ,p_calculation_date => p_end_date
1407: ,p_start_date => p_start_date);
1408:
1409: hr_utility.trace(' return: ' || to_char(nvl(l_total_absence, 0))) ;
1410: hr_utility.trace('Out: ' || l_proc) ;
1411: RETURN NVL(l_total_absence, 0);
1412:
1413: END get_annual_leave_taken;
1406: ,p_calculation_date => p_end_date
1407: ,p_start_date => p_start_date);
1408:
1409: hr_utility.trace(' return: ' || to_char(nvl(l_total_absence, 0))) ;
1410: hr_utility.trace('Out: ' || l_proc) ;
1411: RETURN NVL(l_total_absence, 0);
1412:
1413: END get_annual_leave_taken;
1414:
1456: and tp.regular_payment_date < add_months(p_start_of_year, 12) ;
1457:
1458: begin
1459:
1460: hr_utility.trace('In: ' || l_proc) ;
1461: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1462: hr_utility.trace(' p_start_of_year_date: ' || to_char(p_start_of_year_date,'dd Mon yyyy')) ;
1463:
1464: open c_number_of_leave_weeks(p_assignment_id
1457:
1458: begin
1459:
1460: hr_utility.trace('In: ' || l_proc) ;
1461: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1462: hr_utility.trace(' p_start_of_year_date: ' || to_char(p_start_of_year_date,'dd Mon yyyy')) ;
1463:
1464: open c_number_of_leave_weeks(p_assignment_id
1465: ,p_start_of_year_date) ;
1458: begin
1459:
1460: hr_utility.trace('In: ' || l_proc) ;
1461: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1462: hr_utility.trace(' p_start_of_year_date: ' || to_char(p_start_of_year_date,'dd Mon yyyy')) ;
1463:
1464: open c_number_of_leave_weeks(p_assignment_id
1465: ,p_start_of_year_date) ;
1466: fetch c_number_of_leave_weeks
1471: end if ;
1472: close c_number_of_leave_weeks ;
1473: l_number_of_weeks := 52 - l_number_of_leave_weeks ;
1474:
1475: hr_utility.trace(' return: ' || to_char(l_number_of_weeks)) ;
1476: hr_utility.trace('Out: ' || l_proc) ;
1477:
1478: return l_number_of_weeks ;
1479:
1472: close c_number_of_leave_weeks ;
1473: l_number_of_weeks := 52 - l_number_of_leave_weeks ;
1474:
1475: hr_utility.trace(' return: ' || to_char(l_number_of_weeks)) ;
1476: hr_utility.trace('Out: ' || l_proc) ;
1477:
1478: return l_number_of_weeks ;
1479:
1480: end num_weeks_for_avg_earnings ;
1515: l_holiday_year_end_date_iv_id NUMBER;
1516: l_hours_accrued_iv_id NUMBER;
1517:
1518: BEGIN
1519: hr_utility.trace('In: ' || l_proc) ;
1520: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1521: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1522: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1523:
1516: l_hours_accrued_iv_id NUMBER;
1517:
1518: BEGIN
1519: hr_utility.trace('In: ' || l_proc) ;
1520: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1521: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1522: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1523:
1524: -- Find the Accrual Record Element
1517:
1518: BEGIN
1519: hr_utility.trace('In: ' || l_proc) ;
1520: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1521: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1522: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1523:
1524: -- Find the Accrual Record Element
1525: OPEN csr_accrual_record_element(p_calculation_date);
1518: BEGIN
1519: hr_utility.trace('In: ' || l_proc) ;
1520: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1521: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1522: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1523:
1524: -- Find the Accrual Record Element
1525: OPEN csr_accrual_record_element(p_calculation_date);
1526: FETCH csr_accrual_record_element INTO l_element_type_id;
1526: FETCH csr_accrual_record_element INTO l_element_type_id;
1527: IF (csr_accrual_record_element%NOTFOUND)
1528: THEN
1529: CLOSE csr_accrual_record_element;
1530: hr_utility.trace('Crash Out: ' || l_proc) ;
1531: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1532: hr_utility.raise_error;
1533: END IF;
1534: CLOSE csr_accrual_record_element;
1527: IF (csr_accrual_record_element%NOTFOUND)
1528: THEN
1529: CLOSE csr_accrual_record_element;
1530: hr_utility.trace('Crash Out: ' || l_proc) ;
1531: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1532: hr_utility.raise_error;
1533: END IF;
1534: CLOSE csr_accrual_record_element;
1535: hr_utility.set_location(l_proc,10);
1528: THEN
1529: CLOSE csr_accrual_record_element;
1530: hr_utility.trace('Crash Out: ' || l_proc) ;
1531: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1532: hr_utility.raise_error;
1533: END IF;
1534: CLOSE csr_accrual_record_element;
1535: hr_utility.set_location(l_proc,10);
1536:
1531: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
1532: hr_utility.raise_error;
1533: END IF;
1534: CLOSE csr_accrual_record_element;
1535: hr_utility.set_location(l_proc,10);
1536:
1537: -- Get the input value id for each input value on the Accrual Record Element
1538: FOR rec_input_values in csr_accrual_record_iv(l_element_type_id, p_calculation_date)
1539: LOOP
1552: IF ( l_accual_plan_name_iv_id IS NULL OR
1553: l_holiday_year_end_date_iv_id IS NULL OR
1554: l_hours_accrued_iv_id IS NULL)
1555: THEN
1556: hr_utility.trace('Crash Out: ' || l_proc) ;
1557: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
1558: hr_utility.raise_error;
1559: END IF;
1560: hr_utility.set_location(l_proc, 15);
1553: l_holiday_year_end_date_iv_id IS NULL OR
1554: l_hours_accrued_iv_id IS NULL)
1555: THEN
1556: hr_utility.trace('Crash Out: ' || l_proc) ;
1557: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
1558: hr_utility.raise_error;
1559: END IF;
1560: hr_utility.set_location(l_proc, 15);
1561:
1554: l_hours_accrued_iv_id IS NULL)
1555: THEN
1556: hr_utility.trace('Crash Out: ' || l_proc) ;
1557: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
1558: hr_utility.raise_error;
1559: END IF;
1560: hr_utility.set_location(l_proc, 15);
1561:
1562: hr_utility.trace(' p_element_type_id: ' || to_char(p_element_type_id)) ;
1556: hr_utility.trace('Crash Out: ' || l_proc) ;
1557: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
1558: hr_utility.raise_error;
1559: END IF;
1560: hr_utility.set_location(l_proc, 15);
1561:
1562: hr_utility.trace(' p_element_type_id: ' || to_char(p_element_type_id)) ;
1563: p_element_type_id := l_element_type_id;
1564: hr_utility.trace(' p_accual_plan_name_iv_id: ' || to_char(p_accual_plan_name_iv_id)) ;
1558: hr_utility.raise_error;
1559: END IF;
1560: hr_utility.set_location(l_proc, 15);
1561:
1562: hr_utility.trace(' p_element_type_id: ' || to_char(p_element_type_id)) ;
1563: p_element_type_id := l_element_type_id;
1564: hr_utility.trace(' p_accual_plan_name_iv_id: ' || to_char(p_accual_plan_name_iv_id)) ;
1565: p_accual_plan_name_iv_id := l_accual_plan_name_iv_id;
1566: hr_utility.trace(' p_holiday_year_end_date_iv_id: ' || to_char(p_holiday_year_end_date_iv_id)) ;
1560: hr_utility.set_location(l_proc, 15);
1561:
1562: hr_utility.trace(' p_element_type_id: ' || to_char(p_element_type_id)) ;
1563: p_element_type_id := l_element_type_id;
1564: hr_utility.trace(' p_accual_plan_name_iv_id: ' || to_char(p_accual_plan_name_iv_id)) ;
1565: p_accual_plan_name_iv_id := l_accual_plan_name_iv_id;
1566: hr_utility.trace(' p_holiday_year_end_date_iv_id: ' || to_char(p_holiday_year_end_date_iv_id)) ;
1567: p_holiday_year_end_date_iv_id := l_holiday_year_end_date_iv_id;
1568: hr_utility.trace(' p_hours_accrued_iv_id: ' || to_char(p_hours_accrued_iv_id)) ;
1562: hr_utility.trace(' p_element_type_id: ' || to_char(p_element_type_id)) ;
1563: p_element_type_id := l_element_type_id;
1564: hr_utility.trace(' p_accual_plan_name_iv_id: ' || to_char(p_accual_plan_name_iv_id)) ;
1565: p_accual_plan_name_iv_id := l_accual_plan_name_iv_id;
1566: hr_utility.trace(' p_holiday_year_end_date_iv_id: ' || to_char(p_holiday_year_end_date_iv_id)) ;
1567: p_holiday_year_end_date_iv_id := l_holiday_year_end_date_iv_id;
1568: hr_utility.trace(' p_hours_accrued_iv_id: ' || to_char(p_hours_accrued_iv_id)) ;
1569: p_hours_accrued_iv_id := l_hours_accrued_iv_id;
1570:
1564: hr_utility.trace(' p_accual_plan_name_iv_id: ' || to_char(p_accual_plan_name_iv_id)) ;
1565: p_accual_plan_name_iv_id := l_accual_plan_name_iv_id;
1566: hr_utility.trace(' p_holiday_year_end_date_iv_id: ' || to_char(p_holiday_year_end_date_iv_id)) ;
1567: p_holiday_year_end_date_iv_id := l_holiday_year_end_date_iv_id;
1568: hr_utility.trace(' p_hours_accrued_iv_id: ' || to_char(p_hours_accrued_iv_id)) ;
1569: p_hours_accrued_iv_id := l_hours_accrued_iv_id;
1570:
1571: hr_utility.trace(' return: 0') ;
1572: hr_utility.trace('Out: ' || l_proc) ;
1567: p_holiday_year_end_date_iv_id := l_holiday_year_end_date_iv_id;
1568: hr_utility.trace(' p_hours_accrued_iv_id: ' || to_char(p_hours_accrued_iv_id)) ;
1569: p_hours_accrued_iv_id := l_hours_accrued_iv_id;
1570:
1571: hr_utility.trace(' return: 0') ;
1572: hr_utility.trace('Out: ' || l_proc) ;
1573: RETURN 0;
1574:
1575: EXCEPTION
1568: hr_utility.trace(' p_hours_accrued_iv_id: ' || to_char(p_hours_accrued_iv_id)) ;
1569: p_hours_accrued_iv_id := l_hours_accrued_iv_id;
1570:
1571: hr_utility.trace(' return: 0') ;
1572: hr_utility.trace('Out: ' || l_proc) ;
1573: RETURN 0;
1574:
1575: EXCEPTION
1576: WHEN others
1574:
1575: EXCEPTION
1576: WHEN others
1577: THEN
1578: hr_utility.trace('Crash Out: ' || l_proc) ;
1579: RETURN 1;
1580: END get_ar_element_details;
1581:
1582: /*---------------------------------------------------------------------
1688: l_pleave_taken number := 0;
1689: l_proc varchar2(72) := 'get_parental_leaves_taken' ;
1690:
1691: BEGIN
1692: hr_utility.trace('In: ' || l_proc);
1693: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1694: hr_utility.trace(' p_business_group_id: '||to_char(p_business_group_id));
1695: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1696: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
1689: l_proc varchar2(72) := 'get_parental_leaves_taken' ;
1690:
1691: BEGIN
1692: hr_utility.trace('In: ' || l_proc);
1693: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1694: hr_utility.trace(' p_business_group_id: '||to_char(p_business_group_id));
1695: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1696: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
1697:
1690:
1691: BEGIN
1692: hr_utility.trace('In: ' || l_proc);
1693: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1694: hr_utility.trace(' p_business_group_id: '||to_char(p_business_group_id));
1695: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1696: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
1697:
1698: open csr_parental_leaves_taken(p_assignment_id,
1691: BEGIN
1692: hr_utility.trace('In: ' || l_proc);
1693: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1694: hr_utility.trace(' p_business_group_id: '||to_char(p_business_group_id));
1695: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1696: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
1697:
1698: open csr_parental_leaves_taken(p_assignment_id,
1699: p_business_group_id,
1692: hr_utility.trace('In: ' || l_proc);
1693: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1694: hr_utility.trace(' p_business_group_id: '||to_char(p_business_group_id));
1695: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1696: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
1697:
1698: open csr_parental_leaves_taken(p_assignment_id,
1699: p_business_group_id,
1700: p_start_date,
1702: fetch csr_parental_leaves_taken into l_pleave_taken;
1703:
1704: if csr_parental_leaves_taken%FOUND then
1705: close csr_parental_leaves_taken;
1706: hr_utility.trace(' l_pleave_taken: ' || to_char(l_pleave_taken));
1707: hr_utility.trace('Out: ' || l_proc);
1708: return 1;
1709: end if;
1710: close csr_parental_leaves_taken;
1703:
1704: if csr_parental_leaves_taken%FOUND then
1705: close csr_parental_leaves_taken;
1706: hr_utility.trace(' l_pleave_taken: ' || to_char(l_pleave_taken));
1707: hr_utility.trace('Out: ' || l_proc);
1708: return 1;
1709: end if;
1710: close csr_parental_leaves_taken;
1711: hr_utility.trace(' No parental leave taken');
1707: hr_utility.trace('Out: ' || l_proc);
1708: return 1;
1709: end if;
1710: close csr_parental_leaves_taken;
1711: hr_utility.trace(' No parental leave taken');
1712: hr_utility.trace('Out: ' || l_proc);
1713: return 0;
1714: END get_parental_leaves_taken;
1715: /* Bug 2798048-NZ Parental leave, End.*/
1708: return 1;
1709: end if;
1710: close csr_parental_leaves_taken;
1711: hr_utility.trace(' No parental leave taken');
1712: hr_utility.trace('Out: ' || l_proc);
1713: return 0;
1714: END get_parental_leaves_taken;
1715: /* Bug 2798048-NZ Parental leave, End.*/
1716:
1735: l_accrual_adj NUMBER;
1736: l_entitlement_adj NUMBER;
1737:
1738: BEGIN
1739: hr_utility.trace(' In: ' || l_proc) ;
1740:
1741: -- find what the accrual was as at the holiday year end date supplied
1742:
1743: per_accrual_calc_functions.get_accrual
1764: ,p_start_date => l_start_date
1765: ,p_end_date => l_end_date));
1766:
1767:
1768: hr_utility.trace('ven_others_ent= '||to_char(l_entitlement_adj));
1769:
1770: l_adjustment_element := 'Accrual Adjustment Element';
1771: l_accrual_adj:= (get_adjustment_values(
1772: p_assignment_id => p_assignment_id
1776: ,p_start_date => l_start_date
1777: ,p_end_date => l_end_date));
1778:
1779:
1780: hr_utility.trace('ven_others_acc= '||to_char(l_accrual_adj));
1781:
1782:
1783: l_other := per_accrual_calc_functions.get_other_net_contribution
1784: (p_assignment_id => p_assignment_id
1787: ,p_calculation_date => p_holiday_year_end_date);
1788:
1789: l_total := l_accrual + l_other +l_accrual_adj + l_entitlement_adj;
1790:
1791: hr_utility.trace(' Out: ' || l_proc) ;
1792: RETURN l_total ;
1793:
1794: END get_total_annual_leave_accrued;
1795:
1793:
1794: END get_total_annual_leave_accrued;
1795:
1796: BEGIN
1797: hr_utility.trace('In: ' || l_proc) ;
1798: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1799: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1800: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1801: hr_utility.trace(' p_entitled_to_hours: ' || to_char(p_entitled_to_hours)) ;
1794: END get_total_annual_leave_accrued;
1795:
1796: BEGIN
1797: hr_utility.trace('In: ' || l_proc) ;
1798: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1799: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1800: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1801: hr_utility.trace(' p_entitled_to_hours: ' || to_char(p_entitled_to_hours)) ;
1802: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1795:
1796: BEGIN
1797: hr_utility.trace('In: ' || l_proc) ;
1798: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1799: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1800: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1801: hr_utility.trace(' p_entitled_to_hours: ' || to_char(p_entitled_to_hours)) ;
1802: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1803: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date,'dd Mon yyyy')) ;
1796: BEGIN
1797: hr_utility.trace('In: ' || l_proc) ;
1798: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1799: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1800: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1801: hr_utility.trace(' p_entitled_to_hours: ' || to_char(p_entitled_to_hours)) ;
1802: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1803: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date,'dd Mon yyyy')) ;
1804: hr_utility.trace(' p_working_hours: ' || to_char(p_working_hours)) ;
1797: hr_utility.trace('In: ' || l_proc) ;
1798: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1799: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1800: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1801: hr_utility.trace(' p_entitled_to_hours: ' || to_char(p_entitled_to_hours)) ;
1802: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1803: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date,'dd Mon yyyy')) ;
1804: hr_utility.trace(' p_working_hours: ' || to_char(p_working_hours)) ;
1805:
1798: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
1799: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1800: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1801: hr_utility.trace(' p_entitled_to_hours: ' || to_char(p_entitled_to_hours)) ;
1802: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1803: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date,'dd Mon yyyy')) ;
1804: hr_utility.trace(' p_working_hours: ' || to_char(p_working_hours)) ;
1805:
1806: l_anniversary_date := p_anniversary_date ;
1799: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
1800: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1801: hr_utility.trace(' p_entitled_to_hours: ' || to_char(p_entitled_to_hours)) ;
1802: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1803: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date,'dd Mon yyyy')) ;
1804: hr_utility.trace(' p_working_hours: ' || to_char(p_working_hours)) ;
1805:
1806: l_anniversary_date := p_anniversary_date ;
1807: l_hours_left_to_pay := p_entitled_to_hours;
1800: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'dd Mon yyyy')) ;
1801: hr_utility.trace(' p_entitled_to_hours: ' || to_char(p_entitled_to_hours)) ;
1802: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
1803: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date,'dd Mon yyyy')) ;
1804: hr_utility.trace(' p_working_hours: ' || to_char(p_working_hours)) ;
1805:
1806: l_anniversary_date := p_anniversary_date ;
1807: l_hours_left_to_pay := p_entitled_to_hours;
1808:
1812: ,p_calculation_date => p_calculation_date);
1813:
1814: IF (l_plan_id IS NULL)
1815: THEN
1816: hr_utility.trace('Crash Out: ' || l_proc) ;
1817: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
1818: hr_utility.raise_error;
1819: END IF;
1820:
1813:
1814: IF (l_plan_id IS NULL)
1815: THEN
1816: hr_utility.trace('Crash Out: ' || l_proc) ;
1817: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
1818: hr_utility.raise_error;
1819: END IF;
1820:
1821: -- find total leave taken up until just before this leave
1814: IF (l_plan_id IS NULL)
1815: THEN
1816: hr_utility.trace('Crash Out: ' || l_proc) ;
1817: hr_utility.set_message(801,'HR_NZ_ACCRUAL_PLAN_NOT_FOUND');
1818: hr_utility.raise_error;
1819: END IF;
1820:
1821: -- find total leave taken up until just before this leave
1822:
1826: ,p_calculation_date => p_calculation_date
1827: ,p_start_date => p_anniversary_date
1828: ,p_end_date => p_start_date - 1) ;
1829:
1830: hr_utility.trace(' l_total_annual_leave_taken: ' || to_char(l_total_annual_leave_taken)) ;
1831: hr_utility.trace(' l_anniversary_date: ' || to_char(l_anniversary_date, 'dd Mon yyyy')) ;
1832:
1833: WHILE (l_anniversary_date <= p_start_date)
1834: LOOP
1827: ,p_start_date => p_anniversary_date
1828: ,p_end_date => p_start_date - 1) ;
1829:
1830: hr_utility.trace(' l_total_annual_leave_taken: ' || to_char(l_total_annual_leave_taken)) ;
1831: hr_utility.trace(' l_anniversary_date: ' || to_char(l_anniversary_date, 'dd Mon yyyy')) ;
1832:
1833: WHILE (l_anniversary_date <= p_start_date)
1834: LOOP
1835:
1839: ,p_plan_id => l_plan_id
1840: ,p_business_group_id => p_business_group_id
1841: ,p_payroll_id => p_payroll_id) ;
1842:
1843: hr_utility.trace(' l_total_annual_leave_accrual: ' || to_char(l_total_annual_leave_accrual)) ;
1844:
1845: IF (l_total_annual_leave_accrual >= l_total_annual_leave_taken)
1846: THEN
1847: l_invalid_exit := FALSE;
1849: EXIT ;
1850: END IF;
1851:
1852: l_anniversary_date := ADD_MONTHS(l_anniversary_date,12);
1853: hr_utility.trace(' l_anniversary_date: ' || to_char(l_anniversary_date, 'dd Mon yyyy')) ;
1854:
1855: END LOOP;
1856:
1857: IF (l_invalid_exit)
1855: END LOOP;
1856:
1857: IF (l_invalid_exit)
1858: THEN
1859: hr_utility.trace(' ** No entitled annual leave found **');
1860: hr_utility.trace('Crash Out: ' || l_proc) ;
1861: hr_utility.set_message(801,'HR_NZ_ENTITLED_LEAVE_NOT_FOUND');
1862: hr_utility.raise_error;
1863: END IF;
1856:
1857: IF (l_invalid_exit)
1858: THEN
1859: hr_utility.trace(' ** No entitled annual leave found **');
1860: hr_utility.trace('Crash Out: ' || l_proc) ;
1861: hr_utility.set_message(801,'HR_NZ_ENTITLED_LEAVE_NOT_FOUND');
1862: hr_utility.raise_error;
1863: END IF;
1864:
1857: IF (l_invalid_exit)
1858: THEN
1859: hr_utility.trace(' ** No entitled annual leave found **');
1860: hr_utility.trace('Crash Out: ' || l_proc) ;
1861: hr_utility.set_message(801,'HR_NZ_ENTITLED_LEAVE_NOT_FOUND');
1862: hr_utility.raise_error;
1863: END IF;
1864:
1865:
1858: THEN
1859: hr_utility.trace(' ** No entitled annual leave found **');
1860: hr_utility.trace('Crash Out: ' || l_proc) ;
1861: hr_utility.set_message(801,'HR_NZ_ENTITLED_LEAVE_NOT_FOUND');
1862: hr_utility.raise_error;
1863: END IF;
1864:
1865:
1866: /* Bug 2230110 cursor get_pay_period_start_date is used to get the pay period start date. */
1898: CLOSE csr_gross_earning_balance;
1899:
1900: IF (l_balance_type_id IS NULL)
1901: THEN
1902: hr_utility.trace('Crash Out: ' || l_proc) ;
1903: hr_utility.set_message(801,'HR_NZ_BALANCE_NOT_FOUND');
1904: hr_utility.raise_error;
1905: END IF;
1906:
1899:
1900: IF (l_balance_type_id IS NULL)
1901: THEN
1902: hr_utility.trace('Crash Out: ' || l_proc) ;
1903: hr_utility.set_message(801,'HR_NZ_BALANCE_NOT_FOUND');
1904: hr_utility.raise_error;
1905: END IF;
1906:
1907: -- Changed the parameter to p_calculation_date. Bug #2090809
1900: IF (l_balance_type_id IS NULL)
1901: THEN
1902: hr_utility.trace('Crash Out: ' || l_proc) ;
1903: hr_utility.set_message(801,'HR_NZ_BALANCE_NOT_FOUND');
1904: hr_utility.raise_error;
1905: END IF;
1906:
1907: -- Changed the parameter to p_calculation_date. Bug #2090809
1908: /* Bug# 2185116 --> Changed the calculation date to anniversary date-1 */
1910: l_gross_earnings := hr_nzbal.calc_asg_hol_ytd_date
1911: (p_assignment_id => p_assignment_id
1912: ,p_balance_type_id => l_balance_type_id
1913: ,p_effective_date => l_anniversary_date-1);
1914: hr_utility.trace(' Year Ending: ' || to_char(l_anniversary_date - 1,'dd Mon yyyy')) ;
1915: hr_utility.trace(' Gross Earnings for Holiday Pay: ' || to_char(l_gross_earnings)) ;
1916:
1917: l_rate := l_gross_earnings / l_num_weeks_in_year / p_working_hours;
1918: l_hours_to_pay := LEAST(l_hours_left_to_pay, l_total_annual_leave_accrual - l_prev_total_accrual);
1911: (p_assignment_id => p_assignment_id
1912: ,p_balance_type_id => l_balance_type_id
1913: ,p_effective_date => l_anniversary_date-1);
1914: hr_utility.trace(' Year Ending: ' || to_char(l_anniversary_date - 1,'dd Mon yyyy')) ;
1915: hr_utility.trace(' Gross Earnings for Holiday Pay: ' || to_char(l_gross_earnings)) ;
1916:
1917: l_rate := l_gross_earnings / l_num_weeks_in_year / p_working_hours;
1918: l_hours_to_pay := LEAST(l_hours_left_to_pay, l_total_annual_leave_accrual - l_prev_total_accrual);
1919: hr_utility.trace(' Rate: ' || to_char(l_rate)) ;
1915: hr_utility.trace(' Gross Earnings for Holiday Pay: ' || to_char(l_gross_earnings)) ;
1916:
1917: l_rate := l_gross_earnings / l_num_weeks_in_year / p_working_hours;
1918: l_hours_to_pay := LEAST(l_hours_left_to_pay, l_total_annual_leave_accrual - l_prev_total_accrual);
1919: hr_utility.trace(' Rate: ' || to_char(l_rate)) ;
1920: hr_utility.trace(' Hours Left to Pay: ' || to_char(l_hours_left_to_pay)) ;
1921: hr_utility.trace(' Total Annual Leave Accrual: ' || to_char(l_total_annual_leave_accrual)) ;
1922: hr_utility.trace(' Previous Total Accrual: ' || to_char(l_prev_total_accrual)) ;
1923: hr_utility.trace(' Hours to Pay: ' || to_char(l_hours_to_pay)) ;
1916:
1917: l_rate := l_gross_earnings / l_num_weeks_in_year / p_working_hours;
1918: l_hours_to_pay := LEAST(l_hours_left_to_pay, l_total_annual_leave_accrual - l_prev_total_accrual);
1919: hr_utility.trace(' Rate: ' || to_char(l_rate)) ;
1920: hr_utility.trace(' Hours Left to Pay: ' || to_char(l_hours_left_to_pay)) ;
1921: hr_utility.trace(' Total Annual Leave Accrual: ' || to_char(l_total_annual_leave_accrual)) ;
1922: hr_utility.trace(' Previous Total Accrual: ' || to_char(l_prev_total_accrual)) ;
1923: hr_utility.trace(' Hours to Pay: ' || to_char(l_hours_to_pay)) ;
1924: hr_utility.trace(' Annual Leave Pay: ' || to_char(l_annual_leave_pay)) ;
1917: l_rate := l_gross_earnings / l_num_weeks_in_year / p_working_hours;
1918: l_hours_to_pay := LEAST(l_hours_left_to_pay, l_total_annual_leave_accrual - l_prev_total_accrual);
1919: hr_utility.trace(' Rate: ' || to_char(l_rate)) ;
1920: hr_utility.trace(' Hours Left to Pay: ' || to_char(l_hours_left_to_pay)) ;
1921: hr_utility.trace(' Total Annual Leave Accrual: ' || to_char(l_total_annual_leave_accrual)) ;
1922: hr_utility.trace(' Previous Total Accrual: ' || to_char(l_prev_total_accrual)) ;
1923: hr_utility.trace(' Hours to Pay: ' || to_char(l_hours_to_pay)) ;
1924: hr_utility.trace(' Annual Leave Pay: ' || to_char(l_annual_leave_pay)) ;
1925:
1918: l_hours_to_pay := LEAST(l_hours_left_to_pay, l_total_annual_leave_accrual - l_prev_total_accrual);
1919: hr_utility.trace(' Rate: ' || to_char(l_rate)) ;
1920: hr_utility.trace(' Hours Left to Pay: ' || to_char(l_hours_left_to_pay)) ;
1921: hr_utility.trace(' Total Annual Leave Accrual: ' || to_char(l_total_annual_leave_accrual)) ;
1922: hr_utility.trace(' Previous Total Accrual: ' || to_char(l_prev_total_accrual)) ;
1923: hr_utility.trace(' Hours to Pay: ' || to_char(l_hours_to_pay)) ;
1924: hr_utility.trace(' Annual Leave Pay: ' || to_char(l_annual_leave_pay)) ;
1925:
1926: /* Bug 2798048-NZ Parental leave, calculation changes for annual leave
1919: hr_utility.trace(' Rate: ' || to_char(l_rate)) ;
1920: hr_utility.trace(' Hours Left to Pay: ' || to_char(l_hours_left_to_pay)) ;
1921: hr_utility.trace(' Total Annual Leave Accrual: ' || to_char(l_total_annual_leave_accrual)) ;
1922: hr_utility.trace(' Previous Total Accrual: ' || to_char(l_prev_total_accrual)) ;
1923: hr_utility.trace(' Hours to Pay: ' || to_char(l_hours_to_pay)) ;
1924: hr_utility.trace(' Annual Leave Pay: ' || to_char(l_annual_leave_pay)) ;
1925:
1926: /* Bug 2798048-NZ Parental leave, calculation changes for annual leave
1927: falling in parental leave period.*/
1920: hr_utility.trace(' Hours Left to Pay: ' || to_char(l_hours_left_to_pay)) ;
1921: hr_utility.trace(' Total Annual Leave Accrual: ' || to_char(l_total_annual_leave_accrual)) ;
1922: hr_utility.trace(' Previous Total Accrual: ' || to_char(l_prev_total_accrual)) ;
1923: hr_utility.trace(' Hours to Pay: ' || to_char(l_hours_to_pay)) ;
1924: hr_utility.trace(' Annual Leave Pay: ' || to_char(l_annual_leave_pay)) ;
1925:
1926: /* Bug 2798048-NZ Parental leave, calculation changes for annual leave
1927: falling in parental leave period.*/
1928: l_parental_leave := get_parental_leaves_taken
1930: ,p_business_group_id => p_business_group_id
1931: ,p_start_date => l_prev_anniversary_date
1932: ,p_end_date => l_anniversary_date-1);
1933:
1934: hr_utility.trace(' Parental Leave Taken:' || to_char(l_parental_leave));
1935: if l_parental_leave = 1 then
1936: l_annual_leave_pay := l_annual_leave_pay + (l_hours_to_pay * l_rate);
1937: else
1938: /* Bug# 2185116 Included the check for greatest of Ordinary pay and
1939: Average Pay and the greatest value is returned */
1940: l_annual_leave_pay := l_annual_leave_pay + GREATEST((l_hours_to_pay * l_rate),(l_hours_to_pay*p_ordinary_rate));
1941: end if;
1942:
1943: hr_utility.trace(' Annual Leave Pay: ' || to_char(l_annual_leave_pay)) ;
1944: l_hours_left_to_pay := nvl(l_hours_left_to_pay,0) - round(nvl(l_hours_to_pay,0),3);
1945:
1946: hr_utility.trace(' Hours Left to Pay: ' || to_char(l_hours_left_to_pay)) ;
1947: EXIT WHEN (l_hours_left_to_pay = 0);
1942:
1943: hr_utility.trace(' Annual Leave Pay: ' || to_char(l_annual_leave_pay)) ;
1944: l_hours_left_to_pay := nvl(l_hours_left_to_pay,0) - round(nvl(l_hours_to_pay,0),3);
1945:
1946: hr_utility.trace(' Hours Left to Pay: ' || to_char(l_hours_left_to_pay)) ;
1947: EXIT WHEN (l_hours_left_to_pay = 0);
1948:
1949: /* Bug 2798048-NZ Parental leave, update the
1950: previous anniversary date*/
1965: ,p_plan_id => l_plan_id
1966: ,p_business_group_id => p_business_group_id
1967: ,p_payroll_id => p_payroll_id) ;
1968:
1969: hr_utility.trace(' Leave Taken: ' || to_char(l_taken)) ;
1970: hr_utility.trace(' Leave Accrued: ' || to_char(l_accrued)) ;
1971: l_total_annual_leave_accrual := l_accrued - l_taken;
1972:
1973: END LOOP;
1966: ,p_business_group_id => p_business_group_id
1967: ,p_payroll_id => p_payroll_id) ;
1968:
1969: hr_utility.trace(' Leave Taken: ' || to_char(l_taken)) ;
1970: hr_utility.trace(' Leave Accrued: ' || to_char(l_accrued)) ;
1971: l_total_annual_leave_accrual := l_accrued - l_taken;
1972:
1973: END LOOP;
1974:
1971: l_total_annual_leave_accrual := l_accrued - l_taken;
1972:
1973: END LOOP;
1974:
1975: hr_utility.trace(' return: ' || to_char(l_annual_leave_pay)) ;
1976: hr_utility.trace('Out: ' || l_proc) ;
1977: RETURN l_annual_leave_pay;
1978:
1979: END annual_leave_entitled_to_pay;
1972:
1973: END LOOP;
1974:
1975: hr_utility.trace(' return: ' || to_char(l_annual_leave_pay)) ;
1976: hr_utility.trace('Out: ' || l_proc) ;
1977: RETURN l_annual_leave_pay;
1978:
1979: END annual_leave_entitled_to_pay;
1980:
2159:
2160: begin
2161:
2162: -- trace input variables
2163: hr_utility.trace('In: ' || l_procedure_name) ;
2164: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
2165: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2166: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2167: hr_utility.trace(' p_asg_hours: ' || to_char(p_asg_hours)) ;
2160: begin
2161:
2162: -- trace input variables
2163: hr_utility.trace('In: ' || l_procedure_name) ;
2164: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
2165: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2166: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2167: hr_utility.trace(' p_asg_hours: ' || to_char(p_asg_hours)) ;
2168: hr_utility.trace(' p_year_end_date: ' || to_char(p_year_end_date, 'dd Mon yyyy')) ;
2161:
2162: -- trace input variables
2163: hr_utility.trace('In: ' || l_procedure_name) ;
2164: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
2165: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2166: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2167: hr_utility.trace(' p_asg_hours: ' || to_char(p_asg_hours)) ;
2168: hr_utility.trace(' p_year_end_date: ' || to_char(p_year_end_date, 'dd Mon yyyy')) ;
2169: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2162: -- trace input variables
2163: hr_utility.trace('In: ' || l_procedure_name) ;
2164: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
2165: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2166: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2167: hr_utility.trace(' p_asg_hours: ' || to_char(p_asg_hours)) ;
2168: hr_utility.trace(' p_year_end_date: ' || to_char(p_year_end_date, 'dd Mon yyyy')) ;
2169: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2170: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2163: hr_utility.trace('In: ' || l_procedure_name) ;
2164: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
2165: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2166: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2167: hr_utility.trace(' p_asg_hours: ' || to_char(p_asg_hours)) ;
2168: hr_utility.trace(' p_year_end_date: ' || to_char(p_year_end_date, 'dd Mon yyyy')) ;
2169: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2170: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2171:
2164: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
2165: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2166: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2167: hr_utility.trace(' p_asg_hours: ' || to_char(p_asg_hours)) ;
2168: hr_utility.trace(' p_year_end_date: ' || to_char(p_year_end_date, 'dd Mon yyyy')) ;
2169: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2170: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2171:
2172: -- get values for ANNUAL_LEAVE_IN_ADVANCE_HOURS_ASG_HOL_YTD and
2165: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2166: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2167: hr_utility.trace(' p_asg_hours: ' || to_char(p_asg_hours)) ;
2168: hr_utility.trace(' p_year_end_date: ' || to_char(p_year_end_date, 'dd Mon yyyy')) ;
2169: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2170: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2171:
2172: -- get values for ANNUAL_LEAVE_IN_ADVANCE_HOURS_ASG_HOL_YTD and
2173: -- ANNUAL_LEAVE_IN_ADVANCE_PAY_ASG_HOL_YTD balances as at the end of the
2166: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2167: hr_utility.trace(' p_asg_hours: ' || to_char(p_asg_hours)) ;
2168: hr_utility.trace(' p_year_end_date: ' || to_char(p_year_end_date, 'dd Mon yyyy')) ;
2169: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2170: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2171:
2172: -- get values for ANNUAL_LEAVE_IN_ADVANCE_HOURS_ASG_HOL_YTD and
2173: -- ANNUAL_LEAVE_IN_ADVANCE_PAY_ASG_HOL_YTD balances as at the end of the
2174: -- holiday year
2208:
2209: l_annual_leave_in_advance_pay := l_annual_leave_in_advance_pay
2210: + p_in_advance_pay_carryover ;
2211:
2212: hr_utility.trace('Ann_leave_adv_hrs= '|| to_char(l_annual_leave_in_advance_hrs));
2213: hr_utility.trace('Ann_leave_adv_pay= '|| to_char(l_annual_leave_in_advance_pay));
2214: -- if there is no annual leave in advance or annual leave in advance
2215: -- carryover then we can finish now
2216: if l_annual_leave_in_advance_hrs = 0
2209: l_annual_leave_in_advance_pay := l_annual_leave_in_advance_pay
2210: + p_in_advance_pay_carryover ;
2211:
2212: hr_utility.trace('Ann_leave_adv_hrs= '|| to_char(l_annual_leave_in_advance_hrs));
2213: hr_utility.trace('Ann_leave_adv_pay= '|| to_char(l_annual_leave_in_advance_pay));
2214: -- if there is no annual leave in advance or annual leave in advance
2215: -- carryover then we can finish now
2216: if l_annual_leave_in_advance_hrs = 0
2217: then
2215: -- carryover then we can finish now
2216: if l_annual_leave_in_advance_hrs = 0
2217: then
2218:
2219: hr_utility.trace(' no in advance leave to process') ;
2220:
2221: -- set outputs
2222: p_in_advance_pay_carryover := 0 ;
2223: p_in_advance_hours_carryover := 0 ;
2223: p_in_advance_hours_carryover := 0 ;
2224: l_eoy_adjustment := 0 ;
2225:
2226: -- trace output variables
2227: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2228: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2229: hr_utility.trace(' return: ' || to_char(l_eoy_adjustment)) ;
2230:
2231: return l_eoy_adjustment ;
2224: l_eoy_adjustment := 0 ;
2225:
2226: -- trace output variables
2227: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2228: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2229: hr_utility.trace(' return: ' || to_char(l_eoy_adjustment)) ;
2230:
2231: return l_eoy_adjustment ;
2232:
2225:
2226: -- trace output variables
2227: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2228: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2229: hr_utility.trace(' return: ' || to_char(l_eoy_adjustment)) ;
2230:
2231: return l_eoy_adjustment ;
2232:
2233: end if ;
2231: return l_eoy_adjustment ;
2232:
2233: end if ;
2234:
2235: hr_utility.trace(' in advance leave to process') ;
2236:
2237: -- Now work out what the accrual for the holiday year was. First
2238: -- get the accrual plan ID, then find the accrual up until the end of the
2239: -- holiday year, then the accrual up until the end of the previous holiday
2274: ,p_accrual => l_accrual_tmp) ;
2275:
2276: l_accrual := l_accrual - l_accrual_tmp ;
2277:
2278: hr_utility.trace(' l_accrual: ' || to_char(l_accrual)) ;
2279:
2280: -- Now we know how many hours have been taken in advance
2281: -- (l_annual_leave_in_advance_hrs) and how many hours were accrued during
2282: -- the year (l_accrual). We also know the value, as paid, of the in
2298:
2299: if l_annual_leave_in_advance_hrs <= l_accrual
2300: then
2301:
2302: hr_utility.trace(' no in advance leave carryover to process') ;
2303:
2304: -- all the advance pay will be adjusted this year
2305: l_in_advance_hours_carryover := 0 ;
2306: l_hours_to_adjust := l_annual_leave_in_advance_hrs ;
2308: l_pay_to_adjust := l_annual_leave_in_advance_pay ;
2309:
2310: else -- if l_annual_leave_in_advance_hrs > l_accrual
2311:
2312: hr_utility.trace(' in advance leave carryover to process') ;
2313:
2314: -- some of the adjustment will be carried over. Work out what
2315: -- portion of the advance should be dealth with now.
2316:
2318: l_in_advance_hours_carryover := l_annual_leave_in_advance_hrs
2319: - l_accrual ;
2320: l_hours_to_adjust := l_accrual ;
2321:
2322: hr_utility.trace('l_hrs_to_adj= '||l_hours_to_adjust);
2323:
2324: -- work out the pay to adjust and the pay to carryover
2325: --
2326: -- to find the pay to adjust we need to loop through the in advance
2361:
2362: l_hours_running_total := l_hours_running_total + l_absence_hours ;
2363: l_pay_running_total := l_pay_running_total + l_absence_pay ;
2364:
2365: hr_utility.trace(' l_absence_hours: ' || to_char(l_absence_hours)) ;
2366: hr_utility.trace(' l_absence_pay: ' || to_char(l_absence_pay)) ;
2367:
2368: -- test to see if we've past the records that are in the carryover
2369: if l_hours_running_total > l_in_advance_hours_carryover
2362: l_hours_running_total := l_hours_running_total + l_absence_hours ;
2363: l_pay_running_total := l_pay_running_total + l_absence_pay ;
2364:
2365: hr_utility.trace(' l_absence_hours: ' || to_char(l_absence_hours)) ;
2366: hr_utility.trace(' l_absence_pay: ' || to_char(l_absence_pay)) ;
2367:
2368: -- test to see if we've past the records that are in the carryover
2369: if l_hours_running_total > l_in_advance_hours_carryover
2370: then
2378: -- this adjustment
2379: if l_hours_running_total >= l_annual_leave_in_advance_hrs
2380: then
2381:
2382: hr_utility.trace(' processing first and last absence record to adjust') ;
2383:
2384: -- first and last record: work out how much of this absence
2385: -- record should be included in this adjustment
2386:
2388: - (l_hours_running_total - l_annual_leave_in_advance_hrs) ;
2389:
2390: l_pay := (l_hours / l_absence_hours) * l_absence_pay ;
2391:
2392: hr_utility.trace(' l_hours: ' || to_char(l_hours)) ;
2393: hr_utility.trace(' l_pay: ' || to_char(l_pay)) ;
2394:
2395: l_pay_to_adjust := l_pay_to_adjust + l_pay ;
2396:
2389:
2390: l_pay := (l_hours / l_absence_hours) * l_absence_pay ;
2391:
2392: hr_utility.trace(' l_hours: ' || to_char(l_hours)) ;
2393: hr_utility.trace(' l_pay: ' || to_char(l_pay)) ;
2394:
2395: l_pay_to_adjust := l_pay_to_adjust + l_pay ;
2396:
2397: -- exit from loop
2398: exit ;
2399:
2400: else
2401:
2402: hr_utility.trace(' processing first record to adjust') ;
2403:
2404: -- first record only: work out how much of this absence record
2405: -- should be included in this adjustment
2406:
2406:
2407: l_hours := l_hours_running_total - l_in_advance_hours_carryover ;
2408: l_pay := (l_hours / l_absence_hours) * l_absence_pay ;
2409:
2410: hr_utility.trace(' l_hours: ' || to_char(l_hours)) ;
2411: hr_utility.trace(' l_pay: ' || to_char(l_pay)) ;
2412:
2413: l_pay_to_adjust := l_pay_to_adjust + l_pay ;
2414:
2407: l_hours := l_hours_running_total - l_in_advance_hours_carryover ;
2408: l_pay := (l_hours / l_absence_hours) * l_absence_pay ;
2409:
2410: hr_utility.trace(' l_hours: ' || to_char(l_hours)) ;
2411: hr_utility.trace(' l_pay: ' || to_char(l_pay)) ;
2412:
2413: l_pay_to_adjust := l_pay_to_adjust + l_pay ;
2414:
2415: end if ;
2418: -- adjustment
2419: elsif l_hours_running_total >= l_annual_leave_in_advance_hrs
2420: then
2421:
2422: hr_utility.trace(' processing last record to adjust') ;
2423:
2424: l_hours := l_absence_hours - (l_hours_running_total - l_annual_leave_in_advance_hrs) ;
2425: l_pay := (l_hours / l_absence_hours) * l_absence_pay ;
2426:
2423:
2424: l_hours := l_absence_hours - (l_hours_running_total - l_annual_leave_in_advance_hrs) ;
2425: l_pay := (l_hours / l_absence_hours) * l_absence_pay ;
2426:
2427: hr_utility.trace(' l_hours: ' || to_char(l_hours)) ;
2428: hr_utility.trace(' l_pay: ' || to_char(l_pay)) ;
2429:
2430: l_pay_to_adjust := l_pay_to_adjust + l_pay ;
2431:
2424: l_hours := l_absence_hours - (l_hours_running_total - l_annual_leave_in_advance_hrs) ;
2425: l_pay := (l_hours / l_absence_hours) * l_absence_pay ;
2426:
2427: hr_utility.trace(' l_hours: ' || to_char(l_hours)) ;
2428: hr_utility.trace(' l_pay: ' || to_char(l_pay)) ;
2429:
2430: l_pay_to_adjust := l_pay_to_adjust + l_pay ;
2431:
2432: -- exit from loop
2435: -- otherwise this is a record between the first and last to be
2436: -- included in the adjustment
2437: else
2438:
2439: hr_utility.trace(' processing middle in advance absence record to adjust') ;
2440:
2441: -- add all of the value of this absence
2442: l_pay_to_adjust := l_pay_to_adjust + l_absence_pay ;
2443:
2458:
2459: -- We now know how many hours (l_hours_to_adjust) and how much pay
2460: -- (l_pay_to_adjust) this year.
2461:
2462: hr_utility.trace(' l_hours_to_adjust: ' || to_char(l_hours_to_adjust)) ;
2463: hr_utility.trace(' l_pay_to_adjust: ' || to_char(l_pay_to_adjust)) ;
2464:
2465: -- get the ID of the Gross Earnings for Holiday Pay balance
2466: open c_balance_type('Gross Earnings for Holiday Pay') ;
2459: -- We now know how many hours (l_hours_to_adjust) and how much pay
2460: -- (l_pay_to_adjust) this year.
2461:
2462: hr_utility.trace(' l_hours_to_adjust: ' || to_char(l_hours_to_adjust)) ;
2463: hr_utility.trace(' l_pay_to_adjust: ' || to_char(l_pay_to_adjust)) ;
2464:
2465: -- get the ID of the Gross Earnings for Holiday Pay balance
2466: open c_balance_type('Gross Earnings for Holiday Pay') ;
2467: fetch c_balance_type
2477: (p_assignment_id
2478: ,l_balance_type_id
2479: ,p_year_end_date) ;
2480:
2481: hr_utility.trace(' l_gross_earnings_for_hol_pay: ' || to_char(l_gross_earnings_for_hol_pay)) ;
2482:
2483: -- Get number of eligible weeks in year (complete weeks of special and
2484: -- protected voluntary service leave are subtracted from the number of
2485: -- weeks in the year.
2486: l_num_weeks := num_weeks_for_avg_earnings
2487: (p_assignment_id
2488: ,add_months(p_year_end_date + 1, -12)) ;
2489:
2490: hr_utility.trace(' l_num_weeks: ' || to_char(l_num_weeks)) ;
2491:
2492: open get_pay_period_start_date(p_assignment_id);
2493: fetch get_pay_period_start_date into l_pay_period_start_date,l_num_of_pay_periods_per_year;
2494: close get_pay_period_start_date;
2512: l_recalculated_pay := ((l_gross_earnings_for_hol_pay / l_num_weeks)
2513: / p_asg_hours)
2514: * l_hours_to_adjust ;
2515:
2516: hr_utility.trace(' l_recalculated_pay: ' || to_char(l_recalculated_pay)) ;
2517: hr_utility.trace(' Pay_to_adjust= '||l_pay_to_adjust);
2518: -- work out the adjustment (cannot be negative)
2519: l_eoy_adjustment := l_recalculated_pay - l_pay_to_adjust ;
2520: /*Bug 2950172 - Removed greatest(...) logic so as to return negative value
2513: / p_asg_hours)
2514: * l_hours_to_adjust ;
2515:
2516: hr_utility.trace(' l_recalculated_pay: ' || to_char(l_recalculated_pay)) ;
2517: hr_utility.trace(' Pay_to_adjust= '||l_pay_to_adjust);
2518: -- work out the adjustment (cannot be negative)
2519: l_eoy_adjustment := l_recalculated_pay - l_pay_to_adjust ;
2520: /*Bug 2950172 - Removed greatest(...) logic so as to return negative value
2521: to the formula. The negative value is handled in the formula.*/
2524: p_in_advance_pay_carryover := l_in_advance_pay_carryover ;
2525: p_in_advance_hours_carryover := l_in_advance_hours_carryover ;
2526:
2527: -- trace output variables
2528: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2529: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2530: hr_utility.trace(' return: ' || to_char(l_eoy_adjustment)) ;
2531:
2532: return l_eoy_adjustment ;
2525: p_in_advance_hours_carryover := l_in_advance_hours_carryover ;
2526:
2527: -- trace output variables
2528: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2529: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2530: hr_utility.trace(' return: ' || to_char(l_eoy_adjustment)) ;
2531:
2532: return l_eoy_adjustment ;
2533:
2526:
2527: -- trace output variables
2528: hr_utility.trace(' p_in_advance_pay_carryover: ' || to_char(p_in_advance_pay_carryover)) ;
2529: hr_utility.trace(' p_in_advance_hours_carryover: ' || to_char(p_in_advance_hours_carryover)) ;
2530: hr_utility.trace(' return: ' || to_char(l_eoy_adjustment)) ;
2531:
2532: return l_eoy_adjustment ;
2533:
2534: exception
2533:
2534: exception
2535: when e_missing_balance_type
2536: then
2537: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2538: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2539: hr_utility.set_message_token('STEP', 'Missing Balance Type Exception') ;
2540: hr_utility.raise_error ;
2541:
2534: exception
2535: when e_missing_balance_type
2536: then
2537: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2538: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2539: hr_utility.set_message_token('STEP', 'Missing Balance Type Exception') ;
2540: hr_utility.raise_error ;
2541:
2542: when e_missing_accrual_plan
2535: when e_missing_balance_type
2536: then
2537: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2538: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2539: hr_utility.set_message_token('STEP', 'Missing Balance Type Exception') ;
2540: hr_utility.raise_error ;
2541:
2542: when e_missing_accrual_plan
2543: then
2536: then
2537: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2538: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2539: hr_utility.set_message_token('STEP', 'Missing Balance Type Exception') ;
2540: hr_utility.raise_error ;
2541:
2542: when e_missing_accrual_plan
2543: then
2544: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2540: hr_utility.raise_error ;
2541:
2542: when e_missing_accrual_plan
2543: then
2544: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2545: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2546: hr_utility.set_message_token('STEP', 'Missing Accrual Plan Exception') ;
2547: hr_utility.raise_error ;
2548:
2541:
2542: when e_missing_accrual_plan
2543: then
2544: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2545: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2546: hr_utility.set_message_token('STEP', 'Missing Accrual Plan Exception') ;
2547: hr_utility.raise_error ;
2548:
2549: when e_missing_leave_in_advance
2542: when e_missing_accrual_plan
2543: then
2544: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2545: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2546: hr_utility.set_message_token('STEP', 'Missing Accrual Plan Exception') ;
2547: hr_utility.raise_error ;
2548:
2549: when e_missing_leave_in_advance
2550: then
2543: then
2544: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2545: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2546: hr_utility.set_message_token('STEP', 'Missing Accrual Plan Exception') ;
2547: hr_utility.raise_error ;
2548:
2549: when e_missing_leave_in_advance
2550: then
2551: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2547: hr_utility.raise_error ;
2548:
2549: when e_missing_leave_in_advance
2550: then
2551: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2552: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2553: hr_utility.set_message_token('STEP', 'Missing Leave in Advance Exception') ;
2554: hr_utility.raise_error ;
2555:
2548:
2549: when e_missing_leave_in_advance
2550: then
2551: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2552: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2553: hr_utility.set_message_token('STEP', 'Missing Leave in Advance Exception') ;
2554: hr_utility.raise_error ;
2555:
2556: end annual_leave_eoy_adjustment ;
2549: when e_missing_leave_in_advance
2550: then
2551: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2552: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2553: hr_utility.set_message_token('STEP', 'Missing Leave in Advance Exception') ;
2554: hr_utility.raise_error ;
2555:
2556: end annual_leave_eoy_adjustment ;
2557:
2550: then
2551: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
2552: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
2553: hr_utility.set_message_token('STEP', 'Missing Leave in Advance Exception') ;
2554: hr_utility.raise_error ;
2555:
2556: end annual_leave_eoy_adjustment ;
2557:
2558: /*---------------------------------------------------------------------
2569: l_day_count NUMBER := 0;
2570: l_day DATE;
2571: BEGIN
2572:
2573: hr_utility.trace('In: '||l_proc);
2574: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
2575: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
2576:
2577: IF (p_start_date > p_end_date)
2570: l_day DATE;
2571: BEGIN
2572:
2573: hr_utility.trace('In: '||l_proc);
2574: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
2575: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
2576:
2577: IF (p_start_date > p_end_date)
2578: THEN
2571: BEGIN
2572:
2573: hr_utility.trace('In: '||l_proc);
2574: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
2575: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
2576:
2577: IF (p_start_date > p_end_date)
2578: THEN
2579: hr_utility.trace('Crash Out: '||l_proc);
2575: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
2576:
2577: IF (p_start_date > p_end_date)
2578: THEN
2579: hr_utility.trace('Crash Out: '||l_proc);
2580: hr_utility.set_message(801,'HR_NZ_INVALID_DATE_RANGE');
2581: hr_utility.raise_error;
2582: END IF;
2583:
2576:
2577: IF (p_start_date > p_end_date)
2578: THEN
2579: hr_utility.trace('Crash Out: '||l_proc);
2580: hr_utility.set_message(801,'HR_NZ_INVALID_DATE_RANGE');
2581: hr_utility.raise_error;
2582: END IF;
2583:
2584: hr_utility.set_location(l_proc,5);
2577: IF (p_start_date > p_end_date)
2578: THEN
2579: hr_utility.trace('Crash Out: '||l_proc);
2580: hr_utility.set_message(801,'HR_NZ_INVALID_DATE_RANGE');
2581: hr_utility.raise_error;
2582: END IF;
2583:
2584: hr_utility.set_location(l_proc,5);
2585: l_day := p_start_date;
2580: hr_utility.set_message(801,'HR_NZ_INVALID_DATE_RANGE');
2581: hr_utility.raise_error;
2582: END IF;
2583:
2584: hr_utility.set_location(l_proc,5);
2585: l_day := p_start_date;
2586: WHILE (l_day <= p_end_date)
2587: LOOP
2588: IF (TO_CHAR(l_day,'DY') IN ('MON','TUE','WED','THU','FRI'))
2590: l_day_count := l_day_count + 1;
2591: END IF;
2592: l_day := l_day + 1;
2593: END LOOP;
2594: hr_utility.trace(' return: ' || to_char(l_day_count)) ;
2595: hr_utility.trace('Out: '||l_proc);
2596: RETURN l_day_count;
2597:
2598: END get_weekdays_in_period;
2591: END IF;
2592: l_day := l_day + 1;
2593: END LOOP;
2594: hr_utility.trace(' return: ' || to_char(l_day_count)) ;
2595: hr_utility.trace('Out: '||l_proc);
2596: RETURN l_day_count;
2597:
2598: END get_weekdays_in_period;
2599:
2736: l_band_notfound_flag boolean := true ;
2737:
2738: begin
2739:
2740: -- hr_utility.trace(' In: ' || l_procedure_name) ;
2741:
2742: -- loop through the PL/SQL table looking for a likely accrual band
2743: while l_accrual_band_cache.count > 0
2744: and l_band_notfound_flag
2766: raise e_accrual_function_failure ;
2767:
2768: end if ;
2769:
2770: -- hr_utility.trace(' Out: ' || l_procedure_name) ;
2771: return l_annual_accrual ;
2772:
2773: end accrual_annual_rate ;
2774:
2783: l_hours_notfound_flag boolean := true ;
2784:
2785: begin
2786:
2787: -- hr_utility.trace(' In: ' || l_procedure_name) ;
2788:
2789: -- loop through the PL/SQL table looking for a likely accrual band
2790: while l_asg_work_day_info_cache.count > 0
2791: and l_hours_notfound_flag
2813: raise e_accrual_function_failure ;
2814:
2815: end if ;
2816:
2817: -- hr_utility.trace(' Out: ' || l_procedure_name) ;
2818: return l_asg_working_hours ;
2819:
2820: end asg_working_hours ;
2821:
2820: end asg_working_hours ;
2821:
2822: begin
2823:
2824: hr_utility.trace('In: ' || l_procedure_name) ;
2825: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2826: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
2827: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2828: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
2821:
2822: begin
2823:
2824: hr_utility.trace('In: ' || l_procedure_name) ;
2825: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2826: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
2827: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2828: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
2829: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
2822: begin
2823:
2824: hr_utility.trace('In: ' || l_procedure_name) ;
2825: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2826: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
2827: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2828: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
2829: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
2830: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
2823:
2824: hr_utility.trace('In: ' || l_procedure_name) ;
2825: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2826: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
2827: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2828: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
2829: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
2830: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
2831: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
2824: hr_utility.trace('In: ' || l_procedure_name) ;
2825: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2826: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
2827: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2828: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
2829: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
2830: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
2831: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
2832: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
2825: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
2826: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
2827: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2828: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
2829: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
2830: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
2831: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
2832: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
2833:
2826: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
2827: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2828: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
2829: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
2830: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
2831: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
2832: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
2833:
2834: -- cache the assignment's work day history
2827: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
2828: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
2829: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
2830: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
2831: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
2832: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
2833:
2834: -- cache the assignment's work day history
2835: l_counter := 1 ;
2828: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
2829: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
2830: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
2831: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
2832: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
2833:
2834: -- cache the assignment's work day history
2835: l_counter := 1 ;
2836:
2926: l_accrual := l_accrual + l_period_accrual ;
2927:
2928: end loop ; -- c_periods
2929:
2930: hr_utility.trace(' return: ' || to_char(l_accrual)) ;
2931: hr_utility.trace('Out: ' || l_procedure_name) ;
2932: return l_accrual ;
2933:
2934: exception
2927:
2928: end loop ; -- c_periods
2929:
2930: hr_utility.trace(' return: ' || to_char(l_accrual)) ;
2931: hr_utility.trace('Out: ' || l_procedure_name) ;
2932: return l_accrual ;
2933:
2934: exception
2935: when e_accrual_function_failure
2933:
2934: exception
2935: when e_accrual_function_failure
2936: then
2937: hr_utility.trace('Crash Out: ' || l_procedure_name) ;
2938: hr_utility.set_message(801, 'HR_NZ_ACCRUAL_FUNCTION_FAILURE') ;
2939: hr_utility.raise_error ;
2940:
2941: end accrual_period_basis ;
2934: exception
2935: when e_accrual_function_failure
2936: then
2937: hr_utility.trace('Crash Out: ' || l_procedure_name) ;
2938: hr_utility.set_message(801, 'HR_NZ_ACCRUAL_FUNCTION_FAILURE') ;
2939: hr_utility.raise_error ;
2940:
2941: end accrual_period_basis ;
2942:
2935: when e_accrual_function_failure
2936: then
2937: hr_utility.trace('Crash Out: ' || l_procedure_name) ;
2938: hr_utility.set_message(801, 'HR_NZ_ACCRUAL_FUNCTION_FAILURE') ;
2939: hr_utility.raise_error ;
2940:
2941: end accrual_period_basis ;
2942:
2943: -----------------------------------------------------------------------------
3055: l_band_notfound_flag boolean := true ;
3056:
3057: begin
3058:
3059: hr_utility.trace('acc_band_cache_ct '||l_accrual_band_cache.count);
3060: hr_utility.trace('l_counter '||l_counter);
3061: hr_utility.trace('l_accrual_band_cache.last '||l_accrual_band_cache.last);
3062:
3063: -- hr_utility.trace(' In: ' || l_procedure_name) ;
3056:
3057: begin
3058:
3059: hr_utility.trace('acc_band_cache_ct '||l_accrual_band_cache.count);
3060: hr_utility.trace('l_counter '||l_counter);
3061: hr_utility.trace('l_accrual_band_cache.last '||l_accrual_band_cache.last);
3062:
3063: -- hr_utility.trace(' In: ' || l_procedure_name) ;
3064:
3057: begin
3058:
3059: hr_utility.trace('acc_band_cache_ct '||l_accrual_band_cache.count);
3060: hr_utility.trace('l_counter '||l_counter);
3061: hr_utility.trace('l_accrual_band_cache.last '||l_accrual_band_cache.last);
3062:
3063: -- hr_utility.trace(' In: ' || l_procedure_name) ;
3064:
3065: -- loop through the PL/SQL table looking for a likely accrual band
3059: hr_utility.trace('acc_band_cache_ct '||l_accrual_band_cache.count);
3060: hr_utility.trace('l_counter '||l_counter);
3061: hr_utility.trace('l_accrual_band_cache.last '||l_accrual_band_cache.last);
3062:
3063: -- hr_utility.trace(' In: ' || l_procedure_name) ;
3064:
3065: -- loop through the PL/SQL table looking for a likely accrual band
3066: while l_accrual_band_cache.count > 0
3067: and l_band_notfound_flag
3089: raise e_accrual_function_failure ;
3090:
3091: end if ;
3092:
3093: -- hr_utility.trace(' Out: ' || l_procedure_name) ;
3094: return l_annual_accrual ;
3095:
3096: end accrual_annual_rate ;
3097:
3106: l_hours_notfound_flag boolean := true ;
3107:
3108: begin
3109:
3110: -- hr_utility.trace(' In: ' || l_procedure_name) ;
3111:
3112: -- loop through the PL/SQL table looking for a likely accrual band
3113: while l_asg_work_day_info_cache.count > 0
3114: and l_hours_notfound_flag
3136: raise e_accrual_function_failure ;
3137:
3138: end if ;
3139:
3140: -- hr_utility.trace(' Out: ' || l_procedure_name) ;
3141: return l_asg_working_hours ;
3142:
3143: end asg_working_hours ;
3144:
3142:
3143: end asg_working_hours ;
3144:
3145: begin
3146: hr_utility.trace('fun_enetered_ven');
3147: hr_utility.trace('In: ' || l_procedure_name) ;
3148: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
3149: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
3150: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
3143: end asg_working_hours ;
3144:
3145: begin
3146: hr_utility.trace('fun_enetered_ven');
3147: hr_utility.trace('In: ' || l_procedure_name) ;
3148: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
3149: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
3150: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
3151: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
3144:
3145: begin
3146: hr_utility.trace('fun_enetered_ven');
3147: hr_utility.trace('In: ' || l_procedure_name) ;
3148: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
3149: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
3150: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
3151: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
3152: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
3145: begin
3146: hr_utility.trace('fun_enetered_ven');
3147: hr_utility.trace('In: ' || l_procedure_name) ;
3148: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
3149: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
3150: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
3151: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
3152: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
3153: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
3146: hr_utility.trace('fun_enetered_ven');
3147: hr_utility.trace('In: ' || l_procedure_name) ;
3148: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
3149: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
3150: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
3151: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
3152: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
3153: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
3154: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date, 'dd-Mon-yyyy')) ;
3147: hr_utility.trace('In: ' || l_procedure_name) ;
3148: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
3149: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
3150: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
3151: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
3152: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
3153: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
3154: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date, 'dd-Mon-yyyy')) ;
3155: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
3148: hr_utility.trace(' p_payroll_id: ' || to_char(p_payroll_id)) ;
3149: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
3150: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
3151: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
3152: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
3153: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
3154: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date, 'dd-Mon-yyyy')) ;
3155: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
3156: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
3149: hr_utility.trace(' p_accrual_plan_id: ' || to_char(p_accrual_plan_id)) ;
3150: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
3151: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
3152: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
3153: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
3154: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date, 'dd-Mon-yyyy')) ;
3155: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
3156: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
3157:
3150: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
3151: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
3152: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
3153: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
3154: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date, 'dd-Mon-yyyy')) ;
3155: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
3156: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
3157:
3158: -- cache the assignment's work day history
3151: hr_utility.trace(' p_calculation_start_date: ' || to_char(p_calculation_start_date, 'dd-Mon-yyyy')) ;
3152: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
3153: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
3154: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date, 'dd-Mon-yyyy')) ;
3155: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
3156: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
3157:
3158: -- cache the assignment's work day history
3159: l_counter := 1 ;
3152: hr_utility.trace(' p_calculation_end_date: ' || to_char(p_calculation_end_date, 'dd-Mon-yyyy')) ;
3153: hr_utility.trace(' p_service_start_date: ' || to_char(p_service_start_date, 'dd-Mon-yyyy')) ;
3154: hr_utility.trace(' p_anniversary_date: ' || to_char(p_anniversary_date, 'dd-Mon-yyyy')) ;
3155: hr_utility.trace(' p_business_group_hours: ' || to_char(p_business_group_hours)) ;
3156: hr_utility.trace(' p_business_group_freq: ' || p_business_group_freq) ;
3157:
3158: -- cache the assignment's work day history
3159: l_counter := 1 ;
3160: l_check_flag := false;
3198: ,p_calculation_end_date)
3199: loop
3200:
3201: -- how many years of service does the assignment have (as at the end of the period)
3202: hr_utility.trace('---------------------------------------------------------------------');
3203:
3204: -- Bug# 2072748 -- added the following code
3205: -- calculation of accruals is upto the calculation end date, hence for each
3206: -- period calculation start date and calculation end date are compared with
3389: l_period_accrual := (l_annual_accrual/l_days_in_year)*l_days_in_part_period;
3390: end if;
3391: end if;
3392:
3393: -- hr_utility.trace('l_annual_accrual = '||to_char(l_annual_accrual));
3394: --
3395: -- the algorithm being used here is:
3396: --
3397: -- days to accrue for period
3406: l_accrual := l_accrual + l_period_accrual ;
3407: --
3408: end loop ; -- c_periods
3409:
3410: hr_utility.trace(' return: ' || to_char(l_accrual)) ;
3411: hr_utility.trace('Out: ' || l_procedure_name) ;
3412: return l_accrual ;
3413:
3414: exception
3407: --
3408: end loop ; -- c_periods
3409:
3410: hr_utility.trace(' return: ' || to_char(l_accrual)) ;
3411: hr_utility.trace('Out: ' || l_procedure_name) ;
3412: return l_accrual ;
3413:
3414: exception
3415: when e_accrual_function_failure
3413:
3414: exception
3415: when e_accrual_function_failure
3416: then
3417: hr_utility.trace('Crash Out: ' || l_procedure_name) ;
3418: hr_utility.set_message(801, 'HR_NZ_ACCRUAL_FUNCTION_FAILURE') ;
3419: hr_utility.raise_error ;
3420:
3421: end accrual_daily_basis ;
3414: exception
3415: when e_accrual_function_failure
3416: then
3417: hr_utility.trace('Crash Out: ' || l_procedure_name) ;
3418: hr_utility.set_message(801, 'HR_NZ_ACCRUAL_FUNCTION_FAILURE') ;
3419: hr_utility.raise_error ;
3420:
3421: end accrual_daily_basis ;
3422:
3415: when e_accrual_function_failure
3416: then
3417: hr_utility.trace('Crash Out: ' || l_procedure_name) ;
3418: hr_utility.set_message(801, 'HR_NZ_ACCRUAL_FUNCTION_FAILURE') ;
3419: hr_utility.raise_error ;
3420:
3421: end accrual_daily_basis ;
3422:
3423:
3462:
3463: FETCH get_balance_id INTO l_balance_type_id;
3464:
3465: IF get_balance_id %NOTFOUND THEN
3466: hr_utility.set_location('balance -Gross Earnings for Holiday Pay- not found ',3);
3467: END IF;
3468:
3469: CLOSE get_balance_id ;
3470:
3471: l_gross_earnings := hr_nzbal.calc_asg_hol_ytd_date
3472: (p_assignment_id => p_assignment_id
3473: ,p_balance_type_id => l_balance_type_id
3474: ,p_effective_date => l_year_end);
3475: hr_utility.trace('gross earnings :'||l_gross_earnings);
3476: hr_utility.trace('year end date :'||l_year_end);
3477:
3478: l_num_of_weeks := hr_nz_holidays.num_weeks_for_avg_earnings
3479: (p_assignment_id
3472: (p_assignment_id => p_assignment_id
3473: ,p_balance_type_id => l_balance_type_id
3474: ,p_effective_date => l_year_end);
3475: hr_utility.trace('gross earnings :'||l_gross_earnings);
3476: hr_utility.trace('year end date :'||l_year_end);
3477:
3478: l_num_of_weeks := hr_nz_holidays.num_weeks_for_avg_earnings
3479: (p_assignment_id
3480: ,add_months(l_year_end + 1, -12)) ;
3478: l_num_of_weeks := hr_nz_holidays.num_weeks_for_avg_earnings
3479: (p_assignment_id
3480: ,add_months(l_year_end + 1, -12)) ;
3481:
3482: hr_utility.trace('num of weeks :'||l_num_of_weeks);
3483: l_avg_rate := l_gross_Earnings/l_num_of_weeks/p_asg_hours;
3484: hr_utility.trace('Return :'||l_avg_rate);
3485: RETURN l_avg_rate ;
3486:
3480: ,add_months(l_year_end + 1, -12)) ;
3481:
3482: hr_utility.trace('num of weeks :'||l_num_of_weeks);
3483: l_avg_rate := l_gross_Earnings/l_num_of_weeks/p_asg_hours;
3484: hr_utility.trace('Return :'||l_avg_rate);
3485: RETURN l_avg_rate ;
3486:
3487: EXCEPTION
3488: WHEN OTHERS THEN
3485: RETURN l_avg_rate ;
3486:
3487: EXCEPTION
3488: WHEN OTHERS THEN
3489: hr_utility.set_location('Error in function -average_accrual_rate. ',3);
3490: RAISE ;
3491: END average_accrual_rate;
3492:
3493: /* Bug 2264070 This function returns the annual leave paid before
3613: open c_get_curr_action_type(p_payroll_id);
3614: FETCH c_get_curr_action_type INTO l_action_type;
3615: close c_get_curr_action_type;
3616:
3617: hr_utility.trace('Action_type= '||l_action_type);
3618: if l_action_type = 'L' then
3619: return 1;
3620: else
3621: return 0;
3659: l_effective_date date;
3660: l_payroll_id number;
3661:
3662: begin
3663: hr_utility.trace('Inside retro_start_date');
3664:
3665: open c_get_values(p_assignment_id);
3666: fetch c_get_values into l_effective_date ,l_payroll_id;
3667: close c_get_values;
3668:
3669: open c_retro_start_date(l_effective_date,l_payroll_id);
3670: fetch c_retro_start_date into l_retro_start_date ;
3671: close c_retro_start_date ;
3672: hr_utility.trace('Executed_retro_start_cursor value of date'|| to_char(l_retro_start_date,'DD-MON-YYYY'));
3673: return l_retro_start_date ;
3674:
3675: end retro_start_date;
3676:
3714:
3715: exception
3716: when e_missing_balance_type
3717: then
3718: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3719: hr_utility.set_message_token('PROCEDURE',l_procedure_name);
3720: hr_utility.set_message_token('STEP','Missing Balance Type Exception');
3721: hr_utility.raise_error;
3722:
3715: exception
3716: when e_missing_balance_type
3717: then
3718: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3719: hr_utility.set_message_token('PROCEDURE',l_procedure_name);
3720: hr_utility.set_message_token('STEP','Missing Balance Type Exception');
3721: hr_utility.raise_error;
3722:
3723: END gross_earnings_ytd_for_retro;
3716: when e_missing_balance_type
3717: then
3718: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3719: hr_utility.set_message_token('PROCEDURE',l_procedure_name);
3720: hr_utility.set_message_token('STEP','Missing Balance Type Exception');
3721: hr_utility.raise_error;
3722:
3723: END gross_earnings_ytd_for_retro;
3724:
3717: then
3718: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3719: hr_utility.set_message_token('PROCEDURE',l_procedure_name);
3720: hr_utility.set_message_token('STEP','Missing Balance Type Exception');
3721: hr_utility.raise_error;
3722:
3723: END gross_earnings_ytd_for_retro;
3724:
3725:
3784: and pee.effective_start_date between pev2.effective_start_date and pev2.effective_end_date;
3785:
3786: begin
3787:
3788: hr_utility.set_location(' In: ' || l_proc,5) ;
3789: hr_utility.trace('p_adjustment_element = '||p_adjustment_element);
3790: hr_utility.trace('p_calc_end_date = '||to_char(p_calc_end_date,'dd/mm/rrrr'));
3791: hr_utility.trace('p_start_date = '||to_char(p_start_date,'dd/mm/rrrr'));
3792: hr_utility.trace('p_end_date = '||to_char(p_end_date,'dd/mm/rrrr'));
3785:
3786: begin
3787:
3788: hr_utility.set_location(' In: ' || l_proc,5) ;
3789: hr_utility.trace('p_adjustment_element = '||p_adjustment_element);
3790: hr_utility.trace('p_calc_end_date = '||to_char(p_calc_end_date,'dd/mm/rrrr'));
3791: hr_utility.trace('p_start_date = '||to_char(p_start_date,'dd/mm/rrrr'));
3792: hr_utility.trace('p_end_date = '||to_char(p_end_date,'dd/mm/rrrr'));
3793: -- find total leave initialise - should return zero if none entered
3786: begin
3787:
3788: hr_utility.set_location(' In: ' || l_proc,5) ;
3789: hr_utility.trace('p_adjustment_element = '||p_adjustment_element);
3790: hr_utility.trace('p_calc_end_date = '||to_char(p_calc_end_date,'dd/mm/rrrr'));
3791: hr_utility.trace('p_start_date = '||to_char(p_start_date,'dd/mm/rrrr'));
3792: hr_utility.trace('p_end_date = '||to_char(p_end_date,'dd/mm/rrrr'));
3793: -- find total leave initialise - should return zero if none entered
3794:
3787:
3788: hr_utility.set_location(' In: ' || l_proc,5) ;
3789: hr_utility.trace('p_adjustment_element = '||p_adjustment_element);
3790: hr_utility.trace('p_calc_end_date = '||to_char(p_calc_end_date,'dd/mm/rrrr'));
3791: hr_utility.trace('p_start_date = '||to_char(p_start_date,'dd/mm/rrrr'));
3792: hr_utility.trace('p_end_date = '||to_char(p_end_date,'dd/mm/rrrr'));
3793: -- find total leave initialise - should return zero if none entered
3794:
3795: open c_get_adjustments(p_assignment_id
3788: hr_utility.set_location(' In: ' || l_proc,5) ;
3789: hr_utility.trace('p_adjustment_element = '||p_adjustment_element);
3790: hr_utility.trace('p_calc_end_date = '||to_char(p_calc_end_date,'dd/mm/rrrr'));
3791: hr_utility.trace('p_start_date = '||to_char(p_start_date,'dd/mm/rrrr'));
3792: hr_utility.trace('p_end_date = '||to_char(p_end_date,'dd/mm/rrrr'));
3793: -- find total leave initialise - should return zero if none entered
3794:
3795: open c_get_adjustments(p_assignment_id
3796: ,p_accrual_plan_id
3800: ,p_end_date);
3801: fetch c_get_adjustments into l_adjustment;
3802: close c_get_adjustments;
3803:
3804: hr_utility.trace('Adjustment: '||to_char(l_adjustment));
3805: hr_utility.set_location(' Out: ' || l_proc,10) ;
3806:
3807: return(nvl(l_adjustment,0));
3808:
3801: fetch c_get_adjustments into l_adjustment;
3802: close c_get_adjustments;
3803:
3804: hr_utility.trace('Adjustment: '||to_char(l_adjustment));
3805: hr_utility.set_location(' Out: ' || l_proc,10) ;
3806:
3807: return(nvl(l_adjustment,0));
3808:
3809: end get_adjustment_values;