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 307: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);

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

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

307: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
308: END IF;
309:
310: IF NOT (tlinfo.NAME = X_NAME) THEN
311: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.NAME);
312: END IF;
313:
314: IF NOT (tlinfo.LEASE_NUM = X_LEASE_NUM) THEN
315: pn_var_rent_pkg.lock_row_exception('LEASE_NUM',tlinfo.LEASE_NUM);

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

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

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

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

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

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

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

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

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

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

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

336: END IF;
337:
338: IF NOT ((tlinfo.STATUS = X_STATUS)
339: OR ((tlinfo.STATUS IS NULL) AND (X_STATUS IS NULL))) THEN
340: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);
341: END IF;
342:
343: IF NOT ((tlinfo.PAYMENT_TERM_PRORATION_RULE = X_PAYMENT_TERM_PRORATION_RULE)
344: OR ((tlinfo.PAYMENT_TERM_PRORATION_RULE IS NULL) AND

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

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

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

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

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

352: END IF;
353:
354: IF NOT ((tlinfo.location_id = x_location_id)
355: OR ((tlinfo.location_id IS NULL) AND (x_location_id IS NULL))) THEN
356: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.location_id);
357: END IF;
358:
359: IF NOT ((tlinfo.customer_id = x_customer_id)
360: OR ((tlinfo.customer_id IS NULL) AND (x_customer_id IS NULL))) THEN

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

357: END IF;
358:
359: IF NOT ((tlinfo.customer_id = x_customer_id)
360: OR ((tlinfo.customer_id IS NULL) AND (x_customer_id IS NULL))) THEN
361: pn_var_rent_pkg.lock_row_exception('CUSTOMER_ID',tlinfo.customer_id);
362: END IF;
363:
364: IF NOT ((tlinfo.cal_start = x_calendar_year_start_date)
365: OR ((tlinfo.cal_start IS NULL) AND (x_calendar_year_start_date IS NULL))) THEN

Line 366: pn_var_rent_pkg.lock_row_exception('CALENDAR_YEAR_START_DATE',tlinfo.cal_start);

362: END IF;
363:
364: IF NOT ((tlinfo.cal_start = x_calendar_year_start_date)
365: OR ((tlinfo.cal_start IS NULL) AND (x_calendar_year_start_date IS NULL))) THEN
366: pn_var_rent_pkg.lock_row_exception('CALENDAR_YEAR_START_DATE',tlinfo.cal_start);
367: END IF;
368:
369: ------------------------------------------------------
370: -- We need to lock records in pn_lease_details