APPS.IRC_PURGE_OLD_DATA_PKG dependencies on FND_USER

Line 121: from fnd_user

117: where person_id = p_person_id;
118:
119: cursor csr_getfnduser(l_personIdIn in number) is
120: select user_name
121: from fnd_user
122: where employee_id = l_personIdIn;
123: --
124: begin
125: --

Line 169: l_user_name fnd_user.user_name%type;

165: ,p_root_person_id in number
166: ,p_effective_date in date
167: ) is
168: --
169: l_user_name fnd_user.user_name%type;
170: --
171: cursor csr_ias_del is
172: select ias.assignment_status_id, ias.object_version_number
173: from irc_assignment_statuses ias, per_all_assignments_f asg,

Line 188: from fnd_user usr

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

Line 193: -- Delete Fnd User record

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

Line 200: fnd_user_pkg.UpdateUser(

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

Line 203: ,x_employee_id => fnd_user_pkg.null_number

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

Line 208: fnd_user_pkg.DisableUser(

204: );
205: --
206: -- Disable user
207: --
208: fnd_user_pkg.DisableUser(
209: username => l_user_name
210: );
211: end if;
212: --

Line 826: , fnd_user usr

822: cursor csr_last_login_date is
823: select inp.person_id,
824: inp.party_id
825: from irc_notification_preferences inp
826: , fnd_user usr
827: where inp.person_id = usr.employee_id
828: and is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
829: and p_months < months_between(p_effective_date,usr.last_logon_date);
830: --

Line 991: from fnd_user u

987: )
988: is
989: cursor csr_upd_employee is
990: select user_name
991: from fnd_user u
992: where u.employee_id is not null
993: and u.user_id between p_start_pkid and p_end_pkid
994: and not exists(select null
995: from per_all_people_f

Line 1002: fnd_user_pkg.UpdateUser(

998: l_rows_processed number := 0;
999: begin
1000: for csr_rec in csr_upd_employee
1001: loop
1002: fnd_user_pkg.UpdateUser(
1003: x_user_name => csr_rec.user_name
1004: ,x_owner => 'CUST'
1005: ,x_employee_id => fnd_user_pkg.null_number
1006: );

Line 1005: ,x_employee_id => fnd_user_pkg.null_number

1001: loop
1002: fnd_user_pkg.UpdateUser(
1003: x_user_name => csr_rec.user_name
1004: ,x_owner => 'CUST'
1005: ,x_employee_id => fnd_user_pkg.null_number
1006: );
1007: l_rows_processed := l_rows_processed + 1;
1008: end loop;
1009: p_rows_processed := l_rows_processed;