ebs asserter profile options

asserterprofileupdate.sql

Declare
value Boolean;
val varchar2(500);
pnm varchar2(500);
prev_val varchar2(500);
post_val varchar2(500);
Begin
select profile_option_name into pnm from fnd_profile_options_tl where USER_PROFILE_OPTION_NAME='Application Authenticate Agent';
DBMS_OUTPUT.PUT_LINE('Profile name to be updated: '  || pnm);
select fnd_profile.value(pnm) into prev_val from dual;
DBMS_OUTPUT.PUT_LINE('Value before update: ' || prev_val);
select 'http://ebsasserter.omcs.tech:30018/ebs' into val from dual;
DBMS_OUTPUT.PUT_LINE('Value to update: ' || val);
value := fnd_profile.save(pnm,val,'SITE');
select fnd_profile.value(pnm) into post_val from dual;
DBMS_OUTPUT.PUT_LINE('Value after update: ' || post_val);
End;
/
commit;


Declare
value Boolean;
val varchar2(500);
pnm varchar2(500);
prev_val varchar2(500);
post_val varchar2(500);
Begin
select profile_option_name into pnm from fnd_profile_options_tl where USER_PROFILE_OPTION_NAME='Applications SSO Type';
DBMS_OUTPUT.PUT_LINE('Profile name to be updated: '  || pnm);
select fnd_profile.value(pnm) into prev_val from dual;
DBMS_OUTPUT.PUT_LINE('Value before update: ' || prev_val);
select 'SSWA_SSO' into val from dual;
DBMS_OUTPUT.PUT_LINE('Value to update: ' || val);
value := fnd_profile.save(pnm,val,'SITE');
select fnd_profile.value(pnm) into post_val from dual;
DBMS_OUTPUT.PUT_LINE('Value after update: ' || post_val);
End;
/
commit;


Declare
value Boolean;
val varchar2(500);
pnm varchar2(500);
prev_val varchar2(500);
post_val varchar2(500);
Begin
select profile_option_name into pnm from fnd_profile_options_tl where USER_PROFILE_OPTION_NAME='Oracle Applications Session Cookie Domain';
DBMS_OUTPUT.PUT_LINE('Profile name to be updated: '  || pnm);
select fnd_profile.value(pnm) into prev_val from dual;
DBMS_OUTPUT.PUT_LINE('Value before update: ' || prev_val);
select 'DOMAIN' into val from dual;
DBMS_OUTPUT.PUT_LINE('Value to update: ' || val);
value := fnd_profile.save(pnm,val,'SITE');
select fnd_profile.value(pnm) into post_val from dual;
DBMS_OUTPUT.PUT_LINE('Value after update: ' || post_val);
End;
/
commit;