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

Line 258: pn_var_rent_pkg.lock_row_exception('LANDLORD_SERVICE_ID',tlinfo.LANDLORD_SERVICE_ID);

254: END IF;
255: CLOSE c1;
256:
257: IF NOT (tlinfo.LANDLORD_SERVICE_ID = X_LANDLORD_SERVICE_ID) THEN
258: pn_var_rent_pkg.lock_row_exception('LANDLORD_SERVICE_ID',tlinfo.LANDLORD_SERVICE_ID);
259: END IF;
260:
261: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
262: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);

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

258: pn_var_rent_pkg.lock_row_exception('LANDLORD_SERVICE_ID',tlinfo.LANDLORD_SERVICE_ID);
259: END IF;
260:
261: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
262: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
263: END IF;
264:
265: IF NOT (tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID) THEN
266: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);

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

262: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
263: END IF;
264:
265: IF NOT (tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID) THEN
266: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
267: END IF;
268:
269: IF NOT (tlinfo.SERVICE_TYPE_LOOKUP_CODE = X_SERVICE_TYPE_LOOKUP_CODE) THEN
270: pn_var_rent_pkg.lock_row_exception('SERVICE_TYPE_LOOKUP_CODE',tlinfo.SERVICE_TYPE_LOOKUP_CODE);

Line 270: pn_var_rent_pkg.lock_row_exception('SERVICE_TYPE_LOOKUP_CODE',tlinfo.SERVICE_TYPE_LOOKUP_CODE);

266: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
267: END IF;
268:
269: IF NOT (tlinfo.SERVICE_TYPE_LOOKUP_CODE = X_SERVICE_TYPE_LOOKUP_CODE) THEN
270: pn_var_rent_pkg.lock_row_exception('SERVICE_TYPE_LOOKUP_CODE',tlinfo.SERVICE_TYPE_LOOKUP_CODE);
271: END IF;
272:
273: IF NOT ((tlinfo.START_DATE = X_START_DATE)
274: OR ((tlinfo.START_DATE IS NULL) AND (X_START_DATE IS NULL))) THEN

Line 275: pn_var_rent_pkg.lock_row_exception('START_DATE',tlinfo.START_DATE);

271: END IF;
272:
273: IF NOT ((tlinfo.START_DATE = X_START_DATE)
274: OR ((tlinfo.START_DATE IS NULL) AND (X_START_DATE IS NULL))) THEN
275: pn_var_rent_pkg.lock_row_exception('START_DATE',tlinfo.START_DATE);
276: END IF;
277:
278: IF NOT ((tlinfo.END_DATE = X_END_DATE)
279: OR ((tlinfo.END_DATE IS NULL) AND (X_END_DATE IS NULL))) THEN

Line 280: pn_var_rent_pkg.lock_row_exception('END_DATE',tlinfo.END_DATE);

276: END IF;
277:
278: IF NOT ((tlinfo.END_DATE = X_END_DATE)
279: OR ((tlinfo.END_DATE IS NULL) AND (X_END_DATE IS NULL))) THEN
280: pn_var_rent_pkg.lock_row_exception('END_DATE',tlinfo.END_DATE);
281: END IF;
282:
283: IF NOT (tlinfo.STATUS = X_STATUS) THEN
284: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);

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

280: pn_var_rent_pkg.lock_row_exception('END_DATE',tlinfo.END_DATE);
281: END IF;
282:
283: IF NOT (tlinfo.STATUS = X_STATUS) THEN
284: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);
285: END IF;
286:
287: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
288: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN

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

285: END IF;
286:
287: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
288: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN
289: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
290: END IF;
291:
292: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
293: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN

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

290: END IF;
291:
292: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
293: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN
294: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
295: END IF;
296:
297: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
298: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN

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

295: END IF;
296:
297: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
298: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN
299: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
300: END IF;
301:
302: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
303: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN

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

300: END IF;
301:
302: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
303: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN
304: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
305: END IF;
306:
307: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
308: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN

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

305: END IF;
306:
307: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
308: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN
309: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
310: END IF;
311:
312: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
313: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN

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

310: END IF;
311:
312: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
313: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN
314: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
315: END IF;
316:
317: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
318: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN

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

315: END IF;
316:
317: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
318: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN
319: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
320: END IF;
321:
322: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
323: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN

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

320: END IF;
321:
322: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
323: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN
324: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
325: END IF;
326:
327: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
328: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN

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

325: END IF;
326:
327: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
328: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN
329: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
330: END IF;
331:
332: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
333: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN

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

330: END IF;
331:
332: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
333: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN
334: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
335: END IF;
336:
337: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
338: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN

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

335: END IF;
336:
337: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
338: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN
339: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
340: END IF;
341:
342: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
343: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN

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

340: END IF;
341:
342: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
343: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN
344: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
345: END IF;
346:
347: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
348: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN

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

345: END IF;
346:
347: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
348: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN
349: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
350: END IF;
351:
352: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
353: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN

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

350: END IF;
351:
352: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
353: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN
354: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
355: END IF;
356:
357: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
358: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN

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

355: END IF;
356:
357: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
358: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN
359: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
360: END IF;
361:
362: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
363: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN

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

360: END IF;
361:
362: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
363: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN
364: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
365: END IF;
366:
367: IF NOT ((tlinfo.OBLIGATION_NUM = X_OBLIGATION_NUM)
368: OR ((tlinfo.OBLIGATION_NUM IS NULL) AND (X_OBLIGATION_NUM IS NULL))) THEN

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

365: END IF;
366:
367: IF NOT ((tlinfo.OBLIGATION_NUM = X_OBLIGATION_NUM)
368: OR ((tlinfo.OBLIGATION_NUM IS NULL) AND (X_OBLIGATION_NUM IS NULL))) THEN
369: pn_var_rent_pkg.lock_row_exception('OBLIGATION_NUM',tlinfo.OBLIGATION_NUM);
370: END IF;
371:
372: IF NOT ((tlinfo.RESPONSIBILITY_CODE = X_RESPONSIBILITY_CODE)
373: OR ((tlinfo.RESPONSIBILITY_CODE IS NULL) AND (X_RESPONSIBILITY_CODE IS NULL))) THEN

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

370: END IF;
371:
372: IF NOT ((tlinfo.RESPONSIBILITY_CODE = X_RESPONSIBILITY_CODE)
373: OR ((tlinfo.RESPONSIBILITY_CODE IS NULL) AND (X_RESPONSIBILITY_CODE IS NULL))) THEN
374: pn_var_rent_pkg.lock_row_exception('RESPONSIBILITY_CODE',tlinfo.RESPONSIBILITY_CODE);
375: END IF;
376:
377: IF NOT ((tlinfo.COMMON_AREA_RESP = X_COMMON_AREA_RESP)
378: OR ((tlinfo.COMMON_AREA_RESP IS NULL) AND (X_COMMON_AREA_RESP IS NULL))) THEN

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

375: END IF;
376:
377: IF NOT ((tlinfo.COMMON_AREA_RESP = X_COMMON_AREA_RESP)
378: OR ((tlinfo.COMMON_AREA_RESP IS NULL) AND (X_COMMON_AREA_RESP IS NULL))) THEN
379: pn_var_rent_pkg.lock_row_exception('COMMON_AREA_RESP',tlinfo.COMMON_AREA_RESP);
380: END IF;
381:
382: IF NOT ((tlinfo.FINANCIAL_RESP_PARTY_CODE = X_FINANCIAL_RESP_PARTY_CODE)
383: OR ((tlinfo.FINANCIAL_RESP_PARTY_CODE IS NULL) AND (X_FINANCIAL_RESP_PARTY_CODE IS NULL))) THEN

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

380: END IF;
381:
382: IF NOT ((tlinfo.FINANCIAL_RESP_PARTY_CODE = X_FINANCIAL_RESP_PARTY_CODE)
383: OR ((tlinfo.FINANCIAL_RESP_PARTY_CODE IS NULL) AND (X_FINANCIAL_RESP_PARTY_CODE IS NULL))) THEN
384: pn_var_rent_pkg.lock_row_exception('FINANCIAL_RESP_PARTY_CODE',tlinfo.FINANCIAL_RESP_PARTY_CODE);
385: END IF;
386:
387: IF NOT ((tlinfo.FINANCIAL_PCT_RESP = X_FINANCIAL_PCT_RESP)
388: OR ((tlinfo.FINANCIAL_PCT_RESP IS NULL) AND (X_FINANCIAL_PCT_RESP IS NULL))) THEN

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

385: END IF;
386:
387: IF NOT ((tlinfo.FINANCIAL_PCT_RESP = X_FINANCIAL_PCT_RESP)
388: OR ((tlinfo.FINANCIAL_PCT_RESP IS NULL) AND (X_FINANCIAL_PCT_RESP IS NULL))) THEN
389: pn_var_rent_pkg.lock_row_exception('FINANCIAL_PCT_RESP',tlinfo.FINANCIAL_PCT_RESP);
390: END IF;
391:
392: IF NOT ((tlinfo.RESPONSIBILITY_MAINT = X_RESPONSIBILITY_MAINT)
393: OR ((tlinfo.RESPONSIBILITY_MAINT IS NULL) AND (X_RESPONSIBILITY_MAINT IS NULL))) THEN

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

390: END IF;
391:
392: IF NOT ((tlinfo.RESPONSIBILITY_MAINT = X_RESPONSIBILITY_MAINT)
393: OR ((tlinfo.RESPONSIBILITY_MAINT IS NULL) AND (X_RESPONSIBILITY_MAINT IS NULL))) THEN
394: pn_var_rent_pkg.lock_row_exception('RESPONSIBILITY_MAINT',tlinfo.RESPONSIBILITY_MAINT);
395: END IF;
396:
397: IF NOT ((tlinfo.COMPANY_ID = X_COMPANY_ID)
398: OR ((tlinfo.COMPANY_ID IS NULL) AND (X_COMPANY_ID IS NULL))) THEN

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

395: END IF;
396:
397: IF NOT ((tlinfo.COMPANY_ID = X_COMPANY_ID)
398: OR ((tlinfo.COMPANY_ID IS NULL) AND (X_COMPANY_ID IS NULL))) THEN
399: pn_var_rent_pkg.lock_row_exception('COMPANY_ID',tlinfo.COMPANY_ID);
400: END IF;
401:
402: IF NOT ((tlinfo.OBLIGATION_REFERENCE = X_OBLIGATION_REFERENCE)
403: OR ((tlinfo.OBLIGATION_REFERENCE IS NULL) AND (X_OBLIGATION_REFERENCE IS NULL))) THEN

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

400: END IF;
401:
402: IF NOT ((tlinfo.OBLIGATION_REFERENCE = X_OBLIGATION_REFERENCE)
403: OR ((tlinfo.OBLIGATION_REFERENCE IS NULL) AND (X_OBLIGATION_REFERENCE IS NULL))) THEN
404: pn_var_rent_pkg.lock_row_exception('OBLIGATION_REFERENCE',tlinfo.OBLIGATION_REFERENCE);
405: END IF;
406:
407: IF NOT ((tlinfo.OBLIGATION_COMMENTS = X_OBLIGATION_COMMENTS)
408: OR ((tlinfo.OBLIGATION_COMMENTS IS NULL) AND (X_OBLIGATION_COMMENTS IS NULL))) THEN

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

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