APPS.JTF_RS_ROLE_RELATE_AUD_PVT dependencies on FND_PROFILE

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

59: FND_MSG_PUB.Initialize;
60: END IF;
61:
62: l_date := sysdate;
63: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
64: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
65:
66:
67: select jtf_rs_role_relate_aud_s.nextval

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

60: END IF;
61:
62: l_date := sysdate;
63: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
64: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
65:
66:
67: select jtf_rs_role_relate_aud_s.nextval
68: into l_role_relate_aud_id

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

206: FND_MSG_PUB.Initialize;
207: END IF;
208:
209: l_date := sysdate;
210: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
211: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
212:
213:
214: open rr_old_cur(p_role_relate_id);

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

207: END IF;
208:
209: l_date := sysdate;
210: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
211: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
212:
213:
214: open rr_old_cur(p_role_relate_id);
215: FETCH rr_old_cur into rr_old_rec;

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

380: FND_MSG_PUB.Initialize;
381: END IF;
382:
383: l_date := sysdate;
384: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
385: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
386:
387:
388: open rr_old_cur(p_role_relate_id);

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

381: END IF;
382:
383: l_date := sysdate;
384: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
385: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
386:
387:
388: open rr_old_cur(p_role_relate_id);
389: FETCH rr_old_cur into rr_old_rec;