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

Line 290: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VAR_RENT_ID',tlinfo.VAR_RENT_ID);

286:
287: if (tlinfo.VAR_RENT_ID = X_VAR_RENT_ID) then
288: null;
289: else
290: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VAR_RENT_ID',tlinfo.VAR_RENT_ID);
291: end if;
292: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
293: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then
294: null;

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

292: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
293: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then
294: null;
295: else
296: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
297: end if;
298: if (tlinfo.LEASE_ID = X_LEASE_ID) then
299: null;
300: else

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

297: end if;
298: if (tlinfo.LEASE_ID = X_LEASE_ID) then
299: null;
300: else
301: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LEASE_ID',tlinfo.LEASE_ID);
302: end if;
303: if ((tlinfo.LOCATION_ID = X_LOCATION_ID)
304: OR ((tlinfo.LOCATION_ID is null) AND (X_LOCATION_ID is null))) then
305: null;

Line 307: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LOCATION_ID',tlinfo.LOCATION_ID);

303: if ((tlinfo.LOCATION_ID = X_LOCATION_ID)
304: OR ((tlinfo.LOCATION_ID is null) AND (X_LOCATION_ID is null))) then
305: null;
306: else
307: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LOCATION_ID',tlinfo.LOCATION_ID);
308: end if;
309:
310: if ((tlinfo.PRORATION_DAYS = X_PRORATION_DAYS)
311: OR ((tlinfo.PRORATION_DAYS is null) AND (X_PRORATION_DAYS is null))) then

Line 314: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PRORATION_DAYS',tlinfo.PRORATION_DAYS);

310: if ((tlinfo.PRORATION_DAYS = X_PRORATION_DAYS)
311: OR ((tlinfo.PRORATION_DAYS is null) AND (X_PRORATION_DAYS is null))) then
312: null;
313: else
314: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PRORATION_DAYS',tlinfo.PRORATION_DAYS);
315: end if;
316: if (tlinfo.PURPOSE_CODE = X_PURPOSE_CODE) then
317: null;
318: else

Line 319: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PURPOSE_CODE',tlinfo.PURPOSE_CODE);

315: end if;
316: if (tlinfo.PURPOSE_CODE = X_PURPOSE_CODE) then
317: null;
318: else
319: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PURPOSE_CODE',tlinfo.PURPOSE_CODE);
320: end if;
321: if (tlinfo.TYPE_CODE = X_TYPE_CODE) then
322: null;
323: else

Line 324: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('TYPE_CODE',tlinfo.TYPE_CODE);

320: end if;
321: if (tlinfo.TYPE_CODE = X_TYPE_CODE) then
322: null;
323: else
324: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('TYPE_CODE',tlinfo.TYPE_CODE);
325: end if;
326: if (trunc(tlinfo.COMMENCEMENT_DATE) = trunc(X_COMMENCEMENT_DATE)) then
327: null;
328: else

Line 329: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('COMMENCEMENT_DATE',tlinfo.COMMENCEMENT_DATE);

325: end if;
326: if (trunc(tlinfo.COMMENCEMENT_DATE) = trunc(X_COMMENCEMENT_DATE)) then
327: null;
328: else
329: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('COMMENCEMENT_DATE',tlinfo.COMMENCEMENT_DATE);
330: end if;
331: if (trunc(tlinfo.TERMINATION_DATE) = trunc(X_TERMINATION_DATE)) then
332: null;
333: else

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

330: end if;
331: if (trunc(tlinfo.TERMINATION_DATE) = trunc(X_TERMINATION_DATE)) then
332: null;
333: else
334: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('TERMINATION_DATE',tlinfo.TERMINATION_DATE);
335: end if;
336: if (tlinfo.ABSTRACTED_BY_USER = X_ABSTRACTED_BY_USER) then
337: null;
338: else

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

335: end if;
336: if (tlinfo.ABSTRACTED_BY_USER = X_ABSTRACTED_BY_USER) then
337: null;
338: else
339: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ABSTRACTED_BY_USER',tlinfo.ABSTRACTED_BY_USER);
340: end if;
341: if ((tlinfo.CUMULATIVE_VOL = X_CUMULATIVE_VOL)
342: OR ((tlinfo.CUMULATIVE_VOL is null) AND (X_CUMULATIVE_VOL is null))) then
343: null;

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

341: if ((tlinfo.CUMULATIVE_VOL = X_CUMULATIVE_VOL)
342: OR ((tlinfo.CUMULATIVE_VOL is null) AND (X_CUMULATIVE_VOL is null))) then
343: null;
344: else
345: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('CUMULATIVE_VOL',tlinfo.CUMULATIVE_VOL);
346: end if;
347: if ((tlinfo.ACCRUAL = X_ACCRUAL)
348: OR ((tlinfo.ACCRUAL is null) AND (X_ACCRUAL is null))) then
349: null;

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

347: if ((tlinfo.ACCRUAL = X_ACCRUAL)
348: OR ((tlinfo.ACCRUAL is null) AND (X_ACCRUAL is null))) then
349: null;
350: else
351: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ACCRUAL',tlinfo.ACCRUAL);
352: end if;
353: if ((tlinfo.UOM_CODE = X_UOM_CODE)
354: OR ((tlinfo.UOM_CODE is null) AND (X_UOM_CODE is null))) then
355: null;

Line 357: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('UOM_CODE',tlinfo.UOM_CODE);

353: if ((tlinfo.UOM_CODE = X_UOM_CODE)
354: OR ((tlinfo.UOM_CODE is null) AND (X_UOM_CODE is null))) then
355: null;
356: else
357: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('UOM_CODE',tlinfo.UOM_CODE);
358: end if;
359: if (tlinfo.INVOICE_ON = X_INVOICE_ON) then
360: null;
361: else

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

358: end if;
359: if (tlinfo.INVOICE_ON = X_INVOICE_ON) then
360: null;
361: else
362: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('INVOICE_ON',tlinfo.INVOICE_ON);
363: end if;
364: if (tlinfo.NEGATIVE_RENT = X_NEGATIVE_RENT) then
365: null;
366: else

Line 367: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('NEGATIVE_RENT',tlinfo.NEGATIVE_RENT);

363: end if;
364: if (tlinfo.NEGATIVE_RENT = X_NEGATIVE_RENT) then
365: null;
366: else
367: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('NEGATIVE_RENT',tlinfo.NEGATIVE_RENT);
368: end if;
369: if ((tlinfo.TERM_TEMPLATE_ID = X_TERM_TEMPLATE_ID)
370: OR ((tlinfo.TERM_TEMPLATE_ID is null) AND (X_TERM_TEMPLATE_ID is null))) then
371: null;

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

369: if ((tlinfo.TERM_TEMPLATE_ID = X_TERM_TEMPLATE_ID)
370: OR ((tlinfo.TERM_TEMPLATE_ID is null) AND (X_TERM_TEMPLATE_ID is null))) then
371: null;
372: else
373: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('TERM_TEMPLATE_ID',tlinfo.TERM_TEMPLATE_ID);
374: end if;
375: /* codev
376: if ((tlinfo.ABATEMENT_AMOUNT = X_ABATEMENT_AMOUNT)
377: OR ((tlinfo.ABATEMENT_AMOUNT is null) AND (X_ABATEMENT_AMOUNT is null))) then

Line 380: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ABATEMENT_AMOUNT',tlinfo.ABATEMENT_AMOUNT);

376: if ((tlinfo.ABATEMENT_AMOUNT = X_ABATEMENT_AMOUNT)
377: OR ((tlinfo.ABATEMENT_AMOUNT is null) AND (X_ABATEMENT_AMOUNT is null))) then
378: null;
379: else
380: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ABATEMENT_AMOUNT',tlinfo.ABATEMENT_AMOUNT);
381: end if; */
382: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
383: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then
384: null;

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

382: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
383: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then
384: null;
385: else
386: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
387: end if;
388: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
389: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) then
390: null;

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

388: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
389: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) then
390: null;
391: else
392: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
393: end if;
394: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
395: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then
396: null;

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

394: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
395: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then
396: null;
397: else
398: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
399: end if;
400: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
401: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then
402: null;

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

400: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
401: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then
402: null;
403: else
404: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
405: end if;
406: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
407: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then
408: null;

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

406: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
407: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then
408: null;
409: else
410: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
411: end if;
412: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
413: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then
414: null;

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

412: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
413: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then
414: null;
415: else
416: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
417: end if;
418: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
419: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then
420: null;

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

418: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
419: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then
420: null;
421: else
422: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
423: end if;
424: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
425: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then
426: null;

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

424: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
425: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then
426: null;
427: else
428: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
429: end if;
430: if ((tlinfo.RENT_NUM = X_RENT_NUM)
431: OR ((tlinfo.RENT_NUM is null) AND (X_RENT_NUM is null))) then
432: null;

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

430: if ((tlinfo.RENT_NUM = X_RENT_NUM)
431: OR ((tlinfo.RENT_NUM is null) AND (X_RENT_NUM is null))) then
432: null;
433: else
434: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
435: end if;
436: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
437: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then
438: null;

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

436: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
437: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then
438: null;
439: else
440: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
441: end if;
442: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
443: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then
444: null;

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

442: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
443: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then
444: null;
445: else
446: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
447: end if;
448: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
449: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then
450: null;

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

448: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
449: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then
450: null;
451: else
452: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
453: end if;
454: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
455: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then
456: null;

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

454: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
455: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then
456: null;
457: else
458: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
459: end if;
460: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
461: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then
462: null;

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

460: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
461: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then
462: null;
463: else
464: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
465: end if;
466: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
467: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then
468: null;

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

466: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
467: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then
468: null;
469: else
470: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
471: end if;
472: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
473: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then
474: null;

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

472: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
473: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then
474: null;
475: else
476: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
477: end if;
478: if ((tlinfo.CURRENCY_CODE = X_CURRENCY_CODE) --BUG#2452909
479: OR ((tlinfo.CURRENCY_CODE is null) AND (X_CURRENCY_CODE is null))) then
480: null;

Line 482: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('CURRENCY_CODE',tlinfo.CURRENCY_CODE);

478: if ((tlinfo.CURRENCY_CODE = X_CURRENCY_CODE) --BUG#2452909
479: OR ((tlinfo.CURRENCY_CODE is null) AND (X_CURRENCY_CODE is null))) then
480: null;
481: else
482: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('CURRENCY_CODE',tlinfo.CURRENCY_CODE);
483: end if;
484: if ((tlinfo.AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID)
485: OR ((tlinfo.AGREEMENT_TEMPLATE_ID is null) AND (X_AGREEMENT_TEMPLATE_ID is null))) then
486: null;

Line 488: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('AGREEMENT_TEMPLATE_ID',tlinfo.AGREEMENT_TEMPLATE_ID);

484: if ((tlinfo.AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID)
485: OR ((tlinfo.AGREEMENT_TEMPLATE_ID is null) AND (X_AGREEMENT_TEMPLATE_ID is null))) then
486: null;
487: else
488: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('AGREEMENT_TEMPLATE_ID',tlinfo.AGREEMENT_TEMPLATE_ID);
489: end if;
490: if ((tlinfo.PRORATION_RULE = X_PRORATION_RULE)
491: OR ((tlinfo.PRORATION_RULE is null) AND (X_PRORATION_RULE is null))) then
492: null;

Line 494: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PRORATION_RULE',tlinfo.PRORATION_RULE);

490: if ((tlinfo.PRORATION_RULE = X_PRORATION_RULE)
491: OR ((tlinfo.PRORATION_RULE is null) AND (X_PRORATION_RULE is null))) then
492: null;
493: else
494: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PRORATION_RULE',tlinfo.PRORATION_RULE);
495: end if;
496: if ((tlinfo.CHG_CAL_VAR_RENT_ID = X_CHG_CAL_VAR_RENT_ID)
497: OR ((tlinfo.CHG_CAL_VAR_RENT_ID is null) AND (X_CHG_CAL_VAR_RENT_ID is null))) then
498: null;

Line 500: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('CHG_CAL_VAR_RENT_ID',tlinfo.CHG_CAL_VAR_RENT_ID);

496: if ((tlinfo.CHG_CAL_VAR_RENT_ID = X_CHG_CAL_VAR_RENT_ID)
497: OR ((tlinfo.CHG_CAL_VAR_RENT_ID is null) AND (X_CHG_CAL_VAR_RENT_ID is null))) then
498: null;
499: else
500: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('CHG_CAL_VAR_RENT_ID',tlinfo.CHG_CAL_VAR_RENT_ID);
501: end if;
502:
503: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.LOCK_ROW (-)');
504:

Line 840: pn_var_rent_pkg.create_var_rent_periods(

836: x_var_rent_id := l_var_rent_id ;
837: x_var_rent_num := l_var_rent_num ;
838:
839: IF p_create_periods = 'Y' THEN
840: pn_var_rent_pkg.create_var_rent_periods(
841: p_var_rent_id => l_var_rent_id,
842: p_cumulative_vol => p_pn_var_rents_rec.cumulative_vol,
843: p_comm_date => p_pn_var_rents_rec.commencement_date,
844: p_term_date => p_pn_var_rents_rec.termination_date);

Line 919: PN_VAR_RENT_PKG.delete_var_rent_periods(l_varent_id);

915: FOR var_rent_rec IN get_var_rents(p_lease_id,p_termination_dt) LOOP
916:
917: l_varent_id := var_rent_rec.var_rent_id;
918:
919: PN_VAR_RENT_PKG.delete_var_rent_periods(l_varent_id);
920:
921: PN_VAR_TRX_PKG.delete_transactions( p_var_rent_id => l_varent_id
922: ,p_period_id => NULL
923: ,p_line_item_id => NULL);