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

Line 204: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ABATEMENT_ID', to_char(tlinfo.ABATEMENT_ID));

200:
201: if (tlinfo.ABATEMENT_ID = X_ABATEMENT_ID) then
202: null;
203: else
204: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ABATEMENT_ID', to_char(tlinfo.ABATEMENT_ID));
205: end if;
206:
207: if ((tlinfo.VAR_RENT_ID = X_VAR_RENT_ID)
208: OR ((tlinfo.VAR_RENT_ID is null) AND (X_VAR_RENT_ID is null))) then

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

207: if ((tlinfo.VAR_RENT_ID = X_VAR_RENT_ID)
208: OR ((tlinfo.VAR_RENT_ID is null) AND (X_VAR_RENT_ID is null))) then
209: null;
210: else
211: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VAR_RENT_ID', to_char(tlinfo.VAR_RENT_ID));
212: end if;
213:
214: if ((tlinfo.START_DATE = X_START_DATE)
215: OR ((tlinfo.START_DATE is null) AND (X_START_DATE is null))) then

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

214: if ((tlinfo.START_DATE = X_START_DATE)
215: OR ((tlinfo.START_DATE is null) AND (X_START_DATE is null))) then
216: null;
217: else
218: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('START_DATE', to_char(tlinfo.START_DATE));
219: end if;
220:
221: if ((tlinfo.END_DATE = X_END_DATE)
222: OR ((tlinfo.END_DATE is null) AND (X_END_DATE is null))) then

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

221: if ((tlinfo.END_DATE = X_END_DATE)
222: OR ((tlinfo.END_DATE is null) AND (X_END_DATE is null))) then
223: null;
224: else
225: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('END_DATE', to_char(tlinfo.END_DATE));
226: end if;
227:
228: if ((tlinfo.TYPE_CODE = X_TYPE_CODE)
229: OR ((tlinfo.TYPE_CODE is null) AND (X_TYPE_CODE is null))) then

Line 232: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('TYPE_CODE', tlinfo.TYPE_CODE);

228: if ((tlinfo.TYPE_CODE = X_TYPE_CODE)
229: OR ((tlinfo.TYPE_CODE is null) AND (X_TYPE_CODE is null))) then
230: null;
231: else
232: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('TYPE_CODE', tlinfo.TYPE_CODE);
233: end if;
234:
235: if ((tlinfo.AMOUNT = X_AMOUNT)
236: OR ((tlinfo.AMOUNT is null) AND (X_AMOUNT is null))) then

Line 239: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('AMOUNT', to_char(tlinfo.AMOUNT));

235: if ((tlinfo.AMOUNT = X_AMOUNT)
236: OR ((tlinfo.AMOUNT is null) AND (X_AMOUNT is null))) then
237: null;
238: else
239: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('AMOUNT', to_char(tlinfo.AMOUNT));
240: end if;
241: if ((tlinfo.DESCRIPTION = X_DESCRIPTION)
242: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null))) then
243: null;

Line 245: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('DESCRIPTION', to_char(tlinfo.DESCRIPTION));

241: if ((tlinfo.DESCRIPTION = X_DESCRIPTION)
242: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null))) then
243: null;
244: else
245: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('DESCRIPTION', to_char(tlinfo.DESCRIPTION));
246: end if;
247:
248: if ((tlinfo.COMMENTS = X_COMMENTS)
249: OR ((tlinfo.COMMENTS is null) AND (X_COMMENTS is null))) then

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

248: if ((tlinfo.COMMENTS = X_COMMENTS)
249: OR ((tlinfo.COMMENTS is null) AND (X_COMMENTS is null))) then
250: null;
251: else
252: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('COMMENTS', to_char(tlinfo.COMMENTS));
253: end if;
254:
255: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
256: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then

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

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

Line 265: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',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',tlinfo.ATTRIBUTE1);
266: end if;
267: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
268: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then
269: null;

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

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

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

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

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

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

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

285: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
286: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then
287: null;
288: else
289: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
290: end if;
291: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
292: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then
293: null;

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

291: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
292: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then
293: null;
294: else
295: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
296: end if;
297: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
298: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then
299: null;

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

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

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

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

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

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

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

315: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
316: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then
317: null;
318: else
319: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE10', tlinfo.ATTRIBUTE10);
320: end if;
321: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
322: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then
323: null;

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

321: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
322: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then
323: null;
324: else
325: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
326: end if;
327: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
328: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then
329: null;

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

327: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
328: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then
329: null;
330: else
331: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
332: end if;
333: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
334: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then
335: null;

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

333: if ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
334: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) then
335: null;
336: else
337: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
338: end if;
339: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
340: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then
341: null;

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

339: if ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
340: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) then
341: null;
342: else
343: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
344: end if;
345: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
346: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then
347: null;

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

345: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
346: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then
347: null;
348: else
349: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
350: end if;
351:
352: if ((tlinfo.ORG_ID = X_ORG_ID)
353: OR ((tlinfo.ORG_ID is null) AND (X_ORG_ID is null))) then

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

352: if ((tlinfo.ORG_ID = X_ORG_ID)
353: OR ((tlinfo.ORG_ID is null) AND (X_ORG_ID is null))) then
354: null;
355: else
356: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ORG_ID', to_char(tlinfo.ORG_ID));
357: end if;
358:
359: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.LOCK_ROW (-)');
360: