1 PACKAGE PA_CLIENT_EXTN_ASGMT_WF AUTHID CURRENT_USER AS
2 -- $Header: PARAWFCS.pls 120.6 2006/07/26 10:49:03 dthakker noship $
3 /*#
4 * This client extension enables you to customize assignment approval workflow processes for generating
5 * assignment approvers and notification recipients.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Assignment Approval Notification Extension
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJ_RESOURCE
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14
15 TYPE Users_List_Rectyp IS RECORD
16 (User_Name VARCHAR2(100) , /* Modified length of user_name to 100 from 30 for bug 3148857 */
17 Person_id NUMBER,
18 Type VARCHAR2(30),
19 Routing_Order NUMBER );
20
21 TYPE Users_List_Tbltyp IS TABLE OF Users_List_Rectyp
22 INDEX BY BINARY_INTEGER;
23
24
25
26 /*#
27 * This procedure is used to generate a list of approvers for the assignment. Oracle Project sends the list
28 * of default approvers to this procedure. The procedure makes the changes requested by user, and provides a
29 * modified list of approvers.
30 * @param p_assignment_id The unique identifier of the assignment
31 * @rep:paraminfo {@rep:required}
32 * @param p_project_id The unique identifier of the project
33 * @rep:paraminfo {@rep:required}
34 * @param p_in_list_of_approvers Input list of notification recipients
35 * @rep:paraminfo {@rep:required}
36 * @param x_out_list_of_approvers Output list of notification recipients
37 * @rep:paraminfo {@rep:required}
38 * @param x_number_of_approvers Number of recipients
39 * @rep:paraminfo {@rep:required}
40 * @rep:scope public
41 * @rep:lifecycle active
42 * @rep:displayname Generate Assignment Approvers
43 * @rep:compatibility S
44 */
45 PROCEDURE Generate_Assignment_Approvers
46 (p_assignment_id IN NUMBER
47 ,p_project_id IN NUMBER
48 ,p_in_list_of_approvers IN Users_List_tbltyp
49 ,x_out_list_of_approvers OUT NOCOPY Users_List_tbltyp -- For 1159 mandate changes bug#2674619
50 ,x_number_of_approvers OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
51
52 /*#
53 * This procedure is used to generate a list of recipients for notifications. Oracle Projects sends the list
54 * of default approvers to this procedure. The procedure makes the changes requested by user, and provides a
55 * modified list of recipients.
56 * @param p_assignment_id The unique identifier of the assignment
57 * @rep:paraminfo {@rep:required}
58 * @param p_project_id The unique identifier of the project
59 * @rep:paraminfo {@rep:required}
60 * @param p_notification_type Type of notification
61 * @rep:paraminfo {@rep:required}
62 * @param p_in_list_of_recipients Input list of notification recipients
63 * @rep:paraminfo {@rep:required}
64 * @param x_out_list_of_recipients Output list of notification recipient
65 * @rep:paraminfo {@rep:required}
66 * @param x_number_of_recipients Number of recipients
67 * @rep:paraminfo {@rep:required}
68 * @rep:scope public
69 * @rep:lifecycle active
70 * @rep:displayname Generate Notification Recipients
71 * @rep:compatibility S
72 */
73 PROCEDURE Generate_NF_Recipients
74 ( p_assignment_id IN NUMBER
75 ,p_project_id IN NUMBER
76 ,p_notification_type IN VARCHAR2
77 ,p_in_list_of_recipients IN Users_List_tbltyp
78 ,x_out_list_of_recipients OUT NOCOPY Users_List_tbltyp -- For 1159 mandate changes bug#2674619
79 ,x_number_of_recipients OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
80
81 /*#
82 * This procedure is used to set reminder parameters, such as the waiting period between reminders and the number
83 * of reminders that are issued before the workflow process is canceled.
84 * @param p_assignment_id The unique identifier of the assignment
85 * @rep:paraminfo {@rep:required}
86 * @param p_project_id The unique identifier of the project
87 * @rep:paraminfo {@rep:required}
88 * @param x_waiting_time The maximum amount of time to wait before sending a reminder
89 * @rep:paraminfo {@rep:required}
90 * @param x_number_of_reminders The maximum number of reminders to send before aborting the process
91 * @rep:paraminfo {@rep:required}
92 * @rep:scope public
93 * @rep:lifecycle active
94 * @rep:displayname Set Timeout and Reminders
95 * @rep:compatibility S
96 */
97 PROCEDURE Set_Timeout_And_Reminders
98 ( p_assignment_id IN NUMBER
99 ,p_project_id IN NUMBER
100 ,x_waiting_time OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
101 ,x_number_of_reminders OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
102
103 END PA_CLIENT_EXTN_ASGMT_WF ;