[Home] [Help]
PACKAGE: APPS.PO_CLOSEOUT_PVT
Source
1 PACKAGE PO_CLOSEOUT_PVT AUTHID CURRENT_USER AS
2 --$Header: PO_CLOSEOUT_PVT.pls 120.6.12020000.6 2013/05/09 11:55:14 mabaig noship $
3
4 c_result_type_FATAL CONSTANT VARCHAR2(30) := 'FATAL';
5 c_result_type_FAILURE CONSTANT VARCHAR2(30) := 'ERROR';
6 c_result_type_WARNING CONSTANT VARCHAR2(30) := 'WARNING';
7 c_result_type_SUCCESS CONSTANT VARCHAR2(30) := 'SUCCESS';
8
9 g_CLOSEOUT_TYPE_INDIVIDUAL CONSTANT VARCHAR2(30) := 'INDIVIDUAL';
10 g_CLOSEOUT_TYPE_MASS CONSTANT VARCHAR2(30) := 'MASS';
11
12 -- Read the profile option that enables/disables the debug log
13 g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
14
15
16 --------------------------------------------------------------------------------
17 --Start of Comments
18
19 --Name: create_contract
20
21 --Function:
22 -- This will call out the Contract API to create the contract
23
24 --Parameters:
25
26 --IN:
27 -- p_doc_id NUMBER
28 -- p_closeout_type VARCHAR2
29
30 --OUT:
31 -- x_contract_id NUMBER
32 -- x_contract_ver NUMBER
33 -- x_contract_type VARCHAR2
34 -- x_return_status VARCHAR2
35 -- x_return_msg VARCHAR2
36
37 --End of Comments
38 --------------------------------------------------------------------------------
39
40 PROCEDURE create_contract (
41 p_doc_id IN NUMBER
42 , p_closeout_type IN VARCHAR
43 , x_contract_id OUT NOCOPY NUMBER
44 , x_contract_ver OUT NOCOPY NUMBER
45 , x_contract_type OUT NOCOPY VARCHAR2
46 , x_return_status OUT NOCOPY VARCHAR2
47 , x_return_msg OUT NOCOPY VARCHAR2
48 );
49
50 --------------------------------------------------------------------------------
51 --Start of Comments
52
53 --Name: check_contract_exists
54
55 --Function:
56 -- This will call out the Contract API to check contract exists or not
57
58 --Parameters:
59
60 --IN:
61 -- p_doc_id NUMBER
62 -- p_closeout_type VARCHAR2
63
64 --OUT:
65 -- x_contract_id NUMBER
66 -- x_contract_ver NUMBER
67 -- x_contract_type VARCHAR2
68 -- x_return_status VARCHAR2
69 -- x_return_msg VARCHAR2
70
71 --End of Comments
72 --------------------------------------------------------------------------------
73 PROCEDURE check_contract_exists(
74 p_doc_id IN NUMBER
75 , p_closeout_type IN VARCHAR
76 , x_contract_id OUT NOCOPY NUMBER
77 , x_contract_ver OUT NOCOPY NUMBER
78 , x_contract_type OUT NOCOPY VARCHAR2
79 , x_return_status OUT NOCOPY VARCHAR2
80 , x_return_msg OUT NOCOPY VARCHAR2
81 );
82
83 --------------------------------------------------------------------------------
84 --Start of Comments
85
86 --Name: get_contract
87
88 --Function:
89 -- This will call out the Contract API to check contract exists or not. If
90 -- It contract id not found. It will call the create_contract procedure of
91 -- this package
92
93 --Parameters:
94
95 --IN:
96 -- p_doc_id NUMBER
97 -- p_closeout_type VARCHAR2
98
99 --OUT:
100 -- x_contract_id NUMBER
101 -- x_contract_ver NUMBER
102 -- x_contract_type VARCHAR2
103 -- x_return_status VARCHAR2
104 -- x_return_msg VARCHAR2
105
106 --End of Comments
107 --------------------------------------------------------------------------------
108 PROCEDURE get_contract(
109 p_doc_id IN NUMBER
110 , p_closeout_type IN VARCHAR
111 , x_contract_id OUT NOCOPY NUMBER
112 , x_contract_ver OUT NOCOPY NUMBER
113 , x_contract_type OUT NOCOPY VARCHAR2
114 , x_return_status OUT NOCOPY VARCHAR2
115 , x_return_msg OUT NOCOPY VARCHAR2
116 );
117
118 --------------------------------------------------------------------------------
119 --Start of Comments
120
121 --Name: open_mod_exists
122
123 --Function:
124 -- Checks if there already exists an open modification
125
126 --Parameters:
127
128 --IN:
129 -- p_doc_id NUMBER
130
131 --OUT:
132 --x_result_type Result type of the validation.
133
134 --End of Comments
135 --------------------------------------------------------------------------------
136
137 PROCEDURE open_mod_exists(
138 p_doc_id IN NUMBER
139 , x_result_type OUT NOCOPY VARCHAR2
140 );
141
142 --------------------------------------------------------------------------------
143 --Start of Comments
144
145 --Name: is_doc_fully_received
146
147 --Function:
148 -- Checks if the document is fully receieved
149
150 --Parameters:
151
152 --IN:
153 -- p_doc_id NUMBER
154
155 --OUT:
156 --x_result_type VARCHAR2
157
158 --End of Comments
159 --------------------------------------------------------------------------------
160
161 PROCEDURE is_doc_fully_received (
162 p_doc_id IN NUMBER
163 , x_result_type OUT NOCOPY VARCHAR2
164 );
165
166 --------------------------------------------------------------------------------
167 --Start of Comments
168
169 --Name: is_doc_fully_invoiced
170
171 --Function:
172 -- Checks if the document is fully invoiced
173
174 --Parameters:
175
176 --IN:
177 -- p_doc_id NUMBER
178
179 --OUT:
180 --x_result_type VARCHAR2
181
182 --End of Comments
183 --------------------------------------------------------------------------------
184
185 PROCEDURE is_doc_fully_invoiced (
186 p_doc_id IN NUMBER
187 , x_result_type OUT NOCOPY VARCHAR2
188 );
189
190 --------------------------------------------------------------------------------
191 --Start of Comments
192
193 --Name: is_doc_fully_paid
194
195 --Function:
196 -- Checks if the document is fully paid
197
198 --Parameters:
199
200 --IN:
201 -- p_doc_id NUMBER
202
203 --OUT:
204 --x_result_type VARCHAR2
205
206 --End of Comments
207 --------------------------------------------------------------------------------
208
209 PROCEDURE is_doc_fully_paid (
210 p_doc_id IN NUMBER
211 , x_result_type OUT NOCOPY VARCHAR2
212 );
213
214 --------------------------------------------------------------------------------
215 --Start of Comments
216
217 --Name: chklist_task_available
218
219 --Function:
220 -- Check if there are any checklists/tasks are available
221
222 --Parameters:
223
224 --IN:
225 -- p_doc_id NUMBER
226
227 --OUT:
228 --x_result_type VARCHAR2
229
230 --End of Comments
231 --------------------------------------------------------------------------------
232
233 PROCEDURE chklist_task_available (
234 p_doc_id IN NUMBER
235 , x_result_type OUT NOCOPY VARCHAR2
236 );
237
238 --------------------------------------------------------------------------------
239 --Start of Comments
240
241 --Name: validate_manage_closeout
242
243 --Function:
244 -- Validate the Manage Closeout action
245
246 --Parameters:
247
248 --IN:
249 -- p_doc_id NUMBER
250 -- p_chk_list_req VARCHAR2
251
252 --OUT:
253 --x_result_type VARCHAR2
254 --x_results PO_MULTI_MOD_VAL_RESULTS_TYPE
255
256 --End of Comments
257 --------------------------------------------------------------------------------
258
259 PROCEDURE validate_manage_closeout (
260 p_doc_id IN NUMBER
261 , p_chk_list_req IN VARCHAR2
262 , x_result_type OUT NOCOPY VARCHAR2
263 , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
264 );
265
266 --------------------------------------------------------------------------------
267 --Start of Comments
268
269 --Name: check_exceptions
270
271 --Function:
272 -- Validate the Mass Closeout documents
273
274 --Parameters:
275
276 --IN:
277 -- p_doc_id NUMBER
278 -- p_chk_list_req VARCHAR2
279
280 --OUT:
281 --x_result_type VARCHAR2
282
283 --End of Comments
284 --------------------------------------------------------------------------------
285
286 PROCEDURE check_exceptions (
287 p_req_id IN NUMBER
288 , p_chk_list_req IN VARCHAR2
289 , x_result_type OUT NOCOPY VARCHAR2
290 );
291
292 --------------------------------------------------------------------------------
293 --Start of Comments
294
295 --Name: mass_closeout_submit
296
297 --Function:
298 -- Process Mass Closeout action.
299
300 --Parameters:
301
302 --IN:
303 -- p_doc_id NUMBER
304
305 --OUT:
306 -- errbuf VARCHAR2
307 -- retcode VARCHAR2
308
309 --End of Comments
310 --------------------------------------------------------------------------------
311
312 PROCEDURE mass_closeout_submit (
313 errbuf OUT NOCOPY VARCHAR2
314 , retcode OUT NOCOPY VARCHAR2
315 , p_req_id IN NUMBER
316 );
317
318 --------------------------------------------------------------------------------
319 --Start of Comments
320
321 --Name: mass_closeout_validate_set
322
323 --Function:
324 -- Validates the selected documents.
325
326 --Parameters:
327
328 --IN:
329 -- p_selected_docs NUMBER
330
331 --OUT:
332 -- x_failed_docs VARCHAR2
333 -- x_result_type VARCHAR2
334
335 --End of Comments
336 --------------------------------------------------------------------------------
337
338 PROCEDURE mass_closeout_validate_set (
339 p_selected_docs IN PO_TBL_NUMBER
340 , x_failed_docs OUT NOCOPY VARCHAR2
341 , x_result_type OUT NOCOPY VARCHAR2
342 );
343
344 --------------------------------------------------------------------------------
345 --Start of Comments
346
347 --Name: validate_mass_closeout
348
349 --Function:
350 -- Validate the Mass Closeout action
351
352 --Parameters:
353
354 --IN:
355 -- p_req_id NUMBER
356 -- p_chk_list_req VARCHAR2
357
358 --OUT:
359 -- errbuf VARCHAR2
360 -- retcode VARCHAR2
361
362 --End of Comments
363 --------------------------------------------------------------------------------
364
365 PROCEDURE validate_mass_closeout (
366 errbuf OUT NOCOPY VARCHAR2
367 , retcode OUT NOCOPY VARCHAR2
368 , p_req_id IN NUMBER
369 , p_chk_list_req IN VARCHAR2
370 );
371
372 --------------------------------------------------------------------------------
373 --Start of Comments
374
375 --Name: eligible_docs_for_closeout
376
377 --Function:
378 -- Retrieve the eligible documents for closeout
379
380 --Parameters:
381
382 --OUT:
383 -- errbuf VARCHAR2
384 -- retcode VARCHAR2
385
386 --End of Comments
387 --------------------------------------------------------------------------------
388
389 PROCEDURE eligible_docs_for_closeout (
390 errbuf OUT NOCOPY VARCHAR2
391 , retcode OUT NOCOPY VARCHAR2
392 );
393
394 --------------------------------------------------------------------------------
395 --Start of Comments
396
397 --Name: get_val_notfn_body
401
398
399 --Function:
400 -- Get the notification body for the task list activation error and PDF generation error.
402 --Parameters:
403
404 --IN:
405 --messages IN VARCHAR2,
406 --display_type IN VARCHAR2,
407 --document IN OUT NOCOPY CLOB,
408 --document_type IN OUT NOCOPY VARCHAR2
409
410
411 -- OUT:
412
413 --End of Comments
414 --------------------------------------------------------------------------------
415
416 PROCEDURE get_eligible_doc_notfn_body
417 (
418 messages IN VARCHAR2,
419 display_type IN VARCHAR2,
420 document IN OUT NOCOPY CLOB,
421 document_type IN OUT NOCOPY VARCHAR2
422 ) ;
423
424 --------------------------------------------------------------------------------
425 --Start of Comments
426
427 --Name: store_validations
428
429 --Function:
430 -- Inserts the validation record into po_multi_mod_val_results
431
432 --Parameters:
433
434 --IN:
435 -- p_doc_id NUMBER
436 -- p_doc_num VARCHAR2
437 -- p_mod_doc_id NUMBER
438 -- p_req_id VARCHAR2
439 -- p_exception_type VARCHAR2
440 -- p_message_app VARCHAR2
441 -- p_message_name VARCHAR2
442 -- p_validation_type VARCHAR2
443 -- p_token_name1 VARCHAR2
444 -- p_token_value1 VARCHAR2
445 -- p_token_name2 VARCHAR2
446 -- p_token_value2 VARCHAR2
447 -- p_token_name3 VARCHAR2
448 -- p_token_value3 VARCHAR2
449 -- p_token_name4 VARCHAR2
450 -- p_token_value4 VARCHAR2
451 -- p_token_name5 VARCHAR2
452 -- p_token_value5 VARCHAR2
453
454 --OUT:
455 --x_result_type VARCHAR2
456
457 --End of Comments
458 --------------------------------------------------------------------------------
459 PROCEDURE store_validations (
460 p_doc_id IN NUMBER
461 , p_doc_num IN VARCHAR2
462 , p_mod_doc_id IN NUMBER
463 , p_req_id IN NUMBER
464 , p_exception_type IN VARCHAR2
465 , p_message_app IN VARCHAR2
466 , p_message_name IN VARCHAR2
467 , p_validation_type IN VARCHAR2
468 , p_token_name1 IN VARCHAR2 DEFAULT NULL
469 , p_token_value1 IN VARCHAR2 DEFAULT NULL
470 , p_token_name2 IN VARCHAR2 DEFAULT NULL
471 , p_token_value2 IN VARCHAR2 DEFAULT NULL
472 , p_token_name3 IN VARCHAR2 DEFAULT NULL
473 , p_token_value3 IN VARCHAR2 DEFAULT NULL
474 , p_token_name4 IN VARCHAR2 DEFAULT NULL
475 , p_token_value4 IN VARCHAR2 DEFAULT NULL
476 , p_token_name5 IN VARCHAR2 DEFAULT NULL
477 , p_token_value5 IN VARCHAR2 DEFAULT NULL
478 );
479
480 --------------------------------------------------------------------------------
481 --Start of Comments
482
483 --Name: delete_contract
484
485 --Function:
486 -- Deletes the contract if exist
487
488 --Parameters:
489
490 --IN:
491 -- p_doc_id NUMBER
492 -- p_closeout_type VARCHAR2
493
494 --OUT:
495 -- x_return_status VARCHAR2
496 -- x_return_msg VARCHAR2
497
498 --End of Comments
499 --------------------------------------------------------------------------------
500 procedure delete_contract (
501 p_doc_id IN NUMBER
502 , p_closeout_type IN VARCHAR
503 , x_return_status OUT NOCOPY VARCHAR2
504 , x_return_msg OUT NOCOPY VARCHAR2
505 );
506
507 --------------------------------------------------------------------------------
508 --Start of Comments
509
510 --Name: set_closeout_status
511
512 --Function:
513 -- Set the closeout status. This will get called from Closeout workflow.
514 -- Reads the status value from WF attribute.
515
516 --Parameters:
517
518 --IN:
519 -- itemtype NUMBER
520 -- itemkey VARCHAR2
521 -- actid NUMBER
522 -- funcmode VARCHAR2
523
524 --OUT:
525 --resultout VARCHAR2
526
527 --End of Comments
528 --------------------------------------------------------------------------------
529
530 PROCEDURE set_closeout_status (
531 itemtype IN VARCHAR2
532 , itemkey IN VARCHAR2
533 , actid IN NUMBER
534 , funcmode IN VARCHAR2
535 , resultout OUT NOCOPY VARCHAR2
536 );
537
538 --------------------------------------------------------------------------------
539 --Start of Comments
540
541 --Name: Validate_Document
542
543 --Function:
544 -- Validate the Manage Closeout from WF. It is wrapper for the procedure
545 -- "validate_manage_closeout"
546
547 --Parameters:
548
549 --IN:
550 -- itemtype NUMBER
551 -- itemkey VARCHAR2
552 -- actid NUMBER
553 -- funcmode VARCHAR2
554
555 --OUT:
556 --resultout VARCHAR2
557
558 --End of Comments
559 --------------------------------------------------------------------------------
560
561 PROCEDURE Validate_Document (
562 itemtype IN VARCHAR2
563 , itemkey IN VARCHAR2
564 , actid IN NUMBER
565 , funcmode IN VARCHAR2
566 , resultout OUT NOCOPY VARCHAR2
567 );
568
569 --------------------------------------------------------------------------------
573
570 --Start of Comments
571
572 --Name: Activate_task_list
574 --Function:
575 -- Activating the Contract's Task list
576
577 --Parameters:
578
579 --IN:
580 -- itemtype NUMBER
581 -- itemkey VARCHAR2
582 -- actid NUMBER
583 -- funcmode VARCHAR2
584
585 --OUT:
586 --resultout VARCHAR2
587
588 --End of Comments
589 --------------------------------------------------------------------------------
590
591 PROCEDURE Activate_tasks_list (
592 itemtype IN VARCHAR2
593 , itemkey IN VARCHAR2
594 , actid IN NUMBER
595 , funcmode IN VARCHAR2
596 , resultout OUT NOCOPY VARCHAR2
597 );
598
599
600 --------------------------------------------------------------------------------
601 --Start of Comments
602
603 --Name: Set_Doc_TO_Prev_State
604
605 --Function:
606 -- Set the document to the previuous state as its error while activating the Contract's Task list
607
608 --Parameters:
609
610 --IN:
611 -- itemtype NUMBER
612 -- itemkey VARCHAR2
613 -- actid NUMBER
614 -- funcmode VARCHAR2
615
616 --OUT:
617 --resultout VARCHAR2
618
619 --End of Comments
620 --------------------------------------------------------------------------------
621
622 PROCEDURE Set_Doc_TO_Prev_State (
623 itemtype IN VARCHAR2
624 , itemkey IN VARCHAR2
625 , actid IN NUMBER
626 , funcmode IN VARCHAR2
627 , resultout OUT NOCOPY VARCHAR2
628 );
629
630 --------------------------------------------------------------------------------
631 --Start of Comments
632
633 --Name: Set_Notification_Message
634
635 --Function:
636 -- Set the subject and the body for the notification based on the MessageType attribute.
637
638 --Parameters:
639
640 --IN:
641 -- itemtype NUMBER
642 -- itemkey VARCHAR2
643 -- actid NUMBER
644 -- funcmode VARCHAR2
645
646 --OUT:
647 --resultout VARCHAR2
648
649 --End of Comments
650 --------------------------------------------------------------------------------
651
652 PROCEDURE Set_Notification_Message (
653 itemtype IN VARCHAR2
654 , itemkey IN VARCHAR2
655 , actid IN NUMBER
656 , funcmode IN VARCHAR2
657 , resultout OUT NOCOPY VARCHAR2
658 );
659
660 --------------------------------------------------------------------------------
661 --Start of Comments
662
663 --Name: IS_STATUS_PHYSICAL_COMPLETE
664
665 --Function:
666 -- Activating the Contract's Task list
667
668 --Parameters:
669
670 --IN:
671 -- itemtype NUMBER
672 -- itemkey VARCHAR2
673 -- actid NUMBER
674 -- funcmode VARCHAR2
675
676 --OUT:
677 --resultout VARCHAR2
678
679 --End of Comments
680 --------------------------------------------------------------------------------
681
682 PROCEDURE IS_STATUS_PHYSICAL_COMPLETE (
683 itemtype IN VARCHAR2
684 , itemkey IN VARCHAR2
685 , actid IN NUMBER
686 , funcmode IN VARCHAR2
687 , resultout OUT NOCOPY VARCHAR2
688 );
689
690 --------------------------------------------------------------------------------
691 --Start of Comments
692
693 --Name: start_closeout_wf_process
694
695 --Function:
696 -- Starts the Closeout WF process and the sets the attributes
697
698 --End of Comments
699 --------------------------------------------------------------------------------
700
701 PROCEDURE start_closeout_wf_process (
702 p_doc_id IN NUMBER ,
703 x_return_status OUT NOCOPY VARCHAR2
704 );
705
706
707 --------------------------------------------------------------------------------
708 --Start of Comments
709
710 --Name: Generate_Closeout_PDF
711
712 --Function:
713 -- Generate Closeout PDFs CCS and CheckList"
714
715 --Parameters:
716
717 --IN:
718 -- itemtype NUMBER
719 -- itemkey VARCHAR2
720 -- actid NUMBER
721 -- funcmode VARCHAR2
722
723 --OUT:
724 --resultout VARCHAR2
725
726 --End of Comments
727 --------------------------------------------------------------------------------
728 PROCEDURE Generate_Closeout_PDF (
729 itemtype IN VARCHAR2
730 , itemkey IN VARCHAR2
731 , actid IN NUMBER
732 , funcmode IN VARCHAR2
733 , resultout OUT NOCOPY VARCHAR2
734 ) ;
735
736
737 --------------------------------------------------------------------------------
738 --Start of Comments
739
740 --Name: get_val_notfn_body
741
742 --Function:
743 -- Get the notification body for the task list activation error and PDF generation error.
744
745 --Parameters:
746
747 --IN:
748 --messages IN VARCHAR2,
749 --display_type IN VARCHAR2,
750 --document IN OUT NOCOPY CLOB,
751 --document_type IN OUT NOCOPY VARCHAR2
752
753
754 -- OUT:
755
756 --End of Comments
760 (
757 --------------------------------------------------------------------------------
758
759 PROCEDURE get_val_notfn_body
761 messages IN VARCHAR2,
762 display_type IN VARCHAR2,
763 document IN OUT NOCOPY CLOB,
764 document_type IN OUT NOCOPY VARCHAR2
765 ) ;
766
767
768
769 --------------------------------------------------------------------------------
770 --Start of Comments
771
772 --Name: get_val_notfn_body
773
774 --Function:
775 -- Get the notification body for the task list activation error and PDF generation error.
776
777 --Parameters:
778
779 --IN:
780 --messages IN VARCHAR2,
781 --display_type IN VARCHAR2,
782 --document IN OUT NOCOPY CLOB,
783 --document_type IN OUT NOCOPY VARCHAR2
784
785
786 -- OUT:
787
788 --End of Comments
789 --------------------------------------------------------------------------------
790
791 PROCEDURE get_clsout_err_msg_body
792 (
793 message_type IN VARCHAR2,
794 display_type IN VARCHAR2,
795 document IN OUT NOCOPY CLOB,
796 document_type IN OUT NOCOPY VARCHAR2
797 ) ;
798
799
800 --------------------------------------------------------------------------------
801 --Start of Comments
802
803 --Name: get_sign_notfn_body
804
805 --Function:
806 -- Get the signer name based on the input p_signer_type.
807
808 --Parameters:
809
810 --IN:
811 -- itemtype VARCHAR2
812 -- itemkey VARCHAR2
813 -- p_signer_type VARCHAR2
814
815 --OUT:
816 --resultout VARCHAR2
817
818 --End of Comments
819 --------------------------------------------------------------------------------
820
821 PROCEDURE get_sign_notfn_body
822 (
823 document_id IN VARCHAR2,
824 display_type IN VARCHAR2,
825 document IN OUT NOCOPY CLOB,
826 document_type IN OUT NOCOPY VARCHAR2
827 );
828
829
830 --------------------------------------------------------------------------------
831 --Start of Comments
832
833 --Name: get_closeout_pdf
834
835 --Function:
836 -- Get the pdf blob and write to the clob
837
838 --Parameters:
839
840 --IN:
841 --messages IN VARCHAR2,
842 --display_type IN VARCHAR2,
843 --document IN OUT NOCOPY CLOB,
844 --document_type IN OUT NOCOPY VARCHAR2
845
846
847 -- OUT:
848
849 --End of Comments
850 --------------------------------------------------------------------------------
851 PROCEDURE get_closeout_pdf
852 (
853 document_id IN VARCHAR2,
854 display_type IN VARCHAR2,
855 document IN OUT NOCOPY BLOB,
856 document_type IN OUT NOCOPY VARCHAR2
857 ) ;
858
859
860
861 -------------------------------------------------------------------------------
862 --Start of Comments
863 --Name: POCLSOUT_SELECTOR
864 --Pre-reqs:
865 -- None.
866 --Modifies:
867 -- Application user id
868 -- Application responsibility id
869 -- Application application id
870 --Locks:
871 -- None.
872 --Function:
873 -- This procedure sets the correct application context when a process is
874 -- picked up by the workflow background engine. When called in
875 -- TEST_CTX mode it compares workflow attribute org id with the current
876 -- org id and workflow attributes user id, responsibility id and
877 -- application id with their corresponding profile values. It returns TRUE
878 -- if these values match and FALSE otherwise. When called in SET_CTX mode
879 -- it sets the correct apps context based on workflow parameters.
880 --Parameters:
881 --IN:
882 --p_itemtype
883 -- Specifies the itemtype of the workflow process
884 --p_itemkey
885 -- Specifies the itemkey of the workflow process
886 --p_actid
887 -- activity id passed by the workflow
888 --p_funcmode
889 -- Input values can be TEST_CTX or SET_CTX (RUN not implemented)
890 -- TEST_CTX to test if current context is correct
891 -- SET_CTX to set the correct context if current context is wrong
892 --IN OUT:
893 --p_x_result
894 -- For TEST_CTX a TRUE value means that the context is correct and
895 -- SET_CTX need not be called. A FALSE value means that current context
896 -- is incorrect and SET_CTX need to set correct context
897 --Testing:
898 -- There is not script to test this procedure but the correct functioning
899 -- may be tested by verifying from the debug_message in table po_wf_debug
900 -- that if at any time the workflow process gets started with a wrong
901 -- context then the selector is called in TEST_CTX and SET_CTX modes and
902 -- correct context is set.
903 --End of Comments
904 -------------------------------------------------------------------------------
905 PROCEDURE Poclsout_selector
906 (
907 p_itemtype IN VARCHAR2,
908 p_itemkey IN VARCHAR2,
909 p_actid IN NUMBER,
910 p_funcmode IN VARCHAR2,
911 p_x_result IN OUT nocopy VARCHAR2
912 );
913
914
915 --------------------------------------------------------------------------------
916 --Start of Comments
917
918 --Name: set_checklist_signed_date
919
920 --Function:
921 -- Set the checklist signed date
922
923 --Parameters:
924
925 --IN:
926 -- itemtype NUMBER
927 -- itemkey VARCHAR2
928 -- actid NUMBER
929 -- funcmode VARCHAR2
930
931 --OUT:
932 --resultout VARCHAR2
933
934 --End of Comments
935 --------------------------------------------------------------------------------
936 PROCEDURE set_checklist_signed_date (
937 itemtype IN VARCHAR2
938 , itemkey IN VARCHAR2
939 , actid IN NUMBER
940 , funcmode IN VARCHAR2
941 , resultout OUT NOCOPY VARCHAR2
942 ) ;
943
944
945
946
947 END PO_CLOSEOUT_PVT;
948