1 PACKAGE OKC_REP_WF_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVREPWFS.pls 120.2.12020000.4 2013/03/14 16:24:52 kkolukul ship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 -- Start of comments
9 --API name : initialize_attributes
10 --Type : Private.
11 --Function : This procedure is called by workflow to initialize workflow attributes.
12 --Pre-reqs : None.
13 --Parameters :
14 --IN : itemtype IN VARCHAR2 Required
15 -- Workflow item type parameter
16 -- : itemkey IN VARCHAR2 Required
17 -- Workflow item key parameter
18 -- : actid IN VARCHAR2 Required
19 -- Workflow actid parameter
20 -- : funcmode IN VARCHAR2 Required
21 -- Workflow function mode parameter
22 --OUT : resultout OUT VARCHAR2(1)
23 -- Workflow standard out parameter
24 -- Note :
25 -- End of comments
26 PROCEDURE initialize_attributes(
27 itemtype in varchar2,
28 itemkey in varchar2,
29 actid in number,
30 funcmode in varchar2,
31 resultout out nocopy varchar2
32 );
33
34 -- Start of comments
35 --API name : has_next_approver
36 --Type : Private.
37 --Function : This procedure is called by workflow to get the next approver in the list.
38 --Pre-reqs : None.
39 --Parameters :
40 --IN : itemtype IN VARCHAR2 Required
41 -- Workflow item type parameter
42 -- : itemkey IN VARCHAR2 Required
43 -- Workflow item key parameter
44 -- : actid IN VARCHAR2 Required
45 -- Workflow actid parameter
46 -- : funcmode IN VARCHAR2 Required
47 -- Workflow function mode parameter
48 --OUT : resultout OUT VARCHAR2(1)
49 -- Workflow standard out parameter
50 -- Note :
51 -- End of comments
52 PROCEDURE has_next_approver(
53 itemtype in varchar2,
54 itemkey in varchar2,
55 actid in number,
56 funcmode in varchar2,
57 resultout out nocopy varchar2
58 );
59
60 -- Start of comments
61 --API name : approve_contract
62 --Type : Private.
63 --Function : This procedure is called by workflow after the contract is approved. Updates Contract's status
64 -- to approved and logs the status change in OKC_REP_CON_STATUS_HIST table.
65 --Pre-reqs : None.
66 --Parameters :
67 --IN : itemtype IN VARCHAR2 Required
68 -- Workflow item type parameter
69 -- : itemkey IN VARCHAR2 Required
70 -- Workflow item key parameter
71 -- : actid IN VARCHAR2 Required
72 -- Workflow actid parameter
73 -- : funcmode IN VARCHAR2 Required
74 -- Workflow function mode parameter
75 --OUT : resultout OUT VARCHAR2(1)
76 -- Workflow standard out parameter
77 -- Note :
78 -- End of comments
79 PROCEDURE approve_contract(
80 itemtype in varchar2,
81 itemkey in varchar2,
82 actid in number,
83 funcmode in varchar2,
84 resultout out nocopy varchar2
85 );
86
87
88 -- Start of comments
89 --API name : reject_contract
90 --Type : Private.
91 --Function : This procedure is called by workflow after the contract is rejected. Updates Contract's status
92 -- to rejected and logs the status change in OKC_REP_CON_STATUS_HIST table.
93 --Pre-reqs : None.
94 --Parameters :
95 --IN : itemtype IN VARCHAR2 Required
96 -- Workflow item type parameter
97 -- : itemkey IN VARCHAR2 Required
98 -- Workflow item key parameter
99 -- : actid IN VARCHAR2 Required
100 -- Workflow actid parameter
101 -- : funcmode IN VARCHAR2 Required
102 -- Workflow function mode parameter
103 --OUT : resultout OUT VARCHAR2(1)
104 -- Workflow standard out parameter
105 -- Note :
106 -- End of comments
107 PROCEDURE reject_contract(
108 itemtype in varchar2,
109 itemkey in varchar2,
110 actid in number,
111 funcmode in varchar2,
112 resultout out nocopy varchar2
113 );
114
115 -- Start of comments
116 --API name : update_ame_status
117 --Type : Private.
118 --Function : This procedure is called by workflow after each approver's response.
119 -- Updates AME approver's approval status, updates Contract's approval hisotry,
120 -- Calls ame_api2.getNextApprovers1 to check if more approvers exists. Return
121 -- COMPLETE:APPROVED if last approver approved the contract,
122 -- COMPLETE:REJECTED if current approver rejected the contract, COMPLETE: if more
123 -- exist for this contract approvers.
124 --Pre-reqs : None.
125 --Parameters :
126 --IN : itemtype IN VARCHAR2 Required
127 -- Workflow item type parameter
128 -- : itemkey IN VARCHAR2 Required
129 -- Workflow item key parameter
130 -- : actid IN VARCHAR2 Required
131 -- Workflow actid parameter
132 -- : funcmode IN VARCHAR2 Required
133 -- Workflow function mode parameter
134 --OUT : resultout OUT VARCHAR2(1)
135 -- Workflow standard out parameter
136 -- Note :
137 -- End of comments
138 PROCEDURE update_ame_status(
139 itemtype in varchar2,
140 itemkey in varchar2,
141 actid in number,
142 funcmode in varchar2,
143 resultout out nocopy varchar2
144 );
145
146
147 -- Start of comments
148 --API name : is_contract_approved
149 --Type : Private.
150 --Function : This procedure is called by workflow to determine if the contract is approved.
151 --Pre-reqs : None.
152 --Parameters :
153 --IN : itemtype IN VARCHAR2 Required
154 -- Workflow item type parameter
155 -- : itemkey IN VARCHAR2 Required
156 -- Workflow item key parameter
157 -- : actid IN VARCHAR2 Required
158 -- Workflow actid parameter
159 -- : funcmode IN VARCHAR2 Required
160 -- Workflow function mode parameter
161 --OUT : resultout OUT VARCHAR2(1)
162 -- Workflow standard out parameter
163 -- Note :
164 -- End of comments
165 PROCEDURE is_contract_approved(
166 itemtype in varchar2,
167 itemkey in varchar2,
168 actid in number,
169 funcmode in varchar2,
170 resultout out nocopy varchar2
171 );
172
173
174
175 -- Start of comments
176 --API name : is_approval_complete
177 --Type : Private.
178 --Function : This procedure is called by workflow Master Process to check if the approval is complete.
179 -- WF Notification process are started for the approvers pending notification
180 -- Updates workflow with the approver list.
181 --Pre-reqs : None.
182 --Parameters :
183 --IN : itemtype IN VARCHAR2 Required
184 -- Workflow item type parameter
185 -- : itemkey IN VARCHAR2 Required
186 -- Workflow item key parameter
187 -- : actid IN VARCHAR2 Required
188 -- Workflow actid parameter
189 -- : funcmode IN VARCHAR2 Required
190 -- Workflow function mode parameter
191 --OUT : resultout OUT VARCHAR2(1)
192 -- Workflow standard out parameter
193 -- Note :
194 -- End of comments
195 PROCEDURE is_approval_complete(
196 itemtype IN varchar2,
197 itemkey IN varchar2,
198 actid IN number,
199 funcmode IN varchar2,
200 resultout OUT nocopy varchar2
201 );
202
203
204
205
206
207 -- Start of comments
208 --API name : update_ame_status_detailed
209 --Type : Private.
210 --Function : Same as updated_ame_status. This API calls ame_api6.updateApprovalStatus to update the notification
211 -- text as well.
212 --Pre-reqs : None.
213 --Parameters :
214 --IN : itemtype IN VARCHAR2 Required
215 -- Workflow item type parameter
216 -- : itemkey IN VARCHAR2 Required
217 -- Workflow item key parameter
218 -- : actid IN VARCHAR2 Required
219 -- Workflow actid parameter
220 -- : funcmode IN VARCHAR2 Required
221 -- Workflow function mode parameter
222 --OUT : resultout OUT VARCHAR2(1)
223 -- Workflow standard out parameter
224 -- Note :
225 -- End of comments
226 PROCEDURE update_ame_status_detailed(
227 itemtype IN varchar2,
228 itemkey IN varchar2,
229 actid IN number,
230 funcmode IN varchar2,
231 resultout OUT nocopy varchar2
232 );
233
234
235
236 -- Start of comments
237 --API name : is_contract_approved_detailed
238 --Type : Private.
239 --Function : This procedure is called by workflow to determine if the contract is approved. Uses
240 -- the detailed values of ame param approvalProcessCompleteYNOut. Is used in
241 -- Master approval process.
242 --Pre-reqs : None.
243 --Parameters :
244 --IN : itemtype IN VARCHAR2 Required
245 -- Workflow item type parameter
246 -- : itemkey IN VARCHAR2 Required
247 -- Workflow item key parameter
248 -- : actid IN VARCHAR2 Required
249 -- Workflow actid parameter
250 -- : funcmode IN VARCHAR2 Required
251 -- Workflow function mode parameter
252 --OUT : resultout OUT VARCHAR2(1)
253 -- Workflow standard out parameter
254 -- Note :
255 -- End of comments
256 PROCEDURE is_contract_approved_detailed(
257 itemtype in varchar2,
258 itemkey in varchar2,
259 actid in number,
260 funcmode in varchar2,
261 resultout out nocopy varchar2
262 );
263
264
265
266 -- Start of comments
267 --API name : complete_notification
268 --Type : Private.
269 --Function : This procedure is called by workflow after the approver responds to the Approval Notification Message.
270 -- : It completes the master process's waiting activity.
271 --Pre-reqs : None.
272 --Parameters :
273 --IN : itemtype IN VARCHAR2 Required
274 -- Workflow item type parameter
275 -- : itemkey IN VARCHAR2 Required
276 -- Workflow item key parameter
277 -- : actid IN VARCHAR2 Required
278 -- Workflow actid parameter
279 -- : funcmode IN VARCHAR2 Required
280 -- Workflow function mode parameter
281 --OUT : resultout OUT VARCHAR2(1)
282 -- Workflow standard out parameter
283 -- Note :
284 -- End of comments
285 PROCEDURE complete_notification(
286 itemtype IN varchar2,
287 itemkey IN varchar2,
288 actid IN number,
289 funcmode IN varchar2,
290 resultout OUT nocopy varchar2
291 );
292
293 --bug 6957819
294 -- Start of comments
295 --API name : Con_Has_Terms
296 --Type : Private.
297 --Function : This procedure is called by workflow to check if terms has been applied on the document.
298 --Pre-reqs : None.
299 --Parameters :
300 --IN : itemtype IN VARCHAR2 Required
301 -- Workflow item type parameter
302 -- : itemkey IN VARCHAR2 Required
303 -- Workflow item key parameter
304 -- : actid IN VARCHAR2 Required
305 -- Workflow actid parameter
306 -- : funcmode IN VARCHAR2 Required
307 -- Workflow function mode parameter
308 --OUT : resultout OUT VARCHAR2(1)
309 -- Workflow standard out parameter
310 -- Note :
311 -- End of comments
312
313 PROCEDURE con_has_terms(
314 itemtype IN varchar2,
315 itemkey IN varchar2,
316 actid IN number,
317 funcmode IN varchar2,
318 resultout OUT nocopy varchar2
319 );
320
321 -- Start of comments
322 --API name : con_attach_generated_YN
323 --Type : Private.
324 --Function : This procedure is called by workflow to check if terms has been applied on the document.
325 --Pre-reqs : None.
326 --Parameters :
327 --IN : itemtype IN VARCHAR2 Required
328 -- Workflow item type parameter
329 -- : itemkey IN VARCHAR2 Required
330 -- Workflow item key parameter
331 -- : actid IN VARCHAR2 Required
332 -- Workflow actid parameter
333 -- : funcmode IN VARCHAR2 Required
334 -- Workflow function mode parameter
335 --OUT : resultout OUT VARCHAR2(1)
336 -- Workflow standard out parameter
337 -- Note :
338 -- End of comments
339
340 PROCEDURE con_attach_generated_yn(
341 itemtype IN varchar2,
342 itemkey IN varchar2,
343 actid IN number,
344 funcmode IN varchar2,
345 resultout OUT nocopy varchar2
346 );
347
348 -- Start of comments
349 --API name : check_current_approver
350 --Type : Private.
351 --Function : This procedure is by ContractDetailsAMImpl.java to check if the logged in user is in list of penging approvers or not.
352 --Pre-reqs : None.
353 --Parameters :
354 --IN :p_contract_id,p_user_id
355 --OUT :'Y' or 'N'
356 -- Note :
357 -- End of comments
358
359
360 FUNCTION check_current_approver
361 (p_contract_id IN NUMBER
362 , p_user_id IN NUMBER
363 )
364 RETURN varchar2 ;
365
366
367 -- Start of comments
368 --API name : allow_approver_edit
369 --Type : Private.
370 --Function : This procedure is checks if the approver is allowed to edit or not
371 --Pre-reqs : None.
372 --Parameters :
373 -- Note :
374 -- End of comments
375 PROCEDURE allow_approver_edit
376 (itemtype IN varchar2,
377 itemkey IN varchar2,
378 actid IN number,
379 funcmode IN varchar2,
380 resultout OUT nocopy varchar2
381 );
382
383
384 -- Start of comments
385 --API name : contract_preview_yn
386 --Type : Private.
387 --Function : This procedure is checks if the contract can be printed or not
388 --Pre-reqs : None.
389 --Parameters :
390 -- Note :
391 -- End of comments
392 PROCEDURE contract_preview_yn
393 (itemtype IN varchar2,
394 itemkey IN varchar2,
395 actid IN number,
396 funcmode IN varchar2,
397 resultout OUT nocopy varchar2
398 ) ;
399
400
401 -- Start of comments
402 --API name : Apps_initialize
403 --Type : Private.
404 --Function : This procedure is sets apps context
405 --Pre-reqs : None.
406 --Parameters :
407 -- Note :
408 -- End of comments
409 PROCEDURE Apps_initialize(itemtype IN varchar2,
410 itemkey IN varchar2,
411 actid IN number,
412 funcmode IN varchar2,
413 resultout OUT nocopy varchar2);
414
415 END OKC_REP_WF_PVT;
[Home] [Help]