create or replace procedure test_uumsfunctionrole as
cursor cur is select USER_DEPT_ID FROM T_UUMS_UPG_USER_DEPT_SYSROLE where USER_DEPT_SYSTEM ='ECS';
begin
for Temp in cur loop
update T_UUMS_UPG_USER_DEPT_SYSROLE set USER_DEPT_ROLECODE='ECS'||USER_DEPT_ROLECODE where USER_DEPT_ID=Temp.USER_DEPT_ID;
end loop;
commit;
end;
cursor cur is select USER_DEPT_ID FROM T_UUMS_UPG_USER_DEPT_SYSROLE where USER_DEPT_SYSTEM ='ECS';
begin
for Temp in cur loop
update T_UUMS_UPG_USER_DEPT_SYSROLE set USER_DEPT_ROLECODE='ECS'||USER_DEPT_ROLECODE where USER_DEPT_ID=Temp.USER_DEPT_ID;
end loop;
commit;
end;