Creating Adhoc Workflow Role

Here is an script to creating Workflow Adhoc Role:

——————————————————————————————————–

DECLARE

 

l_sshrcorp_email  VARCHAR2(100);

l_role_name       VARCHAR2(100);

l_sshrcorp_list   VARCHAR2(240);

 

BEGIN

 

  l_sshrcorp_email := ’email@company.com’;

  l_sshrcorp_list  := ‘HRADMIN’;

  l_role_name := ‘SSHRCORPIT’ ;

 

      WF_DIRECTORY.CreateAdHocRole(l_role_name,

                                   l_role_name,

                                   null,

                                   null,

                                   null,

                                   ‘MAILHTML’, 

                                   l_sshrcorp_list,

                                   l_sshrcorp_email,

                                   null,

                                   ‘ACTIVE’,

                                   sysdate+1825); —–> will be valid for 5 years

 

END;

——————————————————————————————————–

 

Thansks,

Senthil