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;
171: , x_return_status out nocopy VARCHAR2
172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2
174: , p2_a0 NUMBER := 0-1962.0724
175: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
176: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
177: , p2_a3 NUMBER := 0-1962.0724
178: , p2_a4 DATE := fnd_api.g_miss_date
179: , p2_a5 DATE := fnd_api.g_miss_date
172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2
174: , p2_a0 NUMBER := 0-1962.0724
175: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
176: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
177: , p2_a3 NUMBER := 0-1962.0724
178: , p2_a4 DATE := fnd_api.g_miss_date
179: , p2_a5 DATE := fnd_api.g_miss_date
180: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
174: , p2_a0 NUMBER := 0-1962.0724
175: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
176: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
177: , p2_a3 NUMBER := 0-1962.0724
178: , p2_a4 DATE := fnd_api.g_miss_date
179: , p2_a5 DATE := fnd_api.g_miss_date
180: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
181: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
182: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
175: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
176: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
177: , p2_a3 NUMBER := 0-1962.0724
178: , p2_a4 DATE := fnd_api.g_miss_date
179: , p2_a5 DATE := fnd_api.g_miss_date
180: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
181: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
182: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
183: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
176: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
177: , p2_a3 NUMBER := 0-1962.0724
178: , p2_a4 DATE := fnd_api.g_miss_date
179: , p2_a5 DATE := fnd_api.g_miss_date
180: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
181: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
182: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
183: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
184: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
177: , p2_a3 NUMBER := 0-1962.0724
178: , p2_a4 DATE := fnd_api.g_miss_date
179: , p2_a5 DATE := fnd_api.g_miss_date
180: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
181: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
182: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
183: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
184: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
185: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
178: , p2_a4 DATE := fnd_api.g_miss_date
179: , p2_a5 DATE := fnd_api.g_miss_date
180: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
181: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
182: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
183: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
184: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
185: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
186: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
179: , p2_a5 DATE := fnd_api.g_miss_date
180: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
181: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
182: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
183: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
184: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
185: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
186: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
187: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
180: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
181: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
182: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
183: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
184: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
185: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
186: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
187: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
188: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
181: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
182: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
183: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
184: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
185: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
186: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
187: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
188: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
189: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
182: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
183: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
184: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
185: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
186: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
187: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
188: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
189: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
190: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
183: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
184: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
185: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
186: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
187: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
188: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
189: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
190: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
191: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
185: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
186: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
187: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
188: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
189: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
190: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
191: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
192: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
186: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
187: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
188: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
189: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
190: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
191: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
192: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
193: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
187: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
188: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
189: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
190: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
191: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
192: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
193: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
194: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
188: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
189: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
190: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
191: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
192: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
193: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
194: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
195: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
189: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
190: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
191: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
192: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
193: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
194: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
195: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
196: )
189: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
190: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
191: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
192: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
193: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
194: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
195: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
196: )
197:
190: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
191: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
192: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
193: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
194: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
195: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
196: )
197:
198: as
191: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
192: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
193: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
194: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
195: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
196: )
197:
198: as
199: ddp_cu_rec eam_construction_unit_pub.cu_rec;
275: , x_return_status out nocopy VARCHAR2
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2
278: , p2_a0 NUMBER := 0-1962.0724
279: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
280: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
281: , p2_a3 NUMBER := 0-1962.0724
282: , p2_a4 DATE := fnd_api.g_miss_date
283: , p2_a5 DATE := fnd_api.g_miss_date
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2
278: , p2_a0 NUMBER := 0-1962.0724
279: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
280: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
281: , p2_a3 NUMBER := 0-1962.0724
282: , p2_a4 DATE := fnd_api.g_miss_date
283: , p2_a5 DATE := fnd_api.g_miss_date
284: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
278: , p2_a0 NUMBER := 0-1962.0724
279: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
280: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
281: , p2_a3 NUMBER := 0-1962.0724
282: , p2_a4 DATE := fnd_api.g_miss_date
283: , p2_a5 DATE := fnd_api.g_miss_date
284: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
285: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
279: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
280: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
281: , p2_a3 NUMBER := 0-1962.0724
282: , p2_a4 DATE := fnd_api.g_miss_date
283: , p2_a5 DATE := fnd_api.g_miss_date
284: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
285: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
280: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
281: , p2_a3 NUMBER := 0-1962.0724
282: , p2_a4 DATE := fnd_api.g_miss_date
283: , p2_a5 DATE := fnd_api.g_miss_date
284: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
285: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
281: , p2_a3 NUMBER := 0-1962.0724
282: , p2_a4 DATE := fnd_api.g_miss_date
283: , p2_a5 DATE := fnd_api.g_miss_date
284: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
285: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
282: , p2_a4 DATE := fnd_api.g_miss_date
283: , p2_a5 DATE := fnd_api.g_miss_date
284: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
285: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
290: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
283: , p2_a5 DATE := fnd_api.g_miss_date
284: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
285: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
290: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
284: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
285: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
290: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
292: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
285: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
290: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
292: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
286: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
290: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
292: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
294: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
287: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
290: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
292: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
294: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
295: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
288: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
290: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
292: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
294: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
295: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
296: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
289: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
290: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
292: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
294: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
295: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
296: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
297: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
290: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
292: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
294: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
295: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
296: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
297: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
298: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
291: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
292: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
294: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
295: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
296: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
297: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
298: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
299: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
292: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
294: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
295: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
296: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
297: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
298: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
299: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
300: )
293: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
294: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
295: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
296: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
297: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
298: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
299: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
300: )
301:
294: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
295: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
296: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
297: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
298: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
299: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
300: )
301:
302: as
295: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
296: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
297: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
298: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
299: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
300: )
301:
302: as
303: ddp_cu_rec eam_construction_unit_pub.cu_rec;
380: , x_return_status out nocopy VARCHAR2
381: , x_msg_count out nocopy NUMBER
382: , x_msg_data out nocopy VARCHAR2
383: , p2_a0 NUMBER := 0-1962.0724
384: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a3 NUMBER := 0-1962.0724
387: , p2_a4 DATE := fnd_api.g_miss_date
388: , p2_a5 DATE := fnd_api.g_miss_date
381: , x_msg_count out nocopy NUMBER
382: , x_msg_data out nocopy VARCHAR2
383: , p2_a0 NUMBER := 0-1962.0724
384: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a3 NUMBER := 0-1962.0724
387: , p2_a4 DATE := fnd_api.g_miss_date
388: , p2_a5 DATE := fnd_api.g_miss_date
389: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
383: , p2_a0 NUMBER := 0-1962.0724
384: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a3 NUMBER := 0-1962.0724
387: , p2_a4 DATE := fnd_api.g_miss_date
388: , p2_a5 DATE := fnd_api.g_miss_date
389: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
384: , p2_a1 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a3 NUMBER := 0-1962.0724
387: , p2_a4 DATE := fnd_api.g_miss_date
388: , p2_a5 DATE := fnd_api.g_miss_date
389: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a2 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a3 NUMBER := 0-1962.0724
387: , p2_a4 DATE := fnd_api.g_miss_date
388: , p2_a5 DATE := fnd_api.g_miss_date
389: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a3 NUMBER := 0-1962.0724
387: , p2_a4 DATE := fnd_api.g_miss_date
388: , p2_a5 DATE := fnd_api.g_miss_date
389: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
394: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
387: , p2_a4 DATE := fnd_api.g_miss_date
388: , p2_a5 DATE := fnd_api.g_miss_date
389: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
394: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
388: , p2_a5 DATE := fnd_api.g_miss_date
389: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
394: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
389: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
394: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
394: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
398: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
394: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
398: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
399: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
394: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
398: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
399: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
400: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
394: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
398: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
399: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
400: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
401: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
394: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
398: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
399: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
400: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
401: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
402: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
395: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
396: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
398: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
399: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
400: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
401: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
402: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
403: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
396: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
397: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
398: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
399: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
400: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
401: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
402: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
403: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
404: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
397: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
398: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
399: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
400: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
401: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
402: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
403: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
404: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
405: )
398: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
399: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
400: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
401: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
402: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
403: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
404: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
405: )
406:
399: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
400: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
401: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
402: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
403: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
404: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
405: )
406:
407: as
400: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
401: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
402: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
403: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
404: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
405: )
406:
407: as
408: ddp_cu_rec eam_construction_unit_pub.cu_rec;