364: P_Start_Date Date,
365: P_End_Date Date) return NUMBER IS
366: CURSOR Get_Non_SI_Absence(p_person_id number) is
367: select date_start,date_end,time_start,time_end
368: from per_absence_attendances_v
369: where person_id=p_person_id
370: and ((ABS_INFORMATION_CATEGORY='NL' and ABS_INFORMATION1='Y')
371: OR (ABS_INFORMATION_CATEGORY='NL_S' and ABS_INFORMATION2='Y'))
372: and (((p_start_date between date_start and date_end)
378: l_error_code NUMBER;
379: l_non_si_days NUMBER:=0;
380: l_error_msg fnd_new_messages.message_text%TYPE;
381: l_person_id number;
382: l_start_date per_absence_attendances_v.date_start%type;
383: l_end_date per_absence_attendances_v.date_end%type;
384: l_time_start per_absence_attendances_v.time_start%type;
385: l_time_end per_absence_attendances_v.time_end%type;
386: l_temp1 date;
379: l_non_si_days NUMBER:=0;
380: l_error_msg fnd_new_messages.message_text%TYPE;
381: l_person_id number;
382: l_start_date per_absence_attendances_v.date_start%type;
383: l_end_date per_absence_attendances_v.date_end%type;
384: l_time_start per_absence_attendances_v.time_start%type;
385: l_time_end per_absence_attendances_v.time_end%type;
386: l_temp1 date;
387: l_temp2 date;
380: l_error_msg fnd_new_messages.message_text%TYPE;
381: l_person_id number;
382: l_start_date per_absence_attendances_v.date_start%type;
383: l_end_date per_absence_attendances_v.date_end%type;
384: l_time_start per_absence_attendances_v.time_start%type;
385: l_time_end per_absence_attendances_v.time_end%type;
386: l_temp1 date;
387: l_temp2 date;
388: l_curr_date date;
381: l_person_id number;
382: l_start_date per_absence_attendances_v.date_start%type;
383: l_end_date per_absence_attendances_v.date_end%type;
384: l_time_start per_absence_attendances_v.time_start%type;
385: l_time_end per_absence_attendances_v.time_end%type;
386: l_temp1 date;
387: l_temp2 date;
388: l_curr_date date;
389: l_absence_hours per_absence_attendances_v.absence_hours%type;
385: l_time_end per_absence_attendances_v.time_end%type;
386: l_temp1 date;
387: l_temp2 date;
388: l_curr_date date;
389: l_absence_hours per_absence_attendances_v.absence_hours%type;
390: l_wrking_day varchar2(1):='N';
391: BEGIN
392: OPEN c_wp_dets(P_Assignment_Id);
393: FETCH c_wp_dets INTO l_assgn_attr;