APPS.QP_QUALIFIERS_UTIL_MOD 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_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type
13: , p_old_QUALIFIERS_rec IN QP_Modifiers_PUB.Qualifiers_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_QUALIFIERS_REC
15: , x_QUALIFIERS_rec OUT QP_Modifiers_PUB.Qualifiers_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_QUALIFIERS_rec.attribute1,p_old_QUALIFIERS_rec.attribute1)
33: THEN
34: l_index := l_index + 1;

Line 589: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

585: IS
586: l_QUALIFIERS_rec QP_Modifiers_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
587: BEGIN
588:
589: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
590: l_QUALIFIERS_rec.attribute1 := p_old_QUALIFIERS_rec.attribute1;
591: END IF;
592:
593: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 593: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

589: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
590: l_QUALIFIERS_rec.attribute1 := p_old_QUALIFIERS_rec.attribute1;
591: END IF;
592:
593: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
594: l_QUALIFIERS_rec.attribute10 := p_old_QUALIFIERS_rec.attribute10;
595: END IF;
596:
597: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 597: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

593: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
594: l_QUALIFIERS_rec.attribute10 := p_old_QUALIFIERS_rec.attribute10;
595: END IF;
596:
597: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
598: l_QUALIFIERS_rec.attribute11 := p_old_QUALIFIERS_rec.attribute11;
599: END IF;
600:
601: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 601: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

597: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
598: l_QUALIFIERS_rec.attribute11 := p_old_QUALIFIERS_rec.attribute11;
599: END IF;
600:
601: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
602: l_QUALIFIERS_rec.attribute12 := p_old_QUALIFIERS_rec.attribute12;
603: END IF;
604:
605: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 605: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

601: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
602: l_QUALIFIERS_rec.attribute12 := p_old_QUALIFIERS_rec.attribute12;
603: END IF;
604:
605: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
606: l_QUALIFIERS_rec.attribute13 := p_old_QUALIFIERS_rec.attribute13;
607: END IF;
608:
609: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 609: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

605: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
606: l_QUALIFIERS_rec.attribute13 := p_old_QUALIFIERS_rec.attribute13;
607: END IF;
608:
609: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
610: l_QUALIFIERS_rec.attribute14 := p_old_QUALIFIERS_rec.attribute14;
611: END IF;
612:
613: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 613: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

609: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
610: l_QUALIFIERS_rec.attribute14 := p_old_QUALIFIERS_rec.attribute14;
611: END IF;
612:
613: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
614: l_QUALIFIERS_rec.attribute15 := p_old_QUALIFIERS_rec.attribute15;
615: END IF;
616:
617: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 617: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

613: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
614: l_QUALIFIERS_rec.attribute15 := p_old_QUALIFIERS_rec.attribute15;
615: END IF;
616:
617: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
618: l_QUALIFIERS_rec.attribute2 := p_old_QUALIFIERS_rec.attribute2;
619: END IF;
620:
621: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 621: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

617: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
618: l_QUALIFIERS_rec.attribute2 := p_old_QUALIFIERS_rec.attribute2;
619: END IF;
620:
621: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
622: l_QUALIFIERS_rec.attribute3 := p_old_QUALIFIERS_rec.attribute3;
623: END IF;
624:
625: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 625: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

621: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
622: l_QUALIFIERS_rec.attribute3 := p_old_QUALIFIERS_rec.attribute3;
623: END IF;
624:
625: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
626: l_QUALIFIERS_rec.attribute4 := p_old_QUALIFIERS_rec.attribute4;
627: END IF;
628:
629: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 629: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

625: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
626: l_QUALIFIERS_rec.attribute4 := p_old_QUALIFIERS_rec.attribute4;
627: END IF;
628:
629: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
630: l_QUALIFIERS_rec.attribute5 := p_old_QUALIFIERS_rec.attribute5;
631: END IF;
632:
633: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 633: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

629: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
630: l_QUALIFIERS_rec.attribute5 := p_old_QUALIFIERS_rec.attribute5;
631: END IF;
632:
633: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
634: l_QUALIFIERS_rec.attribute6 := p_old_QUALIFIERS_rec.attribute6;
635: END IF;
636:
637: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 637: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

633: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
634: l_QUALIFIERS_rec.attribute6 := p_old_QUALIFIERS_rec.attribute6;
635: END IF;
636:
637: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
638: l_QUALIFIERS_rec.attribute7 := p_old_QUALIFIERS_rec.attribute7;
639: END IF;
640:
641: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 641: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

637: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
638: l_QUALIFIERS_rec.attribute7 := p_old_QUALIFIERS_rec.attribute7;
639: END IF;
640:
641: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
642: l_QUALIFIERS_rec.attribute8 := p_old_QUALIFIERS_rec.attribute8;
643: END IF;
644:
645: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 645: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

641: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
642: l_QUALIFIERS_rec.attribute8 := p_old_QUALIFIERS_rec.attribute8;
643: END IF;
644:
645: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
646: l_QUALIFIERS_rec.attribute9 := p_old_QUALIFIERS_rec.attribute9;
647: END IF;
648:
649: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

Line 649: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

645: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
646: l_QUALIFIERS_rec.attribute9 := p_old_QUALIFIERS_rec.attribute9;
647: END IF;
648:
649: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
650: l_QUALIFIERS_rec.comparison_operator_code := p_old_QUALIFIERS_rec.comparison_operator_code;
651: END IF;
652:
653: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN

Line 653: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN

649: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
650: l_QUALIFIERS_rec.comparison_operator_code := p_old_QUALIFIERS_rec.comparison_operator_code;
651: END IF;
652:
653: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
654: l_QUALIFIERS_rec.context := p_old_QUALIFIERS_rec.context;
655: END IF;
656:
657: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 657: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN

653: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
654: l_QUALIFIERS_rec.context := p_old_QUALIFIERS_rec.context;
655: END IF;
656:
657: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
658: l_QUALIFIERS_rec.created_by := p_old_QUALIFIERS_rec.created_by;
659: END IF;
660:
661: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN

Line 661: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN

657: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
658: l_QUALIFIERS_rec.created_by := p_old_QUALIFIERS_rec.created_by;
659: END IF;
660:
661: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
662: l_QUALIFIERS_rec.created_from_rule_id := p_old_QUALIFIERS_rec.created_from_rule_id;
663: END IF;
664:
665: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 665: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN

661: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
662: l_QUALIFIERS_rec.created_from_rule_id := p_old_QUALIFIERS_rec.created_from_rule_id;
663: END IF;
664:
665: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
666: l_QUALIFIERS_rec.creation_date := p_old_QUALIFIERS_rec.creation_date;
667: END IF;
668:
669: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 669: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN

665: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
666: l_QUALIFIERS_rec.creation_date := p_old_QUALIFIERS_rec.creation_date;
667: END IF;
668:
669: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
670: l_QUALIFIERS_rec.end_date_active := p_old_QUALIFIERS_rec.end_date_active;
671: END IF;
672:
673: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

Line 673: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

669: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
670: l_QUALIFIERS_rec.end_date_active := p_old_QUALIFIERS_rec.end_date_active;
671: END IF;
672:
673: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
674: l_QUALIFIERS_rec.excluder_flag := p_old_QUALIFIERS_rec.excluder_flag;
675: END IF;
676:
677: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 677: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

673: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
674: l_QUALIFIERS_rec.excluder_flag := p_old_QUALIFIERS_rec.excluder_flag;
675: END IF;
676:
677: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
678: l_QUALIFIERS_rec.last_updated_by := p_old_QUALIFIERS_rec.last_updated_by;
679: END IF;
680:
681: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 681: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN

677: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
678: l_QUALIFIERS_rec.last_updated_by := p_old_QUALIFIERS_rec.last_updated_by;
679: END IF;
680:
681: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
682: l_QUALIFIERS_rec.last_update_date := p_old_QUALIFIERS_rec.last_update_date;
683: END IF;
684:
685: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 685: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN

681: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
682: l_QUALIFIERS_rec.last_update_date := p_old_QUALIFIERS_rec.last_update_date;
683: END IF;
684:
685: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
686: l_QUALIFIERS_rec.last_update_login := p_old_QUALIFIERS_rec.last_update_login;
687: END IF;
688:
689: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 689: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN

685: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
686: l_QUALIFIERS_rec.last_update_login := p_old_QUALIFIERS_rec.last_update_login;
687: END IF;
688:
689: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
690: l_QUALIFIERS_rec.list_header_id := p_old_QUALIFIERS_rec.list_header_id;
691: END IF;
692:
693: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 693: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN

689: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
690: l_QUALIFIERS_rec.list_header_id := p_old_QUALIFIERS_rec.list_header_id;
691: END IF;
692:
693: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
694: l_QUALIFIERS_rec.list_line_id := p_old_QUALIFIERS_rec.list_line_id;
695: END IF;
696:
697: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 697: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN

693: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
694: l_QUALIFIERS_rec.list_line_id := p_old_QUALIFIERS_rec.list_line_id;
695: END IF;
696:
697: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
698: l_QUALIFIERS_rec.program_application_id := p_old_QUALIFIERS_rec.program_application_id;
699: END IF;
700:
701: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 701: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN

697: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
698: l_QUALIFIERS_rec.program_application_id := p_old_QUALIFIERS_rec.program_application_id;
699: END IF;
700:
701: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
702: l_QUALIFIERS_rec.program_id := p_old_QUALIFIERS_rec.program_id;
703: END IF;
704:
705: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 705: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN

701: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
702: l_QUALIFIERS_rec.program_id := p_old_QUALIFIERS_rec.program_id;
703: END IF;
704:
705: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
706: l_QUALIFIERS_rec.program_update_date := p_old_QUALIFIERS_rec.program_update_date;
707: END IF;
708:
709: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN

Line 709: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN

705: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
706: l_QUALIFIERS_rec.program_update_date := p_old_QUALIFIERS_rec.program_update_date;
707: END IF;
708:
709: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
710: l_QUALIFIERS_rec.qualifier_attribute := p_old_QUALIFIERS_rec.qualifier_attribute;
711: END IF;
712:
713: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN

Line 713: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN

709: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
710: l_QUALIFIERS_rec.qualifier_attribute := p_old_QUALIFIERS_rec.qualifier_attribute;
711: END IF;
712:
713: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
714: l_QUALIFIERS_rec.qualifier_attr_value := p_old_QUALIFIERS_rec.qualifier_attr_value;
715: END IF;
716:
717: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN

Line 717: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN

713: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
714: l_QUALIFIERS_rec.qualifier_attr_value := p_old_QUALIFIERS_rec.qualifier_attr_value;
715: END IF;
716:
717: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN
718: l_QUALIFIERS_rec.qualifier_context := p_old_QUALIFIERS_rec.qualifier_context;
719: END IF;
720:
721: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN

Line 721: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN

717: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN
718: l_QUALIFIERS_rec.qualifier_context := p_old_QUALIFIERS_rec.qualifier_context;
719: END IF;
720:
721: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN
722: l_QUALIFIERS_rec.qualifier_grouping_no := p_old_QUALIFIERS_rec.qualifier_grouping_no;
723: END IF;
724:
725: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN

Line 725: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN

721: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN
722: l_QUALIFIERS_rec.qualifier_grouping_no := p_old_QUALIFIERS_rec.qualifier_grouping_no;
723: END IF;
724:
725: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
726: l_QUALIFIERS_rec.qualifier_id := p_old_QUALIFIERS_rec.qualifier_id;
727: END IF;
728:
729: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

Line 729: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

725: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
726: l_QUALIFIERS_rec.qualifier_id := p_old_QUALIFIERS_rec.qualifier_id;
727: END IF;
728:
729: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
730: l_QUALIFIERS_rec.qualifier_rule_id := p_old_QUALIFIERS_rec.qualifier_rule_id;
731: END IF;
732:
733: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 733: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN

729: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
730: l_QUALIFIERS_rec.qualifier_rule_id := p_old_QUALIFIERS_rec.qualifier_rule_id;
731: END IF;
732:
733: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
734: l_QUALIFIERS_rec.request_id := p_old_QUALIFIERS_rec.request_id;
735: END IF;
736:
737: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 737: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN

733: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
734: l_QUALIFIERS_rec.request_id := p_old_QUALIFIERS_rec.request_id;
735: END IF;
736:
737: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
738: l_QUALIFIERS_rec.start_date_active := p_old_QUALIFIERS_rec.start_date_active;
739: END IF;
740:
741: RETURN l_QUALIFIERS_rec;

Line 754: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

750: IS
751: l_QUALIFIERS_rec QP_Modifiers_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
752: BEGIN
753:
754: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
755: l_QUALIFIERS_rec.attribute1 := NULL;
756: END IF;
757:
758: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 758: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

754: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
755: l_QUALIFIERS_rec.attribute1 := NULL;
756: END IF;
757:
758: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
759: l_QUALIFIERS_rec.attribute10 := NULL;
760: END IF;
761:
762: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 762: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

758: IF l_QUALIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
759: l_QUALIFIERS_rec.attribute10 := NULL;
760: END IF;
761:
762: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
763: l_QUALIFIERS_rec.attribute11 := NULL;
764: END IF;
765:
766: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 766: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

762: IF l_QUALIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
763: l_QUALIFIERS_rec.attribute11 := NULL;
764: END IF;
765:
766: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
767: l_QUALIFIERS_rec.attribute12 := NULL;
768: END IF;
769:
770: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 770: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

766: IF l_QUALIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
767: l_QUALIFIERS_rec.attribute12 := NULL;
768: END IF;
769:
770: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
771: l_QUALIFIERS_rec.attribute13 := NULL;
772: END IF;
773:
774: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 774: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

770: IF l_QUALIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
771: l_QUALIFIERS_rec.attribute13 := NULL;
772: END IF;
773:
774: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
775: l_QUALIFIERS_rec.attribute14 := NULL;
776: END IF;
777:
778: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 778: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

774: IF l_QUALIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
775: l_QUALIFIERS_rec.attribute14 := NULL;
776: END IF;
777:
778: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
779: l_QUALIFIERS_rec.attribute15 := NULL;
780: END IF;
781:
782: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 782: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

778: IF l_QUALIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
779: l_QUALIFIERS_rec.attribute15 := NULL;
780: END IF;
781:
782: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
783: l_QUALIFIERS_rec.attribute2 := NULL;
784: END IF;
785:
786: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 786: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

782: IF l_QUALIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
783: l_QUALIFIERS_rec.attribute2 := NULL;
784: END IF;
785:
786: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
787: l_QUALIFIERS_rec.attribute3 := NULL;
788: END IF;
789:
790: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 790: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

786: IF l_QUALIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
787: l_QUALIFIERS_rec.attribute3 := NULL;
788: END IF;
789:
790: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
791: l_QUALIFIERS_rec.attribute4 := NULL;
792: END IF;
793:
794: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 794: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

790: IF l_QUALIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
791: l_QUALIFIERS_rec.attribute4 := NULL;
792: END IF;
793:
794: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
795: l_QUALIFIERS_rec.attribute5 := NULL;
796: END IF;
797:
798: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 798: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

794: IF l_QUALIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
795: l_QUALIFIERS_rec.attribute5 := NULL;
796: END IF;
797:
798: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
799: l_QUALIFIERS_rec.attribute6 := NULL;
800: END IF;
801:
802: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 802: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

798: IF l_QUALIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
799: l_QUALIFIERS_rec.attribute6 := NULL;
800: END IF;
801:
802: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
803: l_QUALIFIERS_rec.attribute7 := NULL;
804: END IF;
805:
806: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 806: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

802: IF l_QUALIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
803: l_QUALIFIERS_rec.attribute7 := NULL;
804: END IF;
805:
806: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
807: l_QUALIFIERS_rec.attribute8 := NULL;
808: END IF;
809:
810: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 810: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

806: IF l_QUALIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
807: l_QUALIFIERS_rec.attribute8 := NULL;
808: END IF;
809:
810: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
811: l_QUALIFIERS_rec.attribute9 := NULL;
812: END IF;
813:
814: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

Line 814: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

810: IF l_QUALIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
811: l_QUALIFIERS_rec.attribute9 := NULL;
812: END IF;
813:
814: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
815: l_QUALIFIERS_rec.comparison_operator_code := NULL;
816: END IF;
817:
818: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN

Line 818: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN

814: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
815: l_QUALIFIERS_rec.comparison_operator_code := NULL;
816: END IF;
817:
818: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
819: l_QUALIFIERS_rec.context := NULL;
820: END IF;
821:
822: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 822: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN

818: IF l_QUALIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
819: l_QUALIFIERS_rec.context := NULL;
820: END IF;
821:
822: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
823: l_QUALIFIERS_rec.created_by := NULL;
824: END IF;
825:
826: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN

Line 826: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN

822: IF l_QUALIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
823: l_QUALIFIERS_rec.created_by := NULL;
824: END IF;
825:
826: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
827: l_QUALIFIERS_rec.created_from_rule_id := NULL;
828: END IF;
829:
830: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 830: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN

826: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
827: l_QUALIFIERS_rec.created_from_rule_id := NULL;
828: END IF;
829:
830: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
831: l_QUALIFIERS_rec.creation_date := NULL;
832: END IF;
833:
834: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 834: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN

830: IF l_QUALIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
831: l_QUALIFIERS_rec.creation_date := NULL;
832: END IF;
833:
834: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
835: l_QUALIFIERS_rec.end_date_active := NULL;
836: END IF;
837:
838: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

Line 838: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

834: IF l_QUALIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
835: l_QUALIFIERS_rec.end_date_active := NULL;
836: END IF;
837:
838: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
839: l_QUALIFIERS_rec.excluder_flag := NULL;
840: END IF;
841:
842: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 842: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

838: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
839: l_QUALIFIERS_rec.excluder_flag := NULL;
840: END IF;
841:
842: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
843: l_QUALIFIERS_rec.last_updated_by := NULL;
844: END IF;
845:
846: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 846: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN

842: IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
843: l_QUALIFIERS_rec.last_updated_by := NULL;
844: END IF;
845:
846: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
847: l_QUALIFIERS_rec.last_update_date := NULL;
848: END IF;
849:
850: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 850: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN

846: IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
847: l_QUALIFIERS_rec.last_update_date := NULL;
848: END IF;
849:
850: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
851: l_QUALIFIERS_rec.last_update_login := NULL;
852: END IF;
853:
854: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 854: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN

850: IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
851: l_QUALIFIERS_rec.last_update_login := NULL;
852: END IF;
853:
854: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
855: l_QUALIFIERS_rec.list_header_id := NULL;
856: END IF;
857:
858: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 858: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN

854: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
855: l_QUALIFIERS_rec.list_header_id := NULL;
856: END IF;
857:
858: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
859: l_QUALIFIERS_rec.list_line_id := NULL;
860: END IF;
861:
862: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 862: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN

858: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
859: l_QUALIFIERS_rec.list_line_id := NULL;
860: END IF;
861:
862: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
863: l_QUALIFIERS_rec.program_application_id := NULL;
864: END IF;
865:
866: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 866: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN

862: IF l_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
863: l_QUALIFIERS_rec.program_application_id := NULL;
864: END IF;
865:
866: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
867: l_QUALIFIERS_rec.program_id := NULL;
868: END IF;
869:
870: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 870: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN

866: IF l_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
867: l_QUALIFIERS_rec.program_id := NULL;
868: END IF;
869:
870: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
871: l_QUALIFIERS_rec.program_update_date := NULL;
872: END IF;
873:
874: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN

Line 874: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN

870: IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
871: l_QUALIFIERS_rec.program_update_date := NULL;
872: END IF;
873:
874: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
875: l_QUALIFIERS_rec.qualifier_attribute := NULL;
876: END IF;
877:
878: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN

Line 878: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN

874: IF l_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR THEN
875: l_QUALIFIERS_rec.qualifier_attribute := NULL;
876: END IF;
877:
878: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
879: l_QUALIFIERS_rec.qualifier_attr_value := NULL;
880: END IF;
881:
882: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN

Line 882: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN

878: IF l_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR THEN
879: l_QUALIFIERS_rec.qualifier_attr_value := NULL;
880: END IF;
881:
882: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN
883: l_QUALIFIERS_rec.qualifier_context := NULL;
884: END IF;
885:
886: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN

Line 886: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN

882: IF l_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR THEN
883: l_QUALIFIERS_rec.qualifier_context := NULL;
884: END IF;
885:
886: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN
887: l_QUALIFIERS_rec.qualifier_grouping_no := NULL;
888: END IF;
889:
890: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN

Line 890: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN

886: IF l_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM THEN
887: l_QUALIFIERS_rec.qualifier_grouping_no := NULL;
888: END IF;
889:
890: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
891: l_QUALIFIERS_rec.qualifier_id := NULL;
892: END IF;
893:
894: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

Line 894: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

890: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
891: l_QUALIFIERS_rec.qualifier_id := NULL;
892: END IF;
893:
894: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
895: l_QUALIFIERS_rec.qualifier_rule_id := NULL;
896: END IF;
897:
898: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 898: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN

894: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
895: l_QUALIFIERS_rec.qualifier_rule_id := NULL;
896: END IF;
897:
898: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
899: l_QUALIFIERS_rec.request_id := NULL;
900: END IF;
901:
902: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 902: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN

898: IF l_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
899: l_QUALIFIERS_rec.request_id := NULL;
900: END IF;
901:
902: IF l_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
903: l_QUALIFIERS_rec.start_date_active := NULL;
904: END IF;
905:
906: RETURN l_QUALIFIERS_rec;

Line 1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

997: , 'Update_Row'
998: );
999: END IF;
1000:
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002:
1003: END Update_Row;
1004:
1005: -- Procedure Insert_Row

Line 1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1125: , 'Insert_Row'
1126: );
1127: END IF;
1128:
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130:
1131: END Insert_Row;
1132:
1133: -- Procedure Delete_Row

Line 1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1153: , 'Delete_Row'
1154: );
1155: END IF;
1156:
1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1158:
1159: END Delete_Row;
1160:
1161: -- Function Query_Row

Line 1181: FND_API.G_MISS_NUM

1177: --
1178: */
1179: FUNCTION Query_Rows
1180: ( p_qualifier_id IN NUMBER :=
1181: FND_API.G_MISS_NUM
1182: , p_list_header_id IN NUMBER :=
1183: FND_API.G_MISS_NUM
1184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1185: IS

Line 1183: FND_API.G_MISS_NUM

1179: FUNCTION Query_Rows
1180: ( p_qualifier_id IN NUMBER :=
1181: FND_API.G_MISS_NUM
1182: , p_list_header_id IN NUMBER :=
1183: FND_API.G_MISS_NUM
1184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1185: IS
1186: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1187: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1250: p_qualifier_id <> FND_API.G_MISS_NUM)

1246:
1247: IF
1248: (p_qualifier_id IS NOT NULL
1249: AND
1250: p_qualifier_id <> FND_API.G_MISS_NUM)
1251: AND
1252: (p_list_header_id IS NOT NULL
1253: AND
1254: p_list_header_id <> FND_API.G_MISS_NUM)

Line 1254: p_list_header_id <> FND_API.G_MISS_NUM)

1250: p_qualifier_id <> FND_API.G_MISS_NUM)
1251: AND
1252: (p_list_header_id IS NOT NULL
1253: AND
1254: p_list_header_id <> FND_API.G_MISS_NUM)
1255: THEN
1256: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1257: THEN
1258: FND_MSG_PUB.Add_Exc_Msg

Line 1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1261: , 'Keys are mutually exclusive: qualifier_id = '|| p_qualifier_id || ', list_header_id = '|| p_list_header_id
1262: );
1263: END IF;
1264:
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266:
1267: END IF;
1268:
1269:

Line 1336: p_qualifier_id <> FND_API.G_MISS_NUM)

1332:
1333: IF
1334: (p_qualifier_id IS NOT NULL
1335: AND
1336: p_qualifier_id <> FND_API.G_MISS_NUM)
1337: AND
1338: (l_QUALIFIERS_tbl.COUNT = 0)
1339: THEN
1340: RAISE NO_DATA_FOUND;

Line 1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1346: RETURN l_QUALIFIERS_tbl;
1347:
1348: EXCEPTION
1349:
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351:
1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1353:
1354: WHEN OTHERS THEN

Line 1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1348: EXCEPTION
1349:
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351:
1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1353:
1354: WHEN OTHERS THEN
1355:
1356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1360: , 'Query_Rows'
1361: );
1362: END IF;
1363:
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365:
1366: END Query_Rows;
1367:
1368: -- Procedure lock_Row

Line 1546: x_return_status := FND_API.G_RET_STS_SUCCESS;

1542: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
1543:
1544: -- Set return status
1545:
1546: x_return_status := FND_API.G_RET_STS_SUCCESS;
1547: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1548:
1549: ELSE
1550:

Line 1547: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1543:
1544: -- Set return status
1545:
1546: x_return_status := FND_API.G_RET_STS_SUCCESS;
1547: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1548:
1549: ELSE
1550:
1551: -- Row has changed by another user.

Line 1553: x_return_status := FND_API.G_RET_STS_ERROR;

1549: ELSE
1550:
1551: -- Row has changed by another user.
1552:
1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1555:
1556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1557: THEN

Line 1554: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1550:
1551: -- Row has changed by another user.
1552:
1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1555:
1556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1557: THEN
1558:

Line 1570: x_return_status := FND_API.G_RET_STS_ERROR;

1566: EXCEPTION
1567:
1568: WHEN NO_DATA_FOUND THEN
1569:
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1572:
1573: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1574: THEN

Line 1571: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1567:
1568: WHEN NO_DATA_FOUND THEN
1569:
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1572:
1573: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1574: THEN
1575:

Line 1582: x_return_status := FND_API.G_RET_STS_ERROR;

1578:
1579: END IF;
1580: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1581:
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1584:
1585: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1586: THEN

Line 1583: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1579: END IF;
1580: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1581:
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1584:
1585: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1586: THEN
1587:

Line 1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1590:
1591: END IF;
1592: WHEN OTHERS THEN
1593:
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596:
1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1598: THEN

Line 1595: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1591: END IF;
1592: WHEN OTHERS THEN
1593:
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596:
1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1598: THEN
1599: FND_MSG_PUB.Add_Exc_Msg

Line 1619: p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND

1615: l_QUALIFIERS_val_rec QP_Modifiers_PUB.Qualifiers_Val_Rec_Type;
1616: BEGIN
1617:
1618: IF p_QUALIFIERS_rec.comparison_operator_code IS NOT NULL AND
1619: p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND
1620: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
1621: p_old_QUALIFIERS_rec.comparison_operator_code)
1622: THEN
1623: -- l_QUALIFIERS_val_rec.comparison_operator := QP_Id_To_Value.Comparison_Operator

Line 1629: p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM AND

1625: -- );
1626: END IF;
1627:
1628: IF p_QUALIFIERS_rec.created_from_rule_id IS NOT NULL AND
1629: p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM AND
1630: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
1631: p_old_QUALIFIERS_rec.created_from_rule_id)
1632: THEN
1633: l_QUALIFIERS_val_rec.created_from_rule := QP_Id_To_Value.Created_From_Rule

Line 1639: p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR AND

1635: );
1636: END IF;
1637:
1638: IF p_QUALIFIERS_rec.excluder_flag IS NOT NULL AND
1639: p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
1640: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
1641: p_old_QUALIFIERS_rec.excluder_flag)
1642: THEN
1643: l_QUALIFIERS_val_rec.excluder := QP_Id_To_Value.Excluder

Line 1649: p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND

1645: );
1646: END IF;
1647:
1648: IF p_QUALIFIERS_rec.list_header_id IS NOT NULL AND
1649: p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND
1650: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
1651: p_old_QUALIFIERS_rec.list_header_id)
1652: THEN
1653: l_QUALIFIERS_val_rec.list_header := QP_Id_To_Value.List_Header

Line 1659: p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND

1655: );
1656: END IF;
1657:
1658: IF p_QUALIFIERS_rec.list_line_id IS NOT NULL AND
1659: p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND
1660: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
1661: p_old_QUALIFIERS_rec.list_line_id)
1662: THEN
1663: l_QUALIFIERS_val_rec.list_line := QP_Id_To_Value.List_Line

Line 1669: p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM AND

1665: );
1666: END IF;
1667:
1668: IF p_QUALIFIERS_rec.qualifier_id IS NOT NULL AND
1669: p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM AND
1670: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
1671: p_old_QUALIFIERS_rec.qualifier_id)
1672: THEN
1673: -- l_QUALIFIERS_val_rec.qualifier := QP_Id_To_Value.Qualifier

Line 1679: p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND

1675: -- );
1676: END IF;
1677:
1678: IF p_QUALIFIERS_rec.qualifier_rule_id IS NOT NULL AND
1679: p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND
1680: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
1681: p_old_QUALIFIERS_rec.qualifier_rule_id)
1682: THEN
1683: l_QUALIFIERS_val_rec.qualifier_rule := QP_Id_To_Value.Qualifier_Rule

Line 1704: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1700: BEGIN
1701:
1702: -- initialize return_status.
1703:
1704: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1705:
1706: -- initialize l_QUALIFIERS_rec.
1707:
1708: l_QUALIFIERS_rec := p_QUALIFIERS_rec;

Line 1710: IF p_QUALIFIERS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR

1706: -- initialize l_QUALIFIERS_rec.
1707:
1708: l_QUALIFIERS_rec := p_QUALIFIERS_rec;
1709:
1710: IF p_QUALIFIERS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR
1711: THEN
1712:
1713: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
1714:

Line 1713: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN

1709:
1710: IF p_QUALIFIERS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR
1711: THEN
1712:
1713: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
1714:
1715: l_QUALIFIERS_rec.comparison_operator_code := p_QUALIFIERS_rec.comparison_operator_code;
1716:
1717: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1732: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

1728: -- l_QUALIFIERS_rec.comparison_operator_code := QP_Value_To_Id.comparison_operator
1729: -- ( p_comparison_operator => p_QUALIFIERS_val_rec.comparison_operator
1730: -- );
1731:
1732: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1733: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1734: END IF;
1735:
1736: END IF;

Line 1733: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1729: -- ( p_comparison_operator => p_QUALIFIERS_val_rec.comparison_operator
1730: -- );
1731:
1732: IF l_QUALIFIERS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1733: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1734: END IF;
1735:
1736: END IF;
1737:

Line 1740: IF p_QUALIFIERS_val_rec.created_from_rule <> FND_API.G_MISS_CHAR

1736: END IF;
1737:
1738: END IF;
1739:
1740: IF p_QUALIFIERS_val_rec.created_from_rule <> FND_API.G_MISS_CHAR
1741: THEN
1742:
1743: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN
1744:

Line 1743: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN

1739:
1740: IF p_QUALIFIERS_val_rec.created_from_rule <> FND_API.G_MISS_CHAR
1741: THEN
1742:
1743: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN
1744:
1745: l_QUALIFIERS_rec.created_from_rule_id := p_QUALIFIERS_rec.created_from_rule_id;
1746:
1747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1762: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN

1758: l_QUALIFIERS_rec.created_from_rule_id := QP_Value_To_Id.created_from_rule
1759: ( p_created_from_rule => p_QUALIFIERS_val_rec.created_from_rule
1760: );
1761:
1762: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
1763: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1764: END IF;
1765:
1766: END IF;

Line 1763: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1759: ( p_created_from_rule => p_QUALIFIERS_val_rec.created_from_rule
1760: );
1761:
1762: IF l_QUALIFIERS_rec.created_from_rule_id = FND_API.G_MISS_NUM THEN
1763: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1764: END IF;
1765:
1766: END IF;
1767:

Line 1770: IF p_QUALIFIERS_val_rec.excluder <> FND_API.G_MISS_CHAR

1766: END IF;
1767:
1768: END IF;
1769:
1770: IF p_QUALIFIERS_val_rec.excluder <> FND_API.G_MISS_CHAR
1771: THEN
1772:
1773: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
1774:

Line 1773: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN

1769:
1770: IF p_QUALIFIERS_val_rec.excluder <> FND_API.G_MISS_CHAR
1771: THEN
1772:
1773: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
1774:
1775: l_QUALIFIERS_rec.excluder_flag := p_QUALIFIERS_rec.excluder_flag;
1776:
1777: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1792: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

1788: l_QUALIFIERS_rec.excluder_flag := QP_Value_To_Id.excluder
1789: ( p_excluder => p_QUALIFIERS_val_rec.excluder
1790: );
1791:
1792: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
1793: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1794: END IF;
1795:
1796: END IF;

Line 1793: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1789: ( p_excluder => p_QUALIFIERS_val_rec.excluder
1790: );
1791:
1792: IF l_QUALIFIERS_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
1793: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1794: END IF;
1795:
1796: END IF;
1797:

Line 1800: IF p_QUALIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR

1796: END IF;
1797:
1798: END IF;
1799:
1800: IF p_QUALIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR
1801: THEN
1802:
1803: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
1804:

Line 1803: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN

1799:
1800: IF p_QUALIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR
1801: THEN
1802:
1803: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
1804:
1805: l_QUALIFIERS_rec.list_header_id := p_QUALIFIERS_rec.list_header_id;
1806:
1807: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1822: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN

1818: l_QUALIFIERS_rec.list_header_id := QP_Value_To_Id.list_header
1819: ( p_list_header => p_QUALIFIERS_val_rec.list_header
1820: );
1821:
1822: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1823: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1824: END IF;
1825:
1826: END IF;

Line 1823: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1819: ( p_list_header => p_QUALIFIERS_val_rec.list_header
1820: );
1821:
1822: IF l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1823: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1824: END IF;
1825:
1826: END IF;
1827:

Line 1830: IF p_QUALIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR

1826: END IF;
1827:
1828: END IF;
1829:
1830: IF p_QUALIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR
1831: THEN
1832:
1833: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
1834:

Line 1833: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN

1829:
1830: IF p_QUALIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR
1831: THEN
1832:
1833: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
1834:
1835: l_QUALIFIERS_rec.list_line_id := p_QUALIFIERS_rec.list_line_id;
1836:
1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1852: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN

1848: l_QUALIFIERS_rec.list_line_id := QP_Value_To_Id.list_line
1849: ( p_list_line => p_QUALIFIERS_val_rec.list_line
1850: );
1851:
1852: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1853: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1854: END IF;
1855:
1856: END IF;

Line 1853: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1849: ( p_list_line => p_QUALIFIERS_val_rec.list_line
1850: );
1851:
1852: IF l_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1853: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1854: END IF;
1855:
1856: END IF;
1857:

Line 1860: IF p_QUALIFIERS_val_rec.qualifier <> FND_API.G_MISS_CHAR

1856: END IF;
1857:
1858: END IF;
1859:
1860: IF p_QUALIFIERS_val_rec.qualifier <> FND_API.G_MISS_CHAR
1861: THEN
1862:
1863: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN
1864:

Line 1863: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN

1859:
1860: IF p_QUALIFIERS_val_rec.qualifier <> FND_API.G_MISS_CHAR
1861: THEN
1862:
1863: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN
1864:
1865: l_QUALIFIERS_rec.qualifier_id := p_QUALIFIERS_rec.qualifier_id;
1866:
1867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1882: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN

1878: -- l_QUALIFIERS_rec.qualifier_id := QP_Value_To_Id.qualifier
1879: -- ( p_qualifier => p_QUALIFIERS_val_rec.qualifier
1880: -- );
1881:
1882: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
1883: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1884: END IF;
1885:
1886: END IF;

Line 1883: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1879: -- ( p_qualifier => p_QUALIFIERS_val_rec.qualifier
1880: -- );
1881:
1882: IF l_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM THEN
1883: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1884: END IF;
1885:
1886: END IF;
1887:

Line 1890: IF p_QUALIFIERS_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR

1886: END IF;
1887:
1888: END IF;
1889:
1890: IF p_QUALIFIERS_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR
1891: THEN
1892:
1893: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
1894:

Line 1893: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN

1889:
1890: IF p_QUALIFIERS_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR
1891: THEN
1892:
1893: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
1894:
1895: l_QUALIFIERS_rec.qualifier_rule_id := p_QUALIFIERS_rec.qualifier_rule_id;
1896:
1897: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1912: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

1908: l_QUALIFIERS_rec.qualifier_rule_id := QP_Value_To_Id.qualifier_rule
1909: ( p_qualifier_rule => p_QUALIFIERS_val_rec.qualifier_rule
1910: );
1911:
1912: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
1913: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1914: END IF;
1915:
1916: END IF;

Line 1913: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1909: ( p_qualifier_rule => p_QUALIFIERS_val_rec.qualifier_rule
1910: );
1911:
1912: IF l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
1913: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1914: END IF;
1915:
1916: END IF;
1917: