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

Line 237: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BKHD_DEFAULT_ID',tlinfo.BKHD_DEFAULT_ID);

233:
234: IF (tlinfo.BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID) THEN
235: null;
236: ELSE
237: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BKHD_DEFAULT_ID',tlinfo.BKHD_DEFAULT_ID);
238: END IF;
239:
240: IF (tlinfo.LINE_DEFAULT_ID = X_LINE_DEFAULT_ID) THEN
241: null;

Line 243: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_DEFAULT_ID',tlinfo.LINE_DEFAULT_ID);

239:
240: IF (tlinfo.LINE_DEFAULT_ID = X_LINE_DEFAULT_ID) THEN
241: null;
242: ELSE
243: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_DEFAULT_ID',tlinfo.LINE_DEFAULT_ID);
244: END IF;
245: IF ((tlinfo.AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID)
246: OR ((tlinfo.AGREEMENT_TEMPLATE_ID is null) AND (X_AGREEMENT_TEMPLATE_ID is null))) THEN
247: null;

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

245: IF ((tlinfo.AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID)
246: OR ((tlinfo.AGREEMENT_TEMPLATE_ID is null) AND (X_AGREEMENT_TEMPLATE_ID is null))) THEN
247: null;
248: ELSE
249: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('AGREEMENT_TEMPLATE_ID',tlinfo.AGREEMENT_TEMPLATE_ID);
250: END IF;
251:
252: IF ((tlinfo.BKHD_START_DATE = X_BKHD_START_DATE)
253: OR ((tlinfo.BKHD_START_DATE is null) AND (X_BKHD_START_DATE is null))) THEN

Line 256: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BKHD_START_DATE',tlinfo.BKHD_START_DATE);

252: IF ((tlinfo.BKHD_START_DATE = X_BKHD_START_DATE)
253: OR ((tlinfo.BKHD_START_DATE is null) AND (X_BKHD_START_DATE is null))) THEN
254: null;
255: ELSE
256: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BKHD_START_DATE',tlinfo.BKHD_START_DATE);
257: END IF;
258:
259: IF ((tlinfo.BKHD_END_DATE = X_BKHD_END_DATE)
260: OR ((tlinfo.BKHD_END_DATE is null) AND (X_BKHD_END_DATE is null))) THEN

Line 263: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BKHD_END_DATE',tlinfo.BKHD_END_DATE);

259: IF ((tlinfo.BKHD_END_DATE = X_BKHD_END_DATE)
260: OR ((tlinfo.BKHD_END_DATE is null) AND (X_BKHD_END_DATE is null))) THEN
261: null;
262: ELSE
263: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BKHD_END_DATE',tlinfo.BKHD_END_DATE);
264: END IF;
265:
266: IF ((tlinfo.BREAK_TYPE = X_BREAK_TYPE)
267: OR ((tlinfo.BREAK_TYPE is null) AND (X_BREAK_TYPE is null))) THEN

Line 270: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BREAK_TYPE',tlinfo.BREAK_TYPE);

266: IF ((tlinfo.BREAK_TYPE = X_BREAK_TYPE)
267: OR ((tlinfo.BREAK_TYPE is null) AND (X_BREAK_TYPE is null))) THEN
268: null;
269: ELSE
270: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BREAK_TYPE',tlinfo.BREAK_TYPE);
271: END IF;
272:
273: IF ((tlinfo.BASE_RENT_TYPE = X_BASE_RENT_TYPE)
274: OR ((tlinfo.BASE_RENT_TYPE is null) AND (X_BASE_RENT_TYPE is null))) THEN

Line 277: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BASE_RENT_TYPE',tlinfo.BASE_RENT_TYPE);

273: IF ((tlinfo.BASE_RENT_TYPE = X_BASE_RENT_TYPE)
274: OR ((tlinfo.BASE_RENT_TYPE is null) AND (X_BASE_RENT_TYPE is null))) THEN
275: null;
276: ELSE
277: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BASE_RENT_TYPE',tlinfo.BASE_RENT_TYPE);
278: END IF;
279:
280: IF ((tlinfo.NATURAL_BREAK_RATE = X_NATURAL_BREAK_RATE)
281: OR ((tlinfo.NATURAL_BREAK_RATE is null) AND (X_NATURAL_BREAK_RATE is null))) THEN

Line 284: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('NATURAL_BREAK_RATE',tlinfo.NATURAL_BREAK_RATE);

280: IF ((tlinfo.NATURAL_BREAK_RATE = X_NATURAL_BREAK_RATE)
281: OR ((tlinfo.NATURAL_BREAK_RATE is null) AND (X_NATURAL_BREAK_RATE is null))) THEN
282: null;
283: ELSE
284: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('NATURAL_BREAK_RATE',tlinfo.NATURAL_BREAK_RATE);
285: END IF;
286:
287: IF ((tlinfo.BASE_RENT = X_BASE_RENT)
288: OR ((tlinfo.BASE_RENT is null) AND (X_BASE_RENT is null))) THEN

Line 291: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BASE_RENT',tlinfo.BASE_RENT);

287: IF ((tlinfo.BASE_RENT = X_BASE_RENT)
288: OR ((tlinfo.BASE_RENT is null) AND (X_BASE_RENT is null))) THEN
289: null;
290: ELSE
291: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BASE_RENT',tlinfo.BASE_RENT);
292: END IF;
293:
294: IF ((tlinfo.BREAKPOINT_TYPE = X_BREAKPOINT_TYPE)
295: OR ((tlinfo.BREAKPOINT_TYPE is null) AND (X_BREAKPOINT_TYPE is null))) THEN

Line 298: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BREAKPOINT_TYPE',tlinfo.BREAKPOINT_TYPE);

294: IF ((tlinfo.BREAKPOINT_TYPE = X_BREAKPOINT_TYPE)
295: OR ((tlinfo.BREAKPOINT_TYPE is null) AND (X_BREAKPOINT_TYPE is null))) THEN
296: null;
297: ELSE
298: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BREAKPOINT_TYPE',tlinfo.BREAKPOINT_TYPE);
299: END IF;
300:
301: IF ((tlinfo.BREAKPOINT_LEVEL = X_BREAKPOINT_LEVEL)
302: OR ((tlinfo.BREAKPOINT_LEVEL is null) AND (X_BREAKPOINT_LEVEL is null))) THEN

Line 305: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BREAKPOINT_LEVEL',tlinfo.BREAKPOINT_LEVEL);

301: IF ((tlinfo.BREAKPOINT_LEVEL = X_BREAKPOINT_LEVEL)
302: OR ((tlinfo.BREAKPOINT_LEVEL is null) AND (X_BREAKPOINT_LEVEL is null))) THEN
303: null;
304: ELSE
305: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('BREAKPOINT_LEVEL',tlinfo.BREAKPOINT_LEVEL);
306: END IF;
307:
308: IF ((tlinfo.VAR_RENT_ID = X_VAR_RENT_ID)
309: OR ((tlinfo.VAR_RENT_ID is null) AND (X_VAR_RENT_ID is null))) THEN

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

308: IF ((tlinfo.VAR_RENT_ID = X_VAR_RENT_ID)
309: OR ((tlinfo.VAR_RENT_ID is null) AND (X_VAR_RENT_ID is null))) THEN
310: null;
311: ELSE
312: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VAR_RENT_ID',tlinfo.VAR_RENT_ID);
313: END IF;
314:
315: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
316: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then

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

315: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
316: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then
317: null;
318: else
319: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE_CATEGORY', to_char(tlinfo.ATTRIBUTE_CATEGORY));
320: end if;
321:
322:
323: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)

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

323: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
324: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) then
325: null;
326: else
327: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1', to_char(tlinfo.ATTRIBUTE1));
328: end if;
329:
330: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
331: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then

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

330: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
331: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then
332: null;
333: else
334: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE2', to_char(tlinfo.ATTRIBUTE2));
335: end if;
336:
337: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
338: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then

Line 341: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE3', to_char(tlinfo.ATTRIBUTE3));

337: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
338: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then
339: null;
340: else
341: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE3', to_char(tlinfo.ATTRIBUTE3));
342: end if;
343:
344: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
345: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then

Line 348: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE4', to_char(tlinfo.ATTRIBUTE4));

344: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
345: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then
346: null;
347: else
348: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE4', to_char(tlinfo.ATTRIBUTE4));
349: end if;
350:
351: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
352: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then

Line 355: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE5', to_char(tlinfo.ATTRIBUTE5));

351: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
352: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then
353: null;
354: else
355: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE5', to_char(tlinfo.ATTRIBUTE5));
356: end if;
357:
358: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
359: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then

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

358: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
359: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then
360: null;
361: else
362: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE6', to_char(tlinfo.ATTRIBUTE6));
363: end if;
364:
365: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
366: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then

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

365: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
366: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then
367: null;
368: else
369: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE7', to_char(tlinfo.ATTRIBUTE7));
370: end if;
371:
372: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
373: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then

Line 376: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE8', to_char(tlinfo.ATTRIBUTE8));

372: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
373: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then
374: null;
375: else
376: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE8', to_char(tlinfo.ATTRIBUTE8));
377: end if;
378:
379: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
380: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then

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

379: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
380: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then
381: null;
382: else
383: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE9', to_char(tlinfo.ATTRIBUTE9));
384: end if;
385:
386: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
387: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then

Line 390: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE10', to_char(tlinfo.ATTRIBUTE10));

386: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
387: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then
388: null;
389: else
390: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE10', to_char(tlinfo.ATTRIBUTE10));
391: end if;
392:
393: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
394: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then

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

393: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
394: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then
395: null;
396: else
397: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE11', to_char(tlinfo.ATTRIBUTE11));
398: end if;
399:
400: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
401: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then

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

400: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
401: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then
402: null;
403: else
404: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE12', to_char(tlinfo.ATTRIBUTE12));
405: end if;
406:
407: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
408: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then

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

407: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
408: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then
409: null;
410: else
411: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE13', to_char(tlinfo.ATTRIBUTE13));
412: end if;
413:
414: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
415: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then

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

414: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
415: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then
416: null;
417: else
418: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE14', to_char(tlinfo.ATTRIBUTE14));
419: end if;
420:
421: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
422: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then

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

421: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
422: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then
423: null;
424: else
425: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15', to_char(tlinfo.ATTRIBUTE15));
426: end if;
427:
428: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.LOCK_ROW (-)');
429: