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.PNT_PAYMENT_TERMS_PKG dependencies on PN_VAR_RENT_PKG

Line 624: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_ID',tlinfo.PAYMENT_TERM_ID);

620: END IF;
621: CLOSE c1;
622:
623: IF NOT (tlinfo.PAYMENT_TERM_ID = X_PAYMENT_TERM_ID) THEN
624: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_ID',tlinfo.PAYMENT_TERM_ID);
625: END IF;
626:
627: IF NOT (tlinfo.PAYMENT_PURPOSE_CODE = X_PAYMENT_PURPOSE_CODE) THEN
628: pn_var_rent_pkg.lock_row_exception('PAYMENT_PURPOSE_CODE',tlinfo.PAYMENT_PURPOSE_CODE);

Line 628: pn_var_rent_pkg.lock_row_exception('PAYMENT_PURPOSE_CODE',tlinfo.PAYMENT_PURPOSE_CODE);

624: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_ID',tlinfo.PAYMENT_TERM_ID);
625: END IF;
626:
627: IF NOT (tlinfo.PAYMENT_PURPOSE_CODE = X_PAYMENT_PURPOSE_CODE) THEN
628: pn_var_rent_pkg.lock_row_exception('PAYMENT_PURPOSE_CODE',tlinfo.PAYMENT_PURPOSE_CODE);
629: END IF;
630:
631: IF NOT (tlinfo.PAYMENT_TERM_TYPE_CODE = X_PAYMENT_TERM_TYPE_CODE) THEN
632: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_TYPE_CODE',tlinfo.PAYMENT_TERM_TYPE_CODE);

Line 632: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_TYPE_CODE',tlinfo.PAYMENT_TERM_TYPE_CODE);

628: pn_var_rent_pkg.lock_row_exception('PAYMENT_PURPOSE_CODE',tlinfo.PAYMENT_PURPOSE_CODE);
629: END IF;
630:
631: IF NOT (tlinfo.PAYMENT_TERM_TYPE_CODE = X_PAYMENT_TERM_TYPE_CODE) THEN
632: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_TYPE_CODE',tlinfo.PAYMENT_TERM_TYPE_CODE);
633: END IF;
634:
635: IF NOT (tlinfo.FREQUENCY_CODE = X_FREQUENCY_CODE) THEN
636: pn_var_rent_pkg.lock_row_exception('FREQUENCY_CODE',tlinfo.FREQUENCY_CODE);

Line 636: pn_var_rent_pkg.lock_row_exception('FREQUENCY_CODE',tlinfo.FREQUENCY_CODE);

632: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_TYPE_CODE',tlinfo.PAYMENT_TERM_TYPE_CODE);
633: END IF;
634:
635: IF NOT (tlinfo.FREQUENCY_CODE = X_FREQUENCY_CODE) THEN
636: pn_var_rent_pkg.lock_row_exception('FREQUENCY_CODE',tlinfo.FREQUENCY_CODE);
637: END IF;
638:
639: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
640: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);

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

636: pn_var_rent_pkg.lock_row_exception('FREQUENCY_CODE',tlinfo.FREQUENCY_CODE);
637: END IF;
638:
639: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
640: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
641: END IF;
642:
643: IF NOT (tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID) THEN
644: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);

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

640: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
641: END IF;
642:
643: IF NOT (tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID) THEN
644: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
645: END IF;
646:
647: IF NOT (tlinfo.START_DATE = X_START_DATE) THEN
648: pn_var_rent_pkg.lock_row_exception('START_DATE',tlinfo.START_DATE);

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

644: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
645: END IF;
646:
647: IF NOT (tlinfo.START_DATE = X_START_DATE) THEN
648: pn_var_rent_pkg.lock_row_exception('START_DATE',tlinfo.START_DATE);
649: END IF;
650:
651: IF NOT (tlinfo.END_DATE = X_END_DATE) THEN
652: pn_var_rent_pkg.lock_row_exception('END_DATE',tlinfo.END_DATE);

Line 652: pn_var_rent_pkg.lock_row_exception('END_DATE',tlinfo.END_DATE);

648: pn_var_rent_pkg.lock_row_exception('START_DATE',tlinfo.START_DATE);
649: END IF;
650:
651: IF NOT (tlinfo.END_DATE = X_END_DATE) THEN
652: pn_var_rent_pkg.lock_row_exception('END_DATE',tlinfo.END_DATE);
653: END IF;
654:
655: IF NOT ((tlinfo.VENDOR_ID = X_VENDOR_ID)
656: OR ((tlinfo.VENDOR_ID IS NULL) AND (X_VENDOR_ID IS NULL))) THEN

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

653: END IF;
654:
655: IF NOT ((tlinfo.VENDOR_ID = X_VENDOR_ID)
656: OR ((tlinfo.VENDOR_ID IS NULL) AND (X_VENDOR_ID IS NULL))) THEN
657: pn_var_rent_pkg.lock_row_exception('VENDOR_ID',tlinfo.VENDOR_ID);
658: END IF;
659:
660: IF NOT ((tlinfo.VENDOR_SITE_ID = X_VENDOR_SITE_ID)
661: OR ((tlinfo.VENDOR_SITE_ID IS NULL) AND (X_VENDOR_SITE_ID IS NULL))) THEN

Line 662: pn_var_rent_pkg.lock_row_exception('VENDOR_SITE_ID',tlinfo.VENDOR_SITE_ID);

658: END IF;
659:
660: IF NOT ((tlinfo.VENDOR_SITE_ID = X_VENDOR_SITE_ID)
661: OR ((tlinfo.VENDOR_SITE_ID IS NULL) AND (X_VENDOR_SITE_ID IS NULL))) THEN
662: pn_var_rent_pkg.lock_row_exception('VENDOR_SITE_ID',tlinfo.VENDOR_SITE_ID);
663: END IF;
664:
665: IF NOT ((tlinfo.CUSTOMER_ID = X_CUSTOMER_ID)
666: OR ((tlinfo.CUSTOMER_ID IS NULL) AND (X_CUSTOMER_ID IS NULL))) THEN

Line 667: pn_var_rent_pkg.lock_row_exception('CUSTOMER_ID',tlinfo.CUSTOMER_ID);

663: END IF;
664:
665: IF NOT ((tlinfo.CUSTOMER_ID = X_CUSTOMER_ID)
666: OR ((tlinfo.CUSTOMER_ID IS NULL) AND (X_CUSTOMER_ID IS NULL))) THEN
667: pn_var_rent_pkg.lock_row_exception('CUSTOMER_ID',tlinfo.CUSTOMER_ID);
668: END IF;
669:
670: IF NOT ((tlinfo.CUSTOMER_SITE_USE_ID = X_CUSTOMER_SITE_USE_ID)
671: OR ((tlinfo.CUSTOMER_SITE_USE_ID IS NULL) AND (X_CUSTOMER_SITE_USE_ID IS NULL))) THEN

Line 672: pn_var_rent_pkg.lock_row_exception('CUSTOMER_SITE_USE_ID',tlinfo.CUSTOMER_SITE_USE_ID);

668: END IF;
669:
670: IF NOT ((tlinfo.CUSTOMER_SITE_USE_ID = X_CUSTOMER_SITE_USE_ID)
671: OR ((tlinfo.CUSTOMER_SITE_USE_ID IS NULL) AND (X_CUSTOMER_SITE_USE_ID IS NULL))) THEN
672: pn_var_rent_pkg.lock_row_exception('CUSTOMER_SITE_USE_ID',tlinfo.CUSTOMER_SITE_USE_ID);
673: END IF;
674:
675: IF NOT ((tlinfo.TARGET_DATE = X_TARGET_DATE)
676: OR ((tlinfo.TARGET_DATE IS NULL) AND (X_TARGET_DATE IS NULL))) THEN

Line 677: pn_var_rent_pkg.lock_row_exception('TARGET_DATE',tlinfo.TARGET_DATE);

673: END IF;
674:
675: IF NOT ((tlinfo.TARGET_DATE = X_TARGET_DATE)
676: OR ((tlinfo.TARGET_DATE IS NULL) AND (X_TARGET_DATE IS NULL))) THEN
677: pn_var_rent_pkg.lock_row_exception('TARGET_DATE',tlinfo.TARGET_DATE);
678: END IF;
679:
680: IF NOT ((tlinfo.ACTUAL_AMOUNT = X_ACTUAL_AMOUNT)
681: OR ((tlinfo.ACTUAL_AMOUNT IS NULL) AND (X_ACTUAL_AMOUNT IS NULL))) THEN

Line 682: pn_var_rent_pkg.lock_row_exception('ACTUAL_AMOUNT',tlinfo.ACTUAL_AMOUNT);

678: END IF;
679:
680: IF NOT ((tlinfo.ACTUAL_AMOUNT = X_ACTUAL_AMOUNT)
681: OR ((tlinfo.ACTUAL_AMOUNT IS NULL) AND (X_ACTUAL_AMOUNT IS NULL))) THEN
682: pn_var_rent_pkg.lock_row_exception('ACTUAL_AMOUNT',tlinfo.ACTUAL_AMOUNT);
683: END IF;
684:
685: IF NOT ((tlinfo.ESTIMATED_AMOUNT = X_ESTIMATED_AMOUNT)
686: OR ((tlinfo.ESTIMATED_AMOUNT IS NULL) AND (X_ESTIMATED_AMOUNT IS NULL))) THEN

Line 687: pn_var_rent_pkg.lock_row_exception('ESTIMATED_AMOUNT',tlinfo.ESTIMATED_AMOUNT);

683: END IF;
684:
685: IF NOT ((tlinfo.ESTIMATED_AMOUNT = X_ESTIMATED_AMOUNT)
686: OR ((tlinfo.ESTIMATED_AMOUNT IS NULL) AND (X_ESTIMATED_AMOUNT IS NULL))) THEN
687: pn_var_rent_pkg.lock_row_exception('ESTIMATED_AMOUNT',tlinfo.ESTIMATED_AMOUNT);
688: END IF;
689:
690: IF NOT (tlinfo.SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID) THEN
691: pn_var_rent_pkg.lock_row_exception('SET_OF_BOOKS_ID',tlinfo.SET_OF_BOOKS_ID);

Line 691: pn_var_rent_pkg.lock_row_exception('SET_OF_BOOKS_ID',tlinfo.SET_OF_BOOKS_ID);

687: pn_var_rent_pkg.lock_row_exception('ESTIMATED_AMOUNT',tlinfo.ESTIMATED_AMOUNT);
688: END IF;
689:
690: IF NOT (tlinfo.SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID) THEN
691: pn_var_rent_pkg.lock_row_exception('SET_OF_BOOKS_ID',tlinfo.SET_OF_BOOKS_ID);
692: END IF;
693:
694: IF NOT (tlinfo.CURRENCY_CODE = X_CURRENCY_CODE) THEN
695: pn_var_rent_pkg.lock_row_exception('CURRENCY_CODE',tlinfo.CURRENCY_CODE);

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

691: pn_var_rent_pkg.lock_row_exception('SET_OF_BOOKS_ID',tlinfo.SET_OF_BOOKS_ID);
692: END IF;
693:
694: IF NOT (tlinfo.CURRENCY_CODE = X_CURRENCY_CODE) THEN
695: pn_var_rent_pkg.lock_row_exception('CURRENCY_CODE',tlinfo.CURRENCY_CODE);
696: END IF;
697:
698: IF NOT ((tlinfo.RATE = X_RATE)
699: OR ((tlinfo.RATE IS NULL) AND (X_RATE IS NULL))) THEN

Line 700: pn_var_rent_pkg.lock_row_exception('RATE',tlinfo.RATE);

696: END IF;
697:
698: IF NOT ((tlinfo.RATE = X_RATE)
699: OR ((tlinfo.RATE IS NULL) AND (X_RATE IS NULL))) THEN
700: pn_var_rent_pkg.lock_row_exception('RATE',tlinfo.RATE);
701: END IF;
702:
703: IF NOT ((tlinfo.NORMALIZE = X_NORMALIZE)
704: OR ((tlinfo.NORMALIZE IS NULL) AND (X_NORMALIZE IS NULL))) THEN

Line 705: pn_var_rent_pkg.lock_row_exception('NORMALIZE',tlinfo.NORMALIZE);

701: END IF;
702:
703: IF NOT ((tlinfo.NORMALIZE = X_NORMALIZE)
704: OR ((tlinfo.NORMALIZE IS NULL) AND (X_NORMALIZE IS NULL))) THEN
705: pn_var_rent_pkg.lock_row_exception('NORMALIZE',tlinfo.NORMALIZE);
706: END IF;
707:
708: IF NOT ((tlinfo.LOCATION_ID = X_LOCATION_ID)
709: OR ((tlinfo.LOCATION_ID IS NULL) AND (X_LOCATION_ID IS NULL))) THEN

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

706: END IF;
707:
708: IF NOT ((tlinfo.LOCATION_ID = X_LOCATION_ID)
709: OR ((tlinfo.LOCATION_ID IS NULL) AND (X_LOCATION_ID IS NULL))) THEN
710: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.LOCATION_ID);
711: END IF;
712:
713: IF NOT ((tlinfo.SCHEDULE_DAY = X_SCHEDULE_DAY)
714: OR ((tlinfo.SCHEDULE_DAY IS NULL) AND (X_SCHEDULE_DAY IS NULL))) THEN

Line 715: pn_var_rent_pkg.lock_row_exception('SCHEDULE_DAY',tlinfo.SCHEDULE_DAY);

711: END IF;
712:
713: IF NOT ((tlinfo.SCHEDULE_DAY = X_SCHEDULE_DAY)
714: OR ((tlinfo.SCHEDULE_DAY IS NULL) AND (X_SCHEDULE_DAY IS NULL))) THEN
715: pn_var_rent_pkg.lock_row_exception('SCHEDULE_DAY',tlinfo.SCHEDULE_DAY);
716: END IF;
717:
718: IF NOT ((tlinfo.CUST_SHIP_SITE_ID = X_CUST_SHIP_SITE_ID)
719: OR ((tlinfo.CUST_SHIP_SITE_ID IS NULL) AND (X_CUST_SHIP_SITE_ID IS NULL))) THEN

Line 720: pn_var_rent_pkg.lock_row_exception('CUST_SHIP_SITE_ID',tlinfo.CUST_SHIP_SITE_ID);

716: END IF;
717:
718: IF NOT ((tlinfo.CUST_SHIP_SITE_ID = X_CUST_SHIP_SITE_ID)
719: OR ((tlinfo.CUST_SHIP_SITE_ID IS NULL) AND (X_CUST_SHIP_SITE_ID IS NULL))) THEN
720: pn_var_rent_pkg.lock_row_exception('CUST_SHIP_SITE_ID',tlinfo.CUST_SHIP_SITE_ID);
721: END IF;
722:
723: IF NOT ((tlinfo.AP_AR_TERM_ID = X_AP_AR_TERM_ID)
724: OR ((tlinfo.AP_AR_TERM_ID IS NULL) AND (X_AP_AR_TERM_ID IS NULL))) THEN

Line 725: pn_var_rent_pkg.lock_row_exception('AP_AR_TERM_ID',tlinfo.AP_AR_TERM_ID);

721: END IF;
722:
723: IF NOT ((tlinfo.AP_AR_TERM_ID = X_AP_AR_TERM_ID)
724: OR ((tlinfo.AP_AR_TERM_ID IS NULL) AND (X_AP_AR_TERM_ID IS NULL))) THEN
725: pn_var_rent_pkg.lock_row_exception('AP_AR_TERM_ID',tlinfo.AP_AR_TERM_ID);
726: END IF;
727:
728: IF NOT ((tlinfo.CUST_TRX_TYPE_ID = X_CUST_TRX_TYPE_ID)
729: OR ((tlinfo.CUST_TRX_TYPE_ID IS NULL) AND (X_CUST_TRX_TYPE_ID IS NULL))) THEN

Line 730: pn_var_rent_pkg.lock_row_exception('CUST_TRX_TYPE_ID',tlinfo.CUST_TRX_TYPE_ID);

726: END IF;
727:
728: IF NOT ((tlinfo.CUST_TRX_TYPE_ID = X_CUST_TRX_TYPE_ID)
729: OR ((tlinfo.CUST_TRX_TYPE_ID IS NULL) AND (X_CUST_TRX_TYPE_ID IS NULL))) THEN
730: pn_var_rent_pkg.lock_row_exception('CUST_TRX_TYPE_ID',tlinfo.CUST_TRX_TYPE_ID);
731: END IF;
732:
733: IF NOT ((tlinfo.PROJECT_ID = X_PROJECT_ID)
734: OR ((tlinfo.PROJECT_ID IS NULL) AND (X_PROJECT_ID IS NULL))) THEN

Line 735: pn_var_rent_pkg.lock_row_exception('PROJECT_ID',tlinfo.PROJECT_ID);

731: END IF;
732:
733: IF NOT ((tlinfo.PROJECT_ID = X_PROJECT_ID)
734: OR ((tlinfo.PROJECT_ID IS NULL) AND (X_PROJECT_ID IS NULL))) THEN
735: pn_var_rent_pkg.lock_row_exception('PROJECT_ID',tlinfo.PROJECT_ID);
736: END IF;
737:
738: IF NOT ((tlinfo.TASK_ID = X_TASK_ID)
739: OR ((tlinfo.TASK_ID IS NULL) AND (X_TASK_ID IS NULL))) THEN

Line 740: pn_var_rent_pkg.lock_row_exception('TASK_ID',tlinfo.TASK_ID);

736: END IF;
737:
738: IF NOT ((tlinfo.TASK_ID = X_TASK_ID)
739: OR ((tlinfo.TASK_ID IS NULL) AND (X_TASK_ID IS NULL))) THEN
740: pn_var_rent_pkg.lock_row_exception('TASK_ID',tlinfo.TASK_ID);
741: END IF;
742:
743: IF NOT ((tlinfo.ORGANIZATION_ID = X_ORGANIZATION_ID)
744: OR ((tlinfo.ORGANIZATION_ID IS NULL) AND (X_ORGANIZATION_ID IS NULL))) THEN

Line 745: pn_var_rent_pkg.lock_row_exception('ORGANIZATION_ID',tlinfo.ORGANIZATION_ID);

741: END IF;
742:
743: IF NOT ((tlinfo.ORGANIZATION_ID = X_ORGANIZATION_ID)
744: OR ((tlinfo.ORGANIZATION_ID IS NULL) AND (X_ORGANIZATION_ID IS NULL))) THEN
745: pn_var_rent_pkg.lock_row_exception('ORGANIZATION_ID',tlinfo.ORGANIZATION_ID);
746: END IF;
747:
748: IF NOT ((tlinfo.EXPENDITURE_TYPE = X_EXPENDITURE_TYPE)
749: OR ((tlinfo.EXPENDITURE_TYPE IS NULL) AND (X_EXPENDITURE_TYPE IS NULL))) THEN

Line 750: pn_var_rent_pkg.lock_row_exception('EXPENDITURE_TYPE',tlinfo.EXPENDITURE_TYPE);

746: END IF;
747:
748: IF NOT ((tlinfo.EXPENDITURE_TYPE = X_EXPENDITURE_TYPE)
749: OR ((tlinfo.EXPENDITURE_TYPE IS NULL) AND (X_EXPENDITURE_TYPE IS NULL))) THEN
750: pn_var_rent_pkg.lock_row_exception('EXPENDITURE_TYPE',tlinfo.EXPENDITURE_TYPE);
751: END IF;
752:
753: IF NOT ((tlinfo.EXPENDITURE_ITEM_DATE = X_EXPENDITURE_ITEM_DATE)
754: OR ((tlinfo.EXPENDITURE_ITEM_DATE IS NULL) AND (X_EXPENDITURE_ITEM_DATE IS NULL))) THEN

Line 755: pn_var_rent_pkg.lock_row_exception('EXPENDITURE_ITEM_DATE',tlinfo.EXPENDITURE_ITEM_DATE);

751: END IF;
752:
753: IF NOT ((tlinfo.EXPENDITURE_ITEM_DATE = X_EXPENDITURE_ITEM_DATE)
754: OR ((tlinfo.EXPENDITURE_ITEM_DATE IS NULL) AND (X_EXPENDITURE_ITEM_DATE IS NULL))) THEN
755: pn_var_rent_pkg.lock_row_exception('EXPENDITURE_ITEM_DATE',tlinfo.EXPENDITURE_ITEM_DATE);
756: END IF;
757:
758: IF pn_r12_util_pkg.is_r12 AND
759: NOT ((tlinfo.TAX_CLASSIFICATION_CODE = X_TAX_CLASSIFICATION_CODE)

Line 761: pn_var_rent_pkg.lock_row_exception('TAX_GROUP_ID',tlinfo.TAX_CLASSIFICATION_CODE);

757:
758: IF pn_r12_util_pkg.is_r12 AND
759: NOT ((tlinfo.TAX_CLASSIFICATION_CODE = X_TAX_CLASSIFICATION_CODE)
760: OR ((tlinfo.TAX_CLASSIFICATION_CODE IS NULL) AND (X_TAX_CLASSIFICATION_CODE IS NULL))) THEN
761: pn_var_rent_pkg.lock_row_exception('TAX_GROUP_ID',tlinfo.TAX_CLASSIFICATION_CODE);
762: END IF;
763:
764: IF NOT pn_r12_util_pkg.is_r12 AND
765: NOT ((tlinfo.TAX_GROUP_ID = X_TAX_GROUP_ID)

Line 767: pn_var_rent_pkg.lock_row_exception('TAX_GROUP_ID',tlinfo.TAX_GROUP_ID);

763:
764: IF NOT pn_r12_util_pkg.is_r12 AND
765: NOT ((tlinfo.TAX_GROUP_ID = X_TAX_GROUP_ID)
766: OR ((tlinfo.TAX_GROUP_ID IS NULL) AND (X_TAX_GROUP_ID IS NULL))) THEN
767: pn_var_rent_pkg.lock_row_exception('TAX_GROUP_ID',tlinfo.TAX_GROUP_ID);
768: END IF;
769:
770: IF NOT pn_r12_util_pkg.is_r12 AND
771: NOT ((tlinfo.TAX_CODE_ID = X_TAX_CODE_ID)

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

769:
770: IF NOT pn_r12_util_pkg.is_r12 AND
771: NOT ((tlinfo.TAX_CODE_ID = X_TAX_CODE_ID)
772: OR ((tlinfo.TAX_CODE_ID IS NULL) AND (X_TAX_CODE_ID IS NULL))) THEN
773: pn_var_rent_pkg.lock_row_exception('TAX_CODE_ID',tlinfo.TAX_CODE_ID);
774: END IF;
775:
776: IF ((tlinfo.TAX_INCLUDED = 'Y') AND
777: (tlinfo.VENDOR_SITE_ID IS NOT NULL) AND

Line 782: pn_var_rent_pkg.lock_row_exception('TAX_INCLUDED',tlinfo.TAX_INCLUDED);

778: (pn_r12_util_pkg.is_r12)) THEN
779:
780: IF X_TAX_INCLUDED <> 'A' THEN
781:
782: pn_var_rent_pkg.lock_row_exception('TAX_INCLUDED',tlinfo.TAX_INCLUDED);
783:
784: END IF;
785:
786: ELSIF NOT ((tlinfo.TAX_INCLUDED = X_TAX_INCLUDED)

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

784: END IF;
785:
786: ELSIF NOT ((tlinfo.TAX_INCLUDED = X_TAX_INCLUDED)
787: OR ((tlinfo.TAX_INCLUDED IS NULL) AND (X_TAX_INCLUDED IS NULL))) THEN
788: pn_var_rent_pkg.lock_row_exception('TAX_INCLUDED',tlinfo.TAX_INCLUDED);
789:
790: END IF;
791:
792: IF NOT ((tlinfo.DISTRIBUTION_SET_ID = X_DISTRIBUTION_SET_ID)

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

790: END IF;
791:
792: IF NOT ((tlinfo.DISTRIBUTION_SET_ID = X_DISTRIBUTION_SET_ID)
793: OR ((tlinfo.DISTRIBUTION_SET_ID IS NULL) AND (X_DISTRIBUTION_SET_ID IS NULL))) THEN
794: pn_var_rent_pkg.lock_row_exception('DISTRIBUTION_SET_ID',tlinfo.DISTRIBUTION_SET_ID);
795: END IF;
796:
797: IF NOT ((tlinfo.INV_RULE_ID = X_INV_RULE_ID)
798: OR ((tlinfo.INV_RULE_ID IS NULL) AND (X_INV_RULE_ID IS NULL))) THEN

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

795: END IF;
796:
797: IF NOT ((tlinfo.INV_RULE_ID = X_INV_RULE_ID)
798: OR ((tlinfo.INV_RULE_ID IS NULL) AND (X_INV_RULE_ID IS NULL))) THEN
799: pn_var_rent_pkg.lock_row_exception('INV_RULE_ID',tlinfo.INV_RULE_ID);
800: END IF;
801:
802: IF NOT ((tlinfo.ACCOUNT_RULE_ID = X_ACCOUNT_RULE_ID)
803: OR ((tlinfo.ACCOUNT_RULE_ID IS NULL) AND (X_ACCOUNT_RULE_ID IS NULL))) THEN

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

800: END IF;
801:
802: IF NOT ((tlinfo.ACCOUNT_RULE_ID = X_ACCOUNT_RULE_ID)
803: OR ((tlinfo.ACCOUNT_RULE_ID IS NULL) AND (X_ACCOUNT_RULE_ID IS NULL))) THEN
804: pn_var_rent_pkg.lock_row_exception('ACCOUNT_RULE_ID',tlinfo.ACCOUNT_RULE_ID);
805: END IF;
806:
807: IF NOT ((tlinfo.SALESREP_ID = X_SALESREP_ID)
808: OR ((tlinfo.SALESREP_ID IS NULL) AND (X_SALESREP_ID IS NULL))) THEN

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

805: END IF;
806:
807: IF NOT ((tlinfo.SALESREP_ID = X_SALESREP_ID)
808: OR ((tlinfo.SALESREP_ID IS NULL) AND (X_SALESREP_ID IS NULL))) THEN
809: pn_var_rent_pkg.lock_row_exception('SALESREP_ID',tlinfo.SALESREP_ID);
810: END IF;
811:
812: IF NOT ((tlinfo.APPROVED_BY = X_APPROVED_BY)
813: OR ((tlinfo.APPROVED_BY IS NULL) AND (X_APPROVED_BY IS NULL))) THEN

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

810: END IF;
811:
812: IF NOT ((tlinfo.APPROVED_BY = X_APPROVED_BY)
813: OR ((tlinfo.APPROVED_BY IS NULL) AND (X_APPROVED_BY IS NULL))) THEN
814: pn_var_rent_pkg.lock_row_exception('APPROVED_BY',tlinfo.APPROVED_BY);
815: END IF;
816:
817: IF NOT ((tlinfo.STATUS = X_STATUS)
818: OR ((tlinfo.STATUS IS NULL) AND (X_STATUS IS NULL))) THEN

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

815: END IF;
816:
817: IF NOT ((tlinfo.STATUS = X_STATUS)
818: OR ((tlinfo.STATUS IS NULL) AND (X_STATUS IS NULL))) THEN
819: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);
820: END IF;
821:
822: IF NOT ((tlinfo.INDEX_PERIOD_ID = X_INDEX_PERIOD_ID)
823: OR ((tlinfo.INDEX_PERIOD_ID IS NULL) AND (X_INDEX_PERIOD_ID IS NULL))) THEN

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

820: END IF;
821:
822: IF NOT ((tlinfo.INDEX_PERIOD_ID = X_INDEX_PERIOD_ID)
823: OR ((tlinfo.INDEX_PERIOD_ID IS NULL) AND (X_INDEX_PERIOD_ID IS NULL))) THEN
824: pn_var_rent_pkg.lock_row_exception('INDEX_PERIOD_ID',tlinfo.INDEX_PERIOD_ID);
825: END IF;
826:
827: IF NOT ((tlinfo.INDEX_TERM_INDICATOR = X_INDEX_TERM_INDICATOR)
828: OR ((tlinfo.INDEX_TERM_INDICATOR IS NULL) AND (X_INDEX_TERM_INDICATOR IS NULL))) THEN

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

825: END IF;
826:
827: IF NOT ((tlinfo.INDEX_TERM_INDICATOR = X_INDEX_TERM_INDICATOR)
828: OR ((tlinfo.INDEX_TERM_INDICATOR IS NULL) AND (X_INDEX_TERM_INDICATOR IS NULL))) THEN
829: pn_var_rent_pkg.lock_row_exception('INDEX_TERM_INDICATOR',tlinfo.INDEX_TERM_INDICATOR);
830: END IF;
831:
832: IF NOT ((tlinfo.PO_HEADER_ID = X_PO_HEADER_ID)
833: OR ((tlinfo.PO_HEADER_ID IS NULL) AND (X_PO_HEADER_ID IS NULL))) THEN

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

830: END IF;
831:
832: IF NOT ((tlinfo.PO_HEADER_ID = X_PO_HEADER_ID)
833: OR ((tlinfo.PO_HEADER_ID IS NULL) AND (X_PO_HEADER_ID IS NULL))) THEN
834: pn_var_rent_pkg.lock_row_exception('PO_HEADER_ID',tlinfo.PO_HEADER_ID);
835: END IF;
836:
837: IF NOT ((tlinfo.CUST_PO_NUMBER = X_CUST_PO_NUMBER)
838: OR ((tlinfo.CUST_PO_NUMBER IS NULL) AND (X_CUST_PO_NUMBER IS NULL))) THEN

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

835: END IF;
836:
837: IF NOT ((tlinfo.CUST_PO_NUMBER = X_CUST_PO_NUMBER)
838: OR ((tlinfo.CUST_PO_NUMBER IS NULL) AND (X_CUST_PO_NUMBER IS NULL))) THEN
839: pn_var_rent_pkg.lock_row_exception('CUST_PO_NUMBER',tlinfo.CUST_PO_NUMBER);
840: END IF;
841:
842: IF NOT ((tlinfo.RECEIPT_METHOD_ID = X_RECEIPT_METHOD_ID)
843: OR ((tlinfo.RECEIPT_METHOD_ID IS NULL) AND (X_RECEIPT_METHOD_ID IS NULL))) THEN

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

840: END IF;
841:
842: IF NOT ((tlinfo.RECEIPT_METHOD_ID = X_RECEIPT_METHOD_ID)
843: OR ((tlinfo.RECEIPT_METHOD_ID IS NULL) AND (X_RECEIPT_METHOD_ID IS NULL))) THEN
844: pn_var_rent_pkg.lock_row_exception('RECEIPT_METHOD_ID',tlinfo.RECEIPT_METHOD_ID);
845: END IF;
846:
847: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
848: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN

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

845: END IF;
846:
847: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
848: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN
849: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
850: END IF;
851:
852: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
853: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN

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

850: END IF;
851:
852: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
853: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN
854: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
855: END IF;
856:
857: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
858: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN

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

855: END IF;
856:
857: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
858: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN
859: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
860: END IF;
861:
862: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
863: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN

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

860: END IF;
861:
862: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
863: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN
864: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
865: END IF;
866:
867: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
868: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN

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

865: END IF;
866:
867: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
868: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN
869: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
870: END IF;
871:
872: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
873: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN

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

870: END IF;
871:
872: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
873: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN
874: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
875: END IF;
876:
877: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
878: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN

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

875: END IF;
876:
877: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
878: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN
879: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
880: END IF;
881:
882: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
883: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN

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

880: END IF;
881:
882: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
883: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN
884: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
885: END IF;
886:
887: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
888: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN

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

885: END IF;
886:
887: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
888: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN
889: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
890: END IF;
891:
892: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
893: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN

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

890: END IF;
891:
892: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
893: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN
894: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
895: END IF;
896:
897: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
898: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN

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

895: END IF;
896:
897: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
898: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN
899: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
900: END IF;
901:
902: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
903: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN

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

900: END IF;
901:
902: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
903: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN
904: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
905: END IF;
906:
907: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
908: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN

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

905: END IF;
906:
907: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
908: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN
909: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
910: END IF;
911:
912: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
913: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN

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

910: END IF;
911:
912: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
913: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN
914: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
915: END IF;
916:
917: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
918: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN

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

915: END IF;
916:
917: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
918: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN
919: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
920: END IF;
921:
922: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
923: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN

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

920: END IF;
921:
922: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
923: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN
924: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
925: END IF;
926:
927: IF NOT ((tlinfo.PROJECT_ATTRIBUTE_CATEGORY = X_PROJECT_ATTRIBUTE_CATEGORY)
928: OR ((tlinfo.PROJECT_ATTRIBUTE_CATEGORY IS NULL) AND (X_PROJECT_ATTRIBUTE_CATEGORY IS NULL))) THEN

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

925: END IF;
926:
927: IF NOT ((tlinfo.PROJECT_ATTRIBUTE_CATEGORY = X_PROJECT_ATTRIBUTE_CATEGORY)
928: OR ((tlinfo.PROJECT_ATTRIBUTE_CATEGORY IS NULL) AND (X_PROJECT_ATTRIBUTE_CATEGORY IS NULL))) THEN
929: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE_CATEGORY',tlinfo.PROJECT_ATTRIBUTE_CATEGORY);
930: END IF;
931:
932: IF NOT ((tlinfo.PROJECT_ATTRIBUTE1 = X_PROJECT_ATTRIBUTE1)
933: OR ((tlinfo.PROJECT_ATTRIBUTE1 IS NULL) AND (X_PROJECT_ATTRIBUTE1 IS NULL))) THEN

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

930: END IF;
931:
932: IF NOT ((tlinfo.PROJECT_ATTRIBUTE1 = X_PROJECT_ATTRIBUTE1)
933: OR ((tlinfo.PROJECT_ATTRIBUTE1 IS NULL) AND (X_PROJECT_ATTRIBUTE1 IS NULL))) THEN
934: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE1',tlinfo.PROJECT_ATTRIBUTE1);
935: END IF;
936:
937: IF NOT ((tlinfo.PROJECT_ATTRIBUTE2 = X_PROJECT_ATTRIBUTE2)
938: OR ((tlinfo.PROJECT_ATTRIBUTE2 IS NULL) AND (X_PROJECT_ATTRIBUTE2 IS NULL))) THEN

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

935: END IF;
936:
937: IF NOT ((tlinfo.PROJECT_ATTRIBUTE2 = X_PROJECT_ATTRIBUTE2)
938: OR ((tlinfo.PROJECT_ATTRIBUTE2 IS NULL) AND (X_PROJECT_ATTRIBUTE2 IS NULL))) THEN
939: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE2',tlinfo.PROJECT_ATTRIBUTE2);
940: END IF;
941:
942: IF NOT ((tlinfo.PROJECT_ATTRIBUTE3 = X_PROJECT_ATTRIBUTE3)
943: OR ((tlinfo.PROJECT_ATTRIBUTE3 IS NULL) AND (X_PROJECT_ATTRIBUTE3 IS NULL))) THEN

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

940: END IF;
941:
942: IF NOT ((tlinfo.PROJECT_ATTRIBUTE3 = X_PROJECT_ATTRIBUTE3)
943: OR ((tlinfo.PROJECT_ATTRIBUTE3 IS NULL) AND (X_PROJECT_ATTRIBUTE3 IS NULL))) THEN
944: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE3',tlinfo.PROJECT_ATTRIBUTE3);
945: END IF;
946:
947: IF NOT ((tlinfo.PROJECT_ATTRIBUTE4 = X_PROJECT_ATTRIBUTE4)
948: OR ((tlinfo.PROJECT_ATTRIBUTE4 IS NULL) AND (X_PROJECT_ATTRIBUTE4 IS NULL))) THEN

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

945: END IF;
946:
947: IF NOT ((tlinfo.PROJECT_ATTRIBUTE4 = X_PROJECT_ATTRIBUTE4)
948: OR ((tlinfo.PROJECT_ATTRIBUTE4 IS NULL) AND (X_PROJECT_ATTRIBUTE4 IS NULL))) THEN
949: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE4',tlinfo.PROJECT_ATTRIBUTE4);
950: END IF;
951:
952: IF NOT ((tlinfo.PROJECT_ATTRIBUTE5 = X_PROJECT_ATTRIBUTE5)
953: OR ((tlinfo.PROJECT_ATTRIBUTE5 IS NULL) AND (X_PROJECT_ATTRIBUTE5 IS NULL))) THEN

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

950: END IF;
951:
952: IF NOT ((tlinfo.PROJECT_ATTRIBUTE5 = X_PROJECT_ATTRIBUTE5)
953: OR ((tlinfo.PROJECT_ATTRIBUTE5 IS NULL) AND (X_PROJECT_ATTRIBUTE5 IS NULL))) THEN
954: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE5',tlinfo.PROJECT_ATTRIBUTE5);
955: END IF;
956:
957: IF NOT ((tlinfo.PROJECT_ATTRIBUTE6 = X_PROJECT_ATTRIBUTE6)
958: OR ((tlinfo.PROJECT_ATTRIBUTE6 IS NULL) AND (X_PROJECT_ATTRIBUTE6 IS NULL))) THEN

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

955: END IF;
956:
957: IF NOT ((tlinfo.PROJECT_ATTRIBUTE6 = X_PROJECT_ATTRIBUTE6)
958: OR ((tlinfo.PROJECT_ATTRIBUTE6 IS NULL) AND (X_PROJECT_ATTRIBUTE6 IS NULL))) THEN
959: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE6',tlinfo.PROJECT_ATTRIBUTE6);
960: END IF;
961:
962: IF NOT ((tlinfo.PROJECT_ATTRIBUTE7 = X_PROJECT_ATTRIBUTE7)
963: OR ((tlinfo.PROJECT_ATTRIBUTE7 IS NULL) AND (X_PROJECT_ATTRIBUTE7 IS NULL))) THEN

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

960: END IF;
961:
962: IF NOT ((tlinfo.PROJECT_ATTRIBUTE7 = X_PROJECT_ATTRIBUTE7)
963: OR ((tlinfo.PROJECT_ATTRIBUTE7 IS NULL) AND (X_PROJECT_ATTRIBUTE7 IS NULL))) THEN
964: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE7',tlinfo.PROJECT_ATTRIBUTE7);
965: END IF;
966:
967: IF NOT ((tlinfo.PROJECT_ATTRIBUTE8 = X_PROJECT_ATTRIBUTE8)
968: OR ((tlinfo.PROJECT_ATTRIBUTE8 IS NULL) AND (X_PROJECT_ATTRIBUTE8 IS NULL))) THEN

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

965: END IF;
966:
967: IF NOT ((tlinfo.PROJECT_ATTRIBUTE8 = X_PROJECT_ATTRIBUTE8)
968: OR ((tlinfo.PROJECT_ATTRIBUTE8 IS NULL) AND (X_PROJECT_ATTRIBUTE8 IS NULL))) THEN
969: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE8',tlinfo.PROJECT_ATTRIBUTE8);
970: END IF;
971:
972: IF NOT ((tlinfo.PROJECT_ATTRIBUTE9 = X_PROJECT_ATTRIBUTE9)
973: OR ((tlinfo.PROJECT_ATTRIBUTE9 IS NULL) AND (X_PROJECT_ATTRIBUTE9 IS NULL))) THEN

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

970: END IF;
971:
972: IF NOT ((tlinfo.PROJECT_ATTRIBUTE9 = X_PROJECT_ATTRIBUTE9)
973: OR ((tlinfo.PROJECT_ATTRIBUTE9 IS NULL) AND (X_PROJECT_ATTRIBUTE9 IS NULL))) THEN
974: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE9',tlinfo.PROJECT_ATTRIBUTE9);
975: END IF;
976:
977: IF NOT ((tlinfo.PROJECT_ATTRIBUTE10 = X_PROJECT_ATTRIBUTE10)
978: OR ((tlinfo.PROJECT_ATTRIBUTE10 IS NULL) AND (X_PROJECT_ATTRIBUTE10 IS NULL))) THEN

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

975: END IF;
976:
977: IF NOT ((tlinfo.PROJECT_ATTRIBUTE10 = X_PROJECT_ATTRIBUTE10)
978: OR ((tlinfo.PROJECT_ATTRIBUTE10 IS NULL) AND (X_PROJECT_ATTRIBUTE10 IS NULL))) THEN
979: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE10',tlinfo.PROJECT_ATTRIBUTE10);
980: END IF;
981:
982: IF NOT ((tlinfo.PROJECT_ATTRIBUTE11 = X_PROJECT_ATTRIBUTE11)
983: OR ((tlinfo.PROJECT_ATTRIBUTE11 IS NULL) AND (X_PROJECT_ATTRIBUTE11 IS NULL))) THEN

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

980: END IF;
981:
982: IF NOT ((tlinfo.PROJECT_ATTRIBUTE11 = X_PROJECT_ATTRIBUTE11)
983: OR ((tlinfo.PROJECT_ATTRIBUTE11 IS NULL) AND (X_PROJECT_ATTRIBUTE11 IS NULL))) THEN
984: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE11',tlinfo.PROJECT_ATTRIBUTE11);
985: END IF;
986:
987: IF NOT ((tlinfo.PROJECT_ATTRIBUTE12 = X_PROJECT_ATTRIBUTE12)
988: OR ((tlinfo.PROJECT_ATTRIBUTE12 IS NULL) AND (X_PROJECT_ATTRIBUTE12 IS NULL))) THEN

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

985: END IF;
986:
987: IF NOT ((tlinfo.PROJECT_ATTRIBUTE12 = X_PROJECT_ATTRIBUTE12)
988: OR ((tlinfo.PROJECT_ATTRIBUTE12 IS NULL) AND (X_PROJECT_ATTRIBUTE12 IS NULL))) THEN
989: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE12',tlinfo.PROJECT_ATTRIBUTE12);
990: END IF;
991:
992: IF NOT ((tlinfo.PROJECT_ATTRIBUTE13 = X_PROJECT_ATTRIBUTE13)
993: OR ((tlinfo.PROJECT_ATTRIBUTE13 IS NULL) AND (X_PROJECT_ATTRIBUTE13 IS NULL))) THEN

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

990: END IF;
991:
992: IF NOT ((tlinfo.PROJECT_ATTRIBUTE13 = X_PROJECT_ATTRIBUTE13)
993: OR ((tlinfo.PROJECT_ATTRIBUTE13 IS NULL) AND (X_PROJECT_ATTRIBUTE13 IS NULL))) THEN
994: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE13',tlinfo.PROJECT_ATTRIBUTE13);
995: END IF;
996:
997: IF NOT ((tlinfo.PROJECT_ATTRIBUTE14 = X_PROJECT_ATTRIBUTE14)
998: OR ((tlinfo.PROJECT_ATTRIBUTE14 IS NULL) AND (X_PROJECT_ATTRIBUTE14 IS NULL))) THEN

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

995: END IF;
996:
997: IF NOT ((tlinfo.PROJECT_ATTRIBUTE14 = X_PROJECT_ATTRIBUTE14)
998: OR ((tlinfo.PROJECT_ATTRIBUTE14 IS NULL) AND (X_PROJECT_ATTRIBUTE14 IS NULL))) THEN
999: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE14',tlinfo.PROJECT_ATTRIBUTE14);
1000: END IF;
1001:
1002: IF NOT ((tlinfo.PROJECT_ATTRIBUTE15 = X_PROJECT_ATTRIBUTE15)
1003: OR ((tlinfo.PROJECT_ATTRIBUTE15 IS NULL) AND (X_PROJECT_ATTRIBUTE15 IS NULL))) THEN

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

1000: END IF;
1001:
1002: IF NOT ((tlinfo.PROJECT_ATTRIBUTE15 = X_PROJECT_ATTRIBUTE15)
1003: OR ((tlinfo.PROJECT_ATTRIBUTE15 IS NULL) AND (X_PROJECT_ATTRIBUTE15 IS NULL))) THEN
1004: pn_var_rent_pkg.lock_row_exception('PROJECT_ATTRIBUTE15',tlinfo.PROJECT_ATTRIBUTE15);
1005: END IF;
1006:
1007: IF NOT ((tlinfo.VAR_RENT_INV_ID = X_VAR_RENT_INV_ID)
1008: OR ((tlinfo.VAR_RENT_INV_ID IS NULL) AND (X_VAR_RENT_INV_ID IS NULL))) THEN

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

1005: END IF;
1006:
1007: IF NOT ((tlinfo.VAR_RENT_INV_ID = X_VAR_RENT_INV_ID)
1008: OR ((tlinfo.VAR_RENT_INV_ID IS NULL) AND (X_VAR_RENT_INV_ID IS NULL))) THEN
1009: pn_var_rent_pkg.lock_row_exception('VAR_RENT_INV_ID',tlinfo.VAR_RENT_INV_ID);
1010: END IF;
1011:
1012: IF NOT ((tlinfo.VAR_RENT_TYPE = X_VAR_RENT_TYPE)
1013: OR ((tlinfo.VAR_RENT_TYPE IS NULL) AND (X_VAR_RENT_TYPE IS NULL))) THEN

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

1010: END IF;
1011:
1012: IF NOT ((tlinfo.VAR_RENT_TYPE = X_VAR_RENT_TYPE)
1013: OR ((tlinfo.VAR_RENT_TYPE IS NULL) AND (X_VAR_RENT_TYPE IS NULL))) THEN
1014: pn_var_rent_pkg.lock_row_exception('VAR_RENT_TYPE',tlinfo.VAR_RENT_TYPE);
1015: END IF;
1016:
1017: IF NOT ((tlinfo.recoverable_flag = x_recoverable_flag)
1018: OR ((tlinfo.recoverable_flag IS NULL) AND (x_recoverable_flag IS NULL))) THEN

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

1015: END IF;
1016:
1017: IF NOT ((tlinfo.recoverable_flag = x_recoverable_flag)
1018: OR ((tlinfo.recoverable_flag IS NULL) AND (x_recoverable_flag IS NULL))) THEN
1019: pn_var_rent_pkg.lock_row_exception('RECOVERABLE_FLAG',tlinfo.recoverable_flag);
1020: END IF;
1021:
1022: IF NOT ((tlinfo.area_type_code = x_area_type_code)
1023: OR ((tlinfo.area_type_code IS NULL) AND (x_area_type_code IS NULL))) THEN

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

1020: END IF;
1021:
1022: IF NOT ((tlinfo.area_type_code = x_area_type_code)
1023: OR ((tlinfo.area_type_code IS NULL) AND (x_area_type_code IS NULL))) THEN
1024: pn_var_rent_pkg.lock_row_exception('AREA_TYPE_CODE',tlinfo.area_type_code);
1025: END IF;
1026:
1027: IF NOT ((tlinfo.area = x_area)
1028: OR ((tlinfo.area IS NULL) AND (x_area IS NULL))) THEN

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

1025: END IF;
1026:
1027: IF NOT ((tlinfo.area = x_area)
1028: OR ((tlinfo.area IS NULL) AND (x_area IS NULL))) THEN
1029: pn_var_rent_pkg.lock_row_exception('AREA',tlinfo.area);
1030: END IF;
1031:
1032: IF NOT ((tlinfo.grouping_rule_id = x_grouping_rule_id)
1033: OR ((tlinfo.grouping_rule_id IS NULL) AND (x_grouping_rule_id IS NULL))) THEN

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

1030: END IF;
1031:
1032: IF NOT ((tlinfo.grouping_rule_id = x_grouping_rule_id)
1033: OR ((tlinfo.grouping_rule_id IS NULL) AND (x_grouping_rule_id IS NULL))) THEN
1034: pn_var_rent_pkg.lock_row_exception('GROUPING_RULE_ID',tlinfo.grouping_rule_id);
1035: END IF;
1036:
1037: IF NOT ((tlinfo.term_comments = x_term_comments)
1038: OR ((tlinfo.term_comments IS NULL) AND (x_term_comments IS NULL))) THEN

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

1035: END IF;
1036:
1037: IF NOT ((tlinfo.term_comments = x_term_comments)
1038: OR ((tlinfo.term_comments IS NULL) AND (x_term_comments IS NULL))) THEN
1039: pn_var_rent_pkg.lock_row_exception('TERM_COMMENTS',tlinfo.term_comments);
1040: END IF;
1041:
1042: IF NOT ((tlinfo.TERM_TEMPLATE_ID = X_TERM_TEMPLATE_ID)
1043: OR ((tlinfo.TERM_TEMPLATE_ID IS NULL) AND (X_TERM_TEMPLATE_ID IS NULL))) THEN

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

1040: END IF;
1041:
1042: IF NOT ((tlinfo.TERM_TEMPLATE_ID = X_TERM_TEMPLATE_ID)
1043: OR ((tlinfo.TERM_TEMPLATE_ID IS NULL) AND (X_TERM_TEMPLATE_ID IS NULL))) THEN
1044: pn_var_rent_pkg.lock_row_exception('TERM_TEMPLATE_ID',tlinfo.TERM_TEMPLATE_ID);
1045: END IF;
1046:
1047: IF NOT ((tlinfo.include_in_var_rent = x_include_in_var_rent)
1048: OR ((tlinfo.include_in_var_rent IS NULL) AND (x_include_in_var_rent IS NULL))) THEN

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

1045: END IF;
1046:
1047: IF NOT ((tlinfo.include_in_var_rent = x_include_in_var_rent)
1048: OR ((tlinfo.include_in_var_rent IS NULL) AND (x_include_in_var_rent IS NULL))) THEN
1049: pn_var_rent_pkg.lock_row_exception('INCLUDE_IN_VAR_RENT',tlinfo.include_in_var_rent);
1050: END IF;
1051:
1052: IF NOT ((tlinfo.recur_bb_calc_date = x_recur_bb_calc_date)
1053: OR ((tlinfo.recur_bb_calc_date IS NULL) AND (x_recur_bb_calc_date IS NULL))) THEN

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

1050: END IF;
1051:
1052: IF NOT ((tlinfo.recur_bb_calc_date = x_recur_bb_calc_date)
1053: OR ((tlinfo.recur_bb_calc_date IS NULL) AND (x_recur_bb_calc_date IS NULL))) THEN
1054: pn_var_rent_pkg.lock_row_exception('RECUR_BB_CALC_DATE',tlinfo.recur_bb_calc_date);
1055: END IF;
1056:
1057: IF NOT ((tlinfo.opex_agr_id = x_opex_agr_id)
1058: OR ((tlinfo.opex_agr_id IS NULL) AND (x_opex_agr_id IS NULL))) THEN

Line 1059: pn_var_rent_pkg.lock_row_exception('OPEX_AGR_ID',tlinfo.opex_agr_id);

1055: END IF;
1056:
1057: IF NOT ((tlinfo.opex_agr_id = x_opex_agr_id)
1058: OR ((tlinfo.opex_agr_id IS NULL) AND (x_opex_agr_id IS NULL))) THEN
1059: pn_var_rent_pkg.lock_row_exception('OPEX_AGR_ID',tlinfo.opex_agr_id);
1060: END IF;
1061:
1062: IF NOT ((tlinfo.opex_recon_id = x_opex_recon_id)
1063: OR ((tlinfo.opex_recon_id IS NULL) AND (x_opex_recon_id IS NULL))) THEN

Line 1064: pn_var_rent_pkg.lock_row_exception('OPEX_RECON_ID',tlinfo.opex_recon_id);

1060: END IF;
1061:
1062: IF NOT ((tlinfo.opex_recon_id = x_opex_recon_id)
1063: OR ((tlinfo.opex_recon_id IS NULL) AND (x_opex_recon_id IS NULL))) THEN
1064: pn_var_rent_pkg.lock_row_exception('OPEX_RECON_ID',tlinfo.opex_recon_id);
1065: END IF;
1066:
1067: IF NOT ((tlinfo.opex_type = x_opex_type)
1068: OR ((tlinfo.opex_type IS NULL) AND (x_opex_type IS NULL))) THEN

Line 1069: pn_var_rent_pkg.lock_row_exception('RECUR_BB_CALC_DATE',tlinfo.opex_type);

1065: END IF;
1066:
1067: IF NOT ((tlinfo.opex_type = x_opex_type)
1068: OR ((tlinfo.opex_type IS NULL) AND (x_opex_type IS NULL))) THEN
1069: pn_var_rent_pkg.lock_row_exception('RECUR_BB_CALC_DATE',tlinfo.opex_type);
1070: END IF;
1071:
1072: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.LOCK_ROW (-)');
1073: