[Home] [Help]
PACKAGE BODY: APPS.JTF_TASK_ASSIGNMENTS_PVT_W
Source
1 package body jtf_task_assignments_pvt_w as
2 /* $Header: jtfvtawb.pls 120.2 2006/04/26 04:40 knayyar noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 procedure create_task_assignment(p_api_version NUMBER
17 , p_init_msg_list VARCHAR2
18 , p_commit VARCHAR2
19 , p_task_assignment_id NUMBER
20 , p_task_id NUMBER
21 , p_resource_type_code VARCHAR2
22 , p_resource_id NUMBER
23 , p_actual_effort NUMBER
24 , p_actual_effort_uom VARCHAR2
25 , p_schedule_flag VARCHAR2
26 , p_alarm_type_code VARCHAR2
27 , p_alarm_contact VARCHAR2
28 , p_sched_travel_distance NUMBER
29 , p_sched_travel_duration NUMBER
30 , p_sched_travel_duration_uom VARCHAR2
31 , p_actual_travel_distance NUMBER
32 , p_actual_travel_duration NUMBER
33 , p_actual_travel_duration_uom VARCHAR2
34 , p_actual_start_date date
35 , p_actual_end_date date
36 , p_palm_flag VARCHAR2
37 , p_wince_flag VARCHAR2
38 , p_laptop_flag VARCHAR2
39 , p_device1_flag VARCHAR2
40 , p_device2_flag VARCHAR2
41 , p_device3_flag VARCHAR2
42 , p_resource_territory_id NUMBER
43 , p_assignment_status_id NUMBER
44 , p_shift_construct_id NUMBER
45 , x_return_status out nocopy VARCHAR2
46 , x_msg_count out nocopy NUMBER
47 , x_msg_data out nocopy VARCHAR2
48 , x_task_assignment_id out nocopy NUMBER
49 , p_attribute1 VARCHAR2
50 , p_attribute2 VARCHAR2
51 , p_attribute3 VARCHAR2
52 , p_attribute4 VARCHAR2
53 , p_attribute5 VARCHAR2
54 , p_attribute6 VARCHAR2
55 , p_attribute7 VARCHAR2
56 , p_attribute8 VARCHAR2
57 , p_attribute9 VARCHAR2
58 , p_attribute10 VARCHAR2
59 , p_attribute11 VARCHAR2
60 , p_attribute12 VARCHAR2
61 , p_attribute13 VARCHAR2
62 , p_attribute14 VARCHAR2
63 , p_attribute15 VARCHAR2
64 , p_attribute_category VARCHAR2
65 , p_assignee_role VARCHAR2
66 , p_show_on_calendar VARCHAR2
67 , p_category_id NUMBER
68 , p_enable_workflow VARCHAR2
69 , p_abort_workflow VARCHAR2
70 , p_add_option VARCHAR2
71 , p_free_busy_type VARCHAR2
72 )
73
74 as
75 ddp_actual_start_date date;
76 ddp_actual_end_date date;
77 ddindx binary_integer; indx binary_integer;
78 begin
79
80 -- copy data to the local IN or IN-OUT args, if any
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
100
101 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139 -- here's the delegated call to the old PL/SQL routine
140 jtf_task_assignments_pvt.create_task_assignment(p_api_version,
141 p_init_msg_list,
142 p_commit,
143 p_task_assignment_id,
144 p_task_id,
145 p_resource_type_code,
146 p_resource_id,
147 p_actual_effort,
148 p_actual_effort_uom,
149 p_schedule_flag,
150 p_alarm_type_code,
151 p_alarm_contact,
152 p_sched_travel_distance,
153 p_sched_travel_duration,
154 p_sched_travel_duration_uom,
155 p_actual_travel_distance,
156 p_actual_travel_duration,
157 p_actual_travel_duration_uom,
158 ddp_actual_start_date,
159 ddp_actual_end_date,
160 p_palm_flag,
161 p_wince_flag,
162 p_laptop_flag,
163 p_device1_flag,
164 p_device2_flag,
165 p_device3_flag,
166 p_resource_territory_id,
167 p_assignment_status_id,
168 p_shift_construct_id,
172 x_task_assignment_id,
169 x_return_status,
170 x_msg_count,
171 x_msg_data,
173 p_attribute1,
174 p_attribute2,
175 p_attribute3,
176 p_attribute4,
177 p_attribute5,
178 p_attribute6,
179 p_attribute7,
180 p_attribute8,
181 p_attribute9,
182 p_attribute10,
183 p_attribute11,
184 p_attribute12,
185 p_attribute13,
186 p_attribute14,
187 p_attribute15,
188 p_attribute_category,
189 p_assignee_role,
190 p_show_on_calendar,
191 p_category_id,
192 p_enable_workflow,
193 p_abort_workflow,
194 p_add_option,
195 p_free_busy_type);
196
197 -- copy data back from the local variables to OUT or IN-OUT args, if any
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253 end;
254
255 procedure create_task_assignment(p_api_version NUMBER
256 , p_init_msg_list VARCHAR2
257 , p_commit VARCHAR2
258 , p_task_assignment_id NUMBER
259 , p_task_id NUMBER
260 , p_resource_type_code VARCHAR2
261 , p_resource_id NUMBER
262 , p_actual_effort NUMBER
263 , p_actual_effort_uom VARCHAR2
264 , p_schedule_flag VARCHAR2
265 , p_alarm_type_code VARCHAR2
266 , p_alarm_contact VARCHAR2
267 , p_sched_travel_distance NUMBER
268 , p_sched_travel_duration NUMBER
269 , p_sched_travel_duration_uom VARCHAR2
270 , p_actual_travel_distance NUMBER
271 , p_actual_travel_duration NUMBER
272 , p_actual_travel_duration_uom VARCHAR2
273 , p_actual_start_date date
274 , p_actual_end_date date
275 , p_palm_flag VARCHAR2
276 , p_wince_flag VARCHAR2
277 , p_laptop_flag VARCHAR2
278 , p_device1_flag VARCHAR2
279 , p_device2_flag VARCHAR2
280 , p_device3_flag VARCHAR2
281 , p_resource_territory_id NUMBER
282 , p_assignment_status_id NUMBER
283 , p_shift_construct_id NUMBER
284 , x_return_status out nocopy VARCHAR2
285 , x_msg_count out nocopy NUMBER
286 , x_msg_data out nocopy VARCHAR2
287 , x_task_assignment_id out nocopy NUMBER
288 , p_attribute1 VARCHAR2
289 , p_attribute2 VARCHAR2
290 , p_attribute3 VARCHAR2
291 , p_attribute4 VARCHAR2
292 , p_attribute5 VARCHAR2
293 , p_attribute6 VARCHAR2
294 , p_attribute7 VARCHAR2
295 , p_attribute8 VARCHAR2
296 , p_attribute9 VARCHAR2
297 , p_attribute10 VARCHAR2
298 , p_attribute11 VARCHAR2
299 , p_attribute12 VARCHAR2
300 , p_attribute13 VARCHAR2
301 , p_attribute14 VARCHAR2
302 , p_attribute15 VARCHAR2
303 , p_attribute_category VARCHAR2
304 , p_assignee_role VARCHAR2
305 , p_show_on_calendar VARCHAR2
306 , p_category_id NUMBER
307 , p_enable_workflow VARCHAR2
308 , p_abort_workflow VARCHAR2
309 , p_add_option VARCHAR2
310 , p_free_busy_type VARCHAR2
311 , p_object_capacity_id NUMBER
312 )
313
314 as
315 ddp_actual_start_date date;
316 ddp_actual_end_date date;
317 ddindx binary_integer; indx binary_integer;
318 begin
319
320 -- copy data to the local IN or IN-OUT args, if any
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
340
341 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380 -- here's the delegated call to the old PL/SQL routine
381 jtf_task_assignments_pvt.create_task_assignment(p_api_version,
382 p_init_msg_list,
383 p_commit,
384 p_task_assignment_id,
385 p_task_id,
386 p_resource_type_code,
387 p_resource_id,
388 p_actual_effort,
389 p_actual_effort_uom,
390 p_schedule_flag,
391 p_alarm_type_code,
392 p_alarm_contact,
393 p_sched_travel_distance,
394 p_sched_travel_duration,
395 p_sched_travel_duration_uom,
396 p_actual_travel_distance,
397 p_actual_travel_duration,
398 p_actual_travel_duration_uom,
399 ddp_actual_start_date,
400 ddp_actual_end_date,
401 p_palm_flag,
402 p_wince_flag,
403 p_laptop_flag,
404 p_device1_flag,
408 p_assignment_status_id,
405 p_device2_flag,
406 p_device3_flag,
407 p_resource_territory_id,
409 p_shift_construct_id,
410 x_return_status,
411 x_msg_count,
412 x_msg_data,
413 x_task_assignment_id,
414 p_attribute1,
415 p_attribute2,
416 p_attribute3,
417 p_attribute4,
418 p_attribute5,
419 p_attribute6,
420 p_attribute7,
421 p_attribute8,
422 p_attribute9,
423 p_attribute10,
424 p_attribute11,
425 p_attribute12,
426 p_attribute13,
427 p_attribute14,
428 p_attribute15,
429 p_attribute_category,
430 p_assignee_role,
431 p_show_on_calendar,
432 p_category_id,
433 p_enable_workflow,
434 p_abort_workflow,
435 p_add_option,
436 p_free_busy_type,
437 p_object_capacity_id);
438
439 -- copy data back from the local variables to OUT or IN-OUT args, if any
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496 end;
497
498 procedure create_task_assignment(p_api_version NUMBER
499 , p_init_msg_list VARCHAR2
500 , p_commit VARCHAR2
501 , p_task_assignment_id NUMBER
502 , p_task_id NUMBER
503 , p_resource_type_code VARCHAR2
504 , p_resource_id NUMBER
505 , p_actual_effort NUMBER
506 , p_actual_effort_uom VARCHAR2
507 , p_schedule_flag VARCHAR2
508 , p_alarm_type_code VARCHAR2
509 , p_alarm_contact VARCHAR2
510 , p_sched_travel_distance NUMBER
511 , p_sched_travel_duration NUMBER
512 , p_sched_travel_duration_uom VARCHAR2
513 , p_actual_travel_distance NUMBER
514 , p_actual_travel_duration NUMBER
515 , p_actual_travel_duration_uom VARCHAR2
516 , p_actual_start_date date
517 , p_actual_end_date date
518 , p_palm_flag VARCHAR2
519 , p_wince_flag VARCHAR2
520 , p_laptop_flag VARCHAR2
521 , p_device1_flag VARCHAR2
522 , p_device2_flag VARCHAR2
523 , p_device3_flag VARCHAR2
524 , p_resource_territory_id NUMBER
525 , p_assignment_status_id NUMBER
526 , p_shift_construct_id NUMBER
527 , x_return_status out nocopy VARCHAR2
528 , x_msg_count out nocopy NUMBER
529 , x_msg_data out nocopy VARCHAR2
530 , x_task_assignment_id out nocopy NUMBER
531 , p_attribute1 VARCHAR2
532 , p_attribute2 VARCHAR2
533 , p_attribute3 VARCHAR2
534 , p_attribute4 VARCHAR2
535 , p_attribute5 VARCHAR2
536 , p_attribute6 VARCHAR2
537 , p_attribute7 VARCHAR2
538 , p_attribute8 VARCHAR2
539 , p_attribute9 VARCHAR2
540 , p_attribute10 VARCHAR2
541 , p_attribute11 VARCHAR2
542 , p_attribute12 VARCHAR2
543 , p_attribute13 VARCHAR2
544 , p_attribute14 VARCHAR2
545 , p_attribute15 VARCHAR2
546 , p_attribute_category VARCHAR2
547 , p_assignee_role VARCHAR2
548 , p_show_on_calendar VARCHAR2
549 , p_category_id NUMBER
550 , p_enable_workflow VARCHAR2
551 , p_abort_workflow VARCHAR2
552 , p_add_option VARCHAR2
553 )
554
555 as
556 ddp_actual_start_date date;
557 ddp_actual_end_date date;
558 ddindx binary_integer; indx binary_integer;
559 begin
560
561 -- copy data to the local IN or IN-OUT args, if any
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
581
582 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619 -- here's the delegated call to the old PL/SQL routine
620 jtf_task_assignments_pvt.create_task_assignment(p_api_version,
621 p_init_msg_list,
622 p_commit,
623 p_task_assignment_id,
624 p_task_id,
625 p_resource_type_code,
626 p_resource_id,
627 p_actual_effort,
628 p_actual_effort_uom,
629 p_schedule_flag,
630 p_alarm_type_code,
631 p_alarm_contact,
632 p_sched_travel_distance,
633 p_sched_travel_duration,
634 p_sched_travel_duration_uom,
635 p_actual_travel_distance,
636 p_actual_travel_duration,
637 p_actual_travel_duration_uom,
638 ddp_actual_start_date,
639 ddp_actual_end_date,
643 p_device1_flag,
640 p_palm_flag,
641 p_wince_flag,
642 p_laptop_flag,
644 p_device2_flag,
645 p_device3_flag,
646 p_resource_territory_id,
647 p_assignment_status_id,
648 p_shift_construct_id,
649 x_return_status,
650 x_msg_count,
651 x_msg_data,
652 x_task_assignment_id,
653 p_attribute1,
654 p_attribute2,
655 p_attribute3,
656 p_attribute4,
657 p_attribute5,
658 p_attribute6,
659 p_attribute7,
660 p_attribute8,
661 p_attribute9,
662 p_attribute10,
663 p_attribute11,
664 p_attribute12,
665 p_attribute13,
666 p_attribute14,
667 p_attribute15,
668 p_attribute_category,
669 p_assignee_role,
670 p_show_on_calendar,
671 p_category_id,
672 p_enable_workflow,
673 p_abort_workflow,
674 p_add_option);
675
676 -- copy data back from the local variables to OUT or IN-OUT args, if any
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731 end;
732
733 procedure create_task_assignment(p_api_version NUMBER
734 , p_init_msg_list VARCHAR2
735 , p_commit VARCHAR2
736 , p_task_assignment_id NUMBER
737 , p_task_id NUMBER
738 , p_resource_type_code VARCHAR2
739 , p_resource_id NUMBER
740 , p_actual_effort NUMBER
741 , p_actual_effort_uom VARCHAR2
742 , p_schedule_flag VARCHAR2
743 , p_alarm_type_code VARCHAR2
744 , p_alarm_contact VARCHAR2
745 , p_sched_travel_distance NUMBER
746 , p_sched_travel_duration NUMBER
747 , p_sched_travel_duration_uom VARCHAR2
748 , p_actual_travel_distance NUMBER
749 , p_actual_travel_duration NUMBER
750 , p_actual_travel_duration_uom VARCHAR2
751 , p_actual_start_date date
752 , p_actual_end_date date
753 , p_palm_flag VARCHAR2
754 , p_wince_flag VARCHAR2
755 , p_laptop_flag VARCHAR2
756 , p_device1_flag VARCHAR2
757 , p_device2_flag VARCHAR2
758 , p_device3_flag VARCHAR2
759 , p_resource_territory_id NUMBER
760 , p_assignment_status_id NUMBER
761 , p_shift_construct_id NUMBER
762 , x_return_status out nocopy VARCHAR2
763 , x_msg_count out nocopy NUMBER
764 , x_msg_data out nocopy VARCHAR2
765 , x_task_assignment_id out nocopy NUMBER
766 , p_attribute1 VARCHAR2
767 , p_attribute2 VARCHAR2
768 , p_attribute3 VARCHAR2
769 , p_attribute4 VARCHAR2
770 , p_attribute5 VARCHAR2
771 , p_attribute6 VARCHAR2
772 , p_attribute7 VARCHAR2
773 , p_attribute8 VARCHAR2
774 , p_attribute9 VARCHAR2
775 , p_attribute10 VARCHAR2
776 , p_attribute11 VARCHAR2
777 , p_attribute12 VARCHAR2
778 , p_attribute13 VARCHAR2
779 , p_attribute14 VARCHAR2
780 , p_attribute15 VARCHAR2
781 , p_attribute_category VARCHAR2
782 , p_assignee_role VARCHAR2
783 , p_show_on_calendar VARCHAR2
784 , p_category_id NUMBER
785 , p_enable_workflow VARCHAR2
786 , p_abort_workflow VARCHAR2
787 )
788
789 as
790 ddp_actual_start_date date;
791 ddp_actual_end_date date;
792 ddindx binary_integer; indx binary_integer;
793 begin
794
795 -- copy data to the local IN or IN-OUT args, if any
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
815
816 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852 -- here's the delegated call to the old PL/SQL routine
853 jtf_task_assignments_pvt.create_task_assignment(p_api_version,
854 p_init_msg_list,
855 p_commit,
856 p_task_assignment_id,
857 p_task_id,
858 p_resource_type_code,
859 p_resource_id,
860 p_actual_effort,
861 p_actual_effort_uom,
862 p_schedule_flag,
863 p_alarm_type_code,
864 p_alarm_contact,
865 p_sched_travel_distance,
866 p_sched_travel_duration,
867 p_sched_travel_duration_uom,
868 p_actual_travel_distance,
869 p_actual_travel_duration,
870 p_actual_travel_duration_uom,
871 ddp_actual_start_date,
872 ddp_actual_end_date,
873 p_palm_flag,
877 p_device2_flag,
874 p_wince_flag,
875 p_laptop_flag,
876 p_device1_flag,
878 p_device3_flag,
879 p_resource_territory_id,
880 p_assignment_status_id,
881 p_shift_construct_id,
882 x_return_status,
883 x_msg_count,
884 x_msg_data,
885 x_task_assignment_id,
886 p_attribute1,
887 p_attribute2,
888 p_attribute3,
889 p_attribute4,
890 p_attribute5,
891 p_attribute6,
892 p_attribute7,
893 p_attribute8,
894 p_attribute9,
895 p_attribute10,
896 p_attribute11,
897 p_attribute12,
898 p_attribute13,
899 p_attribute14,
900 p_attribute15,
901 p_attribute_category,
902 p_assignee_role,
903 p_show_on_calendar,
904 p_category_id,
905 p_enable_workflow,
906 p_abort_workflow);
907
908 -- copy data back from the local variables to OUT or IN-OUT args, if any
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962 end;
963
964 procedure create_task_assignment(p_api_version NUMBER
965 , p_init_msg_list VARCHAR2
966 , p_commit VARCHAR2
967 , p_task_assignment_id NUMBER
968 , p_task_id NUMBER
969 , p_resource_type_code VARCHAR2
970 , p_resource_id NUMBER
971 , p_actual_effort NUMBER
972 , p_actual_effort_uom VARCHAR2
973 , p_schedule_flag VARCHAR2
974 , p_alarm_type_code VARCHAR2
975 , p_alarm_contact VARCHAR2
976 , p_sched_travel_distance NUMBER
977 , p_sched_travel_duration NUMBER
978 , p_sched_travel_duration_uom VARCHAR2
979 , p_actual_travel_distance NUMBER
980 , p_actual_travel_duration NUMBER
981 , p_actual_travel_duration_uom VARCHAR2
982 , p_actual_start_date date
983 , p_actual_end_date date
984 , p_palm_flag VARCHAR2
985 , p_wince_flag VARCHAR2
986 , p_laptop_flag VARCHAR2
987 , p_device1_flag VARCHAR2
988 , p_device2_flag VARCHAR2
989 , p_device3_flag VARCHAR2
990 , p_resource_territory_id NUMBER
991 , p_assignment_status_id NUMBER
992 , p_shift_construct_id NUMBER
993 , x_return_status out nocopy VARCHAR2
994 , x_msg_count out nocopy NUMBER
995 , x_msg_data out nocopy VARCHAR2
996 , x_task_assignment_id out nocopy NUMBER
997 , p_attribute1 VARCHAR2
998 , p_attribute2 VARCHAR2
999 , p_attribute3 VARCHAR2
1000 , p_attribute4 VARCHAR2
1001 , p_attribute5 VARCHAR2
1002 , p_attribute6 VARCHAR2
1003 , p_attribute7 VARCHAR2
1004 , p_attribute8 VARCHAR2
1005 , p_attribute9 VARCHAR2
1006 , p_attribute10 VARCHAR2
1007 , p_attribute11 VARCHAR2
1008 , p_attribute12 VARCHAR2
1009 , p_attribute13 VARCHAR2
1010 , p_attribute14 VARCHAR2
1011 , p_attribute15 VARCHAR2
1012 , p_attribute_category VARCHAR2
1013 , p_assignee_role VARCHAR2
1014 , p_show_on_calendar VARCHAR2
1015 , p_category_id NUMBER
1016 )
1017
1018 as
1019 ddp_actual_start_date date;
1020 ddp_actual_end_date date;
1021 ddindx binary_integer; indx binary_integer;
1022 begin
1023
1024 -- copy data to the local IN or IN-OUT args, if any
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1044
1045 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079 -- here's the delegated call to the old PL/SQL routine
1080 jtf_task_assignments_pvt.create_task_assignment(p_api_version,
1081 p_init_msg_list,
1082 p_commit,
1083 p_task_assignment_id,
1084 p_task_id,
1085 p_resource_type_code,
1086 p_resource_id,
1087 p_actual_effort,
1088 p_actual_effort_uom,
1089 p_schedule_flag,
1090 p_alarm_type_code,
1091 p_alarm_contact,
1092 p_sched_travel_distance,
1093 p_sched_travel_duration,
1094 p_sched_travel_duration_uom,
1095 p_actual_travel_distance,
1096 p_actual_travel_duration,
1097 p_actual_travel_duration_uom,
1098 ddp_actual_start_date,
1099 ddp_actual_end_date,
1100 p_palm_flag,
1101 p_wince_flag,
1102 p_laptop_flag,
1103 p_device1_flag,
1104 p_device2_flag,
1105 p_device3_flag,
1109 x_return_status,
1106 p_resource_territory_id,
1107 p_assignment_status_id,
1108 p_shift_construct_id,
1110 x_msg_count,
1111 x_msg_data,
1112 x_task_assignment_id,
1113 p_attribute1,
1114 p_attribute2,
1115 p_attribute3,
1116 p_attribute4,
1117 p_attribute5,
1118 p_attribute6,
1119 p_attribute7,
1120 p_attribute8,
1121 p_attribute9,
1122 p_attribute10,
1123 p_attribute11,
1124 p_attribute12,
1125 p_attribute13,
1126 p_attribute14,
1127 p_attribute15,
1128 p_attribute_category,
1129 p_assignee_role,
1130 p_show_on_calendar,
1131 p_category_id);
1132
1133 -- copy data back from the local variables to OUT or IN-OUT args, if any
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185 end;
1186
1187 procedure update_task_assignment(p_api_version NUMBER
1188 , p_object_version_number in out nocopy NUMBER
1189 , p_init_msg_list VARCHAR2
1190 , p_commit VARCHAR2
1191 , p_task_assignment_id NUMBER
1192 , p_resource_type_code VARCHAR2
1193 , p_resource_id NUMBER
1194 , p_actual_effort NUMBER
1195 , p_actual_effort_uom VARCHAR2
1196 , p_schedule_flag VARCHAR2
1197 , p_alarm_type_code VARCHAR2
1198 , p_alarm_contact VARCHAR2
1199 , p_sched_travel_distance NUMBER
1200 , p_sched_travel_duration NUMBER
1201 , p_sched_travel_duration_uom VARCHAR2
1202 , p_actual_travel_distance NUMBER
1203 , p_actual_travel_duration NUMBER
1204 , p_actual_travel_duration_uom VARCHAR2
1205 , p_actual_start_date date
1206 , p_actual_end_date date
1207 , p_palm_flag VARCHAR2
1208 , p_wince_flag VARCHAR2
1209 , p_laptop_flag VARCHAR2
1210 , p_device1_flag VARCHAR2
1211 , p_device2_flag VARCHAR2
1212 , p_device3_flag VARCHAR2
1213 , p_resource_territory_id NUMBER
1214 , p_assignment_status_id NUMBER
1215 , p_shift_construct_id NUMBER
1216 , x_return_status out nocopy VARCHAR2
1217 , x_msg_count out nocopy NUMBER
1218 , x_msg_data out nocopy VARCHAR2
1219 , p_attribute1 VARCHAR2
1220 , p_attribute2 VARCHAR2
1221 , p_attribute3 VARCHAR2
1222 , p_attribute4 VARCHAR2
1223 , p_attribute5 VARCHAR2
1224 , p_attribute6 VARCHAR2
1225 , p_attribute7 VARCHAR2
1226 , p_attribute8 VARCHAR2
1227 , p_attribute9 VARCHAR2
1228 , p_attribute10 VARCHAR2
1229 , p_attribute11 VARCHAR2
1230 , p_attribute12 VARCHAR2
1231 , p_attribute13 VARCHAR2
1232 , p_attribute14 VARCHAR2
1233 , p_attribute15 VARCHAR2
1234 , p_attribute_category VARCHAR2
1235 , p_assignee_role VARCHAR2
1236 , p_show_on_calendar VARCHAR2
1237 , p_category_id NUMBER
1238 , p_enable_workflow VARCHAR2
1239 , p_abort_workflow VARCHAR2
1240 , p_free_busy_type VARCHAR2
1241 )
1242
1243 as
1244 ddp_actual_start_date date;
1245 ddp_actual_end_date date;
1246 ddindx binary_integer; indx binary_integer;
1247 begin
1248
1249 -- copy data to the local IN or IN-OUT args, if any
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1269
1270 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306 -- here's the delegated call to the old PL/SQL routine
1307 jtf_task_assignments_pvt.update_task_assignment(p_api_version,
1308 p_object_version_number,
1309 p_init_msg_list,
1310 p_commit,
1311 p_task_assignment_id,
1312 p_resource_type_code,
1313 p_resource_id,
1314 p_actual_effort,
1315 p_actual_effort_uom,
1316 p_schedule_flag,
1317 p_alarm_type_code,
1318 p_alarm_contact,
1319 p_sched_travel_distance,
1320 p_sched_travel_duration,
1321 p_sched_travel_duration_uom,
1322 p_actual_travel_distance,
1323 p_actual_travel_duration,
1324 p_actual_travel_duration_uom,
1325 ddp_actual_start_date,
1326 ddp_actual_end_date,
1327 p_palm_flag,
1328 p_wince_flag,
1329 p_laptop_flag,
1330 p_device1_flag,
1331 p_device2_flag,
1332 p_device3_flag,
1333 p_resource_territory_id,
1334 p_assignment_status_id,
1338 x_msg_data,
1335 p_shift_construct_id,
1336 x_return_status,
1337 x_msg_count,
1339 p_attribute1,
1340 p_attribute2,
1341 p_attribute3,
1342 p_attribute4,
1343 p_attribute5,
1344 p_attribute6,
1345 p_attribute7,
1346 p_attribute8,
1347 p_attribute9,
1348 p_attribute10,
1349 p_attribute11,
1350 p_attribute12,
1351 p_attribute13,
1352 p_attribute14,
1353 p_attribute15,
1354 p_attribute_category,
1355 p_assignee_role,
1356 p_show_on_calendar,
1357 p_category_id,
1358 p_enable_workflow,
1359 p_abort_workflow,
1360 p_free_busy_type);
1361
1362 -- copy data back from the local variables to OUT or IN-OUT args, if any
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416 end;
1417
1418 procedure update_task_assignment(p_api_version NUMBER
1419 , p_object_version_number in out nocopy NUMBER
1420 , p_init_msg_list VARCHAR2
1421 , p_commit VARCHAR2
1422 , p_task_assignment_id NUMBER
1423 , p_resource_type_code VARCHAR2
1424 , p_resource_id NUMBER
1425 , p_actual_effort NUMBER
1426 , p_actual_effort_uom VARCHAR2
1427 , p_schedule_flag VARCHAR2
1428 , p_alarm_type_code VARCHAR2
1429 , p_alarm_contact VARCHAR2
1430 , p_sched_travel_distance NUMBER
1431 , p_sched_travel_duration NUMBER
1432 , p_sched_travel_duration_uom VARCHAR2
1433 , p_actual_travel_distance NUMBER
1434 , p_actual_travel_duration NUMBER
1435 , p_actual_travel_duration_uom VARCHAR2
1436 , p_actual_start_date date
1437 , p_actual_end_date date
1438 , p_palm_flag VARCHAR2
1439 , p_wince_flag VARCHAR2
1440 , p_laptop_flag VARCHAR2
1441 , p_device1_flag VARCHAR2
1442 , p_device2_flag VARCHAR2
1443 , p_device3_flag VARCHAR2
1444 , p_resource_territory_id NUMBER
1445 , p_assignment_status_id NUMBER
1446 , p_shift_construct_id NUMBER
1447 , x_return_status out nocopy VARCHAR2
1448 , x_msg_count out nocopy NUMBER
1449 , x_msg_data out nocopy VARCHAR2
1450 , p_attribute1 VARCHAR2
1451 , p_attribute2 VARCHAR2
1452 , p_attribute3 VARCHAR2
1453 , p_attribute4 VARCHAR2
1454 , p_attribute5 VARCHAR2
1455 , p_attribute6 VARCHAR2
1456 , p_attribute7 VARCHAR2
1457 , p_attribute8 VARCHAR2
1458 , p_attribute9 VARCHAR2
1459 , p_attribute10 VARCHAR2
1460 , p_attribute11 VARCHAR2
1461 , p_attribute12 VARCHAR2
1462 , p_attribute13 VARCHAR2
1463 , p_attribute14 VARCHAR2
1464 , p_attribute15 VARCHAR2
1465 , p_attribute_category VARCHAR2
1466 , p_assignee_role VARCHAR2
1467 , p_show_on_calendar VARCHAR2
1468 , p_category_id NUMBER
1469 , p_enable_workflow VARCHAR2
1470 , p_abort_workflow VARCHAR2
1471 , p_free_busy_type VARCHAR2
1472 , p_object_capacity_id NUMBER
1473 )
1474
1475 as
1476 ddp_actual_start_date date;
1477 ddp_actual_end_date date;
1478 ddindx binary_integer; indx binary_integer;
1479 begin
1480
1481 -- copy data to the local IN or IN-OUT args, if any
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1501
1502 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539 -- here's the delegated call to the old PL/SQL routine
1540 jtf_task_assignments_pvt.update_task_assignment(p_api_version,
1541 p_object_version_number,
1542 p_init_msg_list,
1543 p_commit,
1544 p_task_assignment_id,
1545 p_resource_type_code,
1546 p_resource_id,
1547 p_actual_effort,
1548 p_actual_effort_uom,
1549 p_schedule_flag,
1550 p_alarm_type_code,
1551 p_alarm_contact,
1552 p_sched_travel_distance,
1553 p_sched_travel_duration,
1554 p_sched_travel_duration_uom,
1555 p_actual_travel_distance,
1556 p_actual_travel_duration,
1557 p_actual_travel_duration_uom,
1558 ddp_actual_start_date,
1559 ddp_actual_end_date,
1560 p_palm_flag,
1561 p_wince_flag,
1562 p_laptop_flag,
1563 p_device1_flag,
1564 p_device2_flag,
1568 p_shift_construct_id,
1565 p_device3_flag,
1566 p_resource_territory_id,
1567 p_assignment_status_id,
1569 x_return_status,
1570 x_msg_count,
1571 x_msg_data,
1572 p_attribute1,
1573 p_attribute2,
1574 p_attribute3,
1575 p_attribute4,
1576 p_attribute5,
1577 p_attribute6,
1578 p_attribute7,
1579 p_attribute8,
1580 p_attribute9,
1581 p_attribute10,
1582 p_attribute11,
1583 p_attribute12,
1584 p_attribute13,
1585 p_attribute14,
1586 p_attribute15,
1587 p_attribute_category,
1588 p_assignee_role,
1589 p_show_on_calendar,
1590 p_category_id,
1591 p_enable_workflow,
1592 p_abort_workflow,
1593 p_free_busy_type,
1594 p_object_capacity_id);
1595
1596 -- copy data back from the local variables to OUT or IN-OUT args, if any
1597
1598
1599
1600
1601
1602
1603
1604
1605
1606
1607
1608
1609
1610
1611
1612
1613
1614
1615
1616
1617
1618
1619
1620
1621
1622
1623
1624
1625
1626
1627
1628
1629
1630
1631
1632
1633
1634
1635
1636
1637
1638
1639
1640
1641
1642
1643
1644
1645
1646
1647
1648
1649
1650
1651 end;
1652
1653 procedure update_task_assignment(p_api_version NUMBER
1654 , p_object_version_number in out nocopy NUMBER
1655 , p_init_msg_list VARCHAR2
1656 , p_commit VARCHAR2
1657 , p_task_assignment_id NUMBER
1658 , p_resource_type_code VARCHAR2
1659 , p_resource_id NUMBER
1660 , p_actual_effort NUMBER
1661 , p_actual_effort_uom VARCHAR2
1662 , p_schedule_flag VARCHAR2
1663 , p_alarm_type_code VARCHAR2
1664 , p_alarm_contact VARCHAR2
1665 , p_sched_travel_distance NUMBER
1666 , p_sched_travel_duration NUMBER
1667 , p_sched_travel_duration_uom VARCHAR2
1668 , p_actual_travel_distance NUMBER
1669 , p_actual_travel_duration NUMBER
1670 , p_actual_travel_duration_uom VARCHAR2
1671 , p_actual_start_date date
1672 , p_actual_end_date date
1673 , p_palm_flag VARCHAR2
1674 , p_wince_flag VARCHAR2
1675 , p_laptop_flag VARCHAR2
1676 , p_device1_flag VARCHAR2
1677 , p_device2_flag VARCHAR2
1678 , p_device3_flag VARCHAR2
1679 , p_resource_territory_id NUMBER
1680 , p_assignment_status_id NUMBER
1681 , p_shift_construct_id NUMBER
1682 , x_return_status out nocopy VARCHAR2
1683 , x_msg_count out nocopy NUMBER
1684 , x_msg_data out nocopy VARCHAR2
1685 , p_attribute1 VARCHAR2
1686 , p_attribute2 VARCHAR2
1687 , p_attribute3 VARCHAR2
1688 , p_attribute4 VARCHAR2
1689 , p_attribute5 VARCHAR2
1690 , p_attribute6 VARCHAR2
1691 , p_attribute7 VARCHAR2
1692 , p_attribute8 VARCHAR2
1693 , p_attribute9 VARCHAR2
1694 , p_attribute10 VARCHAR2
1695 , p_attribute11 VARCHAR2
1696 , p_attribute12 VARCHAR2
1697 , p_attribute13 VARCHAR2
1698 , p_attribute14 VARCHAR2
1699 , p_attribute15 VARCHAR2
1700 , p_attribute_category VARCHAR2
1701 , p_assignee_role VARCHAR2
1702 , p_show_on_calendar VARCHAR2
1703 , p_category_id NUMBER
1704 , p_enable_workflow VARCHAR2
1705 , p_abort_workflow VARCHAR2
1706 )
1707
1708 as
1709 ddp_actual_start_date date;
1710 ddp_actual_end_date date;
1711 ddindx binary_integer; indx binary_integer;
1712 begin
1713
1714 -- copy data to the local IN or IN-OUT args, if any
1715
1716
1717
1718
1719
1720
1721
1722
1723
1724
1725
1726
1727
1728
1729
1730
1731
1732
1733 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1734
1735 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1736
1737
1738
1739
1740
1741
1742
1743
1744
1745
1746
1747
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770 -- here's the delegated call to the old PL/SQL routine
1771 jtf_task_assignments_pvt.update_task_assignment(p_api_version,
1772 p_object_version_number,
1773 p_init_msg_list,
1774 p_commit,
1775 p_task_assignment_id,
1776 p_resource_type_code,
1777 p_resource_id,
1778 p_actual_effort,
1779 p_actual_effort_uom,
1780 p_schedule_flag,
1781 p_alarm_type_code,
1782 p_alarm_contact,
1783 p_sched_travel_distance,
1784 p_sched_travel_duration,
1785 p_sched_travel_duration_uom,
1786 p_actual_travel_distance,
1787 p_actual_travel_duration,
1788 p_actual_travel_duration_uom,
1789 ddp_actual_start_date,
1790 ddp_actual_end_date,
1794 p_device1_flag,
1791 p_palm_flag,
1792 p_wince_flag,
1793 p_laptop_flag,
1795 p_device2_flag,
1796 p_device3_flag,
1797 p_resource_territory_id,
1798 p_assignment_status_id,
1799 p_shift_construct_id,
1800 x_return_status,
1801 x_msg_count,
1802 x_msg_data,
1803 p_attribute1,
1804 p_attribute2,
1805 p_attribute3,
1806 p_attribute4,
1807 p_attribute5,
1808 p_attribute6,
1809 p_attribute7,
1810 p_attribute8,
1811 p_attribute9,
1812 p_attribute10,
1813 p_attribute11,
1814 p_attribute12,
1815 p_attribute13,
1816 p_attribute14,
1817 p_attribute15,
1818 p_attribute_category,
1819 p_assignee_role,
1820 p_show_on_calendar,
1821 p_category_id,
1822 p_enable_workflow,
1823 p_abort_workflow);
1824
1825 -- copy data back from the local variables to OUT or IN-OUT args, if any
1826
1827
1828
1829
1830
1831
1832
1833
1834
1835
1836
1837
1838
1839
1840
1841
1842
1843
1844
1845
1846
1847
1848
1849
1850
1851
1852
1853
1854
1855
1856
1857
1858
1859
1860
1861
1862
1863
1864
1865
1866
1867
1868
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878 end;
1879
1880 procedure update_task_assignment(p_api_version NUMBER
1881 , p_object_version_number in out nocopy NUMBER
1882 , p_init_msg_list VARCHAR2
1883 , p_commit VARCHAR2
1884 , p_task_assignment_id NUMBER
1885 , p_resource_type_code VARCHAR2
1886 , p_resource_id NUMBER
1887 , p_actual_effort NUMBER
1888 , p_actual_effort_uom VARCHAR2
1889 , p_schedule_flag VARCHAR2
1890 , p_alarm_type_code VARCHAR2
1891 , p_alarm_contact VARCHAR2
1892 , p_sched_travel_distance NUMBER
1893 , p_sched_travel_duration NUMBER
1894 , p_sched_travel_duration_uom VARCHAR2
1895 , p_actual_travel_distance NUMBER
1896 , p_actual_travel_duration NUMBER
1897 , p_actual_travel_duration_uom VARCHAR2
1898 , p_actual_start_date date
1899 , p_actual_end_date date
1900 , p_palm_flag VARCHAR2
1901 , p_wince_flag VARCHAR2
1902 , p_laptop_flag VARCHAR2
1903 , p_device1_flag VARCHAR2
1904 , p_device2_flag VARCHAR2
1905 , p_device3_flag VARCHAR2
1906 , p_resource_territory_id NUMBER
1907 , p_assignment_status_id NUMBER
1908 , p_shift_construct_id NUMBER
1909 , x_return_status out nocopy VARCHAR2
1910 , x_msg_count out nocopy NUMBER
1911 , x_msg_data out nocopy VARCHAR2
1912 , p_attribute1 VARCHAR2
1913 , p_attribute2 VARCHAR2
1914 , p_attribute3 VARCHAR2
1915 , p_attribute4 VARCHAR2
1916 , p_attribute5 VARCHAR2
1917 , p_attribute6 VARCHAR2
1918 , p_attribute7 VARCHAR2
1919 , p_attribute8 VARCHAR2
1920 , p_attribute9 VARCHAR2
1921 , p_attribute10 VARCHAR2
1922 , p_attribute11 VARCHAR2
1923 , p_attribute12 VARCHAR2
1924 , p_attribute13 VARCHAR2
1925 , p_attribute14 VARCHAR2
1926 , p_attribute15 VARCHAR2
1927 , p_attribute_category VARCHAR2
1928 , p_assignee_role VARCHAR2
1929 , p_show_on_calendar VARCHAR2
1930 , p_category_id NUMBER
1931 )
1932
1933 as
1934 ddp_actual_start_date date;
1935 ddp_actual_end_date date;
1936 ddindx binary_integer; indx binary_integer;
1937 begin
1938
1939 -- copy data to the local IN or IN-OUT args, if any
1940
1941
1942
1943
1944
1945
1946
1947
1948
1949
1950
1951
1952
1953
1954
1955
1956
1957
1958 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1959
1960 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993 -- here's the delegated call to the old PL/SQL routine
1994 jtf_task_assignments_pvt.update_task_assignment(p_api_version,
1995 p_object_version_number,
1996 p_init_msg_list,
1997 p_commit,
1998 p_task_assignment_id,
1999 p_resource_type_code,
2000 p_resource_id,
2001 p_actual_effort,
2002 p_actual_effort_uom,
2003 p_schedule_flag,
2004 p_alarm_type_code,
2005 p_alarm_contact,
2006 p_sched_travel_distance,
2007 p_sched_travel_duration,
2008 p_sched_travel_duration_uom,
2009 p_actual_travel_distance,
2010 p_actual_travel_duration,
2011 p_actual_travel_duration_uom,
2012 ddp_actual_start_date,
2013 ddp_actual_end_date,
2014 p_palm_flag,
2015 p_wince_flag,
2016 p_laptop_flag,
2017 p_device1_flag,
2018 p_device2_flag,
2019 p_device3_flag,
2020 p_resource_territory_id,
2021 p_assignment_status_id,
2022 p_shift_construct_id,
2023 x_return_status,
2024 x_msg_count,
2025 x_msg_data,
2026 p_attribute1,
2027 p_attribute2,
2028 p_attribute3,
2029 p_attribute4,
2030 p_attribute5,
2031 p_attribute6,
2032 p_attribute7,
2033 p_attribute8,
2034 p_attribute9,
2035 p_attribute10,
2036 p_attribute11,
2037 p_attribute12,
2038 p_attribute13,
2039 p_attribute14,
2040 p_attribute15,
2041 p_attribute_category,
2042 p_assignee_role,
2043 p_show_on_calendar,
2044 p_category_id);
2045
2046 -- copy data back from the local variables to OUT or IN-OUT args, if any
2047
2048
2049
2050
2051
2052
2053
2054
2055
2056
2057
2058
2059
2060
2061
2062
2063
2064
2065
2066
2067
2068
2069
2070
2071
2072
2073
2074
2075
2076
2077
2078
2079
2080
2081
2082
2083
2084
2085
2086
2087
2088
2089
2090
2091
2092
2093
2094
2095
2096
2097 end;
2098
2099 end jtf_task_assignments_pvt_w;