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

Line 237: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.lease_change_id);

233: END IF;
234: CLOSE c1;
235:
236: IF NOT (tlinfo.lease_change_id = x_lease_change_id) THEN
237: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.lease_change_id);
238: END IF;
239:
240: IF NOT (tlinfo.lease_id = x_lease_id) THEN
241: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.lease_id);

Line 241: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.lease_id);

237: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.lease_change_id);
238: END IF;
239:
240: IF NOT (tlinfo.lease_id = x_lease_id) THEN
241: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.lease_id);
242: END IF;
243:
244: IF NOT ((tlinfo.responsible_user = x_responsible_user)
245: OR ((tlinfo.responsible_user IS NULL) AND (x_responsible_user IS NULL))) THEN

Line 246: pn_var_rent_pkg.lock_row_exception('RESPONSIBLE_USER',tlinfo.responsible_user);

242: END IF;
243:
244: IF NOT ((tlinfo.responsible_user = x_responsible_user)
245: OR ((tlinfo.responsible_user IS NULL) AND (x_responsible_user IS NULL))) THEN
246: pn_var_rent_pkg.lock_row_exception('RESPONSIBLE_USER',tlinfo.responsible_user);
247: END IF;
248:
249: IF NOT ((tlinfo.expense_account_id = x_expense_account_id)
250: OR ((tlinfo.expense_account_id IS NULL) AND (x_expense_account_id IS NULL))) THEN

Line 251: pn_var_rent_pkg.lock_row_exception('EXPENSE_ACCOUNT_ID',tlinfo.expense_account_id);

247: END IF;
248:
249: IF NOT ((tlinfo.expense_account_id = x_expense_account_id)
250: OR ((tlinfo.expense_account_id IS NULL) AND (x_expense_account_id IS NULL))) THEN
251: pn_var_rent_pkg.lock_row_exception('EXPENSE_ACCOUNT_ID',tlinfo.expense_account_id);
252: END IF;
253:
254: IF NOT ((tlinfo.lease_commencement_date = x_lease_commencement_date)
255: OR ((tlinfo.lease_commencement_date IS NULL) AND (x_lease_commencement_date IS NULL))) THEN

Line 256: pn_var_rent_pkg.lock_row_exception('LEASE_COMMENCEMENT_DATE',tlinfo.lease_commencement_date);

252: END IF;
253:
254: IF NOT ((tlinfo.lease_commencement_date = x_lease_commencement_date)
255: OR ((tlinfo.lease_commencement_date IS NULL) AND (x_lease_commencement_date IS NULL))) THEN
256: pn_var_rent_pkg.lock_row_exception('LEASE_COMMENCEMENT_DATE',tlinfo.lease_commencement_date);
257: END IF;
258:
259: IF NOT ((tlinfo.lease_termination_date = x_lease_termination_date)
260: OR ((tlinfo.lease_termination_date IS NULL) AND (x_lease_termination_date IS NULL))) THEN

Line 261: pn_var_rent_pkg.lock_row_exception('LEASE_TERMINATION_DATE',tlinfo.lease_termination_date);

257: END IF;
258:
259: IF NOT ((tlinfo.lease_termination_date = x_lease_termination_date)
260: OR ((tlinfo.lease_termination_date IS NULL) AND (x_lease_termination_date IS NULL))) THEN
261: pn_var_rent_pkg.lock_row_exception('LEASE_TERMINATION_DATE',tlinfo.lease_termination_date);
262: END IF;
263:
264: IF NOT ((tlinfo.lease_execution_date = x_lease_execution_date)
265: OR ((tlinfo.lease_execution_date IS NULL) AND (x_lease_execution_date IS NULL))) THEN

Line 266: pn_var_rent_pkg.lock_row_exception('LEASE_EXECUTION_DATE',tlinfo.lease_execution_date);

262: END IF;
263:
264: IF NOT ((tlinfo.lease_execution_date = x_lease_execution_date)
265: OR ((tlinfo.lease_execution_date IS NULL) AND (x_lease_execution_date IS NULL))) THEN
266: pn_var_rent_pkg.lock_row_exception('LEASE_EXECUTION_DATE',tlinfo.lease_execution_date);
267: END IF;
268:
269: IF NOT ((tlinfo.accrual_account_id = x_accrual_account_id)
270: OR ((tlinfo.accrual_account_id IS NULL) AND (x_accrual_account_id IS NULL))) THEN

Line 271: pn_var_rent_pkg.lock_row_exception('ACCRUAL_ACCOUNT_ID',tlinfo.accrual_account_id);

267: END IF;
268:
269: IF NOT ((tlinfo.accrual_account_id = x_accrual_account_id)
270: OR ((tlinfo.accrual_account_id IS NULL) AND (x_accrual_account_id IS NULL))) THEN
271: pn_var_rent_pkg.lock_row_exception('ACCRUAL_ACCOUNT_ID',tlinfo.accrual_account_id);
272: END IF;
273:
274: IF NOT ((tlinfo.receivable_account_id = x_receivable_account_id)
275: OR ((tlinfo.receivable_account_id IS NULL) AND (x_receivable_account_id IS NULL))) THEN

Line 276: pn_var_rent_pkg.lock_row_exception('RECEIVABLE_ACCOUNT_ID',tlinfo.receivable_account_id);

272: END IF;
273:
274: IF NOT ((tlinfo.receivable_account_id = x_receivable_account_id)
275: OR ((tlinfo.receivable_account_id IS NULL) AND (x_receivable_account_id IS NULL))) THEN
276: pn_var_rent_pkg.lock_row_exception('RECEIVABLE_ACCOUNT_ID',tlinfo.receivable_account_id);
277: END IF;
278:
279: IF NOT ((tlinfo.term_template_id = x_term_template_id)
280: OR ((tlinfo.term_template_id IS NULL) AND (x_term_template_id IS NULL))) THEN

Line 281: pn_var_rent_pkg.lock_row_exception('TERM_TEMPLATE_ID',tlinfo.term_template_id);

277: END IF;
278:
279: IF NOT ((tlinfo.term_template_id = x_term_template_id)
280: OR ((tlinfo.term_template_id IS NULL) AND (x_term_template_id IS NULL))) THEN
281: pn_var_rent_pkg.lock_row_exception('TERM_TEMPLATE_ID',tlinfo.term_template_id);
282: END IF;
283:
284: IF NOT ((tlinfo.lease_extension_end_date = x_lease_extension_end_date)
285: OR ((tlinfo.lease_extension_end_date IS NULL) AND (x_lease_extension_end_date IS NULL))) THEN

Line 286: pn_var_rent_pkg.lock_row_exception('LEASE_EXTENSION_END_DATE',tlinfo.lease_extension_end_date);

282: END IF;
283:
284: IF NOT ((tlinfo.lease_extension_end_date = x_lease_extension_end_date)
285: OR ((tlinfo.lease_extension_end_date IS NULL) AND (x_lease_extension_end_date IS NULL))) THEN
286: pn_var_rent_pkg.lock_row_exception('LEASE_EXTENSION_END_DATE',tlinfo.lease_extension_end_date);
287: END IF;
288:
289: IF NOT ((tlinfo.attribute_category = x_attribute_category)
290: OR ((tlinfo.attribute_category IS NULL) AND (x_attribute_category IS NULL))) THEN

Line 291: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.attribute_category);

287: END IF;
288:
289: IF NOT ((tlinfo.attribute_category = x_attribute_category)
290: OR ((tlinfo.attribute_category IS NULL) AND (x_attribute_category IS NULL))) THEN
291: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.attribute_category);
292: END IF;
293:
294: IF NOT ((tlinfo.attribute1 = x_attribute1)
295: OR ((tlinfo.attribute1 IS NULL) AND (x_attribute1 IS NULL))) THEN

Line 296: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.attribute1);

292: END IF;
293:
294: IF NOT ((tlinfo.attribute1 = x_attribute1)
295: OR ((tlinfo.attribute1 IS NULL) AND (x_attribute1 IS NULL))) THEN
296: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.attribute1);
297: END IF;
298:
299: IF NOT ((tlinfo.attribute2 = x_attribute2)
300: OR ((tlinfo.attribute2 IS NULL) AND (x_attribute2 IS NULL))) THEN

Line 301: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.attribute2);

297: END IF;
298:
299: IF NOT ((tlinfo.attribute2 = x_attribute2)
300: OR ((tlinfo.attribute2 IS NULL) AND (x_attribute2 IS NULL))) THEN
301: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.attribute2);
302: END IF;
303:
304: IF NOT ((tlinfo.attribute3 = x_attribute3)
305: OR ((tlinfo.attribute3 IS NULL) AND (x_attribute3 IS NULL))) THEN

Line 306: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.attribute3);

302: END IF;
303:
304: IF NOT ((tlinfo.attribute3 = x_attribute3)
305: OR ((tlinfo.attribute3 IS NULL) AND (x_attribute3 IS NULL))) THEN
306: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.attribute3);
307: END IF;
308:
309: IF NOT ((tlinfo.attribute4 = x_attribute4)
310: OR ((tlinfo.attribute4 IS NULL) AND (x_attribute4 IS NULL))) THEN

Line 311: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.attribute4);

307: END IF;
308:
309: IF NOT ((tlinfo.attribute4 = x_attribute4)
310: OR ((tlinfo.attribute4 IS NULL) AND (x_attribute4 IS NULL))) THEN
311: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.attribute4);
312: END IF;
313:
314: IF NOT ((tlinfo.attribute5 = x_attribute5)
315: OR ((tlinfo.attribute5 IS NULL) AND (x_attribute5 IS NULL))) THEN

Line 316: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.attribute5);

312: END IF;
313:
314: IF NOT ((tlinfo.attribute5 = x_attribute5)
315: OR ((tlinfo.attribute5 IS NULL) AND (x_attribute5 IS NULL))) THEN
316: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.attribute5);
317: END IF;
318:
319: IF NOT ((tlinfo.attribute6 = x_attribute6)
320: OR ((tlinfo.attribute6 IS NULL) AND (x_attribute6 IS NULL))) THEN

Line 321: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.attribute6);

317: END IF;
318:
319: IF NOT ((tlinfo.attribute6 = x_attribute6)
320: OR ((tlinfo.attribute6 IS NULL) AND (x_attribute6 IS NULL))) THEN
321: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.attribute6);
322: END IF;
323:
324: IF NOT ((tlinfo.attribute7 = x_attribute7)
325: OR ((tlinfo.attribute7 IS NULL) AND (x_attribute7 IS NULL))) THEN

Line 326: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.attribute7);

322: END IF;
323:
324: IF NOT ((tlinfo.attribute7 = x_attribute7)
325: OR ((tlinfo.attribute7 IS NULL) AND (x_attribute7 IS NULL))) THEN
326: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.attribute7);
327: END IF;
328:
329: IF NOT ((tlinfo.attribute8 = x_attribute8)
330: OR ((tlinfo.attribute8 IS NULL) AND (x_attribute8 IS NULL))) THEN

Line 331: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.attribute8);

327: END IF;
328:
329: IF NOT ((tlinfo.attribute8 = x_attribute8)
330: OR ((tlinfo.attribute8 IS NULL) AND (x_attribute8 IS NULL))) THEN
331: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.attribute8);
332: END IF;
333:
334: IF NOT ((tlinfo.attribute9 = x_attribute9)
335: OR ((tlinfo.attribute9 IS NULL) AND (x_attribute9 IS NULL))) THEN

Line 336: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.attribute9);

332: END IF;
333:
334: IF NOT ((tlinfo.attribute9 = x_attribute9)
335: OR ((tlinfo.attribute9 IS NULL) AND (x_attribute9 IS NULL))) THEN
336: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.attribute9);
337: END IF;
338:
339: IF NOT ((tlinfo.attribute10 = x_attribute10)
340: OR ((tlinfo.attribute10 IS NULL) AND (x_attribute10 IS NULL))) THEN

Line 341: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.attribute10);

337: END IF;
338:
339: IF NOT ((tlinfo.attribute10 = x_attribute10)
340: OR ((tlinfo.attribute10 IS NULL) AND (x_attribute10 IS NULL))) THEN
341: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.attribute10);
342: END IF;
343:
344: IF NOT ((tlinfo.attribute11 = x_attribute11)
345: OR ((tlinfo.attribute11 IS NULL) AND (x_attribute11 IS NULL))) THEN

Line 346: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.attribute11);

342: END IF;
343:
344: IF NOT ((tlinfo.attribute11 = x_attribute11)
345: OR ((tlinfo.attribute11 IS NULL) AND (x_attribute11 IS NULL))) THEN
346: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.attribute11);
347: END IF;
348:
349: IF NOT ((tlinfo.attribute12 = x_attribute12)
350: OR ((tlinfo.attribute12 IS NULL) AND (x_attribute12 IS NULL))) THEN

Line 351: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.attribute12);

347: END IF;
348:
349: IF NOT ((tlinfo.attribute12 = x_attribute12)
350: OR ((tlinfo.attribute12 IS NULL) AND (x_attribute12 IS NULL))) THEN
351: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.attribute12);
352: END IF;
353:
354: IF NOT ((tlinfo.attribute13 = x_attribute13)
355: OR ((tlinfo.attribute13 IS NULL) AND (x_attribute13 IS NULL))) THEN

Line 356: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.attribute13);

352: END IF;
353:
354: IF NOT ((tlinfo.attribute13 = x_attribute13)
355: OR ((tlinfo.attribute13 IS NULL) AND (x_attribute13 IS NULL))) THEN
356: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.attribute13);
357: END IF;
358:
359: IF NOT ((tlinfo.attribute14 = x_attribute14)
360: OR ((tlinfo.attribute14 IS NULL) AND (x_attribute14 IS NULL))) THEN

Line 361: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.attribute14);

357: END IF;
358:
359: IF NOT ((tlinfo.attribute14 = x_attribute14)
360: OR ((tlinfo.attribute14 IS NULL) AND (x_attribute14 IS NULL))) THEN
361: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.attribute14);
362: END IF;
363:
364: IF NOT ((tlinfo.attribute15 = x_attribute15)
365: OR ((tlinfo.attribute15 IS NULL) AND (x_attribute15 IS NULL))) THEN

Line 366: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.attribute15);

362: END IF;
363:
364: IF NOT ((tlinfo.attribute15 = x_attribute15)
365: OR ((tlinfo.attribute15 IS NULL) AND (x_attribute15 IS NULL))) THEN
366: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.attribute15);
367: END IF;
368:
369: IF NOT ((tlinfo.name = x_name)
370: OR ((tlinfo.name IS NULL) AND (x_name IS NULL))) THEN

Line 371: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.name);

367: END IF;
368:
369: IF NOT ((tlinfo.name = x_name)
370: OR ((tlinfo.name IS NULL) AND (x_name IS NULL))) THEN
371: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.name);
372: END IF;
373:
374: IF NOT ((tlinfo.lease_num = x_lease_num)
375: OR ((tlinfo.lease_num IS NULL) AND (x_lease_num IS NULL))) THEN

Line 376: pn_var_rent_pkg.lock_row_exception('LEASE_NUM',tlinfo.lease_num);

372: END IF;
373:
374: IF NOT ((tlinfo.lease_num = x_lease_num)
375: OR ((tlinfo.lease_num IS NULL) AND (x_lease_num IS NULL))) THEN
376: pn_var_rent_pkg.lock_row_exception('LEASE_NUM',tlinfo.lease_num);
377: END IF;
378:
379: IF NOT ((tlinfo.lease_status = x_lease_status)
380: OR ((tlinfo.lease_status IS NULL) AND (x_lease_status IS NULL))) THEN

Line 381: pn_var_rent_pkg.lock_row_exception('LEASE_STATUS',tlinfo.lease_status);

377: END IF;
378:
379: IF NOT ((tlinfo.lease_status = x_lease_status)
380: OR ((tlinfo.lease_status IS NULL) AND (x_lease_status IS NULL))) THEN
381: pn_var_rent_pkg.lock_row_exception('LEASE_STATUS',tlinfo.lease_status);
382: END IF;
383:
384: IF NOT ((tlinfo.grouping_rule_id = x_grouping_rule_id)
385: OR ((tlinfo.grouping_rule_id IS NULL) AND (x_grouping_rule_id IS NULL))) THEN

Line 386: pn_var_rent_pkg.lock_row_exception('GROUPING_RULE_ID',tlinfo.grouping_rule_id);

382: END IF;
383:
384: IF NOT ((tlinfo.grouping_rule_id = x_grouping_rule_id)
385: OR ((tlinfo.grouping_rule_id IS NULL) AND (x_grouping_rule_id IS NULL))) THEN
386: pn_var_rent_pkg.lock_row_exception('GROUPING_RULE_ID',tlinfo.grouping_rule_id);
387: END IF;
388:
389: RETURN;
390: