DBA Data[Home] [Help]

APPS.FND_LOGVIEW dependencies on FND_USER

Line 581: select user_id into f_user_id from fnd_user

577: end if;
578:
579: if(only_user is not null and username is not null) then
580: begin
581: select user_id into f_user_id from fnd_user
582: where user_name = upper(username);
583: exception
584: when no_data_found then
585: htp.p('Invalid username entered. Finding data for current user.');

Line 940: from fnd_user

936: found_username := last_username;
937: else
938: begin
939: select user_name into found_username
940: from fnd_user
941: where user_id = l_user_id;
942: exception when no_data_found then
943: found_username := 'Invalid Userid: '||to_char(l_user_id);
944: end;

Line 1181: select user_id into user_id_x from fnd_user

1177: purged := TRUE;
1178: elsif (sysclearuserlog is not null) then /* if user pressed... */
1179: user_id_x := NULL;
1180: begin
1181: select user_id into user_id_x from fnd_user
1182: where user_name = upper(USER_TO_PURGE);
1183: exception
1184: when no_data_found then
1185: htp.p('Invalid username entered. Enter a valid username.');

Line 1206: select user_id into user_id_x from fnd_user

1202: purged := TRUE;
1203: elsif (syssetuserprefs is not null) then /* if user pressed... */
1204: user_id_x := NULL;
1205: begin
1206: select user_id into user_id_x from fnd_user
1207: where user_name = upper(USER_TO_SET);
1208: exception
1209: when no_data_found then
1210: htp.p('Invalid username entered. Enter a valid username.');