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;
61: , p8_a10 out nocopy JTF_DATE_TABLE
62: , p8_a11 out nocopy JTF_NUMBER_TABLE
63: , p5_a0 NUMBER := 0-1962.0724
64: , p5_a1 NUMBER := 0-1962.0724
65: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a5 DATE := fnd_api.g_miss_date
69: , p5_a6 DATE := fnd_api.g_miss_date
62: , p8_a11 out nocopy JTF_NUMBER_TABLE
63: , p5_a0 NUMBER := 0-1962.0724
64: , p5_a1 NUMBER := 0-1962.0724
65: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a5 DATE := fnd_api.g_miss_date
69: , p5_a6 DATE := fnd_api.g_miss_date
70: , p5_a7 NUMBER := 0-1962.0724
63: , p5_a0 NUMBER := 0-1962.0724
64: , p5_a1 NUMBER := 0-1962.0724
65: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a5 DATE := fnd_api.g_miss_date
69: , p5_a6 DATE := fnd_api.g_miss_date
70: , p5_a7 NUMBER := 0-1962.0724
71: , p5_a8 DATE := fnd_api.g_miss_date
64: , p5_a1 NUMBER := 0-1962.0724
65: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a5 DATE := fnd_api.g_miss_date
69: , p5_a6 DATE := fnd_api.g_miss_date
70: , p5_a7 NUMBER := 0-1962.0724
71: , p5_a8 DATE := fnd_api.g_miss_date
72: , p5_a9 NUMBER := 0-1962.0724
65: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a5 DATE := fnd_api.g_miss_date
69: , p5_a6 DATE := fnd_api.g_miss_date
70: , p5_a7 NUMBER := 0-1962.0724
71: , p5_a8 DATE := fnd_api.g_miss_date
72: , p5_a9 NUMBER := 0-1962.0724
73: , p5_a10 DATE := fnd_api.g_miss_date
67: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a5 DATE := fnd_api.g_miss_date
69: , p5_a6 DATE := fnd_api.g_miss_date
70: , p5_a7 NUMBER := 0-1962.0724
71: , p5_a8 DATE := fnd_api.g_miss_date
72: , p5_a9 NUMBER := 0-1962.0724
73: , p5_a10 DATE := fnd_api.g_miss_date
74: , p5_a11 NUMBER := 0-1962.0724
75: )
69: , p5_a6 DATE := fnd_api.g_miss_date
70: , p5_a7 NUMBER := 0-1962.0724
71: , p5_a8 DATE := fnd_api.g_miss_date
72: , p5_a9 NUMBER := 0-1962.0724
73: , p5_a10 DATE := fnd_api.g_miss_date
74: , p5_a11 NUMBER := 0-1962.0724
75: )
76:
77: as
206: , p8_a10 out nocopy JTF_DATE_TABLE
207: , p8_a11 out nocopy JTF_NUMBER_TABLE
208: , p5_a0 NUMBER := 0-1962.0724
209: , p5_a1 NUMBER := 0-1962.0724
210: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a5 DATE := fnd_api.g_miss_date
214: , p5_a6 DATE := fnd_api.g_miss_date
207: , p8_a11 out nocopy JTF_NUMBER_TABLE
208: , p5_a0 NUMBER := 0-1962.0724
209: , p5_a1 NUMBER := 0-1962.0724
210: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a5 DATE := fnd_api.g_miss_date
214: , p5_a6 DATE := fnd_api.g_miss_date
215: , p5_a7 NUMBER := 0-1962.0724
208: , p5_a0 NUMBER := 0-1962.0724
209: , p5_a1 NUMBER := 0-1962.0724
210: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a5 DATE := fnd_api.g_miss_date
214: , p5_a6 DATE := fnd_api.g_miss_date
215: , p5_a7 NUMBER := 0-1962.0724
216: , p5_a8 DATE := fnd_api.g_miss_date
209: , p5_a1 NUMBER := 0-1962.0724
210: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a5 DATE := fnd_api.g_miss_date
214: , p5_a6 DATE := fnd_api.g_miss_date
215: , p5_a7 NUMBER := 0-1962.0724
216: , p5_a8 DATE := fnd_api.g_miss_date
217: , p5_a9 NUMBER := 0-1962.0724
210: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
212: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a5 DATE := fnd_api.g_miss_date
214: , p5_a6 DATE := fnd_api.g_miss_date
215: , p5_a7 NUMBER := 0-1962.0724
216: , p5_a8 DATE := fnd_api.g_miss_date
217: , p5_a9 NUMBER := 0-1962.0724
218: , p5_a10 DATE := fnd_api.g_miss_date
212: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
213: , p5_a5 DATE := fnd_api.g_miss_date
214: , p5_a6 DATE := fnd_api.g_miss_date
215: , p5_a7 NUMBER := 0-1962.0724
216: , p5_a8 DATE := fnd_api.g_miss_date
217: , p5_a9 NUMBER := 0-1962.0724
218: , p5_a10 DATE := fnd_api.g_miss_date
219: , p5_a11 NUMBER := 0-1962.0724
220: )
214: , p5_a6 DATE := fnd_api.g_miss_date
215: , p5_a7 NUMBER := 0-1962.0724
216: , p5_a8 DATE := fnd_api.g_miss_date
217: , p5_a9 NUMBER := 0-1962.0724
218: , p5_a10 DATE := fnd_api.g_miss_date
219: , p5_a11 NUMBER := 0-1962.0724
220: )
221:
222: as
327: , p6_a10 JTF_DATE_TABLE
328: , p6_a11 JTF_NUMBER_TABLE
329: , p5_a0 NUMBER := 0-1962.0724
330: , p5_a1 NUMBER := 0-1962.0724
331: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
332: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a5 DATE := fnd_api.g_miss_date
335: , p5_a6 DATE := fnd_api.g_miss_date
328: , p6_a11 JTF_NUMBER_TABLE
329: , p5_a0 NUMBER := 0-1962.0724
330: , p5_a1 NUMBER := 0-1962.0724
331: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
332: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a5 DATE := fnd_api.g_miss_date
335: , p5_a6 DATE := fnd_api.g_miss_date
336: , p5_a7 NUMBER := 0-1962.0724
329: , p5_a0 NUMBER := 0-1962.0724
330: , p5_a1 NUMBER := 0-1962.0724
331: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
332: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a5 DATE := fnd_api.g_miss_date
335: , p5_a6 DATE := fnd_api.g_miss_date
336: , p5_a7 NUMBER := 0-1962.0724
337: , p5_a8 DATE := fnd_api.g_miss_date
330: , p5_a1 NUMBER := 0-1962.0724
331: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
332: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a5 DATE := fnd_api.g_miss_date
335: , p5_a6 DATE := fnd_api.g_miss_date
336: , p5_a7 NUMBER := 0-1962.0724
337: , p5_a8 DATE := fnd_api.g_miss_date
338: , p5_a9 NUMBER := 0-1962.0724
331: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
332: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a5 DATE := fnd_api.g_miss_date
335: , p5_a6 DATE := fnd_api.g_miss_date
336: , p5_a7 NUMBER := 0-1962.0724
337: , p5_a8 DATE := fnd_api.g_miss_date
338: , p5_a9 NUMBER := 0-1962.0724
339: , p5_a10 DATE := fnd_api.g_miss_date
333: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a5 DATE := fnd_api.g_miss_date
335: , p5_a6 DATE := fnd_api.g_miss_date
336: , p5_a7 NUMBER := 0-1962.0724
337: , p5_a8 DATE := fnd_api.g_miss_date
338: , p5_a9 NUMBER := 0-1962.0724
339: , p5_a10 DATE := fnd_api.g_miss_date
340: , p5_a11 NUMBER := 0-1962.0724
341: )
335: , p5_a6 DATE := fnd_api.g_miss_date
336: , p5_a7 NUMBER := 0-1962.0724
337: , p5_a8 DATE := fnd_api.g_miss_date
338: , p5_a9 NUMBER := 0-1962.0724
339: , p5_a10 DATE := fnd_api.g_miss_date
340: , p5_a11 NUMBER := 0-1962.0724
341: )
342:
343: as
504: , p6_a10 out nocopy DATE
505: , p6_a11 out nocopy NUMBER
506: , p5_a0 NUMBER := 0-1962.0724
507: , p5_a1 NUMBER := 0-1962.0724
508: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a5 DATE := fnd_api.g_miss_date
512: , p5_a6 DATE := fnd_api.g_miss_date
505: , p6_a11 out nocopy NUMBER
506: , p5_a0 NUMBER := 0-1962.0724
507: , p5_a1 NUMBER := 0-1962.0724
508: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a5 DATE := fnd_api.g_miss_date
512: , p5_a6 DATE := fnd_api.g_miss_date
513: , p5_a7 NUMBER := 0-1962.0724
506: , p5_a0 NUMBER := 0-1962.0724
507: , p5_a1 NUMBER := 0-1962.0724
508: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a5 DATE := fnd_api.g_miss_date
512: , p5_a6 DATE := fnd_api.g_miss_date
513: , p5_a7 NUMBER := 0-1962.0724
514: , p5_a8 DATE := fnd_api.g_miss_date
507: , p5_a1 NUMBER := 0-1962.0724
508: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a5 DATE := fnd_api.g_miss_date
512: , p5_a6 DATE := fnd_api.g_miss_date
513: , p5_a7 NUMBER := 0-1962.0724
514: , p5_a8 DATE := fnd_api.g_miss_date
515: , p5_a9 NUMBER := 0-1962.0724
508: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a5 DATE := fnd_api.g_miss_date
512: , p5_a6 DATE := fnd_api.g_miss_date
513: , p5_a7 NUMBER := 0-1962.0724
514: , p5_a8 DATE := fnd_api.g_miss_date
515: , p5_a9 NUMBER := 0-1962.0724
516: , p5_a10 DATE := fnd_api.g_miss_date
510: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a5 DATE := fnd_api.g_miss_date
512: , p5_a6 DATE := fnd_api.g_miss_date
513: , p5_a7 NUMBER := 0-1962.0724
514: , p5_a8 DATE := fnd_api.g_miss_date
515: , p5_a9 NUMBER := 0-1962.0724
516: , p5_a10 DATE := fnd_api.g_miss_date
517: , p5_a11 NUMBER := 0-1962.0724
518: )
512: , p5_a6 DATE := fnd_api.g_miss_date
513: , p5_a7 NUMBER := 0-1962.0724
514: , p5_a8 DATE := fnd_api.g_miss_date
515: , p5_a9 NUMBER := 0-1962.0724
516: , p5_a10 DATE := fnd_api.g_miss_date
517: , p5_a11 NUMBER := 0-1962.0724
518: )
519:
520: as
639: , x_msg_count out nocopy NUMBER
640: , x_msg_data out nocopy VARCHAR2
641: , p5_a0 NUMBER := 0-1962.0724
642: , p5_a1 NUMBER := 0-1962.0724
643: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a5 DATE := fnd_api.g_miss_date
647: , p5_a6 DATE := fnd_api.g_miss_date
640: , x_msg_data out nocopy VARCHAR2
641: , p5_a0 NUMBER := 0-1962.0724
642: , p5_a1 NUMBER := 0-1962.0724
643: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a5 DATE := fnd_api.g_miss_date
647: , p5_a6 DATE := fnd_api.g_miss_date
648: , p5_a7 NUMBER := 0-1962.0724
641: , p5_a0 NUMBER := 0-1962.0724
642: , p5_a1 NUMBER := 0-1962.0724
643: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a5 DATE := fnd_api.g_miss_date
647: , p5_a6 DATE := fnd_api.g_miss_date
648: , p5_a7 NUMBER := 0-1962.0724
649: , p5_a8 DATE := fnd_api.g_miss_date
642: , p5_a1 NUMBER := 0-1962.0724
643: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a5 DATE := fnd_api.g_miss_date
647: , p5_a6 DATE := fnd_api.g_miss_date
648: , p5_a7 NUMBER := 0-1962.0724
649: , p5_a8 DATE := fnd_api.g_miss_date
650: , p5_a9 NUMBER := 0-1962.0724
643: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a5 DATE := fnd_api.g_miss_date
647: , p5_a6 DATE := fnd_api.g_miss_date
648: , p5_a7 NUMBER := 0-1962.0724
649: , p5_a8 DATE := fnd_api.g_miss_date
650: , p5_a9 NUMBER := 0-1962.0724
651: , p5_a10 DATE := fnd_api.g_miss_date
645: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a5 DATE := fnd_api.g_miss_date
647: , p5_a6 DATE := fnd_api.g_miss_date
648: , p5_a7 NUMBER := 0-1962.0724
649: , p5_a8 DATE := fnd_api.g_miss_date
650: , p5_a9 NUMBER := 0-1962.0724
651: , p5_a10 DATE := fnd_api.g_miss_date
652: , p5_a11 NUMBER := 0-1962.0724
653: )
647: , p5_a6 DATE := fnd_api.g_miss_date
648: , p5_a7 NUMBER := 0-1962.0724
649: , p5_a8 DATE := fnd_api.g_miss_date
650: , p5_a9 NUMBER := 0-1962.0724
651: , p5_a10 DATE := fnd_api.g_miss_date
652: , p5_a11 NUMBER := 0-1962.0724
653: )
654:
655: as
799: , p6_a10 out nocopy DATE
800: , p6_a11 out nocopy NUMBER
801: , p5_a0 NUMBER := 0-1962.0724
802: , p5_a1 NUMBER := 0-1962.0724
803: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a5 DATE := fnd_api.g_miss_date
807: , p5_a6 DATE := fnd_api.g_miss_date
800: , p6_a11 out nocopy NUMBER
801: , p5_a0 NUMBER := 0-1962.0724
802: , p5_a1 NUMBER := 0-1962.0724
803: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a5 DATE := fnd_api.g_miss_date
807: , p5_a6 DATE := fnd_api.g_miss_date
808: , p5_a7 NUMBER := 0-1962.0724
801: , p5_a0 NUMBER := 0-1962.0724
802: , p5_a1 NUMBER := 0-1962.0724
803: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a5 DATE := fnd_api.g_miss_date
807: , p5_a6 DATE := fnd_api.g_miss_date
808: , p5_a7 NUMBER := 0-1962.0724
809: , p5_a8 DATE := fnd_api.g_miss_date
802: , p5_a1 NUMBER := 0-1962.0724
803: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a5 DATE := fnd_api.g_miss_date
807: , p5_a6 DATE := fnd_api.g_miss_date
808: , p5_a7 NUMBER := 0-1962.0724
809: , p5_a8 DATE := fnd_api.g_miss_date
810: , p5_a9 NUMBER := 0-1962.0724
803: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a5 DATE := fnd_api.g_miss_date
807: , p5_a6 DATE := fnd_api.g_miss_date
808: , p5_a7 NUMBER := 0-1962.0724
809: , p5_a8 DATE := fnd_api.g_miss_date
810: , p5_a9 NUMBER := 0-1962.0724
811: , p5_a10 DATE := fnd_api.g_miss_date
805: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a5 DATE := fnd_api.g_miss_date
807: , p5_a6 DATE := fnd_api.g_miss_date
808: , p5_a7 NUMBER := 0-1962.0724
809: , p5_a8 DATE := fnd_api.g_miss_date
810: , p5_a9 NUMBER := 0-1962.0724
811: , p5_a10 DATE := fnd_api.g_miss_date
812: , p5_a11 NUMBER := 0-1962.0724
813: )
807: , p5_a6 DATE := fnd_api.g_miss_date
808: , p5_a7 NUMBER := 0-1962.0724
809: , p5_a8 DATE := fnd_api.g_miss_date
810: , p5_a9 NUMBER := 0-1962.0724
811: , p5_a10 DATE := fnd_api.g_miss_date
812: , p5_a11 NUMBER := 0-1962.0724
813: )
814:
815: as
934: , x_msg_count out nocopy NUMBER
935: , x_msg_data out nocopy VARCHAR2
936: , p5_a0 NUMBER := 0-1962.0724
937: , p5_a1 NUMBER := 0-1962.0724
938: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a5 DATE := fnd_api.g_miss_date
942: , p5_a6 DATE := fnd_api.g_miss_date
935: , x_msg_data out nocopy VARCHAR2
936: , p5_a0 NUMBER := 0-1962.0724
937: , p5_a1 NUMBER := 0-1962.0724
938: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a5 DATE := fnd_api.g_miss_date
942: , p5_a6 DATE := fnd_api.g_miss_date
943: , p5_a7 NUMBER := 0-1962.0724
936: , p5_a0 NUMBER := 0-1962.0724
937: , p5_a1 NUMBER := 0-1962.0724
938: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a5 DATE := fnd_api.g_miss_date
942: , p5_a6 DATE := fnd_api.g_miss_date
943: , p5_a7 NUMBER := 0-1962.0724
944: , p5_a8 DATE := fnd_api.g_miss_date
937: , p5_a1 NUMBER := 0-1962.0724
938: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a5 DATE := fnd_api.g_miss_date
942: , p5_a6 DATE := fnd_api.g_miss_date
943: , p5_a7 NUMBER := 0-1962.0724
944: , p5_a8 DATE := fnd_api.g_miss_date
945: , p5_a9 NUMBER := 0-1962.0724
938: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a5 DATE := fnd_api.g_miss_date
942: , p5_a6 DATE := fnd_api.g_miss_date
943: , p5_a7 NUMBER := 0-1962.0724
944: , p5_a8 DATE := fnd_api.g_miss_date
945: , p5_a9 NUMBER := 0-1962.0724
946: , p5_a10 DATE := fnd_api.g_miss_date
940: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a5 DATE := fnd_api.g_miss_date
942: , p5_a6 DATE := fnd_api.g_miss_date
943: , p5_a7 NUMBER := 0-1962.0724
944: , p5_a8 DATE := fnd_api.g_miss_date
945: , p5_a9 NUMBER := 0-1962.0724
946: , p5_a10 DATE := fnd_api.g_miss_date
947: , p5_a11 NUMBER := 0-1962.0724
948: )
942: , p5_a6 DATE := fnd_api.g_miss_date
943: , p5_a7 NUMBER := 0-1962.0724
944: , p5_a8 DATE := fnd_api.g_miss_date
945: , p5_a9 NUMBER := 0-1962.0724
946: , p5_a10 DATE := fnd_api.g_miss_date
947: , p5_a11 NUMBER := 0-1962.0724
948: )
949:
950: as
1053: , x_msg_count out nocopy NUMBER
1054: , x_msg_data out nocopy VARCHAR2
1055: , p5_a0 NUMBER := 0-1962.0724
1056: , p5_a1 NUMBER := 0-1962.0724
1057: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a5 DATE := fnd_api.g_miss_date
1061: , p5_a6 DATE := fnd_api.g_miss_date
1054: , x_msg_data out nocopy VARCHAR2
1055: , p5_a0 NUMBER := 0-1962.0724
1056: , p5_a1 NUMBER := 0-1962.0724
1057: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a5 DATE := fnd_api.g_miss_date
1061: , p5_a6 DATE := fnd_api.g_miss_date
1062: , p5_a7 NUMBER := 0-1962.0724
1055: , p5_a0 NUMBER := 0-1962.0724
1056: , p5_a1 NUMBER := 0-1962.0724
1057: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a5 DATE := fnd_api.g_miss_date
1061: , p5_a6 DATE := fnd_api.g_miss_date
1062: , p5_a7 NUMBER := 0-1962.0724
1063: , p5_a8 DATE := fnd_api.g_miss_date
1056: , p5_a1 NUMBER := 0-1962.0724
1057: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a5 DATE := fnd_api.g_miss_date
1061: , p5_a6 DATE := fnd_api.g_miss_date
1062: , p5_a7 NUMBER := 0-1962.0724
1063: , p5_a8 DATE := fnd_api.g_miss_date
1064: , p5_a9 NUMBER := 0-1962.0724
1057: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a5 DATE := fnd_api.g_miss_date
1061: , p5_a6 DATE := fnd_api.g_miss_date
1062: , p5_a7 NUMBER := 0-1962.0724
1063: , p5_a8 DATE := fnd_api.g_miss_date
1064: , p5_a9 NUMBER := 0-1962.0724
1065: , p5_a10 DATE := fnd_api.g_miss_date
1059: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a5 DATE := fnd_api.g_miss_date
1061: , p5_a6 DATE := fnd_api.g_miss_date
1062: , p5_a7 NUMBER := 0-1962.0724
1063: , p5_a8 DATE := fnd_api.g_miss_date
1064: , p5_a9 NUMBER := 0-1962.0724
1065: , p5_a10 DATE := fnd_api.g_miss_date
1066: , p5_a11 NUMBER := 0-1962.0724
1067: )
1061: , p5_a6 DATE := fnd_api.g_miss_date
1062: , p5_a7 NUMBER := 0-1962.0724
1063: , p5_a8 DATE := fnd_api.g_miss_date
1064: , p5_a9 NUMBER := 0-1962.0724
1065: , p5_a10 DATE := fnd_api.g_miss_date
1066: , p5_a11 NUMBER := 0-1962.0724
1067: )
1068:
1069: as
1214: , p6_a11 out nocopy NUMBER
1215: , p5_a0 NUMBER := 0-1962.0724
1216: , p5_a1 NUMBER := 0-1962.0724
1217: , p5_a2 NUMBER := 0-1962.0724
1218: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a5 DATE := fnd_api.g_miss_date
1221: , p5_a6 DATE := fnd_api.g_miss_date
1222: , p5_a7 NUMBER := 0-1962.0724
1215: , p5_a0 NUMBER := 0-1962.0724
1216: , p5_a1 NUMBER := 0-1962.0724
1217: , p5_a2 NUMBER := 0-1962.0724
1218: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a5 DATE := fnd_api.g_miss_date
1221: , p5_a6 DATE := fnd_api.g_miss_date
1222: , p5_a7 NUMBER := 0-1962.0724
1223: , p5_a8 DATE := fnd_api.g_miss_date
1216: , p5_a1 NUMBER := 0-1962.0724
1217: , p5_a2 NUMBER := 0-1962.0724
1218: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a5 DATE := fnd_api.g_miss_date
1221: , p5_a6 DATE := fnd_api.g_miss_date
1222: , p5_a7 NUMBER := 0-1962.0724
1223: , p5_a8 DATE := fnd_api.g_miss_date
1224: , p5_a9 NUMBER := 0-1962.0724
1217: , p5_a2 NUMBER := 0-1962.0724
1218: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a5 DATE := fnd_api.g_miss_date
1221: , p5_a6 DATE := fnd_api.g_miss_date
1222: , p5_a7 NUMBER := 0-1962.0724
1223: , p5_a8 DATE := fnd_api.g_miss_date
1224: , p5_a9 NUMBER := 0-1962.0724
1225: , p5_a10 DATE := fnd_api.g_miss_date
1219: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a5 DATE := fnd_api.g_miss_date
1221: , p5_a6 DATE := fnd_api.g_miss_date
1222: , p5_a7 NUMBER := 0-1962.0724
1223: , p5_a8 DATE := fnd_api.g_miss_date
1224: , p5_a9 NUMBER := 0-1962.0724
1225: , p5_a10 DATE := fnd_api.g_miss_date
1226: , p5_a11 NUMBER := 0-1962.0724
1227: )
1221: , p5_a6 DATE := fnd_api.g_miss_date
1222: , p5_a7 NUMBER := 0-1962.0724
1223: , p5_a8 DATE := fnd_api.g_miss_date
1224: , p5_a9 NUMBER := 0-1962.0724
1225: , p5_a10 DATE := fnd_api.g_miss_date
1226: , p5_a11 NUMBER := 0-1962.0724
1227: )
1228:
1229: as
1349: , x_msg_data out nocopy VARCHAR2
1350: , p5_a0 NUMBER := 0-1962.0724
1351: , p5_a1 NUMBER := 0-1962.0724
1352: , p5_a2 NUMBER := 0-1962.0724
1353: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1355: , p5_a5 DATE := fnd_api.g_miss_date
1356: , p5_a6 DATE := fnd_api.g_miss_date
1357: , p5_a7 NUMBER := 0-1962.0724
1350: , p5_a0 NUMBER := 0-1962.0724
1351: , p5_a1 NUMBER := 0-1962.0724
1352: , p5_a2 NUMBER := 0-1962.0724
1353: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1355: , p5_a5 DATE := fnd_api.g_miss_date
1356: , p5_a6 DATE := fnd_api.g_miss_date
1357: , p5_a7 NUMBER := 0-1962.0724
1358: , p5_a8 DATE := fnd_api.g_miss_date
1351: , p5_a1 NUMBER := 0-1962.0724
1352: , p5_a2 NUMBER := 0-1962.0724
1353: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1355: , p5_a5 DATE := fnd_api.g_miss_date
1356: , p5_a6 DATE := fnd_api.g_miss_date
1357: , p5_a7 NUMBER := 0-1962.0724
1358: , p5_a8 DATE := fnd_api.g_miss_date
1359: , p5_a9 NUMBER := 0-1962.0724
1352: , p5_a2 NUMBER := 0-1962.0724
1353: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1355: , p5_a5 DATE := fnd_api.g_miss_date
1356: , p5_a6 DATE := fnd_api.g_miss_date
1357: , p5_a7 NUMBER := 0-1962.0724
1358: , p5_a8 DATE := fnd_api.g_miss_date
1359: , p5_a9 NUMBER := 0-1962.0724
1360: , p5_a10 DATE := fnd_api.g_miss_date
1354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1355: , p5_a5 DATE := fnd_api.g_miss_date
1356: , p5_a6 DATE := fnd_api.g_miss_date
1357: , p5_a7 NUMBER := 0-1962.0724
1358: , p5_a8 DATE := fnd_api.g_miss_date
1359: , p5_a9 NUMBER := 0-1962.0724
1360: , p5_a10 DATE := fnd_api.g_miss_date
1361: , p5_a11 NUMBER := 0-1962.0724
1362: )
1356: , p5_a6 DATE := fnd_api.g_miss_date
1357: , p5_a7 NUMBER := 0-1962.0724
1358: , p5_a8 DATE := fnd_api.g_miss_date
1359: , p5_a9 NUMBER := 0-1962.0724
1360: , p5_a10 DATE := fnd_api.g_miss_date
1361: , p5_a11 NUMBER := 0-1962.0724
1362: )
1363:
1364: as
1509: , p6_a11 out nocopy NUMBER
1510: , p5_a0 NUMBER := 0-1962.0724
1511: , p5_a1 NUMBER := 0-1962.0724
1512: , p5_a2 NUMBER := 0-1962.0724
1513: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1514: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1515: , p5_a5 DATE := fnd_api.g_miss_date
1516: , p5_a6 DATE := fnd_api.g_miss_date
1517: , p5_a7 NUMBER := 0-1962.0724
1510: , p5_a0 NUMBER := 0-1962.0724
1511: , p5_a1 NUMBER := 0-1962.0724
1512: , p5_a2 NUMBER := 0-1962.0724
1513: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1514: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1515: , p5_a5 DATE := fnd_api.g_miss_date
1516: , p5_a6 DATE := fnd_api.g_miss_date
1517: , p5_a7 NUMBER := 0-1962.0724
1518: , p5_a8 DATE := fnd_api.g_miss_date
1511: , p5_a1 NUMBER := 0-1962.0724
1512: , p5_a2 NUMBER := 0-1962.0724
1513: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1514: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1515: , p5_a5 DATE := fnd_api.g_miss_date
1516: , p5_a6 DATE := fnd_api.g_miss_date
1517: , p5_a7 NUMBER := 0-1962.0724
1518: , p5_a8 DATE := fnd_api.g_miss_date
1519: , p5_a9 NUMBER := 0-1962.0724
1512: , p5_a2 NUMBER := 0-1962.0724
1513: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1514: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1515: , p5_a5 DATE := fnd_api.g_miss_date
1516: , p5_a6 DATE := fnd_api.g_miss_date
1517: , p5_a7 NUMBER := 0-1962.0724
1518: , p5_a8 DATE := fnd_api.g_miss_date
1519: , p5_a9 NUMBER := 0-1962.0724
1520: , p5_a10 DATE := fnd_api.g_miss_date
1514: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1515: , p5_a5 DATE := fnd_api.g_miss_date
1516: , p5_a6 DATE := fnd_api.g_miss_date
1517: , p5_a7 NUMBER := 0-1962.0724
1518: , p5_a8 DATE := fnd_api.g_miss_date
1519: , p5_a9 NUMBER := 0-1962.0724
1520: , p5_a10 DATE := fnd_api.g_miss_date
1521: , p5_a11 NUMBER := 0-1962.0724
1522: )
1516: , p5_a6 DATE := fnd_api.g_miss_date
1517: , p5_a7 NUMBER := 0-1962.0724
1518: , p5_a8 DATE := fnd_api.g_miss_date
1519: , p5_a9 NUMBER := 0-1962.0724
1520: , p5_a10 DATE := fnd_api.g_miss_date
1521: , p5_a11 NUMBER := 0-1962.0724
1522: )
1523:
1524: as
1644: , x_msg_data out nocopy VARCHAR2
1645: , p5_a0 NUMBER := 0-1962.0724
1646: , p5_a1 NUMBER := 0-1962.0724
1647: , p5_a2 NUMBER := 0-1962.0724
1648: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1649: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1650: , p5_a5 DATE := fnd_api.g_miss_date
1651: , p5_a6 DATE := fnd_api.g_miss_date
1652: , p5_a7 NUMBER := 0-1962.0724
1645: , p5_a0 NUMBER := 0-1962.0724
1646: , p5_a1 NUMBER := 0-1962.0724
1647: , p5_a2 NUMBER := 0-1962.0724
1648: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1649: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1650: , p5_a5 DATE := fnd_api.g_miss_date
1651: , p5_a6 DATE := fnd_api.g_miss_date
1652: , p5_a7 NUMBER := 0-1962.0724
1653: , p5_a8 DATE := fnd_api.g_miss_date
1646: , p5_a1 NUMBER := 0-1962.0724
1647: , p5_a2 NUMBER := 0-1962.0724
1648: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1649: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1650: , p5_a5 DATE := fnd_api.g_miss_date
1651: , p5_a6 DATE := fnd_api.g_miss_date
1652: , p5_a7 NUMBER := 0-1962.0724
1653: , p5_a8 DATE := fnd_api.g_miss_date
1654: , p5_a9 NUMBER := 0-1962.0724
1647: , p5_a2 NUMBER := 0-1962.0724
1648: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1649: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1650: , p5_a5 DATE := fnd_api.g_miss_date
1651: , p5_a6 DATE := fnd_api.g_miss_date
1652: , p5_a7 NUMBER := 0-1962.0724
1653: , p5_a8 DATE := fnd_api.g_miss_date
1654: , p5_a9 NUMBER := 0-1962.0724
1655: , p5_a10 DATE := fnd_api.g_miss_date
1649: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1650: , p5_a5 DATE := fnd_api.g_miss_date
1651: , p5_a6 DATE := fnd_api.g_miss_date
1652: , p5_a7 NUMBER := 0-1962.0724
1653: , p5_a8 DATE := fnd_api.g_miss_date
1654: , p5_a9 NUMBER := 0-1962.0724
1655: , p5_a10 DATE := fnd_api.g_miss_date
1656: , p5_a11 NUMBER := 0-1962.0724
1657: )
1651: , p5_a6 DATE := fnd_api.g_miss_date
1652: , p5_a7 NUMBER := 0-1962.0724
1653: , p5_a8 DATE := fnd_api.g_miss_date
1654: , p5_a9 NUMBER := 0-1962.0724
1655: , p5_a10 DATE := fnd_api.g_miss_date
1656: , p5_a11 NUMBER := 0-1962.0724
1657: )
1658:
1659: as
1763: , x_msg_data out nocopy VARCHAR2
1764: , p5_a0 NUMBER := 0-1962.0724
1765: , p5_a1 NUMBER := 0-1962.0724
1766: , p5_a2 NUMBER := 0-1962.0724
1767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1768: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1769: , p5_a5 DATE := fnd_api.g_miss_date
1770: , p5_a6 DATE := fnd_api.g_miss_date
1771: , p5_a7 NUMBER := 0-1962.0724
1764: , p5_a0 NUMBER := 0-1962.0724
1765: , p5_a1 NUMBER := 0-1962.0724
1766: , p5_a2 NUMBER := 0-1962.0724
1767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1768: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1769: , p5_a5 DATE := fnd_api.g_miss_date
1770: , p5_a6 DATE := fnd_api.g_miss_date
1771: , p5_a7 NUMBER := 0-1962.0724
1772: , p5_a8 DATE := fnd_api.g_miss_date
1765: , p5_a1 NUMBER := 0-1962.0724
1766: , p5_a2 NUMBER := 0-1962.0724
1767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1768: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1769: , p5_a5 DATE := fnd_api.g_miss_date
1770: , p5_a6 DATE := fnd_api.g_miss_date
1771: , p5_a7 NUMBER := 0-1962.0724
1772: , p5_a8 DATE := fnd_api.g_miss_date
1773: , p5_a9 NUMBER := 0-1962.0724
1766: , p5_a2 NUMBER := 0-1962.0724
1767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1768: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1769: , p5_a5 DATE := fnd_api.g_miss_date
1770: , p5_a6 DATE := fnd_api.g_miss_date
1771: , p5_a7 NUMBER := 0-1962.0724
1772: , p5_a8 DATE := fnd_api.g_miss_date
1773: , p5_a9 NUMBER := 0-1962.0724
1774: , p5_a10 DATE := fnd_api.g_miss_date
1768: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1769: , p5_a5 DATE := fnd_api.g_miss_date
1770: , p5_a6 DATE := fnd_api.g_miss_date
1771: , p5_a7 NUMBER := 0-1962.0724
1772: , p5_a8 DATE := fnd_api.g_miss_date
1773: , p5_a9 NUMBER := 0-1962.0724
1774: , p5_a10 DATE := fnd_api.g_miss_date
1775: , p5_a11 NUMBER := 0-1962.0724
1776: )
1770: , p5_a6 DATE := fnd_api.g_miss_date
1771: , p5_a7 NUMBER := 0-1962.0724
1772: , p5_a8 DATE := fnd_api.g_miss_date
1773: , p5_a9 NUMBER := 0-1962.0724
1774: , p5_a10 DATE := fnd_api.g_miss_date
1775: , p5_a11 NUMBER := 0-1962.0724
1776: )
1777:
1778: as