1 package pa_control_items_wf_client AUTHID CURRENT_USER as
2 /* $Header: PACIWFCS.pls 120.4.12020000.2 2012/07/19 09:31:58 admarath ship $ */
3 /*#
4 *This extension enables you to customize the workflow processes for
5 * submitting and approving issues and change documents.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Issue and Change Workflow Extension
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14
15
16 /*============================================================================+
17 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
18 | All rights reserved. |
19 | Oracle Manufacturing |
20 +=============================================================================+
21
22 FILE NAME : PACIWFCS.pls
23 DESCRIPTION :
24 This file provided client extension procedures that are called
25 to execute each activity in the Issue and Change Document Workflow.
26
27 PROCEDURES AND PARAMETERS
28
29 start_workflow
30
31 p_item_type : The workflow item type.
32 p_process_name : Name of the workflow process.
33 p_item_key : The workflow item key.
34 p_ci_id : Control Item Identifier.
35 x_msg_count : The number of messages being sent.
36 x_msg_data : The content of the message.
37 x_return_status : The return status of the message.
38
39
40 set_ci_approver
41
42 p_item_type : The workflow item type.
43 p_item_key : The workflow item key.
44 actid : Identifier of the action.
45 funcmode : Workflow function mode.
46 resultout : Process result.
47
48 set_notification_party
49
50 p_item_type : The workflow item type.
51 p_item_key : The workflow item key.
52 p_status : The control item status.
53 actid : Identifier of the action.
54 funcmode : Workflow function mode.
55 resultout : Process result.
56
57
58 HISTORY : 06/22/00 SYAO Initial Creation
59 04/22/04 mchava Interface Reporsitory Annotation Standards
60 are incorporated.
61 02-JUN-2006 vgottimu Changed the doccd file name from 115pjoug.pdf to 120pjapi.pdf.
62 03-JUL-2006 vgottimu Bug#5367820 Changed the description of APIs and paramenter
63 description as suggested by the Doc Team for IRep.
64 21-Mar-2012 svmohamm Bug#13683760 Added changes for approval process modification.
65 =============================================================================*/
66
67
68
69 /*#
70 * This procedure is used to start the workflow process for issue and change document approval.
71 * @param p_item_type The workflow item type
72 * @rep:paraminfo {@rep:required}
73 * @param p_process_name Name of the workflow process
74 * @rep:paraminfo {@rep:required}
75 * @param p_item_key The workflow item key
76 * @rep:paraminfo {@rep:required}
77 * @param p_ci_id The identifier of the control item
78 * @rep:paraminfo {@rep:required}
79 * @param x_msg_count API standard: number of error messages
80 * @rep:paraminfo {@rep:required}
81 * @param x_msg_data API standard: error message
82 * @rep:paraminfo {@rep:required}
83 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
84 * @rep:paraminfo {@rep:required}
85 * @rep:scope public
86 * @rep:lifecycle active
87 * @rep:displayname Start Workflow
88 * @rep:compatibility S
89 */
90
91 Procedure start_workflow (
92 p_item_type IN VARCHAR2
93 , p_process_name IN VARCHAR2
94 , p_item_key IN NUMBER
95
96 , p_ci_id IN NUMBER
97
98 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
99 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
100 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
101 );
102
103 /*#
104 * This procedure is used to specify persons who can approve issues and change documents.
105 * @param p_item_type The workflow item type
106 * @rep:paraminfo {@rep:required}
107 * @param p_item_key The workflow item key
108 * @rep:paraminfo {@rep:required}
109 * @param actid The identifier of the action
110 * @rep:paraminfo {@rep:required}
111 * @param funcmode The workflow function mode
112 * @rep:paraminfo {@rep:required}
113 * @param resultout The process result
114 * @rep:paraminfo {@rep:required}
115 * @rep:scope public
116 * @rep:lifecycle active
117 * @rep:displayname Set Control Item Approver
118 * @rep:compatibility S
119 */
120
121 PROCEDURE set_ci_approver(
122 p_item_type IN VARCHAR2
123 ,p_item_key IN VARCHAR2
124 ,actid IN NUMBER
125 ,funcmode IN VARCHAR2
126 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
127
128
129 /*#
130 * This procedure is used to specify persons who would be notified about approved and rejected issues and change documents.
131 * @param p_item_type The workflow item type
132 * @rep:paraminfo {@rep:required}
133 * @param p_item_key The workflow item key
134 * @rep:paraminfo {@rep:required}
135 * @param p_status The control item status
136 * @rep:paraminfo {@rep:required}
137 * @param actid The identifier of the action
138 * @rep:paraminfo {@rep:required}
139 * @param funcmode The workflow function mode
140 * @rep:paraminfo {@rep:required}
141 * @param resultout The process result
142 * @rep:paraminfo {@rep:required}
143 * @rep:scope public
144 * @rep:lifecycle active
145 * @rep:displayname Set Notification Party
146 * @rep:compatibility S
147 */
148 PROCEDURE set_notification_party(
149 p_item_type IN VARCHAR2
150 ,p_item_key IN VARCHAR2
151 ,p_status IN VARCHAR2
152 ,actid IN NUMBER
153 ,funcmode IN VARCHAR2
154 ,resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
155 ) ;
156
157 -- Bug#13683760
158 PROCEDURE set_submitted_by(
159 p_item_type IN VARCHAR2
160 ,p_item_key IN VARCHAR2
161 ,actid IN NUMBER
162 ,funcmode IN VARCHAR2
163 ,resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
164 ) ;
165
166 END pa_control_items_wf_client;
167