APPS.PAY_NL_SI_PKG dependencies on PQP_SCHEDULE_CALCULATION_PKG

Line 301: l_is_wrking_day:=PQP_SCHEDULE_CALCULATION_PKG.is_working_day

297: l_curr_date:=p_start_date;
298: l_counter:=0;
299: while l_curr_date <= l_temp1
300: loop
301: l_is_wrking_day:=PQP_SCHEDULE_CALCULATION_PKG.is_working_day
302: (p_assignment_id => l_assgn_attr.assignment_id
303: ,p_business_group_id => l_assgn_attr. business_group_id
304: ,p_date => l_curr_date
305: ,p_error_code => l_error_code

Line 321: l_is_wrking_day:= PQP_SCHEDULE_CALCULATION_PKG.is_working_day

317: IF p_end_date - l_temp1 + 1 >= 7 THEN
318: l_curr_date := l_temp1 +1;
319: while l_curr_date <= l_temp2
320: loop
321: l_is_wrking_day:= PQP_SCHEDULE_CALCULATION_PKG.is_working_day
322: (p_assignment_id => l_assgn_attr.assignment_id
323: ,p_business_group_id => l_assgn_attr. business_group_id
324: ,p_date => l_curr_date
325: ,p_error_code => l_error_code

Line 344: l_is_wrking_day:= PQP_SCHEDULE_CALCULATION_PKG.is_working_day

340: END IF;
341: l_curr_date:=l_temp2 + 1;
342: while l_curr_date <= P_End_Date
343: loop
344: l_is_wrking_day:= PQP_SCHEDULE_CALCULATION_PKG.is_working_day
345: (p_assignment_id => l_assgn_attr.assignment_id
346: ,p_business_group_id => l_assgn_attr. business_group_id
347: ,p_date => l_curr_date
348: ,p_error_code => l_error_code

Line 407: l_hrs_wrked:=pqp_schedule_calculation_pkg.get_hours_worked

403: --hr_utility.set_location(' date_start'||l_absence_record.date_start,100);
404: --hr_utility.set_location(' date_end'||l_absence_record.date_end,100);
405: /*Check whether the start date and end date of the abscence period are equal*/
406: if l_absence_record.date_start = l_absence_record.date_end then
407: l_hrs_wrked:=pqp_schedule_calculation_pkg.get_hours_worked
408: (p_assignment_id => l_assgn_attr.assignment_id
409: ,p_business_group_id => l_assgn_attr.business_group_id
410: ,p_date_start => l_absence_record.date_start
411: ,p_date_end => l_absence_record.date_end

Line 432: l_wrking_day:= pqp_schedule_calculation_pkg.is_working_day

428: should be assigned*/
429: l_absence_hours := (to_date('0001/01/01 '||l_absence_record.time_end,'yyyy/mm/dd hh24:mi') - to_date('0001/01/01 '||l_absence_record.time_start,'yyyy/mm/dd hh24:mi'))*24;
430: end if;
431: --hr_utility.set_location('l_absence_hours'||l_absence_hours,120);
432: l_wrking_day:= pqp_schedule_calculation_pkg.is_working_day
433: (p_assignment_id => l_assgn_attr.assignment_id
434: ,p_business_group_id => l_assgn_attr.business_group_id
435: ,p_date => l_absence_record.date_start
436: ,p_error_code => l_error_code

Line 464: l_wrking_day:= pqp_schedule_calculation_pkg.is_working_day

460: --shveerab
461: /* The Absence should be considered including the end date of the absence period*/
462: while l_curr_date <= l_temp2
463: loop
464: l_wrking_day:= pqp_schedule_calculation_pkg.is_working_day
465: (p_assignment_id => l_assgn_attr.assignment_id
466: ,p_business_group_id => l_assgn_attr.business_group_id
467: ,p_date => l_curr_date
468: ,p_error_code => l_error_code