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 348: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443

344: l_process varchar2(1) := 'Y';
345: l_diff number;
346: l_start_constr date;
347:
348: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
349: l_server_tz_id number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
350: l_res_Timezone_id number ;
351:
352: v_start_date DATE;

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

345: l_diff number;
346: l_start_constr date;
347:
348: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
349: l_server_tz_id number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
350: l_res_Timezone_id number ;
351:
352: v_start_date DATE;
353: v_end_date DATE;

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

404: --
405: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
406: -- Set flag for timezone conversion if needed
407: l_convert_dates := false;
408: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
409: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id);
410: If l_res_Timezone_id <> l_server_tz_id Then
411: l_convert_dates := true;
412: End If;

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

1109: l_start_constr date;
1110: l_process varchar2(1) := 'Y';
1111: l_prev_shift_id number;
1112:
1113: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
1114: l_res_Timezone_id Number;
1115:
1116: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1117:

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

1286:
1287: --
1288: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
1289: --
1290: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
1291: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id);
1292: If l_res_Timezone_id <> l_server_tz_id Then
1293: l_idx := 0;
1294: For r in 1..l_tbl.count loop

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

1692: l_start_constr date;
1693: l_process varchar2(1) := 'Y';
1694: l_prev_shift_id number;
1695:
1696: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
1697: l_res_Timezone_id Number;
1698:
1699: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1700:

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

1893:
1894: --
1895: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
1896: --
1897: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
1898: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id);
1899: If l_res_Timezone_id <> l_server_tz_id Then
1900: l_idx := 0;
1901: For r in 1..l_tbl.count loop

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

2532: l_prev_shift_id number;
2533: l_process varchar2(1) := 'Y';
2534: l_idx number := 0;
2535:
2536: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
2537: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2538: l_res_Timezone_id Number;
2539: m INTEGER := 0;
2540:

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

2533: l_process varchar2(1) := 'Y';
2534: l_idx number := 0;
2535:
2536: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
2537: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2538: l_res_Timezone_id Number;
2539: m INTEGER := 0;
2540:
2541: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561

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

2691: -- changed this to adjust to 24 hour shift .. sudarsana
2692: l_shift(j).end_time := l_shift(j).start_time +
2693: (to_number(c1.shift_end_time - c1.shift_begin_time) * 24)/24;
2694:
2695: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
2696: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id);
2697: If l_res_Timezone_id <> l_server_tz_id Then
2698: l_shift(j).start_time := ResourceDt_To_ServerDT(l_shift(j).start_time,l_res_Timezone_id,l_server_tz_id);
2699: l_shift(j).end_time := ResourceDt_To_ServerDT(l_shift(j).end_time,l_res_Timezone_id,l_server_tz_id);

Line 3032: l_Res_TimeZone_id := nvl(l_Res_TimeZone_id,fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

3028: Open C_Res_TimeZone ;
3029: Fetch C_Res_TimeZone into l_Res_TimeZone_id;
3030: Close C_Res_TimeZone ;
3031:
3032: l_Res_TimeZone_id := nvl(l_Res_TimeZone_id,fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
3033:
3034: Return (l_Res_TimeZone_id);
3035:
3036: End Get_Res_Timezone_Id;