APPS.PAY_NL_SI_PKG dependencies on PQP_SCHEDULE_CALCULATION_PKG

Line 284: l_is_wrking_day:=PQP_SCHEDULE_CALCULATION_PKG.is_working_day

280: l_curr_date:=p_start_date;
281: l_counter:=0;
282: while l_curr_date <= l_temp1
283: loop
284: l_is_wrking_day:=PQP_SCHEDULE_CALCULATION_PKG.is_working_day
285: (p_assignment_id => l_assgn_attr.assignment_id
286: ,p_business_group_id => l_assgn_attr. business_group_id
287: ,p_date => l_curr_date
288: ,p_error_code => l_error_code

Line 304: l_is_wrking_day:= PQP_SCHEDULE_CALCULATION_PKG.is_working_day

300: IF p_end_date - l_temp1 + 1 >= 7 THEN
301: l_curr_date := l_temp1 +1;
302: while l_curr_date <= l_temp2
303: loop
304: l_is_wrking_day:= PQP_SCHEDULE_CALCULATION_PKG.is_working_day
305: (p_assignment_id => l_assgn_attr.assignment_id
306: ,p_business_group_id => l_assgn_attr. business_group_id
307: ,p_date => l_curr_date
308: ,p_error_code => l_error_code

Line 327: l_is_wrking_day:= PQP_SCHEDULE_CALCULATION_PKG.is_working_day

323: END IF;
324: l_curr_date:=l_temp2 + 1;
325: while l_curr_date <= P_End_Date
326: loop
327: l_is_wrking_day:= PQP_SCHEDULE_CALCULATION_PKG.is_working_day
328: (p_assignment_id => l_assgn_attr.assignment_id
329: ,p_business_group_id => l_assgn_attr. business_group_id
330: ,p_date => l_curr_date
331: ,p_error_code => l_error_code

Line 390: l_hrs_wrked:=pqp_schedule_calculation_pkg.get_hours_worked

386: --hr_utility.set_location(' date_start'||l_absence_record.date_start,100);
387: --hr_utility.set_location(' date_end'||l_absence_record.date_end,100);
388: /*Check whether the start date and end date of the abscence period are equal*/
389: if l_absence_record.date_start = l_absence_record.date_end then
390: l_hrs_wrked:=pqp_schedule_calculation_pkg.get_hours_worked
391: (p_assignment_id => l_assgn_attr.assignment_id
392: ,p_business_group_id => l_assgn_attr.business_group_id
393: ,p_date_start => l_absence_record.date_start
394: ,p_date_end => l_absence_record.date_end

Line 415: l_wrking_day:= pqp_schedule_calculation_pkg.is_working_day

411: should be assigned*/
412: 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;
413: end if;
414: --hr_utility.set_location('l_absence_hours'||l_absence_hours,120);
415: l_wrking_day:= pqp_schedule_calculation_pkg.is_working_day
416: (p_assignment_id => l_assgn_attr.assignment_id
417: ,p_business_group_id => l_assgn_attr.business_group_id
418: ,p_date => l_absence_record.date_start
419: ,p_error_code => l_error_code

Line 447: l_wrking_day:= pqp_schedule_calculation_pkg.is_working_day

443: --shveerab
444: /* The Absence should be considered including the end date of the absence period*/
445: while l_curr_date <= l_temp2
446: loop
447: l_wrking_day:= pqp_schedule_calculation_pkg.is_working_day
448: (p_assignment_id => l_assgn_attr.assignment_id
449: ,p_business_group_id => l_assgn_attr.business_group_id
450: ,p_date => l_curr_date
451: ,p_error_code => l_error_code