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

Line 406: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443

402: l_process varchar2(1) := 'Y';
403: l_diff number;
404: l_start_constr date;
405:
406: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
407: l_server_tz_id number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
408: l_res_Timezone_id number ;
409:
410: v_start_date DATE;

Line 407: l_server_tz_id number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

403: l_diff number;
404: l_start_constr date;
405:
406: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
407: l_server_tz_id number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
408: l_res_Timezone_id number ;
409:
410: v_start_date DATE;
411: v_end_date DATE;

Line 466: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then

462: --
463: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
464: -- Set flag for timezone conversion if needed
465: l_convert_dates := false;
466: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
467: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id, p_resource_type);
468: If l_res_Timezone_id <> l_server_tz_id Then
469: l_convert_dates := true;
470: End If;

Line 1180: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

1176: l_start_constr date;
1177: l_process varchar2(1) := 'Y';
1178: l_prev_shift_id number;
1179:
1180: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
1181: l_res_Timezone_id Number;
1182:
1183: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1184:

Line 1456: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then

1452:
1453: --
1454: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
1455: --
1456: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
1457: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id, p_resource_type);
1458: If l_res_Timezone_id <> l_server_tz_id Then
1459: l_idx := 0;
1460: For r in 1..l_tbl.count loop

Line 1763: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

1759: l_start_constr date;
1760: l_process varchar2(1) := 'Y';
1761: l_prev_shift_id number;
1762:
1763: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
1764: l_res_Timezone_id Number;
1765:
1766: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1767:

Line 2159: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then

2155: -- moved to after handling exception so that exception are also get adjusted for resource time zone
2156: --
2157: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
2158: --
2159: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
2160: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id, p_resource_type);
2161: If l_res_Timezone_id <> l_server_tz_id Then
2162: l_idx := 0;
2163: For r in 1..l_tbl.count loop

Line 2606: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443

2602: l_prev_shift_id number;
2603: l_process varchar2(1) := 'Y';
2604: l_idx number := 0;
2605:
2606: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
2607: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2608: l_res_Timezone_id Number;
2609: m INTEGER := 0;
2610:

Line 2607: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

2603: l_process varchar2(1) := 'Y';
2604: l_idx number := 0;
2605:
2606: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
2607: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2608: l_res_Timezone_id Number;
2609: m INTEGER := 0;
2610:
2611: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561

Line 2765: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then

2761: -- changed this to adjust to 24 hour shift .. sudarsana
2762: l_shift(j).end_time := l_shift(j).start_time +
2763: (to_number(c1.shift_end_time - c1.shift_begin_time) * 24)/24;
2764:
2765: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
2766: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id, p_resource_type);
2767: If l_res_Timezone_id <> l_server_tz_id Then
2768: l_shift(j).start_time := ResourceDt_To_ServerDT(l_shift(j).start_time,l_res_Timezone_id,l_server_tz_id);
2769: l_shift(j).end_time := ResourceDt_To_ServerDT(l_shift(j).end_time,l_res_Timezone_id,l_server_tz_id);

Line 3115: l_res_timezone_id := nvl(l_res_timezone_id,fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

3111: FETCH C_Res_TimeZone INTO l_res_timezone_id;
3112: CLOSE C_Res_TimeZone ;
3113: END IF;
3114:
3115: l_res_timezone_id := nvl(l_res_timezone_id,fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
3116:
3117: RETURN l_res_timezone_id;
3118:
3119: END Get_Res_Timezone_Id;