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;
236: , p6_a32 out nocopy DATE
237: , p6_a33 out nocopy NUMBER
238: , p5_a0 NUMBER := 0-1962.0724
239: , p5_a1 NUMBER := 0-1962.0724
240: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a3 NUMBER := 0-1962.0724
242: , p5_a4 NUMBER := 0-1962.0724
243: , p5_a5 NUMBER := 0-1962.0724
244: , p5_a6 NUMBER := 0-1962.0724
241: , p5_a3 NUMBER := 0-1962.0724
242: , p5_a4 NUMBER := 0-1962.0724
243: , p5_a5 NUMBER := 0-1962.0724
244: , p5_a6 NUMBER := 0-1962.0724
245: , p5_a7 DATE := fnd_api.g_miss_date
246: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a4 NUMBER := 0-1962.0724
243: , p5_a5 NUMBER := 0-1962.0724
244: , p5_a6 NUMBER := 0-1962.0724
245: , p5_a7 DATE := fnd_api.g_miss_date
246: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a5 NUMBER := 0-1962.0724
244: , p5_a6 NUMBER := 0-1962.0724
245: , p5_a7 DATE := fnd_api.g_miss_date
246: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a6 NUMBER := 0-1962.0724
245: , p5_a7 DATE := fnd_api.g_miss_date
246: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a7 DATE := fnd_api.g_miss_date
246: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
262: , p5_a24 NUMBER := 0-1962.0724
255: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
262: , p5_a24 NUMBER := 0-1962.0724
263: , p5_a25 NUMBER := 0-1962.0724
256: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
262: , p5_a24 NUMBER := 0-1962.0724
263: , p5_a25 NUMBER := 0-1962.0724
264: , p5_a26 NUMBER := 0-1962.0724
257: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
262: , p5_a24 NUMBER := 0-1962.0724
263: , p5_a25 NUMBER := 0-1962.0724
264: , p5_a26 NUMBER := 0-1962.0724
265: , p5_a27 NUMBER := 0-1962.0724
262: , p5_a24 NUMBER := 0-1962.0724
263: , p5_a25 NUMBER := 0-1962.0724
264: , p5_a26 NUMBER := 0-1962.0724
265: , p5_a27 NUMBER := 0-1962.0724
266: , p5_a28 DATE := fnd_api.g_miss_date
267: , p5_a29 NUMBER := 0-1962.0724
268: , p5_a30 DATE := fnd_api.g_miss_date
269: , p5_a31 NUMBER := 0-1962.0724
270: , p5_a32 DATE := fnd_api.g_miss_date
264: , p5_a26 NUMBER := 0-1962.0724
265: , p5_a27 NUMBER := 0-1962.0724
266: , p5_a28 DATE := fnd_api.g_miss_date
267: , p5_a29 NUMBER := 0-1962.0724
268: , p5_a30 DATE := fnd_api.g_miss_date
269: , p5_a31 NUMBER := 0-1962.0724
270: , p5_a32 DATE := fnd_api.g_miss_date
271: , p5_a33 NUMBER := 0-1962.0724
272: )
266: , p5_a28 DATE := fnd_api.g_miss_date
267: , p5_a29 NUMBER := 0-1962.0724
268: , p5_a30 DATE := fnd_api.g_miss_date
269: , p5_a31 NUMBER := 0-1962.0724
270: , p5_a32 DATE := fnd_api.g_miss_date
271: , p5_a33 NUMBER := 0-1962.0724
272: )
273:
274: as
481: , x_msg_count out nocopy NUMBER
482: , x_msg_data out nocopy VARCHAR2
483: , p5_a0 NUMBER := 0-1962.0724
484: , p5_a1 NUMBER := 0-1962.0724
485: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a3 NUMBER := 0-1962.0724
487: , p5_a4 NUMBER := 0-1962.0724
488: , p5_a5 NUMBER := 0-1962.0724
489: , p5_a6 NUMBER := 0-1962.0724
486: , p5_a3 NUMBER := 0-1962.0724
487: , p5_a4 NUMBER := 0-1962.0724
488: , p5_a5 NUMBER := 0-1962.0724
489: , p5_a6 NUMBER := 0-1962.0724
490: , p5_a7 DATE := fnd_api.g_miss_date
491: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a4 NUMBER := 0-1962.0724
488: , p5_a5 NUMBER := 0-1962.0724
489: , p5_a6 NUMBER := 0-1962.0724
490: , p5_a7 DATE := fnd_api.g_miss_date
491: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a5 NUMBER := 0-1962.0724
489: , p5_a6 NUMBER := 0-1962.0724
490: , p5_a7 DATE := fnd_api.g_miss_date
491: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a6 NUMBER := 0-1962.0724
490: , p5_a7 DATE := fnd_api.g_miss_date
491: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a7 DATE := fnd_api.g_miss_date
491: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a24 NUMBER := 0-1962.0724
500: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a24 NUMBER := 0-1962.0724
508: , p5_a25 NUMBER := 0-1962.0724
501: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a24 NUMBER := 0-1962.0724
508: , p5_a25 NUMBER := 0-1962.0724
509: , p5_a26 NUMBER := 0-1962.0724
502: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
507: , p5_a24 NUMBER := 0-1962.0724
508: , p5_a25 NUMBER := 0-1962.0724
509: , p5_a26 NUMBER := 0-1962.0724
510: , p5_a27 NUMBER := 0-1962.0724
507: , p5_a24 NUMBER := 0-1962.0724
508: , p5_a25 NUMBER := 0-1962.0724
509: , p5_a26 NUMBER := 0-1962.0724
510: , p5_a27 NUMBER := 0-1962.0724
511: , p5_a28 DATE := fnd_api.g_miss_date
512: , p5_a29 NUMBER := 0-1962.0724
513: , p5_a30 DATE := fnd_api.g_miss_date
514: , p5_a31 NUMBER := 0-1962.0724
515: , p5_a32 DATE := fnd_api.g_miss_date
509: , p5_a26 NUMBER := 0-1962.0724
510: , p5_a27 NUMBER := 0-1962.0724
511: , p5_a28 DATE := fnd_api.g_miss_date
512: , p5_a29 NUMBER := 0-1962.0724
513: , p5_a30 DATE := fnd_api.g_miss_date
514: , p5_a31 NUMBER := 0-1962.0724
515: , p5_a32 DATE := fnd_api.g_miss_date
516: , p5_a33 NUMBER := 0-1962.0724
517: )
511: , p5_a28 DATE := fnd_api.g_miss_date
512: , p5_a29 NUMBER := 0-1962.0724
513: , p5_a30 DATE := fnd_api.g_miss_date
514: , p5_a31 NUMBER := 0-1962.0724
515: , p5_a32 DATE := fnd_api.g_miss_date
516: , p5_a33 NUMBER := 0-1962.0724
517: )
518:
519: as
795: , p6_a32 out nocopy DATE
796: , p6_a33 out nocopy NUMBER
797: , p5_a0 NUMBER := 0-1962.0724
798: , p5_a1 NUMBER := 0-1962.0724
799: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
800: , p5_a3 NUMBER := 0-1962.0724
801: , p5_a4 NUMBER := 0-1962.0724
802: , p5_a5 NUMBER := 0-1962.0724
803: , p5_a6 NUMBER := 0-1962.0724
800: , p5_a3 NUMBER := 0-1962.0724
801: , p5_a4 NUMBER := 0-1962.0724
802: , p5_a5 NUMBER := 0-1962.0724
803: , p5_a6 NUMBER := 0-1962.0724
804: , p5_a7 DATE := fnd_api.g_miss_date
805: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a4 NUMBER := 0-1962.0724
802: , p5_a5 NUMBER := 0-1962.0724
803: , p5_a6 NUMBER := 0-1962.0724
804: , p5_a7 DATE := fnd_api.g_miss_date
805: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
802: , p5_a5 NUMBER := 0-1962.0724
803: , p5_a6 NUMBER := 0-1962.0724
804: , p5_a7 DATE := fnd_api.g_miss_date
805: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a6 NUMBER := 0-1962.0724
804: , p5_a7 DATE := fnd_api.g_miss_date
805: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a7 DATE := fnd_api.g_miss_date
805: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a24 NUMBER := 0-1962.0724
814: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a24 NUMBER := 0-1962.0724
822: , p5_a25 NUMBER := 0-1962.0724
815: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a24 NUMBER := 0-1962.0724
822: , p5_a25 NUMBER := 0-1962.0724
823: , p5_a26 NUMBER := 0-1962.0724
816: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a24 NUMBER := 0-1962.0724
822: , p5_a25 NUMBER := 0-1962.0724
823: , p5_a26 NUMBER := 0-1962.0724
824: , p5_a27 NUMBER := 0-1962.0724
821: , p5_a24 NUMBER := 0-1962.0724
822: , p5_a25 NUMBER := 0-1962.0724
823: , p5_a26 NUMBER := 0-1962.0724
824: , p5_a27 NUMBER := 0-1962.0724
825: , p5_a28 DATE := fnd_api.g_miss_date
826: , p5_a29 NUMBER := 0-1962.0724
827: , p5_a30 DATE := fnd_api.g_miss_date
828: , p5_a31 NUMBER := 0-1962.0724
829: , p5_a32 DATE := fnd_api.g_miss_date
823: , p5_a26 NUMBER := 0-1962.0724
824: , p5_a27 NUMBER := 0-1962.0724
825: , p5_a28 DATE := fnd_api.g_miss_date
826: , p5_a29 NUMBER := 0-1962.0724
827: , p5_a30 DATE := fnd_api.g_miss_date
828: , p5_a31 NUMBER := 0-1962.0724
829: , p5_a32 DATE := fnd_api.g_miss_date
830: , p5_a33 NUMBER := 0-1962.0724
831: )
825: , p5_a28 DATE := fnd_api.g_miss_date
826: , p5_a29 NUMBER := 0-1962.0724
827: , p5_a30 DATE := fnd_api.g_miss_date
828: , p5_a31 NUMBER := 0-1962.0724
829: , p5_a32 DATE := fnd_api.g_miss_date
830: , p5_a33 NUMBER := 0-1962.0724
831: )
832:
833: as
1040: , x_msg_count out nocopy NUMBER
1041: , x_msg_data out nocopy VARCHAR2
1042: , p5_a0 NUMBER := 0-1962.0724
1043: , p5_a1 NUMBER := 0-1962.0724
1044: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1045: , p5_a3 NUMBER := 0-1962.0724
1046: , p5_a4 NUMBER := 0-1962.0724
1047: , p5_a5 NUMBER := 0-1962.0724
1048: , p5_a6 NUMBER := 0-1962.0724
1045: , p5_a3 NUMBER := 0-1962.0724
1046: , p5_a4 NUMBER := 0-1962.0724
1047: , p5_a5 NUMBER := 0-1962.0724
1048: , p5_a6 NUMBER := 0-1962.0724
1049: , p5_a7 DATE := fnd_api.g_miss_date
1050: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1051: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1052: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1046: , p5_a4 NUMBER := 0-1962.0724
1047: , p5_a5 NUMBER := 0-1962.0724
1048: , p5_a6 NUMBER := 0-1962.0724
1049: , p5_a7 DATE := fnd_api.g_miss_date
1050: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1051: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1052: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1047: , p5_a5 NUMBER := 0-1962.0724
1048: , p5_a6 NUMBER := 0-1962.0724
1049: , p5_a7 DATE := fnd_api.g_miss_date
1050: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1051: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1052: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1055: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1048: , p5_a6 NUMBER := 0-1962.0724
1049: , p5_a7 DATE := fnd_api.g_miss_date
1050: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1051: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1052: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1055: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1056: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1049: , p5_a7 DATE := fnd_api.g_miss_date
1050: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1051: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1052: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1055: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1056: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1050: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1051: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1052: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1055: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1056: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1051: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1052: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1055: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1056: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1052: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1055: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1056: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1055: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1056: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1061: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1055: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1056: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1061: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1055: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1056: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1061: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1056: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1061: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1061: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1058: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1059: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1061: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1066: , p5_a24 NUMBER := 0-1962.0724
1059: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1061: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1066: , p5_a24 NUMBER := 0-1962.0724
1067: , p5_a25 NUMBER := 0-1962.0724
1060: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1061: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1066: , p5_a24 NUMBER := 0-1962.0724
1067: , p5_a25 NUMBER := 0-1962.0724
1068: , p5_a26 NUMBER := 0-1962.0724
1061: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1066: , p5_a24 NUMBER := 0-1962.0724
1067: , p5_a25 NUMBER := 0-1962.0724
1068: , p5_a26 NUMBER := 0-1962.0724
1069: , p5_a27 NUMBER := 0-1962.0724
1066: , p5_a24 NUMBER := 0-1962.0724
1067: , p5_a25 NUMBER := 0-1962.0724
1068: , p5_a26 NUMBER := 0-1962.0724
1069: , p5_a27 NUMBER := 0-1962.0724
1070: , p5_a28 DATE := fnd_api.g_miss_date
1071: , p5_a29 NUMBER := 0-1962.0724
1072: , p5_a30 DATE := fnd_api.g_miss_date
1073: , p5_a31 NUMBER := 0-1962.0724
1074: , p5_a32 DATE := fnd_api.g_miss_date
1068: , p5_a26 NUMBER := 0-1962.0724
1069: , p5_a27 NUMBER := 0-1962.0724
1070: , p5_a28 DATE := fnd_api.g_miss_date
1071: , p5_a29 NUMBER := 0-1962.0724
1072: , p5_a30 DATE := fnd_api.g_miss_date
1073: , p5_a31 NUMBER := 0-1962.0724
1074: , p5_a32 DATE := fnd_api.g_miss_date
1075: , p5_a33 NUMBER := 0-1962.0724
1076: )
1070: , p5_a28 DATE := fnd_api.g_miss_date
1071: , p5_a29 NUMBER := 0-1962.0724
1072: , p5_a30 DATE := fnd_api.g_miss_date
1073: , p5_a31 NUMBER := 0-1962.0724
1074: , p5_a32 DATE := fnd_api.g_miss_date
1075: , p5_a33 NUMBER := 0-1962.0724
1076: )
1077:
1078: as
1247: , x_msg_count out nocopy NUMBER
1248: , x_msg_data out nocopy VARCHAR2
1249: , p5_a0 NUMBER := 0-1962.0724
1250: , p5_a1 NUMBER := 0-1962.0724
1251: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1252: , p5_a3 NUMBER := 0-1962.0724
1253: , p5_a4 NUMBER := 0-1962.0724
1254: , p5_a5 NUMBER := 0-1962.0724
1255: , p5_a6 NUMBER := 0-1962.0724
1252: , p5_a3 NUMBER := 0-1962.0724
1253: , p5_a4 NUMBER := 0-1962.0724
1254: , p5_a5 NUMBER := 0-1962.0724
1255: , p5_a6 NUMBER := 0-1962.0724
1256: , p5_a7 DATE := fnd_api.g_miss_date
1257: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1253: , p5_a4 NUMBER := 0-1962.0724
1254: , p5_a5 NUMBER := 0-1962.0724
1255: , p5_a6 NUMBER := 0-1962.0724
1256: , p5_a7 DATE := fnd_api.g_miss_date
1257: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1254: , p5_a5 NUMBER := 0-1962.0724
1255: , p5_a6 NUMBER := 0-1962.0724
1256: , p5_a7 DATE := fnd_api.g_miss_date
1257: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a6 NUMBER := 0-1962.0724
1256: , p5_a7 DATE := fnd_api.g_miss_date
1257: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a7 DATE := fnd_api.g_miss_date
1257: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a24 NUMBER := 0-1962.0724
1266: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a24 NUMBER := 0-1962.0724
1274: , p5_a25 NUMBER := 0-1962.0724
1267: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a24 NUMBER := 0-1962.0724
1274: , p5_a25 NUMBER := 0-1962.0724
1275: , p5_a26 NUMBER := 0-1962.0724
1268: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a24 NUMBER := 0-1962.0724
1274: , p5_a25 NUMBER := 0-1962.0724
1275: , p5_a26 NUMBER := 0-1962.0724
1276: , p5_a27 NUMBER := 0-1962.0724
1273: , p5_a24 NUMBER := 0-1962.0724
1274: , p5_a25 NUMBER := 0-1962.0724
1275: , p5_a26 NUMBER := 0-1962.0724
1276: , p5_a27 NUMBER := 0-1962.0724
1277: , p5_a28 DATE := fnd_api.g_miss_date
1278: , p5_a29 NUMBER := 0-1962.0724
1279: , p5_a30 DATE := fnd_api.g_miss_date
1280: , p5_a31 NUMBER := 0-1962.0724
1281: , p5_a32 DATE := fnd_api.g_miss_date
1275: , p5_a26 NUMBER := 0-1962.0724
1276: , p5_a27 NUMBER := 0-1962.0724
1277: , p5_a28 DATE := fnd_api.g_miss_date
1278: , p5_a29 NUMBER := 0-1962.0724
1279: , p5_a30 DATE := fnd_api.g_miss_date
1280: , p5_a31 NUMBER := 0-1962.0724
1281: , p5_a32 DATE := fnd_api.g_miss_date
1282: , p5_a33 NUMBER := 0-1962.0724
1283: )
1277: , p5_a28 DATE := fnd_api.g_miss_date
1278: , p5_a29 NUMBER := 0-1962.0724
1279: , p5_a30 DATE := fnd_api.g_miss_date
1280: , p5_a31 NUMBER := 0-1962.0724
1281: , p5_a32 DATE := fnd_api.g_miss_date
1282: , p5_a33 NUMBER := 0-1962.0724
1283: )
1284:
1285: as