APPS.IRC_PURGE_OLD_DATA_PKG dependencies on FND_USER

Line 117: from fnd_user

113: where person_id = p_person_id;
114:
115: cursor csr_getfnduser(l_personIdIn in number) is
116: select user_name
117: from fnd_user
118: where employee_id = l_personIdIn;
119: --
120: begin
121: --

Line 162: l_user_name fnd_user.user_name%type;

158: ,p_root_person_id in number
159: ,p_effective_date in date
160: ) is
161: --
162: l_user_name fnd_user.user_name%type;
163: --
164: cursor csr_ias_del is
165: select ias.assignment_status_id, ias.object_version_number
166: from irc_assignment_statuses ias, per_all_assignments_f asg,

Line 185: from fnd_user usr

181: and per.effective_end_date;
182: --
183: cursor csr_usr_del is
184: select usr.user_name
185: from fnd_user usr
186: where usr.employee_id = p_root_person_id;
187: --
188: begin
189: --

Line 190: -- Delete Fnd User record

186: where usr.employee_id = p_root_person_id;
187: --
188: begin
189: --
190: -- Delete Fnd User record
191: --
192: open csr_usr_del;
193: fetch csr_usr_del into l_user_name;
194: close csr_usr_del;

Line 197: fnd_user_pkg.UpdateUser(

193: fetch csr_usr_del into l_user_name;
194: close csr_usr_del;
195: --
196: if l_user_name is not null then
197: fnd_user_pkg.UpdateUser(
198: x_user_name => l_user_name
199: ,x_owner => 'CUST'
200: ,x_employee_id => fnd_user_pkg.null_number
201: );

Line 200: ,x_employee_id => fnd_user_pkg.null_number

196: if l_user_name is not null then
197: fnd_user_pkg.UpdateUser(
198: x_user_name => l_user_name
199: ,x_owner => 'CUST'
200: ,x_employee_id => fnd_user_pkg.null_number
201: );
202: --
203: -- Disable user
204: --

Line 205: fnd_user_pkg.DisableUser(

201: );
202: --
203: -- Disable user
204: --
205: fnd_user_pkg.DisableUser(
206: username => l_user_name
207: );
208: end if;
209: --

Line 699: , fnd_user usr

695: cursor csr_last_login_date is
696: select inp.person_id,
697: inp.party_id
698: from irc_notification_preferences inp
699: , fnd_user usr
700: where inp.person_id = usr.employee_id
701: and is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
702: and p_months < months_between(p_effective_date,usr.last_logon_date);
703: --

Line 864: from fnd_user u

860: )
861: is
862: cursor csr_upd_employee is
863: select user_name
864: from fnd_user u
865: where u.employee_id is not null
866: and u.user_id between p_start_pkid and p_end_pkid
867: and not exists(select null
868: from per_all_people_f

Line 875: fnd_user_pkg.UpdateUser(

871: l_rows_processed number := 0;
872: begin
873: for csr_rec in csr_upd_employee
874: loop
875: fnd_user_pkg.UpdateUser(
876: x_user_name => csr_rec.user_name
877: ,x_owner => 'CUST'
878: ,x_employee_id => fnd_user_pkg.null_number
879: );

Line 878: ,x_employee_id => fnd_user_pkg.null_number

874: loop
875: fnd_user_pkg.UpdateUser(
876: x_user_name => csr_rec.user_name
877: ,x_owner => 'CUST'
878: ,x_employee_id => fnd_user_pkg.null_number
879: );
880: l_rows_processed := l_rows_processed + 1;
881: end loop;
882: p_rows_processed := l_rows_processed;