[Home] [Help]
PACKAGE BODY: APPS.PJM_SCHED_INT_WF_PRIV
Source
1 PACKAGE BODY PJM_SCHED_INT_WF_PRIV AS
2 /* $Header: PJMSIWPB.pls 115.8 2003/04/10 21:46:42 alaw ship $ */
3 -- ---------------------------------------------------------------------
4 -- Private Functions / Procedures
5 -- ---------------------------------------------------------------------
6
7 /*---------------------------------------------------------------------------
8 Workflow common start procedure
9 ---------------------------------------------------------------------------*/
10
11 PROCEDURE common_start(c_item_type varchar2
12 ,c_item_key varchar2
13 ,c_process varchar2
14 ,c_owner varchar2
15 ,c_requestor varchar2
16 ,n_tolerance_days number
17 ,c_ntf_proj_mgr varchar2
18 ,c_ntf_task_mgr varchar2
19 ,c_project_number varchar2
20 ,c_project_name varchar2
21 ,d_project_start_date date
22 ,d_project_end_date date
23 ,c_task_number varchar2
24 ,c_task_name varchar2
25 ,d_task_start_date date
26 ,d_task_end_date date
27 ,c_exception_subject varchar2
28 ,c_exception_body varchar2
29 ,c_document_type varchar2
30 ,c_item_number varchar2
31 ,c_item_description varchar2
32 ) is
33 c_project_manager varchar2(80) :='';
34 c_task_manager varchar2(80) :='';
35
36 BEGIN
37
38 if c_ntf_proj_mgr='Y' then
39 c_project_manager:= PJM_INTEGRATION_PROJ_MFG.PJM_SELECT_PROJECT_MANAGER(
40 PJM_PROJECT.val_proj_numtoid(c_project_number));
41 if c_project_manager = c_requestor then
42 c_project_manager:='';
43 end if;
44 end if;
45
46 if c_ntf_task_mgr='Y' then
47 c_task_manager:= PJM_INTEGRATION_PROJ_MFG.PJM_SELECT_TASK_MANAGER(
48 PJM_PROJECT.val_task_numtoid(c_project_number, c_task_number));
49 if c_task_manager = c_requestor then
50 c_task_manager:='';
51 end if;
52 end if;
53
54 wf_purge.total(c_item_type,c_item_key,sysdate);
55
56 begin
57 wf_engine.CreateProcess(itemtype => c_item_type
58 ,itemkey => c_item_key
59 ,process => c_process
60 );
61 exception
62 when others then
63 PJM_CONC.put_line( sqlerrm );
64 null;
65 end;
66
67 wf_engine.SetItemOwner(itemtype => c_item_type
68 ,itemkey => c_item_key
69 ,owner => c_owner
70 );
71
72 wf_engine.SetItemAttrText(itemtype => c_item_type
73 ,itemkey => c_item_key
74 ,aname => 'REQUESTOR'
75 ,avalue => c_requestor
76 );
77
78 wf_engine.SetItemAttrText(itemtype => c_item_type
79 ,itemkey => c_item_key
80 ,aname => 'TOLERANCE_DAYS'
81 ,avalue => n_tolerance_days
82 );
83
84 wf_engine.SetItemAttrText(itemtype => c_item_type
85 ,itemkey => c_item_key
86 ,aname => 'PROJECT_NUMBER'
87 ,avalue => c_project_number
88 );
89
90 wf_engine.SetItemAttrText(itemtype => c_item_type
91 ,itemkey => c_item_key
92 ,aname => 'PROJECT_NAME'
93 ,avalue => c_project_name
94 );
95
96 wf_engine.SetItemAttrText(itemtype => c_item_type
97 ,itemkey => c_item_key
98 ,aname => 'PROJECT_START_DATE'
99 ,avalue => d_project_start_date
100 );
101
102 wf_engine.SetItemAttrText(itemtype => c_item_type
103 ,itemkey => c_item_key
104 ,aname => 'PROJECT_END_DATE'
105 ,avalue => d_project_end_date
106 );
107
108 wf_engine.SetItemAttrText(itemtype => c_item_type
109 ,itemkey => c_item_key
110 ,aname => 'TASK_NUMBER'
111 ,avalue => c_task_number
112 );
113
114 wf_engine.SetItemAttrText(itemtype => c_item_type
115 ,itemkey => c_item_key
116 ,aname => 'TASK_NAME'
117 ,avalue => c_task_name
118 );
119
120 wf_engine.SetItemAttrText(itemtype => c_item_type
121 ,itemkey => c_item_key
122 ,aname => 'TASK_START_DATE'
123 ,avalue => d_task_start_date
124 );
125
126 wf_engine.SetItemAttrText(itemtype => c_item_type
127 ,itemkey => c_item_key
128 ,aname => 'TASK_END_DATE'
129 ,avalue => d_task_end_date
130 );
131
132 wf_engine.SetItemAttrText(itemtype => c_item_type
133 ,itemkey => c_item_key
134 ,aname => 'PROJECT_MANAGER'
135 ,avalue => c_project_manager
136 );
137 wf_engine.SetItemAttrText(itemtype => c_item_type
138 ,itemkey => c_item_key
139 ,aname => 'TASK_MANAGER'
140 ,avalue => c_task_manager
141 );
142
143
144 wf_engine.SetItemAttrText(itemtype => c_item_type
145 ,itemkey => c_item_key
146 ,aname => 'EXCEPTION_SUBJECT'
147 ,avalue => c_exception_subject
148 );
149
150 wf_engine.SetItemAttrText(itemtype => c_item_type
151 ,itemkey => c_item_key
152 ,aname => 'EXCEPTION_BODY'
153 ,avalue => c_exception_body
154 );
155
156 wf_engine.SetItemAttrText(itemtype => c_item_type
157 ,itemkey => c_item_key
158 ,aname => 'DOCUMENT_TYPE'
159 ,avalue => c_document_type
160 );
161
162 wf_engine.SetItemAttrText(itemtype => c_item_type
163 ,itemkey => c_item_key
164 ,aname => 'ITEM_NUMBER'
165 ,avalue => c_item_number
166 );
167
168 wf_engine.SetItemAttrText(itemtype => c_item_type
169 ,itemkey => c_item_key
170 ,aname => 'ITEM_DESCRIPTION'
171 ,avalue => c_item_description
172 );
173
174 END;
175
176
177 /*---------------------------------------------------------------------------
178 For WIP exception process
179 ---------------------------------------------------------------------------*/
180
181 PROCEDURE launch_wip(c_item_type varchar2
182 ,c_item_key varchar2
183 ,c_process varchar2
184 ,c_owner varchar2
185 ,c_requestor varchar2
186 ,n_tolerance_days number
187 ,c_ntf_proj_mgr varchar2
188 ,c_ntf_task_mgr varchar2
189 ,c_project_number varchar2
190 ,c_project_name varchar2
191 ,d_project_start_date date
192 ,d_project_end_date date
193 ,c_task_number varchar2
194 ,c_task_name varchar2
195 ,d_task_start_date date
196 ,d_task_end_date date
197 ,c_exception_subject varchar2
198 ,c_exception_body varchar2
199 ,c_document_type varchar2
200 ,c_item_number varchar2
201 ,c_item_description varchar2
202 ,c_wip_job_name varchar2
203 ,c_organization_name varchar2
204 ,d_job_start_date date
205 ,d_job_end_date date
206 ,c_status varchar2
207 ,c_job_type varchar2
208 ,n_start_quantity number
209 ,n_quantity_completed number
210 ) is
211 BEGIN
212 common_start(c_item_type
213 ,c_item_key
214 ,c_process
215 ,c_owner
216 ,c_requestor
217 ,n_tolerance_days
218 ,c_ntf_proj_mgr
219 ,c_ntf_task_mgr
220 ,c_project_number
221 ,c_project_name
222 ,d_project_start_date
223 ,d_project_end_date
224 ,c_task_number
225 ,c_task_name
226 ,d_task_start_date
227 ,d_task_end_date
228 ,c_exception_subject
229 ,c_exception_body
230 ,c_document_type
231 ,c_item_number
232 ,c_item_description
233 );
234
235 wf_engine.SetItemAttrText(itemtype => c_item_type
236 ,itemkey => c_item_key
237 ,aname => 'WIP_JOB_NAME'
238 ,avalue => c_wip_job_name
239 );
240
241 wf_engine.SetItemAttrText(itemtype => c_item_type
242 ,itemkey => c_item_key
243 ,aname => 'ORGANIZATION_NAME'
244 ,avalue => c_organization_name
245 );
246
247 wf_engine.SetItemAttrText(itemtype => c_item_type
248 ,itemkey => c_item_key
249 ,aname => 'JOB_START_DATE'
250 ,avalue => d_job_start_date
251 );
252
253 wf_engine.SetItemAttrText(itemtype => c_item_type
254 ,itemkey => c_item_key
255 ,aname => 'JOB_END_DATE'
256 ,avalue => d_job_end_date
257 );
258
259 wf_engine.SetItemAttrText(itemtype => c_item_type
260 ,itemkey => c_item_key
261 ,aname => 'STATUS'
262 ,avalue => c_status
263 );
264
265 wf_engine.SetItemAttrText(itemtype => c_item_type
266 ,itemkey => c_item_key
267 ,aname => 'JOB_TYPE'
268 ,avalue => c_job_type
269 );
270
271 wf_engine.SetItemAttrText(itemtype => c_item_type
272 ,itemkey => c_item_key
273 ,aname => 'START_QUANTITY'
274 ,avalue => n_start_quantity
275 );
276
277 wf_engine.SetItemAttrText(itemtype => c_item_type
278 ,itemkey => c_item_key
279 ,aname => 'QUANTITY_COMPLETED'
280 ,avalue => n_quantity_completed
281 );
282
283 wf_engine.StartProcess (itemtype => c_item_type
284 ,itemkey => c_item_key
285 );
286 END;
287
288 /*---------------------------------------------------------------------------
289 For SO exception process
290 ---------------------------------------------------------------------------*/
291 PROCEDURE launch_so (c_item_type varchar2
292 ,c_item_key varchar2
293 ,c_process varchar2
294 ,c_owner varchar2
295 ,c_requestor varchar2
296 ,n_tolerance_days number
297 ,c_ntf_proj_mgr varchar2
298 ,c_ntf_task_mgr varchar2
299 ,c_project_number varchar2
300 ,c_project_name varchar2
301 ,d_project_start_date date
302 ,d_project_end_date date
303 ,c_task_number varchar2
304 ,c_task_name varchar2
305 ,d_task_start_date date
306 ,d_task_end_date date
307 ,c_exception_subject varchar2
308 ,c_exception_body varchar2
309 ,c_document_type varchar2
310 ,c_item_number varchar2
311 ,c_item_description varchar2
312 ,c_so_number number
313 ,c_line_number number
314 ,c_warehouse varchar2
315 ,n_quantity number
316 ,d_requested_date date
317 ,d_promised_date date
318 ) is
319 BEGIN
320 common_start(c_item_type
321 ,c_item_key
322 ,c_process
323 ,c_owner
324 ,c_requestor
325 ,n_tolerance_days
326 ,c_ntf_proj_mgr
327 ,c_ntf_task_mgr
328 ,c_project_number
329 ,c_project_name
330 ,d_project_start_date
331 ,d_project_end_date
332 ,c_task_number
333 ,c_task_name
334 ,d_task_start_date
335 ,d_task_end_date
336 ,c_exception_subject
337 ,c_exception_body
338 ,c_document_type
339 ,c_item_number
340 ,c_item_description
341 );
342
343 wf_engine.SetItemAttrText(itemtype => c_item_type
344 ,itemkey => c_item_key
345 ,aname => 'SO_NUMBER'
346 ,avalue => c_so_number
347 );
348
349 wf_engine.SetItemAttrText(itemtype => c_item_type
350 ,itemkey => c_item_key
351 ,aname => 'LINE_NUMBER'
352 ,avalue => c_line_number
353 );
354
355 wf_engine.SetItemAttrText(itemtype => c_item_type
356 ,itemkey => c_item_key
357 ,aname => 'WAREHOUSE'
358 ,avalue => c_warehouse
359 );
360
361 wf_engine.SetItemAttrText(itemtype => c_item_type
362 ,itemkey => c_item_key
363 ,aname => 'QUANTITY'
364 ,avalue => n_quantity
365 );
366
367 wf_engine.SetItemAttrText(itemtype => c_item_type
368 ,itemkey => c_item_key
369 ,aname => 'REQUESTED_DATE'
370 ,avalue => d_requested_date
371 );
372
373 wf_engine.SetItemAttrText(itemtype => c_item_type
374 ,itemkey => c_item_key
375 ,aname => 'PROMISED_DATE'
376 ,avalue => d_promised_date
377 );
378
379 wf_engine.StartProcess (itemtype => c_item_type
380 ,itemkey => c_item_key
381 );
382 END;
383
384 /*---------------------------------------------------------------------------
385 For FORECAST exception process
386 ---------------------------------------------------------------------------*/
387 PROCEDURE launch_forecast(c_item_type varchar2
388 ,c_item_key varchar2
389 ,c_process varchar2
390 ,c_owner varchar2
391 ,c_requestor varchar2
392 ,n_tolerance_days number
393 ,c_ntf_proj_mgr varchar2
394 ,c_ntf_task_mgr varchar2
395 ,c_project_number varchar2
396 ,c_project_name varchar2
397 ,d_project_start_date date
398 ,d_project_end_date date
399 ,c_task_number varchar2
400 ,c_task_name varchar2
401 ,d_task_start_date date
402 ,d_task_end_date date
403 ,c_exception_subject varchar2
404 ,c_exception_body varchar2
405 ,c_document_type varchar2
406 ,c_item_number varchar2
407 ,c_item_description varchar2
408 ,c_forecast_set varchar2
409 ,c_forecast_name varchar2
410 ,c_organization_name varchar2
411 ,n_quantity number
412 ,d_forecast_start_date date
413 ,d_forecast_end_date date
414 ) is
415 BEGIN
416 common_start(c_item_type
417 ,c_item_key
418 ,c_process
419 ,c_owner
420 ,c_requestor
421 ,n_tolerance_days
422 ,c_ntf_proj_mgr
423 ,c_ntf_task_mgr
424 ,c_project_number
425 ,c_project_name
426 ,d_project_start_date
427 ,d_project_end_date
428 ,c_task_number
429 ,c_task_name
430 ,d_task_start_date
431 ,d_task_end_date
432 ,c_exception_subject
433 ,c_exception_body
434 ,c_document_type
435 ,c_item_number
436 ,c_item_description
437 );
438
439 wf_engine.SetItemAttrText(itemtype => c_item_type
440 ,itemkey => c_item_key
441 ,aname => 'FORECAST_SET'
442 ,avalue => c_forecast_set
443 );
444
445 wf_engine.SetItemAttrText(itemtype => c_item_type
446 ,itemkey => c_item_key
447 ,aname => 'FORECAST_NAME'
448 ,avalue => c_forecast_name
449 );
450
451 wf_engine.SetItemAttrText(itemtype => c_item_type
452 ,itemkey => c_item_key
453 ,aname => 'ORGANIZATION_NAME'
454 ,avalue => c_organization_name
455 );
456
457 wf_engine.SetItemAttrText(itemtype => c_item_type
458 ,itemkey => c_item_key
459 ,aname => 'QUANTITY'
460 ,avalue => n_quantity
461 );
462
463 wf_engine.SetItemAttrText(itemtype => c_item_type
464 ,itemkey => c_item_key
465 ,aname => 'FORECAST_START_DATE'
466 ,avalue => d_forecast_start_date
467 );
468
469 wf_engine.SetItemAttrText(itemtype => c_item_type
470 ,itemkey => c_item_key
471 ,aname => 'FORECAST_END_DATE'
472 ,avalue => d_forecast_end_date
473 );
474
475 wf_engine.StartProcess (itemtype => c_item_type
476 ,itemkey => c_item_key
477 );
478 END;
479
480 /*---------------------------------------------------------------------------
481 For PR exception process
482 ---------------------------------------------------------------------------*/
483 PROCEDURE launch_pr (c_item_type varchar2
484 ,c_item_key varchar2
485 ,c_process varchar2
486 ,c_owner varchar2
487 ,c_requestor varchar2
488 ,n_tolerance_days number
489 ,c_ntf_proj_mgr varchar2
490 ,c_ntf_task_mgr varchar2
491 ,c_project_number varchar2
492 ,c_project_name varchar2
493 ,d_project_start_date date
494 ,d_project_end_date date
495 ,c_task_number varchar2
496 ,c_task_name varchar2
497 ,d_task_start_date date
498 ,d_task_end_date date
499 ,c_exception_subject varchar2
500 ,c_exception_body varchar2
501 ,c_document_type varchar2
502 ,c_item_number varchar2
503 ,c_item_description varchar2
504 ,c_pr_number varchar2
505 ,c_ship_to_location varchar2
506 ,c_status varchar2
507 ,n_quantity number
508 ,d_need_by_date date
509 ) is
510 BEGIN
511 common_start(c_item_type
512 ,c_item_key
513 ,c_process
514 ,c_owner
515 ,c_requestor
516 ,n_tolerance_days
517 ,c_ntf_proj_mgr
518 ,c_ntf_task_mgr
519 ,c_project_number
520 ,c_project_name
521 ,d_project_start_date
522 ,d_project_end_date
523 ,c_task_number
524 ,c_task_name
525 ,d_task_start_date
526 ,d_task_end_date
527 ,c_exception_subject
528 ,c_exception_body
529 ,c_document_type
530 ,c_item_number
531 ,c_item_description
532 );
533
534 wf_engine.SetItemAttrText(itemtype => c_item_type
535 ,itemkey => c_item_key
536 ,aname => 'PR_NUMBER'
537 ,avalue => c_pr_number
538 );
539
540 wf_engine.SetItemAttrText(itemtype => c_item_type
541 ,itemkey => c_item_key
542 ,aname => 'SHIP_TO_LOCATION'
543 ,avalue => c_ship_to_location
544 );
545
546 wf_engine.SetItemAttrText(itemtype => c_item_type
547 ,itemkey => c_item_key
548 ,aname => 'STATUS'
549 ,avalue => c_status
550 );
551
552 wf_engine.SetItemAttrText(itemtype => c_item_type
553 ,itemkey => c_item_key
554 ,aname => 'QUANTITY'
555 ,avalue => n_quantity
556 );
557
558 wf_engine.SetItemAttrText(itemtype => c_item_type
559 ,itemkey => c_item_key
560 ,aname => 'NEED_BY_DATE'
561 ,avalue => d_need_by_date
562 );
563
564 wf_engine.StartProcess (itemtype => c_item_type
565 ,itemkey => c_item_key
566 );
567 END;
568
569 /*---------------------------------------------------------------------------
570 For RFQ exception process
571 ---------------------------------------------------------------------------*/
572 PROCEDURE launch_rfq(c_item_type varchar2
573 ,c_item_key varchar2
574 ,c_process varchar2
575 ,c_owner varchar2
576 ,c_requestor varchar2
577 ,n_tolerance_days number
578 ,c_ntf_proj_mgr varchar2
579 ,c_ntf_task_mgr varchar2
580 ,c_project_number varchar2
581 ,c_project_name varchar2
582 ,d_project_start_date date
583 ,d_project_end_date date
584 ,c_task_number varchar2
585 ,c_task_name varchar2
586 ,d_task_start_date date
587 ,d_task_end_date date
588 ,c_exception_subject varchar2
589 ,c_exception_body varchar2
590 ,c_document_type varchar2
591 ,c_item_number varchar2
592 ,c_item_description varchar2
593 ,c_rfq_number varchar2
594 ,c_ship_to_location varchar2
595 ,c_status varchar2
596 ,d_due_date date
597 ) is
598 BEGIN
599 common_start(c_item_type
600 ,c_item_key
601 ,c_process
602 ,c_owner
603 ,c_requestor
604 ,n_tolerance_days
605 ,c_ntf_proj_mgr
606 ,c_ntf_task_mgr
607 ,c_project_number
608 ,c_project_name
609 ,d_project_start_date
610 ,d_project_end_date
611 ,c_task_number
612 ,c_task_name
613 ,d_task_start_date
614 ,d_task_end_date
615 ,c_exception_subject
616 ,c_exception_body
617 ,c_document_type
618 ,c_item_number
619 ,c_item_description
620 );
621
622 wf_engine.SetItemAttrText(itemtype => c_item_type
623 ,itemkey => c_item_key
624 ,aname => 'RFQ_NUMBER'
625 ,avalue => c_rfq_number
626 );
627
628 wf_engine.SetItemAttrText(itemtype => c_item_type
629 ,itemkey => c_item_key
630 ,aname => 'SHIP_TO_LOCATION'
631 ,avalue => c_ship_to_location
632 );
633
634 wf_engine.SetItemAttrText(itemtype => c_item_type
635 ,itemkey => c_item_key
636 ,aname => 'STATUS'
637 ,avalue => c_status
638 );
639
640 wf_engine.SetItemAttrText(itemtype => c_item_type
641 ,itemkey => c_item_key
642 ,aname => 'DUE_DATE'
643 ,avalue => d_due_date
644 );
645
646 wf_engine.StartProcess (itemtype => c_item_type
647 ,itemkey => c_item_key
648 );
649 END;
650
651 /*---------------------------------------------------------------------------
652 For QUOTATION exception process
653 ---------------------------------------------------------------------------*/
654 PROCEDURE launch_quotation (c_item_type varchar2
655 ,c_item_key varchar2
656 ,c_process varchar2
657 ,c_owner varchar2
658 ,c_requestor varchar2
659 ,n_tolerance_days number
660 ,c_ntf_proj_mgr varchar2
661 ,c_ntf_task_mgr varchar2
662 ,c_project_number varchar2
663 ,c_project_name varchar2
664 ,d_project_start_date date
665 ,d_project_end_date date
666 ,c_task_number varchar2
667 ,c_task_name varchar2
668 ,d_task_start_date date
669 ,d_task_end_date date
670 ,c_exception_subject varchar2
671 ,c_exception_body varchar2
672 ,c_document_type varchar2
673 ,c_item_number varchar2
674 ,c_item_description varchar2
675 ,c_quotation_number varchar2
676 ,c_ship_to_location varchar2
677 ,c_status varchar2
678 ,d_eff_start_date date
679 ,d_eff_end_date date
680 ) is
681 BEGIN
682 common_start(c_item_type
683 ,c_item_key
684 ,c_process
685 ,c_owner
686 ,c_requestor
687 ,n_tolerance_days
688 ,c_ntf_proj_mgr
689 ,c_ntf_task_mgr
690 ,c_project_number
691 ,c_project_name
692 ,d_project_start_date
693 ,d_project_end_date
694 ,c_task_number
695 ,c_task_name
696 ,d_task_start_date
697 ,d_task_end_date
698 ,c_exception_subject
699 ,c_exception_body
700 ,c_document_type
701 ,c_item_number
702 ,c_item_description
703 );
704
705 wf_engine.SetItemAttrText(itemtype => c_item_type
706 ,itemkey => c_item_key
707 ,aname => 'QUOTATION_NUMBER'
708 ,avalue => c_quotation_number
709 );
710
711 wf_engine.SetItemAttrText(itemtype => c_item_type
712 ,itemkey => c_item_key
713 ,aname => 'SHIP_TO_LOCATION'
714 ,avalue => c_ship_to_location
715 );
716
717 wf_engine.SetItemAttrText(itemtype => c_item_type
718 ,itemkey => c_item_key
719 ,aname => 'STATUS'
720 ,avalue => c_status
721 );
722
723 wf_engine.SetItemAttrText(itemtype => c_item_type
724 ,itemkey => c_item_key
725 ,aname => 'EFF_START_DATE'
726 ,avalue => d_eff_start_date
727 );
728
729 wf_engine.SetItemAttrText(itemtype => c_item_type
730 ,itemkey => c_item_key
731 ,aname => 'EFF_END_DATE'
732 ,avalue => d_eff_end_date
733 );
734
735 wf_engine.StartProcess (itemtype => c_item_type
736 ,itemkey => c_item_key
737 );
738 END;
739
740 /*---------------------------------------------------------------------------
741 For MDS exception process
742 ---------------------------------------------------------------------------*/
743 PROCEDURE launch_mds(c_item_type varchar2
744 ,c_item_key varchar2
745 ,c_process varchar2
746 ,c_owner varchar2
747 ,c_requestor varchar2
748 ,n_tolerance_days number
749 ,c_ntf_proj_mgr varchar2
750 ,c_ntf_task_mgr varchar2
751 ,c_project_number varchar2
752 ,c_project_name varchar2
753 ,d_project_start_date date
754 ,d_project_end_date date
755 ,c_task_number varchar2
756 ,c_task_name varchar2
757 ,d_task_start_date date
758 ,d_task_end_date date
759 ,c_exception_subject varchar2
760 ,c_exception_body varchar2
761 ,c_document_type varchar2
762 ,c_item_number varchar2
763 ,c_item_description varchar2
764 ,c_mds_name varchar2
765 ,c_organization_name varchar2
766 ,n_quantity number
767 ,d_schedule_date date
768 ,d_schedule_end_date date
769 ) is
770 BEGIN
771 common_start(c_item_type
772 ,c_item_key
773 ,c_process
774 ,c_owner
775 ,c_requestor
776 ,n_tolerance_days
777 ,c_ntf_proj_mgr
778 ,c_ntf_task_mgr
779 ,c_project_number
780 ,c_project_name
781 ,d_project_start_date
782 ,d_project_end_date
783 ,c_task_number
784 ,c_task_name
785 ,d_task_start_date
786 ,d_task_end_date
787 ,c_exception_subject
788 ,c_exception_body
789 ,c_document_type
790 ,c_item_number
791 ,c_item_description
792 );
793
794 wf_engine.SetItemAttrText(itemtype => c_item_type
795 ,itemkey => c_item_key
796 ,aname => 'MDS_NAME'
797 ,avalue => c_mds_name
798 );
799
800 wf_engine.SetItemAttrText(itemtype => c_item_type
801 ,itemkey => c_item_key
802 ,aname => 'ORGANIZATION_NAME'
803 ,avalue => c_organization_name
804 );
805
806 wf_engine.SetItemAttrText(itemtype => c_item_type
807 ,itemkey => c_item_key
808 ,aname => 'QUANTITY'
809 ,avalue => n_quantity
810 );
811
812 wf_engine.SetItemAttrText(itemtype => c_item_type
813 ,itemkey => c_item_key
814 ,aname => 'SCHEDULE_DATE'
815 ,avalue => d_schedule_date
816 );
817
818 wf_engine.SetItemAttrText(itemtype => c_item_type
819 ,itemkey => c_item_key
820 ,aname => 'SCHEDULE_END_DATE'
821 ,avalue => d_schedule_end_date
822 );
823
824 wf_engine.StartProcess (itemtype => c_item_type
825 ,itemkey => c_item_key
826 );
827 END;
828
829 /*---------------------------------------------------------------------------
830 For MPS exception process
831 ---------------------------------------------------------------------------*/
832 PROCEDURE launch_mps(c_item_type varchar2
833 ,c_item_key varchar2
834 ,c_process varchar2
835 ,c_owner varchar2
836 ,c_requestor varchar2
837 ,n_tolerance_days number
838 ,c_ntf_proj_mgr varchar2
839 ,c_ntf_task_mgr varchar2
840 ,c_project_number varchar2
841 ,c_project_name varchar2
842 ,d_project_start_date date
843 ,d_project_end_date date
844 ,c_task_number varchar2
845 ,c_task_name varchar2
846 ,d_task_start_date date
847 ,d_task_end_date date
848 ,c_exception_subject varchar2
849 ,c_exception_body varchar2
850 ,c_document_type varchar2
851 ,c_item_number varchar2
852 ,c_item_description varchar2
853 ,c_mps_name varchar2
854 ,c_organization_name varchar2
855 ,n_quantity number
856 ,d_schedule_date date
857 ,d_schedule_end_date date
858 ) is
859 BEGIN
860 common_start(c_item_type
861 ,c_item_key
862 ,c_process
863 ,c_owner
864 ,c_requestor
865 ,n_tolerance_days
866 ,c_ntf_proj_mgr
867 ,c_ntf_task_mgr
868 ,c_project_number
869 ,c_project_name
870 ,d_project_start_date
871 ,d_project_end_date
872 ,c_task_number
873 ,c_task_name
874 ,d_task_start_date
875 ,d_task_end_date
876 ,c_exception_subject
877 ,c_exception_body
878 ,c_document_type
879 ,c_item_number
880 ,c_item_description
881 );
882
883 wf_engine.SetItemAttrText(itemtype => c_item_type
884 ,itemkey => c_item_key
885 ,aname => 'MPS_NAME'
886 ,avalue => c_mps_name
887 );
888
889 wf_engine.SetItemAttrText(itemtype => c_item_type
890 ,itemkey => c_item_key
891 ,aname => 'ORGANIZATION_NAME'
892 ,avalue => c_organization_name
893 );
894
895 wf_engine.SetItemAttrText(itemtype => c_item_type
896 ,itemkey => c_item_key
897 ,aname => 'QUANTITY'
898 ,avalue => n_quantity
899 );
900
901 wf_engine.SetItemAttrText(itemtype => c_item_type
902 ,itemkey => c_item_key
903 ,aname => 'SCHEDULE_DATE'
904 ,avalue => d_schedule_date
905 );
906
907 wf_engine.SetItemAttrText(itemtype => c_item_type
908 ,itemkey => c_item_key
909 ,aname => 'SCHEDULE_END_DATE'
910 ,avalue => d_schedule_end_date
911 );
912
913 wf_engine.StartProcess (itemtype => c_item_type
914 ,itemkey => c_item_key
915 );
916 END;
917
918 /*---------------------------------------------------------------------------
919 For PO exception process
920 ---------------------------------------------------------------------------*/
921 PROCEDURE launch_po (c_item_type varchar2
922 ,c_item_key varchar2
923 ,c_process varchar2
924 ,c_owner varchar2
925 ,c_requestor varchar2
926 ,n_tolerance_days number
927 ,c_ntf_proj_mgr varchar2
928 ,c_ntf_task_mgr varchar2
929 ,c_project_number varchar2
930 ,c_project_name varchar2
931 ,d_project_start_date date
932 ,d_project_end_date date
933 ,c_task_number varchar2
934 ,c_task_name varchar2
935 ,d_task_start_date date
936 ,d_task_end_date date
937 ,c_exception_subject varchar2
938 ,c_exception_body varchar2
939 ,c_document_type varchar2
940 ,c_item_number varchar2
941 ,c_item_description varchar2
942 ,c_po_number varchar2
943 ,c_ship_to_location varchar2
944 ,c_status varchar2
945 ,n_ordered_quantity number
946 ,n_delivered_quantity number
947 ,d_promised_date date
948 ,d_need_by_date date
949 ) is
950 BEGIN
951 common_start(c_item_type
952 ,c_item_key
953 ,c_process
954 ,c_owner
955 ,c_requestor
956 ,n_tolerance_days
957 ,c_ntf_proj_mgr
958 ,c_ntf_task_mgr
959 ,c_project_number
960 ,c_project_name
961 ,d_project_start_date
962 ,d_project_end_date
963 ,c_task_number
964 ,c_task_name
965 ,d_task_start_date
966 ,d_task_end_date
967 ,c_exception_subject
968 ,c_exception_body
969 ,c_document_type
970 ,c_item_number
971 ,c_item_description
972 );
973
974 wf_engine.SetItemAttrText(itemtype => c_item_type
975 ,itemkey => c_item_key
976 ,aname => 'PO_NUMBER'
977 ,avalue => c_po_number
978 );
979
980 wf_engine.SetItemAttrText(itemtype => c_item_type
981 ,itemkey => c_item_key
982 ,aname => 'SHIP_TO_LOCATION'
983 ,avalue => c_ship_to_location
984 );
985
986 wf_engine.SetItemAttrText(itemtype => c_item_type
987 ,itemkey => c_item_key
988 ,aname => 'STATUS'
989 ,avalue => c_status
990 );
991
992 wf_engine.SetItemAttrText(itemtype => c_item_type
993 ,itemkey => c_item_key
994 ,aname => 'ORDERED_QUANTITY'
995 ,avalue => n_ordered_quantity
996 );
997
998 wf_engine.SetItemAttrText(itemtype => c_item_type
999 ,itemkey => c_item_key
1000 ,aname => 'DELIVERED_QUANTITY'
1001 ,avalue => n_delivered_quantity
1002 );
1003
1004 wf_engine.SetItemAttrText(itemtype => c_item_type
1005 ,itemkey => c_item_key
1006 ,aname => 'PROMISED_DATE'
1007 ,avalue => d_promised_date
1008 );
1009
1010 wf_engine.SetItemAttrText(itemtype => c_item_type
1011 ,itemkey => c_item_key
1012 ,aname => 'NEED_BY_DATE'
1013 ,avalue => d_need_by_date
1014 );
1015
1016 wf_engine.StartProcess (itemtype => c_item_type
1017 ,itemkey => c_item_key
1018 );
1019 END;
1020
1021 /*---------------------------------------------------------------------------
1022 For PO_RELEASE exception process
1023 ---------------------------------------------------------------------------*/
1024 PROCEDURE launch_po_release (c_item_type varchar2
1025 ,c_item_key varchar2
1026 ,c_process varchar2
1027 ,c_owner varchar2
1028 ,c_requestor varchar2
1029 ,n_tolerance_days number
1030 ,c_ntf_proj_mgr varchar2
1031 ,c_ntf_task_mgr varchar2
1032 ,c_project_number varchar2
1033 ,c_project_name varchar2
1034 ,d_project_start_date date
1035 ,d_project_end_date date
1036 ,c_task_number varchar2
1037 ,c_task_name varchar2
1038 ,d_task_start_date date
1039 ,d_task_end_date date
1040 ,c_exception_subject varchar2
1041 ,c_exception_body varchar2
1042 ,c_document_type varchar2
1043 ,c_item_number varchar2
1044 ,c_item_description varchar2
1045 ,c_po_number varchar2
1046 ,c_release_number varchar2
1047 ,c_ship_to_location varchar2
1048 ,c_status varchar2
1049 ,n_ordered_quantity number
1050 ,n_delivered_quantity number
1051 ,d_promised_date date
1052 ,d_need_by_date date
1053 ) is
1054 BEGIN
1055 common_start(c_item_type
1056 ,c_item_key
1057 ,c_process
1058 ,c_owner
1059 ,c_requestor
1060 ,n_tolerance_days
1061 ,c_ntf_proj_mgr
1062 ,c_ntf_task_mgr
1063 ,c_project_number
1064 ,c_project_name
1065 ,d_project_start_date
1066 ,d_project_end_date
1067 ,c_task_number
1068 ,c_task_name
1069 ,d_task_start_date
1070 ,d_task_end_date
1071 ,c_exception_subject
1072 ,c_exception_body
1073 ,c_document_type
1074 ,c_item_number
1075 ,c_item_description
1076 );
1077
1078 wf_engine.SetItemAttrText(itemtype => c_item_type
1079 ,itemkey => c_item_key
1080 ,aname => 'PO_NUMBER'
1081 ,avalue => c_po_number
1082 );
1083
1084 wf_engine.SetItemAttrText(itemtype => c_item_type
1085 ,itemkey => c_item_key
1086 ,aname => 'RELEASE_NUMBER'
1087 ,avalue => c_release_number
1088 );
1089
1090 wf_engine.SetItemAttrText(itemtype => c_item_type
1091 ,itemkey => c_item_key
1092 ,aname => 'SHIP_TO_LOCATION'
1093 ,avalue => c_ship_to_location
1094 );
1095
1096 wf_engine.SetItemAttrText(itemtype => c_item_type
1097 ,itemkey => c_item_key
1098 ,aname => 'STATUS'
1099 ,avalue => c_status
1100 );
1101
1102 wf_engine.SetItemAttrText(itemtype => c_item_type
1103 ,itemkey => c_item_key
1104 ,aname => 'ORDERED_QUANTITY'
1105 ,avalue => n_ordered_quantity
1106 );
1107
1108 wf_engine.SetItemAttrText(itemtype => c_item_type
1109 ,itemkey => c_item_key
1110 ,aname => 'DELIVERED_QUANTITY'
1111 ,avalue => n_delivered_quantity
1112 );
1113
1114 wf_engine.SetItemAttrText(itemtype => c_item_type
1115 ,itemkey => c_item_key
1116 ,aname => 'PROMISED_DATE'
1117 ,avalue => d_promised_date
1118 );
1119
1120 wf_engine.SetItemAttrText(itemtype => c_item_type
1121 ,itemkey => c_item_key
1122 ,aname => 'NEED_BY_DATE'
1123 ,avalue => d_need_by_date
1124 );
1125
1126 wf_engine.StartProcess (itemtype => c_item_type
1127 ,itemkey => c_item_key
1128 );
1129 END;
1130
1131 END PJM_SCHED_INT_WF_PRIV;