816:
817: l_sickness_end_date := LEAST(l_start_end_date.end_date, l_sickness_group.fourteenth_date );
818: IF l_sickness_group.fourteenth_date < l_start_end_date.end_date THEN
819:
820: fnd_file.put_line(fnd_file.log,'location: 1 l_total_full_day: '||l_total_full_day);
821: fnd_file.put_line(fnd_file.log,'location: 1 l_start_end_date.end_date : '||l_start_end_date.end_date );
822:
823: l_exit_flag := 'Y';
824: if nvl(l_start_end_date.full_day,0) > 0 then
817: l_sickness_end_date := LEAST(l_start_end_date.end_date, l_sickness_group.fourteenth_date );
818: IF l_sickness_group.fourteenth_date < l_start_end_date.end_date THEN
819:
820: fnd_file.put_line(fnd_file.log,'location: 1 l_total_full_day: '||l_total_full_day);
821: fnd_file.put_line(fnd_file.log,'location: 1 l_start_end_date.end_date : '||l_start_end_date.end_date );
822:
823: l_exit_flag := 'Y';
824: if nvl(l_start_end_date.full_day,0) > 0 then
825: l_full_day := l_employer_days - l_total_full_day;
837:
838: l_total_full_day:= nvl(l_start_end_date.full_day,0) + nvl(l_total_full_day,0)
839: + nvl(l_start_end_date.part_day,0);
840:
841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
838: l_total_full_day:= nvl(l_start_end_date.full_day,0) + nvl(l_total_full_day,0)
839: + nvl(l_start_end_date.part_day,0);
840:
841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
839: + nvl(l_start_end_date.part_day,0);
840:
841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));
840:
841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));
848:
841: fnd_file.put_line(fnd_file.log,'location: 2 l_total_full_day: '||l_total_full_day);
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));
848:
849: IF l_start_end_date.start_date < g_start_date THEN
842: fnd_file.put_line(fnd_file.log,'location: 2 l_exit_flag: '||l_exit_flag);
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));
848:
849: IF l_start_end_date.start_date < g_start_date THEN
850: l_sickness_start_date := g_start_date;
843: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.full_day: '||l_start_end_date.full_day);
844: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.part_day: '||l_start_end_date.part_day);
845: fnd_file.put_line(fnd_file.log,'location: 2 l_start_end_date.end_date : '||l_start_end_date.end_date );
846: fnd_file.put_line(fnd_file.log,'location: 2 l_sickness_group.end_date : '||l_sickness_group.end_date );
847: fnd_file.put_line(fnd_file.log,'in assignment_action_code total full day ' || to_char(l_total_full_day));
848:
849: IF l_start_end_date.start_date < g_start_date THEN
850: l_sickness_start_date := g_start_date;
851: ELSE