APPS.PN_LOC_ACC_MAP_PKG dependencies on PN_VAR_RENT_PKG

Line 635: pn_var_rent_pkg.lock_row_exception('lOC_ACC_MAP_ID',tlinfo.loc_acc_map_id);

631: END IF;
632:
633: CLOSE c1;
634: IF NOT (tlinfo.LOC_ACC_MAP_ID = x_loc_acc_map_id) THEN
635: pn_var_rent_pkg.lock_row_exception('lOC_ACC_MAP_ID',tlinfo.loc_acc_map_id);
636: END IF;
637:
638: IF NOT (tlinfo.LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID ) THEN
639: pn_var_rent_pkg.lock_row_exception('LOC_ACC_MAP_HDR_ID',tlinfo.LOC_ACC_MAP_HDR_ID);

Line 639: pn_var_rent_pkg.lock_row_exception('LOC_ACC_MAP_HDR_ID',tlinfo.LOC_ACC_MAP_HDR_ID);

635: pn_var_rent_pkg.lock_row_exception('lOC_ACC_MAP_ID',tlinfo.loc_acc_map_id);
636: END IF;
637:
638: IF NOT (tlinfo.LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID ) THEN
639: pn_var_rent_pkg.lock_row_exception('LOC_ACC_MAP_HDR_ID',tlinfo.LOC_ACC_MAP_HDR_ID);
640: END IF;
641:
642: IF NOT ((tlinfo.PROPERTY_ID = x_PROPERTY_ID)
643: OR ((tlinfo.PROPERTY_ID IS NULL) AND (x_PROPERTY_ID IS NULL))) THEN

Line 644: pn_var_rent_pkg.lock_row_exception('PROPERTY_ID',tlinfo.PROPERTY_ID);

640: END IF;
641:
642: IF NOT ((tlinfo.PROPERTY_ID = x_PROPERTY_ID)
643: OR ((tlinfo.PROPERTY_ID IS NULL) AND (x_PROPERTY_ID IS NULL))) THEN
644: pn_var_rent_pkg.lock_row_exception('PROPERTY_ID',tlinfo.PROPERTY_ID);
645: END IF;
646:
647: IF NOT ((tlinfo.LOCATION_ID = x_LOCATION_ID)
648: OR ((tlinfo.LOCATION_ID IS NULL) AND (x_LOCATION_ID IS NULL))) THEN

Line 649: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.LOCATION_ID);

645: END IF;
646:
647: IF NOT ((tlinfo.LOCATION_ID = x_LOCATION_ID)
648: OR ((tlinfo.LOCATION_ID IS NULL) AND (x_LOCATION_ID IS NULL))) THEN
649: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.LOCATION_ID);
650: END IF;
651:
652: IF NOT (tlinfo.ACCOUNT_LOW = x_ACCOUNT_LOW) THEN
653: pn_var_rent_pkg.lock_row_exception('ACCOUNT_LOW',tlinfo.ACCOUNT_LOW);

Line 653: pn_var_rent_pkg.lock_row_exception('ACCOUNT_LOW',tlinfo.ACCOUNT_LOW);

649: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.LOCATION_ID);
650: END IF;
651:
652: IF NOT (tlinfo.ACCOUNT_LOW = x_ACCOUNT_LOW) THEN
653: pn_var_rent_pkg.lock_row_exception('ACCOUNT_LOW',tlinfo.ACCOUNT_LOW);
654: END IF;
655:
656: IF NOT (tlinfo.ACCOUNT_HIGH = x_ACCOUNT_HIGH) THEN
657: pn_var_rent_pkg.lock_row_exception('ACCOUNT_HIGH',tlinfo.ACCOUNT_HIGH);

Line 657: pn_var_rent_pkg.lock_row_exception('ACCOUNT_HIGH',tlinfo.ACCOUNT_HIGH);

653: pn_var_rent_pkg.lock_row_exception('ACCOUNT_LOW',tlinfo.ACCOUNT_LOW);
654: END IF;
655:
656: IF NOT (tlinfo.ACCOUNT_HIGH = x_ACCOUNT_HIGH) THEN
657: pn_var_rent_pkg.lock_row_exception('ACCOUNT_HIGH',tlinfo.ACCOUNT_HIGH);
658: END IF;
659:
660: IF NOT (tlinfo.EXPENSE_TYPE_CODE = x_EXPENSE_TYPE_CODE) THEN
661: pn_var_rent_pkg.lock_row_exception('EXPENSE_TYPE_CODE',tlinfo.EXPENSE_TYPE_CODE);

Line 661: pn_var_rent_pkg.lock_row_exception('EXPENSE_TYPE_CODE',tlinfo.EXPENSE_TYPE_CODE);

657: pn_var_rent_pkg.lock_row_exception('ACCOUNT_HIGH',tlinfo.ACCOUNT_HIGH);
658: END IF;
659:
660: IF NOT (tlinfo.EXPENSE_TYPE_CODE = x_EXPENSE_TYPE_CODE) THEN
661: pn_var_rent_pkg.lock_row_exception('EXPENSE_TYPE_CODE',tlinfo.EXPENSE_TYPE_CODE);
662: END IF;
663:
664: IF NOT (tlinfo.EFFECTIVE_FROM_DATE = x_EFFECTIVE_FROM_DATE) THEN
665: pn_var_rent_pkg.lock_row_exception('EFFECTIVE_FROM_DATE',tlinfo.EFFECTIVE_FROM_DATE);

Line 665: pn_var_rent_pkg.lock_row_exception('EFFECTIVE_FROM_DATE',tlinfo.EFFECTIVE_FROM_DATE);

661: pn_var_rent_pkg.lock_row_exception('EXPENSE_TYPE_CODE',tlinfo.EXPENSE_TYPE_CODE);
662: END IF;
663:
664: IF NOT (tlinfo.EFFECTIVE_FROM_DATE = x_EFFECTIVE_FROM_DATE) THEN
665: pn_var_rent_pkg.lock_row_exception('EFFECTIVE_FROM_DATE',tlinfo.EFFECTIVE_FROM_DATE);
666: END IF;
667:
668: IF NOT (tlinfo.EFFECTIVE_TO_DATE = x_EFFECTIVE_TO_DATE) THEN
669: pn_var_rent_pkg.lock_row_exception('EFFECTIVE_TO_DATE',tlinfo.EFFECTIVE_TO_DATE);

Line 669: pn_var_rent_pkg.lock_row_exception('EFFECTIVE_TO_DATE',tlinfo.EFFECTIVE_TO_DATE);

665: pn_var_rent_pkg.lock_row_exception('EFFECTIVE_FROM_DATE',tlinfo.EFFECTIVE_FROM_DATE);
666: END IF;
667:
668: IF NOT (tlinfo.EFFECTIVE_TO_DATE = x_EFFECTIVE_TO_DATE) THEN
669: pn_var_rent_pkg.lock_row_exception('EFFECTIVE_TO_DATE',tlinfo.EFFECTIVE_TO_DATE);
670: END IF;
671:
672: IF NOT ((tlinfo.RECOVERABLE_FLAG = x_RECOVERABLE_FLAG )
673: OR ((tlinfo.RECOVERABLE_FLAG IS NULL) AND (x_RECOVERABLE_FLAG IS NULL))) THEN

Line 674: pn_var_rent_pkg.lock_row_exception('RECOVERABLE_FLAG',tlinfo.RECOVERABLE_FLAG);

670: END IF;
671:
672: IF NOT ((tlinfo.RECOVERABLE_FLAG = x_RECOVERABLE_FLAG )
673: OR ((tlinfo.RECOVERABLE_FLAG IS NULL) AND (x_RECOVERABLE_FLAG IS NULL))) THEN
674: pn_var_rent_pkg.lock_row_exception('RECOVERABLE_FLAG',tlinfo.RECOVERABLE_FLAG);
675: END IF;
676:
677: IF NOT ((tlinfo.SEGMENT1_LOW = x_SEGMENT1_LOW )
678: OR ((tlinfo.SEGMENT1_LOW IS NULL) AND (x_SEGMENT1_LOW IS NULL))) THEN

Line 679: pn_var_rent_pkg.lock_row_exception('SEGMENT1_LOW',tlinfo.SEGMENT1_LOW);

675: END IF;
676:
677: IF NOT ((tlinfo.SEGMENT1_LOW = x_SEGMENT1_LOW )
678: OR ((tlinfo.SEGMENT1_LOW IS NULL) AND (x_SEGMENT1_LOW IS NULL))) THEN
679: pn_var_rent_pkg.lock_row_exception('SEGMENT1_LOW',tlinfo.SEGMENT1_LOW);
680: END IF;
681:
682: IF NOT ((tlinfo.SEGMENT1_HIGH = x_SEGMENT1_HIGH )
683: OR ((tlinfo.SEGMENT1_HIGH IS NULL) AND (x_SEGMENT1_HIGH IS NULL))) THEN

Line 684: pn_var_rent_pkg.lock_row_exception('SEGMENT1_HIGH',tlinfo.SEGMENT1_HIGH);

680: END IF;
681:
682: IF NOT ((tlinfo.SEGMENT1_HIGH = x_SEGMENT1_HIGH )
683: OR ((tlinfo.SEGMENT1_HIGH IS NULL) AND (x_SEGMENT1_HIGH IS NULL))) THEN
684: pn_var_rent_pkg.lock_row_exception('SEGMENT1_HIGH',tlinfo.SEGMENT1_HIGH);
685: END IF;
686:
687: IF NOT ((tlinfo.SEGMENT2_LOW = x_SEGMENT2_LOW )
688: OR ((tlinfo.SEGMENT2_LOW IS NULL) AND (x_SEGMENT2_LOW IS NULL))) THEN

Line 689: pn_var_rent_pkg.lock_row_exception('SEGMENT2_LOW',tlinfo.SEGMENT2_LOW);

685: END IF;
686:
687: IF NOT ((tlinfo.SEGMENT2_LOW = x_SEGMENT2_LOW )
688: OR ((tlinfo.SEGMENT2_LOW IS NULL) AND (x_SEGMENT2_LOW IS NULL))) THEN
689: pn_var_rent_pkg.lock_row_exception('SEGMENT2_LOW',tlinfo.SEGMENT2_LOW);
690: END IF;
691:
692: IF NOT ((tlinfo.SEGMENT2_HIGH = x_SEGMENT2_HIGH )
693: OR ((tlinfo.SEGMENT2_HIGH IS NULL) AND (x_SEGMENT2_HIGH IS NULL))) THEN

Line 694: pn_var_rent_pkg.lock_row_exception('SEGMENT2_HIGH',tlinfo.SEGMENT2_HIGH);

690: END IF;
691:
692: IF NOT ((tlinfo.SEGMENT2_HIGH = x_SEGMENT2_HIGH )
693: OR ((tlinfo.SEGMENT2_HIGH IS NULL) AND (x_SEGMENT2_HIGH IS NULL))) THEN
694: pn_var_rent_pkg.lock_row_exception('SEGMENT2_HIGH',tlinfo.SEGMENT2_HIGH);
695: END IF;
696:
697: IF NOT ((tlinfo.SEGMENT3_LOW = x_SEGMENT3_LOW )
698: OR ((tlinfo.SEGMENT3_LOW IS NULL) AND (x_SEGMENT3_LOW IS NULL))) THEN

Line 699: pn_var_rent_pkg.lock_row_exception('SEGMENT3_LOW',tlinfo.SEGMENT3_LOW);

695: END IF;
696:
697: IF NOT ((tlinfo.SEGMENT3_LOW = x_SEGMENT3_LOW )
698: OR ((tlinfo.SEGMENT3_LOW IS NULL) AND (x_SEGMENT3_LOW IS NULL))) THEN
699: pn_var_rent_pkg.lock_row_exception('SEGMENT3_LOW',tlinfo.SEGMENT3_LOW);
700: END IF;
701:
702: IF NOT ((tlinfo.SEGMENT3_HIGH = x_SEGMENT3_HIGH )
703: OR ((tlinfo.SEGMENT3_HIGH IS NULL) AND (x_SEGMENT3_HIGH IS NULL))) THEN

Line 704: pn_var_rent_pkg.lock_row_exception('SEGMENT3_HIGH',tlinfo.SEGMENT3_HIGH);

700: END IF;
701:
702: IF NOT ((tlinfo.SEGMENT3_HIGH = x_SEGMENT3_HIGH )
703: OR ((tlinfo.SEGMENT3_HIGH IS NULL) AND (x_SEGMENT3_HIGH IS NULL))) THEN
704: pn_var_rent_pkg.lock_row_exception('SEGMENT3_HIGH',tlinfo.SEGMENT3_HIGH);
705: END IF;
706:
707: IF NOT ((tlinfo.SEGMENT4_LOW = x_SEGMENT4_LOW )
708: OR ((tlinfo.SEGMENT4_LOW IS NULL) AND (x_SEGMENT4_LOW IS NULL))) THEN

Line 709: pn_var_rent_pkg.lock_row_exception('SEGMENT4_LOW',tlinfo.SEGMENT4_LOW);

705: END IF;
706:
707: IF NOT ((tlinfo.SEGMENT4_LOW = x_SEGMENT4_LOW )
708: OR ((tlinfo.SEGMENT4_LOW IS NULL) AND (x_SEGMENT4_LOW IS NULL))) THEN
709: pn_var_rent_pkg.lock_row_exception('SEGMENT4_LOW',tlinfo.SEGMENT4_LOW);
710: END IF;
711:
712: IF NOT ((tlinfo.SEGMENT4_HIGH = x_SEGMENT4_HIGH )
713: OR ((tlinfo.SEGMENT4_HIGH IS NULL) AND (x_SEGMENT4_HIGH IS NULL))) THEN

Line 714: pn_var_rent_pkg.lock_row_exception('SEGMENT4_HIGH',tlinfo.SEGMENT4_HIGH);

710: END IF;
711:
712: IF NOT ((tlinfo.SEGMENT4_HIGH = x_SEGMENT4_HIGH )
713: OR ((tlinfo.SEGMENT4_HIGH IS NULL) AND (x_SEGMENT4_HIGH IS NULL))) THEN
714: pn_var_rent_pkg.lock_row_exception('SEGMENT4_HIGH',tlinfo.SEGMENT4_HIGH);
715: END IF;
716:
717: IF NOT ((tlinfo.SEGMENT5_LOW = x_SEGMENT5_LOW )
718: OR ((tlinfo.SEGMENT5_LOW IS NULL) AND (x_SEGMENT5_LOW IS NULL))) THEN

Line 719: pn_var_rent_pkg.lock_row_exception('SEGMENT5_LOW',tlinfo.SEGMENT5_LOW);

715: END IF;
716:
717: IF NOT ((tlinfo.SEGMENT5_LOW = x_SEGMENT5_LOW )
718: OR ((tlinfo.SEGMENT5_LOW IS NULL) AND (x_SEGMENT5_LOW IS NULL))) THEN
719: pn_var_rent_pkg.lock_row_exception('SEGMENT5_LOW',tlinfo.SEGMENT5_LOW);
720: END IF;
721:
722: IF NOT ((tlinfo.SEGMENT5_HIGH = x_SEGMENT5_HIGH )
723: OR ((tlinfo.SEGMENT5_HIGH IS NULL) AND (x_SEGMENT5_HIGH IS NULL))) THEN

Line 724: pn_var_rent_pkg.lock_row_exception('SEGMENT5_HIGH',tlinfo.SEGMENT5_HIGH);

720: END IF;
721:
722: IF NOT ((tlinfo.SEGMENT5_HIGH = x_SEGMENT5_HIGH )
723: OR ((tlinfo.SEGMENT5_HIGH IS NULL) AND (x_SEGMENT5_HIGH IS NULL))) THEN
724: pn_var_rent_pkg.lock_row_exception('SEGMENT5_HIGH',tlinfo.SEGMENT5_HIGH);
725: END IF;
726:
727: IF NOT ((tlinfo.SEGMENT6_LOW = x_SEGMENT6_LOW )
728: OR ((tlinfo.SEGMENT6_LOW IS NULL) AND (x_SEGMENT6_LOW IS NULL))) THEN

Line 729: pn_var_rent_pkg.lock_row_exception('SEGMENT6_LOW',tlinfo.SEGMENT6_LOW);

725: END IF;
726:
727: IF NOT ((tlinfo.SEGMENT6_LOW = x_SEGMENT6_LOW )
728: OR ((tlinfo.SEGMENT6_LOW IS NULL) AND (x_SEGMENT6_LOW IS NULL))) THEN
729: pn_var_rent_pkg.lock_row_exception('SEGMENT6_LOW',tlinfo.SEGMENT6_LOW);
730: END IF;
731:
732: IF NOT ((tlinfo.SEGMENT6_HIGH = x_SEGMENT6_HIGH )
733: OR ((tlinfo.SEGMENT6_HIGH IS NULL) AND (x_SEGMENT6_HIGH IS NULL))) THEN

Line 734: pn_var_rent_pkg.lock_row_exception('SEGMENT6_HIGH',tlinfo.SEGMENT6_HIGH);

730: END IF;
731:
732: IF NOT ((tlinfo.SEGMENT6_HIGH = x_SEGMENT6_HIGH )
733: OR ((tlinfo.SEGMENT6_HIGH IS NULL) AND (x_SEGMENT6_HIGH IS NULL))) THEN
734: pn_var_rent_pkg.lock_row_exception('SEGMENT6_HIGH',tlinfo.SEGMENT6_HIGH);
735: END IF;
736:
737: IF NOT ((tlinfo.SEGMENT7_LOW = x_SEGMENT7_LOW )
738: OR ((tlinfo.SEGMENT7_LOW IS NULL) AND (x_SEGMENT7_LOW IS NULL))) THEN

Line 739: pn_var_rent_pkg.lock_row_exception('SEGMENT7_LOW',tlinfo.SEGMENT7_LOW);

735: END IF;
736:
737: IF NOT ((tlinfo.SEGMENT7_LOW = x_SEGMENT7_LOW )
738: OR ((tlinfo.SEGMENT7_LOW IS NULL) AND (x_SEGMENT7_LOW IS NULL))) THEN
739: pn_var_rent_pkg.lock_row_exception('SEGMENT7_LOW',tlinfo.SEGMENT7_LOW);
740: END IF;
741:
742: IF NOT ((tlinfo.SEGMENT7_HIGH = x_SEGMENT7_HIGH )
743: OR ((tlinfo.SEGMENT7_HIGH IS NULL) AND (x_SEGMENT7_HIGH IS NULL))) THEN

Line 744: pn_var_rent_pkg.lock_row_exception('SEGMENT7_HIGH',tlinfo.SEGMENT7_HIGH);

740: END IF;
741:
742: IF NOT ((tlinfo.SEGMENT7_HIGH = x_SEGMENT7_HIGH )
743: OR ((tlinfo.SEGMENT7_HIGH IS NULL) AND (x_SEGMENT7_HIGH IS NULL))) THEN
744: pn_var_rent_pkg.lock_row_exception('SEGMENT7_HIGH',tlinfo.SEGMENT7_HIGH);
745: END IF;
746:
747: IF NOT ((tlinfo.SEGMENT8_LOW = x_SEGMENT8_LOW )
748: OR ((tlinfo.SEGMENT8_LOW IS NULL) AND (x_SEGMENT8_LOW IS NULL))) THEN

Line 749: pn_var_rent_pkg.lock_row_exception('SEGMENT8_LOW',tlinfo.SEGMENT8_LOW);

745: END IF;
746:
747: IF NOT ((tlinfo.SEGMENT8_LOW = x_SEGMENT8_LOW )
748: OR ((tlinfo.SEGMENT8_LOW IS NULL) AND (x_SEGMENT8_LOW IS NULL))) THEN
749: pn_var_rent_pkg.lock_row_exception('SEGMENT8_LOW',tlinfo.SEGMENT8_LOW);
750: END IF;
751:
752: IF NOT ((tlinfo.SEGMENT8_HIGH = x_SEGMENT8_HIGH )
753: OR ((tlinfo.SEGMENT8_HIGH IS NULL) AND (x_SEGMENT8_HIGH IS NULL))) THEN

Line 754: pn_var_rent_pkg.lock_row_exception('SEGMENT8_HIGH',tlinfo.SEGMENT8_HIGH);

750: END IF;
751:
752: IF NOT ((tlinfo.SEGMENT8_HIGH = x_SEGMENT8_HIGH )
753: OR ((tlinfo.SEGMENT8_HIGH IS NULL) AND (x_SEGMENT8_HIGH IS NULL))) THEN
754: pn_var_rent_pkg.lock_row_exception('SEGMENT8_HIGH',tlinfo.SEGMENT8_HIGH);
755: END IF;
756:
757: IF NOT ((tlinfo.SEGMENT9_LOW = x_SEGMENT9_LOW )
758: OR ((tlinfo.SEGMENT9_LOW IS NULL) AND (x_SEGMENT9_LOW IS NULL))) THEN

Line 759: pn_var_rent_pkg.lock_row_exception('SEGMENT9_LOW',tlinfo.SEGMENT9_LOW);

755: END IF;
756:
757: IF NOT ((tlinfo.SEGMENT9_LOW = x_SEGMENT9_LOW )
758: OR ((tlinfo.SEGMENT9_LOW IS NULL) AND (x_SEGMENT9_LOW IS NULL))) THEN
759: pn_var_rent_pkg.lock_row_exception('SEGMENT9_LOW',tlinfo.SEGMENT9_LOW);
760: END IF;
761:
762: IF NOT ((tlinfo.SEGMENT9_HIGH = x_SEGMENT9_HIGH )
763: OR ((tlinfo.SEGMENT9_HIGH IS NULL) AND (x_SEGMENT9_HIGH IS NULL))) THEN

Line 764: pn_var_rent_pkg.lock_row_exception('SEGMENT9_HIGH',tlinfo.SEGMENT9_HIGH);

760: END IF;
761:
762: IF NOT ((tlinfo.SEGMENT9_HIGH = x_SEGMENT9_HIGH )
763: OR ((tlinfo.SEGMENT9_HIGH IS NULL) AND (x_SEGMENT9_HIGH IS NULL))) THEN
764: pn_var_rent_pkg.lock_row_exception('SEGMENT9_HIGH',tlinfo.SEGMENT9_HIGH);
765: END IF;
766:
767: IF NOT ((tlinfo.SEGMENT10_LOW = x_SEGMENT10_LOW )
768: OR ((tlinfo.SEGMENT10_LOW IS NULL) AND (x_SEGMENT10_LOW IS NULL))) THEN

Line 769: pn_var_rent_pkg.lock_row_exception('SEGMENT10_LOW',tlinfo.SEGMENT10_LOW);

765: END IF;
766:
767: IF NOT ((tlinfo.SEGMENT10_LOW = x_SEGMENT10_LOW )
768: OR ((tlinfo.SEGMENT10_LOW IS NULL) AND (x_SEGMENT10_LOW IS NULL))) THEN
769: pn_var_rent_pkg.lock_row_exception('SEGMENT10_LOW',tlinfo.SEGMENT10_LOW);
770: END IF;
771:
772: IF NOT ((tlinfo.SEGMENT10_HIGH = x_SEGMENT10_HIGH )
773: OR ((tlinfo.SEGMENT10_HIGH IS NULL) AND (x_SEGMENT10_HIGH IS NULL))) THEN

Line 774: pn_var_rent_pkg.lock_row_exception('SEGMENT10_HIGH',tlinfo.SEGMENT10_HIGH);

770: END IF;
771:
772: IF NOT ((tlinfo.SEGMENT10_HIGH = x_SEGMENT10_HIGH )
773: OR ((tlinfo.SEGMENT10_HIGH IS NULL) AND (x_SEGMENT10_HIGH IS NULL))) THEN
774: pn_var_rent_pkg.lock_row_exception('SEGMENT10_HIGH',tlinfo.SEGMENT10_HIGH);
775: END IF;
776:
777: IF NOT ((tlinfo.SEGMENT11_LOW = x_SEGMENT11_LOW )
778: OR ((tlinfo.SEGMENT11_LOW IS NULL) AND (x_SEGMENT11_LOW IS NULL))) THEN

Line 779: pn_var_rent_pkg.lock_row_exception('SEGMENT11_LOW',tlinfo.SEGMENT11_LOW);

775: END IF;
776:
777: IF NOT ((tlinfo.SEGMENT11_LOW = x_SEGMENT11_LOW )
778: OR ((tlinfo.SEGMENT11_LOW IS NULL) AND (x_SEGMENT11_LOW IS NULL))) THEN
779: pn_var_rent_pkg.lock_row_exception('SEGMENT11_LOW',tlinfo.SEGMENT11_LOW);
780: END IF;
781:
782: IF NOT ((tlinfo.SEGMENT11_HIGH = x_SEGMENT11_HIGH )
783: OR ((tlinfo.SEGMENT11_HIGH IS NULL) AND (x_SEGMENT11_HIGH IS NULL))) THEN

Line 784: pn_var_rent_pkg.lock_row_exception('SEGMENT11_HIGH',tlinfo.SEGMENT11_HIGH);

780: END IF;
781:
782: IF NOT ((tlinfo.SEGMENT11_HIGH = x_SEGMENT11_HIGH )
783: OR ((tlinfo.SEGMENT11_HIGH IS NULL) AND (x_SEGMENT11_HIGH IS NULL))) THEN
784: pn_var_rent_pkg.lock_row_exception('SEGMENT11_HIGH',tlinfo.SEGMENT11_HIGH);
785: END IF;
786:
787: IF NOT ((tlinfo.SEGMENT12_LOW = x_SEGMENT12_LOW )
788: OR ((tlinfo.SEGMENT12_LOW IS NULL) AND (x_SEGMENT12_LOW IS NULL))) THEN

Line 789: pn_var_rent_pkg.lock_row_exception('SEGMENT12_LOW',tlinfo.SEGMENT12_LOW);

785: END IF;
786:
787: IF NOT ((tlinfo.SEGMENT12_LOW = x_SEGMENT12_LOW )
788: OR ((tlinfo.SEGMENT12_LOW IS NULL) AND (x_SEGMENT12_LOW IS NULL))) THEN
789: pn_var_rent_pkg.lock_row_exception('SEGMENT12_LOW',tlinfo.SEGMENT12_LOW);
790: END IF;
791:
792: IF NOT ((tlinfo.SEGMENT12_HIGH = x_SEGMENT12_HIGH )
793: OR ((tlinfo.SEGMENT12_HIGH IS NULL) AND (x_SEGMENT12_HIGH IS NULL))) THEN

Line 794: pn_var_rent_pkg.lock_row_exception('SEGMENT12_HIGH',tlinfo.SEGMENT12_HIGH);

790: END IF;
791:
792: IF NOT ((tlinfo.SEGMENT12_HIGH = x_SEGMENT12_HIGH )
793: OR ((tlinfo.SEGMENT12_HIGH IS NULL) AND (x_SEGMENT12_HIGH IS NULL))) THEN
794: pn_var_rent_pkg.lock_row_exception('SEGMENT12_HIGH',tlinfo.SEGMENT12_HIGH);
795: END IF;
796:
797: IF NOT ((tlinfo.SEGMENT13_LOW = x_SEGMENT13_LOW )
798: OR ((tlinfo.SEGMENT13_LOW IS NULL) AND (x_SEGMENT13_LOW IS NULL))) THEN

Line 799: pn_var_rent_pkg.lock_row_exception('SEGMENT13_LOW',tlinfo.SEGMENT13_LOW);

795: END IF;
796:
797: IF NOT ((tlinfo.SEGMENT13_LOW = x_SEGMENT13_LOW )
798: OR ((tlinfo.SEGMENT13_LOW IS NULL) AND (x_SEGMENT13_LOW IS NULL))) THEN
799: pn_var_rent_pkg.lock_row_exception('SEGMENT13_LOW',tlinfo.SEGMENT13_LOW);
800: END IF;
801:
802: IF NOT ((tlinfo.SEGMENT13_HIGH = x_SEGMENT13_HIGH )
803: OR ((tlinfo.SEGMENT13_HIGH IS NULL) AND (x_SEGMENT13_HIGH IS NULL))) THEN

Line 804: pn_var_rent_pkg.lock_row_exception('SEGMENT13_HIGH',tlinfo.SEGMENT13_HIGH);

800: END IF;
801:
802: IF NOT ((tlinfo.SEGMENT13_HIGH = x_SEGMENT13_HIGH )
803: OR ((tlinfo.SEGMENT13_HIGH IS NULL) AND (x_SEGMENT13_HIGH IS NULL))) THEN
804: pn_var_rent_pkg.lock_row_exception('SEGMENT13_HIGH',tlinfo.SEGMENT13_HIGH);
805: END IF;
806:
807: IF NOT ((tlinfo.SEGMENT14_LOW = x_SEGMENT14_LOW )
808: OR ((tlinfo.SEGMENT14_LOW IS NULL) AND (x_SEGMENT14_LOW IS NULL))) THEN

Line 809: pn_var_rent_pkg.lock_row_exception('SEGMENT14_LOW',tlinfo.SEGMENT14_LOW);

805: END IF;
806:
807: IF NOT ((tlinfo.SEGMENT14_LOW = x_SEGMENT14_LOW )
808: OR ((tlinfo.SEGMENT14_LOW IS NULL) AND (x_SEGMENT14_LOW IS NULL))) THEN
809: pn_var_rent_pkg.lock_row_exception('SEGMENT14_LOW',tlinfo.SEGMENT14_LOW);
810: END IF;
811:
812: IF NOT ((tlinfo.SEGMENT14_HIGH = x_SEGMENT14_HIGH )
813: OR ((tlinfo.SEGMENT14_HIGH IS NULL) AND (x_SEGMENT14_HIGH IS NULL))) THEN

Line 814: pn_var_rent_pkg.lock_row_exception('SEGMENT14_HIGH',tlinfo.SEGMENT14_HIGH);

810: END IF;
811:
812: IF NOT ((tlinfo.SEGMENT14_HIGH = x_SEGMENT14_HIGH )
813: OR ((tlinfo.SEGMENT14_HIGH IS NULL) AND (x_SEGMENT14_HIGH IS NULL))) THEN
814: pn_var_rent_pkg.lock_row_exception('SEGMENT14_HIGH',tlinfo.SEGMENT14_HIGH);
815: END IF;
816:
817: IF NOT ((tlinfo.SEGMENT15_LOW = x_SEGMENT15_LOW )
818: OR ((tlinfo.SEGMENT15_LOW IS NULL) AND (x_SEGMENT15_LOW IS NULL))) THEN

Line 819: pn_var_rent_pkg.lock_row_exception('SEGMENT15_LOW',tlinfo.SEGMENT15_LOW);

815: END IF;
816:
817: IF NOT ((tlinfo.SEGMENT15_LOW = x_SEGMENT15_LOW )
818: OR ((tlinfo.SEGMENT15_LOW IS NULL) AND (x_SEGMENT15_LOW IS NULL))) THEN
819: pn_var_rent_pkg.lock_row_exception('SEGMENT15_LOW',tlinfo.SEGMENT15_LOW);
820: END IF;
821:
822: IF NOT ((tlinfo.SEGMENT15_HIGH = x_SEGMENT15_HIGH )
823: OR ((tlinfo.SEGMENT15_HIGH IS NULL) AND (x_SEGMENT15_HIGH IS NULL))) THEN

Line 824: pn_var_rent_pkg.lock_row_exception('SEGMENT15_HIGH',tlinfo.SEGMENT15_HIGH);

820: END IF;
821:
822: IF NOT ((tlinfo.SEGMENT15_HIGH = x_SEGMENT15_HIGH )
823: OR ((tlinfo.SEGMENT15_HIGH IS NULL) AND (x_SEGMENT15_HIGH IS NULL))) THEN
824: pn_var_rent_pkg.lock_row_exception('SEGMENT15_HIGH',tlinfo.SEGMENT15_HIGH);
825: END IF;
826:
827: IF NOT ((tlinfo.SEGMENT16_LOW = x_SEGMENT16_LOW )
828: OR ((tlinfo.SEGMENT16_LOW IS NULL) AND (x_SEGMENT16_LOW IS NULL))) THEN

Line 829: pn_var_rent_pkg.lock_row_exception('SEGMENT16_LOW',tlinfo.SEGMENT16_LOW);

825: END IF;
826:
827: IF NOT ((tlinfo.SEGMENT16_LOW = x_SEGMENT16_LOW )
828: OR ((tlinfo.SEGMENT16_LOW IS NULL) AND (x_SEGMENT16_LOW IS NULL))) THEN
829: pn_var_rent_pkg.lock_row_exception('SEGMENT16_LOW',tlinfo.SEGMENT16_LOW);
830: END IF;
831:
832: IF NOT ((tlinfo.SEGMENT16_HIGH = x_SEGMENT16_HIGH )
833: OR ((tlinfo.SEGMENT16_HIGH IS NULL) AND (x_SEGMENT16_HIGH IS NULL))) THEN

Line 834: pn_var_rent_pkg.lock_row_exception('SEGMENT16_HIGH',tlinfo.SEGMENT16_HIGH);

830: END IF;
831:
832: IF NOT ((tlinfo.SEGMENT16_HIGH = x_SEGMENT16_HIGH )
833: OR ((tlinfo.SEGMENT16_HIGH IS NULL) AND (x_SEGMENT16_HIGH IS NULL))) THEN
834: pn_var_rent_pkg.lock_row_exception('SEGMENT16_HIGH',tlinfo.SEGMENT16_HIGH);
835: END IF;
836:
837: IF NOT ((tlinfo.SEGMENT17_LOW = x_SEGMENT17_LOW )
838: OR ((tlinfo.SEGMENT17_LOW IS NULL) AND (x_SEGMENT17_LOW IS NULL))) THEN

Line 839: pn_var_rent_pkg.lock_row_exception('SEGMENT17_LOW',tlinfo.SEGMENT17_LOW);

835: END IF;
836:
837: IF NOT ((tlinfo.SEGMENT17_LOW = x_SEGMENT17_LOW )
838: OR ((tlinfo.SEGMENT17_LOW IS NULL) AND (x_SEGMENT17_LOW IS NULL))) THEN
839: pn_var_rent_pkg.lock_row_exception('SEGMENT17_LOW',tlinfo.SEGMENT17_LOW);
840: END IF;
841:
842: IF NOT ((tlinfo.SEGMENT17_HIGH = x_SEGMENT17_HIGH )
843: OR ((tlinfo.SEGMENT17_HIGH IS NULL) AND (x_SEGMENT17_HIGH IS NULL))) THEN

Line 844: pn_var_rent_pkg.lock_row_exception('SEGMENT17_HIGH',tlinfo.SEGMENT17_HIGH);

840: END IF;
841:
842: IF NOT ((tlinfo.SEGMENT17_HIGH = x_SEGMENT17_HIGH )
843: OR ((tlinfo.SEGMENT17_HIGH IS NULL) AND (x_SEGMENT17_HIGH IS NULL))) THEN
844: pn_var_rent_pkg.lock_row_exception('SEGMENT17_HIGH',tlinfo.SEGMENT17_HIGH);
845: END IF;
846:
847: IF NOT ((tlinfo.SEGMENT18_LOW = x_SEGMENT18_LOW )
848: OR ((tlinfo.SEGMENT18_LOW IS NULL) AND (x_SEGMENT18_LOW IS NULL))) THEN

Line 849: pn_var_rent_pkg.lock_row_exception('SEGMENT18_LOW',tlinfo.SEGMENT18_LOW);

845: END IF;
846:
847: IF NOT ((tlinfo.SEGMENT18_LOW = x_SEGMENT18_LOW )
848: OR ((tlinfo.SEGMENT18_LOW IS NULL) AND (x_SEGMENT18_LOW IS NULL))) THEN
849: pn_var_rent_pkg.lock_row_exception('SEGMENT18_LOW',tlinfo.SEGMENT18_LOW);
850: END IF;
851:
852: IF NOT ((tlinfo.SEGMENT18_HIGH = x_SEGMENT18_HIGH )
853: OR ((tlinfo.SEGMENT18_HIGH IS NULL) AND (x_SEGMENT18_HIGH IS NULL))) THEN

Line 854: pn_var_rent_pkg.lock_row_exception('SEGMENT18_HIGH',tlinfo.SEGMENT18_HIGH);

850: END IF;
851:
852: IF NOT ((tlinfo.SEGMENT18_HIGH = x_SEGMENT18_HIGH )
853: OR ((tlinfo.SEGMENT18_HIGH IS NULL) AND (x_SEGMENT18_HIGH IS NULL))) THEN
854: pn_var_rent_pkg.lock_row_exception('SEGMENT18_HIGH',tlinfo.SEGMENT18_HIGH);
855: END IF;
856:
857: IF NOT ((tlinfo.SEGMENT19_LOW = x_SEGMENT19_LOW )
858: OR ((tlinfo.SEGMENT19_LOW IS NULL) AND (x_SEGMENT19_LOW IS NULL))) THEN

Line 859: pn_var_rent_pkg.lock_row_exception('SEGMENT19_LOW',tlinfo.SEGMENT19_LOW);

855: END IF;
856:
857: IF NOT ((tlinfo.SEGMENT19_LOW = x_SEGMENT19_LOW )
858: OR ((tlinfo.SEGMENT19_LOW IS NULL) AND (x_SEGMENT19_LOW IS NULL))) THEN
859: pn_var_rent_pkg.lock_row_exception('SEGMENT19_LOW',tlinfo.SEGMENT19_LOW);
860: END IF;
861:
862: IF NOT ((tlinfo.SEGMENT19_HIGH = x_SEGMENT19_HIGH )
863: OR ((tlinfo.SEGMENT19_HIGH IS NULL) AND (x_SEGMENT19_HIGH IS NULL))) THEN

Line 864: pn_var_rent_pkg.lock_row_exception('SEGMENT19_HIGH',tlinfo.SEGMENT19_HIGH);

860: END IF;
861:
862: IF NOT ((tlinfo.SEGMENT19_HIGH = x_SEGMENT19_HIGH )
863: OR ((tlinfo.SEGMENT19_HIGH IS NULL) AND (x_SEGMENT19_HIGH IS NULL))) THEN
864: pn_var_rent_pkg.lock_row_exception('SEGMENT19_HIGH',tlinfo.SEGMENT19_HIGH);
865: END IF;
866:
867: IF NOT ((tlinfo.SEGMENT20_LOW = x_SEGMENT20_LOW )
868: OR ((tlinfo.SEGMENT20_LOW IS NULL) AND (x_SEGMENT20_LOW IS NULL))) THEN

Line 869: pn_var_rent_pkg.lock_row_exception('SEGMENT20_LOW',tlinfo.SEGMENT20_LOW);

865: END IF;
866:
867: IF NOT ((tlinfo.SEGMENT20_LOW = x_SEGMENT20_LOW )
868: OR ((tlinfo.SEGMENT20_LOW IS NULL) AND (x_SEGMENT20_LOW IS NULL))) THEN
869: pn_var_rent_pkg.lock_row_exception('SEGMENT20_LOW',tlinfo.SEGMENT20_LOW);
870: END IF;
871:
872: IF NOT ((tlinfo.SEGMENT20_HIGH = x_SEGMENT20_HIGH )
873: OR ((tlinfo.SEGMENT20_HIGH IS NULL) AND (x_SEGMENT20_HIGH IS NULL))) THEN

Line 874: pn_var_rent_pkg.lock_row_exception('SEGMENT20_HIGH',tlinfo.SEGMENT20_HIGH);

870: END IF;
871:
872: IF NOT ((tlinfo.SEGMENT20_HIGH = x_SEGMENT20_HIGH )
873: OR ((tlinfo.SEGMENT20_HIGH IS NULL) AND (x_SEGMENT20_HIGH IS NULL))) THEN
874: pn_var_rent_pkg.lock_row_exception('SEGMENT20_HIGH',tlinfo.SEGMENT20_HIGH);
875: END IF;
876:
877: IF NOT ((tlinfo.SEGMENT21_LOW = x_SEGMENT21_LOW )
878: OR ((tlinfo.SEGMENT21_LOW IS NULL) AND (x_SEGMENT21_LOW IS NULL))) THEN

Line 879: pn_var_rent_pkg.lock_row_exception('SEGMENT21_LOW',tlinfo.SEGMENT21_LOW);

875: END IF;
876:
877: IF NOT ((tlinfo.SEGMENT21_LOW = x_SEGMENT21_LOW )
878: OR ((tlinfo.SEGMENT21_LOW IS NULL) AND (x_SEGMENT21_LOW IS NULL))) THEN
879: pn_var_rent_pkg.lock_row_exception('SEGMENT21_LOW',tlinfo.SEGMENT21_LOW);
880: END IF;
881:
882: IF NOT ((tlinfo.SEGMENT21_HIGH = x_SEGMENT21_HIGH )
883: OR ((tlinfo.SEGMENT21_HIGH IS NULL) AND (x_SEGMENT21_HIGH IS NULL))) THEN

Line 884: pn_var_rent_pkg.lock_row_exception('SEGMENT21_HIGH',tlinfo.SEGMENT21_HIGH);

880: END IF;
881:
882: IF NOT ((tlinfo.SEGMENT21_HIGH = x_SEGMENT21_HIGH )
883: OR ((tlinfo.SEGMENT21_HIGH IS NULL) AND (x_SEGMENT21_HIGH IS NULL))) THEN
884: pn_var_rent_pkg.lock_row_exception('SEGMENT21_HIGH',tlinfo.SEGMENT21_HIGH);
885: END IF;
886:
887: IF NOT ((tlinfo.SEGMENT22_LOW = x_SEGMENT22_LOW )
888: OR ((tlinfo.SEGMENT22_LOW IS NULL) AND (x_SEGMENT22_LOW IS NULL))) THEN

Line 889: pn_var_rent_pkg.lock_row_exception('SEGMENT22_LOW',tlinfo.SEGMENT22_LOW);

885: END IF;
886:
887: IF NOT ((tlinfo.SEGMENT22_LOW = x_SEGMENT22_LOW )
888: OR ((tlinfo.SEGMENT22_LOW IS NULL) AND (x_SEGMENT22_LOW IS NULL))) THEN
889: pn_var_rent_pkg.lock_row_exception('SEGMENT22_LOW',tlinfo.SEGMENT22_LOW);
890: END IF;
891:
892: IF NOT ((tlinfo.SEGMENT22_HIGH = x_SEGMENT22_HIGH )
893: OR ((tlinfo.SEGMENT22_HIGH IS NULL) AND (x_SEGMENT22_HIGH IS NULL))) THEN

Line 894: pn_var_rent_pkg.lock_row_exception('SEGMENT22_HIGH',tlinfo.SEGMENT22_HIGH);

890: END IF;
891:
892: IF NOT ((tlinfo.SEGMENT22_HIGH = x_SEGMENT22_HIGH )
893: OR ((tlinfo.SEGMENT22_HIGH IS NULL) AND (x_SEGMENT22_HIGH IS NULL))) THEN
894: pn_var_rent_pkg.lock_row_exception('SEGMENT22_HIGH',tlinfo.SEGMENT22_HIGH);
895: END IF;
896:
897: IF NOT ((tlinfo.SEGMENT23_LOW = x_SEGMENT23_LOW )
898: OR ((tlinfo.SEGMENT23_LOW IS NULL) AND (x_SEGMENT23_LOW IS NULL))) THEN

Line 899: pn_var_rent_pkg.lock_row_exception('SEGMENT23_LOW',tlinfo.SEGMENT23_LOW);

895: END IF;
896:
897: IF NOT ((tlinfo.SEGMENT23_LOW = x_SEGMENT23_LOW )
898: OR ((tlinfo.SEGMENT23_LOW IS NULL) AND (x_SEGMENT23_LOW IS NULL))) THEN
899: pn_var_rent_pkg.lock_row_exception('SEGMENT23_LOW',tlinfo.SEGMENT23_LOW);
900: END IF;
901:
902: IF NOT ((tlinfo.SEGMENT23_HIGH = x_SEGMENT23_HIGH )
903: OR ((tlinfo.SEGMENT23_HIGH IS NULL) AND (x_SEGMENT23_HIGH IS NULL))) THEN

Line 904: pn_var_rent_pkg.lock_row_exception('SEGMENT23_HIGH',tlinfo.SEGMENT23_HIGH);

900: END IF;
901:
902: IF NOT ((tlinfo.SEGMENT23_HIGH = x_SEGMENT23_HIGH )
903: OR ((tlinfo.SEGMENT23_HIGH IS NULL) AND (x_SEGMENT23_HIGH IS NULL))) THEN
904: pn_var_rent_pkg.lock_row_exception('SEGMENT23_HIGH',tlinfo.SEGMENT23_HIGH);
905: END IF;
906:
907: IF NOT ((tlinfo.SEGMENT24_LOW = x_SEGMENT24_LOW )
908: OR ((tlinfo.SEGMENT24_LOW IS NULL) AND (x_SEGMENT24_LOW IS NULL))) THEN

Line 909: pn_var_rent_pkg.lock_row_exception('SEGMENT24_LOW',tlinfo.SEGMENT24_LOW);

905: END IF;
906:
907: IF NOT ((tlinfo.SEGMENT24_LOW = x_SEGMENT24_LOW )
908: OR ((tlinfo.SEGMENT24_LOW IS NULL) AND (x_SEGMENT24_LOW IS NULL))) THEN
909: pn_var_rent_pkg.lock_row_exception('SEGMENT24_LOW',tlinfo.SEGMENT24_LOW);
910: END IF;
911:
912: IF NOT ((tlinfo.SEGMENT24_HIGH = x_SEGMENT24_HIGH )
913: OR ((tlinfo.SEGMENT24_HIGH IS NULL) AND (x_SEGMENT24_HIGH IS NULL))) THEN

Line 914: pn_var_rent_pkg.lock_row_exception('SEGMENT24_HIGH',tlinfo.SEGMENT24_HIGH);

910: END IF;
911:
912: IF NOT ((tlinfo.SEGMENT24_HIGH = x_SEGMENT24_HIGH )
913: OR ((tlinfo.SEGMENT24_HIGH IS NULL) AND (x_SEGMENT24_HIGH IS NULL))) THEN
914: pn_var_rent_pkg.lock_row_exception('SEGMENT24_HIGH',tlinfo.SEGMENT24_HIGH);
915: END IF;
916:
917: IF NOT ((tlinfo.SEGMENT25_LOW = x_SEGMENT25_LOW )
918: OR ((tlinfo.SEGMENT25_LOW IS NULL) AND (x_SEGMENT25_LOW IS NULL))) THEN

Line 919: pn_var_rent_pkg.lock_row_exception('SEGMENT25_LOW',tlinfo.SEGMENT25_LOW);

915: END IF;
916:
917: IF NOT ((tlinfo.SEGMENT25_LOW = x_SEGMENT25_LOW )
918: OR ((tlinfo.SEGMENT25_LOW IS NULL) AND (x_SEGMENT25_LOW IS NULL))) THEN
919: pn_var_rent_pkg.lock_row_exception('SEGMENT25_LOW',tlinfo.SEGMENT25_LOW);
920: END IF;
921:
922: IF NOT ((tlinfo.SEGMENT25_HIGH = x_SEGMENT25_HIGH )
923: OR ((tlinfo.SEGMENT25_HIGH IS NULL) AND (x_SEGMENT25_HIGH IS NULL))) THEN

Line 924: pn_var_rent_pkg.lock_row_exception('SEGMENT25_HIGH',tlinfo.SEGMENT25_HIGH);

920: END IF;
921:
922: IF NOT ((tlinfo.SEGMENT25_HIGH = x_SEGMENT25_HIGH )
923: OR ((tlinfo.SEGMENT25_HIGH IS NULL) AND (x_SEGMENT25_HIGH IS NULL))) THEN
924: pn_var_rent_pkg.lock_row_exception('SEGMENT25_HIGH',tlinfo.SEGMENT25_HIGH);
925: END IF;
926:
927: IF NOT ((tlinfo.SEGMENT26_LOW = x_SEGMENT26_LOW )
928: OR ((tlinfo.SEGMENT26_LOW IS NULL) AND (x_SEGMENT26_LOW IS NULL))) THEN

Line 929: pn_var_rent_pkg.lock_row_exception('SEGMENT26_LOW',tlinfo.SEGMENT26_LOW);

925: END IF;
926:
927: IF NOT ((tlinfo.SEGMENT26_LOW = x_SEGMENT26_LOW )
928: OR ((tlinfo.SEGMENT26_LOW IS NULL) AND (x_SEGMENT26_LOW IS NULL))) THEN
929: pn_var_rent_pkg.lock_row_exception('SEGMENT26_LOW',tlinfo.SEGMENT26_LOW);
930: END IF;
931:
932: IF NOT ((tlinfo.SEGMENT26_HIGH = x_SEGMENT26_HIGH )
933: OR ((tlinfo.SEGMENT26_HIGH IS NULL) AND (x_SEGMENT26_HIGH IS NULL))) THEN

Line 934: pn_var_rent_pkg.lock_row_exception('SEGMENT26_HIGH',tlinfo.SEGMENT26_HIGH);

930: END IF;
931:
932: IF NOT ((tlinfo.SEGMENT26_HIGH = x_SEGMENT26_HIGH )
933: OR ((tlinfo.SEGMENT26_HIGH IS NULL) AND (x_SEGMENT26_HIGH IS NULL))) THEN
934: pn_var_rent_pkg.lock_row_exception('SEGMENT26_HIGH',tlinfo.SEGMENT26_HIGH);
935: END IF;
936:
937: IF NOT ((tlinfo.SEGMENT27_LOW = x_SEGMENT27_LOW )
938: OR ((tlinfo.SEGMENT27_LOW IS NULL) AND (x_SEGMENT27_LOW IS NULL))) THEN

Line 939: pn_var_rent_pkg.lock_row_exception('SEGMENT27_LOW',tlinfo.SEGMENT27_LOW);

935: END IF;
936:
937: IF NOT ((tlinfo.SEGMENT27_LOW = x_SEGMENT27_LOW )
938: OR ((tlinfo.SEGMENT27_LOW IS NULL) AND (x_SEGMENT27_LOW IS NULL))) THEN
939: pn_var_rent_pkg.lock_row_exception('SEGMENT27_LOW',tlinfo.SEGMENT27_LOW);
940: END IF;
941:
942: IF NOT ((tlinfo.SEGMENT27_HIGH = x_SEGMENT27_HIGH )
943: OR ((tlinfo.SEGMENT27_HIGH IS NULL) AND (x_SEGMENT27_HIGH IS NULL))) THEN

Line 944: pn_var_rent_pkg.lock_row_exception('SEGMENT27_HIGH',tlinfo.SEGMENT27_HIGH);

940: END IF;
941:
942: IF NOT ((tlinfo.SEGMENT27_HIGH = x_SEGMENT27_HIGH )
943: OR ((tlinfo.SEGMENT27_HIGH IS NULL) AND (x_SEGMENT27_HIGH IS NULL))) THEN
944: pn_var_rent_pkg.lock_row_exception('SEGMENT27_HIGH',tlinfo.SEGMENT27_HIGH);
945: END IF;
946:
947: IF NOT ((tlinfo.SEGMENT28_LOW = x_SEGMENT28_LOW )
948: OR ((tlinfo.SEGMENT28_LOW IS NULL) AND (x_SEGMENT28_LOW IS NULL))) THEN

Line 949: pn_var_rent_pkg.lock_row_exception('SEGMENT28_LOW',tlinfo.SEGMENT28_LOW);

945: END IF;
946:
947: IF NOT ((tlinfo.SEGMENT28_LOW = x_SEGMENT28_LOW )
948: OR ((tlinfo.SEGMENT28_LOW IS NULL) AND (x_SEGMENT28_LOW IS NULL))) THEN
949: pn_var_rent_pkg.lock_row_exception('SEGMENT28_LOW',tlinfo.SEGMENT28_LOW);
950: END IF;
951:
952: IF NOT ((tlinfo.SEGMENT28_HIGH = x_SEGMENT28_HIGH )
953: OR ((tlinfo.SEGMENT28_HIGH IS NULL) AND (x_SEGMENT28_HIGH IS NULL))) THEN

Line 954: pn_var_rent_pkg.lock_row_exception('SEGMENT28_HIGH',tlinfo.SEGMENT28_HIGH);

950: END IF;
951:
952: IF NOT ((tlinfo.SEGMENT28_HIGH = x_SEGMENT28_HIGH )
953: OR ((tlinfo.SEGMENT28_HIGH IS NULL) AND (x_SEGMENT28_HIGH IS NULL))) THEN
954: pn_var_rent_pkg.lock_row_exception('SEGMENT28_HIGH',tlinfo.SEGMENT28_HIGH);
955: END IF;
956:
957: IF NOT ((tlinfo.SEGMENT29_LOW = x_SEGMENT29_LOW )
958: OR ((tlinfo.SEGMENT29_LOW IS NULL) AND (x_SEGMENT29_LOW IS NULL))) THEN

Line 959: pn_var_rent_pkg.lock_row_exception('SEGMENT29_LOW',tlinfo.SEGMENT29_LOW);

955: END IF;
956:
957: IF NOT ((tlinfo.SEGMENT29_LOW = x_SEGMENT29_LOW )
958: OR ((tlinfo.SEGMENT29_LOW IS NULL) AND (x_SEGMENT29_LOW IS NULL))) THEN
959: pn_var_rent_pkg.lock_row_exception('SEGMENT29_LOW',tlinfo.SEGMENT29_LOW);
960: END IF;
961:
962: IF NOT ((tlinfo.SEGMENT29_HIGH = x_SEGMENT29_HIGH )
963: OR ((tlinfo.SEGMENT29_HIGH IS NULL) AND (x_SEGMENT29_HIGH IS NULL))) THEN

Line 964: pn_var_rent_pkg.lock_row_exception('SEGMENT29_HIGH',tlinfo.SEGMENT29_HIGH);

960: END IF;
961:
962: IF NOT ((tlinfo.SEGMENT29_HIGH = x_SEGMENT29_HIGH )
963: OR ((tlinfo.SEGMENT29_HIGH IS NULL) AND (x_SEGMENT29_HIGH IS NULL))) THEN
964: pn_var_rent_pkg.lock_row_exception('SEGMENT29_HIGH',tlinfo.SEGMENT29_HIGH);
965: END IF;
966:
967: IF NOT ((tlinfo.SEGMENT30_LOW = x_SEGMENT30_LOW )
968: OR ((tlinfo.SEGMENT30_LOW IS NULL) AND (x_SEGMENT30_LOW IS NULL))) THEN

Line 969: pn_var_rent_pkg.lock_row_exception('SEGMENT30_LOW',tlinfo.SEGMENT30_LOW);

965: END IF;
966:
967: IF NOT ((tlinfo.SEGMENT30_LOW = x_SEGMENT30_LOW )
968: OR ((tlinfo.SEGMENT30_LOW IS NULL) AND (x_SEGMENT30_LOW IS NULL))) THEN
969: pn_var_rent_pkg.lock_row_exception('SEGMENT30_LOW',tlinfo.SEGMENT30_LOW);
970: END IF;
971:
972: IF NOT ((tlinfo.SEGMENT30_HIGH = x_SEGMENT30_HIGH )
973: OR ((tlinfo.SEGMENT30_HIGH IS NULL) AND (x_SEGMENT30_HIGH IS NULL))) THEN

Line 974: pn_var_rent_pkg.lock_row_exception('SEGMENT30_HIGH',tlinfo.SEGMENT30_HIGH);

970: END IF;
971:
972: IF NOT ((tlinfo.SEGMENT30_HIGH = x_SEGMENT30_HIGH )
973: OR ((tlinfo.SEGMENT30_HIGH IS NULL) AND (x_SEGMENT30_HIGH IS NULL))) THEN
974: pn_var_rent_pkg.lock_row_exception('SEGMENT30_HIGH',tlinfo.SEGMENT30_HIGH);
975: END IF;
976:
977: IF NOT ((tlinfo.attribute_category = x_attribute_category)
978: OR ((tlinfo.attribute_category is null) AND (x_attribute_category is null))) THEN

Line 979: pn_var_rent_pkg.lock_row_exception('attribute_category',tlinfo.attribute_category);

975: END IF;
976:
977: IF NOT ((tlinfo.attribute_category = x_attribute_category)
978: OR ((tlinfo.attribute_category is null) AND (x_attribute_category is null))) THEN
979: pn_var_rent_pkg.lock_row_exception('attribute_category',tlinfo.attribute_category);
980: END IF;
981:
982: IF NOT ((tlinfo.attribute1 = x_attribute1)
983: OR ((tlinfo.attribute1 is null) AND (x_attribute1 is null))) THEN

Line 984: pn_var_rent_pkg.lock_row_exception('attribute1',tlinfo.attribute1);

980: END IF;
981:
982: IF NOT ((tlinfo.attribute1 = x_attribute1)
983: OR ((tlinfo.attribute1 is null) AND (x_attribute1 is null))) THEN
984: pn_var_rent_pkg.lock_row_exception('attribute1',tlinfo.attribute1);
985: END IF;
986:
987: IF NOT ((tlinfo.attribute2 = x_attribute2)
988: OR ((tlinfo.attribute2 is null) AND (x_attribute2 is null))) THEN

Line 989: pn_var_rent_pkg.lock_row_exception('attribute2',tlinfo.attribute2);

985: END IF;
986:
987: IF NOT ((tlinfo.attribute2 = x_attribute2)
988: OR ((tlinfo.attribute2 is null) AND (x_attribute2 is null))) THEN
989: pn_var_rent_pkg.lock_row_exception('attribute2',tlinfo.attribute2);
990: END IF;
991:
992: IF NOT ((tlinfo.attribute3 = x_attribute3)
993: OR ((tlinfo.attribute3 is null) AND (x_attribute3 is null))) THEN

Line 994: pn_var_rent_pkg.lock_row_exception('attribute3',tlinfo.attribute3);

990: END IF;
991:
992: IF NOT ((tlinfo.attribute3 = x_attribute3)
993: OR ((tlinfo.attribute3 is null) AND (x_attribute3 is null))) THEN
994: pn_var_rent_pkg.lock_row_exception('attribute3',tlinfo.attribute3);
995: END IF;
996:
997: IF NOT ((tlinfo.attribute4 = x_attribute4)
998: OR ((tlinfo.attribute4 is null) AND (x_attribute4 is null))) THEN

Line 999: pn_var_rent_pkg.lock_row_exception('attribute4',tlinfo.attribute4);

995: END IF;
996:
997: IF NOT ((tlinfo.attribute4 = x_attribute4)
998: OR ((tlinfo.attribute4 is null) AND (x_attribute4 is null))) THEN
999: pn_var_rent_pkg.lock_row_exception('attribute4',tlinfo.attribute4);
1000: END IF;
1001:
1002: IF NOT ((tlinfo.attribute5 = x_attribute5)
1003: OR ((tlinfo.attribute5 is null) AND (x_attribute5 is null))) THEN

Line 1004: pn_var_rent_pkg.lock_row_exception('attribute5',tlinfo.attribute5);

1000: END IF;
1001:
1002: IF NOT ((tlinfo.attribute5 = x_attribute5)
1003: OR ((tlinfo.attribute5 is null) AND (x_attribute5 is null))) THEN
1004: pn_var_rent_pkg.lock_row_exception('attribute5',tlinfo.attribute5);
1005: END IF;
1006:
1007: IF NOT ((tlinfo.attribute6 = x_attribute6)
1008: OR ((tlinfo.attribute6 is null) AND (x_attribute6 is null))) THEN

Line 1009: pn_var_rent_pkg.lock_row_exception('attribute6',tlinfo.attribute6);

1005: END IF;
1006:
1007: IF NOT ((tlinfo.attribute6 = x_attribute6)
1008: OR ((tlinfo.attribute6 is null) AND (x_attribute6 is null))) THEN
1009: pn_var_rent_pkg.lock_row_exception('attribute6',tlinfo.attribute6);
1010: END IF;
1011:
1012: IF NOT ((tlinfo.attribute7 = x_attribute7)
1013: OR ((tlinfo.attribute7 is null) AND (x_attribute7 is null))) THEN

Line 1014: pn_var_rent_pkg.lock_row_exception('attribute7',tlinfo.attribute7);

1010: END IF;
1011:
1012: IF NOT ((tlinfo.attribute7 = x_attribute7)
1013: OR ((tlinfo.attribute7 is null) AND (x_attribute7 is null))) THEN
1014: pn_var_rent_pkg.lock_row_exception('attribute7',tlinfo.attribute7);
1015: END IF;
1016:
1017: IF NOT ((tlinfo.attribute8 = x_attribute8)
1018: OR ((tlinfo.attribute8 is null) AND (x_attribute8 is null))) THEN

Line 1019: pn_var_rent_pkg.lock_row_exception('attribute8',tlinfo.attribute8);

1015: END IF;
1016:
1017: IF NOT ((tlinfo.attribute8 = x_attribute8)
1018: OR ((tlinfo.attribute8 is null) AND (x_attribute8 is null))) THEN
1019: pn_var_rent_pkg.lock_row_exception('attribute8',tlinfo.attribute8);
1020: END IF;
1021:
1022: IF NOT ((tlinfo.attribute9 = x_attribute9)
1023: OR ((tlinfo.attribute9 is null) AND (x_attribute9 is null))) THEN

Line 1024: pn_var_rent_pkg.lock_row_exception('attribute9',tlinfo.attribute9);

1020: END IF;
1021:
1022: IF NOT ((tlinfo.attribute9 = x_attribute9)
1023: OR ((tlinfo.attribute9 is null) AND (x_attribute9 is null))) THEN
1024: pn_var_rent_pkg.lock_row_exception('attribute9',tlinfo.attribute9);
1025: END IF;
1026:
1027: IF NOT ((tlinfo.attribute10 = x_attribute10)
1028: OR ((tlinfo.attribute10 is null) AND (x_attribute10 is null))) THEN

Line 1029: pn_var_rent_pkg.lock_row_exception('attribute10',tlinfo.attribute10);

1025: END IF;
1026:
1027: IF NOT ((tlinfo.attribute10 = x_attribute10)
1028: OR ((tlinfo.attribute10 is null) AND (x_attribute10 is null))) THEN
1029: pn_var_rent_pkg.lock_row_exception('attribute10',tlinfo.attribute10);
1030: END IF;
1031:
1032: IF NOT ((tlinfo.attribute11 = x_attribute11)
1033: OR ((tlinfo.attribute11 is null) AND (x_attribute11 is null))) THEN

Line 1034: pn_var_rent_pkg.lock_row_exception('attribute11',tlinfo.attribute11);

1030: END IF;
1031:
1032: IF NOT ((tlinfo.attribute11 = x_attribute11)
1033: OR ((tlinfo.attribute11 is null) AND (x_attribute11 is null))) THEN
1034: pn_var_rent_pkg.lock_row_exception('attribute11',tlinfo.attribute11);
1035: END IF;
1036:
1037: IF NOT ((tlinfo.attribute12 = x_attribute12)
1038: OR ((tlinfo.attribute12 is null) AND (x_attribute12 is null))) THEN

Line 1039: pn_var_rent_pkg.lock_row_exception('attribute12',tlinfo.attribute12);

1035: END IF;
1036:
1037: IF NOT ((tlinfo.attribute12 = x_attribute12)
1038: OR ((tlinfo.attribute12 is null) AND (x_attribute12 is null))) THEN
1039: pn_var_rent_pkg.lock_row_exception('attribute12',tlinfo.attribute12);
1040: END IF;
1041:
1042: IF NOT ((tlinfo.attribute13 = x_attribute13)
1043: OR ((tlinfo.attribute13 is null) AND (x_attribute13 is null))) THEN

Line 1044: pn_var_rent_pkg.lock_row_exception('attribute13',tlinfo.attribute13);

1040: END IF;
1041:
1042: IF NOT ((tlinfo.attribute13 = x_attribute13)
1043: OR ((tlinfo.attribute13 is null) AND (x_attribute13 is null))) THEN
1044: pn_var_rent_pkg.lock_row_exception('attribute13',tlinfo.attribute13);
1045: END IF;
1046:
1047: IF NOT ((tlinfo.attribute14 = x_attribute14)
1048: OR ((tlinfo.attribute14 is null) AND (x_attribute14 is null))) THEN

Line 1049: pn_var_rent_pkg.lock_row_exception('attribute14',tlinfo.attribute14);

1045: END IF;
1046:
1047: IF NOT ((tlinfo.attribute14 = x_attribute14)
1048: OR ((tlinfo.attribute14 is null) AND (x_attribute14 is null))) THEN
1049: pn_var_rent_pkg.lock_row_exception('attribute14',tlinfo.attribute14);
1050: END IF;
1051:
1052: IF NOT ((tlinfo.attribute15 = x_attribute15)
1053: OR ((tlinfo.attribute15 is null) AND (x_attribute15 is null))) THEN

Line 1054: pn_var_rent_pkg.lock_row_exception('attribute15',tlinfo.attribute15);

1050: END IF;
1051:
1052: IF NOT ((tlinfo.attribute15 = x_attribute15)
1053: OR ((tlinfo.attribute15 is null) AND (x_attribute15 is null))) THEN
1054: pn_var_rent_pkg.lock_row_exception('attribute15',tlinfo.attribute15);
1055: END IF;
1056:
1057: END lock_row;
1058: