APPS.JTF_RS_GROUP_RELATE_PUB dependencies on FND_PROFILE

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

96: END IF;
97:
98: --GET USER ID AND SYSDATE
99: l_date := sysdate;
100: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
101: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
102:
103: --check for group id/number and get valid group id
104: OPEN grp_cur(p_group_id,

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

97:
98: --GET USER ID AND SYSDATE
99: l_date := sysdate;
100: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
101: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
102:
103: --check for group id/number and get valid group id
104: OPEN grp_cur(p_group_id,
105: p_group_number);

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

260: END IF;
261:
262: --GET USER ID AND SYSDATE
263: l_date := sysdate;
264: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
265: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
266: -------------------
267: OPEN val_grp_rel_cur(p_group_relate_id);
268: FETCH val_grp_rel_cur INTO dummy;

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

261:
262: --GET USER ID AND SYSDATE
263: l_date := sysdate;
264: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
265: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
266: -------------------
267: OPEN val_grp_rel_cur(p_group_relate_id);
268: FETCH val_grp_rel_cur INTO dummy;
269: IF(val_grp_rel_cur%NOTFOUND)

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

391: END IF;
392:
393: --GET USER ID AND SYSDATE
394: l_date := sysdate;
395: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
396: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
397: -------------------
398: OPEN val_grp_rel_cur(p_group_relate_id);
399: FETCH val_grp_rel_cur INTO dummy;

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

392:
393: --GET USER ID AND SYSDATE
394: l_date := sysdate;
395: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
396: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
397: -------------------
398: OPEN val_grp_rel_cur(p_group_relate_id);
399: FETCH val_grp_rel_cur INTO dummy;
400: IF(val_grp_rel_cur%NOTFOUND)