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;
267: , p6_a39 out nocopy NUMBER
268: , p5_a0 NUMBER := 0-1962.0724
269: , p5_a1 NUMBER := 0-1962.0724
270: , p5_a2 NUMBER := 0-1962.0724
271: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a4 NUMBER := 0-1962.0724
273: , p5_a5 NUMBER := 0-1962.0724
274: , p5_a6 NUMBER := 0-1962.0724
275: , p5_a7 NUMBER := 0-1962.0724
276: , p5_a8 NUMBER := 0-1962.0724
277: , p5_a9 NUMBER := 0-1962.0724
278: , p5_a10 NUMBER := 0-1962.0724
279: , p5_a11 NUMBER := 0-1962.0724
280: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a13 NUMBER := 0-1962.0724
282: , p5_a14 NUMBER := 0-1962.0724
283: , p5_a15 NUMBER := 0-1962.0724
284: , p5_a16 NUMBER := 0-1962.0724
282: , p5_a14 NUMBER := 0-1962.0724
283: , p5_a15 NUMBER := 0-1962.0724
284: , p5_a16 NUMBER := 0-1962.0724
285: , p5_a17 NUMBER := 0-1962.0724
286: , p5_a18 DATE := fnd_api.g_miss_date
287: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a15 NUMBER := 0-1962.0724
284: , p5_a16 NUMBER := 0-1962.0724
285: , p5_a17 NUMBER := 0-1962.0724
286: , p5_a18 DATE := fnd_api.g_miss_date
287: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a16 NUMBER := 0-1962.0724
285: , p5_a17 NUMBER := 0-1962.0724
286: , p5_a18 DATE := fnd_api.g_miss_date
287: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a17 NUMBER := 0-1962.0724
286: , p5_a18 DATE := fnd_api.g_miss_date
287: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a18 DATE := fnd_api.g_miss_date
287: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a35 NUMBER := 0-1962.0724
296: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a35 NUMBER := 0-1962.0724
304: , p5_a36 DATE := fnd_api.g_miss_date
297: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a35 NUMBER := 0-1962.0724
304: , p5_a36 DATE := fnd_api.g_miss_date
305: , p5_a37 NUMBER := 0-1962.0724
298: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a35 NUMBER := 0-1962.0724
304: , p5_a36 DATE := fnd_api.g_miss_date
305: , p5_a37 NUMBER := 0-1962.0724
306: , p5_a38 DATE := fnd_api.g_miss_date
300: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a35 NUMBER := 0-1962.0724
304: , p5_a36 DATE := fnd_api.g_miss_date
305: , p5_a37 NUMBER := 0-1962.0724
306: , p5_a38 DATE := fnd_api.g_miss_date
307: , p5_a39 NUMBER := 0-1962.0724
308: )
302: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a35 NUMBER := 0-1962.0724
304: , p5_a36 DATE := fnd_api.g_miss_date
305: , p5_a37 NUMBER := 0-1962.0724
306: , p5_a38 DATE := fnd_api.g_miss_date
307: , p5_a39 NUMBER := 0-1962.0724
308: )
309:
310: as
542: , x_msg_data out nocopy VARCHAR2
543: , p5_a0 NUMBER := 0-1962.0724
544: , p5_a1 NUMBER := 0-1962.0724
545: , p5_a2 NUMBER := 0-1962.0724
546: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a4 NUMBER := 0-1962.0724
548: , p5_a5 NUMBER := 0-1962.0724
549: , p5_a6 NUMBER := 0-1962.0724
550: , p5_a7 NUMBER := 0-1962.0724
551: , p5_a8 NUMBER := 0-1962.0724
552: , p5_a9 NUMBER := 0-1962.0724
553: , p5_a10 NUMBER := 0-1962.0724
554: , p5_a11 NUMBER := 0-1962.0724
555: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a13 NUMBER := 0-1962.0724
557: , p5_a14 NUMBER := 0-1962.0724
558: , p5_a15 NUMBER := 0-1962.0724
559: , p5_a16 NUMBER := 0-1962.0724
557: , p5_a14 NUMBER := 0-1962.0724
558: , p5_a15 NUMBER := 0-1962.0724
559: , p5_a16 NUMBER := 0-1962.0724
560: , p5_a17 NUMBER := 0-1962.0724
561: , p5_a18 DATE := fnd_api.g_miss_date
562: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
565: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a15 NUMBER := 0-1962.0724
559: , p5_a16 NUMBER := 0-1962.0724
560: , p5_a17 NUMBER := 0-1962.0724
561: , p5_a18 DATE := fnd_api.g_miss_date
562: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
565: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a16 NUMBER := 0-1962.0724
560: , p5_a17 NUMBER := 0-1962.0724
561: , p5_a18 DATE := fnd_api.g_miss_date
562: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
565: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a17 NUMBER := 0-1962.0724
561: , p5_a18 DATE := fnd_api.g_miss_date
562: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
565: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
561: , p5_a18 DATE := fnd_api.g_miss_date
562: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
565: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
565: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
565: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
565: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
565: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
568: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a35 NUMBER := 0-1962.0724
571: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a35 NUMBER := 0-1962.0724
579: , p5_a36 DATE := fnd_api.g_miss_date
572: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a35 NUMBER := 0-1962.0724
579: , p5_a36 DATE := fnd_api.g_miss_date
580: , p5_a37 NUMBER := 0-1962.0724
573: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a35 NUMBER := 0-1962.0724
579: , p5_a36 DATE := fnd_api.g_miss_date
580: , p5_a37 NUMBER := 0-1962.0724
581: , p5_a38 DATE := fnd_api.g_miss_date
575: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a35 NUMBER := 0-1962.0724
579: , p5_a36 DATE := fnd_api.g_miss_date
580: , p5_a37 NUMBER := 0-1962.0724
581: , p5_a38 DATE := fnd_api.g_miss_date
582: , p5_a39 NUMBER := 0-1962.0724
583: )
577: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a35 NUMBER := 0-1962.0724
579: , p5_a36 DATE := fnd_api.g_miss_date
580: , p5_a37 NUMBER := 0-1962.0724
581: , p5_a38 DATE := fnd_api.g_miss_date
582: , p5_a39 NUMBER := 0-1962.0724
583: )
584:
585: as
898: , p6_a39 out nocopy NUMBER
899: , p5_a0 NUMBER := 0-1962.0724
900: , p5_a1 NUMBER := 0-1962.0724
901: , p5_a2 NUMBER := 0-1962.0724
902: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
903: , p5_a4 NUMBER := 0-1962.0724
904: , p5_a5 NUMBER := 0-1962.0724
905: , p5_a6 NUMBER := 0-1962.0724
906: , p5_a7 NUMBER := 0-1962.0724
907: , p5_a8 NUMBER := 0-1962.0724
908: , p5_a9 NUMBER := 0-1962.0724
909: , p5_a10 NUMBER := 0-1962.0724
910: , p5_a11 NUMBER := 0-1962.0724
911: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a13 NUMBER := 0-1962.0724
913: , p5_a14 NUMBER := 0-1962.0724
914: , p5_a15 NUMBER := 0-1962.0724
915: , p5_a16 NUMBER := 0-1962.0724
913: , p5_a14 NUMBER := 0-1962.0724
914: , p5_a15 NUMBER := 0-1962.0724
915: , p5_a16 NUMBER := 0-1962.0724
916: , p5_a17 NUMBER := 0-1962.0724
917: , p5_a18 DATE := fnd_api.g_miss_date
918: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a15 NUMBER := 0-1962.0724
915: , p5_a16 NUMBER := 0-1962.0724
916: , p5_a17 NUMBER := 0-1962.0724
917: , p5_a18 DATE := fnd_api.g_miss_date
918: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a16 NUMBER := 0-1962.0724
916: , p5_a17 NUMBER := 0-1962.0724
917: , p5_a18 DATE := fnd_api.g_miss_date
918: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a17 NUMBER := 0-1962.0724
917: , p5_a18 DATE := fnd_api.g_miss_date
918: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a18 DATE := fnd_api.g_miss_date
918: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
925: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
926: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
934: , p5_a35 NUMBER := 0-1962.0724
927: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
928: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
934: , p5_a35 NUMBER := 0-1962.0724
935: , p5_a36 DATE := fnd_api.g_miss_date
928: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
929: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
934: , p5_a35 NUMBER := 0-1962.0724
935: , p5_a36 DATE := fnd_api.g_miss_date
936: , p5_a37 NUMBER := 0-1962.0724
929: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
930: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
931: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
934: , p5_a35 NUMBER := 0-1962.0724
935: , p5_a36 DATE := fnd_api.g_miss_date
936: , p5_a37 NUMBER := 0-1962.0724
937: , p5_a38 DATE := fnd_api.g_miss_date
931: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
934: , p5_a35 NUMBER := 0-1962.0724
935: , p5_a36 DATE := fnd_api.g_miss_date
936: , p5_a37 NUMBER := 0-1962.0724
937: , p5_a38 DATE := fnd_api.g_miss_date
938: , p5_a39 NUMBER := 0-1962.0724
939: )
933: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
934: , p5_a35 NUMBER := 0-1962.0724
935: , p5_a36 DATE := fnd_api.g_miss_date
936: , p5_a37 NUMBER := 0-1962.0724
937: , p5_a38 DATE := fnd_api.g_miss_date
938: , p5_a39 NUMBER := 0-1962.0724
939: )
940:
941: as
1173: , x_msg_data out nocopy VARCHAR2
1174: , p5_a0 NUMBER := 0-1962.0724
1175: , p5_a1 NUMBER := 0-1962.0724
1176: , p5_a2 NUMBER := 0-1962.0724
1177: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a4 NUMBER := 0-1962.0724
1179: , p5_a5 NUMBER := 0-1962.0724
1180: , p5_a6 NUMBER := 0-1962.0724
1181: , p5_a7 NUMBER := 0-1962.0724
1182: , p5_a8 NUMBER := 0-1962.0724
1183: , p5_a9 NUMBER := 0-1962.0724
1184: , p5_a10 NUMBER := 0-1962.0724
1185: , p5_a11 NUMBER := 0-1962.0724
1186: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a13 NUMBER := 0-1962.0724
1188: , p5_a14 NUMBER := 0-1962.0724
1189: , p5_a15 NUMBER := 0-1962.0724
1190: , p5_a16 NUMBER := 0-1962.0724
1188: , p5_a14 NUMBER := 0-1962.0724
1189: , p5_a15 NUMBER := 0-1962.0724
1190: , p5_a16 NUMBER := 0-1962.0724
1191: , p5_a17 NUMBER := 0-1962.0724
1192: , p5_a18 DATE := fnd_api.g_miss_date
1193: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1194: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1195: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1196: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a15 NUMBER := 0-1962.0724
1190: , p5_a16 NUMBER := 0-1962.0724
1191: , p5_a17 NUMBER := 0-1962.0724
1192: , p5_a18 DATE := fnd_api.g_miss_date
1193: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1194: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1195: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1196: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1197: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a16 NUMBER := 0-1962.0724
1191: , p5_a17 NUMBER := 0-1962.0724
1192: , p5_a18 DATE := fnd_api.g_miss_date
1193: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1194: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1195: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1196: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1197: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a17 NUMBER := 0-1962.0724
1192: , p5_a18 DATE := fnd_api.g_miss_date
1193: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1194: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1195: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1196: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1197: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1199: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a18 DATE := fnd_api.g_miss_date
1193: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1194: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1195: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1196: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1197: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1199: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1193: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1194: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1195: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1196: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1197: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1199: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1194: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1195: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1196: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1197: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1199: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1202: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1195: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1196: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1197: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1199: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1202: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1196: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1197: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1199: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1202: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1197: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1199: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1202: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1199: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1202: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1199: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1202: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1207: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1202: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1207: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1208: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1202: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1207: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1208: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a35 NUMBER := 0-1962.0724
1202: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1207: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1208: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a35 NUMBER := 0-1962.0724
1210: , p5_a36 DATE := fnd_api.g_miss_date
1203: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1207: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1208: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a35 NUMBER := 0-1962.0724
1210: , p5_a36 DATE := fnd_api.g_miss_date
1211: , p5_a37 NUMBER := 0-1962.0724
1204: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1207: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1208: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a35 NUMBER := 0-1962.0724
1210: , p5_a36 DATE := fnd_api.g_miss_date
1211: , p5_a37 NUMBER := 0-1962.0724
1212: , p5_a38 DATE := fnd_api.g_miss_date
1206: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1207: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1208: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a35 NUMBER := 0-1962.0724
1210: , p5_a36 DATE := fnd_api.g_miss_date
1211: , p5_a37 NUMBER := 0-1962.0724
1212: , p5_a38 DATE := fnd_api.g_miss_date
1213: , p5_a39 NUMBER := 0-1962.0724
1214: )
1208: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a35 NUMBER := 0-1962.0724
1210: , p5_a36 DATE := fnd_api.g_miss_date
1211: , p5_a37 NUMBER := 0-1962.0724
1212: , p5_a38 DATE := fnd_api.g_miss_date
1213: , p5_a39 NUMBER := 0-1962.0724
1214: )
1215:
1216: as
1404: , x_msg_data out nocopy VARCHAR2
1405: , p5_a0 NUMBER := 0-1962.0724
1406: , p5_a1 NUMBER := 0-1962.0724
1407: , p5_a2 NUMBER := 0-1962.0724
1408: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1409: , p5_a4 NUMBER := 0-1962.0724
1410: , p5_a5 NUMBER := 0-1962.0724
1411: , p5_a6 NUMBER := 0-1962.0724
1412: , p5_a7 NUMBER := 0-1962.0724
1413: , p5_a8 NUMBER := 0-1962.0724
1414: , p5_a9 NUMBER := 0-1962.0724
1415: , p5_a10 NUMBER := 0-1962.0724
1416: , p5_a11 NUMBER := 0-1962.0724
1417: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a13 NUMBER := 0-1962.0724
1419: , p5_a14 NUMBER := 0-1962.0724
1420: , p5_a15 NUMBER := 0-1962.0724
1421: , p5_a16 NUMBER := 0-1962.0724
1419: , p5_a14 NUMBER := 0-1962.0724
1420: , p5_a15 NUMBER := 0-1962.0724
1421: , p5_a16 NUMBER := 0-1962.0724
1422: , p5_a17 NUMBER := 0-1962.0724
1423: , p5_a18 DATE := fnd_api.g_miss_date
1424: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a15 NUMBER := 0-1962.0724
1421: , p5_a16 NUMBER := 0-1962.0724
1422: , p5_a17 NUMBER := 0-1962.0724
1423: , p5_a18 DATE := fnd_api.g_miss_date
1424: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1421: , p5_a16 NUMBER := 0-1962.0724
1422: , p5_a17 NUMBER := 0-1962.0724
1423: , p5_a18 DATE := fnd_api.g_miss_date
1424: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1422: , p5_a17 NUMBER := 0-1962.0724
1423: , p5_a18 DATE := fnd_api.g_miss_date
1424: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a18 DATE := fnd_api.g_miss_date
1424: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a35 NUMBER := 0-1962.0724
1433: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a35 NUMBER := 0-1962.0724
1441: , p5_a36 DATE := fnd_api.g_miss_date
1434: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a35 NUMBER := 0-1962.0724
1441: , p5_a36 DATE := fnd_api.g_miss_date
1442: , p5_a37 NUMBER := 0-1962.0724
1435: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a35 NUMBER := 0-1962.0724
1441: , p5_a36 DATE := fnd_api.g_miss_date
1442: , p5_a37 NUMBER := 0-1962.0724
1443: , p5_a38 DATE := fnd_api.g_miss_date
1437: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a35 NUMBER := 0-1962.0724
1441: , p5_a36 DATE := fnd_api.g_miss_date
1442: , p5_a37 NUMBER := 0-1962.0724
1443: , p5_a38 DATE := fnd_api.g_miss_date
1444: , p5_a39 NUMBER := 0-1962.0724
1445: )
1439: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a35 NUMBER := 0-1962.0724
1441: , p5_a36 DATE := fnd_api.g_miss_date
1442: , p5_a37 NUMBER := 0-1962.0724
1443: , p5_a38 DATE := fnd_api.g_miss_date
1444: , p5_a39 NUMBER := 0-1962.0724
1445: )
1446:
1447: as