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 297: AND DAY.date_to = hr_general.end_of_time

293: AND DAY.object_version_number = detail.parent_building_block_ovn
294: AND DAY.SCOPE = 'DAY'
295: AND detail.resource_id = l_resource_id
296: AND detail.SCOPE = 'DETAIL'
297: AND DAY.date_to = hr_general.end_of_time
298: AND detail.date_to = hr_general.end_of_time
299: AND DAY.parent_building_block_id = timecard_id
300: AND DAY.parent_building_block_ovn = timecard_ovn
301: AND DAY.resource_id = l_resource_id)

Line 298: AND detail.date_to = hr_general.end_of_time

294: AND DAY.SCOPE = 'DAY'
295: AND detail.resource_id = l_resource_id
296: AND detail.SCOPE = 'DETAIL'
297: AND DAY.date_to = hr_general.end_of_time
298: AND detail.date_to = hr_general.end_of_time
299: AND DAY.parent_building_block_id = timecard_id
300: AND DAY.parent_building_block_ovn = timecard_ovn
301: AND DAY.resource_id = l_resource_id)
302: UNION

Line 316: WHERE DAY.date_to = hr_general.end_of_time

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

Line 335: WHERE htbb.date_to = hr_general.end_of_time

331: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
332: AND (au.time_building_block_id, au.time_building_block_ovn) IN
333: (SELECT time_building_block_id, object_version_number
334: FROM hxc_time_building_blocks htbb
335: WHERE htbb.date_to = hr_general.end_of_time
336: AND htbb.SCOPE = 'TIMECARD'
337: AND htbb.time_building_block_id = timecard_id
338: AND htbb.object_version_number = timecard_ovn
339: AND htbb.resource_id = l_resource_id)

Line 862: AND date_to = hr_general.end_of_time

858: WHERE resource_id
859: /*ADVICE(829): Cursor references an external variable (use a parameter) [209] */
860: = p_resource_id
861: AND SCOPE = 'TIMECARD'
862: AND date_to = hr_general.end_of_time
863: AND TO_DATE (p_tc_frdt, 'dd-mm-rrrr') BETWEEN TO_DATE (start_time, 'dd-mm-rrrr')
864: AND TO_DATE (stop_time, 'dd-mm-rrrr')
865: UNION
866: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')

Line 872: AND date_to = hr_general.end_of_time

868: WHERE resource_id
869: /*ADVICE(839): Cursor references an external variable (use a parameter) [209] */
870: = p_resource_id
871: AND SCOPE = 'TIMECARD'
872: AND date_to = hr_general.end_of_time
873: AND TO_DATE (p_tc_todt, 'dd-mm-rrrr') BETWEEN TO_DATE (start_time, 'dd-mm-rrrr')
874: AND TO_DATE (stop_time, 'dd-mm-rrrr')
875: UNION
876: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')

Line 882: AND date_to = hr_general.end_of_time

878: WHERE resource_id
879: /*ADVICE(849): Cursor references an external variable (use a parameter) [209] */
880: = p_resource_id
881: AND SCOPE = 'TIMECARD'
882: AND date_to = hr_general.end_of_time
883: AND TO_DATE (start_time, 'dd-mm-rrrr') >= TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
884: AND TO_DATE (stop_time, 'dd-mm-rrrr') <= TO_DATE (p_tc_todt, 'dd-mm-rrrr')
885: MINUS
886: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')

Line 892: AND date_to = hr_general.end_of_time

888: WHERE resource_id
889: /*ADVICE(859): Cursor references an external variable (use a parameter) [209] */
890: = p_resource_id
891: AND SCOPE = 'TIMECARD'
892: AND date_to = hr_general.end_of_time
893: AND TO_DATE (start_time, 'dd-mm-rrrr') = TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
894: AND TO_DATE (stop_time, 'dd-mm-rrrr') = TO_DATE (p_tc_todt, 'dd-mm-rrrr')
895: ORDER BY 4;
896:

Line 940: and date_to=hr_general.end_of_time

936: select start_time,stop_time,to_date(start_time)
937: from hxc_time_building_blocks
938: where resource_id = p_resource_id
939: and scope='TIMECARD'
940: and date_to=hr_general.end_of_time
941: and to_date(start_time,'dd-mm-rrrr') >=to_date(p_tc_frdt,'dd-mm-rrrr') and
942: to_date(stop_time,'dd-mm-rrrr') <=to_date(p_tc_todt,'dd-mm-rrrr')
943: union
944: select tc_frdt,tc_todt,to_date(tc_frdt)

Line 955: AND date_to = hr_general.end_of_time

951: WHERE resource_id
952: /*ADVICE(922): Cursor references an external variable (use a parameter) [209] */
953: = p_resource_id
954: AND SCOPE = 'TIMECARD'
955: AND date_to = hr_general.end_of_time
956: AND TO_DATE (start_time, 'dd-mm-rrrr') >= TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
957: AND TO_DATE (stop_time, 'dd-mm-rrrr') <= TO_DATE (p_tc_todt, 'dd-mm-rrrr')
958: UNION
959: SELECT TO_DATE (tc_frdt

Line 1336: hr_general.end_of_time) >= p_tc_start_date

1332: FROM per_periods_of_service
1333: WHERE person_id = p_resource_id
1334: AND date_start <= p_tc_end_date
1335: AND COALESCE(final_process_date,actual_termination_date,
1336: hr_general.end_of_time) >= p_tc_start_date
1337: UNION
1338: SELECT date_start
1339: FROM per_periods_of_placement
1340: WHERE person_id = p_resource_id

Line 1343: hr_general.end_of_time) >= p_tc_start_date

1339: FROM per_periods_of_placement
1340: WHERE person_id = p_resource_id
1341: AND date_start <= p_tc_end_date
1342: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,
1343: hr_general.end_of_time) >= p_tc_start_date
1344: ORDER BY date_start ;
1345:
1346:
1347: /*Cursor Modified By Mithun for CWK Terminate Bug*/

Line 1382: hr_general.end_of_time) >= p_tc_start_date

1378: FROM per_periods_of_service
1379: WHERE person_id = p_resource_id
1380: AND date_start <= p_tc_end_date
1381: AND COALESCE(final_process_date,actual_termination_date,
1382: hr_general.end_of_time) >= p_tc_start_date
1383: UNION
1384: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date,
1385: date_start
1386: FROM PER_PERIODS_OF_placement

Line 1390: hr_general.end_of_time) >= p_tc_start_date

1386: FROM PER_PERIODS_OF_placement
1387: WHERE person_id = p_resource_id
1388: AND date_start <= p_tc_end_date
1389: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,
1390: hr_general.end_of_time) >= p_tc_start_date
1391: ORDER BY date_start DESC;
1392:
1393:
1394:

Line 1543: AND date_to = hr_general.end_of_time

1539: ) IS
1540: SELECT TRUNC (start_time), TRUNC (stop_time)
1541: FROM hxc_time_building_blocks
1542: WHERE SCOPE = 'TIMECARD'
1543: AND date_to = hr_general.end_of_time
1544: AND resource_id = p_resource_id
1545: AND resource_type = p_resource_type
1546: AND stop_time >= p_first_start_date
1547: AND start_time <= p_last_end_date;

Line 1591: hr_general.end_of_time) > p_past_date

1587: IS SELECT date_start
1588: FROM per_periods_of_service
1589: WHERE person_id = p_resource_id
1590: AND COALESCE(final_process_date,actual_termination_date,
1591: hr_general.end_of_time) > p_past_date
1592: UNION
1593: SELECT date_start
1594: FROM per_periods_of_placement
1595: WHERE person_id = p_resource_id

Line 1597: hr_general.end_of_time) > p_past_date

1593: SELECT date_start
1594: FROM per_periods_of_placement
1595: WHERE person_id = p_resource_id
1596: AND COALESCE(final_process_date,actual_termination_date,
1597: hr_general.end_of_time) > p_past_date
1598: ORDER BY date_start ;
1599:
1600:
1601:

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

1627:
1628:
1629: CURSOR c_emp_inactive ( p_resource_id NUMBER )
1630: IS SELECT final_process_date start_date,
1631: NVL(LEAD(date_start) OVER (ORDER BY date_start)-1,hr_general.end_of_time) end_date
1632: FROM ( SELECT date_start,
1633: COALESCE(final_process_date+1,actual_termination_date+1,hr_general.end_of_time)
1634: final_process_date
1635: FROM per_periods_of_service

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

1629: CURSOR c_emp_inactive ( p_resource_id NUMBER )
1630: IS SELECT final_process_date start_date,
1631: NVL(LEAD(date_start) OVER (ORDER BY date_start)-1,hr_general.end_of_time) end_date
1632: FROM ( SELECT date_start,
1633: COALESCE(final_process_date+1,actual_termination_date+1,hr_general.end_of_time)
1634: final_process_date
1635: FROM per_periods_of_service
1636: WHERE person_id = p_resource_id
1637: UNION

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

1635: FROM per_periods_of_service
1636: WHERE person_id = p_resource_id
1637: UNION
1638: SELECT date_start,
1639: COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0))+1,actual_termination_date+1,hr_general.end_of_time)
1640: final_process_date
1641: FROM per_periods_of_placement
1642: WHERE person_id = p_resource_id
1643: )

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

1654: ) IS
1655: SELECT count(*)
1656: FROM hxc_time_building_blocks
1657: WHERE SCOPE = 'TIMECARD'
1658: AND (date_to = hr_general.end_of_time or APPROVAL_STATUS='ERROR')
1659: AND resource_id = p_resource_id
1660: AND p_terminate_date between start_time and stop_time;
1661: /* end of changes made by senthil */
1662:

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

1816: FOR i IN l_inactive_periods.FIRST..l_inactive_periods.LAST
1817: LOOP
1818: -- We neednt consider this inactive period if the start_date is end_of_time
1819: -- or the start_date and end_date dont have atleast one day in between.
1820: IF (l_inactive_periods(i).start_date <> hr_general.end_of_time)
1821: AND (l_inactive_periods(i).end_date - l_inactive_periods(i).start_date > 1)
1822:
1823: THEN
1824: <>

Line 3683: AND date_to = hr_general.end_of_time

3679: WHERE resource_id
3680: /*ADVICE(3110): Cursor references an external variable (use a parameter) [209] */
3681: = p_resource_id
3682: AND SCOPE = 'TIMECARD'
3683: AND date_to = hr_general.end_of_time
3684: AND TO_DATE (start_time, 'dd-mm-rrrr') < TO_DATE (p_tc_todt, 'dd-mm-rrrr')
3685: AND TO_DATE (stop_time, 'dd-mm-rrrr') > TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
3686: AND ( TO_DATE (start_time, 'dd-mm-rrrr') <> TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
3687: OR TO_DATE (stop_time, 'dd-mm-rrrr') <> TO_DATE (p_tc_todt, 'dd-mm-rrrr')

Line 4192: hr_general.end_of_time) >= p_tc_start_date

4188: WHERE person_id = p_resource_id
4189: AND date_start <= p_tc_end_date
4190: AND COALESCE(final_process_date,
4191: actual_termination_date,
4192: hr_general.end_of_time) >= p_tc_start_date
4193: UNION
4194: SELECT date_start,
4195: (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date
4196: FROM per_periods_of_placement

Line 4201: hr_general.end_of_time) >= p_tc_start_date

4197: WHERE person_id = p_resource_id
4198: AND date_start <= p_tc_end_date
4199: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0))
4200: ,actual_termination_date,
4201: hr_general.end_of_time) >= p_tc_start_date
4202: ORDER BY date_start ;
4203:
4204:
4205: l_start_date DATE;

Line 4239: if (p_tc_start_date between nvl(l_start_date, hr_general.start_of_time)

4235: hr_utility.trace('p_tc_end_date = '||p_tc_end_date);
4236:
4237: end if;
4238:
4239: if (p_tc_start_date between nvl(l_start_date, hr_general.start_of_time)
4240: and nvl(l_end_date, hr_general.end_of_time)) then
4241:
4242: if g_debug then
4243:

Line 4240: and nvl(l_end_date, hr_general.end_of_time)) then

4236:
4237: end if;
4238:
4239: if (p_tc_start_date between nvl(l_start_date, hr_general.start_of_time)
4240: and nvl(l_end_date, hr_general.end_of_time)) then
4241:
4242: if g_debug then
4243:
4244: hr_utility.trace('Going to return p_tc_start_date ='|| p_tc_start_date);

Line 5840: --nvl(hav.date_from,hr_general.start_of_time) <= p_start_period and

5836:
5837: WHERE hav.attribute1=to_char(p_element_type_id) and
5838: hav.enabled_flag='Y' and
5839: hav.attribute_category='PAYROLL_ELEMENTS' and
5840: --nvl(hav.date_from,hr_general.start_of_time) <= p_start_period and
5841: --nvl(hav.date_to,hr_general.end_of_time) >= p_end_period and
5842: nvl(hav.date_from,hr_general.start_of_time) <= p_end_period and
5843: nvl(hav.date_to,hr_general.end_of_time) >= p_start_period and
5844: hav.alias_definition_id=p_alias_definition_id and

Line 5841: --nvl(hav.date_to,hr_general.end_of_time) >= p_end_period and

5837: WHERE hav.attribute1=to_char(p_element_type_id) and
5838: hav.enabled_flag='Y' and
5839: hav.attribute_category='PAYROLL_ELEMENTS' and
5840: --nvl(hav.date_from,hr_general.start_of_time) <= p_start_period and
5841: --nvl(hav.date_to,hr_general.end_of_time) >= p_end_period and
5842: nvl(hav.date_from,hr_general.start_of_time) <= p_end_period and
5843: nvl(hav.date_to,hr_general.end_of_time) >= p_start_period and
5844: hav.alias_definition_id=p_alias_definition_id and
5845: hav.alias_definition_id=had.alias_definition_id and

Line 5842: nvl(hav.date_from,hr_general.start_of_time) <= p_end_period and

5838: hav.enabled_flag='Y' and
5839: hav.attribute_category='PAYROLL_ELEMENTS' and
5840: --nvl(hav.date_from,hr_general.start_of_time) <= p_start_period and
5841: --nvl(hav.date_to,hr_general.end_of_time) >= p_end_period and
5842: nvl(hav.date_from,hr_general.start_of_time) <= p_end_period and
5843: nvl(hav.date_to,hr_general.end_of_time) >= p_start_period and
5844: hav.alias_definition_id=p_alias_definition_id and
5845: hav.alias_definition_id=had.alias_definition_id and
5846: had.alias_type_id=hat.alias_type_id and

Line 5843: nvl(hav.date_to,hr_general.end_of_time) >= p_start_period and

5839: hav.attribute_category='PAYROLL_ELEMENTS' and
5840: --nvl(hav.date_from,hr_general.start_of_time) <= p_start_period and
5841: --nvl(hav.date_to,hr_general.end_of_time) >= p_end_period and
5842: nvl(hav.date_from,hr_general.start_of_time) <= p_end_period and
5843: nvl(hav.date_to,hr_general.end_of_time) >= p_start_period and
5844: hav.alias_definition_id=p_alias_definition_id and
5845: hav.alias_definition_id=had.alias_definition_id and
5846: had.alias_type_id=hat.alias_type_id and
5847: hat.alias_type = 'OTL_ALT_DDF' and