DBA Data[Home] [Help]

APPS.IRC_PENDING_DATA_API dependencies on FND_USER

Line 79: l_enc_password fnd_user.encrypted_user_password%type;

75: l_user_id number;
76: l_date_of_birth date;
77: l_creation_date date;
78: l_last_update_date date;
79: l_enc_password fnd_user.encrypted_user_password%type;
80: l_user_guid fnd_user.user_guid%type;
81: l_proc varchar2(72) := g_package||'CREATE_PENDING_DATA';
82: --
83: -- cursor to get the encryptd password for new user.

Line 80: l_user_guid fnd_user.user_guid%type;

76: l_date_of_birth date;
77: l_creation_date date;
78: l_last_update_date date;
79: l_enc_password fnd_user.encrypted_user_password%type;
80: l_user_guid fnd_user.user_guid%type;
81: l_proc varchar2(72) := g_package||'CREATE_PENDING_DATA';
82: --
83: -- cursor to get the encryptd password for new user.
84: cursor csr_fnd_user_details is

Line 84: cursor csr_fnd_user_details is

80: l_user_guid fnd_user.user_guid%type;
81: l_proc varchar2(72) := g_package||'CREATE_PENDING_DATA';
82: --
83: -- cursor to get the encryptd password for new user.
84: cursor csr_fnd_user_details is
85: select fnd_user_pkg.GetReEncryptedPassword(user_name,'LOADER') as encrypted_user_password,
86: user_guid
87: from fnd_user
88: where user_name = upper(p_email_address);

Line 85: select fnd_user_pkg.GetReEncryptedPassword(user_name,'LOADER') as encrypted_user_password,

81: l_proc varchar2(72) := g_package||'CREATE_PENDING_DATA';
82: --
83: -- cursor to get the encryptd password for new user.
84: cursor csr_fnd_user_details is
85: select fnd_user_pkg.GetReEncryptedPassword(user_name,'LOADER') as encrypted_user_password,
86: user_guid
87: from fnd_user
88: where user_name = upper(p_email_address);
89: --

Line 87: from fnd_user

83: -- cursor to get the encryptd password for new user.
84: cursor csr_fnd_user_details is
85: select fnd_user_pkg.GetReEncryptedPassword(user_name,'LOADER') as encrypted_user_password,
86: user_guid
87: from fnd_user
88: where user_name = upper(p_email_address);
89: --
90: begin
91: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 177: --Create new fnd_user

173: l_num := irc_party_api.testusername(p_user_name=>p_email_address);
174: hr_utility.set_location(l_proc,20);
175: if l_num = 0 then
176: --
177: --Create new fnd_user
178: --
179: l_user_id := fnd_user_pkg.createUserId
180: (x_user_name => p_email_address
181: ,x_owner => 'CUST'

Line 179: l_user_id := fnd_user_pkg.createUserId

175: if l_num = 0 then
176: --
177: --Create new fnd_user
178: --
179: l_user_id := fnd_user_pkg.createUserId
180: (x_user_name => p_email_address
181: ,x_owner => 'CUST'
182: ,x_unencrypted_password => p_user_password
183: ,x_email_address => p_email_address

Line 194: open csr_fnd_user_details;

190: fnd_message.raise_error;
191: end if;
192: end if;
193: -- get the user details
194: open csr_fnd_user_details;
195: fetch csr_fnd_user_details into l_enc_password, l_user_guid;
196: close csr_fnd_user_details;
197: --
198: irc_ipd_ins.ins

Line 195: fetch csr_fnd_user_details into l_enc_password, l_user_guid;

191: end if;
192: end if;
193: -- get the user details
194: open csr_fnd_user_details;
195: fetch csr_fnd_user_details into l_enc_password, l_user_guid;
196: close csr_fnd_user_details;
197: --
198: irc_ipd_ins.ins
199: (p_email_address => p_email_address

Line 196: close csr_fnd_user_details;

192: end if;
193: -- get the user details
194: open csr_fnd_user_details;
195: fetch csr_fnd_user_details into l_enc_password, l_user_guid;
196: close csr_fnd_user_details;
197: --
198: irc_ipd_ins.ins
199: (p_email_address => p_email_address
200: ,p_last_name => p_last_name

Line 808: from fnd_user

804: l_new_user_id number;
805: --
806: cursor csr_get_user_id (p_user_name varchar2) is
807: select user_id
808: from fnd_user
809: where user_name= upper(p_user_name);
810: l_user_id fnd_user.user_id%type;
811: --
812: cursor csr_get_employee_id (p_user_name varchar2) is

Line 810: l_user_id fnd_user.user_id%type;

806: cursor csr_get_user_id (p_user_name varchar2) is
807: select user_id
808: from fnd_user
809: where user_name= upper(p_user_name);
810: l_user_id fnd_user.user_id%type;
811: --
812: cursor csr_get_employee_id (p_user_name varchar2) is
813: select employee_id
814: from fnd_user

Line 814: from fnd_user

810: l_user_id fnd_user.user_id%type;
811: --
812: cursor csr_get_employee_id (p_user_name varchar2) is
813: select employee_id
814: from fnd_user
815: where user_name= upper(p_user_name);
816: --
817: cursor csr_get_resp_id(p_resp_key varchar2) is
818: select responsibility_id,application_id

Line 918: from irc_pending_data ipd, fnd_user usr

914: ,ipd.user_guid
915: ,ipd.visitor_resp_key
916: ,ipd.visitor_resp_appl_id
917: ,ipd.security_group_key
918: from irc_pending_data ipd, fnd_user usr
919: where upper(ipd.email_address) = usr.user_name(+)
920: and ipd.processed is null
921: order by ipd.creation_date asc;
922: --

Line 1035: -- If user_id is NULL, create the FND user for this user

1031: begin
1032: --
1033: l_person_id := null;
1034: --
1035: -- If user_id is NULL, create the FND user for this user
1036: --
1037: if l_data.user_id is null then
1038: irc_party_api.create_ha_processed_user(p_user_name => l_data.email_address
1039: ,p_password => l_data.user_password

Line 1055: from fnd_user

1051: --
1052: l_new_user_id := null;
1053: --
1054: select employee_id, user_id into l_person_id, l_new_user_id
1055: from fnd_user
1056: where user_name = upper(l_data.email_address);
1057: --
1058: irc_party_api.process_ha_resp_check(p_user_id => l_new_user_id,
1059: p_responsibility_id => l_irc_resp_id,

Line 1093: from fnd_user

1089: ,p_allow_access => l_data.allow_access
1090: );
1091: end if;
1092: select employee_id into l_person_id
1093: from fnd_user
1094: where user_name = upper(l_data.email_address);
1095: --
1096: -- update pending data row to have the person_id
1097: --