DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on FND_GLOBAL

Line 917: RETURN fnd_global.user_id;

913: FUNCTION created_by
914: RETURN NUMBER
915: IS
916: BEGIN
917: RETURN fnd_global.user_id;
918: END;
919:
920: -- Fix For Bug 2932012
921: FUNCTION updated_by

Line 925: RETURN fnd_global.user_id;

921: FUNCTION updated_by
922: RETURN NUMBER
923: IS
924: BEGIN
925: RETURN fnd_global.user_id;
926: END;
927:
928: -- Fix For Bug 2932012
929: FUNCTION login_id

Line 933: RETURN fnd_global.login_id;

929: FUNCTION login_id
930: RETURN NUMBER
931: IS
932: BEGIN
933: RETURN fnd_global.login_id;
934: END;
935:
936: FUNCTION get_task_template_group (p_task_template_id IN NUMBER)
937: RETURN NUMBER

Line 2745: WHERE user_id = fnd_global.user_id;

2741:
2742: SELECT resource_id
2743: INTO l_resource_id
2744: FROM jtf_rs_resource_extns
2745: WHERE user_id = fnd_global.user_id;
2746: EXCEPTION
2747: WHEN NO_DATA_FOUND
2748: THEN
2749: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2831: WHERE user_id = fnd_global.user_id;

2827: )
2828: INTO x_owner_id,
2829: x_owner_type_code
2830: FROM jtf_rs_resource_extns
2831: WHERE user_id = fnd_global.user_id;
2832: SELECT name
2833: INTO x_owner_type_code_name
2834: FROM jtf_objects_vl
2835: WHERE object_code = x_owner_type_code;

Line 3141: WHERE user_id = fnd_global.user_id;

3137: IF p_category_id is not null THEN
3138: SELECT resource_id
3139: INTO l_resource_id
3140: FROM jtf_rs_resource_extns
3141: WHERE user_id = fnd_global.user_id;
3142:
3143: l_profile_name := TO_CHAR(l_resource_id)||g_perz_suffix;
3144:
3145: SELECT perz_data_id into l_category_id

Line 3197: WHERE user_id = fnd_global.user_id;

3193: -- user's id and type
3194: SELECT resource_id
3195: INTO l_rs_id
3196: FROM jtf_rs_resource_extns
3197: WHERE user_id = fnd_global.user_id;
3198:
3199:
3200: IF p_session = 'UPDATE'
3201: THEN

Line 3285: l_user_id NUMBER := fnd_global.user_id;

3281: p_task_id NUMBER,
3282: p_session VARCHAR2,
3283: x_return_status OUT NOCOPY VARCHAR2)
3284: IS
3285: l_user_id NUMBER := fnd_global.user_id;
3286:
3287: -- select the owner info from task table for this task id
3288: CURSOR c_task_owner IS
3289: SELECT owner_id, owner_type_code, private_flag