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

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

214:
215: if (tlinfo.LINE_ITEM_ID = X_LINE_ITEM_ID) then
216: null;
217: else
218: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_ITEM_ID', to_char(tlinfo.LINE_ITEM_ID));
219: end if;
220: if (tlinfo.LINE_ITEM_NUM = X_LINE_ITEM_NUM) then
221: null;
222: else

Line 223: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_ITEM_NUM', to_char(tlinfo.LINE_ITEM_NUM));

219: end if;
220: if (tlinfo.LINE_ITEM_NUM = X_LINE_ITEM_NUM) then
221: null;
222: else
223: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_ITEM_NUM', to_char(tlinfo.LINE_ITEM_NUM));
224: end if;
225: if ((tlinfo.PERIOD_ID = X_PERIOD_ID)
226: OR ((tlinfo.PERIOD_ID is null) AND (X_PERIOD_ID is null))) then
227: null;

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

225: if ((tlinfo.PERIOD_ID = X_PERIOD_ID)
226: OR ((tlinfo.PERIOD_ID is null) AND (X_PERIOD_ID is null))) then
227: null;
228: else
229: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PERIOD_ID', to_char(tlinfo.PERIOD_ID));
230: end if;
231: if ((tlinfo.SALES_TYPE_CODE = X_SALES_TYPE_CODE)
232: OR ((tlinfo.SALES_TYPE_CODE is null) AND (X_SALES_TYPE_CODE is null))) then
233: null;

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

231: if ((tlinfo.SALES_TYPE_CODE = X_SALES_TYPE_CODE)
232: OR ((tlinfo.SALES_TYPE_CODE is null) AND (X_SALES_TYPE_CODE is null))) then
233: null;
234: else
235: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('SALES_TYPE_CODE',tlinfo.SALES_TYPE_CODE);
236: end if;
237: if ((tlinfo.ITEM_CATEGORY_CODE = X_ITEM_CATEGORY_CODE)
238: OR ((tlinfo.ITEM_CATEGORY_CODE is null) AND (X_ITEM_CATEGORY_CODE is null))) then
239: null;

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

237: if ((tlinfo.ITEM_CATEGORY_CODE = X_ITEM_CATEGORY_CODE)
238: OR ((tlinfo.ITEM_CATEGORY_CODE is null) AND (X_ITEM_CATEGORY_CODE is null))) then
239: null;
240: else
241: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ITEM_CATEGORY_CODE',tlinfo.ITEM_CATEGORY_CODE);
242: end if;
243: if ((tlinfo.COMMENTS = X_COMMENTS)
244: OR ((tlinfo.COMMENTS is null) AND (X_COMMENTS is null))) then
245: null;

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

243: if ((tlinfo.COMMENTS = X_COMMENTS)
244: OR ((tlinfo.COMMENTS is null) AND (X_COMMENTS is null))) then
245: null;
246: else
247: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('COMMENTS',tlinfo.COMMENTS);
248: end if;
249: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
250: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then
251: null;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

346: if ((tlinfo.LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID )
347: OR ((tlinfo.LINE_TEMPLATE_ID is null) AND (X_LINE_TEMPLATE_ID is null))) then
348: null;
349: else
350: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_TEMPLATE_ID ',tlinfo.LINE_TEMPLATE_ID );
351: end if;
352: if ((tlinfo.AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID)
353: OR ((tlinfo.AGREEMENT_TEMPLATE_ID is null) AND (X_AGREEMENT_TEMPLATE_ID is null))) then
354: null;

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

352: if ((tlinfo.AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID)
353: OR ((tlinfo.AGREEMENT_TEMPLATE_ID is null) AND (X_AGREEMENT_TEMPLATE_ID is null))) then
354: null;
355: else
356: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('AGREEMENT_TEMPLATE_ID',tlinfo.AGREEMENT_TEMPLATE_ID);
357: end if;
358: if ((tlinfo.LINE_DEFAULT_ID = X_LINE_DEFAULT_ID)
359: OR ((tlinfo.LINE_DEFAULT_ID is null) AND (X_LINE_DEFAULT_ID is null))) then
360: null;

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

358: if ((tlinfo.LINE_DEFAULT_ID = X_LINE_DEFAULT_ID)
359: OR ((tlinfo.LINE_DEFAULT_ID is null) AND (X_LINE_DEFAULT_ID is null))) then
360: null;
361: else
362: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_DEFAULT_ID',tlinfo.LINE_DEFAULT_ID);
363: end if;
364: if ((tlinfo.VAR_RENT_ID = X_VAR_RENT_ID)
365: OR ((tlinfo.VAR_RENT_ID is null) AND (X_VAR_RENT_ID is null))) then
366: null;

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

364: if ((tlinfo.VAR_RENT_ID = X_VAR_RENT_ID)
365: OR ((tlinfo.VAR_RENT_ID is null) AND (X_VAR_RENT_ID is null))) then
366: null;
367: else
368: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VAR_RENT_ID',tlinfo.VAR_RENT_ID);
369: end if;
370: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.LOCK_ROW (-)');
371:
372: END LOCK_ROW;