1 PACKAGE per_pmp_mass_notification AUTHID CURRENT_USER AS
2 /* $Header: pepmpmas.pkh 120.0.12010000.2 2008/11/09 13:43:49 kgowripe noship $ */
3 -- Declare Global variables
4 TYPE r_user IS RECORD (person_id NUMBER(15),
5 user_name fnd_user.user_name%TYPE,
6 user_display_name per_all_people_f.full_name%TYPE);
7 TYPE t_userdtls IS TABLE OF r_user index by BINARY_INTEGER;
8 ----
9 PROCEDURE mass_notify(errbuf out nocopy varchar2
10 ,retcode out nocopy number
11 ,p_plan_id IN NUMBER
12 ,p_effective_date IN Varchar2
13 ,p_message_subject IN VARCHAR2
14 ,p_message_body IN VARCHAR2
15 ,p_target_population IN VARCHAR2 default NULL
16 ,p_target_person_id IN NUMBER DEFAULT NULL
17 ,p_person_selection_rule IN NUMBER DEFAULT NULL);
18 --
19 END per_pmp_mass_notification;