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;
130: , x_msg_data out nocopy VARCHAR2
131: , p5_a0 NUMBER := 0-1962.0724
132: , p5_a1 NUMBER := 0-1962.0724
133: , p5_a2 NUMBER := 0-1962.0724
134: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
131: , p5_a0 NUMBER := 0-1962.0724
132: , p5_a1 NUMBER := 0-1962.0724
133: , p5_a2 NUMBER := 0-1962.0724
134: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a1 NUMBER := 0-1962.0724
133: , p5_a2 NUMBER := 0-1962.0724
134: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a2 NUMBER := 0-1962.0724
134: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
144: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a20 NUMBER := 0-1962.0724
144: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
145: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a20 NUMBER := 0-1962.0724
152: , p5_a21 DATE := fnd_api.g_miss_date
145: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
146: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a20 NUMBER := 0-1962.0724
152: , p5_a21 DATE := fnd_api.g_miss_date
153: , p5_a22 NUMBER := 0-1962.0724
146: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a20 NUMBER := 0-1962.0724
152: , p5_a21 DATE := fnd_api.g_miss_date
153: , p5_a22 NUMBER := 0-1962.0724
154: , p5_a23 DATE := fnd_api.g_miss_date
148: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
149: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a20 NUMBER := 0-1962.0724
152: , p5_a21 DATE := fnd_api.g_miss_date
153: , p5_a22 NUMBER := 0-1962.0724
154: , p5_a23 DATE := fnd_api.g_miss_date
155: , p5_a24 NUMBER := 0-1962.0724
156: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
150: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a20 NUMBER := 0-1962.0724
152: , p5_a21 DATE := fnd_api.g_miss_date
153: , p5_a22 NUMBER := 0-1962.0724
154: , p5_a23 DATE := fnd_api.g_miss_date
155: , p5_a24 NUMBER := 0-1962.0724
156: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a26 NUMBER := 0-1962.0724
158: , p5_a27 DATE := fnd_api.g_miss_date
152: , p5_a21 DATE := fnd_api.g_miss_date
153: , p5_a22 NUMBER := 0-1962.0724
154: , p5_a23 DATE := fnd_api.g_miss_date
155: , p5_a24 NUMBER := 0-1962.0724
156: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a26 NUMBER := 0-1962.0724
158: , p5_a27 DATE := fnd_api.g_miss_date
159: , p5_a28 NUMBER := 0-1962.0724
160: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a23 DATE := fnd_api.g_miss_date
155: , p5_a24 NUMBER := 0-1962.0724
156: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a26 NUMBER := 0-1962.0724
158: , p5_a27 DATE := fnd_api.g_miss_date
159: , p5_a28 NUMBER := 0-1962.0724
160: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a30 NUMBER := 0-1962.0724
162: , p5_a31 NUMBER := 0-1962.0724
156: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a26 NUMBER := 0-1962.0724
158: , p5_a27 DATE := fnd_api.g_miss_date
159: , p5_a28 NUMBER := 0-1962.0724
160: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a30 NUMBER := 0-1962.0724
162: , p5_a31 NUMBER := 0-1962.0724
163: , p5_a32 NUMBER := 0-1962.0724
164: , p5_a33 NUMBER := 0-1962.0724
161: , p5_a30 NUMBER := 0-1962.0724
162: , p5_a31 NUMBER := 0-1962.0724
163: , p5_a32 NUMBER := 0-1962.0724
164: , p5_a33 NUMBER := 0-1962.0724
165: , p5_a34 DATE := fnd_api.g_miss_date
166: , p6_a0 NUMBER := 0-1962.0724
167: , p6_a1 NUMBER := 0-1962.0724
168: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p6_a3 NUMBER := 0-1962.0724
164: , p5_a33 NUMBER := 0-1962.0724
165: , p5_a34 DATE := fnd_api.g_miss_date
166: , p6_a0 NUMBER := 0-1962.0724
167: , p6_a1 NUMBER := 0-1962.0724
168: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p6_a3 NUMBER := 0-1962.0724
170: , p6_a4 NUMBER := 0-1962.0724
171: , p6_a5 NUMBER := 0-1962.0724
172: , p6_a6 NUMBER := 0-1962.0724
174: , p6_a8 NUMBER := 0-1962.0724
175: , p6_a9 NUMBER := 0-1962.0724
176: , p6_a10 NUMBER := 0-1962.0724
177: , p6_a11 NUMBER := 0-1962.0724
178: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a15 NUMBER := 0-1962.0724
182: , p6_a16 NUMBER := 0-1962.0724
175: , p6_a9 NUMBER := 0-1962.0724
176: , p6_a10 NUMBER := 0-1962.0724
177: , p6_a11 NUMBER := 0-1962.0724
178: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a15 NUMBER := 0-1962.0724
182: , p6_a16 NUMBER := 0-1962.0724
183: , p6_a17 NUMBER := 0-1962.0724
176: , p6_a10 NUMBER := 0-1962.0724
177: , p6_a11 NUMBER := 0-1962.0724
178: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
179: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a15 NUMBER := 0-1962.0724
182: , p6_a16 NUMBER := 0-1962.0724
183: , p6_a17 NUMBER := 0-1962.0724
184: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a15 NUMBER := 0-1962.0724
182: , p6_a16 NUMBER := 0-1962.0724
183: , p6_a17 NUMBER := 0-1962.0724
184: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a19 NUMBER := 0-1962.0724
186: , p6_a20 NUMBER := 0-1962.0724
187: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a17 NUMBER := 0-1962.0724
184: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a19 NUMBER := 0-1962.0724
186: , p6_a20 NUMBER := 0-1962.0724
187: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p6_a25 DATE := fnd_api.g_miss_date
184: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a19 NUMBER := 0-1962.0724
186: , p6_a20 NUMBER := 0-1962.0724
187: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p6_a25 DATE := fnd_api.g_miss_date
192: , p6_a26 DATE := fnd_api.g_miss_date
185: , p6_a19 NUMBER := 0-1962.0724
186: , p6_a20 NUMBER := 0-1962.0724
187: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p6_a25 DATE := fnd_api.g_miss_date
192: , p6_a26 DATE := fnd_api.g_miss_date
193: , p6_a27 DATE := fnd_api.g_miss_date
186: , p6_a20 NUMBER := 0-1962.0724
187: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p6_a25 DATE := fnd_api.g_miss_date
192: , p6_a26 DATE := fnd_api.g_miss_date
193: , p6_a27 DATE := fnd_api.g_miss_date
194: , p6_a28 NUMBER := 0-1962.0724
187: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p6_a25 DATE := fnd_api.g_miss_date
192: , p6_a26 DATE := fnd_api.g_miss_date
193: , p6_a27 DATE := fnd_api.g_miss_date
194: , p6_a28 NUMBER := 0-1962.0724
195: , p6_a29 NUMBER := 0-1962.0724
188: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p6_a25 DATE := fnd_api.g_miss_date
192: , p6_a26 DATE := fnd_api.g_miss_date
193: , p6_a27 DATE := fnd_api.g_miss_date
194: , p6_a28 NUMBER := 0-1962.0724
195: , p6_a29 NUMBER := 0-1962.0724
196: , p6_a30 NUMBER := 0-1962.0724
189: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p6_a25 DATE := fnd_api.g_miss_date
192: , p6_a26 DATE := fnd_api.g_miss_date
193: , p6_a27 DATE := fnd_api.g_miss_date
194: , p6_a28 NUMBER := 0-1962.0724
195: , p6_a29 NUMBER := 0-1962.0724
196: , p6_a30 NUMBER := 0-1962.0724
197: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
193: , p6_a27 DATE := fnd_api.g_miss_date
194: , p6_a28 NUMBER := 0-1962.0724
195: , p6_a29 NUMBER := 0-1962.0724
196: , p6_a30 NUMBER := 0-1962.0724
197: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p6_a32 NUMBER := 0-1962.0724
199: , p6_a33 NUMBER := 0-1962.0724
200: , p6_a34 NUMBER := 0-1962.0724
201: , p6_a35 NUMBER := 0-1962.0724
198: , p6_a32 NUMBER := 0-1962.0724
199: , p6_a33 NUMBER := 0-1962.0724
200: , p6_a34 NUMBER := 0-1962.0724
201: , p6_a35 NUMBER := 0-1962.0724
202: , p6_a36 DATE := fnd_api.g_miss_date
203: , p6_a37 NUMBER := 0-1962.0724
204: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
205: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
200: , p6_a34 NUMBER := 0-1962.0724
201: , p6_a35 NUMBER := 0-1962.0724
202: , p6_a36 DATE := fnd_api.g_miss_date
203: , p6_a37 NUMBER := 0-1962.0724
204: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
205: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
201: , p6_a35 NUMBER := 0-1962.0724
202: , p6_a36 DATE := fnd_api.g_miss_date
203: , p6_a37 NUMBER := 0-1962.0724
204: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
205: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
202: , p6_a36 DATE := fnd_api.g_miss_date
203: , p6_a37 NUMBER := 0-1962.0724
204: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
205: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
203: , p6_a37 NUMBER := 0-1962.0724
204: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
205: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
204: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
205: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
205: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
206: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
206: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
207: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
207: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
208: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
208: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
209: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
209: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
210: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a51 VARCHAR2 := fnd_api.g_miss_char
210: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
211: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a52 VARCHAR2 := fnd_api.g_miss_char
211: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a53 VARCHAR2 := fnd_api.g_miss_char
212: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p6_a54 NUMBER := 0-1962.0724
213: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p6_a54 NUMBER := 0-1962.0724
221: , p6_a55 DATE := fnd_api.g_miss_date
214: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p6_a54 NUMBER := 0-1962.0724
221: , p6_a55 DATE := fnd_api.g_miss_date
222: , p6_a56 NUMBER := 0-1962.0724
215: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p6_a54 NUMBER := 0-1962.0724
221: , p6_a55 DATE := fnd_api.g_miss_date
222: , p6_a56 NUMBER := 0-1962.0724
223: , p6_a57 DATE := fnd_api.g_miss_date
217: , p6_a51 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a52 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p6_a54 NUMBER := 0-1962.0724
221: , p6_a55 DATE := fnd_api.g_miss_date
222: , p6_a56 NUMBER := 0-1962.0724
223: , p6_a57 DATE := fnd_api.g_miss_date
224: , p6_a58 NUMBER := 0-1962.0724
225: , p6_a59 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a53 VARCHAR2 := fnd_api.g_miss_char
220: , p6_a54 NUMBER := 0-1962.0724
221: , p6_a55 DATE := fnd_api.g_miss_date
222: , p6_a56 NUMBER := 0-1962.0724
223: , p6_a57 DATE := fnd_api.g_miss_date
224: , p6_a58 NUMBER := 0-1962.0724
225: , p6_a59 VARCHAR2 := fnd_api.g_miss_char
226: , p6_a60 NUMBER := 0-1962.0724
227: , p6_a61 NUMBER := 0-1962.0724
221: , p6_a55 DATE := fnd_api.g_miss_date
222: , p6_a56 NUMBER := 0-1962.0724
223: , p6_a57 DATE := fnd_api.g_miss_date
224: , p6_a58 NUMBER := 0-1962.0724
225: , p6_a59 VARCHAR2 := fnd_api.g_miss_char
226: , p6_a60 NUMBER := 0-1962.0724
227: , p6_a61 NUMBER := 0-1962.0724
228: , p6_a62 NUMBER := 0-1962.0724
229: , p6_a63 NUMBER := 0-1962.0724
231: , p6_a65 NUMBER := 0-1962.0724
232: , p6_a66 NUMBER := 0-1962.0724
233: , p6_a67 NUMBER := 0-1962.0724
234: , p6_a68 NUMBER := 0-1962.0724
235: , p6_a69 DATE := fnd_api.g_miss_date
236: , p6_a70 NUMBER := 0-1962.0724
237: , p6_a71 NUMBER := 0-1962.0724
238: , p6_a72 NUMBER := 0-1962.0724
239: , p6_a73 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a69 DATE := fnd_api.g_miss_date
236: , p6_a70 NUMBER := 0-1962.0724
237: , p6_a71 NUMBER := 0-1962.0724
238: , p6_a72 NUMBER := 0-1962.0724
239: , p6_a73 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a74 NUMBER := 0-1962.0724
241: , p6_a75 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a76 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a77 NUMBER := 0-1962.0724
237: , p6_a71 NUMBER := 0-1962.0724
238: , p6_a72 NUMBER := 0-1962.0724
239: , p6_a73 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a74 NUMBER := 0-1962.0724
241: , p6_a75 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a76 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a77 NUMBER := 0-1962.0724
244: , p6_a78 DATE := fnd_api.g_miss_date
245: , p6_a79 NUMBER := 0-1962.0724
238: , p6_a72 NUMBER := 0-1962.0724
239: , p6_a73 VARCHAR2 := fnd_api.g_miss_char
240: , p6_a74 NUMBER := 0-1962.0724
241: , p6_a75 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a76 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a77 NUMBER := 0-1962.0724
244: , p6_a78 DATE := fnd_api.g_miss_date
245: , p6_a79 NUMBER := 0-1962.0724
246: , p6_a80 NUMBER := 0-1962.0724
240: , p6_a74 NUMBER := 0-1962.0724
241: , p6_a75 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a76 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a77 NUMBER := 0-1962.0724
244: , p6_a78 DATE := fnd_api.g_miss_date
245: , p6_a79 NUMBER := 0-1962.0724
246: , p6_a80 NUMBER := 0-1962.0724
247: , p6_a81 NUMBER := 0-1962.0724
248: )
681: , x_msg_count out nocopy NUMBER
682: , x_msg_data out nocopy VARCHAR2
683: , p5_a0 NUMBER := 0-1962.0724
684: , p5_a1 NUMBER := 0-1962.0724
685: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
686: , p5_a3 NUMBER := 0-1962.0724
687: , p5_a4 NUMBER := 0-1962.0724
688: , p5_a5 DATE := fnd_api.g_miss_date
689: , p5_a6 NUMBER := 0-1962.0724
684: , p5_a1 NUMBER := 0-1962.0724
685: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
686: , p5_a3 NUMBER := 0-1962.0724
687: , p5_a4 NUMBER := 0-1962.0724
688: , p5_a5 DATE := fnd_api.g_miss_date
689: , p5_a6 NUMBER := 0-1962.0724
690: )
691:
692: as