APPS.JTF_RS_GROUPS_AUD_PVT dependencies on FND_PROFILE

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

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

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

62: END IF;
63:
64: l_date := sysdate;
65: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
66: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
67:
68:
69: select jtf_rs_groups_audit_s.nextval
70: into l_group_audit_id

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

229: FND_MSG_PUB.Initialize;
230: END IF;
231:
232: l_date := sysdate;
233: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
234: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
235:
236:
237: open rr_old_cur(p_group_id);

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

230: END IF;
231:
232: l_date := sysdate;
233: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
234: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
235:
236:
237: open rr_old_cur(p_group_id);
238: FETCH rr_old_cur into rr_old_rec;

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

427: FND_MSG_PUB.Initialize;
428: END IF;
429:
430: l_date := sysdate;
431: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
432: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
433:
434:
435: open rr_old_cur(p_group_id);

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

428: END IF;
429:
430: l_date := sysdate;
431: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
432: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
433:
434:
435: open rr_old_cur(p_group_id);
436: FETCH rr_old_cur into rr_old_rec;