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;
35: , p3_a11 out nocopy NUMBER
36: , p0_a0 NUMBER := 0-1962.0724
37: , p0_a1 NUMBER := 0-1962.0724
38: , p0_a2 NUMBER := 0-1962.0724
39: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a5 DATE := fnd_api.g_miss_date
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
36: , p0_a0 NUMBER := 0-1962.0724
37: , p0_a1 NUMBER := 0-1962.0724
38: , p0_a2 NUMBER := 0-1962.0724
39: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a5 DATE := fnd_api.g_miss_date
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
44: , p0_a8 DATE := fnd_api.g_miss_date
37: , p0_a1 NUMBER := 0-1962.0724
38: , p0_a2 NUMBER := 0-1962.0724
39: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a5 DATE := fnd_api.g_miss_date
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
44: , p0_a8 DATE := fnd_api.g_miss_date
45: , p0_a9 NUMBER := 0-1962.0724
38: , p0_a2 NUMBER := 0-1962.0724
39: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a5 DATE := fnd_api.g_miss_date
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
44: , p0_a8 DATE := fnd_api.g_miss_date
45: , p0_a9 NUMBER := 0-1962.0724
46: , p0_a10 DATE := fnd_api.g_miss_date
40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a5 DATE := fnd_api.g_miss_date
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
44: , p0_a8 DATE := fnd_api.g_miss_date
45: , p0_a9 NUMBER := 0-1962.0724
46: , p0_a10 DATE := fnd_api.g_miss_date
47: , p0_a11 NUMBER := 0-1962.0724
48: )
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
44: , p0_a8 DATE := fnd_api.g_miss_date
45: , p0_a9 NUMBER := 0-1962.0724
46: , p0_a10 DATE := fnd_api.g_miss_date
47: , p0_a11 NUMBER := 0-1962.0724
48: )
49:
50: as
164: , p3_a58 out nocopy VARCHAR2
165: , p3_a59 out nocopy NUMBER
166: , p0_a0 NUMBER := 0-1962.0724
167: , p0_a1 NUMBER := 0-1962.0724
168: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
165: , p3_a59 out nocopy NUMBER
166: , p0_a0 NUMBER := 0-1962.0724
167: , p0_a1 NUMBER := 0-1962.0724
168: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
166: , p0_a0 NUMBER := 0-1962.0724
167: , p0_a1 NUMBER := 0-1962.0724
168: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
167: , p0_a1 NUMBER := 0-1962.0724
168: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
168: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
178: , p0_a12 NUMBER := 0-1962.0724
171: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
178: , p0_a12 NUMBER := 0-1962.0724
179: , p0_a13 NUMBER := 0-1962.0724
172: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
178: , p0_a12 NUMBER := 0-1962.0724
179: , p0_a13 NUMBER := 0-1962.0724
180: , p0_a14 NUMBER := 0-1962.0724
173: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
178: , p0_a12 NUMBER := 0-1962.0724
179: , p0_a13 NUMBER := 0-1962.0724
180: , p0_a14 NUMBER := 0-1962.0724
181: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
178: , p0_a12 NUMBER := 0-1962.0724
179: , p0_a13 NUMBER := 0-1962.0724
180: , p0_a14 NUMBER := 0-1962.0724
181: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
182: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
183: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
178: , p0_a12 NUMBER := 0-1962.0724
179: , p0_a13 NUMBER := 0-1962.0724
180: , p0_a14 NUMBER := 0-1962.0724
181: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
182: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
183: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
179: , p0_a13 NUMBER := 0-1962.0724
180: , p0_a14 NUMBER := 0-1962.0724
181: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
182: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
183: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
180: , p0_a14 NUMBER := 0-1962.0724
181: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
182: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
183: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
181: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
182: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
183: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
182: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
183: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
183: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
184: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
185: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
186: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
187: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
188: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
189: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
190: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
191: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
200: , p0_a34 NUMBER := 0-1962.0724
193: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
200: , p0_a34 NUMBER := 0-1962.0724
201: , p0_a35 DATE := fnd_api.g_miss_date
194: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
200: , p0_a34 NUMBER := 0-1962.0724
201: , p0_a35 DATE := fnd_api.g_miss_date
202: , p0_a36 NUMBER := 0-1962.0724
195: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
200: , p0_a34 NUMBER := 0-1962.0724
201: , p0_a35 DATE := fnd_api.g_miss_date
202: , p0_a36 NUMBER := 0-1962.0724
203: , p0_a37 DATE := fnd_api.g_miss_date
197: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
200: , p0_a34 NUMBER := 0-1962.0724
201: , p0_a35 DATE := fnd_api.g_miss_date
202: , p0_a36 NUMBER := 0-1962.0724
203: , p0_a37 DATE := fnd_api.g_miss_date
204: , p0_a38 NUMBER := 0-1962.0724
205: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
200: , p0_a34 NUMBER := 0-1962.0724
201: , p0_a35 DATE := fnd_api.g_miss_date
202: , p0_a36 NUMBER := 0-1962.0724
203: , p0_a37 DATE := fnd_api.g_miss_date
204: , p0_a38 NUMBER := 0-1962.0724
205: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a35 DATE := fnd_api.g_miss_date
202: , p0_a36 NUMBER := 0-1962.0724
203: , p0_a37 DATE := fnd_api.g_miss_date
204: , p0_a38 NUMBER := 0-1962.0724
205: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a36 NUMBER := 0-1962.0724
203: , p0_a37 DATE := fnd_api.g_miss_date
204: , p0_a38 NUMBER := 0-1962.0724
205: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a37 DATE := fnd_api.g_miss_date
204: , p0_a38 NUMBER := 0-1962.0724
205: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
204: , p0_a38 NUMBER := 0-1962.0724
205: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
205: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a57 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a57 VARCHAR2 := fnd_api.g_miss_char
224: , p0_a58 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a57 VARCHAR2 := fnd_api.g_miss_char
224: , p0_a58 VARCHAR2 := fnd_api.g_miss_char
225: , p0_a59 NUMBER := 0-1962.0724
218: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a57 VARCHAR2 := fnd_api.g_miss_char
224: , p0_a58 VARCHAR2 := fnd_api.g_miss_char
225: , p0_a59 NUMBER := 0-1962.0724
226: )
219: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a57 VARCHAR2 := fnd_api.g_miss_char
224: , p0_a58 VARCHAR2 := fnd_api.g_miss_char
225: , p0_a59 NUMBER := 0-1962.0724
226: )
227:
220: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a57 VARCHAR2 := fnd_api.g_miss_char
224: , p0_a58 VARCHAR2 := fnd_api.g_miss_char
225: , p0_a59 NUMBER := 0-1962.0724
226: )
227:
228: as
393: , p7_a10 out nocopy DATE
394: , p7_a11 out nocopy NUMBER
395: , p5_a0 NUMBER := 0-1962.0724
396: , p5_a1 NUMBER := 0-1962.0724
397: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a4 DATE := fnd_api.g_miss_date
400: , p5_a5 DATE := fnd_api.g_miss_date
401: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
394: , p7_a11 out nocopy NUMBER
395: , p5_a0 NUMBER := 0-1962.0724
396: , p5_a1 NUMBER := 0-1962.0724
397: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a4 DATE := fnd_api.g_miss_date
400: , p5_a5 DATE := fnd_api.g_miss_date
401: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a0 NUMBER := 0-1962.0724
396: , p5_a1 NUMBER := 0-1962.0724
397: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a4 DATE := fnd_api.g_miss_date
400: , p5_a5 DATE := fnd_api.g_miss_date
401: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a1 NUMBER := 0-1962.0724
397: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a4 DATE := fnd_api.g_miss_date
400: , p5_a5 DATE := fnd_api.g_miss_date
401: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a4 DATE := fnd_api.g_miss_date
400: , p5_a5 DATE := fnd_api.g_miss_date
401: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a4 DATE := fnd_api.g_miss_date
400: , p5_a5 DATE := fnd_api.g_miss_date
401: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a4 DATE := fnd_api.g_miss_date
400: , p5_a5 DATE := fnd_api.g_miss_date
401: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a5 DATE := fnd_api.g_miss_date
401: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 NUMBER := 0-1962.0724
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 NUMBER := 0-1962.0724
418: , p5_a23 DATE := fnd_api.g_miss_date
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 NUMBER := 0-1962.0724
418: , p5_a23 DATE := fnd_api.g_miss_date
419: , p5_a24 NUMBER := 0-1962.0724
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 NUMBER := 0-1962.0724
418: , p5_a23 DATE := fnd_api.g_miss_date
419: , p5_a24 NUMBER := 0-1962.0724
420: , p5_a25 DATE := fnd_api.g_miss_date
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 NUMBER := 0-1962.0724
418: , p5_a23 DATE := fnd_api.g_miss_date
419: , p5_a24 NUMBER := 0-1962.0724
420: , p5_a25 DATE := fnd_api.g_miss_date
421: , p5_a26 NUMBER := 0-1962.0724
422: , p6_a0 NUMBER := 0-1962.0724
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 NUMBER := 0-1962.0724
418: , p5_a23 DATE := fnd_api.g_miss_date
419: , p5_a24 NUMBER := 0-1962.0724
420: , p5_a25 DATE := fnd_api.g_miss_date
421: , p5_a26 NUMBER := 0-1962.0724
422: , p6_a0 NUMBER := 0-1962.0724
423: , p6_a1 NUMBER := 0-1962.0724
424: , p6_a2 NUMBER := 0-1962.0724
421: , p5_a26 NUMBER := 0-1962.0724
422: , p6_a0 NUMBER := 0-1962.0724
423: , p6_a1 NUMBER := 0-1962.0724
424: , p6_a2 NUMBER := 0-1962.0724
425: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
426: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
427: , p6_a5 DATE := fnd_api.g_miss_date
428: , p6_a6 DATE := fnd_api.g_miss_date
429: , p6_a7 NUMBER := 0-1962.0724
422: , p6_a0 NUMBER := 0-1962.0724
423: , p6_a1 NUMBER := 0-1962.0724
424: , p6_a2 NUMBER := 0-1962.0724
425: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
426: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
427: , p6_a5 DATE := fnd_api.g_miss_date
428: , p6_a6 DATE := fnd_api.g_miss_date
429: , p6_a7 NUMBER := 0-1962.0724
430: , p6_a8 DATE := fnd_api.g_miss_date
423: , p6_a1 NUMBER := 0-1962.0724
424: , p6_a2 NUMBER := 0-1962.0724
425: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
426: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
427: , p6_a5 DATE := fnd_api.g_miss_date
428: , p6_a6 DATE := fnd_api.g_miss_date
429: , p6_a7 NUMBER := 0-1962.0724
430: , p6_a8 DATE := fnd_api.g_miss_date
431: , p6_a9 NUMBER := 0-1962.0724
424: , p6_a2 NUMBER := 0-1962.0724
425: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
426: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
427: , p6_a5 DATE := fnd_api.g_miss_date
428: , p6_a6 DATE := fnd_api.g_miss_date
429: , p6_a7 NUMBER := 0-1962.0724
430: , p6_a8 DATE := fnd_api.g_miss_date
431: , p6_a9 NUMBER := 0-1962.0724
432: , p6_a10 DATE := fnd_api.g_miss_date
426: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
427: , p6_a5 DATE := fnd_api.g_miss_date
428: , p6_a6 DATE := fnd_api.g_miss_date
429: , p6_a7 NUMBER := 0-1962.0724
430: , p6_a8 DATE := fnd_api.g_miss_date
431: , p6_a9 NUMBER := 0-1962.0724
432: , p6_a10 DATE := fnd_api.g_miss_date
433: , p6_a11 NUMBER := 0-1962.0724
434: )
428: , p6_a6 DATE := fnd_api.g_miss_date
429: , p6_a7 NUMBER := 0-1962.0724
430: , p6_a8 DATE := fnd_api.g_miss_date
431: , p6_a9 NUMBER := 0-1962.0724
432: , p6_a10 DATE := fnd_api.g_miss_date
433: , p6_a11 NUMBER := 0-1962.0724
434: )
435:
436: as
538: , p7_a10 out nocopy DATE
539: , p7_a11 out nocopy NUMBER
540: , p5_a0 NUMBER := 0-1962.0724
541: , p5_a1 NUMBER := 0-1962.0724
542: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a4 DATE := fnd_api.g_miss_date
545: , p5_a5 DATE := fnd_api.g_miss_date
546: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
539: , p7_a11 out nocopy NUMBER
540: , p5_a0 NUMBER := 0-1962.0724
541: , p5_a1 NUMBER := 0-1962.0724
542: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a4 DATE := fnd_api.g_miss_date
545: , p5_a5 DATE := fnd_api.g_miss_date
546: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a0 NUMBER := 0-1962.0724
541: , p5_a1 NUMBER := 0-1962.0724
542: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a4 DATE := fnd_api.g_miss_date
545: , p5_a5 DATE := fnd_api.g_miss_date
546: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a1 NUMBER := 0-1962.0724
542: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a4 DATE := fnd_api.g_miss_date
545: , p5_a5 DATE := fnd_api.g_miss_date
546: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a4 DATE := fnd_api.g_miss_date
545: , p5_a5 DATE := fnd_api.g_miss_date
546: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a4 DATE := fnd_api.g_miss_date
545: , p5_a5 DATE := fnd_api.g_miss_date
546: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a4 DATE := fnd_api.g_miss_date
545: , p5_a5 DATE := fnd_api.g_miss_date
546: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a5 DATE := fnd_api.g_miss_date
546: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
561: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
561: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a22 NUMBER := 0-1962.0724
555: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
561: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a22 NUMBER := 0-1962.0724
563: , p5_a23 DATE := fnd_api.g_miss_date
556: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
561: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a22 NUMBER := 0-1962.0724
563: , p5_a23 DATE := fnd_api.g_miss_date
564: , p5_a24 NUMBER := 0-1962.0724
557: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
561: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a22 NUMBER := 0-1962.0724
563: , p5_a23 DATE := fnd_api.g_miss_date
564: , p5_a24 NUMBER := 0-1962.0724
565: , p5_a25 DATE := fnd_api.g_miss_date
559: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
561: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a22 NUMBER := 0-1962.0724
563: , p5_a23 DATE := fnd_api.g_miss_date
564: , p5_a24 NUMBER := 0-1962.0724
565: , p5_a25 DATE := fnd_api.g_miss_date
566: , p5_a26 NUMBER := 0-1962.0724
567: , p6_a0 NUMBER := 0-1962.0724
561: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a22 NUMBER := 0-1962.0724
563: , p5_a23 DATE := fnd_api.g_miss_date
564: , p5_a24 NUMBER := 0-1962.0724
565: , p5_a25 DATE := fnd_api.g_miss_date
566: , p5_a26 NUMBER := 0-1962.0724
567: , p6_a0 NUMBER := 0-1962.0724
568: , p6_a1 NUMBER := 0-1962.0724
569: , p6_a2 NUMBER := 0-1962.0724
566: , p5_a26 NUMBER := 0-1962.0724
567: , p6_a0 NUMBER := 0-1962.0724
568: , p6_a1 NUMBER := 0-1962.0724
569: , p6_a2 NUMBER := 0-1962.0724
570: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
571: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
572: , p6_a5 DATE := fnd_api.g_miss_date
573: , p6_a6 DATE := fnd_api.g_miss_date
574: , p6_a7 NUMBER := 0-1962.0724
567: , p6_a0 NUMBER := 0-1962.0724
568: , p6_a1 NUMBER := 0-1962.0724
569: , p6_a2 NUMBER := 0-1962.0724
570: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
571: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
572: , p6_a5 DATE := fnd_api.g_miss_date
573: , p6_a6 DATE := fnd_api.g_miss_date
574: , p6_a7 NUMBER := 0-1962.0724
575: , p6_a8 DATE := fnd_api.g_miss_date
568: , p6_a1 NUMBER := 0-1962.0724
569: , p6_a2 NUMBER := 0-1962.0724
570: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
571: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
572: , p6_a5 DATE := fnd_api.g_miss_date
573: , p6_a6 DATE := fnd_api.g_miss_date
574: , p6_a7 NUMBER := 0-1962.0724
575: , p6_a8 DATE := fnd_api.g_miss_date
576: , p6_a9 NUMBER := 0-1962.0724
569: , p6_a2 NUMBER := 0-1962.0724
570: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
571: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
572: , p6_a5 DATE := fnd_api.g_miss_date
573: , p6_a6 DATE := fnd_api.g_miss_date
574: , p6_a7 NUMBER := 0-1962.0724
575: , p6_a8 DATE := fnd_api.g_miss_date
576: , p6_a9 NUMBER := 0-1962.0724
577: , p6_a10 DATE := fnd_api.g_miss_date
571: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
572: , p6_a5 DATE := fnd_api.g_miss_date
573: , p6_a6 DATE := fnd_api.g_miss_date
574: , p6_a7 NUMBER := 0-1962.0724
575: , p6_a8 DATE := fnd_api.g_miss_date
576: , p6_a9 NUMBER := 0-1962.0724
577: , p6_a10 DATE := fnd_api.g_miss_date
578: , p6_a11 NUMBER := 0-1962.0724
579: )
573: , p6_a6 DATE := fnd_api.g_miss_date
574: , p6_a7 NUMBER := 0-1962.0724
575: , p6_a8 DATE := fnd_api.g_miss_date
576: , p6_a9 NUMBER := 0-1962.0724
577: , p6_a10 DATE := fnd_api.g_miss_date
578: , p6_a11 NUMBER := 0-1962.0724
579: )
580:
581: as