Change end_date in fnd_user.updateuser [message #536120] |
Mon, 19 December 2011 05:18 |
aadebayo
Messages: 38 Registered: August 2005
|
Member |
|
|
I am currently trying to extend the end_date of all the external users of my application. I have created a procedure to update the end_date of evry user selected in a cursor. When I run the plsql procedure, the end_date is not updated. Please can anyone help? The procedure is below
procedure
as
CURSOR usercur
IS
SELECT fu.user_name, fu.start_date
FROM apps.fnd_user fu
WHERE user_name like '%EXT';
DECLARE ld_end_date DATE;
BEGIN
ld_end_date = SYSDATE + 10000;
FOR myuser IN usercur
dbms_output.put_line('current user is = ' || myuser.user_name|| 'Start date is = ' || myuser.start_date);
LOOP
fnd_user_pkg.updateuser(
x_user_name => myuser.user_name
,x_owner => 'CUST'
,x_end_date => ld_end_date
);
dbms_output.put_line('current user is = ' || myuser.user_name|| 'Start date is = ' || myuser.start_date);
END LOOP;
END;
|
|
|
|
|
|
|