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:
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: function rosetta_g_miss_num_map(n number) return number as
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;
385: , p6_a17 out nocopy VARCHAR2
386: , p6_a18 out nocopy VARCHAR2
387: , p5_a0 NUMBER := 0-1962.0724
388: , p5_a1 NUMBER := 0-1962.0724
389: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
386: , p6_a18 out nocopy VARCHAR2
387: , p5_a0 NUMBER := 0-1962.0724
388: , p5_a1 NUMBER := 0-1962.0724
389: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a0 NUMBER := 0-1962.0724
388: , p5_a1 NUMBER := 0-1962.0724
389: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a8 NUMBER := 0-1962.0724
388: , p5_a1 NUMBER := 0-1962.0724
389: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a8 NUMBER := 0-1962.0724
396: , p5_a9 NUMBER := 0-1962.0724
389: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a8 NUMBER := 0-1962.0724
396: , p5_a9 NUMBER := 0-1962.0724
397: , p5_a10 DATE := fnd_api.g_miss_date
390: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a8 NUMBER := 0-1962.0724
396: , p5_a9 NUMBER := 0-1962.0724
397: , p5_a10 DATE := fnd_api.g_miss_date
398: , p5_a11 NUMBER := 0-1962.0724
393: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a8 NUMBER := 0-1962.0724
396: , p5_a9 NUMBER := 0-1962.0724
397: , p5_a10 DATE := fnd_api.g_miss_date
398: , p5_a11 NUMBER := 0-1962.0724
399: , p5_a12 DATE := fnd_api.g_miss_date
400: , p5_a13 NUMBER := 0-1962.0724
401: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a8 NUMBER := 0-1962.0724
396: , p5_a9 NUMBER := 0-1962.0724
397: , p5_a10 DATE := fnd_api.g_miss_date
398: , p5_a11 NUMBER := 0-1962.0724
399: , p5_a12 DATE := fnd_api.g_miss_date
400: , p5_a13 NUMBER := 0-1962.0724
401: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a10 DATE := fnd_api.g_miss_date
398: , p5_a11 NUMBER := 0-1962.0724
399: , p5_a12 DATE := fnd_api.g_miss_date
400: , p5_a13 NUMBER := 0-1962.0724
401: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a11 NUMBER := 0-1962.0724
399: , p5_a12 DATE := fnd_api.g_miss_date
400: , p5_a13 NUMBER := 0-1962.0724
401: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
406: )
399: , p5_a12 DATE := fnd_api.g_miss_date
400: , p5_a13 NUMBER := 0-1962.0724
401: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
406: )
407:
400: , p5_a13 NUMBER := 0-1962.0724
401: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
406: )
407:
408: as
401: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
406: )
407:
408: as
409: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;
617: , p6_a17 out nocopy VARCHAR2
618: , p6_a18 out nocopy VARCHAR2
619: , p5_a0 NUMBER := 0-1962.0724
620: , p5_a1 NUMBER := 0-1962.0724
621: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
618: , p6_a18 out nocopy VARCHAR2
619: , p5_a0 NUMBER := 0-1962.0724
620: , p5_a1 NUMBER := 0-1962.0724
621: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a0 NUMBER := 0-1962.0724
620: , p5_a1 NUMBER := 0-1962.0724
621: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a8 NUMBER := 0-1962.0724
620: , p5_a1 NUMBER := 0-1962.0724
621: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a8 NUMBER := 0-1962.0724
628: , p5_a9 NUMBER := 0-1962.0724
621: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a8 NUMBER := 0-1962.0724
628: , p5_a9 NUMBER := 0-1962.0724
629: , p5_a10 DATE := fnd_api.g_miss_date
622: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a8 NUMBER := 0-1962.0724
628: , p5_a9 NUMBER := 0-1962.0724
629: , p5_a10 DATE := fnd_api.g_miss_date
630: , p5_a11 NUMBER := 0-1962.0724
625: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a8 NUMBER := 0-1962.0724
628: , p5_a9 NUMBER := 0-1962.0724
629: , p5_a10 DATE := fnd_api.g_miss_date
630: , p5_a11 NUMBER := 0-1962.0724
631: , p5_a12 DATE := fnd_api.g_miss_date
632: , p5_a13 NUMBER := 0-1962.0724
633: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a8 NUMBER := 0-1962.0724
628: , p5_a9 NUMBER := 0-1962.0724
629: , p5_a10 DATE := fnd_api.g_miss_date
630: , p5_a11 NUMBER := 0-1962.0724
631: , p5_a12 DATE := fnd_api.g_miss_date
632: , p5_a13 NUMBER := 0-1962.0724
633: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a10 DATE := fnd_api.g_miss_date
630: , p5_a11 NUMBER := 0-1962.0724
631: , p5_a12 DATE := fnd_api.g_miss_date
632: , p5_a13 NUMBER := 0-1962.0724
633: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
636: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
630: , p5_a11 NUMBER := 0-1962.0724
631: , p5_a12 DATE := fnd_api.g_miss_date
632: , p5_a13 NUMBER := 0-1962.0724
633: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
636: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
638: )
631: , p5_a12 DATE := fnd_api.g_miss_date
632: , p5_a13 NUMBER := 0-1962.0724
633: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
636: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
638: )
639:
632: , p5_a13 NUMBER := 0-1962.0724
633: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
636: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
638: )
639:
640: as
633: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
636: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
638: )
639:
640: as
641: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;
830: , x_msg_count out nocopy NUMBER
831: , x_msg_data out nocopy VARCHAR2
832: , p5_a0 NUMBER := 0-1962.0724
833: , p5_a1 NUMBER := 0-1962.0724
834: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
838: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
831: , x_msg_data out nocopy VARCHAR2
832: , p5_a0 NUMBER := 0-1962.0724
833: , p5_a1 NUMBER := 0-1962.0724
834: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
838: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
839: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
832: , p5_a0 NUMBER := 0-1962.0724
833: , p5_a1 NUMBER := 0-1962.0724
834: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
838: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
839: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
840: , p5_a8 NUMBER := 0-1962.0724
833: , p5_a1 NUMBER := 0-1962.0724
834: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
838: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
839: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
840: , p5_a8 NUMBER := 0-1962.0724
841: , p5_a9 NUMBER := 0-1962.0724
834: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
838: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
839: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
840: , p5_a8 NUMBER := 0-1962.0724
841: , p5_a9 NUMBER := 0-1962.0724
842: , p5_a10 DATE := fnd_api.g_miss_date
835: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
838: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
839: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
840: , p5_a8 NUMBER := 0-1962.0724
841: , p5_a9 NUMBER := 0-1962.0724
842: , p5_a10 DATE := fnd_api.g_miss_date
843: , p5_a11 NUMBER := 0-1962.0724
838: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
839: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
840: , p5_a8 NUMBER := 0-1962.0724
841: , p5_a9 NUMBER := 0-1962.0724
842: , p5_a10 DATE := fnd_api.g_miss_date
843: , p5_a11 NUMBER := 0-1962.0724
844: , p5_a12 DATE := fnd_api.g_miss_date
845: , p5_a13 NUMBER := 0-1962.0724
846: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
840: , p5_a8 NUMBER := 0-1962.0724
841: , p5_a9 NUMBER := 0-1962.0724
842: , p5_a10 DATE := fnd_api.g_miss_date
843: , p5_a11 NUMBER := 0-1962.0724
844: , p5_a12 DATE := fnd_api.g_miss_date
845: , p5_a13 NUMBER := 0-1962.0724
846: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
847: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
848: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
842: , p5_a10 DATE := fnd_api.g_miss_date
843: , p5_a11 NUMBER := 0-1962.0724
844: , p5_a12 DATE := fnd_api.g_miss_date
845: , p5_a13 NUMBER := 0-1962.0724
846: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
847: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
848: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
843: , p5_a11 NUMBER := 0-1962.0724
844: , p5_a12 DATE := fnd_api.g_miss_date
845: , p5_a13 NUMBER := 0-1962.0724
846: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
847: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
848: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
851: )
844: , p5_a12 DATE := fnd_api.g_miss_date
845: , p5_a13 NUMBER := 0-1962.0724
846: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
847: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
848: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
851: )
852:
845: , p5_a13 NUMBER := 0-1962.0724
846: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
847: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
848: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
851: )
852:
853: as
846: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
847: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
848: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
851: )
852:
853: as
854: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;