APPS.JTF_RS_IMPORT_USER_PUB dependencies on FND_USER

Line 43: l_mgr_employee_id fnd_user.employee_id%type;

39: l_resource_group jtf_rs_groups_vl.group_name%type ;
40: l_default_resp fnd_responsibility_vl.responsibility_name%type ;
41:
42: l_business_group_id per_all_people_f.business_group_id%type;
43: l_mgr_employee_id fnd_user.employee_id%type;
44:
45: cursor upload_data is
46: select column1, column2, column3, column4, column5, column6, column7, column8,
47: column9, column10, column11, column12, column13, record_no

Line 51: cursor get_mgr_emp_id (p_mgr_user_name fnd_user.user_name%type) is

47: column9, column10, column11, column12, column13, record_no
48: from jtf_rs_upload_data
49: where transaction_no = p_transaction_no;
50:
51: cursor get_mgr_emp_id (p_mgr_user_name fnd_user.user_name%type) is
52: select employee_id
53: from fnd_user
54: where user_name = p_mgr_user_name;
55:

Line 53: from fnd_user

49: where transaction_no = p_transaction_no;
50:
51: cursor get_mgr_emp_id (p_mgr_user_name fnd_user.user_name%type) is
52: select employee_id
53: from fnd_user
54: where user_name = p_mgr_user_name;
55:
56: cursor c_dup_user_name (l_user_name fnd_user.user_name%type) is
57: select 1 from fnd_user

Line 56: cursor c_dup_user_name (l_user_name fnd_user.user_name%type) is

52: select employee_id
53: from fnd_user
54: where user_name = p_mgr_user_name;
55:
56: cursor c_dup_user_name (l_user_name fnd_user.user_name%type) is
57: select 1 from fnd_user
58: where user_name = l_user_name;
59:
60: cursor c_mgr_user_name (l_mgr_user_name fnd_user.user_name%type) is

Line 57: select 1 from fnd_user

53: from fnd_user
54: where user_name = p_mgr_user_name;
55:
56: cursor c_dup_user_name (l_user_name fnd_user.user_name%type) is
57: select 1 from fnd_user
58: where user_name = l_user_name;
59:
60: cursor c_mgr_user_name (l_mgr_user_name fnd_user.user_name%type) is
61: select user_id from fnd_user

Line 60: cursor c_mgr_user_name (l_mgr_user_name fnd_user.user_name%type) is

56: cursor c_dup_user_name (l_user_name fnd_user.user_name%type) is
57: select 1 from fnd_user
58: where user_name = l_user_name;
59:
60: cursor c_mgr_user_name (l_mgr_user_name fnd_user.user_name%type) is
61: select user_id from fnd_user
62: where user_name = l_mgr_user_name;
63:
64: cursor c_mgr_resource_id (l_mgr_user_id jtf_rs_resource_extns.user_id%type) is

Line 61: select user_id from fnd_user

57: select 1 from fnd_user
58: where user_name = l_user_name;
59:
60: cursor c_mgr_user_name (l_mgr_user_name fnd_user.user_name%type) is
61: select user_id from fnd_user
62: where user_name = l_mgr_user_name;
63:
64: cursor c_mgr_resource_id (l_mgr_user_id jtf_rs_resource_extns.user_id%type) is
65: select resource_id

Line 105: from fnd_user

101: where role_name = l_role_name;
102:
103: cursor c_get_user_id (l_user_name jtf_rs_resource_extns.user_name%type) is
104: select user_id
105: from fnd_user
106: where user_name = l_user_name;
107:
108: l_resource_id number;
109: l_user_id number;

Line 110: l_user_password fnd_user.encrypted_user_password%type := NULL;

106: where user_name = l_user_name;
107:
108: l_resource_id number;
109: l_user_id number;
110: l_user_password fnd_user.encrypted_user_password%type := NULL;
111: l_group_member_id number;
112: l_role_relate_id number;
113:
114: l_mgr_user_id jtf_rs_resource_extns.user_id%type;

Line 496: --Create Fnd User Responsibility Groups

492: open c_get_user_id (l_user_name);
493: fetch c_get_user_id into l_user_id;
494: close c_get_user_id;
495:
496: --Create Fnd User Responsibility Groups
497: Fnd_User_Resp_Groups_Api.Insert_Assignment(
498: l_user_id,
499: l_responsibility_id1,
500: 690,

Line 497: Fnd_User_Resp_Groups_Api.Insert_Assignment(

493: fetch c_get_user_id into l_user_id;
494: close c_get_user_id;
495:
496: --Create Fnd User Responsibility Groups
497: Fnd_User_Resp_Groups_Api.Insert_Assignment(
498: l_user_id,
499: l_responsibility_id1,
500: 690,
501: 0,

Line 509: Fnd_User_Resp_Groups_Api.Insert_Assignment(

505: );
506:
507: if l_responsibility_id2 is not null then
508:
509: Fnd_User_Resp_Groups_Api.Insert_Assignment(
510: l_user_id,
511: l_responsibility_id2,
512: 690,
513: 0,