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;
502: , p6_a25 out nocopy DATE
503: , p6_a26 out nocopy NUMBER
504: , p5_a0 NUMBER := 0-1962.0724
505: , p5_a1 NUMBER := 0-1962.0724
506: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a4 DATE := fnd_api.g_miss_date
509: , p5_a5 DATE := fnd_api.g_miss_date
510: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
503: , p6_a26 out nocopy NUMBER
504: , p5_a0 NUMBER := 0-1962.0724
505: , p5_a1 NUMBER := 0-1962.0724
506: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a4 DATE := fnd_api.g_miss_date
509: , p5_a5 DATE := fnd_api.g_miss_date
510: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a0 NUMBER := 0-1962.0724
505: , p5_a1 NUMBER := 0-1962.0724
506: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a4 DATE := fnd_api.g_miss_date
509: , p5_a5 DATE := fnd_api.g_miss_date
510: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a1 NUMBER := 0-1962.0724
506: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a4 DATE := fnd_api.g_miss_date
509: , p5_a5 DATE := fnd_api.g_miss_date
510: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a4 DATE := fnd_api.g_miss_date
509: , p5_a5 DATE := fnd_api.g_miss_date
510: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a4 DATE := fnd_api.g_miss_date
509: , p5_a5 DATE := fnd_api.g_miss_date
510: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a4 DATE := fnd_api.g_miss_date
509: , p5_a5 DATE := fnd_api.g_miss_date
510: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a5 DATE := fnd_api.g_miss_date
510: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a22 NUMBER := 0-1962.0724
519: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a22 NUMBER := 0-1962.0724
527: , p5_a23 DATE := fnd_api.g_miss_date
520: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a22 NUMBER := 0-1962.0724
527: , p5_a23 DATE := fnd_api.g_miss_date
528: , p5_a24 NUMBER := 0-1962.0724
521: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a22 NUMBER := 0-1962.0724
527: , p5_a23 DATE := fnd_api.g_miss_date
528: , p5_a24 NUMBER := 0-1962.0724
529: , p5_a25 DATE := fnd_api.g_miss_date
523: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a22 NUMBER := 0-1962.0724
527: , p5_a23 DATE := fnd_api.g_miss_date
528: , p5_a24 NUMBER := 0-1962.0724
529: , p5_a25 DATE := fnd_api.g_miss_date
530: , p5_a26 NUMBER := 0-1962.0724
531: )
525: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a22 NUMBER := 0-1962.0724
527: , p5_a23 DATE := fnd_api.g_miss_date
528: , p5_a24 NUMBER := 0-1962.0724
529: , p5_a25 DATE := fnd_api.g_miss_date
530: , p5_a26 NUMBER := 0-1962.0724
531: )
532:
533: as
771: , x_msg_count out nocopy NUMBER
772: , x_msg_data out nocopy VARCHAR2
773: , p5_a0 NUMBER := 0-1962.0724
774: , p5_a1 NUMBER := 0-1962.0724
775: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a4 DATE := fnd_api.g_miss_date
778: , p5_a5 DATE := fnd_api.g_miss_date
779: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
772: , x_msg_data out nocopy VARCHAR2
773: , p5_a0 NUMBER := 0-1962.0724
774: , p5_a1 NUMBER := 0-1962.0724
775: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a4 DATE := fnd_api.g_miss_date
778: , p5_a5 DATE := fnd_api.g_miss_date
779: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a0 NUMBER := 0-1962.0724
774: , p5_a1 NUMBER := 0-1962.0724
775: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a4 DATE := fnd_api.g_miss_date
778: , p5_a5 DATE := fnd_api.g_miss_date
779: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a1 NUMBER := 0-1962.0724
775: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a4 DATE := fnd_api.g_miss_date
778: , p5_a5 DATE := fnd_api.g_miss_date
779: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a4 DATE := fnd_api.g_miss_date
778: , p5_a5 DATE := fnd_api.g_miss_date
779: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a4 DATE := fnd_api.g_miss_date
778: , p5_a5 DATE := fnd_api.g_miss_date
779: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a4 DATE := fnd_api.g_miss_date
778: , p5_a5 DATE := fnd_api.g_miss_date
779: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a5 DATE := fnd_api.g_miss_date
779: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a22 NUMBER := 0-1962.0724
788: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a22 NUMBER := 0-1962.0724
796: , p5_a23 DATE := fnd_api.g_miss_date
789: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a22 NUMBER := 0-1962.0724
796: , p5_a23 DATE := fnd_api.g_miss_date
797: , p5_a24 NUMBER := 0-1962.0724
790: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a22 NUMBER := 0-1962.0724
796: , p5_a23 DATE := fnd_api.g_miss_date
797: , p5_a24 NUMBER := 0-1962.0724
798: , p5_a25 DATE := fnd_api.g_miss_date
792: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a22 NUMBER := 0-1962.0724
796: , p5_a23 DATE := fnd_api.g_miss_date
797: , p5_a24 NUMBER := 0-1962.0724
798: , p5_a25 DATE := fnd_api.g_miss_date
799: , p5_a26 NUMBER := 0-1962.0724
800: )
794: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a22 NUMBER := 0-1962.0724
796: , p5_a23 DATE := fnd_api.g_miss_date
797: , p5_a24 NUMBER := 0-1962.0724
798: , p5_a25 DATE := fnd_api.g_miss_date
799: , p5_a26 NUMBER := 0-1962.0724
800: )
801:
802: as
977: , p6_a25 out nocopy DATE
978: , p6_a26 out nocopy NUMBER
979: , p5_a0 NUMBER := 0-1962.0724
980: , p5_a1 NUMBER := 0-1962.0724
981: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a4 DATE := fnd_api.g_miss_date
984: , p5_a5 DATE := fnd_api.g_miss_date
985: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
978: , p6_a26 out nocopy NUMBER
979: , p5_a0 NUMBER := 0-1962.0724
980: , p5_a1 NUMBER := 0-1962.0724
981: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a4 DATE := fnd_api.g_miss_date
984: , p5_a5 DATE := fnd_api.g_miss_date
985: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
979: , p5_a0 NUMBER := 0-1962.0724
980: , p5_a1 NUMBER := 0-1962.0724
981: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a4 DATE := fnd_api.g_miss_date
984: , p5_a5 DATE := fnd_api.g_miss_date
985: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a1 NUMBER := 0-1962.0724
981: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a4 DATE := fnd_api.g_miss_date
984: , p5_a5 DATE := fnd_api.g_miss_date
985: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a4 DATE := fnd_api.g_miss_date
984: , p5_a5 DATE := fnd_api.g_miss_date
985: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a4 DATE := fnd_api.g_miss_date
984: , p5_a5 DATE := fnd_api.g_miss_date
985: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a4 DATE := fnd_api.g_miss_date
984: , p5_a5 DATE := fnd_api.g_miss_date
985: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a5 DATE := fnd_api.g_miss_date
985: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
985: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
996: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
996: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
997: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
996: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
997: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
998: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
996: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
997: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
998: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
999: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
996: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
997: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
998: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
999: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1000: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
996: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
997: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
998: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
999: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1000: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1001: , p5_a22 NUMBER := 0-1962.0724
994: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
996: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
997: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
998: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
999: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1000: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1001: , p5_a22 NUMBER := 0-1962.0724
1002: , p5_a23 DATE := fnd_api.g_miss_date
995: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
996: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
997: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
998: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
999: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1000: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1001: , p5_a22 NUMBER := 0-1962.0724
1002: , p5_a23 DATE := fnd_api.g_miss_date
1003: , p5_a24 NUMBER := 0-1962.0724
996: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
997: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
998: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
999: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1000: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1001: , p5_a22 NUMBER := 0-1962.0724
1002: , p5_a23 DATE := fnd_api.g_miss_date
1003: , p5_a24 NUMBER := 0-1962.0724
1004: , p5_a25 DATE := fnd_api.g_miss_date
998: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
999: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1000: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1001: , p5_a22 NUMBER := 0-1962.0724
1002: , p5_a23 DATE := fnd_api.g_miss_date
1003: , p5_a24 NUMBER := 0-1962.0724
1004: , p5_a25 DATE := fnd_api.g_miss_date
1005: , p5_a26 NUMBER := 0-1962.0724
1006: )
1000: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1001: , p5_a22 NUMBER := 0-1962.0724
1002: , p5_a23 DATE := fnd_api.g_miss_date
1003: , p5_a24 NUMBER := 0-1962.0724
1004: , p5_a25 DATE := fnd_api.g_miss_date
1005: , p5_a26 NUMBER := 0-1962.0724
1006: )
1007:
1008: as
1246: , x_msg_count out nocopy NUMBER
1247: , x_msg_data out nocopy VARCHAR2
1248: , p5_a0 NUMBER := 0-1962.0724
1249: , p5_a1 NUMBER := 0-1962.0724
1250: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p5_a4 DATE := fnd_api.g_miss_date
1253: , p5_a5 DATE := fnd_api.g_miss_date
1254: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1247: , x_msg_data out nocopy VARCHAR2
1248: , p5_a0 NUMBER := 0-1962.0724
1249: , p5_a1 NUMBER := 0-1962.0724
1250: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p5_a4 DATE := fnd_api.g_miss_date
1253: , p5_a5 DATE := fnd_api.g_miss_date
1254: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1248: , p5_a0 NUMBER := 0-1962.0724
1249: , p5_a1 NUMBER := 0-1962.0724
1250: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p5_a4 DATE := fnd_api.g_miss_date
1253: , p5_a5 DATE := fnd_api.g_miss_date
1254: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1249: , p5_a1 NUMBER := 0-1962.0724
1250: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p5_a4 DATE := fnd_api.g_miss_date
1253: , p5_a5 DATE := fnd_api.g_miss_date
1254: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1250: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p5_a4 DATE := fnd_api.g_miss_date
1253: , p5_a5 DATE := fnd_api.g_miss_date
1254: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1251: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p5_a4 DATE := fnd_api.g_miss_date
1253: , p5_a5 DATE := fnd_api.g_miss_date
1254: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1252: , p5_a4 DATE := fnd_api.g_miss_date
1253: , p5_a5 DATE := fnd_api.g_miss_date
1254: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1253: , p5_a5 DATE := fnd_api.g_miss_date
1254: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1254: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a22 NUMBER := 0-1962.0724
1263: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a22 NUMBER := 0-1962.0724
1271: , p5_a23 DATE := fnd_api.g_miss_date
1264: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a22 NUMBER := 0-1962.0724
1271: , p5_a23 DATE := fnd_api.g_miss_date
1272: , p5_a24 NUMBER := 0-1962.0724
1265: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a22 NUMBER := 0-1962.0724
1271: , p5_a23 DATE := fnd_api.g_miss_date
1272: , p5_a24 NUMBER := 0-1962.0724
1273: , p5_a25 DATE := fnd_api.g_miss_date
1267: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a22 NUMBER := 0-1962.0724
1271: , p5_a23 DATE := fnd_api.g_miss_date
1272: , p5_a24 NUMBER := 0-1962.0724
1273: , p5_a25 DATE := fnd_api.g_miss_date
1274: , p5_a26 NUMBER := 0-1962.0724
1275: )
1269: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a22 NUMBER := 0-1962.0724
1271: , p5_a23 DATE := fnd_api.g_miss_date
1272: , p5_a24 NUMBER := 0-1962.0724
1273: , p5_a25 DATE := fnd_api.g_miss_date
1274: , p5_a26 NUMBER := 0-1962.0724
1275: )
1276:
1277: as
1425: , x_msg_count out nocopy NUMBER
1426: , x_msg_data out nocopy VARCHAR2
1427: , p5_a0 NUMBER := 0-1962.0724
1428: , p5_a1 NUMBER := 0-1962.0724
1429: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a4 DATE := fnd_api.g_miss_date
1432: , p5_a5 DATE := fnd_api.g_miss_date
1433: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1426: , x_msg_data out nocopy VARCHAR2
1427: , p5_a0 NUMBER := 0-1962.0724
1428: , p5_a1 NUMBER := 0-1962.0724
1429: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a4 DATE := fnd_api.g_miss_date
1432: , p5_a5 DATE := fnd_api.g_miss_date
1433: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a0 NUMBER := 0-1962.0724
1428: , p5_a1 NUMBER := 0-1962.0724
1429: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a4 DATE := fnd_api.g_miss_date
1432: , p5_a5 DATE := fnd_api.g_miss_date
1433: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a1 NUMBER := 0-1962.0724
1429: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a4 DATE := fnd_api.g_miss_date
1432: , p5_a5 DATE := fnd_api.g_miss_date
1433: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a4 DATE := fnd_api.g_miss_date
1432: , p5_a5 DATE := fnd_api.g_miss_date
1433: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a4 DATE := fnd_api.g_miss_date
1432: , p5_a5 DATE := fnd_api.g_miss_date
1433: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a4 DATE := fnd_api.g_miss_date
1432: , p5_a5 DATE := fnd_api.g_miss_date
1433: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a5 DATE := fnd_api.g_miss_date
1433: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a22 NUMBER := 0-1962.0724
1442: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a22 NUMBER := 0-1962.0724
1450: , p5_a23 DATE := fnd_api.g_miss_date
1443: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a22 NUMBER := 0-1962.0724
1450: , p5_a23 DATE := fnd_api.g_miss_date
1451: , p5_a24 NUMBER := 0-1962.0724
1444: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a22 NUMBER := 0-1962.0724
1450: , p5_a23 DATE := fnd_api.g_miss_date
1451: , p5_a24 NUMBER := 0-1962.0724
1452: , p5_a25 DATE := fnd_api.g_miss_date
1446: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a22 NUMBER := 0-1962.0724
1450: , p5_a23 DATE := fnd_api.g_miss_date
1451: , p5_a24 NUMBER := 0-1962.0724
1452: , p5_a25 DATE := fnd_api.g_miss_date
1453: , p5_a26 NUMBER := 0-1962.0724
1454: )
1448: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a22 NUMBER := 0-1962.0724
1450: , p5_a23 DATE := fnd_api.g_miss_date
1451: , p5_a24 NUMBER := 0-1962.0724
1452: , p5_a25 DATE := fnd_api.g_miss_date
1453: , p5_a26 NUMBER := 0-1962.0724
1454: )
1455:
1456: as