2730: privelege_all_tasks VARCHAR2(1);
2731: l_resource_id NUMBER;
2732: BEGIN
2733: x_return_status := fnd_api.g_ret_sts_success;
2734: fnd_profile.get (p_profile_name, privelege_all_tasks);
2735:
2736: IF privelege_all_tasks = 'Y'
2737: OR privelege_all_tasks IS NULL
2738: THEN
2774: x_return_status := fnd_api.g_ret_sts_success;
2775:
2776: BEGIN
2777: x_owner_type_code :=
2778: fnd_profile.VALUE ('JTF_TASK_DEFAULT_OWNER_TYPE');
2779: x_owner_id := fnd_profile.VALUE ('JTF_TASK_DEFAULT_OWNER');
2780: EXCEPTION
2781: WHEN NO_DATA_FOUND
2782: THEN
2775:
2776: BEGIN
2777: x_owner_type_code :=
2778: fnd_profile.VALUE ('JTF_TASK_DEFAULT_OWNER_TYPE');
2779: x_owner_id := fnd_profile.VALUE ('JTF_TASK_DEFAULT_OWNER');
2780: EXCEPTION
2781: WHEN NO_DATA_FOUND
2782: THEN
2783: profile_set := FALSE;
3179:
3180: BEGIN
3181:
3182: x_return_status := fnd_api.g_ret_sts_success;
3183: IF fnd_profile.value('JTF_TASK_CHECK_SECURITY') = jtf_task_utl.g_yes_char
3184: THEN
3185:
3186: -- select the owner info from task table for this task id
3187: SELECT owner_id, owner_type_code, private_flag
3354:
3355: BEGIN
3356: x_return_status := fnd_api.g_ret_sts_success;
3357:
3358: IF fnd_profile.value('JTF_TASK_CHECK_SECURITY') = jtf_task_utl.g_yes_char
3359: THEN
3360: OPEN c_task_owner;
3361: FETCH c_task_owner INTO rec_task_owner;
3362: IF c_task_owner%NOTFOUND
3436: ELSE
3437: CLOSE c_group;
3438: END IF; -- Check group
3439: END IF; -- p_session = UPDATE
3440: End IF; -- fnd_profile.value('JTF_TASK_CHECK_SECURITY') = Yes
3441: EXCEPTION
3442: WHEN fnd_api.g_exc_error
3443: THEN
3444: IF c_task_owner%ISOPEN THEN
4706: AS PRAGMA autonomous_transaction;
4707: l_status BOOLEAN := FALSE;
4708: BEGIN
4709: IF( p_enable ) THEN
4710: l_status:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT',g_yes,'SITE');
4711: ELSE
4712: l_status:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT',g_no,'SITE');
4713: END IF;
4714: IF(l_status) THEN
4708: BEGIN
4709: IF( p_enable ) THEN
4710: l_status:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT',g_yes,'SITE');
4711: ELSE
4712: l_status:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT',g_no,'SITE');
4713: END IF;
4714: IF(l_status) THEN
4715: COMMIT;
4716: END IF;
4729: THEN
4730: RETURN p_date;
4731: END IF;
4732:
4733: l_server_tz := fnd_profile.value('SERVER_TIMEZONE_ID');
4734: l_client_tz := fnd_profile.value('CLIENT_TIMEZONE_ID');
4735: l_tz_enabled := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
4736:
4737: jtf_cal_utility_pvt.adjustfortimezone( l_server_tz,
4730: RETURN p_date;
4731: END IF;
4732:
4733: l_server_tz := fnd_profile.value('SERVER_TIMEZONE_ID');
4734: l_client_tz := fnd_profile.value('CLIENT_TIMEZONE_ID');
4735: l_tz_enabled := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
4736:
4737: jtf_cal_utility_pvt.adjustfortimezone( l_server_tz,
4738: p_TaskTz,
4731: END IF;
4732:
4733: l_server_tz := fnd_profile.value('SERVER_TIMEZONE_ID');
4734: l_client_tz := fnd_profile.value('CLIENT_TIMEZONE_ID');
4735: l_tz_enabled := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
4736:
4737: jtf_cal_utility_pvt.adjustfortimezone( l_server_tz,
4738: p_TaskTz,
4739: p_date,
4762: THEN
4763: RETURN p_date;
4764: END IF;
4765:
4766: l_server_tz := fnd_profile.value('SERVER_TIMEZONE_ID');
4767: l_client_tz := fnd_profile.value('CLIENT_TIMEZONE_ID');
4768: l_tz_enabled := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
4769:
4770: l_temp_date:=p_date;
4763: RETURN p_date;
4764: END IF;
4765:
4766: l_server_tz := fnd_profile.value('SERVER_TIMEZONE_ID');
4767: l_client_tz := fnd_profile.value('CLIENT_TIMEZONE_ID');
4768: l_tz_enabled := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
4769:
4770: l_temp_date:=p_date;
4771:
4764: END IF;
4765:
4766: l_server_tz := fnd_profile.value('SERVER_TIMEZONE_ID');
4767: l_client_tz := fnd_profile.value('CLIENT_TIMEZONE_ID');
4768: l_tz_enabled := fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
4769:
4770: l_temp_date:=p_date;
4771:
4772: IF (l_tz_enabled = 'Y')