[Home] [Help]
PACKAGE: APPS.IGI_EXP_APPROVAL_PKG
Source
1 PACKAGE igi_exp_approval_pkg AUTHID CURRENT_USER AS
2 -- $Header: igiexas.pls 120.4.12000000.2 2007/09/21 07:09:10 dvjoshi ship $
3 --
4
5
6 --
7 -- Procedure
8 -- Frame_table_header
9 -- Purpose
10 -- It will frame the HTML table.
11 -- History
12 -- 01-Jan-2004 Rgopalan Initial Version
13 --
14 PROCEDURE Frame_table_header (p_html_tag OUT NOCOPY VARCHAR2);
15
16 --
17 -- Procedure
18 -- Create_du_list
19 -- Purpose
20 -- It will append the details to HTML table
21 -- History
22 -- 01-Jan-2004 Rgopalan Initial Version
23 --
24 PROCEDURE Create_du_list (document_id IN VARCHAR2,
25 display_type IN VARCHAR2,
26 document IN OUT NOCOPY CLOB,
27 document_type IN OUT NOCOPY VARCHAR2);
28
29 --
30 -- Procedure
31 -- Selector
32 -- Purpose
33 -- Chooses the process to run when the workflow is invoked
34 -- History
35 -- 22-Nov-2001 S Brewer Initial Version
36 --
37 PROCEDURE Selector( itemtype IN VARCHAR2,
38 itemkey IN VARCHAR2,
39 actid IN NUMBER,
40 funcmode IN VARCHAR2,
41 resultout OUT NOCOPY VARCHAR2
42 );
43
44 --
45 -- Procedure
46 -- start_approval_workflow
47 -- Purpose
48 -- Creates and starts an instance of the workflow.
49 -- History
50 -- 22-Nov-2001 S Brewer Initial Version
51 --
52 PROCEDURE start_approval_workflow(p_tu_id IN NUMBER
53 ,p_tu_order_number IN VARCHAR2
54 ,p_tu_transmitter_name IN VARCHAR2
55 ,p_tu_transmitter_id IN NUMBER);
56
57 --
58 -- Procedure
59 -- is_tu_trans_employee
60 -- Purpose
61 -- Checks that the tu transmitter has been set up as an
62 -- employee
63 -- History
64 -- 22-Nov-2001 S Brewer Initial Version
65 --
66 PROCEDURE is_tu_trans_employee ( itemtype IN VARCHAR2,
67 itemkey IN VARCHAR2,
68 actid IN NUMBER,
69 funcmode IN VARCHAR2,
70 result OUT NOCOPY VARCHAR2);
71
72 --
73 -- Procedure
74 -- emp_has_position
75 -- Purpose
76 -- Check that the TU transmitter is assigned to a position
77 -- History
78 -- 22-Nov-2001 S Brewer Initial Version
79 --
80 PROCEDURE emp_has_position ( itemtype IN VARCHAR2,
81 itemkey IN VARCHAR2,
82 actid IN NUMBER,
83 funcmode IN VARCHAR2,
84 result OUT NOCOPY VARCHAR2);
85
86 --
87 -- Procedure
88 -- position_in_hierarchy
89 -- Purpose
90 -- History
91 -- 22-Nov-2001 S Brewer Initial Version
92 --
93 PROCEDURE position_in_hierarchy( itemtype IN VARCHAR2,
94 itemkey IN VARCHAR2,
95 actid IN NUMBER,
96 funcmode IN VARCHAR2,
97 result OUT NOCOPY VARCHAR2);
98
99 --
100 -- Procedure
101 -- is_position_gt_final_pos
102 -- Purpose
103 -- History
104 -- 22-Nov-2001 S Brewer Initial Version
105 --
106 PROCEDURE is_position_gt_final_pos( itemtype IN VARCHAR2,
107 itemkey IN VARCHAR2,
108 actid IN NUMBER,
109 funcmode IN VARCHAR2,
110 result OUT NOCOPY VARCHAR2);
111
112 --
113 -- Procedure
114 -- update_tu_status_to_avl
115 -- Purpose
116 -- History
117 -- 22-Nov-2001 S Brewer Initial Version
118 --
119 PROCEDURE update_tu_status_to_avl( itemtype IN VARCHAR2,
120 itemkey IN VARCHAR2,
121 actid IN NUMBER,
122 funcmode IN VARCHAR2,
123 result OUT NOCOPY VARCHAR2);
124
125 --
126 -- Procedure
127 -- update_dus_to_in_a_tu
128 -- Purpose
129 -- History
130 -- 22-Nov-2001 S Brewer Initial Version
131 --
132 PROCEDURE update_dus_to_in_a_tu( itemtype IN VARCHAR2,
133 itemkey IN VARCHAR2,
134 actid IN NUMBER,
135 funcmode IN VARCHAR2,
136 result OUT NOCOPY VARCHAR2);
137
138 --
139 -- Procedure
140 -- build_user_list
141 -- Purpose
142 -- History
143 -- 22-Nov-2001 S Brewer Initial Version
144 --
145 PROCEDURE build_user_list ( itemtype IN VARCHAR2,
146 itemkey IN VARCHAR2,
147 actid IN NUMBER,
148 funcmode IN VARCHAR2,
149 result OUT NOCOPY VARCHAR2);
150
151 --
152 -- Procedure
153 -- check_user_position
154 -- Purpose
155 -- History
156 -- 22-Nov-2001 S Brewer Initial Version
157 --
158 PROCEDURE check_user_position ( itemtype IN VARCHAR2,
159 itemkey IN VARCHAR2,
160 actid IN NUMBER,
161 funcmode IN VARCHAR2,
162 result OUT NOCOPY VARCHAR2);
163
164 --
165 -- Procedure
166 -- set_pos_as_auth
167 -- Purpose
168 -- History
169 -- 22-Nov-2001 S Brewer Initial Version
170 --
171 PROCEDURE set_pos_as_auth ( itemtype IN VARCHAR2,
172 itemkey IN VARCHAR2,
173 actid IN NUMBER,
174 funcmode IN VARCHAR2,
175 result OUT NOCOPY VARCHAR2);
176
177 --
178 -- Procedure
179 -- set_chosen_user_as_auth
180 -- Purpose
181 -- History
182 -- 22-Nov-2001 S Brewer Initial Version
183 --
184 PROCEDURE set_chosen_user_as_auth( itemtype IN VARCHAR2,
185 itemkey IN VARCHAR2,
186 actid IN NUMBER,
187 funcmode IN VARCHAR2,
188 result OUT NOCOPY VARCHAR2);
189
190 --
191 -- Procedure
192 -- is_auth_allowed_return
193 -- Purpose
194 -- History
195 -- 22-Nov-2001 S Brewer Initial Version
196 --
197 PROCEDURE is_auth_allowed_return( itemtype IN VARCHAR2,
198 itemkey IN VARCHAR2,
199 actid IN NUMBER,
200 funcmode IN VARCHAR2,
201 result OUT NOCOPY VARCHAR2);
202
203 --
204 -- Procedure
205 -- set_curr_auth_to_responder
206 -- Purpose
207 -- History
208 -- 22-Nov-2001 S Brewer Initial Version
209 --
210 PROCEDURE set_curr_auth_to_responder( itemtype IN VARCHAR2,
211 itemkey IN VARCHAR2,
212 actid IN NUMBER,
213 funcmode IN VARCHAR2,
214 result OUT NOCOPY VARCHAR2);
215
216 --
217 -- Procedure
218 -- add_auth_to_history
219 -- Purpose
220 -- History
221 -- 22-Nov-2001 S Brewer Initial Version
222 --
223 PROCEDURE add_auth_to_history ( itemtype IN VARCHAR2,
224 itemkey IN VARCHAR2,
225 actid IN NUMBER,
226 funcmode IN VARCHAR2,
227 result OUT NOCOPY VARCHAR2);
228
229 --
230 -- Procedure
231 -- set_current_position_to_subord
232 -- Purpose
233 -- History
234 -- 22-Nov-2001 S Brewer Initial Version
235 --
236 PROCEDURE set_current_position_to_subord( itemtype IN VARCHAR2,
237 itemkey IN VARCHAR2,
238 actid IN NUMBER,
239 funcmode IN VARCHAR2,
240 result OUT NOCOPY VARCHAR2);
241
242 --
243 -- Procedure
244 -- set_current_auth_to_prev_auth
245 -- Purpose
246 -- History
247 -- 22-Nov-2001 S Brewer Initial Version
248 --
249 PROCEDURE set_current_auth_to_prev_auth( itemtype IN VARCHAR2,
250 itemkey IN VARCHAR2,
251 actid IN NUMBER,
252 funcmode IN VARCHAR2,
253 result OUT NOCOPY VARCHAR2);
254
255 --
256 -- Procedure
257 -- reset_du_statuses
258 -- Purpose
259 -- History
260 -- 22-Nov-2001 S Brewer Initial Version
261 --
262 PROCEDURE reset_du_statuses ( itemtype IN VARCHAR2,
263 itemkey IN VARCHAR2,
264 actid IN NUMBER,
265 funcmode IN VARCHAR2,
266 result OUT NOCOPY VARCHAR2);
267
268 --
269 -- Procedure
270 -- check_dus_actioned
271 -- Purpose
272 -- History
273 -- 22-Nov-2001 S Brewer Initial Version
274 --
275 PROCEDURE check_dus_actioned ( itemtype IN VARCHAR2,
276 itemkey IN VARCHAR2,
277 actid IN NUMBER,
278 funcmode IN VARCHAR2,
279 result OUT NOCOPY VARCHAR2);
280
281 --
282 -- Procedure
283 -- set_dus_to_atr
284 -- Purpose
285 -- History
286 -- 22-Nov-2001 S Brewer Initial Version
287 --
288 PROCEDURE set_dus_to_atr ( itemtype IN VARCHAR2,
289 itemkey IN VARCHAR2,
290 actid IN NUMBER,
291 funcmode IN VARCHAR2,
292 result OUT NOCOPY VARCHAR2);
293
294 --
295 -- Procedure
296 -- list_any_dus_on_hold
297 -- Purpose
298 -- History
299 -- 22-Nov-2001 S Brewer Initial Version
300 --
301 PROCEDURE list_any_dus_on_hold ( itemtype IN VARCHAR2,
302 itemkey IN VARCHAR2,
303 actid IN NUMBER,
304 funcmode IN VARCHAR2,
305 result OUT NOCOPY VARCHAR2);
306
307 --
308 -- Procedure
309 -- get_next_du_on_hold
310 -- Purpose
311 -- History
312 -- 22-Nov-2001 S Brewer Initial Version
313 --
314 PROCEDURE get_next_du_on_hold ( itemtype IN VARCHAR2,
315 itemkey IN VARCHAR2,
316 actid IN NUMBER,
317 funcmode IN VARCHAR2,
318 result OUT NOCOPY VARCHAR2);
319
320 --
321 -- Procedure
322 -- remove_dus_on_hold
323 -- Purpose
324 -- History
325 -- 22-Nov-2001 S Brewer Initial Version
326 --
327 PROCEDURE remove_dus_on_hold ( itemtype IN VARCHAR2,
328 itemkey IN VARCHAR2,
329 actid IN NUMBER,
330 funcmode IN VARCHAR2,
331 result OUT NOCOPY VARCHAR2);
332
333 --
334 -- Procedure
335 -- list_any_rejected_dus
336 -- Purpose
337 -- History
338 -- 22-Nov-2001 S Brewer Initial Version
339 --
340 PROCEDURE list_any_rejected_dus( itemtype IN VARCHAR2,
341 itemkey IN VARCHAR2,
342 actid IN NUMBER,
343 funcmode IN VARCHAR2,
344 result OUT NOCOPY VARCHAR2);
345
346 --
347 -- Procedure
348 -- get_next_rejected_du
349 -- Purpose
350 -- History
351 -- 22-Nov-2001 S Brewer Initial Version
352 --
353 PROCEDURE get_next_rejected_du ( itemtype IN VARCHAR2,
354 itemkey IN VARCHAR2,
355 actid IN NUMBER,
356 funcmode IN VARCHAR2,
357 result OUT NOCOPY VARCHAR2);
358
359 --
360 -- Procedure
361 -- rem_trx_from_rej_dus
362 -- Purpose
363 -- History
364 -- 22-Nov-2001 S Brewer Initial Version
365 --
366 PROCEDURE rem_trx_from_rej_dus ( itemtype IN VARCHAR2,
367 itemkey IN VARCHAR2,
368 actid IN NUMBER,
369 funcmode IN VARCHAR2,
370 result OUT NOCOPY VARCHAR2);
371
372 --
373 -- Procedure
374 -- is_legal_num_req
375 -- Purpose
376 -- History
377 -- 22-Nov-2001 S Brewer Initial Version
378 --
379 PROCEDURE is_legal_num_req ( itemtype IN VARCHAR2,
380 itemkey IN VARCHAR2,
381 actid IN NUMBER,
382 funcmode IN VARCHAR2,
383 result OUT NOCOPY VARCHAR2);
384
385 --
386 -- Procedure
387 -- apply_tu_legal_num
388 -- Purpose
389 -- History
390 -- 22-Nov-2001 S Brewer Initial Version
391 --
392 PROCEDURE apply_tu_legal_num ( itemtype IN VARCHAR2,
393 itemkey IN VARCHAR2,
394 actid IN NUMBER,
395 funcmode IN VARCHAR2,
396 result OUT NOCOPY VARCHAR2);
397
398 --
399 -- Procedure
400 -- apply_du_legal_num
401 -- Purpose
402 -- History
403 -- 22-Nov-2001 S Brewer Initial Version
404 --
405 PROCEDURE apply_du_legal_num ( itemtype IN VARCHAR2,
406 itemkey IN VARCHAR2,
407 actid IN NUMBER,
408 funcmode IN VARCHAR2,
409 result OUT NOCOPY VARCHAR2);
410
411 --
412 -- Procedure
413 -- set_tu_status
414 -- Purpose
415 -- History
416 -- 22-Nov-2001 S Brewer Initial Version
417 --
421 funcmode IN VARCHAR2,
418 PROCEDURE set_tu_status ( itemtype IN VARCHAR2,
419 itemkey IN VARCHAR2,
420 actid IN NUMBER,
422 result OUT NOCOPY VARCHAR2);
423
424 --
425 -- Procedure
426 -- get_parent_position
427 -- Purpose
428 -- History
429 -- 22-Nov-2001 S Brewer Initial Version
430 --
431 PROCEDURE get_parent_position ( itemtype IN VARCHAR2,
432 itemkey IN VARCHAR2,
433 actid IN NUMBER,
434 funcmode IN VARCHAR2,
435 result OUT NOCOPY VARCHAR2);
436
437 --
438 -- Procedure
439 -- get_next_incomplete_du
440 -- Purpose
441 -- History
442 -- 22-Nov-2001 S Brewer Initial Version
443 --
444 PROCEDURE get_next_incomplete_du(itemtype IN VARCHAR2,
445 itemkey IN VARCHAR2,
446 actid IN NUMBER,
447 funcmode IN VARCHAR2,
448 result OUT NOCOPY VARCHAR2);
449
450 --
451 -- Procedure
452 -- process_transactions
453 -- Purpose
454 -- History
455 -- 22-Nov-2001 S Brewer Initial Version
456 --
457 PROCEDURE process_transactions ( itemtype IN VARCHAR2,
458 itemkey IN VARCHAR2,
459 actid IN NUMBER,
460 funcmode IN VARCHAR2,
461 result OUT NOCOPY VARCHAR2);
462
463 --
464 -- Procedure
465 -- set_du_to_complete
466 -- Purpose
467 -- History
468 -- 22-Nov-2001 S Brewer Initial Version
469 --
470 PROCEDURE set_du_to_complete ( itemtype IN VARCHAR2,
471 itemkey IN VARCHAR2,
472 actid IN NUMBER,
473 funcmode IN VARCHAR2,
474 result OUT NOCOPY VARCHAR2);
475
476 --
477 -- Procedure
478 -- put_failed_du_on_hold
479 -- Purpose
480 -- History
481 -- 22-Nov-2001 S Brewer Initial Version
482 --
483 PROCEDURE put_failed_du_on_hold( itemtype IN VARCHAR2,
484 itemkey IN VARCHAR2,
485 actid IN NUMBER,
486 funcmode IN VARCHAR2,
487 result OUT NOCOPY VARCHAR2);
488
489 --
490 -- Procedure
491 -- check_dus_completed
492 -- Purpose
493 -- History
494 -- 22-Nov-2001 S Brewer Initial Version
495 --
496 PROCEDURE check_dus_completed ( itemtype IN VARCHAR2,
497 itemkey IN VARCHAR2,
498 actid IN NUMBER,
499 funcmode IN VARCHAR2,
500 result OUT NOCOPY VARCHAR2);
501
502 --
503 -- Procedure
504 -- any_dus_with_trx_fail
505 -- Purpose
506 -- History
507 -- 22-Nov-2001 S Brewer Initial Version
508 --
509 PROCEDURE any_dus_with_trx_fail( itemtype IN VARCHAR2,
510 itemkey IN VARCHAR2,
511 actid IN NUMBER,
512 funcmode IN VARCHAR2,
513 result OUT NOCOPY VARCHAR2);
514
515 --
516 -- Procedure
517 -- remove_all_on_hold_dus
518 -- Purpose
519 -- History
520 -- 22-Nov-2001 S Brewer Initial Version
521 --
522 PROCEDURE remove_all_on_hold_dus(itemtype IN VARCHAR2,
523 itemkey IN VARCHAR2,
524 actid IN NUMBER,
525 funcmode IN VARCHAR2,
526 result OUT NOCOPY VARCHAR2);
527
528 --
529 -- Procedure
530 -- check_for_complete_dus
531 -- Purpose
532 -- History
533 -- 22-Nov-2001 S Brewer Initial Version
534 --
535 PROCEDURE check_for_complete_dus( itemtype IN VARCHAR2,
536 itemkey IN VARCHAR2,
537 actid IN NUMBER,
538 funcmode IN VARCHAR2,
539 result OUT NOCOPY VARCHAR2);
540
541 --
542 -- Procedure
543 -- build_prep_list_of_com_dus
544 -- Purpose
545 -- History
546 -- 22-Nov-2001 S Brewer Initial Version
547 --
548 PROCEDURE build_prep_list_of_com_dus( itemtype IN VARCHAR2,
549 itemkey IN VARCHAR2,
550 actid IN NUMBER,
551 funcmode IN VARCHAR2,
552 result OUT NOCOPY VARCHAR2);
553
554
555 --
556 -- Procedure
557 -- get_next_prep
558 -- Purpose
559 -- History
560 -- 22-Nov-2001 S Brewer Initial Version
561 --
562 PROCEDURE get_next_prep ( itemtype IN VARCHAR2,
563 itemkey IN VARCHAR2,
564 actid IN NUMBER,
565 funcmode IN VARCHAR2,
566 result OUT NOCOPY VARCHAR2);
567
568 --
569 -- Procedure
570 -- remove_prep_from_list
571 -- Purpose
572 -- History
573 -- 22-Nov-2001 S Brewer Initial Version
574 --
575 PROCEDURE remove_prep_from_list( itemtype IN VARCHAR2,
576 itemkey IN VARCHAR2,
577 actid IN NUMBER,
578 funcmode IN VARCHAR2,
579 result OUT NOCOPY VARCHAR2);
580
581 --
582 -- Procedure
583 -- set_tu_to_complete
584 -- Purpose
585 -- History
586 -- 22-Nov-2001 S Brewer Initial Version
587 --
588 PROCEDURE set_tu_to_complete ( itemtype IN VARCHAR2,
589 itemkey IN VARCHAR2,
590 actid IN NUMBER,
591 funcmode IN VARCHAR2,
592 result OUT NOCOPY VARCHAR2);
593
594
595 -- OPSF(I) EXP Bug 2415293 S Brewer 11-JUL-2002 Start(1)
596 -- Added new procedures does_tu_have_legal_num and
597 -- remove_rej_dus_from_tu and get_next_rejected_legal_du
598
599 --
600 -- Procedure
601 -- does_tu_have_legal_num
602 -- Purpose
603 -- History
604 -- 11-Jul-2002 S Brewer Initial Version
605 --
606 PROCEDURE does_tu_have_legal_num( itemtype IN VARCHAR2,
607 itemkey IN VARCHAR2,
608 actid IN NUMBER,
609 funcmode IN VARCHAR2,
610 result OUT NOCOPY VARCHAR2);
611
612
613 --
614 -- Procedure
615 -- remove_rej_dus_from_tu
616 -- Purpose
617 -- History
618 -- 11-Jul-2002 S Brewer Initial Version
619 --
620 PROCEDURE remove_rej_dus_from_tu( itemtype IN VARCHAR2,
621 itemkey IN VARCHAR2,
622 actid IN NUMBER,
623 funcmode IN VARCHAR2,
624 result OUT NOCOPY VARCHAR2);
625
626 --
627 -- Procedure
628 -- get_next_rejected_legal_du
629 -- Purpose
630 -- History
631 -- 11-Jul-2002 S Brewer Initial Version
632 --
633 PROCEDURE get_next_rejected_legal_du( itemtype IN VARCHAR2,
634 itemkey IN VARCHAR2,
635 actid IN NUMBER,
636 funcmode IN VARCHAR2,
637 result OUT NOCOPY VARCHAR2);
638
639 -- OPSF(I) EXP Bug 2415293 S Brewer 11-JUL-2002 End(1)
640
641
642 -- OPSF(I) EXP Bug 2379693 S Brewer 16-JUL-2002 Start(1)
643 -- Added new procedure is_transmitter_final_apprv
644
645 --
646 -- Procedure
647 -- is_transmitter_final_apprv
648 -- Purpose
649 -- History
650 -- 16-Jul-2002 S Brewer Initial Version
651 --
652 PROCEDURE is_transmitter_final_apprv( itemtype IN VARCHAR2,
653 itemkey IN VARCHAR2,
654 actid IN NUMBER,
655 funcmode IN VARCHAR2,
656 result OUT NOCOPY VARCHAR2);
657
658 -- OPSF(I) EXP Bug 2379693 S Brewer 16-JUL-2002 End(1)
659
660 END igi_exp_approval_pkg;