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

Line 215: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('SALES_TYPE_CODE', tlinfo.SALES_TYPE_CODE);

211: if ((tlinfo.SALES_TYPE_CODE = X_SALES_TYPE_CODE)
212: OR ((tlinfo.SALES_TYPE_CODE is null) AND (X_SALES_TYPE_CODE is null))) then
213: null;
214: else
215: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('SALES_TYPE_CODE', tlinfo.SALES_TYPE_CODE);
216: end if;
217:
218: if ((tlinfo.ITEM_CATEGORY_CODE = X_ITEM_CATEGORY_CODE)
219: OR ((tlinfo.ITEM_CATEGORY_CODE is null) AND (X_ITEM_CATEGORY_CODE is null))) then

Line 222: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ITEM_CATEGORY_CODE', tlinfo.ITEM_CATEGORY_CODE);

218: if ((tlinfo.ITEM_CATEGORY_CODE = X_ITEM_CATEGORY_CODE)
219: OR ((tlinfo.ITEM_CATEGORY_CODE is null) AND (X_ITEM_CATEGORY_CODE is null))) then
220: null;
221: else
222: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ITEM_CATEGORY_CODE', tlinfo.ITEM_CATEGORY_CODE);
223: End if;
224:
225: if ((tlinfo.LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID)
226: OR ((tlinfo.LINE_TEMPLATE_ID is null) AND (X_LINE_TEMPLATE_ID is null))) then

Line 229: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_TEMPLATE_ID', to_char(tlinfo.LINE_TEMPLATE_ID));

225: if ((tlinfo.LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID)
226: OR ((tlinfo.LINE_TEMPLATE_ID is null) AND (X_LINE_TEMPLATE_ID is null))) then
227: null;
228: else
229: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_TEMPLATE_ID', to_char(tlinfo.LINE_TEMPLATE_ID));
230: end if;
231:
232: if ((tlinfo.AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID)
233: OR ((tlinfo.AGREEMENT_TEMPLATE_ID is null) AND (X_AGREEMENT_TEMPLATE_ID is null))) then

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

232: if ((tlinfo.AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID)
233: OR ((tlinfo.AGREEMENT_TEMPLATE_ID is null) AND (X_AGREEMENT_TEMPLATE_ID is null))) then
234: null;
235: else
236: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('AGREEMENT_TEMPLATE_ID', to_char(tlinfo.AGREEMENT_TEMPLATE_ID));
237: end if;
238:
239: if ((tlinfo.LINE_START_DATE = X_LINE_START_DATE)
240: OR ((tlinfo.LINE_START_DATE is null) AND (X_LINE_START_DATE is null))) then

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

239: if ((tlinfo.LINE_START_DATE = X_LINE_START_DATE)
240: OR ((tlinfo.LINE_START_DATE is null) AND (X_LINE_START_DATE is null))) then
241: null;
242: else
243: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_START_DATE', to_char(tlinfo.LINE_START_DATE));
244: end if;
245:
246: if ((tlinfo.LINE_END_DATE = X_LINE_END_DATE)
247: OR ((tlinfo.LINE_END_DATE is null) AND (X_LINE_END_DATE is null))) then

Line 250: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_END_DATE', to_char(tlinfo.LINE_END_DATE));

246: if ((tlinfo.LINE_END_DATE = X_LINE_END_DATE)
247: OR ((tlinfo.LINE_END_DATE is null) AND (X_LINE_END_DATE is null))) then
248: null;
249: else
250: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_END_DATE', to_char(tlinfo.LINE_END_DATE));
251: end if;
252:
253: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
254: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then

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

253: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
254: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then
255: null;
256: else
257: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE_CATEGORY', to_char(tlinfo.ATTRIBUTE_CATEGORY));
258: end if;
259:
260:
261: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)

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

261: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
262: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) then
263: null;
264: else
265: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1', to_char(tlinfo.ATTRIBUTE1));
266: end if;
267:
268: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
269: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then

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

268: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
269: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then
270: null;
271: else
272: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE2', to_char(tlinfo.ATTRIBUTE2));
273: end if;
274:
275: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
276: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then

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

275: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
276: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then
277: null;
278: else
279: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE3', to_char(tlinfo.ATTRIBUTE3));
280: end if;
281:
282: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
283: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then

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

282: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
283: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then
284: null;
285: else
286: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE4', to_char(tlinfo.ATTRIBUTE4));
287: end if;
288:
289: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
290: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then

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

289: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
290: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then
291: null;
292: else
293: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE5', to_char(tlinfo.ATTRIBUTE5));
294: end if;
295:
296: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
297: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then

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

296: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
297: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then
298: null;
299: else
300: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE6', to_char(tlinfo.ATTRIBUTE6));
301: end if;
302:
303: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
304: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then

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

303: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
304: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then
305: null;
306: else
307: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE7', to_char(tlinfo.ATTRIBUTE7));
308: end if;
309:
310: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
311: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then

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

310: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
311: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then
312: null;
313: else
314: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE8', to_char(tlinfo.ATTRIBUTE8));
315: end if;
316:
317: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
318: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then

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

317: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
318: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then
319: null;
320: else
321: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE9', to_char(tlinfo.ATTRIBUTE9));
322: end if;
323:
324: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
325: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then

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

324: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
325: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then
326: null;
327: else
328: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE10', to_char(tlinfo.ATTRIBUTE10));
329: end if;
330:
331: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
332: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then

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

331: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
332: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then
333: null;
334: else
335: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE11', to_char(tlinfo.ATTRIBUTE11));
336: end if;
337:
338: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
339: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then

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

338: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
339: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then
340: null;
341: else
342: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE12', to_char(tlinfo.ATTRIBUTE12));
343: end if;
344:
345: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
346: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then

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

345: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
346: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then
347: null;
348: else
349: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE13', to_char(tlinfo.ATTRIBUTE13));
350: end if;
351:
352: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
353: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then

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

352: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
353: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then
354: null;
355: else
356: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE14', to_char(tlinfo.ATTRIBUTE14));
357: end if;
358:
359: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
360: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then

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

359: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
360: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then
361: null;
362: else
363: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15', to_char(tlinfo.ATTRIBUTE15));
364: end if;
365:
366: END LOOP;
367: