[Home] [Help]
Skip to content
PACKAGE BODY: APPS.JTF_TASK_ASSIGNMENTS_PUB_W
Source
1 package body jtf_task_assignments_pub_w as
2 /* $Header: jtfbtkab.pls 120.3 2006/04/26 04:16 knayyar ship $ */
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_task_number VARCHAR2
22 , p_task_name VARCHAR2
23 , p_resource_type_code VARCHAR2
24 , p_resource_id NUMBER
25 , p_resource_name NUMBER
26 , p_actual_effort NUMBER
27 , p_actual_effort_uom VARCHAR2
28 , p_schedule_flag VARCHAR2
29 , p_alarm_type_code VARCHAR2
30 , p_alarm_contact VARCHAR2
31 , p_sched_travel_distance NUMBER
32 , p_sched_travel_duration NUMBER
33 , p_sched_travel_duration_uom VARCHAR2
34 , p_actual_travel_distance NUMBER
35 , p_actual_travel_duration NUMBER
36 , p_actual_travel_duration_uom VARCHAR2
37 , p_actual_start_date date
38 , p_actual_end_date date
39 , p_palm_flag VARCHAR2
40 , p_wince_flag VARCHAR2
41 , p_laptop_flag VARCHAR2
42 , p_device1_flag VARCHAR2
43 , p_device2_flag VARCHAR2
44 , p_device3_flag VARCHAR2
45 , p_resource_territory_id NUMBER
46 , p_assignment_status_id NUMBER
47 , p_shift_construct_id NUMBER
48 , x_return_status out nocopy VARCHAR2
49 , x_msg_count out nocopy NUMBER
50 , x_msg_data out nocopy VARCHAR2
51 , x_task_assignment_id out nocopy NUMBER
52 , p_attribute1 VARCHAR2
53 , p_attribute2 VARCHAR2
54 , p_attribute3 VARCHAR2
55 , p_attribute4 VARCHAR2
56 , p_attribute5 VARCHAR2
57 , p_attribute6 VARCHAR2
58 , p_attribute7 VARCHAR2
59 , p_attribute8 VARCHAR2
60 , p_attribute9 VARCHAR2
61 , p_attribute10 VARCHAR2
62 , p_attribute11 VARCHAR2
63 , p_attribute12 VARCHAR2
64 , p_attribute13 VARCHAR2
65 , p_attribute14 VARCHAR2
66 , p_attribute15 VARCHAR2
67 , p_attribute_category VARCHAR2
68 , p_show_on_calendar VARCHAR2
69 , p_category_id NUMBER
70 , p_enable_workflow VARCHAR2
71 , p_abort_workflow VARCHAR2
72 , p_object_capacity_id NUMBER
73 , p_free_busy_type VARCHAR2
74 )
75
76 as
77 ddp_actual_start_date date;
78 ddp_actual_end_date date;
79 ddindx binary_integer; indx binary_integer;
80 begin
81
82 -- copy data to the local IN or IN-OUT args, if any
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
105
106 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
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
140
141
142
143 -- here's the delegated call to the old PL/SQL routine
144 jtf_task_assignments_pub.create_task_assignment(p_api_version,
145 p_init_msg_list,
146 p_commit,
147 p_task_assignment_id,
148 p_task_id,
149 p_task_number,
150 p_task_name,
151 p_resource_type_code,
152 p_resource_id,
153 p_resource_name,
154 p_actual_effort,
155 p_actual_effort_uom,
156 p_schedule_flag,
157 p_alarm_type_code,
158 p_alarm_contact,
159 p_sched_travel_distance,
160 p_sched_travel_duration,
161 p_sched_travel_duration_uom,
162 p_actual_travel_distance,
163 p_actual_travel_duration,
164 p_actual_travel_duration_uom,
165 ddp_actual_start_date,
166 ddp_actual_end_date,
167 p_palm_flag,
168 p_wince_flag,
169 p_laptop_flag,
170 p_device1_flag,
171 p_device2_flag,
172 p_device3_flag,
173 p_resource_territory_id,
174 p_assignment_status_id,
175 p_shift_construct_id,
176 x_return_status,
177 x_msg_count,
178 x_msg_data,
179 x_task_assignment_id,
180 p_attribute1,
181 p_attribute2,
182 p_attribute3,
183 p_attribute4,
184 p_attribute5,
185 p_attribute6,
186 p_attribute7,
187 p_attribute8,
188 p_attribute9,
189 p_attribute10,
190 p_attribute11,
191 p_attribute12,
192 p_attribute13,
193 p_attribute14,
194 p_attribute15,
195 p_attribute_category,
196 p_show_on_calendar,
197 p_category_id,
198 p_enable_workflow,
199 p_abort_workflow,
200 p_object_capacity_id,
201 p_free_busy_type);
202
203 -- copy data back from the local variables to OUT or IN-OUT args, if any
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
254
255
256
257
258
259
260
261 end;
262
263 procedure create_task_assignment(p_api_version NUMBER
264 , p_init_msg_list VARCHAR2
265 , p_commit VARCHAR2
266 , p_task_assignment_id NUMBER
267 , p_task_id NUMBER
268 , p_task_number VARCHAR2
269 , p_task_name VARCHAR2
270 , p_resource_type_code VARCHAR2
271 , p_resource_id NUMBER
272 , p_resource_name NUMBER
273 , p_actual_effort NUMBER
274 , p_actual_effort_uom VARCHAR2
275 , p_schedule_flag VARCHAR2
276 , p_alarm_type_code VARCHAR2
277 , p_alarm_contact VARCHAR2
278 , p_sched_travel_distance NUMBER
279 , p_sched_travel_duration NUMBER
280 , p_sched_travel_duration_uom VARCHAR2
281 , p_actual_travel_distance NUMBER
282 , p_actual_travel_duration NUMBER
283 , p_actual_travel_duration_uom VARCHAR2
284 , p_actual_start_date date
285 , p_actual_end_date date
286 , p_palm_flag VARCHAR2
287 , p_wince_flag VARCHAR2
288 , p_laptop_flag VARCHAR2
289 , p_device1_flag VARCHAR2
290 , p_device2_flag VARCHAR2
291 , p_device3_flag VARCHAR2
292 , p_resource_territory_id NUMBER
293 , p_assignment_status_id NUMBER
294 , p_shift_construct_id NUMBER
295 , x_return_status out nocopy VARCHAR2
296 , x_msg_count out nocopy NUMBER
297 , x_msg_data out nocopy VARCHAR2
298 , x_task_assignment_id out nocopy NUMBER
299 , p_attribute1 VARCHAR2
300 , p_attribute2 VARCHAR2
301 , p_attribute3 VARCHAR2
302 , p_attribute4 VARCHAR2
303 , p_attribute5 VARCHAR2
304 , p_attribute6 VARCHAR2
305 , p_attribute7 VARCHAR2
306 , p_attribute8 VARCHAR2
307 , p_attribute9 VARCHAR2
308 , p_attribute10 VARCHAR2
309 , p_attribute11 VARCHAR2
310 , p_attribute12 VARCHAR2
311 , p_attribute13 VARCHAR2
312 , p_attribute14 VARCHAR2
313 , p_attribute15 VARCHAR2
314 , p_attribute_category VARCHAR2
315 , p_show_on_calendar VARCHAR2
316 , p_category_id NUMBER
317 , p_enable_workflow VARCHAR2
318 , p_abort_workflow VARCHAR2
319 , p_object_capacity_id NUMBER
320 )
321
322 as
323 ddp_actual_start_date date;
324 ddp_actual_end_date date;
325 ddindx binary_integer; indx binary_integer;
326 begin
327
328 -- copy data to the local IN or IN-OUT args, if any
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
351
352 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
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
381
382
383
384
385
386
387
388 -- here's the delegated call to the old PL/SQL routine
389 jtf_task_assignments_pub.create_task_assignment(p_api_version,
390 p_init_msg_list,
391 p_commit,
392 p_task_assignment_id,
393 p_task_id,
394 p_task_number,
395 p_task_name,
396 p_resource_type_code,
397 p_resource_id,
398 p_resource_name,
399 p_actual_effort,
400 p_actual_effort_uom,
401 p_schedule_flag,
402 p_alarm_type_code,
403 p_alarm_contact,
404 p_sched_travel_distance,
405 p_sched_travel_duration,
406 p_sched_travel_duration_uom,
407 p_actual_travel_distance,
408 p_actual_travel_duration,
409 p_actual_travel_duration_uom,
410 ddp_actual_start_date,
411 ddp_actual_end_date,
412 p_palm_flag,
413 p_wince_flag,
414 p_laptop_flag,
415 p_device1_flag,
416 p_device2_flag,
417 p_device3_flag,
418 p_resource_territory_id,
419 p_assignment_status_id,
420 p_shift_construct_id,
421 x_return_status,
422 x_msg_count,
423 x_msg_data,
424 x_task_assignment_id,
425 p_attribute1,
426 p_attribute2,
427 p_attribute3,
428 p_attribute4,
429 p_attribute5,
430 p_attribute6,
431 p_attribute7,
432 p_attribute8,
433 p_attribute9,
434 p_attribute10,
435 p_attribute11,
436 p_attribute12,
437 p_attribute13,
438 p_attribute14,
439 p_attribute15,
440 p_attribute_category,
441 p_show_on_calendar,
442 p_category_id,
443 p_enable_workflow,
444 p_abort_workflow,
445 p_object_capacity_id);
446
447 -- copy data back from the local variables to OUT or IN-OUT args, if any
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
497
498
499
500
501
502
503
504 end;
505
506 procedure create_task_assignment(p_api_version NUMBER
507 , p_init_msg_list VARCHAR2
508 , p_commit VARCHAR2
509 , p_task_assignment_id NUMBER
510 , p_task_id NUMBER
511 , p_task_number VARCHAR2
512 , p_task_name VARCHAR2
513 , p_resource_type_code VARCHAR2
514 , p_resource_id NUMBER
515 , p_resource_name NUMBER
516 , p_actual_effort NUMBER
517 , p_actual_effort_uom VARCHAR2
518 , p_schedule_flag VARCHAR2
519 , p_alarm_type_code VARCHAR2
520 , p_alarm_contact VARCHAR2
521 , p_sched_travel_distance NUMBER
522 , p_sched_travel_duration NUMBER
523 , p_sched_travel_duration_uom VARCHAR2
524 , p_actual_travel_distance NUMBER
525 , p_actual_travel_duration NUMBER
526 , p_actual_travel_duration_uom VARCHAR2
527 , p_actual_start_date date
528 , p_actual_end_date date
529 , p_palm_flag VARCHAR2
530 , p_wince_flag VARCHAR2
531 , p_laptop_flag VARCHAR2
532 , p_device1_flag VARCHAR2
533 , p_device2_flag VARCHAR2
534 , p_device3_flag VARCHAR2
535 , p_resource_territory_id NUMBER
536 , p_assignment_status_id NUMBER
537 , p_shift_construct_id NUMBER
538 , x_return_status out nocopy VARCHAR2
539 , x_msg_count out nocopy NUMBER
540 , x_msg_data out nocopy VARCHAR2
541 , x_task_assignment_id out nocopy NUMBER
542 , p_attribute1 VARCHAR2
543 , p_attribute2 VARCHAR2
544 , p_attribute3 VARCHAR2
545 , p_attribute4 VARCHAR2
546 , p_attribute5 VARCHAR2
547 , p_attribute6 VARCHAR2
548 , p_attribute7 VARCHAR2
549 , p_attribute8 VARCHAR2
550 , p_attribute9 VARCHAR2
551 , p_attribute10 VARCHAR2
552 , p_attribute11 VARCHAR2
553 , p_attribute12 VARCHAR2
554 , p_attribute13 VARCHAR2
555 , p_attribute14 VARCHAR2
556 , p_attribute15 VARCHAR2
557 , p_attribute_category VARCHAR2
558 , p_show_on_calendar VARCHAR2
559 , p_category_id NUMBER
560 , p_enable_workflow VARCHAR2
561 , p_abort_workflow VARCHAR2
562 )
563
564 as
565 ddp_actual_start_date date;
566 ddp_actual_end_date date;
567 ddindx binary_integer; indx binary_integer;
568 begin
569
570 -- copy data to the local IN or IN-OUT args, if any
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
593
594 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
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
620
621
622
623
624
625
626
627
628
629 -- here's the delegated call to the old PL/SQL routine
630 jtf_task_assignments_pub.create_task_assignment(p_api_version,
631 p_init_msg_list,
632 p_commit,
633 p_task_assignment_id,
634 p_task_id,
635 p_task_number,
636 p_task_name,
637 p_resource_type_code,
638 p_resource_id,
639 p_resource_name,
640 p_actual_effort,
641 p_actual_effort_uom,
642 p_schedule_flag,
643 p_alarm_type_code,
644 p_alarm_contact,
645 p_sched_travel_distance,
646 p_sched_travel_duration,
647 p_sched_travel_duration_uom,
648 p_actual_travel_distance,
649 p_actual_travel_duration,
650 p_actual_travel_duration_uom,
651 ddp_actual_start_date,
652 ddp_actual_end_date,
653 p_palm_flag,
654 p_wince_flag,
655 p_laptop_flag,
656 p_device1_flag,
657 p_device2_flag,
658 p_device3_flag,
659 p_resource_territory_id,
660 p_assignment_status_id,
661 p_shift_construct_id,
662 x_return_status,
663 x_msg_count,
664 x_msg_data,
665 x_task_assignment_id,
666 p_attribute1,
667 p_attribute2,
668 p_attribute3,
669 p_attribute4,
670 p_attribute5,
671 p_attribute6,
672 p_attribute7,
673 p_attribute8,
674 p_attribute9,
675 p_attribute10,
676 p_attribute11,
677 p_attribute12,
678 p_attribute13,
679 p_attribute14,
680 p_attribute15,
681 p_attribute_category,
682 p_show_on_calendar,
683 p_category_id,
684 p_enable_workflow,
685 p_abort_workflow);
686
687 -- copy data back from the local variables to OUT or IN-OUT args, if any
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
732
733
734
735
736
737
738
739
740
741
742
743 end;
744
745 procedure create_task_assignment(p_api_version NUMBER
746 , p_init_msg_list VARCHAR2
747 , p_commit VARCHAR2
748 , p_task_assignment_id NUMBER
749 , p_task_id NUMBER
750 , p_task_number VARCHAR2
751 , p_task_name VARCHAR2
752 , p_resource_type_code VARCHAR2
753 , p_resource_id NUMBER
754 , p_resource_name NUMBER
755 , p_actual_effort NUMBER
756 , p_actual_effort_uom VARCHAR2
757 , p_schedule_flag VARCHAR2
758 , p_alarm_type_code VARCHAR2
759 , p_alarm_contact VARCHAR2
760 , p_sched_travel_distance NUMBER
761 , p_sched_travel_duration NUMBER
762 , p_sched_travel_duration_uom VARCHAR2
763 , p_actual_travel_distance NUMBER
764 , p_actual_travel_duration NUMBER
765 , p_actual_travel_duration_uom VARCHAR2
766 , p_actual_start_date date
767 , p_actual_end_date date
768 , p_palm_flag VARCHAR2
769 , p_wince_flag VARCHAR2
770 , p_laptop_flag VARCHAR2
771 , p_device1_flag VARCHAR2
772 , p_device2_flag VARCHAR2
773 , p_device3_flag VARCHAR2
774 , p_resource_territory_id NUMBER
775 , p_assignment_status_id NUMBER
776 , p_shift_construct_id NUMBER
777 , x_return_status out nocopy VARCHAR2
778 , x_msg_count out nocopy NUMBER
779 , x_msg_data out nocopy VARCHAR2
780 , x_task_assignment_id out nocopy NUMBER
781 , p_attribute1 VARCHAR2
782 , p_attribute2 VARCHAR2
783 , p_attribute3 VARCHAR2
784 , p_attribute4 VARCHAR2
785 , p_attribute5 VARCHAR2
786 , p_attribute6 VARCHAR2
787 , p_attribute7 VARCHAR2
788 , p_attribute8 VARCHAR2
789 , p_attribute9 VARCHAR2
790 , p_attribute10 VARCHAR2
791 , p_attribute11 VARCHAR2
792 , p_attribute12 VARCHAR2
793 , p_attribute13 VARCHAR2
794 , p_attribute14 VARCHAR2
795 , p_attribute15 VARCHAR2
796 , p_attribute_category VARCHAR2
797 , p_show_on_calendar VARCHAR2
798 , p_category_id NUMBER
799 )
800
801 as
802 ddp_actual_start_date date;
803 ddp_actual_end_date date;
804 ddindx binary_integer; indx binary_integer;
805 begin
806
807 -- copy data to the local IN or IN-OUT args, if any
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
830
831 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864 -- here's the delegated call to the old PL/SQL routine
865 jtf_task_assignments_pub.create_task_assignment(p_api_version,
866 p_init_msg_list,
867 p_commit,
868 p_task_assignment_id,
869 p_task_id,
870 p_task_number,
871 p_task_name,
872 p_resource_type_code,
873 p_resource_id,
874 p_resource_name,
875 p_actual_effort,
876 p_actual_effort_uom,
877 p_schedule_flag,
878 p_alarm_type_code,
879 p_alarm_contact,
880 p_sched_travel_distance,
881 p_sched_travel_duration,
882 p_sched_travel_duration_uom,
883 p_actual_travel_distance,
884 p_actual_travel_duration,
885 p_actual_travel_duration_uom,
886 ddp_actual_start_date,
887 ddp_actual_end_date,
888 p_palm_flag,
889 p_wince_flag,
890 p_laptop_flag,
891 p_device1_flag,
892 p_device2_flag,
893 p_device3_flag,
894 p_resource_territory_id,
895 p_assignment_status_id,
896 p_shift_construct_id,
897 x_return_status,
898 x_msg_count,
899 x_msg_data,
900 x_task_assignment_id,
901 p_attribute1,
902 p_attribute2,
903 p_attribute3,
904 p_attribute4,
905 p_attribute5,
906 p_attribute6,
907 p_attribute7,
908 p_attribute8,
909 p_attribute9,
910 p_attribute10,
911 p_attribute11,
912 p_attribute12,
913 p_attribute13,
914 p_attribute14,
915 p_attribute15,
916 p_attribute_category,
917 p_show_on_calendar,
918 p_category_id);
919
920 -- copy data back from the local variables to OUT or IN-OUT args, if any
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
963
964
965
966
967
968
969
970
971
972
973
974 end;
975
976 procedure update_task_assignment(p_api_version NUMBER
977 , p_object_version_number in out nocopy NUMBER
978 , p_init_msg_list VARCHAR2
979 , p_commit VARCHAR2
980 , p_task_assignment_id NUMBER
981 , p_task_id NUMBER
982 , p_task_number VARCHAR2
983 , p_task_name VARCHAR2
984 , p_resource_type_code VARCHAR2
985 , p_resource_id NUMBER
986 , p_resource_name VARCHAR2
987 , p_actual_effort NUMBER
988 , p_actual_effort_uom VARCHAR2
989 , p_schedule_flag VARCHAR2
990 , p_alarm_type_code VARCHAR2
991 , p_alarm_contact VARCHAR2
992 , p_sched_travel_distance NUMBER
993 , p_sched_travel_duration NUMBER
994 , p_sched_travel_duration_uom VARCHAR2
995 , p_actual_travel_distance NUMBER
996 , p_actual_travel_duration NUMBER
997 , p_actual_travel_duration_uom VARCHAR2
998 , p_actual_start_date date
999 , p_actual_end_date date
1000 , p_palm_flag VARCHAR2
1001 , p_wince_flag VARCHAR2
1002 , p_laptop_flag VARCHAR2
1003 , p_device1_flag VARCHAR2
1004 , p_device2_flag VARCHAR2
1005 , p_device3_flag VARCHAR2
1006 , p_resource_territory_id NUMBER
1007 , p_assignment_status_id NUMBER
1008 , p_shift_construct_id NUMBER
1009 , x_return_status out nocopy VARCHAR2
1010 , x_msg_count out nocopy NUMBER
1011 , x_msg_data out nocopy VARCHAR2
1012 , p_attribute1 VARCHAR2
1013 , p_attribute2 VARCHAR2
1014 , p_attribute3 VARCHAR2
1015 , p_attribute4 VARCHAR2
1016 , p_attribute5 VARCHAR2
1017 , p_attribute6 VARCHAR2
1018 , p_attribute7 VARCHAR2
1019 , p_attribute8 VARCHAR2
1020 , p_attribute9 VARCHAR2
1021 , p_attribute10 VARCHAR2
1022 , p_attribute11 VARCHAR2
1023 , p_attribute12 VARCHAR2
1024 , p_attribute13 VARCHAR2
1025 , p_attribute14 VARCHAR2
1026 , p_attribute15 VARCHAR2
1027 , p_attribute_category VARCHAR2
1028 , p_show_on_calendar VARCHAR2
1029 , p_category_id NUMBER
1030 , p_enable_workflow VARCHAR2
1031 , p_abort_workflow VARCHAR2
1032 , p_object_capacity_id NUMBER
1033 )
1034
1035 as
1036 ddp_actual_start_date date;
1037 ddp_actual_end_date date;
1038 ddindx binary_integer; indx binary_integer;
1039 begin
1040
1041 -- copy data to the local IN or IN-OUT args, if any
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1065
1066 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101 -- here's the delegated call to the old PL/SQL routine
1102 jtf_task_assignments_pub.update_task_assignment(p_api_version,
1103 p_object_version_number,
1104 p_init_msg_list,
1105 p_commit,
1106 p_task_assignment_id,
1107 p_task_id,
1108 p_task_number,
1109 p_task_name,
1110 p_resource_type_code,
1111 p_resource_id,
1112 p_resource_name,
1113 p_actual_effort,
1114 p_actual_effort_uom,
1115 p_schedule_flag,
1116 p_alarm_type_code,
1117 p_alarm_contact,
1118 p_sched_travel_distance,
1119 p_sched_travel_duration,
1120 p_sched_travel_duration_uom,
1121 p_actual_travel_distance,
1122 p_actual_travel_duration,
1123 p_actual_travel_duration_uom,
1124 ddp_actual_start_date,
1125 ddp_actual_end_date,
1126 p_palm_flag,
1127 p_wince_flag,
1128 p_laptop_flag,
1129 p_device1_flag,
1130 p_device2_flag,
1131 p_device3_flag,
1132 p_resource_territory_id,
1133 p_assignment_status_id,
1134 p_shift_construct_id,
1135 x_return_status,
1136 x_msg_count,
1137 x_msg_data,
1138 p_attribute1,
1139 p_attribute2,
1140 p_attribute3,
1141 p_attribute4,
1142 p_attribute5,
1143 p_attribute6,
1144 p_attribute7,
1145 p_attribute8,
1146 p_attribute9,
1147 p_attribute10,
1148 p_attribute11,
1149 p_attribute12,
1150 p_attribute13,
1151 p_attribute14,
1152 p_attribute15,
1153 p_attribute_category,
1154 p_show_on_calendar,
1155 p_category_id,
1156 p_enable_workflow,
1157 p_abort_workflow,
1158 p_object_capacity_id);
1159
1160 -- copy data back from the local variables to OUT or IN-OUT args, if any
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
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217 end;
1218
1219 procedure update_task_assignment(p_api_version NUMBER
1220 , p_object_version_number in out nocopy NUMBER
1221 , p_init_msg_list VARCHAR2
1222 , p_commit VARCHAR2
1223 , p_task_assignment_id NUMBER
1224 , p_task_id NUMBER
1225 , p_task_number VARCHAR2
1226 , p_task_name VARCHAR2
1227 , p_resource_type_code VARCHAR2
1228 , p_resource_id NUMBER
1229 , p_resource_name VARCHAR2
1230 , p_actual_effort NUMBER
1231 , p_actual_effort_uom VARCHAR2
1232 , p_schedule_flag VARCHAR2
1233 , p_alarm_type_code VARCHAR2
1234 , p_alarm_contact VARCHAR2
1235 , p_sched_travel_distance NUMBER
1236 , p_sched_travel_duration NUMBER
1237 , p_sched_travel_duration_uom VARCHAR2
1238 , p_actual_travel_distance NUMBER
1239 , p_actual_travel_duration NUMBER
1240 , p_actual_travel_duration_uom VARCHAR2
1241 , p_actual_start_date date
1242 , p_actual_end_date date
1243 , p_palm_flag VARCHAR2
1244 , p_wince_flag VARCHAR2
1245 , p_laptop_flag VARCHAR2
1246 , p_device1_flag VARCHAR2
1247 , p_device2_flag VARCHAR2
1248 , p_device3_flag VARCHAR2
1249 , p_resource_territory_id NUMBER
1250 , p_assignment_status_id NUMBER
1251 , p_shift_construct_id NUMBER
1252 , x_return_status out nocopy VARCHAR2
1253 , x_msg_count out nocopy NUMBER
1254 , x_msg_data out nocopy VARCHAR2
1255 , p_attribute1 VARCHAR2
1256 , p_attribute2 VARCHAR2
1257 , p_attribute3 VARCHAR2
1258 , p_attribute4 VARCHAR2
1259 , p_attribute5 VARCHAR2
1260 , p_attribute6 VARCHAR2
1261 , p_attribute7 VARCHAR2
1262 , p_attribute8 VARCHAR2
1263 , p_attribute9 VARCHAR2
1264 , p_attribute10 VARCHAR2
1265 , p_attribute11 VARCHAR2
1266 , p_attribute12 VARCHAR2
1267 , p_attribute13 VARCHAR2
1268 , p_attribute14 VARCHAR2
1269 , p_attribute15 VARCHAR2
1270 , p_attribute_category VARCHAR2
1271 , p_show_on_calendar VARCHAR2
1272 , p_category_id NUMBER
1273 , p_enable_workflow VARCHAR2
1274 , p_abort_workflow VARCHAR2
1275 )
1276
1277 as
1278 ddp_actual_start_date date;
1279 ddp_actual_end_date date;
1280 ddindx binary_integer; indx binary_integer;
1281 begin
1282
1283 -- copy data to the local IN or IN-OUT args, if any
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1307
1308 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342 -- here's the delegated call to the old PL/SQL routine
1343 jtf_task_assignments_pub.update_task_assignment(p_api_version,
1344 p_object_version_number,
1345 p_init_msg_list,
1346 p_commit,
1347 p_task_assignment_id,
1348 p_task_id,
1349 p_task_number,
1350 p_task_name,
1351 p_resource_type_code,
1352 p_resource_id,
1353 p_resource_name,
1354 p_actual_effort,
1355 p_actual_effort_uom,
1356 p_schedule_flag,
1357 p_alarm_type_code,
1358 p_alarm_contact,
1359 p_sched_travel_distance,
1360 p_sched_travel_duration,
1361 p_sched_travel_duration_uom,
1362 p_actual_travel_distance,
1363 p_actual_travel_duration,
1364 p_actual_travel_duration_uom,
1365 ddp_actual_start_date,
1366 ddp_actual_end_date,
1367 p_palm_flag,
1368 p_wince_flag,
1369 p_laptop_flag,
1370 p_device1_flag,
1371 p_device2_flag,
1372 p_device3_flag,
1373 p_resource_territory_id,
1374 p_assignment_status_id,
1375 p_shift_construct_id,
1376 x_return_status,
1377 x_msg_count,
1378 x_msg_data,
1379 p_attribute1,
1380 p_attribute2,
1381 p_attribute3,
1382 p_attribute4,
1383 p_attribute5,
1384 p_attribute6,
1385 p_attribute7,
1386 p_attribute8,
1387 p_attribute9,
1388 p_attribute10,
1389 p_attribute11,
1390 p_attribute12,
1391 p_attribute13,
1392 p_attribute14,
1393 p_attribute15,
1394 p_attribute_category,
1395 p_show_on_calendar,
1396 p_category_id,
1397 p_enable_workflow,
1398 p_abort_workflow);
1399
1400 -- copy data back from the local variables to OUT or IN-OUT args, if any
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
1454
1455
1456 end;
1457
1458 procedure update_task_assignment(p_api_version NUMBER
1459 , p_object_version_number in out nocopy NUMBER
1460 , p_init_msg_list VARCHAR2
1461 , p_commit VARCHAR2
1462 , p_task_assignment_id NUMBER
1463 , p_task_id NUMBER
1464 , p_task_number VARCHAR2
1465 , p_task_name VARCHAR2
1466 , p_resource_type_code VARCHAR2
1467 , p_resource_id NUMBER
1468 , p_resource_name VARCHAR2
1469 , p_actual_effort NUMBER
1470 , p_actual_effort_uom VARCHAR2
1471 , p_schedule_flag VARCHAR2
1472 , p_alarm_type_code VARCHAR2
1473 , p_alarm_contact VARCHAR2
1474 , p_sched_travel_distance NUMBER
1475 , p_sched_travel_duration NUMBER
1476 , p_sched_travel_duration_uom VARCHAR2
1477 , p_actual_travel_distance NUMBER
1478 , p_actual_travel_duration NUMBER
1479 , p_actual_travel_duration_uom VARCHAR2
1480 , p_actual_start_date date
1481 , p_actual_end_date date
1482 , p_palm_flag VARCHAR2
1483 , p_wince_flag VARCHAR2
1484 , p_laptop_flag VARCHAR2
1485 , p_device1_flag VARCHAR2
1486 , p_device2_flag VARCHAR2
1487 , p_device3_flag VARCHAR2
1488 , p_resource_territory_id NUMBER
1489 , p_assignment_status_id NUMBER
1490 , p_shift_construct_id NUMBER
1491 , x_return_status out nocopy VARCHAR2
1492 , x_msg_count out nocopy NUMBER
1493 , x_msg_data out nocopy VARCHAR2
1494 , p_attribute1 VARCHAR2
1495 , p_attribute2 VARCHAR2
1496 , p_attribute3 VARCHAR2
1497 , p_attribute4 VARCHAR2
1498 , p_attribute5 VARCHAR2
1499 , p_attribute6 VARCHAR2
1500 , p_attribute7 VARCHAR2
1501 , p_attribute8 VARCHAR2
1502 , p_attribute9 VARCHAR2
1503 , p_attribute10 VARCHAR2
1504 , p_attribute11 VARCHAR2
1505 , p_attribute12 VARCHAR2
1506 , p_attribute13 VARCHAR2
1507 , p_attribute14 VARCHAR2
1508 , p_attribute15 VARCHAR2
1509 , p_attribute_category VARCHAR2
1510 , p_show_on_calendar VARCHAR2
1511 , p_category_id NUMBER
1512 )
1513
1514 as
1515 ddp_actual_start_date date;
1516 ddp_actual_end_date date;
1517 ddindx binary_integer; indx binary_integer;
1518 begin
1519
1520 -- copy data to the local IN or IN-OUT args, if any
1521
1522
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1544
1545 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576
1577 -- here's the delegated call to the old PL/SQL routine
1578 jtf_task_assignments_pub.update_task_assignment(p_api_version,
1579 p_object_version_number,
1580 p_init_msg_list,
1581 p_commit,
1582 p_task_assignment_id,
1583 p_task_id,
1584 p_task_number,
1585 p_task_name,
1586 p_resource_type_code,
1587 p_resource_id,
1588 p_resource_name,
1589 p_actual_effort,
1590 p_actual_effort_uom,
1591 p_schedule_flag,
1592 p_alarm_type_code,
1593 p_alarm_contact,
1594 p_sched_travel_distance,
1595 p_sched_travel_duration,
1596 p_sched_travel_duration_uom,
1597 p_actual_travel_distance,
1598 p_actual_travel_duration,
1599 p_actual_travel_duration_uom,
1600 ddp_actual_start_date,
1601 ddp_actual_end_date,
1602 p_palm_flag,
1603 p_wince_flag,
1604 p_laptop_flag,
1605 p_device1_flag,
1606 p_device2_flag,
1607 p_device3_flag,
1608 p_resource_territory_id,
1609 p_assignment_status_id,
1610 p_shift_construct_id,
1611 x_return_status,
1612 x_msg_count,
1613 x_msg_data,
1614 p_attribute1,
1615 p_attribute2,
1616 p_attribute3,
1617 p_attribute4,
1618 p_attribute5,
1619 p_attribute6,
1620 p_attribute7,
1621 p_attribute8,
1622 p_attribute9,
1623 p_attribute10,
1624 p_attribute11,
1625 p_attribute12,
1626 p_attribute13,
1627 p_attribute14,
1628 p_attribute15,
1629 p_attribute_category,
1630 p_show_on_calendar,
1631 p_category_id);
1632
1633 -- copy data back from the local variables to OUT or IN-OUT args, if any
1634
1635
1636
1637
1638
1639
1640
1641
1642
1643
1644
1645
1646
1647
1648
1649
1650
1651
1652
1653
1654
1655
1656
1657
1658
1659
1660
1661
1662
1663
1664
1665
1666
1667
1668
1669
1670
1671
1672
1673
1674
1675
1676
1677
1678
1679
1680
1681
1682
1683
1684
1685
1686
1687 end;
1688
1689 end jtf_task_assignments_pub_w;