APPS.QP_RQT_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_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
13: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_RQT_REC
15: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_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_RQT_rec.attribute1,p_old_RQT_rec.attribute1)
33: THEN
34: l_index := l_index + 1;

Line 525: IF l_RQT_rec.attribute1 = FND_API.G_MISS_CHAR THEN

521: IS
522: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;
523: BEGIN
524:
525: IF l_RQT_rec.attribute1 = FND_API.G_MISS_CHAR THEN
526: l_RQT_rec.attribute1 := p_old_RQT_rec.attribute1;
527: END IF;
528:
529: IF l_RQT_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 529: IF l_RQT_rec.attribute10 = FND_API.G_MISS_CHAR THEN

525: IF l_RQT_rec.attribute1 = FND_API.G_MISS_CHAR THEN
526: l_RQT_rec.attribute1 := p_old_RQT_rec.attribute1;
527: END IF;
528:
529: IF l_RQT_rec.attribute10 = FND_API.G_MISS_CHAR THEN
530: l_RQT_rec.attribute10 := p_old_RQT_rec.attribute10;
531: END IF;
532:
533: IF l_RQT_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 533: IF l_RQT_rec.attribute11 = FND_API.G_MISS_CHAR THEN

529: IF l_RQT_rec.attribute10 = FND_API.G_MISS_CHAR THEN
530: l_RQT_rec.attribute10 := p_old_RQT_rec.attribute10;
531: END IF;
532:
533: IF l_RQT_rec.attribute11 = FND_API.G_MISS_CHAR THEN
534: l_RQT_rec.attribute11 := p_old_RQT_rec.attribute11;
535: END IF;
536:
537: IF l_RQT_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 537: IF l_RQT_rec.attribute12 = FND_API.G_MISS_CHAR THEN

533: IF l_RQT_rec.attribute11 = FND_API.G_MISS_CHAR THEN
534: l_RQT_rec.attribute11 := p_old_RQT_rec.attribute11;
535: END IF;
536:
537: IF l_RQT_rec.attribute12 = FND_API.G_MISS_CHAR THEN
538: l_RQT_rec.attribute12 := p_old_RQT_rec.attribute12;
539: END IF;
540:
541: IF l_RQT_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 541: IF l_RQT_rec.attribute13 = FND_API.G_MISS_CHAR THEN

537: IF l_RQT_rec.attribute12 = FND_API.G_MISS_CHAR THEN
538: l_RQT_rec.attribute12 := p_old_RQT_rec.attribute12;
539: END IF;
540:
541: IF l_RQT_rec.attribute13 = FND_API.G_MISS_CHAR THEN
542: l_RQT_rec.attribute13 := p_old_RQT_rec.attribute13;
543: END IF;
544:
545: IF l_RQT_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 545: IF l_RQT_rec.attribute14 = FND_API.G_MISS_CHAR THEN

541: IF l_RQT_rec.attribute13 = FND_API.G_MISS_CHAR THEN
542: l_RQT_rec.attribute13 := p_old_RQT_rec.attribute13;
543: END IF;
544:
545: IF l_RQT_rec.attribute14 = FND_API.G_MISS_CHAR THEN
546: l_RQT_rec.attribute14 := p_old_RQT_rec.attribute14;
547: END IF;
548:
549: IF l_RQT_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 549: IF l_RQT_rec.attribute15 = FND_API.G_MISS_CHAR THEN

545: IF l_RQT_rec.attribute14 = FND_API.G_MISS_CHAR THEN
546: l_RQT_rec.attribute14 := p_old_RQT_rec.attribute14;
547: END IF;
548:
549: IF l_RQT_rec.attribute15 = FND_API.G_MISS_CHAR THEN
550: l_RQT_rec.attribute15 := p_old_RQT_rec.attribute15;
551: END IF;
552:
553: IF l_RQT_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 553: IF l_RQT_rec.attribute2 = FND_API.G_MISS_CHAR THEN

549: IF l_RQT_rec.attribute15 = FND_API.G_MISS_CHAR THEN
550: l_RQT_rec.attribute15 := p_old_RQT_rec.attribute15;
551: END IF;
552:
553: IF l_RQT_rec.attribute2 = FND_API.G_MISS_CHAR THEN
554: l_RQT_rec.attribute2 := p_old_RQT_rec.attribute2;
555: END IF;
556:
557: IF l_RQT_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 557: IF l_RQT_rec.attribute3 = FND_API.G_MISS_CHAR THEN

553: IF l_RQT_rec.attribute2 = FND_API.G_MISS_CHAR THEN
554: l_RQT_rec.attribute2 := p_old_RQT_rec.attribute2;
555: END IF;
556:
557: IF l_RQT_rec.attribute3 = FND_API.G_MISS_CHAR THEN
558: l_RQT_rec.attribute3 := p_old_RQT_rec.attribute3;
559: END IF;
560:
561: IF l_RQT_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 561: IF l_RQT_rec.attribute4 = FND_API.G_MISS_CHAR THEN

557: IF l_RQT_rec.attribute3 = FND_API.G_MISS_CHAR THEN
558: l_RQT_rec.attribute3 := p_old_RQT_rec.attribute3;
559: END IF;
560:
561: IF l_RQT_rec.attribute4 = FND_API.G_MISS_CHAR THEN
562: l_RQT_rec.attribute4 := p_old_RQT_rec.attribute4;
563: END IF;
564:
565: IF l_RQT_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 565: IF l_RQT_rec.attribute5 = FND_API.G_MISS_CHAR THEN

561: IF l_RQT_rec.attribute4 = FND_API.G_MISS_CHAR THEN
562: l_RQT_rec.attribute4 := p_old_RQT_rec.attribute4;
563: END IF;
564:
565: IF l_RQT_rec.attribute5 = FND_API.G_MISS_CHAR THEN
566: l_RQT_rec.attribute5 := p_old_RQT_rec.attribute5;
567: END IF;
568:
569: IF l_RQT_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 569: IF l_RQT_rec.attribute6 = FND_API.G_MISS_CHAR THEN

565: IF l_RQT_rec.attribute5 = FND_API.G_MISS_CHAR THEN
566: l_RQT_rec.attribute5 := p_old_RQT_rec.attribute5;
567: END IF;
568:
569: IF l_RQT_rec.attribute6 = FND_API.G_MISS_CHAR THEN
570: l_RQT_rec.attribute6 := p_old_RQT_rec.attribute6;
571: END IF;
572:
573: IF l_RQT_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 573: IF l_RQT_rec.attribute7 = FND_API.G_MISS_CHAR THEN

569: IF l_RQT_rec.attribute6 = FND_API.G_MISS_CHAR THEN
570: l_RQT_rec.attribute6 := p_old_RQT_rec.attribute6;
571: END IF;
572:
573: IF l_RQT_rec.attribute7 = FND_API.G_MISS_CHAR THEN
574: l_RQT_rec.attribute7 := p_old_RQT_rec.attribute7;
575: END IF;
576:
577: IF l_RQT_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 577: IF l_RQT_rec.attribute8 = FND_API.G_MISS_CHAR THEN

573: IF l_RQT_rec.attribute7 = FND_API.G_MISS_CHAR THEN
574: l_RQT_rec.attribute7 := p_old_RQT_rec.attribute7;
575: END IF;
576:
577: IF l_RQT_rec.attribute8 = FND_API.G_MISS_CHAR THEN
578: l_RQT_rec.attribute8 := p_old_RQT_rec.attribute8;
579: END IF;
580:
581: IF l_RQT_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 581: IF l_RQT_rec.attribute9 = FND_API.G_MISS_CHAR THEN

577: IF l_RQT_rec.attribute8 = FND_API.G_MISS_CHAR THEN
578: l_RQT_rec.attribute8 := p_old_RQT_rec.attribute8;
579: END IF;
580:
581: IF l_RQT_rec.attribute9 = FND_API.G_MISS_CHAR THEN
582: l_RQT_rec.attribute9 := p_old_RQT_rec.attribute9;
583: END IF;
584:
585: IF l_RQT_rec.context = FND_API.G_MISS_CHAR THEN

Line 585: IF l_RQT_rec.context = FND_API.G_MISS_CHAR THEN

581: IF l_RQT_rec.attribute9 = FND_API.G_MISS_CHAR THEN
582: l_RQT_rec.attribute9 := p_old_RQT_rec.attribute9;
583: END IF;
584:
585: IF l_RQT_rec.context = FND_API.G_MISS_CHAR THEN
586: l_RQT_rec.context := p_old_RQT_rec.context;
587: END IF;
588:
589: IF l_RQT_rec.created_by = FND_API.G_MISS_NUM THEN

Line 589: IF l_RQT_rec.created_by = FND_API.G_MISS_NUM THEN

585: IF l_RQT_rec.context = FND_API.G_MISS_CHAR THEN
586: l_RQT_rec.context := p_old_RQT_rec.context;
587: END IF;
588:
589: IF l_RQT_rec.created_by = FND_API.G_MISS_NUM THEN
590: l_RQT_rec.created_by := p_old_RQT_rec.created_by;
591: END IF;
592:
593: IF l_RQT_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 593: IF l_RQT_rec.creation_date = FND_API.G_MISS_DATE THEN

589: IF l_RQT_rec.created_by = FND_API.G_MISS_NUM THEN
590: l_RQT_rec.created_by := p_old_RQT_rec.created_by;
591: END IF;
592:
593: IF l_RQT_rec.creation_date = FND_API.G_MISS_DATE THEN
594: l_RQT_rec.creation_date := p_old_RQT_rec.creation_date;
595: END IF;
596:
597: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

Line 597: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

593: IF l_RQT_rec.creation_date = FND_API.G_MISS_DATE THEN
594: l_RQT_rec.creation_date := p_old_RQT_rec.creation_date;
595: END IF;
596:
597: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
598: l_RQT_rec.enabled_flag := p_old_RQT_rec.enabled_flag;
599: END IF;
600:
601: IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 601: IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN

597: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
598: l_RQT_rec.enabled_flag := p_old_RQT_rec.enabled_flag;
599: END IF;
600:
601: IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN
602: l_RQT_rec.last_updated_by := p_old_RQT_rec.last_updated_by;
603: END IF;
604:
605: IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 605: IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN

601: IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN
602: l_RQT_rec.last_updated_by := p_old_RQT_rec.last_updated_by;
603: END IF;
604:
605: IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN
606: l_RQT_rec.last_update_date := p_old_RQT_rec.last_update_date;
607: END IF;
608:
609: IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 609: IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN

605: IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN
606: l_RQT_rec.last_update_date := p_old_RQT_rec.last_update_date;
607: END IF;
608:
609: IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN
610: l_RQT_rec.last_update_login := p_old_RQT_rec.last_update_login;
611: END IF;
612:
613: IF l_RQT_rec.line_level_global_struct = FND_API.G_MISS_CHAR THEN

Line 613: IF l_RQT_rec.line_level_global_struct = FND_API.G_MISS_CHAR THEN

609: IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN
610: l_RQT_rec.last_update_login := p_old_RQT_rec.last_update_login;
611: END IF;
612:
613: IF l_RQT_rec.line_level_global_struct = FND_API.G_MISS_CHAR THEN
614: l_RQT_rec.line_level_global_struct := p_old_RQT_rec.line_level_global_struct;
615: END IF;
616:
617: IF l_RQT_rec.line_level_view_name = FND_API.G_MISS_CHAR THEN

Line 617: IF l_RQT_rec.line_level_view_name = FND_API.G_MISS_CHAR THEN

613: IF l_RQT_rec.line_level_global_struct = FND_API.G_MISS_CHAR THEN
614: l_RQT_rec.line_level_global_struct := p_old_RQT_rec.line_level_global_struct;
615: END IF;
616:
617: IF l_RQT_rec.line_level_view_name = FND_API.G_MISS_CHAR THEN
618: l_RQT_rec.line_level_view_name := p_old_RQT_rec.line_level_view_name;
619: END IF;
620:
621: IF l_RQT_rec.order_level_global_struct = FND_API.G_MISS_CHAR THEN

Line 621: IF l_RQT_rec.order_level_global_struct = FND_API.G_MISS_CHAR THEN

617: IF l_RQT_rec.line_level_view_name = FND_API.G_MISS_CHAR THEN
618: l_RQT_rec.line_level_view_name := p_old_RQT_rec.line_level_view_name;
619: END IF;
620:
621: IF l_RQT_rec.order_level_global_struct = FND_API.G_MISS_CHAR THEN
622: l_RQT_rec.order_level_global_struct := p_old_RQT_rec.order_level_global_struct;
623: END IF;
624:
625: IF l_RQT_rec.order_level_view_name = FND_API.G_MISS_CHAR THEN

Line 625: IF l_RQT_rec.order_level_view_name = FND_API.G_MISS_CHAR THEN

621: IF l_RQT_rec.order_level_global_struct = FND_API.G_MISS_CHAR THEN
622: l_RQT_rec.order_level_global_struct := p_old_RQT_rec.order_level_global_struct;
623: END IF;
624:
625: IF l_RQT_rec.order_level_view_name = FND_API.G_MISS_CHAR THEN
626: l_RQT_rec.order_level_view_name := p_old_RQT_rec.order_level_view_name;
627: END IF;
628:
629: IF l_RQT_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 629: IF l_RQT_rec.program_application_id = FND_API.G_MISS_NUM THEN

625: IF l_RQT_rec.order_level_view_name = FND_API.G_MISS_CHAR THEN
626: l_RQT_rec.order_level_view_name := p_old_RQT_rec.order_level_view_name;
627: END IF;
628:
629: IF l_RQT_rec.program_application_id = FND_API.G_MISS_NUM THEN
630: l_RQT_rec.program_application_id := p_old_RQT_rec.program_application_id;
631: END IF;
632:
633: IF l_RQT_rec.program_id = FND_API.G_MISS_NUM THEN

Line 633: IF l_RQT_rec.program_id = FND_API.G_MISS_NUM THEN

629: IF l_RQT_rec.program_application_id = FND_API.G_MISS_NUM THEN
630: l_RQT_rec.program_application_id := p_old_RQT_rec.program_application_id;
631: END IF;
632:
633: IF l_RQT_rec.program_id = FND_API.G_MISS_NUM THEN
634: l_RQT_rec.program_id := p_old_RQT_rec.program_id;
635: END IF;
636:
637: IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 637: IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN

633: IF l_RQT_rec.program_id = FND_API.G_MISS_NUM THEN
634: l_RQT_rec.program_id := p_old_RQT_rec.program_id;
635: END IF;
636:
637: IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN
638: l_RQT_rec.program_update_date := p_old_RQT_rec.program_update_date;
639: END IF;
640:
641: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN

Line 641: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN

637: IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN
638: l_RQT_rec.program_update_date := p_old_RQT_rec.program_update_date;
639: END IF;
640:
641: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN
642: l_RQT_rec.pte_code := p_old_RQT_rec.pte_code;
643: END IF;
644:
645: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN

Line 645: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN

641: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN
642: l_RQT_rec.pte_code := p_old_RQT_rec.pte_code;
643: END IF;
644:
645: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN
646: l_RQT_rec.request_type_code := p_old_RQT_rec.request_type_code;
647: END IF;
648:
649: IF l_RQT_rec.request_type_desc = FND_API.G_MISS_CHAR THEN

Line 649: IF l_RQT_rec.request_type_desc = FND_API.G_MISS_CHAR THEN

645: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN
646: l_RQT_rec.request_type_code := p_old_RQT_rec.request_type_code;
647: END IF;
648:
649: IF l_RQT_rec.request_type_desc = FND_API.G_MISS_CHAR THEN
650: l_RQT_rec.request_type_desc := p_old_RQT_rec.request_type_desc;
651: END IF;
652:
653: IF l_RQT_rec.row_id = FND_API.G_MISS_CHAR THEN

Line 653: IF l_RQT_rec.row_id = FND_API.G_MISS_CHAR THEN

649: IF l_RQT_rec.request_type_desc = FND_API.G_MISS_CHAR THEN
650: l_RQT_rec.request_type_desc := p_old_RQT_rec.request_type_desc;
651: END IF;
652:
653: IF l_RQT_rec.row_id = FND_API.G_MISS_CHAR THEN
654: l_RQT_rec.row_id := p_old_RQT_rec.row_id;
655: END IF;
656:
657: RETURN l_RQT_rec;

Line 670: IF l_RQT_rec.attribute1 = FND_API.G_MISS_CHAR THEN

666: IS
667: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;
668: BEGIN
669:
670: IF l_RQT_rec.attribute1 = FND_API.G_MISS_CHAR THEN
671: l_RQT_rec.attribute1 := NULL;
672: END IF;
673:
674: IF l_RQT_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 674: IF l_RQT_rec.attribute10 = FND_API.G_MISS_CHAR THEN

670: IF l_RQT_rec.attribute1 = FND_API.G_MISS_CHAR THEN
671: l_RQT_rec.attribute1 := NULL;
672: END IF;
673:
674: IF l_RQT_rec.attribute10 = FND_API.G_MISS_CHAR THEN
675: l_RQT_rec.attribute10 := NULL;
676: END IF;
677:
678: IF l_RQT_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 678: IF l_RQT_rec.attribute11 = FND_API.G_MISS_CHAR THEN

674: IF l_RQT_rec.attribute10 = FND_API.G_MISS_CHAR THEN
675: l_RQT_rec.attribute10 := NULL;
676: END IF;
677:
678: IF l_RQT_rec.attribute11 = FND_API.G_MISS_CHAR THEN
679: l_RQT_rec.attribute11 := NULL;
680: END IF;
681:
682: IF l_RQT_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 682: IF l_RQT_rec.attribute12 = FND_API.G_MISS_CHAR THEN

678: IF l_RQT_rec.attribute11 = FND_API.G_MISS_CHAR THEN
679: l_RQT_rec.attribute11 := NULL;
680: END IF;
681:
682: IF l_RQT_rec.attribute12 = FND_API.G_MISS_CHAR THEN
683: l_RQT_rec.attribute12 := NULL;
684: END IF;
685:
686: IF l_RQT_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 686: IF l_RQT_rec.attribute13 = FND_API.G_MISS_CHAR THEN

682: IF l_RQT_rec.attribute12 = FND_API.G_MISS_CHAR THEN
683: l_RQT_rec.attribute12 := NULL;
684: END IF;
685:
686: IF l_RQT_rec.attribute13 = FND_API.G_MISS_CHAR THEN
687: l_RQT_rec.attribute13 := NULL;
688: END IF;
689:
690: IF l_RQT_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 690: IF l_RQT_rec.attribute14 = FND_API.G_MISS_CHAR THEN

686: IF l_RQT_rec.attribute13 = FND_API.G_MISS_CHAR THEN
687: l_RQT_rec.attribute13 := NULL;
688: END IF;
689:
690: IF l_RQT_rec.attribute14 = FND_API.G_MISS_CHAR THEN
691: l_RQT_rec.attribute14 := NULL;
692: END IF;
693:
694: IF l_RQT_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 694: IF l_RQT_rec.attribute15 = FND_API.G_MISS_CHAR THEN

690: IF l_RQT_rec.attribute14 = FND_API.G_MISS_CHAR THEN
691: l_RQT_rec.attribute14 := NULL;
692: END IF;
693:
694: IF l_RQT_rec.attribute15 = FND_API.G_MISS_CHAR THEN
695: l_RQT_rec.attribute15 := NULL;
696: END IF;
697:
698: IF l_RQT_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 698: IF l_RQT_rec.attribute2 = FND_API.G_MISS_CHAR THEN

694: IF l_RQT_rec.attribute15 = FND_API.G_MISS_CHAR THEN
695: l_RQT_rec.attribute15 := NULL;
696: END IF;
697:
698: IF l_RQT_rec.attribute2 = FND_API.G_MISS_CHAR THEN
699: l_RQT_rec.attribute2 := NULL;
700: END IF;
701:
702: IF l_RQT_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 702: IF l_RQT_rec.attribute3 = FND_API.G_MISS_CHAR THEN

698: IF l_RQT_rec.attribute2 = FND_API.G_MISS_CHAR THEN
699: l_RQT_rec.attribute2 := NULL;
700: END IF;
701:
702: IF l_RQT_rec.attribute3 = FND_API.G_MISS_CHAR THEN
703: l_RQT_rec.attribute3 := NULL;
704: END IF;
705:
706: IF l_RQT_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 706: IF l_RQT_rec.attribute4 = FND_API.G_MISS_CHAR THEN

702: IF l_RQT_rec.attribute3 = FND_API.G_MISS_CHAR THEN
703: l_RQT_rec.attribute3 := NULL;
704: END IF;
705:
706: IF l_RQT_rec.attribute4 = FND_API.G_MISS_CHAR THEN
707: l_RQT_rec.attribute4 := NULL;
708: END IF;
709:
710: IF l_RQT_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 710: IF l_RQT_rec.attribute5 = FND_API.G_MISS_CHAR THEN

706: IF l_RQT_rec.attribute4 = FND_API.G_MISS_CHAR THEN
707: l_RQT_rec.attribute4 := NULL;
708: END IF;
709:
710: IF l_RQT_rec.attribute5 = FND_API.G_MISS_CHAR THEN
711: l_RQT_rec.attribute5 := NULL;
712: END IF;
713:
714: IF l_RQT_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 714: IF l_RQT_rec.attribute6 = FND_API.G_MISS_CHAR THEN

710: IF l_RQT_rec.attribute5 = FND_API.G_MISS_CHAR THEN
711: l_RQT_rec.attribute5 := NULL;
712: END IF;
713:
714: IF l_RQT_rec.attribute6 = FND_API.G_MISS_CHAR THEN
715: l_RQT_rec.attribute6 := NULL;
716: END IF;
717:
718: IF l_RQT_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 718: IF l_RQT_rec.attribute7 = FND_API.G_MISS_CHAR THEN

714: IF l_RQT_rec.attribute6 = FND_API.G_MISS_CHAR THEN
715: l_RQT_rec.attribute6 := NULL;
716: END IF;
717:
718: IF l_RQT_rec.attribute7 = FND_API.G_MISS_CHAR THEN
719: l_RQT_rec.attribute7 := NULL;
720: END IF;
721:
722: IF l_RQT_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 722: IF l_RQT_rec.attribute8 = FND_API.G_MISS_CHAR THEN

718: IF l_RQT_rec.attribute7 = FND_API.G_MISS_CHAR THEN
719: l_RQT_rec.attribute7 := NULL;
720: END IF;
721:
722: IF l_RQT_rec.attribute8 = FND_API.G_MISS_CHAR THEN
723: l_RQT_rec.attribute8 := NULL;
724: END IF;
725:
726: IF l_RQT_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 726: IF l_RQT_rec.attribute9 = FND_API.G_MISS_CHAR THEN

722: IF l_RQT_rec.attribute8 = FND_API.G_MISS_CHAR THEN
723: l_RQT_rec.attribute8 := NULL;
724: END IF;
725:
726: IF l_RQT_rec.attribute9 = FND_API.G_MISS_CHAR THEN
727: l_RQT_rec.attribute9 := NULL;
728: END IF;
729:
730: IF l_RQT_rec.context = FND_API.G_MISS_CHAR THEN

Line 730: IF l_RQT_rec.context = FND_API.G_MISS_CHAR THEN

726: IF l_RQT_rec.attribute9 = FND_API.G_MISS_CHAR THEN
727: l_RQT_rec.attribute9 := NULL;
728: END IF;
729:
730: IF l_RQT_rec.context = FND_API.G_MISS_CHAR THEN
731: l_RQT_rec.context := NULL;
732: END IF;
733:
734: IF l_RQT_rec.created_by = FND_API.G_MISS_NUM THEN

Line 734: IF l_RQT_rec.created_by = FND_API.G_MISS_NUM THEN

730: IF l_RQT_rec.context = FND_API.G_MISS_CHAR THEN
731: l_RQT_rec.context := NULL;
732: END IF;
733:
734: IF l_RQT_rec.created_by = FND_API.G_MISS_NUM THEN
735: l_RQT_rec.created_by := NULL;
736: END IF;
737:
738: IF l_RQT_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 738: IF l_RQT_rec.creation_date = FND_API.G_MISS_DATE THEN

734: IF l_RQT_rec.created_by = FND_API.G_MISS_NUM THEN
735: l_RQT_rec.created_by := NULL;
736: END IF;
737:
738: IF l_RQT_rec.creation_date = FND_API.G_MISS_DATE THEN
739: l_RQT_rec.creation_date := NULL;
740: END IF;
741:
742: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

Line 742: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

738: IF l_RQT_rec.creation_date = FND_API.G_MISS_DATE THEN
739: l_RQT_rec.creation_date := NULL;
740: END IF;
741:
742: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
743: l_RQT_rec.enabled_flag := NULL;
744: END IF;
745:
746: IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 746: IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN

742: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
743: l_RQT_rec.enabled_flag := NULL;
744: END IF;
745:
746: IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN
747: l_RQT_rec.last_updated_by := NULL;
748: END IF;
749:
750: IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 750: IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN

746: IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN
747: l_RQT_rec.last_updated_by := NULL;
748: END IF;
749:
750: IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN
751: l_RQT_rec.last_update_date := NULL;
752: END IF;
753:
754: IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 754: IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN

750: IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN
751: l_RQT_rec.last_update_date := NULL;
752: END IF;
753:
754: IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN
755: l_RQT_rec.last_update_login := NULL;
756: END IF;
757:
758: IF l_RQT_rec.line_level_global_struct = FND_API.G_MISS_CHAR THEN

Line 758: IF l_RQT_rec.line_level_global_struct = FND_API.G_MISS_CHAR THEN

754: IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN
755: l_RQT_rec.last_update_login := NULL;
756: END IF;
757:
758: IF l_RQT_rec.line_level_global_struct = FND_API.G_MISS_CHAR THEN
759: l_RQT_rec.line_level_global_struct := NULL;
760: END IF;
761:
762: IF l_RQT_rec.line_level_view_name = FND_API.G_MISS_CHAR THEN

Line 762: IF l_RQT_rec.line_level_view_name = FND_API.G_MISS_CHAR THEN

758: IF l_RQT_rec.line_level_global_struct = FND_API.G_MISS_CHAR THEN
759: l_RQT_rec.line_level_global_struct := NULL;
760: END IF;
761:
762: IF l_RQT_rec.line_level_view_name = FND_API.G_MISS_CHAR THEN
763: l_RQT_rec.line_level_view_name := NULL;
764: END IF;
765:
766: IF l_RQT_rec.order_level_global_struct = FND_API.G_MISS_CHAR THEN

Line 766: IF l_RQT_rec.order_level_global_struct = FND_API.G_MISS_CHAR THEN

762: IF l_RQT_rec.line_level_view_name = FND_API.G_MISS_CHAR THEN
763: l_RQT_rec.line_level_view_name := NULL;
764: END IF;
765:
766: IF l_RQT_rec.order_level_global_struct = FND_API.G_MISS_CHAR THEN
767: l_RQT_rec.order_level_global_struct := NULL;
768: END IF;
769:
770: IF l_RQT_rec.order_level_view_name = FND_API.G_MISS_CHAR THEN

Line 770: IF l_RQT_rec.order_level_view_name = FND_API.G_MISS_CHAR THEN

766: IF l_RQT_rec.order_level_global_struct = FND_API.G_MISS_CHAR THEN
767: l_RQT_rec.order_level_global_struct := NULL;
768: END IF;
769:
770: IF l_RQT_rec.order_level_view_name = FND_API.G_MISS_CHAR THEN
771: l_RQT_rec.order_level_view_name := NULL;
772: END IF;
773:
774: IF l_RQT_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 774: IF l_RQT_rec.program_application_id = FND_API.G_MISS_NUM THEN

770: IF l_RQT_rec.order_level_view_name = FND_API.G_MISS_CHAR THEN
771: l_RQT_rec.order_level_view_name := NULL;
772: END IF;
773:
774: IF l_RQT_rec.program_application_id = FND_API.G_MISS_NUM THEN
775: l_RQT_rec.program_application_id := NULL;
776: END IF;
777:
778: IF l_RQT_rec.program_id = FND_API.G_MISS_NUM THEN

Line 778: IF l_RQT_rec.program_id = FND_API.G_MISS_NUM THEN

774: IF l_RQT_rec.program_application_id = FND_API.G_MISS_NUM THEN
775: l_RQT_rec.program_application_id := NULL;
776: END IF;
777:
778: IF l_RQT_rec.program_id = FND_API.G_MISS_NUM THEN
779: l_RQT_rec.program_id := NULL;
780: END IF;
781:
782: IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 782: IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN

778: IF l_RQT_rec.program_id = FND_API.G_MISS_NUM THEN
779: l_RQT_rec.program_id := NULL;
780: END IF;
781:
782: IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN
783: l_RQT_rec.program_update_date := NULL;
784: END IF;
785:
786: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN

Line 786: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN

782: IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN
783: l_RQT_rec.program_update_date := NULL;
784: END IF;
785:
786: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN
787: l_RQT_rec.pte_code := NULL;
788: END IF;
789:
790: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN

Line 790: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN

786: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN
787: l_RQT_rec.pte_code := NULL;
788: END IF;
789:
790: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN
791: l_RQT_rec.request_type_code := NULL;
792: END IF;
793:
794: IF l_RQT_rec.request_type_desc = FND_API.G_MISS_CHAR THEN

Line 794: IF l_RQT_rec.request_type_desc = FND_API.G_MISS_CHAR THEN

790: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN
791: l_RQT_rec.request_type_code := NULL;
792: END IF;
793:
794: IF l_RQT_rec.request_type_desc = FND_API.G_MISS_CHAR THEN
795: l_RQT_rec.request_type_desc := NULL;
796: END IF;
797:
798: IF l_RQT_rec.row_id = FND_API.G_MISS_CHAR THEN

Line 798: IF l_RQT_rec.row_id = FND_API.G_MISS_CHAR THEN

794: IF l_RQT_rec.request_type_desc = FND_API.G_MISS_CHAR THEN
795: l_RQT_rec.request_type_desc := NULL;
796: END IF;
797:
798: IF l_RQT_rec.row_id = FND_API.G_MISS_CHAR THEN
799: l_RQT_rec.row_id := NULL;
800: END IF;
801:
802: RETURN l_RQT_rec;

Line 911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

907: , 'Update_Row'
908: );
909: END IF;
910:
911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
912:
913: END Update_Row;
914:
915: -- Procedure Insert_Row

Line 1107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1103: , 'Insert_Row'
1104: );
1105: END IF;
1106:
1107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1108:
1109: END Insert_Row;
1110:
1111: -- Procedure Delete_Row

Line 1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1137: , 'Delete_Row'
1138: );
1139: END IF;
1140:
1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1142:
1143: END Delete_Row;
1144:
1145: -- Function Query_Row

Line 1165: FND_API.G_MISS_CHAR

1161: --
1162:
1163: FUNCTION Query_Rows
1164: ( p_request_type_code IN VARCHAR2 :=
1165: FND_API.G_MISS_CHAR
1166: , p_lookup_code IN VARCHAR2 :=
1167: FND_API.G_MISS_CHAR
1168: ) RETURN QP_Attr_Map_PUB.Rqt_Tbl_Type
1169: IS

Line 1167: FND_API.G_MISS_CHAR

1163: FUNCTION Query_Rows
1164: ( p_request_type_code IN VARCHAR2 :=
1165: FND_API.G_MISS_CHAR
1166: , p_lookup_code IN VARCHAR2 :=
1167: FND_API.G_MISS_CHAR
1168: ) RETURN QP_Attr_Map_PUB.Rqt_Tbl_Type
1169: IS
1170: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1171: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 1219: p_request_type_code <> FND_API.G_MISS_CHAR)

1215:
1216: IF
1217: (p_request_type_code IS NOT NULL
1218: AND
1219: p_request_type_code <> FND_API.G_MISS_CHAR)
1220: AND
1221: (p_lookup_code IS NOT NULL
1222: AND
1223: p_lookup_code <> FND_API.G_MISS_CHAR)

Line 1223: p_lookup_code <> FND_API.G_MISS_CHAR)

1219: p_request_type_code <> FND_API.G_MISS_CHAR)
1220: AND
1221: (p_lookup_code IS NOT NULL
1222: AND
1223: p_lookup_code <> FND_API.G_MISS_CHAR)
1224: THEN
1225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1226: THEN
1227: OE_MSG_PUB.Add_Exc_Msg

Line 1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1230: , 'Keys are mutually exclusive: request_type_code = '|| p_request_type_code || ', lookup_code = '|| p_lookup_code
1231: );
1232: END IF;
1233:
1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1235:
1236: END IF;
1237:
1238:

Line 1287: p_request_type_code <> FND_API.G_MISS_CHAR)

1283:
1284: IF
1285: (p_request_type_code IS NOT NULL
1286: AND
1287: p_request_type_code <> FND_API.G_MISS_CHAR)
1288: AND
1289: (l_RQT_tbl.COUNT = 0)
1290: THEN
1291: RAISE NO_DATA_FOUND;

Line 1301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1297: RETURN l_RQT_tbl;
1298:
1299: EXCEPTION
1300:
1301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1302:
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304:
1305: WHEN OTHERS THEN

Line 1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1299: EXCEPTION
1300:
1301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1302:
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304:
1305: WHEN OTHERS THEN
1306:
1307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1311: , 'Query_Rows'
1312: );
1313: END IF;
1314:
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316:
1317: END Query_Rows;
1318:
1319: -- Procedure lock_Row

Line 1477: x_return_status := FND_API.G_RET_STS_SUCCESS;

1473: x_RQT_rec := l_RQT_rec;
1474:
1475: -- Set return status
1476:
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478: x_RQT_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1479:
1480: ELSE
1481:

Line 1478: x_RQT_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1474:
1475: -- Set return status
1476:
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478: x_RQT_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1479:
1480: ELSE
1481:
1482: -- Row has changed by another user.

Line 1484: x_return_status := FND_API.G_RET_STS_ERROR;

1480: ELSE
1481:
1482: -- Row has changed by another user.
1483:
1484: x_return_status := FND_API.G_RET_STS_ERROR;
1485: x_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1486:
1487: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1488: THEN

Line 1485: x_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;

1481:
1482: -- Row has changed by another user.
1483:
1484: x_return_status := FND_API.G_RET_STS_ERROR;
1485: x_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1486:
1487: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1488: THEN
1489:

Line 1501: x_return_status := FND_API.G_RET_STS_ERROR;

1497: EXCEPTION
1498:
1499: WHEN NO_DATA_FOUND THEN
1500:
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: x_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1503:
1504: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1505: THEN

Line 1502: x_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;

1498:
1499: WHEN NO_DATA_FOUND THEN
1500:
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: x_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1503:
1504: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1505: THEN
1506:

Line 1513: x_return_status := FND_API.G_RET_STS_ERROR;

1509:
1510: END IF;
1511: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1512:
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514: x_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1515:
1516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1517: THEN

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

1510: END IF;
1511: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1512:
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514: x_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1515:
1516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1517: THEN
1518:

Line 1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1521:
1522: END IF;
1523: WHEN OTHERS THEN
1524:
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: x_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1529: THEN

Line 1526: x_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1522: END IF;
1523: WHEN OTHERS THEN
1524:
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: x_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1529: THEN
1530: OE_MSG_PUB.Add_Exc_Msg

Line 1550: p_RQT_rec.enabled_flag <> FND_API.G_MISS_CHAR AND

1546: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
1547: BEGIN
1548:
1549: IF p_RQT_rec.enabled_flag IS NOT NULL AND
1550: p_RQT_rec.enabled_flag <> FND_API.G_MISS_CHAR AND
1551: NOT QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,
1552: p_old_RQT_rec.enabled_flag)
1553: THEN
1554: l_RQT_val_rec.enabled := QP_Id_To_Value.Enabled

Line 1560: p_RQT_rec.pte_code <> FND_API.G_MISS_CHAR AND

1556: );
1557: END IF;
1558:
1559: IF p_RQT_rec.pte_code IS NOT NULL AND
1560: p_RQT_rec.pte_code <> FND_API.G_MISS_CHAR AND
1561: NOT QP_GLOBALS.Equal(p_RQT_rec.pte_code,
1562: p_old_RQT_rec.pte_code)
1563: THEN
1564: l_RQT_val_rec.pte := QP_Id_To_Value.Pte

Line 1570: p_RQT_rec.request_type_code <> FND_API.G_MISS_CHAR AND

1566: );
1567: END IF;
1568:
1569: IF p_RQT_rec.request_type_code IS NOT NULL AND
1570: p_RQT_rec.request_type_code <> FND_API.G_MISS_CHAR AND
1571: NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_code,
1572: p_old_RQT_rec.request_type_code)
1573: THEN
1574: l_RQT_val_rec.request_type := QP_Id_To_Value.Request_Type

Line 1580: p_RQT_rec.row_id <> FND_API.G_MISS_CHAR AND

1576: );
1577: END IF;
1578:
1579: IF p_RQT_rec.row_id IS NOT NULL AND
1580: p_RQT_rec.row_id <> FND_API.G_MISS_CHAR AND
1581: NOT QP_GLOBALS.Equal(p_RQT_rec.row_id,
1582: p_old_RQT_rec.row_id)
1583: THEN
1584: l_RQT_val_rec.row := QP_Id_To_Value.Row

Line 1605: l_RQT_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1601: BEGIN
1602:
1603: -- initialize return_status.
1604:
1605: l_RQT_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1606:
1607: -- initialize l_RQT_rec.
1608:
1609: l_RQT_rec := p_RQT_rec;

Line 1611: IF p_RQT_val_rec.enabled <> FND_API.G_MISS_CHAR

1607: -- initialize l_RQT_rec.
1608:
1609: l_RQT_rec := p_RQT_rec;
1610:
1611: IF p_RQT_val_rec.enabled <> FND_API.G_MISS_CHAR
1612: THEN
1613:
1614: IF p_RQT_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1615:

Line 1614: IF p_RQT_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN

1610:
1611: IF p_RQT_val_rec.enabled <> FND_API.G_MISS_CHAR
1612: THEN
1613:
1614: IF p_RQT_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1615:
1616: l_RQT_rec.enabled_flag := p_RQT_rec.enabled_flag;
1617:
1618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1633: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

1629: l_RQT_rec.enabled_flag := QP_Value_To_Id.enabled
1630: ( p_enabled => p_RQT_val_rec.enabled
1631: );
1632:
1633: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
1634: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1635: END IF;
1636:
1637: END IF;

Line 1634: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;

1630: ( p_enabled => p_RQT_val_rec.enabled
1631: );
1632:
1633: IF l_RQT_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
1634: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1635: END IF;
1636:
1637: END IF;
1638:

Line 1641: IF p_RQT_val_rec.pte <> FND_API.G_MISS_CHAR

1637: END IF;
1638:
1639: END IF;
1640:
1641: IF p_RQT_val_rec.pte <> FND_API.G_MISS_CHAR
1642: THEN
1643:
1644: IF p_RQT_rec.pte_code <> FND_API.G_MISS_CHAR THEN
1645:

Line 1644: IF p_RQT_rec.pte_code <> FND_API.G_MISS_CHAR THEN

1640:
1641: IF p_RQT_val_rec.pte <> FND_API.G_MISS_CHAR
1642: THEN
1643:
1644: IF p_RQT_rec.pte_code <> FND_API.G_MISS_CHAR THEN
1645:
1646: l_RQT_rec.pte_code := p_RQT_rec.pte_code;
1647:
1648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1663: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN

1659: l_RQT_rec.pte_code := QP_Value_To_Id.pte
1660: ( p_pte => p_RQT_val_rec.pte
1661: );
1662:
1663: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN
1664: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1665: END IF;
1666:
1667: END IF;

Line 1664: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;

1660: ( p_pte => p_RQT_val_rec.pte
1661: );
1662:
1663: IF l_RQT_rec.pte_code = FND_API.G_MISS_CHAR THEN
1664: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1665: END IF;
1666:
1667: END IF;
1668:

Line 1671: IF p_RQT_val_rec.request_type <> FND_API.G_MISS_CHAR

1667: END IF;
1668:
1669: END IF;
1670:
1671: IF p_RQT_val_rec.request_type <> FND_API.G_MISS_CHAR
1672: THEN
1673:
1674: IF p_RQT_rec.request_type_code <> FND_API.G_MISS_CHAR THEN
1675:

Line 1674: IF p_RQT_rec.request_type_code <> FND_API.G_MISS_CHAR THEN

1670:
1671: IF p_RQT_val_rec.request_type <> FND_API.G_MISS_CHAR
1672: THEN
1673:
1674: IF p_RQT_rec.request_type_code <> FND_API.G_MISS_CHAR THEN
1675:
1676: l_RQT_rec.request_type_code := p_RQT_rec.request_type_code;
1677:
1678: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1693: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN

1689: l_RQT_rec.request_type_code := QP_Value_To_Id.request_type
1690: ( p_request_type => p_RQT_val_rec.request_type
1691: );
1692:
1693: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN
1694: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1695: END IF;
1696:
1697: END IF;

Line 1694: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;

1690: ( p_request_type => p_RQT_val_rec.request_type
1691: );
1692:
1693: IF l_RQT_rec.request_type_code = FND_API.G_MISS_CHAR THEN
1694: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1695: END IF;
1696:
1697: END IF;
1698:

Line 1701: IF p_RQT_val_rec.row <> FND_API.G_MISS_CHAR

1697: END IF;
1698:
1699: END IF;
1700:
1701: IF p_RQT_val_rec.row <> FND_API.G_MISS_CHAR
1702: THEN
1703:
1704: IF p_RQT_rec.row_id <> FND_API.G_MISS_CHAR THEN
1705:

Line 1704: IF p_RQT_rec.row_id <> FND_API.G_MISS_CHAR THEN

1700:
1701: IF p_RQT_val_rec.row <> FND_API.G_MISS_CHAR
1702: THEN
1703:
1704: IF p_RQT_rec.row_id <> FND_API.G_MISS_CHAR THEN
1705:
1706: l_RQT_rec.row_id := p_RQT_rec.row_id;
1707:
1708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1724: --**IF l_RQT_rec.row_id = FND_API.G_MISS_CHAR THEN

1720: --**l_RQT_rec.row_id := QP_Value_To_Id.row
1721: --**( p_row => p_RQT_val_rec.row
1722: --**);
1723:
1724: --**IF l_RQT_rec.row_id = FND_API.G_MISS_CHAR THEN
1725: --**l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1726: --**END IF;
1727:
1728: END IF;

Line 1725: --**l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;

1721: --**( p_row => p_RQT_val_rec.row
1722: --**);
1723:
1724: --**IF l_RQT_rec.row_id = FND_API.G_MISS_CHAR THEN
1725: --**l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1726: --**END IF;
1727:
1728: END IF;
1729: