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;
120: , p6_a8 out nocopy NUMBER
121: , p6_a9 out nocopy DATE
122: , p6_a10 out nocopy NUMBER
123: , p5_a0 NUMBER := 0-1962.0724
124: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a2 NUMBER := 0-1962.0724
126: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a4 NUMBER := 0-1962.0724
128: , p5_a5 NUMBER := 0-1962.0724
122: , p6_a10 out nocopy NUMBER
123: , p5_a0 NUMBER := 0-1962.0724
124: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a2 NUMBER := 0-1962.0724
126: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a4 NUMBER := 0-1962.0724
128: , p5_a5 NUMBER := 0-1962.0724
129: , p5_a6 NUMBER := 0-1962.0724
130: , p5_a7 DATE := fnd_api.g_miss_date
126: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a4 NUMBER := 0-1962.0724
128: , p5_a5 NUMBER := 0-1962.0724
129: , p5_a6 NUMBER := 0-1962.0724
130: , p5_a7 DATE := fnd_api.g_miss_date
131: , p5_a8 NUMBER := 0-1962.0724
132: , p5_a9 DATE := fnd_api.g_miss_date
133: , p5_a10 NUMBER := 0-1962.0724
134: )
128: , p5_a5 NUMBER := 0-1962.0724
129: , p5_a6 NUMBER := 0-1962.0724
130: , p5_a7 DATE := fnd_api.g_miss_date
131: , p5_a8 NUMBER := 0-1962.0724
132: , p5_a9 DATE := fnd_api.g_miss_date
133: , p5_a10 NUMBER := 0-1962.0724
134: )
135:
136: as
250: , x_return_status out nocopy VARCHAR2
251: , x_msg_count out nocopy NUMBER
252: , x_msg_data out nocopy VARCHAR2
253: , p5_a0 NUMBER := 0-1962.0724
254: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a2 NUMBER := 0-1962.0724
256: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a4 NUMBER := 0-1962.0724
258: , p5_a5 NUMBER := 0-1962.0724
252: , x_msg_data out nocopy VARCHAR2
253: , p5_a0 NUMBER := 0-1962.0724
254: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a2 NUMBER := 0-1962.0724
256: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a4 NUMBER := 0-1962.0724
258: , p5_a5 NUMBER := 0-1962.0724
259: , p5_a6 NUMBER := 0-1962.0724
260: , p5_a7 DATE := fnd_api.g_miss_date
256: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a4 NUMBER := 0-1962.0724
258: , p5_a5 NUMBER := 0-1962.0724
259: , p5_a6 NUMBER := 0-1962.0724
260: , p5_a7 DATE := fnd_api.g_miss_date
261: , p5_a8 NUMBER := 0-1962.0724
262: , p5_a9 DATE := fnd_api.g_miss_date
263: , p5_a10 NUMBER := 0-1962.0724
264: )
258: , p5_a5 NUMBER := 0-1962.0724
259: , p5_a6 NUMBER := 0-1962.0724
260: , p5_a7 DATE := fnd_api.g_miss_date
261: , p5_a8 NUMBER := 0-1962.0724
262: , p5_a9 DATE := fnd_api.g_miss_date
263: , p5_a10 NUMBER := 0-1962.0724
264: )
265:
266: as
403: , p6_a8 out nocopy NUMBER
404: , p6_a9 out nocopy DATE
405: , p6_a10 out nocopy NUMBER
406: , p5_a0 NUMBER := 0-1962.0724
407: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a2 NUMBER := 0-1962.0724
409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a4 NUMBER := 0-1962.0724
411: , p5_a5 NUMBER := 0-1962.0724
405: , p6_a10 out nocopy NUMBER
406: , p5_a0 NUMBER := 0-1962.0724
407: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a2 NUMBER := 0-1962.0724
409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a4 NUMBER := 0-1962.0724
411: , p5_a5 NUMBER := 0-1962.0724
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date
409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a4 NUMBER := 0-1962.0724
411: , p5_a5 NUMBER := 0-1962.0724
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date
414: , p5_a8 NUMBER := 0-1962.0724
415: , p5_a9 DATE := fnd_api.g_miss_date
416: , p5_a10 NUMBER := 0-1962.0724
417: )
411: , p5_a5 NUMBER := 0-1962.0724
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date
414: , p5_a8 NUMBER := 0-1962.0724
415: , p5_a9 DATE := fnd_api.g_miss_date
416: , p5_a10 NUMBER := 0-1962.0724
417: )
418:
419: as
533: , x_return_status out nocopy VARCHAR2
534: , x_msg_count out nocopy NUMBER
535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 NUMBER := 0-1962.0724
537: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a2 NUMBER := 0-1962.0724
539: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a4 NUMBER := 0-1962.0724
541: , p5_a5 NUMBER := 0-1962.0724
535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 NUMBER := 0-1962.0724
537: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a2 NUMBER := 0-1962.0724
539: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a4 NUMBER := 0-1962.0724
541: , p5_a5 NUMBER := 0-1962.0724
542: , p5_a6 NUMBER := 0-1962.0724
543: , p5_a7 DATE := fnd_api.g_miss_date
539: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a4 NUMBER := 0-1962.0724
541: , p5_a5 NUMBER := 0-1962.0724
542: , p5_a6 NUMBER := 0-1962.0724
543: , p5_a7 DATE := fnd_api.g_miss_date
544: , p5_a8 NUMBER := 0-1962.0724
545: , p5_a9 DATE := fnd_api.g_miss_date
546: , p5_a10 NUMBER := 0-1962.0724
547: )
541: , p5_a5 NUMBER := 0-1962.0724
542: , p5_a6 NUMBER := 0-1962.0724
543: , p5_a7 DATE := fnd_api.g_miss_date
544: , p5_a8 NUMBER := 0-1962.0724
545: , p5_a9 DATE := fnd_api.g_miss_date
546: , p5_a10 NUMBER := 0-1962.0724
547: )
548:
549: as
648: , x_return_status out nocopy VARCHAR2
649: , x_msg_count out nocopy NUMBER
650: , x_msg_data out nocopy VARCHAR2
651: , p5_a0 NUMBER := 0-1962.0724
652: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a2 NUMBER := 0-1962.0724
654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a4 NUMBER := 0-1962.0724
656: , p5_a5 NUMBER := 0-1962.0724
650: , x_msg_data out nocopy VARCHAR2
651: , p5_a0 NUMBER := 0-1962.0724
652: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a2 NUMBER := 0-1962.0724
654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a4 NUMBER := 0-1962.0724
656: , p5_a5 NUMBER := 0-1962.0724
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date
654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a4 NUMBER := 0-1962.0724
656: , p5_a5 NUMBER := 0-1962.0724
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date
659: , p5_a8 NUMBER := 0-1962.0724
660: , p5_a9 DATE := fnd_api.g_miss_date
661: , p5_a10 NUMBER := 0-1962.0724
662: )
656: , p5_a5 NUMBER := 0-1962.0724
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date
659: , p5_a8 NUMBER := 0-1962.0724
660: , p5_a9 DATE := fnd_api.g_miss_date
661: , p5_a10 NUMBER := 0-1962.0724
662: )
663:
664: as