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

Line 192: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION(' LINE_TEMPLATE_ID',

188:
189: if (tlinfo. LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID) then
190: null;
191: else
192: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION(' LINE_TEMPLATE_ID',
193: to_char(tlinfo. LINE_TEMPLATE_ID));
194:
195: end if;
196: if (tlinfo.LINE_DETAIL_NUM = X_LINE_DETAIL_NUM) then

Line 199: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_DETAIL_NUM',

195: end if;
196: if (tlinfo.LINE_DETAIL_NUM = X_LINE_DETAIL_NUM) then
197: null;
198: else
199: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LINE_DETAIL_NUM',
200: to_char(tlinfo.LINE_DETAIL_NUM));
201:
202: end if;
203:

Line 209: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('AGREEMENT_TEMPLATE_ID',

205: OR ((tlinfo.AGREEMENT_TEMPLATE_ID is null) AND
206: (X_AGREEMENT_TEMPLATE_ID is null))) then
207: null;
208: else
209: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('AGREEMENT_TEMPLATE_ID',
210: to_char(tlinfo.AGREEMENT_TEMPLATE_ID));
211: end if;
212: if ((tlinfo.SALES_TYPE_CODE = X_SALES_TYPE_CODE)
213: OR ((tlinfo.SALES_TYPE_CODE is null) AND

Line 217: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('SALES_TYPE_CODE',

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

Line 225: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ITEM_CATEGORY_CODE',

221: OR ((tlinfo.ITEM_CATEGORY_CODE is null) AND
222: (X_ITEM_CATEGORY_CODE is null))) then
223: null;
224: else
225: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ITEM_CATEGORY_CODE',
226: tlinfo.ITEM_CATEGORY_CODE);
227: end if;
228:
229: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)

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

229: if ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
230: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) then
231: null;
232: else
233: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE_CATEGORY', to_char(tlinfo.ATTRIBUTE_CATEGORY));
234: end if;
235:
236:
237: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)

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

237: if ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
238: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) then
239: null;
240: else
241: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1', to_char(tlinfo.ATTRIBUTE1));
242: end if;
243:
244: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
245: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then

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

244: if ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
245: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) then
246: null;
247: else
248: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE2', to_char(tlinfo.ATTRIBUTE2));
249: end if;
250:
251: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
252: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then

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

251: if ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
252: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) then
253: null;
254: else
255: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE3', to_char(tlinfo.ATTRIBUTE3));
256: end if;
257:
258: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
259: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then

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

258: if ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
259: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) then
260: null;
261: else
262: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE4', to_char(tlinfo.ATTRIBUTE4));
263: end if;
264:
265: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
266: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then

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

265: if ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
266: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) then
267: null;
268: else
269: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE5', to_char(tlinfo.ATTRIBUTE5));
270: end if;
271:
272: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
273: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then

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

272: if ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
273: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) then
274: null;
275: else
276: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE6', to_char(tlinfo.ATTRIBUTE6));
277: end if;
278:
279: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
280: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then

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

279: if ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
280: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) then
281: null;
282: else
283: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE7', to_char(tlinfo.ATTRIBUTE7));
284: end if;
285:
286: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
287: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then

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

286: if ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
287: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) then
288: null;
289: else
290: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE8', to_char(tlinfo.ATTRIBUTE8));
291: end if;
292:
293: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
294: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then

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

293: if ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
294: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) then
295: null;
296: else
297: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE9', to_char(tlinfo.ATTRIBUTE9));
298: end if;
299:
300: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
301: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then

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

300: if ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
301: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) then
302: null;
303: else
304: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE10', to_char(tlinfo.ATTRIBUTE10));
305: end if;
306:
307: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
308: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then

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

307: if ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
308: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) then
309: null;
310: else
311: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE11', to_char(tlinfo.ATTRIBUTE11));
312: end if;
313:
314: if ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
315: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) then

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

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

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

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

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

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

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

335: if ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
336: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) then
337: null;
338: else
339: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15', to_char(tlinfo.ATTRIBUTE15));
340: end if;
341:
342: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.LOCK_ROW (-)');
343: