947: ;
948:
949: --Bug 14326815 start.
950: CURSOR role_info is
951: select name,expiration_date from wf_local_roles where name = l_approval_role;
952:
953: l_name wf_local_roles.name%type;
954: l_exp_date wf_local_roles.expiration_date%type;
955: -- Bug 14326815 end.
949: --Bug 14326815 start.
950: CURSOR role_info is
951: select name,expiration_date from wf_local_roles where name = l_approval_role;
952:
953: l_name wf_local_roles.name%type;
954: l_exp_date wf_local_roles.expiration_date%type;
955: -- Bug 14326815 end.
956: display_name VARCHAR2(2000);
957: email_address VARCHAR2(2000);
950: CURSOR role_info is
951: select name,expiration_date from wf_local_roles where name = l_approval_role;
952:
953: l_name wf_local_roles.name%type;
954: l_exp_date wf_local_roles.expiration_date%type;
955: -- Bug 14326815 end.
956: display_name VARCHAR2(2000);
957: email_address VARCHAR2(2000);
958: notification_preference VARCHAR2(2000);