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;
59: , p8_a10 out nocopy JTF_NUMBER_TABLE
60: , p5_a0 NUMBER := 0-1962.0724
61: , p5_a1 NUMBER := 0-1962.0724
62: , p5_a2 NUMBER := 0-1962.0724
63: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a4 NUMBER := 0-1962.0724
65: , p5_a5 NUMBER := 0-1962.0724
66: , p5_a6 NUMBER := 0-1962.0724
67: , p5_a7 DATE := fnd_api.g_miss_date
63: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a4 NUMBER := 0-1962.0724
65: , p5_a5 NUMBER := 0-1962.0724
66: , p5_a6 NUMBER := 0-1962.0724
67: , p5_a7 DATE := fnd_api.g_miss_date
68: , p5_a8 NUMBER := 0-1962.0724
69: , p5_a9 DATE := fnd_api.g_miss_date
70: , p5_a10 NUMBER := 0-1962.0724
71: )
65: , p5_a5 NUMBER := 0-1962.0724
66: , p5_a6 NUMBER := 0-1962.0724
67: , p5_a7 DATE := fnd_api.g_miss_date
68: , p5_a8 NUMBER := 0-1962.0724
69: , p5_a9 DATE := fnd_api.g_miss_date
70: , p5_a10 NUMBER := 0-1962.0724
71: )
72:
73: as
196: , p8_a10 out nocopy JTF_NUMBER_TABLE
197: , p5_a0 NUMBER := 0-1962.0724
198: , p5_a1 NUMBER := 0-1962.0724
199: , p5_a2 NUMBER := 0-1962.0724
200: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
201: , p5_a4 NUMBER := 0-1962.0724
202: , p5_a5 NUMBER := 0-1962.0724
203: , p5_a6 NUMBER := 0-1962.0724
204: , p5_a7 DATE := fnd_api.g_miss_date
200: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
201: , p5_a4 NUMBER := 0-1962.0724
202: , p5_a5 NUMBER := 0-1962.0724
203: , p5_a6 NUMBER := 0-1962.0724
204: , p5_a7 DATE := fnd_api.g_miss_date
205: , p5_a8 NUMBER := 0-1962.0724
206: , p5_a9 DATE := fnd_api.g_miss_date
207: , p5_a10 NUMBER := 0-1962.0724
208: )
202: , p5_a5 NUMBER := 0-1962.0724
203: , p5_a6 NUMBER := 0-1962.0724
204: , p5_a7 DATE := fnd_api.g_miss_date
205: , p5_a8 NUMBER := 0-1962.0724
206: , p5_a9 DATE := fnd_api.g_miss_date
207: , p5_a10 NUMBER := 0-1962.0724
208: )
209:
210: as
311: , p6_a10 JTF_NUMBER_TABLE
312: , p5_a0 NUMBER := 0-1962.0724
313: , p5_a1 NUMBER := 0-1962.0724
314: , p5_a2 NUMBER := 0-1962.0724
315: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
316: , p5_a4 NUMBER := 0-1962.0724
317: , p5_a5 NUMBER := 0-1962.0724
318: , p5_a6 NUMBER := 0-1962.0724
319: , p5_a7 DATE := fnd_api.g_miss_date
315: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
316: , p5_a4 NUMBER := 0-1962.0724
317: , p5_a5 NUMBER := 0-1962.0724
318: , p5_a6 NUMBER := 0-1962.0724
319: , p5_a7 DATE := fnd_api.g_miss_date
320: , p5_a8 NUMBER := 0-1962.0724
321: , p5_a9 DATE := fnd_api.g_miss_date
322: , p5_a10 NUMBER := 0-1962.0724
323: )
317: , p5_a5 NUMBER := 0-1962.0724
318: , p5_a6 NUMBER := 0-1962.0724
319: , p5_a7 DATE := fnd_api.g_miss_date
320: , p5_a8 NUMBER := 0-1962.0724
321: , p5_a9 DATE := fnd_api.g_miss_date
322: , p5_a10 NUMBER := 0-1962.0724
323: )
324:
325: as
480: , p6_a10 out nocopy NUMBER
481: , p5_a0 NUMBER := 0-1962.0724
482: , p5_a1 NUMBER := 0-1962.0724
483: , p5_a2 NUMBER := 0-1962.0724
484: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a4 NUMBER := 0-1962.0724
486: , p5_a5 NUMBER := 0-1962.0724
487: , p5_a6 NUMBER := 0-1962.0724
488: , p5_a7 DATE := fnd_api.g_miss_date
484: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a4 NUMBER := 0-1962.0724
486: , p5_a5 NUMBER := 0-1962.0724
487: , p5_a6 NUMBER := 0-1962.0724
488: , p5_a7 DATE := fnd_api.g_miss_date
489: , p5_a8 NUMBER := 0-1962.0724
490: , p5_a9 DATE := fnd_api.g_miss_date
491: , p5_a10 NUMBER := 0-1962.0724
492: )
486: , p5_a5 NUMBER := 0-1962.0724
487: , p5_a6 NUMBER := 0-1962.0724
488: , p5_a7 DATE := fnd_api.g_miss_date
489: , p5_a8 NUMBER := 0-1962.0724
490: , p5_a9 DATE := fnd_api.g_miss_date
491: , p5_a10 NUMBER := 0-1962.0724
492: )
493:
494: as
610: , x_msg_data out nocopy VARCHAR2
611: , p5_a0 NUMBER := 0-1962.0724
612: , p5_a1 NUMBER := 0-1962.0724
613: , p5_a2 NUMBER := 0-1962.0724
614: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a4 NUMBER := 0-1962.0724
616: , p5_a5 NUMBER := 0-1962.0724
617: , p5_a6 NUMBER := 0-1962.0724
618: , p5_a7 DATE := fnd_api.g_miss_date
614: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a4 NUMBER := 0-1962.0724
616: , p5_a5 NUMBER := 0-1962.0724
617: , p5_a6 NUMBER := 0-1962.0724
618: , p5_a7 DATE := fnd_api.g_miss_date
619: , p5_a8 NUMBER := 0-1962.0724
620: , p5_a9 DATE := fnd_api.g_miss_date
621: , p5_a10 NUMBER := 0-1962.0724
622: )
616: , p5_a5 NUMBER := 0-1962.0724
617: , p5_a6 NUMBER := 0-1962.0724
618: , p5_a7 DATE := fnd_api.g_miss_date
619: , p5_a8 NUMBER := 0-1962.0724
620: , p5_a9 DATE := fnd_api.g_miss_date
621: , p5_a10 NUMBER := 0-1962.0724
622: )
623:
624: as
763: , p6_a10 out nocopy NUMBER
764: , p5_a0 NUMBER := 0-1962.0724
765: , p5_a1 NUMBER := 0-1962.0724
766: , p5_a2 NUMBER := 0-1962.0724
767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a4 NUMBER := 0-1962.0724
769: , p5_a5 NUMBER := 0-1962.0724
770: , p5_a6 NUMBER := 0-1962.0724
771: , p5_a7 DATE := fnd_api.g_miss_date
767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a4 NUMBER := 0-1962.0724
769: , p5_a5 NUMBER := 0-1962.0724
770: , p5_a6 NUMBER := 0-1962.0724
771: , p5_a7 DATE := fnd_api.g_miss_date
772: , p5_a8 NUMBER := 0-1962.0724
773: , p5_a9 DATE := fnd_api.g_miss_date
774: , p5_a10 NUMBER := 0-1962.0724
775: )
769: , p5_a5 NUMBER := 0-1962.0724
770: , p5_a6 NUMBER := 0-1962.0724
771: , p5_a7 DATE := fnd_api.g_miss_date
772: , p5_a8 NUMBER := 0-1962.0724
773: , p5_a9 DATE := fnd_api.g_miss_date
774: , p5_a10 NUMBER := 0-1962.0724
775: )
776:
777: as
893: , x_msg_data out nocopy VARCHAR2
894: , p5_a0 NUMBER := 0-1962.0724
895: , p5_a1 NUMBER := 0-1962.0724
896: , p5_a2 NUMBER := 0-1962.0724
897: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a4 NUMBER := 0-1962.0724
899: , p5_a5 NUMBER := 0-1962.0724
900: , p5_a6 NUMBER := 0-1962.0724
901: , p5_a7 DATE := fnd_api.g_miss_date
897: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a4 NUMBER := 0-1962.0724
899: , p5_a5 NUMBER := 0-1962.0724
900: , p5_a6 NUMBER := 0-1962.0724
901: , p5_a7 DATE := fnd_api.g_miss_date
902: , p5_a8 NUMBER := 0-1962.0724
903: , p5_a9 DATE := fnd_api.g_miss_date
904: , p5_a10 NUMBER := 0-1962.0724
905: )
899: , p5_a5 NUMBER := 0-1962.0724
900: , p5_a6 NUMBER := 0-1962.0724
901: , p5_a7 DATE := fnd_api.g_miss_date
902: , p5_a8 NUMBER := 0-1962.0724
903: , p5_a9 DATE := fnd_api.g_miss_date
904: , p5_a10 NUMBER := 0-1962.0724
905: )
906:
907: as
1008: , x_msg_data out nocopy VARCHAR2
1009: , p5_a0 NUMBER := 0-1962.0724
1010: , p5_a1 NUMBER := 0-1962.0724
1011: , p5_a2 NUMBER := 0-1962.0724
1012: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a4 NUMBER := 0-1962.0724
1014: , p5_a5 NUMBER := 0-1962.0724
1015: , p5_a6 NUMBER := 0-1962.0724
1016: , p5_a7 DATE := fnd_api.g_miss_date
1012: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a4 NUMBER := 0-1962.0724
1014: , p5_a5 NUMBER := 0-1962.0724
1015: , p5_a6 NUMBER := 0-1962.0724
1016: , p5_a7 DATE := fnd_api.g_miss_date
1017: , p5_a8 NUMBER := 0-1962.0724
1018: , p5_a9 DATE := fnd_api.g_miss_date
1019: , p5_a10 NUMBER := 0-1962.0724
1020: )
1014: , p5_a5 NUMBER := 0-1962.0724
1015: , p5_a6 NUMBER := 0-1962.0724
1016: , p5_a7 DATE := fnd_api.g_miss_date
1017: , p5_a8 NUMBER := 0-1962.0724
1018: , p5_a9 DATE := fnd_api.g_miss_date
1019: , p5_a10 NUMBER := 0-1962.0724
1020: )
1021:
1022: as
1162: , p5_a0 NUMBER := 0-1962.0724
1163: , p5_a1 NUMBER := 0-1962.0724
1164: , p5_a2 NUMBER := 0-1962.0724
1165: , p5_a3 NUMBER := 0-1962.0724
1166: , p5_a4 DATE := fnd_api.g_miss_date
1167: , p5_a5 NUMBER := 0-1962.0724
1168: , p5_a6 NUMBER := 0-1962.0724
1169: , p5_a7 DATE := fnd_api.g_miss_date
1170: , p5_a8 NUMBER := 0-1962.0724
1165: , p5_a3 NUMBER := 0-1962.0724
1166: , p5_a4 DATE := fnd_api.g_miss_date
1167: , p5_a5 NUMBER := 0-1962.0724
1168: , p5_a6 NUMBER := 0-1962.0724
1169: , p5_a7 DATE := fnd_api.g_miss_date
1170: , p5_a8 NUMBER := 0-1962.0724
1171: , p5_a9 DATE := fnd_api.g_miss_date
1172: , p5_a10 NUMBER := 0-1962.0724
1173: )
1167: , p5_a5 NUMBER := 0-1962.0724
1168: , p5_a6 NUMBER := 0-1962.0724
1169: , p5_a7 DATE := fnd_api.g_miss_date
1170: , p5_a8 NUMBER := 0-1962.0724
1171: , p5_a9 DATE := fnd_api.g_miss_date
1172: , p5_a10 NUMBER := 0-1962.0724
1173: )
1174:
1175: as
1292: , p5_a0 NUMBER := 0-1962.0724
1293: , p5_a1 NUMBER := 0-1962.0724
1294: , p5_a2 NUMBER := 0-1962.0724
1295: , p5_a3 NUMBER := 0-1962.0724
1296: , p5_a4 DATE := fnd_api.g_miss_date
1297: , p5_a5 NUMBER := 0-1962.0724
1298: , p5_a6 NUMBER := 0-1962.0724
1299: , p5_a7 DATE := fnd_api.g_miss_date
1300: , p5_a8 NUMBER := 0-1962.0724
1295: , p5_a3 NUMBER := 0-1962.0724
1296: , p5_a4 DATE := fnd_api.g_miss_date
1297: , p5_a5 NUMBER := 0-1962.0724
1298: , p5_a6 NUMBER := 0-1962.0724
1299: , p5_a7 DATE := fnd_api.g_miss_date
1300: , p5_a8 NUMBER := 0-1962.0724
1301: , p5_a9 DATE := fnd_api.g_miss_date
1302: , p5_a10 NUMBER := 0-1962.0724
1303: )
1297: , p5_a5 NUMBER := 0-1962.0724
1298: , p5_a6 NUMBER := 0-1962.0724
1299: , p5_a7 DATE := fnd_api.g_miss_date
1300: , p5_a8 NUMBER := 0-1962.0724
1301: , p5_a9 DATE := fnd_api.g_miss_date
1302: , p5_a10 NUMBER := 0-1962.0724
1303: )
1304:
1305: as
1445: , p5_a0 NUMBER := 0-1962.0724
1446: , p5_a1 NUMBER := 0-1962.0724
1447: , p5_a2 NUMBER := 0-1962.0724
1448: , p5_a3 NUMBER := 0-1962.0724
1449: , p5_a4 DATE := fnd_api.g_miss_date
1450: , p5_a5 NUMBER := 0-1962.0724
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 DATE := fnd_api.g_miss_date
1453: , p5_a8 NUMBER := 0-1962.0724
1448: , p5_a3 NUMBER := 0-1962.0724
1449: , p5_a4 DATE := fnd_api.g_miss_date
1450: , p5_a5 NUMBER := 0-1962.0724
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 DATE := fnd_api.g_miss_date
1453: , p5_a8 NUMBER := 0-1962.0724
1454: , p5_a9 DATE := fnd_api.g_miss_date
1455: , p5_a10 NUMBER := 0-1962.0724
1456: )
1450: , p5_a5 NUMBER := 0-1962.0724
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 DATE := fnd_api.g_miss_date
1453: , p5_a8 NUMBER := 0-1962.0724
1454: , p5_a9 DATE := fnd_api.g_miss_date
1455: , p5_a10 NUMBER := 0-1962.0724
1456: )
1457:
1458: as
1575: , p5_a0 NUMBER := 0-1962.0724
1576: , p5_a1 NUMBER := 0-1962.0724
1577: , p5_a2 NUMBER := 0-1962.0724
1578: , p5_a3 NUMBER := 0-1962.0724
1579: , p5_a4 DATE := fnd_api.g_miss_date
1580: , p5_a5 NUMBER := 0-1962.0724
1581: , p5_a6 NUMBER := 0-1962.0724
1582: , p5_a7 DATE := fnd_api.g_miss_date
1583: , p5_a8 NUMBER := 0-1962.0724
1578: , p5_a3 NUMBER := 0-1962.0724
1579: , p5_a4 DATE := fnd_api.g_miss_date
1580: , p5_a5 NUMBER := 0-1962.0724
1581: , p5_a6 NUMBER := 0-1962.0724
1582: , p5_a7 DATE := fnd_api.g_miss_date
1583: , p5_a8 NUMBER := 0-1962.0724
1584: , p5_a9 DATE := fnd_api.g_miss_date
1585: , p5_a10 NUMBER := 0-1962.0724
1586: )
1580: , p5_a5 NUMBER := 0-1962.0724
1581: , p5_a6 NUMBER := 0-1962.0724
1582: , p5_a7 DATE := fnd_api.g_miss_date
1583: , p5_a8 NUMBER := 0-1962.0724
1584: , p5_a9 DATE := fnd_api.g_miss_date
1585: , p5_a10 NUMBER := 0-1962.0724
1586: )
1587:
1588: as
1690: , p5_a0 NUMBER := 0-1962.0724
1691: , p5_a1 NUMBER := 0-1962.0724
1692: , p5_a2 NUMBER := 0-1962.0724
1693: , p5_a3 NUMBER := 0-1962.0724
1694: , p5_a4 DATE := fnd_api.g_miss_date
1695: , p5_a5 NUMBER := 0-1962.0724
1696: , p5_a6 NUMBER := 0-1962.0724
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 NUMBER := 0-1962.0724
1693: , p5_a3 NUMBER := 0-1962.0724
1694: , p5_a4 DATE := fnd_api.g_miss_date
1695: , p5_a5 NUMBER := 0-1962.0724
1696: , p5_a6 NUMBER := 0-1962.0724
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 NUMBER := 0-1962.0724
1699: , p5_a9 DATE := fnd_api.g_miss_date
1700: , p5_a10 NUMBER := 0-1962.0724
1701: )
1695: , p5_a5 NUMBER := 0-1962.0724
1696: , p5_a6 NUMBER := 0-1962.0724
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 NUMBER := 0-1962.0724
1699: , p5_a9 DATE := fnd_api.g_miss_date
1700: , p5_a10 NUMBER := 0-1962.0724
1701: )
1702:
1703: as