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

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

426: l_idx number := 0;
427: l_resource_name jtf_task_resources_vl.resource_name%TYPE; -- bug #2418561
428: l_st_time date;
429:
430: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
431: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
432: l_res_Timezone_id Number;
433:
434: BEGIN

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

427: l_resource_name jtf_task_resources_vl.resource_name%TYPE; -- bug #2418561
428: l_st_time date;
429:
430: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
431: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
432: l_res_Timezone_id Number;
433:
434: BEGIN
435: -- Standard call to check for call compatibility.

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

527:
528: --
529: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
530: --
531: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
532: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id);
533: If l_res_Timezone_id <> l_server_tz_id Then
534: l_idx := 0;
535: For r in 1..l_tbl.count loop

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

924: l_exp_flg varchar2(1) := 'N';
925: l_start_date_time date;
926: l_st_time date;
927:
928: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
929: l_res_Timezone_id Number;
930:
931: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
932:

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

1061:
1062: --
1063: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
1064: --
1065: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
1066: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id);
1067: If l_res_Timezone_id <> l_server_tz_id Then
1068: l_idx := 0;
1069: For r in 1..l_tbl.count loop

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

1434: l_calendar_start_date date;
1435: l_exp_flg varchar2(1) := 'N';
1436: l_start_date_time date;
1437: l_st_time date;
1438: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
1439: l_res_Timezone_id Number;
1440:
1441: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1442:

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

1589:
1590: --
1591: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
1592: --
1593: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
1594: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id);
1595: If l_res_Timezone_id <> l_server_tz_id Then
1596: l_idx := 0;
1597: For r in 1..l_tbl.count loop

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

2106: l_shift_b_time varchar2(25);
2107: l_shift_b_date date;
2108: l_shift_e_time varchar2(25);
2109: l_shift_e_date date;
2110: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
2111: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2112: l_res_Timezone_id Number;
2113:
2114: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561

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

2107: l_shift_b_date date;
2108: l_shift_e_time varchar2(25);
2109: l_shift_e_date date;
2110: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
2111: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2112: l_res_Timezone_id Number;
2113:
2114: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
2115:

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

2216: x_shift(j).end_time := to_char(c1.shift_end_time, 'hh24.mi');
2217: --
2218: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
2219: --
2220: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
2221: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id);
2222: If l_res_Timezone_id <> l_server_tz_id Then
2223: l_shift_b_time := to_char(l_shift_date,'DD-MON-YYYY')||' '||to_char(c1.shift_begin_time, 'hh24.mi');
2224: l_shift_b_date := to_date(l_shift_b_time,'DD/MM/YYYY HH24:MI');

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

2255:
2256: --
2257: -- Added for Simplex Timezone Enh # 3040681 by ABRAINA
2258: --
2259: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' Then
2260: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id);
2261: If l_res_Timezone_id <> l_server_tz_id Then
2262: l_shift_b_time := to_char(l_shift_date,'DD-MON-YYYY')||' '||to_char(c1.shift_begin_time, 'hh24.mi');
2263: l_shift_b_date := to_date(l_shift_b_time,'DD/MM/YYYY HH24:MI');

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

2536: Open C_Res_TimeZone ;
2537: Fetch C_Res_TimeZone into l_Res_TimeZone_id;
2538: Close C_Res_TimeZone ;
2539:
2540: l_Res_TimeZone_id := nvl(l_Res_TimeZone_id,fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2541:
2542: Return (l_Res_TimeZone_id);
2543:
2544: End Get_Res_Timezone_Id;