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;
276: , p6_a9 out nocopy DATE
277: , p6_a10 out nocopy NUMBER
278: , p6_a11 out nocopy NUMBER
279: , p5_a0 NUMBER := 0-1962.0724
280: , p5_a1 DATE := fnd_api.g_miss_date
281: , p5_a2 DATE := fnd_api.g_miss_date
282: , p5_a3 NUMBER := 0-1962.0724
283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a5 NUMBER := 0-1962.0724
277: , p6_a10 out nocopy NUMBER
278: , p6_a11 out nocopy NUMBER
279: , p5_a0 NUMBER := 0-1962.0724
280: , p5_a1 DATE := fnd_api.g_miss_date
281: , p5_a2 DATE := fnd_api.g_miss_date
282: , p5_a3 NUMBER := 0-1962.0724
283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a5 NUMBER := 0-1962.0724
285: , p5_a6 NUMBER := 0-1962.0724
279: , p5_a0 NUMBER := 0-1962.0724
280: , p5_a1 DATE := fnd_api.g_miss_date
281: , p5_a2 DATE := fnd_api.g_miss_date
282: , p5_a3 NUMBER := 0-1962.0724
283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a5 NUMBER := 0-1962.0724
285: , p5_a6 NUMBER := 0-1962.0724
286: , p5_a7 NUMBER := 0-1962.0724
287: , p5_a8 DATE := fnd_api.g_miss_date
283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a5 NUMBER := 0-1962.0724
285: , p5_a6 NUMBER := 0-1962.0724
286: , p5_a7 NUMBER := 0-1962.0724
287: , p5_a8 DATE := fnd_api.g_miss_date
288: , p5_a9 DATE := fnd_api.g_miss_date
289: , p5_a10 NUMBER := 0-1962.0724
290: , p5_a11 NUMBER := 0-1962.0724
291: )
284: , p5_a5 NUMBER := 0-1962.0724
285: , p5_a6 NUMBER := 0-1962.0724
286: , p5_a7 NUMBER := 0-1962.0724
287: , p5_a8 DATE := fnd_api.g_miss_date
288: , p5_a9 DATE := fnd_api.g_miss_date
289: , p5_a10 NUMBER := 0-1962.0724
290: , p5_a11 NUMBER := 0-1962.0724
291: )
292:
440: , x_return_status out nocopy VARCHAR2
441: , x_msg_count out nocopy NUMBER
442: , x_msg_data out nocopy VARCHAR2
443: , p5_a0 NUMBER := 0-1962.0724
444: , p5_a1 DATE := fnd_api.g_miss_date
445: , p5_a2 DATE := fnd_api.g_miss_date
446: , p5_a3 NUMBER := 0-1962.0724
447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a5 NUMBER := 0-1962.0724
441: , x_msg_count out nocopy NUMBER
442: , x_msg_data out nocopy VARCHAR2
443: , p5_a0 NUMBER := 0-1962.0724
444: , p5_a1 DATE := fnd_api.g_miss_date
445: , p5_a2 DATE := fnd_api.g_miss_date
446: , p5_a3 NUMBER := 0-1962.0724
447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a5 NUMBER := 0-1962.0724
449: , p5_a6 NUMBER := 0-1962.0724
443: , p5_a0 NUMBER := 0-1962.0724
444: , p5_a1 DATE := fnd_api.g_miss_date
445: , p5_a2 DATE := fnd_api.g_miss_date
446: , p5_a3 NUMBER := 0-1962.0724
447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a5 NUMBER := 0-1962.0724
449: , p5_a6 NUMBER := 0-1962.0724
450: , p5_a7 NUMBER := 0-1962.0724
451: , p5_a8 DATE := fnd_api.g_miss_date
447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a5 NUMBER := 0-1962.0724
449: , p5_a6 NUMBER := 0-1962.0724
450: , p5_a7 NUMBER := 0-1962.0724
451: , p5_a8 DATE := fnd_api.g_miss_date
452: , p5_a9 DATE := fnd_api.g_miss_date
453: , p5_a10 NUMBER := 0-1962.0724
454: , p5_a11 NUMBER := 0-1962.0724
455: )
448: , p5_a5 NUMBER := 0-1962.0724
449: , p5_a6 NUMBER := 0-1962.0724
450: , p5_a7 NUMBER := 0-1962.0724
451: , p5_a8 DATE := fnd_api.g_miss_date
452: , p5_a9 DATE := fnd_api.g_miss_date
453: , p5_a10 NUMBER := 0-1962.0724
454: , p5_a11 NUMBER := 0-1962.0724
455: )
456:
571: , p6_a9 out nocopy DATE
572: , p6_a10 out nocopy NUMBER
573: , p6_a11 out nocopy NUMBER
574: , p5_a0 NUMBER := 0-1962.0724
575: , p5_a1 DATE := fnd_api.g_miss_date
576: , p5_a2 DATE := fnd_api.g_miss_date
577: , p5_a3 NUMBER := 0-1962.0724
578: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a5 NUMBER := 0-1962.0724
572: , p6_a10 out nocopy NUMBER
573: , p6_a11 out nocopy NUMBER
574: , p5_a0 NUMBER := 0-1962.0724
575: , p5_a1 DATE := fnd_api.g_miss_date
576: , p5_a2 DATE := fnd_api.g_miss_date
577: , p5_a3 NUMBER := 0-1962.0724
578: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a5 NUMBER := 0-1962.0724
580: , p5_a6 NUMBER := 0-1962.0724
574: , p5_a0 NUMBER := 0-1962.0724
575: , p5_a1 DATE := fnd_api.g_miss_date
576: , p5_a2 DATE := fnd_api.g_miss_date
577: , p5_a3 NUMBER := 0-1962.0724
578: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a5 NUMBER := 0-1962.0724
580: , p5_a6 NUMBER := 0-1962.0724
581: , p5_a7 NUMBER := 0-1962.0724
582: , p5_a8 DATE := fnd_api.g_miss_date
578: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a5 NUMBER := 0-1962.0724
580: , p5_a6 NUMBER := 0-1962.0724
581: , p5_a7 NUMBER := 0-1962.0724
582: , p5_a8 DATE := fnd_api.g_miss_date
583: , p5_a9 DATE := fnd_api.g_miss_date
584: , p5_a10 NUMBER := 0-1962.0724
585: , p5_a11 NUMBER := 0-1962.0724
586: )
579: , p5_a5 NUMBER := 0-1962.0724
580: , p5_a6 NUMBER := 0-1962.0724
581: , p5_a7 NUMBER := 0-1962.0724
582: , p5_a8 DATE := fnd_api.g_miss_date
583: , p5_a9 DATE := fnd_api.g_miss_date
584: , p5_a10 NUMBER := 0-1962.0724
585: , p5_a11 NUMBER := 0-1962.0724
586: )
587:
735: , x_return_status out nocopy VARCHAR2
736: , x_msg_count out nocopy NUMBER
737: , x_msg_data out nocopy VARCHAR2
738: , p5_a0 NUMBER := 0-1962.0724
739: , p5_a1 DATE := fnd_api.g_miss_date
740: , p5_a2 DATE := fnd_api.g_miss_date
741: , p5_a3 NUMBER := 0-1962.0724
742: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a5 NUMBER := 0-1962.0724
736: , x_msg_count out nocopy NUMBER
737: , x_msg_data out nocopy VARCHAR2
738: , p5_a0 NUMBER := 0-1962.0724
739: , p5_a1 DATE := fnd_api.g_miss_date
740: , p5_a2 DATE := fnd_api.g_miss_date
741: , p5_a3 NUMBER := 0-1962.0724
742: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a5 NUMBER := 0-1962.0724
744: , p5_a6 NUMBER := 0-1962.0724
738: , p5_a0 NUMBER := 0-1962.0724
739: , p5_a1 DATE := fnd_api.g_miss_date
740: , p5_a2 DATE := fnd_api.g_miss_date
741: , p5_a3 NUMBER := 0-1962.0724
742: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a5 NUMBER := 0-1962.0724
744: , p5_a6 NUMBER := 0-1962.0724
745: , p5_a7 NUMBER := 0-1962.0724
746: , p5_a8 DATE := fnd_api.g_miss_date
742: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a5 NUMBER := 0-1962.0724
744: , p5_a6 NUMBER := 0-1962.0724
745: , p5_a7 NUMBER := 0-1962.0724
746: , p5_a8 DATE := fnd_api.g_miss_date
747: , p5_a9 DATE := fnd_api.g_miss_date
748: , p5_a10 NUMBER := 0-1962.0724
749: , p5_a11 NUMBER := 0-1962.0724
750: )
743: , p5_a5 NUMBER := 0-1962.0724
744: , p5_a6 NUMBER := 0-1962.0724
745: , p5_a7 NUMBER := 0-1962.0724
746: , p5_a8 DATE := fnd_api.g_miss_date
747: , p5_a9 DATE := fnd_api.g_miss_date
748: , p5_a10 NUMBER := 0-1962.0724
749: , p5_a11 NUMBER := 0-1962.0724
750: )
751:
854: , x_return_status out nocopy VARCHAR2
855: , x_msg_count out nocopy NUMBER
856: , x_msg_data out nocopy VARCHAR2
857: , p5_a0 NUMBER := 0-1962.0724
858: , p5_a1 DATE := fnd_api.g_miss_date
859: , p5_a2 DATE := fnd_api.g_miss_date
860: , p5_a3 NUMBER := 0-1962.0724
861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a5 NUMBER := 0-1962.0724
855: , x_msg_count out nocopy NUMBER
856: , x_msg_data out nocopy VARCHAR2
857: , p5_a0 NUMBER := 0-1962.0724
858: , p5_a1 DATE := fnd_api.g_miss_date
859: , p5_a2 DATE := fnd_api.g_miss_date
860: , p5_a3 NUMBER := 0-1962.0724
861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
857: , p5_a0 NUMBER := 0-1962.0724
858: , p5_a1 DATE := fnd_api.g_miss_date
859: , p5_a2 DATE := fnd_api.g_miss_date
860: , p5_a3 NUMBER := 0-1962.0724
861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
864: , p5_a7 NUMBER := 0-1962.0724
865: , p5_a8 DATE := fnd_api.g_miss_date
861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
864: , p5_a7 NUMBER := 0-1962.0724
865: , p5_a8 DATE := fnd_api.g_miss_date
866: , p5_a9 DATE := fnd_api.g_miss_date
867: , p5_a10 NUMBER := 0-1962.0724
868: , p5_a11 NUMBER := 0-1962.0724
869: )
862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
864: , p5_a7 NUMBER := 0-1962.0724
865: , p5_a8 DATE := fnd_api.g_miss_date
866: , p5_a9 DATE := fnd_api.g_miss_date
867: , p5_a10 NUMBER := 0-1962.0724
868: , p5_a11 NUMBER := 0-1962.0724
869: )
870: