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 FND_PROFILE

Line 1342: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,

1338: SELECT date_start
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:

Line 1356: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start

1352: SELECT final_process_date, date_start
1353: FROM per_periods_of_service
1354: WHERE person_id = p_resource_id
1355: union all
1356: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
1357: FROM PER_PERIODS_OF_placement
1358: WHERE person_id = p_resource_id
1359: ORDER BY date_start DESC;
1360: */

Line 1384: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date,

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
1387: WHERE person_id = p_resource_id
1388: AND date_start <= p_tc_end_date

Line 1389: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,

1385: date_start
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:

Line 1412: l_tc_start_date := FND_PROFILE.VALUE('OTL_TK_START_DATE');

1408:
1409:
1410: -- Bug 7454062
1411:
1412: l_tc_start_date := FND_PROFILE.VALUE('OTL_TK_START_DATE');
1413: l_tc_end_date := FND_PROFILE.VALUE('OTL_TK_END_DATE');
1414:
1415: IF p_resource_id IS NOT NULL THEN
1416: IF NOT g_resource_perftab.EXISTS (p_resource_id) THEN

Line 1413: l_tc_end_date := FND_PROFILE.VALUE('OTL_TK_END_DATE');

1409:
1410: -- Bug 7454062
1411:
1412: l_tc_start_date := FND_PROFILE.VALUE('OTL_TK_START_DATE');
1413: l_tc_end_date := FND_PROFILE.VALUE('OTL_TK_END_DATE');
1414:
1415: IF p_resource_id IS NOT NULL THEN
1416: IF NOT g_resource_perftab.EXISTS (p_resource_id) THEN
1417: hxc_preference_evaluation.resource_preferences (

Line 1611: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start

1607: SELECT final_process_date, date_start
1608: FROM per_periods_of_service
1609: WHERE person_id = p_resource_id
1610: union all
1611: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
1612: from per_periods_of_placement
1613: where person_id = p_resource_id
1614: ORDER BY date_start DESC;
1615:

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 2857: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start

2853: SELECT final_process_date, date_start
2854: FROM per_periods_of_service
2855: WHERE person_id = p_resource_id
2856: union all
2857: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
2858: from per_periods_of_placement
2859: where person_id = p_resource_id
2860: ORDER BY date_start DESC;
2861:

Line 3644: if ( nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y'

3640: END IF;
3641:
3642: ELSIF (l_pref_table (l_index).preference_code = 'TS_ABS_PREFERENCES') THEN
3643:
3644: if ( nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'),'N') = 'Y'
3645: and nvl(l_pref_table (l_index).attribute1,'N') = 'Y'
3646: and nvl(l_pref_table (l_index).attribute5,'N') = 'Y') then
3647:
3648: hxc_timekeeper_utilities.g_tk_show_absences:= 1;

Line 4195: (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) 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
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))

Line 4199: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0))

4195: (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date
4196: FROM per_periods_of_placement
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: