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_TIMEKEEPER_UTILITIES dependencies on HR_GENERAL

Line 279: AND DAY.date_to = hr_general.end_of_time

275: AND DAY.object_version_number = detail.parent_building_block_ovn
276: AND DAY.SCOPE = 'DAY'
277: AND detail.resource_id = l_resource_id
278: AND detail.SCOPE = 'DETAIL'
279: AND DAY.date_to = hr_general.end_of_time
280: AND detail.date_to = hr_general.end_of_time
281: AND DAY.parent_building_block_id = timecard_id
282: AND DAY.parent_building_block_ovn = timecard_ovn
283: AND DAY.resource_id = l_resource_id)

Line 280: AND detail.date_to = hr_general.end_of_time

276: AND DAY.SCOPE = 'DAY'
277: AND detail.resource_id = l_resource_id
278: AND detail.SCOPE = 'DETAIL'
279: AND DAY.date_to = hr_general.end_of_time
280: AND detail.date_to = hr_general.end_of_time
281: AND DAY.parent_building_block_id = timecard_id
282: AND DAY.parent_building_block_ovn = timecard_ovn
283: AND DAY.resource_id = l_resource_id)
284: UNION

Line 298: WHERE DAY.date_to = hr_general.end_of_time

294: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
295: AND (au.time_building_block_id, au.time_building_block_ovn) IN
296: (SELECT DAY.time_building_block_id, DAY.object_version_number
297: FROM hxc_time_building_blocks DAY
298: WHERE DAY.date_to = hr_general.end_of_time
299: AND DAY.SCOPE = 'DAY'
300: AND DAY.parent_building_block_id = timecard_id
301: AND DAY.parent_building_block_ovn = timecard_ovn
302: AND DAY.resource_id = l_resource_id)

Line 317: WHERE htbb.date_to = hr_general.end_of_time

313: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
314: AND (au.time_building_block_id, au.time_building_block_ovn) IN
315: (SELECT time_building_block_id, object_version_number
316: FROM hxc_time_building_blocks htbb
317: WHERE htbb.date_to = hr_general.end_of_time
318: AND htbb.SCOPE = 'TIMECARD'
319: AND htbb.time_building_block_id = timecard_id
320: AND htbb.object_version_number = timecard_ovn
321: AND htbb.resource_id = l_resource_id)

Line 844: AND date_to = hr_general.end_of_time

840: WHERE resource_id
841: /*ADVICE(829): Cursor references an external variable (use a parameter) [209] */
842: = p_resource_id
843: AND SCOPE = 'TIMECARD'
844: AND date_to = hr_general.end_of_time
845: AND TO_DATE (p_tc_frdt, 'dd-mm-rrrr') BETWEEN TO_DATE (start_time, 'dd-mm-rrrr')
846: AND TO_DATE (stop_time, 'dd-mm-rrrr')
847: UNION
848: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')

Line 854: AND date_to = hr_general.end_of_time

850: WHERE resource_id
851: /*ADVICE(839): Cursor references an external variable (use a parameter) [209] */
852: = p_resource_id
853: AND SCOPE = 'TIMECARD'
854: AND date_to = hr_general.end_of_time
855: AND TO_DATE (p_tc_todt, 'dd-mm-rrrr') BETWEEN TO_DATE (start_time, 'dd-mm-rrrr')
856: AND TO_DATE (stop_time, 'dd-mm-rrrr')
857: UNION
858: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')

Line 864: AND date_to = hr_general.end_of_time

860: WHERE resource_id
861: /*ADVICE(849): Cursor references an external variable (use a parameter) [209] */
862: = p_resource_id
863: AND SCOPE = 'TIMECARD'
864: AND date_to = hr_general.end_of_time
865: AND TO_DATE (start_time, 'dd-mm-rrrr') >= TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
866: AND TO_DATE (stop_time, 'dd-mm-rrrr') <= TO_DATE (p_tc_todt, 'dd-mm-rrrr')
867: MINUS
868: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')

Line 874: AND date_to = hr_general.end_of_time

870: WHERE resource_id
871: /*ADVICE(859): Cursor references an external variable (use a parameter) [209] */
872: = p_resource_id
873: AND SCOPE = 'TIMECARD'
874: AND date_to = hr_general.end_of_time
875: AND TO_DATE (start_time, 'dd-mm-rrrr') = TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
876: AND TO_DATE (stop_time, 'dd-mm-rrrr') = TO_DATE (p_tc_todt, 'dd-mm-rrrr')
877: ORDER BY 4;
878:

Line 922: and date_to=hr_general.end_of_time

918: select start_time,stop_time,to_date(start_time)
919: from hxc_time_building_blocks
920: where resource_id = p_resource_id
921: and scope='TIMECARD'
922: and date_to=hr_general.end_of_time
923: and to_date(start_time,'dd-mm-rrrr') >=to_date(p_tc_frdt,'dd-mm-rrrr') and
924: to_date(stop_time,'dd-mm-rrrr') <=to_date(p_tc_todt,'dd-mm-rrrr')
925: union
926: select tc_frdt,tc_todt,to_date(tc_frdt)

Line 937: AND date_to = hr_general.end_of_time

933: WHERE resource_id
934: /*ADVICE(922): Cursor references an external variable (use a parameter) [209] */
935: = p_resource_id
936: AND SCOPE = 'TIMECARD'
937: AND date_to = hr_general.end_of_time
938: AND TO_DATE (start_time, 'dd-mm-rrrr') >= TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
939: AND TO_DATE (stop_time, 'dd-mm-rrrr') <= TO_DATE (p_tc_todt, 'dd-mm-rrrr')
940: UNION
941: SELECT TO_DATE (tc_frdt

Line 1318: hr_general.end_of_time) >= p_tc_start_date

1314: FROM per_periods_of_service
1315: WHERE person_id = p_resource_id
1316: AND date_start <= p_tc_end_date
1317: AND COALESCE(final_process_date,actual_termination_date,
1318: hr_general.end_of_time) >= p_tc_start_date
1319: UNION
1320: SELECT date_start
1321: FROM per_periods_of_placement
1322: WHERE person_id = p_resource_id

Line 1325: hr_general.end_of_time) >= p_tc_start_date

1321: FROM per_periods_of_placement
1322: WHERE person_id = p_resource_id
1323: AND date_start <= p_tc_end_date
1324: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,
1325: hr_general.end_of_time) >= p_tc_start_date
1326: ORDER BY date_start ;
1327:
1328:
1329: /*Cursor Modified By Mithun for CWK Terminate Bug*/

Line 1364: hr_general.end_of_time) >= p_tc_start_date

1360: FROM per_periods_of_service
1361: WHERE person_id = p_resource_id
1362: AND date_start <= p_tc_end_date
1363: AND COALESCE(final_process_date,actual_termination_date,
1364: hr_general.end_of_time) >= p_tc_start_date
1365: UNION
1366: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date,
1367: date_start
1368: FROM PER_PERIODS_OF_placement

Line 1372: hr_general.end_of_time) >= p_tc_start_date

1368: FROM PER_PERIODS_OF_placement
1369: WHERE person_id = p_resource_id
1370: AND date_start <= p_tc_end_date
1371: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,
1372: hr_general.end_of_time) >= p_tc_start_date
1373: ORDER BY date_start DESC;
1374:
1375:
1376:

Line 1525: AND date_to = hr_general.end_of_time

1521: ) IS
1522: SELECT TRUNC (start_time), TRUNC (stop_time)
1523: FROM hxc_time_building_blocks
1524: WHERE SCOPE = 'TIMECARD'
1525: AND date_to = hr_general.end_of_time
1526: AND resource_id = p_resource_id
1527: AND resource_type = p_resource_type
1528: AND stop_time >= p_first_start_date
1529: AND start_time <= p_last_end_date;

Line 1573: hr_general.end_of_time) > p_past_date

1569: IS SELECT date_start
1570: FROM per_periods_of_service
1571: WHERE person_id = p_resource_id
1572: AND COALESCE(final_process_date,actual_termination_date,
1573: hr_general.end_of_time) > p_past_date
1574: UNION
1575: SELECT date_start
1576: FROM per_periods_of_placement
1577: WHERE person_id = p_resource_id

Line 1579: hr_general.end_of_time) > p_past_date

1575: SELECT date_start
1576: FROM per_periods_of_placement
1577: WHERE person_id = p_resource_id
1578: AND COALESCE(final_process_date,actual_termination_date,
1579: hr_general.end_of_time) > p_past_date
1580: ORDER BY date_start ;
1581:
1582:
1583:

Line 1613: NVL(LEAD(date_start) OVER (ORDER BY date_start)-1,hr_general.end_of_time) end_date

1609:
1610:
1611: CURSOR c_emp_inactive ( p_resource_id NUMBER )
1612: IS SELECT final_process_date start_date,
1613: NVL(LEAD(date_start) OVER (ORDER BY date_start)-1,hr_general.end_of_time) end_date
1614: FROM ( SELECT date_start,
1615: COALESCE(final_process_date+1,actual_termination_date+1,hr_general.end_of_time)
1616: final_process_date
1617: FROM per_periods_of_service

Line 1615: COALESCE(final_process_date+1,actual_termination_date+1,hr_general.end_of_time)

1611: CURSOR c_emp_inactive ( p_resource_id NUMBER )
1612: IS SELECT final_process_date start_date,
1613: NVL(LEAD(date_start) OVER (ORDER BY date_start)-1,hr_general.end_of_time) end_date
1614: FROM ( SELECT date_start,
1615: COALESCE(final_process_date+1,actual_termination_date+1,hr_general.end_of_time)
1616: final_process_date
1617: FROM per_periods_of_service
1618: WHERE person_id = p_resource_id
1619: UNION

Line 1621: COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0))+1,actual_termination_date+1,hr_general.end_of_time)

1617: FROM per_periods_of_service
1618: WHERE person_id = p_resource_id
1619: UNION
1620: SELECT date_start,
1621: COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0))+1,actual_termination_date+1,hr_general.end_of_time)
1622: final_process_date
1623: FROM per_periods_of_placement
1624: WHERE person_id = p_resource_id
1625: )

Line 1640: AND (date_to = hr_general.end_of_time or APPROVAL_STATUS='ERROR')

1636: ) IS
1637: SELECT count(*)
1638: FROM hxc_time_building_blocks
1639: WHERE SCOPE = 'TIMECARD'
1640: AND (date_to = hr_general.end_of_time or APPROVAL_STATUS='ERROR')
1641: AND resource_id = p_resource_id
1642: AND p_terminate_date between start_time and stop_time;
1643: /* end of changes made by senthil */
1644:

Line 1802: IF (l_inactive_periods(i).start_date <> hr_general.end_of_time)

1798: FOR i IN l_inactive_periods.FIRST..l_inactive_periods.LAST
1799: LOOP
1800: -- We neednt consider this inactive period if the start_date is end_of_time
1801: -- or the start_date and end_date dont have atleast one day in between.
1802: IF (l_inactive_periods(i).start_date <> hr_general.end_of_time)
1803: AND (l_inactive_periods(i).end_date - l_inactive_periods(i).start_date > 1)
1804:
1805: THEN
1806: <>

Line 3644: AND date_to = hr_general.end_of_time

3640: WHERE resource_id
3641: /*ADVICE(3110): Cursor references an external variable (use a parameter) [209] */
3642: = p_resource_id
3643: AND SCOPE = 'TIMECARD'
3644: AND date_to = hr_general.end_of_time
3645: AND TO_DATE (start_time, 'dd-mm-rrrr') < TO_DATE (p_tc_todt, 'dd-mm-rrrr')
3646: AND TO_DATE (stop_time, 'dd-mm-rrrr') > TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
3647: AND ( TO_DATE (start_time, 'dd-mm-rrrr') <> TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
3648: OR TO_DATE (stop_time, 'dd-mm-rrrr') <> TO_DATE (p_tc_todt, 'dd-mm-rrrr')