FND_PROFILE.save
Hello All
I'm am trying to update all RESP to have a null/blank value using this:
DECLARE
l_success BOOLEAN;
BEGIN
DBMS_OUTPUT.ENABLE (buffer_size => NULL);
FOR i IN
(SELECT RESPONSIBILITY_ID from FND_RESPONSIBILITY)
LOOP
l_success := FND_PROFILE.save
(x_name => 'ICX_SESSION_TIMEOUT',
x_value => '',
x_level_name => 'RESP',
x_level_value => i.responsibility_id,
x_level_value_app_id => NULL
);
IF l_success
THEN
commit;
DBMS_OUTPUT.put_line('---');
DBMS_OUTPUT.put_line(i.responsibility_id||' ' ||'Profile Updated successfully ');
DBMS_OUTPUT.put_line('---');
ELSE
DBMS_OUTPUT.put_line('---');