92: END IF;
93:
94: --GET USER ID AND SYSDATE
95: l_date := sysdate;
96: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
97: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
98:
99: OPEN c_dup_res_avail (l_resource_id, l_mode_of_availability);
100: FETCH c_dup_res_avail into l_availability_id;
93:
94: --GET USER ID AND SYSDATE
95: l_date := sysdate;
96: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
97: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
98:
99: OPEN c_dup_res_avail (l_resource_id, l_mode_of_availability);
100: FETCH c_dup_res_avail into l_availability_id;
101: IF (c_dup_res_avail%NOTFOUND) THEN
322:
323:
324: --GET USER ID AND SYSDATE
325: l_date := sysdate;
326: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
327: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
328:
329: OPEN resource_cur(l_availability_id);
330: FETCH resource_cur INTO resource_rec;
323:
324: --GET USER ID AND SYSDATE
325: l_date := sysdate;
326: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
327: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
328:
329: OPEN resource_cur(l_availability_id);
330: FETCH resource_cur INTO resource_rec;
331: