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;
637: , p6_a34 out nocopy NUMBER
638: , p6_a35 out nocopy DATE
639: , p5_a0 NUMBER := 0-1962.0724
640: , p5_a1 NUMBER := 0-1962.0724
641: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a3 NUMBER := 0-1962.0724
643: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a5 NUMBER := 0-1962.0724
645: , p5_a6 NUMBER := 0-1962.0724
639: , p5_a0 NUMBER := 0-1962.0724
640: , p5_a1 NUMBER := 0-1962.0724
641: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a3 NUMBER := 0-1962.0724
643: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a5 NUMBER := 0-1962.0724
645: , p5_a6 NUMBER := 0-1962.0724
646: , p5_a7 NUMBER := 0-1962.0724
647: , p5_a8 NUMBER := 0-1962.0724
644: , p5_a5 NUMBER := 0-1962.0724
645: , p5_a6 NUMBER := 0-1962.0724
646: , p5_a7 NUMBER := 0-1962.0724
647: , p5_a8 NUMBER := 0-1962.0724
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a6 NUMBER := 0-1962.0724
646: , p5_a7 NUMBER := 0-1962.0724
647: , p5_a8 NUMBER := 0-1962.0724
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a7 NUMBER := 0-1962.0724
647: , p5_a8 NUMBER := 0-1962.0724
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a8 NUMBER := 0-1962.0724
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a24 NUMBER := 0-1962.0724
656: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a24 NUMBER := 0-1962.0724
664: , p5_a25 NUMBER := 0-1962.0724
657: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a24 NUMBER := 0-1962.0724
664: , p5_a25 NUMBER := 0-1962.0724
665: , p5_a26 NUMBER := 0-1962.0724
658: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a24 NUMBER := 0-1962.0724
664: , p5_a25 NUMBER := 0-1962.0724
665: , p5_a26 NUMBER := 0-1962.0724
666: , p5_a27 DATE := fnd_api.g_miss_date
662: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a24 NUMBER := 0-1962.0724
664: , p5_a25 NUMBER := 0-1962.0724
665: , p5_a26 NUMBER := 0-1962.0724
666: , p5_a27 DATE := fnd_api.g_miss_date
667: , p5_a28 DATE := fnd_api.g_miss_date
668: , p5_a29 NUMBER := 0-1962.0724
669: , p5_a30 NUMBER := 0-1962.0724
670: , p5_a31 DATE := fnd_api.g_miss_date
663: , p5_a24 NUMBER := 0-1962.0724
664: , p5_a25 NUMBER := 0-1962.0724
665: , p5_a26 NUMBER := 0-1962.0724
666: , p5_a27 DATE := fnd_api.g_miss_date
667: , p5_a28 DATE := fnd_api.g_miss_date
668: , p5_a29 NUMBER := 0-1962.0724
669: , p5_a30 NUMBER := 0-1962.0724
670: , p5_a31 DATE := fnd_api.g_miss_date
671: , p5_a32 NUMBER := 0-1962.0724
666: , p5_a27 DATE := fnd_api.g_miss_date
667: , p5_a28 DATE := fnd_api.g_miss_date
668: , p5_a29 NUMBER := 0-1962.0724
669: , p5_a30 NUMBER := 0-1962.0724
670: , p5_a31 DATE := fnd_api.g_miss_date
671: , p5_a32 NUMBER := 0-1962.0724
672: , p5_a33 NUMBER := 0-1962.0724
673: , p5_a34 NUMBER := 0-1962.0724
674: , p5_a35 DATE := fnd_api.g_miss_date
670: , p5_a31 DATE := fnd_api.g_miss_date
671: , p5_a32 NUMBER := 0-1962.0724
672: , p5_a33 NUMBER := 0-1962.0724
673: , p5_a34 NUMBER := 0-1962.0724
674: , p5_a35 DATE := fnd_api.g_miss_date
675: )
676:
677: as
678: ddp_sirv_rec okl_sir_pvt.sirv_rec_type;
969: , x_msg_count out nocopy NUMBER
970: , x_msg_data out nocopy VARCHAR2
971: , p5_a0 NUMBER := 0-1962.0724
972: , p5_a1 NUMBER := 0-1962.0724
973: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
974: , p5_a3 NUMBER := 0-1962.0724
975: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a5 NUMBER := 0-1962.0724
977: , p5_a6 NUMBER := 0-1962.0724
971: , p5_a0 NUMBER := 0-1962.0724
972: , p5_a1 NUMBER := 0-1962.0724
973: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
974: , p5_a3 NUMBER := 0-1962.0724
975: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a5 NUMBER := 0-1962.0724
977: , p5_a6 NUMBER := 0-1962.0724
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
976: , p5_a5 NUMBER := 0-1962.0724
977: , p5_a6 NUMBER := 0-1962.0724
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a6 NUMBER := 0-1962.0724
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
985: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
985: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
985: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
985: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
985: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
982: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
985: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
985: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
985: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
985: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
986: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
988: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a24 NUMBER := 0-1962.0724
988: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
989: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a24 NUMBER := 0-1962.0724
996: , p5_a25 NUMBER := 0-1962.0724
989: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a24 NUMBER := 0-1962.0724
996: , p5_a25 NUMBER := 0-1962.0724
997: , p5_a26 NUMBER := 0-1962.0724
990: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
992: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
993: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
994: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a24 NUMBER := 0-1962.0724
996: , p5_a25 NUMBER := 0-1962.0724
997: , p5_a26 NUMBER := 0-1962.0724
998: , p5_a27 DATE := fnd_api.g_miss_date
994: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
995: , p5_a24 NUMBER := 0-1962.0724
996: , p5_a25 NUMBER := 0-1962.0724
997: , p5_a26 NUMBER := 0-1962.0724
998: , p5_a27 DATE := fnd_api.g_miss_date
999: , p5_a28 DATE := fnd_api.g_miss_date
1000: , p5_a29 NUMBER := 0-1962.0724
1001: , p5_a30 NUMBER := 0-1962.0724
1002: , p5_a31 DATE := fnd_api.g_miss_date
995: , p5_a24 NUMBER := 0-1962.0724
996: , p5_a25 NUMBER := 0-1962.0724
997: , p5_a26 NUMBER := 0-1962.0724
998: , p5_a27 DATE := fnd_api.g_miss_date
999: , p5_a28 DATE := fnd_api.g_miss_date
1000: , p5_a29 NUMBER := 0-1962.0724
1001: , p5_a30 NUMBER := 0-1962.0724
1002: , p5_a31 DATE := fnd_api.g_miss_date
1003: , p5_a32 NUMBER := 0-1962.0724
998: , p5_a27 DATE := fnd_api.g_miss_date
999: , p5_a28 DATE := fnd_api.g_miss_date
1000: , p5_a29 NUMBER := 0-1962.0724
1001: , p5_a30 NUMBER := 0-1962.0724
1002: , p5_a31 DATE := fnd_api.g_miss_date
1003: , p5_a32 NUMBER := 0-1962.0724
1004: , p5_a33 NUMBER := 0-1962.0724
1005: , p5_a34 NUMBER := 0-1962.0724
1006: , p5_a35 DATE := fnd_api.g_miss_date
1002: , p5_a31 DATE := fnd_api.g_miss_date
1003: , p5_a32 NUMBER := 0-1962.0724
1004: , p5_a33 NUMBER := 0-1962.0724
1005: , p5_a34 NUMBER := 0-1962.0724
1006: , p5_a35 DATE := fnd_api.g_miss_date
1007: )
1008:
1009: as
1010: ddp_sirv_rec okl_sir_pvt.sirv_rec_type;
1220: , p6_a34 out nocopy NUMBER
1221: , p6_a35 out nocopy DATE
1222: , p5_a0 NUMBER := 0-1962.0724
1223: , p5_a1 NUMBER := 0-1962.0724
1224: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a3 NUMBER := 0-1962.0724
1226: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a5 NUMBER := 0-1962.0724
1228: , p5_a6 NUMBER := 0-1962.0724
1222: , p5_a0 NUMBER := 0-1962.0724
1223: , p5_a1 NUMBER := 0-1962.0724
1224: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a3 NUMBER := 0-1962.0724
1226: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a5 NUMBER := 0-1962.0724
1228: , p5_a6 NUMBER := 0-1962.0724
1229: , p5_a7 NUMBER := 0-1962.0724
1230: , p5_a8 NUMBER := 0-1962.0724
1227: , p5_a5 NUMBER := 0-1962.0724
1228: , p5_a6 NUMBER := 0-1962.0724
1229: , p5_a7 NUMBER := 0-1962.0724
1230: , p5_a8 NUMBER := 0-1962.0724
1231: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a6 NUMBER := 0-1962.0724
1229: , p5_a7 NUMBER := 0-1962.0724
1230: , p5_a8 NUMBER := 0-1962.0724
1231: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1229: , p5_a7 NUMBER := 0-1962.0724
1230: , p5_a8 NUMBER := 0-1962.0724
1231: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a8 NUMBER := 0-1962.0724
1231: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1231: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a24 NUMBER := 0-1962.0724
1239: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a24 NUMBER := 0-1962.0724
1247: , p5_a25 NUMBER := 0-1962.0724
1240: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a24 NUMBER := 0-1962.0724
1247: , p5_a25 NUMBER := 0-1962.0724
1248: , p5_a26 NUMBER := 0-1962.0724
1241: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a24 NUMBER := 0-1962.0724
1247: , p5_a25 NUMBER := 0-1962.0724
1248: , p5_a26 NUMBER := 0-1962.0724
1249: , p5_a27 DATE := fnd_api.g_miss_date
1245: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a24 NUMBER := 0-1962.0724
1247: , p5_a25 NUMBER := 0-1962.0724
1248: , p5_a26 NUMBER := 0-1962.0724
1249: , p5_a27 DATE := fnd_api.g_miss_date
1250: , p5_a28 DATE := fnd_api.g_miss_date
1251: , p5_a29 NUMBER := 0-1962.0724
1252: , p5_a30 NUMBER := 0-1962.0724
1253: , p5_a31 DATE := fnd_api.g_miss_date
1246: , p5_a24 NUMBER := 0-1962.0724
1247: , p5_a25 NUMBER := 0-1962.0724
1248: , p5_a26 NUMBER := 0-1962.0724
1249: , p5_a27 DATE := fnd_api.g_miss_date
1250: , p5_a28 DATE := fnd_api.g_miss_date
1251: , p5_a29 NUMBER := 0-1962.0724
1252: , p5_a30 NUMBER := 0-1962.0724
1253: , p5_a31 DATE := fnd_api.g_miss_date
1254: , p5_a32 NUMBER := 0-1962.0724
1249: , p5_a27 DATE := fnd_api.g_miss_date
1250: , p5_a28 DATE := fnd_api.g_miss_date
1251: , p5_a29 NUMBER := 0-1962.0724
1252: , p5_a30 NUMBER := 0-1962.0724
1253: , p5_a31 DATE := fnd_api.g_miss_date
1254: , p5_a32 NUMBER := 0-1962.0724
1255: , p5_a33 NUMBER := 0-1962.0724
1256: , p5_a34 NUMBER := 0-1962.0724
1257: , p5_a35 DATE := fnd_api.g_miss_date
1253: , p5_a31 DATE := fnd_api.g_miss_date
1254: , p5_a32 NUMBER := 0-1962.0724
1255: , p5_a33 NUMBER := 0-1962.0724
1256: , p5_a34 NUMBER := 0-1962.0724
1257: , p5_a35 DATE := fnd_api.g_miss_date
1258: )
1259:
1260: as
1261: ddp_sirv_rec okl_sir_pvt.sirv_rec_type;
1552: , x_msg_count out nocopy NUMBER
1553: , x_msg_data out nocopy VARCHAR2
1554: , p5_a0 NUMBER := 0-1962.0724
1555: , p5_a1 NUMBER := 0-1962.0724
1556: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1557: , p5_a3 NUMBER := 0-1962.0724
1558: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a5 NUMBER := 0-1962.0724
1560: , p5_a6 NUMBER := 0-1962.0724
1554: , p5_a0 NUMBER := 0-1962.0724
1555: , p5_a1 NUMBER := 0-1962.0724
1556: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1557: , p5_a3 NUMBER := 0-1962.0724
1558: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a5 NUMBER := 0-1962.0724
1560: , p5_a6 NUMBER := 0-1962.0724
1561: , p5_a7 NUMBER := 0-1962.0724
1562: , p5_a8 NUMBER := 0-1962.0724
1559: , p5_a5 NUMBER := 0-1962.0724
1560: , p5_a6 NUMBER := 0-1962.0724
1561: , p5_a7 NUMBER := 0-1962.0724
1562: , p5_a8 NUMBER := 0-1962.0724
1563: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a6 NUMBER := 0-1962.0724
1561: , p5_a7 NUMBER := 0-1962.0724
1562: , p5_a8 NUMBER := 0-1962.0724
1563: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1561: , p5_a7 NUMBER := 0-1962.0724
1562: , p5_a8 NUMBER := 0-1962.0724
1563: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1562: , p5_a8 NUMBER := 0-1962.0724
1563: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a24 NUMBER := 0-1962.0724
1571: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a24 NUMBER := 0-1962.0724
1579: , p5_a25 NUMBER := 0-1962.0724
1572: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a24 NUMBER := 0-1962.0724
1579: , p5_a25 NUMBER := 0-1962.0724
1580: , p5_a26 NUMBER := 0-1962.0724
1573: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a24 NUMBER := 0-1962.0724
1579: , p5_a25 NUMBER := 0-1962.0724
1580: , p5_a26 NUMBER := 0-1962.0724
1581: , p5_a27 DATE := fnd_api.g_miss_date
1577: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a24 NUMBER := 0-1962.0724
1579: , p5_a25 NUMBER := 0-1962.0724
1580: , p5_a26 NUMBER := 0-1962.0724
1581: , p5_a27 DATE := fnd_api.g_miss_date
1582: , p5_a28 DATE := fnd_api.g_miss_date
1583: , p5_a29 NUMBER := 0-1962.0724
1584: , p5_a30 NUMBER := 0-1962.0724
1585: , p5_a31 DATE := fnd_api.g_miss_date
1578: , p5_a24 NUMBER := 0-1962.0724
1579: , p5_a25 NUMBER := 0-1962.0724
1580: , p5_a26 NUMBER := 0-1962.0724
1581: , p5_a27 DATE := fnd_api.g_miss_date
1582: , p5_a28 DATE := fnd_api.g_miss_date
1583: , p5_a29 NUMBER := 0-1962.0724
1584: , p5_a30 NUMBER := 0-1962.0724
1585: , p5_a31 DATE := fnd_api.g_miss_date
1586: , p5_a32 NUMBER := 0-1962.0724
1581: , p5_a27 DATE := fnd_api.g_miss_date
1582: , p5_a28 DATE := fnd_api.g_miss_date
1583: , p5_a29 NUMBER := 0-1962.0724
1584: , p5_a30 NUMBER := 0-1962.0724
1585: , p5_a31 DATE := fnd_api.g_miss_date
1586: , p5_a32 NUMBER := 0-1962.0724
1587: , p5_a33 NUMBER := 0-1962.0724
1588: , p5_a34 NUMBER := 0-1962.0724
1589: , p5_a35 DATE := fnd_api.g_miss_date
1585: , p5_a31 DATE := fnd_api.g_miss_date
1586: , p5_a32 NUMBER := 0-1962.0724
1587: , p5_a33 NUMBER := 0-1962.0724
1588: , p5_a34 NUMBER := 0-1962.0724
1589: , p5_a35 DATE := fnd_api.g_miss_date
1590: )
1591:
1592: as
1593: ddp_sirv_rec okl_sir_pvt.sirv_rec_type;
1767: , x_msg_count out nocopy NUMBER
1768: , x_msg_data out nocopy VARCHAR2
1769: , p5_a0 NUMBER := 0-1962.0724
1770: , p5_a1 NUMBER := 0-1962.0724
1771: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1772: , p5_a3 NUMBER := 0-1962.0724
1773: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1774: , p5_a5 NUMBER := 0-1962.0724
1775: , p5_a6 NUMBER := 0-1962.0724
1769: , p5_a0 NUMBER := 0-1962.0724
1770: , p5_a1 NUMBER := 0-1962.0724
1771: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1772: , p5_a3 NUMBER := 0-1962.0724
1773: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1774: , p5_a5 NUMBER := 0-1962.0724
1775: , p5_a6 NUMBER := 0-1962.0724
1776: , p5_a7 NUMBER := 0-1962.0724
1777: , p5_a8 NUMBER := 0-1962.0724
1774: , p5_a5 NUMBER := 0-1962.0724
1775: , p5_a6 NUMBER := 0-1962.0724
1776: , p5_a7 NUMBER := 0-1962.0724
1777: , p5_a8 NUMBER := 0-1962.0724
1778: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1779: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1780: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1781: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1782: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1775: , p5_a6 NUMBER := 0-1962.0724
1776: , p5_a7 NUMBER := 0-1962.0724
1777: , p5_a8 NUMBER := 0-1962.0724
1778: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1779: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1780: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1781: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1782: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1783: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1776: , p5_a7 NUMBER := 0-1962.0724
1777: , p5_a8 NUMBER := 0-1962.0724
1778: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1779: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1780: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1781: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1782: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1783: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1784: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1777: , p5_a8 NUMBER := 0-1962.0724
1778: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1779: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1780: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1781: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1782: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1783: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1784: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1778: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1779: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1780: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1781: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1782: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1783: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1784: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1786: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1779: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1780: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1781: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1782: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1783: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1784: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1786: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1787: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1780: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1781: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1782: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1783: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1784: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1786: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1787: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1781: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1782: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1783: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1784: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1786: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1787: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1782: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1783: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1784: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1786: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1787: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1783: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1784: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1786: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1787: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1784: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1786: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1787: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1786: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1787: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a24 NUMBER := 0-1962.0724
1786: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1787: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a24 NUMBER := 0-1962.0724
1794: , p5_a25 NUMBER := 0-1962.0724
1787: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a24 NUMBER := 0-1962.0724
1794: , p5_a25 NUMBER := 0-1962.0724
1795: , p5_a26 NUMBER := 0-1962.0724
1788: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a24 NUMBER := 0-1962.0724
1794: , p5_a25 NUMBER := 0-1962.0724
1795: , p5_a26 NUMBER := 0-1962.0724
1796: , p5_a27 DATE := fnd_api.g_miss_date
1792: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a24 NUMBER := 0-1962.0724
1794: , p5_a25 NUMBER := 0-1962.0724
1795: , p5_a26 NUMBER := 0-1962.0724
1796: , p5_a27 DATE := fnd_api.g_miss_date
1797: , p5_a28 DATE := fnd_api.g_miss_date
1798: , p5_a29 NUMBER := 0-1962.0724
1799: , p5_a30 NUMBER := 0-1962.0724
1800: , p5_a31 DATE := fnd_api.g_miss_date
1793: , p5_a24 NUMBER := 0-1962.0724
1794: , p5_a25 NUMBER := 0-1962.0724
1795: , p5_a26 NUMBER := 0-1962.0724
1796: , p5_a27 DATE := fnd_api.g_miss_date
1797: , p5_a28 DATE := fnd_api.g_miss_date
1798: , p5_a29 NUMBER := 0-1962.0724
1799: , p5_a30 NUMBER := 0-1962.0724
1800: , p5_a31 DATE := fnd_api.g_miss_date
1801: , p5_a32 NUMBER := 0-1962.0724
1796: , p5_a27 DATE := fnd_api.g_miss_date
1797: , p5_a28 DATE := fnd_api.g_miss_date
1798: , p5_a29 NUMBER := 0-1962.0724
1799: , p5_a30 NUMBER := 0-1962.0724
1800: , p5_a31 DATE := fnd_api.g_miss_date
1801: , p5_a32 NUMBER := 0-1962.0724
1802: , p5_a33 NUMBER := 0-1962.0724
1803: , p5_a34 NUMBER := 0-1962.0724
1804: , p5_a35 DATE := fnd_api.g_miss_date
1800: , p5_a31 DATE := fnd_api.g_miss_date
1801: , p5_a32 NUMBER := 0-1962.0724
1802: , p5_a33 NUMBER := 0-1962.0724
1803: , p5_a34 NUMBER := 0-1962.0724
1804: , p5_a35 DATE := fnd_api.g_miss_date
1805: )
1806:
1807: as
1808: ddp_sirv_rec okl_sir_pvt.sirv_rec_type;