PL/SQL

PL/SQL Script to Inactive and Delete Adhoc Role

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

Usage of PL/SQL Collections

/********************************************************* *PURPOSE: Sample Usage of PL/SQL Collections * *AUTHOR: Shailender Thallam * **********************************************************/ SET serveroutput ON; DECLARE ——————– –Record type object ——————– TYPE emp_type IS… Read More »Usage of PL/SQL Collections