APPS.CCT_ICJUMPSTART_PUB dependencies on FND_USER

Line 88: from fnd_user

84: If (p_app_username is not null) then
85: Begin
86: Select 1
87: into p_sql_Result
88: from fnd_user
89: where user_name=p_app_username;
90: If (p_sql_result=1) then
91: x_Return_Status:=FND_API.G_RET_STS_ERROR;
92: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_USERNAME_ALREADY_EXISTS');

Line 243: fnd_user_pkg.addresp(upper(p_app_username),'CCT','CCT_WEB_ADMIN'

239:
240: -- Add CCT Web Admin, Telesales Agent, Customer Care responsibilities to
241: -- agent
242: Begin
243: fnd_user_pkg.addresp(upper(p_app_username),'CCT','CCT_WEB_ADMIN'
244: ,'STANDARD'
245: ,'Call Center Admin'
246: ,sysdate
247: ,null);

Line 258: fnd_user_pkg.addresp(upper(p_app_username),'AST','AST_TELEAGENT'

254: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
255: -- rem dbms_output.put_line('Error Creating Call Center Responsibility:'||x_message_data);
256: end;
257: Begin
258: fnd_user_pkg.addresp(upper(p_app_username),'AST','AST_TELEAGENT'
259: ,'STANDARD'
260: ,'Telesales Agent'
261: ,sysdate
262: ,null);

Line 273: fnd_user_pkg.addresp(upper(p_app_username),'CSS','ORACLE_SUPPORT'

269: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
270: -- rem dbms_output.put_line('Error Creating Telesales Responsibility:'||x_message_data);
271: end;
272: Begin
273: fnd_user_pkg.addresp(upper(p_app_username),'CSS','ORACLE_SUPPORT'
274: ,'STANDARD'
275: ,'Customer Support Agent'
276: ,sysdate
277: ,null);

Line 291: l_chgpwd_status:=fnd_user_pkg.changepassword(p_app_username,'WELCOME');

287: -- rem dbms_output.put_line('Added responsibilities for '||p_last_name||', '||p_first_name);
288:
289: -- Reset Password to 'WELCOME'
290:
291: l_chgpwd_status:=fnd_user_pkg.changepassword(p_app_username,'WELCOME');
292: x_user_password:='WELCOME';
293:
294: -- Define Agent Role
295: