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;
324: , p5_a0 NUMBER := 0-1962.0724
325: , p5_a1 NUMBER := 0-1962.0724
326: , p5_a2 NUMBER := 0-1962.0724
327: , p5_a3 NUMBER := 0-1962.0724
328: , p5_a4 DATE := fnd_api.g_miss_date
329: , p5_a5 DATE := fnd_api.g_miss_date
330: , p5_a6 NUMBER := 0-1962.0724
331: , p5_a7 NUMBER := 0-1962.0724
332: , p5_a8 NUMBER := 0-1962.0724
325: , p5_a1 NUMBER := 0-1962.0724
326: , p5_a2 NUMBER := 0-1962.0724
327: , p5_a3 NUMBER := 0-1962.0724
328: , p5_a4 DATE := fnd_api.g_miss_date
329: , p5_a5 DATE := fnd_api.g_miss_date
330: , p5_a6 NUMBER := 0-1962.0724
331: , p5_a7 NUMBER := 0-1962.0724
332: , p5_a8 NUMBER := 0-1962.0724
333: , p5_a9 DATE := fnd_api.g_miss_date
329: , p5_a5 DATE := fnd_api.g_miss_date
330: , p5_a6 NUMBER := 0-1962.0724
331: , p5_a7 NUMBER := 0-1962.0724
332: , p5_a8 NUMBER := 0-1962.0724
333: , p5_a9 DATE := fnd_api.g_miss_date
334: , p5_a10 NUMBER := 0-1962.0724
335: , p5_a11 DATE := fnd_api.g_miss_date
336: , p5_a12 NUMBER := 0-1962.0724
337: , p5_a13 DATE := fnd_api.g_miss_date
331: , p5_a7 NUMBER := 0-1962.0724
332: , p5_a8 NUMBER := 0-1962.0724
333: , p5_a9 DATE := fnd_api.g_miss_date
334: , p5_a10 NUMBER := 0-1962.0724
335: , p5_a11 DATE := fnd_api.g_miss_date
336: , p5_a12 NUMBER := 0-1962.0724
337: , p5_a13 DATE := fnd_api.g_miss_date
338: , p5_a14 NUMBER := 0-1962.0724
339: )
333: , p5_a9 DATE := fnd_api.g_miss_date
334: , p5_a10 NUMBER := 0-1962.0724
335: , p5_a11 DATE := fnd_api.g_miss_date
336: , p5_a12 NUMBER := 0-1962.0724
337: , p5_a13 DATE := fnd_api.g_miss_date
338: , p5_a14 NUMBER := 0-1962.0724
339: )
340:
341: as
509: , p5_a0 NUMBER := 0-1962.0724
510: , p5_a1 NUMBER := 0-1962.0724
511: , p5_a2 NUMBER := 0-1962.0724
512: , p5_a3 NUMBER := 0-1962.0724
513: , p5_a4 DATE := fnd_api.g_miss_date
514: , p5_a5 DATE := fnd_api.g_miss_date
515: , p5_a6 NUMBER := 0-1962.0724
516: , p5_a7 NUMBER := 0-1962.0724
517: , p5_a8 NUMBER := 0-1962.0724
510: , p5_a1 NUMBER := 0-1962.0724
511: , p5_a2 NUMBER := 0-1962.0724
512: , p5_a3 NUMBER := 0-1962.0724
513: , p5_a4 DATE := fnd_api.g_miss_date
514: , p5_a5 DATE := fnd_api.g_miss_date
515: , p5_a6 NUMBER := 0-1962.0724
516: , p5_a7 NUMBER := 0-1962.0724
517: , p5_a8 NUMBER := 0-1962.0724
518: , p5_a9 DATE := fnd_api.g_miss_date
514: , p5_a5 DATE := fnd_api.g_miss_date
515: , p5_a6 NUMBER := 0-1962.0724
516: , p5_a7 NUMBER := 0-1962.0724
517: , p5_a8 NUMBER := 0-1962.0724
518: , p5_a9 DATE := fnd_api.g_miss_date
519: , p5_a10 NUMBER := 0-1962.0724
520: , p5_a11 DATE := fnd_api.g_miss_date
521: , p5_a12 NUMBER := 0-1962.0724
522: , p5_a13 DATE := fnd_api.g_miss_date
516: , p5_a7 NUMBER := 0-1962.0724
517: , p5_a8 NUMBER := 0-1962.0724
518: , p5_a9 DATE := fnd_api.g_miss_date
519: , p5_a10 NUMBER := 0-1962.0724
520: , p5_a11 DATE := fnd_api.g_miss_date
521: , p5_a12 NUMBER := 0-1962.0724
522: , p5_a13 DATE := fnd_api.g_miss_date
523: , p5_a14 NUMBER := 0-1962.0724
524: )
518: , p5_a9 DATE := fnd_api.g_miss_date
519: , p5_a10 NUMBER := 0-1962.0724
520: , p5_a11 DATE := fnd_api.g_miss_date
521: , p5_a12 NUMBER := 0-1962.0724
522: , p5_a13 DATE := fnd_api.g_miss_date
523: , p5_a14 NUMBER := 0-1962.0724
524: )
525:
526: as
655: , p5_a0 NUMBER := 0-1962.0724
656: , p5_a1 NUMBER := 0-1962.0724
657: , p5_a2 NUMBER := 0-1962.0724
658: , p5_a3 NUMBER := 0-1962.0724
659: , p5_a4 DATE := fnd_api.g_miss_date
660: , p5_a5 DATE := fnd_api.g_miss_date
661: , p5_a6 NUMBER := 0-1962.0724
662: , p5_a7 NUMBER := 0-1962.0724
663: , p5_a8 NUMBER := 0-1962.0724
656: , p5_a1 NUMBER := 0-1962.0724
657: , p5_a2 NUMBER := 0-1962.0724
658: , p5_a3 NUMBER := 0-1962.0724
659: , p5_a4 DATE := fnd_api.g_miss_date
660: , p5_a5 DATE := fnd_api.g_miss_date
661: , p5_a6 NUMBER := 0-1962.0724
662: , p5_a7 NUMBER := 0-1962.0724
663: , p5_a8 NUMBER := 0-1962.0724
664: , p5_a9 DATE := fnd_api.g_miss_date
660: , p5_a5 DATE := fnd_api.g_miss_date
661: , p5_a6 NUMBER := 0-1962.0724
662: , p5_a7 NUMBER := 0-1962.0724
663: , p5_a8 NUMBER := 0-1962.0724
664: , p5_a9 DATE := fnd_api.g_miss_date
665: , p5_a10 NUMBER := 0-1962.0724
666: , p5_a11 DATE := fnd_api.g_miss_date
667: , p5_a12 NUMBER := 0-1962.0724
668: , p5_a13 DATE := fnd_api.g_miss_date
662: , p5_a7 NUMBER := 0-1962.0724
663: , p5_a8 NUMBER := 0-1962.0724
664: , p5_a9 DATE := fnd_api.g_miss_date
665: , p5_a10 NUMBER := 0-1962.0724
666: , p5_a11 DATE := fnd_api.g_miss_date
667: , p5_a12 NUMBER := 0-1962.0724
668: , p5_a13 DATE := fnd_api.g_miss_date
669: , p5_a14 NUMBER := 0-1962.0724
670: )
664: , p5_a9 DATE := fnd_api.g_miss_date
665: , p5_a10 NUMBER := 0-1962.0724
666: , p5_a11 DATE := fnd_api.g_miss_date
667: , p5_a12 NUMBER := 0-1962.0724
668: , p5_a13 DATE := fnd_api.g_miss_date
669: , p5_a14 NUMBER := 0-1962.0724
670: )
671:
672: as
840: , p5_a0 NUMBER := 0-1962.0724
841: , p5_a1 NUMBER := 0-1962.0724
842: , p5_a2 NUMBER := 0-1962.0724
843: , p5_a3 NUMBER := 0-1962.0724
844: , p5_a4 DATE := fnd_api.g_miss_date
845: , p5_a5 DATE := fnd_api.g_miss_date
846: , p5_a6 NUMBER := 0-1962.0724
847: , p5_a7 NUMBER := 0-1962.0724
848: , p5_a8 NUMBER := 0-1962.0724
841: , p5_a1 NUMBER := 0-1962.0724
842: , p5_a2 NUMBER := 0-1962.0724
843: , p5_a3 NUMBER := 0-1962.0724
844: , p5_a4 DATE := fnd_api.g_miss_date
845: , p5_a5 DATE := fnd_api.g_miss_date
846: , p5_a6 NUMBER := 0-1962.0724
847: , p5_a7 NUMBER := 0-1962.0724
848: , p5_a8 NUMBER := 0-1962.0724
849: , p5_a9 DATE := fnd_api.g_miss_date
845: , p5_a5 DATE := fnd_api.g_miss_date
846: , p5_a6 NUMBER := 0-1962.0724
847: , p5_a7 NUMBER := 0-1962.0724
848: , p5_a8 NUMBER := 0-1962.0724
849: , p5_a9 DATE := fnd_api.g_miss_date
850: , p5_a10 NUMBER := 0-1962.0724
851: , p5_a11 DATE := fnd_api.g_miss_date
852: , p5_a12 NUMBER := 0-1962.0724
853: , p5_a13 DATE := fnd_api.g_miss_date
847: , p5_a7 NUMBER := 0-1962.0724
848: , p5_a8 NUMBER := 0-1962.0724
849: , p5_a9 DATE := fnd_api.g_miss_date
850: , p5_a10 NUMBER := 0-1962.0724
851: , p5_a11 DATE := fnd_api.g_miss_date
852: , p5_a12 NUMBER := 0-1962.0724
853: , p5_a13 DATE := fnd_api.g_miss_date
854: , p5_a14 NUMBER := 0-1962.0724
855: )
849: , p5_a9 DATE := fnd_api.g_miss_date
850: , p5_a10 NUMBER := 0-1962.0724
851: , p5_a11 DATE := fnd_api.g_miss_date
852: , p5_a12 NUMBER := 0-1962.0724
853: , p5_a13 DATE := fnd_api.g_miss_date
854: , p5_a14 NUMBER := 0-1962.0724
855: )
856:
857: as
971: , p5_a0 NUMBER := 0-1962.0724
972: , p5_a1 NUMBER := 0-1962.0724
973: , p5_a2 NUMBER := 0-1962.0724
974: , p5_a3 NUMBER := 0-1962.0724
975: , p5_a4 DATE := fnd_api.g_miss_date
976: , p5_a5 DATE := fnd_api.g_miss_date
977: , p5_a6 NUMBER := 0-1962.0724
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
972: , p5_a1 NUMBER := 0-1962.0724
973: , p5_a2 NUMBER := 0-1962.0724
974: , p5_a3 NUMBER := 0-1962.0724
975: , p5_a4 DATE := fnd_api.g_miss_date
976: , p5_a5 DATE := fnd_api.g_miss_date
977: , p5_a6 NUMBER := 0-1962.0724
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 DATE := fnd_api.g_miss_date
976: , p5_a5 DATE := fnd_api.g_miss_date
977: , p5_a6 NUMBER := 0-1962.0724
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 DATE := fnd_api.g_miss_date
981: , p5_a10 NUMBER := 0-1962.0724
982: , p5_a11 DATE := fnd_api.g_miss_date
983: , p5_a12 NUMBER := 0-1962.0724
984: , p5_a13 DATE := fnd_api.g_miss_date
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 DATE := fnd_api.g_miss_date
981: , p5_a10 NUMBER := 0-1962.0724
982: , p5_a11 DATE := fnd_api.g_miss_date
983: , p5_a12 NUMBER := 0-1962.0724
984: , p5_a13 DATE := fnd_api.g_miss_date
985: , p5_a14 NUMBER := 0-1962.0724
986: )
980: , p5_a9 DATE := fnd_api.g_miss_date
981: , p5_a10 NUMBER := 0-1962.0724
982: , p5_a11 DATE := fnd_api.g_miss_date
983: , p5_a12 NUMBER := 0-1962.0724
984: , p5_a13 DATE := fnd_api.g_miss_date
985: , p5_a14 NUMBER := 0-1962.0724
986: )
987:
988: as