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.CAC_VIEW_PVT dependencies on FND_PROFILE

Line 423: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))

419: else
420:
421: CAC_VIEW_UTIL_PVT.AdjustForTimezone
422: ( p_source_tz_id => r_Bookings.TimezoneID
423: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
424: , p_source_day_time => l_StartDate
425: , x_dest_day_time => l_NewStartDate
426: );
427:

Line 430: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))

426: );
427:
428: CAC_VIEW_UTIL_PVT.AdjustForTimezone
429: ( p_source_tz_id => r_Bookings.TimezoneID
430: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
431: , p_source_day_time => l_EndDate
432: , x_dest_day_time => l_NewEndDate
433: );
434:

Line 832: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))

828:
829: else
830: CAC_VIEW_UTIL_PVT.AdjustForTimezone
831: ( p_source_tz_id => r_PersonalApt.TimezoneID
832: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
833: , p_source_day_time => l_StartDate
834: , x_dest_day_time => l_NewStartDate
835: );
836:

Line 839: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))

835: );
836:
837: CAC_VIEW_UTIL_PVT.AdjustForTimezone
838: ( p_source_tz_id => r_PersonalApt.TimezoneID
839: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
840: , p_source_day_time => l_EndDate
841: , x_dest_day_time => l_NewEndDate
842: );
843:

Line 1013: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))

1009:
1010: else
1011: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1012: ( p_source_tz_id => r_PersonalTask.TIMEZONE_ID
1013: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
1014: , p_source_day_time => l_StartDate
1015: , x_dest_day_time => l_NewStartDate
1016: );
1017:

Line 1020: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))

1016: );
1017:
1018: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1019: ( p_source_tz_id => r_PersonalTask.TIMEZONE_ID
1020: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
1021: , p_source_day_time => l_EndDate
1022: , x_dest_day_time => l_NewEndDate
1023: );
1024:

Line 1318: , p_dest_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('CLIENT_TIMEZONE_ID'),'4'))

1314: );
1315: else
1316: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1317: ( p_source_tz_id => r_PersonalItem .TimezoneID
1318: , p_dest_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('CLIENT_TIMEZONE_ID'),'4'))
1319: , p_source_day_time => l_StartDate
1320: , x_dest_day_time => l_NewStartDate
1321: );
1322:

Line 1325: , p_dest_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('CLIENT_TIMEZONE_ID'),'4'))

1321: );
1322:
1323: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1324: ( p_source_tz_id => r_PersonalItem .TimezoneID
1325: , p_dest_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('CLIENT_TIMEZONE_ID'),'4'))
1326: , p_source_day_time => l_EndDate
1327: , x_dest_day_time => l_NewEndDate
1328: );
1329:

Line 1544: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))

1540: THEN
1541:
1542: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1543: ( p_source_tz_id => p_timezone_id
1544: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
1545: , p_source_day_time => l_schedule_daytime(k).start_date_time
1546: , x_dest_day_time => l_new_start_date
1547: );
1548:

Line 1551: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))

1547: );
1548:
1549: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1550: ( p_source_tz_id => p_timezone_id
1551: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
1552: , p_source_day_time => l_schedule_daytime(k).end_date_time
1553: , x_dest_day_time => l_new_end_date
1554: );
1555:

Line 1559: ( p_source_tz_id => to_number(NVL(FND_PROFILE.Value('SERVER_TIMEZONE_ID'),'4'))

1555:
1556: ELSIF p_view_timezone is not null
1557: then
1558: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1559: ( p_source_tz_id => to_number(NVL(FND_PROFILE.Value('SERVER_TIMEZONE_ID'),'4'))
1560: , p_dest_tz_id => p_view_timezone
1561: , p_source_day_time => l_schedule_daytime(k).start_date_time
1562: , x_dest_day_time => l_new_start_date
1563: );

Line 1566: ( p_source_tz_id => to_number(NVL(FND_PROFILE.Value('SERVER_TIMEZONE_ID'),'4'))

1562: , x_dest_day_time => l_new_start_date
1563: );
1564:
1565: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1566: ( p_source_tz_id => to_number(NVL(FND_PROFILE.Value('SERVER_TIMEZONE_ID'),'4'))
1567: , p_dest_tz_id => p_view_timezone
1568: , p_source_day_time => l_schedule_daytime(k).end_date_time
1569: , x_dest_day_time => l_new_end_date
1570: );

Line 2017: l_CalSpanDaysProfile := fnd_profile.value('JTF_CAL_SPAN_DAYS');

2013: , x_loggedon_emp_resource_type => l_LoggedOnRSType
2014: );
2015:
2016: -- need to fetch SpanDaysProfile profile independently
2017: l_CalSpanDaysProfile := fnd_profile.value('JTF_CAL_SPAN_DAYS');
2018: /***************************************************************************
2019: ** What is today for the logged on user
2020: ***************************************************************************/
2021: if p_input.ViewTimezoneID is not null

Line 2025: , p_source_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('SERVER_TIMEZONE_ID'),'4'))

2021: if p_input.ViewTimezoneID is not null
2022: then
2023: Hz_Timezone_Pub.Get_Time( p_api_version => 1.0
2024: , p_init_msg_list => Fnd_Api.G_FALSE
2025: , p_source_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('SERVER_TIMEZONE_ID'),'4'))
2026: , p_dest_tz_id => p_input.ViewTimezoneID
2027: , p_source_day_time => SYSDATE -- database sysdate
2028: , x_dest_day_time => l_LoggedOnToday
2029: , x_return_status => l_return_status

Line 2036: , p_source_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('SERVER_TIMEZONE_ID'),'4'))

2032: );
2033: else
2034: Hz_Timezone_Pub.Get_Time( p_api_version => 1.0
2035: , p_init_msg_list => Fnd_Api.G_FALSE
2036: , p_source_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('SERVER_TIMEZONE_ID'),'4'))
2037: , p_dest_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('CLIENT_TIMEZONE_ID'),'4'))
2038: , p_source_day_time => SYSDATE -- database sysdate
2039: , x_dest_day_time => l_LoggedOnToday
2040: , x_return_status => l_return_status

Line 2037: , p_dest_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('CLIENT_TIMEZONE_ID'),'4'))

2033: else
2034: Hz_Timezone_Pub.Get_Time( p_api_version => 1.0
2035: , p_init_msg_list => Fnd_Api.G_FALSE
2036: , p_source_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('SERVER_TIMEZONE_ID'),'4'))
2037: , p_dest_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('CLIENT_TIMEZONE_ID'),'4'))
2038: , p_source_day_time => SYSDATE -- database sysdate
2039: , x_dest_day_time => l_LoggedOnToday
2040: , x_return_status => l_return_status
2041: , x_msg_count => l_msg_count