DBA Data[Home] [Help]

APPS.QP_QP_FORM_LIMIT_BALANCES dependencies on QP_GLOBALS

Line 80: l_control_rec QP_GLOBALS.Control_Rec_Type;

76: IS
77: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
78: l_LIMIT_BALANCES_val_rec QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
79: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
80: l_control_rec QP_GLOBALS.Control_Rec_Type;
81: l_return_status VARCHAR2(1);
82: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
83: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
84: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 129: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_CREATE;

125: l_LIMIT_BALANCES_rec.context := NULL;
126:
127: -- Set Operation to Create
128:
129: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_CREATE;
130:
131: -- Populate LIMIT_BALANCES table
132:
133: l_LIMIT_BALANCES_tbl(1) := l_LIMIT_BALANCES_rec;

Line 341: l_control_rec QP_GLOBALS.Control_Rec_Type;

337: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
338: l_LIMIT_BALANCES_val_rec QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
339: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
340: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
341: l_control_rec QP_GLOBALS.Control_Rec_Type;
342: l_return_status VARCHAR2(1);
343: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
344: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
345: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 465: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

461:
462: -- Set Operation.
463:
464: IF FND_API.To_Boolean(l_LIMIT_BALANCES_rec.db_flag) THEN
465: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
466: ELSE
467: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_CREATE;
468: END IF;
469:

Line 467: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_CREATE;

463:
464: IF FND_API.To_Boolean(l_LIMIT_BALANCES_rec.db_flag) THEN
465: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
466: ELSE
467: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_CREATE;
468: END IF;
469:
470: -- Populate LIMIT_BALANCES table
471:

Line 551: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute1,

547: );
548:
549: -- Return changed attributes.
550:
551: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute1,
552: l_LIMIT_BALANCES_rec.attribute1)
553: THEN
554: x_attribute1 := l_x_LIMIT_BALANCES_rec.attribute1;
555: END IF;

Line 557: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute10,

553: THEN
554: x_attribute1 := l_x_LIMIT_BALANCES_rec.attribute1;
555: END IF;
556:
557: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute10,
558: l_LIMIT_BALANCES_rec.attribute10)
559: THEN
560: x_attribute10 := l_x_LIMIT_BALANCES_rec.attribute10;
561: END IF;

Line 563: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute11,

559: THEN
560: x_attribute10 := l_x_LIMIT_BALANCES_rec.attribute10;
561: END IF;
562:
563: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute11,
564: l_LIMIT_BALANCES_rec.attribute11)
565: THEN
566: x_attribute11 := l_x_LIMIT_BALANCES_rec.attribute11;
567: END IF;

Line 569: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute12,

565: THEN
566: x_attribute11 := l_x_LIMIT_BALANCES_rec.attribute11;
567: END IF;
568:
569: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute12,
570: l_LIMIT_BALANCES_rec.attribute12)
571: THEN
572: x_attribute12 := l_x_LIMIT_BALANCES_rec.attribute12;
573: END IF;

Line 575: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute13,

571: THEN
572: x_attribute12 := l_x_LIMIT_BALANCES_rec.attribute12;
573: END IF;
574:
575: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute13,
576: l_LIMIT_BALANCES_rec.attribute13)
577: THEN
578: x_attribute13 := l_x_LIMIT_BALANCES_rec.attribute13;
579: END IF;

Line 581: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute14,

577: THEN
578: x_attribute13 := l_x_LIMIT_BALANCES_rec.attribute13;
579: END IF;
580:
581: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute14,
582: l_LIMIT_BALANCES_rec.attribute14)
583: THEN
584: x_attribute14 := l_x_LIMIT_BALANCES_rec.attribute14;
585: END IF;

Line 587: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute15,

583: THEN
584: x_attribute14 := l_x_LIMIT_BALANCES_rec.attribute14;
585: END IF;
586:
587: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute15,
588: l_LIMIT_BALANCES_rec.attribute15)
589: THEN
590: x_attribute15 := l_x_LIMIT_BALANCES_rec.attribute15;
591: END IF;

Line 593: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute2,

589: THEN
590: x_attribute15 := l_x_LIMIT_BALANCES_rec.attribute15;
591: END IF;
592:
593: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute2,
594: l_LIMIT_BALANCES_rec.attribute2)
595: THEN
596: x_attribute2 := l_x_LIMIT_BALANCES_rec.attribute2;
597: END IF;

Line 599: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute3,

595: THEN
596: x_attribute2 := l_x_LIMIT_BALANCES_rec.attribute2;
597: END IF;
598:
599: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute3,
600: l_LIMIT_BALANCES_rec.attribute3)
601: THEN
602: x_attribute3 := l_x_LIMIT_BALANCES_rec.attribute3;
603: END IF;

Line 605: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute4,

601: THEN
602: x_attribute3 := l_x_LIMIT_BALANCES_rec.attribute3;
603: END IF;
604:
605: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute4,
606: l_LIMIT_BALANCES_rec.attribute4)
607: THEN
608: x_attribute4 := l_x_LIMIT_BALANCES_rec.attribute4;
609: END IF;

Line 611: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute5,

607: THEN
608: x_attribute4 := l_x_LIMIT_BALANCES_rec.attribute4;
609: END IF;
610:
611: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute5,
612: l_LIMIT_BALANCES_rec.attribute5)
613: THEN
614: x_attribute5 := l_x_LIMIT_BALANCES_rec.attribute5;
615: END IF;

Line 617: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute6,

613: THEN
614: x_attribute5 := l_x_LIMIT_BALANCES_rec.attribute5;
615: END IF;
616:
617: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute6,
618: l_LIMIT_BALANCES_rec.attribute6)
619: THEN
620: x_attribute6 := l_x_LIMIT_BALANCES_rec.attribute6;
621: END IF;

Line 623: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute7,

619: THEN
620: x_attribute6 := l_x_LIMIT_BALANCES_rec.attribute6;
621: END IF;
622:
623: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute7,
624: l_LIMIT_BALANCES_rec.attribute7)
625: THEN
626: x_attribute7 := l_x_LIMIT_BALANCES_rec.attribute7;
627: END IF;

Line 629: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute8,

625: THEN
626: x_attribute7 := l_x_LIMIT_BALANCES_rec.attribute7;
627: END IF;
628:
629: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute8,
630: l_LIMIT_BALANCES_rec.attribute8)
631: THEN
632: x_attribute8 := l_x_LIMIT_BALANCES_rec.attribute8;
633: END IF;

Line 635: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute9,

631: THEN
632: x_attribute8 := l_x_LIMIT_BALANCES_rec.attribute8;
633: END IF;
634:
635: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.attribute9,
636: l_LIMIT_BALANCES_rec.attribute9)
637: THEN
638: x_attribute9 := l_x_LIMIT_BALANCES_rec.attribute9;
639: END IF;

Line 641: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.available_amount,

637: THEN
638: x_attribute9 := l_x_LIMIT_BALANCES_rec.attribute9;
639: END IF;
640:
641: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.available_amount,
642: l_LIMIT_BALANCES_rec.available_amount)
643: THEN
644: x_available_amount := l_x_LIMIT_BALANCES_rec.available_amount;
645: END IF;

Line 647: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.consumed_amount,

643: THEN
644: x_available_amount := l_x_LIMIT_BALANCES_rec.available_amount;
645: END IF;
646:
647: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.consumed_amount,
648: l_LIMIT_BALANCES_rec.consumed_amount)
649: THEN
650: x_consumed_amount := l_x_LIMIT_BALANCES_rec.consumed_amount;
651: END IF;

Line 653: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.context,

649: THEN
650: x_consumed_amount := l_x_LIMIT_BALANCES_rec.consumed_amount;
651: END IF;
652:
653: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.context,
654: l_LIMIT_BALANCES_rec.context)
655: THEN
656: x_context := l_x_LIMIT_BALANCES_rec.context;
657: END IF;

Line 659: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.limit_balance_id,

655: THEN
656: x_context := l_x_LIMIT_BALANCES_rec.context;
657: END IF;
658:
659: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.limit_balance_id,
660: l_LIMIT_BALANCES_rec.limit_balance_id)
661: THEN
662: x_limit_balance_id := l_x_LIMIT_BALANCES_rec.limit_balance_id;
663: x_limit_balance := l_LIMIT_BALANCES_val_rec.limit_balance;

Line 666: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.limit_id,

662: x_limit_balance_id := l_x_LIMIT_BALANCES_rec.limit_balance_id;
663: x_limit_balance := l_LIMIT_BALANCES_val_rec.limit_balance;
664: END IF;
665:
666: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.limit_id,
667: l_LIMIT_BALANCES_rec.limit_id)
668: THEN
669: x_limit_id := l_x_LIMIT_BALANCES_rec.limit_id;
670: x_limit := l_LIMIT_BALANCES_val_rec.limit;

Line 673: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr1_type,

669: x_limit_id := l_x_LIMIT_BALANCES_rec.limit_id;
670: x_limit := l_LIMIT_BALANCES_val_rec.limit;
671: END IF;
672:
673: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr1_type,
674: l_LIMIT_BALANCES_rec.multival_attr1_type)
675: THEN
676: x_multival_attr1_type := l_x_LIMIT_BALANCES_rec.multival_attr1_type;
677: END IF;

Line 679: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr1_context,

675: THEN
676: x_multival_attr1_type := l_x_LIMIT_BALANCES_rec.multival_attr1_type;
677: END IF;
678:
679: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr1_context,
680: l_LIMIT_BALANCES_rec.multival_attr1_context)
681: THEN
682: x_multival_attr1_context := l_x_LIMIT_BALANCES_rec.multival_attr1_context;
683: END IF;

Line 685: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attribute1,

681: THEN
682: x_multival_attr1_context := l_x_LIMIT_BALANCES_rec.multival_attr1_context;
683: END IF;
684:
685: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attribute1,
686: l_LIMIT_BALANCES_rec.multival_attribute1)
687: THEN
688: x_multival_attribute1 := l_x_LIMIT_BALANCES_rec.multival_attribute1;
689: END IF;

Line 691: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr1_value,

687: THEN
688: x_multival_attribute1 := l_x_LIMIT_BALANCES_rec.multival_attribute1;
689: END IF;
690:
691: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr1_value,
692: l_LIMIT_BALANCES_rec.multival_attr1_value)
693: THEN
694: x_multival_attr1_value := l_x_LIMIT_BALANCES_rec.multival_attr1_value;
695: END IF;

Line 697: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr1_datatype,

693: THEN
694: x_multival_attr1_value := l_x_LIMIT_BALANCES_rec.multival_attr1_value;
695: END IF;
696:
697: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr1_datatype,
698: l_LIMIT_BALANCES_rec.multival_attr1_datatype)
699: THEN
700: x_multival_attr1_datatype := l_x_LIMIT_BALANCES_rec.multival_attr1_datatype;
701: END IF;

Line 703: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr2_type,

699: THEN
700: x_multival_attr1_datatype := l_x_LIMIT_BALANCES_rec.multival_attr1_datatype;
701: END IF;
702:
703: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr2_type,
704: l_LIMIT_BALANCES_rec.multival_attr2_type)
705: THEN
706: x_multival_attr2_type := l_x_LIMIT_BALANCES_rec.multival_attr2_type;
707: END IF;

Line 709: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr2_context,

705: THEN
706: x_multival_attr2_type := l_x_LIMIT_BALANCES_rec.multival_attr2_type;
707: END IF;
708:
709: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr2_context,
710: l_LIMIT_BALANCES_rec.multival_attr2_context)
711: THEN
712: x_multival_attr2_context := l_x_LIMIT_BALANCES_rec.multival_attr2_context;
713: END IF;

Line 715: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attribute2,

711: THEN
712: x_multival_attr2_context := l_x_LIMIT_BALANCES_rec.multival_attr2_context;
713: END IF;
714:
715: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attribute2,
716: l_LIMIT_BALANCES_rec.multival_attribute2)
717: THEN
718: x_multival_attribute2 := l_x_LIMIT_BALANCES_rec.multival_attribute2;
719: END IF;

Line 721: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr2_value,

717: THEN
718: x_multival_attribute2 := l_x_LIMIT_BALANCES_rec.multival_attribute2;
719: END IF;
720:
721: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr2_value,
722: l_LIMIT_BALANCES_rec.multival_attr2_value)
723: THEN
724: x_multival_attr2_value := l_x_LIMIT_BALANCES_rec.multival_attr2_value;
725: END IF;

Line 727: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr2_datatype,

723: THEN
724: x_multival_attr2_value := l_x_LIMIT_BALANCES_rec.multival_attr2_value;
725: END IF;
726:
727: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.multival_attr2_datatype,
728: l_LIMIT_BALANCES_rec.multival_attr2_datatype)
729: THEN
730: x_multival_attr2_datatype := l_x_LIMIT_BALANCES_rec.multival_attr2_datatype;
731: END IF;

Line 733: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.organization_attr_context,

729: THEN
730: x_multival_attr2_datatype := l_x_LIMIT_BALANCES_rec.multival_attr2_datatype;
731: END IF;
732:
733: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.organization_attr_context,
734: l_LIMIT_BALANCES_rec.organization_attr_context)
735: THEN
736: x_organization_attr_context := l_x_LIMIT_BALANCES_rec.organization_attr_context;
737: END IF;

Line 739: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.organization_attribute,

735: THEN
736: x_organization_attr_context := l_x_LIMIT_BALANCES_rec.organization_attr_context;
737: END IF;
738:
739: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.organization_attribute,
740: l_LIMIT_BALANCES_rec.organization_attribute)
741: THEN
742: x_organization_attribute := l_x_LIMIT_BALANCES_rec.organization_attribute;
743: END IF;

Line 745: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.organization_attr_value,

741: THEN
742: x_organization_attribute := l_x_LIMIT_BALANCES_rec.organization_attribute;
743: END IF;
744:
745: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.organization_attr_value,
746: l_LIMIT_BALANCES_rec.organization_attr_value)
747: THEN
748: x_organization_attr_value := l_x_LIMIT_BALANCES_rec.organization_attr_value;
749: END IF;

Line 751: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.reserved_amount,

747: THEN
748: x_organization_attr_value := l_x_LIMIT_BALANCES_rec.organization_attr_value;
749: END IF;
750:
751: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_BALANCES_rec.reserved_amount,
752: l_LIMIT_BALANCES_rec.reserved_amount)
753: THEN
754: x_reserved_amount := l_x_LIMIT_BALANCES_rec.reserved_amount;
755: END IF;

Line 840: l_control_rec QP_GLOBALS.Control_Rec_Type;

836: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
837: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
838: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
839: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
840: l_control_rec QP_GLOBALS.Control_Rec_Type;
841: l_return_status VARCHAR2(1);
842: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
843: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
844: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 879: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

875:
876: -- Set Operation.
877:
878: IF FND_API.To_Boolean(l_LIMIT_BALANCES_rec.db_flag) THEN
879: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
880: ELSE
881: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_CREATE;
882: END IF;
883:

Line 881: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_CREATE;

877:
878: IF FND_API.To_Boolean(l_LIMIT_BALANCES_rec.db_flag) THEN
879: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
880: ELSE
881: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_CREATE;
882: END IF;
883:
884: -- Populate LIMIT_BALANCES table
885:

Line 1000: l_control_rec QP_GLOBALS.Control_Rec_Type;

996: )
997: IS
998: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
999: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1000: l_control_rec QP_GLOBALS.Control_Rec_Type;
1001: l_return_status VARCHAR2(1);
1002: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1003: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1004: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 1033: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_DELETE;

1029: );
1030:
1031: -- Set Operation.
1032:
1033: l_LIMIT_BALANCES_rec.operation := QP_GLOBALS.G_OPR_DELETE;
1034:
1035: -- Populate LIMIT_BALANCES table
1036:
1037: l_LIMIT_BALANCES_tbl(1) := l_LIMIT_BALANCES_rec;

Line 1131: l_control_rec QP_GLOBALS.Control_Rec_Type;

1127: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1128: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1129: )
1130: IS
1131: l_control_rec QP_GLOBALS.Control_Rec_Type;
1132: l_return_status VARCHAR2(1);
1133: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1134: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1135: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 1144: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_LIMIT_BALANCES;

1140: -- Set control flags.
1141:
1142: l_control_rec.controlled_operation := TRUE;
1143: l_control_rec.process := TRUE;
1144: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_LIMIT_BALANCES;
1145:
1146: l_control_rec.default_attributes := FALSE;
1147: l_control_rec.change_attributes := FALSE;
1148: l_control_rec.validate_entity := FALSE;