APPS.JTF_RS_GROUP_MEMBERS_AUD_PVT dependencies on FND_PROFILE

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

56: FND_MSG_PUB.Initialize;
57: END IF;
58:
59: l_date := sysdate;
60: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
61: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
62:
63:
64:

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

57: END IF;
58:
59: l_date := sysdate;
60: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
61: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
62:
63:
64:
65: select jtf_rs_group_members_aud_s.nextval

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

187: FND_MSG_PUB.Initialize;
188: END IF;
189:
190: l_date := sysdate;
191: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
192: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
193:
194:
195: open rr_old_cur(p_group_member_id);

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

188: END IF;
189:
190: l_date := sysdate;
191: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
192: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
193:
194:
195: open rr_old_cur(p_group_member_id);
196: FETCH rr_old_cur into rr_old_rec;

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

333: FND_MSG_PUB.Initialize;
334: END IF;
335:
336: l_date := sysdate;
337: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
338: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
339:
340:
341: open rr_old_cur(p_group_member_id);

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

334: END IF;
335:
336: l_date := sysdate;
337: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
338: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
339:
340:
341: open rr_old_cur(p_group_member_id);
342: FETCH rr_old_cur into rr_old_rec;