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

Line 284: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VOL_HIST_ID',tlinfo.VOL_HIST_ID);

280:
281: if (tlinfo.VOL_HIST_ID = X_VOL_HIST_ID) then
282: null;
283: else
284: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VOL_HIST_ID',tlinfo.VOL_HIST_ID);
285: end if;
286: if (tlinfo.VOL_HIST_NUM = X_VOL_HIST_NUM) then
287: null;
288: else

Line 289: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VOL_HIST_NUM',tlinfo.VOL_HIST_NUM);

285: end if;
286: if (tlinfo.VOL_HIST_NUM = X_VOL_HIST_NUM) then
287: null;
288: else
289: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VOL_HIST_NUM',tlinfo.VOL_HIST_NUM);
290: end if;
291: if ((tlinfo.LINE_ITEM_ID = X_LINE_ITEM_ID)
292: OR ((tlinfo.LINE_ITEM_ID is null) AND (X_LINE_ITEM_ID is null))) then
293: null;

Line 295: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_ITEM_ID',tlinfo.LINE_ITEM_ID);

291: if ((tlinfo.LINE_ITEM_ID = X_LINE_ITEM_ID)
292: OR ((tlinfo.LINE_ITEM_ID is null) AND (X_LINE_ITEM_ID is null))) then
293: null;
294: else
295: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_ITEM_ID',tlinfo.LINE_ITEM_ID);
296: end if;
297: if ((tlinfo.PERIOD_ID = X_PERIOD_ID)
298: OR ((tlinfo.PERIOD_ID is null) AND (X_PERIOD_ID is null))) then
299: null;

Line 301: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PERIOD_ID',tlinfo.PERIOD_ID);

297: if ((tlinfo.PERIOD_ID = X_PERIOD_ID)
298: OR ((tlinfo.PERIOD_ID is null) AND (X_PERIOD_ID is null))) then
299: null;
300: else
301: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PERIOD_ID',tlinfo.PERIOD_ID);
302: end if;
303: if (tlinfo.START_DATE = X_START_DATE) then
304: null;
305: else

Line 306: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('START_DATE',tlinfo.START_DATE);

302: end if;
303: if (tlinfo.START_DATE = X_START_DATE) then
304: null;
305: else
306: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('START_DATE',tlinfo.START_DATE);
307: end if;
308: if (tlinfo.END_DATE = X_END_DATE) then
309: null;
310: else

Line 311: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('END_DATE',tlinfo.END_DATE);

307: end if;
308: if (tlinfo.END_DATE = X_END_DATE) then
309: null;
310: else
311: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('END_DATE',tlinfo.END_DATE);
312: end if;
313: if ((tlinfo.GRP_DATE_ID = X_GRP_DATE_ID)
314: OR ((tlinfo.GRP_DATE_ID is null) AND (X_GRP_DATE_ID is null))) then
315: null;

Line 317: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('GRP_DATE_ID',tlinfo.GRP_DATE_ID);

313: if ((tlinfo.GRP_DATE_ID = X_GRP_DATE_ID)
314: OR ((tlinfo.GRP_DATE_ID is null) AND (X_GRP_DATE_ID is null))) then
315: null;
316: else
317: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('GRP_DATE_ID',tlinfo.GRP_DATE_ID);
318: end if;
319: if (tlinfo.GROUP_DATE = X_GROUP_DATE) then
320: null;
321: else

Line 322: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('GROUP_DATE',tlinfo.GROUP_DATE);

318: end if;
319: if (tlinfo.GROUP_DATE = X_GROUP_DATE) then
320: null;
321: else
322: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('GROUP_DATE',tlinfo.GROUP_DATE);
323: end if;
324: if ((tlinfo.REPORTING_DATE = X_REPORTING_DATE)
325: OR ((tlinfo.REPORTING_DATE is null) AND (X_REPORTING_DATE is null))) then
326: null;

Line 328: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('REPORTING_DATE',tlinfo.REPORTING_DATE);

324: if ((tlinfo.REPORTING_DATE = X_REPORTING_DATE)
325: OR ((tlinfo.REPORTING_DATE is null) AND (X_REPORTING_DATE is null))) then
326: null;
327: else
328: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('REPORTING_DATE',tlinfo.REPORTING_DATE);
329: end if;
330: if ((tlinfo.DUE_DATE = X_DUE_DATE)
331: OR ((tlinfo.DUE_DATE is null) AND (X_DUE_DATE is null))) then
332: null;

Line 334: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('DUE_DATE',tlinfo.DUE_DATE);

330: if ((tlinfo.DUE_DATE = X_DUE_DATE)
331: OR ((tlinfo.DUE_DATE is null) AND (X_DUE_DATE is null))) then
332: null;
333: else
334: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('DUE_DATE',tlinfo.DUE_DATE);
335: end if;
336: if (tlinfo.INVOICING_DATE = X_INVOICING_DATE) then
337: null;
338: else

Line 339: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('INVOICING_DATE',tlinfo.INVOICING_DATE);

335: end if;
336: if (tlinfo.INVOICING_DATE = X_INVOICING_DATE) then
337: null;
338: else
339: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('INVOICING_DATE',tlinfo.INVOICING_DATE);
340: end if;
341: if ((tlinfo.ACTUAL_GL_ACCOUNT_ID = X_ACTUAL_GL_ACCOUNT_ID)
342: OR ((tlinfo.ACTUAL_GL_ACCOUNT_ID is null) AND (X_ACTUAL_GL_ACCOUNT_ID is null))) then
343: null;

Line 345: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ACTUAL_GL_ACCOUNT_ID',tlinfo.ACTUAL_GL_ACCOUNT_ID);

341: if ((tlinfo.ACTUAL_GL_ACCOUNT_ID = X_ACTUAL_GL_ACCOUNT_ID)
342: OR ((tlinfo.ACTUAL_GL_ACCOUNT_ID is null) AND (X_ACTUAL_GL_ACCOUNT_ID is null))) then
343: null;
344: else
345: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ACTUAL_GL_ACCOUNT_ID',tlinfo.ACTUAL_GL_ACCOUNT_ID);
346: end if;
347: if ((tlinfo.ACTUAL_AMOUNT = X_ACTUAL_AMOUNT)
348: OR ((tlinfo.ACTUAL_AMOUNT is null) AND (X_ACTUAL_AMOUNT is null))) then
349: null;

Line 351: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ACTUAL_AMOUNT',tlinfo.ACTUAL_AMOUNT);

347: if ((tlinfo.ACTUAL_AMOUNT = X_ACTUAL_AMOUNT)
348: OR ((tlinfo.ACTUAL_AMOUNT is null) AND (X_ACTUAL_AMOUNT is null))) then
349: null;
350: else
351: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ACTUAL_AMOUNT',tlinfo.ACTUAL_AMOUNT);
352: end if;
353: if (tlinfo.VOL_HIST_STATUS_CODE = X_VOL_HIST_STATUS_CODE) then
354: null;
355: else

Line 356: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VOL_HIST_STATUS_CODE',tlinfo.VOL_HIST_STATUS_CODE);

352: end if;
353: if (tlinfo.VOL_HIST_STATUS_CODE = X_VOL_HIST_STATUS_CODE) then
354: null;
355: else
356: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VOL_HIST_STATUS_CODE',tlinfo.VOL_HIST_STATUS_CODE);
357: end if;
358: if ((tlinfo.REPORT_TYPE_CODE = X_REPORT_TYPE_CODE)
359: OR ((tlinfo.REPORT_TYPE_CODE is null) AND (X_REPORT_TYPE_CODE is null))) then
360: null;

Line 362: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('REPORT_TYPE_CODE',tlinfo.REPORT_TYPE_CODE);

358: if ((tlinfo.REPORT_TYPE_CODE = X_REPORT_TYPE_CODE)
359: OR ((tlinfo.REPORT_TYPE_CODE is null) AND (X_REPORT_TYPE_CODE is null))) then
360: null;
361: else
362: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('REPORT_TYPE_CODE',tlinfo.REPORT_TYPE_CODE);
363: end if;
364: if ((tlinfo.CERTIFIED_BY = X_CERTIFIED_BY)
365: OR ((tlinfo.CERTIFIED_BY is null) AND (X_CERTIFIED_BY is null))) then
366: null;

Line 368: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('CERTIFIED_BY',tlinfo.CERTIFIED_BY);

364: if ((tlinfo.CERTIFIED_BY = X_CERTIFIED_BY)
365: OR ((tlinfo.CERTIFIED_BY is null) AND (X_CERTIFIED_BY is null))) then
366: null;
367: else
368: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('CERTIFIED_BY',tlinfo.CERTIFIED_BY);
369: end if;
370: if (tlinfo.ACTUAL_EXP_CODE = X_ACTUAL_EXP_CODE) then
371: null;
372: else

Line 373: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ACTUAL_EXP_CODE',tlinfo.ACTUAL_EXP_CODE);

369: end if;
370: if (tlinfo.ACTUAL_EXP_CODE = X_ACTUAL_EXP_CODE) then
371: null;
372: else
373: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ACTUAL_EXP_CODE',tlinfo.ACTUAL_EXP_CODE);
374: end if;
375: if ((tlinfo.FOR_GL_ACCOUNT_ID = X_FOR_GL_ACCOUNT_ID)
376: OR ((tlinfo.FOR_GL_ACCOUNT_ID is null) AND (X_FOR_GL_ACCOUNT_ID is null))) then
377: null;

Line 379: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('FOR_GL_ACCOUNT_ID',tlinfo.FOR_GL_ACCOUNT_ID);

375: if ((tlinfo.FOR_GL_ACCOUNT_ID = X_FOR_GL_ACCOUNT_ID)
376: OR ((tlinfo.FOR_GL_ACCOUNT_ID is null) AND (X_FOR_GL_ACCOUNT_ID is null))) then
377: null;
378: else
379: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('FOR_GL_ACCOUNT_ID',tlinfo.FOR_GL_ACCOUNT_ID);
380: end if;
381: if ((tlinfo.FORECASTED_AMOUNT = X_FORECASTED_AMOUNT)
382: OR ((tlinfo.FORECASTED_AMOUNT is null) AND (X_FORECASTED_AMOUNT is null))) then
383: null;

Line 385: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('FORECASTED_AMOUNT',tlinfo.FORECASTED_AMOUNT);

381: if ((tlinfo.FORECASTED_AMOUNT = X_FORECASTED_AMOUNT)
382: OR ((tlinfo.FORECASTED_AMOUNT is null) AND (X_FORECASTED_AMOUNT is null))) then
383: null;
384: else
385: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('FORECASTED_AMOUNT',tlinfo.FORECASTED_AMOUNT);
386: end if;
387: if (tlinfo.FORECASTED_EXP_CODE = X_FORECASTED_EXP_CODE) then
388: null;
389: else

Line 390: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('FORECASTED_EXP_CODE',tlinfo.FORECASTED_EXP_CODE);

386: end if;
387: if (tlinfo.FORECASTED_EXP_CODE = X_FORECASTED_EXP_CODE) then
388: null;
389: else
390: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('FORECASTED_EXP_CODE',tlinfo.FORECASTED_EXP_CODE);
391: end if;
392: if (tlinfo.VARIANCE_EXP_CODE = X_VARIANCE_EXP_CODE) then
393: null;
394: else

Line 395: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VARIANCE_EXP_CODE',tlinfo.VARIANCE_EXP_CODE);

391: end if;
392: if (tlinfo.VARIANCE_EXP_CODE = X_VARIANCE_EXP_CODE) then
393: null;
394: else
395: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VARIANCE_EXP_CODE',tlinfo.VARIANCE_EXP_CODE);
396: end if;
397: if ((tlinfo.COMMENTS = X_COMMENTS)
398: OR ((tlinfo.COMMENTS is null) AND (X_COMMENTS is null))) then
399: null;

Line 401: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('COMMENTS',tlinfo.COMMENTS);

397: if ((tlinfo.COMMENTS = X_COMMENTS)
398: OR ((tlinfo.COMMENTS is null) AND (X_COMMENTS is null))) then
399: null;
400: else
401: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('COMMENTS',tlinfo.COMMENTS);
402: end if;
403: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
404: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then
405: null;

Line 407: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);

403: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
404: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then
405: null;
406: else
407: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
408: end if;
409: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
410: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) then
411: null;

Line 413: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);

409: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
410: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) then
411: null;
412: else
413: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
414: end if;
415: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
416: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then
417: null;

Line 419: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE2',tlinfo.ATTRIBUTE2);

415: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
416: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then
417: null;
418: else
419: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
420: end if;
421: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
422: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then
423: null;

Line 425: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE3',tlinfo.ATTRIBUTE3);

421: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
422: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then
423: null;
424: else
425: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
426: end if;
427: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
428: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then
429: null;

Line 431: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE4',tlinfo.ATTRIBUTE4);

427: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
428: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then
429: null;
430: else
431: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
432: end if;
433: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
434: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then
435: null;

Line 437: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE5',tlinfo.ATTRIBUTE5);

433: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
434: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then
435: null;
436: else
437: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
438: end if;
439: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
440: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then
441: null;

Line 443: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE6',tlinfo.ATTRIBUTE6);

439: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
440: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then
441: null;
442: else
443: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
444: end if;
445: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
446: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then
447: null;

Line 449: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE7',tlinfo.ATTRIBUTE7);

445: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
446: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then
447: null;
448: else
449: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
450: end if;
451: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
452: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then
453: null;

Line 455: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE8',tlinfo.ATTRIBUTE8);

451: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
452: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then
453: null;
454: else
455: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
456: end if;
457: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
458: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then
459: null;

Line 461: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE9',tlinfo.ATTRIBUTE9);

457: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
458: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then
459: null;
460: else
461: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
462: end if;
463: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
464: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then
465: null;

Line 467: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE10',tlinfo.ATTRIBUTE10);

463: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
464: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then
465: null;
466: else
467: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
468: end if;
469: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
470: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then
471: null;

Line 473: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE11',tlinfo.ATTRIBUTE11);

469: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
470: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then
471: null;
472: else
473: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
474: end if;
475: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
476: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then
477: null;

Line 479: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE12',tlinfo.ATTRIBUTE12);

475: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
476: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then
477: null;
478: else
479: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
480: end if;
481: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
482: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then
483: null;

Line 485: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE13',tlinfo.ATTRIBUTE13);

481: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
482: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then
483: null;
484: else
485: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
486: end if;
487: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
488: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then
489: null;

Line 491: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE14',tlinfo.ATTRIBUTE14);

487: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
488: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then
489: null;
490: else
491: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
492: end if;
493: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
494: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then
495: null;

Line 497: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15',tlinfo.ATTRIBUTE15);

493: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
494: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then
495: null;
496: else
497: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
498: end if;
499:
500: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.LOCK_ROW (-)');
501: