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

Line 680: pn_var_rent_pkg.lock_row_exception('PAYMENT_SCHEDULE_ID',tlinfo.PAYMENT_SCHEDULE_ID);

676: END IF;
677: CLOSE c1;
678:
679: IF NOT (tlinfo.PAYMENT_SCHEDULE_ID = X_PAYMENT_SCHEDULE_ID) THEN
680: pn_var_rent_pkg.lock_row_exception('PAYMENT_SCHEDULE_ID',tlinfo.PAYMENT_SCHEDULE_ID);
681: END IF;
682:
683: IF NOT ((tlinfo.APPROVED_BY_USER_ID = X_APPROVED_BY_USER_ID)
684: OR ((tlinfo.APPROVED_BY_USER_ID IS NULL) AND (X_APPROVED_BY_USER_ID IS NULL))) THEN

Line 685: pn_var_rent_pkg.lock_row_exception('APPROVED_BY_USER_ID',tlinfo.APPROVED_BY_USER_ID);

681: END IF;
682:
683: IF NOT ((tlinfo.APPROVED_BY_USER_ID = X_APPROVED_BY_USER_ID)
684: OR ((tlinfo.APPROVED_BY_USER_ID IS NULL) AND (X_APPROVED_BY_USER_ID IS NULL))) THEN
685: pn_var_rent_pkg.lock_row_exception('APPROVED_BY_USER_ID',tlinfo.APPROVED_BY_USER_ID);
686: END IF;
687:
688: IF NOT ((tlinfo.TRANSFERRED_BY_USER_ID = X_TRANSFERRED_BY_USER_ID)
689: OR ((tlinfo.TRANSFERRED_BY_USER_ID IS NULL) AND (X_TRANSFERRED_BY_USER_ID IS NULL))) THEN

Line 690: pn_var_rent_pkg.lock_row_exception('TRANSFERRED_BY_USER_ID',tlinfo.TRANSFERRED_BY_USER_ID);

686: END IF;
687:
688: IF NOT ((tlinfo.TRANSFERRED_BY_USER_ID = X_TRANSFERRED_BY_USER_ID)
689: OR ((tlinfo.TRANSFERRED_BY_USER_ID IS NULL) AND (X_TRANSFERRED_BY_USER_ID IS NULL))) THEN
690: pn_var_rent_pkg.lock_row_exception('TRANSFERRED_BY_USER_ID',tlinfo.TRANSFERRED_BY_USER_ID);
691: END IF;
692:
693: IF NOT ((tlinfo.PAYMENT_STATUS_LOOKUP_CODE = X_PAYMENT_STATUS_LOOKUP_CODE)
694: OR ((tlinfo.PAYMENT_STATUS_LOOKUP_CODE IS NULL) AND (X_PAYMENT_STATUS_LOOKUP_CODE IS NULL))) THEN

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

691: END IF;
692:
693: IF NOT ((tlinfo.PAYMENT_STATUS_LOOKUP_CODE = X_PAYMENT_STATUS_LOOKUP_CODE)
694: OR ((tlinfo.PAYMENT_STATUS_LOOKUP_CODE IS NULL) AND (X_PAYMENT_STATUS_LOOKUP_CODE IS NULL))) THEN
695: pn_var_rent_pkg.lock_row_exception('PAYMENT_STATUS_LOOKUP_CODE',tlinfo.PAYMENT_STATUS_LOOKUP_CODE);
696: END IF;
697:
698: IF NOT ((trunc(tlinfo.APPROVAL_DATE) = trunc(X_APPROVAL_DATE))
699: OR ((trunc(tlinfo.APPROVAL_DATE) IS NULL) AND (trunc(X_APPROVAL_DATE) IS NULL))) THEN

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

696: END IF;
697:
698: IF NOT ((trunc(tlinfo.APPROVAL_DATE) = trunc(X_APPROVAL_DATE))
699: OR ((trunc(tlinfo.APPROVAL_DATE) IS NULL) AND (trunc(X_APPROVAL_DATE) IS NULL))) THEN
700: pn_var_rent_pkg.lock_row_exception('APPROVAL_DATE',tlinfo.APPROVAL_DATE);
701: END IF;
702:
703: IF NOT ((trunc(tlinfo.TRANSFER_DATE) = trunc(X_TRANSFER_DATE))
704: OR ((tlinfo.TRANSFER_DATE IS NULL) AND (X_TRANSFER_DATE IS NULL))) THEN

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

701: END IF;
702:
703: IF NOT ((trunc(tlinfo.TRANSFER_DATE) = trunc(X_TRANSFER_DATE))
704: OR ((tlinfo.TRANSFER_DATE IS NULL) AND (X_TRANSFER_DATE IS NULL))) THEN
705: pn_var_rent_pkg.lock_row_exception('TRANSFER_DATE',tlinfo.TRANSFER_DATE);
706: END IF;
707:
708: IF NOT ((tlinfo.PERIOD_NAME = X_PERIOD_NAME)
709: OR ((tlinfo.PERIOD_NAME IS NULL) AND (X_PERIOD_NAME IS NULL))) THEN

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

706: END IF;
707:
708: IF NOT ((tlinfo.PERIOD_NAME = X_PERIOD_NAME)
709: OR ((tlinfo.PERIOD_NAME IS NULL) AND (X_PERIOD_NAME IS NULL))) THEN
710: pn_var_rent_pkg.lock_row_exception('PERIOD_NAME',tlinfo.PERIOD_NAME);
711: END IF;
712:
713: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
714: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN

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

711: END IF;
712:
713: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
714: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN
715: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
716: END IF;
717:
718: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
719: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN

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

716: END IF;
717:
718: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
719: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN
720: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
721: END IF;
722:
723: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
724: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN

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

721: END IF;
722:
723: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
724: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN
725: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
726: END IF;
727:
728: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
729: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN

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

726: END IF;
727:
728: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
729: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN
730: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
731: END IF;
732:
733: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
734: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN

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

731: END IF;
732:
733: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
734: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN
735: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
736: END IF;
737:
738: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
739: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN

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

736: END IF;
737:
738: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
739: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN
740: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
741: END IF;
742:
743: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
744: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN

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

741: END IF;
742:
743: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
744: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN
745: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
746: END IF;
747:
748: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
749: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN

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

746: END IF;
747:
748: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
749: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN
750: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
751: END IF;
752:
753: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
754: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN

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

751: END IF;
752:
753: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
754: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN
755: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
756: END IF;
757:
758: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
759: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN

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

756: END IF;
757:
758: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
759: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN
760: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
761: END IF;
762:
763: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
764: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN

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

761: END IF;
762:
763: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
764: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN
765: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
766: END IF;
767:
768: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
769: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN

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

766: END IF;
767:
768: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
769: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN
770: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
771: END IF;
772:
773: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
774: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN

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

771: END IF;
772:
773: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
774: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN
775: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
776: END IF;
777:
778: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
779: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN

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

776: END IF;
777:
778: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
779: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN
780: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
781: END IF;
782:
783: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
784: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN

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

781: END IF;
782:
783: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
784: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN
785: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
786: END IF;
787:
788: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
789: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN

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

786: END IF;
787:
788: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
789: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN
790: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
791: END IF;
792:
793: RETURN;
794: END Lock_Row;