APPS.HXC_TIMECARD_SUMMARY_PKG dependencies on HXC_RETRIEVE_ABSENCES

Line 373: WHERE resource_id = hxc_retrieve_absences.g_person_id

369: nvl(absence_hours,0)
370: INTO l_abs_days,
371: l_abs_hours
372: FROM hxc_absence_summary_temp
373: WHERE resource_id = hxc_retrieve_absences.g_person_id
374: AND start_time = hxc_retrieve_absences.g_start_time
375: AND stop_time = hxc_retrieve_absences.g_stop_time;
376:
377: EXCEPTION

Line 374: AND start_time = hxc_retrieve_absences.g_start_time

370: INTO l_abs_days,
371: l_abs_hours
372: FROM hxc_absence_summary_temp
373: WHERE resource_id = hxc_retrieve_absences.g_person_id
374: AND start_time = hxc_retrieve_absences.g_start_time
375: AND stop_time = hxc_retrieve_absences.g_stop_time;
376:
377: EXCEPTION
378: WHEN NO_DATA_FOUND THEN

Line 375: AND stop_time = hxc_retrieve_absences.g_stop_time;

371: l_abs_hours
372: FROM hxc_absence_summary_temp
373: WHERE resource_id = hxc_retrieve_absences.g_person_id
374: AND start_time = hxc_retrieve_absences.g_start_time
375: AND stop_time = hxc_retrieve_absences.g_stop_time;
376:
377: EXCEPTION
378: WHEN NO_DATA_FOUND THEN
379: l_abs_days := 0;

Line 405: hxc_retrieve_absences.clear_absence_summary_rows;

401: hr_utility.trace('ABS> In hxc_timecard_summary_pkg.insert_summary_row');
402: hr_utility.trace('ABS> clear absence summary rows');
403: END IF;
404:
405: hxc_retrieve_absences.clear_absence_summary_rows;
406:
407: END IF;
408: -- OTL-ABS END
409: