7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;
142: , p9_a27 out nocopy DATE
143: , p9_a28 out nocopy NUMBER
144: , p5_a0 NUMBER := 0-1962.0724
145: , p5_a1 NUMBER := 0-1962.0724
146: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
143: , p9_a28 out nocopy NUMBER
144: , p5_a0 NUMBER := 0-1962.0724
145: , p5_a1 NUMBER := 0-1962.0724
146: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a0 NUMBER := 0-1962.0724
145: , p5_a1 NUMBER := 0-1962.0724
146: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a8 NUMBER := 0-1962.0724
145: , p5_a1 NUMBER := 0-1962.0724
146: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a8 NUMBER := 0-1962.0724
153: , p5_a9 NUMBER := 0-1962.0724
146: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a8 NUMBER := 0-1962.0724
153: , p5_a9 NUMBER := 0-1962.0724
154: , p5_a10 DATE := fnd_api.g_miss_date
147: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a8 NUMBER := 0-1962.0724
153: , p5_a9 NUMBER := 0-1962.0724
154: , p5_a10 DATE := fnd_api.g_miss_date
155: , p5_a11 NUMBER := 0-1962.0724
150: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a8 NUMBER := 0-1962.0724
153: , p5_a9 NUMBER := 0-1962.0724
154: , p5_a10 DATE := fnd_api.g_miss_date
155: , p5_a11 NUMBER := 0-1962.0724
156: , p5_a12 DATE := fnd_api.g_miss_date
157: , p5_a13 NUMBER := 0-1962.0724
158: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a8 NUMBER := 0-1962.0724
153: , p5_a9 NUMBER := 0-1962.0724
154: , p5_a10 DATE := fnd_api.g_miss_date
155: , p5_a11 NUMBER := 0-1962.0724
156: , p5_a12 DATE := fnd_api.g_miss_date
157: , p5_a13 NUMBER := 0-1962.0724
158: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a10 DATE := fnd_api.g_miss_date
155: , p5_a11 NUMBER := 0-1962.0724
156: , p5_a12 DATE := fnd_api.g_miss_date
157: , p5_a13 NUMBER := 0-1962.0724
158: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a11 NUMBER := 0-1962.0724
156: , p5_a12 DATE := fnd_api.g_miss_date
157: , p5_a13 NUMBER := 0-1962.0724
158: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
163: , p6_a0 NUMBER := 0-1962.0724
156: , p5_a12 DATE := fnd_api.g_miss_date
157: , p5_a13 NUMBER := 0-1962.0724
158: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
163: , p6_a0 NUMBER := 0-1962.0724
164: , p6_a1 NUMBER := 0-1962.0724
157: , p5_a13 NUMBER := 0-1962.0724
158: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
163: , p6_a0 NUMBER := 0-1962.0724
164: , p6_a1 NUMBER := 0-1962.0724
165: , p6_a2 NUMBER := 0-1962.0724
158: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
163: , p6_a0 NUMBER := 0-1962.0724
164: , p6_a1 NUMBER := 0-1962.0724
165: , p6_a2 NUMBER := 0-1962.0724
166: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
163: , p6_a0 NUMBER := 0-1962.0724
164: , p6_a1 NUMBER := 0-1962.0724
165: , p6_a2 NUMBER := 0-1962.0724
166: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
167: , p6_a4 DATE := fnd_api.g_miss_date
168: , p6_a5 DATE := fnd_api.g_miss_date
169: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
163: , p6_a0 NUMBER := 0-1962.0724
164: , p6_a1 NUMBER := 0-1962.0724
165: , p6_a2 NUMBER := 0-1962.0724
166: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
167: , p6_a4 DATE := fnd_api.g_miss_date
168: , p6_a5 DATE := fnd_api.g_miss_date
169: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
171: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
164: , p6_a1 NUMBER := 0-1962.0724
165: , p6_a2 NUMBER := 0-1962.0724
166: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
167: , p6_a4 DATE := fnd_api.g_miss_date
168: , p6_a5 DATE := fnd_api.g_miss_date
169: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
171: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
172: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
165: , p6_a2 NUMBER := 0-1962.0724
166: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
167: , p6_a4 DATE := fnd_api.g_miss_date
168: , p6_a5 DATE := fnd_api.g_miss_date
169: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
171: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
172: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
173: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
166: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
167: , p6_a4 DATE := fnd_api.g_miss_date
168: , p6_a5 DATE := fnd_api.g_miss_date
169: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
171: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
172: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
173: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
174: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
167: , p6_a4 DATE := fnd_api.g_miss_date
168: , p6_a5 DATE := fnd_api.g_miss_date
169: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
171: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
172: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
173: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
174: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
175: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
168: , p6_a5 DATE := fnd_api.g_miss_date
169: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
171: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
172: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
173: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
174: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
175: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
176: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
169: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
171: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
172: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
173: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
174: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
175: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
176: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
177: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
171: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
172: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
173: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
174: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
175: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
176: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
177: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
178: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
171: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
172: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
173: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
174: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
175: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
176: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
177: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
178: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
172: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
173: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
174: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
175: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
176: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
177: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
178: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
173: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
174: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
175: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
176: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
177: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
178: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
174: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
175: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
176: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
177: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
178: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
175: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
176: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
177: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
178: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
176: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
177: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
178: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
177: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
178: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
178: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
186: , p6_a23 NUMBER := 0-1962.0724
179: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
186: , p6_a23 NUMBER := 0-1962.0724
187: , p6_a24 NUMBER := 0-1962.0724
180: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
186: , p6_a23 NUMBER := 0-1962.0724
187: , p6_a24 NUMBER := 0-1962.0724
188: , p6_a25 DATE := fnd_api.g_miss_date
181: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
182: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
186: , p6_a23 NUMBER := 0-1962.0724
187: , p6_a24 NUMBER := 0-1962.0724
188: , p6_a25 DATE := fnd_api.g_miss_date
189: , p6_a26 NUMBER := 0-1962.0724
184: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
186: , p6_a23 NUMBER := 0-1962.0724
187: , p6_a24 NUMBER := 0-1962.0724
188: , p6_a25 DATE := fnd_api.g_miss_date
189: , p6_a26 NUMBER := 0-1962.0724
190: , p6_a27 DATE := fnd_api.g_miss_date
191: , p6_a28 NUMBER := 0-1962.0724
192: )
186: , p6_a23 NUMBER := 0-1962.0724
187: , p6_a24 NUMBER := 0-1962.0724
188: , p6_a25 DATE := fnd_api.g_miss_date
189: , p6_a26 NUMBER := 0-1962.0724
190: , p6_a27 DATE := fnd_api.g_miss_date
191: , p6_a28 NUMBER := 0-1962.0724
192: )
193:
194: as
405: , p9_a27 out nocopy DATE
406: , p9_a28 out nocopy NUMBER
407: , p5_a0 NUMBER := 0-1962.0724
408: , p5_a1 NUMBER := 0-1962.0724
409: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
406: , p9_a28 out nocopy NUMBER
407: , p5_a0 NUMBER := 0-1962.0724
408: , p5_a1 NUMBER := 0-1962.0724
409: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a0 NUMBER := 0-1962.0724
408: , p5_a1 NUMBER := 0-1962.0724
409: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a1 NUMBER := 0-1962.0724
409: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a8 NUMBER := 0-1962.0724
416: , p5_a9 NUMBER := 0-1962.0724
409: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a8 NUMBER := 0-1962.0724
416: , p5_a9 NUMBER := 0-1962.0724
417: , p5_a10 DATE := fnd_api.g_miss_date
410: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a8 NUMBER := 0-1962.0724
416: , p5_a9 NUMBER := 0-1962.0724
417: , p5_a10 DATE := fnd_api.g_miss_date
418: , p5_a11 NUMBER := 0-1962.0724
413: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a8 NUMBER := 0-1962.0724
416: , p5_a9 NUMBER := 0-1962.0724
417: , p5_a10 DATE := fnd_api.g_miss_date
418: , p5_a11 NUMBER := 0-1962.0724
419: , p5_a12 DATE := fnd_api.g_miss_date
420: , p5_a13 NUMBER := 0-1962.0724
421: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a8 NUMBER := 0-1962.0724
416: , p5_a9 NUMBER := 0-1962.0724
417: , p5_a10 DATE := fnd_api.g_miss_date
418: , p5_a11 NUMBER := 0-1962.0724
419: , p5_a12 DATE := fnd_api.g_miss_date
420: , p5_a13 NUMBER := 0-1962.0724
421: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a10 DATE := fnd_api.g_miss_date
418: , p5_a11 NUMBER := 0-1962.0724
419: , p5_a12 DATE := fnd_api.g_miss_date
420: , p5_a13 NUMBER := 0-1962.0724
421: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a11 NUMBER := 0-1962.0724
419: , p5_a12 DATE := fnd_api.g_miss_date
420: , p5_a13 NUMBER := 0-1962.0724
421: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
426: , p6_a0 NUMBER := 0-1962.0724
419: , p5_a12 DATE := fnd_api.g_miss_date
420: , p5_a13 NUMBER := 0-1962.0724
421: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
426: , p6_a0 NUMBER := 0-1962.0724
427: , p6_a1 NUMBER := 0-1962.0724
420: , p5_a13 NUMBER := 0-1962.0724
421: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
426: , p6_a0 NUMBER := 0-1962.0724
427: , p6_a1 NUMBER := 0-1962.0724
428: , p6_a2 NUMBER := 0-1962.0724
421: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
426: , p6_a0 NUMBER := 0-1962.0724
427: , p6_a1 NUMBER := 0-1962.0724
428: , p6_a2 NUMBER := 0-1962.0724
429: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
426: , p6_a0 NUMBER := 0-1962.0724
427: , p6_a1 NUMBER := 0-1962.0724
428: , p6_a2 NUMBER := 0-1962.0724
429: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
430: , p6_a4 DATE := fnd_api.g_miss_date
431: , p6_a5 DATE := fnd_api.g_miss_date
432: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
433: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
426: , p6_a0 NUMBER := 0-1962.0724
427: , p6_a1 NUMBER := 0-1962.0724
428: , p6_a2 NUMBER := 0-1962.0724
429: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
430: , p6_a4 DATE := fnd_api.g_miss_date
431: , p6_a5 DATE := fnd_api.g_miss_date
432: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
433: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
434: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
427: , p6_a1 NUMBER := 0-1962.0724
428: , p6_a2 NUMBER := 0-1962.0724
429: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
430: , p6_a4 DATE := fnd_api.g_miss_date
431: , p6_a5 DATE := fnd_api.g_miss_date
432: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
433: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
434: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
435: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
428: , p6_a2 NUMBER := 0-1962.0724
429: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
430: , p6_a4 DATE := fnd_api.g_miss_date
431: , p6_a5 DATE := fnd_api.g_miss_date
432: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
433: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
434: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
435: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
436: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
429: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
430: , p6_a4 DATE := fnd_api.g_miss_date
431: , p6_a5 DATE := fnd_api.g_miss_date
432: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
433: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
434: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
435: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
436: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
437: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
430: , p6_a4 DATE := fnd_api.g_miss_date
431: , p6_a5 DATE := fnd_api.g_miss_date
432: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
433: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
434: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
435: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
436: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
437: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
438: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
431: , p6_a5 DATE := fnd_api.g_miss_date
432: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
433: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
434: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
435: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
436: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
437: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
438: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
439: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
432: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
433: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
434: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
435: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
436: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
437: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
438: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
439: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
440: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
433: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
434: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
435: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
436: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
437: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
438: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
439: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
440: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
441: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
434: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
435: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
436: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
437: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
438: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
439: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
440: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
441: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
442: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
435: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
436: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
437: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
438: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
439: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
440: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
441: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
442: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
443: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
436: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
437: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
438: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
439: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
440: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
441: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
442: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
443: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
444: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
437: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
438: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
439: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
440: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
441: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
442: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
443: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
444: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
445: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
438: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
439: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
440: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
441: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
442: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
443: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
444: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
445: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
446: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
439: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
440: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
441: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
442: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
443: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
444: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
445: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
446: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
447: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
440: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
441: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
442: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
443: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
444: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
445: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
446: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
447: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
448: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
441: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
442: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
443: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
444: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
445: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
446: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
447: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
448: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
449: , p6_a23 NUMBER := 0-1962.0724
442: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
443: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
444: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
445: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
446: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
447: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
448: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
449: , p6_a23 NUMBER := 0-1962.0724
450: , p6_a24 NUMBER := 0-1962.0724
443: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
444: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
445: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
446: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
447: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
448: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
449: , p6_a23 NUMBER := 0-1962.0724
450: , p6_a24 NUMBER := 0-1962.0724
451: , p6_a25 DATE := fnd_api.g_miss_date
444: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
445: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
446: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
447: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
448: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
449: , p6_a23 NUMBER := 0-1962.0724
450: , p6_a24 NUMBER := 0-1962.0724
451: , p6_a25 DATE := fnd_api.g_miss_date
452: , p6_a26 NUMBER := 0-1962.0724
447: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
448: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
449: , p6_a23 NUMBER := 0-1962.0724
450: , p6_a24 NUMBER := 0-1962.0724
451: , p6_a25 DATE := fnd_api.g_miss_date
452: , p6_a26 NUMBER := 0-1962.0724
453: , p6_a27 DATE := fnd_api.g_miss_date
454: , p6_a28 NUMBER := 0-1962.0724
455: )
449: , p6_a23 NUMBER := 0-1962.0724
450: , p6_a24 NUMBER := 0-1962.0724
451: , p6_a25 DATE := fnd_api.g_miss_date
452: , p6_a26 NUMBER := 0-1962.0724
453: , p6_a27 DATE := fnd_api.g_miss_date
454: , p6_a28 NUMBER := 0-1962.0724
455: )
456:
457: as
1172: , p11_a28 out nocopy NUMBER
1173: , x_pri_purpose_list out nocopy VARCHAR2
1174: , p5_a0 NUMBER := 0-1962.0724
1175: , p5_a1 NUMBER := 0-1962.0724
1176: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1173: , x_pri_purpose_list out nocopy VARCHAR2
1174: , p5_a0 NUMBER := 0-1962.0724
1175: , p5_a1 NUMBER := 0-1962.0724
1176: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a0 NUMBER := 0-1962.0724
1175: , p5_a1 NUMBER := 0-1962.0724
1176: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a8 NUMBER := 0-1962.0724
1175: , p5_a1 NUMBER := 0-1962.0724
1176: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a8 NUMBER := 0-1962.0724
1183: , p5_a9 NUMBER := 0-1962.0724
1176: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a8 NUMBER := 0-1962.0724
1183: , p5_a9 NUMBER := 0-1962.0724
1184: , p5_a10 DATE := fnd_api.g_miss_date
1177: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a8 NUMBER := 0-1962.0724
1183: , p5_a9 NUMBER := 0-1962.0724
1184: , p5_a10 DATE := fnd_api.g_miss_date
1185: , p5_a11 NUMBER := 0-1962.0724
1180: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a8 NUMBER := 0-1962.0724
1183: , p5_a9 NUMBER := 0-1962.0724
1184: , p5_a10 DATE := fnd_api.g_miss_date
1185: , p5_a11 NUMBER := 0-1962.0724
1186: , p5_a12 DATE := fnd_api.g_miss_date
1187: , p5_a13 NUMBER := 0-1962.0724
1188: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a8 NUMBER := 0-1962.0724
1183: , p5_a9 NUMBER := 0-1962.0724
1184: , p5_a10 DATE := fnd_api.g_miss_date
1185: , p5_a11 NUMBER := 0-1962.0724
1186: , p5_a12 DATE := fnd_api.g_miss_date
1187: , p5_a13 NUMBER := 0-1962.0724
1188: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a10 DATE := fnd_api.g_miss_date
1185: , p5_a11 NUMBER := 0-1962.0724
1186: , p5_a12 DATE := fnd_api.g_miss_date
1187: , p5_a13 NUMBER := 0-1962.0724
1188: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a11 NUMBER := 0-1962.0724
1186: , p5_a12 DATE := fnd_api.g_miss_date
1187: , p5_a13 NUMBER := 0-1962.0724
1188: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1193: , p6_a0 NUMBER := 0-1962.0724
1186: , p5_a12 DATE := fnd_api.g_miss_date
1187: , p5_a13 NUMBER := 0-1962.0724
1188: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1193: , p6_a0 NUMBER := 0-1962.0724
1194: , p6_a1 NUMBER := 0-1962.0724
1187: , p5_a13 NUMBER := 0-1962.0724
1188: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1193: , p6_a0 NUMBER := 0-1962.0724
1194: , p6_a1 NUMBER := 0-1962.0724
1195: , p6_a2 NUMBER := 0-1962.0724
1188: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1193: , p6_a0 NUMBER := 0-1962.0724
1194: , p6_a1 NUMBER := 0-1962.0724
1195: , p6_a2 NUMBER := 0-1962.0724
1196: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1193: , p6_a0 NUMBER := 0-1962.0724
1194: , p6_a1 NUMBER := 0-1962.0724
1195: , p6_a2 NUMBER := 0-1962.0724
1196: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1197: , p6_a4 DATE := fnd_api.g_miss_date
1198: , p6_a5 DATE := fnd_api.g_miss_date
1199: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1200: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1193: , p6_a0 NUMBER := 0-1962.0724
1194: , p6_a1 NUMBER := 0-1962.0724
1195: , p6_a2 NUMBER := 0-1962.0724
1196: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1197: , p6_a4 DATE := fnd_api.g_miss_date
1198: , p6_a5 DATE := fnd_api.g_miss_date
1199: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1200: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1201: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1194: , p6_a1 NUMBER := 0-1962.0724
1195: , p6_a2 NUMBER := 0-1962.0724
1196: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1197: , p6_a4 DATE := fnd_api.g_miss_date
1198: , p6_a5 DATE := fnd_api.g_miss_date
1199: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1200: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1201: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1202: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1195: , p6_a2 NUMBER := 0-1962.0724
1196: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1197: , p6_a4 DATE := fnd_api.g_miss_date
1198: , p6_a5 DATE := fnd_api.g_miss_date
1199: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1200: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1201: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1202: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1203: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1196: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1197: , p6_a4 DATE := fnd_api.g_miss_date
1198: , p6_a5 DATE := fnd_api.g_miss_date
1199: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1200: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1201: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1202: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1203: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1204: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1197: , p6_a4 DATE := fnd_api.g_miss_date
1198: , p6_a5 DATE := fnd_api.g_miss_date
1199: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1200: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1201: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1202: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1203: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1204: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1205: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1198: , p6_a5 DATE := fnd_api.g_miss_date
1199: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1200: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1201: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1202: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1203: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1204: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1205: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1206: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1199: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1200: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1201: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1202: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1203: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1204: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1205: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1206: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1207: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1200: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1201: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1202: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1203: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1204: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1205: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1206: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1207: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1208: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1201: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1202: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1203: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1204: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1205: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1206: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1207: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1208: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1209: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1202: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1203: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1204: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1205: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1206: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1207: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1208: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1209: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1210: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1203: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1204: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1205: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1206: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1207: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1208: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1209: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1210: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1211: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1204: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1205: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1206: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1207: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1208: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1209: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1210: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1211: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1212: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1205: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1206: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1207: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1208: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1209: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1210: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1211: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1212: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1213: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1206: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1207: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1208: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1209: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1210: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1211: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1212: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1213: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1214: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1207: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1208: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1209: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1210: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1211: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1212: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1213: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1214: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1215: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1208: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1209: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1210: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1211: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1212: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1213: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1214: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1215: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1216: , p6_a23 NUMBER := 0-1962.0724
1209: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1210: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1211: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1212: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1213: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1214: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1215: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1216: , p6_a23 NUMBER := 0-1962.0724
1217: , p6_a24 NUMBER := 0-1962.0724
1210: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1211: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1212: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1213: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1214: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1215: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1216: , p6_a23 NUMBER := 0-1962.0724
1217: , p6_a24 NUMBER := 0-1962.0724
1218: , p6_a25 DATE := fnd_api.g_miss_date
1211: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1212: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1213: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1214: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1215: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1216: , p6_a23 NUMBER := 0-1962.0724
1217: , p6_a24 NUMBER := 0-1962.0724
1218: , p6_a25 DATE := fnd_api.g_miss_date
1219: , p6_a26 NUMBER := 0-1962.0724
1214: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1215: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1216: , p6_a23 NUMBER := 0-1962.0724
1217: , p6_a24 NUMBER := 0-1962.0724
1218: , p6_a25 DATE := fnd_api.g_miss_date
1219: , p6_a26 NUMBER := 0-1962.0724
1220: , p6_a27 DATE := fnd_api.g_miss_date
1221: , p6_a28 NUMBER := 0-1962.0724
1222: )
1216: , p6_a23 NUMBER := 0-1962.0724
1217: , p6_a24 NUMBER := 0-1962.0724
1218: , p6_a25 DATE := fnd_api.g_miss_date
1219: , p6_a26 NUMBER := 0-1962.0724
1220: , p6_a27 DATE := fnd_api.g_miss_date
1221: , p6_a28 NUMBER := 0-1962.0724
1222: )
1223:
1224: as