1 PACKAGE FPA_MAIN_PROCESS_PVT AUTHID CURRENT_USER AS
2 /* $Header: FPAXWFMS.pls 120.2 2011/08/03 22:16:28 skkoppul ship $ */
3
4
5
6 -------------------------------------------------------------
7 --Start of Comments
8 --Name : INITIATE_WORKFLOW
9 --
10 --Pre-reqs : IN parameters need to be passed in with valid values
11 --
12 --Modifies : None
13 --
14 --Locks : None
15 --
16 --Function : This procedure sets up all necessary workflow
17 -- attributes needed before starting the workflow
18 -- process.
19 --
20 --Parameter(s):
21 --
22 --IN : p_pc_name IN VARCHAR2,
23 -- p_pc_id IN NUMBER,
24 -- p_pc_description IN VARCHAR2,
25 -- p_pc_date_initiated IN DATE,
26 -- p_due_date IN DATE,
27 -- x_return_status OUT NOCOPY VARCHAR2,
28 -- x_msg_count OUT NOCOPY NUMBER,
29 -- x_msg_data OUT NOCOPY VARCHAR2
30 --
31 --IN OUT: : None
32 --
33 --OUT : None
34 --
35 --Returns : None
36 --
37 --Notes : None
38 --
39 --Testing : None
40 --
41 --End of Comments
42 -------------------------------------------------------------
43 PROCEDURE INITIATE_WORKFLOW(p_pc_name IN VARCHAR2,
44 p_pc_id IN NUMBER,
45 p_last_pc_id IN NUMBER,
46 p_pc_description IN VARCHAR2,
47 p_pc_date_initiated IN DATE,
48 p_due_date IN DATE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 -- Cancels the main workflow process and starts an alternate process
55 PROCEDURE CANCEL_WORKFLOW(p_pc_name IN VARCHAR2,
56 p_pc_id IN NUMBER,
57 p_pc_description IN VARCHAR2,
58 p_pc_date_initiated IN DATE,
59 p_due_date IN DATE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 -- Launch the main workflow process
66 PROCEDURE LAUNCH_PROCESS(p_itemtype IN VARCHAR2,
67 p_itemkey IN VARCHAR2,
68 p_actid IN NUMBER,
69 p_funcmode IN VARCHAR2,
70 x_resultout OUT NOCOPY VARCHAR2);
71
72 -- Aborts existing workflow processes and raises Event when Planning cycle is CLOSED
73 PROCEDURE RAISE_CLOSEPC_EVENT(p_pc_id IN NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 /* Workflow get methods */
80 /* Get distribution list */
81 -- gets all project analyst email addresses from the distribution list
82 PROCEDURE GET_DLIST(p_itemtype IN VARCHAR2,
83 p_itemkey IN VARCHAR2,
84 p_actid IN NUMBER,
85 p_funcmode IN VARCHAR2,
86 x_resultout OUT NOCOPY VARCHAR2);
87
88 /* Get access list */
89 -- gets all approvers or related persons email addresses from the access list
90 PROCEDURE GET_ALIST(p_itemtype IN VARCHAR2,
91 p_itemkey IN VARCHAR2,
92 p_actid IN NUMBER,
93 p_funcmode IN VARCHAR2,
94 x_resultout OUT NOCOPY VARCHAR2);
95
96 /* Get list of portfolio approvers*/
97 PROCEDURE GET_APPROVER(p_itemtype IN VARCHAR2,
98 p_itemkey IN VARCHAR2,
99 p_actid IN NUMBER,
100 p_funcmode IN VARCHAR2,
101 x_resultout OUT NOCOPY VARCHAR2);
102
103 /* Get list of portfolio analysts*/
104 PROCEDURE GET_ANALYST (p_itemtype IN VARCHAR2,
105 p_itemkey IN VARCHAR2,
106 p_actid IN NUMBER,
107 p_funcmode IN VARCHAR2,
108 x_resultout OUT NOCOPY VARCHAR2);
109
110 /* Get list of planning cycle managers*/
111 PROCEDURE GET_PC_MANAGERS (p_itemtype IN VARCHAR2,
112 p_itemkey IN VARCHAR2,
113 p_actid IN NUMBER,
114 p_funcmode IN VARCHAR2,
115 x_resultout OUT NOCOPY VARCHAR2);
116
117 /* Wrapper calls */
118 /* Project load */
119 -- calls Project Load api
120 PROCEDURE CALL_PROJ_LOAD(p_itemtype IN VARCHAR2,
121 p_itemkey IN VARCHAR2,
122 p_actid IN NUMBER,
123 p_funcmode IN VARCHAR2,
124 x_resultout OUT NOCOPY VARCHAR2);
125
126 /* Create Initial Scenario */
127 -- calls Create Initial Scenario api
128 PROCEDURE CALL_CREATE_INITIAL_SCENARIO(p_itemtype IN VARCHAR2,
129 p_itemkey IN VARCHAR2,
130 p_actid IN NUMBER,
131 p_funcmode IN VARCHAR2,
132 x_resultout OUT NOCOPY VARCHAR2);
133
134 /* Set Status */
135 -- sets the status of Planning Cycle or Scenario
136 PROCEDURE CALL_SET_STATUS(p_itemtype IN VARCHAR2,
137 p_itemkey IN VARCHAR2,
138 p_actid IN NUMBER,
139 p_funcmode IN VARCHAR2,
140 x_resultout OUT NOCOPY VARCHAR2);
141
142 /* Call Project Sets */
143 -- calls the Project Sets API
144 PROCEDURE CALL_PROJECT_SETS(p_itemtype IN VARCHAR2,
145 p_itemkey IN VARCHAR2,
146 p_actid IN NUMBER,
147 p_funcmode IN VARCHAR2,
148 x_resultout OUT NOCOPY VARCHAR2);
149
150 /* Is Plan Approved */
151 -- Checks if the Plan is approved
152 PROCEDURE IS_PLAN_APPROVED(p_itemtype IN VARCHAR2,
153 p_itemkey IN VARCHAR2,
154 p_actid IN NUMBER,
155 p_funcmode IN VARCHAR2,
156 x_resultout OUT NOCOPY VARCHAR2);
157
158 -- Sets the Planning Cycle Status to ANALYSIS
159 PROCEDURE SET_STATUS_ANALYSIS(p_itemtype IN VARCHAR2,
160 p_itemkey IN VARCHAR2,
161 p_actid IN NUMBER,
162 p_funcmode IN VARCHAR2,
163 x_resultout OUT NOCOPY VARCHAR2);
164
165 -- Sets the Planning Cycle Status to APPROVED
166 PROCEDURE SET_STATUS_APPROVED(p_itemtype IN VARCHAR2,
167 p_itemkey IN VARCHAR2,
168 p_actid IN NUMBER,
169 p_funcmode IN VARCHAR2,
170 x_resultout OUT NOCOPY VARCHAR2);
171
172 -- Sets the Planning Cycle Status to CLOSED
173 PROCEDURE SET_STATUS_CLOSED(p_itemtype IN VARCHAR2,
174 p_itemkey IN VARCHAR2,
175 p_actid IN NUMBER,
176 p_funcmode IN VARCHAR2,
177 x_resultout OUT NOCOPY VARCHAR2);
178
179 -- Sets the Planning Cycle Status to COLLECTING
180 PROCEDURE SET_STATUS_COLLECTING(p_itemtype IN VARCHAR2,
181 p_itemkey IN VARCHAR2,
182 p_actid IN NUMBER,
183 p_funcmode IN VARCHAR2,
184 x_resultout OUT NOCOPY VARCHAR2);
185
186 -- Sets the Planning Cycle Status to SUBMITTED
187 PROCEDURE SET_STATUS_SUBMITTED(p_itemtype IN VARCHAR2,
188 p_itemkey IN VARCHAR2,
189 p_actid IN NUMBER,
190 p_funcmode IN VARCHAR2,
191 x_resultout OUT NOCOPY VARCHAR2);
192
193 /* Workflow business events */
194 /* User force action */
195 -- pings the User Action business event
196 PROCEDURE FORCE_USER_ACTION(p_itemkey IN VARCHAR2,
197 p_event_name IN VARCHAR2,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2);
201
202 /* Workflow business events */
203 /* Submit plan */
204 -- pings the Submit Plan business event
205 PROCEDURE SUBMIT_PLAN(p_itemkey IN VARCHAR2,
206 p_event_name IN VARCHAR2,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2);
210
211 /* Workflow business events */
212 /* Approve or Reject a plan */
213 -- pings the Approve Reject Plan business event
214 PROCEDURE APPROVE_REJECT_PLAN(p_itemkey IN VARCHAR2,
215 p_event_name IN VARCHAR2,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2);
219
220 --Procedure to copy Projects from last planning cycle of current portfolio
221
222 PROCEDURE COPY_PROJ_FROM_PREV_PC(p_itemtype IN VARCHAR2,
223 p_itemkey IN VARCHAR2,
224 p_actid IN NUMBER,
225 p_funcmode IN VARCHAR2,
226 x_resultout OUT NOCOPY VARCHAR2);
227
228 --Procedure to attach AW for workflow
229
230 PROCEDURE WF_ATTACH_AW (p_itemtype IN VARCHAR2,
231 p_itemkey IN VARCHAR2,
232 p_actid IN NUMBER,
233 p_funcmode IN VARCHAR2,
234 x_resultout OUT NOCOPY VARCHAR2);
235
236 --Procedure to detach AW for workflow
237
238 PROCEDURE WF_DETACH_AW (p_itemtype IN VARCHAR2,
239 p_itemkey IN VARCHAR2,
240 p_actid IN NUMBER,
241 p_funcmode IN VARCHAR2,
242 x_resultout OUT NOCOPY VARCHAR2);
243
244 END FPA_MAIN_PROCESS_PVT;