DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on JTF_RS_RESOURCE_EXTNS

Line 2744: FROM jtf_rs_resource_extns

2740: END IF;
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

Line 2830: FROM jtf_rs_resource_extns

2826: 'SUPPLIER_CONTACT', 'RS_SUPPLIER_CONTACT'
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

Line 3140: FROM jtf_rs_resource_extns

3136: -- to verify user's category
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:

Line 3196: FROM jtf_rs_resource_extns

3192:
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'

Line 3298: FROM jtf_rs_resource_extns

3294:
3295: -- user's id and type
3296: CURSOR c_resource IS
3297: SELECT resource_id
3298: FROM jtf_rs_resource_extns
3299: WHERE user_id = l_user_id;
3300:
3301: rec_resource c_resource%ROWTYPE;
3302: