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

Line 293: pn_var_rent_pkg.lock_row_exception('LOCATION_FEATURE_ID',Recinfo.location_feature_id);

289: CLOSE C;
290:
291: IF NOT ((Recinfo.LOCATION_FEATURE_ID = X_LOCATION_FEATURE_ID)
292: OR ((Recinfo.LOCATION_FEATURE_ID is null) AND (X_LOCATION_FEATURE_ID is null))) THEN
293: pn_var_rent_pkg.lock_row_exception('LOCATION_FEATURE_ID',Recinfo.location_feature_id);
294: END IF;
295:
296: IF NOT ((Recinfo.LOCATION_ID = X_LOCATION_ID)
297: OR ((Recinfo.LOCATION_ID is null) AND (X_LOCATION_ID is null))) THEN

Line 298: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',Recinfo.location_id);

294: END IF;
295:
296: IF NOT ((Recinfo.LOCATION_ID = X_LOCATION_ID)
297: OR ((Recinfo.LOCATION_ID is null) AND (X_LOCATION_ID is null))) THEN
298: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',Recinfo.location_id);
299: END IF;
300:
301: IF NOT ((Recinfo.LOCATION_FEATURE_LOOKUP_CODE = X_LOCATION_FEATURE_LOOKUP_CODE)
302: OR ((Recinfo.LOCATION_FEATURE_LOOKUP_CODE is null) AND (X_LOCATION_FEATURE_LOOKUP_CODE is null))) THEN

Line 303: pn_var_rent_pkg.lock_row_exception('LOCATION_FEATURE_LOOKUP_CODE',Recinfo.LOCATION_FEATURE_LOOKUP_CODE);

299: END IF;
300:
301: IF NOT ((Recinfo.LOCATION_FEATURE_LOOKUP_CODE = X_LOCATION_FEATURE_LOOKUP_CODE)
302: OR ((Recinfo.LOCATION_FEATURE_LOOKUP_CODE is null) AND (X_LOCATION_FEATURE_LOOKUP_CODE is null))) THEN
303: pn_var_rent_pkg.lock_row_exception('LOCATION_FEATURE_LOOKUP_CODE',Recinfo.LOCATION_FEATURE_LOOKUP_CODE);
304: END IF;
305:
306: IF NOT ((Recinfo.DESCRIPTION = X_DESCRIPTION)
307: OR ((Recinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null))) THEN

Line 308: pn_var_rent_pkg.lock_row_exception('DESCRIPTION',Recinfo.DESCRIPTION);

304: END IF;
305:
306: IF NOT ((Recinfo.DESCRIPTION = X_DESCRIPTION)
307: OR ((Recinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null))) THEN
308: pn_var_rent_pkg.lock_row_exception('DESCRIPTION',Recinfo.DESCRIPTION);
309: END IF;
310:
311: IF NOT ((Recinfo.QUANTITY = X_QUANTITY)
312: OR ((Recinfo.QUANTITY is null) AND (X_QUANTITY is null))) THEN

Line 313: pn_var_rent_pkg.lock_row_exception('QUANTITY',Recinfo.QUANTITY);

309: END IF;
310:
311: IF NOT ((Recinfo.QUANTITY = X_QUANTITY)
312: OR ((Recinfo.QUANTITY is null) AND (X_QUANTITY is null))) THEN
313: pn_var_rent_pkg.lock_row_exception('QUANTITY',Recinfo.QUANTITY);
314: END IF;
315:
316: IF NOT ((Recinfo.FEATURE_SIZE = X_FEATURE_SIZE)
317: OR ((Recinfo.FEATURE_SIZE is null) AND (X_FEATURE_SIZE is null))) THEN

Line 318: pn_var_rent_pkg.lock_row_exception('FEATURE_SIZE',Recinfo.FEATURE_SIZE);

314: END IF;
315:
316: IF NOT ((Recinfo.FEATURE_SIZE = X_FEATURE_SIZE)
317: OR ((Recinfo.FEATURE_SIZE is null) AND (X_FEATURE_SIZE is null))) THEN
318: pn_var_rent_pkg.lock_row_exception('FEATURE_SIZE',Recinfo.FEATURE_SIZE);
319: END IF;
320:
321: IF NOT ((Recinfo.UOM_CODE = X_UOM_CODE)
322: OR ((Recinfo.UOM_CODE is null) AND (X_UOM_CODE is null))) THEN

Line 323: pn_var_rent_pkg.lock_row_exception('UOM_CODE',Recinfo.UOM_CODE);

319: END IF;
320:
321: IF NOT ((Recinfo.UOM_CODE = X_UOM_CODE)
322: OR ((Recinfo.UOM_CODE is null) AND (X_UOM_CODE is null))) THEN
323: pn_var_rent_pkg.lock_row_exception('UOM_CODE',Recinfo.UOM_CODE);
324: END IF;
325:
326: IF NOT ((Recinfo.CONDITION_LOOKUP_CODE = X_CONDITION_LOOKUP_CODE)
327: OR ((Recinfo.CONDITION_LOOKUP_CODE is null) AND (X_CONDITION_LOOKUP_CODE is null))) THEN

Line 328: pn_var_rent_pkg.lock_row_exception('X_CONDITION_LOOKUP_CODE',Recinfo.CONDITION_LOOKUP_CODE);

324: END IF;
325:
326: IF NOT ((Recinfo.CONDITION_LOOKUP_CODE = X_CONDITION_LOOKUP_CODE)
327: OR ((Recinfo.CONDITION_LOOKUP_CODE is null) AND (X_CONDITION_LOOKUP_CODE is null))) THEN
328: pn_var_rent_pkg.lock_row_exception('X_CONDITION_LOOKUP_CODE',Recinfo.CONDITION_LOOKUP_CODE);
329: END IF;
330:
331: IF NOT ((Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
332: OR ((Recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))THEN

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

329: END IF;
330:
331: IF NOT ((Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
332: OR ((Recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))THEN
333: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY', Recinfo.attribute_category);
334: END IF;
335:
336: IF NOT ((Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
337: OR ((Recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) THEN

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

334: END IF;
335:
336: IF NOT ((Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
337: OR ((Recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) THEN
338: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1', Recinfo.attribute1);
339: END IF;
340:
341: IF NOT ((Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
342: OR ((Recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) THEN

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

339: END IF;
340:
341: IF NOT ((Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
342: OR ((Recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) THEN
343: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2', Recinfo.attribute2);
344: END IF;
345:
346: IF NOT ((Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
347: OR ((Recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) THEN

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

344: END IF;
345:
346: IF NOT ((Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
347: OR ((Recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) THEN
348: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3', Recinfo.attribute3);
349: END IF;
350:
351: IF NOT ((Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
352: OR ((Recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) THEN

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

349: END IF;
350:
351: IF NOT ((Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
352: OR ((Recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) THEN
353: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4', Recinfo.attribute4);
354: END IF;
355:
356: IF NOT ((Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
357: OR ((Recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) THEN

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

354: END IF;
355:
356: IF NOT ((Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
357: OR ((Recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) THEN
358: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5', Recinfo.attribute5);
359: END IF;
360:
361: IF NOT ((Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
362: OR ((Recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) THEN

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

359: END IF;
360:
361: IF NOT ((Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
362: OR ((Recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) THEN
363: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6', Recinfo.attribute6);
364: END IF;
365:
366: IF NOT ((Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
367: OR ((Recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) THEN

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

364: END IF;
365:
366: IF NOT ((Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
367: OR ((Recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) THEN
368: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7', Recinfo.attribute7);
369: END IF;
370:
371: IF NOT ((Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
372: OR ((Recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) THEN

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

369: END IF;
370:
371: IF NOT ((Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
372: OR ((Recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) THEN
373: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8', Recinfo.attribute8);
374: END IF;
375:
376: IF NOT ((Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
377: OR ((Recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) THEN

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

374: END IF;
375:
376: IF NOT ((Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
377: OR ((Recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) THEN
378: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9', Recinfo.attribute9);
379: END IF;
380:
381: IF NOT ((Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
382: OR ((Recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) THEN

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

379: END IF;
380:
381: IF NOT ((Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
382: OR ((Recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) THEN
383: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10', Recinfo.attribute10);
384: END IF;
385:
386: IF NOT ((Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
387: OR ((Recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) THEN

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

384: END IF;
385:
386: IF NOT ((Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
387: OR ((Recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) THEN
388: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11', Recinfo.attribute11);
389: END IF;
390:
391: IF NOT ((Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
392: OR ((Recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) THEN

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

389: END IF;
390:
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:
396: IF NOT ((Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
397: OR ((Recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) THEN

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

394: END IF;
395:
396: IF NOT ((Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
397: OR ((Recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) THEN
398: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13', Recinfo.attribute13);
399: END IF;
400:
401: IF NOT ((Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
402: OR ((Recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) THEN

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

399: END IF;
400:
401: IF NOT ((Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
402: OR ((Recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) THEN
403: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14', Recinfo.attribute14);
404: END IF;
405:
406: IF NOT ((Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
407: OR ((Recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) THEN

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

404: END IF;
405:
406: IF NOT ((Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
407: OR ((Recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) THEN
408: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15', Recinfo.attribute15);
409: END IF;
410:
411: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.lock_row (-)');
412: END LOCK_ROW;