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