DBA Data[Home] [Help]

PACKAGE BODY: APPS.PA_CLIENT_EXTN_CAND_WF

Source


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 ;