APPS.QP_FNA_UTIL dependencies on FND_API

Line 11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
13: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_FNA_REC
15: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type

Line 30: IF p_attr_id = FND_API.G_MISS_NUM THEN

26:
27: -- If attr_id is missing compare old and new records and for
28: -- every changed attribute clear its dependent fields.
29:
30: IF p_attr_id = FND_API.G_MISS_NUM THEN
31:
32: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute1,p_old_FNA_rec.attribute1)
33: THEN
34: l_index := l_index + 1;

Line 506: IF l_FNA_rec.attribute1 = FND_API.G_MISS_CHAR THEN

502: IS
503: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;
504: BEGIN
505:
506: IF l_FNA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
507: l_FNA_rec.attribute1 := p_old_FNA_rec.attribute1;
508: END IF;
509:
510: IF l_FNA_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 510: IF l_FNA_rec.attribute10 = FND_API.G_MISS_CHAR THEN

506: IF l_FNA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
507: l_FNA_rec.attribute1 := p_old_FNA_rec.attribute1;
508: END IF;
509:
510: IF l_FNA_rec.attribute10 = FND_API.G_MISS_CHAR THEN
511: l_FNA_rec.attribute10 := p_old_FNA_rec.attribute10;
512: END IF;
513:
514: IF l_FNA_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 514: IF l_FNA_rec.attribute11 = FND_API.G_MISS_CHAR THEN

510: IF l_FNA_rec.attribute10 = FND_API.G_MISS_CHAR THEN
511: l_FNA_rec.attribute10 := p_old_FNA_rec.attribute10;
512: END IF;
513:
514: IF l_FNA_rec.attribute11 = FND_API.G_MISS_CHAR THEN
515: l_FNA_rec.attribute11 := p_old_FNA_rec.attribute11;
516: END IF;
517:
518: IF l_FNA_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 518: IF l_FNA_rec.attribute12 = FND_API.G_MISS_CHAR THEN

514: IF l_FNA_rec.attribute11 = FND_API.G_MISS_CHAR THEN
515: l_FNA_rec.attribute11 := p_old_FNA_rec.attribute11;
516: END IF;
517:
518: IF l_FNA_rec.attribute12 = FND_API.G_MISS_CHAR THEN
519: l_FNA_rec.attribute12 := p_old_FNA_rec.attribute12;
520: END IF;
521:
522: IF l_FNA_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 522: IF l_FNA_rec.attribute13 = FND_API.G_MISS_CHAR THEN

518: IF l_FNA_rec.attribute12 = FND_API.G_MISS_CHAR THEN
519: l_FNA_rec.attribute12 := p_old_FNA_rec.attribute12;
520: END IF;
521:
522: IF l_FNA_rec.attribute13 = FND_API.G_MISS_CHAR THEN
523: l_FNA_rec.attribute13 := p_old_FNA_rec.attribute13;
524: END IF;
525:
526: IF l_FNA_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 526: IF l_FNA_rec.attribute14 = FND_API.G_MISS_CHAR THEN

522: IF l_FNA_rec.attribute13 = FND_API.G_MISS_CHAR THEN
523: l_FNA_rec.attribute13 := p_old_FNA_rec.attribute13;
524: END IF;
525:
526: IF l_FNA_rec.attribute14 = FND_API.G_MISS_CHAR THEN
527: l_FNA_rec.attribute14 := p_old_FNA_rec.attribute14;
528: END IF;
529:
530: IF l_FNA_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 530: IF l_FNA_rec.attribute15 = FND_API.G_MISS_CHAR THEN

526: IF l_FNA_rec.attribute14 = FND_API.G_MISS_CHAR THEN
527: l_FNA_rec.attribute14 := p_old_FNA_rec.attribute14;
528: END IF;
529:
530: IF l_FNA_rec.attribute15 = FND_API.G_MISS_CHAR THEN
531: l_FNA_rec.attribute15 := p_old_FNA_rec.attribute15;
532: END IF;
533:
534: IF l_FNA_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 534: IF l_FNA_rec.attribute2 = FND_API.G_MISS_CHAR THEN

530: IF l_FNA_rec.attribute15 = FND_API.G_MISS_CHAR THEN
531: l_FNA_rec.attribute15 := p_old_FNA_rec.attribute15;
532: END IF;
533:
534: IF l_FNA_rec.attribute2 = FND_API.G_MISS_CHAR THEN
535: l_FNA_rec.attribute2 := p_old_FNA_rec.attribute2;
536: END IF;
537:
538: IF l_FNA_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 538: IF l_FNA_rec.attribute3 = FND_API.G_MISS_CHAR THEN

534: IF l_FNA_rec.attribute2 = FND_API.G_MISS_CHAR THEN
535: l_FNA_rec.attribute2 := p_old_FNA_rec.attribute2;
536: END IF;
537:
538: IF l_FNA_rec.attribute3 = FND_API.G_MISS_CHAR THEN
539: l_FNA_rec.attribute3 := p_old_FNA_rec.attribute3;
540: END IF;
541:
542: IF l_FNA_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 542: IF l_FNA_rec.attribute4 = FND_API.G_MISS_CHAR THEN

538: IF l_FNA_rec.attribute3 = FND_API.G_MISS_CHAR THEN
539: l_FNA_rec.attribute3 := p_old_FNA_rec.attribute3;
540: END IF;
541:
542: IF l_FNA_rec.attribute4 = FND_API.G_MISS_CHAR THEN
543: l_FNA_rec.attribute4 := p_old_FNA_rec.attribute4;
544: END IF;
545:
546: IF l_FNA_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 546: IF l_FNA_rec.attribute5 = FND_API.G_MISS_CHAR THEN

542: IF l_FNA_rec.attribute4 = FND_API.G_MISS_CHAR THEN
543: l_FNA_rec.attribute4 := p_old_FNA_rec.attribute4;
544: END IF;
545:
546: IF l_FNA_rec.attribute5 = FND_API.G_MISS_CHAR THEN
547: l_FNA_rec.attribute5 := p_old_FNA_rec.attribute5;
548: END IF;
549:
550: IF l_FNA_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 550: IF l_FNA_rec.attribute6 = FND_API.G_MISS_CHAR THEN

546: IF l_FNA_rec.attribute5 = FND_API.G_MISS_CHAR THEN
547: l_FNA_rec.attribute5 := p_old_FNA_rec.attribute5;
548: END IF;
549:
550: IF l_FNA_rec.attribute6 = FND_API.G_MISS_CHAR THEN
551: l_FNA_rec.attribute6 := p_old_FNA_rec.attribute6;
552: END IF;
553:
554: IF l_FNA_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 554: IF l_FNA_rec.attribute7 = FND_API.G_MISS_CHAR THEN

550: IF l_FNA_rec.attribute6 = FND_API.G_MISS_CHAR THEN
551: l_FNA_rec.attribute6 := p_old_FNA_rec.attribute6;
552: END IF;
553:
554: IF l_FNA_rec.attribute7 = FND_API.G_MISS_CHAR THEN
555: l_FNA_rec.attribute7 := p_old_FNA_rec.attribute7;
556: END IF;
557:
558: IF l_FNA_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 558: IF l_FNA_rec.attribute8 = FND_API.G_MISS_CHAR THEN

554: IF l_FNA_rec.attribute7 = FND_API.G_MISS_CHAR THEN
555: l_FNA_rec.attribute7 := p_old_FNA_rec.attribute7;
556: END IF;
557:
558: IF l_FNA_rec.attribute8 = FND_API.G_MISS_CHAR THEN
559: l_FNA_rec.attribute8 := p_old_FNA_rec.attribute8;
560: END IF;
561:
562: IF l_FNA_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 562: IF l_FNA_rec.attribute9 = FND_API.G_MISS_CHAR THEN

558: IF l_FNA_rec.attribute8 = FND_API.G_MISS_CHAR THEN
559: l_FNA_rec.attribute8 := p_old_FNA_rec.attribute8;
560: END IF;
561:
562: IF l_FNA_rec.attribute9 = FND_API.G_MISS_CHAR THEN
563: l_FNA_rec.attribute9 := p_old_FNA_rec.attribute9;
564: END IF;
565:
566: IF l_FNA_rec.context = FND_API.G_MISS_CHAR THEN

Line 566: IF l_FNA_rec.context = FND_API.G_MISS_CHAR THEN

562: IF l_FNA_rec.attribute9 = FND_API.G_MISS_CHAR THEN
563: l_FNA_rec.attribute9 := p_old_FNA_rec.attribute9;
564: END IF;
565:
566: IF l_FNA_rec.context = FND_API.G_MISS_CHAR THEN
567: l_FNA_rec.context := p_old_FNA_rec.context;
568: END IF;
569:
570: IF l_FNA_rec.created_by = FND_API.G_MISS_NUM THEN

Line 570: IF l_FNA_rec.created_by = FND_API.G_MISS_NUM THEN

566: IF l_FNA_rec.context = FND_API.G_MISS_CHAR THEN
567: l_FNA_rec.context := p_old_FNA_rec.context;
568: END IF;
569:
570: IF l_FNA_rec.created_by = FND_API.G_MISS_NUM THEN
571: l_FNA_rec.created_by := p_old_FNA_rec.created_by;
572: END IF;
573:
574: IF l_FNA_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 574: IF l_FNA_rec.creation_date = FND_API.G_MISS_DATE THEN

570: IF l_FNA_rec.created_by = FND_API.G_MISS_NUM THEN
571: l_FNA_rec.created_by := p_old_FNA_rec.created_by;
572: END IF;
573:
574: IF l_FNA_rec.creation_date = FND_API.G_MISS_DATE THEN
575: l_FNA_rec.creation_date := p_old_FNA_rec.creation_date;
576: END IF;
577:
578: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

Line 578: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

574: IF l_FNA_rec.creation_date = FND_API.G_MISS_DATE THEN
575: l_FNA_rec.creation_date := p_old_FNA_rec.creation_date;
576: END IF;
577:
578: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
579: l_FNA_rec.enabled_flag := p_old_FNA_rec.enabled_flag;
580: END IF;
581:
582: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN

Line 582: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN

578: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
579: l_FNA_rec.enabled_flag := p_old_FNA_rec.enabled_flag;
580: END IF;
581:
582: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN
583: l_FNA_rec.functional_area_id := p_old_FNA_rec.functional_area_id;
584: END IF;
585:
586: IF l_FNA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 586: IF l_FNA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

582: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN
583: l_FNA_rec.functional_area_id := p_old_FNA_rec.functional_area_id;
584: END IF;
585:
586: IF l_FNA_rec.last_updated_by = FND_API.G_MISS_NUM THEN
587: l_FNA_rec.last_updated_by := p_old_FNA_rec.last_updated_by;
588: END IF;
589:
590: IF l_FNA_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 590: IF l_FNA_rec.last_update_date = FND_API.G_MISS_DATE THEN

586: IF l_FNA_rec.last_updated_by = FND_API.G_MISS_NUM THEN
587: l_FNA_rec.last_updated_by := p_old_FNA_rec.last_updated_by;
588: END IF;
589:
590: IF l_FNA_rec.last_update_date = FND_API.G_MISS_DATE THEN
591: l_FNA_rec.last_update_date := p_old_FNA_rec.last_update_date;
592: END IF;
593:
594: IF l_FNA_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 594: IF l_FNA_rec.last_update_login = FND_API.G_MISS_NUM THEN

590: IF l_FNA_rec.last_update_date = FND_API.G_MISS_DATE THEN
591: l_FNA_rec.last_update_date := p_old_FNA_rec.last_update_date;
592: END IF;
593:
594: IF l_FNA_rec.last_update_login = FND_API.G_MISS_NUM THEN
595: l_FNA_rec.last_update_login := p_old_FNA_rec.last_update_login;
596: END IF;
597:
598: IF l_FNA_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 598: IF l_FNA_rec.program_application_id = FND_API.G_MISS_NUM THEN

594: IF l_FNA_rec.last_update_login = FND_API.G_MISS_NUM THEN
595: l_FNA_rec.last_update_login := p_old_FNA_rec.last_update_login;
596: END IF;
597:
598: IF l_FNA_rec.program_application_id = FND_API.G_MISS_NUM THEN
599: l_FNA_rec.program_application_id := p_old_FNA_rec.program_application_id;
600: END IF;
601:
602: IF l_FNA_rec.program_id = FND_API.G_MISS_NUM THEN

Line 602: IF l_FNA_rec.program_id = FND_API.G_MISS_NUM THEN

598: IF l_FNA_rec.program_application_id = FND_API.G_MISS_NUM THEN
599: l_FNA_rec.program_application_id := p_old_FNA_rec.program_application_id;
600: END IF;
601:
602: IF l_FNA_rec.program_id = FND_API.G_MISS_NUM THEN
603: l_FNA_rec.program_id := p_old_FNA_rec.program_id;
604: END IF;
605:
606: IF l_FNA_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 606: IF l_FNA_rec.program_update_date = FND_API.G_MISS_DATE THEN

602: IF l_FNA_rec.program_id = FND_API.G_MISS_NUM THEN
603: l_FNA_rec.program_id := p_old_FNA_rec.program_id;
604: END IF;
605:
606: IF l_FNA_rec.program_update_date = FND_API.G_MISS_DATE THEN
607: l_FNA_rec.program_update_date := p_old_FNA_rec.program_update_date;
608: END IF;
609:
610: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN

Line 610: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN

606: IF l_FNA_rec.program_update_date = FND_API.G_MISS_DATE THEN
607: l_FNA_rec.program_update_date := p_old_FNA_rec.program_update_date;
608: END IF;
609:
610: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN
611: l_FNA_rec.pte_sourcesystem_fnarea_id := p_old_FNA_rec.pte_sourcesystem_fnarea_id;
612: END IF;
613:
614: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN

Line 614: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN

610: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN
611: l_FNA_rec.pte_sourcesystem_fnarea_id := p_old_FNA_rec.pte_sourcesystem_fnarea_id;
612: END IF;
613:
614: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN
615: l_FNA_rec.pte_source_system_id := p_old_FNA_rec.pte_source_system_id;
616: END IF;
617:
618: IF l_FNA_rec.request_id = FND_API.G_MISS_NUM THEN

Line 618: IF l_FNA_rec.request_id = FND_API.G_MISS_NUM THEN

614: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN
615: l_FNA_rec.pte_source_system_id := p_old_FNA_rec.pte_source_system_id;
616: END IF;
617:
618: IF l_FNA_rec.request_id = FND_API.G_MISS_NUM THEN
619: l_FNA_rec.request_id := p_old_FNA_rec.request_id;
620: END IF;
621:
622: IF l_FNA_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

Line 622: IF l_FNA_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

618: IF l_FNA_rec.request_id = FND_API.G_MISS_NUM THEN
619: l_FNA_rec.request_id := p_old_FNA_rec.request_id;
620: END IF;
621:
622: IF l_FNA_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
623: l_FNA_rec.seeded_flag := p_old_FNA_rec.seeded_flag;
624: END IF;
625:
626: RETURN l_FNA_rec;

Line 638: IF l_FNA_rec.attribute1 = FND_API.G_MISS_CHAR THEN

634: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
635: IS
636: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;
637: BEGIN
638: IF l_FNA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
639: l_FNA_rec.attribute1 := NULL;
640: END IF;
641:
642: IF l_FNA_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 642: IF l_FNA_rec.attribute10 = FND_API.G_MISS_CHAR THEN

638: IF l_FNA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
639: l_FNA_rec.attribute1 := NULL;
640: END IF;
641:
642: IF l_FNA_rec.attribute10 = FND_API.G_MISS_CHAR THEN
643: l_FNA_rec.attribute10 := NULL;
644: END IF;
645:
646: IF l_FNA_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 646: IF l_FNA_rec.attribute11 = FND_API.G_MISS_CHAR THEN

642: IF l_FNA_rec.attribute10 = FND_API.G_MISS_CHAR THEN
643: l_FNA_rec.attribute10 := NULL;
644: END IF;
645:
646: IF l_FNA_rec.attribute11 = FND_API.G_MISS_CHAR THEN
647: l_FNA_rec.attribute11 := NULL;
648: END IF;
649:
650: IF l_FNA_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 650: IF l_FNA_rec.attribute12 = FND_API.G_MISS_CHAR THEN

646: IF l_FNA_rec.attribute11 = FND_API.G_MISS_CHAR THEN
647: l_FNA_rec.attribute11 := NULL;
648: END IF;
649:
650: IF l_FNA_rec.attribute12 = FND_API.G_MISS_CHAR THEN
651: l_FNA_rec.attribute12 := NULL;
652: END IF;
653:
654: IF l_FNA_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 654: IF l_FNA_rec.attribute13 = FND_API.G_MISS_CHAR THEN

650: IF l_FNA_rec.attribute12 = FND_API.G_MISS_CHAR THEN
651: l_FNA_rec.attribute12 := NULL;
652: END IF;
653:
654: IF l_FNA_rec.attribute13 = FND_API.G_MISS_CHAR THEN
655: l_FNA_rec.attribute13 := NULL;
656: END IF;
657:
658: IF l_FNA_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 658: IF l_FNA_rec.attribute14 = FND_API.G_MISS_CHAR THEN

654: IF l_FNA_rec.attribute13 = FND_API.G_MISS_CHAR THEN
655: l_FNA_rec.attribute13 := NULL;
656: END IF;
657:
658: IF l_FNA_rec.attribute14 = FND_API.G_MISS_CHAR THEN
659: l_FNA_rec.attribute14 := NULL;
660: END IF;
661:
662: IF l_FNA_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 662: IF l_FNA_rec.attribute15 = FND_API.G_MISS_CHAR THEN

658: IF l_FNA_rec.attribute14 = FND_API.G_MISS_CHAR THEN
659: l_FNA_rec.attribute14 := NULL;
660: END IF;
661:
662: IF l_FNA_rec.attribute15 = FND_API.G_MISS_CHAR THEN
663: l_FNA_rec.attribute15 := NULL;
664: END IF;
665:
666: IF l_FNA_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 666: IF l_FNA_rec.attribute2 = FND_API.G_MISS_CHAR THEN

662: IF l_FNA_rec.attribute15 = FND_API.G_MISS_CHAR THEN
663: l_FNA_rec.attribute15 := NULL;
664: END IF;
665:
666: IF l_FNA_rec.attribute2 = FND_API.G_MISS_CHAR THEN
667: l_FNA_rec.attribute2 := NULL;
668: END IF;
669:
670: IF l_FNA_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 670: IF l_FNA_rec.attribute3 = FND_API.G_MISS_CHAR THEN

666: IF l_FNA_rec.attribute2 = FND_API.G_MISS_CHAR THEN
667: l_FNA_rec.attribute2 := NULL;
668: END IF;
669:
670: IF l_FNA_rec.attribute3 = FND_API.G_MISS_CHAR THEN
671: l_FNA_rec.attribute3 := NULL;
672: END IF;
673:
674: IF l_FNA_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 674: IF l_FNA_rec.attribute4 = FND_API.G_MISS_CHAR THEN

670: IF l_FNA_rec.attribute3 = FND_API.G_MISS_CHAR THEN
671: l_FNA_rec.attribute3 := NULL;
672: END IF;
673:
674: IF l_FNA_rec.attribute4 = FND_API.G_MISS_CHAR THEN
675: l_FNA_rec.attribute4 := NULL;
676: END IF;
677:
678: IF l_FNA_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 678: IF l_FNA_rec.attribute5 = FND_API.G_MISS_CHAR THEN

674: IF l_FNA_rec.attribute4 = FND_API.G_MISS_CHAR THEN
675: l_FNA_rec.attribute4 := NULL;
676: END IF;
677:
678: IF l_FNA_rec.attribute5 = FND_API.G_MISS_CHAR THEN
679: l_FNA_rec.attribute5 := NULL;
680: END IF;
681:
682: IF l_FNA_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 682: IF l_FNA_rec.attribute6 = FND_API.G_MISS_CHAR THEN

678: IF l_FNA_rec.attribute5 = FND_API.G_MISS_CHAR THEN
679: l_FNA_rec.attribute5 := NULL;
680: END IF;
681:
682: IF l_FNA_rec.attribute6 = FND_API.G_MISS_CHAR THEN
683: l_FNA_rec.attribute6 := NULL;
684: END IF;
685:
686: IF l_FNA_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 686: IF l_FNA_rec.attribute7 = FND_API.G_MISS_CHAR THEN

682: IF l_FNA_rec.attribute6 = FND_API.G_MISS_CHAR THEN
683: l_FNA_rec.attribute6 := NULL;
684: END IF;
685:
686: IF l_FNA_rec.attribute7 = FND_API.G_MISS_CHAR THEN
687: l_FNA_rec.attribute7 := NULL;
688: END IF;
689:
690: IF l_FNA_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 690: IF l_FNA_rec.attribute8 = FND_API.G_MISS_CHAR THEN

686: IF l_FNA_rec.attribute7 = FND_API.G_MISS_CHAR THEN
687: l_FNA_rec.attribute7 := NULL;
688: END IF;
689:
690: IF l_FNA_rec.attribute8 = FND_API.G_MISS_CHAR THEN
691: l_FNA_rec.attribute8 := NULL;
692: END IF;
693:
694: IF l_FNA_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 694: IF l_FNA_rec.attribute9 = FND_API.G_MISS_CHAR THEN

690: IF l_FNA_rec.attribute8 = FND_API.G_MISS_CHAR THEN
691: l_FNA_rec.attribute8 := NULL;
692: END IF;
693:
694: IF l_FNA_rec.attribute9 = FND_API.G_MISS_CHAR THEN
695: l_FNA_rec.attribute9 := NULL;
696: END IF;
697:
698: IF l_FNA_rec.context = FND_API.G_MISS_CHAR THEN

Line 698: IF l_FNA_rec.context = FND_API.G_MISS_CHAR THEN

694: IF l_FNA_rec.attribute9 = FND_API.G_MISS_CHAR THEN
695: l_FNA_rec.attribute9 := NULL;
696: END IF;
697:
698: IF l_FNA_rec.context = FND_API.G_MISS_CHAR THEN
699: l_FNA_rec.context := NULL;
700: END IF;
701:
702: IF l_FNA_rec.created_by = FND_API.G_MISS_NUM THEN

Line 702: IF l_FNA_rec.created_by = FND_API.G_MISS_NUM THEN

698: IF l_FNA_rec.context = FND_API.G_MISS_CHAR THEN
699: l_FNA_rec.context := NULL;
700: END IF;
701:
702: IF l_FNA_rec.created_by = FND_API.G_MISS_NUM THEN
703: l_FNA_rec.created_by := NULL;
704: END IF;
705:
706: IF l_FNA_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 706: IF l_FNA_rec.creation_date = FND_API.G_MISS_DATE THEN

702: IF l_FNA_rec.created_by = FND_API.G_MISS_NUM THEN
703: l_FNA_rec.created_by := NULL;
704: END IF;
705:
706: IF l_FNA_rec.creation_date = FND_API.G_MISS_DATE THEN
707: l_FNA_rec.creation_date := NULL;
708: END IF;
709:
710: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

Line 710: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

706: IF l_FNA_rec.creation_date = FND_API.G_MISS_DATE THEN
707: l_FNA_rec.creation_date := NULL;
708: END IF;
709:
710: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
711: l_FNA_rec.enabled_flag := NULL;
712: END IF;
713:
714: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN

Line 714: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN

710: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
711: l_FNA_rec.enabled_flag := NULL;
712: END IF;
713:
714: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN
715: l_FNA_rec.functional_area_id := NULL;
716: END IF;
717:
718: IF l_FNA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 718: IF l_FNA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

714: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN
715: l_FNA_rec.functional_area_id := NULL;
716: END IF;
717:
718: IF l_FNA_rec.last_updated_by = FND_API.G_MISS_NUM THEN
719: l_FNA_rec.last_updated_by := NULL;
720: END IF;
721:
722: IF l_FNA_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 722: IF l_FNA_rec.last_update_date = FND_API.G_MISS_DATE THEN

718: IF l_FNA_rec.last_updated_by = FND_API.G_MISS_NUM THEN
719: l_FNA_rec.last_updated_by := NULL;
720: END IF;
721:
722: IF l_FNA_rec.last_update_date = FND_API.G_MISS_DATE THEN
723: l_FNA_rec.last_update_date := NULL;
724: END IF;
725:
726: IF l_FNA_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 726: IF l_FNA_rec.last_update_login = FND_API.G_MISS_NUM THEN

722: IF l_FNA_rec.last_update_date = FND_API.G_MISS_DATE THEN
723: l_FNA_rec.last_update_date := NULL;
724: END IF;
725:
726: IF l_FNA_rec.last_update_login = FND_API.G_MISS_NUM THEN
727: l_FNA_rec.last_update_login := NULL;
728: END IF;
729:
730: IF l_FNA_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 730: IF l_FNA_rec.program_application_id = FND_API.G_MISS_NUM THEN

726: IF l_FNA_rec.last_update_login = FND_API.G_MISS_NUM THEN
727: l_FNA_rec.last_update_login := NULL;
728: END IF;
729:
730: IF l_FNA_rec.program_application_id = FND_API.G_MISS_NUM THEN
731: l_FNA_rec.program_application_id := NULL;
732: END IF;
733:
734: IF l_FNA_rec.program_id = FND_API.G_MISS_NUM THEN

Line 734: IF l_FNA_rec.program_id = FND_API.G_MISS_NUM THEN

730: IF l_FNA_rec.program_application_id = FND_API.G_MISS_NUM THEN
731: l_FNA_rec.program_application_id := NULL;
732: END IF;
733:
734: IF l_FNA_rec.program_id = FND_API.G_MISS_NUM THEN
735: l_FNA_rec.program_id := NULL;
736: END IF;
737:
738: IF l_FNA_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 738: IF l_FNA_rec.program_update_date = FND_API.G_MISS_DATE THEN

734: IF l_FNA_rec.program_id = FND_API.G_MISS_NUM THEN
735: l_FNA_rec.program_id := NULL;
736: END IF;
737:
738: IF l_FNA_rec.program_update_date = FND_API.G_MISS_DATE THEN
739: l_FNA_rec.program_update_date := NULL;
740: END IF;
741:
742: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN

Line 742: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN

738: IF l_FNA_rec.program_update_date = FND_API.G_MISS_DATE THEN
739: l_FNA_rec.program_update_date := NULL;
740: END IF;
741:
742: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN
743: l_FNA_rec.pte_sourcesystem_fnarea_id := NULL;
744: END IF;
745:
746: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN

Line 746: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN

742: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN
743: l_FNA_rec.pte_sourcesystem_fnarea_id := NULL;
744: END IF;
745:
746: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN
747: l_FNA_rec.pte_source_system_id := NULL;
748: END IF;
749:
750: IF l_FNA_rec.request_id = FND_API.G_MISS_NUM THEN

Line 750: IF l_FNA_rec.request_id = FND_API.G_MISS_NUM THEN

746: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN
747: l_FNA_rec.pte_source_system_id := NULL;
748: END IF;
749:
750: IF l_FNA_rec.request_id = FND_API.G_MISS_NUM THEN
751: l_FNA_rec.request_id := NULL;
752: END IF;
753:
754: IF l_FNA_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

Line 754: IF l_FNA_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

750: IF l_FNA_rec.request_id = FND_API.G_MISS_NUM THEN
751: l_FNA_rec.request_id := NULL;
752: END IF;
753:
754: IF l_FNA_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
755: l_FNA_rec.seeded_flag := NULL;
756: END IF;
757:
758: RETURN l_FNA_rec;

Line 816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

812: , 'Update_Row'
813: );
814: END IF;
815:
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817:
818: END Update_Row;
819:
820: -- Procedure Insert_Row

Line 905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

901: , 'Insert_Row'
902: );
903: END IF;
904:
905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
906:
907: END Insert_Row;
908:
909: -- Procedure Delete_Row

Line 933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

929: , 'Delete_Row'
930: );
931: END IF;
932:
933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
934:
935: END Delete_Row;
936:
937: -- Function Query_Row

Line 957: FND_API.G_MISS_NUM

953: --
954:
955: FUNCTION Query_Rows
956: ( p_pte_sourcesystem_fnarea_id IN NUMBER :=
957: FND_API.G_MISS_NUM
958: , p_pte_source_system_id IN NUMBER :=
959: FND_API.G_MISS_NUM
960: ) RETURN QP_Attr_Map_PUB.Fna_Tbl_Type
961: IS

Line 959: FND_API.G_MISS_NUM

955: FUNCTION Query_Rows
956: ( p_pte_sourcesystem_fnarea_id IN NUMBER :=
957: FND_API.G_MISS_NUM
958: , p_pte_source_system_id IN NUMBER :=
959: FND_API.G_MISS_NUM
960: ) RETURN QP_Attr_Map_PUB.Fna_Tbl_Type
961: IS
962: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
963: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1007: p_pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM)

1003:
1004: IF
1005: (p_pte_sourcesystem_fnarea_id IS NOT NULL
1006: AND
1007: p_pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM)
1008: AND
1009: (p_pte_source_system_id IS NOT NULL
1010: AND
1011: p_pte_source_system_id <> FND_API.G_MISS_NUM)

Line 1011: p_pte_source_system_id <> FND_API.G_MISS_NUM)

1007: p_pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM)
1008: AND
1009: (p_pte_source_system_id IS NOT NULL
1010: AND
1011: p_pte_source_system_id <> FND_API.G_MISS_NUM)
1012: THEN
1013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg

Line 1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1018: , 'Keys are mutually exclusive: pte_sourcesystem_fnarea_id = '|| p_pte_sourcesystem_fnarea_id || ', pte_source_system_id = '|| p_pte_source_system_id
1019: );
1020: END IF;
1021:
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023:
1024: END IF;
1025:
1026:

Line 1071: p_pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM)

1067:
1068: IF
1069: (p_pte_sourcesystem_fnarea_id IS NOT NULL
1070: AND
1071: p_pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM)
1072: AND
1073: (l_FNA_tbl.COUNT = 0)
1074: THEN
1075: RAISE NO_DATA_FOUND;

Line 1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1081: RETURN l_FNA_tbl;
1082:
1083: EXCEPTION
1084:
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086:
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088:
1089: WHEN OTHERS THEN

Line 1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1083: EXCEPTION
1084:
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086:
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088:
1089: WHEN OTHERS THEN
1090:
1091: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1095: , 'Query_Rows'
1096: );
1097: END IF;
1098:
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100:
1101: END Query_Rows;
1102:
1103: -- Procedure lock_Row

Line 1249: x_return_status := FND_API.G_RET_STS_SUCCESS;

1245: x_FNA_rec := l_FNA_rec;
1246:
1247: -- Set return status
1248:
1249: x_return_status := FND_API.G_RET_STS_SUCCESS;
1250: x_FNA_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1251:
1252: ELSE
1253:

Line 1250: x_FNA_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1246:
1247: -- Set return status
1248:
1249: x_return_status := FND_API.G_RET_STS_SUCCESS;
1250: x_FNA_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1251:
1252: ELSE
1253:
1254: -- Row has changed by another user.

Line 1256: x_return_status := FND_API.G_RET_STS_ERROR;

1252: ELSE
1253:
1254: -- Row has changed by another user.
1255:
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1258:
1259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1260: THEN

Line 1257: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;

1253:
1254: -- Row has changed by another user.
1255:
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1258:
1259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1260: THEN
1261:

Line 1273: x_return_status := FND_API.G_RET_STS_ERROR;

1269: EXCEPTION
1270:
1271: WHEN NO_DATA_FOUND THEN
1272:
1273: x_return_status := FND_API.G_RET_STS_ERROR;
1274: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1275:
1276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1277: THEN

Line 1274: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;

1270:
1271: WHEN NO_DATA_FOUND THEN
1272:
1273: x_return_status := FND_API.G_RET_STS_ERROR;
1274: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1275:
1276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1277: THEN
1278:

Line 1285: x_return_status := FND_API.G_RET_STS_ERROR;

1281:
1282: END IF;
1283: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1284:
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1287:
1288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1289: THEN

Line 1286: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;

1282: END IF;
1283: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1284:
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286: x_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1287:
1288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1289: THEN
1290:

Line 1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1293:
1294: END IF;
1295: WHEN OTHERS THEN
1296:
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: x_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299:
1300: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1301: THEN

Line 1298: x_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1294: END IF;
1295: WHEN OTHERS THEN
1296:
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: x_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299:
1300: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1301: THEN
1302: OE_MSG_PUB.Add_Exc_Msg

Line 1322: p_FNA_rec.enabled_flag <> FND_API.G_MISS_CHAR AND

1318: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
1319: BEGIN
1320:
1321: IF p_FNA_rec.enabled_flag IS NOT NULL AND
1322: p_FNA_rec.enabled_flag <> FND_API.G_MISS_CHAR AND
1323: NOT QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,
1324: p_old_FNA_rec.enabled_flag)
1325: THEN
1326: l_FNA_val_rec.enabled := QP_Id_To_Value.Enabled

Line 1332: p_FNA_rec.functional_area_id <> FND_API.G_MISS_NUM AND

1328: );
1329: END IF;
1330:
1331: IF p_FNA_rec.functional_area_id IS NOT NULL AND
1332: p_FNA_rec.functional_area_id <> FND_API.G_MISS_NUM AND
1333: NOT QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,
1334: p_old_FNA_rec.functional_area_id)
1335: THEN
1336: l_FNA_val_rec.functional_area := QP_Id_To_Value.Functional_Area

Line 1342: p_FNA_rec.pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM AND

1338: );
1339: END IF;
1340:
1341: IF p_FNA_rec.pte_sourcesystem_fnarea_id IS NOT NULL AND
1342: p_FNA_rec.pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM AND
1343: NOT QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,
1344: p_old_FNA_rec.pte_sourcesystem_fnarea_id)
1345: THEN
1346: -- We comment this code out because we have a pte_sourcesystem_fnarea_id,

Line 1359: p_FNA_rec.pte_source_system_id <> FND_API.G_MISS_NUM AND

1355: END IF;
1356:
1357:
1358: IF p_FNA_rec.pte_source_system_id IS NOT NULL AND
1359: p_FNA_rec.pte_source_system_id <> FND_API.G_MISS_NUM AND
1360: NOT QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,
1361: p_old_FNA_rec.pte_source_system_id)
1362: THEN
1363: l_FNA_val_rec.pte_source_system := QP_Id_To_Value.Pte_Source_System

Line 1370: p_FNA_rec.seeded_flag <> FND_API.G_MISS_CHAR AND

1366: END IF;
1367:
1368:
1369: IF p_FNA_rec.seeded_flag IS NOT NULL AND
1370: p_FNA_rec.seeded_flag <> FND_API.G_MISS_CHAR AND
1371: NOT QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,
1372: p_old_FNA_rec.seeded_flag)
1373: THEN
1374: l_FNA_val_rec.seeded := QP_Id_To_Value.Seeded

Line 1395: l_FNA_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1391: BEGIN
1392:
1393: -- initialize return_status.
1394:
1395: l_FNA_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1396:
1397: -- initialize l_FNA_rec.
1398:
1399: l_FNA_rec := p_FNA_rec;

Line 1401: IF p_FNA_val_rec.enabled <> FND_API.G_MISS_CHAR

1397: -- initialize l_FNA_rec.
1398:
1399: l_FNA_rec := p_FNA_rec;
1400:
1401: IF p_FNA_val_rec.enabled <> FND_API.G_MISS_CHAR
1402: THEN
1403:
1404: IF p_FNA_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1405:

Line 1404: IF p_FNA_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN

1400:
1401: IF p_FNA_val_rec.enabled <> FND_API.G_MISS_CHAR
1402: THEN
1403:
1404: IF p_FNA_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1405:
1406: l_FNA_rec.enabled_flag := p_FNA_rec.enabled_flag;
1407:
1408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1423: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

1419: l_FNA_rec.enabled_flag := QP_Value_To_Id.enabled
1420: ( p_enabled => p_FNA_val_rec.enabled
1421: );
1422:
1423: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
1424: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;
1426:
1427: END IF;

Line 1424: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;

1420: ( p_enabled => p_FNA_val_rec.enabled
1421: );
1422:
1423: IF l_FNA_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
1424: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;
1426:
1427: END IF;
1428:

Line 1431: IF p_FNA_val_rec.functional_area <> FND_API.G_MISS_CHAR

1427: END IF;
1428:
1429: END IF;
1430:
1431: IF p_FNA_val_rec.functional_area <> FND_API.G_MISS_CHAR
1432: THEN
1433:
1434: IF p_FNA_rec.functional_area_id <> FND_API.G_MISS_NUM THEN
1435:

Line 1434: IF p_FNA_rec.functional_area_id <> FND_API.G_MISS_NUM THEN

1430:
1431: IF p_FNA_val_rec.functional_area <> FND_API.G_MISS_CHAR
1432: THEN
1433:
1434: IF p_FNA_rec.functional_area_id <> FND_API.G_MISS_NUM THEN
1435:
1436: l_FNA_rec.functional_area_id := p_FNA_rec.functional_area_id;
1437:
1438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1453: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN

1449: l_FNA_rec.functional_area_id := QP_Value_To_Id.functional_area
1450: ( p_functional_area => p_FNA_val_rec.functional_area
1451: );
1452:
1453: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN
1454: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1455: END IF;
1456:
1457: END IF;

Line 1454: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;

1450: ( p_functional_area => p_FNA_val_rec.functional_area
1451: );
1452:
1453: IF l_FNA_rec.functional_area_id = FND_API.G_MISS_NUM THEN
1454: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1455: END IF;
1456:
1457: END IF;
1458:

Line 1461: IF p_FNA_val_rec.pte_sourcesystem_fnarea <> FND_API.G_MISS_CHAR

1457: END IF;
1458:
1459: END IF;
1460:
1461: IF p_FNA_val_rec.pte_sourcesystem_fnarea <> FND_API.G_MISS_CHAR
1462: THEN
1463:
1464: IF p_FNA_rec.pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM THEN
1465:

Line 1464: IF p_FNA_rec.pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM THEN

1460:
1461: IF p_FNA_val_rec.pte_sourcesystem_fnarea <> FND_API.G_MISS_CHAR
1462: THEN
1463:
1464: IF p_FNA_rec.pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM THEN
1465:
1466: l_FNA_rec.pte_sourcesystem_fnarea_id := p_FNA_rec.pte_sourcesystem_fnarea_id;
1467:
1468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1483: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN

1479: l_FNA_rec.pte_sourcesystem_fnarea_id := QP_Value_To_Id.pte_sourcesystem_fnarea
1480: ( p_pte_sourcesystem_fnarea => p_FNA_val_rec.pte_sourcesystem_fnarea
1481: );
1482:
1483: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN
1484: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1485: END IF;
1486:
1487: END IF;

Line 1484: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;

1480: ( p_pte_sourcesystem_fnarea => p_FNA_val_rec.pte_sourcesystem_fnarea
1481: );
1482:
1483: IF l_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM THEN
1484: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1485: END IF;
1486:
1487: END IF;
1488:

Line 1491: IF p_FNA_val_rec.pte_source_system <> FND_API.G_MISS_CHAR

1487: END IF;
1488:
1489: END IF;
1490:
1491: IF p_FNA_val_rec.pte_source_system <> FND_API.G_MISS_CHAR
1492: THEN
1493:
1494: IF p_FNA_rec.pte_source_system_id <> FND_API.G_MISS_NUM THEN
1495:

Line 1494: IF p_FNA_rec.pte_source_system_id <> FND_API.G_MISS_NUM THEN

1490:
1491: IF p_FNA_val_rec.pte_source_system <> FND_API.G_MISS_CHAR
1492: THEN
1493:
1494: IF p_FNA_rec.pte_source_system_id <> FND_API.G_MISS_NUM THEN
1495:
1496: l_FNA_rec.pte_source_system_id := p_FNA_rec.pte_source_system_id;
1497:
1498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1513: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN

1509: l_FNA_rec.pte_source_system_id := QP_Value_To_Id.pte_source_system
1510: ( p_pte_source_system => p_FNA_val_rec.pte_source_system
1511: );
1512:
1513: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN
1514: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1515: END IF;
1516:
1517: END IF;

Line 1514: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;

1510: ( p_pte_source_system => p_FNA_val_rec.pte_source_system
1511: );
1512:
1513: IF l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM THEN
1514: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1515: END IF;
1516:
1517: END IF;
1518:

Line 1521: IF p_FNA_val_rec.seeded <> FND_API.G_MISS_CHAR

1517: END IF;
1518:
1519: END IF;
1520:
1521: IF p_FNA_val_rec.seeded <> FND_API.G_MISS_CHAR
1522: THEN
1523:
1524: IF p_FNA_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
1525:

Line 1524: IF p_FNA_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN

1520:
1521: IF p_FNA_val_rec.seeded <> FND_API.G_MISS_CHAR
1522: THEN
1523:
1524: IF p_FNA_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
1525:
1526: l_FNA_rec.seeded_flag := p_FNA_rec.seeded_flag;
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1543: IF l_FNA_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

1539: l_FNA_rec.seeded_flag := QP_Value_To_Id.seeded
1540: ( p_seeded => p_FNA_val_rec.seeded
1541: );
1542:
1543: IF l_FNA_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
1544: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1545: END IF;
1546:
1547: END IF;

Line 1544: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;

1540: ( p_seeded => p_FNA_val_rec.seeded
1541: );
1542:
1543: IF l_FNA_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
1544: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1545: END IF;
1546:
1547: END IF;
1548: