DBA Data[Home] [Help]

PACKAGE: APPS.PA_CLIENT_EXTN_ASGMT_WF

Source


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 ;