APPS.JTF_RS_GROUP_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_grp_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_grp_relate_aud_s.nextval
68: into l_group_relate_aud_id

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

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

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

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

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

377: FND_MSG_PUB.Initialize;
378: END IF;
379:
380: l_date := sysdate;
381: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
382: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
383:
384:
385: open rr_old_cur(p_group_relate_id);

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

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