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