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

Line 372: pn_var_rent_pkg.lock_row_exception('company_id',Recinfo.company_id);

368: END IF;
369: CLOSE C;
370:
371: IF NOT (Recinfo.company_id = x_company_id) THEN
372: pn_var_rent_pkg.lock_row_exception('company_id',Recinfo.company_id);
373: END IF;
374: IF NOT (Recinfo.company_number = x_company_number) THEN
375: pn_var_rent_pkg.lock_row_exception('company_number',Recinfo.company_number);
376: END IF;

Line 375: pn_var_rent_pkg.lock_row_exception('company_number',Recinfo.company_number);

371: IF NOT (Recinfo.company_id = x_company_id) THEN
372: pn_var_rent_pkg.lock_row_exception('company_id',Recinfo.company_id);
373: END IF;
374: IF NOT (Recinfo.company_number = x_company_number) THEN
375: pn_var_rent_pkg.lock_row_exception('company_number',Recinfo.company_number);
376: END IF;
377: IF NOT (Recinfo.name = x_name) THEN
378: pn_var_rent_pkg.lock_row_exception('name',Recinfo.name);
379: END IF;

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

374: IF NOT (Recinfo.company_number = x_company_number) THEN
375: pn_var_rent_pkg.lock_row_exception('company_number',Recinfo.company_number);
376: END IF;
377: IF NOT (Recinfo.name = x_name) THEN
378: pn_var_rent_pkg.lock_row_exception('name',Recinfo.name);
379: END IF;
380: IF NOT (Recinfo.enabled_flag = x_enabled_flag) THEN
381: pn_var_rent_pkg.lock_row_exception('enabled_flag',Recinfo.enabled_flag);
382: END IF;

Line 381: pn_var_rent_pkg.lock_row_exception('enabled_flag',Recinfo.enabled_flag);

377: IF NOT (Recinfo.name = x_name) THEN
378: pn_var_rent_pkg.lock_row_exception('name',Recinfo.name);
379: END IF;
380: IF NOT (Recinfo.enabled_flag = x_enabled_flag) THEN
381: pn_var_rent_pkg.lock_row_exception('enabled_flag',Recinfo.enabled_flag);
382: END IF;
383: IF NOT ((Recinfo.parent_company_id = x_parent_company_id)
384: or ((Recinfo.parent_company_id is null) and (x_parent_company_id is null))) THEN
385: pn_var_rent_pkg.lock_row_exception('parent_company_id',Recinfo.parent_company_id);

Line 385: pn_var_rent_pkg.lock_row_exception('parent_company_id',Recinfo.parent_company_id);

381: pn_var_rent_pkg.lock_row_exception('enabled_flag',Recinfo.enabled_flag);
382: END IF;
383: IF NOT ((Recinfo.parent_company_id = x_parent_company_id)
384: or ((Recinfo.parent_company_id is null) and (x_parent_company_id is null))) THEN
385: pn_var_rent_pkg.lock_row_exception('parent_company_id',Recinfo.parent_company_id);
386: END IF;
387: IF NOT ((Recinfo.attribute11 = x_attribute11)
388: or ((Recinfo.attribute11 is null) and (x_attribute11 is null))) THEN
389: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);

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

385: pn_var_rent_pkg.lock_row_exception('parent_company_id',Recinfo.parent_company_id);
386: END IF;
387: IF NOT ((Recinfo.attribute11 = x_attribute11)
388: or ((Recinfo.attribute11 is null) and (x_attribute11 is null))) THEN
389: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);
390: END IF;
391: IF NOT ((Recinfo.attribute12 = x_attribute12)
392: or ((Recinfo.attribute12 is null) and (x_attribute12 is null))) THEN
393: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);

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

389: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);
390: END IF;
391: IF NOT ((Recinfo.attribute12 = x_attribute12)
392: or ((Recinfo.attribute12 is null) and (x_attribute12 is null))) THEN
393: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);
394: END IF;
395: IF NOT ((Recinfo.attribute13 = x_attribute13)
396: or ((Recinfo.attribute13 is null) and (x_attribute13 is null))) THEN
397: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);

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

393: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);
394: END IF;
395: IF NOT ((Recinfo.attribute13 = x_attribute13)
396: or ((Recinfo.attribute13 is null) and (x_attribute13 is null))) THEN
397: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);
398: END IF;
399: IF NOT ((Recinfo.attribute14 = x_attribute14)
400: or ((Recinfo.attribute14 is null) and (x_attribute14 is null))) THEN
401: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);

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

397: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);
398: END IF;
399: IF NOT ((Recinfo.attribute14 = x_attribute14)
400: or ((Recinfo.attribute14 is null) and (x_attribute14 is null))) THEN
401: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);
402: END IF;
403: IF NOT ((Recinfo.attribute15 = x_attribute15)
404: or ((Recinfo.attribute15 is null) and (x_attribute15 is null))) THEN
405: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);

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

401: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);
402: END IF;
403: IF NOT ((Recinfo.attribute15 = x_attribute15)
404: or ((Recinfo.attribute15 is null) and (x_attribute15 is null))) THEN
405: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);
406: END IF;
407: IF NOT ((Recinfo.attribute_category = x_attribute_category)
408: or ((Recinfo.attribute_category is null) and (x_attribute_category is null))) THEN
409: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);

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

405: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);
406: END IF;
407: IF NOT ((Recinfo.attribute_category = x_attribute_category)
408: or ((Recinfo.attribute_category is null) and (x_attribute_category is null))) THEN
409: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);
410: END IF;
411: IF NOT ((Recinfo.attribute1 = x_attribute1)
412: or ((Recinfo.attribute1 is null) and (x_attribute1 is null))) THEN
413: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);

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

409: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);
410: END IF;
411: IF NOT ((Recinfo.attribute1 = x_attribute1)
412: or ((Recinfo.attribute1 is null) and (x_attribute1 is null))) THEN
413: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);
414: END IF;
415: IF NOT ((Recinfo.attribute2 = x_attribute2)
416: or ((Recinfo.attribute2 is null) and (x_attribute2 is null))) THEN
417: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);

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

413: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);
414: END IF;
415: IF NOT ((Recinfo.attribute2 = x_attribute2)
416: or ((Recinfo.attribute2 is null) and (x_attribute2 is null))) THEN
417: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);
418: END IF;
419: IF NOT ((Recinfo.attribute3 = x_attribute3)
420: or ((Recinfo.attribute3 is null) and (x_attribute3 is null))) THEN
421: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);

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

417: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);
418: END IF;
419: IF NOT ((Recinfo.attribute3 = x_attribute3)
420: or ((Recinfo.attribute3 is null) and (x_attribute3 is null))) THEN
421: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);
422: END IF;
423: IF NOT ((Recinfo.attribute4 = x_attribute4)
424: or ((Recinfo.attribute4 is null) and (x_attribute4 is null))) THEN
425: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);

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

421: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);
422: END IF;
423: IF NOT ((Recinfo.attribute4 = x_attribute4)
424: or ((Recinfo.attribute4 is null) and (x_attribute4 is null))) THEN
425: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);
426: END IF;
427: IF NOT ((Recinfo.attribute5 = x_attribute5)
428: or ((Recinfo.attribute5 is null) and (x_attribute5 is null))) THEN
429: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);

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

425: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);
426: END IF;
427: IF NOT ((Recinfo.attribute5 = x_attribute5)
428: or ((Recinfo.attribute5 is null) and (x_attribute5 is null))) THEN
429: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);
430: END IF;
431: IF NOT ((Recinfo.attribute6 = x_attribute6)
432: or ((Recinfo.attribute6 is null) and (x_attribute6 is null))) THEN
433: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);

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

429: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);
430: END IF;
431: IF NOT ((Recinfo.attribute6 = x_attribute6)
432: or ((Recinfo.attribute6 is null) and (x_attribute6 is null))) THEN
433: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);
434: END IF;
435: IF NOT ((Recinfo.attribute7 = x_attribute7)
436: or ((Recinfo.attribute7 is null) and (x_attribute7 is null))) THEN
437: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);

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

433: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);
434: END IF;
435: IF NOT ((Recinfo.attribute7 = x_attribute7)
436: or ((Recinfo.attribute7 is null) and (x_attribute7 is null))) THEN
437: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);
438: END IF;
439: IF NOT ((Recinfo.attribute8 = x_attribute8)
440: or ((Recinfo.attribute8 is null) and (x_attribute8 is null))) THEN
441: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);

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

437: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);
438: END IF;
439: IF NOT ((Recinfo.attribute8 = x_attribute8)
440: or ((Recinfo.attribute8 is null) and (x_attribute8 is null))) THEN
441: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);
442: END IF;
443: IF NOT ((Recinfo.attribute9 = x_attribute9)
444: or ((Recinfo.attribute9 is null) and (x_attribute9 is null))) THEN
445: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);

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

441: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);
442: END IF;
443: IF NOT ((Recinfo.attribute9 = x_attribute9)
444: or ((Recinfo.attribute9 is null) and (x_attribute9 is null))) THEN
445: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);
446: END IF;
447: IF NOT ((Recinfo.attribute10 = x_attribute10)
448: or ((Recinfo.attribute10 is null) and (x_attribute10 is null))) THEN
449: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);

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

445: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);
446: END IF;
447: IF NOT ((Recinfo.attribute10 = x_attribute10)
448: or ((Recinfo.attribute10 is null) and (x_attribute10 is null))) THEN
449: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);
450: END IF;
451:
452: END lock_row;
453: