eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_PARTY_API dependencies on FND_USER

Line 2730: l_user_name fnd_user.user_name%type;

2726: l_proc varchar2(72) := g_package||'create_user';
2727: l_person_id per_all_people_f.person_id%type;
2728: l_user_id number;
2729: l_profile_check boolean;
2730: l_user_name fnd_user.user_name%type;
2731: l_default_last_name per_all_people_f.last_name%type;
2732: l_effective_start_date date;
2733: l_effective_end_date date;
2734: l_sec_profile_assignment_id number;

Line 2798: l_user_id := fnd_user_pkg.CreateUserId (

2794: hr_utility.set_location(l_proc,20);
2795: --
2796: -- Create User and set person_id to employee_id
2797: --
2798: l_user_id := fnd_user_pkg.CreateUserId (
2799: x_user_name => p_user_name,
2800: x_owner => 'CUST',
2801: x_unencrypted_password => p_password,
2802: x_email_address => p_email,

Line 2821: fnd_user_resp_groups_api.Insert_Assignment

2817: --
2818: --
2819: -- add the appropriate responsibility
2820: --
2821: fnd_user_resp_groups_api.Insert_Assignment
2822: (user_id => l_user_id
2823: ,responsibility_id => p_responsibility_id
2824: ,responsibility_application_id => p_resp_appl_id
2825: ,security_group_id => p_security_group_id

Line 3175: from fnd_user

3171: bad_guest_user exception;
3172:
3173: cursor get_pwd(p_guestUserName varchar2) is
3174: select encrypted_foundation_password
3175: from fnd_user
3176: where user_name = p_guestUserName
3177: and trunc(sysdate) between start_date and
3178: nvl(end_date,trunc(sysdate));
3179: --

Line 3180: guestEncFndPwd fnd_user.encrypted_foundation_password%type;

3176: where user_name = p_guestUserName
3177: and trunc(sysdate) between start_date and
3178: nvl(end_date,trunc(sysdate));
3179: --
3180: guestEncFndPwd fnd_user.encrypted_foundation_password%type;
3181: --
3182: begin
3183: --
3184: guestUserPwd := upper(FND_WEB_SEC.GET_GUEST_USERNAME_PWD());

Line 3248: l_new_user_name fnd_user.user_name%type;

3244: p_fax in varchar2 default null,
3245: p_customer_id in number default null,
3246: p_supplier_id in number default null,
3247: p_old_password in varchar2 default null) is
3248: l_new_user_name fnd_user.user_name%type;
3249: l_current_email_address fnd_user.email_address%type;
3250: cursor csr_get_email(p_user_name varchar2) is
3251: select upper(email_address)
3252: from fnd_user

Line 3249: l_current_email_address fnd_user.email_address%type;

3245: p_customer_id in number default null,
3246: p_supplier_id in number default null,
3247: p_old_password in varchar2 default null) is
3248: l_new_user_name fnd_user.user_name%type;
3249: l_current_email_address fnd_user.email_address%type;
3250: cursor csr_get_email(p_user_name varchar2) is
3251: select upper(email_address)
3252: from fnd_user
3253: where user_name = p_user_name;

Line 3252: from fnd_user

3248: l_new_user_name fnd_user.user_name%type;
3249: l_current_email_address fnd_user.email_address%type;
3250: cursor csr_get_email(p_user_name varchar2) is
3251: select upper(email_address)
3252: from fnd_user
3253: where user_name = p_user_name;
3254: --
3255: begin
3256: -- get existing email address

Line 3262: fnd_user_pkg.UpdateUser (

3258: open csr_get_email(p_user_name);
3259: fetch csr_get_email into l_current_email_address;
3260: close csr_get_email;
3261: --
3262: fnd_user_pkg.UpdateUser (
3263: x_user_name => p_user_name,
3264: x_owner => p_owner,
3265: x_unencrypted_password => p_unencrypted_password,
3266: x_session_number => p_session_number,

Line 3287: fnd_user_pkg.change_user_name(p_user_name,l_new_user_name);

3283: --
3284: l_new_user_name := upper(p_email_address);
3285: if p_user_name <> l_new_user_name
3286: and l_current_email_address = p_user_name then
3287: fnd_user_pkg.change_user_name(p_user_name,l_new_user_name);
3288: end if;
3289: end update_user;
3290: -- -------------------------------------------------------------------------
3291: -- |------------------------< self_register_user >-------------------------|

Line 3318: select 1 from fnd_user

3314: ,p_user_name IN varchar2 default null
3315: ) is
3316:
3317: cursor email_exists is
3318: select 1 from fnd_user
3319: where user_name=upper(p_current_email_address);
3320:
3321: l_date_of_birth date;
3322:

Line 3453: from fnd_user fusr

3449: and trunc(sysdate) between ptuf.effective_start_date and ptuf.effective_end_date;
3450:
3451: cursor existing_emails(p_person_id number,p_party_id number) is
3452: select fusr.user_name
3453: from fnd_user fusr
3454: where fusr.employee_id=p_person_id
3455: union
3456: select fusr.user_name
3457: from fnd_user fusr

Line 3457: from fnd_user fusr

3453: from fnd_user fusr
3454: where fusr.employee_id=p_person_id
3455: union
3456: select fusr.user_name
3457: from fnd_user fusr
3458: where fusr.customer_id=p_party_id;
3459:
3460: cursor user_association_exists(p_user_name varchar2) is
3461: select 1

Line 3462: from fnd_user fusr

3458: where fusr.customer_id=p_party_id;
3459:
3460: cursor user_association_exists(p_user_name varchar2) is
3461: select 1
3462: from fnd_user fusr
3463: where fusr.user_name=p_user_name
3464: and fusr.employee_id is not null;
3465:
3466: cursor get_user_id(p_user_name varchar2) is

Line 3468: from fnd_user fusr

3464: and fusr.employee_id is not null;
3465:
3466: cursor get_user_id(p_user_name varchar2) is
3467: select fusr.user_id
3468: from fnd_user fusr
3469: where fusr.user_name=p_user_name;
3470: --
3471: cursor get_menu_id (p_menu_name varchar2)is
3472: select menu_id from fnd_menus where menu_name=upper(p_menu_name);

Line 3736: fnd_user_pkg.disableUser(user_rec.user_name);

3732: --
3733: hr_utility.set_location(l_proc,150);
3734:
3735: for user_rec in existing_emails(l_person_id,l_party_id) loop
3736: fnd_user_pkg.disableUser(user_rec.user_name);
3737: end loop;
3738: --
3739: -- Get the Password Length from the profile
3740: --

Line 3785: l_user_id := fnd_user_pkg.CreateUserId (

3781: l_password:=l_password||mod(fnd_crypto.randomnumber,10);
3782:
3783: hr_utility.set_location(l_proc,160);
3784:
3785: l_user_id := fnd_user_pkg.CreateUserId (
3786: x_user_name => upper(p_current_email_address),
3787: x_owner => 'CUST',
3788: x_unencrypted_password => l_password,
3789: x_employee_id => l_person_id);

Line 3792: -- associate the previous employee record to the fnd user

3788: x_unencrypted_password => l_password,
3789: x_employee_id => l_person_id);
3790:
3791: else
3792: -- associate the previous employee record to the fnd user
3793: hr_utility.set_location(l_proc,165);
3794: fnd_user_pkg.UpdateUser(
3795: x_user_name => p_user_name,
3796: x_owner => 'CUST',

Line 3794: fnd_user_pkg.UpdateUser(

3790:
3791: else
3792: -- associate the previous employee record to the fnd user
3793: hr_utility.set_location(l_proc,165);
3794: fnd_user_pkg.UpdateUser(
3795: x_user_name => p_user_name,
3796: x_owner => 'CUST',
3797: x_employee_id => l_person_id);
3798: -- get the user ID for the given user name

Line 3829: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(l_user_id,

3825: if p_user_name is null then
3826: l_resp_exists := false;
3827: else
3828: hr_utility.set_location(l_proc,175);
3829: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(l_user_id,
3830: p_responsibility_id, p_resp_appl_id, p_security_group_id);
3831: end if;
3832: -- if the User doesn't have the responsibility, assign it.
3833: if NOT l_resp_exists then

Line 3837: fnd_user_resp_groups_api.Insert_Assignment

3833: if NOT l_resp_exists then
3834: --
3835: -- add the appropriate responsibility
3836: --
3837: fnd_user_resp_groups_api.Insert_Assignment
3838: (user_id => l_user_id
3839: ,responsibility_id => p_responsibility_id
3840: ,responsibility_application_id => p_resp_appl_id
3841: ,security_group_id => p_security_group_id

Line 3882: fnd_user_resp_groups_api.Update_Assignment

3878: hr_utility.set_location(l_proc, 205);
3879: --
3880: -- reopen the candidate responsibility
3881: --
3882: fnd_user_resp_groups_api.Update_Assignment
3883: (user_id => l_user_id
3884: ,responsibility_id => p_responsibility_id
3885: ,responsibility_application_id => p_resp_appl_id
3886: ,security_group_id => p_security_group_id

Line 4095: from fnd_user

4091: l_default_last_name per_all_people_f.last_name%type;
4092: --
4093: cursor get_person_party_info is
4094: select user_id, employee_id, person_party_id
4095: from fnd_user
4096: where user_name=upper(p_user_name);
4097: --
4098: cursor get_email_address is
4099: select nvl(fu.email_address, hzp.email_address)

Line 4100: from fnd_user fu, hz_parties hzp

4096: where user_name=upper(p_user_name);
4097: --
4098: cursor get_email_address is
4099: select nvl(fu.email_address, hzp.email_address)
4100: from fnd_user fu, hz_parties hzp
4101: where user_name=upper(p_user_name)
4102: and fu.person_party_id=hzp.party_id(+);
4103: --
4104: cursor get_notif_prefs(p_party_id number) is

Line 4194: -- if input email address is not null, use it rather than one from fnd_user

4190: open get_person_party_info;
4191: fetch get_person_party_info into l_user_id, l_person_id, l_person_party_id;
4192: close get_person_party_info;
4193: --
4194: -- if input email address is not null, use it rather than one from fnd_user
4195: --
4196: if p_email is not null then
4197: l_email_address := p_email;
4198: else

Line 4199: -- if input email is NULL, try getting it from FND_USER

4195: --
4196: if p_email is not null then
4197: l_email_address := p_email;
4198: else
4199: -- if input email is NULL, try getting it from FND_USER
4200: -- and if it is NULL try getting it from HZ_PARTIES
4201: -- and if that is NULL, use the UserName
4202: open get_email_address;
4203: fetch get_email_address into l_email_address;

Line 4223: -- there is no person attached to this FND_USER. We need to create a new

4219: end if;
4220: end if;
4221: --
4222: hr_utility.set_location(l_proc, 40);
4223: -- there is no person attached to this FND_USER. We need to create a new
4224: -- iRecruitment Candidate, update FND user with the person_id,
4225: -- set Language profile and Create Work Preferences
4226: if l_person_id is NULL then
4227: l_default_last_name := nvl(p_last_name,fnd_message.get_string('PER','IRC_412108_UNKNOWN_NAME'));

Line 4224: -- iRecruitment Candidate, update FND user with the person_id,

4220: end if;
4221: --
4222: hr_utility.set_location(l_proc, 40);
4223: -- there is no person attached to this FND_USER. We need to create a new
4224: -- iRecruitment Candidate, update FND user with the person_id,
4225: -- set Language profile and Create Work Preferences
4226: if l_person_id is NULL then
4227: l_default_last_name := nvl(p_last_name,fnd_message.get_string('PER','IRC_412108_UNKNOWN_NAME'));
4228:

Line 4244: fnd_user_pkg.UpdateUser

4240: );
4241: --
4242: hr_utility.set_location(l_proc, 50);
4243: --
4244: fnd_user_pkg.UpdateUser
4245: (x_user_name => p_user_name
4246: ,x_owner => 'CUST'
4247: ,x_employee_id => l_person_id);
4248: --

Line 4335: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(l_user_id,

4331: ,p_allow_access => l_allow_access);
4332: end if;
4333: hr_utility.set_location(l_proc, 90);
4334: -- check if the User has the required responsibility
4335: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(l_user_id,
4336: p_responsibility_id, p_resp_appl_id, p_security_group_id);
4337: -- if the User doesn't have the responsibility, assign it.
4338: if NOT l_resp_exists then
4339: --

Line 4342: fnd_user_resp_groups_api.Insert_Assignment

4338: if NOT l_resp_exists then
4339: --
4340: -- add the appropriate responsibility
4341: --
4342: fnd_user_resp_groups_api.Insert_Assignment
4343: (user_id => l_user_id
4344: ,responsibility_id => p_responsibility_id
4345: ,responsibility_application_id => p_resp_appl_id
4346: ,security_group_id => p_security_group_id

Line 4386: fnd_user_resp_groups_api.Update_Assignment

4382: hr_utility.set_location(l_proc, 95);
4383: --
4384: -- reopen the candidate responsibility
4385: --
4386: fnd_user_resp_groups_api.Update_Assignment
4387: (user_id => l_user_id
4388: ,responsibility_id => p_responsibility_id
4389: ,responsibility_application_id => p_resp_appl_id
4390: ,security_group_id => p_security_group_id

Line 4464: from fnd_user

4460: l_func_check varchar2(1);
4461: --
4462: cursor get_person_party_info is
4463: select user_id, employee_id, person_party_id
4464: from fnd_user
4465: where user_name=upper(p_user_name);
4466: --
4467: cursor get_bg(p_person_id number) is
4468: select per1.business_group_id

Line 4482: from fnd_user_resp_groups

4478: --
4479: cursor get_user_responsibility(p_user_id number, p_responsibility_id number,
4480: p_resp_appl_id number, p_security_group_id number) is
4481: select responsibility_id
4482: from fnd_user_resp_groups
4483: where user_id=p_user_id and responsibility_id=p_responsibility_id
4484: and responsibility_application_id = p_resp_appl_id
4485: and security_group_id = p_security_group_id;
4486: --

Line 4624: l_bool := fnd_user_pkg.setreencryptedpassword(username => p_user_name,

4620: p_email => p_email,
4621: p_allow_access => p_allow_access);
4622: hr_utility.set_location(' Entering: '||l_proc, 30);
4623: -- update the user password
4624: l_bool := fnd_user_pkg.setreencryptedpassword(username => p_user_name,
4625: reencpwd => p_password,
4626: newkey => 'LOADER');
4627: if NOT l_bool then
4628: raise PASSWORD_UPDATE_FAILED;

Line 4643: l_user_id := fnd_user_pkg.CreateUserId(

4639: -- note that we are passing in FND_WEB_SEC.EXTERNAL_PWD which is checked by
4640: -- ATG routine and treats this as an SSO user
4641: elsif l_num = 3 then
4642: hr_utility.set_location(l_proc, 15);
4643: l_user_id := fnd_user_pkg.CreateUserId(
4644: x_user_name => p_user_name
4645: ,x_owner => 'CUST'
4646: ,x_unencrypted_password => FND_WEB_SEC.EXTERNAL_PWD
4647: ,x_email_address => p_email

Line 4703: from fnd_user

4699: )is
4700: --
4701: cursor get_person_party_info is
4702: select employee_id, person_party_id
4703: from fnd_user
4704: where user_id=p_user_id;
4705:
4706: l_person_id number;
4707: l_person_party_id number;

Line 4729: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(p_user_id,

4725: if l_person_id is not null then
4726: l_per_type := irc_utilities_pkg.get_emp_spt_for_person(l_person_id, trunc(p_start_date));
4727: end if;
4728: -- check if the User has the required responsibility
4729: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(p_user_id,
4730: p_responsibility_id, p_resp_appl_id, p_security_group_id);
4731: -- if the User doesn't have the responsibility, assign it.
4732: if NOT l_resp_exists then
4733: if (l_per_type = 'EMP') then

Line 4740: fnd_user_resp_groups_api.Insert_Assignment

4736: end if;
4737: --
4738: -- add the appropriate responsibility
4739: --
4740: fnd_user_resp_groups_api.Insert_Assignment
4741: (user_id => p_user_id
4742: ,responsibility_id => p_responsibility_id
4743: ,responsibility_application_id => p_resp_appl_id
4744: ,security_group_id => p_security_group_id

Line 4785: fnd_user_resp_groups_api.Update_Assignment

4781: if (l_per_type <> 'EMP') then
4782: --
4783: -- reopen the candidate responsibility
4784: --
4785: fnd_user_resp_groups_api.Update_Assignment
4786: (user_id => p_user_id
4787: ,responsibility_id => p_responsibility_id
4788: ,responsibility_application_id => p_resp_appl_id
4789: ,security_group_id => p_security_group_id

Line 4824: return fnd_user_pkg.testusername(x_user_name=>p_user_name);

4820: p_user_name IN varchar2
4821: ) return NUMBER
4822: is
4823: begin
4824: return fnd_user_pkg.testusername(x_user_name=>p_user_name);
4825: end TestUserName;
4826: --
4827: -- -------------------------------------------------------------------------
4828: -- |------------------------< assign_responsibility >----------------------|

Line 4849: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(p_user_id,

4845: l_proc varchar2(72) := g_package||'assign_responsibility';
4846:
4847: begin
4848: -- check if the User has the required responsibility
4849: l_resp_exists := fnd_user_resp_groups_api.Assignment_Exists(p_user_id,
4850: p_resp_id, p_resp_appl_id, p_sec_group_id);
4851: -- if the User doesn't have the responsibility, assign it.
4852: if NOT l_resp_exists then
4853: --

Line 4856: fnd_user_resp_groups_api.Insert_Assignment

4852: if NOT l_resp_exists then
4853: --
4854: -- add the appropriate responsibility
4855: --
4856: fnd_user_resp_groups_api.Insert_Assignment
4857: (user_id => p_user_id
4858: ,responsibility_id => p_resp_id
4859: ,responsibility_application_id => p_resp_appl_id
4860: ,security_group_id => p_sec_group_id

Line 4900: fnd_user_resp_groups_api.Update_Assignment

4896: hr_utility.set_location(l_proc, 95);
4897: --
4898: -- reopen the candidate responsibility
4899: --
4900: fnd_user_resp_groups_api.Update_Assignment
4901: (user_id => p_user_id
4902: ,responsibility_id => p_resp_id
4903: ,responsibility_application_id => p_resp_appl_id
4904: ,security_group_id => p_sec_group_id

Line 4973: l_user_name fnd_user.user_name%type;

4969: l_proc varchar2(72) := g_package||'create_user_internal_byReferral';
4970: l_person_id per_all_people_f.person_id%type;
4971: l_user_id number;
4972: l_profile_check boolean;
4973: l_user_name fnd_user.user_name%type;
4974: l_default_last_name per_all_people_f.last_name%type;
4975: l_effective_start_date date;
4976: l_effective_end_date date;
4977: l_sec_profile_assignment_id number;

Line 5000: l_user_id := fnd_user_pkg.CreateUserId (

4996: hr_utility.set_location(l_proc,20);
4997: --
4998: -- Create User and set person_id to employee_id
4999: --
5000: l_user_id := fnd_user_pkg.CreateUserId (
5001: x_user_name => p_user_name,
5002: x_owner => 'CUST',
5003: x_unencrypted_password => p_password,
5004: x_email_address => p_email,

Line 5023: UPDATE fnd_user

5019: --
5020: -- Set the password date Column to Null for the created user
5021: -- As the password is system generated, it should be changed
5022: -- by candidate when he first logs in
5023: UPDATE fnd_user
5024: SET password_date=NULL
5025: WHERE user_name=upper(p_user_name);
5026: --
5027: -- commit autonomous transaction