98: END IF;
99:
100: --GET USER ID AND SYSDATE
101: l_date := sysdate;
102: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
103: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
104:
105: -- Check that attribute access levels are valid
106: IF l_attribute_access_level IN ('U','NU','UWN','UWA') THEN
99:
100: --GET USER ID AND SYSDATE
101: l_date := sysdate;
102: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
103: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
104:
105: -- Check that attribute access levels are valid
106: IF l_attribute_access_level IN ('U','NU','UWN','UWA') THEN
107: l_go_ahead := 'YES';
323:
324:
325: --GET USER ID AND SYSDATE
326: l_date := sysdate;
327: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
328: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
329:
330: OPEN table_attribute_cur(l_attribute_id);
331: FETCH table_attribute_cur INTO table_attribute_rec;
324:
325: --GET USER ID AND SYSDATE
326: l_date := sysdate;
327: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
328: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
329:
330: OPEN table_attribute_cur(l_attribute_id);
331: FETCH table_attribute_cur INTO table_attribute_rec;
332: