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

Line 297: pn_var_rent_pkg.lock_row_exception('PROPERTY_NAME', tlinfo.property_name);

293: CLOSE c;
294:
295: IF NOT ((tlinfo.PROPERTY_NAME = X_PROPERTY_NAME)
296: OR ((tlinfo.PROPERTY_NAME is null) AND (X_PROPERTY_NAME is null))) THEN
297: pn_var_rent_pkg.lock_row_exception('PROPERTY_NAME', tlinfo.property_name);
298: END IF;
299:
300: IF NOT (tlinfo.PROPERTY_CODE = X_PROPERTY_CODE) THEN
301: pn_var_rent_pkg.lock_row_exception('PROPERTY_CODE', tlinfo.property_code);

Line 301: pn_var_rent_pkg.lock_row_exception('PROPERTY_CODE', tlinfo.property_code);

297: pn_var_rent_pkg.lock_row_exception('PROPERTY_NAME', tlinfo.property_name);
298: END IF;
299:
300: IF NOT (tlinfo.PROPERTY_CODE = X_PROPERTY_CODE) THEN
301: pn_var_rent_pkg.lock_row_exception('PROPERTY_CODE', tlinfo.property_code);
302: END IF;
303:
304: IF NOT ((tlinfo.LOCATION_PARK_ID = X_LOCATION_PARK_ID)
305: OR ((tlinfo.LOCATION_PARK_ID is null) AND (X_LOCATION_PARK_ID is null))) THEN

Line 306: pn_var_rent_pkg.lock_row_exception('LOCATION_PARK_ID',tlinfo.location_park_id);

302: END IF;
303:
304: IF NOT ((tlinfo.LOCATION_PARK_ID = X_LOCATION_PARK_ID)
305: OR ((tlinfo.LOCATION_PARK_ID is null) AND (X_LOCATION_PARK_ID is null))) THEN
306: pn_var_rent_pkg.lock_row_exception('LOCATION_PARK_ID',tlinfo.location_park_id);
307: END IF;
308:
309: IF NOT ((tlinfo.ZONE = X_ZONE)
310: OR ((tlinfo.ZONE is null) AND (X_ZONE is null))) THEN

Line 311: pn_var_rent_pkg.lock_row_exception('ZONE',tlinfo.zone);

307: END IF;
308:
309: IF NOT ((tlinfo.ZONE = X_ZONE)
310: OR ((tlinfo.ZONE is null) AND (X_ZONE is null))) THEN
311: pn_var_rent_pkg.lock_row_exception('ZONE',tlinfo.zone);
312: END IF;
313:
314: IF NOT ((tlinfo.DISTRICT = X_DISTRICT)
315: OR ((tlinfo.DISTRICT is null) AND (X_DISTRICT is null))) THEN

Line 316: pn_var_rent_pkg.lock_row_exception('DISTRICT',tlinfo.district);

312: END IF;
313:
314: IF NOT ((tlinfo.DISTRICT = X_DISTRICT)
315: OR ((tlinfo.DISTRICT is null) AND (X_DISTRICT is null))) THEN
316: pn_var_rent_pkg.lock_row_exception('DISTRICT',tlinfo.district);
317: END IF;
318:
319: IF NOT ((tlinfo.COUNTRY = X_COUNTRY)
320: OR ((tlinfo.COUNTRY is null) AND (X_COUNTRY is null))) THEN

Line 321: pn_var_rent_pkg.lock_row_exception('COUNTRY',tlinfo.country);

317: END IF;
318:
319: IF NOT ((tlinfo.COUNTRY = X_COUNTRY)
320: OR ((tlinfo.COUNTRY is null) AND (X_COUNTRY is null))) THEN
321: pn_var_rent_pkg.lock_row_exception('COUNTRY',tlinfo.country);
322: END IF;
323:
324: IF NOT ((tlinfo.DESCRIPTION = X_DESCRIPTION)
325: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null))) THEN

Line 326: pn_var_rent_pkg.lock_row_exception('DESCRIPTION',tlinfo.description);

322: END IF;
323:
324: IF NOT ((tlinfo.DESCRIPTION = X_DESCRIPTION)
325: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null))) THEN
326: pn_var_rent_pkg.lock_row_exception('DESCRIPTION',tlinfo.description);
327: END IF;
328:
329: IF NOT ((tlinfo.PORTFOLIO = X_PORTFOLIO)
330: OR ((tlinfo.PORTFOLIO is null) AND (X_PORTFOLIO is null))) THEN

Line 331: pn_var_rent_pkg.lock_row_exception('PORTFOLIO',tlinfo.portfolio);

327: END IF;
328:
329: IF NOT ((tlinfo.PORTFOLIO = X_PORTFOLIO)
330: OR ((tlinfo.PORTFOLIO is null) AND (X_PORTFOLIO is null))) THEN
331: pn_var_rent_pkg.lock_row_exception('PORTFOLIO',tlinfo.portfolio);
332: END IF;
333:
334: IF NOT (tlinfo.TENURE = X_TENURE) THEN
335: pn_var_rent_pkg.lock_row_exception('TENURE',tlinfo.tenure);

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

331: pn_var_rent_pkg.lock_row_exception('PORTFOLIO',tlinfo.portfolio);
332: END IF;
333:
334: IF NOT (tlinfo.TENURE = X_TENURE) THEN
335: pn_var_rent_pkg.lock_row_exception('TENURE',tlinfo.tenure);
336: END IF;
337:
338: IF NOT ((tlinfo.CLASS = X_CLASS)
339: OR ((tlinfo.CLASS is null) AND (X_CLASS is null))) THEN

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

336: END IF;
337:
338: IF NOT ((tlinfo.CLASS = X_CLASS)
339: OR ((tlinfo.CLASS is null) AND (X_CLASS is null))) THEN
340: pn_var_rent_pkg.lock_row_exception('CLASS',tlinfo.class);
341: END IF;
342:
343: IF NOT ((tlinfo.PROPERTY_STATUS = X_PROPERTY_STATUS)
344: OR ((tlinfo.PROPERTY_STATUS is null) AND (X_PROPERTY_STATUS is null))) THEN

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

341: END IF;
342:
343: IF NOT ((tlinfo.PROPERTY_STATUS = X_PROPERTY_STATUS)
344: OR ((tlinfo.PROPERTY_STATUS is null) AND (X_PROPERTY_STATUS is null))) THEN
345: pn_var_rent_pkg.lock_row_exception('PROPERTY_STATUS',tlinfo.property_status);
346: END IF;
347:
348: IF NOT ((tlinfo.CONDITION = X_CONDITION)
349: OR ((tlinfo.CONDITION is null) AND (X_CONDITION is null))) THEN

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

346: END IF;
347:
348: IF NOT ((tlinfo.CONDITION = X_CONDITION)
349: OR ((tlinfo.CONDITION is null) AND (X_CONDITION is null))) THEN
350: pn_var_rent_pkg.lock_row_exception('CONDITION',tlinfo.condition);
351: END IF;
352:
353: IF NOT ((tlinfo.ACTIVE_PROPERTY = X_ACTIVE_PROPERTY)
354: OR ((tlinfo.ACTIVE_PROPERTY is null) AND (X_ACTIVE_PROPERTY is null))) THEN

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

351: END IF;
352:
353: IF NOT ((tlinfo.ACTIVE_PROPERTY = X_ACTIVE_PROPERTY)
354: OR ((tlinfo.ACTIVE_PROPERTY is null) AND (X_ACTIVE_PROPERTY is null))) THEN
355: pn_var_rent_pkg.lock_row_exception('ACTIVE_PROPERTY',tlinfo.active_property);
356: END IF;
357:
358: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
359: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))THEN

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

356: END IF;
357:
358: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
359: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))THEN
360: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY', tlinfo.attribute_category);
361: END IF;
362:
363: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
364: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) THEN

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

361: END IF;
362:
363: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
364: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) THEN
365: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1', tlinfo.attribute1);
366: END IF;
367:
368: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
369: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) THEN

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

366: END IF;
367:
368: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
369: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) THEN
370: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2', tlinfo.attribute2);
371: END IF;
372:
373: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
374: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) THEN

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

371: END IF;
372:
373: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
374: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) THEN
375: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3', tlinfo.attribute3);
376: END IF;
377:
378: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
379: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) THEN

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

376: END IF;
377:
378: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
379: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) THEN
380: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4', tlinfo.attribute4);
381: END IF;
382:
383: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
384: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) THEN

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

381: END IF;
382:
383: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
384: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) THEN
385: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5', tlinfo.attribute5);
386: END IF;
387:
388: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
389: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) THEN

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

386: END IF;
387:
388: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
389: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) THEN
390: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6', tlinfo.attribute6);
391: END IF;
392:
393: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
394: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) THEN

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

391: END IF;
392:
393: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
394: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) THEN
395: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7', tlinfo.attribute7);
396: END IF;
397:
398: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
399: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) THEN

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

396: END IF;
397:
398: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
399: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) THEN
400: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8', tlinfo.attribute8);
401: END IF;
402:
403: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
404: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) THEN

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

401: END IF;
402:
403: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
404: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) THEN
405: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9', tlinfo.attribute9);
406: END IF;
407:
408: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
409: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) THEN

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

406: END IF;
407:
408: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
409: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) THEN
410: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10', tlinfo.attribute10);
411: END IF;
412:
413: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
414: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) THEN

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

411: END IF;
412:
413: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
414: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) THEN
415: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11', tlinfo.attribute11);
416: END IF;
417:
418: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
419: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) THEN

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

416: END IF;
417:
418: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
419: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) THEN
420: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12', tlinfo.attribute12);
421: END IF;
422:
423: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
424: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) THEN

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

421: END IF;
422:
423: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
424: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) THEN
425: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13', tlinfo.attribute13);
426: END IF;
427:
428: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
429: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) THEN

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

426: END IF;
427:
428: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
429: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) THEN
430: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14', tlinfo.attribute14);
431: END IF;
432:
433: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
434: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) THEN

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

431: END IF;
432:
433: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
434: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) THEN
435: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15', tlinfo.attribute15);
436: END IF;
437:
438:
439: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.LOCK_ROW (-)');