7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;
367: , p6_a35 out nocopy VARCHAR2
368: , p6_a36 out nocopy VARCHAR2
369: , p6_a37 out nocopy NUMBER
370: , p5_a0 NUMBER := 0-1962.0724
371: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a2 NUMBER := 0-1962.0724
373: , p5_a3 NUMBER := 0-1962.0724
374: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a5 DATE := fnd_api.g_miss_date
370: , p5_a0 NUMBER := 0-1962.0724
371: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a2 NUMBER := 0-1962.0724
373: , p5_a3 NUMBER := 0-1962.0724
374: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a5 DATE := fnd_api.g_miss_date
376: , p5_a6 DATE := fnd_api.g_miss_date
377: , p5_a7 DATE := fnd_api.g_miss_date
378: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a2 NUMBER := 0-1962.0724
373: , p5_a3 NUMBER := 0-1962.0724
374: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a5 DATE := fnd_api.g_miss_date
376: , p5_a6 DATE := fnd_api.g_miss_date
377: , p5_a7 DATE := fnd_api.g_miss_date
378: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a2 NUMBER := 0-1962.0724
373: , p5_a3 NUMBER := 0-1962.0724
374: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a5 DATE := fnd_api.g_miss_date
376: , p5_a6 DATE := fnd_api.g_miss_date
377: , p5_a7 DATE := fnd_api.g_miss_date
378: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a3 NUMBER := 0-1962.0724
374: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a5 DATE := fnd_api.g_miss_date
376: , p5_a6 DATE := fnd_api.g_miss_date
377: , p5_a7 DATE := fnd_api.g_miss_date
378: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a5 DATE := fnd_api.g_miss_date
376: , p5_a6 DATE := fnd_api.g_miss_date
377: , p5_a7 DATE := fnd_api.g_miss_date
378: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a5 DATE := fnd_api.g_miss_date
376: , p5_a6 DATE := fnd_api.g_miss_date
377: , p5_a7 DATE := fnd_api.g_miss_date
378: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a6 DATE := fnd_api.g_miss_date
377: , p5_a7 DATE := fnd_api.g_miss_date
378: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a14 NUMBER := 0-1962.0724
377: , p5_a7 DATE := fnd_api.g_miss_date
378: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a14 NUMBER := 0-1962.0724
385: , p5_a15 DATE := fnd_api.g_miss_date
378: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a14 NUMBER := 0-1962.0724
385: , p5_a15 DATE := fnd_api.g_miss_date
386: , p5_a16 NUMBER := 0-1962.0724
379: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a14 NUMBER := 0-1962.0724
385: , p5_a15 DATE := fnd_api.g_miss_date
386: , p5_a16 NUMBER := 0-1962.0724
387: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a14 NUMBER := 0-1962.0724
385: , p5_a15 DATE := fnd_api.g_miss_date
386: , p5_a16 NUMBER := 0-1962.0724
387: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a14 NUMBER := 0-1962.0724
385: , p5_a15 DATE := fnd_api.g_miss_date
386: , p5_a16 NUMBER := 0-1962.0724
387: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a20 NUMBER := 0-1962.0724
391: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a14 NUMBER := 0-1962.0724
385: , p5_a15 DATE := fnd_api.g_miss_date
386: , p5_a16 NUMBER := 0-1962.0724
387: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a20 NUMBER := 0-1962.0724
391: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a15 DATE := fnd_api.g_miss_date
386: , p5_a16 NUMBER := 0-1962.0724
387: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a20 NUMBER := 0-1962.0724
391: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a20 NUMBER := 0-1962.0724
391: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a20 NUMBER := 0-1962.0724
391: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a20 NUMBER := 0-1962.0724
391: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a20 NUMBER := 0-1962.0724
391: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a37 NUMBER := 0-1962.0724
400: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a37 NUMBER := 0-1962.0724
408: )
401: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a37 NUMBER := 0-1962.0724
408: )
409:
402: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a37 NUMBER := 0-1962.0724
408: )
409:
410: as
558: , p6_a35 out nocopy VARCHAR2
559: , p6_a36 out nocopy VARCHAR2
560: , p6_a37 out nocopy NUMBER
561: , p5_a0 NUMBER := 0-1962.0724
562: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a2 NUMBER := 0-1962.0724
564: , p5_a3 NUMBER := 0-1962.0724
565: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a5 DATE := fnd_api.g_miss_date
561: , p5_a0 NUMBER := 0-1962.0724
562: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a2 NUMBER := 0-1962.0724
564: , p5_a3 NUMBER := 0-1962.0724
565: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a5 DATE := fnd_api.g_miss_date
567: , p5_a6 DATE := fnd_api.g_miss_date
568: , p5_a7 DATE := fnd_api.g_miss_date
569: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a2 NUMBER := 0-1962.0724
564: , p5_a3 NUMBER := 0-1962.0724
565: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a5 DATE := fnd_api.g_miss_date
567: , p5_a6 DATE := fnd_api.g_miss_date
568: , p5_a7 DATE := fnd_api.g_miss_date
569: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a2 NUMBER := 0-1962.0724
564: , p5_a3 NUMBER := 0-1962.0724
565: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a5 DATE := fnd_api.g_miss_date
567: , p5_a6 DATE := fnd_api.g_miss_date
568: , p5_a7 DATE := fnd_api.g_miss_date
569: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a3 NUMBER := 0-1962.0724
565: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a5 DATE := fnd_api.g_miss_date
567: , p5_a6 DATE := fnd_api.g_miss_date
568: , p5_a7 DATE := fnd_api.g_miss_date
569: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
565: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a5 DATE := fnd_api.g_miss_date
567: , p5_a6 DATE := fnd_api.g_miss_date
568: , p5_a7 DATE := fnd_api.g_miss_date
569: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
566: , p5_a5 DATE := fnd_api.g_miss_date
567: , p5_a6 DATE := fnd_api.g_miss_date
568: , p5_a7 DATE := fnd_api.g_miss_date
569: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a6 DATE := fnd_api.g_miss_date
568: , p5_a7 DATE := fnd_api.g_miss_date
569: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a14 NUMBER := 0-1962.0724
568: , p5_a7 DATE := fnd_api.g_miss_date
569: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a14 NUMBER := 0-1962.0724
576: , p5_a15 DATE := fnd_api.g_miss_date
569: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a14 NUMBER := 0-1962.0724
576: , p5_a15 DATE := fnd_api.g_miss_date
577: , p5_a16 NUMBER := 0-1962.0724
570: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a14 NUMBER := 0-1962.0724
576: , p5_a15 DATE := fnd_api.g_miss_date
577: , p5_a16 NUMBER := 0-1962.0724
578: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a14 NUMBER := 0-1962.0724
576: , p5_a15 DATE := fnd_api.g_miss_date
577: , p5_a16 NUMBER := 0-1962.0724
578: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a14 NUMBER := 0-1962.0724
576: , p5_a15 DATE := fnd_api.g_miss_date
577: , p5_a16 NUMBER := 0-1962.0724
578: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a20 NUMBER := 0-1962.0724
582: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a14 NUMBER := 0-1962.0724
576: , p5_a15 DATE := fnd_api.g_miss_date
577: , p5_a16 NUMBER := 0-1962.0724
578: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a20 NUMBER := 0-1962.0724
582: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a15 DATE := fnd_api.g_miss_date
577: , p5_a16 NUMBER := 0-1962.0724
578: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a20 NUMBER := 0-1962.0724
582: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a20 NUMBER := 0-1962.0724
582: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a20 NUMBER := 0-1962.0724
582: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a20 NUMBER := 0-1962.0724
582: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a20 NUMBER := 0-1962.0724
582: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a37 NUMBER := 0-1962.0724
591: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a37 NUMBER := 0-1962.0724
599: )
592: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a37 NUMBER := 0-1962.0724
599: )
600:
593: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a37 NUMBER := 0-1962.0724
599: )
600:
601: as