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_COMP_SITE_PKG dependencies on PN_VAR_RENT_PKG

Line 570: pn_var_rent_pkg.lock_row_exception('company_site_id',Recinfo.company_site_id);

566: END IF;
567: CLOSE C;
568:
569: IF NOT (Recinfo.company_site_id = x_company_site_id) THEN
570: pn_var_rent_pkg.lock_row_exception('company_site_id',Recinfo.company_site_id);
571: END IF;
572: IF NOT (Recinfo.name = x_name) THEN
573: pn_var_rent_pkg.lock_row_exception('name',Recinfo.name);
574: END IF;

Line 573: pn_var_rent_pkg.lock_row_exception('name',Recinfo.name);

569: IF NOT (Recinfo.company_site_id = x_company_site_id) THEN
570: pn_var_rent_pkg.lock_row_exception('company_site_id',Recinfo.company_site_id);
571: END IF;
572: IF NOT (Recinfo.name = x_name) THEN
573: pn_var_rent_pkg.lock_row_exception('name',Recinfo.name);
574: END IF;
575: IF NOT (Recinfo.enabled_flag = x_enabled_flag) THEN
576: pn_var_rent_pkg.lock_row_exception('enabled_flag',Recinfo.enabled_flag);
577: END IF;

Line 576: pn_var_rent_pkg.lock_row_exception('enabled_flag',Recinfo.enabled_flag);

572: IF NOT (Recinfo.name = x_name) THEN
573: pn_var_rent_pkg.lock_row_exception('name',Recinfo.name);
574: END IF;
575: IF NOT (Recinfo.enabled_flag = x_enabled_flag) THEN
576: pn_var_rent_pkg.lock_row_exception('enabled_flag',Recinfo.enabled_flag);
577: END IF;
578: IF NOT ((Recinfo.company_id = x_company_id)
579: or ((Recinfo.company_id is null) and (x_company_id is null))) THEN
580: pn_var_rent_pkg.lock_row_exception('company_id',Recinfo.company_id);

Line 580: pn_var_rent_pkg.lock_row_exception('company_id',Recinfo.company_id);

576: pn_var_rent_pkg.lock_row_exception('enabled_flag',Recinfo.enabled_flag);
577: END IF;
578: IF NOT ((Recinfo.company_id = x_company_id)
579: or ((Recinfo.company_id is null) and (x_company_id is null))) THEN
580: pn_var_rent_pkg.lock_row_exception('company_id',Recinfo.company_id);
581: END IF;
582: IF NOT ((Recinfo.lease_role_type = x_lease_role_type)
583: or ((Recinfo.lease_role_type is null) and (x_lease_role_type is null))) THEN
584: pn_var_rent_pkg.lock_row_exception('lease_role_type',Recinfo.lease_role_type);

Line 584: pn_var_rent_pkg.lock_row_exception('lease_role_type',Recinfo.lease_role_type);

580: pn_var_rent_pkg.lock_row_exception('company_id',Recinfo.company_id);
581: END IF;
582: IF NOT ((Recinfo.lease_role_type = x_lease_role_type)
583: or ((Recinfo.lease_role_type is null) and (x_lease_role_type is null))) THEN
584: pn_var_rent_pkg.lock_row_exception('lease_role_type',Recinfo.lease_role_type);
585: END IF;
586: IF NOT ((Recinfo.company_site_code = x_company_site_code)
587: or ((Recinfo.company_site_code is null) and (x_company_site_code is null))) THEN
588: pn_var_rent_pkg.lock_row_exception('company_site_code',Recinfo.company_site_code);

Line 588: pn_var_rent_pkg.lock_row_exception('company_site_code',Recinfo.company_site_code);

584: pn_var_rent_pkg.lock_row_exception('lease_role_type',Recinfo.lease_role_type);
585: END IF;
586: IF NOT ((Recinfo.company_site_code = x_company_site_code)
587: or ((Recinfo.company_site_code is null) and (x_company_site_code is null))) THEN
588: pn_var_rent_pkg.lock_row_exception('company_site_code',Recinfo.company_site_code);
589: END IF;
590: IF NOT ((Recinfo.address_id = x_address_id)
591: or ((Recinfo.address_id is null) and (x_address_id is null))) THEN
592: pn_var_rent_pkg.lock_row_exception('address_id',Recinfo.address_id);

Line 592: pn_var_rent_pkg.lock_row_exception('address_id',Recinfo.address_id);

588: pn_var_rent_pkg.lock_row_exception('company_site_code',Recinfo.company_site_code);
589: END IF;
590: IF NOT ((Recinfo.address_id = x_address_id)
591: or ((Recinfo.address_id is null) and (x_address_id is null))) THEN
592: pn_var_rent_pkg.lock_row_exception('address_id',Recinfo.address_id);
593: END IF;
594: IF NOT ((Recinfo.attribute11 = x_attribute11)
595: or ((Recinfo.attribute11 is null) and (x_attribute11 is null))) THEN
596: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);

Line 596: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);

592: pn_var_rent_pkg.lock_row_exception('address_id',Recinfo.address_id);
593: END IF;
594: IF NOT ((Recinfo.attribute11 = x_attribute11)
595: or ((Recinfo.attribute11 is null) and (x_attribute11 is null))) THEN
596: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);
597: END IF;
598: IF NOT ((Recinfo.attribute12 = x_attribute12)
599: or ((Recinfo.attribute12 is null) and (x_attribute12 is null))) THEN
600: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);

Line 600: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);

596: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);
597: END IF;
598: IF NOT ((Recinfo.attribute12 = x_attribute12)
599: or ((Recinfo.attribute12 is null) and (x_attribute12 is null))) THEN
600: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);
601: END IF;
602: IF NOT ((Recinfo.attribute13 = x_attribute13)
603: or ((Recinfo.attribute13 is null) and (x_attribute13 is null))) THEN
604: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);

Line 604: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);

600: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);
601: END IF;
602: IF NOT ((Recinfo.attribute13 = x_attribute13)
603: or ((Recinfo.attribute13 is null) and (x_attribute13 is null))) THEN
604: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);
605: END IF;
606: IF NOT ((Recinfo.attribute14 = x_attribute14)
607: or ((Recinfo.attribute14 is null) and (x_attribute14 is null))) THEN
608: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);

Line 608: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);

604: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);
605: END IF;
606: IF NOT ((Recinfo.attribute14 = x_attribute14)
607: or ((Recinfo.attribute14 is null) and (x_attribute14 is null))) THEN
608: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);
609: END IF;
610: IF NOT ((Recinfo.attribute15 = x_attribute15)
611: or ((Recinfo.attribute15 is null) and (x_attribute15 is null))) THEN
612: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);

Line 612: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);

608: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);
609: END IF;
610: IF NOT ((Recinfo.attribute15 = x_attribute15)
611: or ((Recinfo.attribute15 is null) and (x_attribute15 is null))) THEN
612: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);
613: END IF;
614: IF NOT ((Recinfo.attribute_category = x_attribute_category)
615: or ((Recinfo.attribute_category is null) and (x_attribute_category is null))) THEN
616: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);

Line 616: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);

612: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);
613: END IF;
614: IF NOT ((Recinfo.attribute_category = x_attribute_category)
615: or ((Recinfo.attribute_category is null) and (x_attribute_category is null))) THEN
616: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);
617: END IF;
618: IF NOT ((Recinfo.attribute1 = x_attribute1)
619: or ((Recinfo.attribute1 is null) and (x_attribute1 is null))) THEN
620: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);

Line 620: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);

616: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);
617: END IF;
618: IF NOT ((Recinfo.attribute1 = x_attribute1)
619: or ((Recinfo.attribute1 is null) and (x_attribute1 is null))) THEN
620: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);
621: END IF;
622: IF NOT ((Recinfo.attribute2 = x_attribute2)
623: or ((Recinfo.attribute2 is null) and (x_attribute2 is null))) THEN
624: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);

Line 624: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);

620: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);
621: END IF;
622: IF NOT ((Recinfo.attribute2 = x_attribute2)
623: or ((Recinfo.attribute2 is null) and (x_attribute2 is null))) THEN
624: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);
625: END IF;
626: IF NOT ((Recinfo.attribute3 = x_attribute3)
627: or ((Recinfo.attribute3 is null) and (x_attribute3 is null))) THEN
628: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);

Line 628: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);

624: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);
625: END IF;
626: IF NOT ((Recinfo.attribute3 = x_attribute3)
627: or ((Recinfo.attribute3 is null) and (x_attribute3 is null))) THEN
628: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);
629: END IF;
630: IF NOT ((Recinfo.attribute4 = x_attribute4)
631: or ((Recinfo.attribute4 is null) and (x_attribute4 is null))) THEN
632: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);

Line 632: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);

628: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);
629: END IF;
630: IF NOT ((Recinfo.attribute4 = x_attribute4)
631: or ((Recinfo.attribute4 is null) and (x_attribute4 is null))) THEN
632: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);
633: END IF;
634: IF NOT ((Recinfo.attribute5 = x_attribute5)
635: or ((Recinfo.attribute5 is null) and (x_attribute5 is null))) THEN
636: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);

Line 636: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);

632: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);
633: END IF;
634: IF NOT ((Recinfo.attribute5 = x_attribute5)
635: or ((Recinfo.attribute5 is null) and (x_attribute5 is null))) THEN
636: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);
637: END IF;
638: IF NOT ((Recinfo.attribute6 = x_attribute6)
639: or ((Recinfo.attribute6 is null) and (x_attribute6 is null))) THEN
640: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);

Line 640: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);

636: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);
637: END IF;
638: IF NOT ((Recinfo.attribute6 = x_attribute6)
639: or ((Recinfo.attribute6 is null) and (x_attribute6 is null))) THEN
640: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);
641: END IF;
642: IF NOT ((Recinfo.attribute7 = x_attribute7)
643: or ((Recinfo.attribute7 is null) and (x_attribute7 is null))) THEN
644: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);

Line 644: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);

640: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);
641: END IF;
642: IF NOT ((Recinfo.attribute7 = x_attribute7)
643: or ((Recinfo.attribute7 is null) and (x_attribute7 is null))) THEN
644: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);
645: END IF;
646: IF NOT ((Recinfo.attribute8 = x_attribute8)
647: or ((Recinfo.attribute8 is null) and (x_attribute8 is null))) THEN
648: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);

Line 648: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);

644: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);
645: END IF;
646: IF NOT ((Recinfo.attribute8 = x_attribute8)
647: or ((Recinfo.attribute8 is null) and (x_attribute8 is null))) THEN
648: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);
649: END IF;
650: IF NOT ((Recinfo.attribute9 = x_attribute9)
651: or ((Recinfo.attribute9 is null) and (x_attribute9 is null))) THEN
652: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);

Line 652: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);

648: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);
649: END IF;
650: IF NOT ((Recinfo.attribute9 = x_attribute9)
651: or ((Recinfo.attribute9 is null) and (x_attribute9 is null))) THEN
652: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);
653: END IF;
654: IF NOT ((Recinfo.attribute10 = x_attribute10)
655: or ((Recinfo.attribute10 is null) and (x_attribute10 is null))) THEN
656: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);

Line 656: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);

652: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);
653: END IF;
654: IF NOT ((Recinfo.attribute10 = x_attribute10)
655: or ((Recinfo.attribute10 is null) and (x_attribute10 is null))) THEN
656: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);
657: END IF;
658:
659: -----------------------------------------------------------------
660: -- Call the PN_ADDRESSES lock table handler to lock the address