DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on HR_GENERAL

Line 224: ) = hr_general.end_of_time

220: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
221:
222: IF (hxc_timecard_block_utils.date_value
223: (p_blocks (l_timecard_index).date_to
224: ) = hr_general.end_of_time
225: )
226: THEN
227: l_resubmit :=
228: hxc_timecard_approval.is_timecard_resubmitted

Line 798: ) = hr_general.end_of_time

794: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
795:
796: IF (hxc_timecard_block_utils.date_value
797: (p_blocks (l_timecard_index).date_to
798: ) = hr_general.end_of_time
799: )
800: THEN
801: l_resubmit :=
802: hxc_timecard_approval.is_timecard_resubmitted

Line 2168: AND tbb.date_to = hr_general.end_of_time

2164: WHERE tbb.SCOPE = v_scope
2165: AND tbb.resource_type = v_resource_type
2166: AND tbb.resource_id = v_resource_id
2167: AND v_start_time BETWEEN tbb.start_time AND tbb.stop_time
2168: AND tbb.date_to = hr_general.end_of_time
2169: AND parent_tbb.time_building_block_id = tbb.parent_building_block_id
2170: AND parent_tbb.object_version_number = tbb.parent_building_block_ovn
2171: AND parent_tbb.date_to = hr_general.end_of_time
2172: AND parent_tbb.SCOPE <> hxc_timecard.c_template_scope

Line 2171: AND parent_tbb.date_to = hr_general.end_of_time

2167: AND v_start_time BETWEEN tbb.start_time AND tbb.stop_time
2168: AND tbb.date_to = hr_general.end_of_time
2169: AND parent_tbb.time_building_block_id = tbb.parent_building_block_id
2170: AND parent_tbb.object_version_number = tbb.parent_building_block_ovn
2171: AND parent_tbb.date_to = hr_general.end_of_time
2172: AND parent_tbb.SCOPE <> hxc_timecard.c_template_scope
2173: GROUP BY tbb.time_building_block_id;
2174:
2175: l_building_block_count PLS_INTEGER;

Line 2596: AND date_to = hr_general.end_of_time

2592: IS
2593: SELECT time_building_block_id, MAX (object_version_number)
2594: FROM hxc_time_building_blocks
2595: WHERE SCOPE = hxc_timecard.c_timecard_scope
2596: AND date_to = hr_general.end_of_time
2597: CONNECT BY PRIOR parent_building_block_id = time_building_block_id
2598: AND PRIOR parent_building_block_ovn = object_version_number
2599: START WITH time_building_block_id = v_tc_id
2600: GROUP BY time_building_block_id

Line 2866: AND date_to = hr_general.end_of_time

2862: AND v_start_time >= start_time
2863: AND v_stop_time <= stop_time
2864: AND v_resource_id = resource_id
2865: AND v_resource_type = resource_type
2866: AND date_to = hr_general.end_of_time
2867: GROUP BY time_building_block_id;
2868: BEGIN
2869: g_debug :=hr_utility.debug_enabled;
2870: if g_debug then

Line 3990: l_past_date_limit := hr_general.START_OF_TIME;

3986: IF l_num_past_days IS NOT NULL
3987: THEN
3988: l_past_date_limit := SYSDATE - TO_NUMBER(l_num_past_days);
3989: ELSE
3990: l_past_date_limit := hr_general.START_OF_TIME;
3991: END IF;
3992:
3993: IF l_num_future_days IS NOT NULL
3994: THEN

Line 3997: l_future_date_limit := hr_general.END_OF_TIME;

3993: IF l_num_future_days IS NOT NULL
3994: THEN
3995: l_future_date_limit := SYSDATE + TO_NUMBER(l_num_future_days);
3996: ELSE
3997: l_future_date_limit := hr_general.END_OF_TIME;
3998: END IF;
3999:
4000: l_past_date_limit := TRUNC(l_past_date_limit);
4001: l_future_date_limit := TRUNC(l_future_date_limit);