Delete Adhoc Role

PL/SQL Script to Inactive and Delete Adhoc Role

by Shailender Thallam
June 24, 2016June 24, 2016

DECLARE lc_role_name apps.wf_roles.name%TYPE := ‘XX_TEST_ROLE’; BEGIN wf_directory.setadhocroleexpiration(lc_role_name, sysdate -1 ); COMMIT; wf_directory.setadhocrolestatus( lc_role_name, ‘INACTIVE’); COMMIT; wf_directory.deleterole(lc_role_name , ‘WF_LOCAL_ROLES’ , 0); COMMIT; END; /DECLARE lc_role_name apps.wf_roles.name%type… Read More »PL/SQL Script to Inactive and Delete Adhoc Role