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;
49: , p3_a25 out nocopy DATE
50: , p3_a26 out nocopy NUMBER
51: , p0_a0 NUMBER := 0-1962.0724
52: , p0_a1 NUMBER := 0-1962.0724
53: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a4 DATE := fnd_api.g_miss_date
56: , p0_a5 DATE := fnd_api.g_miss_date
57: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
50: , p3_a26 out nocopy NUMBER
51: , p0_a0 NUMBER := 0-1962.0724
52: , p0_a1 NUMBER := 0-1962.0724
53: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a4 DATE := fnd_api.g_miss_date
56: , p0_a5 DATE := fnd_api.g_miss_date
57: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
51: , p0_a0 NUMBER := 0-1962.0724
52: , p0_a1 NUMBER := 0-1962.0724
53: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a4 DATE := fnd_api.g_miss_date
56: , p0_a5 DATE := fnd_api.g_miss_date
57: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
52: , p0_a1 NUMBER := 0-1962.0724
53: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a4 DATE := fnd_api.g_miss_date
56: , p0_a5 DATE := fnd_api.g_miss_date
57: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
53: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a4 DATE := fnd_api.g_miss_date
56: , p0_a5 DATE := fnd_api.g_miss_date
57: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
54: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a4 DATE := fnd_api.g_miss_date
56: , p0_a5 DATE := fnd_api.g_miss_date
57: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
55: , p0_a4 DATE := fnd_api.g_miss_date
56: , p0_a5 DATE := fnd_api.g_miss_date
57: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
56: , p0_a5 DATE := fnd_api.g_miss_date
57: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
57: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
58: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
66: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
59: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
66: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
67: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
60: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
66: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
67: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
68: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
61: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
66: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
67: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
68: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
69: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
62: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
66: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
67: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
68: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
69: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
70: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
63: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
66: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
67: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
68: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
69: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
70: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
71: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
64: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
66: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
67: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
68: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
69: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
70: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
71: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
72: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
65: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
66: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
67: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
68: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
69: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
70: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
71: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
72: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
73: , p0_a22 NUMBER := 0-1962.0724
66: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
67: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
68: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
69: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
70: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
71: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
72: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
73: , p0_a22 NUMBER := 0-1962.0724
74: , p0_a23 DATE := fnd_api.g_miss_date
67: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
68: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
69: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
70: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
71: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
72: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
73: , p0_a22 NUMBER := 0-1962.0724
74: , p0_a23 DATE := fnd_api.g_miss_date
75: , p0_a24 NUMBER := 0-1962.0724
68: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
69: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
70: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
71: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
72: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
73: , p0_a22 NUMBER := 0-1962.0724
74: , p0_a23 DATE := fnd_api.g_miss_date
75: , p0_a24 NUMBER := 0-1962.0724
76: , p0_a25 DATE := fnd_api.g_miss_date
70: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
71: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
72: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
73: , p0_a22 NUMBER := 0-1962.0724
74: , p0_a23 DATE := fnd_api.g_miss_date
75: , p0_a24 NUMBER := 0-1962.0724
76: , p0_a25 DATE := fnd_api.g_miss_date
77: , p0_a26 NUMBER := 0-1962.0724
78: )
72: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
73: , p0_a22 NUMBER := 0-1962.0724
74: , p0_a23 DATE := fnd_api.g_miss_date
75: , p0_a24 NUMBER := 0-1962.0724
76: , p0_a25 DATE := fnd_api.g_miss_date
77: , p0_a26 NUMBER := 0-1962.0724
78: )
79:
80: as
194: , p6_a25 out nocopy DATE
195: , p6_a26 out nocopy NUMBER
196: , p5_a0 NUMBER := 0-1962.0724
197: , p5_a1 NUMBER := 0-1962.0724
198: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a4 DATE := fnd_api.g_miss_date
201: , p5_a5 DATE := fnd_api.g_miss_date
202: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
195: , p6_a26 out nocopy NUMBER
196: , p5_a0 NUMBER := 0-1962.0724
197: , p5_a1 NUMBER := 0-1962.0724
198: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a4 DATE := fnd_api.g_miss_date
201: , p5_a5 DATE := fnd_api.g_miss_date
202: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
203: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
196: , p5_a0 NUMBER := 0-1962.0724
197: , p5_a1 NUMBER := 0-1962.0724
198: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a4 DATE := fnd_api.g_miss_date
201: , p5_a5 DATE := fnd_api.g_miss_date
202: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
203: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
197: , p5_a1 NUMBER := 0-1962.0724
198: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a4 DATE := fnd_api.g_miss_date
201: , p5_a5 DATE := fnd_api.g_miss_date
202: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
203: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a4 DATE := fnd_api.g_miss_date
201: , p5_a5 DATE := fnd_api.g_miss_date
202: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
203: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
206: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a4 DATE := fnd_api.g_miss_date
201: , p5_a5 DATE := fnd_api.g_miss_date
202: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
203: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
206: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
200: , p5_a4 DATE := fnd_api.g_miss_date
201: , p5_a5 DATE := fnd_api.g_miss_date
202: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
203: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
206: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
201: , p5_a5 DATE := fnd_api.g_miss_date
202: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
203: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
206: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
209: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
202: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
203: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
206: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
209: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
210: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
203: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
206: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
209: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
210: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
204: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
206: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
209: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
210: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
205: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
206: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
209: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
210: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
206: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
209: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
210: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
214: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
207: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
209: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
210: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
214: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
209: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
210: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
214: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
209: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
210: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
214: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
210: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
214: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a22 NUMBER := 0-1962.0724
211: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
214: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a22 NUMBER := 0-1962.0724
219: , p5_a23 DATE := fnd_api.g_miss_date
212: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
214: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a22 NUMBER := 0-1962.0724
219: , p5_a23 DATE := fnd_api.g_miss_date
220: , p5_a24 NUMBER := 0-1962.0724
213: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
214: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a22 NUMBER := 0-1962.0724
219: , p5_a23 DATE := fnd_api.g_miss_date
220: , p5_a24 NUMBER := 0-1962.0724
221: , p5_a25 DATE := fnd_api.g_miss_date
215: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a22 NUMBER := 0-1962.0724
219: , p5_a23 DATE := fnd_api.g_miss_date
220: , p5_a24 NUMBER := 0-1962.0724
221: , p5_a25 DATE := fnd_api.g_miss_date
222: , p5_a26 NUMBER := 0-1962.0724
223: )
217: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a22 NUMBER := 0-1962.0724
219: , p5_a23 DATE := fnd_api.g_miss_date
220: , p5_a24 NUMBER := 0-1962.0724
221: , p5_a25 DATE := fnd_api.g_miss_date
222: , p5_a26 NUMBER := 0-1962.0724
223: )
224:
225: as
341: , p6_a25 out nocopy DATE
342: , p6_a26 out nocopy NUMBER
343: , p5_a0 NUMBER := 0-1962.0724
344: , p5_a1 NUMBER := 0-1962.0724
345: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
346: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
347: , p5_a4 DATE := fnd_api.g_miss_date
348: , p5_a5 DATE := fnd_api.g_miss_date
349: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
342: , p6_a26 out nocopy NUMBER
343: , p5_a0 NUMBER := 0-1962.0724
344: , p5_a1 NUMBER := 0-1962.0724
345: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
346: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
347: , p5_a4 DATE := fnd_api.g_miss_date
348: , p5_a5 DATE := fnd_api.g_miss_date
349: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
343: , p5_a0 NUMBER := 0-1962.0724
344: , p5_a1 NUMBER := 0-1962.0724
345: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
346: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
347: , p5_a4 DATE := fnd_api.g_miss_date
348: , p5_a5 DATE := fnd_api.g_miss_date
349: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
344: , p5_a1 NUMBER := 0-1962.0724
345: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
346: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
347: , p5_a4 DATE := fnd_api.g_miss_date
348: , p5_a5 DATE := fnd_api.g_miss_date
349: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
345: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
346: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
347: , p5_a4 DATE := fnd_api.g_miss_date
348: , p5_a5 DATE := fnd_api.g_miss_date
349: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
346: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
347: , p5_a4 DATE := fnd_api.g_miss_date
348: , p5_a5 DATE := fnd_api.g_miss_date
349: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
347: , p5_a4 DATE := fnd_api.g_miss_date
348: , p5_a5 DATE := fnd_api.g_miss_date
349: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
348: , p5_a5 DATE := fnd_api.g_miss_date
349: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
349: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a22 NUMBER := 0-1962.0724
358: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a22 NUMBER := 0-1962.0724
366: , p5_a23 DATE := fnd_api.g_miss_date
359: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a22 NUMBER := 0-1962.0724
366: , p5_a23 DATE := fnd_api.g_miss_date
367: , p5_a24 NUMBER := 0-1962.0724
360: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a22 NUMBER := 0-1962.0724
366: , p5_a23 DATE := fnd_api.g_miss_date
367: , p5_a24 NUMBER := 0-1962.0724
368: , p5_a25 DATE := fnd_api.g_miss_date
362: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a22 NUMBER := 0-1962.0724
366: , p5_a23 DATE := fnd_api.g_miss_date
367: , p5_a24 NUMBER := 0-1962.0724
368: , p5_a25 DATE := fnd_api.g_miss_date
369: , p5_a26 NUMBER := 0-1962.0724
370: )
364: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a22 NUMBER := 0-1962.0724
366: , p5_a23 DATE := fnd_api.g_miss_date
367: , p5_a24 NUMBER := 0-1962.0724
368: , p5_a25 DATE := fnd_api.g_miss_date
369: , p5_a26 NUMBER := 0-1962.0724
370: )
371:
372: as