DBA Data[Home] [Help]

APPS.PER_PMP_MASS_NOTIFICATION dependencies on WF_LOCAL_ROLES

Line 294: l_administrator_role wf_local_roles.name%TYPE;

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)

Line 296: to_role wf_local_roles.name%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