DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_PROCESS dependencies on HXC_RETRIEVE_ABSENCES

Line 5852: HXC_RETRIEVE_ABSENCES.g_lock_row_id:= ROWIDTOCHAR(l_row_locked_id);

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:

Line 5853: HXC_RETRIEVE_ABSENCES.g_person_id:=l_resource_id;

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;

Line 5854: HXC_RETRIEVE_ABSENCES.g_start_time:=TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR');

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

Line 5855: HXC_RETRIEVE_ABSENCES.g_stop_time:=TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR');

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:

Line 5857: HXC_RETRIEVE_ABSENCES.g_detail_trans_tab.DELETE;

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');

Line 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);

Line 5863: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_lock_row_id = '||HXC_RETRIEVE_ABSENCES.g_lock_row_id);

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;

Line 5864: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_person_id = '||HXC_RETRIEVE_ABSENCES.g_person_id);

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:

Line 5865: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_start_time = '||HXC_RETRIEVE_ABSENCES.g_start_time);

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:

Line 5866: hr_utility.trace('HXC_RETRIEVE_ABSENCES.g_stop_time = '||HXC_RETRIEVE_ABSENCES.g_stop_time);

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 (

Line 9578: p_abs_status IN OUT NOCOPY HXC_RETRIEVE_ABSENCES.ABS_STATUS_TAB)

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

Line 9584: HXC_RETRIEVE_ABSENCES.get_abs_statuses ( p_person_id => p_resource_id,

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: