APPS.HXC_RETRIEVE_ABSENCES dependencies on HR_GENERAL

Line 487: p_block_array(l_block_ind).DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);

483: p_block_array(l_block_ind).RESOURCE_ID := p_person_id;
484: p_block_array(l_block_ind).RESOURCE_TYPE := 'PERSON';
485: p_block_array(l_block_ind).APPROVAL_STYLE_ID := NULL;
486: p_block_array(l_block_ind).DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
487: p_block_array(l_block_ind).DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);
488: p_block_array(l_block_ind).COMMENT_TEXT := NULL;
489: p_block_array(l_block_ind).PARENT_BUILDING_BLOCK_OVN := NULL;
490: p_block_array(l_block_ind).NEW := 'Y';
491: p_block_array(l_block_ind).CHANGED := 'Y';

Line 543: trunc(hr_general.end_of_time));

539: p_approval_style_id,
540: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,'YYYYMMDD')),
541: l_det_id,
542: 1,
543: trunc(hr_general.end_of_time));
544: p_attribute_array(l_att_ind) := get_attribute_for_detail(l_det_id,
545: 1,
546: l_abs_tab(i).element_type_id,
547: l_abs_tab(i).abs_attendance_id,

Line 732: p_block_array(l_block_ind).DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);

728: p_block_array(l_block_ind).RESOURCE_ID := p_person_id;
729: p_block_array(l_block_ind).RESOURCE_TYPE := 'PERSON';
730: p_block_array(l_block_ind).APPROVAL_STYLE_ID := NULL;
731: p_block_array(l_block_ind).DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
732: p_block_array(l_block_ind).DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);
733: p_block_array(l_block_ind).COMMENT_TEXT := NULL;
734: p_block_array(l_block_ind).PARENT_BUILDING_BLOCK_OVN := NULL;
735: p_block_array(l_block_ind).NEW := 'Y';
736: p_block_array(l_block_ind).CHANGED := 'Y';

Line 818: TRUNC(hr_general.end_of_time));

814: p_approval_style_id,
815: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,'YYYYMMDD')),
816: l_det_id,
817: 1,
818: TRUNC(hr_general.end_of_time));
819: p_attribute_array(l_att_ind) := get_attribute_for_detail(l_det_id,
820: 1,
821: l_abs_tab(i).element_type_id,
822: l_abs_tab(i).abs_attendance_id,

Line 963: l_block_type.DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);

959: l_block_type.RESOURCE_ID := p_person_id;
960: l_block_type.RESOURCE_TYPE := 'PERSON';
961: l_block_type.APPROVAL_STYLE_ID := p_approval_style_id;
962: l_block_type.DATE_FROM := FND_DATE.DATE_TO_CANONICAL(SYSDATE);
963: l_block_type.DATE_TO := FND_DATE.DATE_TO_CANONICAL(hr_general.end_of_time);
964: l_block_type.PARENT_BUILDING_BLOCK_OVN := 1;
965: l_block_type.NEW := 'Y';
966: l_block_type.CHANGED := 'Y';
967: l_block_type.PROCESS := NULL;

Line 2037: TRUNC(hr_general.end_of_time));

2033: p_approval_style_id,
2034: l_day_id_tab(FND_DATE.DATE_TO_CANONICAL(l_abs_tab(l_index).abs_date)),
2035: l_det_id,
2036: 1,
2037: TRUNC(hr_general.end_of_time));
2038: p_attribute_array(l_att_ind) := get_attribute_for_detail(l_det_id,
2039: 1,
2040: l_abs_tab(l_index).element_type_id,
2041: l_abs_tab(l_index).abs_attendance_id,

Line 3458: AND FND_DATE.canonical_to_date(p_blocks(i).DATE_TO) = hr_general.end_of_time

3454: LOOP
3455: IF p_blocks(i).scope = 'TIMECARD'
3456: -- Bug 8858587
3457: -- Dont do any of these in case the timecard is going to be deleted.
3458: AND FND_DATE.canonical_to_date(p_blocks(i).DATE_TO) = hr_general.end_of_time
3459: THEN
3460: hxc_preference_evaluation.resource_preferences(p_blocks(i).resource_id,
3461: FND_DATE.canonical_to_date(p_blocks(i).start_time),
3462: FND_DATE.canonical_to_date(p_blocks(i).start_time),

Line 3483: OR FND_DATE.canonical_to_date(p_blocks(i).DATE_TO) <> hr_general.end_of_time

3479: EXIT TO_CONTINUE_TO_NEXT_BLOCK;
3480: END IF;
3481:
3482: IF p_blocks(i).SCOPE <> 'DETAIL'
3483: OR FND_DATE.canonical_to_date(p_blocks(i).DATE_TO) <> hr_general.end_of_time
3484: THEN
3485: EXIT TO_CONTINUE_TO_NEXT_BLOCK;
3486: END IF;
3487: bb_index := p_blocks(i).time_building_block_id;