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;
43: , p6_a16 out nocopy NUMBER
44: , p5_a0 NUMBER := 0-1962.0724
45: , p5_a1 NUMBER := 0-1962.0724
46: , p5_a2 NUMBER := 0-1962.0724
47: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
44: , p5_a0 NUMBER := 0-1962.0724
45: , p5_a1 NUMBER := 0-1962.0724
46: , p5_a2 NUMBER := 0-1962.0724
47: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
59: , p5_a15 DATE := fnd_api.g_miss_date
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
59: , p5_a15 DATE := fnd_api.g_miss_date
60: , p5_a16 NUMBER := 0-1962.0724
61: )
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
59: , p5_a15 DATE := fnd_api.g_miss_date
60: , p5_a16 NUMBER := 0-1962.0724
61: )
62:
63: as
259: , p6_a16 out nocopy NUMBER
260: , p5_a0 NUMBER := 0-1962.0724
261: , p5_a1 NUMBER := 0-1962.0724
262: , p5_a2 NUMBER := 0-1962.0724
263: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
264: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a5 NUMBER := 0-1962.0724
266: , p5_a6 NUMBER := 0-1962.0724
267: , p5_a7 NUMBER := 0-1962.0724
260: , p5_a0 NUMBER := 0-1962.0724
261: , p5_a1 NUMBER := 0-1962.0724
262: , p5_a2 NUMBER := 0-1962.0724
263: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
264: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a5 NUMBER := 0-1962.0724
266: , p5_a6 NUMBER := 0-1962.0724
267: , p5_a7 NUMBER := 0-1962.0724
268: , p5_a8 NUMBER := 0-1962.0724
265: , p5_a5 NUMBER := 0-1962.0724
266: , p5_a6 NUMBER := 0-1962.0724
267: , p5_a7 NUMBER := 0-1962.0724
268: , p5_a8 NUMBER := 0-1962.0724
269: , p5_a9 DATE := fnd_api.g_miss_date
270: , p5_a10 DATE := fnd_api.g_miss_date
271: , p5_a11 DATE := fnd_api.g_miss_date
272: , p5_a12 NUMBER := 0-1962.0724
273: , p5_a13 DATE := fnd_api.g_miss_date
266: , p5_a6 NUMBER := 0-1962.0724
267: , p5_a7 NUMBER := 0-1962.0724
268: , p5_a8 NUMBER := 0-1962.0724
269: , p5_a9 DATE := fnd_api.g_miss_date
270: , p5_a10 DATE := fnd_api.g_miss_date
271: , p5_a11 DATE := fnd_api.g_miss_date
272: , p5_a12 NUMBER := 0-1962.0724
273: , p5_a13 DATE := fnd_api.g_miss_date
274: , p5_a14 NUMBER := 0-1962.0724
267: , p5_a7 NUMBER := 0-1962.0724
268: , p5_a8 NUMBER := 0-1962.0724
269: , p5_a9 DATE := fnd_api.g_miss_date
270: , p5_a10 DATE := fnd_api.g_miss_date
271: , p5_a11 DATE := fnd_api.g_miss_date
272: , p5_a12 NUMBER := 0-1962.0724
273: , p5_a13 DATE := fnd_api.g_miss_date
274: , p5_a14 NUMBER := 0-1962.0724
275: , p5_a15 DATE := fnd_api.g_miss_date
269: , p5_a9 DATE := fnd_api.g_miss_date
270: , p5_a10 DATE := fnd_api.g_miss_date
271: , p5_a11 DATE := fnd_api.g_miss_date
272: , p5_a12 NUMBER := 0-1962.0724
273: , p5_a13 DATE := fnd_api.g_miss_date
274: , p5_a14 NUMBER := 0-1962.0724
275: , p5_a15 DATE := fnd_api.g_miss_date
276: , p5_a16 NUMBER := 0-1962.0724
277: )
271: , p5_a11 DATE := fnd_api.g_miss_date
272: , p5_a12 NUMBER := 0-1962.0724
273: , p5_a13 DATE := fnd_api.g_miss_date
274: , p5_a14 NUMBER := 0-1962.0724
275: , p5_a15 DATE := fnd_api.g_miss_date
276: , p5_a16 NUMBER := 0-1962.0724
277: )
278:
279: as
458: , x_msg_data out nocopy VARCHAR2
459: , p5_a0 NUMBER := 0-1962.0724
460: , p5_a1 NUMBER := 0-1962.0724
461: , p5_a2 NUMBER := 0-1962.0724
462: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a5 NUMBER := 0-1962.0724
465: , p5_a6 NUMBER := 0-1962.0724
466: , p5_a7 NUMBER := 0-1962.0724
459: , p5_a0 NUMBER := 0-1962.0724
460: , p5_a1 NUMBER := 0-1962.0724
461: , p5_a2 NUMBER := 0-1962.0724
462: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a5 NUMBER := 0-1962.0724
465: , p5_a6 NUMBER := 0-1962.0724
466: , p5_a7 NUMBER := 0-1962.0724
467: , p5_a8 NUMBER := 0-1962.0724
464: , p5_a5 NUMBER := 0-1962.0724
465: , p5_a6 NUMBER := 0-1962.0724
466: , p5_a7 NUMBER := 0-1962.0724
467: , p5_a8 NUMBER := 0-1962.0724
468: , p5_a9 DATE := fnd_api.g_miss_date
469: , p5_a10 DATE := fnd_api.g_miss_date
470: , p5_a11 DATE := fnd_api.g_miss_date
471: , p5_a12 NUMBER := 0-1962.0724
472: , p5_a13 DATE := fnd_api.g_miss_date
465: , p5_a6 NUMBER := 0-1962.0724
466: , p5_a7 NUMBER := 0-1962.0724
467: , p5_a8 NUMBER := 0-1962.0724
468: , p5_a9 DATE := fnd_api.g_miss_date
469: , p5_a10 DATE := fnd_api.g_miss_date
470: , p5_a11 DATE := fnd_api.g_miss_date
471: , p5_a12 NUMBER := 0-1962.0724
472: , p5_a13 DATE := fnd_api.g_miss_date
473: , p5_a14 NUMBER := 0-1962.0724
466: , p5_a7 NUMBER := 0-1962.0724
467: , p5_a8 NUMBER := 0-1962.0724
468: , p5_a9 DATE := fnd_api.g_miss_date
469: , p5_a10 DATE := fnd_api.g_miss_date
470: , p5_a11 DATE := fnd_api.g_miss_date
471: , p5_a12 NUMBER := 0-1962.0724
472: , p5_a13 DATE := fnd_api.g_miss_date
473: , p5_a14 NUMBER := 0-1962.0724
474: , p5_a15 DATE := fnd_api.g_miss_date
468: , p5_a9 DATE := fnd_api.g_miss_date
469: , p5_a10 DATE := fnd_api.g_miss_date
470: , p5_a11 DATE := fnd_api.g_miss_date
471: , p5_a12 NUMBER := 0-1962.0724
472: , p5_a13 DATE := fnd_api.g_miss_date
473: , p5_a14 NUMBER := 0-1962.0724
474: , p5_a15 DATE := fnd_api.g_miss_date
475: , p5_a16 NUMBER := 0-1962.0724
476: )
470: , p5_a11 DATE := fnd_api.g_miss_date
471: , p5_a12 NUMBER := 0-1962.0724
472: , p5_a13 DATE := fnd_api.g_miss_date
473: , p5_a14 NUMBER := 0-1962.0724
474: , p5_a15 DATE := fnd_api.g_miss_date
475: , p5_a16 NUMBER := 0-1962.0724
476: )
477:
478: as