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;
486: , p6_a23 out nocopy NUMBER
487: , p6_a24 out nocopy DATE
488: , p6_a25 out nocopy NUMBER
489: , p5_a0 NUMBER := 0-1962.0724
490: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a3 NUMBER := 0-1962.0724
493: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
487: , p6_a24 out nocopy DATE
488: , p6_a25 out nocopy NUMBER
489: , p5_a0 NUMBER := 0-1962.0724
490: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a3 NUMBER := 0-1962.0724
493: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a0 NUMBER := 0-1962.0724
490: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a3 NUMBER := 0-1962.0724
493: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a3 NUMBER := 0-1962.0724
493: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a3 NUMBER := 0-1962.0724
493: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a3 NUMBER := 0-1962.0724
493: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a20 NUMBER := 0-1962.0724
502: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a20 NUMBER := 0-1962.0724
510: , p5_a21 NUMBER := 0-1962.0724
503: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a20 NUMBER := 0-1962.0724
510: , p5_a21 NUMBER := 0-1962.0724
511: , p5_a22 DATE := fnd_api.g_miss_date
504: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a20 NUMBER := 0-1962.0724
510: , p5_a21 NUMBER := 0-1962.0724
511: , p5_a22 DATE := fnd_api.g_miss_date
512: , p5_a23 NUMBER := 0-1962.0724
507: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a20 NUMBER := 0-1962.0724
510: , p5_a21 NUMBER := 0-1962.0724
511: , p5_a22 DATE := fnd_api.g_miss_date
512: , p5_a23 NUMBER := 0-1962.0724
513: , p5_a24 DATE := fnd_api.g_miss_date
514: , p5_a25 NUMBER := 0-1962.0724
515: )
509: , p5_a20 NUMBER := 0-1962.0724
510: , p5_a21 NUMBER := 0-1962.0724
511: , p5_a22 DATE := fnd_api.g_miss_date
512: , p5_a23 NUMBER := 0-1962.0724
513: , p5_a24 DATE := fnd_api.g_miss_date
514: , p5_a25 NUMBER := 0-1962.0724
515: )
516:
517: as
748: , x_return_status out nocopy VARCHAR2
749: , x_msg_count out nocopy NUMBER
750: , x_msg_data out nocopy VARCHAR2
751: , p5_a0 NUMBER := 0-1962.0724
752: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a3 NUMBER := 0-1962.0724
755: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
749: , x_msg_count out nocopy NUMBER
750: , x_msg_data out nocopy VARCHAR2
751: , p5_a0 NUMBER := 0-1962.0724
752: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a3 NUMBER := 0-1962.0724
755: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
751: , p5_a0 NUMBER := 0-1962.0724
752: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a3 NUMBER := 0-1962.0724
755: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
752: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a3 NUMBER := 0-1962.0724
755: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a3 NUMBER := 0-1962.0724
755: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a3 NUMBER := 0-1962.0724
755: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
755: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a20 NUMBER := 0-1962.0724
764: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a20 NUMBER := 0-1962.0724
772: , p5_a21 NUMBER := 0-1962.0724
765: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a20 NUMBER := 0-1962.0724
772: , p5_a21 NUMBER := 0-1962.0724
773: , p5_a22 DATE := fnd_api.g_miss_date
766: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a20 NUMBER := 0-1962.0724
772: , p5_a21 NUMBER := 0-1962.0724
773: , p5_a22 DATE := fnd_api.g_miss_date
774: , p5_a23 NUMBER := 0-1962.0724
769: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a20 NUMBER := 0-1962.0724
772: , p5_a21 NUMBER := 0-1962.0724
773: , p5_a22 DATE := fnd_api.g_miss_date
774: , p5_a23 NUMBER := 0-1962.0724
775: , p5_a24 DATE := fnd_api.g_miss_date
776: , p5_a25 NUMBER := 0-1962.0724
777: )
771: , p5_a20 NUMBER := 0-1962.0724
772: , p5_a21 NUMBER := 0-1962.0724
773: , p5_a22 DATE := fnd_api.g_miss_date
774: , p5_a23 NUMBER := 0-1962.0724
775: , p5_a24 DATE := fnd_api.g_miss_date
776: , p5_a25 NUMBER := 0-1962.0724
777: )
778:
779: as
949: , p6_a23 out nocopy NUMBER
950: , p6_a24 out nocopy DATE
951: , p6_a25 out nocopy NUMBER
952: , p5_a0 NUMBER := 0-1962.0724
953: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a3 NUMBER := 0-1962.0724
956: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
950: , p6_a24 out nocopy DATE
951: , p6_a25 out nocopy NUMBER
952: , p5_a0 NUMBER := 0-1962.0724
953: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a3 NUMBER := 0-1962.0724
956: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a0 NUMBER := 0-1962.0724
953: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a3 NUMBER := 0-1962.0724
956: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a3 NUMBER := 0-1962.0724
956: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a3 NUMBER := 0-1962.0724
956: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a3 NUMBER := 0-1962.0724
956: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
964: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
964: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
964: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
964: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
964: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
964: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
964: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
964: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
964: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a20 NUMBER := 0-1962.0724
965: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a20 NUMBER := 0-1962.0724
973: , p5_a21 NUMBER := 0-1962.0724
966: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a20 NUMBER := 0-1962.0724
973: , p5_a21 NUMBER := 0-1962.0724
974: , p5_a22 DATE := fnd_api.g_miss_date
967: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a20 NUMBER := 0-1962.0724
973: , p5_a21 NUMBER := 0-1962.0724
974: , p5_a22 DATE := fnd_api.g_miss_date
975: , p5_a23 NUMBER := 0-1962.0724
970: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a20 NUMBER := 0-1962.0724
973: , p5_a21 NUMBER := 0-1962.0724
974: , p5_a22 DATE := fnd_api.g_miss_date
975: , p5_a23 NUMBER := 0-1962.0724
976: , p5_a24 DATE := fnd_api.g_miss_date
977: , p5_a25 NUMBER := 0-1962.0724
978: )
972: , p5_a20 NUMBER := 0-1962.0724
973: , p5_a21 NUMBER := 0-1962.0724
974: , p5_a22 DATE := fnd_api.g_miss_date
975: , p5_a23 NUMBER := 0-1962.0724
976: , p5_a24 DATE := fnd_api.g_miss_date
977: , p5_a25 NUMBER := 0-1962.0724
978: )
979:
980: as
1211: , x_return_status out nocopy VARCHAR2
1212: , x_msg_count out nocopy NUMBER
1213: , x_msg_data out nocopy VARCHAR2
1214: , p5_a0 NUMBER := 0-1962.0724
1215: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a3 NUMBER := 0-1962.0724
1218: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1212: , x_msg_count out nocopy NUMBER
1213: , x_msg_data out nocopy VARCHAR2
1214: , p5_a0 NUMBER := 0-1962.0724
1215: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a3 NUMBER := 0-1962.0724
1218: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a0 NUMBER := 0-1962.0724
1215: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a3 NUMBER := 0-1962.0724
1218: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a3 NUMBER := 0-1962.0724
1218: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a3 NUMBER := 0-1962.0724
1218: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a3 NUMBER := 0-1962.0724
1218: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1229: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1229: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1229: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1231: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1229: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1231: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1229: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1231: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1229: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1231: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a20 NUMBER := 0-1962.0724
1227: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1229: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1231: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a20 NUMBER := 0-1962.0724
1235: , p5_a21 NUMBER := 0-1962.0724
1228: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1229: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1231: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a20 NUMBER := 0-1962.0724
1235: , p5_a21 NUMBER := 0-1962.0724
1236: , p5_a22 DATE := fnd_api.g_miss_date
1229: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1231: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a20 NUMBER := 0-1962.0724
1235: , p5_a21 NUMBER := 0-1962.0724
1236: , p5_a22 DATE := fnd_api.g_miss_date
1237: , p5_a23 NUMBER := 0-1962.0724
1232: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a20 NUMBER := 0-1962.0724
1235: , p5_a21 NUMBER := 0-1962.0724
1236: , p5_a22 DATE := fnd_api.g_miss_date
1237: , p5_a23 NUMBER := 0-1962.0724
1238: , p5_a24 DATE := fnd_api.g_miss_date
1239: , p5_a25 NUMBER := 0-1962.0724
1240: )
1234: , p5_a20 NUMBER := 0-1962.0724
1235: , p5_a21 NUMBER := 0-1962.0724
1236: , p5_a22 DATE := fnd_api.g_miss_date
1237: , p5_a23 NUMBER := 0-1962.0724
1238: , p5_a24 DATE := fnd_api.g_miss_date
1239: , p5_a25 NUMBER := 0-1962.0724
1240: )
1241:
1242: as
1386: , x_return_status out nocopy VARCHAR2
1387: , x_msg_count out nocopy NUMBER
1388: , x_msg_data out nocopy VARCHAR2
1389: , p5_a0 NUMBER := 0-1962.0724
1390: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a3 NUMBER := 0-1962.0724
1393: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1387: , x_msg_count out nocopy NUMBER
1388: , x_msg_data out nocopy VARCHAR2
1389: , p5_a0 NUMBER := 0-1962.0724
1390: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a3 NUMBER := 0-1962.0724
1393: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a0 NUMBER := 0-1962.0724
1390: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a3 NUMBER := 0-1962.0724
1393: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a3 NUMBER := 0-1962.0724
1393: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a3 NUMBER := 0-1962.0724
1393: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a3 NUMBER := 0-1962.0724
1393: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1407: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1407: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1408: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1407: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1408: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1409: , p5_a20 NUMBER := 0-1962.0724
1402: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1407: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1408: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1409: , p5_a20 NUMBER := 0-1962.0724
1410: , p5_a21 NUMBER := 0-1962.0724
1403: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1407: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1408: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1409: , p5_a20 NUMBER := 0-1962.0724
1410: , p5_a21 NUMBER := 0-1962.0724
1411: , p5_a22 DATE := fnd_api.g_miss_date
1404: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1407: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1408: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1409: , p5_a20 NUMBER := 0-1962.0724
1410: , p5_a21 NUMBER := 0-1962.0724
1411: , p5_a22 DATE := fnd_api.g_miss_date
1412: , p5_a23 NUMBER := 0-1962.0724
1407: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1408: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1409: , p5_a20 NUMBER := 0-1962.0724
1410: , p5_a21 NUMBER := 0-1962.0724
1411: , p5_a22 DATE := fnd_api.g_miss_date
1412: , p5_a23 NUMBER := 0-1962.0724
1413: , p5_a24 DATE := fnd_api.g_miss_date
1414: , p5_a25 NUMBER := 0-1962.0724
1415: )
1409: , p5_a20 NUMBER := 0-1962.0724
1410: , p5_a21 NUMBER := 0-1962.0724
1411: , p5_a22 DATE := fnd_api.g_miss_date
1412: , p5_a23 NUMBER := 0-1962.0724
1413: , p5_a24 DATE := fnd_api.g_miss_date
1414: , p5_a25 NUMBER := 0-1962.0724
1415: )
1416:
1417: as