APPS.JTF_RS_GROUPS_AUD_PVT dependencies on FND_PROFILE

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

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

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

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

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

223: FND_MSG_PUB.Initialize;
224: END IF;
225:
226: l_date := sysdate;
227: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
228: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
229:
230:
231: open rr_old_cur(p_group_id);

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

224: END IF;
225:
226: l_date := sysdate;
227: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
228: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
229:
230:
231: open rr_old_cur(p_group_id);
232: FETCH rr_old_cur into rr_old_rec;

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

412: FND_MSG_PUB.Initialize;
413: END IF;
414:
415: l_date := sysdate;
416: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
417: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
418:
419:
420: open rr_old_cur(p_group_id);

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

413: END IF;
414:
415: l_date := sysdate;
416: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
417: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
418:
419:
420: open rr_old_cur(p_group_id);
421: FETCH rr_old_cur into rr_old_rec;