290: ,p_message_subject IN VARCHAR2
291: ,p_message_body IN VARCHAR2) IS
292: item_key wf_notifications.item_key%TYPE;
293: --item_type wf_notifications.item_type%type default 'HRWPM';
294: l_administrator_role wf_local_roles.name%TYPE;
295: l_admin_person_id per_perf_mgmt_plans.ADMINISTRATOR_PERSON_ID%TYPE;
296: to_role wf_local_roles.name%TYPE;
297: l_message_body VARCHAR2(4000);
298: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)
292: item_key wf_notifications.item_key%TYPE;
293: --item_type wf_notifications.item_type%type default 'HRWPM';
294: l_administrator_role wf_local_roles.name%TYPE;
295: l_admin_person_id per_perf_mgmt_plans.ADMINISTRATOR_PERSON_ID%TYPE;
296: to_role wf_local_roles.name%TYPE;
297: l_message_body VARCHAR2(4000);
298: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)
299: is
300: select name from wf_roles