eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_LIMIT_ATTRS_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_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
13: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
15: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_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_LIMIT_ATTRS_rec.attribute1,p_old_LIMIT_ATTRS_rec.attribute1)
33: THEN
34: l_index := l_index + 1;

Line 527: IF l_LIMIT_ATTRS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

523: IS
524: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;
525: BEGIN
526:
527: IF l_LIMIT_ATTRS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
528: l_LIMIT_ATTRS_rec.attribute1 := p_old_LIMIT_ATTRS_rec.attribute1;
529: END IF;
530:
531: IF l_LIMIT_ATTRS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 531: IF l_LIMIT_ATTRS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

527: IF l_LIMIT_ATTRS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
528: l_LIMIT_ATTRS_rec.attribute1 := p_old_LIMIT_ATTRS_rec.attribute1;
529: END IF;
530:
531: IF l_LIMIT_ATTRS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
532: l_LIMIT_ATTRS_rec.attribute10 := p_old_LIMIT_ATTRS_rec.attribute10;
533: END IF;
534:
535: IF l_LIMIT_ATTRS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 535: IF l_LIMIT_ATTRS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

531: IF l_LIMIT_ATTRS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
532: l_LIMIT_ATTRS_rec.attribute10 := p_old_LIMIT_ATTRS_rec.attribute10;
533: END IF;
534:
535: IF l_LIMIT_ATTRS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
536: l_LIMIT_ATTRS_rec.attribute11 := p_old_LIMIT_ATTRS_rec.attribute11;
537: END IF;
538:
539: IF l_LIMIT_ATTRS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 539: IF l_LIMIT_ATTRS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

535: IF l_LIMIT_ATTRS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
536: l_LIMIT_ATTRS_rec.attribute11 := p_old_LIMIT_ATTRS_rec.attribute11;
537: END IF;
538:
539: IF l_LIMIT_ATTRS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
540: l_LIMIT_ATTRS_rec.attribute12 := p_old_LIMIT_ATTRS_rec.attribute12;
541: END IF;
542:
543: IF l_LIMIT_ATTRS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 543: IF l_LIMIT_ATTRS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

539: IF l_LIMIT_ATTRS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
540: l_LIMIT_ATTRS_rec.attribute12 := p_old_LIMIT_ATTRS_rec.attribute12;
541: END IF;
542:
543: IF l_LIMIT_ATTRS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
544: l_LIMIT_ATTRS_rec.attribute13 := p_old_LIMIT_ATTRS_rec.attribute13;
545: END IF;
546:
547: IF l_LIMIT_ATTRS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 547: IF l_LIMIT_ATTRS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

543: IF l_LIMIT_ATTRS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
544: l_LIMIT_ATTRS_rec.attribute13 := p_old_LIMIT_ATTRS_rec.attribute13;
545: END IF;
546:
547: IF l_LIMIT_ATTRS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
548: l_LIMIT_ATTRS_rec.attribute14 := p_old_LIMIT_ATTRS_rec.attribute14;
549: END IF;
550:
551: IF l_LIMIT_ATTRS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 551: IF l_LIMIT_ATTRS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

547: IF l_LIMIT_ATTRS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
548: l_LIMIT_ATTRS_rec.attribute14 := p_old_LIMIT_ATTRS_rec.attribute14;
549: END IF;
550:
551: IF l_LIMIT_ATTRS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
552: l_LIMIT_ATTRS_rec.attribute15 := p_old_LIMIT_ATTRS_rec.attribute15;
553: END IF;
554:
555: IF l_LIMIT_ATTRS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 555: IF l_LIMIT_ATTRS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

551: IF l_LIMIT_ATTRS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
552: l_LIMIT_ATTRS_rec.attribute15 := p_old_LIMIT_ATTRS_rec.attribute15;
553: END IF;
554:
555: IF l_LIMIT_ATTRS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
556: l_LIMIT_ATTRS_rec.attribute2 := p_old_LIMIT_ATTRS_rec.attribute2;
557: END IF;
558:
559: IF l_LIMIT_ATTRS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 559: IF l_LIMIT_ATTRS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

555: IF l_LIMIT_ATTRS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
556: l_LIMIT_ATTRS_rec.attribute2 := p_old_LIMIT_ATTRS_rec.attribute2;
557: END IF;
558:
559: IF l_LIMIT_ATTRS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
560: l_LIMIT_ATTRS_rec.attribute3 := p_old_LIMIT_ATTRS_rec.attribute3;
561: END IF;
562:
563: IF l_LIMIT_ATTRS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 563: IF l_LIMIT_ATTRS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

559: IF l_LIMIT_ATTRS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
560: l_LIMIT_ATTRS_rec.attribute3 := p_old_LIMIT_ATTRS_rec.attribute3;
561: END IF;
562:
563: IF l_LIMIT_ATTRS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
564: l_LIMIT_ATTRS_rec.attribute4 := p_old_LIMIT_ATTRS_rec.attribute4;
565: END IF;
566:
567: IF l_LIMIT_ATTRS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 567: IF l_LIMIT_ATTRS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

563: IF l_LIMIT_ATTRS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
564: l_LIMIT_ATTRS_rec.attribute4 := p_old_LIMIT_ATTRS_rec.attribute4;
565: END IF;
566:
567: IF l_LIMIT_ATTRS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
568: l_LIMIT_ATTRS_rec.attribute5 := p_old_LIMIT_ATTRS_rec.attribute5;
569: END IF;
570:
571: IF l_LIMIT_ATTRS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 571: IF l_LIMIT_ATTRS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

567: IF l_LIMIT_ATTRS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
568: l_LIMIT_ATTRS_rec.attribute5 := p_old_LIMIT_ATTRS_rec.attribute5;
569: END IF;
570:
571: IF l_LIMIT_ATTRS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
572: l_LIMIT_ATTRS_rec.attribute6 := p_old_LIMIT_ATTRS_rec.attribute6;
573: END IF;
574:
575: IF l_LIMIT_ATTRS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 575: IF l_LIMIT_ATTRS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

571: IF l_LIMIT_ATTRS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
572: l_LIMIT_ATTRS_rec.attribute6 := p_old_LIMIT_ATTRS_rec.attribute6;
573: END IF;
574:
575: IF l_LIMIT_ATTRS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
576: l_LIMIT_ATTRS_rec.attribute7 := p_old_LIMIT_ATTRS_rec.attribute7;
577: END IF;
578:
579: IF l_LIMIT_ATTRS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 579: IF l_LIMIT_ATTRS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

575: IF l_LIMIT_ATTRS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
576: l_LIMIT_ATTRS_rec.attribute7 := p_old_LIMIT_ATTRS_rec.attribute7;
577: END IF;
578:
579: IF l_LIMIT_ATTRS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
580: l_LIMIT_ATTRS_rec.attribute8 := p_old_LIMIT_ATTRS_rec.attribute8;
581: END IF;
582:
583: IF l_LIMIT_ATTRS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 583: IF l_LIMIT_ATTRS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

579: IF l_LIMIT_ATTRS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
580: l_LIMIT_ATTRS_rec.attribute8 := p_old_LIMIT_ATTRS_rec.attribute8;
581: END IF;
582:
583: IF l_LIMIT_ATTRS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
584: l_LIMIT_ATTRS_rec.attribute9 := p_old_LIMIT_ATTRS_rec.attribute9;
585: END IF;
586:
587: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

Line 587: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

583: IF l_LIMIT_ATTRS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
584: l_LIMIT_ATTRS_rec.attribute9 := p_old_LIMIT_ATTRS_rec.attribute9;
585: END IF;
586:
587: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
588: l_LIMIT_ATTRS_rec.comparison_operator_code := p_old_LIMIT_ATTRS_rec.comparison_operator_code;
589: END IF;
590:
591: IF l_LIMIT_ATTRS_rec.context = FND_API.G_MISS_CHAR THEN

Line 591: IF l_LIMIT_ATTRS_rec.context = FND_API.G_MISS_CHAR THEN

587: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
588: l_LIMIT_ATTRS_rec.comparison_operator_code := p_old_LIMIT_ATTRS_rec.comparison_operator_code;
589: END IF;
590:
591: IF l_LIMIT_ATTRS_rec.context = FND_API.G_MISS_CHAR THEN
592: l_LIMIT_ATTRS_rec.context := p_old_LIMIT_ATTRS_rec.context;
593: END IF;
594:
595: IF l_LIMIT_ATTRS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 595: IF l_LIMIT_ATTRS_rec.created_by = FND_API.G_MISS_NUM THEN

591: IF l_LIMIT_ATTRS_rec.context = FND_API.G_MISS_CHAR THEN
592: l_LIMIT_ATTRS_rec.context := p_old_LIMIT_ATTRS_rec.context;
593: END IF;
594:
595: IF l_LIMIT_ATTRS_rec.created_by = FND_API.G_MISS_NUM THEN
596: l_LIMIT_ATTRS_rec.created_by := p_old_LIMIT_ATTRS_rec.created_by;
597: END IF;
598:
599: IF l_LIMIT_ATTRS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 599: IF l_LIMIT_ATTRS_rec.creation_date = FND_API.G_MISS_DATE THEN

595: IF l_LIMIT_ATTRS_rec.created_by = FND_API.G_MISS_NUM THEN
596: l_LIMIT_ATTRS_rec.created_by := p_old_LIMIT_ATTRS_rec.created_by;
597: END IF;
598:
599: IF l_LIMIT_ATTRS_rec.creation_date = FND_API.G_MISS_DATE THEN
600: l_LIMIT_ATTRS_rec.creation_date := p_old_LIMIT_ATTRS_rec.creation_date;
601: END IF;
602:
603: IF l_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 603: IF l_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

599: IF l_LIMIT_ATTRS_rec.creation_date = FND_API.G_MISS_DATE THEN
600: l_LIMIT_ATTRS_rec.creation_date := p_old_LIMIT_ATTRS_rec.creation_date;
601: END IF;
602:
603: IF l_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
604: l_LIMIT_ATTRS_rec.last_updated_by := p_old_LIMIT_ATTRS_rec.last_updated_by;
605: END IF;
606:
607: IF l_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 607: IF l_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE THEN

603: IF l_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
604: l_LIMIT_ATTRS_rec.last_updated_by := p_old_LIMIT_ATTRS_rec.last_updated_by;
605: END IF;
606:
607: IF l_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE THEN
608: l_LIMIT_ATTRS_rec.last_update_date := p_old_LIMIT_ATTRS_rec.last_update_date;
609: END IF;
610:
611: IF l_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 611: IF l_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM THEN

607: IF l_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE THEN
608: l_LIMIT_ATTRS_rec.last_update_date := p_old_LIMIT_ATTRS_rec.last_update_date;
609: END IF;
610:
611: IF l_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM THEN
612: l_LIMIT_ATTRS_rec.last_update_login := p_old_LIMIT_ATTRS_rec.last_update_login;
613: END IF;
614:
615: IF l_LIMIT_ATTRS_rec.limit_attribute = FND_API.G_MISS_CHAR THEN

Line 615: IF l_LIMIT_ATTRS_rec.limit_attribute = FND_API.G_MISS_CHAR THEN

611: IF l_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM THEN
612: l_LIMIT_ATTRS_rec.last_update_login := p_old_LIMIT_ATTRS_rec.last_update_login;
613: END IF;
614:
615: IF l_LIMIT_ATTRS_rec.limit_attribute = FND_API.G_MISS_CHAR THEN
616: l_LIMIT_ATTRS_rec.limit_attribute := p_old_LIMIT_ATTRS_rec.limit_attribute;
617: END IF;
618:
619: IF l_LIMIT_ATTRS_rec.limit_attribute_context = FND_API.G_MISS_CHAR THEN

Line 619: IF l_LIMIT_ATTRS_rec.limit_attribute_context = FND_API.G_MISS_CHAR THEN

615: IF l_LIMIT_ATTRS_rec.limit_attribute = FND_API.G_MISS_CHAR THEN
616: l_LIMIT_ATTRS_rec.limit_attribute := p_old_LIMIT_ATTRS_rec.limit_attribute;
617: END IF;
618:
619: IF l_LIMIT_ATTRS_rec.limit_attribute_context = FND_API.G_MISS_CHAR THEN
620: l_LIMIT_ATTRS_rec.limit_attribute_context := p_old_LIMIT_ATTRS_rec.limit_attribute_context;
621: END IF;
622:
623: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN

Line 623: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN

619: IF l_LIMIT_ATTRS_rec.limit_attribute_context = FND_API.G_MISS_CHAR THEN
620: l_LIMIT_ATTRS_rec.limit_attribute_context := p_old_LIMIT_ATTRS_rec.limit_attribute_context;
621: END IF;
622:
623: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN
624: l_LIMIT_ATTRS_rec.limit_attribute_id := p_old_LIMIT_ATTRS_rec.limit_attribute_id;
625: END IF;
626:
627: IF l_LIMIT_ATTRS_rec.limit_attribute_type = FND_API.G_MISS_CHAR THEN

Line 627: IF l_LIMIT_ATTRS_rec.limit_attribute_type = FND_API.G_MISS_CHAR THEN

623: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN
624: l_LIMIT_ATTRS_rec.limit_attribute_id := p_old_LIMIT_ATTRS_rec.limit_attribute_id;
625: END IF;
626:
627: IF l_LIMIT_ATTRS_rec.limit_attribute_type = FND_API.G_MISS_CHAR THEN
628: l_LIMIT_ATTRS_rec.limit_attribute_type := p_old_LIMIT_ATTRS_rec.limit_attribute_type;
629: END IF;
630:
631: IF l_LIMIT_ATTRS_rec.limit_attr_datatype = FND_API.G_MISS_CHAR THEN

Line 631: IF l_LIMIT_ATTRS_rec.limit_attr_datatype = FND_API.G_MISS_CHAR THEN

627: IF l_LIMIT_ATTRS_rec.limit_attribute_type = FND_API.G_MISS_CHAR THEN
628: l_LIMIT_ATTRS_rec.limit_attribute_type := p_old_LIMIT_ATTRS_rec.limit_attribute_type;
629: END IF;
630:
631: IF l_LIMIT_ATTRS_rec.limit_attr_datatype = FND_API.G_MISS_CHAR THEN
632: l_LIMIT_ATTRS_rec.limit_attr_datatype := p_old_LIMIT_ATTRS_rec.limit_attr_datatype;
633: END IF;
634:
635: IF l_LIMIT_ATTRS_rec.limit_attr_value = FND_API.G_MISS_CHAR THEN

Line 635: IF l_LIMIT_ATTRS_rec.limit_attr_value = FND_API.G_MISS_CHAR THEN

631: IF l_LIMIT_ATTRS_rec.limit_attr_datatype = FND_API.G_MISS_CHAR THEN
632: l_LIMIT_ATTRS_rec.limit_attr_datatype := p_old_LIMIT_ATTRS_rec.limit_attr_datatype;
633: END IF;
634:
635: IF l_LIMIT_ATTRS_rec.limit_attr_value = FND_API.G_MISS_CHAR THEN
636: l_LIMIT_ATTRS_rec.limit_attr_value := p_old_LIMIT_ATTRS_rec.limit_attr_value;
637: END IF;
638:
639: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN

Line 639: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN

635: IF l_LIMIT_ATTRS_rec.limit_attr_value = FND_API.G_MISS_CHAR THEN
636: l_LIMIT_ATTRS_rec.limit_attr_value := p_old_LIMIT_ATTRS_rec.limit_attr_value;
637: END IF;
638:
639: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN
640: l_LIMIT_ATTRS_rec.limit_id := p_old_LIMIT_ATTRS_rec.limit_id;
641: END IF;
642:
643: IF l_LIMIT_ATTRS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 643: IF l_LIMIT_ATTRS_rec.program_application_id = FND_API.G_MISS_NUM THEN

639: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN
640: l_LIMIT_ATTRS_rec.limit_id := p_old_LIMIT_ATTRS_rec.limit_id;
641: END IF;
642:
643: IF l_LIMIT_ATTRS_rec.program_application_id = FND_API.G_MISS_NUM THEN
644: l_LIMIT_ATTRS_rec.program_application_id := p_old_LIMIT_ATTRS_rec.program_application_id;
645: END IF;
646:
647: IF l_LIMIT_ATTRS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 647: IF l_LIMIT_ATTRS_rec.program_id = FND_API.G_MISS_NUM THEN

643: IF l_LIMIT_ATTRS_rec.program_application_id = FND_API.G_MISS_NUM THEN
644: l_LIMIT_ATTRS_rec.program_application_id := p_old_LIMIT_ATTRS_rec.program_application_id;
645: END IF;
646:
647: IF l_LIMIT_ATTRS_rec.program_id = FND_API.G_MISS_NUM THEN
648: l_LIMIT_ATTRS_rec.program_id := p_old_LIMIT_ATTRS_rec.program_id;
649: END IF;
650:
651: IF l_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 651: IF l_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE THEN

647: IF l_LIMIT_ATTRS_rec.program_id = FND_API.G_MISS_NUM THEN
648: l_LIMIT_ATTRS_rec.program_id := p_old_LIMIT_ATTRS_rec.program_id;
649: END IF;
650:
651: IF l_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE THEN
652: l_LIMIT_ATTRS_rec.program_update_date := p_old_LIMIT_ATTRS_rec.program_update_date;
653: END IF;
654:
655: IF l_LIMIT_ATTRS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 655: IF l_LIMIT_ATTRS_rec.request_id = FND_API.G_MISS_NUM THEN

651: IF l_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE THEN
652: l_LIMIT_ATTRS_rec.program_update_date := p_old_LIMIT_ATTRS_rec.program_update_date;
653: END IF;
654:
655: IF l_LIMIT_ATTRS_rec.request_id = FND_API.G_MISS_NUM THEN
656: l_LIMIT_ATTRS_rec.request_id := p_old_LIMIT_ATTRS_rec.request_id;
657: END IF;
658:
659: RETURN l_LIMIT_ATTRS_rec;

Line 672: IF l_LIMIT_ATTRS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

668: IS
669: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;
670: BEGIN
671:
672: IF l_LIMIT_ATTRS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
673: l_LIMIT_ATTRS_rec.attribute1 := NULL;
674: END IF;
675:
676: IF l_LIMIT_ATTRS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 676: IF l_LIMIT_ATTRS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

672: IF l_LIMIT_ATTRS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
673: l_LIMIT_ATTRS_rec.attribute1 := NULL;
674: END IF;
675:
676: IF l_LIMIT_ATTRS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
677: l_LIMIT_ATTRS_rec.attribute10 := NULL;
678: END IF;
679:
680: IF l_LIMIT_ATTRS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 680: IF l_LIMIT_ATTRS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

676: IF l_LIMIT_ATTRS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
677: l_LIMIT_ATTRS_rec.attribute10 := NULL;
678: END IF;
679:
680: IF l_LIMIT_ATTRS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
681: l_LIMIT_ATTRS_rec.attribute11 := NULL;
682: END IF;
683:
684: IF l_LIMIT_ATTRS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 684: IF l_LIMIT_ATTRS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

680: IF l_LIMIT_ATTRS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
681: l_LIMIT_ATTRS_rec.attribute11 := NULL;
682: END IF;
683:
684: IF l_LIMIT_ATTRS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
685: l_LIMIT_ATTRS_rec.attribute12 := NULL;
686: END IF;
687:
688: IF l_LIMIT_ATTRS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 688: IF l_LIMIT_ATTRS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

684: IF l_LIMIT_ATTRS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
685: l_LIMIT_ATTRS_rec.attribute12 := NULL;
686: END IF;
687:
688: IF l_LIMIT_ATTRS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
689: l_LIMIT_ATTRS_rec.attribute13 := NULL;
690: END IF;
691:
692: IF l_LIMIT_ATTRS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 692: IF l_LIMIT_ATTRS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

688: IF l_LIMIT_ATTRS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
689: l_LIMIT_ATTRS_rec.attribute13 := NULL;
690: END IF;
691:
692: IF l_LIMIT_ATTRS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
693: l_LIMIT_ATTRS_rec.attribute14 := NULL;
694: END IF;
695:
696: IF l_LIMIT_ATTRS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 696: IF l_LIMIT_ATTRS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

692: IF l_LIMIT_ATTRS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
693: l_LIMIT_ATTRS_rec.attribute14 := NULL;
694: END IF;
695:
696: IF l_LIMIT_ATTRS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
697: l_LIMIT_ATTRS_rec.attribute15 := NULL;
698: END IF;
699:
700: IF l_LIMIT_ATTRS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 700: IF l_LIMIT_ATTRS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

696: IF l_LIMIT_ATTRS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
697: l_LIMIT_ATTRS_rec.attribute15 := NULL;
698: END IF;
699:
700: IF l_LIMIT_ATTRS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
701: l_LIMIT_ATTRS_rec.attribute2 := NULL;
702: END IF;
703:
704: IF l_LIMIT_ATTRS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 704: IF l_LIMIT_ATTRS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

700: IF l_LIMIT_ATTRS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
701: l_LIMIT_ATTRS_rec.attribute2 := NULL;
702: END IF;
703:
704: IF l_LIMIT_ATTRS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
705: l_LIMIT_ATTRS_rec.attribute3 := NULL;
706: END IF;
707:
708: IF l_LIMIT_ATTRS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 708: IF l_LIMIT_ATTRS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

704: IF l_LIMIT_ATTRS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
705: l_LIMIT_ATTRS_rec.attribute3 := NULL;
706: END IF;
707:
708: IF l_LIMIT_ATTRS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
709: l_LIMIT_ATTRS_rec.attribute4 := NULL;
710: END IF;
711:
712: IF l_LIMIT_ATTRS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 712: IF l_LIMIT_ATTRS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

708: IF l_LIMIT_ATTRS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
709: l_LIMIT_ATTRS_rec.attribute4 := NULL;
710: END IF;
711:
712: IF l_LIMIT_ATTRS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
713: l_LIMIT_ATTRS_rec.attribute5 := NULL;
714: END IF;
715:
716: IF l_LIMIT_ATTRS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 716: IF l_LIMIT_ATTRS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

712: IF l_LIMIT_ATTRS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
713: l_LIMIT_ATTRS_rec.attribute5 := NULL;
714: END IF;
715:
716: IF l_LIMIT_ATTRS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
717: l_LIMIT_ATTRS_rec.attribute6 := NULL;
718: END IF;
719:
720: IF l_LIMIT_ATTRS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 720: IF l_LIMIT_ATTRS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

716: IF l_LIMIT_ATTRS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
717: l_LIMIT_ATTRS_rec.attribute6 := NULL;
718: END IF;
719:
720: IF l_LIMIT_ATTRS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
721: l_LIMIT_ATTRS_rec.attribute7 := NULL;
722: END IF;
723:
724: IF l_LIMIT_ATTRS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 724: IF l_LIMIT_ATTRS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

720: IF l_LIMIT_ATTRS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
721: l_LIMIT_ATTRS_rec.attribute7 := NULL;
722: END IF;
723:
724: IF l_LIMIT_ATTRS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
725: l_LIMIT_ATTRS_rec.attribute8 := NULL;
726: END IF;
727:
728: IF l_LIMIT_ATTRS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 728: IF l_LIMIT_ATTRS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

724: IF l_LIMIT_ATTRS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
725: l_LIMIT_ATTRS_rec.attribute8 := NULL;
726: END IF;
727:
728: IF l_LIMIT_ATTRS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
729: l_LIMIT_ATTRS_rec.attribute9 := NULL;
730: END IF;
731:
732: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

Line 732: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

728: IF l_LIMIT_ATTRS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
729: l_LIMIT_ATTRS_rec.attribute9 := NULL;
730: END IF;
731:
732: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
733: l_LIMIT_ATTRS_rec.comparison_operator_code := NULL;
734: END IF;
735:
736: IF l_LIMIT_ATTRS_rec.context = FND_API.G_MISS_CHAR THEN

Line 736: IF l_LIMIT_ATTRS_rec.context = FND_API.G_MISS_CHAR THEN

732: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
733: l_LIMIT_ATTRS_rec.comparison_operator_code := NULL;
734: END IF;
735:
736: IF l_LIMIT_ATTRS_rec.context = FND_API.G_MISS_CHAR THEN
737: l_LIMIT_ATTRS_rec.context := NULL;
738: END IF;
739:
740: IF l_LIMIT_ATTRS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 740: IF l_LIMIT_ATTRS_rec.created_by = FND_API.G_MISS_NUM THEN

736: IF l_LIMIT_ATTRS_rec.context = FND_API.G_MISS_CHAR THEN
737: l_LIMIT_ATTRS_rec.context := NULL;
738: END IF;
739:
740: IF l_LIMIT_ATTRS_rec.created_by = FND_API.G_MISS_NUM THEN
741: l_LIMIT_ATTRS_rec.created_by := NULL;
742: END IF;
743:
744: IF l_LIMIT_ATTRS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 744: IF l_LIMIT_ATTRS_rec.creation_date = FND_API.G_MISS_DATE THEN

740: IF l_LIMIT_ATTRS_rec.created_by = FND_API.G_MISS_NUM THEN
741: l_LIMIT_ATTRS_rec.created_by := NULL;
742: END IF;
743:
744: IF l_LIMIT_ATTRS_rec.creation_date = FND_API.G_MISS_DATE THEN
745: l_LIMIT_ATTRS_rec.creation_date := NULL;
746: END IF;
747:
748: IF l_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 748: IF l_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

744: IF l_LIMIT_ATTRS_rec.creation_date = FND_API.G_MISS_DATE THEN
745: l_LIMIT_ATTRS_rec.creation_date := NULL;
746: END IF;
747:
748: IF l_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
749: l_LIMIT_ATTRS_rec.last_updated_by := NULL;
750: END IF;
751:
752: IF l_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 752: IF l_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE THEN

748: IF l_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
749: l_LIMIT_ATTRS_rec.last_updated_by := NULL;
750: END IF;
751:
752: IF l_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE THEN
753: l_LIMIT_ATTRS_rec.last_update_date := NULL;
754: END IF;
755:
756: IF l_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 756: IF l_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM THEN

752: IF l_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE THEN
753: l_LIMIT_ATTRS_rec.last_update_date := NULL;
754: END IF;
755:
756: IF l_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM THEN
757: l_LIMIT_ATTRS_rec.last_update_login := NULL;
758: END IF;
759:
760: IF l_LIMIT_ATTRS_rec.limit_attribute = FND_API.G_MISS_CHAR THEN

Line 760: IF l_LIMIT_ATTRS_rec.limit_attribute = FND_API.G_MISS_CHAR THEN

756: IF l_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM THEN
757: l_LIMIT_ATTRS_rec.last_update_login := NULL;
758: END IF;
759:
760: IF l_LIMIT_ATTRS_rec.limit_attribute = FND_API.G_MISS_CHAR THEN
761: l_LIMIT_ATTRS_rec.limit_attribute := NULL;
762: END IF;
763:
764: IF l_LIMIT_ATTRS_rec.limit_attribute_context = FND_API.G_MISS_CHAR THEN

Line 764: IF l_LIMIT_ATTRS_rec.limit_attribute_context = FND_API.G_MISS_CHAR THEN

760: IF l_LIMIT_ATTRS_rec.limit_attribute = FND_API.G_MISS_CHAR THEN
761: l_LIMIT_ATTRS_rec.limit_attribute := NULL;
762: END IF;
763:
764: IF l_LIMIT_ATTRS_rec.limit_attribute_context = FND_API.G_MISS_CHAR THEN
765: l_LIMIT_ATTRS_rec.limit_attribute_context := NULL;
766: END IF;
767:
768: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN

Line 768: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN

764: IF l_LIMIT_ATTRS_rec.limit_attribute_context = FND_API.G_MISS_CHAR THEN
765: l_LIMIT_ATTRS_rec.limit_attribute_context := NULL;
766: END IF;
767:
768: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN
769: l_LIMIT_ATTRS_rec.limit_attribute_id := NULL;
770: END IF;
771:
772: IF l_LIMIT_ATTRS_rec.limit_attribute_type = FND_API.G_MISS_CHAR THEN

Line 772: IF l_LIMIT_ATTRS_rec.limit_attribute_type = FND_API.G_MISS_CHAR THEN

768: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN
769: l_LIMIT_ATTRS_rec.limit_attribute_id := NULL;
770: END IF;
771:
772: IF l_LIMIT_ATTRS_rec.limit_attribute_type = FND_API.G_MISS_CHAR THEN
773: l_LIMIT_ATTRS_rec.limit_attribute_type := NULL;
774: END IF;
775:
776: IF l_LIMIT_ATTRS_rec.limit_attr_datatype = FND_API.G_MISS_CHAR THEN

Line 776: IF l_LIMIT_ATTRS_rec.limit_attr_datatype = FND_API.G_MISS_CHAR THEN

772: IF l_LIMIT_ATTRS_rec.limit_attribute_type = FND_API.G_MISS_CHAR THEN
773: l_LIMIT_ATTRS_rec.limit_attribute_type := NULL;
774: END IF;
775:
776: IF l_LIMIT_ATTRS_rec.limit_attr_datatype = FND_API.G_MISS_CHAR THEN
777: l_LIMIT_ATTRS_rec.limit_attr_datatype := NULL;
778: END IF;
779:
780: IF l_LIMIT_ATTRS_rec.limit_attr_value = FND_API.G_MISS_CHAR THEN

Line 780: IF l_LIMIT_ATTRS_rec.limit_attr_value = FND_API.G_MISS_CHAR THEN

776: IF l_LIMIT_ATTRS_rec.limit_attr_datatype = FND_API.G_MISS_CHAR THEN
777: l_LIMIT_ATTRS_rec.limit_attr_datatype := NULL;
778: END IF;
779:
780: IF l_LIMIT_ATTRS_rec.limit_attr_value = FND_API.G_MISS_CHAR THEN
781: l_LIMIT_ATTRS_rec.limit_attr_value := NULL;
782: END IF;
783:
784: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN

Line 784: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN

780: IF l_LIMIT_ATTRS_rec.limit_attr_value = FND_API.G_MISS_CHAR THEN
781: l_LIMIT_ATTRS_rec.limit_attr_value := NULL;
782: END IF;
783:
784: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN
785: l_LIMIT_ATTRS_rec.limit_id := NULL;
786: END IF;
787:
788: IF l_LIMIT_ATTRS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 788: IF l_LIMIT_ATTRS_rec.program_application_id = FND_API.G_MISS_NUM THEN

784: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN
785: l_LIMIT_ATTRS_rec.limit_id := NULL;
786: END IF;
787:
788: IF l_LIMIT_ATTRS_rec.program_application_id = FND_API.G_MISS_NUM THEN
789: l_LIMIT_ATTRS_rec.program_application_id := NULL;
790: END IF;
791:
792: IF l_LIMIT_ATTRS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 792: IF l_LIMIT_ATTRS_rec.program_id = FND_API.G_MISS_NUM THEN

788: IF l_LIMIT_ATTRS_rec.program_application_id = FND_API.G_MISS_NUM THEN
789: l_LIMIT_ATTRS_rec.program_application_id := NULL;
790: END IF;
791:
792: IF l_LIMIT_ATTRS_rec.program_id = FND_API.G_MISS_NUM THEN
793: l_LIMIT_ATTRS_rec.program_id := NULL;
794: END IF;
795:
796: IF l_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 796: IF l_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE THEN

792: IF l_LIMIT_ATTRS_rec.program_id = FND_API.G_MISS_NUM THEN
793: l_LIMIT_ATTRS_rec.program_id := NULL;
794: END IF;
795:
796: IF l_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE THEN
797: l_LIMIT_ATTRS_rec.program_update_date := NULL;
798: END IF;
799:
800: IF l_LIMIT_ATTRS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 800: IF l_LIMIT_ATTRS_rec.request_id = FND_API.G_MISS_NUM THEN

796: IF l_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE THEN
797: l_LIMIT_ATTRS_rec.program_update_date := NULL;
798: END IF;
799:
800: IF l_LIMIT_ATTRS_rec.request_id = FND_API.G_MISS_NUM THEN
801: l_LIMIT_ATTRS_rec.request_id := NULL;
802: END IF;
803:
804: RETURN l_LIMIT_ATTRS_rec;

Line 890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

886: , 'Update_Row'
887: );
888: END IF;
889:
890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
891:
892: END Update_Row;
893:
894: -- Procedure Insert_Row

Line 1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1006: , 'Insert_Row'
1007: );
1008: END IF;
1009:
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011:
1012: END Insert_Row;
1013:
1014: -- Procedure Delete_Row

Line 1039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1035: , 'Delete_Row'
1036: );
1037: END IF;
1038:
1039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1040:
1041: END Delete_Row;
1042:
1043: -- Function Query_Row

Line 1063: FND_API.G_MISS_NUM

1059: --
1060:
1061: FUNCTION Query_Rows
1062: ( p_limit_attribute_id IN NUMBER :=
1063: FND_API.G_MISS_NUM
1064: , p_limit_id IN NUMBER :=
1065: FND_API.G_MISS_NUM
1066: ) RETURN QP_Limits_PUB.Limit_Attrs_Tbl_Type
1067: IS

Line 1065: FND_API.G_MISS_NUM

1061: FUNCTION Query_Rows
1062: ( p_limit_attribute_id IN NUMBER :=
1063: FND_API.G_MISS_NUM
1064: , p_limit_id IN NUMBER :=
1065: FND_API.G_MISS_NUM
1066: ) RETURN QP_Limits_PUB.Limit_Attrs_Tbl_Type
1067: IS
1068: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1069: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 1116: p_limit_attribute_id <> FND_API.G_MISS_NUM)

1112:
1113: IF
1114: (p_limit_attribute_id IS NOT NULL
1115: AND
1116: p_limit_attribute_id <> FND_API.G_MISS_NUM)
1117: AND
1118: (p_limit_id IS NOT NULL
1119: AND
1120: p_limit_id <> FND_API.G_MISS_NUM)

Line 1120: p_limit_id <> FND_API.G_MISS_NUM)

1116: p_limit_attribute_id <> FND_API.G_MISS_NUM)
1117: AND
1118: (p_limit_id IS NOT NULL
1119: AND
1120: p_limit_id <> FND_API.G_MISS_NUM)
1121: THEN
1122: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: OE_MSG_PUB.Add_Exc_Msg

Line 1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1127: , 'Keys are mutually exclusive: limit_attribute_id = '|| p_limit_attribute_id || ', limit_id = '|| p_limit_id
1128: );
1129: END IF;
1130:
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132:
1133: END IF;
1134:
1135:

Line 1184: p_limit_attribute_id <> FND_API.G_MISS_NUM)

1180:
1181: IF
1182: (p_limit_attribute_id IS NOT NULL
1183: AND
1184: p_limit_attribute_id <> FND_API.G_MISS_NUM)
1185: AND
1186: (l_LIMIT_ATTRS_tbl.COUNT = 0)
1187: THEN
1188: RAISE NO_DATA_FOUND;

Line 1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1194: RETURN l_LIMIT_ATTRS_tbl;
1195:
1196: EXCEPTION
1197:
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199:
1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1201:
1202: WHEN OTHERS THEN

Line 1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1196: EXCEPTION
1197:
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199:
1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1201:
1202: WHEN OTHERS THEN
1203:
1204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1208: , 'Query_Rows'
1209: );
1210: END IF;
1211:
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213:
1214: END Query_Rows;
1215:
1216: -- Procedure lock_Row

Line 1374: x_return_status := FND_API.G_RET_STS_SUCCESS;

1370: x_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec;
1371:
1372: -- Set return status
1373:
1374: x_return_status := FND_API.G_RET_STS_SUCCESS;
1375: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1376:
1377: ELSE
1378:

Line 1375: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1371:
1372: -- Set return status
1373:
1374: x_return_status := FND_API.G_RET_STS_SUCCESS;
1375: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1376:
1377: ELSE
1378:
1379: -- Row has changed by another user.

Line 1381: x_return_status := FND_API.G_RET_STS_ERROR;

1377: ELSE
1378:
1379: -- Row has changed by another user.
1380:
1381: x_return_status := FND_API.G_RET_STS_ERROR;
1382: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1383:
1384: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1385: THEN

Line 1382: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;

1378:
1379: -- Row has changed by another user.
1380:
1381: x_return_status := FND_API.G_RET_STS_ERROR;
1382: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1383:
1384: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1385: THEN
1386:

Line 1398: x_return_status := FND_API.G_RET_STS_ERROR;

1394: EXCEPTION
1395:
1396: WHEN NO_DATA_FOUND THEN
1397:
1398: x_return_status := FND_API.G_RET_STS_ERROR;
1399: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1400:
1401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1402: THEN

Line 1399: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;

1395:
1396: WHEN NO_DATA_FOUND THEN
1397:
1398: x_return_status := FND_API.G_RET_STS_ERROR;
1399: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1400:
1401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1402: THEN
1403:

Line 1410: x_return_status := FND_API.G_RET_STS_ERROR;

1406:
1407: END IF;
1408: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1409:
1410: x_return_status := FND_API.G_RET_STS_ERROR;
1411: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1412:
1413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1414: THEN

Line 1411: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;

1407: END IF;
1408: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1409:
1410: x_return_status := FND_API.G_RET_STS_ERROR;
1411: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1412:
1413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1414: THEN
1415:

Line 1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1418:
1419: END IF;
1420: WHEN OTHERS THEN
1421:
1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1423: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424:
1425: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1426: THEN

Line 1423: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1419: END IF;
1420: WHEN OTHERS THEN
1421:
1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1423: x_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424:
1425: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1426: THEN
1427: OE_MSG_PUB.Add_Exc_Msg

Line 1447: p_LIMIT_ATTRS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND

1443: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
1444: BEGIN
1445:
1446: IF p_LIMIT_ATTRS_rec.comparison_operator_code IS NOT NULL AND
1447: p_LIMIT_ATTRS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND
1448: NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,
1449: p_old_LIMIT_ATTRS_rec.comparison_operator_code)
1450: THEN
1451: l_LIMIT_ATTRS_val_rec.comparison_operator := QP_Id_To_Value.Comparison_Operator

Line 1457: p_LIMIT_ATTRS_rec.limit_attribute_id <> FND_API.G_MISS_NUM AND

1453: );
1454: END IF;
1455:
1456: IF p_LIMIT_ATTRS_rec.limit_attribute_id IS NOT NULL AND
1457: p_LIMIT_ATTRS_rec.limit_attribute_id <> FND_API.G_MISS_NUM AND
1458: NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,
1459: p_old_LIMIT_ATTRS_rec.limit_attribute_id)
1460: THEN
1461: l_LIMIT_ATTRS_val_rec.limit_attribute := QP_Id_To_Value.Limit_Attribute

Line 1467: p_LIMIT_ATTRS_rec.limit_id <> FND_API.G_MISS_NUM AND

1463: );
1464: END IF;
1465:
1466: IF p_LIMIT_ATTRS_rec.limit_id IS NOT NULL AND
1467: p_LIMIT_ATTRS_rec.limit_id <> FND_API.G_MISS_NUM AND
1468: NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,
1469: p_old_LIMIT_ATTRS_rec.limit_id)
1470: THEN
1471: l_LIMIT_ATTRS_val_rec.limit := QP_Id_To_Value.Limit

Line 1492: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1488: BEGIN
1489:
1490: -- initialize return_status.
1491:
1492: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1493:
1494: -- initialize l_LIMIT_ATTRS_rec.
1495:
1496: l_LIMIT_ATTRS_rec := p_LIMIT_ATTRS_rec;

Line 1498: IF p_LIMIT_ATTRS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR

1494: -- initialize l_LIMIT_ATTRS_rec.
1495:
1496: l_LIMIT_ATTRS_rec := p_LIMIT_ATTRS_rec;
1497:
1498: IF p_LIMIT_ATTRS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR
1499: THEN
1500:
1501: IF p_LIMIT_ATTRS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
1502:

Line 1501: IF p_LIMIT_ATTRS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN

1497:
1498: IF p_LIMIT_ATTRS_val_rec.comparison_operator <> FND_API.G_MISS_CHAR
1499: THEN
1500:
1501: IF p_LIMIT_ATTRS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
1502:
1503: l_LIMIT_ATTRS_rec.comparison_operator_code := p_LIMIT_ATTRS_rec.comparison_operator_code;
1504:
1505: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1520: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

1516: l_LIMIT_ATTRS_rec.comparison_operator_code := QP_Value_To_Id.comparison_operator
1517: ( p_comparison_operator => p_LIMIT_ATTRS_val_rec.comparison_operator
1518: );
1519:
1520: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1521: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1522: END IF;
1523:
1524: END IF;

Line 1521: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;

1517: ( p_comparison_operator => p_LIMIT_ATTRS_val_rec.comparison_operator
1518: );
1519:
1520: IF l_LIMIT_ATTRS_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1521: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1522: END IF;
1523:
1524: END IF;
1525:

Line 1528: IF p_LIMIT_ATTRS_val_rec.limit_attribute <> FND_API.G_MISS_CHAR

1524: END IF;
1525:
1526: END IF;
1527:
1528: IF p_LIMIT_ATTRS_val_rec.limit_attribute <> FND_API.G_MISS_CHAR
1529: THEN
1530:
1531: IF p_LIMIT_ATTRS_rec.limit_attribute_id <> FND_API.G_MISS_NUM THEN
1532:

Line 1531: IF p_LIMIT_ATTRS_rec.limit_attribute_id <> FND_API.G_MISS_NUM THEN

1527:
1528: IF p_LIMIT_ATTRS_val_rec.limit_attribute <> FND_API.G_MISS_CHAR
1529: THEN
1530:
1531: IF p_LIMIT_ATTRS_rec.limit_attribute_id <> FND_API.G_MISS_NUM THEN
1532:
1533: l_LIMIT_ATTRS_rec.limit_attribute_id := p_LIMIT_ATTRS_rec.limit_attribute_id;
1534:
1535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1550: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN

1546: l_LIMIT_ATTRS_rec.limit_attribute_id := QP_Value_To_Id.limit_attribute
1547: ( p_limit_attribute => p_LIMIT_ATTRS_val_rec.limit_attribute
1548: );
1549:
1550: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN
1551: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1552: END IF;
1553:
1554: END IF;

Line 1551: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;

1547: ( p_limit_attribute => p_LIMIT_ATTRS_val_rec.limit_attribute
1548: );
1549:
1550: IF l_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM THEN
1551: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1552: END IF;
1553:
1554: END IF;
1555:

Line 1558: IF p_LIMIT_ATTRS_val_rec.limit <> FND_API.G_MISS_CHAR

1554: END IF;
1555:
1556: END IF;
1557:
1558: IF p_LIMIT_ATTRS_val_rec.limit <> FND_API.G_MISS_CHAR
1559: THEN
1560:
1561: IF p_LIMIT_ATTRS_rec.limit_id <> FND_API.G_MISS_NUM THEN
1562:

Line 1561: IF p_LIMIT_ATTRS_rec.limit_id <> FND_API.G_MISS_NUM THEN

1557:
1558: IF p_LIMIT_ATTRS_val_rec.limit <> FND_API.G_MISS_CHAR
1559: THEN
1560:
1561: IF p_LIMIT_ATTRS_rec.limit_id <> FND_API.G_MISS_NUM THEN
1562:
1563: l_LIMIT_ATTRS_rec.limit_id := p_LIMIT_ATTRS_rec.limit_id;
1564:
1565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1580: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN

1576: l_LIMIT_ATTRS_rec.limit_id := QP_Value_To_Id.limit
1577: ( p_limit => p_LIMIT_ATTRS_val_rec.limit
1578: );
1579:
1580: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN
1581: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1582: END IF;
1583:
1584: END IF;

Line 1581: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;

1577: ( p_limit => p_LIMIT_ATTRS_val_rec.limit
1578: );
1579:
1580: IF l_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM THEN
1581: l_LIMIT_ATTRS_rec.return_status := FND_API.G_RET_STS_ERROR;
1582: END IF;
1583:
1584: END IF;
1585:

Line 1620: WHEN FND_API.G_EXC_ERROR THEN

1616:
1617: x_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec;
1618:
1619: EXCEPTION
1620: WHEN FND_API.G_EXC_ERROR THEN
1621: RAISE;
1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1623: RAISE;
1624: WHEN OTHERS THEN

Line 1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1618:
1619: EXCEPTION
1620: WHEN FND_API.G_EXC_ERROR THEN
1621: RAISE;
1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1623: RAISE;
1624: WHEN OTHERS THEN
1625: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1626: THEN

Line 1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1628: ( G_PKG_NAME
1629: , 'Pre_Write_Process'
1630: );
1631: END IF;
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633:
1634:
1635: END Pre_Write_Process;
1636: