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

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

305: END IF;
306: CLOSE c1;
307:
308: IF NOT (tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID) THEN
309: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
310: END IF;
311:
312: IF NOT ((tlinfo.RESPONSIBLE_USER = X_RESPONSIBLE_USER)
313: OR ((tlinfo.RESPONSIBLE_USER IS NULL) AND (X_RESPONSIBLE_USER IS NULL))) THEN

Line 314: pn_var_rent_pkg.lock_row_exception('RESPONSIBLE_USER',tlinfo.RESPONSIBLE_USER);

310: END IF;
311:
312: IF NOT ((tlinfo.RESPONSIBLE_USER = X_RESPONSIBLE_USER)
313: OR ((tlinfo.RESPONSIBLE_USER IS NULL) AND (X_RESPONSIBLE_USER IS NULL))) THEN
314: pn_var_rent_pkg.lock_row_exception('RESPONSIBLE_USER',tlinfo.RESPONSIBLE_USER);
315: END IF;
316:
317: IF NOT ((tlinfo.CHANGE_COMMENCEMENT_DATE = X_CHANGE_COMMENCEMENT_DATE)
318: OR ((tlinfo.CHANGE_COMMENCEMENT_DATE IS NULL) AND (X_CHANGE_COMMENCEMENT_DATE IS NULL))) THEN

Line 319: pn_var_rent_pkg.lock_row_exception('CHANGE_COMMENCEMENT_DATE',tlinfo.CHANGE_COMMENCEMENT_DATE);

315: END IF;
316:
317: IF NOT ((tlinfo.CHANGE_COMMENCEMENT_DATE = X_CHANGE_COMMENCEMENT_DATE)
318: OR ((tlinfo.CHANGE_COMMENCEMENT_DATE IS NULL) AND (X_CHANGE_COMMENCEMENT_DATE IS NULL))) THEN
319: pn_var_rent_pkg.lock_row_exception('CHANGE_COMMENCEMENT_DATE',tlinfo.CHANGE_COMMENCEMENT_DATE);
320: END IF;
321:
322: IF NOT ((tlinfo.CHANGE_TERMINATION_DATE = X_CHANGE_TERMINATION_DATE)
323: OR ((tlinfo.CHANGE_TERMINATION_DATE IS NULL) AND (X_CHANGE_TERMINATION_DATE IS NULL))) THEN

Line 324: pn_var_rent_pkg.lock_row_exception('CHANGE_TERMINATION_DATE',tlinfo.CHANGE_TERMINATION_DATE);

320: END IF;
321:
322: IF NOT ((tlinfo.CHANGE_TERMINATION_DATE = X_CHANGE_TERMINATION_DATE)
323: OR ((tlinfo.CHANGE_TERMINATION_DATE IS NULL) AND (X_CHANGE_TERMINATION_DATE IS NULL))) THEN
324: pn_var_rent_pkg.lock_row_exception('CHANGE_TERMINATION_DATE',tlinfo.CHANGE_TERMINATION_DATE);
325: END IF;
326:
327: IF NOT ((tlinfo.CHANGE_TYPE_LOOKUP_CODE = X_CHANGE_TYPE_LOOKUP_CODE)
328: OR ((tlinfo.CHANGE_TYPE_LOOKUP_CODE IS NULL) AND (X_CHANGE_TYPE_LOOKUP_CODE IS NULL))) THEN

Line 329: pn_var_rent_pkg.lock_row_exception('CHANGE_TYPE_LOOKUP_CODE',tlinfo.CHANGE_TYPE_LOOKUP_CODE);

325: END IF;
326:
327: IF NOT ((tlinfo.CHANGE_TYPE_LOOKUP_CODE = X_CHANGE_TYPE_LOOKUP_CODE)
328: OR ((tlinfo.CHANGE_TYPE_LOOKUP_CODE IS NULL) AND (X_CHANGE_TYPE_LOOKUP_CODE IS NULL))) THEN
329: pn_var_rent_pkg.lock_row_exception('CHANGE_TYPE_LOOKUP_CODE',tlinfo.CHANGE_TYPE_LOOKUP_CODE);
330: END IF;
331:
332: IF NOT ((tlinfo.CHANGE_EXECUTION_DATE = X_CHANGE_EXECUTION_DATE)
333: OR ((tlinfo.CHANGE_EXECUTION_DATE IS NULL) AND (X_CHANGE_EXECUTION_DATE IS NULL))) THEN

Line 334: pn_var_rent_pkg.lock_row_exception('CHANGE_EXECUTION_DATE',tlinfo.CHANGE_EXECUTION_DATE);

330: END IF;
331:
332: IF NOT ((tlinfo.CHANGE_EXECUTION_DATE = X_CHANGE_EXECUTION_DATE)
333: OR ((tlinfo.CHANGE_EXECUTION_DATE IS NULL) AND (X_CHANGE_EXECUTION_DATE IS NULL))) THEN
334: pn_var_rent_pkg.lock_row_exception('CHANGE_EXECUTION_DATE',tlinfo.CHANGE_EXECUTION_DATE);
335: END IF;
336:
337: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
338: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN

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

335: END IF;
336:
337: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
338: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN
339: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
340: END IF;
341:
342: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
343: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN

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

340: END IF;
341:
342: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
343: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN
344: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
345: END IF;
346:
347: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
348: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN

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

345: END IF;
346:
347: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
348: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN
349: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
350: END IF;
351:
352: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
353: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN

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

350: END IF;
351:
352: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
353: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN
354: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
355: END IF;
356:
357: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
358: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN

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

355: END IF;
356:
357: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
358: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN
359: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
360: END IF;
361:
362: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
363: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN

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

360: END IF;
361:
362: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
363: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN
364: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
365: END IF;
366:
367: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
368: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN

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

365: END IF;
366:
367: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
368: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN
369: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
370: END IF;
371:
372: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
373: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN

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

370: END IF;
371:
372: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
373: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN
374: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
375: END IF;
376:
377: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
378: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN

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

375: END IF;
376:
377: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
378: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN
379: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
380: END IF;
381:
382: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
383: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN

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

380: END IF;
381:
382: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
383: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN
384: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
385: END IF;
386:
387: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
388: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN

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

385: END IF;
386:
387: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
388: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN
389: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
390: END IF;
391:
392: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
393: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN

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

390: END IF;
391:
392: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
393: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN
394: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
395: END IF;
396:
397: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
398: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN

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

395: END IF;
396:
397: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
398: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN
399: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
400: END IF;
401:
402: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
403: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN

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

400: END IF;
401:
402: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
403: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN
404: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
405: END IF;
406:
407: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
408: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN

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

405: END IF;
406:
407: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
408: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN
409: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
410: END IF;
411:
412: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
413: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN

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

410: END IF;
411:
412: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
413: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN
414: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
415: END IF;
416:
417: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
418: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);

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

414: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
415: END IF;
416:
417: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
418: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
419: END IF;
420:
421: IF NOT (tlinfo.LEASE_TRANSACTION_ID = X_LEASE_TRANSACTION_ID) THEN
422: pn_var_rent_pkg.lock_row_exception('LEASE_TRANSACTION_ID',tlinfo.LEASE_TRANSACTION_ID);

Line 422: pn_var_rent_pkg.lock_row_exception('LEASE_TRANSACTION_ID',tlinfo.LEASE_TRANSACTION_ID);

418: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
419: END IF;
420:
421: IF NOT (tlinfo.LEASE_TRANSACTION_ID = X_LEASE_TRANSACTION_ID) THEN
422: pn_var_rent_pkg.lock_row_exception('LEASE_TRANSACTION_ID',tlinfo.LEASE_TRANSACTION_ID);
423: END IF;
424:
425: IF NOT ((tlinfo.LEASE_CHANGE_NUMBER = X_LEASE_CHANGE_NUMBER)
426: OR ((tlinfo.LEASE_CHANGE_NUMBER IS NULL) AND (X_LEASE_CHANGE_NUMBER IS NULL))) THEN

Line 427: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_NUMBER',tlinfo.LEASE_CHANGE_NUMBER);

423: END IF;
424:
425: IF NOT ((tlinfo.LEASE_CHANGE_NUMBER = X_LEASE_CHANGE_NUMBER)
426: OR ((tlinfo.LEASE_CHANGE_NUMBER IS NULL) AND (X_LEASE_CHANGE_NUMBER IS NULL))) THEN
427: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_NUMBER',tlinfo.LEASE_CHANGE_NUMBER);
428: END IF;
429:
430: IF NOT ((tlinfo.LEASE_CHANGE_NAME = X_LEASE_CHANGE_NAME)
431: OR ((tlinfo.LEASE_CHANGE_NAME IS NULL) AND (X_LEASE_CHANGE_NAME IS NULL))) THEN

Line 432: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_NAME',tlinfo.LEASE_CHANGE_NAME);

428: END IF;
429:
430: IF NOT ((tlinfo.LEASE_CHANGE_NAME = X_LEASE_CHANGE_NAME)
431: OR ((tlinfo.LEASE_CHANGE_NAME IS NULL) AND (X_LEASE_CHANGE_NAME IS NULL))) THEN
432: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_NAME',tlinfo.LEASE_CHANGE_NAME);
433: END IF;
434:
435: IF NOT ((tlinfo.ABSTRACTED_BY_USER = X_ABSTRACTED_BY_USER)
436: OR ((tlinfo.ABSTRACTED_BY_USER IS NULL) AND (X_ABSTRACTED_BY_USER IS NULL))) THEN

Line 437: pn_var_rent_pkg.lock_row_exception('ABSTRACTED_BY_USER',tlinfo.ABSTRACTED_BY_USER);

433: END IF;
434:
435: IF NOT ((tlinfo.ABSTRACTED_BY_USER = X_ABSTRACTED_BY_USER)
436: OR ((tlinfo.ABSTRACTED_BY_USER IS NULL) AND (X_ABSTRACTED_BY_USER IS NULL))) THEN
437: pn_var_rent_pkg.lock_row_exception('ABSTRACTED_BY_USER',tlinfo.ABSTRACTED_BY_USER);
438: END IF;
439:
440: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Lock_Row (-)');
441: