APPS.PN_INDEX_LEASES_PKG dependencies on PN_VAR_RENT_PKG

Line 623: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);

619: END IF;
620: CLOSE c1;
621:
622: IF NOT (tlinfo.index_lease_id = x_index_lease_id) THEN
623: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);
624: END IF;
625:
626: IF NOT (tlinfo.lease_id = x_lease_id) THEN
627: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.lease_id);

Line 627: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.lease_id);

623: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);
624: END IF;
625:
626: IF NOT (tlinfo.lease_id = x_lease_id) THEN
627: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.lease_id);
628: END IF;
629:
630: IF NOT (tlinfo.index_id = x_index_id) THEN
631: pn_var_rent_pkg.lock_row_exception('INDEX_ID',tlinfo.index_id);

Line 631: pn_var_rent_pkg.lock_row_exception('INDEX_ID',tlinfo.index_id);

627: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.lease_id);
628: END IF;
629:
630: IF NOT (tlinfo.index_id = x_index_id) THEN
631: pn_var_rent_pkg.lock_row_exception('INDEX_ID',tlinfo.index_id);
632: END IF;
633:
634: IF NOT (tlinfo.commencement_date = x_commencement_date) THEN
635: pn_var_rent_pkg.lock_row_exception('COMMENCEMENT_DATE',tlinfo.commencement_date);

Line 635: pn_var_rent_pkg.lock_row_exception('COMMENCEMENT_DATE',tlinfo.commencement_date);

631: pn_var_rent_pkg.lock_row_exception('INDEX_ID',tlinfo.index_id);
632: END IF;
633:
634: IF NOT (tlinfo.commencement_date = x_commencement_date) THEN
635: pn_var_rent_pkg.lock_row_exception('COMMENCEMENT_DATE',tlinfo.commencement_date);
636: END IF;
637:
638: IF NOT (tlinfo.termination_date = x_termination_date) THEN
639: pn_var_rent_pkg.lock_row_exception('tERMINATION_DATE',tlinfo.termination_date);

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

635: pn_var_rent_pkg.lock_row_exception('COMMENCEMENT_DATE',tlinfo.commencement_date);
636: END IF;
637:
638: IF NOT (tlinfo.termination_date = x_termination_date) THEN
639: pn_var_rent_pkg.lock_row_exception('tERMINATION_DATE',tlinfo.termination_date);
640: END IF;
641:
642: IF NOT (tlinfo.index_lease_number = x_index_lease_number) THEN
643: pn_var_rent_pkg.lock_row_exception('inDEX_LEASE_NUMBER',tlinfo.index_lease_number);

Line 643: pn_var_rent_pkg.lock_row_exception('inDEX_LEASE_NUMBER',tlinfo.index_lease_number);

639: pn_var_rent_pkg.lock_row_exception('tERMINATION_DATE',tlinfo.termination_date);
640: END IF;
641:
642: IF NOT (tlinfo.index_lease_number = x_index_lease_number) THEN
643: pn_var_rent_pkg.lock_row_exception('inDEX_LEASE_NUMBER',tlinfo.index_lease_number);
644: END IF;
645:
646: IF NOT ((tlinfo.location_id = x_location_id)
647: OR ((tlinfo.location_id IS NULL) AND x_location_id IS NULL)) THEN

Line 648: pn_var_rent_pkg.lock_row_exception('loCATION_ID',tlinfo.location_id);

644: END IF;
645:
646: IF NOT ((tlinfo.location_id = x_location_id)
647: OR ((tlinfo.location_id IS NULL) AND x_location_id IS NULL)) THEN
648: pn_var_rent_pkg.lock_row_exception('loCATION_ID',tlinfo.location_id);
649: END IF;
650:
651: IF NOT ((tlinfo.term_template_id = x_term_template_id)
652: OR ((tlinfo.term_template_id IS NULL) AND x_term_template_id IS NULL)) THEN

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

649: END IF;
650:
651: IF NOT ((tlinfo.term_template_id = x_term_template_id)
652: OR ((tlinfo.term_template_id IS NULL) AND x_term_template_id IS NULL)) THEN
653: pn_var_rent_pkg.lock_row_exception('TERM_TEMPLATE_ID',tlinfo.term_template_id);
654: END IF;
655:
656: IF NOT ((tlinfo.abstracted_by = x_abstracted_by)
657: OR ((tlinfo.abstracted_by IS NULL) AND x_abstracted_by IS NULL)) THEN

Line 658: pn_var_rent_pkg.lock_row_exception('ABSTRACTED_BY',tlinfo.abstracted_by);

654: END IF;
655:
656: IF NOT ((tlinfo.abstracted_by = x_abstracted_by)
657: OR ((tlinfo.abstracted_by IS NULL) AND x_abstracted_by IS NULL)) THEN
658: pn_var_rent_pkg.lock_row_exception('ABSTRACTED_BY',tlinfo.abstracted_by);
659: END IF;
660:
661: IF NOT ((tlinfo.assessment_date = x_assessment_date)
662: OR ((tlinfo.assessment_date IS NULL) AND x_assessment_date IS NULL)) THEN

Line 663: pn_var_rent_pkg.lock_row_exception('ASSESSMENT_DATE',tlinfo.assessment_date);

659: END IF;
660:
661: IF NOT ((tlinfo.assessment_date = x_assessment_date)
662: OR ((tlinfo.assessment_date IS NULL) AND x_assessment_date IS NULL)) THEN
663: pn_var_rent_pkg.lock_row_exception('ASSESSMENT_DATE',tlinfo.assessment_date);
664: END IF;
665:
666: IF NOT ((tlinfo.assessment_interval = x_assessment_interval)
667: OR ((tlinfo.assessment_interval IS NULL) AND x_assessment_interval IS NULL)) THEN

Line 668: pn_var_rent_pkg.lock_row_exception('ASSESSMENT_INTERVAL',tlinfo.assessment_interval);

664: END IF;
665:
666: IF NOT ((tlinfo.assessment_interval = x_assessment_interval)
667: OR ((tlinfo.assessment_interval IS NULL) AND x_assessment_interval IS NULL)) THEN
668: pn_var_rent_pkg.lock_row_exception('ASSESSMENT_INTERVAL',tlinfo.assessment_interval);
669: END IF;
670:
671: IF NOT ((tlinfo.spread_frequency = x_spread_frequency)
672: OR ((tlinfo.spread_frequency IS NULL) AND x_spread_frequency IS NULL)) THEN

Line 673: pn_var_rent_pkg.lock_row_exception('SPREAD_FREQUENCY',tlinfo.spread_frequency);

669: END IF;
670:
671: IF NOT ((tlinfo.spread_frequency = x_spread_frequency)
672: OR ((tlinfo.spread_frequency IS NULL) AND x_spread_frequency IS NULL)) THEN
673: pn_var_rent_pkg.lock_row_exception('SPREAD_FREQUENCY',tlinfo.spread_frequency);
674: END IF;
675:
676: IF NOT ((tlinfo.relationship_default = x_relationship_default)
677: OR ((tlinfo.relationship_default IS NULL) AND x_relationship_default IS NULL)) THEN

Line 678: pn_var_rent_pkg.lock_row_exception('RELATIONSHIP_DEFAULT',tlinfo.relationship_default);

674: END IF;
675:
676: IF NOT ((tlinfo.relationship_default = x_relationship_default)
677: OR ((tlinfo.relationship_default IS NULL) AND x_relationship_default IS NULL)) THEN
678: pn_var_rent_pkg.lock_row_exception('RELATIONSHIP_DEFAULT',tlinfo.relationship_default);
679: END IF;
680:
681: IF NOT ((tlinfo.basis_percent_default = x_basis_percent_default)
682: OR ((tlinfo.basis_percent_default IS NULL) AND x_basis_percent_default IS NULL)) THEN

Line 683: pn_var_rent_pkg.lock_row_exception('BASIS_PERCENT_DEFAULT',tlinfo.basis_percent_default);

679: END IF;
680:
681: IF NOT ((tlinfo.basis_percent_default = x_basis_percent_default)
682: OR ((tlinfo.basis_percent_default IS NULL) AND x_basis_percent_default IS NULL)) THEN
683: pn_var_rent_pkg.lock_row_exception('BASIS_PERCENT_DEFAULT',tlinfo.basis_percent_default);
684: END IF;
685:
686: IF NOT ((tlinfo.initial_basis = x_initial_basis)
687: OR ((tlinfo.initial_basis IS NULL) AND x_initial_basis IS NULL)) THEN

Line 688: pn_var_rent_pkg.lock_row_exception('INITIAL_BASIS',tlinfo.initial_basis);

684: END IF;
685:
686: IF NOT ((tlinfo.initial_basis = x_initial_basis)
687: OR ((tlinfo.initial_basis IS NULL) AND x_initial_basis IS NULL)) THEN
688: pn_var_rent_pkg.lock_row_exception('INITIAL_BASIS',tlinfo.initial_basis);
689: END IF;
690:
691: IF NOT ((tlinfo.base_index = x_base_index)
692: OR ((tlinfo.base_index IS NULL) AND x_base_index IS NULL)) THEN

Line 693: pn_var_rent_pkg.lock_row_exception('BASE_INDEX',tlinfo.base_index);

689: END IF;
690:
691: IF NOT ((tlinfo.base_index = x_base_index)
692: OR ((tlinfo.base_index IS NULL) AND x_base_index IS NULL)) THEN
693: pn_var_rent_pkg.lock_row_exception('BASE_INDEX',tlinfo.base_index);
694: END IF;
695:
696: IF NOT ((tlinfo.base_index_line_id = x_base_index_line_id)
697: OR ((tlinfo.base_index_line_id IS NULL) AND x_base_index_line_id IS NULL)) THEN

Line 698: pn_var_rent_pkg.lock_row_exception('BASE_INDEX_LINE_ID',tlinfo.base_index_line_id);

694: END IF;
695:
696: IF NOT ((tlinfo.base_index_line_id = x_base_index_line_id)
697: OR ((tlinfo.base_index_line_id IS NULL) AND x_base_index_line_id IS NULL)) THEN
698: pn_var_rent_pkg.lock_row_exception('BASE_INDEX_LINE_ID',tlinfo.base_index_line_id);
699: END IF;
700:
701: IF NOT ((tlinfo.index_finder_method = x_index_finder_method)
702: OR ((tlinfo.index_finder_method IS NULL) AND x_index_finder_method IS NULL)) THEN

Line 703: pn_var_rent_pkg.lock_row_exception('INDEX_FINDER_METHOD',tlinfo.index_finder_method);

699: END IF;
700:
701: IF NOT ((tlinfo.index_finder_method = x_index_finder_method)
702: OR ((tlinfo.index_finder_method IS NULL) AND x_index_finder_method IS NULL)) THEN
703: pn_var_rent_pkg.lock_row_exception('INDEX_FINDER_METHOD',tlinfo.index_finder_method);
704: END IF;
705:
706: IF NOT ((tlinfo.index_finder_months = x_index_finder_months)
707: OR ((tlinfo.index_finder_months IS NULL) AND x_index_finder_months IS NULL)) THEN

Line 708: pn_var_rent_pkg.lock_row_exception('INDEX_FINDER_MONTHS',tlinfo.index_finder_months);

704: END IF;
705:
706: IF NOT ((tlinfo.index_finder_months = x_index_finder_months)
707: OR ((tlinfo.index_finder_months IS NULL) AND x_index_finder_months IS NULL)) THEN
708: pn_var_rent_pkg.lock_row_exception('INDEX_FINDER_MONTHS',tlinfo.index_finder_months);
709: END IF;
710:
711: IF NOT ((tlinfo.negative_rent_type = x_negative_rent_type)
712: OR ((tlinfo.negative_rent_type IS NULL) AND x_negative_rent_type IS NULL)) THEN

Line 713: pn_var_rent_pkg.lock_row_exception('NEGATIVE_RENT_TYPE',tlinfo.negative_rent_type);

709: END IF;
710:
711: IF NOT ((tlinfo.negative_rent_type = x_negative_rent_type)
712: OR ((tlinfo.negative_rent_type IS NULL) AND x_negative_rent_type IS NULL)) THEN
713: pn_var_rent_pkg.lock_row_exception('NEGATIVE_RENT_TYPE',tlinfo.negative_rent_type);
714: END IF;
715:
716: IF NOT ((tlinfo.increase_on = x_increase_on)
717: OR ((tlinfo.increase_on IS NULL) AND x_increase_on IS NULL)) THEN

Line 718: pn_var_rent_pkg.lock_row_exception('INCREASE_ON',tlinfo.increase_on);

714: END IF;
715:
716: IF NOT ((tlinfo.increase_on = x_increase_on)
717: OR ((tlinfo.increase_on IS NULL) AND x_increase_on IS NULL)) THEN
718: pn_var_rent_pkg.lock_row_exception('INCREASE_ON',tlinfo.increase_on);
719: END IF;
720:
721: IF NOT ((tlinfo.basis_type = x_basis_type)
722: OR ((tlinfo.basis_type IS NULL) AND x_basis_type IS NULL)) THEN

Line 723: pn_var_rent_pkg.lock_row_exception('BASIS_TYPE',tlinfo.basis_type);

719: END IF;
720:
721: IF NOT ((tlinfo.basis_type = x_basis_type)
722: OR ((tlinfo.basis_type IS NULL) AND x_basis_type IS NULL)) THEN
723: pn_var_rent_pkg.lock_row_exception('BASIS_TYPE',tlinfo.basis_type);
724: END IF;
725:
726: IF NOT ((tlinfo.reference_period = x_reference_period)
727: OR ((tlinfo.reference_period IS NULL) AND x_reference_period IS NULL)) THEN

Line 728: pn_var_rent_pkg.lock_row_exception('REFERENCE_PERIOD',tlinfo.reference_period);

724: END IF;
725:
726: IF NOT ((tlinfo.reference_period = x_reference_period)
727: OR ((tlinfo.reference_period IS NULL) AND x_reference_period IS NULL)) THEN
728: pn_var_rent_pkg.lock_row_exception('REFERENCE_PERIOD',tlinfo.reference_period);
729: END IF;
730:
731: IF NOT ((tlinfo.base_year = x_base_year)
732: OR ((tlinfo.base_year IS NULL) AND x_base_year IS NULL)) THEN

Line 733: pn_var_rent_pkg.lock_row_exception('BASE_YEAR',tlinfo.base_year);

729: END IF;
730:
731: IF NOT ((tlinfo.base_year = x_base_year)
732: OR ((tlinfo.base_year IS NULL) AND x_base_year IS NULL)) THEN
733: pn_var_rent_pkg.lock_row_exception('BASE_YEAR',tlinfo.base_year);
734: END IF;
735:
736: IF NOT ((tlinfo.leased_area = x_leased_area)
737: OR ((tlinfo.leased_area IS NULL) AND x_leased_area IS NULL)) THEN

Line 738: pn_var_rent_pkg.lock_row_exception('LEASED_AREA',tlinfo.leased_area);

734: END IF;
735:
736: IF NOT ((tlinfo.leased_area = x_leased_area)
737: OR ((tlinfo.leased_area IS NULL) AND x_leased_area IS NULL)) THEN
738: pn_var_rent_pkg.lock_row_exception('LEASED_AREA',tlinfo.leased_area);
739: END IF;
740:
741: IF NOT ((tlinfo.rounding_flag = x_rounding_flag)
742: OR ((tlinfo.rounding_flag IS NULL) AND x_rounding_flag IS NULL)) THEN

Line 743: pn_var_rent_pkg.lock_row_exception('ROUNDING_FLAG',tlinfo.rounding_flag);

739: END IF;
740:
741: IF NOT ((tlinfo.rounding_flag = x_rounding_flag)
742: OR ((tlinfo.rounding_flag IS NULL) AND x_rounding_flag IS NULL)) THEN
743: pn_var_rent_pkg.lock_row_exception('ROUNDING_FLAG',tlinfo.rounding_flag);
744: END IF;
745:
746: IF NOT ((tlinfo.aggregation_flag = x_aggregation_flag)
747: OR ((tlinfo.aggregation_flag IS NULL) AND x_aggregation_flag IS NULL)) THEN

Line 748: pn_var_rent_pkg.lock_row_exception('AGGREGATION_FLAG',tlinfo.aggregation_flag);

744: END IF;
745:
746: IF NOT ((tlinfo.aggregation_flag = x_aggregation_flag)
747: OR ((tlinfo.aggregation_flag IS NULL) AND x_aggregation_flag IS NULL)) THEN
748: pn_var_rent_pkg.lock_row_exception('AGGREGATION_FLAG',tlinfo.aggregation_flag);
749: END IF;
750:
751: IF NOT ((tlinfo.gross_flag = x_gross_flag)
752: OR ((tlinfo.gross_flag IS NULL) AND x_gross_flag IS NULL)) THEN

Line 753: pn_var_rent_pkg.lock_row_exception('GROSS_FLAG',tlinfo.gross_flag);

749: END IF;
750:
751: IF NOT ((tlinfo.gross_flag = x_gross_flag)
752: OR ((tlinfo.gross_flag IS NULL) AND x_gross_flag IS NULL)) THEN
753: pn_var_rent_pkg.lock_row_exception('GROSS_FLAG',tlinfo.gross_flag);
754: END IF;
755:
756: IF NOT ((tlinfo.AGREEMENT_CATEGORY = X_AGREEMENT_CATEGORY)
757: OR ((tlinfo.AGREEMENT_CATEGORY IS NULL) AND (X_AGREEMENT_CATEGORY IS NULL))) THEN

Line 758: pn_var_rent_pkg.lock_row_exception('AGREEMENT_CATEGORY',tlinfo.AGREEMENT_CATEGORY);

754: END IF;
755:
756: IF NOT ((tlinfo.AGREEMENT_CATEGORY = X_AGREEMENT_CATEGORY)
757: OR ((tlinfo.AGREEMENT_CATEGORY IS NULL) AND (X_AGREEMENT_CATEGORY IS NULL))) THEN
758: pn_var_rent_pkg.lock_row_exception('AGREEMENT_CATEGORY',tlinfo.AGREEMENT_CATEGORY);
759: END IF;
760:
761: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE1 = X_AGREEMENT_ATTRIBUTE1)
762: OR ((tlinfo.AGREEMENT_ATTRIBUTE1 IS NULL) AND (X_AGREEMENT_ATTRIBUTE1 IS NULL))) THEN

Line 763: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE1',tlinfo.AGREEMENT_ATTRIBUTE1);

759: END IF;
760:
761: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE1 = X_AGREEMENT_ATTRIBUTE1)
762: OR ((tlinfo.AGREEMENT_ATTRIBUTE1 IS NULL) AND (X_AGREEMENT_ATTRIBUTE1 IS NULL))) THEN
763: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE1',tlinfo.AGREEMENT_ATTRIBUTE1);
764: END IF;
765:
766: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE2 = X_AGREEMENT_ATTRIBUTE2)
767: OR ((tlinfo.AGREEMENT_ATTRIBUTE2 IS NULL) AND (X_AGREEMENT_ATTRIBUTE2 IS NULL))) THEN

Line 768: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE2',tlinfo.AGREEMENT_ATTRIBUTE2);

764: END IF;
765:
766: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE2 = X_AGREEMENT_ATTRIBUTE2)
767: OR ((tlinfo.AGREEMENT_ATTRIBUTE2 IS NULL) AND (X_AGREEMENT_ATTRIBUTE2 IS NULL))) THEN
768: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE2',tlinfo.AGREEMENT_ATTRIBUTE2);
769: END IF;
770:
771: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE3 = X_AGREEMENT_ATTRIBUTE3)
772: OR ((tlinfo.AGREEMENT_ATTRIBUTE3 IS NULL) AND (X_AGREEMENT_ATTRIBUTE3 IS NULL))) THEN

Line 773: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE3',tlinfo.AGREEMENT_ATTRIBUTE3);

769: END IF;
770:
771: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE3 = X_AGREEMENT_ATTRIBUTE3)
772: OR ((tlinfo.AGREEMENT_ATTRIBUTE3 IS NULL) AND (X_AGREEMENT_ATTRIBUTE3 IS NULL))) THEN
773: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE3',tlinfo.AGREEMENT_ATTRIBUTE3);
774: END IF;
775:
776: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE4 = X_AGREEMENT_ATTRIBUTE4)
777: OR ((tlinfo.AGREEMENT_ATTRIBUTE4 IS NULL) AND (X_AGREEMENT_ATTRIBUTE4 IS NULL))) THEN

Line 778: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE4',tlinfo.AGREEMENT_ATTRIBUTE4);

774: END IF;
775:
776: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE4 = X_AGREEMENT_ATTRIBUTE4)
777: OR ((tlinfo.AGREEMENT_ATTRIBUTE4 IS NULL) AND (X_AGREEMENT_ATTRIBUTE4 IS NULL))) THEN
778: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE4',tlinfo.AGREEMENT_ATTRIBUTE4);
779: END IF;
780:
781: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE5 = X_AGREEMENT_ATTRIBUTE5)
782: OR ((tlinfo.AGREEMENT_ATTRIBUTE5 IS NULL) AND (X_AGREEMENT_ATTRIBUTE5 IS NULL))) THEN

Line 783: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE5',tlinfo.AGREEMENT_ATTRIBUTE5);

779: END IF;
780:
781: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE5 = X_AGREEMENT_ATTRIBUTE5)
782: OR ((tlinfo.AGREEMENT_ATTRIBUTE5 IS NULL) AND (X_AGREEMENT_ATTRIBUTE5 IS NULL))) THEN
783: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE5',tlinfo.AGREEMENT_ATTRIBUTE5);
784: END IF;
785:
786: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE6 = X_AGREEMENT_ATTRIBUTE6)
787: OR ((tlinfo.AGREEMENT_ATTRIBUTE6 IS NULL) AND (X_AGREEMENT_ATTRIBUTE6 IS NULL))) THEN

Line 788: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE6',tlinfo.AGREEMENT_ATTRIBUTE6);

784: END IF;
785:
786: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE6 = X_AGREEMENT_ATTRIBUTE6)
787: OR ((tlinfo.AGREEMENT_ATTRIBUTE6 IS NULL) AND (X_AGREEMENT_ATTRIBUTE6 IS NULL))) THEN
788: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE6',tlinfo.AGREEMENT_ATTRIBUTE6);
789: END IF;
790:
791: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE7 = X_AGREEMENT_ATTRIBUTE7)
792: OR ((tlinfo.AGREEMENT_ATTRIBUTE7 IS NULL) AND (X_AGREEMENT_ATTRIBUTE7 IS NULL))) THEN

Line 793: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE7',tlinfo.AGREEMENT_ATTRIBUTE7);

789: END IF;
790:
791: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE7 = X_AGREEMENT_ATTRIBUTE7)
792: OR ((tlinfo.AGREEMENT_ATTRIBUTE7 IS NULL) AND (X_AGREEMENT_ATTRIBUTE7 IS NULL))) THEN
793: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE7',tlinfo.AGREEMENT_ATTRIBUTE7);
794: END IF;
795:
796: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE8 = X_AGREEMENT_ATTRIBUTE8)
797: OR ((tlinfo.AGREEMENT_ATTRIBUTE8 IS NULL) AND (X_AGREEMENT_ATTRIBUTE8 IS NULL))) THEN

Line 798: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE8',tlinfo.AGREEMENT_ATTRIBUTE8);

794: END IF;
795:
796: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE8 = X_AGREEMENT_ATTRIBUTE8)
797: OR ((tlinfo.AGREEMENT_ATTRIBUTE8 IS NULL) AND (X_AGREEMENT_ATTRIBUTE8 IS NULL))) THEN
798: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE8',tlinfo.AGREEMENT_ATTRIBUTE8);
799: END IF;
800:
801: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE9 = X_AGREEMENT_ATTRIBUTE9)
802: OR ((tlinfo.AGREEMENT_ATTRIBUTE9 IS NULL) AND (X_AGREEMENT_ATTRIBUTE9 IS NULL))) THEN

Line 803: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE9',tlinfo.AGREEMENT_ATTRIBUTE9);

799: END IF;
800:
801: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE9 = X_AGREEMENT_ATTRIBUTE9)
802: OR ((tlinfo.AGREEMENT_ATTRIBUTE9 IS NULL) AND (X_AGREEMENT_ATTRIBUTE9 IS NULL))) THEN
803: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE9',tlinfo.AGREEMENT_ATTRIBUTE9);
804: END IF;
805:
806: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE10 = X_AGREEMENT_ATTRIBUTE10)
807: OR ((tlinfo.AGREEMENT_ATTRIBUTE10 IS NULL) AND (X_AGREEMENT_ATTRIBUTE10 IS NULL))) THEN

Line 808: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE10',tlinfo.AGREEMENT_ATTRIBUTE10);

804: END IF;
805:
806: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE10 = X_AGREEMENT_ATTRIBUTE10)
807: OR ((tlinfo.AGREEMENT_ATTRIBUTE10 IS NULL) AND (X_AGREEMENT_ATTRIBUTE10 IS NULL))) THEN
808: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE10',tlinfo.AGREEMENT_ATTRIBUTE10);
809: END IF;
810:
811: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE11 = X_AGREEMENT_ATTRIBUTE11)
812: OR ((tlinfo.AGREEMENT_ATTRIBUTE11 IS NULL) AND (X_AGREEMENT_ATTRIBUTE11 IS NULL))) THEN

Line 813: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE11',tlinfo.AGREEMENT_ATTRIBUTE11);

809: END IF;
810:
811: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE11 = X_AGREEMENT_ATTRIBUTE11)
812: OR ((tlinfo.AGREEMENT_ATTRIBUTE11 IS NULL) AND (X_AGREEMENT_ATTRIBUTE11 IS NULL))) THEN
813: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE11',tlinfo.AGREEMENT_ATTRIBUTE11);
814: END IF;
815:
816: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE12 = X_AGREEMENT_ATTRIBUTE12)
817: OR ((tlinfo.AGREEMENT_ATTRIBUTE12 IS NULL) AND (X_AGREEMENT_ATTRIBUTE12 IS NULL))) THEN

Line 818: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE12',tlinfo.AGREEMENT_ATTRIBUTE12);

814: END IF;
815:
816: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE12 = X_AGREEMENT_ATTRIBUTE12)
817: OR ((tlinfo.AGREEMENT_ATTRIBUTE12 IS NULL) AND (X_AGREEMENT_ATTRIBUTE12 IS NULL))) THEN
818: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE12',tlinfo.AGREEMENT_ATTRIBUTE12);
819: END IF;
820:
821: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE13 = X_AGREEMENT_ATTRIBUTE13)
822: OR ((tlinfo.AGREEMENT_ATTRIBUTE13 IS NULL) AND (X_AGREEMENT_ATTRIBUTE13 IS NULL))) THEN

Line 823: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE13',tlinfo.AGREEMENT_ATTRIBUTE13);

819: END IF;
820:
821: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE13 = X_AGREEMENT_ATTRIBUTE13)
822: OR ((tlinfo.AGREEMENT_ATTRIBUTE13 IS NULL) AND (X_AGREEMENT_ATTRIBUTE13 IS NULL))) THEN
823: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE13',tlinfo.AGREEMENT_ATTRIBUTE13);
824: END IF;
825:
826: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE14 = X_AGREEMENT_ATTRIBUTE14)
827: OR ((tlinfo.AGREEMENT_ATTRIBUTE14 IS NULL) AND (X_AGREEMENT_ATTRIBUTE14 IS NULL))) THEN

Line 828: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE14',tlinfo.AGREEMENT_ATTRIBUTE14);

824: END IF;
825:
826: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE14 = X_AGREEMENT_ATTRIBUTE14)
827: OR ((tlinfo.AGREEMENT_ATTRIBUTE14 IS NULL) AND (X_AGREEMENT_ATTRIBUTE14 IS NULL))) THEN
828: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE14',tlinfo.AGREEMENT_ATTRIBUTE14);
829: END IF;
830:
831: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE15 = X_AGREEMENT_ATTRIBUTE15)
832: OR ((tlinfo.AGREEMENT_ATTRIBUTE15 IS NULL) AND (X_AGREEMENT_ATTRIBUTE15 IS NULL))) THEN

Line 833: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE15',tlinfo.AGREEMENT_ATTRIBUTE15);

829: END IF;
830:
831: IF NOT ((tlinfo.AGREEMENT_ATTRIBUTE15 = X_AGREEMENT_ATTRIBUTE15)
832: OR ((tlinfo.AGREEMENT_ATTRIBUTE15 IS NULL) AND (X_AGREEMENT_ATTRIBUTE15 IS NULL))) THEN
833: pn_var_rent_pkg.lock_row_exception('AGREEMENT_ATTRIBUTE15',tlinfo.AGREEMENT_ATTRIBUTE15);
834: END IF;
835:
836: IF NOT ((tlinfo.CURRENCY_CODE = X_CURRENCY_CODE)
837: OR ((tlinfo.CURRENCY_CODE IS NULL) AND (X_CURRENCY_CODE IS NULL))) THEN

Line 838: pn_var_rent_pkg.lock_row_exception('CURRENCY_CODE',tlinfo.CURRENCY_CODE);

834: END IF;
835:
836: IF NOT ((tlinfo.CURRENCY_CODE = X_CURRENCY_CODE)
837: OR ((tlinfo.CURRENCY_CODE IS NULL) AND (X_CURRENCY_CODE IS NULL))) THEN
838: pn_var_rent_pkg.lock_row_exception('CURRENCY_CODE',tlinfo.CURRENCY_CODE);
839: END IF;
840:
841: IF NOT ((tlinfo.CARRY_FORWARD_FLAG = X_CARRY_FORWARD_FLAG)
842: OR ((tlinfo.CARRY_FORWARD_FLAG IS NULL) AND (X_CARRY_FORWARD_FLAG IS NULL))) THEN

Line 843: pn_var_rent_pkg.lock_row_exception('CARRY_FORWARD_FLAG',tlinfo.CARRY_FORWARD_FLAG);

839: END IF;
840:
841: IF NOT ((tlinfo.CARRY_FORWARD_FLAG = X_CARRY_FORWARD_FLAG)
842: OR ((tlinfo.CARRY_FORWARD_FLAG IS NULL) AND (X_CARRY_FORWARD_FLAG IS NULL))) THEN
843: pn_var_rent_pkg.lock_row_exception('CARRY_FORWARD_FLAG',tlinfo.CARRY_FORWARD_FLAG);
844: END IF;
845:
846: IF NOT ((tlinfo.RETAIN_INITIAL_BASIS_FLAG = X_RETAIN_INITIAL_BASIS_FLAG)
847: OR ((tlinfo.RETAIN_INITIAL_BASIS_FLAG IS NULL) AND (X_RETAIN_INITIAL_BASIS_FLAG IS NULL))) THEN

Line 848: pn_var_rent_pkg.lock_row_exception('RETAIN_INITIAL_BASIS_FLAG',tlinfo.RETAIN_INITIAL_BASIS_FLAG);

844: END IF;
845:
846: IF NOT ((tlinfo.RETAIN_INITIAL_BASIS_FLAG = X_RETAIN_INITIAL_BASIS_FLAG)
847: OR ((tlinfo.RETAIN_INITIAL_BASIS_FLAG IS NULL) AND (X_RETAIN_INITIAL_BASIS_FLAG IS NULL))) THEN
848: pn_var_rent_pkg.lock_row_exception('RETAIN_INITIAL_BASIS_FLAG',tlinfo.RETAIN_INITIAL_BASIS_FLAG);
849: END IF;
850:
851: IF NOT ((tlinfo.VR_NBP_FLAG = X_VR_NBP_FLAG)
852: OR ((tlinfo.VR_NBP_FLAG IS NULL) AND (X_VR_NBP_FLAG IS NULL))) THEN

Line 853: pn_var_rent_pkg.lock_row_exception('VR_NBP_FLAG',tlinfo.VR_NBP_FLAG);

849: END IF;
850:
851: IF NOT ((tlinfo.VR_NBP_FLAG = X_VR_NBP_FLAG)
852: OR ((tlinfo.VR_NBP_FLAG IS NULL) AND (X_VR_NBP_FLAG IS NULL))) THEN
853: pn_var_rent_pkg.lock_row_exception('VR_NBP_FLAG',tlinfo.VR_NBP_FLAG);
854: END IF;
855:
856: IF NOT ((tlinfo.INDEX_MULTIPLIER = X_INDEX_MULTIPLIER)
857: OR ((tlinfo.INDEX_MULTIPLIER IS NULL) AND (X_INDEX_MULTIPLIER IS NULL))) THEN

Line 858: pn_var_rent_pkg.lock_row_exception('VR_NBP_FLAG',tlinfo.INDEX_MULTIPLIER);

854: END IF;
855:
856: IF NOT ((tlinfo.INDEX_MULTIPLIER = X_INDEX_MULTIPLIER)
857: OR ((tlinfo.INDEX_MULTIPLIER IS NULL) AND (X_INDEX_MULTIPLIER IS NULL))) THEN
858: pn_var_rent_pkg.lock_row_exception('VR_NBP_FLAG',tlinfo.INDEX_MULTIPLIER);
859: END IF;
860:
861: IF NOT ((tlinfo.PRORATION_RULE = X_PRORATION_RULE)
862: OR ((tlinfo.PRORATION_RULE IS NULL) AND (X_PRORATION_RULE IS NULL))) THEN

Line 863: pn_var_rent_pkg.lock_row_exception('VR_NBP_FLAG',tlinfo.PRORATION_RULE);

859: END IF;
860:
861: IF NOT ((tlinfo.PRORATION_RULE = X_PRORATION_RULE)
862: OR ((tlinfo.PRORATION_RULE IS NULL) AND (X_PRORATION_RULE IS NULL))) THEN
863: pn_var_rent_pkg.lock_row_exception('VR_NBP_FLAG',tlinfo.PRORATION_RULE);
864: END IF;
865:
866: IF NOT ((tlinfo.PRORATION_PERIOD_START_DATE = X_PRORATION_PERIOD_START_DATE)
867: OR ((tlinfo.PRORATION_PERIOD_START_DATE IS NULL) AND (X_PRORATION_PERIOD_START_DATE IS NULL))) THEN

Line 868: pn_var_rent_pkg.lock_row_exception('VR_NBP_FLAG',tlinfo.PRORATION_PERIOD_START_DATE);

864: END IF;
865:
866: IF NOT ((tlinfo.PRORATION_PERIOD_START_DATE = X_PRORATION_PERIOD_START_DATE)
867: OR ((tlinfo.PRORATION_PERIOD_START_DATE IS NULL) AND (X_PRORATION_PERIOD_START_DATE IS NULL))) THEN
868: pn_var_rent_pkg.lock_row_exception('VR_NBP_FLAG',tlinfo.PRORATION_PERIOD_START_DATE);
869: END IF;
870:
871: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASES_PKG.lock_row (-)');
872: