APPS.JTF_CALENDAR_PUB dependencies on FND_PROFILE

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

468: l_idx number := 0;
469: l_resource_name jtf_task_resources_vl.resource_name%TYPE; -- bug #2418561
470: l_st_time date;
471:
472: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
473: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
474: l_res_Timezone_id Number;
475:
476: BEGIN

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

469: l_resource_name jtf_task_resources_vl.resource_name%TYPE; -- bug #2418561
470: l_st_time date;
471:
472: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
473: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
474: l_res_Timezone_id Number;
475:
476: BEGIN
477: -- Standard call to check for call compatibility.

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

569:
570: --
571: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
572: --
573: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
574: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id, p_resource_type);
575: If l_res_Timezone_id <> l_server_tz_id Then
576: l_idx := 0;
577: For r in 1..l_tbl.count loop

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

966: l_exp_flg varchar2(1) := 'N';
967: l_start_date_time date;
968: l_st_time date;
969:
970: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
971: l_res_Timezone_id Number;
972:
973: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
974:

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

1205: -- moved this code here so that exceptions are also adjusted for time zone conversion
1206: --
1207: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
1208: --
1209: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
1210: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id, p_resource_type);
1211: If l_res_Timezone_id <> l_server_tz_id Then
1212: l_idx := 0;
1213: For r in 1..l_tbl.count loop

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

1479: l_calendar_start_date date;
1480: l_exp_flg varchar2(1) := 'N';
1481: l_start_date_time date;
1482: l_st_time date;
1483: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
1484: l_res_Timezone_id Number;
1485:
1486: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1487:

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

1829: -- Moved this code here so that exceptions are also considered for timezone conversion
1830: --
1831: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
1832: --
1833: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
1834: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id, p_resource_type);
1835: If l_res_Timezone_id <> l_server_tz_id Then
1836: l_idx := 0;
1837: For r in 1..l_tbl.count loop

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

2156: l_shift_b_time varchar2(25);
2157: l_shift_b_date date;
2158: l_shift_e_time varchar2(25);
2159: l_shift_e_date date;
2160: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
2161: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2162: l_res_Timezone_id Number;
2163:
2164: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561

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

2157: l_shift_b_date date;
2158: l_shift_e_time varchar2(25);
2159: l_shift_e_date date;
2160: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
2161: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2162: l_res_Timezone_id Number;
2163:
2164: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
2165:

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

2266: x_shift(j).end_time := to_char(c1.shift_end_time, 'hh24.mi');
2267: --
2268: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
2269: --
2270: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
2271: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id, p_resource_type);
2272: If l_res_Timezone_id <> l_server_tz_id Then
2273: l_shift_b_time := to_char(l_shift_date,'DD-MON-YYYY')||' '||to_char(c1.shift_begin_time, 'hh24.mi');
2274: l_shift_b_date := to_date(l_shift_b_time,'DD/MM/YYYY HH24:MI');

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

2305:
2306: --
2307: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
2308: --
2309: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
2310: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id, p_resource_type);
2311: If l_res_Timezone_id <> l_server_tz_id Then
2312: l_shift_b_time := to_char(l_shift_date,'DD-MON-YYYY')||' '||to_char(c1.shift_begin_time, 'hh24.mi');
2313: l_shift_b_date := to_date(l_shift_b_time,'DD/MM/YYYY HH24:MI');

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

2599: FETCH C_Res_TimeZone INTO l_res_timezone_id;
2600: CLOSE C_Res_TimeZone ;
2601: END IF;
2602:
2603: l_res_timezone_id := nvl(l_res_timezone_id,fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2604:
2605: RETURN l_res_timezone_id;
2606:
2607: END Get_Res_Timezone_Id;