5848:
5849: */
5850:
5851: -- Change start
5852: HXC_RETRIEVE_ABSENCES.g_lock_row_id:= ROWIDTOCHAR(l_row_locked_id);
5853: HXC_RETRIEVE_ABSENCES.g_person_id:=l_resource_id;
5854: HXC_RETRIEVE_ABSENCES.g_start_time:=TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR');
5855: HXC_RETRIEVE_ABSENCES.g_stop_time:=TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR');
5856:
5849: */
5850:
5851: -- Change start
5852: HXC_RETRIEVE_ABSENCES.g_lock_row_id:= ROWIDTOCHAR(l_row_locked_id);
5853: HXC_RETRIEVE_ABSENCES.g_person_id:=l_resource_id;
5854: HXC_RETRIEVE_ABSENCES.g_start_time:=TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR');
5855: HXC_RETRIEVE_ABSENCES.g_stop_time:=TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR');
5856:
5857: HXC_RETRIEVE_ABSENCES.g_detail_trans_tab.DELETE;
5850:
5851: -- Change start
5852: HXC_RETRIEVE_ABSENCES.g_lock_row_id:= ROWIDTOCHAR(l_row_locked_id);
5853: HXC_RETRIEVE_ABSENCES.g_person_id:=l_resource_id;
5854: HXC_RETRIEVE_ABSENCES.g_start_time:=TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR');
5855: HXC_RETRIEVE_ABSENCES.g_stop_time:=TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR');
5856:
5857: HXC_RETRIEVE_ABSENCES.g_detail_trans_tab.DELETE;
5858: -- Change end
5851: -- Change start
5852: HXC_RETRIEVE_ABSENCES.g_lock_row_id:= ROWIDTOCHAR(l_row_locked_id);
5853: HXC_RETRIEVE_ABSENCES.g_person_id:=l_resource_id;
5854: HXC_RETRIEVE_ABSENCES.g_start_time:=TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR');
5855: HXC_RETRIEVE_ABSENCES.g_stop_time:=TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR');
5856:
5857: HXC_RETRIEVE_ABSENCES.g_detail_trans_tab.DELETE;
5858: -- Change end
5859:
5853: HXC_RETRIEVE_ABSENCES.g_person_id:=l_resource_id;
5854: HXC_RETRIEVE_ABSENCES.g_start_time:=TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR');
5855: HXC_RETRIEVE_ABSENCES.g_stop_time:=TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR');
5856:
5857: HXC_RETRIEVE_ABSENCES.g_detail_trans_tab.DELETE;
5858: -- Change end
5859:
5860: if g_debug then
5861: hr_utility.trace('Global vars initialized in hxctksta - save timecard for hxc_retrieve_absences');
5857: HXC_RETRIEVE_ABSENCES.g_detail_trans_tab.DELETE;
5858: -- Change end
5859:
5860: if g_debug then
5861: hr_utility.trace('Global vars initialized in hxctksta - save timecard for hxc_retrieve_absences');
5862: hr_utility.trace('-----------------------------');
5863: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_lock_row_id = '||HXC_RETRIEVE_ABSENCES.g_lock_row_id);
5864: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_person_id = '||HXC_RETRIEVE_ABSENCES.g_person_id);
5865: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_start_time = '||HXC_RETRIEVE_ABSENCES.g_start_time);
5859:
5860: if g_debug then
5861: hr_utility.trace('Global vars initialized in hxctksta - save timecard for hxc_retrieve_absences');
5862: hr_utility.trace('-----------------------------');
5863: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_lock_row_id = '||HXC_RETRIEVE_ABSENCES.g_lock_row_id);
5864: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_person_id = '||HXC_RETRIEVE_ABSENCES.g_person_id);
5865: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_start_time = '||HXC_RETRIEVE_ABSENCES.g_start_time);
5866: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_stop_time = '||HXC_RETRIEVE_ABSENCES.g_stop_time);
5867: end if;
5860: if g_debug then
5861: hr_utility.trace('Global vars initialized in hxctksta - save timecard for hxc_retrieve_absences');
5862: hr_utility.trace('-----------------------------');
5863: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_lock_row_id = '||HXC_RETRIEVE_ABSENCES.g_lock_row_id);
5864: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_person_id = '||HXC_RETRIEVE_ABSENCES.g_person_id);
5865: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_start_time = '||HXC_RETRIEVE_ABSENCES.g_start_time);
5866: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_stop_time = '||HXC_RETRIEVE_ABSENCES.g_stop_time);
5867: end if;
5868:
5861: hr_utility.trace('Global vars initialized in hxctksta - save timecard for hxc_retrieve_absences');
5862: hr_utility.trace('-----------------------------');
5863: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_lock_row_id = '||HXC_RETRIEVE_ABSENCES.g_lock_row_id);
5864: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_person_id = '||HXC_RETRIEVE_ABSENCES.g_person_id);
5865: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_start_time = '||HXC_RETRIEVE_ABSENCES.g_start_time);
5866: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_stop_time = '||HXC_RETRIEVE_ABSENCES.g_stop_time);
5867: end if;
5868:
5869:
5862: hr_utility.trace('-----------------------------');
5863: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_lock_row_id = '||HXC_RETRIEVE_ABSENCES.g_lock_row_id);
5864: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_person_id = '||HXC_RETRIEVE_ABSENCES.g_person_id);
5865: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_start_time = '||HXC_RETRIEVE_ABSENCES.g_start_time);
5866: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_stop_time = '||HXC_RETRIEVE_ABSENCES.g_stop_time);
5867: end if;
5868:
5869:
5870: hxc_timekeeper.save_timecard (
9574:
9575: PROCEDURE get_absence_statuses ( p_resource_id IN NUMBER,
9576: p_start_date IN DATE,
9577: p_end_date IN DATE,
9578: p_abs_status IN OUT NOCOPY HXC_RETRIEVE_ABSENCES.ABS_STATUS_TAB)
9579: IS
9580:
9581:
9582: BEGIN
9580:
9581:
9582: BEGIN
9583:
9584: HXC_RETRIEVE_ABSENCES.get_abs_statuses ( p_person_id => p_resource_id,
9585: p_start_date => p_start_date,
9586: p_end_date => p_end_date + g_one_day,
9587: p_abs_status_rec => p_abs_status);
9588: