eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1619: and tbbdet.date_to = hr_general.end_of_time;

1615: and trunc(tbbday.start_time) = trunc(p_day_date)
1616: and tbbdet.resource_id = l_resource_id
1617: and tbbday.resource_id = l_resource_id
1618: and tbbtc.resource_id = l_resource_id
1619: and tbbdet.date_to = hr_general.end_of_time;
1620:
1621: */
1622:
1623: -- Bug 11837942

Line 1651: AND tbbdet.date_to = hr_general.end_of_time;

1647: AND TRUNC(tbbday.start_time) = TRUNC(p_day_date)
1648: AND tbbdet.resource_id = l_resource_id
1649: AND tbbday.resource_id = l_resource_id
1650: AND tbbtc.resource_id = l_resource_id
1651: AND tbbdet.date_to = hr_general.end_of_time;
1652:
1653:
1654: BEGIN
1655:

Line 1657: l_earliest_tc := hr_general.end_of_time;

1653:
1654: BEGIN
1655:
1656:
1657: l_earliest_tc := hr_general.end_of_time;
1658:
1659: l_latest_tc := hr_general.start_of_time;
1660:
1661: l_timecardid:=null; --added for bug 2796204

Line 1659: l_latest_tc := hr_general.start_of_time;

1655:
1656:
1657: l_earliest_tc := hr_general.end_of_time;
1658:
1659: l_latest_tc := hr_general.start_of_time;
1660:
1661: l_timecardid:=null; --added for bug 2796204
1662: l_timecardovn:=null; --added for bug 2796204
1663:

Line 1709: l_date_to = hr_general.end_of_time ) THEN

1705: -- and stop_time not null and make sure they are not end-dated!
1706: --
1707: IF (l_scope = 'DETAIL' AND l_type = 'RANGE' AND
1708: l_start_time is NOT NULL AND l_stop_time is NOT NULL AND
1709: l_date_to = hr_general.end_of_time ) THEN
1710:
1711: --
1712: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

Line 1764: l_date_to_detail = hr_general.end_of_time ) THEN

1760: end if;
1761: --
1762: IF (l_scope_detail = 'DETAIL' AND l_type_detail = 'RANGE'
1763: AND l_start_detail is NOT NULL AND l_stop_detail is NOT NULL AND
1764: l_date_to_detail = hr_general.end_of_time ) THEN
1765: --
1766: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1768: 'Inner is a DETAIL RANGE');

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

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

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

2088: WHILE l_bb_ind IS NOT NULL
2089: LOOP
2090:
2091: IF ( p_tco_bb(l_bb_ind).scope = 'DETAIL' and
2092: p_tco_bb(l_bb_ind).date_to = hr_general.end_of_time ) --Fix for Bug#2943285
2093: THEN
2094:
2095: IF ( hxc_time_category_utils_pkg.chk_tc_bb_ok ( p_tco_bb(l_bb_ind).time_building_block_id ) )
2096: THEN

Line 2496: tbb_detail.date_to=hr_general.end_of_time and

2492: WHERE
2493: tbb_day.time_building_block_id = tbb_detail.parent_building_block_id and
2494: ts.timecard_id = tbb_day.parent_building_block_id and
2495: tbb_detail.scope='DETAIL' and
2496: tbb_detail.date_to=hr_general.end_of_time and
2497: tbb_day.scope='DAY' and
2498: tbb_day.type='RANGE' and
2499: tbb_day.date_to=hr_general.end_of_time and
2500: ts.resource_id = p_resource_id and

Line 2499: tbb_day.date_to=hr_general.end_of_time and

2495: tbb_detail.scope='DETAIL' and
2496: tbb_detail.date_to=hr_general.end_of_time and
2497: tbb_day.scope='DAY' and
2498: tbb_day.type='RANGE' and
2499: tbb_day.date_to=hr_general.end_of_time and
2500: ts.resource_id = p_resource_id and
2501: to_date(to_char(tbb_day.start_time,
2502: 'DD-MON-YYYY'),
2503: 'DD-MON-YYYY') BETWEEN p_start_date AND p_end_date

Line 3412: AND detail.date_to = hr_general.end_of_time

3408: WHERE DAY.parent_building_block_id =
3409: p_timecard_rec.timecard_bb_id
3410: AND DAY.parent_building_block_ovn =
3411: p_timecard_rec.timecard_ovn
3412: AND detail.date_to = hr_general.end_of_time
3413: AND detail.SCOPE = 'DETAIL'
3414: AND detail.parent_building_block_id =
3415: DAY.time_building_block_id
3416: AND detail.parent_building_block_ovn =

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

3415: DAY.time_building_block_id
3416: AND detail.parent_building_block_ovn =
3417: DAY.object_version_number
3418: AND DAY.SCOPE = 'DAY'
3419: AND DAY.date_to = hr_general.end_of_time;
3420:
3421: -- Bug 8920374
3422: -- Changed the below query to resolve the perf issue.
3423: /*

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

5203:
5204: IF ( p_tco_bb (l_tbb_index).SCOPE = 'DETAIL'
5205: AND p_tco_bb (l_tbb_index).new = 'Y'
5206: -- Bug 2958441
5207: AND p_tco_bb (l_tbb_index).date_to = hr_general.end_of_time
5208: -- Bug 2958441
5209: )
5210: THEN
5211: l_date_worked := NULL;

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

5260:
5261: IF ( p_tco_bb (l_tbb_index).SCOPE = 'DETAIL'
5262: AND p_tco_bb (l_tbb_index).new = 'Y'
5263: -- Bug 2958441
5264: AND p_tco_bb (l_tbb_index).date_to = hr_general.end_of_time
5265: -- Bug 2958441
5266: )
5267: THEN
5268: l_date_worked := NULL;