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

Line 371: pn_var_rent_pkg.lock_row_exception('TENANCY_ID',tlinfo.TENANCY_ID);

367: END IF;
368: CLOSE c1;
369:
370: IF NOT (tlinfo.TENANCY_ID = X_TENANCY_ID) THEN
371: pn_var_rent_pkg.lock_row_exception('TENANCY_ID',tlinfo.TENANCY_ID);
372: END IF;
373:
374: IF NOT (tlinfo.LOCATION_ID = X_LOCATION_ID) THEN
375: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.LOCATION_ID);

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

371: pn_var_rent_pkg.lock_row_exception('TENANCY_ID',tlinfo.TENANCY_ID);
372: END IF;
373:
374: IF NOT (tlinfo.LOCATION_ID = X_LOCATION_ID) THEN
375: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.LOCATION_ID);
376: END IF;
377:
378: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
379: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);

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

375: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.LOCATION_ID);
376: END IF;
377:
378: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
379: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
380: END IF;
381:
382: IF NOT (tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID) THEN
383: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);

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

379: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
380: END IF;
381:
382: IF NOT (tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID) THEN
383: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
384: END IF;
385:
386: IF NOT (tlinfo.TENANCY_USAGE_LOOKUP_CODE = X_TENANCY_USAGE_LOOKUP_CODE) THEN
387: pn_var_rent_pkg.lock_row_exception('TENANCY_USAGE_LOOKUP_CODE',tlinfo.TENANCY_USAGE_LOOKUP_CODE);

Line 387: pn_var_rent_pkg.lock_row_exception('TENANCY_USAGE_LOOKUP_CODE',tlinfo.TENANCY_USAGE_LOOKUP_CODE);

383: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
384: END IF;
385:
386: IF NOT (tlinfo.TENANCY_USAGE_LOOKUP_CODE = X_TENANCY_USAGE_LOOKUP_CODE) THEN
387: pn_var_rent_pkg.lock_row_exception('TENANCY_USAGE_LOOKUP_CODE',tlinfo.TENANCY_USAGE_LOOKUP_CODE);
388: END IF;
389:
390: IF NOT (tlinfo.PRIMARY_FLAG = X_PRIMARY_FLAG) THEN
391: pn_var_rent_pkg.lock_row_exception('PRIMARY_FLAG',tlinfo.PRIMARY_FLAG);

Line 391: pn_var_rent_pkg.lock_row_exception('PRIMARY_FLAG',tlinfo.PRIMARY_FLAG);

387: pn_var_rent_pkg.lock_row_exception('TENANCY_USAGE_LOOKUP_CODE',tlinfo.TENANCY_USAGE_LOOKUP_CODE);
388: END IF;
389:
390: IF NOT (tlinfo.PRIMARY_FLAG = X_PRIMARY_FLAG) THEN
391: pn_var_rent_pkg.lock_row_exception('PRIMARY_FLAG',tlinfo.PRIMARY_FLAG);
392: END IF;
393:
394: IF NOT ((tlinfo.ESTIMATED_OCCUPANCY_DATE = X_ESTIMATED_OCCUPANCY_DATE)
395: OR ((tlinfo.ESTIMATED_OCCUPANCY_DATE IS NULL) AND (X_ESTIMATED_OCCUPANCY_DATE IS NULL))) THEN

Line 396: pn_var_rent_pkg.lock_row_exception('ESTIMATED_OCCUPANCY_DATE',tlinfo.ESTIMATED_OCCUPANCY_DATE);

392: END IF;
393:
394: IF NOT ((tlinfo.ESTIMATED_OCCUPANCY_DATE = X_ESTIMATED_OCCUPANCY_DATE)
395: OR ((tlinfo.ESTIMATED_OCCUPANCY_DATE IS NULL) AND (X_ESTIMATED_OCCUPANCY_DATE IS NULL))) THEN
396: pn_var_rent_pkg.lock_row_exception('ESTIMATED_OCCUPANCY_DATE',tlinfo.ESTIMATED_OCCUPANCY_DATE);
397: END IF;
398:
399: IF NOT ((tlinfo.OCCUPANCY_DATE = X_OCCUPANCY_DATE)
400: OR ((tlinfo.OCCUPANCY_DATE IS NULL) AND (X_OCCUPANCY_DATE IS NULL))) THEN

Line 401: pn_var_rent_pkg.lock_row_exception('OCCUPANCY_DATE',tlinfo.OCCUPANCY_DATE);

397: END IF;
398:
399: IF NOT ((tlinfo.OCCUPANCY_DATE = X_OCCUPANCY_DATE)
400: OR ((tlinfo.OCCUPANCY_DATE IS NULL) AND (X_OCCUPANCY_DATE IS NULL))) THEN
401: pn_var_rent_pkg.lock_row_exception('OCCUPANCY_DATE',tlinfo.OCCUPANCY_DATE);
402: END IF;
403:
404: IF NOT ((tlinfo.EXPIRATION_DATE = X_EXPIRATION_DATE)
405: OR ((tlinfo.EXPIRATION_DATE IS NULL) AND (X_EXPIRATION_DATE IS NULL))) THEN

Line 406: pn_var_rent_pkg.lock_row_exception('EXPIRATION_DATE',tlinfo.EXPIRATION_DATE);

402: END IF;
403:
404: IF NOT ((tlinfo.EXPIRATION_DATE = X_EXPIRATION_DATE)
405: OR ((tlinfo.EXPIRATION_DATE IS NULL) AND (X_EXPIRATION_DATE IS NULL))) THEN
406: pn_var_rent_pkg.lock_row_exception('EXPIRATION_DATE',tlinfo.EXPIRATION_DATE);
407: END IF;
408:
409: IF NOT ((tlinfo.ASSIGNABLE_FLAG = X_ASSIGNABLE_FLAG)
410: OR ((tlinfo.ASSIGNABLE_FLAG IS NULL) AND (X_ASSIGNABLE_FLAG IS NULL))) THEN

Line 411: pn_var_rent_pkg.lock_row_exception('ASSIGNABLE_FLAG',tlinfo.ASSIGNABLE_FLAG);

407: END IF;
408:
409: IF NOT ((tlinfo.ASSIGNABLE_FLAG = X_ASSIGNABLE_FLAG)
410: OR ((tlinfo.ASSIGNABLE_FLAG IS NULL) AND (X_ASSIGNABLE_FLAG IS NULL))) THEN
411: pn_var_rent_pkg.lock_row_exception('ASSIGNABLE_FLAG',tlinfo.ASSIGNABLE_FLAG);
412: END IF;
413:
414: IF NOT ((tlinfo.SUBLEASEABLE_FLAG = X_SUBLEASEABLE_FLAG)
415: OR ((tlinfo.SUBLEASEABLE_FLAG IS NULL) AND (X_SUBLEASEABLE_FLAG IS NULL))) THEN

Line 416: pn_var_rent_pkg.lock_row_exception('SUBLEASEABLE_FLAG',tlinfo.SUBLEASEABLE_FLAG);

412: END IF;
413:
414: IF NOT ((tlinfo.SUBLEASEABLE_FLAG = X_SUBLEASEABLE_FLAG)
415: OR ((tlinfo.SUBLEASEABLE_FLAG IS NULL) AND (X_SUBLEASEABLE_FLAG IS NULL))) THEN
416: pn_var_rent_pkg.lock_row_exception('SUBLEASEABLE_FLAG',tlinfo.SUBLEASEABLE_FLAG);
417: END IF;
418:
419: IF NOT ((tlinfo.TENANTS_PROPORTIONATE_SHARE = X_TENANTS_PROPORTIONATE_SHARE)
420: OR ((tlinfo.TENANTS_PROPORTIONATE_SHARE IS NULL) AND (X_TENANTS_PROPORTIONATE_SHARE IS NULL))) THEN

Line 421: pn_var_rent_pkg.lock_row_exception('TENANTS_PROPORTIONATE_SHARE',tlinfo.TENANTS_PROPORTIONATE_SHARE);

417: END IF;
418:
419: IF NOT ((tlinfo.TENANTS_PROPORTIONATE_SHARE = X_TENANTS_PROPORTIONATE_SHARE)
420: OR ((tlinfo.TENANTS_PROPORTIONATE_SHARE IS NULL) AND (X_TENANTS_PROPORTIONATE_SHARE IS NULL))) THEN
421: pn_var_rent_pkg.lock_row_exception('TENANTS_PROPORTIONATE_SHARE',tlinfo.TENANTS_PROPORTIONATE_SHARE);
422: END IF;
423:
424: IF NOT ((tlinfo.STATUS = X_STATUS)
425: OR ((tlinfo.STATUS IS NULL) AND (X_STATUS IS NULL))) THEN

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

422: END IF;
423:
424: IF NOT ((tlinfo.STATUS = X_STATUS)
425: OR ((tlinfo.STATUS IS NULL) AND (X_STATUS IS NULL))) THEN
426: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);
427: END IF;
428:
429: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
430: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN

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

427: END IF;
428:
429: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
430: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN
431: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
432: END IF;
433:
434: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
435: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN

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

432: END IF;
433:
434: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
435: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN
436: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
437: END IF;
438:
439: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
440: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN

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

437: END IF;
438:
439: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
440: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN
441: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
442: END IF;
443:
444: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
445: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN

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

442: END IF;
443:
444: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
445: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN
446: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
447: END IF;
448:
449: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
450: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN

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

447: END IF;
448:
449: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
450: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN
451: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
452: END IF;
453:
454: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
455: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN

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

452: END IF;
453:
454: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
455: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN
456: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
457: END IF;
458:
459: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
460: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN

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

457: END IF;
458:
459: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
460: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN
461: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
462: END IF;
463:
464: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
465: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN

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

462: END IF;
463:
464: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
465: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN
466: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
467: END IF;
468:
469: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
470: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN

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

467: END IF;
468:
469: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
470: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN
471: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
472: END IF;
473:
474: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
475: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN

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

472: END IF;
473:
474: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
475: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN
476: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
477: END IF;
478:
479: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
480: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN

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

477: END IF;
478:
479: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
480: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN
481: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
482: END IF;
483:
484: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
485: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN

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

482: END IF;
483:
484: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
485: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN
486: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
487: END IF;
488:
489: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
490: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN

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

487: END IF;
488:
489: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
490: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN
491: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
492: END IF;
493:
494: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
495: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN

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

492: END IF;
493:
494: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
495: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN
496: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
497: END IF;
498:
499: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
500: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN

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

497: END IF;
498:
499: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
500: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN
501: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
502: END IF;
503:
504: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
505: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN

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

502: END IF;
503:
504: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
505: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN
506: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
507: END IF;
508:
509: IF NOT ((tlinfo.RECOVERY_TYPE_CODE = X_RECOVERY_TYPE_CODE)
510: OR ((tlinfo.RECOVERY_TYPE_CODE IS NULL) AND (X_RECOVERY_TYPE_CODE IS NULL))) THEN

Line 511: pn_var_rent_pkg.lock_row_exception('RECOVERY_TYPE_CODE',tlinfo.RECOVERY_TYPE_CODE);

507: END IF;
508:
509: IF NOT ((tlinfo.RECOVERY_TYPE_CODE = X_RECOVERY_TYPE_CODE)
510: OR ((tlinfo.RECOVERY_TYPE_CODE IS NULL) AND (X_RECOVERY_TYPE_CODE IS NULL))) THEN
511: pn_var_rent_pkg.lock_row_exception('RECOVERY_TYPE_CODE',tlinfo.RECOVERY_TYPE_CODE);
512: END IF;
513:
514: IF NOT ((tlinfo.RECOVERY_SPACE_STD_CODE = X_RECOVERY_SPACE_STD_CODE)
515: OR ((tlinfo.RECOVERY_SPACE_STD_CODE IS NULL) AND (X_RECOVERY_SPACE_STD_CODE IS NULL))) THEN

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

512: END IF;
513:
514: IF NOT ((tlinfo.RECOVERY_SPACE_STD_CODE = X_RECOVERY_SPACE_STD_CODE)
515: OR ((tlinfo.RECOVERY_SPACE_STD_CODE IS NULL) AND (X_RECOVERY_SPACE_STD_CODE IS NULL))) THEN
516: pn_var_rent_pkg.lock_row_exception('RECOVERY_SPACE_STD_CODE',tlinfo.RECOVERY_SPACE_STD_CODE);
517: END IF;
518:
519: IF NOT ((tlinfo.FIN_OBLIG_END_DATE = X_FIN_OBLIG_END_DATE)
520: OR ((tlinfo.FIN_OBLIG_END_DATE IS NULL) AND (X_FIN_OBLIG_END_DATE IS NULL))) THEN

Line 521: pn_var_rent_pkg.lock_row_exception('FIN_OBLIG_END_DATE',tlinfo.FIN_OBLIG_END_DATE);

517: END IF;
518:
519: IF NOT ((tlinfo.FIN_OBLIG_END_DATE = X_FIN_OBLIG_END_DATE)
520: OR ((tlinfo.FIN_OBLIG_END_DATE IS NULL) AND (X_FIN_OBLIG_END_DATE IS NULL))) THEN
521: pn_var_rent_pkg.lock_row_exception('FIN_OBLIG_END_DATE',tlinfo.FIN_OBLIG_END_DATE);
522: END IF;
523:
524: IF NOT ((tlinfo.CUSTOMER_ID = X_CUSTOMER_ID)
525: OR ((tlinfo.CUSTOMER_ID IS NULL) AND (X_CUSTOMER_ID IS NULL))) THEN

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

522: END IF;
523:
524: IF NOT ((tlinfo.CUSTOMER_ID = X_CUSTOMER_ID)
525: OR ((tlinfo.CUSTOMER_ID IS NULL) AND (X_CUSTOMER_ID IS NULL))) THEN
526: pn_var_rent_pkg.lock_row_exception('CUSTOMER_ID',tlinfo.CUSTOMER_ID);
527: END IF;
528:
529: IF NOT ((tlinfo.CUSTOMER_SITE_USE_ID = X_CUSTOMER_SITE_USE_ID)
530: OR ((tlinfo.CUSTOMER_SITE_USE_ID IS NULL) AND (X_CUSTOMER_SITE_USE_ID IS NULL))) THEN

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

527: END IF;
528:
529: IF NOT ((tlinfo.CUSTOMER_SITE_USE_ID = X_CUSTOMER_SITE_USE_ID)
530: OR ((tlinfo.CUSTOMER_SITE_USE_ID IS NULL) AND (X_CUSTOMER_SITE_USE_ID IS NULL))) THEN
531: pn_var_rent_pkg.lock_row_exception('CUSTOMER_SITE_USE_ID',tlinfo.CUSTOMER_SITE_USE_ID);
532: END IF;
533:
534: IF NOT ((tlinfo.LEASE_RENTABLE_AREA = X_LEASE_RENTABLE_AREA)
535: OR ((tlinfo.LEASE_RENTABLE_AREA IS NULL) AND (X_LEASE_RENTABLE_AREA IS NULL))) THEN

Line 536: pn_var_rent_pkg.lock_row_exception('LEASE_RENTABLE_AREA',tlinfo.LEASE_RENTABLE_AREA);

532: END IF;
533:
534: IF NOT ((tlinfo.LEASE_RENTABLE_AREA = X_LEASE_RENTABLE_AREA)
535: OR ((tlinfo.LEASE_RENTABLE_AREA IS NULL) AND (X_LEASE_RENTABLE_AREA IS NULL))) THEN
536: pn_var_rent_pkg.lock_row_exception('LEASE_RENTABLE_AREA',tlinfo.LEASE_RENTABLE_AREA);
537: END IF;
538:
539: IF NOT ((tlinfo.LEASE_USABLE_AREA = X_LEASE_USABLE_AREA)
540: OR ((tlinfo.LEASE_USABLE_AREA IS NULL) AND (X_LEASE_USABLE_AREA IS NULL))) THEN

Line 541: pn_var_rent_pkg.lock_row_exception('LEASE_USABLE_AREA',tlinfo.LEASE_USABLE_AREA);

537: END IF;
538:
539: IF NOT ((tlinfo.LEASE_USABLE_AREA = X_LEASE_USABLE_AREA)
540: OR ((tlinfo.LEASE_USABLE_AREA IS NULL) AND (X_LEASE_USABLE_AREA IS NULL))) THEN
541: pn_var_rent_pkg.lock_row_exception('LEASE_USABLE_AREA',tlinfo.LEASE_USABLE_AREA);
542: END IF;
543:
544: IF NOT ((tlinfo.LEASE_ASSIGNABLE_AREA = X_LEASE_ASSIGNABLE_AREA)
545: OR ((tlinfo.LEASE_ASSIGNABLE_AREA IS NULL) AND (X_LEASE_ASSIGNABLE_AREA IS NULL))) THEN

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

542: END IF;
543:
544: IF NOT ((tlinfo.LEASE_ASSIGNABLE_AREA = X_LEASE_ASSIGNABLE_AREA)
545: OR ((tlinfo.LEASE_ASSIGNABLE_AREA IS NULL) AND (X_LEASE_ASSIGNABLE_AREA IS NULL))) THEN
546: pn_var_rent_pkg.lock_row_exception('LEASE_ASSIGNABLE_AREA',tlinfo.LEASE_ASSIGNABLE_AREA);
547: END IF;
548:
549: IF NOT ((tlinfo.LEASE_LOAD_FACTOR = X_LEASE_LOAD_FACTOR)
550: OR ((tlinfo.LEASE_LOAD_FACTOR IS NULL) AND (X_LEASE_LOAD_FACTOR IS NULL))) THEN

Line 551: pn_var_rent_pkg.lock_row_exception('LEASE_LOAD_FACTOR',tlinfo.LEASE_LOAD_FACTOR);

547: END IF;
548:
549: IF NOT ((tlinfo.LEASE_LOAD_FACTOR = X_LEASE_LOAD_FACTOR)
550: OR ((tlinfo.LEASE_LOAD_FACTOR IS NULL) AND (X_LEASE_LOAD_FACTOR IS NULL))) THEN
551: pn_var_rent_pkg.lock_row_exception('LEASE_LOAD_FACTOR',tlinfo.LEASE_LOAD_FACTOR);
552: END IF;
553:
554: pnp_debug_pkg.debug('PN_TENANCIES_PKG.LOCK_ROW (-)');
555: