APPS.PN_TERM_TEMPLATES_PKG dependencies on PN_VAR_RENT_PKG

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

504:
505: CLOSE c1;
506:
507: IF NOT (tlinfo.term_template_id = x_term_template_id ) THEN
508: pn_var_rent_pkg.lock_row_exception('TERM_TEMPLATE_ID',tlinfo.term_template_id);
509: END IF;
510:
511: IF NOT (tlinfo.name = x_name ) THEN
512: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.name);

Line 512: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.name);

508: pn_var_rent_pkg.lock_row_exception('TERM_TEMPLATE_ID',tlinfo.term_template_id);
509: END IF;
510:
511: IF NOT (tlinfo.name = x_name ) THEN
512: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.name);
513: END IF;
514:
515: IF NOT (tlinfo.set_of_books_id = x_set_of_books_id ) THEN
516: pn_var_rent_pkg.lock_row_exception('SET_OF_BOOKS_ID',tlinfo.set_of_books_id);

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

512: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.name);
513: END IF;
514:
515: IF NOT (tlinfo.set_of_books_id = x_set_of_books_id ) THEN
516: pn_var_rent_pkg.lock_row_exception('SET_OF_BOOKS_ID',tlinfo.set_of_books_id);
517: END IF;
518:
519: IF NOT ((tlinfo.currency_code = x_currency_code ) OR
520: (tlinfo.currency_code = null) AND (x_currency_code = null))

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

518:
519: IF NOT ((tlinfo.currency_code = x_currency_code ) OR
520: (tlinfo.currency_code = null) AND (x_currency_code = null))
521: THEN
522: pn_var_rent_pkg.lock_row_exception('CURRENCY_CODE',tlinfo.currency_code);
523: END IF;
524:
525: IF NOT ((tlinfo.normalize = x_normalize ) OR
526: (tlinfo.normalize = null) AND (x_normalize = null))

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

524:
525: IF NOT ((tlinfo.normalize = x_normalize ) OR
526: (tlinfo.normalize = null) AND (x_normalize = null))
527: THEN
528: pn_var_rent_pkg.lock_row_exception('NORMALIZE',tlinfo.normalize);
529: END IF;
530:
531: IF NOT ((tlinfo.schedule_day = x_schedule_day ) OR
532: (tlinfo.schedule_day = null) AND (x_schedule_day = null))

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

530:
531: IF NOT ((tlinfo.schedule_day = x_schedule_day ) OR
532: (tlinfo.schedule_day = null) AND (x_schedule_day = null))
533: THEN
534: pn_var_rent_pkg.lock_row_exception('SCHEDULE_DAY',tlinfo.schedule_day);
535: END IF;
536:
537: IF NOT ((tlinfo.payment_purpose_code = x_payment_purpose_code ) OR
538: (tlinfo.payment_purpose_code = null) AND (x_payment_purpose_code = null))

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

536:
537: IF NOT ((tlinfo.payment_purpose_code = x_payment_purpose_code ) OR
538: (tlinfo.payment_purpose_code = null) AND (x_payment_purpose_code = null))
539: THEN
540: pn_var_rent_pkg.lock_row_exception('PAYMENT_PURPOSE_CODE',tlinfo.payment_purpose_code);
541: END IF;
542:
543: IF NOT ((tlinfo.payment_term_type_code = x_payment_term_type_code ) OR
544: (tlinfo.payment_term_type_code = null) AND (x_payment_term_type_code = null))

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

542:
543: IF NOT ((tlinfo.payment_term_type_code = x_payment_term_type_code ) OR
544: (tlinfo.payment_term_type_code = null) AND (x_payment_term_type_code = null))
545: THEN
546: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_TYPE_CODE',tlinfo.payment_term_type_code);
547: END IF;
548:
549: IF NOT ((tlinfo.accrual_account_id = x_accrual_account_id ) OR
550: (tlinfo.accrual_account_id = null) AND (x_accrual_account_id = null))

Line 552: pn_var_rent_pkg.lock_row_exception('ACCRUAL_ACCOUNT_ID',tlinfo.accrual_account_id);

548:
549: IF NOT ((tlinfo.accrual_account_id = x_accrual_account_id ) OR
550: (tlinfo.accrual_account_id = null) AND (x_accrual_account_id = null))
551: THEN
552: pn_var_rent_pkg.lock_row_exception('ACCRUAL_ACCOUNT_ID',tlinfo.accrual_account_id);
553: END IF;
554:
555: IF NOT ((tlinfo.project_id = x_project_id ) OR
556: (tlinfo.project_id = null) AND (x_project_id = null))

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

554:
555: IF NOT ((tlinfo.project_id = x_project_id ) OR
556: (tlinfo.project_id = null) AND (x_project_id = null))
557: THEN
558: pn_var_rent_pkg.lock_row_exception('PROJECT_ID',tlinfo.project_id);
559: END IF;
560:
561: IF NOT ((tlinfo.task_id = x_task_id ) OR
562: (tlinfo.task_id = null) AND (x_task_id = null))

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

560:
561: IF NOT ((tlinfo.task_id = x_task_id ) OR
562: (tlinfo.task_id = null) AND (x_task_id = null))
563: THEN
564: pn_var_rent_pkg.lock_row_exception('TASK_ID',tlinfo.task_id);
565: END IF;
566:
567: IF NOT ((tlinfo.organization_id = x_organization_id ) OR
568: (tlinfo.organization_id = null) AND (x_organization_id = null))

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

566:
567: IF NOT ((tlinfo.organization_id = x_organization_id ) OR
568: (tlinfo.organization_id = null) AND (x_organization_id = null))
569: THEN
570: pn_var_rent_pkg.lock_row_exception('ORGANIZATION_ID',tlinfo.organization_id);
571: END IF;
572:
573: IF NOT ((tlinfo.expenditure_type = x_expenditure_type ) OR
574: (tlinfo.expenditure_type = null) AND (x_expenditure_type = null))

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

572:
573: IF NOT ((tlinfo.expenditure_type = x_expenditure_type ) OR
574: (tlinfo.expenditure_type = null) AND (x_expenditure_type = null))
575: THEN
576: pn_var_rent_pkg.lock_row_exception('EXPENDITURE_TYPE',tlinfo.expenditure_type);
577: END IF;
578:
579: IF NOT ((tlinfo.expenditure_item_date = x_expenditure_item_date ) OR
580: (tlinfo.expenditure_item_date = null) AND (x_expenditure_item_date = null))

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

578:
579: IF NOT ((tlinfo.expenditure_item_date = x_expenditure_item_date ) OR
580: (tlinfo.expenditure_item_date = null) AND (x_expenditure_item_date = null))
581: THEN
582: pn_var_rent_pkg.lock_row_exception('EXPENDITURE_ITEM_DATE',tlinfo.expenditure_item_date);
583: END IF;
584:
585: IF NOT ((tlinfo.vendor_id = x_vendor_id ) OR
586: (tlinfo.vendor_id = null) AND (x_vendor_id = null))

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

584:
585: IF NOT ((tlinfo.vendor_id = x_vendor_id ) OR
586: (tlinfo.vendor_id = null) AND (x_vendor_id = null))
587: THEN
588: pn_var_rent_pkg.lock_row_exception('VENDOR_ID',tlinfo.vendor_id);
589: END IF;
590:
591: IF NOT ((tlinfo.vendor_site_id = x_vendor_site_id ) OR
592: (tlinfo.vendor_site_id = null) AND (x_vendor_site_id = null))

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

590:
591: IF NOT ((tlinfo.vendor_site_id = x_vendor_site_id ) OR
592: (tlinfo.vendor_site_id = null) AND (x_vendor_site_id = null))
593: THEN
594: pn_var_rent_pkg.lock_row_exception('VENDOR_SITE_ID',tlinfo.vendor_site_id);
595: END IF;
596:
597: IF NOT ((tlinfo.customer_id = x_customer_id ) OR
598: (tlinfo.customer_id = null) AND (x_customer_id = null))

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

596:
597: IF NOT ((tlinfo.customer_id = x_customer_id ) OR
598: (tlinfo.customer_id = null) AND (x_customer_id = null))
599: THEN
600: pn_var_rent_pkg.lock_row_exception('CUSTOMER_ID',tlinfo.customer_id);
601: END IF;
602:
603: IF NOT ((tlinfo.customer_site_use_id = x_customer_site_use_id ) OR
604: (tlinfo.customer_site_use_id = null) AND (x_customer_site_use_id = null))

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

602:
603: IF NOT ((tlinfo.customer_site_use_id = x_customer_site_use_id ) OR
604: (tlinfo.customer_site_use_id = null) AND (x_customer_site_use_id = null))
605: THEN
606: pn_var_rent_pkg.lock_row_exception('CUSTOMER_SITE_USE_ID',tlinfo.customer_site_use_id);
607: END IF;
608:
609: IF NOT ((tlinfo.cust_ship_site_id = x_cust_ship_site_id ) OR
610: (tlinfo.cust_ship_site_id = null) AND (x_cust_ship_site_id = null))

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

608:
609: IF NOT ((tlinfo.cust_ship_site_id = x_cust_ship_site_id ) OR
610: (tlinfo.cust_ship_site_id = null) AND (x_cust_ship_site_id = null))
611: THEN
612: pn_var_rent_pkg.lock_row_exception('CUST_SHIP_SITE_ID',tlinfo.cust_ship_site_id);
613: END IF;
614:
615: IF NOT ((tlinfo.ap_ar_term_id = x_ap_ar_term_id ) OR
616: (tlinfo.ap_ar_term_id = null) AND (x_ap_ar_term_id = null))

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

614:
615: IF NOT ((tlinfo.ap_ar_term_id = x_ap_ar_term_id ) OR
616: (tlinfo.ap_ar_term_id = null) AND (x_ap_ar_term_id = null))
617: THEN
618: pn_var_rent_pkg.lock_row_exception('AP_AR_TERM_ID',tlinfo.ap_ar_term_id);
619: END IF;
620:
621: IF NOT ((tlinfo.cust_trx_type_id = x_cust_trx_type_id ) OR
622: (tlinfo.cust_trx_type_id = null) AND (x_cust_trx_type_id = null))

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

620:
621: IF NOT ((tlinfo.cust_trx_type_id = x_cust_trx_type_id ) OR
622: (tlinfo.cust_trx_type_id = null) AND (x_cust_trx_type_id = null))
623: THEN
624: pn_var_rent_pkg.lock_row_exception('CUST_TRX_TYPE_ID',tlinfo.cust_trx_type_id);
625: END IF;
626:
627: IF pn_r12_util_pkg.is_r12 AND
628: NOT ((tlinfo.tax_classification_code = x_tax_classification_code ) OR

Line 631: pn_var_rent_pkg.lock_row_exception('TAX_CLASSIFICATION_CODE',tlinfo.tax_classification_code);

627: IF pn_r12_util_pkg.is_r12 AND
628: NOT ((tlinfo.tax_classification_code = x_tax_classification_code ) OR
629: (tlinfo.tax_classification_code = null) AND (x_tax_classification_code = null))
630: THEN
631: pn_var_rent_pkg.lock_row_exception('TAX_CLASSIFICATION_CODE',tlinfo.tax_classification_code);
632: END IF;
633:
634: IF NOT pn_r12_util_pkg.is_r12 AND
635: NOT ((tlinfo.tax_group_id = x_tax_group_id ) OR

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

634: IF NOT pn_r12_util_pkg.is_r12 AND
635: NOT ((tlinfo.tax_group_id = x_tax_group_id ) OR
636: (tlinfo.tax_group_id = null) AND (x_tax_group_id = null))
637: THEN
638: pn_var_rent_pkg.lock_row_exception('TAX_GROUP_ID',tlinfo.tax_group_id);
639: END IF;
640:
641: IF NOT pn_r12_util_pkg.is_r12 AND
642: NOT ((tlinfo.tax_code_id = x_tax_code_id ) OR

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

641: IF NOT pn_r12_util_pkg.is_r12 AND
642: NOT ((tlinfo.tax_code_id = x_tax_code_id ) OR
643: (tlinfo.tax_code_id = null) AND (x_tax_code_id = null))
644: THEN
645: pn_var_rent_pkg.lock_row_exception('TAX_CODE_ID',tlinfo.tax_code_id);
646: END IF;
647:
648: IF NOT ((tlinfo.distribution_set_id = x_distribution_set_id ) OR
649: (tlinfo.distribution_set_id = null) AND (x_distribution_set_id = null))

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

647:
648: IF NOT ((tlinfo.distribution_set_id = x_distribution_set_id ) OR
649: (tlinfo.distribution_set_id = null) AND (x_distribution_set_id = null))
650: THEN
651: pn_var_rent_pkg.lock_row_exception('DISTRIBUTION_SET_ID',tlinfo.distribution_set_id);
652: END IF;
653:
654: IF NOT ((tlinfo.inv_rule_id = x_inv_rule_id ) OR
655: (tlinfo.inv_rule_id = null) AND (x_inv_rule_id = null))

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

653:
654: IF NOT ((tlinfo.inv_rule_id = x_inv_rule_id ) OR
655: (tlinfo.inv_rule_id = null) AND (x_inv_rule_id = null))
656: THEN
657: pn_var_rent_pkg.lock_row_exception('INV_RULE_ID',tlinfo.inv_rule_id);
658: END IF;
659:
660: IF NOT ((tlinfo.account_rule_id = x_account_rule_id ) OR
661: (tlinfo.account_rule_id = null) AND (x_account_rule_id = null))

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

659:
660: IF NOT ((tlinfo.account_rule_id = x_account_rule_id ) OR
661: (tlinfo.account_rule_id = null) AND (x_account_rule_id = null))
662: THEN
663: pn_var_rent_pkg.lock_row_exception('ACCOUNT_RULE_ID',tlinfo.account_rule_id);
664: END IF;
665:
666: IF NOT ((tlinfo.salesrep_id = x_salesrep_id ) OR
667: (tlinfo.salesrep_id = null) AND (x_salesrep_id = null))

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

665:
666: IF NOT ((tlinfo.salesrep_id = x_salesrep_id ) OR
667: (tlinfo.salesrep_id = null) AND (x_salesrep_id = null))
668: THEN
669: pn_var_rent_pkg.lock_row_exception('SALESREP_ID',tlinfo.salesrep_id);
670: END IF;
671:
672: IF NOT ((tlinfo.tax_included = x_tax_included ) OR
673: (tlinfo.tax_included = null) AND (x_tax_included = null))

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

671:
672: IF NOT ((tlinfo.tax_included = x_tax_included ) OR
673: (tlinfo.tax_included = null) AND (x_tax_included = null))
674: THEN
675: pn_var_rent_pkg.lock_row_exception('TAX_INCLUDED',tlinfo.tax_included);
676: END IF;
677:
678: IF NOT ((tlinfo.po_header_id = x_po_header_id ) OR
679: (tlinfo.po_header_id = null) AND (x_po_header_id = null))

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

677:
678: IF NOT ((tlinfo.po_header_id = x_po_header_id ) OR
679: (tlinfo.po_header_id = null) AND (x_po_header_id = null))
680: THEN
681: pn_var_rent_pkg.lock_row_exception('PO_HEADER_ID',tlinfo.po_header_id);
682: END IF;
683:
684: IF NOT ((tlinfo.cust_po_number = x_cust_po_number ) OR
685: (tlinfo.cust_po_number = null) AND (x_cust_po_number = null))

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

683:
684: IF NOT ((tlinfo.cust_po_number = x_cust_po_number ) OR
685: (tlinfo.cust_po_number = null) AND (x_cust_po_number = null))
686: THEN
687: pn_var_rent_pkg.lock_row_exception('CUST_PO_NUMBER',tlinfo.cust_po_number);
688: END IF;
689:
690: IF NOT ((tlinfo.receipt_method_id = x_receipt_method_id ) OR
691: (tlinfo.receipt_method_id = null) AND (x_receipt_method_id = null))

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

689:
690: IF NOT ((tlinfo.receipt_method_id = x_receipt_method_id ) OR
691: (tlinfo.receipt_method_id = null) AND (x_receipt_method_id = null))
692: THEN
693: pn_var_rent_pkg.lock_row_exception('RECEIPT_METHOD_ID',tlinfo.receipt_method_id);
694: END IF;
695:
696: IF NOT ((tlinfo.active = x_active ) OR
697: (tlinfo.active = null) AND (x_active = null))

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

695:
696: IF NOT ((tlinfo.active = x_active ) OR
697: (tlinfo.active = null) AND (x_active = null))
698: THEN
699: pn_var_rent_pkg.lock_row_exception('ACTIVE',tlinfo.active);
700: END IF;
701:
702: IF NOT ((tlinfo.description = x_description ) OR
703: (tlinfo.description = null) AND (x_description = null))

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

701:
702: IF NOT ((tlinfo.description = x_description ) OR
703: (tlinfo.description = null) AND (x_description = null))
704: THEN
705: pn_var_rent_pkg.lock_row_exception('DESCRIPTION',tlinfo.description);
706: END IF;
707:
708: IF NOT ((tlinfo.location_id = x_location_id ) OR
709: (tlinfo.location_id = null) AND (x_location_id = null))

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

707:
708: IF NOT ((tlinfo.location_id = x_location_id ) OR
709: (tlinfo.location_id = null) AND (x_location_id = null))
710: THEN
711: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.location_id);
712: END IF;
713:
714: IF NOT ((tlinfo.attribute_category = x_attribute_category ) OR
715: (tlinfo.attribute_category = null) AND (x_attribute_category = null))

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

713:
714: IF NOT ((tlinfo.attribute_category = x_attribute_category ) OR
715: (tlinfo.attribute_category = null) AND (x_attribute_category = null))
716: THEN
717: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.attribute_category);
718: END IF;
719:
720: IF NOT ((tlinfo.attribute1 = x_attribute1 ) OR
721: (tlinfo.attribute1 = null) AND (x_attribute1 = null))

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

719:
720: IF NOT ((tlinfo.attribute1 = x_attribute1 ) OR
721: (tlinfo.attribute1 = null) AND (x_attribute1 = null))
722: THEN
723: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.attribute1);
724: END IF;
725:
726: IF NOT ((tlinfo.attribute2 = x_attribute2 ) OR
727: (tlinfo.attribute2 = null) AND (x_attribute2 = null))

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

725:
726: IF NOT ((tlinfo.attribute2 = x_attribute2 ) OR
727: (tlinfo.attribute2 = null) AND (x_attribute2 = null))
728: THEN
729: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.attribute2);
730: END IF;
731:
732: IF NOT ((tlinfo.attribute3 = x_attribute3 ) OR
733: (tlinfo.attribute3 = null) AND (x_attribute3 = null))

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

731:
732: IF NOT ((tlinfo.attribute3 = x_attribute3 ) OR
733: (tlinfo.attribute3 = null) AND (x_attribute3 = null))
734: THEN
735: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.attribute3);
736: END IF;
737:
738: IF NOT ((tlinfo.attribute4 = x_attribute4 ) OR
739: (tlinfo.attribute4 = null) AND (x_attribute4 = null))

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

737:
738: IF NOT ((tlinfo.attribute4 = x_attribute4 ) OR
739: (tlinfo.attribute4 = null) AND (x_attribute4 = null))
740: THEN
741: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.attribute4);
742: END IF;
743:
744: IF NOT ((tlinfo.attribute5 = x_attribute5 ) OR
745: (tlinfo.attribute5 = null) AND (x_attribute5 = null))

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

743:
744: IF NOT ((tlinfo.attribute5 = x_attribute5 ) OR
745: (tlinfo.attribute5 = null) AND (x_attribute5 = null))
746: THEN
747: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.attribute5);
748: END IF;
749:
750: IF NOT ((tlinfo.attribute6 = x_attribute6 ) OR
751: (tlinfo.attribute6 = null) AND (x_attribute6 = null))

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

749:
750: IF NOT ((tlinfo.attribute6 = x_attribute6 ) OR
751: (tlinfo.attribute6 = null) AND (x_attribute6 = null))
752: THEN
753: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.attribute6);
754: END IF;
755:
756: IF NOT ((tlinfo.attribute7 = x_attribute7 ) OR
757: (tlinfo.attribute7 = null) AND (x_attribute7 = null))

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

755:
756: IF NOT ((tlinfo.attribute7 = x_attribute7 ) OR
757: (tlinfo.attribute7 = null) AND (x_attribute7 = null))
758: THEN
759: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.attribute7);
760: END IF;
761:
762: IF NOT ((tlinfo.attribute8 = x_attribute8 ) OR
763: (tlinfo.attribute8 = null) AND (x_attribute8 = null))

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

761:
762: IF NOT ((tlinfo.attribute8 = x_attribute8 ) OR
763: (tlinfo.attribute8 = null) AND (x_attribute8 = null))
764: THEN
765: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.attribute8);
766: END IF;
767:
768: IF NOT ((tlinfo.attribute9 = x_attribute9 ) OR
769: (tlinfo.attribute9 = null) AND (x_attribute9 = null))

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

767:
768: IF NOT ((tlinfo.attribute9 = x_attribute9 ) OR
769: (tlinfo.attribute9 = null) AND (x_attribute9 = null))
770: THEN
771: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.attribute9);
772: END IF;
773:
774: IF NOT ((tlinfo.attribute10 = x_attribute10 ) OR
775: (tlinfo.attribute10 = null) AND (x_attribute10 = null))

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

773:
774: IF NOT ((tlinfo.attribute10 = x_attribute10 ) OR
775: (tlinfo.attribute10 = null) AND (x_attribute10 = null))
776: THEN
777: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.attribute10);
778: END IF;
779:
780: IF NOT ((tlinfo.attribute11 = x_attribute11 ) OR
781: (tlinfo.attribute11 = null) AND (x_attribute11 = null))

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

779:
780: IF NOT ((tlinfo.attribute11 = x_attribute11 ) OR
781: (tlinfo.attribute11 = null) AND (x_attribute11 = null))
782: THEN
783: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.attribute11);
784: END IF;
785:
786: IF NOT ((tlinfo.attribute12 = x_attribute12 ) OR
787: (tlinfo.attribute12 = null) AND (x_attribute12 = null))

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

785:
786: IF NOT ((tlinfo.attribute12 = x_attribute12 ) OR
787: (tlinfo.attribute12 = null) AND (x_attribute12 = null))
788: THEN
789: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.attribute12);
790: END IF;
791:
792: IF NOT ((tlinfo.attribute13 = x_attribute13 ) OR
793: (tlinfo.attribute13 = null) AND (x_attribute13 = null))

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

791:
792: IF NOT ((tlinfo.attribute13 = x_attribute13 ) OR
793: (tlinfo.attribute13 = null) AND (x_attribute13 = null))
794: THEN
795: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.attribute13);
796: END IF;
797:
798: IF NOT ((tlinfo.attribute14 = x_attribute14 ) OR
799: (tlinfo.attribute14 = null) AND (x_attribute14 = null))

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

797:
798: IF NOT ((tlinfo.attribute14 = x_attribute14 ) OR
799: (tlinfo.attribute14 = null) AND (x_attribute14 = null))
800: THEN
801: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.attribute14);
802: END IF;
803:
804: IF NOT ((tlinfo.attribute15 = x_attribute15 ) OR
805: (tlinfo.attribute15 = null) AND (x_attribute15 = null))

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

803:
804: IF NOT ((tlinfo.attribute15 = x_attribute15 ) OR
805: (tlinfo.attribute15 = null) AND (x_attribute15 = null))
806: THEN
807: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.attribute15);
808: END IF;
809:
810: PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.lock_row (-)');
811: