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;
295: , p5_a1 NUMBER := 0-1962.0724
296: , p5_a2 NUMBER := 0-1962.0724
297: , p5_a3 NUMBER := 0-1962.0724
298: , p5_a4 NUMBER := 0-1962.0724
299: , p5_a5 DATE := fnd_api.g_miss_date
300: , p5_a6 DATE := fnd_api.g_miss_date
301: , p5_a7 NUMBER := 0-1962.0724
302: , p5_a8 NUMBER := 0-1962.0724
303: , p5_a9 DATE := fnd_api.g_miss_date
296: , p5_a2 NUMBER := 0-1962.0724
297: , p5_a3 NUMBER := 0-1962.0724
298: , p5_a4 NUMBER := 0-1962.0724
299: , p5_a5 DATE := fnd_api.g_miss_date
300: , p5_a6 DATE := fnd_api.g_miss_date
301: , p5_a7 NUMBER := 0-1962.0724
302: , p5_a8 NUMBER := 0-1962.0724
303: , p5_a9 DATE := fnd_api.g_miss_date
304: , p5_a10 NUMBER := 0-1962.0724
299: , p5_a5 DATE := fnd_api.g_miss_date
300: , p5_a6 DATE := fnd_api.g_miss_date
301: , p5_a7 NUMBER := 0-1962.0724
302: , p5_a8 NUMBER := 0-1962.0724
303: , p5_a9 DATE := fnd_api.g_miss_date
304: , p5_a10 NUMBER := 0-1962.0724
305: , p5_a11 DATE := fnd_api.g_miss_date
306: , p5_a12 NUMBER := 0-1962.0724
307: )
301: , p5_a7 NUMBER := 0-1962.0724
302: , p5_a8 NUMBER := 0-1962.0724
303: , p5_a9 DATE := fnd_api.g_miss_date
304: , p5_a10 NUMBER := 0-1962.0724
305: , p5_a11 DATE := fnd_api.g_miss_date
306: , p5_a12 NUMBER := 0-1962.0724
307: )
308:
309: as
466: , p5_a1 NUMBER := 0-1962.0724
467: , p5_a2 NUMBER := 0-1962.0724
468: , p5_a3 NUMBER := 0-1962.0724
469: , p5_a4 NUMBER := 0-1962.0724
470: , p5_a5 DATE := fnd_api.g_miss_date
471: , p5_a6 DATE := fnd_api.g_miss_date
472: , p5_a7 NUMBER := 0-1962.0724
473: , p5_a8 NUMBER := 0-1962.0724
474: , p5_a9 DATE := fnd_api.g_miss_date
467: , p5_a2 NUMBER := 0-1962.0724
468: , p5_a3 NUMBER := 0-1962.0724
469: , p5_a4 NUMBER := 0-1962.0724
470: , p5_a5 DATE := fnd_api.g_miss_date
471: , p5_a6 DATE := fnd_api.g_miss_date
472: , p5_a7 NUMBER := 0-1962.0724
473: , p5_a8 NUMBER := 0-1962.0724
474: , p5_a9 DATE := fnd_api.g_miss_date
475: , p5_a10 NUMBER := 0-1962.0724
470: , p5_a5 DATE := fnd_api.g_miss_date
471: , p5_a6 DATE := fnd_api.g_miss_date
472: , p5_a7 NUMBER := 0-1962.0724
473: , p5_a8 NUMBER := 0-1962.0724
474: , p5_a9 DATE := fnd_api.g_miss_date
475: , p5_a10 NUMBER := 0-1962.0724
476: , p5_a11 DATE := fnd_api.g_miss_date
477: , p5_a12 NUMBER := 0-1962.0724
478: )
472: , p5_a7 NUMBER := 0-1962.0724
473: , p5_a8 NUMBER := 0-1962.0724
474: , p5_a9 DATE := fnd_api.g_miss_date
475: , p5_a10 NUMBER := 0-1962.0724
476: , p5_a11 DATE := fnd_api.g_miss_date
477: , p5_a12 NUMBER := 0-1962.0724
478: )
479:
480: as
602: , p5_a1 NUMBER := 0-1962.0724
603: , p5_a2 NUMBER := 0-1962.0724
604: , p5_a3 NUMBER := 0-1962.0724
605: , p5_a4 NUMBER := 0-1962.0724
606: , p5_a5 DATE := fnd_api.g_miss_date
607: , p5_a6 DATE := fnd_api.g_miss_date
608: , p5_a7 NUMBER := 0-1962.0724
609: , p5_a8 NUMBER := 0-1962.0724
610: , p5_a9 DATE := fnd_api.g_miss_date
603: , p5_a2 NUMBER := 0-1962.0724
604: , p5_a3 NUMBER := 0-1962.0724
605: , p5_a4 NUMBER := 0-1962.0724
606: , p5_a5 DATE := fnd_api.g_miss_date
607: , p5_a6 DATE := fnd_api.g_miss_date
608: , p5_a7 NUMBER := 0-1962.0724
609: , p5_a8 NUMBER := 0-1962.0724
610: , p5_a9 DATE := fnd_api.g_miss_date
611: , p5_a10 NUMBER := 0-1962.0724
606: , p5_a5 DATE := fnd_api.g_miss_date
607: , p5_a6 DATE := fnd_api.g_miss_date
608: , p5_a7 NUMBER := 0-1962.0724
609: , p5_a8 NUMBER := 0-1962.0724
610: , p5_a9 DATE := fnd_api.g_miss_date
611: , p5_a10 NUMBER := 0-1962.0724
612: , p5_a11 DATE := fnd_api.g_miss_date
613: , p5_a12 NUMBER := 0-1962.0724
614: )
608: , p5_a7 NUMBER := 0-1962.0724
609: , p5_a8 NUMBER := 0-1962.0724
610: , p5_a9 DATE := fnd_api.g_miss_date
611: , p5_a10 NUMBER := 0-1962.0724
612: , p5_a11 DATE := fnd_api.g_miss_date
613: , p5_a12 NUMBER := 0-1962.0724
614: )
615:
616: as
773: , p5_a1 NUMBER := 0-1962.0724
774: , p5_a2 NUMBER := 0-1962.0724
775: , p5_a3 NUMBER := 0-1962.0724
776: , p5_a4 NUMBER := 0-1962.0724
777: , p5_a5 DATE := fnd_api.g_miss_date
778: , p5_a6 DATE := fnd_api.g_miss_date
779: , p5_a7 NUMBER := 0-1962.0724
780: , p5_a8 NUMBER := 0-1962.0724
781: , p5_a9 DATE := fnd_api.g_miss_date
774: , p5_a2 NUMBER := 0-1962.0724
775: , p5_a3 NUMBER := 0-1962.0724
776: , p5_a4 NUMBER := 0-1962.0724
777: , p5_a5 DATE := fnd_api.g_miss_date
778: , p5_a6 DATE := fnd_api.g_miss_date
779: , p5_a7 NUMBER := 0-1962.0724
780: , p5_a8 NUMBER := 0-1962.0724
781: , p5_a9 DATE := fnd_api.g_miss_date
782: , p5_a10 NUMBER := 0-1962.0724
777: , p5_a5 DATE := fnd_api.g_miss_date
778: , p5_a6 DATE := fnd_api.g_miss_date
779: , p5_a7 NUMBER := 0-1962.0724
780: , p5_a8 NUMBER := 0-1962.0724
781: , p5_a9 DATE := fnd_api.g_miss_date
782: , p5_a10 NUMBER := 0-1962.0724
783: , p5_a11 DATE := fnd_api.g_miss_date
784: , p5_a12 NUMBER := 0-1962.0724
785: )
779: , p5_a7 NUMBER := 0-1962.0724
780: , p5_a8 NUMBER := 0-1962.0724
781: , p5_a9 DATE := fnd_api.g_miss_date
782: , p5_a10 NUMBER := 0-1962.0724
783: , p5_a11 DATE := fnd_api.g_miss_date
784: , p5_a12 NUMBER := 0-1962.0724
785: )
786:
787: as
896: , p5_a1 NUMBER := 0-1962.0724
897: , p5_a2 NUMBER := 0-1962.0724
898: , p5_a3 NUMBER := 0-1962.0724
899: , p5_a4 NUMBER := 0-1962.0724
900: , p5_a5 DATE := fnd_api.g_miss_date
901: , p5_a6 DATE := fnd_api.g_miss_date
902: , p5_a7 NUMBER := 0-1962.0724
903: , p5_a8 NUMBER := 0-1962.0724
904: , p5_a9 DATE := fnd_api.g_miss_date
897: , p5_a2 NUMBER := 0-1962.0724
898: , p5_a3 NUMBER := 0-1962.0724
899: , p5_a4 NUMBER := 0-1962.0724
900: , p5_a5 DATE := fnd_api.g_miss_date
901: , p5_a6 DATE := fnd_api.g_miss_date
902: , p5_a7 NUMBER := 0-1962.0724
903: , p5_a8 NUMBER := 0-1962.0724
904: , p5_a9 DATE := fnd_api.g_miss_date
905: , p5_a10 NUMBER := 0-1962.0724
900: , p5_a5 DATE := fnd_api.g_miss_date
901: , p5_a6 DATE := fnd_api.g_miss_date
902: , p5_a7 NUMBER := 0-1962.0724
903: , p5_a8 NUMBER := 0-1962.0724
904: , p5_a9 DATE := fnd_api.g_miss_date
905: , p5_a10 NUMBER := 0-1962.0724
906: , p5_a11 DATE := fnd_api.g_miss_date
907: , p5_a12 NUMBER := 0-1962.0724
908: )
902: , p5_a7 NUMBER := 0-1962.0724
903: , p5_a8 NUMBER := 0-1962.0724
904: , p5_a9 DATE := fnd_api.g_miss_date
905: , p5_a10 NUMBER := 0-1962.0724
906: , p5_a11 DATE := fnd_api.g_miss_date
907: , p5_a12 NUMBER := 0-1962.0724
908: )
909:
910: as