[Home] [Help]
PACKAGE BODY: APPS.JTF_TASKS_PVT_W
Source
1 package body jtf_tasks_pvt_w as
2 /* $Header: jtfrtktb.pls 120.4 2006/04/26 04:38 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(p_api_version NUMBER
17 , p_init_msg_list VARCHAR2
18 , p_commit VARCHAR2
19 , p_task_id NUMBER
20 , p_task_name VARCHAR2
21 , p_task_type_id NUMBER
22 , p_description VARCHAR2
23 , p_task_status_id NUMBER
24 , p_task_priority_id NUMBER
25 , p_owner_type_code VARCHAR2
26 , p_owner_id NUMBER
27 , p_owner_territory_id NUMBER
28 , p_assigned_by_id NUMBER
29 , p_customer_id NUMBER
30 , p_cust_account_id NUMBER
31 , p_address_id NUMBER
32 , p_planned_start_date date
33 , p_planned_end_date date
34 , p_scheduled_start_date date
35 , p_scheduled_end_date date
36 , p_actual_start_date date
37 , p_actual_end_date date
38 , p_timezone_id NUMBER
39 , p_source_object_type_code VARCHAR2
40 , p_source_object_id NUMBER
41 , p_source_object_name VARCHAR2
42 , p_duration NUMBER
43 , p_duration_uom VARCHAR2
44 , p_planned_effort NUMBER
45 , p_planned_effort_uom VARCHAR2
46 , p_actual_effort NUMBER
47 , p_actual_effort_uom VARCHAR2
48 , p_percentage_complete NUMBER
49 , p_reason_code VARCHAR2
50 , p_private_flag VARCHAR2
51 , p_publish_flag VARCHAR2
52 , p_restrict_closure_flag VARCHAR2
53 , p_multi_booked_flag VARCHAR2
54 , p_milestone_flag VARCHAR2
55 , p_holiday_flag VARCHAR2
56 , p_billable_flag VARCHAR2
57 , p_bound_mode_code VARCHAR2
58 , p_soft_bound_flag VARCHAR2
59 , p_workflow_process_id NUMBER
60 , p_notification_flag VARCHAR2
61 , p_notification_period NUMBER
62 , p_notification_period_uom VARCHAR2
63 , p_parent_task_id NUMBER
64 , p_alarm_start NUMBER
65 , p_alarm_start_uom VARCHAR2
66 , p_alarm_on VARCHAR2
67 , p_alarm_count NUMBER
68 , p_alarm_interval NUMBER
69 , p_alarm_interval_uom VARCHAR2
70 , p_palm_flag VARCHAR2
71 , p_wince_flag VARCHAR2
72 , p_laptop_flag VARCHAR2
73 , p_device1_flag VARCHAR2
74 , p_device2_flag VARCHAR2
75 , p_device3_flag VARCHAR2
76 , p_costs NUMBER
77 , p_currency_code VARCHAR2
78 , p_escalation_level VARCHAR2
79 , x_return_status out nocopy VARCHAR2
80 , x_msg_count out nocopy NUMBER
81 , x_msg_data out nocopy VARCHAR2
82 , x_task_id out nocopy NUMBER
83 , p_attribute1 VARCHAR2
84 , p_attribute2 VARCHAR2
85 , p_attribute3 VARCHAR2
86 , p_attribute4 VARCHAR2
87 , p_attribute5 VARCHAR2
88 , p_attribute6 VARCHAR2
89 , p_attribute7 VARCHAR2
90 , p_attribute8 VARCHAR2
91 , p_attribute9 VARCHAR2
92 , p_attribute10 VARCHAR2
93 , p_attribute11 VARCHAR2
94 , p_attribute12 VARCHAR2
95 , p_attribute13 VARCHAR2
96 , p_attribute14 VARCHAR2
97 , p_attribute15 VARCHAR2
98 , p_attribute_category VARCHAR2
99 , p_date_selected VARCHAR2
100 , p_category_id NUMBER
101 , p_show_on_calendar VARCHAR2
102 , p_owner_status_id NUMBER
103 , p_template_id NUMBER
104 , p_template_group_id NUMBER
105 , p_enable_workflow VARCHAR2
106 , p_abort_workflow VARCHAR2
107 )
108
109 as
110 ddp_planned_start_date date;
111 ddp_planned_end_date date;
112 ddp_scheduled_start_date date;
113 ddp_scheduled_end_date date;
114 ddp_actual_start_date date;
115 ddp_actual_end_date date;
116 ddindx binary_integer; indx binary_integer;
117 begin
118
119 -- copy data to the local IN or IN-OUT args, if any
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
137
138 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
139
140 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
141
142 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
143
144 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
145
146 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217 -- here's the delegated call to the old PL/SQL routine
218 jtf_tasks_pvt.create_task(p_api_version,
219 p_init_msg_list,
220 p_commit,
221 p_task_id,
222 p_task_name,
223 p_task_type_id,
224 p_description,
225 p_task_status_id,
226 p_task_priority_id,
227 p_owner_type_code,
228 p_owner_id,
229 p_owner_territory_id,
230 p_assigned_by_id,
231 p_customer_id,
232 p_cust_account_id,
233 p_address_id,
234 ddp_planned_start_date,
235 ddp_planned_end_date,
236 ddp_scheduled_start_date,
237 ddp_scheduled_end_date,
238 ddp_actual_start_date,
239 ddp_actual_end_date,
240 p_timezone_id,
241 p_source_object_type_code,
242 p_source_object_id,
243 p_source_object_name,
244 p_duration,
245 p_duration_uom,
246 p_planned_effort,
247 p_planned_effort_uom,
248 p_actual_effort,
249 p_actual_effort_uom,
250 p_percentage_complete,
251 p_reason_code,
252 p_private_flag,
253 p_publish_flag,
254 p_restrict_closure_flag,
255 p_multi_booked_flag,
256 p_milestone_flag,
257 p_holiday_flag,
258 p_billable_flag,
259 p_bound_mode_code,
260 p_soft_bound_flag,
261 p_workflow_process_id,
262 p_notification_flag,
263 p_notification_period,
264 p_notification_period_uom,
265 p_parent_task_id,
266 p_alarm_start,
267 p_alarm_start_uom,
268 p_alarm_on,
269 p_alarm_count,
270 p_alarm_interval,
271 p_alarm_interval_uom,
272 p_palm_flag,
273 p_wince_flag,
274 p_laptop_flag,
275 p_device1_flag,
276 p_device2_flag,
277 p_device3_flag,
278 p_costs,
279 p_currency_code,
280 p_escalation_level,
281 x_return_status,
282 x_msg_count,
283 x_msg_data,
284 x_task_id,
285 p_attribute1,
286 p_attribute2,
287 p_attribute3,
288 p_attribute4,
289 p_attribute5,
290 p_attribute6,
291 p_attribute7,
292 p_attribute8,
293 p_attribute9,
294 p_attribute10,
295 p_attribute11,
296 p_attribute12,
297 p_attribute13,
298 p_attribute14,
299 p_attribute15,
300 p_attribute_category,
301 p_date_selected,
302 p_category_id,
303 p_show_on_calendar,
304 p_owner_status_id,
305 p_template_id,
306 p_template_group_id,
307 p_enable_workflow,
308 p_abort_workflow);
309
310 -- copy data back from the local variables to OUT or IN-OUT args, if any
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
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
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401 end;
402
403 procedure create_task(p_api_version NUMBER
404 , p_init_msg_list VARCHAR2
405 , p_commit VARCHAR2
406 , p_task_id NUMBER
407 , p_task_name VARCHAR2
408 , p_task_type_id NUMBER
409 , p_description VARCHAR2
410 , p_task_status_id NUMBER
411 , p_task_priority_id NUMBER
412 , p_owner_type_code VARCHAR2
413 , p_owner_id NUMBER
414 , p_owner_territory_id NUMBER
415 , p_assigned_by_id NUMBER
416 , p_customer_id NUMBER
417 , p_cust_account_id NUMBER
418 , p_address_id NUMBER
419 , p_planned_start_date date
420 , p_planned_end_date date
421 , p_scheduled_start_date date
422 , p_scheduled_end_date date
423 , p_actual_start_date date
424 , p_actual_end_date date
425 , p_timezone_id NUMBER
426 , p_source_object_type_code VARCHAR2
427 , p_source_object_id NUMBER
428 , p_source_object_name VARCHAR2
429 , p_duration NUMBER
430 , p_duration_uom VARCHAR2
431 , p_planned_effort NUMBER
432 , p_planned_effort_uom VARCHAR2
433 , p_actual_effort NUMBER
434 , p_actual_effort_uom VARCHAR2
435 , p_percentage_complete NUMBER
436 , p_reason_code VARCHAR2
437 , p_private_flag VARCHAR2
438 , p_publish_flag VARCHAR2
439 , p_restrict_closure_flag VARCHAR2
440 , p_multi_booked_flag VARCHAR2
441 , p_milestone_flag VARCHAR2
442 , p_holiday_flag VARCHAR2
443 , p_billable_flag VARCHAR2
444 , p_bound_mode_code VARCHAR2
445 , p_soft_bound_flag VARCHAR2
446 , p_workflow_process_id NUMBER
447 , p_notification_flag VARCHAR2
448 , p_notification_period NUMBER
449 , p_notification_period_uom VARCHAR2
450 , p_parent_task_id NUMBER
451 , p_alarm_start NUMBER
452 , p_alarm_start_uom VARCHAR2
453 , p_alarm_on VARCHAR2
454 , p_alarm_count NUMBER
455 , p_alarm_interval NUMBER
456 , p_alarm_interval_uom VARCHAR2
457 , p_palm_flag VARCHAR2
458 , p_wince_flag VARCHAR2
459 , p_laptop_flag VARCHAR2
460 , p_device1_flag VARCHAR2
461 , p_device2_flag VARCHAR2
462 , p_device3_flag VARCHAR2
463 , p_costs NUMBER
464 , p_currency_code VARCHAR2
465 , p_escalation_level VARCHAR2
466 , x_return_status out nocopy VARCHAR2
467 , x_msg_count out nocopy NUMBER
468 , x_msg_data out nocopy VARCHAR2
469 , x_task_id out nocopy NUMBER
470 , p_attribute1 VARCHAR2
471 , p_attribute2 VARCHAR2
472 , p_attribute3 VARCHAR2
473 , p_attribute4 VARCHAR2
474 , p_attribute5 VARCHAR2
475 , p_attribute6 VARCHAR2
476 , p_attribute7 VARCHAR2
477 , p_attribute8 VARCHAR2
478 , p_attribute9 VARCHAR2
479 , p_attribute10 VARCHAR2
480 , p_attribute11 VARCHAR2
481 , p_attribute12 VARCHAR2
482 , p_attribute13 VARCHAR2
483 , p_attribute14 VARCHAR2
484 , p_attribute15 VARCHAR2
485 , p_attribute_category VARCHAR2
486 , p_date_selected VARCHAR2
487 , p_category_id NUMBER
488 , p_show_on_calendar VARCHAR2
489 , p_owner_status_id NUMBER
490 , p_template_id NUMBER
491 , p_template_group_id NUMBER
492 , p_enable_workflow VARCHAR2
493 , p_abort_workflow VARCHAR2
494 , p_entity VARCHAR2
495 , p_free_busy_type VARCHAR2
496 )
497
498 as
499 ddp_planned_start_date date;
500 ddp_planned_end_date date;
501 ddp_scheduled_start_date date;
502 ddp_scheduled_end_date date;
503 ddp_actual_start_date date;
504 ddp_actual_end_date date;
505 ddindx binary_integer; indx binary_integer;
506 begin
507
508 -- copy data to the local IN or IN-OUT args, if any
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
526
527 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
528
529 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
530
531 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
532
533 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
534
535 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
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 -- here's the delegated call to the old PL/SQL routine
609 jtf_tasks_pvt.create_task(p_api_version,
610 p_init_msg_list,
611 p_commit,
612 p_task_id,
613 p_task_name,
614 p_task_type_id,
615 p_description,
616 p_task_status_id,
617 p_task_priority_id,
618 p_owner_type_code,
619 p_owner_id,
620 p_owner_territory_id,
621 p_assigned_by_id,
622 p_customer_id,
623 p_cust_account_id,
624 p_address_id,
625 ddp_planned_start_date,
626 ddp_planned_end_date,
627 ddp_scheduled_start_date,
628 ddp_scheduled_end_date,
629 ddp_actual_start_date,
630 ddp_actual_end_date,
631 p_timezone_id,
632 p_source_object_type_code,
633 p_source_object_id,
634 p_source_object_name,
635 p_duration,
636 p_duration_uom,
637 p_planned_effort,
638 p_planned_effort_uom,
639 p_actual_effort,
640 p_actual_effort_uom,
641 p_percentage_complete,
642 p_reason_code,
643 p_private_flag,
644 p_publish_flag,
645 p_restrict_closure_flag,
646 p_multi_booked_flag,
647 p_milestone_flag,
648 p_holiday_flag,
649 p_billable_flag,
650 p_bound_mode_code,
651 p_soft_bound_flag,
652 p_workflow_process_id,
653 p_notification_flag,
654 p_notification_period,
655 p_notification_period_uom,
656 p_parent_task_id,
657 p_alarm_start,
658 p_alarm_start_uom,
659 p_alarm_on,
660 p_alarm_count,
661 p_alarm_interval,
662 p_alarm_interval_uom,
663 p_palm_flag,
664 p_wince_flag,
665 p_laptop_flag,
666 p_device1_flag,
667 p_device2_flag,
668 p_device3_flag,
669 p_costs,
670 p_currency_code,
671 p_escalation_level,
672 x_return_status,
673 x_msg_count,
674 x_msg_data,
675 x_task_id,
676 p_attribute1,
677 p_attribute2,
678 p_attribute3,
679 p_attribute4,
680 p_attribute5,
681 p_attribute6,
682 p_attribute7,
683 p_attribute8,
684 p_attribute9,
685 p_attribute10,
686 p_attribute11,
687 p_attribute12,
688 p_attribute13,
689 p_attribute14,
690 p_attribute15,
691 p_attribute_category,
692 p_date_selected,
693 p_category_id,
694 p_show_on_calendar,
695 p_owner_status_id,
696 p_template_id,
697 p_template_group_id,
698 p_enable_workflow,
699 p_abort_workflow,
700 p_entity,
701 p_free_busy_type);
702
703 -- copy data back from the local variables to OUT or IN-OUT args, if any
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
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796 end;
797
798 procedure create_task(p_api_version NUMBER
799 , p_init_msg_list VARCHAR2
800 , p_commit VARCHAR2
801 , p_task_id NUMBER
802 , p_task_name VARCHAR2
803 , p_task_type_id NUMBER
804 , p_description VARCHAR2
805 , p_task_status_id NUMBER
806 , p_task_priority_id NUMBER
807 , p_owner_type_code VARCHAR2
808 , p_owner_id NUMBER
809 , p_owner_territory_id NUMBER
810 , p_assigned_by_id NUMBER
811 , p_customer_id NUMBER
812 , p_cust_account_id NUMBER
813 , p_address_id NUMBER
814 , p_planned_start_date date
815 , p_planned_end_date date
816 , p_scheduled_start_date date
817 , p_scheduled_end_date date
818 , p_actual_start_date date
819 , p_actual_end_date date
820 , p_timezone_id NUMBER
821 , p_source_object_type_code VARCHAR2
822 , p_source_object_id NUMBER
823 , p_source_object_name VARCHAR2
824 , p_duration NUMBER
825 , p_duration_uom VARCHAR2
826 , p_planned_effort NUMBER
827 , p_planned_effort_uom VARCHAR2
828 , p_actual_effort NUMBER
829 , p_actual_effort_uom VARCHAR2
830 , p_percentage_complete NUMBER
831 , p_reason_code VARCHAR2
832 , p_private_flag VARCHAR2
833 , p_publish_flag VARCHAR2
834 , p_restrict_closure_flag VARCHAR2
835 , p_multi_booked_flag VARCHAR2
836 , p_milestone_flag VARCHAR2
837 , p_holiday_flag VARCHAR2
838 , p_billable_flag VARCHAR2
839 , p_bound_mode_code VARCHAR2
840 , p_soft_bound_flag VARCHAR2
841 , p_workflow_process_id NUMBER
842 , p_notification_flag VARCHAR2
843 , p_notification_period NUMBER
844 , p_notification_period_uom VARCHAR2
845 , p_parent_task_id NUMBER
846 , p_alarm_start NUMBER
847 , p_alarm_start_uom VARCHAR2
848 , p_alarm_on VARCHAR2
849 , p_alarm_count NUMBER
850 , p_alarm_interval NUMBER
851 , p_alarm_interval_uom VARCHAR2
852 , p_palm_flag VARCHAR2
853 , p_wince_flag VARCHAR2
854 , p_laptop_flag VARCHAR2
855 , p_device1_flag VARCHAR2
856 , p_device2_flag VARCHAR2
857 , p_device3_flag VARCHAR2
858 , p_costs NUMBER
859 , p_currency_code VARCHAR2
860 , p_escalation_level VARCHAR2
861 , x_return_status out nocopy VARCHAR2
862 , x_msg_count out nocopy NUMBER
863 , x_msg_data out nocopy VARCHAR2
864 , x_task_id out nocopy NUMBER
865 , p_attribute1 VARCHAR2
866 , p_attribute2 VARCHAR2
867 , p_attribute3 VARCHAR2
868 , p_attribute4 VARCHAR2
869 , p_attribute5 VARCHAR2
870 , p_attribute6 VARCHAR2
871 , p_attribute7 VARCHAR2
872 , p_attribute8 VARCHAR2
873 , p_attribute9 VARCHAR2
874 , p_attribute10 VARCHAR2
875 , p_attribute11 VARCHAR2
876 , p_attribute12 VARCHAR2
877 , p_attribute13 VARCHAR2
878 , p_attribute14 VARCHAR2
879 , p_attribute15 VARCHAR2
880 , p_attribute_category VARCHAR2
881 , p_date_selected VARCHAR2
882 , p_category_id NUMBER
883 , p_show_on_calendar VARCHAR2
884 , p_owner_status_id NUMBER
885 , p_template_id NUMBER
886 , p_template_group_id NUMBER
887 , p_enable_workflow VARCHAR2
888 , p_abort_workflow VARCHAR2
889 , p_entity VARCHAR2
890 , p_free_busy_type VARCHAR2
891 , p_task_confirmation_status VARCHAR2
892 , p_task_confirmation_counter NUMBER
893 , p_task_split_flag VARCHAR2
894 , p_reference_flag VARCHAR2
895 , p_child_position VARCHAR2
896 , p_child_sequence_num NUMBER
897 , p_location_id NUMBER
898 )
899
900 as
901 ddp_planned_start_date date;
902 ddp_planned_end_date date;
903 ddp_scheduled_start_date date;
904 ddp_scheduled_end_date date;
905 ddp_actual_start_date date;
906 ddp_actual_end_date date;
907 ddindx binary_integer; indx binary_integer;
908 begin
909
910 -- copy data to the local IN or IN-OUT args, if any
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
928
929 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
930
931 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
932
933 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
934
935 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
936
937 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
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
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017 -- here's the delegated call to the old PL/SQL routine
1018 jtf_tasks_pvt.create_task(p_api_version,
1019 p_init_msg_list,
1020 p_commit,
1021 p_task_id,
1022 p_task_name,
1023 p_task_type_id,
1024 p_description,
1025 p_task_status_id,
1026 p_task_priority_id,
1027 p_owner_type_code,
1028 p_owner_id,
1029 p_owner_territory_id,
1030 p_assigned_by_id,
1031 p_customer_id,
1032 p_cust_account_id,
1033 p_address_id,
1034 ddp_planned_start_date,
1035 ddp_planned_end_date,
1036 ddp_scheduled_start_date,
1037 ddp_scheduled_end_date,
1038 ddp_actual_start_date,
1039 ddp_actual_end_date,
1040 p_timezone_id,
1041 p_source_object_type_code,
1042 p_source_object_id,
1043 p_source_object_name,
1044 p_duration,
1045 p_duration_uom,
1046 p_planned_effort,
1047 p_planned_effort_uom,
1048 p_actual_effort,
1049 p_actual_effort_uom,
1050 p_percentage_complete,
1051 p_reason_code,
1052 p_private_flag,
1053 p_publish_flag,
1054 p_restrict_closure_flag,
1055 p_multi_booked_flag,
1056 p_milestone_flag,
1057 p_holiday_flag,
1058 p_billable_flag,
1059 p_bound_mode_code,
1060 p_soft_bound_flag,
1061 p_workflow_process_id,
1062 p_notification_flag,
1063 p_notification_period,
1064 p_notification_period_uom,
1065 p_parent_task_id,
1066 p_alarm_start,
1067 p_alarm_start_uom,
1068 p_alarm_on,
1069 p_alarm_count,
1070 p_alarm_interval,
1071 p_alarm_interval_uom,
1072 p_palm_flag,
1073 p_wince_flag,
1074 p_laptop_flag,
1075 p_device1_flag,
1076 p_device2_flag,
1077 p_device3_flag,
1078 p_costs,
1079 p_currency_code,
1080 p_escalation_level,
1081 x_return_status,
1082 x_msg_count,
1083 x_msg_data,
1084 x_task_id,
1085 p_attribute1,
1086 p_attribute2,
1087 p_attribute3,
1088 p_attribute4,
1089 p_attribute5,
1090 p_attribute6,
1091 p_attribute7,
1092 p_attribute8,
1093 p_attribute9,
1094 p_attribute10,
1095 p_attribute11,
1096 p_attribute12,
1097 p_attribute13,
1098 p_attribute14,
1099 p_attribute15,
1100 p_attribute_category,
1101 p_date_selected,
1102 p_category_id,
1103 p_show_on_calendar,
1104 p_owner_status_id,
1105 p_template_id,
1106 p_template_group_id,
1107 p_enable_workflow,
1108 p_abort_workflow,
1109 p_entity,
1110 p_free_busy_type,
1111 p_task_confirmation_status,
1112 p_task_confirmation_counter,
1113 p_task_split_flag,
1114 p_reference_flag,
1115 p_child_position,
1116 p_child_sequence_num,
1117 p_location_id);
1118
1119 -- copy data back from the local variables to OUT or IN-OUT args, if any
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
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
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
1218
1219 end;
1220
1221 procedure create_task(p_api_version NUMBER
1222 , p_init_msg_list VARCHAR2
1223 , p_commit VARCHAR2
1224 , p_task_id NUMBER
1225 , p_task_name VARCHAR2
1226 , p_task_type_id NUMBER
1227 , p_description VARCHAR2
1228 , p_task_status_id NUMBER
1229 , p_task_priority_id NUMBER
1230 , p_owner_type_code VARCHAR2
1231 , p_owner_id NUMBER
1232 , p_owner_territory_id NUMBER
1233 , p_assigned_by_id NUMBER
1234 , p_customer_id NUMBER
1235 , p_cust_account_id NUMBER
1236 , p_address_id NUMBER
1237 , p_planned_start_date date
1238 , p_planned_end_date date
1239 , p_scheduled_start_date date
1240 , p_scheduled_end_date date
1241 , p_actual_start_date date
1242 , p_actual_end_date date
1243 , p_timezone_id NUMBER
1244 , p_source_object_type_code VARCHAR2
1245 , p_source_object_id NUMBER
1246 , p_source_object_name VARCHAR2
1247 , p_duration NUMBER
1248 , p_duration_uom VARCHAR2
1249 , p_planned_effort NUMBER
1250 , p_planned_effort_uom VARCHAR2
1251 , p_actual_effort NUMBER
1252 , p_actual_effort_uom VARCHAR2
1253 , p_percentage_complete NUMBER
1254 , p_reason_code VARCHAR2
1255 , p_private_flag VARCHAR2
1256 , p_publish_flag VARCHAR2
1257 , p_restrict_closure_flag VARCHAR2
1258 , p_multi_booked_flag VARCHAR2
1259 , p_milestone_flag VARCHAR2
1260 , p_holiday_flag VARCHAR2
1261 , p_billable_flag VARCHAR2
1262 , p_bound_mode_code VARCHAR2
1263 , p_soft_bound_flag VARCHAR2
1264 , p_workflow_process_id NUMBER
1265 , p_notification_flag VARCHAR2
1266 , p_notification_period NUMBER
1267 , p_notification_period_uom VARCHAR2
1268 , p_parent_task_id NUMBER
1269 , p_alarm_start NUMBER
1270 , p_alarm_start_uom VARCHAR2
1271 , p_alarm_on VARCHAR2
1272 , p_alarm_count NUMBER
1273 , p_alarm_interval NUMBER
1274 , p_alarm_interval_uom VARCHAR2
1275 , p_palm_flag VARCHAR2
1276 , p_wince_flag VARCHAR2
1277 , p_laptop_flag VARCHAR2
1278 , p_device1_flag VARCHAR2
1279 , p_device2_flag VARCHAR2
1280 , p_device3_flag VARCHAR2
1281 , p_costs NUMBER
1282 , p_currency_code VARCHAR2
1283 , p_escalation_level VARCHAR2
1284 , x_return_status out nocopy VARCHAR2
1285 , x_msg_count out nocopy NUMBER
1286 , x_msg_data out nocopy VARCHAR2
1287 , x_task_id out nocopy NUMBER
1288 , p_attribute1 VARCHAR2
1289 , p_attribute2 VARCHAR2
1290 , p_attribute3 VARCHAR2
1291 , p_attribute4 VARCHAR2
1292 , p_attribute5 VARCHAR2
1293 , p_attribute6 VARCHAR2
1294 , p_attribute7 VARCHAR2
1295 , p_attribute8 VARCHAR2
1296 , p_attribute9 VARCHAR2
1297 , p_attribute10 VARCHAR2
1298 , p_attribute11 VARCHAR2
1299 , p_attribute12 VARCHAR2
1300 , p_attribute13 VARCHAR2
1301 , p_attribute14 VARCHAR2
1302 , p_attribute15 VARCHAR2
1303 , p_attribute_category VARCHAR2
1304 , p_date_selected VARCHAR2
1305 , p_category_id NUMBER
1306 , p_show_on_calendar VARCHAR2
1307 , p_owner_status_id NUMBER
1308 , p_template_id NUMBER
1309 , p_template_group_id NUMBER
1310 , p_enable_workflow VARCHAR2
1311 , p_abort_workflow VARCHAR2
1312 , p_entity VARCHAR2
1313 , p_free_busy_type VARCHAR2
1314 , p_task_confirmation_status VARCHAR2
1315 , p_task_confirmation_counter NUMBER
1316 , p_task_split_flag VARCHAR2
1317 , p_reference_flag VARCHAR2
1318 , p_child_position VARCHAR2
1319 , p_child_sequence_num NUMBER
1320 )
1321
1322 as
1323 ddp_planned_start_date date;
1324 ddp_planned_end_date date;
1325 ddp_scheduled_start_date date;
1326 ddp_scheduled_end_date date;
1327 ddp_actual_start_date date;
1328 ddp_actual_end_date date;
1329 ddindx binary_integer; indx binary_integer;
1330 begin
1331
1332 -- copy data to the local IN or IN-OUT args, if any
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
1350
1351 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
1352
1353 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
1354
1355 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
1356
1357 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1358
1359 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1360
1361
1362
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
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438 -- here's the delegated call to the old PL/SQL routine
1439 jtf_tasks_pvt.create_task(p_api_version,
1440 p_init_msg_list,
1441 p_commit,
1442 p_task_id,
1443 p_task_name,
1444 p_task_type_id,
1445 p_description,
1446 p_task_status_id,
1447 p_task_priority_id,
1448 p_owner_type_code,
1449 p_owner_id,
1450 p_owner_territory_id,
1451 p_assigned_by_id,
1452 p_customer_id,
1453 p_cust_account_id,
1454 p_address_id,
1455 ddp_planned_start_date,
1456 ddp_planned_end_date,
1457 ddp_scheduled_start_date,
1458 ddp_scheduled_end_date,
1459 ddp_actual_start_date,
1460 ddp_actual_end_date,
1461 p_timezone_id,
1462 p_source_object_type_code,
1463 p_source_object_id,
1464 p_source_object_name,
1465 p_duration,
1466 p_duration_uom,
1467 p_planned_effort,
1468 p_planned_effort_uom,
1469 p_actual_effort,
1470 p_actual_effort_uom,
1471 p_percentage_complete,
1472 p_reason_code,
1473 p_private_flag,
1474 p_publish_flag,
1475 p_restrict_closure_flag,
1476 p_multi_booked_flag,
1477 p_milestone_flag,
1478 p_holiday_flag,
1479 p_billable_flag,
1480 p_bound_mode_code,
1481 p_soft_bound_flag,
1482 p_workflow_process_id,
1483 p_notification_flag,
1484 p_notification_period,
1485 p_notification_period_uom,
1486 p_parent_task_id,
1487 p_alarm_start,
1488 p_alarm_start_uom,
1489 p_alarm_on,
1490 p_alarm_count,
1491 p_alarm_interval,
1492 p_alarm_interval_uom,
1493 p_palm_flag,
1494 p_wince_flag,
1495 p_laptop_flag,
1496 p_device1_flag,
1497 p_device2_flag,
1498 p_device3_flag,
1499 p_costs,
1500 p_currency_code,
1501 p_escalation_level,
1502 x_return_status,
1503 x_msg_count,
1504 x_msg_data,
1505 x_task_id,
1506 p_attribute1,
1507 p_attribute2,
1508 p_attribute3,
1509 p_attribute4,
1510 p_attribute5,
1511 p_attribute6,
1512 p_attribute7,
1513 p_attribute8,
1514 p_attribute9,
1515 p_attribute10,
1516 p_attribute11,
1517 p_attribute12,
1518 p_attribute13,
1519 p_attribute14,
1520 p_attribute15,
1521 p_attribute_category,
1522 p_date_selected,
1523 p_category_id,
1524 p_show_on_calendar,
1525 p_owner_status_id,
1526 p_template_id,
1527 p_template_group_id,
1528 p_enable_workflow,
1529 p_abort_workflow,
1530 p_entity,
1531 p_free_busy_type,
1532 p_task_confirmation_status,
1533 p_task_confirmation_counter,
1534 p_task_split_flag,
1535 p_reference_flag,
1536 p_child_position,
1537 p_child_sequence_num);
1538
1539 -- copy data back from the local variables to OUT or IN-OUT args, if any
1540
1541
1542
1543
1544
1545
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
1578
1579
1580
1581
1582
1583
1584
1585
1586
1587
1588
1589
1590
1591
1592
1593
1594
1595
1596
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 end;
1639
1640 procedure create_task(p_api_version NUMBER
1641 , p_init_msg_list VARCHAR2
1642 , p_commit VARCHAR2
1643 , p_task_id NUMBER
1644 , p_task_name VARCHAR2
1645 , p_task_type_id NUMBER
1646 , p_description VARCHAR2
1647 , p_task_status_id NUMBER
1648 , p_task_priority_id NUMBER
1649 , p_owner_type_code VARCHAR2
1650 , p_owner_id NUMBER
1651 , p_owner_territory_id NUMBER
1652 , p_assigned_by_id NUMBER
1653 , p_customer_id NUMBER
1654 , p_cust_account_id NUMBER
1655 , p_address_id NUMBER
1656 , p_planned_start_date date
1657 , p_planned_end_date date
1658 , p_scheduled_start_date date
1659 , p_scheduled_end_date date
1660 , p_actual_start_date date
1661 , p_actual_end_date date
1662 , p_timezone_id NUMBER
1663 , p_source_object_type_code VARCHAR2
1664 , p_source_object_id NUMBER
1665 , p_source_object_name VARCHAR2
1666 , p_duration NUMBER
1667 , p_duration_uom VARCHAR2
1668 , p_planned_effort NUMBER
1669 , p_planned_effort_uom VARCHAR2
1670 , p_actual_effort NUMBER
1671 , p_actual_effort_uom VARCHAR2
1672 , p_percentage_complete NUMBER
1673 , p_reason_code VARCHAR2
1674 , p_private_flag VARCHAR2
1675 , p_publish_flag VARCHAR2
1676 , p_restrict_closure_flag VARCHAR2
1677 , p_multi_booked_flag VARCHAR2
1678 , p_milestone_flag VARCHAR2
1679 , p_holiday_flag VARCHAR2
1680 , p_billable_flag VARCHAR2
1681 , p_bound_mode_code VARCHAR2
1682 , p_soft_bound_flag VARCHAR2
1683 , p_workflow_process_id NUMBER
1684 , p_notification_flag VARCHAR2
1685 , p_notification_period NUMBER
1686 , p_notification_period_uom VARCHAR2
1687 , p_parent_task_id NUMBER
1688 , p_alarm_start NUMBER
1689 , p_alarm_start_uom VARCHAR2
1690 , p_alarm_on VARCHAR2
1691 , p_alarm_count NUMBER
1692 , p_alarm_interval NUMBER
1693 , p_alarm_interval_uom VARCHAR2
1694 , p_palm_flag VARCHAR2
1695 , p_wince_flag VARCHAR2
1696 , p_laptop_flag VARCHAR2
1697 , p_device1_flag VARCHAR2
1698 , p_device2_flag VARCHAR2
1699 , p_device3_flag VARCHAR2
1700 , p_costs NUMBER
1701 , p_currency_code VARCHAR2
1702 , p_escalation_level VARCHAR2
1703 , x_return_status out nocopy VARCHAR2
1704 , x_msg_count out nocopy NUMBER
1705 , x_msg_data out nocopy VARCHAR2
1706 , x_task_id out nocopy NUMBER
1707 , p_attribute1 VARCHAR2
1708 , p_attribute2 VARCHAR2
1709 , p_attribute3 VARCHAR2
1710 , p_attribute4 VARCHAR2
1711 , p_attribute5 VARCHAR2
1712 , p_attribute6 VARCHAR2
1713 , p_attribute7 VARCHAR2
1714 , p_attribute8 VARCHAR2
1715 , p_attribute9 VARCHAR2
1716 , p_attribute10 VARCHAR2
1717 , p_attribute11 VARCHAR2
1718 , p_attribute12 VARCHAR2
1719 , p_attribute13 VARCHAR2
1720 , p_attribute14 VARCHAR2
1721 , p_attribute15 VARCHAR2
1722 , p_attribute_category VARCHAR2
1723 , p_date_selected VARCHAR2
1724 , p_category_id NUMBER
1725 , p_show_on_calendar VARCHAR2
1726 , p_owner_status_id NUMBER
1727 , p_template_id NUMBER
1728 , p_template_group_id NUMBER
1729 )
1730
1731 as
1732 ddp_planned_start_date date;
1733 ddp_planned_end_date date;
1734 ddp_scheduled_start_date date;
1735 ddp_scheduled_end_date date;
1736 ddp_actual_start_date date;
1737 ddp_actual_end_date date;
1738 ddindx binary_integer; indx binary_integer;
1739 begin
1740
1741 -- copy data to the local IN or IN-OUT args, if any
1742
1743
1744
1745
1746
1747
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
1759
1760 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
1761
1762 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
1763
1764 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
1765
1766 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1767
1768 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1785
1786
1787
1788
1789
1790
1791
1792
1793
1794
1795
1796
1797
1798
1799
1800
1801
1802
1803
1804
1805
1806
1807
1808
1809
1810
1811
1812
1813
1814
1815
1816
1817
1818
1819
1820
1821
1822
1823
1824
1825
1826
1827
1828
1829
1830
1831
1832
1833
1834
1835
1836
1837 -- here's the delegated call to the old PL/SQL routine
1838 jtf_tasks_pvt.create_task(p_api_version,
1839 p_init_msg_list,
1840 p_commit,
1841 p_task_id,
1842 p_task_name,
1843 p_task_type_id,
1844 p_description,
1845 p_task_status_id,
1846 p_task_priority_id,
1847 p_owner_type_code,
1848 p_owner_id,
1849 p_owner_territory_id,
1850 p_assigned_by_id,
1851 p_customer_id,
1852 p_cust_account_id,
1853 p_address_id,
1854 ddp_planned_start_date,
1855 ddp_planned_end_date,
1856 ddp_scheduled_start_date,
1857 ddp_scheduled_end_date,
1858 ddp_actual_start_date,
1859 ddp_actual_end_date,
1860 p_timezone_id,
1861 p_source_object_type_code,
1862 p_source_object_id,
1863 p_source_object_name,
1864 p_duration,
1865 p_duration_uom,
1866 p_planned_effort,
1867 p_planned_effort_uom,
1868 p_actual_effort,
1869 p_actual_effort_uom,
1870 p_percentage_complete,
1871 p_reason_code,
1872 p_private_flag,
1873 p_publish_flag,
1874 p_restrict_closure_flag,
1875 p_multi_booked_flag,
1876 p_milestone_flag,
1877 p_holiday_flag,
1878 p_billable_flag,
1879 p_bound_mode_code,
1880 p_soft_bound_flag,
1881 p_workflow_process_id,
1882 p_notification_flag,
1883 p_notification_period,
1884 p_notification_period_uom,
1885 p_parent_task_id,
1886 p_alarm_start,
1887 p_alarm_start_uom,
1888 p_alarm_on,
1889 p_alarm_count,
1890 p_alarm_interval,
1891 p_alarm_interval_uom,
1892 p_palm_flag,
1893 p_wince_flag,
1894 p_laptop_flag,
1895 p_device1_flag,
1896 p_device2_flag,
1897 p_device3_flag,
1898 p_costs,
1899 p_currency_code,
1900 p_escalation_level,
1901 x_return_status,
1902 x_msg_count,
1903 x_msg_data,
1904 x_task_id,
1905 p_attribute1,
1906 p_attribute2,
1907 p_attribute3,
1908 p_attribute4,
1909 p_attribute5,
1910 p_attribute6,
1911 p_attribute7,
1912 p_attribute8,
1913 p_attribute9,
1914 p_attribute10,
1915 p_attribute11,
1916 p_attribute12,
1917 p_attribute13,
1918 p_attribute14,
1919 p_attribute15,
1920 p_attribute_category,
1921 p_date_selected,
1922 p_category_id,
1923 p_show_on_calendar,
1924 p_owner_status_id,
1925 p_template_id,
1926 p_template_group_id);
1927
1928 -- copy data back from the local variables to OUT or IN-OUT args, if any
1929
1930
1931
1932
1933
1934
1935
1936
1937
1938
1939
1940
1941
1942
1943
1944
1945
1946
1947
1948
1949
1950
1951
1952
1953
1954
1955
1956
1957
1958
1959
1960
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
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017 end;
2018
2019 procedure update_task(p_api_version NUMBER
2020 , p_init_msg_list VARCHAR2
2021 , p_commit VARCHAR2
2022 , p_object_version_number in out nocopy NUMBER
2023 , p_task_id NUMBER
2024 , p_task_name VARCHAR2
2025 , p_task_type_id NUMBER
2026 , p_description VARCHAR2
2027 , p_task_status_id NUMBER
2028 , p_task_priority_id NUMBER
2029 , p_owner_type_code VARCHAR2
2030 , p_owner_id NUMBER
2031 , p_owner_territory_id NUMBER
2032 , p_assigned_by_id NUMBER
2033 , p_customer_id NUMBER
2034 , p_cust_account_id NUMBER
2035 , p_address_id NUMBER
2036 , p_planned_start_date date
2037 , p_planned_end_date date
2038 , p_scheduled_start_date date
2039 , p_scheduled_end_date date
2040 , p_actual_start_date date
2041 , p_actual_end_date date
2042 , p_timezone_id NUMBER
2043 , p_source_object_type_code VARCHAR2
2044 , p_source_object_id NUMBER
2045 , p_source_object_name VARCHAR2
2046 , p_duration NUMBER
2047 , p_duration_uom VARCHAR2
2048 , p_planned_effort NUMBER
2049 , p_planned_effort_uom VARCHAR2
2050 , p_actual_effort NUMBER
2051 , p_actual_effort_uom VARCHAR2
2052 , p_percentage_complete NUMBER
2053 , p_reason_code VARCHAR2
2054 , p_private_flag VARCHAR2
2055 , p_publish_flag VARCHAR2
2056 , p_restrict_closure_flag VARCHAR2
2057 , p_multi_booked_flag VARCHAR2
2058 , p_milestone_flag VARCHAR2
2059 , p_holiday_flag VARCHAR2
2060 , p_billable_flag VARCHAR2
2061 , p_bound_mode_code VARCHAR2
2062 , p_soft_bound_flag VARCHAR2
2063 , p_workflow_process_id NUMBER
2064 , p_notification_flag VARCHAR2
2065 , p_notification_period NUMBER
2066 , p_notification_period_uom VARCHAR2
2067 , p_parent_task_id NUMBER
2068 , p_alarm_start NUMBER
2069 , p_alarm_start_uom VARCHAR2
2070 , p_alarm_on VARCHAR2
2071 , p_alarm_count NUMBER
2072 , p_alarm_fired_count NUMBER
2073 , p_alarm_interval NUMBER
2074 , p_alarm_interval_uom VARCHAR2
2075 , p_palm_flag VARCHAR2
2076 , p_wince_flag VARCHAR2
2077 , p_laptop_flag VARCHAR2
2078 , p_device1_flag VARCHAR2
2079 , p_device2_flag VARCHAR2
2080 , p_device3_flag VARCHAR2
2081 , p_costs NUMBER
2082 , p_currency_code VARCHAR2
2083 , p_escalation_level VARCHAR2
2084 , x_return_status out nocopy VARCHAR2
2085 , x_msg_count out nocopy NUMBER
2086 , x_msg_data out nocopy VARCHAR2
2087 , p_attribute1 VARCHAR2
2088 , p_attribute2 VARCHAR2
2089 , p_attribute3 VARCHAR2
2090 , p_attribute4 VARCHAR2
2091 , p_attribute5 VARCHAR2
2092 , p_attribute6 VARCHAR2
2093 , p_attribute7 VARCHAR2
2094 , p_attribute8 VARCHAR2
2095 , p_attribute9 VARCHAR2
2096 , p_attribute10 VARCHAR2
2097 , p_attribute11 VARCHAR2
2098 , p_attribute12 VARCHAR2
2099 , p_attribute13 VARCHAR2
2100 , p_attribute14 VARCHAR2
2101 , p_attribute15 VARCHAR2
2102 , p_attribute_category VARCHAR2
2103 , p_date_selected VARCHAR2
2104 , p_category_id NUMBER
2105 , p_show_on_calendar VARCHAR2
2106 , p_owner_status_id NUMBER
2107 , p_enable_workflow VARCHAR2
2108 , p_abort_workflow VARCHAR2
2109 , p_change_mode VARCHAR2
2110 )
2111
2112 as
2113 ddp_planned_start_date date;
2114 ddp_planned_end_date date;
2115 ddp_scheduled_start_date date;
2116 ddp_scheduled_end_date date;
2117 ddp_actual_start_date date;
2118 ddp_actual_end_date date;
2119 ddindx binary_integer; indx binary_integer;
2120 begin
2121
2122 -- copy data to the local IN or IN-OUT args, if any
2123
2124
2125
2126
2127
2128
2129
2130
2131
2132
2133
2134
2135
2136
2137
2138
2139
2140 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
2141
2142 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
2143
2144 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
2145
2146 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
2147
2148 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
2149
2150 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
2151
2152
2153
2154
2155
2156
2157
2158
2159
2160
2161
2162
2163
2164
2165
2166
2167
2168
2169
2170
2171
2172
2173
2174
2175
2176
2177
2178
2179
2180
2181
2182
2183
2184
2185
2186
2187
2188
2189
2190
2191
2192
2193
2194
2195
2196
2197
2198
2199
2200
2201
2202
2203
2204
2205
2206
2207
2208
2209
2210
2211
2212
2213
2214
2215
2216
2217
2218
2219
2220 -- here's the delegated call to the old PL/SQL routine
2221 jtf_tasks_pvt.update_task(p_api_version,
2222 p_init_msg_list,
2223 p_commit,
2224 p_object_version_number,
2225 p_task_id,
2226 p_task_name,
2227 p_task_type_id,
2228 p_description,
2229 p_task_status_id,
2230 p_task_priority_id,
2231 p_owner_type_code,
2232 p_owner_id,
2233 p_owner_territory_id,
2234 p_assigned_by_id,
2235 p_customer_id,
2236 p_cust_account_id,
2237 p_address_id,
2238 ddp_planned_start_date,
2239 ddp_planned_end_date,
2240 ddp_scheduled_start_date,
2241 ddp_scheduled_end_date,
2242 ddp_actual_start_date,
2243 ddp_actual_end_date,
2244 p_timezone_id,
2245 p_source_object_type_code,
2246 p_source_object_id,
2247 p_source_object_name,
2248 p_duration,
2249 p_duration_uom,
2250 p_planned_effort,
2251 p_planned_effort_uom,
2252 p_actual_effort,
2253 p_actual_effort_uom,
2254 p_percentage_complete,
2255 p_reason_code,
2256 p_private_flag,
2257 p_publish_flag,
2258 p_restrict_closure_flag,
2259 p_multi_booked_flag,
2260 p_milestone_flag,
2261 p_holiday_flag,
2262 p_billable_flag,
2263 p_bound_mode_code,
2264 p_soft_bound_flag,
2265 p_workflow_process_id,
2266 p_notification_flag,
2267 p_notification_period,
2268 p_notification_period_uom,
2269 p_parent_task_id,
2270 p_alarm_start,
2271 p_alarm_start_uom,
2272 p_alarm_on,
2273 p_alarm_count,
2274 p_alarm_fired_count,
2275 p_alarm_interval,
2276 p_alarm_interval_uom,
2277 p_palm_flag,
2278 p_wince_flag,
2279 p_laptop_flag,
2280 p_device1_flag,
2281 p_device2_flag,
2282 p_device3_flag,
2283 p_costs,
2284 p_currency_code,
2285 p_escalation_level,
2286 x_return_status,
2287 x_msg_count,
2288 x_msg_data,
2289 p_attribute1,
2290 p_attribute2,
2291 p_attribute3,
2292 p_attribute4,
2293 p_attribute5,
2294 p_attribute6,
2295 p_attribute7,
2296 p_attribute8,
2297 p_attribute9,
2298 p_attribute10,
2299 p_attribute11,
2300 p_attribute12,
2301 p_attribute13,
2302 p_attribute14,
2303 p_attribute15,
2304 p_attribute_category,
2305 p_date_selected,
2306 p_category_id,
2307 p_show_on_calendar,
2308 p_owner_status_id,
2309 p_enable_workflow,
2310 p_abort_workflow,
2311 p_change_mode);
2312
2313 -- copy data back from the local variables to OUT or IN-OUT args, if any
2314
2315
2316
2317
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328
2329
2330
2331
2332
2333
2334
2335
2336
2337
2338
2339
2340
2341
2342
2343
2344
2345
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
2358
2359
2360
2361
2362
2363
2364
2365
2366
2367
2368
2369
2370
2371
2372
2373
2374
2375
2376
2377
2378
2379
2380
2381
2382
2383
2384
2385
2386
2387
2388
2389
2390
2391
2392
2393
2394
2395
2396
2397
2398
2399
2400
2401
2402
2403
2404 end;
2405
2406 procedure update_task(p_api_version NUMBER
2407 , p_init_msg_list VARCHAR2
2408 , p_commit VARCHAR2
2409 , p_object_version_number in out nocopy NUMBER
2410 , p_task_id NUMBER
2411 , p_task_name VARCHAR2
2412 , p_task_type_id NUMBER
2413 , p_description VARCHAR2
2414 , p_task_status_id NUMBER
2415 , p_task_priority_id NUMBER
2416 , p_owner_type_code VARCHAR2
2417 , p_owner_id NUMBER
2418 , p_owner_territory_id NUMBER
2419 , p_assigned_by_id NUMBER
2420 , p_customer_id NUMBER
2421 , p_cust_account_id NUMBER
2422 , p_address_id NUMBER
2423 , p_planned_start_date date
2424 , p_planned_end_date date
2425 , p_scheduled_start_date date
2426 , p_scheduled_end_date date
2427 , p_actual_start_date date
2428 , p_actual_end_date date
2429 , p_timezone_id NUMBER
2430 , p_source_object_type_code VARCHAR2
2431 , p_source_object_id NUMBER
2432 , p_source_object_name VARCHAR2
2433 , p_duration NUMBER
2434 , p_duration_uom VARCHAR2
2435 , p_planned_effort NUMBER
2436 , p_planned_effort_uom VARCHAR2
2437 , p_actual_effort NUMBER
2438 , p_actual_effort_uom VARCHAR2
2439 , p_percentage_complete NUMBER
2440 , p_reason_code VARCHAR2
2441 , p_private_flag VARCHAR2
2442 , p_publish_flag VARCHAR2
2443 , p_restrict_closure_flag VARCHAR2
2444 , p_multi_booked_flag VARCHAR2
2445 , p_milestone_flag VARCHAR2
2446 , p_holiday_flag VARCHAR2
2447 , p_billable_flag VARCHAR2
2448 , p_bound_mode_code VARCHAR2
2449 , p_soft_bound_flag VARCHAR2
2450 , p_workflow_process_id NUMBER
2451 , p_notification_flag VARCHAR2
2452 , p_notification_period NUMBER
2453 , p_notification_period_uom VARCHAR2
2454 , p_parent_task_id NUMBER
2455 , p_alarm_start NUMBER
2456 , p_alarm_start_uom VARCHAR2
2457 , p_alarm_on VARCHAR2
2458 , p_alarm_count NUMBER
2459 , p_alarm_fired_count NUMBER
2460 , p_alarm_interval NUMBER
2461 , p_alarm_interval_uom VARCHAR2
2462 , p_palm_flag VARCHAR2
2463 , p_wince_flag VARCHAR2
2464 , p_laptop_flag VARCHAR2
2465 , p_device1_flag VARCHAR2
2466 , p_device2_flag VARCHAR2
2467 , p_device3_flag VARCHAR2
2468 , p_costs NUMBER
2469 , p_currency_code VARCHAR2
2470 , p_escalation_level VARCHAR2
2471 , x_return_status out nocopy VARCHAR2
2472 , x_msg_count out nocopy NUMBER
2473 , x_msg_data out nocopy VARCHAR2
2474 , p_attribute1 VARCHAR2
2475 , p_attribute2 VARCHAR2
2476 , p_attribute3 VARCHAR2
2477 , p_attribute4 VARCHAR2
2478 , p_attribute5 VARCHAR2
2479 , p_attribute6 VARCHAR2
2480 , p_attribute7 VARCHAR2
2481 , p_attribute8 VARCHAR2
2482 , p_attribute9 VARCHAR2
2483 , p_attribute10 VARCHAR2
2484 , p_attribute11 VARCHAR2
2485 , p_attribute12 VARCHAR2
2486 , p_attribute13 VARCHAR2
2487 , p_attribute14 VARCHAR2
2488 , p_attribute15 VARCHAR2
2489 , p_attribute_category VARCHAR2
2490 , p_date_selected VARCHAR2
2491 , p_category_id NUMBER
2492 , p_show_on_calendar VARCHAR2
2493 , p_owner_status_id NUMBER
2494 , p_enable_workflow VARCHAR2
2495 , p_abort_workflow VARCHAR2
2496 , p_change_mode VARCHAR2
2497 , p_free_busy_type VARCHAR2
2498 )
2499
2500 as
2501 ddp_planned_start_date date;
2502 ddp_planned_end_date date;
2503 ddp_scheduled_start_date date;
2504 ddp_scheduled_end_date date;
2505 ddp_actual_start_date date;
2506 ddp_actual_end_date date;
2507 ddindx binary_integer; indx binary_integer;
2508 begin
2509
2510 -- copy data to the local IN or IN-OUT args, if any
2511
2512
2513
2514
2515
2516
2517
2518
2519
2520
2521
2522
2523
2524
2525
2526
2527
2528 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
2529
2530 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
2531
2532 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
2533
2534 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
2535
2536 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
2537
2538 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
2539
2540
2541
2542
2543
2544
2545
2546
2547
2548
2549
2550
2551
2552
2553
2554
2555
2556
2557
2558
2559
2560
2561
2562
2563
2564
2565
2566
2567
2568
2569
2570
2571
2572
2573
2574
2575
2576
2577
2578
2579
2580
2581
2582
2583
2584
2585
2586
2587
2588
2589
2590
2591
2592
2593
2594
2595
2596
2597
2598
2599
2600
2601
2602
2603
2604
2605
2606
2607
2608
2609 -- here's the delegated call to the old PL/SQL routine
2610 jtf_tasks_pvt.update_task(p_api_version,
2611 p_init_msg_list,
2612 p_commit,
2613 p_object_version_number,
2614 p_task_id,
2615 p_task_name,
2616 p_task_type_id,
2617 p_description,
2618 p_task_status_id,
2619 p_task_priority_id,
2620 p_owner_type_code,
2621 p_owner_id,
2622 p_owner_territory_id,
2623 p_assigned_by_id,
2624 p_customer_id,
2625 p_cust_account_id,
2626 p_address_id,
2627 ddp_planned_start_date,
2628 ddp_planned_end_date,
2629 ddp_scheduled_start_date,
2630 ddp_scheduled_end_date,
2631 ddp_actual_start_date,
2632 ddp_actual_end_date,
2633 p_timezone_id,
2634 p_source_object_type_code,
2635 p_source_object_id,
2636 p_source_object_name,
2637 p_duration,
2638 p_duration_uom,
2639 p_planned_effort,
2640 p_planned_effort_uom,
2641 p_actual_effort,
2642 p_actual_effort_uom,
2643 p_percentage_complete,
2644 p_reason_code,
2645 p_private_flag,
2646 p_publish_flag,
2647 p_restrict_closure_flag,
2648 p_multi_booked_flag,
2649 p_milestone_flag,
2650 p_holiday_flag,
2651 p_billable_flag,
2652 p_bound_mode_code,
2653 p_soft_bound_flag,
2654 p_workflow_process_id,
2655 p_notification_flag,
2656 p_notification_period,
2657 p_notification_period_uom,
2658 p_parent_task_id,
2659 p_alarm_start,
2660 p_alarm_start_uom,
2661 p_alarm_on,
2662 p_alarm_count,
2663 p_alarm_fired_count,
2664 p_alarm_interval,
2665 p_alarm_interval_uom,
2666 p_palm_flag,
2667 p_wince_flag,
2668 p_laptop_flag,
2669 p_device1_flag,
2670 p_device2_flag,
2671 p_device3_flag,
2672 p_costs,
2673 p_currency_code,
2674 p_escalation_level,
2675 x_return_status,
2676 x_msg_count,
2677 x_msg_data,
2678 p_attribute1,
2679 p_attribute2,
2680 p_attribute3,
2681 p_attribute4,
2682 p_attribute5,
2683 p_attribute6,
2684 p_attribute7,
2685 p_attribute8,
2686 p_attribute9,
2687 p_attribute10,
2688 p_attribute11,
2689 p_attribute12,
2690 p_attribute13,
2691 p_attribute14,
2692 p_attribute15,
2693 p_attribute_category,
2694 p_date_selected,
2695 p_category_id,
2696 p_show_on_calendar,
2697 p_owner_status_id,
2698 p_enable_workflow,
2699 p_abort_workflow,
2700 p_change_mode,
2701 p_free_busy_type);
2702
2703 -- copy data back from the local variables to OUT or IN-OUT args, if any
2704
2705
2706
2707
2708
2709
2710
2711
2712
2713
2714
2715
2716
2717
2718
2719
2720
2721
2722
2723
2724
2725
2726
2727
2728
2729
2730
2731
2732
2733
2734
2735
2736
2737
2738
2739
2740
2741
2742
2743
2744
2745
2746
2747
2748
2749
2750
2751
2752
2753
2754
2755
2756
2757
2758
2759
2760
2761
2762
2763
2764
2765
2766
2767
2768
2769
2770
2771
2772
2773
2774
2775
2776
2777
2778
2779
2780
2781
2782
2783
2784
2785
2786
2787
2788
2789
2790
2791
2792
2793
2794
2795 end;
2796
2797 procedure update_task(p_api_version NUMBER
2798 , p_init_msg_list VARCHAR2
2799 , p_commit VARCHAR2
2800 , p_object_version_number in out nocopy NUMBER
2801 , p_task_id NUMBER
2802 , p_task_name VARCHAR2
2803 , p_task_type_id NUMBER
2804 , p_description VARCHAR2
2805 , p_task_status_id NUMBER
2806 , p_task_priority_id NUMBER
2807 , p_owner_type_code VARCHAR2
2808 , p_owner_id NUMBER
2809 , p_owner_territory_id NUMBER
2810 , p_assigned_by_id NUMBER
2811 , p_customer_id NUMBER
2812 , p_cust_account_id NUMBER
2813 , p_address_id NUMBER
2814 , p_planned_start_date date
2815 , p_planned_end_date date
2816 , p_scheduled_start_date date
2817 , p_scheduled_end_date date
2818 , p_actual_start_date date
2819 , p_actual_end_date date
2820 , p_timezone_id NUMBER
2821 , p_source_object_type_code VARCHAR2
2822 , p_source_object_id NUMBER
2823 , p_source_object_name VARCHAR2
2824 , p_duration NUMBER
2825 , p_duration_uom VARCHAR2
2826 , p_planned_effort NUMBER
2827 , p_planned_effort_uom VARCHAR2
2828 , p_actual_effort NUMBER
2829 , p_actual_effort_uom VARCHAR2
2830 , p_percentage_complete NUMBER
2831 , p_reason_code VARCHAR2
2832 , p_private_flag VARCHAR2
2833 , p_publish_flag VARCHAR2
2834 , p_restrict_closure_flag VARCHAR2
2835 , p_multi_booked_flag VARCHAR2
2836 , p_milestone_flag VARCHAR2
2837 , p_holiday_flag VARCHAR2
2838 , p_billable_flag VARCHAR2
2839 , p_bound_mode_code VARCHAR2
2840 , p_soft_bound_flag VARCHAR2
2841 , p_workflow_process_id NUMBER
2842 , p_notification_flag VARCHAR2
2843 , p_notification_period NUMBER
2844 , p_notification_period_uom VARCHAR2
2845 , p_parent_task_id NUMBER
2846 , p_alarm_start NUMBER
2847 , p_alarm_start_uom VARCHAR2
2848 , p_alarm_on VARCHAR2
2849 , p_alarm_count NUMBER
2850 , p_alarm_fired_count NUMBER
2851 , p_alarm_interval NUMBER
2852 , p_alarm_interval_uom VARCHAR2
2853 , p_palm_flag VARCHAR2
2854 , p_wince_flag VARCHAR2
2855 , p_laptop_flag VARCHAR2
2856 , p_device1_flag VARCHAR2
2857 , p_device2_flag VARCHAR2
2858 , p_device3_flag VARCHAR2
2859 , p_costs NUMBER
2860 , p_currency_code VARCHAR2
2861 , p_escalation_level VARCHAR2
2862 , x_return_status out nocopy VARCHAR2
2863 , x_msg_count out nocopy NUMBER
2864 , x_msg_data out nocopy VARCHAR2
2865 , p_attribute1 VARCHAR2
2866 , p_attribute2 VARCHAR2
2867 , p_attribute3 VARCHAR2
2868 , p_attribute4 VARCHAR2
2869 , p_attribute5 VARCHAR2
2870 , p_attribute6 VARCHAR2
2871 , p_attribute7 VARCHAR2
2872 , p_attribute8 VARCHAR2
2873 , p_attribute9 VARCHAR2
2874 , p_attribute10 VARCHAR2
2875 , p_attribute11 VARCHAR2
2876 , p_attribute12 VARCHAR2
2877 , p_attribute13 VARCHAR2
2878 , p_attribute14 VARCHAR2
2879 , p_attribute15 VARCHAR2
2880 , p_attribute_category VARCHAR2
2881 , p_date_selected VARCHAR2
2882 , p_category_id NUMBER
2883 , p_show_on_calendar VARCHAR2
2884 , p_owner_status_id NUMBER
2885 , p_enable_workflow VARCHAR2
2886 , p_abort_workflow VARCHAR2
2887 , p_change_mode VARCHAR2
2888 , p_free_busy_type VARCHAR2
2889 , p_task_confirmation_status VARCHAR2
2890 , p_task_confirmation_counter NUMBER
2891 , p_task_split_flag VARCHAR2
2892 , p_child_position VARCHAR2
2893 , p_child_sequence_num NUMBER
2894 , p_location_id NUMBER
2895 )
2896
2897 as
2898 ddp_planned_start_date date;
2899 ddp_planned_end_date date;
2900 ddp_scheduled_start_date date;
2901 ddp_scheduled_end_date date;
2902 ddp_actual_start_date date;
2903 ddp_actual_end_date date;
2904 ddindx binary_integer; indx binary_integer;
2905 begin
2906
2907 -- copy data to the local IN or IN-OUT args, if any
2908
2909
2910
2911
2912
2913
2914
2915
2916
2917
2918
2919
2920
2921
2922
2923
2924
2925 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
2926
2927 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
2928
2929 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
2930
2931 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
2932
2933 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
2934
2935 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
2936
2937
2938
2939
2940
2941
2942
2943
2944
2945
2946
2947
2948
2949
2950
2951
2952
2953
2954
2955
2956
2957
2958
2959
2960
2961
2962
2963
2964
2965
2966
2967
2968
2969
2970
2971
2972
2973
2974
2975
2976
2977
2978
2979
2980
2981
2982
2983
2984
2985
2986
2987
2988
2989
2990
2991
2992
2993
2994
2995
2996
2997
2998
2999
3000
3001
3002
3003
3004
3005
3006
3007
3008
3009
3010
3011
3012 -- here's the delegated call to the old PL/SQL routine
3013 jtf_tasks_pvt.update_task(p_api_version,
3014 p_init_msg_list,
3015 p_commit,
3016 p_object_version_number,
3017 p_task_id,
3018 p_task_name,
3019 p_task_type_id,
3020 p_description,
3021 p_task_status_id,
3022 p_task_priority_id,
3023 p_owner_type_code,
3024 p_owner_id,
3025 p_owner_territory_id,
3026 p_assigned_by_id,
3027 p_customer_id,
3028 p_cust_account_id,
3029 p_address_id,
3030 ddp_planned_start_date,
3031 ddp_planned_end_date,
3032 ddp_scheduled_start_date,
3033 ddp_scheduled_end_date,
3034 ddp_actual_start_date,
3035 ddp_actual_end_date,
3036 p_timezone_id,
3037 p_source_object_type_code,
3038 p_source_object_id,
3039 p_source_object_name,
3040 p_duration,
3041 p_duration_uom,
3042 p_planned_effort,
3043 p_planned_effort_uom,
3044 p_actual_effort,
3045 p_actual_effort_uom,
3046 p_percentage_complete,
3047 p_reason_code,
3048 p_private_flag,
3049 p_publish_flag,
3050 p_restrict_closure_flag,
3051 p_multi_booked_flag,
3052 p_milestone_flag,
3053 p_holiday_flag,
3054 p_billable_flag,
3055 p_bound_mode_code,
3056 p_soft_bound_flag,
3057 p_workflow_process_id,
3058 p_notification_flag,
3059 p_notification_period,
3060 p_notification_period_uom,
3061 p_parent_task_id,
3062 p_alarm_start,
3063 p_alarm_start_uom,
3064 p_alarm_on,
3065 p_alarm_count,
3066 p_alarm_fired_count,
3067 p_alarm_interval,
3068 p_alarm_interval_uom,
3069 p_palm_flag,
3070 p_wince_flag,
3071 p_laptop_flag,
3072 p_device1_flag,
3073 p_device2_flag,
3074 p_device3_flag,
3075 p_costs,
3076 p_currency_code,
3077 p_escalation_level,
3078 x_return_status,
3079 x_msg_count,
3080 x_msg_data,
3081 p_attribute1,
3082 p_attribute2,
3083 p_attribute3,
3084 p_attribute4,
3085 p_attribute5,
3086 p_attribute6,
3087 p_attribute7,
3088 p_attribute8,
3089 p_attribute9,
3090 p_attribute10,
3091 p_attribute11,
3092 p_attribute12,
3093 p_attribute13,
3094 p_attribute14,
3095 p_attribute15,
3096 p_attribute_category,
3097 p_date_selected,
3098 p_category_id,
3099 p_show_on_calendar,
3100 p_owner_status_id,
3101 p_enable_workflow,
3102 p_abort_workflow,
3103 p_change_mode,
3104 p_free_busy_type,
3105 p_task_confirmation_status,
3106 p_task_confirmation_counter,
3107 p_task_split_flag,
3108 p_child_position,
3109 p_child_sequence_num,
3110 p_location_id);
3111
3112 -- copy data back from the local variables to OUT or IN-OUT args, if any
3113
3114
3115
3116
3117
3118
3119
3120
3121
3122
3123
3124
3125
3126
3127
3128
3129
3130
3131
3132
3133
3134
3135
3136
3137
3138
3139
3140
3141
3142
3143
3144
3145
3146
3147
3148
3149
3150
3151
3152
3153
3154
3155
3156
3157
3158
3159
3160
3161
3162
3163
3164
3165
3166
3167
3168
3169
3170
3171
3172
3173
3174
3175
3176
3177
3178
3179
3180
3181
3182
3183
3184
3185
3186
3187
3188
3189
3190
3191
3192
3193
3194
3195
3196
3197
3198
3199
3200
3201
3202
3203
3204
3205
3206
3207
3208
3209
3210 end;
3211
3212 procedure update_task(p_api_version NUMBER
3213 , p_init_msg_list VARCHAR2
3214 , p_commit VARCHAR2
3215 , p_object_version_number in out nocopy NUMBER
3216 , p_task_id NUMBER
3217 , p_task_name VARCHAR2
3218 , p_task_type_id NUMBER
3219 , p_description VARCHAR2
3220 , p_task_status_id NUMBER
3221 , p_task_priority_id NUMBER
3222 , p_owner_type_code VARCHAR2
3223 , p_owner_id NUMBER
3224 , p_owner_territory_id NUMBER
3225 , p_assigned_by_id NUMBER
3226 , p_customer_id NUMBER
3227 , p_cust_account_id NUMBER
3228 , p_address_id NUMBER
3229 , p_planned_start_date date
3230 , p_planned_end_date date
3231 , p_scheduled_start_date date
3232 , p_scheduled_end_date date
3233 , p_actual_start_date date
3234 , p_actual_end_date date
3235 , p_timezone_id NUMBER
3236 , p_source_object_type_code VARCHAR2
3237 , p_source_object_id NUMBER
3238 , p_source_object_name VARCHAR2
3239 , p_duration NUMBER
3240 , p_duration_uom VARCHAR2
3241 , p_planned_effort NUMBER
3242 , p_planned_effort_uom VARCHAR2
3243 , p_actual_effort NUMBER
3244 , p_actual_effort_uom VARCHAR2
3245 , p_percentage_complete NUMBER
3246 , p_reason_code VARCHAR2
3247 , p_private_flag VARCHAR2
3248 , p_publish_flag VARCHAR2
3249 , p_restrict_closure_flag VARCHAR2
3250 , p_multi_booked_flag VARCHAR2
3251 , p_milestone_flag VARCHAR2
3252 , p_holiday_flag VARCHAR2
3253 , p_billable_flag VARCHAR2
3254 , p_bound_mode_code VARCHAR2
3255 , p_soft_bound_flag VARCHAR2
3256 , p_workflow_process_id NUMBER
3257 , p_notification_flag VARCHAR2
3258 , p_notification_period NUMBER
3259 , p_notification_period_uom VARCHAR2
3260 , p_parent_task_id NUMBER
3261 , p_alarm_start NUMBER
3262 , p_alarm_start_uom VARCHAR2
3263 , p_alarm_on VARCHAR2
3264 , p_alarm_count NUMBER
3265 , p_alarm_fired_count NUMBER
3266 , p_alarm_interval NUMBER
3267 , p_alarm_interval_uom VARCHAR2
3268 , p_palm_flag VARCHAR2
3269 , p_wince_flag VARCHAR2
3270 , p_laptop_flag VARCHAR2
3271 , p_device1_flag VARCHAR2
3272 , p_device2_flag VARCHAR2
3273 , p_device3_flag VARCHAR2
3274 , p_costs NUMBER
3275 , p_currency_code VARCHAR2
3276 , p_escalation_level VARCHAR2
3277 , x_return_status out nocopy VARCHAR2
3278 , x_msg_count out nocopy NUMBER
3279 , x_msg_data out nocopy VARCHAR2
3280 , p_attribute1 VARCHAR2
3281 , p_attribute2 VARCHAR2
3282 , p_attribute3 VARCHAR2
3283 , p_attribute4 VARCHAR2
3284 , p_attribute5 VARCHAR2
3285 , p_attribute6 VARCHAR2
3286 , p_attribute7 VARCHAR2
3287 , p_attribute8 VARCHAR2
3288 , p_attribute9 VARCHAR2
3289 , p_attribute10 VARCHAR2
3290 , p_attribute11 VARCHAR2
3291 , p_attribute12 VARCHAR2
3292 , p_attribute13 VARCHAR2
3293 , p_attribute14 VARCHAR2
3294 , p_attribute15 VARCHAR2
3295 , p_attribute_category VARCHAR2
3296 , p_date_selected VARCHAR2
3297 , p_category_id NUMBER
3298 , p_show_on_calendar VARCHAR2
3299 , p_owner_status_id NUMBER
3300 , p_enable_workflow VARCHAR2
3301 , p_abort_workflow VARCHAR2
3302 , p_change_mode VARCHAR2
3303 , p_free_busy_type VARCHAR2
3304 , p_task_confirmation_status VARCHAR2
3305 , p_task_confirmation_counter NUMBER
3306 , p_task_split_flag VARCHAR2
3307 , p_child_position VARCHAR2
3308 , p_child_sequence_num NUMBER
3309 )
3310
3311 as
3312 ddp_planned_start_date date;
3313 ddp_planned_end_date date;
3314 ddp_scheduled_start_date date;
3315 ddp_scheduled_end_date date;
3316 ddp_actual_start_date date;
3317 ddp_actual_end_date date;
3318 ddindx binary_integer; indx binary_integer;
3319 begin
3320
3321 -- copy data to the local IN or IN-OUT args, if any
3322
3323
3324
3325
3326
3327
3328
3329
3330
3331
3332
3333
3334
3335
3336
3337
3338
3339 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
3340
3341 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
3342
3343 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
3344
3345 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
3346
3347 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
3348
3349 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
3350
3351
3352
3353
3354
3355
3356
3357
3358
3359
3360
3361
3362
3363
3364
3365
3366
3367
3368
3369
3370
3371
3372
3373
3374
3375
3376
3377
3378
3379
3380
3381
3382
3383
3384
3385
3386
3387
3388
3389
3390
3391
3392
3393
3394
3395
3396
3397
3398
3399
3400
3401
3402
3403
3404
3405
3406
3407
3408
3409
3410
3411
3412
3413
3414
3415
3416
3417
3418
3419
3420
3421
3422
3423
3424
3425 -- here's the delegated call to the old PL/SQL routine
3426 jtf_tasks_pvt.update_task(p_api_version,
3427 p_init_msg_list,
3428 p_commit,
3429 p_object_version_number,
3430 p_task_id,
3431 p_task_name,
3432 p_task_type_id,
3433 p_description,
3434 p_task_status_id,
3435 p_task_priority_id,
3436 p_owner_type_code,
3437 p_owner_id,
3438 p_owner_territory_id,
3439 p_assigned_by_id,
3440 p_customer_id,
3441 p_cust_account_id,
3442 p_address_id,
3443 ddp_planned_start_date,
3444 ddp_planned_end_date,
3445 ddp_scheduled_start_date,
3446 ddp_scheduled_end_date,
3447 ddp_actual_start_date,
3448 ddp_actual_end_date,
3449 p_timezone_id,
3450 p_source_object_type_code,
3451 p_source_object_id,
3452 p_source_object_name,
3453 p_duration,
3454 p_duration_uom,
3455 p_planned_effort,
3456 p_planned_effort_uom,
3457 p_actual_effort,
3458 p_actual_effort_uom,
3459 p_percentage_complete,
3460 p_reason_code,
3461 p_private_flag,
3462 p_publish_flag,
3463 p_restrict_closure_flag,
3464 p_multi_booked_flag,
3465 p_milestone_flag,
3466 p_holiday_flag,
3467 p_billable_flag,
3468 p_bound_mode_code,
3469 p_soft_bound_flag,
3470 p_workflow_process_id,
3471 p_notification_flag,
3472 p_notification_period,
3473 p_notification_period_uom,
3474 p_parent_task_id,
3475 p_alarm_start,
3476 p_alarm_start_uom,
3477 p_alarm_on,
3478 p_alarm_count,
3479 p_alarm_fired_count,
3480 p_alarm_interval,
3481 p_alarm_interval_uom,
3482 p_palm_flag,
3483 p_wince_flag,
3484 p_laptop_flag,
3485 p_device1_flag,
3486 p_device2_flag,
3487 p_device3_flag,
3488 p_costs,
3489 p_currency_code,
3490 p_escalation_level,
3491 x_return_status,
3492 x_msg_count,
3493 x_msg_data,
3494 p_attribute1,
3495 p_attribute2,
3496 p_attribute3,
3497 p_attribute4,
3498 p_attribute5,
3499 p_attribute6,
3500 p_attribute7,
3501 p_attribute8,
3502 p_attribute9,
3503 p_attribute10,
3504 p_attribute11,
3505 p_attribute12,
3506 p_attribute13,
3507 p_attribute14,
3508 p_attribute15,
3509 p_attribute_category,
3510 p_date_selected,
3511 p_category_id,
3512 p_show_on_calendar,
3513 p_owner_status_id,
3514 p_enable_workflow,
3515 p_abort_workflow,
3516 p_change_mode,
3517 p_free_busy_type,
3518 p_task_confirmation_status,
3519 p_task_confirmation_counter,
3520 p_task_split_flag,
3521 p_child_position,
3522 p_child_sequence_num);
3523
3524 -- copy data back from the local variables to OUT or IN-OUT args, if any
3525
3526
3527
3528
3529
3530
3531
3532
3533
3534
3535
3536
3537
3538
3539
3540
3541
3542
3543
3544
3545
3546
3547
3548
3549
3550
3551
3552
3553
3554
3555
3556
3557
3558
3559
3560
3561
3562
3563
3564
3565
3566
3567
3568
3569
3570
3571
3572
3573
3574
3575
3576
3577
3578
3579
3580
3581
3582
3583
3584
3585
3586
3587
3588
3589
3590
3591
3592
3593
3594
3595
3596
3597
3598
3599
3600
3601
3602
3603
3604
3605
3606
3607
3608
3609
3610
3611
3612
3613
3614
3615
3616
3617
3618
3619
3620
3621 end;
3622
3623 procedure update_task(p_api_version NUMBER
3624 , p_init_msg_list VARCHAR2
3625 , p_commit VARCHAR2
3626 , p_object_version_number in out nocopy NUMBER
3627 , p_task_id NUMBER
3628 , p_task_name VARCHAR2
3629 , p_task_type_id NUMBER
3630 , p_description VARCHAR2
3631 , p_task_status_id NUMBER
3632 , p_task_priority_id NUMBER
3633 , p_owner_type_code VARCHAR2
3634 , p_owner_id NUMBER
3635 , p_owner_territory_id NUMBER
3636 , p_assigned_by_id NUMBER
3637 , p_customer_id NUMBER
3638 , p_cust_account_id NUMBER
3639 , p_address_id NUMBER
3640 , p_planned_start_date date
3641 , p_planned_end_date date
3642 , p_scheduled_start_date date
3643 , p_scheduled_end_date date
3644 , p_actual_start_date date
3645 , p_actual_end_date date
3646 , p_timezone_id NUMBER
3647 , p_source_object_type_code VARCHAR2
3648 , p_source_object_id NUMBER
3649 , p_source_object_name VARCHAR2
3650 , p_duration NUMBER
3651 , p_duration_uom VARCHAR2
3652 , p_planned_effort NUMBER
3653 , p_planned_effort_uom VARCHAR2
3654 , p_actual_effort NUMBER
3655 , p_actual_effort_uom VARCHAR2
3656 , p_percentage_complete NUMBER
3657 , p_reason_code VARCHAR2
3658 , p_private_flag VARCHAR2
3659 , p_publish_flag VARCHAR2
3660 , p_restrict_closure_flag VARCHAR2
3661 , p_multi_booked_flag VARCHAR2
3662 , p_milestone_flag VARCHAR2
3663 , p_holiday_flag VARCHAR2
3664 , p_billable_flag VARCHAR2
3665 , p_bound_mode_code VARCHAR2
3666 , p_soft_bound_flag VARCHAR2
3667 , p_workflow_process_id NUMBER
3668 , p_notification_flag VARCHAR2
3669 , p_notification_period NUMBER
3670 , p_notification_period_uom VARCHAR2
3671 , p_parent_task_id NUMBER
3672 , p_alarm_start NUMBER
3673 , p_alarm_start_uom VARCHAR2
3674 , p_alarm_on VARCHAR2
3675 , p_alarm_count NUMBER
3676 , p_alarm_fired_count NUMBER
3677 , p_alarm_interval NUMBER
3678 , p_alarm_interval_uom VARCHAR2
3679 , p_palm_flag VARCHAR2
3680 , p_wince_flag VARCHAR2
3681 , p_laptop_flag VARCHAR2
3682 , p_device1_flag VARCHAR2
3683 , p_device2_flag VARCHAR2
3684 , p_device3_flag VARCHAR2
3685 , p_costs NUMBER
3686 , p_currency_code VARCHAR2
3687 , p_escalation_level VARCHAR2
3688 , x_return_status out nocopy VARCHAR2
3689 , x_msg_count out nocopy NUMBER
3690 , x_msg_data out nocopy VARCHAR2
3691 , p_attribute1 VARCHAR2
3692 , p_attribute2 VARCHAR2
3693 , p_attribute3 VARCHAR2
3694 , p_attribute4 VARCHAR2
3695 , p_attribute5 VARCHAR2
3696 , p_attribute6 VARCHAR2
3697 , p_attribute7 VARCHAR2
3698 , p_attribute8 VARCHAR2
3699 , p_attribute9 VARCHAR2
3700 , p_attribute10 VARCHAR2
3701 , p_attribute11 VARCHAR2
3702 , p_attribute12 VARCHAR2
3703 , p_attribute13 VARCHAR2
3704 , p_attribute14 VARCHAR2
3705 , p_attribute15 VARCHAR2
3706 , p_attribute_category VARCHAR2
3707 , p_date_selected VARCHAR2
3708 , p_category_id NUMBER
3709 , p_show_on_calendar VARCHAR2
3710 , p_owner_status_id NUMBER
3711 , p_enable_workflow VARCHAR2
3712 , p_abort_workflow VARCHAR2
3713 )
3714
3715 as
3716 ddp_planned_start_date date;
3717 ddp_planned_end_date date;
3718 ddp_scheduled_start_date date;
3719 ddp_scheduled_end_date date;
3720 ddp_actual_start_date date;
3721 ddp_actual_end_date date;
3722 ddindx binary_integer; indx binary_integer;
3723 begin
3724
3725 -- copy data to the local IN or IN-OUT args, if any
3726
3727
3728
3729
3730
3731
3732
3733
3734
3735
3736
3737
3738
3739
3740
3741
3742
3743 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
3744
3745 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
3746
3747 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
3748
3749 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
3750
3751 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
3752
3753 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
3754
3755
3756
3757
3758
3759
3760
3761
3762
3763
3764
3765
3766
3767
3768
3769
3770
3771
3772
3773
3774
3775
3776
3777
3778
3779
3780
3781
3782
3783
3784
3785
3786
3787
3788
3789
3790
3791
3792
3793
3794
3795
3796
3797
3798
3799
3800
3801
3802
3803
3804
3805
3806
3807
3808
3809
3810
3811
3812
3813
3814
3815
3816
3817
3818
3819
3820
3821
3822 -- here's the delegated call to the old PL/SQL routine
3823 jtf_tasks_pvt.update_task(p_api_version,
3824 p_init_msg_list,
3825 p_commit,
3826 p_object_version_number,
3827 p_task_id,
3828 p_task_name,
3829 p_task_type_id,
3830 p_description,
3831 p_task_status_id,
3832 p_task_priority_id,
3833 p_owner_type_code,
3834 p_owner_id,
3835 p_owner_territory_id,
3836 p_assigned_by_id,
3837 p_customer_id,
3838 p_cust_account_id,
3839 p_address_id,
3840 ddp_planned_start_date,
3841 ddp_planned_end_date,
3842 ddp_scheduled_start_date,
3843 ddp_scheduled_end_date,
3844 ddp_actual_start_date,
3845 ddp_actual_end_date,
3846 p_timezone_id,
3847 p_source_object_type_code,
3848 p_source_object_id,
3849 p_source_object_name,
3850 p_duration,
3851 p_duration_uom,
3852 p_planned_effort,
3853 p_planned_effort_uom,
3854 p_actual_effort,
3855 p_actual_effort_uom,
3856 p_percentage_complete,
3857 p_reason_code,
3858 p_private_flag,
3859 p_publish_flag,
3860 p_restrict_closure_flag,
3861 p_multi_booked_flag,
3862 p_milestone_flag,
3863 p_holiday_flag,
3864 p_billable_flag,
3865 p_bound_mode_code,
3866 p_soft_bound_flag,
3867 p_workflow_process_id,
3868 p_notification_flag,
3869 p_notification_period,
3870 p_notification_period_uom,
3871 p_parent_task_id,
3872 p_alarm_start,
3873 p_alarm_start_uom,
3874 p_alarm_on,
3875 p_alarm_count,
3876 p_alarm_fired_count,
3877 p_alarm_interval,
3878 p_alarm_interval_uom,
3879 p_palm_flag,
3880 p_wince_flag,
3881 p_laptop_flag,
3882 p_device1_flag,
3883 p_device2_flag,
3884 p_device3_flag,
3885 p_costs,
3886 p_currency_code,
3887 p_escalation_level,
3888 x_return_status,
3889 x_msg_count,
3890 x_msg_data,
3891 p_attribute1,
3892 p_attribute2,
3893 p_attribute3,
3894 p_attribute4,
3895 p_attribute5,
3896 p_attribute6,
3897 p_attribute7,
3898 p_attribute8,
3899 p_attribute9,
3900 p_attribute10,
3901 p_attribute11,
3902 p_attribute12,
3903 p_attribute13,
3904 p_attribute14,
3905 p_attribute15,
3906 p_attribute_category,
3907 p_date_selected,
3908 p_category_id,
3909 p_show_on_calendar,
3910 p_owner_status_id,
3911 p_enable_workflow,
3912 p_abort_workflow);
3913
3914 -- copy data back from the local variables to OUT or IN-OUT args, if any
3915
3916
3917
3918
3919
3920
3921
3922
3923
3924
3925
3926
3927
3928
3929
3930
3931
3932
3933
3934
3935
3936
3937
3938
3939
3940
3941
3942
3943
3944
3945
3946
3947
3948
3949
3950
3951
3952
3953
3954
3955
3956
3957
3958
3959
3960
3961
3962
3963
3964
3965
3966
3967
3968
3969
3970
3971
3972
3973
3974
3975
3976
3977
3978
3979
3980
3981
3982
3983
3984
3985
3986
3987
3988
3989
3990
3991
3992
3993
3994
3995
3996
3997
3998
3999
4000
4001
4002
4003
4004 end;
4005
4006 procedure update_task(p_api_version NUMBER
4007 , p_init_msg_list VARCHAR2
4008 , p_commit VARCHAR2
4009 , p_object_version_number in out nocopy NUMBER
4010 , p_task_id NUMBER
4011 , p_task_name VARCHAR2
4012 , p_task_type_id NUMBER
4013 , p_description VARCHAR2
4014 , p_task_status_id NUMBER
4015 , p_task_priority_id NUMBER
4016 , p_owner_type_code VARCHAR2
4017 , p_owner_id NUMBER
4018 , p_owner_territory_id NUMBER
4019 , p_assigned_by_id NUMBER
4020 , p_customer_id NUMBER
4021 , p_cust_account_id NUMBER
4022 , p_address_id NUMBER
4023 , p_planned_start_date date
4024 , p_planned_end_date date
4025 , p_scheduled_start_date date
4026 , p_scheduled_end_date date
4027 , p_actual_start_date date
4028 , p_actual_end_date date
4029 , p_timezone_id NUMBER
4030 , p_source_object_type_code VARCHAR2
4031 , p_source_object_id NUMBER
4032 , p_source_object_name VARCHAR2
4033 , p_duration NUMBER
4034 , p_duration_uom VARCHAR2
4035 , p_planned_effort NUMBER
4036 , p_planned_effort_uom VARCHAR2
4037 , p_actual_effort NUMBER
4038 , p_actual_effort_uom VARCHAR2
4039 , p_percentage_complete NUMBER
4040 , p_reason_code VARCHAR2
4041 , p_private_flag VARCHAR2
4042 , p_publish_flag VARCHAR2
4043 , p_restrict_closure_flag VARCHAR2
4044 , p_multi_booked_flag VARCHAR2
4045 , p_milestone_flag VARCHAR2
4046 , p_holiday_flag VARCHAR2
4047 , p_billable_flag VARCHAR2
4048 , p_bound_mode_code VARCHAR2
4049 , p_soft_bound_flag VARCHAR2
4050 , p_workflow_process_id NUMBER
4051 , p_notification_flag VARCHAR2
4052 , p_notification_period NUMBER
4053 , p_notification_period_uom VARCHAR2
4054 , p_parent_task_id NUMBER
4055 , p_alarm_start NUMBER
4056 , p_alarm_start_uom VARCHAR2
4057 , p_alarm_on VARCHAR2
4058 , p_alarm_count NUMBER
4059 , p_alarm_fired_count NUMBER
4060 , p_alarm_interval NUMBER
4061 , p_alarm_interval_uom VARCHAR2
4062 , p_palm_flag VARCHAR2
4063 , p_wince_flag VARCHAR2
4064 , p_laptop_flag VARCHAR2
4065 , p_device1_flag VARCHAR2
4066 , p_device2_flag VARCHAR2
4067 , p_device3_flag VARCHAR2
4068 , p_costs NUMBER
4069 , p_currency_code VARCHAR2
4070 , p_escalation_level VARCHAR2
4071 , x_return_status out nocopy VARCHAR2
4072 , x_msg_count out nocopy NUMBER
4073 , x_msg_data out nocopy VARCHAR2
4074 , p_attribute1 VARCHAR2
4075 , p_attribute2 VARCHAR2
4076 , p_attribute3 VARCHAR2
4077 , p_attribute4 VARCHAR2
4078 , p_attribute5 VARCHAR2
4079 , p_attribute6 VARCHAR2
4080 , p_attribute7 VARCHAR2
4081 , p_attribute8 VARCHAR2
4082 , p_attribute9 VARCHAR2
4083 , p_attribute10 VARCHAR2
4084 , p_attribute11 VARCHAR2
4085 , p_attribute12 VARCHAR2
4086 , p_attribute13 VARCHAR2
4087 , p_attribute14 VARCHAR2
4088 , p_attribute15 VARCHAR2
4089 , p_attribute_category VARCHAR2
4090 , p_date_selected VARCHAR2
4091 , p_category_id NUMBER
4092 , p_show_on_calendar VARCHAR2
4093 , p_owner_status_id NUMBER
4094 )
4095
4096 as
4097 ddp_planned_start_date date;
4098 ddp_planned_end_date date;
4099 ddp_scheduled_start_date date;
4100 ddp_scheduled_end_date date;
4101 ddp_actual_start_date date;
4102 ddp_actual_end_date date;
4103 ddindx binary_integer; indx binary_integer;
4104 begin
4105
4106 -- copy data to the local IN or IN-OUT args, if any
4107
4108
4109
4110
4111
4112
4113
4114
4115
4116
4117
4118
4119
4120
4121
4122
4123
4124 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
4125
4126 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
4127
4128 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
4129
4130 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
4131
4132 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
4133
4134 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
4135
4136
4137
4138
4139
4140
4141
4142
4143
4144
4145
4146
4147
4148
4149
4150
4151
4152
4153
4154
4155
4156
4157
4158
4159
4160
4161
4162
4163
4164
4165
4166
4167
4168
4169
4170
4171
4172
4173
4174
4175
4176
4177
4178
4179
4180
4181
4182
4183
4184
4185
4186
4187
4188
4189
4190
4191
4192
4193
4194
4195
4196
4197
4198
4199
4200
4201 -- here's the delegated call to the old PL/SQL routine
4202 jtf_tasks_pvt.update_task(p_api_version,
4203 p_init_msg_list,
4204 p_commit,
4205 p_object_version_number,
4206 p_task_id,
4207 p_task_name,
4208 p_task_type_id,
4209 p_description,
4210 p_task_status_id,
4211 p_task_priority_id,
4212 p_owner_type_code,
4213 p_owner_id,
4214 p_owner_territory_id,
4215 p_assigned_by_id,
4216 p_customer_id,
4217 p_cust_account_id,
4218 p_address_id,
4219 ddp_planned_start_date,
4220 ddp_planned_end_date,
4221 ddp_scheduled_start_date,
4222 ddp_scheduled_end_date,
4223 ddp_actual_start_date,
4224 ddp_actual_end_date,
4225 p_timezone_id,
4226 p_source_object_type_code,
4227 p_source_object_id,
4228 p_source_object_name,
4229 p_duration,
4230 p_duration_uom,
4231 p_planned_effort,
4232 p_planned_effort_uom,
4233 p_actual_effort,
4234 p_actual_effort_uom,
4235 p_percentage_complete,
4236 p_reason_code,
4237 p_private_flag,
4238 p_publish_flag,
4239 p_restrict_closure_flag,
4240 p_multi_booked_flag,
4241 p_milestone_flag,
4242 p_holiday_flag,
4243 p_billable_flag,
4244 p_bound_mode_code,
4245 p_soft_bound_flag,
4246 p_workflow_process_id,
4247 p_notification_flag,
4248 p_notification_period,
4249 p_notification_period_uom,
4250 p_parent_task_id,
4251 p_alarm_start,
4252 p_alarm_start_uom,
4253 p_alarm_on,
4254 p_alarm_count,
4255 p_alarm_fired_count,
4256 p_alarm_interval,
4257 p_alarm_interval_uom,
4258 p_palm_flag,
4259 p_wince_flag,
4260 p_laptop_flag,
4261 p_device1_flag,
4262 p_device2_flag,
4263 p_device3_flag,
4264 p_costs,
4265 p_currency_code,
4266 p_escalation_level,
4267 x_return_status,
4268 x_msg_count,
4269 x_msg_data,
4270 p_attribute1,
4271 p_attribute2,
4272 p_attribute3,
4273 p_attribute4,
4274 p_attribute5,
4275 p_attribute6,
4276 p_attribute7,
4277 p_attribute8,
4278 p_attribute9,
4279 p_attribute10,
4280 p_attribute11,
4281 p_attribute12,
4282 p_attribute13,
4283 p_attribute14,
4284 p_attribute15,
4285 p_attribute_category,
4286 p_date_selected,
4287 p_category_id,
4288 p_show_on_calendar,
4289 p_owner_status_id);
4290
4291 -- copy data back from the local variables to OUT or IN-OUT args, if any
4292
4293
4294
4295
4296
4297
4298
4299
4300
4301
4302
4303
4304
4305
4306
4307
4308
4309
4310
4311
4312
4313
4314
4315
4316
4317
4318
4319
4320
4321
4322
4323
4324
4325
4326
4327
4328
4329
4330
4331
4332
4333
4334
4335
4336
4337
4338
4339
4340
4341
4342
4343
4344
4345
4346
4347
4348
4349
4350
4351
4352
4353
4354
4355
4356
4357
4358
4359
4360
4361
4362
4363
4364
4365
4366
4367
4368
4369
4370
4371
4372
4373
4374
4375
4376
4377
4378
4379 end;
4380
4381 end jtf_tasks_pvt_w;