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;
207: , p6_a27 out nocopy NUMBER
208: , p5_a0 NUMBER := 0-1962.0724
209: , p5_a1 NUMBER := 0-1962.0724
210: , p5_a2 NUMBER := 0-1962.0724
211: , p5_a3 DATE := fnd_api.g_miss_date
212: , p5_a4 DATE := fnd_api.g_miss_date
213: , p5_a5 NUMBER := 0-1962.0724
214: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a0 NUMBER := 0-1962.0724
209: , p5_a1 NUMBER := 0-1962.0724
210: , p5_a2 NUMBER := 0-1962.0724
211: , p5_a3 DATE := fnd_api.g_miss_date
212: , p5_a4 DATE := fnd_api.g_miss_date
213: , p5_a5 NUMBER := 0-1962.0724
214: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
210: , p5_a2 NUMBER := 0-1962.0724
211: , p5_a3 DATE := fnd_api.g_miss_date
212: , p5_a4 DATE := fnd_api.g_miss_date
213: , p5_a5 NUMBER := 0-1962.0724
214: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a3 DATE := fnd_api.g_miss_date
212: , p5_a4 DATE := fnd_api.g_miss_date
213: , p5_a5 NUMBER := 0-1962.0724
214: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a4 DATE := fnd_api.g_miss_date
213: , p5_a5 NUMBER := 0-1962.0724
214: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a5 NUMBER := 0-1962.0724
214: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
214: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
216: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
220: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
220: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
221: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a23 NUMBER := 0-1962.0724
224: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a23 NUMBER := 0-1962.0724
232: , p5_a24 DATE := fnd_api.g_miss_date
225: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a23 NUMBER := 0-1962.0724
232: , p5_a24 DATE := fnd_api.g_miss_date
233: , p5_a25 NUMBER := 0-1962.0724
226: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a23 NUMBER := 0-1962.0724
232: , p5_a24 DATE := fnd_api.g_miss_date
233: , p5_a25 NUMBER := 0-1962.0724
234: , p5_a26 DATE := fnd_api.g_miss_date
228: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
230: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a23 NUMBER := 0-1962.0724
232: , p5_a24 DATE := fnd_api.g_miss_date
233: , p5_a25 NUMBER := 0-1962.0724
234: , p5_a26 DATE := fnd_api.g_miss_date
235: , p5_a27 NUMBER := 0-1962.0724
236: )
230: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a23 NUMBER := 0-1962.0724
232: , p5_a24 DATE := fnd_api.g_miss_date
233: , p5_a25 NUMBER := 0-1962.0724
234: , p5_a26 DATE := fnd_api.g_miss_date
235: , p5_a27 NUMBER := 0-1962.0724
236: )
237:
238: as
422: , x_msg_data out nocopy VARCHAR2
423: , p5_a0 NUMBER := 0-1962.0724
424: , p5_a1 NUMBER := 0-1962.0724
425: , p5_a2 NUMBER := 0-1962.0724
426: , p5_a3 DATE := fnd_api.g_miss_date
427: , p5_a4 DATE := fnd_api.g_miss_date
428: , p5_a5 NUMBER := 0-1962.0724
429: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a0 NUMBER := 0-1962.0724
424: , p5_a1 NUMBER := 0-1962.0724
425: , p5_a2 NUMBER := 0-1962.0724
426: , p5_a3 DATE := fnd_api.g_miss_date
427: , p5_a4 DATE := fnd_api.g_miss_date
428: , p5_a5 NUMBER := 0-1962.0724
429: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a2 NUMBER := 0-1962.0724
426: , p5_a3 DATE := fnd_api.g_miss_date
427: , p5_a4 DATE := fnd_api.g_miss_date
428: , p5_a5 NUMBER := 0-1962.0724
429: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a3 DATE := fnd_api.g_miss_date
427: , p5_a4 DATE := fnd_api.g_miss_date
428: , p5_a5 NUMBER := 0-1962.0724
429: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a4 DATE := fnd_api.g_miss_date
428: , p5_a5 NUMBER := 0-1962.0724
429: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
428: , p5_a5 NUMBER := 0-1962.0724
429: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a23 NUMBER := 0-1962.0724
439: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a23 NUMBER := 0-1962.0724
447: , p5_a24 DATE := fnd_api.g_miss_date
440: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a23 NUMBER := 0-1962.0724
447: , p5_a24 DATE := fnd_api.g_miss_date
448: , p5_a25 NUMBER := 0-1962.0724
441: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a23 NUMBER := 0-1962.0724
447: , p5_a24 DATE := fnd_api.g_miss_date
448: , p5_a25 NUMBER := 0-1962.0724
449: , p5_a26 DATE := fnd_api.g_miss_date
443: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a23 NUMBER := 0-1962.0724
447: , p5_a24 DATE := fnd_api.g_miss_date
448: , p5_a25 NUMBER := 0-1962.0724
449: , p5_a26 DATE := fnd_api.g_miss_date
450: , p5_a27 NUMBER := 0-1962.0724
451: )
445: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a23 NUMBER := 0-1962.0724
447: , p5_a24 DATE := fnd_api.g_miss_date
448: , p5_a25 NUMBER := 0-1962.0724
449: , p5_a26 DATE := fnd_api.g_miss_date
450: , p5_a27 NUMBER := 0-1962.0724
451: )
452:
453: as
694: , p6_a27 out nocopy NUMBER
695: , p5_a0 NUMBER := 0-1962.0724
696: , p5_a1 NUMBER := 0-1962.0724
697: , p5_a2 NUMBER := 0-1962.0724
698: , p5_a3 DATE := fnd_api.g_miss_date
699: , p5_a4 DATE := fnd_api.g_miss_date
700: , p5_a5 NUMBER := 0-1962.0724
701: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
695: , p5_a0 NUMBER := 0-1962.0724
696: , p5_a1 NUMBER := 0-1962.0724
697: , p5_a2 NUMBER := 0-1962.0724
698: , p5_a3 DATE := fnd_api.g_miss_date
699: , p5_a4 DATE := fnd_api.g_miss_date
700: , p5_a5 NUMBER := 0-1962.0724
701: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
697: , p5_a2 NUMBER := 0-1962.0724
698: , p5_a3 DATE := fnd_api.g_miss_date
699: , p5_a4 DATE := fnd_api.g_miss_date
700: , p5_a5 NUMBER := 0-1962.0724
701: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
698: , p5_a3 DATE := fnd_api.g_miss_date
699: , p5_a4 DATE := fnd_api.g_miss_date
700: , p5_a5 NUMBER := 0-1962.0724
701: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
699: , p5_a4 DATE := fnd_api.g_miss_date
700: , p5_a5 NUMBER := 0-1962.0724
701: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
700: , p5_a5 NUMBER := 0-1962.0724
701: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
701: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a23 NUMBER := 0-1962.0724
711: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a23 NUMBER := 0-1962.0724
719: , p5_a24 DATE := fnd_api.g_miss_date
712: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a23 NUMBER := 0-1962.0724
719: , p5_a24 DATE := fnd_api.g_miss_date
720: , p5_a25 NUMBER := 0-1962.0724
713: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a23 NUMBER := 0-1962.0724
719: , p5_a24 DATE := fnd_api.g_miss_date
720: , p5_a25 NUMBER := 0-1962.0724
721: , p5_a26 DATE := fnd_api.g_miss_date
715: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a23 NUMBER := 0-1962.0724
719: , p5_a24 DATE := fnd_api.g_miss_date
720: , p5_a25 NUMBER := 0-1962.0724
721: , p5_a26 DATE := fnd_api.g_miss_date
722: , p5_a27 NUMBER := 0-1962.0724
723: )
717: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a23 NUMBER := 0-1962.0724
719: , p5_a24 DATE := fnd_api.g_miss_date
720: , p5_a25 NUMBER := 0-1962.0724
721: , p5_a26 DATE := fnd_api.g_miss_date
722: , p5_a27 NUMBER := 0-1962.0724
723: )
724:
725: as
909: , x_msg_data out nocopy VARCHAR2
910: , p5_a0 NUMBER := 0-1962.0724
911: , p5_a1 NUMBER := 0-1962.0724
912: , p5_a2 NUMBER := 0-1962.0724
913: , p5_a3 DATE := fnd_api.g_miss_date
914: , p5_a4 DATE := fnd_api.g_miss_date
915: , p5_a5 NUMBER := 0-1962.0724
916: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a0 NUMBER := 0-1962.0724
911: , p5_a1 NUMBER := 0-1962.0724
912: , p5_a2 NUMBER := 0-1962.0724
913: , p5_a3 DATE := fnd_api.g_miss_date
914: , p5_a4 DATE := fnd_api.g_miss_date
915: , p5_a5 NUMBER := 0-1962.0724
916: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a2 NUMBER := 0-1962.0724
913: , p5_a3 DATE := fnd_api.g_miss_date
914: , p5_a4 DATE := fnd_api.g_miss_date
915: , p5_a5 NUMBER := 0-1962.0724
916: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a3 DATE := fnd_api.g_miss_date
914: , p5_a4 DATE := fnd_api.g_miss_date
915: , p5_a5 NUMBER := 0-1962.0724
916: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a4 DATE := fnd_api.g_miss_date
915: , p5_a5 NUMBER := 0-1962.0724
916: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a5 NUMBER := 0-1962.0724
916: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a23 NUMBER := 0-1962.0724
926: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a23 NUMBER := 0-1962.0724
934: , p5_a24 DATE := fnd_api.g_miss_date
927: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a23 NUMBER := 0-1962.0724
934: , p5_a24 DATE := fnd_api.g_miss_date
935: , p5_a25 NUMBER := 0-1962.0724
928: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a23 NUMBER := 0-1962.0724
934: , p5_a24 DATE := fnd_api.g_miss_date
935: , p5_a25 NUMBER := 0-1962.0724
936: , p5_a26 DATE := fnd_api.g_miss_date
930: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a23 NUMBER := 0-1962.0724
934: , p5_a24 DATE := fnd_api.g_miss_date
935: , p5_a25 NUMBER := 0-1962.0724
936: , p5_a26 DATE := fnd_api.g_miss_date
937: , p5_a27 NUMBER := 0-1962.0724
938: )
932: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a23 NUMBER := 0-1962.0724
934: , p5_a24 DATE := fnd_api.g_miss_date
935: , p5_a25 NUMBER := 0-1962.0724
936: , p5_a26 DATE := fnd_api.g_miss_date
937: , p5_a27 NUMBER := 0-1962.0724
938: )
939:
940: as
1092: , x_msg_data out nocopy VARCHAR2
1093: , p5_a0 NUMBER := 0-1962.0724
1094: , p5_a1 NUMBER := 0-1962.0724
1095: , p5_a2 NUMBER := 0-1962.0724
1096: , p5_a3 DATE := fnd_api.g_miss_date
1097: , p5_a4 DATE := fnd_api.g_miss_date
1098: , p5_a5 NUMBER := 0-1962.0724
1099: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a0 NUMBER := 0-1962.0724
1094: , p5_a1 NUMBER := 0-1962.0724
1095: , p5_a2 NUMBER := 0-1962.0724
1096: , p5_a3 DATE := fnd_api.g_miss_date
1097: , p5_a4 DATE := fnd_api.g_miss_date
1098: , p5_a5 NUMBER := 0-1962.0724
1099: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a2 NUMBER := 0-1962.0724
1096: , p5_a3 DATE := fnd_api.g_miss_date
1097: , p5_a4 DATE := fnd_api.g_miss_date
1098: , p5_a5 NUMBER := 0-1962.0724
1099: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a3 DATE := fnd_api.g_miss_date
1097: , p5_a4 DATE := fnd_api.g_miss_date
1098: , p5_a5 NUMBER := 0-1962.0724
1099: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a4 DATE := fnd_api.g_miss_date
1098: , p5_a5 NUMBER := 0-1962.0724
1099: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a5 NUMBER := 0-1962.0724
1099: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a23 NUMBER := 0-1962.0724
1109: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a23 NUMBER := 0-1962.0724
1117: , p5_a24 DATE := fnd_api.g_miss_date
1110: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a23 NUMBER := 0-1962.0724
1117: , p5_a24 DATE := fnd_api.g_miss_date
1118: , p5_a25 NUMBER := 0-1962.0724
1111: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a23 NUMBER := 0-1962.0724
1117: , p5_a24 DATE := fnd_api.g_miss_date
1118: , p5_a25 NUMBER := 0-1962.0724
1119: , p5_a26 DATE := fnd_api.g_miss_date
1113: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a23 NUMBER := 0-1962.0724
1117: , p5_a24 DATE := fnd_api.g_miss_date
1118: , p5_a25 NUMBER := 0-1962.0724
1119: , p5_a26 DATE := fnd_api.g_miss_date
1120: , p5_a27 NUMBER := 0-1962.0724
1121: )
1115: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a23 NUMBER := 0-1962.0724
1117: , p5_a24 DATE := fnd_api.g_miss_date
1118: , p5_a25 NUMBER := 0-1962.0724
1119: , p5_a26 DATE := fnd_api.g_miss_date
1120: , p5_a27 NUMBER := 0-1962.0724
1121: )
1122:
1123: as