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.PNT_CONT_PKG dependencies on PN_VAR_RENT_PKG

Line 363: pn_var_rent_pkg.lock_row_exception('last_name',Recinfo.last_name);

359: end if;
360: CLOSE C;
361:
362: IF NOT (recinfo.last_name = x_last_name) THEN
363: pn_var_rent_pkg.lock_row_exception('last_name',Recinfo.last_name);
364: END IF;
365: IF NOT (recinfo.status = x_status) THEN
366: pn_var_rent_pkg.lock_row_exception('status',Recinfo.status);
367: END IF;

Line 366: pn_var_rent_pkg.lock_row_exception('status',Recinfo.status);

362: IF NOT (recinfo.last_name = x_last_name) THEN
363: pn_var_rent_pkg.lock_row_exception('last_name',Recinfo.last_name);
364: END IF;
365: IF NOT (recinfo.status = x_status) THEN
366: pn_var_rent_pkg.lock_row_exception('status',Recinfo.status);
367: END IF;
368: IF NOT ( (recinfo.first_name = x_first_name)
369: or ((recinfo.first_name is null) and (x_first_name is null))) THEN
370: pn_var_rent_pkg.lock_row_exception('first_name',Recinfo.first_name);

Line 370: pn_var_rent_pkg.lock_row_exception('first_name',Recinfo.first_name);

366: pn_var_rent_pkg.lock_row_exception('status',Recinfo.status);
367: END IF;
368: IF NOT ( (recinfo.first_name = x_first_name)
369: or ((recinfo.first_name is null) and (x_first_name is null))) THEN
370: pn_var_rent_pkg.lock_row_exception('first_name',Recinfo.first_name);
371: END IF;
372: IF NOT ( (recinfo.job_title = x_job_title)
373: or ((recinfo.job_title is null) and (x_job_title is null))) THEN
374: pn_var_rent_pkg.lock_row_exception('job_title',Recinfo.job_title);

Line 374: pn_var_rent_pkg.lock_row_exception('job_title',Recinfo.job_title);

370: pn_var_rent_pkg.lock_row_exception('first_name',Recinfo.first_name);
371: END IF;
372: IF NOT ( (recinfo.job_title = x_job_title)
373: or ((recinfo.job_title is null) and (x_job_title is null))) THEN
374: pn_var_rent_pkg.lock_row_exception('job_title',Recinfo.job_title);
375: END IF;
376: IF NOT ( (recinfo.mail_stop = x_mail_stop)
377: or ((recinfo.mail_stop is null) and (x_mail_stop is null))) THEN
378: pn_var_rent_pkg.lock_row_exception('mail_stop',Recinfo.mail_stop);

Line 378: pn_var_rent_pkg.lock_row_exception('mail_stop',Recinfo.mail_stop);

374: pn_var_rent_pkg.lock_row_exception('job_title',Recinfo.job_title);
375: END IF;
376: IF NOT ( (recinfo.mail_stop = x_mail_stop)
377: or ((recinfo.mail_stop is null) and (x_mail_stop is null))) THEN
378: pn_var_rent_pkg.lock_row_exception('mail_stop',Recinfo.mail_stop);
379: END IF;
380: IF NOT ( (recinfo.email_address = x_email_address)
381: or ((recinfo.email_address is null) and (x_email_address is null))) THEN
382: pn_var_rent_pkg.lock_row_exception('email_address',Recinfo.email_address);

Line 382: pn_var_rent_pkg.lock_row_exception('email_address',Recinfo.email_address);

378: pn_var_rent_pkg.lock_row_exception('mail_stop',Recinfo.mail_stop);
379: END IF;
380: IF NOT ( (recinfo.email_address = x_email_address)
381: or ((recinfo.email_address is null) and (x_email_address is null))) THEN
382: pn_var_rent_pkg.lock_row_exception('email_address',Recinfo.email_address);
383: END IF;
384: IF NOT ( (recinfo.primary_flag = x_primary_flag)
385: or ((recinfo.primary_flag is null) and (x_primary_flag is null))) THEN
386: pn_var_rent_pkg.lock_row_exception('primary_flag',Recinfo.primary_flag);

Line 386: pn_var_rent_pkg.lock_row_exception('primary_flag',Recinfo.primary_flag);

382: pn_var_rent_pkg.lock_row_exception('email_address',Recinfo.email_address);
383: END IF;
384: IF NOT ( (recinfo.primary_flag = x_primary_flag)
385: or ((recinfo.primary_flag is null) and (x_primary_flag is null))) THEN
386: pn_var_rent_pkg.lock_row_exception('primary_flag',Recinfo.primary_flag);
387: END IF;
388: IF NOT ( (recinfo.attribute_category = x_attribute_category)
389: or ((recinfo.attribute_category is null) and (x_attribute_category is null))) THEN
390: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);

Line 390: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);

386: pn_var_rent_pkg.lock_row_exception('primary_flag',Recinfo.primary_flag);
387: END IF;
388: IF NOT ( (recinfo.attribute_category = x_attribute_category)
389: or ((recinfo.attribute_category is null) and (x_attribute_category is null))) THEN
390: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);
391: END IF;
392: IF NOT ( (recinfo.attribute1 = x_attribute1)
393: or ((recinfo.attribute1 is null) and (x_attribute1 is null))) THEN
394: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);

Line 394: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);

390: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);
391: END IF;
392: IF NOT ( (recinfo.attribute1 = x_attribute1)
393: or ((recinfo.attribute1 is null) and (x_attribute1 is null))) THEN
394: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);
395: END IF;
396: IF NOT ( (recinfo.attribute2 = x_attribute2)
397: or ((recinfo.attribute2 is null) and (x_attribute2 is null))) THEN
398: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);

Line 398: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);

394: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);
395: END IF;
396: IF NOT ( (recinfo.attribute2 = x_attribute2)
397: or ((recinfo.attribute2 is null) and (x_attribute2 is null))) THEN
398: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);
399: END IF;
400: IF NOT ( (recinfo.attribute3 = x_attribute3)
401: or ((recinfo.attribute3 is null) and (x_attribute3 is null))) THEN
402: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);

Line 402: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);

398: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);
399: END IF;
400: IF NOT ( (recinfo.attribute3 = x_attribute3)
401: or ((recinfo.attribute3 is null) and (x_attribute3 is null))) THEN
402: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);
403: END IF;
404: IF NOT ( (recinfo.attribute4 = x_attribute4)
405: or ((recinfo.attribute4 is null) and (x_attribute4 is null))) THEN
406: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);

Line 406: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);

402: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);
403: END IF;
404: IF NOT ( (recinfo.attribute4 = x_attribute4)
405: or ((recinfo.attribute4 is null) and (x_attribute4 is null))) THEN
406: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);
407: END IF;
408: IF NOT ( (recinfo.attribute5 = x_attribute5)
409: or ((recinfo.attribute5 is null) and (x_attribute5 is null))) THEN
410: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);

Line 410: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);

406: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);
407: END IF;
408: IF NOT ( (recinfo.attribute5 = x_attribute5)
409: or ((recinfo.attribute5 is null) and (x_attribute5 is null))) THEN
410: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);
411: END IF;
412: IF NOT ( (recinfo.attribute6 = x_attribute6)
413: or ((recinfo.attribute6 is null) and (x_attribute6 is null))) THEN
414: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);

Line 414: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);

410: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);
411: END IF;
412: IF NOT ( (recinfo.attribute6 = x_attribute6)
413: or ((recinfo.attribute6 is null) and (x_attribute6 is null))) THEN
414: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);
415: END IF;
416: IF NOT ( (recinfo.attribute7 = x_attribute7)
417: or ((recinfo.attribute7 is null) and (x_attribute7 is null))) THEN
418: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);

Line 418: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);

414: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);
415: END IF;
416: IF NOT ( (recinfo.attribute7 = x_attribute7)
417: or ((recinfo.attribute7 is null) and (x_attribute7 is null))) THEN
418: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);
419: END IF;
420: IF NOT ( (recinfo.attribute8 = x_attribute8)
421: or ((recinfo.attribute8 is null) and (x_attribute8 is null))) THEN
422: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);

Line 422: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);

418: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);
419: END IF;
420: IF NOT ( (recinfo.attribute8 = x_attribute8)
421: or ((recinfo.attribute8 is null) and (x_attribute8 is null))) THEN
422: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);
423: END IF;
424: IF NOT ( (recinfo.attribute9 = x_attribute9)
425: or ((recinfo.attribute9 is null) and (x_attribute9 is null))) THEN
426: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);

Line 426: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);

422: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);
423: END IF;
424: IF NOT ( (recinfo.attribute9 = x_attribute9)
425: or ((recinfo.attribute9 is null) and (x_attribute9 is null))) THEN
426: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);
427: END IF;
428: IF NOT ( (recinfo.attribute10 = x_attribute10)
429: or ((recinfo.attribute10 is null) and (x_attribute10 is null))) THEN
430: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);

Line 430: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);

426: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);
427: END IF;
428: IF NOT ( (recinfo.attribute10 = x_attribute10)
429: or ((recinfo.attribute10 is null) and (x_attribute10 is null))) THEN
430: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);
431: END IF;
432: IF NOT ( (recinfo.attribute11 = x_attribute11)
433: or ((recinfo.attribute11 is null) and (x_attribute11 is null))) THEN
434: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);

Line 434: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);

430: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);
431: END IF;
432: IF NOT ( (recinfo.attribute11 = x_attribute11)
433: or ((recinfo.attribute11 is null) and (x_attribute11 is null))) THEN
434: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);
435: END IF;
436: IF NOT ( (recinfo.attribute12 = x_attribute12)
437: or ((recinfo.attribute12 is null) and (x_attribute12 is null))) THEN
438: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);

Line 438: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);

434: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);
435: END IF;
436: IF NOT ( (recinfo.attribute12 = x_attribute12)
437: or ((recinfo.attribute12 is null) and (x_attribute12 is null))) THEN
438: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);
439: END IF;
440: IF NOT ( (recinfo.attribute13 = x_attribute13)
441: or ((recinfo.attribute13 is null) and (x_attribute13 is null))) THEN
442: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);

Line 442: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);

438: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);
439: END IF;
440: IF NOT ( (recinfo.attribute13 = x_attribute13)
441: or ((recinfo.attribute13 is null) and (x_attribute13 is null))) THEN
442: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);
443: END IF;
444: IF NOT ( (recinfo.attribute14 = x_attribute14)
445: or ((recinfo.attribute14 is null) and (x_attribute14 is null))) THEN
446: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);

Line 446: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);

442: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);
443: END IF;
444: IF NOT ( (recinfo.attribute14 = x_attribute14)
445: or ((recinfo.attribute14 is null) and (x_attribute14 is null))) THEN
446: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);
447: END IF;
448: IF NOT ( (recinfo.attribute15 = x_attribute15)
449: or ((recinfo.attribute15 is null) and (x_attribute15 is null))) THEN
450: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);

Line 450: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);

446: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);
447: END IF;
448: IF NOT ( (recinfo.attribute15 = x_attribute15)
449: or ((recinfo.attribute15 is null) and (x_attribute15 is null))) THEN
450: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);
451: END IF;
452:
453: END lock_row;
454: