DBA Data[Home] [Help]

APPS.PER_PMP_MASS_NOTIFICATION dependencies on WF_NOTIFICATIONS

Line 292: item_key wf_notifications.item_key%TYPE;

288: PROCEDURE notify(p_plan_id IN NUMBER
289: ,p_effective_date IN DATE
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;

Line 293: --item_type wf_notifications.item_type%type default 'HRWPM';

289: ,p_effective_date IN DATE
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);