DBA Data[Home] [Help]

APPS.HR_NZBAL dependencies on HR_UTILITY

Line 754: hr_utility.trace('ven_gppst_date= '||to_char(l_cur_per_start_date));

750: open get_pay_period_start_date(p_assignment_id);
751: fetch get_pay_period_start_date into l_cur_per_start_date;
752: close get_pay_period_start_date;
753:
754: hr_utility.trace('ven_gppst_date= '||to_char(l_cur_per_start_date));
755: open get_next_pay_period_start_date(p_assignment_id,p_effective_date);
756: fetch get_next_pay_period_start_date into l_next_start_date;
757: close get_next_pay_period_start_date;
758:

Line 759: hr_utility.trace('ven_nppst_date= '||to_char(l_next_start_date));

755: open get_next_pay_period_start_date(p_assignment_id,p_effective_date);
756: fetch get_next_pay_period_start_date into l_next_start_date;
757: close get_next_pay_period_start_date;
758:
759: hr_utility.trace('ven_nppst_date= '||to_char(l_next_start_date));
760:
761: loop
762: --* if the hol anniversary date is the first day of the pay period
763: --* then set the effective date to last day of the previous pay period

Line 772: hr_utility.trace('ven_if');

768: if l_count = 1 then
769: if to_char(p_effective_date+1,'dd')<>to_char(l_cur_per_start_date,'dd')
770: then
771: l_effective_date:= l_next_start_date;
772: hr_utility.trace('ven_if');
773: else
774: l_effective_date:=p_effective_date;
775: l_count := 2;
776: hr_utility.trace('ven_else');

Line 776: hr_utility.trace('ven_else');

772: hr_utility.trace('ven_if');
773: else
774: l_effective_date:=p_effective_date;
775: l_count := 2;
776: hr_utility.trace('ven_else');
777: end if;
778: else
779: if l_count = 2 then
780: l_effective_date := p_effective_date;

Line 781: hr_utility.trace('ven_count=2');

777: end if;
778: else
779: if l_count = 2 then
780: l_effective_date := p_effective_date;
781: hr_utility.trace('ven_count=2');
782: end if;
783: end if;
784:
785: /* Bug:3043157 Start */