DBA Data[Home] [Help]

APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on WF_LOCAL_ROLES

Line 951: select name,expiration_date from wf_local_roles where name = l_approval_role;

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.

Line 953: l_name wf_local_roles.name%type;

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);

Line 954: l_exp_date wf_local_roles.expiration_date%type;

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);