1 PACKAGE AHL_MEL_CDL_APPROVALS_PVT AS
2 /* $Header: AHLVMAPS.pls 120.1 2008/02/29 07:55:25 sracha ship $ */
3
4 G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL'; -- Use for all FND_MESSAGE.SET_NAME calls
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_MEL_CDL_APPROVALS_PVT'; -- Use for all debug messages, FND_API.COMPATIBLE_API_CALL, etc
6
7 G_APPR_OBJ CONSTANT VARCHAR2(30) := 'MEL_CDL';
8 G_APPR_TYPE CONSTANT VARCHAR2(30) := 'CONCEPT';
9
10 -- object used for non-routine approval.
11 G_NR_APPR_OBJ CONSTANT VARCHAR2(30) := 'NR_MEL_CDL';
12
13 -- Start of Comments --
14 --
15 -- Procedure name : SET_ACTIVITY_DETAILS
16 -- Type : Private
17 -- Description : This procedure sets all item attribute details for the approval rule
18 --
19 -- Version :
20 -- Initial Version 1.0
21 --
22 -- End of Comments --
23 PROCEDURE SET_ACTIVITY_DETAILS
24 (
25 itemtype IN VARCHAR2,
26 itemkey IN VARCHAR2,
27 actid IN NUMBER,
28 funcmode IN VARCHAR2,
29 resultout OUT NOCOPY VARCHAR2
30 );
31
32 -- Start of Comments --
33 --
34 -- Procedure name : NTF_FORWARD_FYI
35 -- Type : Private
36 -- Description : This procedure generates the FYI document for forwarded workflow notifications
37 --
38 -- Version :
39 -- Initial Version 1.0
40 --
41 -- End of Comments --
42 PROCEDURE NTF_FORWARD_FYI
43 (
44 document_id IN VARCHAR2,
45 display_type IN VARCHAR2,
46 document IN OUT NOCOPY VARCHAR2,
47 document_type IN OUT NOCOPY VARCHAR2
48 );
49
50 -- Start of Comments --
51 --
52 -- Procedure name : NTF_APPROVED_FYI
53 -- Type : Private
54 -- Description : This procedure generates the FYI document for approved workflow notifications
55 --
56 -- Version :
57 -- Initial Version 1.0
58 --
59 -- End of Comments --
60 PROCEDURE NTF_APPROVED_FYI
61 (
62 document_id IN VARCHAR2,
63 display_type IN VARCHAR2,
64 document IN OUT NOCOPY VARCHAR2,
65 document_type IN OUT NOCOPY VARCHAR2
66 );
67
68 -- Start of Comments --
69 --
70 -- Procedure name : NTF_FINAL_APPROVAL_FYI
71 -- Type : Private
72 -- Description : This procedure generates the FYI document for final approval workflow notifications
73 --
74 -- Version :
75 -- Initial Version 1.0
76 --
77 -- End of Comments --
78 PROCEDURE NTF_FINAL_APPROVAL_FYI
79 (
80 document_id IN VARCHAR2,
81 display_type IN VARCHAR2,
82 document IN OUT NOCOPY VARCHAR2,
83 document_type IN OUT NOCOPY VARCHAR2
84 );
85
86 -- Start of Comments --
87 --
88 -- Procedure name : NTF_REJECTED_FYI
89 -- Type : Private
90 -- Description : This procedure generates the FYI document for rejected workflow notifications
91 --
92 -- Version :
93 -- Initial Version 1.0
94 --
95 -- End of Comments --
96 PROCEDURE NTF_REJECTED_FYI
97 (
98 document_id IN VARCHAR2,
99 display_type IN VARCHAR2,
100 document IN OUT NOCOPY VARCHAR2,
101 document_type IN OUT NOCOPY VARCHAR2
102 );
103
104 -- Start of Comments --
105 --
106 -- Procedure name : NTF_APPROVAL
107 -- Type : Private
108 -- Description : This procedure generates the document for sending to-approve notifications
109 --
110 -- Version :
111 -- Initial Version 1.0
112 --
113 -- End of Comments --
114 PROCEDURE NTF_APPROVAL
115 (
116 document_id IN VARCHAR2,
117 display_type IN VARCHAR2,
118 document IN OUT NOCOPY VARCHAR2,
119 document_type IN OUT NOCOPY VARCHAR2
120 );
121
122 -- Start of Comments --
123 --
124 -- Procedure name : NTF_APPROVAL_REMINDER
125 -- Type : Private
126 -- Description : This procedure generates the document for sending reminders
127 --
128 -- Version :
129 -- Initial Version 1.0
130 --
131 -- End of Comments --
132 PROCEDURE NTF_APPROVAL_REMINDER
133 (
134 document_id IN VARCHAR2,
135 display_type IN VARCHAR2,
136 document IN OUT NOCOPY VARCHAR2,
137 document_type IN OUT NOCOPY VARCHAR2
138 );
139
140 -- Start of Comments --
141 --
142 -- Procedure name : NTF_ERROR_ACT
143 -- Type : Private
144 -- Description : This procedure generates the document for requesting action on error
145 --
146 -- Version :
147 -- Initial Version 1.0
148 --
149 -- End of Comments --
150 PROCEDURE NTF_ERROR_ACT
151 (
152 document_id IN VARCHAR2,
153 display_type IN VARCHAR2,
154 document IN OUT NOCOPY VARCHAR2,
155 document_type IN OUT NOCOPY VARCHAR2
156 );
157
158 -- Start of Comments --
159 --
160 -- Procedure name : UPDATE_STATUS
161 -- Type : Private
162 -- Description : This procedure handles the final complete step of the workflow process
163 --
164 -- Version :
165 -- Initial Version 1.0
166 --
167 -- End of Comments --
168 PROCEDURE UPDATE_STATUS
169 (
170 itemtype IN VARCHAR2,
171 itemkey IN VARCHAR2,
172 actid IN NUMBER,
173 funcmode IN VARCHAR2,
174 resultout OUT NOCOPY VARCHAR2
175 );
176
177 -- Start of Comments --
178 --
179 -- Procedure name : REVERT_STATUS
180 -- Type : Private
181 -- Description : This procedure handles revert of the workflow process on any error
182 --
183 -- Version :
184 -- Initial Version 1.0
185 --
186 -- End of Comments --
187 PROCEDURE REVERT_STATUS
188 (
189 itemtype IN VARCHAR2,
190 itemkey IN VARCHAR2,
191 actid IN NUMBER,
192 funcmode IN VARCHAR2,
193 resultout OUT NOCOPY VARCHAR2
194 );
195
196 -- Procedures used by Non-Routine MEL/CDl approval --
197 -----------------------------------------------------
198
199
200 -- Start of Comments --
201 --
202 -- Procedure name : NR_SET_ACTIVITY_DETAILS
203 -- Type : Private
204 -- Description : This procedure sets all item attribute details for the NR approval rule
205 --
206 -- Version :
207 -- Initial Version 1.0
208 --
209 -- End of Comments --
210 PROCEDURE NR_SET_ACTIVITY_DETAILS
211 (
212 itemtype IN VARCHAR2,
213 itemkey IN VARCHAR2,
214 actid IN NUMBER,
215 funcmode IN VARCHAR2,
216 resultout OUT NOCOPY VARCHAR2
217 );
218
219 -- Start of Comments --
220 --
221 -- Procedure name : NR_NTF_FORWARD_FYI
222 -- Type : Private
223 -- Description : This procedure generates the FYI document for forwarded workflow notifications
224 --
225 -- Version :
226 -- Initial Version 1.0
227 --
228 -- End of Comments --
229 PROCEDURE NR_NTF_FORWARD_FYI
230 (
231 document_id IN VARCHAR2,
232 display_type IN VARCHAR2,
233 document IN OUT NOCOPY VARCHAR2,
234 document_type IN OUT NOCOPY VARCHAR2
235 );
236
237
238 -- Start of Comments --
239 --
240 -- Procedure name : NR_NTF_APPROVED_FYI
241 -- Type : Private
242 -- Description : This procedure generates the FYI document for approved workflow notifications
243 --
244 -- Version :
245 -- Initial Version 1.0
246 --
247 -- End of Comments --
248 PROCEDURE NR_NTF_APPROVED_FYI
249 (
250 document_id IN VARCHAR2,
251 display_type IN VARCHAR2,
252 document IN OUT NOCOPY VARCHAR2,
253 document_type IN OUT NOCOPY VARCHAR2
254 );
255
256
257 -- Start of Comments --
258 --
259 -- Procedure name : NR_NTF_FINAL_APPROVAL_FYI
260 -- Type : Private
261 -- Description : This procedure generates the FYI document for final approval workflow notifications
262 --
263 -- Version :
264 -- Initial Version 1.0
265 --
266 -- End of Comments --
267 PROCEDURE NR_NTF_FINAL_APPROVAL_FYI
268 (
269 document_id IN VARCHAR2,
270 display_type IN VARCHAR2,
271 document IN OUT NOCOPY VARCHAR2,
272 document_type IN OUT NOCOPY VARCHAR2
273 );
274
275
276 -- Start of Comments --
277 --
278 -- Procedure name : NR_NTF_REJECTED_FYI
279 -- Type : Private
280 -- Description : This procedure generates the FYI document for rejected workflow notifications
281 --
282 -- Version :
283 -- Initial Version 1.0
284 --
285 -- End of Comments --
286 PROCEDURE NR_NTF_REJECTED_FYI
287 (
288 document_id IN VARCHAR2,
289 display_type IN VARCHAR2,
290 document IN OUT NOCOPY VARCHAR2,
291 document_type IN OUT NOCOPY VARCHAR2
292 );
293
294
295 -- Start of Comments --
296 --
297 -- Procedure name : NR_NTF_APPROVAL
298 -- Type : Private
299 -- Description : This procedure generates the document for sending to-approve notifications
300 --
301 -- Version :
302 -- Initial Version 1.0
303 --
304 -- End of Comments --
305 PROCEDURE NR_NTF_APPROVAL
306 (
307 document_id IN VARCHAR2,
308 display_type IN VARCHAR2,
309 document IN OUT NOCOPY VARCHAR2,
310 document_type IN OUT NOCOPY VARCHAR2
311 );
312
313
314 -- Start of Comments --
315 --
316 -- Procedure name : NR_NTF_APPROVAL_REMINDER
317 -- Type : Private
318 -- Description : This procedure generates the document for sending reminders
319 --
320 -- Version :
321 -- Initial Version 1.0
322 --
323 -- End of Comments --
324 PROCEDURE NR_NTF_APPROVAL_REMINDER
325 (
326 document_id IN VARCHAR2,
327 display_type IN VARCHAR2,
328 document IN OUT NOCOPY VARCHAR2,
329 document_type IN OUT NOCOPY VARCHAR2
330 );
331
332
333 -- Start of Comments --
334 --
335 -- Procedure name : NR_NTF_ERROR_ACT
336 -- Type : Private
337 -- Description : This procedure generates the document for requesting action on error
338 --
339 -- Version :
340 -- Initial Version 1.0
341 --
342 -- End of Comments --
343 PROCEDURE NR_NTF_ERROR_ACT
344 (
345 document_id IN VARCHAR2,
346 display_type IN VARCHAR2,
347 document IN OUT NOCOPY VARCHAR2,
348 document_type IN OUT NOCOPY VARCHAR2
349 );
350
351
352 -- Start of Comments --
353 --
354 -- Procedure name : NR_UPDATE_STATUS
355 -- Type : Private
356 -- Description : This procedure handles the final complete step of the workflow process
357 --
358 -- Version :
359 -- Initial Version 1.0
360 --
361 -- End of Comments --
362 PROCEDURE NR_UPDATE_STATUS
363 (
364 itemtype IN VARCHAR2,
365 itemkey IN VARCHAR2,
366 actid IN NUMBER,
367 funcmode IN VARCHAR2,
368 resultout OUT NOCOPY VARCHAR2
369 );
370
371
372 -- Start of Comments --
373 --
374 -- Procedure name : NR_REVERT_STATUS
375 -- Type : Private
376 -- Description : This procedure handles revert of the workflow process on any error
377 --
378 -- Version :
379 -- Initial Version 1.0
380 --
381 -- End of Comments --
382 PROCEDURE NR_REVERT_STATUS
383 (
384 itemtype IN VARCHAR2,
385 itemkey IN VARCHAR2,
386 actid IN NUMBER,
387 funcmode IN VARCHAR2,
388 resultout OUT NOCOPY VARCHAR2
389 );
390
391
392 End AHL_MEL_CDL_APPROVALS_PVT;