APPS.JTF_RS_RESOURCE_SKILLS_PVT dependencies on FND_PROFILE

Line 305: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

301: END IF;
302:
303: --GET USER ID AND SYSDATE
304: l_date := sysdate;
305: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
306: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
307:
308: l_catset := to_number(fnd_profile.value('CS_SR_DEFAULT_CATEGORY_SET'));
309:

Line 306: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

302:
303: --GET USER ID AND SYSDATE
304: l_date := sysdate;
305: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
306: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
307:
308: l_catset := to_number(fnd_profile.value('CS_SR_DEFAULT_CATEGORY_SET'));
309:
310: -------------------------------------------------------------------

Line 308: l_catset := to_number(fnd_profile.value('CS_SR_DEFAULT_CATEGORY_SET'));

304: l_date := sysdate;
305: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
306: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
307:
308: l_catset := to_number(fnd_profile.value('CS_SR_DEFAULT_CATEGORY_SET'));
309:
310: -------------------------------------------------------------------
311:
312: -- Check if subcategory passed is valid

Line 864: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

860:
861:
862: --GET USER ID AND SYSDATE
863: l_date := sysdate;
864: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
865: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
866:
867: OPEN resource_skills_cur(l_resource_skill_id);
868: FETCH resource_skills_cur INTO resource_skills_rec;

Line 865: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

861:
862: --GET USER ID AND SYSDATE
863: l_date := sysdate;
864: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
865: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
866:
867: OPEN resource_skills_cur(l_resource_skill_id);
868: FETCH resource_skills_cur INTO resource_skills_rec;
869: