DBA Data[Home] [Help]

APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HR_GENERAL

Line 62: IF ( p_time_building_blocks(l_tbb_index).date_to = hr_general.end_of_time )

58:
59: -- GPM v115.32
60: p_timecard_rec.new := p_time_building_blocks(l_tbb_index).new;
61:
62: IF ( p_time_building_blocks(l_tbb_index).date_to = hr_general.end_of_time )
63: THEN
64: --p_timecard_rec.deleted := 'N';
65: deletedFlag := false;
66: EXIT;

Line 1595: and tbbdet.date_to = hr_general.end_of_time;

1591: and tbbdet.parent_building_block_ovn = tbbday.object_version_number
1592: and trunc(tbbday.start_time)=trunc(p_day_date)
1593: and tbbdet.resource_id = l_resource_id
1594: and tbbday.resource_id = l_resource_id
1595: and tbbdet.date_to = hr_general.end_of_time;
1596:
1597:
1598:
1599: BEGIN

Line 1602: l_earliest_tc := hr_general.end_of_time;

1598:
1599: BEGIN
1600:
1601:
1602: l_earliest_tc := hr_general.end_of_time;
1603:
1604: l_latest_tc := hr_general.start_of_time;
1605:
1606: l_timecardid:=null; --added for bug 2796204

Line 1604: l_latest_tc := hr_general.start_of_time;

1600:
1601:
1602: l_earliest_tc := hr_general.end_of_time;
1603:
1604: l_latest_tc := hr_general.start_of_time;
1605:
1606: l_timecardid:=null; --added for bug 2796204
1607: l_timecardovn:=null; --added for bug 2796204
1608:

Line 1654: l_date_to = hr_general.end_of_time ) THEN

1650: -- and stop_time not null and make sure they are not end-dated!
1651: --
1652: IF (l_scope = 'DETAIL' AND l_type = 'RANGE' AND
1653: l_start_time is NOT NULL AND l_stop_time is NOT NULL AND
1654: l_date_to = hr_general.end_of_time ) THEN
1655:
1656: --
1657: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

Line 1709: l_date_to_detail = hr_general.end_of_time ) THEN

1705: end if;
1706: --
1707: IF (l_scope_detail = 'DETAIL' AND l_type_detail = 'RANGE'
1708: AND l_start_detail is NOT NULL AND l_stop_detail is NOT NULL AND
1709: l_date_to_detail = hr_general.end_of_time ) THEN
1710: --
1711: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1713: 'Inner is a DETAIL RANGE');

Line 1983: p_tco_bb(l_bb_ind).date_to = hr_general.end_of_time ) --Fix for Bug#2943285

1979: WHILE l_bb_ind IS NOT NULL
1980: LOOP
1981:
1982: IF ( p_tco_bb(l_bb_ind).scope = 'DETAIL' and
1983: p_tco_bb(l_bb_ind).date_to = hr_general.end_of_time ) --Fix for Bug#2943285
1984: THEN
1985:
1986: IF ( NOT hxc_time_category_utils_pkg.chk_tc_bb_ok ( p_tco_bb(l_bb_ind).time_building_block_id ) )
1987: THEN

Line 2037: p_tco_bb(l_bb_ind).date_to = hr_general.end_of_time ) --Fix for Bug#2943285

2033: WHILE l_bb_ind IS NOT NULL
2034: LOOP
2035:
2036: IF ( p_tco_bb(l_bb_ind).scope = 'DETAIL' and
2037: p_tco_bb(l_bb_ind).date_to = hr_general.end_of_time ) --Fix for Bug#2943285
2038: THEN
2039:
2040: IF ( hxc_time_category_utils_pkg.chk_tc_bb_ok ( p_tco_bb(l_bb_ind).time_building_block_id ) )
2041: THEN

Line 2441: tbb_detail.date_to=hr_general.end_of_time and

2437: WHERE
2438: tbb_day.time_building_block_id = tbb_detail.parent_building_block_id and
2439: ts.timecard_id = tbb_day.parent_building_block_id and
2440: tbb_detail.scope='DETAIL' and
2441: tbb_detail.date_to=hr_general.end_of_time and
2442: tbb_day.scope='DAY' and
2443: tbb_day.type='RANGE' and
2444: tbb_day.date_to=hr_general.end_of_time and
2445: ts.resource_id = p_resource_id and

Line 2444: tbb_day.date_to=hr_general.end_of_time and

2440: tbb_detail.scope='DETAIL' and
2441: tbb_detail.date_to=hr_general.end_of_time and
2442: tbb_day.scope='DAY' and
2443: tbb_day.type='RANGE' and
2444: tbb_day.date_to=hr_general.end_of_time and
2445: ts.resource_id = p_resource_id and
2446: to_date(to_char(tbb_day.start_time,
2447: 'DD-MON-YYYY'),
2448: 'DD-MON-YYYY') BETWEEN p_start_date AND p_end_date

Line 3357: AND detail.date_to = hr_general.end_of_time

3353: WHERE DAY.parent_building_block_id =
3354: p_timecard_rec.timecard_bb_id
3355: AND DAY.parent_building_block_ovn =
3356: p_timecard_rec.timecard_ovn
3357: AND detail.date_to = hr_general.end_of_time
3358: AND detail.SCOPE = 'DETAIL'
3359: AND detail.parent_building_block_id =
3360: DAY.time_building_block_id
3361: AND detail.parent_building_block_ovn =

Line 3364: AND DAY.date_to = hr_general.end_of_time;

3360: DAY.time_building_block_id
3361: AND detail.parent_building_block_ovn =
3362: DAY.object_version_number
3363: AND DAY.SCOPE = 'DAY'
3364: AND DAY.date_to = hr_general.end_of_time;
3365:
3366: CURSOR csr_get_det_attr (p_building_block_id NUMBER, p_bb_ovn NUMBER)
3367: IS
3368: SELECT a.time_attribute_id, au.time_building_block_id,

Line 5110: AND p_tco_bb (l_tbb_index).date_to = hr_general.end_of_time

5106:
5107: IF ( p_tco_bb (l_tbb_index).SCOPE = 'DETAIL'
5108: AND p_tco_bb (l_tbb_index).new = 'Y'
5109: -- Bug 2958441
5110: AND p_tco_bb (l_tbb_index).date_to = hr_general.end_of_time
5111: -- Bug 2958441
5112: )
5113: THEN
5114: l_date_worked := NULL;

Line 5167: AND p_tco_bb (l_tbb_index).date_to = hr_general.end_of_time

5163:
5164: IF ( p_tco_bb (l_tbb_index).SCOPE = 'DETAIL'
5165: AND p_tco_bb (l_tbb_index).new = 'Y'
5166: -- Bug 2958441
5167: AND p_tco_bb (l_tbb_index).date_to = hr_general.end_of_time
5168: -- Bug 2958441
5169: )
5170: THEN
5171: l_date_worked := NULL;