[Home] [Help]
PACKAGE: APPS.OKE_K_APPROVAL_WF
Source
1 PACKAGE OKE_K_APPROVAL_WF AUTHID CURRENT_USER AS
2 /* $Header: OKEWKAPS.pls 120.1.12000000.2 2007/02/27 18:46:00 nnadahal ship $ */
3 --
4 -- Name : Initialize
5 -- Pre-reqs : Must be called from WF activity
6 -- Function : This procedure initializes the remaining of the item
7 -- attributes not set during launch
8 --
9 -- Parameters :
10 -- IN : ItemType
11 -- ItemKey
12 -- ActID
13 -- FuncMode
14 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( None )
15 --
16 -- Returns : None
17 --
18 PROCEDURE Initialize
19 ( ItemType IN VARCHAR2
20 , ItemKey IN VARCHAR2
21 , ActID IN NUMBER
22 , FuncMode IN VARCHAR2
23 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 );
25
26
27 --
28 -- Name : Is_BOA_Approved
29 -- Pre-reqs : Must be called from WF activity
30 -- Function : This procedure determines if the master agreement
31 -- has been approved or not.
32 --
33 -- Parameters :
34 -- IN : ItemType
35 -- ItemKey
36 -- ActID
37 -- FuncMode
38 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( WFSTD_YES_NO )
39 --
40 -- Returns : None
41 --
42 PROCEDURE Is_BOA_Approved
43 ( ItemType IN VARCHAR2
44 , ItemKey IN VARCHAR2
45 , ActID IN NUMBER
46 , FuncMode IN VARCHAR2
47 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 );
49
50
51 --
52 -- Name : Is_Doc_Approved
53 -- Pre-reqs : Must be called from WF activity
54 -- Function : This procedure determines if the contract document
55 -- has already been approved or not.
56 --
57 -- Parameters :
58 -- IN : ItemType
59 -- ItemKey
60 -- ActID
61 -- FuncMode
62 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( WFSTD_YES_NO )
63 --
64 -- Returns : None
65 --
66 PROCEDURE Is_Doc_Approved
67 ( ItemType IN VARCHAR2
68 , ItemKey IN VARCHAR2
69 , ActID IN NUMBER
70 , FuncMode IN VARCHAR2
71 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 );
73
74
75 --
76 -- Name : Is_Doc_Delv_Order
77 -- Pre-reqs : Must be called from WF activity
78 -- Function : This procedure determines if the contract document
79 -- is a delivery order.
80 --
81 -- Parameters :
82 -- IN : ItemType
83 -- ItemKey
84 -- ActID
85 -- FuncMode
86 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( WFSTD_YES_NO )
87 --
88 -- Returns : None
89 --
90 PROCEDURE Is_Doc_Delv_Order
91 ( ItemType IN VARCHAR2
92 , ItemKey IN VARCHAR2
93 , ActID IN NUMBER
94 , FuncMode IN VARCHAR2
95 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 );
97
98
99 --
100 -- Name : Is_Doc_Inactive
101 -- Pre-reqs : Must be called from WF activity
102 -- Function : This procedure determines if the contract document
103 -- is currently inactive (Canceled, Expired, Terminated)
104 --
105 -- Parameters :
106 -- IN : ItemType
107 -- ItemKey
108 -- ActID
109 -- FuncMode
110 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( WFSTD_YES_NO )
111 --
112 -- Returns : None
113 --
114 PROCEDURE Is_Doc_Inactive
115 ( ItemType IN VARCHAR2
116 , ItemKey IN VARCHAR2
117 , ActID IN NUMBER
118 , FuncMode IN VARCHAR2
119 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
120 );
121
122
123 --
124 -- Name : Is_Final_Approver
125 -- Pre-reqs : Must be called from WF activity
126 -- Function : This procedure determines if the last approver
127 -- is the final approver based to the approval
128 -- hierarchy.
129 --
130 -- Parameters :
131 -- IN : ItemType
132 -- ItemKey
133 -- ActID
134 -- FuncMode
135 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( WFSTD_YES_NO )
136 --
137 -- Returns : None
138 --
139 PROCEDURE Is_Final_Approver
140 ( ItemType IN VARCHAR2
141 , ItemKey IN VARCHAR2
142 , ActID IN NUMBER
143 , FuncMode IN VARCHAR2
144 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
145 );
146
147
148 --
149 -- Name : Is_Requestor_Approver
150 -- Pre-reqs : Must be called from WF activity
151 -- Function : This procedure checks wheter the approver happens
152 -- to be also the requestor.
153 --
154 -- Parameters :
155 -- IN : ItemType
156 -- ItemKey
157 -- ActID
158 -- FuncMode
159 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( WFSTD_YES_NO )
160 --
161 -- Returns : None
162 --
163 PROCEDURE Is_Requestor_Approver
164 ( ItemType IN VARCHAR2
165 , ItemKey IN VARCHAR2
166 , ActID IN NUMBER
167 , FuncMode IN VARCHAR2
168 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
169 );
170
171
172 --
173 -- Name : Is_Signature_Required
174 -- Pre-reqs : Must be called from WF activity
175 -- Function : This procedure checks whether signature is required
176 -- based on the approval hierarchy
177 --
178 -- Parameters :
179 -- IN : ItemType
180 -- ItemKey
181 -- ActID
182 -- FuncMode
183 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( WFSTD_YES_NO )
184 --
185 -- Returns : None
186 --
187 PROCEDURE Is_Signature_Required
188 ( ItemType IN VARCHAR2
189 , ItemKey IN VARCHAR2
190 , ActID IN NUMBER
191 , FuncMode IN VARCHAR2
192 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
193 );
194
195
196 --
197 -- Name : Rej_Note_Filled
198 -- Pre-reqs : Must be called from WF activity
199 -- Function : This procedure verifies that the note is filled if
200 -- the contract was rejected.
201 --
202 -- Parameters :
203 -- IN : ItemType
204 -- ItemKey
205 -- ActID
206 -- FuncMode
207 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( WFSTD_YES_NO )
208 --
209 -- Returns : None
210 --
211 PROCEDURE Rej_Note_Filled
212 ( ItemType IN VARCHAR2
213 , ItemKey IN VARCHAR2
214 , ActID IN NUMBER
215 , FuncMode IN VARCHAR2
216 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
217 );
218
219
220 --
221 -- Name : Select_Next_Approver
222 -- Pre-reqs : Must be called from WF activity
223 -- Function : This procedure determines the next approver for
224 -- the contract based on the approval hierarchy.
225 --
226 -- Parameters :
227 -- IN : ItemType
228 -- ItemKey
229 -- ActID
230 -- FuncMode
231 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( WFSTD_BOOLEAN )
232 --
233 -- Returns : None
234 --
235 PROCEDURE Select_Next_Approver
236 ( ItemType IN VARCHAR2
237 , ItemKey IN VARCHAR2
238 , ActID IN NUMBER
239 , FuncMode IN VARCHAR2
240 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
241 );
242
243
244 --
245 -- Name : Select_Signatory
246 -- Pre-reqs : Must be called from WF activity
247 -- Function : This procedure determines the signatory for
248 -- the contract based on the approval hierarchy
249 --
250 -- Parameters :
251 -- IN : ItemType
252 -- ItemKey
253 -- ActID
254 -- FuncMode
255 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( WFSTD_BOOLEAN )
256 --
257 -- Returns : None
258 --
259 PROCEDURE Select_Signatory
260 ( ItemType IN VARCHAR2
261 , ItemKey IN VARCHAR2
262 , ActID IN NUMBER
263 , FuncMode IN VARCHAR2
264 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
265 );
266
267
268 --
269 -- Name : Set_Approval_History
270 -- Pre-reqs : Must be called from WF activity
271 -- Function : This post-notification procedure records the approval
272 -- history based on the notification response
273 --
274 -- Parameters :
275 -- IN : ItemType
276 -- ItemKey
277 -- ActID
278 -- FuncMode
279 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( None )
280 --
281 -- Returns : None
282 --
283 PROCEDURE Set_Approval_History
284 ( ItemType IN VARCHAR2
285 , ItemKey IN VARCHAR2
286 , ActID IN NUMBER
287 , FuncMode IN VARCHAR2
288 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
289 );
290
291
292 --
293 -- Name : Validate_Approval_Path
294 -- Pre-reqs : Must be called from WF activity
295 -- Function : This procedure validates the approval hierarchy
296 -- associated with the contract document type.
297 --
298 -- Parameters :
299 -- IN : Document_ID ( ItemType:ItemKey )
300 -- Display_Type
301 -- Document_Type
302 -- OUT NOCOPY /* file.sql.39 change */ : Document
303 -- Document_Type
304 --
305 -- Returns : None
306 --
307 PROCEDURE Validate_Approval_Path
308 ( ItemType IN VARCHAR2
309 , ItemKey IN VARCHAR2
310 , ActID IN NUMBER
311 , FuncMode IN VARCHAR2
312 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
313 );
314
315 --bug#5846706
316 --
317 -- Name : Erase_Approved
318 -- Pre-reqs : Must be called from WF activity
319 -- Function : It erases approved date when signatory rejects the contract
320 --
321 --
322 -- Parameters :
323 -- IN : ItemType
324 -- ItemKey
325 -- ActID
326 -- FuncMode
327 -- OUT NOCOPY /* file.sql.39 change */ : ResultOut ( None )
328 --
329 -- Returns : None
330 --
331 PROCEDURE Erase_Approved
332 ( ItemType IN VARCHAR2
333 , ItemKey IN VARCHAR2
334 , ActID IN NUMBER
335 , FuncMode IN VARCHAR2
336 , ResultOut OUT NOCOPY /* file.sql.39 change */ VARCHAR2
337 );
338
339
340 END OKE_K_APPROVAL_WF;