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_BALANCES_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_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
13: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
15: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_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_BALANCES_rec.attribute1,p_old_LIMIT_BALANCES_rec.attribute1)
33: THEN
34: l_index := l_index + 1;

Line 666: IF l_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR THEN

662: IS
663: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;
664: BEGIN
665:
666: IF l_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
667: l_LIMIT_BALANCES_rec.attribute1 := p_old_LIMIT_BALANCES_rec.attribute1;
668: END IF;
669:
670: IF l_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 670: IF l_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

666: IF l_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
667: l_LIMIT_BALANCES_rec.attribute1 := p_old_LIMIT_BALANCES_rec.attribute1;
668: END IF;
669:
670: IF l_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
671: l_LIMIT_BALANCES_rec.attribute10 := p_old_LIMIT_BALANCES_rec.attribute10;
672: END IF;
673:
674: IF l_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 674: IF l_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

670: IF l_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
671: l_LIMIT_BALANCES_rec.attribute10 := p_old_LIMIT_BALANCES_rec.attribute10;
672: END IF;
673:
674: IF l_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
675: l_LIMIT_BALANCES_rec.attribute11 := p_old_LIMIT_BALANCES_rec.attribute11;
676: END IF;
677:
678: IF l_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 678: IF l_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

674: IF l_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
675: l_LIMIT_BALANCES_rec.attribute11 := p_old_LIMIT_BALANCES_rec.attribute11;
676: END IF;
677:
678: IF l_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
679: l_LIMIT_BALANCES_rec.attribute12 := p_old_LIMIT_BALANCES_rec.attribute12;
680: END IF;
681:
682: IF l_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 682: IF l_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

678: IF l_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
679: l_LIMIT_BALANCES_rec.attribute12 := p_old_LIMIT_BALANCES_rec.attribute12;
680: END IF;
681:
682: IF l_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
683: l_LIMIT_BALANCES_rec.attribute13 := p_old_LIMIT_BALANCES_rec.attribute13;
684: END IF;
685:
686: IF l_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 686: IF l_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

682: IF l_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
683: l_LIMIT_BALANCES_rec.attribute13 := p_old_LIMIT_BALANCES_rec.attribute13;
684: END IF;
685:
686: IF l_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
687: l_LIMIT_BALANCES_rec.attribute14 := p_old_LIMIT_BALANCES_rec.attribute14;
688: END IF;
689:
690: IF l_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 690: IF l_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

686: IF l_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
687: l_LIMIT_BALANCES_rec.attribute14 := p_old_LIMIT_BALANCES_rec.attribute14;
688: END IF;
689:
690: IF l_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
691: l_LIMIT_BALANCES_rec.attribute15 := p_old_LIMIT_BALANCES_rec.attribute15;
692: END IF;
693:
694: IF l_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 694: IF l_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

690: IF l_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
691: l_LIMIT_BALANCES_rec.attribute15 := p_old_LIMIT_BALANCES_rec.attribute15;
692: END IF;
693:
694: IF l_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
695: l_LIMIT_BALANCES_rec.attribute2 := p_old_LIMIT_BALANCES_rec.attribute2;
696: END IF;
697:
698: IF l_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 698: IF l_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

694: IF l_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
695: l_LIMIT_BALANCES_rec.attribute2 := p_old_LIMIT_BALANCES_rec.attribute2;
696: END IF;
697:
698: IF l_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
699: l_LIMIT_BALANCES_rec.attribute3 := p_old_LIMIT_BALANCES_rec.attribute3;
700: END IF;
701:
702: IF l_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 702: IF l_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

698: IF l_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
699: l_LIMIT_BALANCES_rec.attribute3 := p_old_LIMIT_BALANCES_rec.attribute3;
700: END IF;
701:
702: IF l_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
703: l_LIMIT_BALANCES_rec.attribute4 := p_old_LIMIT_BALANCES_rec.attribute4;
704: END IF;
705:
706: IF l_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 706: IF l_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

702: IF l_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
703: l_LIMIT_BALANCES_rec.attribute4 := p_old_LIMIT_BALANCES_rec.attribute4;
704: END IF;
705:
706: IF l_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
707: l_LIMIT_BALANCES_rec.attribute5 := p_old_LIMIT_BALANCES_rec.attribute5;
708: END IF;
709:
710: IF l_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 710: IF l_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

706: IF l_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
707: l_LIMIT_BALANCES_rec.attribute5 := p_old_LIMIT_BALANCES_rec.attribute5;
708: END IF;
709:
710: IF l_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
711: l_LIMIT_BALANCES_rec.attribute6 := p_old_LIMIT_BALANCES_rec.attribute6;
712: END IF;
713:
714: IF l_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 714: IF l_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

710: IF l_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
711: l_LIMIT_BALANCES_rec.attribute6 := p_old_LIMIT_BALANCES_rec.attribute6;
712: END IF;
713:
714: IF l_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
715: l_LIMIT_BALANCES_rec.attribute7 := p_old_LIMIT_BALANCES_rec.attribute7;
716: END IF;
717:
718: IF l_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 718: IF l_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

714: IF l_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
715: l_LIMIT_BALANCES_rec.attribute7 := p_old_LIMIT_BALANCES_rec.attribute7;
716: END IF;
717:
718: IF l_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
719: l_LIMIT_BALANCES_rec.attribute8 := p_old_LIMIT_BALANCES_rec.attribute8;
720: END IF;
721:
722: IF l_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 722: IF l_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

718: IF l_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
719: l_LIMIT_BALANCES_rec.attribute8 := p_old_LIMIT_BALANCES_rec.attribute8;
720: END IF;
721:
722: IF l_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
723: l_LIMIT_BALANCES_rec.attribute9 := p_old_LIMIT_BALANCES_rec.attribute9;
724: END IF;
725:
726: IF l_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM THEN

Line 726: IF l_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM THEN

722: IF l_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
723: l_LIMIT_BALANCES_rec.attribute9 := p_old_LIMIT_BALANCES_rec.attribute9;
724: END IF;
725:
726: IF l_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM THEN
727: l_LIMIT_BALANCES_rec.available_amount := p_old_LIMIT_BALANCES_rec.available_amount;
728: END IF;
729:
730: IF l_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM THEN

Line 730: IF l_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM THEN

726: IF l_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM THEN
727: l_LIMIT_BALANCES_rec.available_amount := p_old_LIMIT_BALANCES_rec.available_amount;
728: END IF;
729:
730: IF l_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM THEN
731: l_LIMIT_BALANCES_rec.consumed_amount := p_old_LIMIT_BALANCES_rec.consumed_amount;
732: END IF;
733:
734: IF l_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR THEN

Line 734: IF l_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR THEN

730: IF l_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM THEN
731: l_LIMIT_BALANCES_rec.consumed_amount := p_old_LIMIT_BALANCES_rec.consumed_amount;
732: END IF;
733:
734: IF l_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR THEN
735: l_LIMIT_BALANCES_rec.context := p_old_LIMIT_BALANCES_rec.context;
736: END IF;
737:
738: IF l_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM THEN

Line 738: IF l_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM THEN

734: IF l_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR THEN
735: l_LIMIT_BALANCES_rec.context := p_old_LIMIT_BALANCES_rec.context;
736: END IF;
737:
738: IF l_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM THEN
739: l_LIMIT_BALANCES_rec.created_by := p_old_LIMIT_BALANCES_rec.created_by;
740: END IF;
741:
742: IF l_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 742: IF l_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE THEN

738: IF l_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM THEN
739: l_LIMIT_BALANCES_rec.created_by := p_old_LIMIT_BALANCES_rec.created_by;
740: END IF;
741:
742: IF l_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE THEN
743: l_LIMIT_BALANCES_rec.creation_date := p_old_LIMIT_BALANCES_rec.creation_date;
744: END IF;
745:
746: IF l_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

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

742: IF l_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE THEN
743: l_LIMIT_BALANCES_rec.creation_date := p_old_LIMIT_BALANCES_rec.creation_date;
744: END IF;
745:
746: IF l_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
747: l_LIMIT_BALANCES_rec.last_updated_by := p_old_LIMIT_BALANCES_rec.last_updated_by;
748: END IF;
749:
750: IF l_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE THEN

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

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

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

750: IF l_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE THEN
751: l_LIMIT_BALANCES_rec.last_update_date := p_old_LIMIT_BALANCES_rec.last_update_date;
752: END IF;
753:
754: IF l_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM THEN
755: l_LIMIT_BALANCES_rec.last_update_login := p_old_LIMIT_BALANCES_rec.last_update_login;
756: END IF;
757:
758: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN

Line 758: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN

754: IF l_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM THEN
755: l_LIMIT_BALANCES_rec.last_update_login := p_old_LIMIT_BALANCES_rec.last_update_login;
756: END IF;
757:
758: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN
759: l_LIMIT_BALANCES_rec.limit_balance_id := p_old_LIMIT_BALANCES_rec.limit_balance_id;
760: END IF;
761:
762: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN

Line 762: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN

758: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN
759: l_LIMIT_BALANCES_rec.limit_balance_id := p_old_LIMIT_BALANCES_rec.limit_balance_id;
760: END IF;
761:
762: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN
763: l_LIMIT_BALANCES_rec.limit_id := p_old_LIMIT_BALANCES_rec.limit_id;
764: END IF;
765:
766: IF l_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 766: IF l_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM THEN

762: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN
763: l_LIMIT_BALANCES_rec.limit_id := p_old_LIMIT_BALANCES_rec.limit_id;
764: END IF;
765:
766: IF l_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM THEN
767: l_LIMIT_BALANCES_rec.program_application_id := p_old_LIMIT_BALANCES_rec.program_application_id;
768: END IF;
769:
770: IF l_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM THEN

Line 770: IF l_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM THEN

766: IF l_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM THEN
767: l_LIMIT_BALANCES_rec.program_application_id := p_old_LIMIT_BALANCES_rec.program_application_id;
768: END IF;
769:
770: IF l_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM THEN
771: l_LIMIT_BALANCES_rec.program_id := p_old_LIMIT_BALANCES_rec.program_id;
772: END IF;
773:
774: IF l_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 774: IF l_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN

770: IF l_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM THEN
771: l_LIMIT_BALANCES_rec.program_id := p_old_LIMIT_BALANCES_rec.program_id;
772: END IF;
773:
774: IF l_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN
775: l_LIMIT_BALANCES_rec.program_update_date := p_old_LIMIT_BALANCES_rec.program_update_date;
776: END IF;
777:
778: IF l_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM THEN

Line 778: IF l_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM THEN

774: IF l_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN
775: l_LIMIT_BALANCES_rec.program_update_date := p_old_LIMIT_BALANCES_rec.program_update_date;
776: END IF;
777:
778: IF l_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM THEN
779: l_LIMIT_BALANCES_rec.request_id := p_old_LIMIT_BALANCES_rec.request_id;
780: END IF;
781:
782: IF l_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM THEN

Line 782: IF l_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM THEN

778: IF l_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM THEN
779: l_LIMIT_BALANCES_rec.request_id := p_old_LIMIT_BALANCES_rec.request_id;
780: END IF;
781:
782: IF l_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM THEN
783: l_LIMIT_BALANCES_rec.reserved_amount := p_old_LIMIT_BALANCES_rec.reserved_amount;
784: END IF;
785:
786: IF l_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN

Line 786: IF l_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN

782: IF l_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM THEN
783: l_LIMIT_BALANCES_rec.reserved_amount := p_old_LIMIT_BALANCES_rec.reserved_amount;
784: END IF;
785:
786: IF l_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN
787: l_LIMIT_BALANCES_rec.multival_attr1_type := p_old_LIMIT_BALANCES_rec.multival_attr1_type;
788: END IF;
789:
790: IF l_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN

Line 790: IF l_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN

786: IF l_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN
787: l_LIMIT_BALANCES_rec.multival_attr1_type := p_old_LIMIT_BALANCES_rec.multival_attr1_type;
788: END IF;
789:
790: IF l_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN
791: l_LIMIT_BALANCES_rec.multival_attr1_context := p_old_LIMIT_BALANCES_rec.multival_attr1_context;
792: END IF;
793:
794: IF l_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN

Line 794: IF l_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN

790: IF l_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN
791: l_LIMIT_BALANCES_rec.multival_attr1_context := p_old_LIMIT_BALANCES_rec.multival_attr1_context;
792: END IF;
793:
794: IF l_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN
795: l_LIMIT_BALANCES_rec.multival_attribute1 := p_old_LIMIT_BALANCES_rec.multival_attribute1;
796: END IF;
797:
798: IF l_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR THEN

Line 798: IF l_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR THEN

794: IF l_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN
795: l_LIMIT_BALANCES_rec.multival_attribute1 := p_old_LIMIT_BALANCES_rec.multival_attribute1;
796: END IF;
797:
798: IF l_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR THEN
799: l_LIMIT_BALANCES_rec.multival_attr1_value := p_old_LIMIT_BALANCES_rec.multival_attr1_value;
800: END IF;
801:
802: IF l_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN

Line 802: IF l_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN

798: IF l_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR THEN
799: l_LIMIT_BALANCES_rec.multival_attr1_value := p_old_LIMIT_BALANCES_rec.multival_attr1_value;
800: END IF;
801:
802: IF l_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN
803: l_LIMIT_BALANCES_rec.multival_attr1_datatype := p_old_LIMIT_BALANCES_rec.multival_attr1_datatype;
804: END IF;
805:
806: IF l_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN

Line 806: IF l_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN

802: IF l_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN
803: l_LIMIT_BALANCES_rec.multival_attr1_datatype := p_old_LIMIT_BALANCES_rec.multival_attr1_datatype;
804: END IF;
805:
806: IF l_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN
807: l_LIMIT_BALANCES_rec.multival_attr2_type := p_old_LIMIT_BALANCES_rec.multival_attr2_type;
808: END IF;
809:
810: IF l_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN

Line 810: IF l_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN

806: IF l_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN
807: l_LIMIT_BALANCES_rec.multival_attr2_type := p_old_LIMIT_BALANCES_rec.multival_attr2_type;
808: END IF;
809:
810: IF l_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN
811: l_LIMIT_BALANCES_rec.multival_attr2_context := p_old_LIMIT_BALANCES_rec.multival_attr2_context;
812: END IF;
813:
814: IF l_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN

Line 814: IF l_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN

810: IF l_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN
811: l_LIMIT_BALANCES_rec.multival_attr2_context := p_old_LIMIT_BALANCES_rec.multival_attr2_context;
812: END IF;
813:
814: IF l_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN
815: l_LIMIT_BALANCES_rec.multival_attribute2 := p_old_LIMIT_BALANCES_rec.multival_attribute2;
816: END IF;
817:
818: IF l_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR THEN

Line 818: IF l_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR THEN

814: IF l_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN
815: l_LIMIT_BALANCES_rec.multival_attribute2 := p_old_LIMIT_BALANCES_rec.multival_attribute2;
816: END IF;
817:
818: IF l_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR THEN
819: l_LIMIT_BALANCES_rec.multival_attr2_value := p_old_LIMIT_BALANCES_rec.multival_attr2_value;
820: END IF;
821:
822: IF l_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN

Line 822: IF l_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN

818: IF l_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR THEN
819: l_LIMIT_BALANCES_rec.multival_attr2_value := p_old_LIMIT_BALANCES_rec.multival_attr2_value;
820: END IF;
821:
822: IF l_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN
823: l_LIMIT_BALANCES_rec.multival_attr2_datatype := p_old_LIMIT_BALANCES_rec.multival_attr2_datatype;
824: END IF;
825:
826: IF l_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR THEN

Line 826: IF l_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR THEN

822: IF l_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN
823: l_LIMIT_BALANCES_rec.multival_attr2_datatype := p_old_LIMIT_BALANCES_rec.multival_attr2_datatype;
824: END IF;
825:
826: IF l_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR THEN
827: l_LIMIT_BALANCES_rec.organization_attr_context := p_old_LIMIT_BALANCES_rec.organization_attr_context;
828: END IF;
829:
830: IF l_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR THEN

Line 830: IF l_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR THEN

826: IF l_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR THEN
827: l_LIMIT_BALANCES_rec.organization_attr_context := p_old_LIMIT_BALANCES_rec.organization_attr_context;
828: END IF;
829:
830: IF l_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR THEN
831: l_LIMIT_BALANCES_rec.organization_attribute := p_old_LIMIT_BALANCES_rec.organization_attribute;
832: END IF;
833:
834: IF l_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR THEN

Line 834: IF l_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR THEN

830: IF l_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR THEN
831: l_LIMIT_BALANCES_rec.organization_attribute := p_old_LIMIT_BALANCES_rec.organization_attribute;
832: END IF;
833:
834: IF l_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR THEN
835: l_LIMIT_BALANCES_rec.organization_attr_value := p_old_LIMIT_BALANCES_rec.organization_attr_value;
836: END IF;
837:
838: RETURN l_LIMIT_BALANCES_rec;

Line 851: IF l_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR THEN

847: IS
848: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;
849: BEGIN
850:
851: IF l_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
852: l_LIMIT_BALANCES_rec.attribute1 := NULL;
853: END IF;
854:
855: IF l_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 855: IF l_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

851: IF l_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
852: l_LIMIT_BALANCES_rec.attribute1 := NULL;
853: END IF;
854:
855: IF l_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
856: l_LIMIT_BALANCES_rec.attribute10 := NULL;
857: END IF;
858:
859: IF l_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 859: IF l_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

855: IF l_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
856: l_LIMIT_BALANCES_rec.attribute10 := NULL;
857: END IF;
858:
859: IF l_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
860: l_LIMIT_BALANCES_rec.attribute11 := NULL;
861: END IF;
862:
863: IF l_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 863: IF l_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

859: IF l_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
860: l_LIMIT_BALANCES_rec.attribute11 := NULL;
861: END IF;
862:
863: IF l_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
864: l_LIMIT_BALANCES_rec.attribute12 := NULL;
865: END IF;
866:
867: IF l_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 867: IF l_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

863: IF l_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
864: l_LIMIT_BALANCES_rec.attribute12 := NULL;
865: END IF;
866:
867: IF l_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
868: l_LIMIT_BALANCES_rec.attribute13 := NULL;
869: END IF;
870:
871: IF l_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 871: IF l_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

867: IF l_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
868: l_LIMIT_BALANCES_rec.attribute13 := NULL;
869: END IF;
870:
871: IF l_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
872: l_LIMIT_BALANCES_rec.attribute14 := NULL;
873: END IF;
874:
875: IF l_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 875: IF l_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

871: IF l_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
872: l_LIMIT_BALANCES_rec.attribute14 := NULL;
873: END IF;
874:
875: IF l_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
876: l_LIMIT_BALANCES_rec.attribute15 := NULL;
877: END IF;
878:
879: IF l_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 879: IF l_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

875: IF l_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
876: l_LIMIT_BALANCES_rec.attribute15 := NULL;
877: END IF;
878:
879: IF l_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
880: l_LIMIT_BALANCES_rec.attribute2 := NULL;
881: END IF;
882:
883: IF l_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 883: IF l_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

879: IF l_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
880: l_LIMIT_BALANCES_rec.attribute2 := NULL;
881: END IF;
882:
883: IF l_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
884: l_LIMIT_BALANCES_rec.attribute3 := NULL;
885: END IF;
886:
887: IF l_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 887: IF l_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

883: IF l_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
884: l_LIMIT_BALANCES_rec.attribute3 := NULL;
885: END IF;
886:
887: IF l_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
888: l_LIMIT_BALANCES_rec.attribute4 := NULL;
889: END IF;
890:
891: IF l_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 891: IF l_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

887: IF l_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
888: l_LIMIT_BALANCES_rec.attribute4 := NULL;
889: END IF;
890:
891: IF l_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
892: l_LIMIT_BALANCES_rec.attribute5 := NULL;
893: END IF;
894:
895: IF l_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 895: IF l_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

891: IF l_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
892: l_LIMIT_BALANCES_rec.attribute5 := NULL;
893: END IF;
894:
895: IF l_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
896: l_LIMIT_BALANCES_rec.attribute6 := NULL;
897: END IF;
898:
899: IF l_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 899: IF l_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

895: IF l_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
896: l_LIMIT_BALANCES_rec.attribute6 := NULL;
897: END IF;
898:
899: IF l_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
900: l_LIMIT_BALANCES_rec.attribute7 := NULL;
901: END IF;
902:
903: IF l_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 903: IF l_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

899: IF l_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
900: l_LIMIT_BALANCES_rec.attribute7 := NULL;
901: END IF;
902:
903: IF l_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
904: l_LIMIT_BALANCES_rec.attribute8 := NULL;
905: END IF;
906:
907: IF l_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 907: IF l_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

903: IF l_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
904: l_LIMIT_BALANCES_rec.attribute8 := NULL;
905: END IF;
906:
907: IF l_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
908: l_LIMIT_BALANCES_rec.attribute9 := NULL;
909: END IF;
910:
911: IF l_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM THEN

Line 911: IF l_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM THEN

907: IF l_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
908: l_LIMIT_BALANCES_rec.attribute9 := NULL;
909: END IF;
910:
911: IF l_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM THEN
912: l_LIMIT_BALANCES_rec.available_amount := NULL;
913: END IF;
914:
915: IF l_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM THEN

Line 915: IF l_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM THEN

911: IF l_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM THEN
912: l_LIMIT_BALANCES_rec.available_amount := NULL;
913: END IF;
914:
915: IF l_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM THEN
916: l_LIMIT_BALANCES_rec.consumed_amount := NULL;
917: END IF;
918:
919: IF l_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR THEN

Line 919: IF l_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR THEN

915: IF l_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM THEN
916: l_LIMIT_BALANCES_rec.consumed_amount := NULL;
917: END IF;
918:
919: IF l_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR THEN
920: l_LIMIT_BALANCES_rec.context := NULL;
921: END IF;
922:
923: IF l_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM THEN

Line 923: IF l_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM THEN

919: IF l_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR THEN
920: l_LIMIT_BALANCES_rec.context := NULL;
921: END IF;
922:
923: IF l_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM THEN
924: l_LIMIT_BALANCES_rec.created_by := NULL;
925: END IF;
926:
927: IF l_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 927: IF l_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE THEN

923: IF l_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM THEN
924: l_LIMIT_BALANCES_rec.created_by := NULL;
925: END IF;
926:
927: IF l_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE THEN
928: l_LIMIT_BALANCES_rec.creation_date := NULL;
929: END IF;
930:
931: IF l_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 931: IF l_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

927: IF l_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE THEN
928: l_LIMIT_BALANCES_rec.creation_date := NULL;
929: END IF;
930:
931: IF l_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
932: l_LIMIT_BALANCES_rec.last_updated_by := NULL;
933: END IF;
934:
935: IF l_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 935: IF l_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE THEN

931: IF l_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
932: l_LIMIT_BALANCES_rec.last_updated_by := NULL;
933: END IF;
934:
935: IF l_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE THEN
936: l_LIMIT_BALANCES_rec.last_update_date := NULL;
937: END IF;
938:
939: IF l_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 939: IF l_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM THEN

935: IF l_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE THEN
936: l_LIMIT_BALANCES_rec.last_update_date := NULL;
937: END IF;
938:
939: IF l_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM THEN
940: l_LIMIT_BALANCES_rec.last_update_login := NULL;
941: END IF;
942:
943: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN

Line 943: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN

939: IF l_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM THEN
940: l_LIMIT_BALANCES_rec.last_update_login := NULL;
941: END IF;
942:
943: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN
944: l_LIMIT_BALANCES_rec.limit_balance_id := NULL;
945: END IF;
946:
947: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN

Line 947: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN

943: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN
944: l_LIMIT_BALANCES_rec.limit_balance_id := NULL;
945: END IF;
946:
947: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN
948: l_LIMIT_BALANCES_rec.limit_id := NULL;
949: END IF;
950:
951: IF l_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 951: IF l_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM THEN

947: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN
948: l_LIMIT_BALANCES_rec.limit_id := NULL;
949: END IF;
950:
951: IF l_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM THEN
952: l_LIMIT_BALANCES_rec.program_application_id := NULL;
953: END IF;
954:
955: IF l_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM THEN

Line 955: IF l_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM THEN

951: IF l_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM THEN
952: l_LIMIT_BALANCES_rec.program_application_id := NULL;
953: END IF;
954:
955: IF l_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM THEN
956: l_LIMIT_BALANCES_rec.program_id := NULL;
957: END IF;
958:
959: IF l_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 959: IF l_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN

955: IF l_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM THEN
956: l_LIMIT_BALANCES_rec.program_id := NULL;
957: END IF;
958:
959: IF l_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN
960: l_LIMIT_BALANCES_rec.program_update_date := NULL;
961: END IF;
962:
963: IF l_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM THEN

Line 963: IF l_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM THEN

959: IF l_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN
960: l_LIMIT_BALANCES_rec.program_update_date := NULL;
961: END IF;
962:
963: IF l_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM THEN
964: l_LIMIT_BALANCES_rec.request_id := NULL;
965: END IF;
966:
967: IF l_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM THEN

Line 967: IF l_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM THEN

963: IF l_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM THEN
964: l_LIMIT_BALANCES_rec.request_id := NULL;
965: END IF;
966:
967: IF l_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM THEN
968: l_LIMIT_BALANCES_rec.reserved_amount := NULL;
969: END IF;
970:
971: IF l_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN

Line 971: IF l_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN

967: IF l_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM THEN
968: l_LIMIT_BALANCES_rec.reserved_amount := NULL;
969: END IF;
970:
971: IF l_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN
972: l_LIMIT_BALANCES_rec.multival_attr1_type := NULL;
973: END IF;
974:
975: IF l_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN

Line 975: IF l_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN

971: IF l_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN
972: l_LIMIT_BALANCES_rec.multival_attr1_type := NULL;
973: END IF;
974:
975: IF l_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN
976: l_LIMIT_BALANCES_rec.multival_attr1_context := NULL;
977: END IF;
978:
979: IF l_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN

Line 979: IF l_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN

975: IF l_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN
976: l_LIMIT_BALANCES_rec.multival_attr1_context := NULL;
977: END IF;
978:
979: IF l_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN
980: l_LIMIT_BALANCES_rec.multival_attribute1 := NULL;
981: END IF;
982:
983: IF l_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR THEN

Line 983: IF l_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR THEN

979: IF l_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN
980: l_LIMIT_BALANCES_rec.multival_attribute1 := NULL;
981: END IF;
982:
983: IF l_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR THEN
984: l_LIMIT_BALANCES_rec.multival_attr1_value := NULL;
985: END IF;
986:
987: IF l_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN

Line 987: IF l_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN

983: IF l_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR THEN
984: l_LIMIT_BALANCES_rec.multival_attr1_value := NULL;
985: END IF;
986:
987: IF l_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN
988: l_LIMIT_BALANCES_rec.multival_attr1_datatype := NULL;
989: END IF;
990:
991: IF l_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN

Line 991: IF l_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN

987: IF l_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN
988: l_LIMIT_BALANCES_rec.multival_attr1_datatype := NULL;
989: END IF;
990:
991: IF l_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN
992: l_LIMIT_BALANCES_rec.multival_attr2_type := NULL;
993: END IF;
994:
995: IF l_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN

Line 995: IF l_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN

991: IF l_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN
992: l_LIMIT_BALANCES_rec.multival_attr2_type := NULL;
993: END IF;
994:
995: IF l_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN
996: l_LIMIT_BALANCES_rec.multival_attr2_context := NULL;
997: END IF;
998:
999: IF l_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN

Line 999: IF l_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN

995: IF l_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN
996: l_LIMIT_BALANCES_rec.multival_attr2_context := NULL;
997: END IF;
998:
999: IF l_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN
1000: l_LIMIT_BALANCES_rec.multival_attribute2 := NULL;
1001: END IF;
1002:
1003: IF l_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR THEN

Line 1003: IF l_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR THEN

999: IF l_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN
1000: l_LIMIT_BALANCES_rec.multival_attribute2 := NULL;
1001: END IF;
1002:
1003: IF l_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR THEN
1004: l_LIMIT_BALANCES_rec.multival_attr2_value := NULL;
1005: END IF;
1006:
1007: IF l_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN

Line 1007: IF l_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN

1003: IF l_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR THEN
1004: l_LIMIT_BALANCES_rec.multival_attr2_value := NULL;
1005: END IF;
1006:
1007: IF l_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN
1008: l_LIMIT_BALANCES_rec.multival_attr2_datatype := NULL;
1009: END IF;
1010:
1011: IF l_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR THEN

Line 1011: IF l_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR THEN

1007: IF l_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN
1008: l_LIMIT_BALANCES_rec.multival_attr2_datatype := NULL;
1009: END IF;
1010:
1011: IF l_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR THEN
1012: l_LIMIT_BALANCES_rec.organization_attr_context := NULL;
1013: END IF;
1014:
1015: IF l_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR THEN

Line 1015: IF l_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR THEN

1011: IF l_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR THEN
1012: l_LIMIT_BALANCES_rec.organization_attr_context := NULL;
1013: END IF;
1014:
1015: IF l_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR THEN
1016: l_LIMIT_BALANCES_rec.organization_attribute := NULL;
1017: END IF;
1018:
1019: IF l_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR THEN

Line 1019: IF l_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR THEN

1015: IF l_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR THEN
1016: l_LIMIT_BALANCES_rec.organization_attribute := NULL;
1017: END IF;
1018:
1019: IF l_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR THEN
1020: l_LIMIT_BALANCES_rec.organization_attr_value := NULL;
1021: END IF;
1022:
1023: RETURN l_LIMIT_BALANCES_rec;

Line 1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1130: , 'Update_Row'
1131: );
1132: END IF;
1133:
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135:
1136: END Update_Row;
1137:
1138: -- Procedure Insert_Row

Line 1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1281: , 'Insert_Row'
1282: );
1283: END IF;
1284:
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286:
1287: END Insert_Row;
1288:
1289: -- Procedure Delete_Row

Line 1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1311: , 'Delete_Row'
1312: );
1313: END IF;
1314:
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316:
1317: END Delete_Row;
1318:
1319: -- Function Query_Row

Line 1339: FND_API.G_MISS_NUM

1335: --
1336:
1337: FUNCTION Query_Rows
1338: ( p_limit_balance_id IN NUMBER :=
1339: FND_API.G_MISS_NUM
1340: , p_limit_id IN NUMBER :=
1341: FND_API.G_MISS_NUM
1342: ) RETURN QP_Limits_PUB.Limit_Balances_Tbl_Type
1343: IS

Line 1341: FND_API.G_MISS_NUM

1337: FUNCTION Query_Rows
1338: ( p_limit_balance_id IN NUMBER :=
1339: FND_API.G_MISS_NUM
1340: , p_limit_id IN NUMBER :=
1341: FND_API.G_MISS_NUM
1342: ) RETURN QP_Limits_PUB.Limit_Balances_Tbl_Type
1343: IS
1344: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1345: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 1402: p_limit_balance_id <> FND_API.G_MISS_NUM)

1398:
1399: IF
1400: (p_limit_balance_id IS NOT NULL
1401: AND
1402: p_limit_balance_id <> FND_API.G_MISS_NUM)
1403: AND
1404: (p_limit_id IS NOT NULL
1405: AND
1406: p_limit_id <> FND_API.G_MISS_NUM)

Line 1406: p_limit_id <> FND_API.G_MISS_NUM)

1402: p_limit_balance_id <> FND_API.G_MISS_NUM)
1403: AND
1404: (p_limit_id IS NOT NULL
1405: AND
1406: p_limit_id <> FND_API.G_MISS_NUM)
1407: THEN
1408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1409: THEN
1410: OE_MSG_PUB.Add_Exc_Msg

Line 1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1413: , 'Keys are mutually exclusive: limit_balance_id = '|| p_limit_balance_id || ', limit_id = '|| p_limit_id
1414: );
1415: END IF;
1416:
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1418:
1419: END IF;
1420:
1421:

Line 1480: p_limit_balance_id <> FND_API.G_MISS_NUM)

1476:
1477: IF
1478: (p_limit_balance_id IS NOT NULL
1479: AND
1480: p_limit_balance_id <> FND_API.G_MISS_NUM)
1481: AND
1482: (l_LIMIT_BALANCES_tbl.COUNT = 0)
1483: THEN
1484: RAISE NO_DATA_FOUND;

Line 1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1490: RETURN l_LIMIT_BALANCES_tbl;
1491:
1492: EXCEPTION
1493:
1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1495:
1496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1497:
1498: WHEN OTHERS THEN

Line 1496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1492: EXCEPTION
1493:
1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1495:
1496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1497:
1498: WHEN OTHERS THEN
1499:
1500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1504: , 'Query_Rows'
1505: );
1506: END IF;
1507:
1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1509:
1510: END Query_Rows;
1511:
1512: -- Procedure lock_Row

Line 1710: x_return_status := FND_API.G_RET_STS_SUCCESS;

1706: x_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec;
1707:
1708: -- Set return status
1709:
1710: x_return_status := FND_API.G_RET_STS_SUCCESS;
1711: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1712:
1713: ELSE
1714:

Line 1711: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1707:
1708: -- Set return status
1709:
1710: x_return_status := FND_API.G_RET_STS_SUCCESS;
1711: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1712:
1713: ELSE
1714:
1715: -- Row has changed by another user.

Line 1717: x_return_status := FND_API.G_RET_STS_ERROR;

1713: ELSE
1714:
1715: -- Row has changed by another user.
1716:
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;
1719:
1720: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1721: THEN

Line 1718: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;

1714:
1715: -- Row has changed by another user.
1716:
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;
1719:
1720: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1721: THEN
1722:

Line 1734: x_return_status := FND_API.G_RET_STS_ERROR;

1730: EXCEPTION
1731:
1732: WHEN NO_DATA_FOUND THEN
1733:
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;
1736:
1737: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1738: THEN

Line 1735: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;

1731:
1732: WHEN NO_DATA_FOUND THEN
1733:
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;
1736:
1737: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1738: THEN
1739:

Line 1746: x_return_status := FND_API.G_RET_STS_ERROR;

1742:
1743: END IF;
1744: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1745:
1746: x_return_status := FND_API.G_RET_STS_ERROR;
1747: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;
1748:
1749: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1750: THEN

Line 1747: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;

1743: END IF;
1744: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1745:
1746: x_return_status := FND_API.G_RET_STS_ERROR;
1747: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;
1748:
1749: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1750: THEN
1751:

Line 1758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1754:
1755: END IF;
1756: WHEN OTHERS THEN
1757:
1758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1759: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1760:
1761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1762: THEN

Line 1759: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1755: END IF;
1756: WHEN OTHERS THEN
1757:
1758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1759: x_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1760:
1761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1762: THEN
1763: OE_MSG_PUB.Add_Exc_Msg

Line 1783: p_LIMIT_BALANCES_rec.limit_balance_id <> FND_API.G_MISS_NUM AND

1779: l_LIMIT_BALANCES_val_rec QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
1780: BEGIN
1781:
1782: IF p_LIMIT_BALANCES_rec.limit_balance_id IS NOT NULL AND
1783: p_LIMIT_BALANCES_rec.limit_balance_id <> FND_API.G_MISS_NUM AND
1784: NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,
1785: p_old_LIMIT_BALANCES_rec.limit_balance_id)
1786: THEN
1787: l_LIMIT_BALANCES_val_rec.limit_balance := QP_Id_To_Value.Limit_Balance

Line 1793: p_LIMIT_BALANCES_rec.limit_id <> FND_API.G_MISS_NUM AND

1789: );
1790: END IF;
1791:
1792: IF p_LIMIT_BALANCES_rec.limit_id IS NOT NULL AND
1793: p_LIMIT_BALANCES_rec.limit_id <> FND_API.G_MISS_NUM AND
1794: NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,
1795: p_old_LIMIT_BALANCES_rec.limit_id)
1796: THEN
1797: l_LIMIT_BALANCES_val_rec.limit := QP_Id_To_Value.Limit

Line 1818: l_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1814: BEGIN
1815:
1816: -- initialize return_status.
1817:
1818: l_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1819:
1820: -- initialize l_LIMIT_BALANCES_rec.
1821:
1822: l_LIMIT_BALANCES_rec := p_LIMIT_BALANCES_rec;

Line 1824: IF p_LIMIT_BALANCES_val_rec.limit_balance <> FND_API.G_MISS_CHAR

1820: -- initialize l_LIMIT_BALANCES_rec.
1821:
1822: l_LIMIT_BALANCES_rec := p_LIMIT_BALANCES_rec;
1823:
1824: IF p_LIMIT_BALANCES_val_rec.limit_balance <> FND_API.G_MISS_CHAR
1825: THEN
1826:
1827: IF p_LIMIT_BALANCES_rec.limit_balance_id <> FND_API.G_MISS_NUM THEN
1828:

Line 1827: IF p_LIMIT_BALANCES_rec.limit_balance_id <> FND_API.G_MISS_NUM THEN

1823:
1824: IF p_LIMIT_BALANCES_val_rec.limit_balance <> FND_API.G_MISS_CHAR
1825: THEN
1826:
1827: IF p_LIMIT_BALANCES_rec.limit_balance_id <> FND_API.G_MISS_NUM THEN
1828:
1829: l_LIMIT_BALANCES_rec.limit_balance_id := p_LIMIT_BALANCES_rec.limit_balance_id;
1830:
1831: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1846: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN

1842: l_LIMIT_BALANCES_rec.limit_balance_id := QP_Value_To_Id.limit_balance
1843: ( p_limit_balance => p_LIMIT_BALANCES_val_rec.limit_balance
1844: );
1845:
1846: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN
1847: l_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;
1848: END IF;
1849:
1850: END IF;

Line 1847: l_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;

1843: ( p_limit_balance => p_LIMIT_BALANCES_val_rec.limit_balance
1844: );
1845:
1846: IF l_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN
1847: l_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;
1848: END IF;
1849:
1850: END IF;
1851:

Line 1854: IF p_LIMIT_BALANCES_val_rec.limit <> FND_API.G_MISS_CHAR

1850: END IF;
1851:
1852: END IF;
1853:
1854: IF p_LIMIT_BALANCES_val_rec.limit <> FND_API.G_MISS_CHAR
1855: THEN
1856:
1857: IF p_LIMIT_BALANCES_rec.limit_id <> FND_API.G_MISS_NUM THEN
1858:

Line 1857: IF p_LIMIT_BALANCES_rec.limit_id <> FND_API.G_MISS_NUM THEN

1853:
1854: IF p_LIMIT_BALANCES_val_rec.limit <> FND_API.G_MISS_CHAR
1855: THEN
1856:
1857: IF p_LIMIT_BALANCES_rec.limit_id <> FND_API.G_MISS_NUM THEN
1858:
1859: l_LIMIT_BALANCES_rec.limit_id := p_LIMIT_BALANCES_rec.limit_id;
1860:
1861: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1876: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN

1872: l_LIMIT_BALANCES_rec.limit_id := QP_Value_To_Id.limit
1873: ( p_limit => p_LIMIT_BALANCES_val_rec.limit
1874: );
1875:
1876: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN
1877: l_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;
1878: END IF;
1879:
1880: END IF;

Line 1877: l_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;

1873: ( p_limit => p_LIMIT_BALANCES_val_rec.limit
1874: );
1875:
1876: IF l_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN
1877: l_LIMIT_BALANCES_rec.return_status := FND_API.G_RET_STS_ERROR;
1878: END IF;
1879:
1880: END IF;
1881: