1 PACKAGE PA_CLIENT_EXTN_CAND_WF AS
2 -- $Header: PARCWFCS.pls 120.4 2006/07/21 11:24:02 dthakker noship $
3 /*#
4 * This client extension enables you to customize candidate workflow processes.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Candidate Approval Notification Extension
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJ_RESOURCE
11 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
12 */
13
14 TYPE Users_List_Rectyp IS RECORD
15 (User_Name VARCHAR2(320) , /* Modified VARCHAR2(30) for bug 3158966 */
16 Person_id NUMBER,
17 Type VARCHAR2(30),
18 Routing_Order NUMBER);
19
20 TYPE Users_List_Tbltyp IS TABLE OF Users_List_Rectyp
21 INDEX BY BINARY_INTEGER;
22
23 /*#
24 * This procedure is used to generate a list of recipients for notifications. Oracle Project sends the list
25 * of default approvers to this procedure. The procedure makes user-requested changes and provides a
26 * modified list.
27 * @param p_project_id The unique identifier of the project
28 * @rep:paraminfo {@rep:required}
29 * @param p_assignment_id The unique identifier of the assignment
30 * @rep:paraminfo {@rep:required}
31 * @param p_candidate_number The unique identifier of the candidate
32 * @rep:paraminfo {@rep:required}
33 * @param p_notification_type Type of notification
34 * @rep:paraminfo {@rep:required}
35 * @param p_in_list_of_recipients Input list of notification recipients
36 * @rep:paraminfo {@rep:required}
37 * @param x_out_list_of_recipients Output list of notification recipients
38 * @rep:paraminfo {@rep:required}
39 * @param x_number_of_recipients Number of recipients
40 * @rep:paraminfo {@rep:required}
41 * @rep:scope public
42 * @rep:lifecycle active
43 * @rep:displayname Generate Notification Recipients
44 * @rep:compatibility S
45 */
46 PROCEDURE Generate_NF_Recipients
47 (p_project_id IN NUMBER
48 ,p_assignment_id IN NUMBER
49 ,p_candidate_number IN NUMBER
50 ,p_notification_type IN VARCHAR2
51 ,p_in_list_of_recipients IN Users_List_tbltyp
52 ,x_out_list_of_recipients OUT NOCOPY Users_List_tbltyp /* Added NOCOPY for bug#2674619 */
53 ,x_number_of_recipients OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
54
55 END PA_CLIENT_EXTN_CAND_WF;