DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on FND_PROFILE

Line 2734: fnd_profile.get (p_profile_name, privelege_all_tasks);

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

Line 2778: fnd_profile.VALUE ('JTF_TASK_DEFAULT_OWNER_TYPE');

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

Line 2779: x_owner_id := fnd_profile.VALUE ('JTF_TASK_DEFAULT_OWNER');

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;

Line 3183: IF fnd_profile.value('JTF_TASK_CHECK_SECURITY') = jtf_task_utl.g_yes_char

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

Line 3358: IF fnd_profile.value('JTF_TASK_CHECK_SECURITY') = jtf_task_utl.g_yes_char

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

Line 3440: End IF; -- fnd_profile.value('JTF_TASK_CHECK_SECURITY') = Yes

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