DBA Data[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: