5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;
519: , p6_a20 out nocopy VARCHAR2
520: , p6_a21 out nocopy VARCHAR2
521: , p5_a0 NUMBER := 0-1962.0724
522: , p5_a1 NUMBER := 0-1962.0724
523: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a4 NUMBER := 0-1962.0724
526: , p5_a5 NUMBER := 0-1962.0724
527: , p5_a6 NUMBER := 0-1962.0724
520: , p6_a21 out nocopy VARCHAR2
521: , p5_a0 NUMBER := 0-1962.0724
522: , p5_a1 NUMBER := 0-1962.0724
523: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a4 NUMBER := 0-1962.0724
526: , p5_a5 NUMBER := 0-1962.0724
527: , p5_a6 NUMBER := 0-1962.0724
528: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a4 NUMBER := 0-1962.0724
526: , p5_a5 NUMBER := 0-1962.0724
527: , p5_a6 NUMBER := 0-1962.0724
528: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a4 NUMBER := 0-1962.0724
526: , p5_a5 NUMBER := 0-1962.0724
527: , p5_a6 NUMBER := 0-1962.0724
528: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a12 NUMBER := 0-1962.0724
526: , p5_a5 NUMBER := 0-1962.0724
527: , p5_a6 NUMBER := 0-1962.0724
528: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a12 NUMBER := 0-1962.0724
534: , p5_a13 NUMBER := 0-1962.0724
527: , p5_a6 NUMBER := 0-1962.0724
528: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a12 NUMBER := 0-1962.0724
534: , p5_a13 NUMBER := 0-1962.0724
535: , p5_a14 DATE := fnd_api.g_miss_date
528: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a12 NUMBER := 0-1962.0724
534: , p5_a13 NUMBER := 0-1962.0724
535: , p5_a14 DATE := fnd_api.g_miss_date
536: , p5_a15 NUMBER := 0-1962.0724
531: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a12 NUMBER := 0-1962.0724
534: , p5_a13 NUMBER := 0-1962.0724
535: , p5_a14 DATE := fnd_api.g_miss_date
536: , p5_a15 NUMBER := 0-1962.0724
537: , p5_a16 DATE := fnd_api.g_miss_date
538: , p5_a17 NUMBER := 0-1962.0724
539: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a12 NUMBER := 0-1962.0724
534: , p5_a13 NUMBER := 0-1962.0724
535: , p5_a14 DATE := fnd_api.g_miss_date
536: , p5_a15 NUMBER := 0-1962.0724
537: , p5_a16 DATE := fnd_api.g_miss_date
538: , p5_a17 NUMBER := 0-1962.0724
539: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a14 DATE := fnd_api.g_miss_date
536: , p5_a15 NUMBER := 0-1962.0724
537: , p5_a16 DATE := fnd_api.g_miss_date
538: , p5_a17 NUMBER := 0-1962.0724
539: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
543: )
536: , p5_a15 NUMBER := 0-1962.0724
537: , p5_a16 DATE := fnd_api.g_miss_date
538: , p5_a17 NUMBER := 0-1962.0724
539: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
543: )
544:
537: , p5_a16 DATE := fnd_api.g_miss_date
538: , p5_a17 NUMBER := 0-1962.0724
539: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
543: )
544:
545: as
538: , p5_a17 NUMBER := 0-1962.0724
539: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
543: )
544:
545: as
546: ddp_tryv_rec okl_try_pvt.tryv_rec_type;
753: , x_msg_count out nocopy NUMBER
754: , x_msg_data out nocopy VARCHAR2
755: , p5_a0 NUMBER := 0-1962.0724
756: , p5_a1 NUMBER := 0-1962.0724
757: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a4 NUMBER := 0-1962.0724
760: , p5_a5 NUMBER := 0-1962.0724
761: , p5_a6 NUMBER := 0-1962.0724
754: , x_msg_data out nocopy VARCHAR2
755: , p5_a0 NUMBER := 0-1962.0724
756: , p5_a1 NUMBER := 0-1962.0724
757: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a4 NUMBER := 0-1962.0724
760: , p5_a5 NUMBER := 0-1962.0724
761: , p5_a6 NUMBER := 0-1962.0724
762: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a4 NUMBER := 0-1962.0724
760: , p5_a5 NUMBER := 0-1962.0724
761: , p5_a6 NUMBER := 0-1962.0724
762: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a4 NUMBER := 0-1962.0724
760: , p5_a5 NUMBER := 0-1962.0724
761: , p5_a6 NUMBER := 0-1962.0724
762: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a12 NUMBER := 0-1962.0724
760: , p5_a5 NUMBER := 0-1962.0724
761: , p5_a6 NUMBER := 0-1962.0724
762: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a12 NUMBER := 0-1962.0724
768: , p5_a13 NUMBER := 0-1962.0724
761: , p5_a6 NUMBER := 0-1962.0724
762: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a12 NUMBER := 0-1962.0724
768: , p5_a13 NUMBER := 0-1962.0724
769: , p5_a14 DATE := fnd_api.g_miss_date
762: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a12 NUMBER := 0-1962.0724
768: , p5_a13 NUMBER := 0-1962.0724
769: , p5_a14 DATE := fnd_api.g_miss_date
770: , p5_a15 NUMBER := 0-1962.0724
765: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a12 NUMBER := 0-1962.0724
768: , p5_a13 NUMBER := 0-1962.0724
769: , p5_a14 DATE := fnd_api.g_miss_date
770: , p5_a15 NUMBER := 0-1962.0724
771: , p5_a16 DATE := fnd_api.g_miss_date
772: , p5_a17 NUMBER := 0-1962.0724
773: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a12 NUMBER := 0-1962.0724
768: , p5_a13 NUMBER := 0-1962.0724
769: , p5_a14 DATE := fnd_api.g_miss_date
770: , p5_a15 NUMBER := 0-1962.0724
771: , p5_a16 DATE := fnd_api.g_miss_date
772: , p5_a17 NUMBER := 0-1962.0724
773: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a14 DATE := fnd_api.g_miss_date
770: , p5_a15 NUMBER := 0-1962.0724
771: , p5_a16 DATE := fnd_api.g_miss_date
772: , p5_a17 NUMBER := 0-1962.0724
773: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
777: )
770: , p5_a15 NUMBER := 0-1962.0724
771: , p5_a16 DATE := fnd_api.g_miss_date
772: , p5_a17 NUMBER := 0-1962.0724
773: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
777: )
778:
771: , p5_a16 DATE := fnd_api.g_miss_date
772: , p5_a17 NUMBER := 0-1962.0724
773: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
777: )
778:
779: as
772: , p5_a17 NUMBER := 0-1962.0724
773: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
777: )
778:
779: as
780: ddp_tryv_rec okl_try_pvt.tryv_rec_type;
934: , p6_a20 out nocopy VARCHAR2
935: , p6_a21 out nocopy VARCHAR2
936: , p5_a0 NUMBER := 0-1962.0724
937: , p5_a1 NUMBER := 0-1962.0724
938: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a4 NUMBER := 0-1962.0724
941: , p5_a5 NUMBER := 0-1962.0724
942: , p5_a6 NUMBER := 0-1962.0724
935: , p6_a21 out nocopy VARCHAR2
936: , p5_a0 NUMBER := 0-1962.0724
937: , p5_a1 NUMBER := 0-1962.0724
938: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a4 NUMBER := 0-1962.0724
941: , p5_a5 NUMBER := 0-1962.0724
942: , p5_a6 NUMBER := 0-1962.0724
943: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a4 NUMBER := 0-1962.0724
941: , p5_a5 NUMBER := 0-1962.0724
942: , p5_a6 NUMBER := 0-1962.0724
943: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a4 NUMBER := 0-1962.0724
941: , p5_a5 NUMBER := 0-1962.0724
942: , p5_a6 NUMBER := 0-1962.0724
943: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a12 NUMBER := 0-1962.0724
941: , p5_a5 NUMBER := 0-1962.0724
942: , p5_a6 NUMBER := 0-1962.0724
943: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a12 NUMBER := 0-1962.0724
949: , p5_a13 NUMBER := 0-1962.0724
942: , p5_a6 NUMBER := 0-1962.0724
943: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a12 NUMBER := 0-1962.0724
949: , p5_a13 NUMBER := 0-1962.0724
950: , p5_a14 DATE := fnd_api.g_miss_date
943: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a12 NUMBER := 0-1962.0724
949: , p5_a13 NUMBER := 0-1962.0724
950: , p5_a14 DATE := fnd_api.g_miss_date
951: , p5_a15 NUMBER := 0-1962.0724
946: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a12 NUMBER := 0-1962.0724
949: , p5_a13 NUMBER := 0-1962.0724
950: , p5_a14 DATE := fnd_api.g_miss_date
951: , p5_a15 NUMBER := 0-1962.0724
952: , p5_a16 DATE := fnd_api.g_miss_date
953: , p5_a17 NUMBER := 0-1962.0724
954: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a12 NUMBER := 0-1962.0724
949: , p5_a13 NUMBER := 0-1962.0724
950: , p5_a14 DATE := fnd_api.g_miss_date
951: , p5_a15 NUMBER := 0-1962.0724
952: , p5_a16 DATE := fnd_api.g_miss_date
953: , p5_a17 NUMBER := 0-1962.0724
954: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a14 DATE := fnd_api.g_miss_date
951: , p5_a15 NUMBER := 0-1962.0724
952: , p5_a16 DATE := fnd_api.g_miss_date
953: , p5_a17 NUMBER := 0-1962.0724
954: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
958: )
951: , p5_a15 NUMBER := 0-1962.0724
952: , p5_a16 DATE := fnd_api.g_miss_date
953: , p5_a17 NUMBER := 0-1962.0724
954: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
958: )
959:
952: , p5_a16 DATE := fnd_api.g_miss_date
953: , p5_a17 NUMBER := 0-1962.0724
954: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
958: )
959:
960: as
953: , p5_a17 NUMBER := 0-1962.0724
954: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
958: )
959:
960: as
961: ddp_tryv_rec okl_try_pvt.tryv_rec_type;
1168: , x_msg_count out nocopy NUMBER
1169: , x_msg_data out nocopy VARCHAR2
1170: , p5_a0 NUMBER := 0-1962.0724
1171: , p5_a1 NUMBER := 0-1962.0724
1172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a4 NUMBER := 0-1962.0724
1175: , p5_a5 NUMBER := 0-1962.0724
1176: , p5_a6 NUMBER := 0-1962.0724
1169: , x_msg_data out nocopy VARCHAR2
1170: , p5_a0 NUMBER := 0-1962.0724
1171: , p5_a1 NUMBER := 0-1962.0724
1172: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a4 NUMBER := 0-1962.0724
1175: , p5_a5 NUMBER := 0-1962.0724
1176: , p5_a6 NUMBER := 0-1962.0724
1177: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a4 NUMBER := 0-1962.0724
1175: , p5_a5 NUMBER := 0-1962.0724
1176: , p5_a6 NUMBER := 0-1962.0724
1177: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a4 NUMBER := 0-1962.0724
1175: , p5_a5 NUMBER := 0-1962.0724
1176: , p5_a6 NUMBER := 0-1962.0724
1177: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a12 NUMBER := 0-1962.0724
1175: , p5_a5 NUMBER := 0-1962.0724
1176: , p5_a6 NUMBER := 0-1962.0724
1177: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a12 NUMBER := 0-1962.0724
1183: , p5_a13 NUMBER := 0-1962.0724
1176: , p5_a6 NUMBER := 0-1962.0724
1177: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a12 NUMBER := 0-1962.0724
1183: , p5_a13 NUMBER := 0-1962.0724
1184: , p5_a14 DATE := fnd_api.g_miss_date
1177: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a12 NUMBER := 0-1962.0724
1183: , p5_a13 NUMBER := 0-1962.0724
1184: , p5_a14 DATE := fnd_api.g_miss_date
1185: , p5_a15 NUMBER := 0-1962.0724
1180: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a12 NUMBER := 0-1962.0724
1183: , p5_a13 NUMBER := 0-1962.0724
1184: , p5_a14 DATE := fnd_api.g_miss_date
1185: , p5_a15 NUMBER := 0-1962.0724
1186: , p5_a16 DATE := fnd_api.g_miss_date
1187: , p5_a17 NUMBER := 0-1962.0724
1188: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a12 NUMBER := 0-1962.0724
1183: , p5_a13 NUMBER := 0-1962.0724
1184: , p5_a14 DATE := fnd_api.g_miss_date
1185: , p5_a15 NUMBER := 0-1962.0724
1186: , p5_a16 DATE := fnd_api.g_miss_date
1187: , p5_a17 NUMBER := 0-1962.0724
1188: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a14 DATE := fnd_api.g_miss_date
1185: , p5_a15 NUMBER := 0-1962.0724
1186: , p5_a16 DATE := fnd_api.g_miss_date
1187: , p5_a17 NUMBER := 0-1962.0724
1188: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1192: )
1185: , p5_a15 NUMBER := 0-1962.0724
1186: , p5_a16 DATE := fnd_api.g_miss_date
1187: , p5_a17 NUMBER := 0-1962.0724
1188: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1192: )
1193:
1186: , p5_a16 DATE := fnd_api.g_miss_date
1187: , p5_a17 NUMBER := 0-1962.0724
1188: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1192: )
1193:
1194: as
1187: , p5_a17 NUMBER := 0-1962.0724
1188: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1192: )
1193:
1194: as
1195: ddp_tryv_rec okl_try_pvt.tryv_rec_type;
1327: , x_msg_count out nocopy NUMBER
1328: , x_msg_data out nocopy VARCHAR2
1329: , p5_a0 NUMBER := 0-1962.0724
1330: , p5_a1 NUMBER := 0-1962.0724
1331: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1332: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a4 NUMBER := 0-1962.0724
1334: , p5_a5 NUMBER := 0-1962.0724
1335: , p5_a6 NUMBER := 0-1962.0724
1328: , x_msg_data out nocopy VARCHAR2
1329: , p5_a0 NUMBER := 0-1962.0724
1330: , p5_a1 NUMBER := 0-1962.0724
1331: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1332: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a4 NUMBER := 0-1962.0724
1334: , p5_a5 NUMBER := 0-1962.0724
1335: , p5_a6 NUMBER := 0-1962.0724
1336: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1332: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a4 NUMBER := 0-1962.0724
1334: , p5_a5 NUMBER := 0-1962.0724
1335: , p5_a6 NUMBER := 0-1962.0724
1336: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1337: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1338: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a4 NUMBER := 0-1962.0724
1334: , p5_a5 NUMBER := 0-1962.0724
1335: , p5_a6 NUMBER := 0-1962.0724
1336: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1337: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1338: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a12 NUMBER := 0-1962.0724
1334: , p5_a5 NUMBER := 0-1962.0724
1335: , p5_a6 NUMBER := 0-1962.0724
1336: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1337: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1338: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a12 NUMBER := 0-1962.0724
1342: , p5_a13 NUMBER := 0-1962.0724
1335: , p5_a6 NUMBER := 0-1962.0724
1336: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1337: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1338: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a12 NUMBER := 0-1962.0724
1342: , p5_a13 NUMBER := 0-1962.0724
1343: , p5_a14 DATE := fnd_api.g_miss_date
1336: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1337: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1338: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a12 NUMBER := 0-1962.0724
1342: , p5_a13 NUMBER := 0-1962.0724
1343: , p5_a14 DATE := fnd_api.g_miss_date
1344: , p5_a15 NUMBER := 0-1962.0724
1339: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a12 NUMBER := 0-1962.0724
1342: , p5_a13 NUMBER := 0-1962.0724
1343: , p5_a14 DATE := fnd_api.g_miss_date
1344: , p5_a15 NUMBER := 0-1962.0724
1345: , p5_a16 DATE := fnd_api.g_miss_date
1346: , p5_a17 NUMBER := 0-1962.0724
1347: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a12 NUMBER := 0-1962.0724
1342: , p5_a13 NUMBER := 0-1962.0724
1343: , p5_a14 DATE := fnd_api.g_miss_date
1344: , p5_a15 NUMBER := 0-1962.0724
1345: , p5_a16 DATE := fnd_api.g_miss_date
1346: , p5_a17 NUMBER := 0-1962.0724
1347: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a14 DATE := fnd_api.g_miss_date
1344: , p5_a15 NUMBER := 0-1962.0724
1345: , p5_a16 DATE := fnd_api.g_miss_date
1346: , p5_a17 NUMBER := 0-1962.0724
1347: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1351: )
1344: , p5_a15 NUMBER := 0-1962.0724
1345: , p5_a16 DATE := fnd_api.g_miss_date
1346: , p5_a17 NUMBER := 0-1962.0724
1347: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1351: )
1352:
1345: , p5_a16 DATE := fnd_api.g_miss_date
1346: , p5_a17 NUMBER := 0-1962.0724
1347: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1351: )
1352:
1353: as
1346: , p5_a17 NUMBER := 0-1962.0724
1347: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1351: )
1352:
1353: as
1354: ddp_tryv_rec okl_try_pvt.tryv_rec_type;