APPS.IRC_LOGIN dependencies on FND_USER

Line 25: from fnd_user

21: l_function_id fnd_form_functions.function_id%type;
22: --
23: cursor get_user_id is
24: select user_id
25: from fnd_user
26: where user_name=substr(FND_WEB_SEC.GET_GUEST_USERNAME_PWD()
27: ,0
28: ,instr(FND_WEB_SEC.GET_GUEST_USERNAME_PWD(),'/')-1);
29: l_user_id fnd_user.user_id%type;

Line 29: l_user_id fnd_user.user_id%type;

25: from fnd_user
26: where user_name=substr(FND_WEB_SEC.GET_GUEST_USERNAME_PWD()
27: ,0
28: ,instr(FND_WEB_SEC.GET_GUEST_USERNAME_PWD(),'/')-1);
29: l_user_id fnd_user.user_id%type;
30: --
31: cursor get_resp_id is
32: select responsibility_id
33: from fnd_responsibility

Line 139: from fnd_user

135: if l_result = 'N' and p_disable = 'Y' then
136: begin
137: hr_utility.set_location('calling disable user',30);
138: select user_id into userID
139: from fnd_user
140: where user_name = user AND
141: user_id <> 6 and
142: (start_date <= sysdate) AND
143: (end_date is null or end_date > sysdate);

Line 172: FND_USER_PKG.UpdateUser (

168: c_token => p_token
169: ,i_1 => p_username
170: ,i_2 => p_password);
171: hr_utility.set_location('done calling convertsession'||p_username,20);
172: FND_USER_PKG.UpdateUser (
173: x_user_name => p_username
174: ,x_owner => null
175: ,x_last_logon_date => sysdate
176: );