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;
43: , p6_a16 out nocopy DATE
44: , p6_a17 out nocopy NUMBER
45: , p5_a0 NUMBER := 0-1962.0724
46: , p5_a1 NUMBER := 0-1962.0724
47: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 NUMBER := 0-1962.0724
51: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p6_a17 out nocopy NUMBER
45: , p5_a0 NUMBER := 0-1962.0724
46: , p5_a1 NUMBER := 0-1962.0724
47: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 NUMBER := 0-1962.0724
51: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a0 NUMBER := 0-1962.0724
46: , p5_a1 NUMBER := 0-1962.0724
47: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 NUMBER := 0-1962.0724
51: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 NUMBER := 0-1962.0724
51: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a10 DATE := fnd_api.g_miss_date
48: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 NUMBER := 0-1962.0724
51: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a10 DATE := fnd_api.g_miss_date
56: , p5_a11 DATE := fnd_api.g_miss_date
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 NUMBER := 0-1962.0724
51: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a10 DATE := fnd_api.g_miss_date
56: , p5_a11 DATE := fnd_api.g_miss_date
57: , p5_a12 NUMBER := 0-1962.0724
50: , p5_a5 NUMBER := 0-1962.0724
51: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a10 DATE := fnd_api.g_miss_date
56: , p5_a11 DATE := fnd_api.g_miss_date
57: , p5_a12 NUMBER := 0-1962.0724
58: , p5_a13 NUMBER := 0-1962.0724
51: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a10 DATE := fnd_api.g_miss_date
56: , p5_a11 DATE := fnd_api.g_miss_date
57: , p5_a12 NUMBER := 0-1962.0724
58: , p5_a13 NUMBER := 0-1962.0724
59: , p5_a14 DATE := fnd_api.g_miss_date
52: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a10 DATE := fnd_api.g_miss_date
56: , p5_a11 DATE := fnd_api.g_miss_date
57: , p5_a12 NUMBER := 0-1962.0724
58: , p5_a13 NUMBER := 0-1962.0724
59: , p5_a14 DATE := fnd_api.g_miss_date
60: , p5_a15 NUMBER := 0-1962.0724
55: , p5_a10 DATE := fnd_api.g_miss_date
56: , p5_a11 DATE := fnd_api.g_miss_date
57: , p5_a12 NUMBER := 0-1962.0724
58: , p5_a13 NUMBER := 0-1962.0724
59: , p5_a14 DATE := fnd_api.g_miss_date
60: , p5_a15 NUMBER := 0-1962.0724
61: , p5_a16 DATE := fnd_api.g_miss_date
62: , p5_a17 NUMBER := 0-1962.0724
63: )
57: , p5_a12 NUMBER := 0-1962.0724
58: , p5_a13 NUMBER := 0-1962.0724
59: , p5_a14 DATE := fnd_api.g_miss_date
60: , p5_a15 NUMBER := 0-1962.0724
61: , p5_a16 DATE := fnd_api.g_miss_date
62: , p5_a17 NUMBER := 0-1962.0724
63: )
64:
65: as
249: , x_msg_count out nocopy NUMBER
250: , x_msg_data out nocopy VARCHAR2
251: , p5_a0 NUMBER := 0-1962.0724
252: , p5_a1 NUMBER := 0-1962.0724
253: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 NUMBER := 0-1962.0724
257: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
250: , x_msg_data out nocopy VARCHAR2
251: , p5_a0 NUMBER := 0-1962.0724
252: , p5_a1 NUMBER := 0-1962.0724
253: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 NUMBER := 0-1962.0724
257: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a0 NUMBER := 0-1962.0724
252: , p5_a1 NUMBER := 0-1962.0724
253: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 NUMBER := 0-1962.0724
257: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 NUMBER := 0-1962.0724
257: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a10 DATE := fnd_api.g_miss_date
254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 NUMBER := 0-1962.0724
257: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a10 DATE := fnd_api.g_miss_date
262: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 NUMBER := 0-1962.0724
257: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a10 DATE := fnd_api.g_miss_date
262: , p5_a11 DATE := fnd_api.g_miss_date
263: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a5 NUMBER := 0-1962.0724
257: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a10 DATE := fnd_api.g_miss_date
262: , p5_a11 DATE := fnd_api.g_miss_date
263: , p5_a12 NUMBER := 0-1962.0724
264: , p5_a13 NUMBER := 0-1962.0724
257: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a10 DATE := fnd_api.g_miss_date
262: , p5_a11 DATE := fnd_api.g_miss_date
263: , p5_a12 NUMBER := 0-1962.0724
264: , p5_a13 NUMBER := 0-1962.0724
265: , p5_a14 DATE := fnd_api.g_miss_date
258: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a10 DATE := fnd_api.g_miss_date
262: , p5_a11 DATE := fnd_api.g_miss_date
263: , p5_a12 NUMBER := 0-1962.0724
264: , p5_a13 NUMBER := 0-1962.0724
265: , p5_a14 DATE := fnd_api.g_miss_date
266: , p5_a15 NUMBER := 0-1962.0724
261: , p5_a10 DATE := fnd_api.g_miss_date
262: , p5_a11 DATE := fnd_api.g_miss_date
263: , p5_a12 NUMBER := 0-1962.0724
264: , p5_a13 NUMBER := 0-1962.0724
265: , p5_a14 DATE := fnd_api.g_miss_date
266: , p5_a15 NUMBER := 0-1962.0724
267: , p5_a16 DATE := fnd_api.g_miss_date
268: , p5_a17 NUMBER := 0-1962.0724
269: )
263: , p5_a12 NUMBER := 0-1962.0724
264: , p5_a13 NUMBER := 0-1962.0724
265: , p5_a14 DATE := fnd_api.g_miss_date
266: , p5_a15 NUMBER := 0-1962.0724
267: , p5_a16 DATE := fnd_api.g_miss_date
268: , p5_a17 NUMBER := 0-1962.0724
269: )
270:
271: as
410: , p6_a16 out nocopy DATE
411: , p6_a17 out nocopy NUMBER
412: , p5_a0 NUMBER := 0-1962.0724
413: , p5_a1 NUMBER := 0-1962.0724
414: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a5 NUMBER := 0-1962.0724
418: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
411: , p6_a17 out nocopy NUMBER
412: , p5_a0 NUMBER := 0-1962.0724
413: , p5_a1 NUMBER := 0-1962.0724
414: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a5 NUMBER := 0-1962.0724
418: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a0 NUMBER := 0-1962.0724
413: , p5_a1 NUMBER := 0-1962.0724
414: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a5 NUMBER := 0-1962.0724
418: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a5 NUMBER := 0-1962.0724
418: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a10 DATE := fnd_api.g_miss_date
415: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a5 NUMBER := 0-1962.0724
418: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a10 DATE := fnd_api.g_miss_date
423: , p5_a11 DATE := fnd_api.g_miss_date
416: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a5 NUMBER := 0-1962.0724
418: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a10 DATE := fnd_api.g_miss_date
423: , p5_a11 DATE := fnd_api.g_miss_date
424: , p5_a12 NUMBER := 0-1962.0724
417: , p5_a5 NUMBER := 0-1962.0724
418: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a10 DATE := fnd_api.g_miss_date
423: , p5_a11 DATE := fnd_api.g_miss_date
424: , p5_a12 NUMBER := 0-1962.0724
425: , p5_a13 NUMBER := 0-1962.0724
418: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a10 DATE := fnd_api.g_miss_date
423: , p5_a11 DATE := fnd_api.g_miss_date
424: , p5_a12 NUMBER := 0-1962.0724
425: , p5_a13 NUMBER := 0-1962.0724
426: , p5_a14 DATE := fnd_api.g_miss_date
419: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a10 DATE := fnd_api.g_miss_date
423: , p5_a11 DATE := fnd_api.g_miss_date
424: , p5_a12 NUMBER := 0-1962.0724
425: , p5_a13 NUMBER := 0-1962.0724
426: , p5_a14 DATE := fnd_api.g_miss_date
427: , p5_a15 NUMBER := 0-1962.0724
422: , p5_a10 DATE := fnd_api.g_miss_date
423: , p5_a11 DATE := fnd_api.g_miss_date
424: , p5_a12 NUMBER := 0-1962.0724
425: , p5_a13 NUMBER := 0-1962.0724
426: , p5_a14 DATE := fnd_api.g_miss_date
427: , p5_a15 NUMBER := 0-1962.0724
428: , p5_a16 DATE := fnd_api.g_miss_date
429: , p5_a17 NUMBER := 0-1962.0724
430: )
424: , p5_a12 NUMBER := 0-1962.0724
425: , p5_a13 NUMBER := 0-1962.0724
426: , p5_a14 DATE := fnd_api.g_miss_date
427: , p5_a15 NUMBER := 0-1962.0724
428: , p5_a16 DATE := fnd_api.g_miss_date
429: , p5_a17 NUMBER := 0-1962.0724
430: )
431:
432: as
616: , x_msg_count out nocopy NUMBER
617: , x_msg_data out nocopy VARCHAR2
618: , p5_a0 NUMBER := 0-1962.0724
619: , p5_a1 NUMBER := 0-1962.0724
620: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a5 NUMBER := 0-1962.0724
624: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
617: , x_msg_data out nocopy VARCHAR2
618: , p5_a0 NUMBER := 0-1962.0724
619: , p5_a1 NUMBER := 0-1962.0724
620: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a5 NUMBER := 0-1962.0724
624: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a0 NUMBER := 0-1962.0724
619: , p5_a1 NUMBER := 0-1962.0724
620: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a5 NUMBER := 0-1962.0724
624: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a5 NUMBER := 0-1962.0724
624: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a10 DATE := fnd_api.g_miss_date
621: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a5 NUMBER := 0-1962.0724
624: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a10 DATE := fnd_api.g_miss_date
629: , p5_a11 DATE := fnd_api.g_miss_date
622: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a5 NUMBER := 0-1962.0724
624: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a10 DATE := fnd_api.g_miss_date
629: , p5_a11 DATE := fnd_api.g_miss_date
630: , p5_a12 NUMBER := 0-1962.0724
623: , p5_a5 NUMBER := 0-1962.0724
624: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a10 DATE := fnd_api.g_miss_date
629: , p5_a11 DATE := fnd_api.g_miss_date
630: , p5_a12 NUMBER := 0-1962.0724
631: , p5_a13 NUMBER := 0-1962.0724
624: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a10 DATE := fnd_api.g_miss_date
629: , p5_a11 DATE := fnd_api.g_miss_date
630: , p5_a12 NUMBER := 0-1962.0724
631: , p5_a13 NUMBER := 0-1962.0724
632: , p5_a14 DATE := fnd_api.g_miss_date
625: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a10 DATE := fnd_api.g_miss_date
629: , p5_a11 DATE := fnd_api.g_miss_date
630: , p5_a12 NUMBER := 0-1962.0724
631: , p5_a13 NUMBER := 0-1962.0724
632: , p5_a14 DATE := fnd_api.g_miss_date
633: , p5_a15 NUMBER := 0-1962.0724
628: , p5_a10 DATE := fnd_api.g_miss_date
629: , p5_a11 DATE := fnd_api.g_miss_date
630: , p5_a12 NUMBER := 0-1962.0724
631: , p5_a13 NUMBER := 0-1962.0724
632: , p5_a14 DATE := fnd_api.g_miss_date
633: , p5_a15 NUMBER := 0-1962.0724
634: , p5_a16 DATE := fnd_api.g_miss_date
635: , p5_a17 NUMBER := 0-1962.0724
636: )
630: , p5_a12 NUMBER := 0-1962.0724
631: , p5_a13 NUMBER := 0-1962.0724
632: , p5_a14 DATE := fnd_api.g_miss_date
633: , p5_a15 NUMBER := 0-1962.0724
634: , p5_a16 DATE := fnd_api.g_miss_date
635: , p5_a17 NUMBER := 0-1962.0724
636: )
637:
638: as
759: , x_msg_count out nocopy NUMBER
760: , x_msg_data out nocopy VARCHAR2
761: , p5_a0 NUMBER := 0-1962.0724
762: , p5_a1 NUMBER := 0-1962.0724
763: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 NUMBER := 0-1962.0724
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
760: , x_msg_data out nocopy VARCHAR2
761: , p5_a0 NUMBER := 0-1962.0724
762: , p5_a1 NUMBER := 0-1962.0724
763: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 NUMBER := 0-1962.0724
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a0 NUMBER := 0-1962.0724
762: , p5_a1 NUMBER := 0-1962.0724
763: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 NUMBER := 0-1962.0724
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 NUMBER := 0-1962.0724
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 DATE := fnd_api.g_miss_date
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 NUMBER := 0-1962.0724
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 DATE := fnd_api.g_miss_date
772: , p5_a11 DATE := fnd_api.g_miss_date
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 NUMBER := 0-1962.0724
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 DATE := fnd_api.g_miss_date
772: , p5_a11 DATE := fnd_api.g_miss_date
773: , p5_a12 NUMBER := 0-1962.0724
766: , p5_a5 NUMBER := 0-1962.0724
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 DATE := fnd_api.g_miss_date
772: , p5_a11 DATE := fnd_api.g_miss_date
773: , p5_a12 NUMBER := 0-1962.0724
774: , p5_a13 NUMBER := 0-1962.0724
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 DATE := fnd_api.g_miss_date
772: , p5_a11 DATE := fnd_api.g_miss_date
773: , p5_a12 NUMBER := 0-1962.0724
774: , p5_a13 NUMBER := 0-1962.0724
775: , p5_a14 DATE := fnd_api.g_miss_date
768: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 DATE := fnd_api.g_miss_date
772: , p5_a11 DATE := fnd_api.g_miss_date
773: , p5_a12 NUMBER := 0-1962.0724
774: , p5_a13 NUMBER := 0-1962.0724
775: , p5_a14 DATE := fnd_api.g_miss_date
776: , p5_a15 NUMBER := 0-1962.0724
771: , p5_a10 DATE := fnd_api.g_miss_date
772: , p5_a11 DATE := fnd_api.g_miss_date
773: , p5_a12 NUMBER := 0-1962.0724
774: , p5_a13 NUMBER := 0-1962.0724
775: , p5_a14 DATE := fnd_api.g_miss_date
776: , p5_a15 NUMBER := 0-1962.0724
777: , p5_a16 DATE := fnd_api.g_miss_date
778: , p5_a17 NUMBER := 0-1962.0724
779: )
773: , p5_a12 NUMBER := 0-1962.0724
774: , p5_a13 NUMBER := 0-1962.0724
775: , p5_a14 DATE := fnd_api.g_miss_date
776: , p5_a15 NUMBER := 0-1962.0724
777: , p5_a16 DATE := fnd_api.g_miss_date
778: , p5_a17 NUMBER := 0-1962.0724
779: )
780:
781: as