DBA Data[Home] [Help]

APPS.OKL_AGN_PVT_W dependencies on FND_API

Line 11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;

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:

Line 12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;

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

Line 17: a number := fnd_api.g_miss_num;

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;

Line 374: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

370: , p6_a16 out nocopy DATE
371: , p6_a17 out nocopy NUMBER
372: , p5_a0 NUMBER := 0-1962.0724
373: , p5_a1 NUMBER := 0-1962.0724
374: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

371: , p6_a17 out nocopy NUMBER
372: , p5_a0 NUMBER := 0-1962.0724
373: , p5_a1 NUMBER := 0-1962.0724
374: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

372: , p5_a0 NUMBER := 0-1962.0724
373: , p5_a1 NUMBER := 0-1962.0724
374: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

374: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date

Line 379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date

Line 380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
384: , p5_a12 NUMBER := 0-1962.0724

Line 381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
384: , p5_a12 NUMBER := 0-1962.0724
385: , p5_a13 NUMBER := 0-1962.0724

Line 382: , p5_a10 DATE := fnd_api.g_miss_date

378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
384: , p5_a12 NUMBER := 0-1962.0724
385: , p5_a13 NUMBER := 0-1962.0724
386: , p5_a14 DATE := fnd_api.g_miss_date

Line 383: , p5_a11 DATE := fnd_api.g_miss_date

379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
384: , p5_a12 NUMBER := 0-1962.0724
385: , p5_a13 NUMBER := 0-1962.0724
386: , p5_a14 DATE := fnd_api.g_miss_date
387: , p5_a15 NUMBER := 0-1962.0724

Line 386: , p5_a14 DATE := fnd_api.g_miss_date

382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
384: , p5_a12 NUMBER := 0-1962.0724
385: , p5_a13 NUMBER := 0-1962.0724
386: , p5_a14 DATE := fnd_api.g_miss_date
387: , p5_a15 NUMBER := 0-1962.0724
388: , p5_a16 DATE := fnd_api.g_miss_date
389: , p5_a17 NUMBER := 0-1962.0724
390: )

Line 388: , p5_a16 DATE := fnd_api.g_miss_date

384: , p5_a12 NUMBER := 0-1962.0724
385: , p5_a13 NUMBER := 0-1962.0724
386: , p5_a14 DATE := fnd_api.g_miss_date
387: , p5_a15 NUMBER := 0-1962.0724
388: , p5_a16 DATE := fnd_api.g_miss_date
389: , p5_a17 NUMBER := 0-1962.0724
390: )
391:
392: as

Line 580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

576: , x_msg_count out nocopy NUMBER
577: , x_msg_data out nocopy VARCHAR2
578: , p5_a0 NUMBER := 0-1962.0724
579: , p5_a1 NUMBER := 0-1962.0724
580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

577: , x_msg_data out nocopy VARCHAR2
578: , p5_a0 NUMBER := 0-1962.0724
579: , p5_a1 NUMBER := 0-1962.0724
580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

578: , p5_a0 NUMBER := 0-1962.0724
579: , p5_a1 NUMBER := 0-1962.0724
580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date

Line 585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date

Line 586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
590: , p5_a12 NUMBER := 0-1962.0724

Line 587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
590: , p5_a12 NUMBER := 0-1962.0724
591: , p5_a13 NUMBER := 0-1962.0724

Line 588: , p5_a10 DATE := fnd_api.g_miss_date

584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
590: , p5_a12 NUMBER := 0-1962.0724
591: , p5_a13 NUMBER := 0-1962.0724
592: , p5_a14 DATE := fnd_api.g_miss_date

Line 589: , p5_a11 DATE := fnd_api.g_miss_date

585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
590: , p5_a12 NUMBER := 0-1962.0724
591: , p5_a13 NUMBER := 0-1962.0724
592: , p5_a14 DATE := fnd_api.g_miss_date
593: , p5_a15 NUMBER := 0-1962.0724

Line 592: , p5_a14 DATE := fnd_api.g_miss_date

588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
590: , p5_a12 NUMBER := 0-1962.0724
591: , p5_a13 NUMBER := 0-1962.0724
592: , p5_a14 DATE := fnd_api.g_miss_date
593: , p5_a15 NUMBER := 0-1962.0724
594: , p5_a16 DATE := fnd_api.g_miss_date
595: , p5_a17 NUMBER := 0-1962.0724
596: )

Line 594: , p5_a16 DATE := fnd_api.g_miss_date

590: , p5_a12 NUMBER := 0-1962.0724
591: , p5_a13 NUMBER := 0-1962.0724
592: , p5_a14 DATE := fnd_api.g_miss_date
593: , p5_a15 NUMBER := 0-1962.0724
594: , p5_a16 DATE := fnd_api.g_miss_date
595: , p5_a17 NUMBER := 0-1962.0724
596: )
597:
598: as

Line 741: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

737: , p6_a16 out nocopy DATE
738: , p6_a17 out nocopy NUMBER
739: , p5_a0 NUMBER := 0-1962.0724
740: , p5_a1 NUMBER := 0-1962.0724
741: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

738: , p6_a17 out nocopy NUMBER
739: , p5_a0 NUMBER := 0-1962.0724
740: , p5_a1 NUMBER := 0-1962.0724
741: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

739: , p5_a0 NUMBER := 0-1962.0724
740: , p5_a1 NUMBER := 0-1962.0724
741: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

741: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date

Line 746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date

Line 747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
751: , p5_a12 NUMBER := 0-1962.0724

Line 748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
751: , p5_a12 NUMBER := 0-1962.0724
752: , p5_a13 NUMBER := 0-1962.0724

Line 749: , p5_a10 DATE := fnd_api.g_miss_date

745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
751: , p5_a12 NUMBER := 0-1962.0724
752: , p5_a13 NUMBER := 0-1962.0724
753: , p5_a14 DATE := fnd_api.g_miss_date

Line 750: , p5_a11 DATE := fnd_api.g_miss_date

746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
751: , p5_a12 NUMBER := 0-1962.0724
752: , p5_a13 NUMBER := 0-1962.0724
753: , p5_a14 DATE := fnd_api.g_miss_date
754: , p5_a15 NUMBER := 0-1962.0724

Line 753: , p5_a14 DATE := fnd_api.g_miss_date

749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
751: , p5_a12 NUMBER := 0-1962.0724
752: , p5_a13 NUMBER := 0-1962.0724
753: , p5_a14 DATE := fnd_api.g_miss_date
754: , p5_a15 NUMBER := 0-1962.0724
755: , p5_a16 DATE := fnd_api.g_miss_date
756: , p5_a17 NUMBER := 0-1962.0724
757: )

Line 755: , p5_a16 DATE := fnd_api.g_miss_date

751: , p5_a12 NUMBER := 0-1962.0724
752: , p5_a13 NUMBER := 0-1962.0724
753: , p5_a14 DATE := fnd_api.g_miss_date
754: , p5_a15 NUMBER := 0-1962.0724
755: , p5_a16 DATE := fnd_api.g_miss_date
756: , p5_a17 NUMBER := 0-1962.0724
757: )
758:
759: as

Line 947: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

943: , x_msg_count out nocopy NUMBER
944: , x_msg_data out nocopy VARCHAR2
945: , p5_a0 NUMBER := 0-1962.0724
946: , p5_a1 NUMBER := 0-1962.0724
947: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

944: , x_msg_data out nocopy VARCHAR2
945: , p5_a0 NUMBER := 0-1962.0724
946: , p5_a1 NUMBER := 0-1962.0724
947: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

945: , p5_a0 NUMBER := 0-1962.0724
946: , p5_a1 NUMBER := 0-1962.0724
947: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

947: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date

Line 952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date

Line 953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
957: , p5_a12 NUMBER := 0-1962.0724

Line 954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
957: , p5_a12 NUMBER := 0-1962.0724
958: , p5_a13 NUMBER := 0-1962.0724

Line 955: , p5_a10 DATE := fnd_api.g_miss_date

951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
957: , p5_a12 NUMBER := 0-1962.0724
958: , p5_a13 NUMBER := 0-1962.0724
959: , p5_a14 DATE := fnd_api.g_miss_date

Line 956: , p5_a11 DATE := fnd_api.g_miss_date

952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
957: , p5_a12 NUMBER := 0-1962.0724
958: , p5_a13 NUMBER := 0-1962.0724
959: , p5_a14 DATE := fnd_api.g_miss_date
960: , p5_a15 NUMBER := 0-1962.0724

Line 959: , p5_a14 DATE := fnd_api.g_miss_date

955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
957: , p5_a12 NUMBER := 0-1962.0724
958: , p5_a13 NUMBER := 0-1962.0724
959: , p5_a14 DATE := fnd_api.g_miss_date
960: , p5_a15 NUMBER := 0-1962.0724
961: , p5_a16 DATE := fnd_api.g_miss_date
962: , p5_a17 NUMBER := 0-1962.0724
963: )

Line 961: , p5_a16 DATE := fnd_api.g_miss_date

957: , p5_a12 NUMBER := 0-1962.0724
958: , p5_a13 NUMBER := 0-1962.0724
959: , p5_a14 DATE := fnd_api.g_miss_date
960: , p5_a15 NUMBER := 0-1962.0724
961: , p5_a16 DATE := fnd_api.g_miss_date
962: , p5_a17 NUMBER := 0-1962.0724
963: )
964:
965: as

Line 1090: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

1086: , x_msg_count out nocopy NUMBER
1087: , x_msg_data out nocopy VARCHAR2
1088: , p5_a0 NUMBER := 0-1962.0724
1089: , p5_a1 NUMBER := 0-1962.0724
1090: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

1087: , x_msg_data out nocopy VARCHAR2
1088: , p5_a0 NUMBER := 0-1962.0724
1089: , p5_a1 NUMBER := 0-1962.0724
1090: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

1088: , p5_a0 NUMBER := 0-1962.0724
1089: , p5_a1 NUMBER := 0-1962.0724
1090: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

1090: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date

Line 1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date

Line 1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1100: , p5_a12 NUMBER := 0-1962.0724

Line 1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1100: , p5_a12 NUMBER := 0-1962.0724
1101: , p5_a13 NUMBER := 0-1962.0724

Line 1098: , p5_a10 DATE := fnd_api.g_miss_date

1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1100: , p5_a12 NUMBER := 0-1962.0724
1101: , p5_a13 NUMBER := 0-1962.0724
1102: , p5_a14 DATE := fnd_api.g_miss_date

Line 1099: , p5_a11 DATE := fnd_api.g_miss_date

1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1100: , p5_a12 NUMBER := 0-1962.0724
1101: , p5_a13 NUMBER := 0-1962.0724
1102: , p5_a14 DATE := fnd_api.g_miss_date
1103: , p5_a15 NUMBER := 0-1962.0724

Line 1102: , p5_a14 DATE := fnd_api.g_miss_date

1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1100: , p5_a12 NUMBER := 0-1962.0724
1101: , p5_a13 NUMBER := 0-1962.0724
1102: , p5_a14 DATE := fnd_api.g_miss_date
1103: , p5_a15 NUMBER := 0-1962.0724
1104: , p5_a16 DATE := fnd_api.g_miss_date
1105: , p5_a17 NUMBER := 0-1962.0724
1106: )

Line 1104: , p5_a16 DATE := fnd_api.g_miss_date

1100: , p5_a12 NUMBER := 0-1962.0724
1101: , p5_a13 NUMBER := 0-1962.0724
1102: , p5_a14 DATE := fnd_api.g_miss_date
1103: , p5_a15 NUMBER := 0-1962.0724
1104: , p5_a16 DATE := fnd_api.g_miss_date
1105: , p5_a17 NUMBER := 0-1962.0724
1106: )
1107:
1108: as