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

Line 259: pn_var_rent_pkg.lock_row_exception('OPTION_ID',tlinfo.OPTION_ID);

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

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

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

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

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

Line 271: pn_var_rent_pkg.lock_row_exception('OPTION_NUM',tlinfo.OPTION_NUM);

267: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
268: END IF;
269:
270: IF NOT (tlinfo.OPTION_NUM = X_OPTION_NUM) THEN
271: pn_var_rent_pkg.lock_row_exception('OPTION_NUM',tlinfo.OPTION_NUM);
272: END IF;
273:
274: IF NOT (tlinfo.OPTION_TYPE_CODE = X_OPTION_TYPE_CODE) THEN
275: pn_var_rent_pkg.lock_row_exception('OPTION_TYPE_CODE',tlinfo.OPTION_TYPE_CODE);

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

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

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

276: END IF;
277:
278: IF NOT ((tlinfo.START_DATE = X_START_DATE)
279: OR ((tlinfo.START_DATE IS NULL) AND (X_START_DATE IS NULL))) THEN
280: pn_var_rent_pkg.lock_row_exception('START_DATE',tlinfo.START_DATE);
281: END IF;
282:
283: IF NOT ((tlinfo.EXPIRATION_DATE = X_EXPIRATION_DATE)
284: OR ((tlinfo.EXPIRATION_DATE IS NULL) AND (X_EXPIRATION_DATE IS NULL))) THEN

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

281: END IF;
282:
283: IF NOT ((tlinfo.EXPIRATION_DATE = X_EXPIRATION_DATE)
284: OR ((tlinfo.EXPIRATION_DATE IS NULL) AND (X_EXPIRATION_DATE IS NULL))) THEN
285: pn_var_rent_pkg.lock_row_exception('EXPIRATION_DATE',tlinfo.EXPIRATION_DATE);
286: END IF;
287:
288: IF NOT ((tlinfo.OPTION_SIZE = X_OPTION_SIZE)
289: OR ((tlinfo.OPTION_SIZE IS NULL) AND (X_OPTION_SIZE IS NULL))) THEN

Line 290: pn_var_rent_pkg.lock_row_exception('OPTION_SIZE',tlinfo.OPTION_SIZE);

286: END IF;
287:
288: IF NOT ((tlinfo.OPTION_SIZE = X_OPTION_SIZE)
289: OR ((tlinfo.OPTION_SIZE IS NULL) AND (X_OPTION_SIZE IS NULL))) THEN
290: pn_var_rent_pkg.lock_row_exception('OPTION_SIZE',tlinfo.OPTION_SIZE);
291: END IF;
292:
293: IF NOT ((tlinfo.UOM_CODE = X_UOM_CODE)
294: OR ((tlinfo.UOM_CODE IS NULL) AND (X_UOM_CODE IS NULL))) THEN

Line 295: pn_var_rent_pkg.lock_row_exception('UOM_CODE',tlinfo.UOM_CODE);

291: END IF;
292:
293: IF NOT ((tlinfo.UOM_CODE = X_UOM_CODE)
294: OR ((tlinfo.UOM_CODE IS NULL) AND (X_UOM_CODE IS NULL))) THEN
295: pn_var_rent_pkg.lock_row_exception('UOM_CODE',tlinfo.UOM_CODE);
296: END IF;
297:
298: IF NOT ((tlinfo.OPTION_STATUS_LOOKUP_CODE = X_OPTION_STATUS_LOOKUP_CODE)
299: OR ((tlinfo.OPTION_STATUS_LOOKUP_CODE IS NULL) AND (X_OPTION_STATUS_LOOKUP_CODE IS NULL))) THEN

Line 300: pn_var_rent_pkg.lock_row_exception('OPTION_STATUS_LOOKUP_CODE',tlinfo.OPTION_STATUS_LOOKUP_CODE);

296: END IF;
297:
298: IF NOT ((tlinfo.OPTION_STATUS_LOOKUP_CODE = X_OPTION_STATUS_LOOKUP_CODE)
299: OR ((tlinfo.OPTION_STATUS_LOOKUP_CODE IS NULL) AND (X_OPTION_STATUS_LOOKUP_CODE IS NULL))) THEN
300: pn_var_rent_pkg.lock_row_exception('OPTION_STATUS_LOOKUP_CODE',tlinfo.OPTION_STATUS_LOOKUP_CODE);
301: END IF;
302:
303: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
304: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN

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

301: END IF;
302:
303: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
304: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN
305: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
306: END IF;
307:
308: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
309: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN

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

306: END IF;
307:
308: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
309: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN
310: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
311: END IF;
312:
313: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
314: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN

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

311: END IF;
312:
313: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
314: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN
315: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
316: END IF;
317:
318: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
319: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN

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

316: END IF;
317:
318: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
319: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN
320: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
321: END IF;
322:
323: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
324: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN

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

321: END IF;
322:
323: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
324: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN
325: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
326: END IF;
327:
328: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
329: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN

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

326: END IF;
327:
328: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
329: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN
330: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
331: END IF;
332:
333: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
334: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN

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

331: END IF;
332:
333: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
334: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN
335: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
336: END IF;
337:
338: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
339: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN

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

336: END IF;
337:
338: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
339: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN
340: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
341: END IF;
342:
343: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
344: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN

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

341: END IF;
342:
343: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
344: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN
345: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
346: END IF;
347:
348: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
349: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN

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

346: END IF;
347:
348: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
349: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN
350: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
351: END IF;
352:
353: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
354: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN

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

351: END IF;
352:
353: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
354: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN
355: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
356: END IF;
357:
358: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
359: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN

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

356: END IF;
357:
358: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
359: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN
360: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
361: END IF;
362:
363: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
364: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN

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

361: END IF;
362:
363: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
364: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN
365: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
366: END IF;
367:
368: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
369: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN

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

366: END IF;
367:
368: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
369: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN
370: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
371: END IF;
372:
373: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
374: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN

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

371: END IF;
372:
373: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
374: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN
375: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
376: END IF;
377:
378: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
379: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN

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

376: END IF;
377:
378: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
379: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN
380: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
381: END IF;
382:
383: IF NOT ((tlinfo.OPTION_EXER_START_DATE = X_OPTION_EXER_START_DATE)
384: OR ((tlinfo.OPTION_EXER_START_DATE IS NULL) AND (X_OPTION_EXER_START_DATE IS NULL))) THEN

Line 385: pn_var_rent_pkg.lock_row_exception('OPTION_EXER_START_DATE',tlinfo.OPTION_EXER_START_DATE);

381: END IF;
382:
383: IF NOT ((tlinfo.OPTION_EXER_START_DATE = X_OPTION_EXER_START_DATE)
384: OR ((tlinfo.OPTION_EXER_START_DATE IS NULL) AND (X_OPTION_EXER_START_DATE IS NULL))) THEN
385: pn_var_rent_pkg.lock_row_exception('OPTION_EXER_START_DATE',tlinfo.OPTION_EXER_START_DATE);
386: END IF;
387:
388: IF NOT ((tlinfo.OPTION_EXER_END_DATE = X_OPTION_EXER_END_DATE)
389: OR ((tlinfo.OPTION_EXER_END_DATE IS NULL) AND (X_OPTION_EXER_END_DATE IS NULL))) THEN

Line 390: pn_var_rent_pkg.lock_row_exception('OPTION_EXER_END_DATE',tlinfo.OPTION_EXER_END_DATE);

386: END IF;
387:
388: IF NOT ((tlinfo.OPTION_EXER_END_DATE = X_OPTION_EXER_END_DATE)
389: OR ((tlinfo.OPTION_EXER_END_DATE IS NULL) AND (X_OPTION_EXER_END_DATE IS NULL))) THEN
390: pn_var_rent_pkg.lock_row_exception('OPTION_EXER_END_DATE',tlinfo.OPTION_EXER_END_DATE);
391: END IF;
392:
393: IF NOT ((tlinfo.OPTION_ACTION_DATE = X_OPTION_ACTION_DATE)
394: OR ((tlinfo.OPTION_ACTION_DATE IS NULL) AND (X_OPTION_ACTION_DATE IS NULL))) THEN

Line 395: pn_var_rent_pkg.lock_row_exception('OPTION_ACTION_DATE',tlinfo.OPTION_ACTION_DATE);

391: END IF;
392:
393: IF NOT ((tlinfo.OPTION_ACTION_DATE = X_OPTION_ACTION_DATE)
394: OR ((tlinfo.OPTION_ACTION_DATE IS NULL) AND (X_OPTION_ACTION_DATE IS NULL))) THEN
395: pn_var_rent_pkg.lock_row_exception('OPTION_ACTION_DATE',tlinfo.OPTION_ACTION_DATE);
396: END IF;
397:
398: IF NOT ((tlinfo.OPTION_COST = X_OPTION_COST)
399: OR ((tlinfo.OPTION_COST IS NULL) AND (X_OPTION_COST IS NULL))) THEN

Line 400: pn_var_rent_pkg.lock_row_exception('OPTION_COST',tlinfo.OPTION_COST);

396: END IF;
397:
398: IF NOT ((tlinfo.OPTION_COST = X_OPTION_COST)
399: OR ((tlinfo.OPTION_COST IS NULL) AND (X_OPTION_COST IS NULL))) THEN
400: pn_var_rent_pkg.lock_row_exception('OPTION_COST',tlinfo.OPTION_COST);
401: END IF;
402:
403: IF NOT ((tlinfo.OPTION_AREA_CHANGE = X_OPTION_AREA_CHANGE)
404: OR ((tlinfo.OPTION_AREA_CHANGE IS NULL) AND (X_OPTION_AREA_CHANGE IS NULL))) THEN

Line 405: pn_var_rent_pkg.lock_row_exception('OPTION_AREA_CHANGE',tlinfo.OPTION_AREA_CHANGE);

401: END IF;
402:
403: IF NOT ((tlinfo.OPTION_AREA_CHANGE = X_OPTION_AREA_CHANGE)
404: OR ((tlinfo.OPTION_AREA_CHANGE IS NULL) AND (X_OPTION_AREA_CHANGE IS NULL))) THEN
405: pn_var_rent_pkg.lock_row_exception('OPTION_AREA_CHANGE',tlinfo.OPTION_AREA_CHANGE);
406: END IF;
407:
408: IF NOT ((tlinfo.OPTION_REFERENCE = X_OPTION_REFERENCE)
409: OR ((tlinfo.OPTION_REFERENCE IS NULL) AND (X_OPTION_REFERENCE IS NULL))) THEN

Line 410: pn_var_rent_pkg.lock_row_exception('OPTION_REFERENCE',tlinfo.OPTION_REFERENCE);

406: END IF;
407:
408: IF NOT ((tlinfo.OPTION_REFERENCE = X_OPTION_REFERENCE)
409: OR ((tlinfo.OPTION_REFERENCE IS NULL) AND (X_OPTION_REFERENCE IS NULL))) THEN
410: pn_var_rent_pkg.lock_row_exception('OPTION_REFERENCE',tlinfo.OPTION_REFERENCE);
411: END IF;
412:
413: IF NOT ((tlinfo.OPTION_NOTICE_REQD = X_OPTION_NOTICE_REQD)
414: OR ((tlinfo.OPTION_NOTICE_REQD IS NULL) AND (X_OPTION_NOTICE_REQD IS NULL))) THEN

Line 415: pn_var_rent_pkg.lock_row_exception('OPTION_NOTICE_REQD',tlinfo.OPTION_NOTICE_REQD);

411: END IF;
412:
413: IF NOT ((tlinfo.OPTION_NOTICE_REQD = X_OPTION_NOTICE_REQD)
414: OR ((tlinfo.OPTION_NOTICE_REQD IS NULL) AND (X_OPTION_NOTICE_REQD IS NULL))) THEN
415: pn_var_rent_pkg.lock_row_exception('OPTION_NOTICE_REQD',tlinfo.OPTION_NOTICE_REQD);
416: END IF;
417:
418: IF NOT ((tlinfo.OPTION_COMMENTS = X_OPTION_COMMENTS)
419: OR ((tlinfo.OPTION_COMMENTS IS NULL) AND (X_OPTION_COMMENTS IS NULL))) THEN

Line 420: pn_var_rent_pkg.lock_row_exception('OPTION_COMMENTS',tlinfo.OPTION_COMMENTS);

416: END IF;
417:
418: IF NOT ((tlinfo.OPTION_COMMENTS = X_OPTION_COMMENTS)
419: OR ((tlinfo.OPTION_COMMENTS IS NULL) AND (X_OPTION_COMMENTS IS NULL))) THEN
420: pn_var_rent_pkg.lock_row_exception('OPTION_COMMENTS',tlinfo.OPTION_COMMENTS);
421: END IF;
422:
423: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.LOCK_ROW (-)');
424: