APPS.JTF_RS_SKILL_LEVELS_PVT dependencies on FND_PROFILE

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

151: END IF;
152:
153: --GET USER ID AND SYSDATE
154: l_date := sysdate;
155: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
156: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
157: x_skill_level_id := -1;
158:
159: chk_dup_skill_level(P_SKILL_LEVEL => p_skill_level,

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

152:
153: --GET USER ID AND SYSDATE
154: l_date := sysdate;
155: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
156: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
157: x_skill_level_id := -1;
158:
159: chk_dup_skill_level(P_SKILL_LEVEL => p_skill_level,
160: X_SKILL_LEVEL_ID => x_skill_level_id,

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

339:
340:
341: --GET USER ID AND SYSDATE
342: l_date := sysdate;
343: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
344: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
345:
346: OPEN chk_skill_cur(l_skill_level_id);
347: FETCH chk_skill_cur INTO skill_levels_rec;

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

340:
341: --GET USER ID AND SYSDATE
342: l_date := sysdate;
343: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
344: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
345:
346: OPEN chk_skill_cur(l_skill_level_id);
347: FETCH chk_skill_cur INTO skill_levels_rec;
348: