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.

[Home] [Help]

APPS.JTF_TASK_RECURRENCES_PVT dependencies on FND_PROFILE

Line 583: l_server_tz_id NUMBER := TO_NUMBER(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

579: p_to_date IN DATE
580: , p_from_date IN DATE
581: ) RETURN DATE IS
582:
583: l_server_tz_id NUMBER := TO_NUMBER(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
584: l_from_date DATE := p_from_date;
585: l_to_date DATE := p_to_date;
586: l_global_timezone_name VARCHAR2(50);
587: l_name VARCHAR2(80);

Line 710: l_tz_enabled_prof VARCHAR2(10) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');

706: l_day_of_week VARCHAR2(15);
707: l_month VARCHAR2(2);
708:
709: /******* Start of addition by SBARAT on 12/04/2006 for bug# 5119803 ******/
710: l_tz_enabled_prof VARCHAR2(10) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
711: l_server_tz_id NUMBER := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
712: l_client_tz_id NUMBER := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
713:
714: Cursor c_task IS

Line 711: l_server_tz_id NUMBER := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

707: l_month VARCHAR2(2);
708:
709: /******* Start of addition by SBARAT on 12/04/2006 for bug# 5119803 ******/
710: l_tz_enabled_prof VARCHAR2(10) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
711: l_server_tz_id NUMBER := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
712: l_client_tz_id NUMBER := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
713:
714: Cursor c_task IS
715: Select calendar_start_date, timezone_id From jtf_tasks_b Where task_id=p_task_id;

Line 712: l_client_tz_id NUMBER := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));

708:
709: /******* Start of addition by SBARAT on 12/04/2006 for bug# 5119803 ******/
710: l_tz_enabled_prof VARCHAR2(10) := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
711: l_server_tz_id NUMBER := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
712: l_client_tz_id NUMBER := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
713:
714: Cursor c_task IS
715: Select calendar_start_date, timezone_id From jtf_tasks_b Where task_id=p_task_id;
716:

Line 3137: IF(fnd_profile.Value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN

3133:
3134: l_name := null;
3135: l_name := JTF_TASK_UTL.get_owner(i.resource_type_code, i.resource_id);
3136: l_date := l_booking_start_date;
3137: IF(fnd_profile.Value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
3138: l_date := To_Char(CAC_AVLBLTY_PVT.ADJUST_FOR_TIMEZONE(fnd_profile.value('SERVER_TIMEZONE_ID'),
3139: fnd_profile.value('CLIENT_TIMEZONE_ID'),
3140: l_booking_start_date),
3141: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');

Line 3138: l_date := To_Char(CAC_AVLBLTY_PVT.ADJUST_FOR_TIMEZONE(fnd_profile.value('SERVER_TIMEZONE_ID'),

3134: l_name := null;
3135: l_name := JTF_TASK_UTL.get_owner(i.resource_type_code, i.resource_id);
3136: l_date := l_booking_start_date;
3137: IF(fnd_profile.Value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
3138: l_date := To_Char(CAC_AVLBLTY_PVT.ADJUST_FOR_TIMEZONE(fnd_profile.value('SERVER_TIMEZONE_ID'),
3139: fnd_profile.value('CLIENT_TIMEZONE_ID'),
3140: l_booking_start_date),
3141: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');
3142: END IF;

Line 3139: fnd_profile.value('CLIENT_TIMEZONE_ID'),

3135: l_name := JTF_TASK_UTL.get_owner(i.resource_type_code, i.resource_id);
3136: l_date := l_booking_start_date;
3137: IF(fnd_profile.Value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
3138: l_date := To_Char(CAC_AVLBLTY_PVT.ADJUST_FOR_TIMEZONE(fnd_profile.value('SERVER_TIMEZONE_ID'),
3139: fnd_profile.value('CLIENT_TIMEZONE_ID'),
3140: l_booking_start_date),
3141: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');
3142: END IF;
3143:

Line 3141: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');

3137: IF(fnd_profile.Value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
3138: l_date := To_Char(CAC_AVLBLTY_PVT.ADJUST_FOR_TIMEZONE(fnd_profile.value('SERVER_TIMEZONE_ID'),
3139: fnd_profile.value('CLIENT_TIMEZONE_ID'),
3140: l_booking_start_date),
3141: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');
3142: END IF;
3143:
3144:
3145: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');