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;
486: , x_return_status out nocopy VARCHAR2
487: , x_msg_count out nocopy NUMBER
488: , x_msg_data out nocopy VARCHAR2
489: , x_access_id out nocopy NUMBER
490: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
491: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
492: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
493: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
494: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
487: , x_msg_count out nocopy NUMBER
488: , x_msg_data out nocopy VARCHAR2
489: , x_access_id out nocopy NUMBER
490: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
491: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
492: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
493: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
494: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
495: , p9_a0 NUMBER := 0-1962.0724
488: , x_msg_data out nocopy VARCHAR2
489: , x_access_id out nocopy NUMBER
490: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
491: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
492: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
493: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
494: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
495: , p9_a0 NUMBER := 0-1962.0724
496: , p9_a1 DATE := fnd_api.g_miss_date
489: , x_access_id out nocopy NUMBER
490: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
491: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
492: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
493: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
494: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
495: , p9_a0 NUMBER := 0-1962.0724
496: , p9_a1 DATE := fnd_api.g_miss_date
497: , p9_a2 NUMBER := 0-1962.0724
490: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
491: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
492: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
493: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
494: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
495: , p9_a0 NUMBER := 0-1962.0724
496: , p9_a1 DATE := fnd_api.g_miss_date
497: , p9_a2 NUMBER := 0-1962.0724
498: , p9_a3 DATE := fnd_api.g_miss_date
492: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
493: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
494: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
495: , p9_a0 NUMBER := 0-1962.0724
496: , p9_a1 DATE := fnd_api.g_miss_date
497: , p9_a2 NUMBER := 0-1962.0724
498: , p9_a3 DATE := fnd_api.g_miss_date
499: , p9_a4 NUMBER := 0-1962.0724
500: , p9_a5 NUMBER := 0-1962.0724
494: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
495: , p9_a0 NUMBER := 0-1962.0724
496: , p9_a1 DATE := fnd_api.g_miss_date
497: , p9_a2 NUMBER := 0-1962.0724
498: , p9_a3 DATE := fnd_api.g_miss_date
499: , p9_a4 NUMBER := 0-1962.0724
500: , p9_a5 NUMBER := 0-1962.0724
501: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
502: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
497: , p9_a2 NUMBER := 0-1962.0724
498: , p9_a3 DATE := fnd_api.g_miss_date
499: , p9_a4 NUMBER := 0-1962.0724
500: , p9_a5 NUMBER := 0-1962.0724
501: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
502: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
503: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
504: , p9_a9 NUMBER := 0-1962.0724
505: , p9_a10 NUMBER := 0-1962.0724
498: , p9_a3 DATE := fnd_api.g_miss_date
499: , p9_a4 NUMBER := 0-1962.0724
500: , p9_a5 NUMBER := 0-1962.0724
501: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
502: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
503: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
504: , p9_a9 NUMBER := 0-1962.0724
505: , p9_a10 NUMBER := 0-1962.0724
506: , p9_a11 NUMBER := 0-1962.0724
499: , p9_a4 NUMBER := 0-1962.0724
500: , p9_a5 NUMBER := 0-1962.0724
501: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
502: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
503: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
504: , p9_a9 NUMBER := 0-1962.0724
505: , p9_a10 NUMBER := 0-1962.0724
506: , p9_a11 NUMBER := 0-1962.0724
507: , p9_a12 NUMBER := 0-1962.0724
504: , p9_a9 NUMBER := 0-1962.0724
505: , p9_a10 NUMBER := 0-1962.0724
506: , p9_a11 NUMBER := 0-1962.0724
507: , p9_a12 NUMBER := 0-1962.0724
508: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
509: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
510: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
511: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
512: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
505: , p9_a10 NUMBER := 0-1962.0724
506: , p9_a11 NUMBER := 0-1962.0724
507: , p9_a12 NUMBER := 0-1962.0724
508: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
509: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
510: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
511: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
512: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
513: , p9_a18 NUMBER := 0-1962.0724
506: , p9_a11 NUMBER := 0-1962.0724
507: , p9_a12 NUMBER := 0-1962.0724
508: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
509: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
510: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
511: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
512: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
513: , p9_a18 NUMBER := 0-1962.0724
514: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
507: , p9_a12 NUMBER := 0-1962.0724
508: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
509: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
510: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
511: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
512: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
513: , p9_a18 NUMBER := 0-1962.0724
514: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
515: , p9_a20 NUMBER := 0-1962.0724
508: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
509: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
510: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
511: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
512: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
513: , p9_a18 NUMBER := 0-1962.0724
514: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
515: , p9_a20 NUMBER := 0-1962.0724
516: , p9_a21 NUMBER := 0-1962.0724
510: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
511: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
512: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
513: , p9_a18 NUMBER := 0-1962.0724
514: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
515: , p9_a20 NUMBER := 0-1962.0724
516: , p9_a21 NUMBER := 0-1962.0724
517: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
518: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
513: , p9_a18 NUMBER := 0-1962.0724
514: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
515: , p9_a20 NUMBER := 0-1962.0724
516: , p9_a21 NUMBER := 0-1962.0724
517: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
518: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
519: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
520: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
521: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
514: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
515: , p9_a20 NUMBER := 0-1962.0724
516: , p9_a21 NUMBER := 0-1962.0724
517: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
518: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
519: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
520: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
521: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
522: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
515: , p9_a20 NUMBER := 0-1962.0724
516: , p9_a21 NUMBER := 0-1962.0724
517: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
518: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
519: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
520: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
521: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
522: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
523: , p9_a28 NUMBER := 0-1962.0724
516: , p9_a21 NUMBER := 0-1962.0724
517: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
518: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
519: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
520: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
521: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
522: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
523: , p9_a28 NUMBER := 0-1962.0724
524: , p9_a29 NUMBER := 0-1962.0724
517: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
518: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
519: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
520: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
521: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
522: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
523: , p9_a28 NUMBER := 0-1962.0724
524: , p9_a29 NUMBER := 0-1962.0724
525: , p9_a30 DATE := fnd_api.g_miss_date
518: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
519: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
520: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
521: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
522: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
523: , p9_a28 NUMBER := 0-1962.0724
524: , p9_a29 NUMBER := 0-1962.0724
525: , p9_a30 DATE := fnd_api.g_miss_date
526: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
521: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
522: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
523: , p9_a28 NUMBER := 0-1962.0724
524: , p9_a29 NUMBER := 0-1962.0724
525: , p9_a30 DATE := fnd_api.g_miss_date
526: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
527: , p9_a32 DATE := fnd_api.g_miss_date
528: , p9_a33 NUMBER := 0-1962.0724
529: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
522: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
523: , p9_a28 NUMBER := 0-1962.0724
524: , p9_a29 NUMBER := 0-1962.0724
525: , p9_a30 DATE := fnd_api.g_miss_date
526: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
527: , p9_a32 DATE := fnd_api.g_miss_date
528: , p9_a33 NUMBER := 0-1962.0724
529: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
530: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
523: , p9_a28 NUMBER := 0-1962.0724
524: , p9_a29 NUMBER := 0-1962.0724
525: , p9_a30 DATE := fnd_api.g_miss_date
526: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
527: , p9_a32 DATE := fnd_api.g_miss_date
528: , p9_a33 NUMBER := 0-1962.0724
529: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
530: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
531: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
525: , p9_a30 DATE := fnd_api.g_miss_date
526: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
527: , p9_a32 DATE := fnd_api.g_miss_date
528: , p9_a33 NUMBER := 0-1962.0724
529: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
530: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
531: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
532: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
533: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
526: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
527: , p9_a32 DATE := fnd_api.g_miss_date
528: , p9_a33 NUMBER := 0-1962.0724
529: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
530: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
531: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
532: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
533: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
534: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
527: , p9_a32 DATE := fnd_api.g_miss_date
528: , p9_a33 NUMBER := 0-1962.0724
529: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
530: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
531: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
532: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
533: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
534: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
535: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
528: , p9_a33 NUMBER := 0-1962.0724
529: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
530: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
531: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
532: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
533: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
534: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
535: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
536: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
529: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
530: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
531: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
532: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
533: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
534: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
535: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
536: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
537: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
530: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
531: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
532: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
533: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
534: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
535: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
536: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
537: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
538: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
531: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
532: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
533: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
534: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
535: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
536: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
537: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
538: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
539: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
532: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
533: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
534: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
535: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
536: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
537: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
538: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
539: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
540: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
533: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
534: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
535: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
536: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
537: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
538: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
539: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
540: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
541: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
534: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
535: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
536: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
537: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
538: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
539: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
540: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
541: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
542: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
535: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
536: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
537: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
538: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
539: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
540: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
541: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
542: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
543: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
536: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
537: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
538: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
539: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
540: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
541: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
542: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
543: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
544: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
537: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
538: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
539: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
540: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
541: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
542: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
543: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
544: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
545: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
538: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
539: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
540: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
541: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
542: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
543: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
544: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
545: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
546: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
539: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
540: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
541: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
542: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
543: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
544: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
545: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
546: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
547: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
540: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
541: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
542: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
543: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
544: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
545: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
546: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
547: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
548: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
541: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
542: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
543: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
544: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
545: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
546: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
547: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
548: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
549: , p9_a54 NUMBER := 0-1962.0724
542: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
543: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
544: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
545: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
546: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
547: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
548: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
549: , p9_a54 NUMBER := 0-1962.0724
550: , p9_a55 NUMBER := 0-1962.0724
543: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
544: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
545: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
546: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
547: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
548: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
549: , p9_a54 NUMBER := 0-1962.0724
550: , p9_a55 NUMBER := 0-1962.0724
551: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
544: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
545: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
546: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
547: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
548: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
549: , p9_a54 NUMBER := 0-1962.0724
550: , p9_a55 NUMBER := 0-1962.0724
551: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
552: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
547: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
548: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
549: , p9_a54 NUMBER := 0-1962.0724
550: , p9_a55 NUMBER := 0-1962.0724
551: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
552: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
553: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
554: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
555: )
548: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
549: , p9_a54 NUMBER := 0-1962.0724
550: , p9_a55 NUMBER := 0-1962.0724
551: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
552: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
553: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
554: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
555: )
556:
549: , p9_a54 NUMBER := 0-1962.0724
550: , p9_a55 NUMBER := 0-1962.0724
551: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
552: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
553: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
554: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
555: )
556:
557: as
550: , p9_a55 NUMBER := 0-1962.0724
551: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
552: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
553: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
554: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
555: )
556:
557: as
558: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
683: , x_return_status out nocopy VARCHAR2
684: , x_msg_count out nocopy NUMBER
685: , x_msg_data out nocopy VARCHAR2
686: , x_access_id out nocopy NUMBER
687: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
688: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
689: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
690: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
691: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
684: , x_msg_count out nocopy NUMBER
685: , x_msg_data out nocopy VARCHAR2
686: , x_access_id out nocopy NUMBER
687: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
688: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
689: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
690: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
691: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
692: , p9_a0 NUMBER := 0-1962.0724
685: , x_msg_data out nocopy VARCHAR2
686: , x_access_id out nocopy NUMBER
687: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
688: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
689: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
690: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
691: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
692: , p9_a0 NUMBER := 0-1962.0724
693: , p9_a1 DATE := fnd_api.g_miss_date
686: , x_access_id out nocopy NUMBER
687: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
688: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
689: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
690: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
691: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
692: , p9_a0 NUMBER := 0-1962.0724
693: , p9_a1 DATE := fnd_api.g_miss_date
694: , p9_a2 NUMBER := 0-1962.0724
687: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
688: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
689: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
690: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
691: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
692: , p9_a0 NUMBER := 0-1962.0724
693: , p9_a1 DATE := fnd_api.g_miss_date
694: , p9_a2 NUMBER := 0-1962.0724
695: , p9_a3 DATE := fnd_api.g_miss_date
689: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
690: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
691: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
692: , p9_a0 NUMBER := 0-1962.0724
693: , p9_a1 DATE := fnd_api.g_miss_date
694: , p9_a2 NUMBER := 0-1962.0724
695: , p9_a3 DATE := fnd_api.g_miss_date
696: , p9_a4 NUMBER := 0-1962.0724
697: , p9_a5 NUMBER := 0-1962.0724
691: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
692: , p9_a0 NUMBER := 0-1962.0724
693: , p9_a1 DATE := fnd_api.g_miss_date
694: , p9_a2 NUMBER := 0-1962.0724
695: , p9_a3 DATE := fnd_api.g_miss_date
696: , p9_a4 NUMBER := 0-1962.0724
697: , p9_a5 NUMBER := 0-1962.0724
698: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
699: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
694: , p9_a2 NUMBER := 0-1962.0724
695: , p9_a3 DATE := fnd_api.g_miss_date
696: , p9_a4 NUMBER := 0-1962.0724
697: , p9_a5 NUMBER := 0-1962.0724
698: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
699: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
700: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
701: , p9_a9 NUMBER := 0-1962.0724
702: , p9_a10 NUMBER := 0-1962.0724
695: , p9_a3 DATE := fnd_api.g_miss_date
696: , p9_a4 NUMBER := 0-1962.0724
697: , p9_a5 NUMBER := 0-1962.0724
698: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
699: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
700: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
701: , p9_a9 NUMBER := 0-1962.0724
702: , p9_a10 NUMBER := 0-1962.0724
703: , p9_a11 NUMBER := 0-1962.0724
696: , p9_a4 NUMBER := 0-1962.0724
697: , p9_a5 NUMBER := 0-1962.0724
698: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
699: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
700: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
701: , p9_a9 NUMBER := 0-1962.0724
702: , p9_a10 NUMBER := 0-1962.0724
703: , p9_a11 NUMBER := 0-1962.0724
704: , p9_a12 NUMBER := 0-1962.0724
701: , p9_a9 NUMBER := 0-1962.0724
702: , p9_a10 NUMBER := 0-1962.0724
703: , p9_a11 NUMBER := 0-1962.0724
704: , p9_a12 NUMBER := 0-1962.0724
705: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
706: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
707: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
708: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
709: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
702: , p9_a10 NUMBER := 0-1962.0724
703: , p9_a11 NUMBER := 0-1962.0724
704: , p9_a12 NUMBER := 0-1962.0724
705: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
706: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
707: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
708: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
709: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
710: , p9_a18 NUMBER := 0-1962.0724
703: , p9_a11 NUMBER := 0-1962.0724
704: , p9_a12 NUMBER := 0-1962.0724
705: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
706: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
707: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
708: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
709: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
710: , p9_a18 NUMBER := 0-1962.0724
711: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
704: , p9_a12 NUMBER := 0-1962.0724
705: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
706: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
707: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
708: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
709: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
710: , p9_a18 NUMBER := 0-1962.0724
711: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
712: , p9_a20 NUMBER := 0-1962.0724
705: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
706: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
707: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
708: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
709: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
710: , p9_a18 NUMBER := 0-1962.0724
711: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
712: , p9_a20 NUMBER := 0-1962.0724
713: , p9_a21 NUMBER := 0-1962.0724
707: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
708: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
709: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
710: , p9_a18 NUMBER := 0-1962.0724
711: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
712: , p9_a20 NUMBER := 0-1962.0724
713: , p9_a21 NUMBER := 0-1962.0724
714: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
715: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
710: , p9_a18 NUMBER := 0-1962.0724
711: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
712: , p9_a20 NUMBER := 0-1962.0724
713: , p9_a21 NUMBER := 0-1962.0724
714: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
715: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
716: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
711: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
712: , p9_a20 NUMBER := 0-1962.0724
713: , p9_a21 NUMBER := 0-1962.0724
714: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
715: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
716: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
719: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
712: , p9_a20 NUMBER := 0-1962.0724
713: , p9_a21 NUMBER := 0-1962.0724
714: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
715: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
716: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
719: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
720: , p9_a28 NUMBER := 0-1962.0724
713: , p9_a21 NUMBER := 0-1962.0724
714: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
715: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
716: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
719: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
720: , p9_a28 NUMBER := 0-1962.0724
721: , p9_a29 NUMBER := 0-1962.0724
714: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
715: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
716: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
719: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
720: , p9_a28 NUMBER := 0-1962.0724
721: , p9_a29 NUMBER := 0-1962.0724
722: , p9_a30 DATE := fnd_api.g_miss_date
715: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
716: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
719: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
720: , p9_a28 NUMBER := 0-1962.0724
721: , p9_a29 NUMBER := 0-1962.0724
722: , p9_a30 DATE := fnd_api.g_miss_date
723: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
718: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
719: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
720: , p9_a28 NUMBER := 0-1962.0724
721: , p9_a29 NUMBER := 0-1962.0724
722: , p9_a30 DATE := fnd_api.g_miss_date
723: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
724: , p9_a32 DATE := fnd_api.g_miss_date
725: , p9_a33 NUMBER := 0-1962.0724
726: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
719: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
720: , p9_a28 NUMBER := 0-1962.0724
721: , p9_a29 NUMBER := 0-1962.0724
722: , p9_a30 DATE := fnd_api.g_miss_date
723: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
724: , p9_a32 DATE := fnd_api.g_miss_date
725: , p9_a33 NUMBER := 0-1962.0724
726: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
727: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
720: , p9_a28 NUMBER := 0-1962.0724
721: , p9_a29 NUMBER := 0-1962.0724
722: , p9_a30 DATE := fnd_api.g_miss_date
723: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
724: , p9_a32 DATE := fnd_api.g_miss_date
725: , p9_a33 NUMBER := 0-1962.0724
726: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
727: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
728: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
722: , p9_a30 DATE := fnd_api.g_miss_date
723: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
724: , p9_a32 DATE := fnd_api.g_miss_date
725: , p9_a33 NUMBER := 0-1962.0724
726: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
727: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
728: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
729: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
730: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
723: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
724: , p9_a32 DATE := fnd_api.g_miss_date
725: , p9_a33 NUMBER := 0-1962.0724
726: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
727: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
728: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
729: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
730: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
731: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
724: , p9_a32 DATE := fnd_api.g_miss_date
725: , p9_a33 NUMBER := 0-1962.0724
726: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
727: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
728: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
729: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
730: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
731: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
732: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
725: , p9_a33 NUMBER := 0-1962.0724
726: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
727: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
728: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
729: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
730: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
731: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
732: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
733: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
726: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
727: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
728: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
729: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
730: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
731: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
732: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
733: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
734: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
727: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
728: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
729: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
730: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
731: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
732: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
733: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
734: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
735: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
728: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
729: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
730: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
731: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
732: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
733: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
734: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
735: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
736: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
729: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
730: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
731: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
732: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
733: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
734: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
735: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
736: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
737: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
730: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
731: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
732: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
733: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
734: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
735: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
736: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
737: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
738: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
731: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
732: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
733: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
734: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
735: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
736: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
737: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
738: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
739: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
732: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
733: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
734: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
735: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
736: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
737: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
738: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
739: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
740: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
733: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
734: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
735: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
736: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
737: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
738: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
739: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
740: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
741: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
734: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
735: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
736: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
737: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
738: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
739: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
740: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
741: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
742: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
735: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
736: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
737: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
738: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
739: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
740: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
741: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
742: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
743: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
736: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
737: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
738: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
739: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
740: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
741: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
742: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
743: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
744: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
737: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
738: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
739: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
740: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
741: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
742: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
743: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
744: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
745: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
738: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
739: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
740: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
741: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
742: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
743: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
744: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
745: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
746: , p9_a54 NUMBER := 0-1962.0724
739: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
740: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
741: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
742: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
743: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
744: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
745: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
746: , p9_a54 NUMBER := 0-1962.0724
747: , p9_a55 NUMBER := 0-1962.0724
740: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
741: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
742: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
743: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
744: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
745: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
746: , p9_a54 NUMBER := 0-1962.0724
747: , p9_a55 NUMBER := 0-1962.0724
748: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
741: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
742: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
743: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
744: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
745: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
746: , p9_a54 NUMBER := 0-1962.0724
747: , p9_a55 NUMBER := 0-1962.0724
748: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
749: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
744: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
745: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
746: , p9_a54 NUMBER := 0-1962.0724
747: , p9_a55 NUMBER := 0-1962.0724
748: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
749: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
750: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
751: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
752: )
745: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
746: , p9_a54 NUMBER := 0-1962.0724
747: , p9_a55 NUMBER := 0-1962.0724
748: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
749: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
750: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
751: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
752: )
753:
746: , p9_a54 NUMBER := 0-1962.0724
747: , p9_a55 NUMBER := 0-1962.0724
748: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
749: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
750: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
751: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
752: )
753:
754: as
747: , p9_a55 NUMBER := 0-1962.0724
748: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
749: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
750: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
751: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
752: )
753:
754: as
755: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
879: , p_identity_salesforce_id NUMBER
880: , x_return_status out nocopy VARCHAR2
881: , x_msg_count out nocopy NUMBER
882: , x_msg_data out nocopy VARCHAR2
883: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
884: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
885: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
886: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
887: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
880: , x_return_status out nocopy VARCHAR2
881: , x_msg_count out nocopy NUMBER
882: , x_msg_data out nocopy VARCHAR2
883: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
884: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
885: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
886: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
887: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
888: , p9_a0 NUMBER := 0-1962.0724
881: , x_msg_count out nocopy NUMBER
882: , x_msg_data out nocopy VARCHAR2
883: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
884: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
885: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
886: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
887: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
888: , p9_a0 NUMBER := 0-1962.0724
889: , p9_a1 DATE := fnd_api.g_miss_date
882: , x_msg_data out nocopy VARCHAR2
883: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
884: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
885: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
886: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
887: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
888: , p9_a0 NUMBER := 0-1962.0724
889: , p9_a1 DATE := fnd_api.g_miss_date
890: , p9_a2 NUMBER := 0-1962.0724
883: , p4_a0 VARCHAR2 := fnd_api.g_miss_char
884: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
885: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
886: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
887: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
888: , p9_a0 NUMBER := 0-1962.0724
889: , p9_a1 DATE := fnd_api.g_miss_date
890: , p9_a2 NUMBER := 0-1962.0724
891: , p9_a3 DATE := fnd_api.g_miss_date
885: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
886: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
887: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
888: , p9_a0 NUMBER := 0-1962.0724
889: , p9_a1 DATE := fnd_api.g_miss_date
890: , p9_a2 NUMBER := 0-1962.0724
891: , p9_a3 DATE := fnd_api.g_miss_date
892: , p9_a4 NUMBER := 0-1962.0724
893: , p9_a5 NUMBER := 0-1962.0724
887: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
888: , p9_a0 NUMBER := 0-1962.0724
889: , p9_a1 DATE := fnd_api.g_miss_date
890: , p9_a2 NUMBER := 0-1962.0724
891: , p9_a3 DATE := fnd_api.g_miss_date
892: , p9_a4 NUMBER := 0-1962.0724
893: , p9_a5 NUMBER := 0-1962.0724
894: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
895: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
890: , p9_a2 NUMBER := 0-1962.0724
891: , p9_a3 DATE := fnd_api.g_miss_date
892: , p9_a4 NUMBER := 0-1962.0724
893: , p9_a5 NUMBER := 0-1962.0724
894: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
895: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
896: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
897: , p9_a9 NUMBER := 0-1962.0724
898: , p9_a10 NUMBER := 0-1962.0724
891: , p9_a3 DATE := fnd_api.g_miss_date
892: , p9_a4 NUMBER := 0-1962.0724
893: , p9_a5 NUMBER := 0-1962.0724
894: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
895: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
896: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
897: , p9_a9 NUMBER := 0-1962.0724
898: , p9_a10 NUMBER := 0-1962.0724
899: , p9_a11 NUMBER := 0-1962.0724
892: , p9_a4 NUMBER := 0-1962.0724
893: , p9_a5 NUMBER := 0-1962.0724
894: , p9_a6 VARCHAR2 := fnd_api.g_miss_char
895: , p9_a7 VARCHAR2 := fnd_api.g_miss_char
896: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
897: , p9_a9 NUMBER := 0-1962.0724
898: , p9_a10 NUMBER := 0-1962.0724
899: , p9_a11 NUMBER := 0-1962.0724
900: , p9_a12 NUMBER := 0-1962.0724
897: , p9_a9 NUMBER := 0-1962.0724
898: , p9_a10 NUMBER := 0-1962.0724
899: , p9_a11 NUMBER := 0-1962.0724
900: , p9_a12 NUMBER := 0-1962.0724
901: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
902: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
903: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
904: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
905: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
898: , p9_a10 NUMBER := 0-1962.0724
899: , p9_a11 NUMBER := 0-1962.0724
900: , p9_a12 NUMBER := 0-1962.0724
901: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
902: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
903: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
904: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
905: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
906: , p9_a18 NUMBER := 0-1962.0724
899: , p9_a11 NUMBER := 0-1962.0724
900: , p9_a12 NUMBER := 0-1962.0724
901: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
902: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
903: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
904: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
905: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
906: , p9_a18 NUMBER := 0-1962.0724
907: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
900: , p9_a12 NUMBER := 0-1962.0724
901: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
902: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
903: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
904: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
905: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
906: , p9_a18 NUMBER := 0-1962.0724
907: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
908: , p9_a20 NUMBER := 0-1962.0724
901: , p9_a13 VARCHAR2 := fnd_api.g_miss_char
902: , p9_a14 VARCHAR2 := fnd_api.g_miss_char
903: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
904: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
905: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
906: , p9_a18 NUMBER := 0-1962.0724
907: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
908: , p9_a20 NUMBER := 0-1962.0724
909: , p9_a21 NUMBER := 0-1962.0724
903: , p9_a15 VARCHAR2 := fnd_api.g_miss_char
904: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
905: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
906: , p9_a18 NUMBER := 0-1962.0724
907: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
908: , p9_a20 NUMBER := 0-1962.0724
909: , p9_a21 NUMBER := 0-1962.0724
910: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
911: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
906: , p9_a18 NUMBER := 0-1962.0724
907: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
908: , p9_a20 NUMBER := 0-1962.0724
909: , p9_a21 NUMBER := 0-1962.0724
910: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
911: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
912: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
913: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
914: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
907: , p9_a19 VARCHAR2 := fnd_api.g_miss_char
908: , p9_a20 NUMBER := 0-1962.0724
909: , p9_a21 NUMBER := 0-1962.0724
910: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
911: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
912: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
913: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
914: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
915: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
908: , p9_a20 NUMBER := 0-1962.0724
909: , p9_a21 NUMBER := 0-1962.0724
910: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
911: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
912: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
913: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
914: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
915: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
916: , p9_a28 NUMBER := 0-1962.0724
909: , p9_a21 NUMBER := 0-1962.0724
910: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
911: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
912: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
913: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
914: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
915: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
916: , p9_a28 NUMBER := 0-1962.0724
917: , p9_a29 NUMBER := 0-1962.0724
910: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
911: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
912: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
913: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
914: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
915: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
916: , p9_a28 NUMBER := 0-1962.0724
917: , p9_a29 NUMBER := 0-1962.0724
918: , p9_a30 DATE := fnd_api.g_miss_date
911: , p9_a23 VARCHAR2 := fnd_api.g_miss_char
912: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
913: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
914: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
915: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
916: , p9_a28 NUMBER := 0-1962.0724
917: , p9_a29 NUMBER := 0-1962.0724
918: , p9_a30 DATE := fnd_api.g_miss_date
919: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
914: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
915: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
916: , p9_a28 NUMBER := 0-1962.0724
917: , p9_a29 NUMBER := 0-1962.0724
918: , p9_a30 DATE := fnd_api.g_miss_date
919: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
920: , p9_a32 DATE := fnd_api.g_miss_date
921: , p9_a33 NUMBER := 0-1962.0724
922: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
915: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
916: , p9_a28 NUMBER := 0-1962.0724
917: , p9_a29 NUMBER := 0-1962.0724
918: , p9_a30 DATE := fnd_api.g_miss_date
919: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
920: , p9_a32 DATE := fnd_api.g_miss_date
921: , p9_a33 NUMBER := 0-1962.0724
922: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
923: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
916: , p9_a28 NUMBER := 0-1962.0724
917: , p9_a29 NUMBER := 0-1962.0724
918: , p9_a30 DATE := fnd_api.g_miss_date
919: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
920: , p9_a32 DATE := fnd_api.g_miss_date
921: , p9_a33 NUMBER := 0-1962.0724
922: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
923: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
924: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
918: , p9_a30 DATE := fnd_api.g_miss_date
919: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
920: , p9_a32 DATE := fnd_api.g_miss_date
921: , p9_a33 NUMBER := 0-1962.0724
922: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
923: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
924: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
925: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
926: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
919: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
920: , p9_a32 DATE := fnd_api.g_miss_date
921: , p9_a33 NUMBER := 0-1962.0724
922: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
923: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
924: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
925: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
926: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
927: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
920: , p9_a32 DATE := fnd_api.g_miss_date
921: , p9_a33 NUMBER := 0-1962.0724
922: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
923: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
924: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
925: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
926: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
927: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
928: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
921: , p9_a33 NUMBER := 0-1962.0724
922: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
923: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
924: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
925: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
926: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
927: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
928: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
929: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
922: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
923: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
924: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
925: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
926: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
927: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
928: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
929: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
930: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
923: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
924: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
925: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
926: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
927: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
928: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
929: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
930: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
931: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
924: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
925: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
926: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
927: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
928: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
929: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
930: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
931: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
932: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
925: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
926: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
927: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
928: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
929: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
930: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
931: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
932: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
933: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
926: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
927: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
928: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
929: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
930: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
931: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
932: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
933: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
934: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
927: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
928: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
929: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
930: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
931: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
932: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
933: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
934: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
935: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
928: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
929: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
930: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
931: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
932: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
933: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
934: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
935: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
936: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
929: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
930: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
931: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
932: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
933: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
934: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
935: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
936: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
937: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
930: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
931: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
932: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
933: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
934: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
935: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
936: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
937: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
938: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
931: , p9_a43 VARCHAR2 := fnd_api.g_miss_char
932: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
933: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
934: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
935: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
936: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
937: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
938: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
939: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
932: , p9_a44 VARCHAR2 := fnd_api.g_miss_char
933: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
934: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
935: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
936: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
937: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
938: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
939: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
940: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
933: , p9_a45 VARCHAR2 := fnd_api.g_miss_char
934: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
935: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
936: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
937: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
938: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
939: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
940: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
941: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
934: , p9_a46 VARCHAR2 := fnd_api.g_miss_char
935: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
936: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
937: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
938: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
939: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
940: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
941: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
942: , p9_a54 NUMBER := 0-1962.0724
935: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
936: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
937: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
938: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
939: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
940: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
941: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
942: , p9_a54 NUMBER := 0-1962.0724
943: , p9_a55 NUMBER := 0-1962.0724
936: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
937: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
938: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
939: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
940: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
941: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
942: , p9_a54 NUMBER := 0-1962.0724
943: , p9_a55 NUMBER := 0-1962.0724
944: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
937: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
938: , p9_a50 VARCHAR2 := fnd_api.g_miss_char
939: , p9_a51 VARCHAR2 := fnd_api.g_miss_char
940: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
941: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
942: , p9_a54 NUMBER := 0-1962.0724
943: , p9_a55 NUMBER := 0-1962.0724
944: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
945: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
940: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
941: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
942: , p9_a54 NUMBER := 0-1962.0724
943: , p9_a55 NUMBER := 0-1962.0724
944: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
945: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
946: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
947: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
948: )
941: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
942: , p9_a54 NUMBER := 0-1962.0724
943: , p9_a55 NUMBER := 0-1962.0724
944: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
945: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
946: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
947: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
948: )
949:
942: , p9_a54 NUMBER := 0-1962.0724
943: , p9_a55 NUMBER := 0-1962.0724
944: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
945: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
946: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
947: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
948: )
949:
950: as
943: , p9_a55 NUMBER := 0-1962.0724
944: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
945: , p9_a57 VARCHAR2 := fnd_api.g_miss_char
946: , p9_a58 VARCHAR2 := fnd_api.g_miss_char
947: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
948: )
949:
950: as
951: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1065: procedure validate_accessprofiles(p_init_msg_list VARCHAR2
1066: , x_return_status out nocopy VARCHAR2
1067: , x_msg_count out nocopy NUMBER
1068: , x_msg_data out nocopy VARCHAR2
1069: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1070: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1071: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1072: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1073: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1066: , x_return_status out nocopy VARCHAR2
1067: , x_msg_count out nocopy NUMBER
1068: , x_msg_data out nocopy VARCHAR2
1069: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1070: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1071: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1072: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1073: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1074: )
1067: , x_msg_count out nocopy NUMBER
1068: , x_msg_data out nocopy VARCHAR2
1069: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1070: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1071: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1072: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1073: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1074: )
1075:
1068: , x_msg_data out nocopy VARCHAR2
1069: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1070: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1071: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1072: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1073: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1074: )
1075:
1076: as
1069: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1070: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1071: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1072: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1073: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1074: )
1075:
1076: as
1077: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1116: , x_return_status out nocopy VARCHAR2
1117: , x_msg_count out nocopy NUMBER
1118: , x_msg_data out nocopy VARCHAR2
1119: , x_view_access_flag out nocopy VARCHAR2
1120: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1121: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1122: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1123: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1117: , x_msg_count out nocopy NUMBER
1118: , x_msg_data out nocopy VARCHAR2
1119: , x_view_access_flag out nocopy VARCHAR2
1120: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1121: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1122: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1123: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1125: )
1118: , x_msg_data out nocopy VARCHAR2
1119: , x_view_access_flag out nocopy VARCHAR2
1120: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1121: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1122: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1123: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1125: )
1126:
1119: , x_view_access_flag out nocopy VARCHAR2
1120: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1121: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1122: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1123: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1125: )
1126:
1127: as
1120: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1121: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1122: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1123: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1125: )
1126:
1127: as
1128: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1197: , x_return_status out nocopy VARCHAR2
1198: , x_msg_count out nocopy NUMBER
1199: , x_msg_data out nocopy VARCHAR2
1200: , x_update_access_flag out nocopy VARCHAR2
1201: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1202: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1203: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1204: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1205: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1198: , x_msg_count out nocopy NUMBER
1199: , x_msg_data out nocopy VARCHAR2
1200: , x_update_access_flag out nocopy VARCHAR2
1201: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1202: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1203: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1204: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1205: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1206: )
1199: , x_msg_data out nocopy VARCHAR2
1200: , x_update_access_flag out nocopy VARCHAR2
1201: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1202: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1203: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1204: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1205: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1206: )
1207:
1200: , x_update_access_flag out nocopy VARCHAR2
1201: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1202: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1203: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1204: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1205: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1206: )
1207:
1208: as
1201: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1202: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1203: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1204: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1205: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1206: )
1207:
1208: as
1209: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1278: , x_return_status out nocopy VARCHAR2
1279: , x_msg_count out nocopy NUMBER
1280: , x_msg_data out nocopy VARCHAR2
1281: , x_update_access_flag out nocopy VARCHAR2
1282: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1283: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1284: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1285: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1286: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1279: , x_msg_count out nocopy NUMBER
1280: , x_msg_data out nocopy VARCHAR2
1281: , x_update_access_flag out nocopy VARCHAR2
1282: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1283: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1284: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1285: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1286: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1287: )
1280: , x_msg_data out nocopy VARCHAR2
1281: , x_update_access_flag out nocopy VARCHAR2
1282: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1283: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1284: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1285: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1286: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1287: )
1288:
1281: , x_update_access_flag out nocopy VARCHAR2
1282: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1283: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1284: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1285: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1286: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1287: )
1288:
1289: as
1282: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1283: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1284: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1285: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1286: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1287: )
1288:
1289: as
1290: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1359: , x_return_status out nocopy VARCHAR2
1360: , x_msg_count out nocopy NUMBER
1361: , x_msg_data out nocopy VARCHAR2
1362: , x_update_access_flag out nocopy VARCHAR2
1363: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1364: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1365: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1366: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1367: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1360: , x_msg_count out nocopy NUMBER
1361: , x_msg_data out nocopy VARCHAR2
1362: , x_update_access_flag out nocopy VARCHAR2
1363: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1364: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1365: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1366: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1367: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1368: )
1361: , x_msg_data out nocopy VARCHAR2
1362: , x_update_access_flag out nocopy VARCHAR2
1363: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1364: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1365: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1366: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1367: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1368: )
1369:
1362: , x_update_access_flag out nocopy VARCHAR2
1363: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1364: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1365: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1366: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1367: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1368: )
1369:
1370: as
1363: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1364: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1365: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1366: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1367: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1368: )
1369:
1370: as
1371: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1442: , x_return_status out nocopy VARCHAR2
1443: , x_msg_count out nocopy NUMBER
1444: , x_msg_data out nocopy VARCHAR2
1445: , x_update_access_flag out nocopy VARCHAR2
1446: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1447: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1448: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1449: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1450: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1443: , x_msg_count out nocopy NUMBER
1444: , x_msg_data out nocopy VARCHAR2
1445: , x_update_access_flag out nocopy VARCHAR2
1446: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1447: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1448: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1449: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1450: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1451: )
1444: , x_msg_data out nocopy VARCHAR2
1445: , x_update_access_flag out nocopy VARCHAR2
1446: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1447: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1448: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1449: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1450: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1451: )
1452:
1445: , x_update_access_flag out nocopy VARCHAR2
1446: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1447: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1448: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1449: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1450: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1451: )
1452:
1453: as
1446: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1447: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1448: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1449: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1450: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1451: )
1452:
1453: as
1454: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1531: , x_return_status out nocopy VARCHAR2
1532: , x_msg_count out nocopy NUMBER
1533: , x_msg_data out nocopy VARCHAR2
1534: , x_view_access_flag out nocopy VARCHAR2
1535: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1536: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1537: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1538: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1539: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1532: , x_msg_count out nocopy NUMBER
1533: , x_msg_data out nocopy VARCHAR2
1534: , x_view_access_flag out nocopy VARCHAR2
1535: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1536: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1537: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1538: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1539: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1540: )
1533: , x_msg_data out nocopy VARCHAR2
1534: , x_view_access_flag out nocopy VARCHAR2
1535: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1536: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1537: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1538: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1539: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1540: )
1541:
1534: , x_view_access_flag out nocopy VARCHAR2
1535: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1536: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1537: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1538: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1539: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1540: )
1541:
1542: as
1535: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1536: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1537: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1538: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1539: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1540: )
1541:
1542: as
1543: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1618: , x_return_status out nocopy VARCHAR2
1619: , x_msg_count out nocopy NUMBER
1620: , x_msg_data out nocopy VARCHAR2
1621: , x_view_access_flag out nocopy VARCHAR2
1622: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1623: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1624: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1625: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1626: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1619: , x_msg_count out nocopy NUMBER
1620: , x_msg_data out nocopy VARCHAR2
1621: , x_view_access_flag out nocopy VARCHAR2
1622: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1623: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1624: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1625: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1626: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1627: )
1620: , x_msg_data out nocopy VARCHAR2
1621: , x_view_access_flag out nocopy VARCHAR2
1622: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1623: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1624: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1625: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1626: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1627: )
1628:
1621: , x_view_access_flag out nocopy VARCHAR2
1622: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1623: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1624: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1625: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1626: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1627: )
1628:
1629: as
1622: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1623: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1624: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1625: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1626: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1627: )
1628:
1629: as
1630: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1699: , x_return_status out nocopy VARCHAR2
1700: , x_msg_count out nocopy NUMBER
1701: , x_msg_data out nocopy VARCHAR2
1702: , x_view_access_flag out nocopy VARCHAR2
1703: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1704: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1705: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1706: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1707: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1700: , x_msg_count out nocopy NUMBER
1701: , x_msg_data out nocopy VARCHAR2
1702: , x_view_access_flag out nocopy VARCHAR2
1703: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1704: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1705: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1706: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1707: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1708: )
1701: , x_msg_data out nocopy VARCHAR2
1702: , x_view_access_flag out nocopy VARCHAR2
1703: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1704: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1705: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1706: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1707: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1708: )
1709:
1702: , x_view_access_flag out nocopy VARCHAR2
1703: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1704: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1705: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1706: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1707: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1708: )
1709:
1710: as
1703: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1704: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1705: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1706: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1707: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1708: )
1709:
1710: as
1711: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1780: , x_return_status out nocopy VARCHAR2
1781: , x_msg_count out nocopy NUMBER
1782: , x_msg_data out nocopy VARCHAR2
1783: , x_access_privilege out nocopy VARCHAR2
1784: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1785: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1786: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1787: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1788: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1781: , x_msg_count out nocopy NUMBER
1782: , x_msg_data out nocopy VARCHAR2
1783: , x_access_privilege out nocopy VARCHAR2
1784: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1785: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1786: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1787: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1788: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1789: )
1782: , x_msg_data out nocopy VARCHAR2
1783: , x_access_privilege out nocopy VARCHAR2
1784: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1785: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1786: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1787: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1788: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1789: )
1790:
1783: , x_access_privilege out nocopy VARCHAR2
1784: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1785: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1786: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1787: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1788: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1789: )
1790:
1791: as
1784: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1785: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1786: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1787: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1788: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1789: )
1790:
1791: as
1792: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1863: , x_return_status out nocopy VARCHAR2
1864: , x_msg_count out nocopy NUMBER
1865: , x_msg_data out nocopy VARCHAR2
1866: , x_access_privilege out nocopy VARCHAR2
1867: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1868: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1869: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1870: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1871: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1864: , x_msg_count out nocopy NUMBER
1865: , x_msg_data out nocopy VARCHAR2
1866: , x_access_privilege out nocopy VARCHAR2
1867: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1868: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1869: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1870: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1871: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1872: )
1865: , x_msg_data out nocopy VARCHAR2
1866: , x_access_privilege out nocopy VARCHAR2
1867: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1868: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1869: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1870: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1871: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1872: )
1873:
1866: , x_access_privilege out nocopy VARCHAR2
1867: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1868: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1869: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1870: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1871: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1872: )
1873:
1874: as
1867: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1868: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1869: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1870: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1871: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1872: )
1873:
1874: as
1875: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1950: , x_return_status out nocopy VARCHAR2
1951: , x_msg_count out nocopy NUMBER
1952: , x_msg_data out nocopy VARCHAR2
1953: , x_access_privilege out nocopy VARCHAR2
1954: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1955: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1956: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1957: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1958: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1951: , x_msg_count out nocopy NUMBER
1952: , x_msg_data out nocopy VARCHAR2
1953: , x_access_privilege out nocopy VARCHAR2
1954: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1955: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1956: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1957: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1958: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1959: )
1952: , x_msg_data out nocopy VARCHAR2
1953: , x_access_privilege out nocopy VARCHAR2
1954: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1955: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1956: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1957: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1958: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1959: )
1960:
1953: , x_access_privilege out nocopy VARCHAR2
1954: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1955: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1956: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1957: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1958: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1959: )
1960:
1961: as
1954: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
1955: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1956: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
1957: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1958: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1959: )
1960:
1961: as
1962: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
2031: , x_return_status out nocopy VARCHAR2
2032: , x_msg_count out nocopy NUMBER
2033: , x_msg_data out nocopy VARCHAR2
2034: , x_access_privilege out nocopy VARCHAR2
2035: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
2036: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
2037: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
2038: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
2039: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
2032: , x_msg_count out nocopy NUMBER
2033: , x_msg_data out nocopy VARCHAR2
2034: , x_access_privilege out nocopy VARCHAR2
2035: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
2036: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
2037: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
2038: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
2039: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
2040: )
2033: , x_msg_data out nocopy VARCHAR2
2034: , x_access_privilege out nocopy VARCHAR2
2035: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
2036: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
2037: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
2038: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
2039: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
2040: )
2041:
2034: , x_access_privilege out nocopy VARCHAR2
2035: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
2036: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
2037: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
2038: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
2039: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
2040: )
2041:
2042: as
2035: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
2036: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
2037: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
2038: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
2039: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
2040: )
2041:
2042: as
2043: ddp_access_profile_rec as_access_pub.access_profile_rec_type;