APPS.JTF_RS_RES_SSWA_PUB dependencies on FND_USER

Line 53: l_user_name fnd_user.user_name%type := upper(p_user_name);

49: l_source_location jtf_rs_resource_extns.source_location%type := p_source_location;
50: l_source_email jtf_rs_resource_extns.source_email%type := p_source_email;
51: l_source_phone jtf_rs_resource_extns.source_phone%type := p_source_phone;
52: l_business_group_id per_all_people_f.business_group_id%type;
53: l_user_name fnd_user.user_name%type := upper(p_user_name);
54: l_user_password fnd_user.encrypted_user_password%type := p_user_password;
55: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
56: /* Out Parameters for Create Employee*/
57:

Line 54: l_user_password fnd_user.encrypted_user_password%type := p_user_password;

50: l_source_email jtf_rs_resource_extns.source_email%type := p_source_email;
51: l_source_phone jtf_rs_resource_extns.source_phone%type := p_source_phone;
52: l_business_group_id per_all_people_f.business_group_id%type;
53: l_user_name fnd_user.user_name%type := upper(p_user_name);
54: l_user_password fnd_user.encrypted_user_password%type := p_user_password;
55: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
56: /* Out Parameters for Create Employee*/
57:
58: l_person_id number;

Line 139: /* Cursor Variables to get Fnd User Deatils */

135:
136: l_source_mgr_name varchar2(2000);
137: l_mgr_source_id number;
138:
139: /* Cursor Variables to get Fnd User Deatils */
140:
141: cursor fnd_user_details(l_user_name varchar2)
142: is
143: select user_id

Line 141: cursor fnd_user_details(l_user_name varchar2)

137: l_mgr_source_id number;
138:
139: /* Cursor Variables to get Fnd User Deatils */
140:
141: cursor fnd_user_details(l_user_name varchar2)
142: is
143: select user_id
144: from fnd_user
145: where user_name = l_user_name;

Line 144: from fnd_user

140:
141: cursor fnd_user_details(l_user_name varchar2)
142: is
143: select user_id
144: from fnd_user
145: where user_name = l_user_name;
146:
147: l_user_id number;
148:

Line 333: -- generate fnd user password

329: close Job_dtls;
330:
331: -- end if;
332:
333: -- generate fnd user password
334:
335: jtf_um_password_pvt.generate_password (
336: p_api_version_number => 1.0,
337: x_password => l_user_password,

Line 348: fnd_user_pkg.CreateUser (

344: end if;
345:
346: p_user_password := l_user_password;
347:
348: fnd_user_pkg.CreateUser (
349: x_user_name => l_user_name
350: ,x_owner => null
351: ,x_unencrypted_password => l_user_password
352: ,x_start_date => p_source_start_date

Line 361: open fnd_user_details(l_user_name);

357:
358: /* Fetching User Id datails */
359: if(l_user_name is NOT NULL )
360: then
361: open fnd_user_details(l_user_name);
362: fetch fnd_user_details into l_user_id;
363: close fnd_user_details;
364:
365: /* if l_user_id is NOT NULL

Line 362: fetch fnd_user_details into l_user_id;

358: /* Fetching User Id datails */
359: if(l_user_name is NOT NULL )
360: then
361: open fnd_user_details(l_user_name);
362: fetch fnd_user_details into l_user_id;
363: close fnd_user_details;
364:
365: /* if l_user_id is NOT NULL
366: then

Line 363: close fnd_user_details;

359: if(l_user_name is NOT NULL )
360: then
361: open fnd_user_details(l_user_name);
362: fetch fnd_user_details into l_user_id;
363: close fnd_user_details;
364:
365: /* if l_user_id is NOT NULL
366: then
367: raise

Line 665: from fnd_user

661:
662: cursor mgr_user(l_mgr_id number)
663: is
664: select user_id
665: from fnd_user
666: where employee_id = l_mgr_id;
667:
668: l_mgr_user_id number;
669:

Line 673: from fnd_user

669:
670: cursor user_cur(l_user_id number)
671: is
672: select user_name
673: from fnd_user
674: where user_id = l_user_id;
675:
676: l_user_name fnd_user.user_name%type;
677:

Line 676: l_user_name fnd_user.user_name%type;

672: select user_name
673: from fnd_user
674: where user_id = l_user_id;
675:
676: l_user_name fnd_user.user_name%type;
677:
678: l_u number := 0;
679: l_uwn number := 0;
680: l_uwa number := 0;