1 PACKAGE BODY PA_CLIENT_EXTN_CAND_WF AS
2 -- $Header: PARCWFCB.pls 120.1 2005/08/19 16:49:55 mwasowic noship $
3
4 -- DO NOT ADD OR MODIFY THE PARAMETERS OF ANY OF THE PROCEDURES IN THIS
5 -- PACKAGE. YOU CAN CODE YOUR OWN LOGIC IN ANY OF THE PROCEDURES.
6
7 PROCEDURE Generate_NF_Recipients
8 (p_project_id IN NUMBER
9 ,p_assignment_id IN NUMBER
10 ,p_candidate_number IN NUMBER
11 ,p_notification_type IN VARCHAR2
12 ,p_in_list_of_recipients IN Users_List_tbltyp
13 ,x_out_list_of_recipients OUT NOCOPY Users_List_tbltyp /* Added NOCOPY for bug#2674619 */
14 ,x_number_of_recipients OUT NOCOPY NUMBER ) IS --File.Sql.39 bug 4440895
15 BEGIN
16 -- This procedure , by default, returns the input recipients
17 -- as output. You could customize this code to add or modify
18 -- more recipients, as necessary. You must ensure that both
19 -- x_out_list_of_recipients and x_number_of_recipients are properly
20 -- populated. The calling apis used by Oracle Projects and Oracle
21 -- Project Resource Management would use the output values.
22 -- You can use the p_notification_type parameter to distinguish
23 -- between different types of notifications
24 -- valid values in p_notification_type are 'PENDING_REVIEW_FYI'
25 -- and 'DECLINED_FYI'
26 x_out_list_of_recipients := p_in_list_of_recipients;
27
28 IF p_in_list_of_recipients.EXISTS(1) THEN
29 x_number_of_recipients := p_in_list_of_recipients.COUNT;
30 ELSE
31 x_number_of_recipients := 0;
32 END IF;
33 END Generate_NF_Recipients;
34
35 END PA_CLIENT_EXTN_CAND_WF ;