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

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

299: END IF;
300: CLOSE c1;
301:
302: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
303: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
304: END IF;
305:
306: IF NOT (tlinfo.NAME = X_NAME) THEN
307: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.NAME);

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

303: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
304: END IF;
305:
306: IF NOT (tlinfo.NAME = X_NAME) THEN
307: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.NAME);
308: END IF;
309:
310: IF NOT (tlinfo.LEASE_NUM = X_LEASE_NUM) THEN
311: pn_var_rent_pkg.lock_row_exception('LEASE_NUM',tlinfo.LEASE_NUM);

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

307: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.NAME);
308: END IF;
309:
310: IF NOT (tlinfo.LEASE_NUM = X_LEASE_NUM) THEN
311: pn_var_rent_pkg.lock_row_exception('LEASE_NUM',tlinfo.LEASE_NUM);
312: END IF;
313:
314: IF NOT ((tlinfo.PARENT_LEASE_ID = X_PARENT_LEASE_ID)
315: OR ((tlinfo.PARENT_LEASE_ID IS NULL) AND (X_PARENT_LEASE_ID IS NULL))) THEN

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

312: END IF;
313:
314: IF NOT ((tlinfo.PARENT_LEASE_ID = X_PARENT_LEASE_ID)
315: OR ((tlinfo.PARENT_LEASE_ID IS NULL) AND (X_PARENT_LEASE_ID IS NULL))) THEN
316: pn_var_rent_pkg.lock_row_exception('PARENT_LEASE_ID',tlinfo.PARENT_LEASE_ID);
317: END IF;
318:
319: IF NOT ((tlinfo.LEASE_TYPE_CODE = X_LEASE_TYPE_CODE)
320: OR ((tlinfo.LEASE_TYPE_CODE IS NULL) AND (X_LEASE_TYPE_CODE IS NULL))) THEN

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

317: END IF;
318:
319: IF NOT ((tlinfo.LEASE_TYPE_CODE = X_LEASE_TYPE_CODE)
320: OR ((tlinfo.LEASE_TYPE_CODE IS NULL) AND (X_LEASE_TYPE_CODE IS NULL))) THEN
321: pn_var_rent_pkg.lock_row_exception('LEASE_TYPE_CODE',tlinfo.LEASE_TYPE_CODE);
322: END IF;
323:
324: IF NOT ((tlinfo.LEASE_CLASS_CODE = X_LEASE_CLASS_CODE)
325: OR ((tlinfo.LEASE_CLASS_CODE IS NULL) AND (X_LEASE_CLASS_CODE IS NULL))) THEN

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

322: END IF;
323:
324: IF NOT ((tlinfo.LEASE_CLASS_CODE = X_LEASE_CLASS_CODE)
325: OR ((tlinfo.LEASE_CLASS_CODE IS NULL) AND (X_LEASE_CLASS_CODE IS NULL))) THEN
326: pn_var_rent_pkg.lock_row_exception('LEASE_CLASS_CODE',tlinfo.LEASE_CLASS_CODE);
327: END IF;
328:
329: IF NOT ((tlinfo.LEASE_STATUS = X_LEASE_STATUS)
330: OR ((tlinfo.LEASE_STATUS IS NULL) AND (X_LEASE_STATUS IS NULL))) THEN

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

327: END IF;
328:
329: IF NOT ((tlinfo.LEASE_STATUS = X_LEASE_STATUS)
330: OR ((tlinfo.LEASE_STATUS IS NULL) AND (X_LEASE_STATUS IS NULL))) THEN
331: pn_var_rent_pkg.lock_row_exception('LEASE_STATUS',tlinfo.LEASE_STATUS);
332: END IF;
333:
334: IF NOT ((tlinfo.STATUS = X_STATUS)
335: OR ((tlinfo.STATUS IS NULL) AND (X_STATUS IS NULL))) THEN

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

332: END IF;
333:
334: IF NOT ((tlinfo.STATUS = X_STATUS)
335: OR ((tlinfo.STATUS IS NULL) AND (X_STATUS IS NULL))) THEN
336: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);
337: END IF;
338:
339: IF NOT ((tlinfo.PAYMENT_TERM_PRORATION_RULE = X_PAYMENT_TERM_PRORATION_RULE)
340: OR ((tlinfo.PAYMENT_TERM_PRORATION_RULE IS NULL) AND

Line 342: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_PRORATION_RULE',tlinfo.PAYMENT_TERM_PRORATION_RULE);

338:
339: IF NOT ((tlinfo.PAYMENT_TERM_PRORATION_RULE = X_PAYMENT_TERM_PRORATION_RULE)
340: OR ((tlinfo.PAYMENT_TERM_PRORATION_RULE IS NULL) AND
341: (X_PAYMENT_TERM_PRORATION_RULE IS NULL))) THEN
342: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_PRORATION_RULE',tlinfo.PAYMENT_TERM_PRORATION_RULE);
343: END IF;
344:
345: IF NOT ((tlinfo.ABSTRACTED_BY_USER = X_ABSTRACTED_BY_USER)
346: OR ((tlinfo.ABSTRACTED_BY_USER IS NULL) AND (X_ABSTRACTED_BY_USER IS NULL))) THEN

Line 347: pn_var_rent_pkg.lock_row_exception('ABSTRACTED_BY_USER',tlinfo.ABSTRACTED_BY_USER);

343: END IF;
344:
345: IF NOT ((tlinfo.ABSTRACTED_BY_USER = X_ABSTRACTED_BY_USER)
346: OR ((tlinfo.ABSTRACTED_BY_USER IS NULL) AND (X_ABSTRACTED_BY_USER IS NULL))) THEN
347: pn_var_rent_pkg.lock_row_exception('ABSTRACTED_BY_USER',tlinfo.ABSTRACTED_BY_USER);
348: END IF;
349:
350: IF NOT ((tlinfo.location_id = x_location_id)
351: OR ((tlinfo.location_id IS NULL) AND (x_location_id IS NULL))) THEN

Line 352: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.location_id);

348: END IF;
349:
350: IF NOT ((tlinfo.location_id = x_location_id)
351: OR ((tlinfo.location_id IS NULL) AND (x_location_id IS NULL))) THEN
352: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.location_id);
353: END IF;
354:
355: IF NOT ((tlinfo.customer_id = x_customer_id)
356: OR ((tlinfo.customer_id IS NULL) AND (x_customer_id IS NULL))) THEN

Line 357: pn_var_rent_pkg.lock_row_exception('CUSTOMER_ID',tlinfo.customer_id);

353: END IF;
354:
355: IF NOT ((tlinfo.customer_id = x_customer_id)
356: OR ((tlinfo.customer_id IS NULL) AND (x_customer_id IS NULL))) THEN
357: pn_var_rent_pkg.lock_row_exception('CUSTOMER_ID',tlinfo.customer_id);
358: END IF;
359:
360: ------------------------------------------------------
361: -- We need to lock records in pn_lease_details