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

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

232:
233: if (tlinfo.DEDUCTION_ID = X_DEDUCTION_ID) then
234: null;
235: else
236: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('DEDUCTION_ID',to_char(tlinfo.DEDUCTION_ID));
237: end if;
238:
239: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
240: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then

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

239: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
240: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then
241: null;
242: else
243: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
244: end if;
245:
246: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
247: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then

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

246: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
247: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then
248: null;
249: else
250: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
251: end if;
252:
253:
254: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)

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

254: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
255: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then
256: null;
257: else
258: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
259: end if;
260:
261: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
262: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then

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

261: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
262: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then
263: null;
264: else
265: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
266: end if;
267:
268: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
269: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then

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

268: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
269: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then
270: null;
271: else
272: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
273: end if;
274:
275: if (tlinfo.DEDUCTION_NUM = X_DEDUCTION_NUM) then
276: null;

Line 278: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('DEDUCTION_NUM',to_char(tlinfo.DEDUCTION_NUM));

274:
275: if (tlinfo.DEDUCTION_NUM = X_DEDUCTION_NUM) then
276: null;
277: else
278: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('DEDUCTION_NUM',to_char(tlinfo.DEDUCTION_NUM));
279: end if;
280:
281: if (tlinfo.EXPORTED_CODE = X_EXPORTED_CODE) then
282: null;

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

280:
281: if (tlinfo.EXPORTED_CODE = X_EXPORTED_CODE) then
282: null;
283: else
284: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('EXPORTED_CODE',tlinfo.EXPORTED_CODE);
285: end if;
286:
287: if ((tlinfo.COMMENTS = X_COMMENTS)
288: OR ((tlinfo.COMMENTS is null) AND (X_COMMENTS is null))) then

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

287: if ((tlinfo.COMMENTS = X_COMMENTS)
288: OR ((tlinfo.COMMENTS is null) AND (X_COMMENTS is null))) then
289: null;
290: else
291: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('COMMENTS',tlinfo.COMMENTS);
292: end if;
293:
294: if ((tlinfo.DEDUCTION_TYPE_CODE = X_DEDUCTION_TYPE_CODE)
295: OR ((tlinfo.DEDUCTION_TYPE_CODE is null) AND (X_DEDUCTION_TYPE_CODE is null))) then

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

294: if ((tlinfo.DEDUCTION_TYPE_CODE = X_DEDUCTION_TYPE_CODE)
295: OR ((tlinfo.DEDUCTION_TYPE_CODE is null) AND (X_DEDUCTION_TYPE_CODE is null))) then
296: null;
297: else
298: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('DEDUCTION_TYPE_CODE',tlinfo.DEDUCTION_TYPE_CODE);
299: end if;
300:
301: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
302: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then

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

301: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
302: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then
303: null;
304: else
305: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
306: end if;
307:
308: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
309: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) then

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

308: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
309: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) then
310: null;
311: else
312: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
313: end if;
314:
315: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
316: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then

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

315: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
316: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then
317: null;
318: else
319: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
320: end if;
321:
322: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
323: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then

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

322: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
323: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then
324: null;
325: else
326: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
327: end if;
328:
329: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
330: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then

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

329: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
330: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then
331: null;
332: else
333: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
334: end if;
335:
336: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
337: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then

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

336: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
337: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then
338: null;
339: else
340: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
341: end if;
342:
343: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
344: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then

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

343: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
344: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then
345: null;
346: else
347: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
348: end if;
349:
350: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
351: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then

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

350: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
351: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then
352: null;
353: else
354: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
355: end if;
356:
357: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
358: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then

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

357: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
358: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then
359: null;
360: else
361: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
362: end if;
363:
364: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
365: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then

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

364: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
365: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then
366: null;
367: else
368: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
369: end if;
370:
371: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
372: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then

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

371: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
372: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then
373: null;
374: else
375: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
376: end if;
377:
378: if ((tlinfo.LINE_ITEM_ID = X_LINE_ITEM_ID)
379: OR ((tlinfo.LINE_ITEM_ID is null) AND (X_LINE_ITEM_ID is null))) then

Line 382: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_ITEM_ID',to_char(tlinfo.LINE_ITEM_ID));

378: if ((tlinfo.LINE_ITEM_ID = X_LINE_ITEM_ID)
379: OR ((tlinfo.LINE_ITEM_ID is null) AND (X_LINE_ITEM_ID is null))) then
380: null;
381: else
382: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_ITEM_ID',to_char(tlinfo.LINE_ITEM_ID));
383: end if;
384:
385: if ((tlinfo.PERIOD_ID = X_PERIOD_ID)
386: OR ((tlinfo.PERIOD_ID is null) AND (X_PERIOD_ID is null))) then

Line 389: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PERIOD_ID',to_char(tlinfo.PERIOD_ID));

385: if ((tlinfo.PERIOD_ID = X_PERIOD_ID)
386: OR ((tlinfo.PERIOD_ID is null) AND (X_PERIOD_ID is null))) then
387: null;
388: else
389: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PERIOD_ID',to_char(tlinfo.PERIOD_ID));
390: end if;
391:
392: if ((tlinfo.GRP_DATE_ID = X_GRP_DATE_ID)
393: OR ((tlinfo.GRP_DATE_ID is null) AND (X_GRP_DATE_ID is null))) then

Line 396: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('GRP_DATE_ID',to_char(tlinfo.GRP_DATE_ID));

392: if ((tlinfo.GRP_DATE_ID = X_GRP_DATE_ID)
393: OR ((tlinfo.GRP_DATE_ID is null) AND (X_GRP_DATE_ID is null))) then
394: null;
395: else
396: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('GRP_DATE_ID',to_char(tlinfo.GRP_DATE_ID));
397: end if;
398:
399: if (tlinfo.START_DATE = X_START_DATE) then
400: null;

Line 402: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('START_DATE',to_char(tlinfo.START_DATE));

398:
399: if (tlinfo.START_DATE = X_START_DATE) then
400: null;
401: else
402: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('START_DATE',to_char(tlinfo.START_DATE));
403: end if;
404:
405: if (tlinfo.END_DATE = X_END_DATE) then
406: null;

Line 408: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('END_DATE',to_char(tlinfo.END_DATE));

404:
405: if (tlinfo.END_DATE = X_END_DATE) then
406: null;
407: else
408: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('END_DATE',to_char(tlinfo.END_DATE));
409: end if;
410:
411: if (tlinfo.GROUP_DATE = X_GROUP_DATE) then
412: null;

Line 414: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('GROUP_DATE',to_char(tlinfo.GROUP_DATE));

410:
411: if (tlinfo.GROUP_DATE = X_GROUP_DATE) then
412: null;
413: else
414: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('GROUP_DATE',to_char(tlinfo.GROUP_DATE));
415: end if;
416:
417: if (tlinfo.INVOICING_DATE = X_INVOICING_DATE) then
418: null;

Line 420: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('INVOICING_DATE',to_char(tlinfo.INVOICING_DATE));

416:
417: if (tlinfo.INVOICING_DATE = X_INVOICING_DATE) then
418: null;
419: else
420: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('INVOICING_DATE',to_char(tlinfo.INVOICING_DATE));
421: end if;
422:
423: if ((tlinfo.GL_ACCOUNT_ID = X_GL_ACCOUNT_ID)
424: OR ((tlinfo.GL_ACCOUNT_ID is null) AND (X_GL_ACCOUNT_ID is null))) then

Line 427: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('GL_ACCOUNT_ID',to_char(tlinfo.GL_ACCOUNT_ID));

423: if ((tlinfo.GL_ACCOUNT_ID = X_GL_ACCOUNT_ID)
424: OR ((tlinfo.GL_ACCOUNT_ID is null) AND (X_GL_ACCOUNT_ID is null))) then
425: null;
426: else
427: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('GL_ACCOUNT_ID',to_char(tlinfo.GL_ACCOUNT_ID));
428: end if;
429:
430: if (tlinfo.DEDUCTION_AMOUNT = X_DEDUCTION_AMOUNT)then
431: null;

Line 433: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('DEDUCTION_AMOUNT',to_char(tlinfo.DEDUCTION_AMOUNT));

429:
430: if (tlinfo.DEDUCTION_AMOUNT = X_DEDUCTION_AMOUNT)then
431: null;
432: else
433: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('DEDUCTION_AMOUNT',to_char(tlinfo.DEDUCTION_AMOUNT));
434: end if;
435:
436:
437: PNP_DEBUG_PKG.debug ('PN_VAR_DEDUCTIONS_PKG.LOCK_ROW (-)');