347: P_Start_Date Date,
348: P_End_Date Date) return NUMBER IS
349: CURSOR Get_Non_SI_Absence(p_person_id number) is
350: select date_start,date_end,time_start,time_end
351: from per_absence_attendances_v
352: where person_id=p_person_id
353: and ((ABS_INFORMATION_CATEGORY='NL' and ABS_INFORMATION1='Y')
354: OR (ABS_INFORMATION_CATEGORY='NL_S' and ABS_INFORMATION2='Y'))
355: and (((p_start_date between date_start and date_end)
361: l_error_code NUMBER;
362: l_non_si_days NUMBER:=0;
363: l_error_msg fnd_new_messages.message_text%TYPE;
364: l_person_id number;
365: l_start_date per_absence_attendances_v.date_start%type;
366: l_end_date per_absence_attendances_v.date_end%type;
367: l_time_start per_absence_attendances_v.time_start%type;
368: l_time_end per_absence_attendances_v.time_end%type;
369: l_temp1 date;
362: l_non_si_days NUMBER:=0;
363: l_error_msg fnd_new_messages.message_text%TYPE;
364: l_person_id number;
365: l_start_date per_absence_attendances_v.date_start%type;
366: l_end_date per_absence_attendances_v.date_end%type;
367: l_time_start per_absence_attendances_v.time_start%type;
368: l_time_end per_absence_attendances_v.time_end%type;
369: l_temp1 date;
370: l_temp2 date;
363: l_error_msg fnd_new_messages.message_text%TYPE;
364: l_person_id number;
365: l_start_date per_absence_attendances_v.date_start%type;
366: l_end_date per_absence_attendances_v.date_end%type;
367: l_time_start per_absence_attendances_v.time_start%type;
368: l_time_end per_absence_attendances_v.time_end%type;
369: l_temp1 date;
370: l_temp2 date;
371: l_curr_date date;
364: l_person_id number;
365: l_start_date per_absence_attendances_v.date_start%type;
366: l_end_date per_absence_attendances_v.date_end%type;
367: l_time_start per_absence_attendances_v.time_start%type;
368: l_time_end per_absence_attendances_v.time_end%type;
369: l_temp1 date;
370: l_temp2 date;
371: l_curr_date date;
372: l_absence_hours per_absence_attendances_v.absence_hours%type;
368: l_time_end per_absence_attendances_v.time_end%type;
369: l_temp1 date;
370: l_temp2 date;
371: l_curr_date date;
372: l_absence_hours per_absence_attendances_v.absence_hours%type;
373: l_wrking_day varchar2(1):='N';
374: BEGIN
375: OPEN c_wp_dets(P_Assignment_Id);
376: FETCH c_wp_dets INTO l_assgn_attr;